リビジョン 9
・積算予算書の自社施工を同一項目は集計するように修正
・積算予算書の共通仮設費が入力しても値が反映されない不具合を修正
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