プロジェクト

全般

プロフィール

リビジョン 9

堀内8年以上前に追加

・積算予算書の自社施工を同一項目は集計するように修正
・積算予算書の共通仮設費が入力しても値が反映されない不具合を修正

差分を表示:

trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsExcute.cs
63 63
            Proceedings,                        // 16:発注者打ち合わせ議事録入力
64 64
            DailyReportList,                    // 17:日報一覧
65 65
            DailyReport,                        // 18:日報全般
66
            DepartmentExpenssList,              // 19:部署別台帳一覧
66 67
        }
67 68
        #endregion
68 69

  
......
349 350
                        case (int)ProcessExecuteNo.DailyReport:                         // 18:日報等
350 351
                            ProcessExecuteNo_DailyReport(m_ProcControlPara[NowPoint]);
351 352
                            break;
353

  
354
                        case (int)ProcessExecuteNo.DepartmentExpenssList:               // 19:部署別台帳一覧
355
                            ProcessExecuteNo_DepartmentExpenssList(m_ProcControlPara[NowPoint]);
356
                            break;
352 357
                        #endregion
353 358

  
354 359
                        #region マスタメンテ
......
1209 1214
        }
1210 1215
        #endregion
1211 1216

  
1217
        #region 部署別台帳一覧
1218
        /// <summary>
1219
        /// 部署別台帳一覧
1220
        /// </summary>
1221
        /// <returns></returns>
1222
        public static void ProcessExecuteNo_DepartmentExpenssList(ProcessParameter CurrentPara)
1223
        {
1224
            // 部署別台帳一覧
1225
            FrmDepExpenssList frm = new FrmDepExpenssList();
1226
            try
1227
            {
1228
                // 次起動プロセスセット
1229
                //frm.ExecuteFlg = CurrentPara.IntExecParameter[0];
1230

  
1231
                // フォーム表示
1232
                frm.ShowDialog();
1233
            }
1234
            catch (Exception ex)
1235
            {
1236
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
1237
            }
1238
            finally
1239
            {
1240
                frm.Dispose(); frm = null;
1241
            }
1242
        }
1212 1243
        #endregion
1213 1244

  
1245
        #endregion
1246

  
1214 1247
        #region マスタメンテナンス
1215 1248
        // ----------------- メンテナンス起動
1216 1249
        #region 管理マスタ
trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstractionList/FrmConstructionListAuxiliary.cs
1303 1303
            }
1304 1304
        }
1305 1305
        #endregion
1306

  
1306 1307
    }
1307 1308
}
trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionPersonList/FrmConstructionPersonList.designer.cs
102 102
            this.label7 = new System.Windows.Forms.Label();
103 103
            this.lblCellTotal = new System.Windows.Forms.Label();
104 104
            this.dgvMaster = new ProcessManagement.Forms.CustomControls.DataGridViewEX();
105
            this.ProgressBar = new System.Windows.Forms.ProgressBar();
105 106
            this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
106 107
            this.Column14 = new System.Windows.Forms.DataGridViewTextBoxColumn();
107 108
            this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
......
113 114
            this.Column9 = new System.Windows.Forms.DataGridViewTextBoxColumn();
114 115
            this.Column10 = new System.Windows.Forms.DataGridViewTextBoxColumn();
115 116
            this.Column12 = new System.Windows.Forms.DataGridViewTextBoxColumn();
116
            this.ProgressBar = new System.Windows.Forms.ProgressBar();
117 117
            this.groupBox1.SuspendLayout();
118 118
            this.pnlPayroll.SuspendLayout();
119 119
            ((System.ComponentModel.ISupportInitialize)(this.numUDConstPro)).BeginInit();
......
973 973
            this.dgvMaster.Leave += new System.EventHandler(this.dgvMaster_Leave);
974 974
            this.dgvMaster.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dgvMaster_MouseUp);
975 975
            // 
976
            // ProgressBar
977
            // 
978
            this.ProgressBar.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
979
            this.ProgressBar.Location = new System.Drawing.Point(5, 619);
980
            this.ProgressBar.Name = "ProgressBar";
981
            this.ProgressBar.Size = new System.Drawing.Size(388, 30);
982
            this.ProgressBar.TabIndex = 30;
983
            this.ProgressBar.Visible = false;
984
            // 
976 985
            // Column1
977 986
            // 
978 987
            dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
......
993 1002
            this.Column14.HeaderText = "部署";
994 1003
            this.Column14.Name = "Column14";
995 1004
            this.Column14.ReadOnly = true;
1005
            this.Column14.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
996 1006
            this.Column14.Width = 200;
997 1007
            // 
998 1008
            // Column2
......
1105 1115
            this.Column12.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
1106 1116
            this.Column12.Width = 120;
1107 1117
            // 
1108
            // ProgressBar
1109
            // 
1110
            this.ProgressBar.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
1111
            this.ProgressBar.Location = new System.Drawing.Point(5, 619);
1112
            this.ProgressBar.Name = "ProgressBar";
1113
            this.ProgressBar.Size = new System.Drawing.Size(388, 30);
1114
            this.ProgressBar.TabIndex = 30;
1115
            this.ProgressBar.Visible = false;
1116
            // 
1117 1118
            // FrmConstructionPersonList
1118 1119
            // 
1119 1120
            this.AutoScaleDimensions = new System.Drawing.SizeF(96F, 96F);
......
1188 1189
        private System.Windows.Forms.Label label25;
1189 1190
        private System.Windows.Forms.Label label8;
1190 1191
        private System.Windows.Forms.Label label23;
1191
        private System.Windows.Forms.DataGridViewTextBoxColumn Column1;
1192
        private System.Windows.Forms.DataGridViewTextBoxColumn Column14;
1193
        private System.Windows.Forms.DataGridViewTextBoxColumn Column2;
1194
        private System.Windows.Forms.DataGridViewTextBoxColumn Column3;
1195
        private System.Windows.Forms.DataGridViewTextBoxColumn Column5;
1196
        private System.Windows.Forms.DataGridViewTextBoxColumn Column6;
1197
        private System.Windows.Forms.DataGridViewTextBoxColumn Column7;
1198
        private System.Windows.Forms.DataGridViewTextBoxColumn Column8;
1199
        private System.Windows.Forms.DataGridViewTextBoxColumn Column9;
1200
        private System.Windows.Forms.DataGridViewTextBoxColumn Column10;
1201
        private System.Windows.Forms.DataGridViewTextBoxColumn Column12;
1202 1192
        private System.Windows.Forms.Label label54;
1203 1193
        private System.Windows.Forms.Label label55;
1204 1194
        private System.Windows.Forms.Label label56;
......
1222 1212
        private System.Windows.Forms.Label label34;
1223 1213
        private System.Windows.Forms.Label label38;
1224 1214
        private System.Windows.Forms.Label label39;
1215
        private System.Windows.Forms.DataGridViewTextBoxColumn Column1;
1216
        private System.Windows.Forms.DataGridViewTextBoxColumn Column14;
1217
        private System.Windows.Forms.DataGridViewTextBoxColumn Column2;
1218
        private System.Windows.Forms.DataGridViewTextBoxColumn Column3;
1219
        private System.Windows.Forms.DataGridViewTextBoxColumn Column5;
1220
        private System.Windows.Forms.DataGridViewTextBoxColumn Column6;
1221
        private System.Windows.Forms.DataGridViewTextBoxColumn Column7;
1222
        private System.Windows.Forms.DataGridViewTextBoxColumn Column8;
1223
        private System.Windows.Forms.DataGridViewTextBoxColumn Column9;
1224
        private System.Windows.Forms.DataGridViewTextBoxColumn Column10;
1225
        private System.Windows.Forms.DataGridViewTextBoxColumn Column12;
1225 1226
    }
1226 1227
}
trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/DRConstruction/FrmDRConstruction.designer.cs
1424 1424
            this.lblCellTotal.BackColor = System.Drawing.Color.WhiteSmoke;
1425 1425
            this.lblCellTotal.Font = new System.Drawing.Font("MS 明朝", 9.75F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
1426 1426
            this.lblCellTotal.ForeColor = System.Drawing.Color.Black;
1427
            this.lblCellTotal.Location = new System.Drawing.Point(100, 25902);
1427
            this.lblCellTotal.Location = new System.Drawing.Point(100, 27188);
1428 1428
            this.lblCellTotal.Name = "lblCellTotal";
1429 1429
            this.lblCellTotal.Size = new System.Drawing.Size(0, 13);
1430 1430
            this.lblCellTotal.TabIndex = 36;
......
1621 1621
            // 
1622 1622
            // panel2
1623 1623
            // 
1624
            this.panel2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
1624 1625
            this.panel2.BackColor = System.Drawing.Color.LemonChiffon;
1625 1626
            this.panel2.Controls.Add(this.btnWorkingList);
1626 1627
            this.panel2.Location = new System.Drawing.Point(1100, 3);
......
1630 1631
            // 
1631 1632
            // btnWorkingList
1632 1633
            // 
1634
            this.btnWorkingList.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
1633 1635
            this.btnWorkingList.BackColor = System.Drawing.Color.DarkOrange;
1634 1636
            this.btnWorkingList.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
1635 1637
            this.btnWorkingList.ForeColor = System.Drawing.Color.Black;
trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/EstimateBudget/FrmEstimateBudgetAuxiliary.cs
1117 1117
                strSQL += string.Format(" And A.COMPANYCODE = {0}",
1118 1118
                            CommonDefine.s_AmountMoney[(int)CommonDefine.AmountMoneyNo.MyCosts].Key);           // 自社施工を除外する
1119 1119
                strSQL += " And A.COMPONENTCODE = B.COMPONENTCODE";
1120
                strSQL += " GROUP BY B.COMPONENTNAME, A.COMPONENTCODE, A.ITEMNAME, A.ITEMCODE, A.PageCount, A.LineCount";
1121
                strSQL += " ORDER BY A.COMPONENTCODE, A.ITEMCODE, A.PAGECOUNT, A.LINECOUNT";
1120
                strSQL += " GROUP BY B.COMPONENTNAME, A.COMPONENTCODE, A.ITEMNAME, A.ITEMCODE, A.PageCount";
1121
                strSQL += " ORDER BY A.COMPONENTCODE, A.ITEMCODE, A.PAGECOUNT";
1122
                //strSQL += " GROUP BY B.COMPONENTNAME, A.COMPONENTCODE, A.ITEMNAME, A.ITEMCODE, A.PageCount, A.LineCount";
1123
                //strSQL += " ORDER BY A.COMPONENTCODE, A.ITEMCODE, A.PAGECOUNT, A.LINECOUNT";
1122 1124
                ArrayList arList = new ArrayList();
1123 1125
                if (!DetailDB.ExecuteReader(strSQL, ref arList)) return;
1124 1126
                // データ無は処理しない
......
3052 3054
                        case (int)GroupName_EstimateBudget.MyConstruction:
3053 3055
                        /// 共通費
3054 3056
                        case (int)GroupName_EstimateBudget.CommonTemp:
3057
                        /// 共通仮設算定費
3058
                        case (int)GroupName_EstimateBudget.CommonTempCalcCosts:
3055 3059
                        /// 積み上げ共通費
3056 3060
                        case (int)GroupName_EstimateBudget.CommonPileUp:
3057 3061
                        /// 現場管理費
trunk/src/ProcessManagement/ProcessManagement/Forms/ZMenu/FrmMenu.Designer.cs
6208 6208
            this.tblLayoutMaster.Controls.Add(this.btnMaster_24, 0, 16);
6209 6209
            this.tblLayoutMaster.Controls.Add(this.btnMaster_25, 2, 16);
6210 6210
            this.tblLayoutMaster.Controls.Add(this.btnMaster_26, 4, 16);
6211
            this.tblLayoutMaster.Location = new System.Drawing.Point(58, 0);
6211
            this.tblLayoutMaster.Location = new System.Drawing.Point(75, 0);
6212 6212
            this.tblLayoutMaster.Name = "tblLayoutMaster";
6213 6213
            this.tblLayoutMaster.RowCount = 17;
6214 6214
            this.tblLayoutMaster.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 44F));
......
6228 6228
            this.tblLayoutMaster.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 44F));
6229 6229
            this.tblLayoutMaster.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 44F));
6230 6230
            this.tblLayoutMaster.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 44F));
6231
            this.tblLayoutMaster.Size = new System.Drawing.Size(1029, 748);
6231
            this.tblLayoutMaster.Size = new System.Drawing.Size(978, 748);
6232 6232
            this.tblLayoutMaster.TabIndex = 14;
6233 6233
            this.tblLayoutMaster.MouseEnter += new System.EventHandler(this.tblLayoutMaster_MouseEnter);
6234 6234
            // 
......
6240 6240
            this.btnMaster_00.Location = new System.Drawing.Point(4, 3);
6241 6241
            this.btnMaster_00.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6242 6242
            this.btnMaster_00.Name = "btnMaster_00";
6243
            this.btnMaster_00.Size = new System.Drawing.Size(300, 38);
6243
            this.btnMaster_00.Size = new System.Drawing.Size(285, 38);
6244 6244
            this.btnMaster_00.TabIndex = 0;
6245 6245
            this.btnMaster_00.Text = "会社情報登録";
6246 6246
            this.btnMaster_00.UseVisualStyleBackColor = true;
......
6251 6251
            this.btnMaster_06.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6252 6252
            | System.Windows.Forms.AnchorStyles.Left) 
6253 6253
            | System.Windows.Forms.AnchorStyles.Right)));
6254
            this.btnMaster_06.Location = new System.Drawing.Point(363, 3);
6254
            this.btnMaster_06.Location = new System.Drawing.Point(345, 3);
6255 6255
            this.btnMaster_06.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6256 6256
            this.btnMaster_06.Name = "btnMaster_06";
6257
            this.btnMaster_06.Size = new System.Drawing.Size(300, 38);
6257
            this.btnMaster_06.Size = new System.Drawing.Size(285, 38);
6258 6258
            this.btnMaster_06.TabIndex = 9;
6259 6259
            this.btnMaster_06.Text = "部署登録";
6260 6260
            this.btnMaster_06.UseVisualStyleBackColor = true;
......
6265 6265
            this.btnMaster_10.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6266 6266
            | System.Windows.Forms.AnchorStyles.Left) 
6267 6267
            | System.Windows.Forms.AnchorStyles.Right)));
6268
            this.btnMaster_10.Location = new System.Drawing.Point(363, 355);
6268
            this.btnMaster_10.Location = new System.Drawing.Point(345, 355);
6269 6269
            this.btnMaster_10.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6270 6270
            this.btnMaster_10.Name = "btnMaster_10";
6271
            this.btnMaster_10.Size = new System.Drawing.Size(300, 38);
6271
            this.btnMaster_10.Size = new System.Drawing.Size(285, 38);
6272 6272
            this.btnMaster_10.TabIndex = 13;
6273 6273
            this.btnMaster_10.Text = "法人格登録";
6274 6274
            this.btnMaster_10.UseVisualStyleBackColor = true;
......
6279 6279
            this.btnMaster_09.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6280 6280
            | System.Windows.Forms.AnchorStyles.Left) 
6281 6281
            | System.Windows.Forms.AnchorStyles.Right)));
6282
            this.btnMaster_09.Location = new System.Drawing.Point(363, 267);
6282
            this.btnMaster_09.Location = new System.Drawing.Point(345, 267);
6283 6283
            this.btnMaster_09.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6284 6284
            this.btnMaster_09.Name = "btnMaster_09";
6285
            this.btnMaster_09.Size = new System.Drawing.Size(300, 38);
6285
            this.btnMaster_09.Size = new System.Drawing.Size(285, 38);
6286 6286
            this.btnMaster_09.TabIndex = 12;
6287 6287
            this.btnMaster_09.Text = "車 両 登 録";
6288 6288
            this.btnMaster_09.UseVisualStyleBackColor = true;
......
6293 6293
            this.btnMaster_08.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6294 6294
            | System.Windows.Forms.AnchorStyles.Left) 
6295 6295
            | System.Windows.Forms.AnchorStyles.Right)));
6296
            this.btnMaster_08.Location = new System.Drawing.Point(363, 179);
6296
            this.btnMaster_08.Location = new System.Drawing.Point(345, 179);
6297 6297
            this.btnMaster_08.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6298 6298
            this.btnMaster_08.Name = "btnMaster_08";
6299
            this.btnMaster_08.Size = new System.Drawing.Size(300, 38);
6299
            this.btnMaster_08.Size = new System.Drawing.Size(285, 38);
6300 6300
            this.btnMaster_08.TabIndex = 11;
6301 6301
            this.btnMaster_08.Text = "外注扱い(常雇工)登録";
6302 6302
            this.btnMaster_08.UseVisualStyleBackColor = true;
......
6307 6307
            this.btnMaster_07.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6308 6308
            | System.Windows.Forms.AnchorStyles.Left) 
6309 6309
            | System.Windows.Forms.AnchorStyles.Right)));
6310
            this.btnMaster_07.Location = new System.Drawing.Point(363, 91);
6310
            this.btnMaster_07.Location = new System.Drawing.Point(345, 91);
6311 6311
            this.btnMaster_07.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6312 6312
            this.btnMaster_07.Name = "btnMaster_07";
6313
            this.btnMaster_07.Size = new System.Drawing.Size(300, 38);
6313
            this.btnMaster_07.Size = new System.Drawing.Size(285, 38);
6314 6314
            this.btnMaster_07.TabIndex = 10;
6315 6315
            this.btnMaster_07.Text = "担当者登録";
6316 6316
            this.btnMaster_07.UseVisualStyleBackColor = true;
......
6321 6321
            this.btnMaster_12.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6322 6322
            | System.Windows.Forms.AnchorStyles.Left) 
6323 6323
            | System.Windows.Forms.AnchorStyles.Right)));
6324
            this.btnMaster_12.Location = new System.Drawing.Point(722, 3);
6324
            this.btnMaster_12.Location = new System.Drawing.Point(686, 3);
6325 6325
            this.btnMaster_12.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6326 6326
            this.btnMaster_12.Name = "btnMaster_12";
6327
            this.btnMaster_12.Size = new System.Drawing.Size(303, 38);
6327
            this.btnMaster_12.Size = new System.Drawing.Size(288, 38);
6328 6328
            this.btnMaster_12.TabIndex = 18;
6329 6329
            this.btnMaster_12.Text = "協力会社登録";
6330 6330
            this.btnMaster_12.UseVisualStyleBackColor = true;
......
6335 6335
            this.btnMaster_13.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6336 6336
            | System.Windows.Forms.AnchorStyles.Left) 
6337 6337
            | System.Windows.Forms.AnchorStyles.Right)));
6338
            this.btnMaster_13.Location = new System.Drawing.Point(722, 91);
6338
            this.btnMaster_13.Location = new System.Drawing.Point(686, 91);
6339 6339
            this.btnMaster_13.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6340 6340
            this.btnMaster_13.Name = "btnMaster_13";
6341
            this.btnMaster_13.Size = new System.Drawing.Size(303, 38);
6341
            this.btnMaster_13.Size = new System.Drawing.Size(288, 38);
6342 6342
            this.btnMaster_13.TabIndex = 18;
6343 6343
            this.btnMaster_13.Text = "協力会社工種登録";
6344 6344
            this.btnMaster_13.UseVisualStyleBackColor = true;
......
6349 6349
            this.btnMaster_14.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6350 6350
            | System.Windows.Forms.AnchorStyles.Left) 
6351 6351
            | System.Windows.Forms.AnchorStyles.Right)));
6352
            this.btnMaster_14.Location = new System.Drawing.Point(722, 179);
6352
            this.btnMaster_14.Location = new System.Drawing.Point(686, 179);
6353 6353
            this.btnMaster_14.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6354 6354
            this.btnMaster_14.Name = "btnMaster_14";
6355
            this.btnMaster_14.Size = new System.Drawing.Size(303, 38);
6355
            this.btnMaster_14.Size = new System.Drawing.Size(288, 38);
6356 6356
            this.btnMaster_14.TabIndex = 20;
6357 6357
            this.btnMaster_14.Text = "協力会社職種登録";
6358 6358
            this.btnMaster_14.UseVisualStyleBackColor = true;
......
6363 6363
            this.btnMaster_15.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6364 6364
            | System.Windows.Forms.AnchorStyles.Left) 
6365 6365
            | System.Windows.Forms.AnchorStyles.Right)));
6366
            this.btnMaster_15.Location = new System.Drawing.Point(722, 267);
6366
            this.btnMaster_15.Location = new System.Drawing.Point(686, 267);
6367 6367
            this.btnMaster_15.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6368 6368
            this.btnMaster_15.Name = "btnMaster_15";
6369
            this.btnMaster_15.Size = new System.Drawing.Size(303, 38);
6369
            this.btnMaster_15.Size = new System.Drawing.Size(288, 38);
6370 6370
            this.btnMaster_15.TabIndex = 21;
6371 6371
            this.btnMaster_15.UseVisualStyleBackColor = true;
6372 6372
            this.btnMaster_15.Click += new System.EventHandler(this.btnMaster_Click);
......
6376 6376
            this.btnMaster_16.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6377 6377
            | System.Windows.Forms.AnchorStyles.Left) 
6378 6378
            | System.Windows.Forms.AnchorStyles.Right)));
6379
            this.btnMaster_16.Location = new System.Drawing.Point(722, 355);
6379
            this.btnMaster_16.Location = new System.Drawing.Point(686, 355);
6380 6380
            this.btnMaster_16.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6381 6381
            this.btnMaster_16.Name = "btnMaster_16";
6382
            this.btnMaster_16.Size = new System.Drawing.Size(303, 38);
6382
            this.btnMaster_16.Size = new System.Drawing.Size(288, 38);
6383 6383
            this.btnMaster_16.TabIndex = 22;
6384 6384
            this.btnMaster_16.Text = "積算単位登録";
6385 6385
            this.btnMaster_16.UseVisualStyleBackColor = true;
......
6390 6390
            this.btnMaster_11.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6391 6391
            | System.Windows.Forms.AnchorStyles.Left) 
6392 6392
            | System.Windows.Forms.AnchorStyles.Right)));
6393
            this.btnMaster_11.Location = new System.Drawing.Point(363, 443);
6393
            this.btnMaster_11.Location = new System.Drawing.Point(345, 443);
6394 6394
            this.btnMaster_11.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6395 6395
            this.btnMaster_11.Name = "btnMaster_11";
6396
            this.btnMaster_11.Size = new System.Drawing.Size(300, 38);
6396
            this.btnMaster_11.Size = new System.Drawing.Size(285, 38);
6397 6397
            this.btnMaster_11.TabIndex = 14;
6398 6398
            this.btnMaster_11.Text = "発注者区分登録";
6399 6399
            this.btnMaster_11.UseVisualStyleBackColor = true;
......
6404 6404
            this.btnMaster_17.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6405 6405
            | System.Windows.Forms.AnchorStyles.Left) 
6406 6406
            | System.Windows.Forms.AnchorStyles.Right)));
6407
            this.btnMaster_17.Location = new System.Drawing.Point(722, 443);
6407
            this.btnMaster_17.Location = new System.Drawing.Point(686, 443);
6408 6408
            this.btnMaster_17.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6409 6409
            this.btnMaster_17.Name = "btnMaster_17";
6410
            this.btnMaster_17.Size = new System.Drawing.Size(303, 38);
6410
            this.btnMaster_17.Size = new System.Drawing.Size(288, 38);
6411 6411
            this.btnMaster_17.TabIndex = 23;
6412 6412
            this.btnMaster_17.Text = "積算大項目登録";
6413 6413
            this.btnMaster_17.UseVisualStyleBackColor = true;
......
6421 6421
            this.btnMaster_05.Location = new System.Drawing.Point(4, 443);
6422 6422
            this.btnMaster_05.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6423 6423
            this.btnMaster_05.Name = "btnMaster_05";
6424
            this.btnMaster_05.Size = new System.Drawing.Size(300, 38);
6424
            this.btnMaster_05.Size = new System.Drawing.Size(285, 38);
6425 6425
            this.btnMaster_05.TabIndex = 5;
6426 6426
            this.btnMaster_05.Text = "期 限 登 録";
6427 6427
            this.btnMaster_05.UseVisualStyleBackColor = true;
......
6435 6435
            this.btnMaster_04.Location = new System.Drawing.Point(4, 355);
6436 6436
            this.btnMaster_04.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6437 6437
            this.btnMaster_04.Name = "btnMaster_04";
6438
            this.btnMaster_04.Size = new System.Drawing.Size(300, 38);
6438
            this.btnMaster_04.Size = new System.Drawing.Size(285, 38);
6439 6439
            this.btnMaster_04.TabIndex = 4;
6440 6440
            this.btnMaster_04.Text = "会社休日登録";
6441 6441
            this.btnMaster_04.UseVisualStyleBackColor = true;
......
6449 6449
            this.btnMaster_03.Location = new System.Drawing.Point(4, 267);
6450 6450
            this.btnMaster_03.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6451 6451
            this.btnMaster_03.Name = "btnMaster_03";
6452
            this.btnMaster_03.Size = new System.Drawing.Size(300, 38);
6452
            this.btnMaster_03.Size = new System.Drawing.Size(285, 38);
6453 6453
            this.btnMaster_03.TabIndex = 3;
6454 6454
            this.btnMaster_03.UseVisualStyleBackColor = true;
6455 6455
            this.btnMaster_03.Click += new System.EventHandler(this.btnMaster_Click);
......
6462 6462
            this.btnMaster_02.Location = new System.Drawing.Point(4, 179);
6463 6463
            this.btnMaster_02.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6464 6464
            this.btnMaster_02.Name = "btnMaster_02";
6465
            this.btnMaster_02.Size = new System.Drawing.Size(300, 38);
6465
            this.btnMaster_02.Size = new System.Drawing.Size(285, 38);
6466 6466
            this.btnMaster_02.TabIndex = 2;
6467 6467
            this.btnMaster_02.Text = "工事経費名称登録";
6468 6468
            this.btnMaster_02.UseVisualStyleBackColor = true;
......
6476 6476
            this.btnMaster_01.Location = new System.Drawing.Point(4, 91);
6477 6477
            this.btnMaster_01.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6478 6478
            this.btnMaster_01.Name = "btnMaster_01";
6479
            this.btnMaster_01.Size = new System.Drawing.Size(300, 38);
6479
            this.btnMaster_01.Size = new System.Drawing.Size(285, 38);
6480 6480
            this.btnMaster_01.TabIndex = 1;
6481 6481
            this.btnMaster_01.Text = "工事種別登録";
6482 6482
            this.btnMaster_01.UseVisualStyleBackColor = true;
......
6490 6490
            this.btnMaster_18.Location = new System.Drawing.Point(4, 531);
6491 6491
            this.btnMaster_18.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6492 6492
            this.btnMaster_18.Name = "btnMaster_18";
6493
            this.btnMaster_18.Size = new System.Drawing.Size(300, 38);
6493
            this.btnMaster_18.Size = new System.Drawing.Size(285, 38);
6494 6494
            this.btnMaster_18.TabIndex = 6;
6495 6495
            this.btnMaster_18.UseVisualStyleBackColor = true;
6496 6496
            this.btnMaster_18.Click += new System.EventHandler(this.btnMaster_Click);
......
6500 6500
            this.btnMaster_19.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6501 6501
            | System.Windows.Forms.AnchorStyles.Left) 
6502 6502
            | System.Windows.Forms.AnchorStyles.Right)));
6503
            this.btnMaster_19.Location = new System.Drawing.Point(363, 531);
6503
            this.btnMaster_19.Location = new System.Drawing.Point(345, 531);
6504 6504
            this.btnMaster_19.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6505 6505
            this.btnMaster_19.Name = "btnMaster_19";
6506
            this.btnMaster_19.Size = new System.Drawing.Size(300, 38);
6506
            this.btnMaster_19.Size = new System.Drawing.Size(285, 38);
6507 6507
            this.btnMaster_19.TabIndex = 15;
6508 6508
            this.btnMaster_19.Text = "発注者登録";
6509 6509
            this.btnMaster_19.UseVisualStyleBackColor = true;
......
6514 6514
            this.btnMaster_20.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6515 6515
            | System.Windows.Forms.AnchorStyles.Left) 
6516 6516
            | System.Windows.Forms.AnchorStyles.Right)));
6517
            this.btnMaster_20.Location = new System.Drawing.Point(722, 531);
6517
            this.btnMaster_20.Location = new System.Drawing.Point(686, 531);
6518 6518
            this.btnMaster_20.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6519 6519
            this.btnMaster_20.Name = "btnMaster_20";
6520
            this.btnMaster_20.Size = new System.Drawing.Size(303, 38);
6520
            this.btnMaster_20.Size = new System.Drawing.Size(288, 38);
6521 6521
            this.btnMaster_20.TabIndex = 24;
6522 6522
            this.btnMaster_20.Text = "積算大・中項目関連登録";
6523 6523
            this.btnMaster_20.UseVisualStyleBackColor = true;
......
6531 6531
            this.btnMaster_21.Location = new System.Drawing.Point(4, 619);
6532 6532
            this.btnMaster_21.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6533 6533
            this.btnMaster_21.Name = "btnMaster_21";
6534
            this.btnMaster_21.Size = new System.Drawing.Size(300, 38);
6534
            this.btnMaster_21.Size = new System.Drawing.Size(285, 38);
6535 6535
            this.btnMaster_21.TabIndex = 7;
6536 6536
            this.btnMaster_21.Text = "売上グラフデータ入力";
6537 6537
            this.btnMaster_21.UseVisualStyleBackColor = true;
......
6542 6542
            this.btnMaster_22.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6543 6543
            | System.Windows.Forms.AnchorStyles.Left) 
6544 6544
            | System.Windows.Forms.AnchorStyles.Right)));
6545
            this.btnMaster_22.Location = new System.Drawing.Point(363, 619);
6545
            this.btnMaster_22.Location = new System.Drawing.Point(345, 619);
6546 6546
            this.btnMaster_22.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6547 6547
            this.btnMaster_22.Name = "btnMaster_22";
6548
            this.btnMaster_22.Size = new System.Drawing.Size(300, 38);
6548
            this.btnMaster_22.Size = new System.Drawing.Size(285, 38);
6549 6549
            this.btnMaster_22.TabIndex = 16;
6550 6550
            this.btnMaster_22.Text = "購入先登録";
6551 6551
            this.btnMaster_22.UseVisualStyleBackColor = true;
......
6556 6556
            this.btnMaster_23.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6557 6557
            | System.Windows.Forms.AnchorStyles.Left) 
6558 6558
            | System.Windows.Forms.AnchorStyles.Right)));
6559
            this.btnMaster_23.Location = new System.Drawing.Point(722, 619);
6559
            this.btnMaster_23.Location = new System.Drawing.Point(686, 619);
6560 6560
            this.btnMaster_23.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6561 6561
            this.btnMaster_23.Name = "btnMaster_23";
6562
            this.btnMaster_23.Size = new System.Drawing.Size(303, 38);
6562
            this.btnMaster_23.Size = new System.Drawing.Size(288, 38);
6563 6563
            this.btnMaster_23.TabIndex = 25;
6564 6564
            this.btnMaster_23.Text = "積算中項目登録";
6565 6565
            this.btnMaster_23.UseVisualStyleBackColor = true;
......
6573 6573
            this.btnMaster_24.Location = new System.Drawing.Point(4, 707);
6574 6574
            this.btnMaster_24.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6575 6575
            this.btnMaster_24.Name = "btnMaster_24";
6576
            this.btnMaster_24.Size = new System.Drawing.Size(300, 38);
6576
            this.btnMaster_24.Size = new System.Drawing.Size(285, 38);
6577 6577
            this.btnMaster_24.TabIndex = 8;
6578 6578
            this.btnMaster_24.UseVisualStyleBackColor = true;
6579 6579
            this.btnMaster_24.Click += new System.EventHandler(this.btnMaster_Click);
......
6583 6583
            this.btnMaster_25.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6584 6584
            | System.Windows.Forms.AnchorStyles.Left) 
6585 6585
            | System.Windows.Forms.AnchorStyles.Right)));
6586
            this.btnMaster_25.Location = new System.Drawing.Point(363, 707);
6586
            this.btnMaster_25.Location = new System.Drawing.Point(345, 707);
6587 6587
            this.btnMaster_25.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6588 6588
            this.btnMaster_25.Name = "btnMaster_25";
6589
            this.btnMaster_25.Size = new System.Drawing.Size(300, 38);
6589
            this.btnMaster_25.Size = new System.Drawing.Size(285, 38);
6590 6590
            this.btnMaster_25.TabIndex = 17;
6591 6591
            this.btnMaster_25.Text = "承認経路登録";
6592 6592
            this.btnMaster_25.UseVisualStyleBackColor = true;
......
6597 6597
            this.btnMaster_26.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
6598 6598
            | System.Windows.Forms.AnchorStyles.Left) 
6599 6599
            | System.Windows.Forms.AnchorStyles.Right)));
6600
            this.btnMaster_26.Location = new System.Drawing.Point(722, 707);
6600
            this.btnMaster_26.Location = new System.Drawing.Point(686, 707);
6601 6601
            this.btnMaster_26.Margin = new System.Windows.Forms.Padding(4, 3, 4, 3);
6602 6602
            this.btnMaster_26.Name = "btnMaster_26";
6603
            this.btnMaster_26.Size = new System.Drawing.Size(303, 38);
6603
            this.btnMaster_26.Size = new System.Drawing.Size(288, 38);
6604 6604
            this.btnMaster_26.TabIndex = 26;
6605 6605
            this.btnMaster_26.Text = "積算小項目登録";
6606 6606
            this.btnMaster_26.UseVisualStyleBackColor = true;
trunk/src/ProcessManagement/ProcessManagement/Forms/ZMenu/FrmMenu.cs
2149 2149
                }
2150 2150
                else if (btnKey.Name == "btnMaster_24")
2151 2151
                {
2152
                    // テスト的に台帳を表示する
2153
                    int NowPoint = ClsExcute.NextProcess((int)ClsExcute.ProcessExecuteNo.DepartmentExpenssList);
2152 2154
                }
2153 2155
                //---- 2列目
2154 2156
                else if (btnKey.Name == "btnMaster_06")
trunk/src/ProcessManagement/ProcessManagement/Forms/ZMenu/FrmMenuAuxiliary.cs
695 695
        #endregion
696 696
        #endregion
697 697

  
698
        #region 数字選択ボックス初期営業期セット
699
        /// <summary>
700
        /// 数字選択ボックス初期営業期セット
701
        /// </summary>
702
        /// <param name="numUPObject"></param>
703
        private void SetInitNumUDData(NumericUpDown numUPObject)
704
        {
705
            try
706
            {
707
                m_bInitFlg = true;
708
                // 検索年度セット
709
                // データにある事業期と現在の事業セット
710
                int minval = 0;
711
                int maxval = 0;
712
                CommonMotions.GetPeriodYear(ref minval, ref maxval);
713
                numUPObject.Minimum = minval;
714
                numUPObject.Maximum = maxval;
715
                numUPObject.Value = CommonMotions.SystemMasterData.BusinessPeriod;
716
            }
717
            catch (Exception ex)
718
            {
719
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
720
            }
721
            finally
722
            {
723
                m_bInitFlg = false;
724
            }
725
        }
726
        #endregion
727

  
728
        #region 月毎の件数を取得する
729
        /// <summary>
730
        /// 月毎の件数を取得する
731
        /// </summary>
732
        /// <param name="StartDate"></param>
733
        /// <returns></returns>
734
        private int GetMonthryCount()
735
        {
736
            IOConstructionBaseInfo cbiDB = new IOConstructionBaseInfo();
737
            try
738
            {
739
                int iCount = 0;
740
                List<int> stat = new List<int>();
741
                stat.Add(CommonDefine.ProjectsStatus.First(x => x.Value.Equals("施工完了")).Key);            // 8
742
                stat.Add(CommonDefine.ProjectsStatus.First(x => x.Value.Equals("請求準備")).Key);            // 9
743
                stat.Add(CommonDefine.ProjectsStatus.First(x => x.Value.Equals("請求完了")).Key);           // 10
744

  
745
                string strSQL = "SELECT TO_CHAR(ConstructionCompletionDate,'YYYY/MM'), count(*) FROM CONSTRUCTIONBASEINFO";
746
                strSQL += CreateListSQLFluctuation();
747
                strSQL += CreateListSQL(stat);
748
                //strSQL += string.Format(" And TO_DATE('{0}', 'yyyy/dd/mm') <= ConstructionCompletionDate", StartDate.ToShortDateString());
749
                strSQL += string.Format(" And CONSTRUCTIONPERIOD = {0}", numUDCompletion.Value);
750
                strSQL += " GROUP BY TO_CHAR(ConstructionCompletionDate,'YYYY/MM')";
751
                strSQL += " Order By TO_CHAR(ConstructionCompletionDate,'YYYY/MM') Desc";
752
                ArrayList arList = new ArrayList();
753
                if (!cbiDB.ExecuteReader(strSQL, ref arList)) return 0;
754
                iCount = arList.Count;
755

  
756
                if (iCount <= 2) iCount--;
757
                return iCount;
758
            }
759
            catch (Exception ex)
760
            {
761
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
762
                return 0;
763
            }
764
            finally
765
            {
766
                cbiDB.close(); cbiDB = null;
767
            }
768
        }
769
        #endregion
770

  
771
        #region 期の件数を取得する
772
        /// <summary>
773
        /// 期の件数を取得する
774
        /// </summary>
775
        /// <param name="StartDate"></param>
776
        /// <returns></returns>
777
        private int GetPeriodCount(string strWhere)
778
        {
779
            IOConstructionBaseInfo cbiDB = new IOConstructionBaseInfo();
780
            try
781
            {
782
                string strSQL = "SELECT ConstructionPeriod, Count(*) FROM CONSTRUCTIONBASEINFO";
783
                strSQL += strWhere;
784
                strSQL += " GROUP BY ConstructionPeriod";
785
                ArrayList arList = new ArrayList();
786
                if (!cbiDB.ExecuteReader(strSQL, ref arList)) return 0;
787
                int iCount = arList.Count;
788

  
789
                return iCount;
790
            }
791
            catch (Exception ex)
792
            {
793
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
794
                return 0;
795
            }
796
            finally
797
            {
798
                cbiDB.close(); cbiDB = null;
799
            }
800
        }
801
        #endregion
802

  
803
        #region グリッドソート実行
804
        private void GridSortExcute(DataGridView ExeGrid)
805
        {
806
            try
807
            {
808
                // ソート無は処理しない
809
                if (m_SortColumns == -1 || m_SortModes == -1) return;
810

  
811
                // カラム取得
812
                DataGridViewColumn wrksortcolumn = ExeGrid.Columns[m_SortColumns];
813
                // ソートオーダー取得
814
                ListSortDirection sortDirection = ((SortOrder)m_SortModes) == SortOrder.Ascending ?
815
                                                        ListSortDirection.Ascending : ListSortDirection.Descending;
816
                ExeGrid.Sort(wrksortcolumn, sortDirection);
817
            }
818
            catch (Exception ex)
819
            {
820
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
821
            }
822
        }
823
        #endregion
824

  
825
        #region グリッドソート退避エリアのクリア
826
        /// <summary>
827
        /// ソート退避エリアのクリア
828
        /// </summary>
829
        private void ClearGridSortStatus(DataGridView ClearGrid)
830
        {
831
            // 前にソートしていたらグリッドソートのクリア
832
            DataGridViewColumn oldColumn = ClearGrid.SortedColumn;
833
            if (oldColumn != null)
834
                oldColumn.HeaderCell.SortGlyphDirection = SortOrder.None;
835

  
836
            m_SortColumns = -1;
837
            m_SortModes = -1;
838
        }
839
        #endregion
840

  
841
        #region グリッドソート状態の退避
842
        /// <summary>
843
        /// グリッドソート状態の退避
844
        /// </summary>
845
        private void GetGridSortStatus(DataGridView GetGrid)
846
        {
847
            // ソート状態
848
            if (GetGrid.SortedColumn != null)
849
            {
850
                m_SortColumns = (int)GetGrid.SortedColumn.Index;
851
                m_SortModes = (int)GetGrid.SortOrder;
852
            }
853
        }
854
        #endregion
855

  
856
        #region 初期時サブフォームハンドルリスト作成
857
        /// <summary>
858
        /// 初期時サブフォームハンドルリスト作成
859
        /// </summary>
860
        private void InitSubFormHandleList()
861
        {
862
            try
863
            {
864
                // フォームハンドル初期化
865
                int cnt = Enum.GetNames(typeof(ClsExcute.ProcessExecuteNo)).Length;
866
                ClsExcute.SubFormHandleList = new PreserveSubFormHandle[cnt];
867
                for (int i = 0; i < ClsExcute.SubFormHandleList.Length; i++)
868
                {
869
                    ClsExcute.SubFormHandleList[i] = new PreserveSubFormHandle();
870
                    ClsExcute.SubFormHandleList[i].ProcessNo = (int)ClsExcute.ProcessExecuteNo.MainMenu;
871
                    ClsExcute.SubFormHandleList[i].SubFormHandle = null;
872
                }
873
            }
874
            catch (Exception ex)
875
            {
876
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
877
            }
878
        }
879
        #endregion
880

  
881
        #region 初期コントロールオブジェクト取得
882
        /// <summary>
883
        /// 初期コントロールオブジェクト取得
884
        /// </summary>
885
        private void SetInitObject()
886
        {
887
            try
888
            {
889
                // フォームサイズ取得
890
                m_FormWidthSize = this.Width;
891

  
892
                // グリッドの情報を取得する(タブ数分確保する)
893
                int AllTabCount = Enum.GetNames(typeof(FrmMenuTabNameEnum)).Length;
894
                m_Alldgv = new DataGridView[AllTabCount];
895
                m_GridWidthSize = new int[AllTabCount];
896

  
897
                for (int i = 0; i < AllTabCount; i++) m_Alldgv[i] = null;
898
                for (int i = 0; i < AllTabCount; i++) m_GridWidthSize[i] = -1;
899

  
900
                int TabPoint = 0;
901
                // 1:秘書からの連絡
902
                TabPoint = (int)FrmMenuTabNameEnum.BusinessMessage - 1;
903
                m_GridWidthSize[TabPoint] = dgvBusinessMessage.Width;
904
                m_Alldgv[TabPoint] = dgvBusinessMessage;
905
                // 2:社内掲示板
906
                TabPoint = (int)FrmMenuTabNameEnum.MessageBoard - 1;
907
                m_GridWidthSize[TabPoint] = dgvMessageBoard.Width;
908
                m_Alldgv[TabPoint] = dgvMessageBoard;
909
                // 3:承認一覧
910
                TabPoint = (int)FrmMenuTabNameEnum.DocumentApproval - 1;
911
                m_GridWidthSize[TabPoint] = dgvApproval.Width;
912
                m_Alldgv[TabPoint] = dgvApproval;
913
                // 4:工事案件
914
                TabPoint = (int)FrmMenuTabNameEnum.SalesInProjects - 1;
915
                m_GridWidthSize[TabPoint] = dgvSalesInProjects.Width;
916
                m_Alldgv[TabPoint] = dgvSalesInProjects;
917
                // 5:入札案件
918
                TabPoint = (int)FrmMenuTabNameEnum.Tenders - 1;
919
                m_GridWidthSize[TabPoint] = dgvTenders.Width;
920
                m_Alldgv[TabPoint] = dgvTenders;
921
                // 6:予算取り案件
922
                TabPoint = (int)FrmMenuTabNameEnum.BudgetUpProjects - 1;
923
                m_GridWidthSize[TabPoint] = dgvBudgetUp.Width;
924
                m_Alldgv[TabPoint] = dgvBudgetUp;
925
                // 7:受注案件
926
                TabPoint = (int)FrmMenuTabNameEnum.ConstructionProjects - 1;
927
                m_GridWidthSize[TabPoint] = dgvConstructionProjects.Width;
928
                m_Alldgv[TabPoint] = dgvConstructionProjects;
929
                // 8:非受注工事
930
                TabPoint = (int)FrmMenuTabNameEnum.NonOrders - 1;
931
                m_GridWidthSize[TabPoint] = dgvNonOrders.Width;
932
                m_Alldgv[TabPoint] = dgvNonOrders;
933
                // 9:完了工事
934
                TabPoint = (int)FrmMenuTabNameEnum.CompletionOfConstruction - 1;
935
                m_GridWidthSize[TabPoint] = dgvCompletionOfConstruction.Width;
936
                m_Alldgv[TabPoint] = dgvCompletionOfConstruction;
937
                // 10:行動予定
938
                TabPoint = (int)FrmMenuTabNameEnum.ActionSchedule - 1;
939
                m_GridWidthSize[TabPoint] = dgvActionSchedule.Width;
940
                m_Alldgv[TabPoint] = dgvActionSchedule;
941
                // 11:人員配置
942
                TabPoint = (int)FrmMenuTabNameEnum.StaffAssignment - 1;
943
                m_GridWidthSize[TabPoint] = dgvStaffAssignment.Width;
944
                m_Alldgv[TabPoint] = dgvStaffAssignment;
945
                // ----- 以下はグリッド無・未定
946
                // 12:売上グラフ
947
                //SalesGraph,
948
                // 13:受注管理
949
                //OrderMenu,
950
                // 14:施工管理
951
                //ConstructionMenu,
952
                // 15:請求管理
953
                //BillingMenu,
954
                // 16:各種提出書類
955
                //DocumentsToBeBubmitted,
956
                // 17:総務管理
957
                //Affairs,
958
                // 18:BOSSマスタ
959
                //MentenanceMenu,
960
                // 19:管理者マスタ
961
                //MentenanceMenu1,
962
                // 20:所属長マスタ
963
                //MentenanceMenu2,
964
                // 21:担当者マスタ
965
                //MentenanceMenu3,
966
                // 22:参考資料
967
                //ReferenceData,
968
                // 23:資材管理
969
                //Materials,
970

  
971
                // セルサイズ取得
972
                int MaxCelCount = 0;
973
                // 一番多いグリッドに合わせる
974
                foreach (DataGridView dgv in m_Alldgv)
975
                {
976
                    if (dgv == null) continue;
977
                    if (MaxCelCount < dgv.ColumnCount) MaxCelCount = dgv.ColumnCount;
978
                }
979

  
980
                m_CellSize = new int[AllTabCount, MaxCelCount];
981
                // 初期値-1セット
982
                for (int iy = 0; iy < m_CellSize.GetLength(0); iy++)
983
                {
984
                    for (int ix = 0; ix < m_CellSize.GetLength(1); ix++)
985
                    {
986
                        m_CellSize[iy, ix] = -1;
987
                    }
988
                }
989
                // セル値セット
990
                for (int iGrid = 0; iGrid < AllTabCount; iGrid++)
991
                {
992
                    // グリッド設定無は処理しない
993
                    if (m_Alldgv[iGrid] == null) continue;
994
                    for (int iCell = 0; iCell < m_Alldgv[iGrid].ColumnCount; iCell++)
995
                    {
996
                        m_CellSize[iGrid, iCell] = m_Alldgv[iGrid].Columns[iCell].Width;
997
                    }
998
                }
999
            }
1000
            catch (Exception ex)
1001
            {
1002
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
1003
            }
1004
        }
1005
        #endregion
1006

  
1007
        private void SelectLedgerProcess()
1008
        {
1009
            try
1010
            {
1011
                // 
1012
            }
1013
            catch (Exception ex)
1014
            {
1015
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
1016
            }
1017
        }
1018

  
1019
        #region メニュータブ表示関連処理
1020
        // *---------------- メニュータブ表示関連処理
1021
        
698 1022
        #region 承認申請
699 1023
        #region 承認申請データを取得する
700 1024
        /// <summary>
......
1897 2221
                string strPeriod = CreateConstructionProjectsSQL();
1898 2222
                int minval = 0;
1899 2223
                int maxval = 0;
1900
                GetPeriodYear(strPeriod, ref minval, ref maxval);
2224
                CommonMotions.GetPeriodYear(ref minval, ref maxval);
1901 2225
                numUDConstPro.Minimum = minval;
1902 2226
                numUDConstPro.Maximum = maxval;
1903 2227
                if (minval <= CommonMotions.SystemMasterData.BusinessPeriod && CommonMotions.SystemMasterData.BusinessPeriod <= maxval)
......
3063 3387
        #endregion
3064 3388
        #endregion
3065 3389

  
3066
        #region 期の最大・最少を取得する
3390
        #region 売上グラフ
3391
        #region 売上グラフ表示
3067 3392
        /// <summary>
3068
        /// 期の最大・最少を取得する
3393
        /// 売上グラフ表示
3069 3394
        /// </summary>
3070
        /// <param name="StartDate"></param>
3071
        /// <returns></returns>
3072
        private void GetPeriodYear(string strWhere, ref int min, ref int max)
3395
        private void DispSalesGraph(bool bInitFlg = true)
3073 3396
        {
3074
            IOConstructionBaseInfo cbiDB = new IOConstructionBaseInfo();
3075 3397
            try
3076 3398
            {
3077
                string strSQL = "SELECT ConstructionPeriod FROM CONSTRUCTIONBASEINFO";
3078
                strSQL += strWhere;
3079
                strSQL += " GROUP BY ConstructionPeriod";
3080
                ArrayList arList = new ArrayList();
3081
                if (!cbiDB.ExecuteReader(strSQL, ref arList)) return;
3082
                int[] iNumber = new int[arList.Count];
3083
                int i = 0;
3084
                foreach (object[] wrkobj in arList)
3399
                chartSalesGraph.SuspendLayout();
3400
                // 初期化
3401
                chartSalesGraph.Series.Clear();
3402
                if (bInitFlg)
3085 3403
                {
3086
                    iNumber[i++] = CommonMotions.cnvInt(wrkobj[0].ToString());
3404
                    // データにある事業期と現在の事業セット
3405
                    SetPeriodYear();
3087 3406
                }
3088
                min = iNumber.Min();
3089
                max = iNumber.Max();
3090
            }
3091
            catch (Exception ex)
3092
            {
3093
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
3094
            }
3095
            finally
3096
            {
3097
                cbiDB.close(); cbiDB = null;
3098
            }
3099
        }
3100
        #endregion
3407
                // データの取得
3408
                DataSet ds = GetData();
3101 3409

  
3102
        #region 数字選択ボックス初期営業期セット
3103
        /// <summary>
3104
        /// 数字選択ボックス初期営業期セット
3105
        /// </summary>
3106
        /// <param name="numUPObject"></param>
3107
        private void SetInitNumUDData(NumericUpDown numUPObject)
3108
        {
3109
            try
3110
            {
3111
                m_bInitFlg = true;
3112
                // 検索年度セット
3113
                // データにある事業期と現在の事業セット
3114
                int minval = 0;
3115
                int maxval = 0;
3116
                CommonMotions.GetPeriodYear(ref minval, ref maxval);
3117
                numUPObject.Minimum = minval;
3118
                numUPObject.Maximum = maxval;
3119
                numUPObject.Value = CommonMotions.SystemMasterData.BusinessPeriod;
3410
                // Chartコントロールにデータソースを設定
3411
                chartSalesGraph.DataSource = ds;
3412

  
3413
                // グラフの種類,系列,軸の設定
3414
                for (int i = 1; i < ds.Tables[0].Columns.Count; i++)
3415
                {
3416
                    // 列名の取得
3417
                    string columnName = ds.Tables[0].Columns[i].ColumnName;
3418

  
3419
                    // 系列の設定
3420
                    chartSalesGraph.Series.Add(columnName);
3421

  
3422
                    // グラフの種類
3423
                    chartSalesGraph.Series[columnName].ChartType = SeriesChartType.Column;
3424

  
3425
                    // X軸
3426
                    chartSalesGraph.Series[columnName].XValueMember = ds.Tables[0].Columns[0].ColumnName.ToString();
3427
                    chartSalesGraph.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
3428
                    chartSalesGraph.ChartAreas[0].AxisX.MinorGrid.Enabled = false;
3429

  
3430
                    // Y軸
3431
                    chartSalesGraph.Series[columnName].YValueMembers = columnName;
3432

  
3433
                    // バーの色
3434
                    switch (i)
3435
                    {
3436
                        case 1:
3437
                            chartSalesGraph.Series[columnName].Color = Color.Lime;
3438
                            break;
3439
                        case 2:
3440
                            chartSalesGraph.Series[columnName].Color = Color.Yellow;
3441
                            break;
3442
                        case 3:
3443
                            chartSalesGraph.Series[columnName].Color = Color.Cyan;
3444
                            break;
3445
                        case 4:
3446
                            chartSalesGraph.Series[columnName].Color = Color.Blue;
3447
                            break;
3448
                    }
3449
                    // グラフを円筒形に描画
3450
                    chartSalesGraph.Series[columnName].SetCustomProperty("DrawingStyle", "Cylinder");
3451
                }
3452

  
3453
                // X軸タイトル
3454
                //chartSalesGraph.ChartAreas[0].AxisX.Title = "月";
3455

  
3456
                // Y軸タイトル
3457
                chartSalesGraph.ChartAreas[0].AxisY.LabelStyle.Format = "#,##0円";
3458

  
3459
                chartSalesGraph.DataBind();
3120 3460
            }
3121 3461
            catch (Exception ex)
3122 3462
            {
......
3124 3464
            }
3125 3465
            finally
3126 3466
            {
3127
                m_bInitFlg = false;
3467
                chartSalesGraph.ResumeLayout();
3128 3468
            }
3129 3469
        }
3130 3470
        #endregion
3131 3471

  
3132
        #region 月毎の件数を取得する
3472
        #region データの設定
3133 3473
        /// <summary>
3134
        /// 月毎の件数を取得する
3474
        /// データの設定
3135 3475
        /// </summary>
3136
        /// <param name="StartDate"></param>
3137 3476
        /// <returns></returns>
3138
        private int GetMonthryCount()
3477
        private DataSet GetData()
3139 3478
        {
3140
            IOConstructionBaseInfo cbiDB = new IOConstructionBaseInfo();
3479
            DataSet ds = new DataSet();
3480
            DataTable dt = new DataTable();
3481
            DataRow dtRow;
3482

  
3483
            IOSalesGraphData sgdDB = new IOSalesGraphData();
3484
            List<SalesGraphData> sgdList = new List<SalesGraphData>();
3141 3485
            try
3142 3486
            {
3143
                int iCount = 0;
3144
                List<int> stat = new List<int>();
3145
                stat.Add(CommonDefine.ProjectsStatus.First(x => x.Value.Equals("施工完了")).Key);            // 8
3146
                stat.Add(CommonDefine.ProjectsStatus.First(x => x.Value.Equals("請求準備")).Key);            // 9
3147
                stat.Add(CommonDefine.ProjectsStatus.First(x => x.Value.Equals("請求完了")).Key);           // 10
3148 3487

  
3149
                string strSQL = "SELECT TO_CHAR(ConstructionCompletionDate,'YYYY/MM'), count(*) FROM CONSTRUCTIONBASEINFO";
3150
                strSQL += CreateListSQLFluctuation();
3151
                strSQL += CreateListSQL(stat);
3152
                //strSQL += string.Format(" And TO_DATE('{0}', 'yyyy/dd/mm') <= ConstructionCompletionDate", StartDate.ToShortDateString());
3153
                strSQL += string.Format(" And CONSTRUCTIONPERIOD = {0}", numUDCompletion.Value);
3154
                strSQL += " GROUP BY TO_CHAR(ConstructionCompletionDate,'YYYY/MM')";
3155
                strSQL += " Order By TO_CHAR(ConstructionCompletionDate,'YYYY/MM') Desc";
3156
                ArrayList arList = new ArrayList();
3157
                if(!cbiDB.ExecuteReader(strSQL,ref arList)) return 0;
3158
                iCount = arList.Count;
3488
                // 列の作成
3489
                dt.Columns.Add("対象名", Type.GetType("System.String"));
3490
                dt.Columns.Add("売上", Type.GetType("System.Int32"));
3491
                dt.Columns.Add("販管・部署経費", Type.GetType("System.Int32"));
3492
                dt.Columns.Add("粗利益", Type.GetType("System.Int32"));
3493
                dt.Columns.Add("純利益(損益)", Type.GetType("System.Int32"));
3494
                ds.Tables.Add(dt);
3159 3495

  
3160
                if (iCount <= 2) iCount--;
3161
                return iCount;
3496
                // SQL作成
3497
                string strSQL = string.Format(" WHERE ConstructionPeriod = {0} Order By DisplayOrder ASC", SalseGraphNum.Value);
3498
                // 表示順マスタ取得
3499
                if (!sgdDB.SelectAction(strSQL, ref sgdList)) return ds;
3500

  
3501
                int ino = 0;
3502
                progBarSalesGraph.Visible = true;
3503
                progBarSalesGraph.Minimum = ino;
3504
                progBarSalesGraph.Maximum = sgdList.Count;
3505
                tabPage12.Update();
3506

  
3507
                DateTime wrkUpdate = sgdList[0].UpdateDate;
3508
                foreach (SalesGraphData wrkRec in sgdList)
3509
                {
3510
                    // データの追加
3511
                    dtRow = ds.Tables[0].NewRow();
3512
                    dtRow[0] = wrkRec.DataName;
3513
                    dtRow[1] = wrkRec.SalesAmount.ToString();
3514
                    dtRow[2] = wrkRec.AdministrativeExpense.ToString();
3515
                    dtRow[3] = wrkRec.GrossProfit.ToString();
3516
                    dtRow[4] = wrkRec.NetIncome.ToString();
3517
                    ds.Tables[0].Rows.Add(dtRow);
3518

  
3519
                    // 1番大きい更新値を取る
3520
                    if (wrkUpdate < wrkRec.UpdateDate) wrkUpdate = wrkRec.UpdateDate;
3521

  
3522
                    // ProgressBarの値を変更する
3523
                    progBarSalesGraph.Value = ino++;
3524
                    progBarSalesGraph.Update();
3525
                }
3526

  
3527
                // ProgressBarの値を変更する
3528
                progBarSalesGraph.Value = progBarSalesGraph.Maximum;
3529
                progBarSalesGraph.Update();
3530
                progBarSalesGraph.Visible = false;
3531

  
3532
                // 更新日時を表示する
3533
                lblSalesGraphUpdate.Text = wrkUpdate.ToString("yyyy年MM月dd日 tthh時mm分 ") + "現在";
3162 3534
            }
3163 3535
            catch (Exception ex)
3164 3536
            {
3165 3537
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
3166
                return 0;
3167 3538
            }
3168 3539
            finally
3169 3540
            {
3170
                cbiDB.close(); cbiDB = null;
3541
                sgdDB.close(); sgdDB = null;
3171 3542
            }
3543

  
3544
            return ds;
3172 3545
        }
3173 3546
        #endregion
3174 3547

  
3175
        #region 期の件数を取得する
3548
        #region 期の最大・最少をセットする(売上グラフ)
3176 3549
        /// <summary>
3177
        /// 期の件数を取得する
3550
        /// 期の最大・最少をセットする(売上グラフ)
3178 3551
        /// </summary>
3179
        /// <param name="StartDate"></param>
3180
        /// <returns></returns>
3181
        private int GetPeriodCount(string strWhere)
3552
        private void SetPeriodYear()
3182 3553
        {
3183
            IOConstructionBaseInfo cbiDB = new IOConstructionBaseInfo();
3184 3554
            try
3185 3555
            {
3186
                string strSQL = "SELECT ConstructionPeriod, Count(*) FROM CONSTRUCTIONBASEINFO";
3187
                strSQL += strWhere;
3188
                strSQL += " GROUP BY ConstructionPeriod";
3189
                ArrayList arList = new ArrayList();
3190
                if (!cbiDB.ExecuteReader(strSQL, ref arList)) return 0;
3191
                int iCount = arList.Count;
3192

  
3193
                return iCount;
3556
                bGraphNotDrow = true;
3557
                // データにある事業期と現在の事業セット
3558
                int minval = 0;
3559
                int maxval = 0;
3560
                CommonMotions.GetPeriodYear(ref minval, ref maxval);
3561
                SalseGraphNum.Minimum = minval;
3562
                SalseGraphNum.Maximum = maxval;
3563
                SalseGraphNum.Value = CommonMotions.SystemMasterData.BusinessPeriod;
3194 3564
            }
3195 3565
            catch (Exception ex)
3196 3566
            {
3197 3567
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
3198
                return 0;
3199 3568
            }
3200 3569
            finally
3201 3570
            {
3202
                cbiDB.close(); cbiDB = null;
3571
                bGraphNotDrow = false;
3203 3572
            }
3204 3573
        }
3205 3574
        #endregion
3575
        #endregion
3206 3576

  
3207 3577
        #region 行動予定一覧表示関連
3208 3578
        #region 行動予定一覧クリア
......
3526 3896
                // 会社予定行
3527 3897
                DispActionFixRow(CommonDefine.s_CompanyActionCode, CommonDefine.s_CompanyActionCode, CommonDefine.s_CompanyActionName);
3528 3898
                // 会社行事表示行
3529
                m_CompanyActionRow = dgv.RowCount-1;
3899
                m_CompanyActionRow = dgv.RowCount - 1;
3530 3900
                // 安全パトロール行
3531 3901
                DispActionFixRow(CommonDefine.s_CompanyActionCode, CommonDefine.s_DivisionActionCode, CommonDefine.s_DivisionActionName);
3532 3902
                // 部署行事表示行
......
3557 3927

  
3558 3928
                    // 担当者が同じならば処理しない
3559 3929
                    if (BreakPerSonCode == PersonRec.PersonCode) continue;
3560
                    
3930

  
3561 3931
                    // 行の追加
3562 3932
                    int LineCnt = dgv.Rows.Add();
3563 3933
                    dgv.Rows.Add();
......
3748 4118
                {
3749 4119
                    // オブジェクト配列より構造体へセット
3750 4120
                    SetActionArrayListToRecTypeB(DataRec, ref PersonRec, ref ActionRec);
3751
                    
4121

  
3752 4122
                    // 担当者が同じならば処理しない
3753 4123
                    if (BreakPerSonCode == PersonRec.PersonCode) continue;
3754 4124

  
......
3802 4172
                    // ブレイクキーセット
3803 4173
                    BreakPerSonCode = PersonRec.PersonCode;
3804 4174
                }
3805
                
4175

  
3806 4176
                // 表示行セット
3807 4177
                if (DspRowCnt != 0) dgvActionSchedule.FirstDisplayedScrollingRowIndex = DspRowCnt;
3808 4178
            }
......
3902 4272
                get { return m_MorningAfternoon; }
3903 4273
                set { m_MorningAfternoon = value; }
3904 4274
            }
3905
            public int PersonCode {
4275
            public int PersonCode
4276
            {
3906 4277
                get { return m_PersonCode; }
3907 4278
                set { m_PersonCode = value; }
3908 4279
            }
......
3984 4355
                strSQL += " LEFT JOIN PERSONINCHARGEMASTER C ON B.PERSONCODE = C.PERSONCODE";
3985 4356
                strSQL += " WHERE VehicleScheduleFlg = 0";
3986 4357
                strSQL += " Order By A.DisplayOrder Asc, B.TargetDate ASC, B.MorningAfternoon ASC";
3987
                
4358

  
3988 4359
                ArrayList vcList = new ArrayList();
3989 4360
                if (!vcDB.ExecuteReader(strSQL, ref vcList)) return;
3990 4361

  
......
4949 5320
        #endregion
4950 5321
        #endregion
4951 5322

  
4952
        #region 売上グラフ
4953
        #region 売上グラフ表示
4954
        /// <summary>
4955
        /// 売上グラフ表示
4956
        /// </summary>
4957
        private void DispSalesGraph(bool bInitFlg = true)
4958
        {
4959
            try
4960
            {
4961
                chartSalesGraph.SuspendLayout();
4962
                // 初期化
4963
                chartSalesGraph.Series.Clear();
4964
                if (bInitFlg)
4965
                {
4966
                    // データにある事業期と現在の事業セット
4967
                    SetPeriodYear();
4968
                }
4969
                // データの取得
4970
                DataSet ds = GetData();
4971

  
4972
                // Chartコントロールにデータソースを設定
4973
                chartSalesGraph.DataSource = ds;
4974

  
4975
                // グラフの種類,系列,軸の設定
4976
                for (int i = 1; i < ds.Tables[0].Columns.Count; i++)
4977
                {
4978
                    // 列名の取得
4979
                    string columnName = ds.Tables[0].Columns[i].ColumnName;
4980

  
4981
                    // 系列の設定
4982
                    chartSalesGraph.Series.Add(columnName);
4983

  
4984
                    // グラフの種類
4985
                    chartSalesGraph.Series[columnName].ChartType = SeriesChartType.Column;
4986

  
4987
                    // X軸
4988
                    chartSalesGraph.Series[columnName].XValueMember = ds.Tables[0].Columns[0].ColumnName.ToString();
4989
                    chartSalesGraph.ChartAreas[0].AxisX.MajorGrid.Enabled = false;
4990
                    chartSalesGraph.ChartAreas[0].AxisX.MinorGrid.Enabled = false;
4991

  
4992
                    // Y軸
4993
                    chartSalesGraph.Series[columnName].YValueMembers = columnName;
4994

  
4995
                    // バーの色
4996
                    switch (i)
4997
                    {
4998
                        case 1:
4999
                            chartSalesGraph.Series[columnName].Color = Color.Lime;
5000
                            break;
5001
                        case 2:
5002
                            chartSalesGraph.Series[columnName].Color = Color.Yellow;
5003
                            break;
5004
                        case 3:
5005
                            chartSalesGraph.Series[columnName].Color = Color.Cyan;
5006
                            break;
5007
                        case 4:
5008
                            chartSalesGraph.Series[columnName].Color = Color.Blue;
5009
                            break;
5010
                    }
5011
                    // グラフを円筒形に描画
5012
                    chartSalesGraph.Series[columnName].SetCustomProperty("DrawingStyle", "Cylinder");
5013
                }
5014

  
5015
                // X軸タイトル
5016
                //chartSalesGraph.ChartAreas[0].AxisX.Title = "月";
5017

  
5018
                // Y軸タイトル
5019
                chartSalesGraph.ChartAreas[0].AxisY.LabelStyle.Format = "#,##0円";
5020

  
5021
                chartSalesGraph.DataBind();
5022
            }
5023
            catch (Exception ex)
5024
            {
5025
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
5026
            }
5027
            finally
5028
            {
5029
                chartSalesGraph.ResumeLayout();
5030
            }
5031
        }
5032 5323
        #endregion
5033

  
5034
        #region データの設定
5035
        /// <summary>
5036
        /// データの設定
5037
        /// </summary>
5038
        /// <returns></returns>
5039
        private DataSet GetData()
5040
        {
5041
            DataSet ds = new DataSet();
5042
            DataTable dt = new DataTable();
5043
            DataRow dtRow;
5044

  
5045
            IOSalesGraphData sgdDB = new IOSalesGraphData();
5046
            List<SalesGraphData> sgdList = new List<SalesGraphData>();
5047
            try
5048
            {
5049

  
5050
                // 列の作成
5051
                dt.Columns.Add("対象名", Type.GetType("System.String"));
5052
                dt.Columns.Add("売上", Type.GetType("System.Int32"));
5053
                dt.Columns.Add("販管・部署経費", Type.GetType("System.Int32"));
5054
                dt.Columns.Add("粗利益", Type.GetType("System.Int32"));
5055
                dt.Columns.Add("純利益(損益)", Type.GetType("System.Int32"));
5056
                ds.Tables.Add(dt);
5057

  
5058
                // SQL作成
5059
                string strSQL = string.Format(" WHERE ConstructionPeriod = {0} Order By DisplayOrder ASC", SalseGraphNum.Value);
5060
                // 表示順マスタ取得
5061
                if (!sgdDB.SelectAction(strSQL, ref sgdList)) return ds;
5062

  
5063
                int ino = 0;
5064
                progBarSalesGraph.Visible = true;
5065
                progBarSalesGraph.Minimum = ino;
5066
                progBarSalesGraph.Maximum = sgdList.Count;
5067
                tabPage12.Update();
5068

  
5069
                DateTime wrkUpdate = sgdList[0].UpdateDate;
5070
                foreach (SalesGraphData wrkRec in sgdList)
5071
                {
5072
                    // データの追加
5073
                    dtRow = ds.Tables[0].NewRow();
5074
                    dtRow[0] = wrkRec.DataName;
5075
                    dtRow[1] = wrkRec.SalesAmount.ToString();
5076
                    dtRow[2] = wrkRec.AdministrativeExpense.ToString();
5077
                    dtRow[3] = wrkRec.GrossProfit.ToString();
5078
                    dtRow[4] = wrkRec.NetIncome.ToString();
5079
                    ds.Tables[0].Rows.Add(dtRow);
5080

  
5081
                    // 1番大きい更新値を取る
5082
                    if (wrkUpdate < wrkRec.UpdateDate) wrkUpdate = wrkRec.UpdateDate;
5083

  
5084
                    // ProgressBarの値を変更する
5085
                    progBarSalesGraph.Value = ino++;
5086
                    progBarSalesGraph.Update();
5087
                }
5088

  
5089
                // ProgressBarの値を変更する
5090
                progBarSalesGraph.Value = progBarSalesGraph.Maximum;
5091
                progBarSalesGraph.Update();
5092
                progBarSalesGraph.Visible = false;
5093

  
5094
                // 更新日時を表示する
5095
                lblSalesGraphUpdate.Text = wrkUpdate.ToString("yyyy年MM月dd日 tthh時mm分 ") + "現在";
5096
            }
5097
            catch (Exception ex)
5098
            {
5099
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
5100
            }
5101
            finally
5102
            {
5103
                sgdDB.close(); sgdDB = null;
5104
            }
5105

  
5106
            return ds;
5107
        }
5108
        #endregion
5109

  
5110
        #region 期の最大・最少を取得する
5111
        /// <summary>
5112
        /// 期の最大・最少を取得する
5113
        /// </summary>
5114
        /// <param name="StartDate"></param>
5115
        /// <returns></returns>
5116
        public void GetSalesPeriodYear(ref int min, ref int max)
5117
        {
5118
            IOSalesGraphData SalesDB = new IOSalesGraphData();
5119
            try
5120
            {
5121
                string strSQL = "SELECT CONSTRUCTIONPERIOD FROM SALESGRAPHDATA";
5122
                strSQL += " GROUP BY CONSTRUCTIONPERIOD";
5123
                strSQL += " ORDER BY CONSTRUCTIONPERIOD";
5124

  
5125
                ArrayList arList = new ArrayList();
5126
                if (!SalesDB.ExecuteReader(strSQL, ref arList)) return;
5127
                if (arList.Count == 0)
5128
                {
5129
                    strSQL = strSQL.Replace("CONSTRUCTIONLEDGER", "CONSTRUCTIONBASEINFO").Replace("CREATORCODE", "CONSTRUCTIONPERSONCODE");
5130
                    if (!SalesDB.ExecuteReader(strSQL, ref arList)) return;
5131
                }
5132

  
5133
                int[] iNumber = new int[arList.Count];
5134
                int i = 0;
5135
                foreach (object[] wrkobj in arList)
5136
                {
5137
                    iNumber[i++] = CommonMotions.cnvInt(wrkobj[0].ToString());
5138
                }
5139
                min = iNumber.Min();
5140
                max = iNumber.Max();
5141
            }
5142
            catch (Exception ex)
5143
            {
5144
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
5145
            }
5146
            finally
5147
            {
5148
                SalesDB.close(); SalesDB = null;
5149
            }
5150
        }
5151
        #endregion
5152

  
5153
        #region 期の最大・最少をセットする
5154
        /// <summary>
5155
        /// 期の最大・最少をセットする
5156
        /// </summary>
5157
        private void SetPeriodYear()
5158
        {
5159
            try
5160
            {
5161
                bGraphNotDrow = true;
5162
                // データにある事業期と現在の事業セット
5163
                int minval = 0;
5164
                int maxval = 0;
5165
                GetSalesPeriodYear(ref minval, ref maxval);
5166
                SalseGraphNum.Minimum = minval;
5167
                SalseGraphNum.Maximum = maxval;
5168
                SalseGraphNum.Value = CommonMotions.SystemMasterData.BusinessPeriod;
5169
            }
5170
            catch (Exception ex)
5171
            {
5172
                logger.ErrorFormat("システムエラー:{0}:{1}", CommonMotions.GetMethodName(), ex.Message);
5173
            }
5174
            finally
5175
            {
5176
                bGraphNotDrow = false;
5177
            }
5178
        }
5179
        #endregion
5180
        #endregion
5181

  
5182
        #region グリッドソート実行
5183
        private void GridSortExcute(DataGridView ExeGrid)
5184
        {
5185
            try
5186
            {
5187
                // ソート無は処理しない
5188
                if (m_SortColumns == -1 || m_SortModes == -1) return;
5189

  
5190
                // カラム取得
5191
                DataGridViewColumn wrksortcolumn = ExeGrid.Columns[m_SortColumns];
5192
                // ソートオーダー取得
5193
                ListSortDirection sortDirection = ((SortOrder)m_SortModes) == SortOrder.Ascending ?
5194
                                                        ListSortDirection.Ascending : ListSortDirection.Descending;
5195
                ExeGrid.Sort(wrksortcolumn, sortDirection);
5196
            }
... 差分の行数が表示可能な上限を超えました。超過分は表示しません。

他の形式にエクスポート: Unified diff