リビジョン 281
タイトルが無いGroupBoxをGroupBoxEXに変更
グリッドの背景を白色に変更
メニュー・工事一覧グリッドタイトルクリックソート時空白を削除
メニュー受注案件表示順変更
注文書印刷不具合(法定福利費印刷)修正
branches/src/ProcessManagement/ProcessManagement/Common/CommonVersion.cs | ||
---|---|---|
14 | 14 |
/// <summary> |
15 | 15 |
/// 本体バージョン |
16 | 16 |
/// </summary> |
17 |
public static int s_SystemVersion = 87;
|
|
17 |
public static int s_SystemVersion = 89;
|
|
18 | 18 |
|
19 | 19 |
/// <summary> |
20 | 20 |
/// コピー・環境バージョン |
branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsExcute.cs | ||
---|---|---|
367 | 367 |
/// <summary> |
368 | 368 |
/// 承認種別カラーテーブル(承認処理定義と同じ並び) |
369 | 369 |
/// </summary> |
370 |
#region 旧テーブル |
|
370 | 371 |
//public static Color[] ApprovalTypeColorList = new Color[]{ Color.White, |
371 | 372 |
// Color.RoyalBlue, |
372 | 373 |
// Color.DarkOrange, |
... | ... | |
382 | 383 |
// Color.MediumVioletRed, |
383 | 384 |
// Color.MediumSeaGreen, |
384 | 385 |
// }; |
386 |
#endregion |
|
385 | 387 |
public static Color[] ApprovalTypeColorList = new Color[]{ |
386 | 388 |
Color.White, |
387 | 389 |
Color.RoyalBlue, |
branches/src/ProcessManagement/ProcessManagement/DataModel/PurchaseOrderDetail.cs | ||
---|---|---|
30 | 30 |
/// </summary> |
31 | 31 |
InstructionCondition, |
32 | 32 |
/// <summary> |
33 |
/// 法定福利費 |
|
33 |
/// 9:法定福利費
|
|
34 | 34 |
/// </summary> |
35 | 35 |
StatutoryWelfare = 9, |
36 | 36 |
} |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalList/FrmApprovalList.designer.cs | ||
---|---|---|
44 | 44 |
this.label1 = new System.Windows.Forms.Label(); |
45 | 45 |
this.lblProcessTitil = new System.Windows.Forms.Label(); |
46 | 46 |
this.btnDataUpDate = new System.Windows.Forms.Button(); |
47 |
this.groupBox1 = new System.Windows.Forms.GroupBox();
|
|
47 |
this.groupBox1 = new ProcessManagement.Forms.CustomControls.GroupBoxEx();
|
|
48 | 48 |
this.label4 = new System.Windows.Forms.Label(); |
49 | 49 |
this.numUDConstPro = new System.Windows.Forms.NumericUpDown(); |
50 | 50 |
this.label5 = new System.Windows.Forms.Label(); |
... | ... | |
138 | 138 |
// |
139 | 139 |
this.groupBox1.Anchor = System.Windows.Forms.AnchorStyles.Top; |
140 | 140 |
this.groupBox1.BackColor = System.Drawing.Color.Gold; |
141 |
this.groupBox1.BorderColor = System.Drawing.Color.Silver; |
|
141 | 142 |
this.groupBox1.Controls.Add(this.label4); |
142 | 143 |
this.groupBox1.Controls.Add(this.numUDConstPro); |
143 | 144 |
this.groupBox1.Controls.Add(this.label5); |
... | ... | |
262 | 263 |
this.dgvMaster.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) |
263 | 264 |
| System.Windows.Forms.AnchorStyles.Left) |
264 | 265 |
| System.Windows.Forms.AnchorStyles.Right))); |
265 |
this.dgvMaster.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
|
|
266 |
this.dgvMaster.BackgroundColor = System.Drawing.Color.White;
|
|
266 | 267 |
this.dgvMaster.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; |
267 | 268 |
dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; |
268 | 269 |
dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Control; |
... | ... | |
294 | 295 |
dataGridViewCellStyle11.WrapMode = System.Windows.Forms.DataGridViewTriState.False; |
295 | 296 |
this.dgvMaster.DefaultCellStyle = dataGridViewCellStyle11; |
296 | 297 |
this.dgvMaster.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter; |
298 |
this.dgvMaster.EnableHeadersVisualStyles = false; |
|
297 | 299 |
this.dgvMaster.Location = new System.Drawing.Point(10, 103); |
298 | 300 |
this.dgvMaster.MultiSelect = false; |
299 | 301 |
this.dgvMaster.Name = "dgvMaster"; |
... | ... | |
473 | 475 |
private System.Windows.Forms.Button btnDataSelect; |
474 | 476 |
private System.Windows.Forms.Button btnEnd; |
475 | 477 |
private System.Windows.Forms.Label label1; |
476 |
private CustomControls.DataGridViewEX dgvMaster; |
|
478 |
private ProcessManagement.Forms.CustomControls.DataGridViewEX dgvMaster;
|
|
477 | 479 |
private System.Windows.Forms.Label lblProcessTitil; |
478 | 480 |
private System.Windows.Forms.Button btnDataUpDate; |
479 |
private System.Windows.Forms.GroupBox groupBox1;
|
|
481 |
private ProcessManagement.Forms.CustomControls.GroupBoxEx groupBox1;
|
|
480 | 482 |
private System.Windows.Forms.ComboBox cmbConstructionPerson; |
481 | 483 |
private System.Windows.Forms.ComboBox cmbDepartment; |
482 | 484 |
private System.Windows.Forms.Label label3; |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalList/FrmApprovalListAuxiliary.cs | ||
---|---|---|
36 | 36 |
#region ?v???p?e?B |
37 | 37 |
#endregion |
38 | 38 |
|
39 |
#region ?O???b?h?w?b?_?[?X?^?C???Z?b?g |
|
40 |
/// <summary> |
|
41 |
/// ?O???b?h?w?b?_?[?X?^?C???Z?b?g |
|
42 |
/// </summary> |
|
43 |
private void SetGridColumnHeaderStyle() |
|
44 |
{ |
|
45 |
try |
|
46 |
{ |
|
47 |
DataGridView dgv = dgvMaster; |
|
48 |
dgvMaster.Columns[(int)DispColumn.LimitDate].HeaderCell.Style.Font = new Font("?l?r ????", 10, FontStyle.Bold); |
|
49 |
} |
|
50 |
catch (Exception ex) |
|
51 |
{ |
|
52 |
logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message); |
|
53 |
} |
|
54 |
} |
|
55 |
#endregion |
|
56 |
|
|
39 | 57 |
#region ???N??????v???Z?X?I?????? |
40 | 58 |
/// <summary> |
41 | 59 |
/// ?H???????N??????v???Z?X?I?????? |
... | ... | |
148 | 166 |
// ?O???b?h??s??0???? |
149 | 167 |
dgvMaster.Rows.Clear(); |
150 | 168 |
|
169 |
// ?w?b?_?[?X?^?C???Z?b?g |
|
170 |
SetGridColumnHeaderStyle(); |
|
171 |
|
|
151 | 172 |
// ?f?[?^?\?? |
152 | 173 |
DataDisplay(); |
153 | 174 |
|
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstractionList/FrmConstructionList.cs | ||
---|---|---|
45 | 45 |
ConstructionPerson, |
46 | 46 |
ConstructionName, |
47 | 47 |
Status, |
48 |
PrintOutFlg,
|
|
48 |
OtherStatus,
|
|
49 | 49 |
ConstructionPeriod, |
50 | 50 |
ConstructionCode, |
51 | 51 |
OrderNo, |
... | ... | |
397 | 397 |
DataDisplay(); |
398 | 398 |
} |
399 | 399 |
#endregion |
400 |
|
|
401 |
#region ?w?b?_?[?N???b?N |
|
402 |
/// <summary> |
|
403 |
/// ?w?b?_?[?N???b?N |
|
404 |
/// </summary> |
|
405 |
/// <param name="sender"></param> |
|
406 |
/// <param name="e"></param> |
|
407 |
private void dgvMaster_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) |
|
408 |
{ |
|
409 |
GridHearderClick(); |
|
410 |
} |
|
411 |
#endregion |
|
400 | 412 |
} |
401 | 413 |
} |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstractionList/FrmConstructionList.designer.cs | ||
---|---|---|
28 | 28 |
/// </summary> |
29 | 29 |
private void InitializeComponent() |
30 | 30 |
{ |
31 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle27 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
32 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle28 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
33 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle39 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
34 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle29 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
35 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle30 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
36 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle31 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
37 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle32 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
38 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle33 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
39 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle34 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
40 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle35 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
41 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle36 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
42 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle37 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
43 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle38 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
31 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
32 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle2 = new System.Windows.Forms.DataGridViewCellStyle(); |
|
33 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle13 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
34 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
35 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
36 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle5 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
37 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle6 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
38 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle7 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
39 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle8 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
40 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle9 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
41 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle10 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
42 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle11 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
43 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle12 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
44 | 44 |
this.btnDataEntry = new System.Windows.Forms.Button(); |
45 | 45 |
this.btnEnd = new System.Windows.Forms.Button(); |
46 | 46 |
this.label1 = new System.Windows.Forms.Label(); |
47 |
this.groupBox1 = new System.Windows.Forms.GroupBox(); |
|
47 |
this.lblProcessTitil = new System.Windows.Forms.Label(); |
|
48 |
this.btnDataUpDate = new System.Windows.Forms.Button(); |
|
49 |
this.btnDataCopy = new System.Windows.Forms.Button(); |
|
50 |
this.ProgressBar = new System.Windows.Forms.ProgressBar(); |
|
51 |
this.groupBox1 = new ProcessManagement.Forms.CustomControls.GroupBoxEx(); |
|
48 | 52 |
this.label3 = new System.Windows.Forms.Label(); |
49 | 53 |
this.radioButton2 = new System.Windows.Forms.RadioButton(); |
50 | 54 |
this.radioButton1 = new System.Windows.Forms.RadioButton(); |
... | ... | |
55 | 59 |
this.cmbConstructionPerson = new System.Windows.Forms.ComboBox(); |
56 | 60 |
this.cmbDepartment = new System.Windows.Forms.ComboBox(); |
57 | 61 |
this.label2 = new System.Windows.Forms.Label(); |
58 |
this.lblProcessTitil = new System.Windows.Forms.Label(); |
|
59 |
this.btnDataUpDate = new System.Windows.Forms.Button(); |
|
60 |
this.btnDataCopy = new System.Windows.Forms.Button(); |
|
61 |
this.ProgressBar = new System.Windows.Forms.ProgressBar(); |
|
62 | 62 |
this.dgvMaster = new ProcessManagement.Forms.CustomControls.DataGridViewEX(); |
63 | 63 |
this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
64 | 64 |
this.Column9 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
... | ... | |
116 | 116 |
this.label1.Text = "工 事 情 報 一 覧"; |
117 | 117 |
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; |
118 | 118 |
// |
119 |
// lblProcessTitil |
|
120 |
// |
|
121 |
this.lblProcessTitil.BackColor = System.Drawing.Color.White; |
|
122 |
this.lblProcessTitil.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; |
|
123 |
this.lblProcessTitil.Location = new System.Drawing.Point(10, 10); |
|
124 |
this.lblProcessTitil.Name = "lblProcessTitil"; |
|
125 |
this.lblProcessTitil.Size = new System.Drawing.Size(200, 20); |
|
126 |
this.lblProcessTitil.TabIndex = 9; |
|
127 |
this.lblProcessTitil.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; |
|
128 |
// |
|
129 |
// btnDataUpDate |
|
130 |
// |
|
131 |
this.btnDataUpDate.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); |
|
132 |
this.btnDataUpDate.BackColor = System.Drawing.Color.Aquamarine; |
|
133 |
this.btnDataUpDate.Font = new System.Drawing.Font("MS 明朝", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128))); |
|
134 |
this.btnDataUpDate.ForeColor = System.Drawing.Color.Black; |
|
135 |
this.btnDataUpDate.Location = new System.Drawing.Point(1150, 4); |
|
136 |
this.btnDataUpDate.Name = "btnDataUpDate"; |
|
137 |
this.btnDataUpDate.Size = new System.Drawing.Size(120, 30); |
|
138 |
this.btnDataUpDate.TabIndex = 7; |
|
139 |
this.btnDataUpDate.Text = "最新状態に更新"; |
|
140 |
this.btnDataUpDate.UseVisualStyleBackColor = false; |
|
141 |
this.btnDataUpDate.Click += new System.EventHandler(this.btnDataUpDate_Click); |
|
142 |
// |
|
143 |
// btnDataCopy |
|
144 |
// |
|
145 |
this.btnDataCopy.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); |
|
146 |
this.btnDataCopy.BackColor = System.Drawing.Color.DarkOrange; |
|
147 |
this.btnDataCopy.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128))); |
|
148 |
this.btnDataCopy.ForeColor = System.Drawing.Color.Black; |
|
149 |
this.btnDataCopy.Location = new System.Drawing.Point(865, 619); |
|
150 |
this.btnDataCopy.Name = "btnDataCopy"; |
|
151 |
this.btnDataCopy.Size = new System.Drawing.Size(260, 30); |
|
152 |
this.btnDataCopy.TabIndex = 30; |
|
153 |
this.btnDataCopy.Text = "既存工事からコピー登録"; |
|
154 |
this.btnDataCopy.UseVisualStyleBackColor = false; |
|
155 |
this.btnDataCopy.Click += new System.EventHandler(this.btnDataCopy_Click); |
|
156 |
// |
|
157 |
// ProgressBar |
|
158 |
// |
|
159 |
this.ProgressBar.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); |
|
160 |
this.ProgressBar.Location = new System.Drawing.Point(10, 619); |
|
161 |
this.ProgressBar.Name = "ProgressBar"; |
|
162 |
this.ProgressBar.Size = new System.Drawing.Size(388, 30); |
|
163 |
this.ProgressBar.TabIndex = 31; |
|
164 |
this.ProgressBar.Visible = false; |
|
165 |
// |
|
119 | 166 |
// groupBox1 |
120 | 167 |
// |
121 | 168 |
this.groupBox1.Anchor = System.Windows.Forms.AnchorStyles.Top; |
122 | 169 |
this.groupBox1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(128)))), ((int)(((byte)(255)))), ((int)(((byte)(255))))); |
170 |
this.groupBox1.BorderColor = System.Drawing.Color.White; |
|
123 | 171 |
this.groupBox1.Controls.Add(this.label3); |
124 | 172 |
this.groupBox1.Controls.Add(this.radioButton2); |
125 | 173 |
this.groupBox1.Controls.Add(this.radioButton1); |
... | ... | |
262 | 310 |
this.label2.Text = "部 署"; |
263 | 311 |
this.label2.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; |
264 | 312 |
// |
265 |
// lblProcessTitil |
|
266 |
// |
|
267 |
this.lblProcessTitil.BackColor = System.Drawing.Color.White; |
|
268 |
this.lblProcessTitil.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; |
|
269 |
this.lblProcessTitil.Location = new System.Drawing.Point(10, 10); |
|
270 |
this.lblProcessTitil.Name = "lblProcessTitil"; |
|
271 |
this.lblProcessTitil.Size = new System.Drawing.Size(200, 20); |
|
272 |
this.lblProcessTitil.TabIndex = 9; |
|
273 |
this.lblProcessTitil.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; |
|
274 |
// |
|
275 |
// btnDataUpDate |
|
276 |
// |
|
277 |
this.btnDataUpDate.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); |
|
278 |
this.btnDataUpDate.BackColor = System.Drawing.Color.Aquamarine; |
|
279 |
this.btnDataUpDate.Font = new System.Drawing.Font("MS 明朝", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128))); |
|
280 |
this.btnDataUpDate.ForeColor = System.Drawing.Color.Black; |
|
281 |
this.btnDataUpDate.Location = new System.Drawing.Point(1150, 4); |
|
282 |
this.btnDataUpDate.Name = "btnDataUpDate"; |
|
283 |
this.btnDataUpDate.Size = new System.Drawing.Size(120, 30); |
|
284 |
this.btnDataUpDate.TabIndex = 7; |
|
285 |
this.btnDataUpDate.Text = "最新状態に更新"; |
|
286 |
this.btnDataUpDate.UseVisualStyleBackColor = false; |
|
287 |
this.btnDataUpDate.Click += new System.EventHandler(this.btnDataUpDate_Click); |
|
288 |
// |
|
289 |
// btnDataCopy |
|
290 |
// |
|
291 |
this.btnDataCopy.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); |
|
292 |
this.btnDataCopy.BackColor = System.Drawing.Color.DarkOrange; |
|
293 |
this.btnDataCopy.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128))); |
|
294 |
this.btnDataCopy.ForeColor = System.Drawing.Color.Black; |
|
295 |
this.btnDataCopy.Location = new System.Drawing.Point(865, 619); |
|
296 |
this.btnDataCopy.Name = "btnDataCopy"; |
|
297 |
this.btnDataCopy.Size = new System.Drawing.Size(260, 30); |
|
298 |
this.btnDataCopy.TabIndex = 30; |
|
299 |
this.btnDataCopy.Text = "既存工事からコピー登録"; |
|
300 |
this.btnDataCopy.UseVisualStyleBackColor = false; |
|
301 |
this.btnDataCopy.Click += new System.EventHandler(this.btnDataCopy_Click); |
|
302 |
// |
|
303 |
// ProgressBar |
|
304 |
// |
|
305 |
this.ProgressBar.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); |
|
306 |
this.ProgressBar.Location = new System.Drawing.Point(10, 619); |
|
307 |
this.ProgressBar.Name = "ProgressBar"; |
|
308 |
this.ProgressBar.Size = new System.Drawing.Size(388, 30); |
|
309 |
this.ProgressBar.TabIndex = 31; |
|
310 |
this.ProgressBar.Visible = false; |
|
311 |
// |
|
312 | 313 |
// dgvMaster |
313 | 314 |
// |
314 | 315 |
this.dgvMaster.AllowUserToAddRows = false; |
315 | 316 |
this.dgvMaster.AllowUserToDeleteRows = false; |
316 | 317 |
this.dgvMaster.AllowUserToResizeColumns = false; |
317 | 318 |
this.dgvMaster.AllowUserToResizeRows = false; |
318 |
dataGridViewCellStyle27.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
|
|
319 |
this.dgvMaster.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle27;
|
|
319 |
dataGridViewCellStyle1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
|
|
320 |
this.dgvMaster.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1;
|
|
320 | 321 |
this.dgvMaster.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) |
321 | 322 |
| System.Windows.Forms.AnchorStyles.Left) |
322 | 323 |
| System.Windows.Forms.AnchorStyles.Right))); |
323 |
this.dgvMaster.BackgroundColor = System.Drawing.Color.FromArgb(((int)(((byte)(224)))), ((int)(((byte)(224)))), ((int)(((byte)(224)))));
|
|
324 |
this.dgvMaster.BackgroundColor = System.Drawing.Color.White;
|
|
324 | 325 |
this.dgvMaster.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; |
325 |
dataGridViewCellStyle28.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
326 |
dataGridViewCellStyle28.BackColor = System.Drawing.SystemColors.Control;
|
|
327 |
dataGridViewCellStyle28.Font = new System.Drawing.Font("MS 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
|
|
328 |
dataGridViewCellStyle28.ForeColor = System.Drawing.SystemColors.WindowText;
|
|
329 |
dataGridViewCellStyle28.SelectionBackColor = System.Drawing.SystemColors.Highlight;
|
|
330 |
dataGridViewCellStyle28.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
|
|
331 |
dataGridViewCellStyle28.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
|
|
332 |
this.dgvMaster.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle28;
|
|
326 |
dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; |
|
327 |
dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Control; |
|
328 |
dataGridViewCellStyle2.Font = new System.Drawing.Font("MS 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128))); |
|
329 |
dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.WindowText; |
|
330 |
dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight; |
|
331 |
dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText; |
|
332 |
dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.True; |
|
333 |
this.dgvMaster.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2; |
|
333 | 334 |
this.dgvMaster.ColumnHeadersHeight = 24; |
334 | 335 |
this.dgvMaster.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing; |
335 | 336 |
this.dgvMaster.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { |
... | ... | |
344 | 345 |
this.Column3, |
345 | 346 |
this.Column2, |
346 | 347 |
this.Column11}); |
347 |
dataGridViewCellStyle39.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
|
|
348 |
dataGridViewCellStyle39.BackColor = System.Drawing.SystemColors.Window;
|
|
349 |
dataGridViewCellStyle39.Font = new System.Drawing.Font("MS 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
|
|
350 |
dataGridViewCellStyle39.ForeColor = System.Drawing.SystemColors.ControlText;
|
|
351 |
dataGridViewCellStyle39.SelectionBackColor = System.Drawing.Color.LightSeaGreen;
|
|
352 |
dataGridViewCellStyle39.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
|
|
353 |
dataGridViewCellStyle39.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
|
|
354 |
this.dgvMaster.DefaultCellStyle = dataGridViewCellStyle39;
|
|
348 |
dataGridViewCellStyle13.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
|
|
349 |
dataGridViewCellStyle13.BackColor = System.Drawing.SystemColors.Window;
|
|
350 |
dataGridViewCellStyle13.Font = new System.Drawing.Font("MS 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
|
|
351 |
dataGridViewCellStyle13.ForeColor = System.Drawing.SystemColors.ControlText;
|
|
352 |
dataGridViewCellStyle13.SelectionBackColor = System.Drawing.Color.LightSeaGreen;
|
|
353 |
dataGridViewCellStyle13.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
|
|
354 |
dataGridViewCellStyle13.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
|
|
355 |
this.dgvMaster.DefaultCellStyle = dataGridViewCellStyle13;
|
|
355 | 356 |
this.dgvMaster.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter; |
357 |
this.dgvMaster.EnableHeadersVisualStyles = false; |
|
356 | 358 |
this.dgvMaster.Location = new System.Drawing.Point(10, 103); |
357 | 359 |
this.dgvMaster.MultiSelect = false; |
358 | 360 |
this.dgvMaster.Name = "dgvMaster"; |
... | ... | |
364 | 366 |
this.dgvMaster.Size = new System.Drawing.Size(1260, 508); |
365 | 367 |
this.dgvMaster.TabIndex = 5; |
366 | 368 |
this.dgvMaster.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgvMaster_CellDoubleClick); |
369 |
this.dgvMaster.ColumnHeaderMouseClick += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.dgvMaster_ColumnHeaderMouseClick); |
|
367 | 370 |
// |
368 | 371 |
// Column1 |
369 | 372 |
// |
370 |
dataGridViewCellStyle29.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
371 |
this.Column1.DefaultCellStyle = dataGridViewCellStyle29;
|
|
373 |
dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
374 |
this.Column1.DefaultCellStyle = dataGridViewCellStyle3;
|
|
372 | 375 |
this.Column1.Frozen = true; |
373 | 376 |
this.Column1.HeaderText = "№"; |
374 | 377 |
this.Column1.Name = "Column1"; |
... | ... | |
379 | 382 |
// |
380 | 383 |
// Column9 |
381 | 384 |
// |
382 |
dataGridViewCellStyle30.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
383 |
this.Column9.DefaultCellStyle = dataGridViewCellStyle30;
|
|
385 |
dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
386 |
this.Column9.DefaultCellStyle = dataGridViewCellStyle4;
|
|
384 | 387 |
this.Column9.Frozen = true; |
385 | 388 |
this.Column9.HeaderText = "営業部署"; |
386 | 389 |
this.Column9.Name = "Column9"; |
... | ... | |
390 | 393 |
// |
391 | 394 |
// Column5 |
392 | 395 |
// |
393 |
dataGridViewCellStyle31.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
394 |
this.Column5.DefaultCellStyle = dataGridViewCellStyle31;
|
|
396 |
dataGridViewCellStyle5.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
397 |
this.Column5.DefaultCellStyle = dataGridViewCellStyle5;
|
|
395 | 398 |
this.Column5.Frozen = true; |
396 | 399 |
this.Column5.HeaderText = "営業担当者"; |
397 | 400 |
this.Column5.Name = "Column5"; |
... | ... | |
402 | 405 |
// |
403 | 406 |
// Column10 |
404 | 407 |
// |
405 |
dataGridViewCellStyle32.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
406 |
this.Column10.DefaultCellStyle = dataGridViewCellStyle32;
|
|
408 |
dataGridViewCellStyle6.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
409 |
this.Column10.DefaultCellStyle = dataGridViewCellStyle6;
|
|
407 | 410 |
this.Column10.Frozen = true; |
408 | 411 |
this.Column10.HeaderText = "工事部署"; |
409 | 412 |
this.Column10.Name = "Column10"; |
... | ... | |
413 | 416 |
// |
414 | 417 |
// Column6 |
415 | 418 |
// |
416 |
dataGridViewCellStyle33.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
417 |
this.Column6.DefaultCellStyle = dataGridViewCellStyle33;
|
|
419 |
dataGridViewCellStyle7.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
420 |
this.Column6.DefaultCellStyle = dataGridViewCellStyle7;
|
|
418 | 421 |
this.Column6.Frozen = true; |
419 | 422 |
this.Column6.HeaderText = "工事担当者"; |
420 | 423 |
this.Column6.Name = "Column6"; |
... | ... | |
425 | 428 |
// |
426 | 429 |
// Column4 |
427 | 430 |
// |
428 |
dataGridViewCellStyle34.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
|
|
429 |
this.Column4.DefaultCellStyle = dataGridViewCellStyle34;
|
|
431 |
dataGridViewCellStyle8.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
|
|
432 |
this.Column4.DefaultCellStyle = dataGridViewCellStyle8;
|
|
430 | 433 |
this.Column4.Frozen = true; |
431 | 434 |
this.Column4.HeaderText = "工 事 名 称"; |
432 | 435 |
this.Column4.Name = "Column4"; |
433 | 436 |
this.Column4.ReadOnly = true; |
434 | 437 |
this.Column4.Resizable = System.Windows.Forms.DataGridViewTriState.False; |
435 | 438 |
this.Column4.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
436 |
this.Column4.Width = 500;
|
|
439 |
this.Column4.Width = 530;
|
|
437 | 440 |
// |
438 | 441 |
// Column7 |
439 | 442 |
// |
440 |
dataGridViewCellStyle35.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
441 |
this.Column7.DefaultCellStyle = dataGridViewCellStyle35;
|
|
443 |
dataGridViewCellStyle9.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
444 |
this.Column7.DefaultCellStyle = dataGridViewCellStyle9;
|
|
442 | 445 |
this.Column7.Frozen = true; |
443 | 446 |
this.Column7.HeaderText = "施工状態"; |
444 | 447 |
this.Column7.Name = "Column7"; |
445 | 448 |
this.Column7.ReadOnly = true; |
446 | 449 |
this.Column7.Resizable = System.Windows.Forms.DataGridViewTriState.False; |
447 | 450 |
this.Column7.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
448 |
this.Column7.Width = 150;
|
|
451 |
this.Column7.Width = 120;
|
|
449 | 452 |
// |
450 | 453 |
// Column8 |
451 | 454 |
// |
452 |
dataGridViewCellStyle36.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
453 |
this.Column8.DefaultCellStyle = dataGridViewCellStyle36;
|
|
455 |
dataGridViewCellStyle10.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
456 |
this.Column8.DefaultCellStyle = dataGridViewCellStyle10;
|
|
454 | 457 |
this.Column8.Frozen = true; |
455 | 458 |
this.Column8.HeaderText = "印刷"; |
456 | 459 |
this.Column8.Name = "Column8"; |
457 | 460 |
this.Column8.ReadOnly = true; |
458 | 461 |
this.Column8.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
459 | 462 |
this.Column8.Visible = false; |
460 |
this.Column8.Width = 30;
|
|
463 |
this.Column8.Width = 60;
|
|
461 | 464 |
// |
462 | 465 |
// Column3 |
463 | 466 |
// |
464 |
dataGridViewCellStyle37.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
465 |
this.Column3.DefaultCellStyle = dataGridViewCellStyle37;
|
|
467 |
dataGridViewCellStyle11.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
468 |
this.Column3.DefaultCellStyle = dataGridViewCellStyle11;
|
|
466 | 469 |
this.Column3.Frozen = true; |
467 | 470 |
this.Column3.HeaderText = "営業期"; |
468 | 471 |
this.Column3.Name = "Column3"; |
... | ... | |
474 | 477 |
// |
475 | 478 |
// Column2 |
476 | 479 |
// |
477 |
dataGridViewCellStyle38.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
478 |
this.Column2.DefaultCellStyle = dataGridViewCellStyle38;
|
|
480 |
dataGridViewCellStyle12.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
481 |
this.Column2.DefaultCellStyle = dataGridViewCellStyle12;
|
|
479 | 482 |
this.Column2.Frozen = true; |
480 | 483 |
this.Column2.HeaderText = "工事コード"; |
481 | 484 |
this.Column2.Name = "Column2"; |
... | ... | |
536 | 539 |
private System.Windows.Forms.Button btnDataEntry; |
537 | 540 |
private System.Windows.Forms.Button btnEnd; |
538 | 541 |
private System.Windows.Forms.Label label1; |
539 |
private System.Windows.Forms.GroupBox groupBox1;
|
|
542 |
private ProcessManagement.Forms.CustomControls.GroupBoxEx groupBox1;
|
|
540 | 543 |
private System.Windows.Forms.Label label2; |
541 | 544 |
private System.Windows.Forms.ComboBox cmbDepartment; |
542 |
private CustomControls.DataGridViewEX dgvMaster; |
|
545 |
private ProcessManagement.Forms.CustomControls.DataGridViewEX dgvMaster;
|
|
543 | 546 |
private System.Windows.Forms.Label lblProcessTitil; |
544 | 547 |
private System.Windows.Forms.ComboBox cmbConstructionPerson; |
545 | 548 |
private System.Windows.Forms.Label label3; |
... | ... | |
551 | 554 |
private System.Windows.Forms.Label label7; |
552 | 555 |
private System.Windows.Forms.RadioButton radioButton2; |
553 | 556 |
private System.Windows.Forms.RadioButton radioButton1; |
557 |
private System.Windows.Forms.ProgressBar ProgressBar; |
|
554 | 558 |
private System.Windows.Forms.DataGridViewTextBoxColumn Column1; |
555 | 559 |
private System.Windows.Forms.DataGridViewTextBoxColumn Column9; |
556 | 560 |
private System.Windows.Forms.DataGridViewTextBoxColumn Column5; |
... | ... | |
562 | 566 |
private System.Windows.Forms.DataGridViewTextBoxColumn Column3; |
563 | 567 |
private System.Windows.Forms.DataGridViewTextBoxColumn Column2; |
564 | 568 |
private System.Windows.Forms.DataGridViewTextBoxColumn Column11; |
565 |
private System.Windows.Forms.ProgressBar ProgressBar; |
|
566 | 569 |
} |
567 | 570 |
} |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstractionList/FrmConstructionListAuxiliary.cs | ||
---|---|---|
37 | 37 |
/// </summary> |
38 | 38 |
private static string[] s_SQLPart1 = new string[] { "SELECT A.CONSTRUCTIONCODE, A.CONSTRUCTIONPERIOD, B.DETAILSTRING, A.CONSTRUCTIONSTATUSFLG,", |
39 | 39 |
" C.PERSONCODE, C.PERSONNAME, C.DEPARTMENTCODE, C.DEPARTMENTNAME, C.MANDISPORDER, C.DEPDISPORDER,", |
40 |
" D.PERSONCODE, D.PERSONNAME, D.DEPARTMENTCODE, D.DEPARTMENTNAME, D.MANDISPORDER, D.DEPDISPORDER", |
|
41 |
" FROM CONSTRUCTIONBASEINFO A" }; |
|
40 |
" D.PERSONCODE, D.PERSONNAME, D.DEPARTMENTCODE, D.DEPARTMENTNAME, D.MANDISPORDER, D.DEPDISPORDER" }; |
|
41 |
private static string[] s_SQLPart1_1 = new string[] { " FROM CONSTRUCTIONBASEINFO A", |
|
42 |
" LEFT JOIN CONSTRUCTIONBASEINFODETAIL B", |
|
43 |
" ON A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE", |
|
44 |
string.Format(" AND B.DETAILNO = {0}", (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName)}; |
|
42 | 45 |
|
43 | 46 |
private static string[] s_SQLPart2 = new string[] { " LEFT JOIN (SELECT CA.CONSTRUCTIONCODE, CA.SALESPERSONCODE PERSONCODE, CB.PERSONNAME PERSONNAME,", |
44 | 47 |
" CB.DEPARTMENTCODE DEPARTMENTCODE, CC.DEPARTMENTSTRING DEPARTMENTNAME,", |
... | ... | |
54 | 57 |
" FROM CONSTRUCTIONBASEINFO DA", |
55 | 58 |
" LEFT JOIN PERSONINCHARGEMASTER DB ON DA.CONSTRUCTIONPERSONCODE = DB.PERSONCODE", |
56 | 59 |
" LEFT JOIN DEPARTMENTMASTER DC ON DB.DEPARTMENTCODE = DC.DEPARTMENTCODE", |
57 |
" WHERE DA.CONSTRUCTIONPERIOD = {0}) D ON A.CONSTRUCTIONCODE = D.CONSTRUCTIONCODE", |
|
58 |
", CONSTRUCTIONBASEINFODETAIL B" }; |
|
60 |
" WHERE DA.CONSTRUCTIONPERIOD = {0}) D ON A.CONSTRUCTIONCODE = D.CONSTRUCTIONCODE" }; |
|
59 | 61 |
|
60 |
private static string[] s_SQLPart4 = new string[] { " WHERE A.CONSTRUCTIONPERIOD = {0}", |
|
61 |
" AND A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE", |
|
62 |
" AND B.DETAILNO = {1}" }; |
|
62 |
private static string[] s_SQLPart4 = new string[] { " WHERE A.CONSTRUCTIONPERIOD = {0}" }; |
|
63 | 63 |
|
64 | 64 |
private static string[] s_SQLPart4Tying = new string[] { " WHERE A.CONSTRUCTIONPERIOD = {0}", |
65 |
string.Format(" AND A.TYINGFLG != {0}", (int)ConstructionBaseInfo.TyingFlgDef.Tying), |
|
66 |
" AND A.CONSTRUCTIONCODE = B.CONSTRUCTIONCODE", |
|
67 |
" AND B.DETAILNO = {1}" }; |
|
65 |
string.Format(" AND A.TYINGFLG != {0}", (int)ConstructionBaseInfo.TyingFlgDef.Tying) }; |
|
68 | 66 |
|
69 | 67 |
private static string[] s_SQLPart5 = new string[] { " ORDER BY A.CONSTRUCTIONSTATUSFLG ASC, C.DEPDISPORDER ASC, C.MANDISPORDER ASC,", |
70 | 68 |
" D.DEPDISPORDER ASC, D.MANDISPORDER ASC, A.CONSTRUCTIONCODE DESC" }; |
... | ... | |
92 | 90 |
CONSTDEPNAME, |
93 | 91 |
CONSTMANDISPORDER, |
94 | 92 |
CONSTDEPDISPORDER, |
95 |
PRINTOUTDATE,
|
|
93 |
AppStatus,
|
|
96 | 94 |
ORDERNO, |
97 | 95 |
} |
98 | 96 |
#endregion |
... | ... | |
310 | 308 |
{ |
311 | 309 |
StringBuilder wrkFormat = new StringBuilder(); |
312 | 310 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
311 |
wrkFormat.Append(", 0, 0"); // ???t?B?[???h??????????? |
|
312 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
313 |
|
|
313 | 314 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
314 | 315 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
315 | 316 |
for (int i = 0; i < s_SQLPart4Tying.Length; i++) wrkFormat.Append(s_SQLPart4Tying[i]); |
316 | 317 |
|
317 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
|
|
318 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
318 | 319 |
|
319 | 320 |
// ???????I??????????? |
320 | 321 |
strSQL.Append(GetDepartmentString()); |
... | ... | |
355 | 356 |
|
356 | 357 |
StringBuilder wrkFormat = new StringBuilder(); |
357 | 358 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
359 |
wrkFormat.Append(", -1, 0"); // ???t?B?[???h??????????? |
|
360 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
361 |
|
|
358 | 362 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
359 | 363 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
360 | 364 |
for (int i = 0; i < s_SQLPart4.Length; i++) wrkFormat.Append(s_SQLPart4[i]); |
361 | 365 |
|
362 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
|
|
366 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
363 | 367 |
strSQL.AppendFormat(" AND A.ConstructionStatusFlg < {0}", ProgressComplete); |
364 | 368 |
|
369 |
strSQL.Append(" AND NOT EXISTS (SELECT * FROM ESTIMATEDATA C WHERE C.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)"); |
|
370 |
|
|
365 | 371 |
// ???????I??????????? |
366 | 372 |
strSQL.Append(GetDepartmentString()); |
367 | 373 |
|
... | ... | |
372 | 378 |
strSQL.Append(wrkBuff.ToString()); |
373 | 379 |
|
374 | 380 |
strSQL.Append(" UNION "); |
375 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName); |
|
381 |
wrkFormat.Clear(); |
|
382 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
|
383 |
wrkFormat.Append(", ifnull(App.ApprovalStatus, -1), ifnull(App.OrderNo, 0)"); |
|
384 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
385 |
|
|
386 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
|
387 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
|
388 |
|
|
389 |
wrkFormat.Append(" LEFT JOIN processapproval AS App ON App.ConstructionCode = A.ConstructionCode"); |
|
390 |
wrkFormat.AppendFormat(" AND App.ApprovalCode = {0}", (int)ClsExcute.ApprovalListNo.EstimateApproval); |
|
391 |
wrkFormat.AppendFormat(" And App.OrderNo = {0}", CommonDefine.s_Default_OrderNo); |
|
392 |
wrkFormat.Append(" And App.SeqNo = 1"); |
|
393 |
|
|
394 |
for (int i = 0; i < s_SQLPart4.Length; i++) wrkFormat.Append(s_SQLPart4[i]); |
|
395 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
396 |
|
|
376 | 397 |
strSQL.Append(" AND EXISTS (SELECT * FROM ESTIMATEDATA C WHERE C.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)"); |
377 | 398 |
|
378 | 399 |
// ???????I??????????? |
... | ... | |
414 | 435 |
|
415 | 436 |
StringBuilder wrkFormat = new StringBuilder(); |
416 | 437 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
438 |
wrkFormat.Append(", DATE_FORMAT(A.EstimatesSubmittedDate, '%Y/%m/%d'), 0"); // ???t?B?[???h??????????? |
|
439 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
440 |
|
|
417 | 441 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
418 | 442 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
419 | 443 |
wrkFormat.Append(", PROCESSAPPROVAL A1"); |
420 | 444 |
for (int i = 0; i < s_SQLPart4.Length; i++) wrkFormat.Append(s_SQLPart4[i]); |
421 | 445 |
|
422 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
|
|
446 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
423 | 447 |
strSQL.AppendFormat(" AND (A.CONSTRUCTIONCODE = A1.CONSTRUCTIONCODE And A1.ApprovalCode = {0} And A1.SeqNo = 1", ApprovalCode); |
424 | 448 |
strSQL.AppendFormat(" And A1.ApprovalStatus = {0})", (int)CommonDefine.ApprovalStatus.Approval); |
425 | 449 |
|
... | ... | |
462 | 486 |
|
463 | 487 |
StringBuilder wrkFormat = new StringBuilder(); |
464 | 488 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
489 |
wrkFormat.Append(", -1, 0"); // ???t?B?[???h??????????? |
|
490 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
491 |
|
|
465 | 492 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
466 | 493 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
467 | 494 |
for (int i = 0; i < s_SQLPart4.Length; i++) wrkFormat.Append(s_SQLPart4[i]); |
468 | 495 |
|
469 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
|
|
496 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
470 | 497 |
strSQL.Append(" AND EXISTS (SELECT * FROM ESTIMATEDATA C WHERE C.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)"); |
471 | 498 |
strSQL.AppendFormat(" AND A.ConstructionStatusFlg < {0}", ProgressComplete); |
499 |
strSQL.Append(" AND NOT EXISTS (SELECT * FROM ESTIMATEBUDGET A1 WHERE A1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)"); |
|
472 | 500 |
|
473 | 501 |
// ???????I??????????? |
474 | 502 |
strSQL.Append(GetDepartmentString()); |
... | ... | |
482 | 510 |
strSQL.AppendFormat(" And A.ConstructionStatusFlg <= {0}", ProgressComplete); |
483 | 511 |
|
484 | 512 |
strSQL.Append(" UNION "); |
485 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName); |
|
513 |
wrkFormat.Clear(); |
|
514 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
|
515 |
wrkFormat.Append(", ifnull(App.ApprovalStatus, -1), ifnull(App.OrderNo, 0)"); |
|
516 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
517 |
|
|
518 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
|
519 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
|
520 |
|
|
521 |
wrkFormat.Append(" LEFT JOIN processapproval AS App ON App.ConstructionCode = A.ConstructionCode"); |
|
522 |
wrkFormat.AppendFormat(" AND App.ApprovalCode = {0}", (int)ClsExcute.ApprovalListNo.EstimateBudgetApproval); |
|
523 |
wrkFormat.AppendFormat(" And App.OrderNo = {0}", CommonDefine.s_Default_OrderNo); |
|
524 |
wrkFormat.Append(" And App.SeqNo = 1"); |
|
525 |
|
|
526 |
for (int i = 0; i < s_SQLPart4.Length; i++) wrkFormat.Append(s_SQLPart4[i]); |
|
527 |
|
|
528 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
486 | 529 |
strSQL.Append(" AND EXISTS (SELECT * FROM ESTIMATEBUDGET A1 WHERE A1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)"); |
487 | 530 |
|
488 | 531 |
// ???????I??????????? |
... | ... | |
530 | 573 |
|
531 | 574 |
StringBuilder wrkFormat = new StringBuilder(); |
532 | 575 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
576 |
wrkFormat.Append(", -1, 0"); // ???t?B?[???h??????????? |
|
577 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
578 |
|
|
533 | 579 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
534 | 580 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
535 | 581 |
wrkFormat.Append(", PROCESSAPPROVAL A1"); |
536 | 582 |
for (int i = 0; i < s_SQLPart4.Length; i++) wrkFormat.Append(s_SQLPart4[i]); |
537 | 583 |
wrkFormat.Append(" AND A.CONSTRUCTIONPERSONCODE != 0"); |
584 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
538 | 585 |
|
539 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName); |
|
540 | 586 |
strSQL.Append(" AND EXISTS (SELECT * FROM ESTIMATEDATA B1 WHERE B1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)"); |
541 | 587 |
strSQL.AppendFormat(" And {0} <= A.ConstructionStatusFlg", ProgressStart); |
542 | 588 |
strSQL.AppendFormat(" And A.ConstructionStatusFlg < {0}", ProgressComplete); |
543 | 589 |
strSQL.Append(" And A.ConstructionPersonCode != 0"); |
544 | 590 |
strSQL.AppendFormat(" AND (A.CONSTRUCTIONCODE = A1.CONSTRUCTIONCODE AND A1.APPROVALCODE = {0}", (int)ClsExcute.ApprovalListNo.EstimateApproval); |
545 | 591 |
strSQL.AppendFormat(" AND SEQNO = 1 AND ApprovalStatus = {0})", (int)CommonDefine.ApprovalStatus.Approval); |
592 |
strSQL.Append(" AND NOT EXISTS (SELECT * FROM CONSTRUCTIONBUDGET C WHERE C.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)"); |
|
546 | 593 |
|
547 | 594 |
// ???????I??????????? |
548 | 595 |
strSQL.Append(GetDepartmentString()); |
... | ... | |
554 | 601 |
strSQL.Append(wrkBuff.ToString()); |
555 | 602 |
|
556 | 603 |
strSQL.Append(" UNION "); |
557 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName); |
|
558 |
strSQL.AppendFormat(" AND (A.CONSTRUCTIONCODE = A1.CONSTRUCTIONCODE AND A1.APPROVALCODE = {0}", (int)ClsExcute.ApprovalListNo.EstimateApproval); |
|
559 |
strSQL.AppendFormat(" AND SEQNO = 1 AND ApprovalStatus = {0})", (int)CommonDefine.ApprovalStatus.Approval); |
|
604 |
wrkFormat.Clear(); |
|
605 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
|
606 |
wrkFormat.Append(", ifnull(App.ApprovalStatus, -1), ifnull(App.OrderNo, 0)"); |
|
607 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
608 |
|
|
609 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
|
610 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
|
611 |
|
|
612 |
wrkFormat.Append(" LEFT JOIN processapproval AS App ON App.ConstructionCode = A.ConstructionCode"); |
|
613 |
wrkFormat.AppendFormat(" AND App.ApprovalCode = {0}", (int)ClsExcute.ApprovalListNo.ConstructionBudgetApproval); |
|
614 |
wrkFormat.AppendFormat(" And App.OrderNo = {0}", CommonDefine.s_Default_OrderNo); |
|
615 |
wrkFormat.Append(" And App.SeqNo = 1"); |
|
616 |
|
|
617 |
wrkFormat.Append(", constructionbudget E"); |
|
618 |
for (int i = 0; i < s_SQLPart4.Length; i++) wrkFormat.Append(s_SQLPart4[i]); |
|
619 |
wrkFormat.Append(" AND A.CONSTRUCTIONPERSONCODE != 0"); |
|
620 |
|
|
621 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
560 | 622 |
strSQL.Append(" AND EXISTS (SELECT * FROM CONSTRUCTIONBUDGET C WHERE C.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)"); |
561 | 623 |
strSQL.AppendFormat(" And A.ConstructionStatusFlg != {0}", NoneOrder); |
624 |
wrkFormat.Append(" And E.ConstructionCode = A.ConstructionCode"); |
|
562 | 625 |
|
563 | 626 |
// ???????I??????????? |
564 | 627 |
strSQL.Append(GetDepartmentString()); |
... | ... | |
604 | 667 |
CreateSecuritySQL(ref wrkBuff); |
605 | 668 |
|
606 | 669 |
StringBuilder wrkFormat = new StringBuilder(); |
607 |
for (int i = 0; i < (s_SQLPart1.Length - 1); i++) wrkFormat.Append(s_SQLPart1[i]); |
|
608 |
wrkFormat.Append(", ''"); |
|
609 |
for (int i = (s_SQLPart1.Length - 1); i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
|
670 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
|
671 |
wrkFormat.Append(", -1, 0"); // ???t?B?[???h??????????? |
|
672 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
673 |
|
|
610 | 674 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
611 | 675 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
676 |
|
|
612 | 677 |
wrkFormat.Append(", PROCESSAPPROVAL A1"); |
613 | 678 |
for (int i = 0; i < s_SQLPart4.Length; i++) wrkFormat.Append(s_SQLPart4[i]); |
614 | 679 |
|
615 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
|
|
680 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
616 | 681 |
strSQL.Append(" AND NOT EXISTS (SELECT * FROM PURCHASEORDER B1 WHERE B1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)"); |
617 | 682 |
strSQL.AppendFormat(" And ((A.TYINGFLG != {0} AND ({1} <= A.ConstructionStatusFlg And A.ConstructionStatusFlg <= {2}))", |
618 | 683 |
(int)ConstructionBaseInfo.TyingFlgDef.Tying, ProgressStart, ProgressComplete); |
... | ... | |
637 | 702 |
// ?Z?L?????e?B??????Z?b?g |
638 | 703 |
strSQL.Append(wrkBuff.ToString()); |
639 | 704 |
|
640 |
wrkFormat = new StringBuilder(); |
|
641 |
for (int i = 0; i < (s_SQLPart1.Length - 1); i++) wrkFormat.Append(s_SQLPart1[i]); |
|
642 |
wrkFormat.Append(", DATE_FORMAT(A1.PRINTOUTDATE, '%Y/%m/%d')"); |
|
643 |
for (int i = (s_SQLPart1.Length - 1); i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
|
705 |
wrkFormat.Clear(); |
|
706 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
|
707 |
wrkFormat.Append(", ifnull(App.ApprovalStatus, -1), ifnull(App.OrderNo, 0)"); |
|
708 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
709 |
|
|
644 | 710 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
645 | 711 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
712 |
|
|
713 |
wrkFormat.Append(" LEFT JOIN processapproval AS App ON App.ConstructionCode = A.ConstructionCode"); |
|
714 |
wrkFormat.AppendFormat(" AND App.ApprovalCode = {0}", (int)ClsExcute.ApprovalListNo.PurchaseOrderEntryApproval); |
|
715 |
wrkFormat.AppendFormat(" And App.OrderNo = {0}", CommonDefine.s_Default_OrderNo); |
|
716 |
wrkFormat.Append(" And App.SeqNo = 1"); |
|
717 |
|
|
646 | 718 |
wrkFormat.Append(", PURCHASEORDER A1"); |
647 | 719 |
for (int i = 0; i < s_SQLPart4.Length; i++) wrkFormat.Append(s_SQLPart4[i]); |
648 | 720 |
|
649 | 721 |
strSQL.Append(" UNION ("); |
650 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
|
|
722 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
651 | 723 |
strSQL.Append(" AND EXISTS (SELECT * FROM PURCHASEORDER B1 WHERE B1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)"); |
652 | 724 |
strSQL.Append(" AND A.CONSTRUCTIONPERSONCODE != 0"); |
653 | 725 |
strSQL.Append(" AND A1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE"); |
... | ... | |
696 | 768 |
CreateSecuritySQL(ref wrkBuff); |
697 | 769 |
|
698 | 770 |
StringBuilder wrkFormat = new StringBuilder(); |
699 |
for (int i = 0; i < (s_SQLPart1.Length - 1); i++) wrkFormat.Append(s_SQLPart1[i]); |
|
700 |
wrkFormat.Append(", DATE_FORMAT(A2.PRINTOUTDATE, '%Y/%m/%d'), A1.ORDERNO"); |
|
701 |
for (int i = (s_SQLPart1.Length - 1); i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
|
771 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
|
772 |
wrkFormat.Append(", DATE_FORMAT(A2.PRINTOUTDATE, '%Y/%m/%d'), A1.ORDERNO"); // ???t?B?[???h??????????? |
|
773 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
774 |
|
|
702 | 775 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
703 | 776 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
704 | 777 |
wrkFormat.Append(", PROCESSAPPROVAL A1, PURCHASEORDER A2"); |
705 | 778 |
for (int i = 0; i < s_SQLPart4.Length; i++) wrkFormat.Append(s_SQLPart4[i]); |
706 | 779 |
|
707 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
|
|
780 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
708 | 781 |
strSQL.Append(" AND EXISTS (SELECT * FROM PURCHASEORDER B1 WHERE B1.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE)"); |
709 | 782 |
strSQL.AppendFormat(" And (A.ConstructionCode = A1.ConstructionCode And A1.ApprovalCode = {0} And A1.SeqNo = 1 And A1.APPROVALSTATUS = {1})", |
710 | 783 |
ApprovalCode, (int)CommonDefine.ApprovalStatus.Approval); |
... | ... | |
720 | 793 |
strSQL.Append(wrkBuff.ToString()); |
721 | 794 |
|
722 | 795 |
// ORDER BY ??? |
723 |
strSQL.AppendFormat(" ORDER BY {0} ASC, {1} ASC, {2} ASC, {3} ASC, {4} ASC, {5} DESC", |
|
796 |
strSQL.AppendFormat(" ORDER BY {0} ASC, {1} ASC, {2} ASC, {3} ASC, {4} ASC, {5} DESC, {6} DESC",
|
|
724 | 797 |
(int)GetData.CONSTRUCTIONSTATUSFLG + 1, |
725 | 798 |
(int)GetData.SALESDEPDISPORDER + 1, |
726 | 799 |
(int)GetData.SALESMANDISPORDER + 1, |
727 | 800 |
(int)GetData.CONSTDEPDISPORDER + 1, |
728 | 801 |
(int)GetData.CONSTMANDISPORDER + 1, |
729 |
(int)GetData.CONSTRUCTIONCODE + 1); |
|
802 |
(int)GetData.CONSTRUCTIONCODE + 1, |
|
803 |
(int)GetData.ORDERNO + 1); |
|
730 | 804 |
} |
731 | 805 |
catch (Exception ex) |
732 | 806 |
{ |
... | ... | |
751 | 825 |
|
752 | 826 |
StringBuilder wrkFormat = new StringBuilder(); |
753 | 827 |
for (int i = 0; i < s_SQLPart1.Length; i++) wrkFormat.Append(s_SQLPart1[i]); |
828 |
wrkFormat.Append(", ifnull(App.ApprovalStatus, -1), ifnull(App.OrderNo, 0)"); |
|
829 |
for (int i = 0; i < s_SQLPart1_1.Length; i++) wrkFormat.Append(s_SQLPart1_1[i]); |
|
830 |
|
|
754 | 831 |
for (int i = 0; i < s_SQLPart2.Length; i++) wrkFormat.Append(s_SQLPart2[i]); |
755 | 832 |
for (int i = 0; i < s_SQLPart3.Length; i++) wrkFormat.Append(s_SQLPart3[i]); |
756 | 833 |
|
834 |
wrkFormat.Append(" LEFT JOIN processapproval AS App ON App.ConstructionCode = A.ConstructionCode"); |
|
835 |
wrkFormat.AppendFormat(" AND App.ApprovalCode = {0}", (int)ClsExcute.ApprovalListNo.EstimateBudgetApproval); |
|
836 |
wrkFormat.AppendFormat(" And App.OrderNo = {0}", CommonDefine.s_Default_OrderNo); |
|
837 |
wrkFormat.Append(" And App.SeqNo = 1"); |
|
838 |
|
|
757 | 839 |
wrkFormat.Append(", constructionledger AS Ledger"); |
758 | 840 |
|
759 | 841 |
for (int i = 0; i < s_SQLPart4.Length; i++) wrkFormat.Append(s_SQLPart4[i]); |
... | ... | |
761 | 843 |
wrkFormat.AppendFormat(" AND ({0} <= A.CONSTRUCTIONSTATUSFLG AND A.CONSTRUCTIONSTATUSFLG <= {1})", nStat1, nStat2); |
762 | 844 |
wrkFormat.Append(" AND Ledger.ConstructionCode = A.ConstructionCode"); |
763 | 845 |
|
764 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value, (int)ConstructionBaseInfoDetail.DataNoDef.ConstructionName);
|
|
846 |
strSQL.AppendFormat(wrkFormat.ToString(), numUDConstPro.Value); |
|
765 | 847 |
|
766 | 848 |
// ???????I??????????? |
767 | 849 |
strSQL.Append(GetDepartmentString()); |
... | ... | |
918 | 1000 |
string strStatus = string.Empty; |
919 | 1001 |
string strConstrName = string.Empty; |
920 | 1002 |
int ConstrCode = 0; |
921 |
int ParentCode = 0; |
|
922 | 1003 |
int OrderNo = 0; |
923 | 1004 |
foreach (object[] objwrk in arData) |
924 | 1005 |
{ |
925 | 1006 |
FlgString = string.Empty; |
926 | 1007 |
ConstrCode = CommonMotions.cnvInt(objwrk[(int)GetData.CONSTRUCTIONCODE]); |
927 | 1008 |
strConstrName = CommonMotions.cnvString(objwrk[(int)GetData.CONSTRUCTIONNAME]); |
1009 |
OrderNo = CommonMotions.cnvInt(objwrk[(int)GetData.ORDERNO]); |
|
928 | 1010 |
|
929 | 1011 |
// ----- ?N????????????? |
930 |
switch (m_ExecuteFlg) |
|
931 |
{ |
|
932 |
case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderEntry: |
|
933 |
case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint: |
|
934 |
// ??????????E???????????t???O???g?? |
|
935 |
ParentCode = ClsProcessExist.GetParentConstrCode(ConstrCode); |
|
936 |
if(GetPrintCount(OrderDB, ParentCode, ConstrCode)) FlgString = "??"; |
|
1012 |
SetPlusStatus(OrderDB, objwrk, ref FlgString, ref strConstrName); |
|
937 | 1013 |
|
938 |
if (m_ExecuteFlg == (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint) |
|
939 |
{ |
|
940 |
OrderNo = CommonMotions.cnvInt(objwrk[(int)GetData.ORDERNO]); |
|
941 |
strConstrName += string.Format(" ?\??{0}???", OrderNo); |
|
942 |
} |
|
943 |
break; |
|
944 |
default: |
|
945 |
break; |
|
946 |
} |
|
947 |
|
|
948 | 1014 |
// ?X?e?[?^?X?t???O??????1?s?J???? |
949 | 1015 |
if (StatusFlg != CommonMotions.cnvInt(objwrk[(int)GetData.CONSTRUCTIONSTATUSFLG])) |
950 | 1016 |
{ |
... | ... | |
993 | 1059 |
} |
994 | 1060 |
#endregion |
995 | 1061 |
|
1062 |
#region ????H????????W |
|
1063 |
/// <summary> |
|
1064 |
/// ????H????????W |
|
1065 |
/// </summary> |
|
1066 |
private void SetPlusStatus(IOPurchaseOrder OrderDB, object[] objwrk, |
|
1067 |
ref string FlgString, ref string strConstrName) |
|
1068 |
{ |
|
1069 |
try |
|
1070 |
{ |
|
1071 |
int nConstrCode = CommonMotions.cnvInt(objwrk[(int)GetData.CONSTRUCTIONCODE]); |
|
1072 |
int nOrderNo = CommonMotions.cnvInt(objwrk[(int)GetData.ORDERNO]); |
|
1073 |
int nAppStatus = 0; |
|
1074 |
string strAppStatus = string.Empty; |
|
1075 |
DateTime dtAppStatus = DateTime.MinValue; |
|
1076 |
|
|
1077 |
// ----- ?N????????????? |
|
1078 |
switch (m_ExecuteFlg) |
|
1079 |
{ |
|
1080 |
case (int)ClsExcute.ProcessExecuteNo.EstimateInput: // ??Z????????? |
|
1081 |
case (int)ClsExcute.ProcessExecuteNo.EstimateBudget: // ??Z?\?Z?????? |
|
1082 |
case (int)ClsExcute.ProcessExecuteNo.ConstructionBudget: // ?H???\?Z?????? |
|
1083 |
nAppStatus = CommonMotions.cnvInt(objwrk[(int)GetData.AppStatus]); |
|
1084 |
if (nAppStatus > -1) |
|
1085 |
{ |
|
1086 |
FlgString = CommonDefine.ApprovalStatusString[nAppStatus]; |
|
1087 |
} |
|
1088 |
break; |
|
1089 |
case (int)ClsExcute.ProcessExecuteNo.EstimatePrint: // ??Z?????? |
|
1090 |
dtAppStatus = CommonMotions.cnvDate(objwrk[(int)GetData.AppStatus]); |
|
1091 |
if (dtAppStatus.Date != DateTime.MinValue.Date) |
|
1092 |
{ |
|
1093 |
FlgString = "?????"; |
|
1094 |
} |
|
1095 |
break; |
|
1096 |
case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderEntry: // ?????????? |
|
1097 |
case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint: // ????????? |
|
1098 |
int ParentCode = ClsProcessExist.GetParentConstrCode(nConstrCode); |
|
1099 |
if (GetPrintCount(OrderDB, ParentCode, nConstrCode)) |
|
1100 |
{ |
|
1101 |
FlgString = "??"; |
|
1102 |
} |
|
1103 |
|
|
1104 |
if (m_ExecuteFlg == (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint) |
|
1105 |
{ |
|
1106 |
strConstrName += string.Format(" ?\??{0}???", nOrderNo); |
|
1107 |
} |
|
1108 |
break; |
|
1109 |
default: |
|
1110 |
break; |
|
1111 |
} |
|
1112 |
} |
|
1113 |
catch (Exception ex) |
|
1114 |
{ |
|
1115 |
logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message); |
|
1116 |
} |
|
1117 |
} |
|
1118 |
#endregion |
|
1119 |
|
|
996 | 1120 |
#region ???N?x?????Z?b?g |
997 | 1121 |
/// <summary> |
998 | 1122 |
/// ???N?x?????Z?b?g |
... | ... | |
1271 | 1395 |
/// </summary> |
1272 | 1396 |
private void InitDisplayStyle() |
1273 | 1397 |
{ |
1274 |
// ?t?H?[???T?C?Y?? |
|
1275 |
m_FormWidthSize = this.Width; |
|
1398 |
try |
|
1399 |
{ |
|
1400 |
// ?t?H?[???T?C?Y?? |
|
1401 |
m_FormWidthSize = this.Width; |
|
1276 | 1402 |
|
1277 |
DataGridView dgv = dgvMaster; |
|
1278 |
// ?O???b?h??????????? |
|
1279 |
m_GridWidthSize = dgv.Width; |
|
1403 |
DataGridView dgv = dgvMaster;
|
|
1404 |
// ?O???b?h???????????
|
|
1405 |
m_GridWidthSize = dgv.Width;
|
|
1280 | 1406 |
|
1281 |
int CellCount = dgv.ColumnCount; |
|
1282 |
m_CellSize = new int[CellCount]; |
|
1283 |
foreach (DataGridViewColumn col in dgv.Columns) |
|
1407 |
int CellCount = dgv.ColumnCount; |
|
1408 |
m_CellSize = new int[CellCount]; |
|
1409 |
foreach (DataGridViewColumn col in dgv.Columns) |
|
1410 |
{ |
|
1411 |
m_CellSize[col.Index] = col.Width; |
|
1412 |
} |
|
1413 |
|
|
1414 |
// ?f?[?^???????{?^????\?? |
|
1415 |
if (!m_DataAddtionButton) |
|
1416 |
{ |
|
1417 |
btnDataEntry.Visible = false; |
|
1418 |
} |
|
1419 |
|
|
1420 |
switch (m_ExecuteFlg) |
|
1421 |
{ |
|
1422 |
case (int)ClsExcute.ProcessExecuteNo.ConstructionBaseInfo: // ?H????{???? |
|
1423 |
// ???w?i?F??X |
|
1424 |
groupBox1.BackColor = Color.RoyalBlue; |
|
1425 |
// ?c??S???Z?b?g |
|
1426 |
radioButton1.Checked = true; |
|
1427 |
break; |
|
1428 |
case (int)ClsExcute.ProcessExecuteNo.EstimateInput: // ??Z??????? |
|
1429 |
case (int)ClsExcute.ProcessExecuteNo.EstimateBudget: // ??Z??????? |
|
1430 |
// ??????????\?? |
|
1431 |
OtherStatusVisible("???F"); |
|
1432 |
// ???w?i?F??X |
|
1433 |
groupBox1.BackColor = Color.RoyalBlue; |
|
1434 |
// ?c??S???Z?b?g |
|
1435 |
radioButton1.Checked = true; |
|
1436 |
break; |
|
1437 |
case (int)ClsExcute.ProcessExecuteNo.EstimatePrint: // ??Z?????? |
|
1438 |
// ??????????\?? |
|
1439 |
OtherStatusVisible("???"); |
|
1440 |
// ???w?i?F??X |
|
1441 |
groupBox1.BackColor = Color.RoyalBlue; |
|
1442 |
// ?c??S???Z?b?g |
|
1443 |
radioButton1.Checked = true; |
|
1444 |
break; |
|
1445 |
case (int)ClsExcute.ProcessExecuteNo.ConstructionBudget: // ?H???{?H?\?Z???? |
|
1446 |
// ??????????\?? |
|
1447 |
OtherStatusVisible("???F"); |
|
1448 |
// ???w?i?F??X |
|
1449 |
groupBox1.BackColor = Color.FromArgb(128, 128, 255); |
|
1450 |
// ?H???S???Z?b?g |
|
1451 |
radioButton2.Checked = true; |
|
1452 |
break; |
|
1453 |
case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderEntry: // ?????????? |
|
1454 |
case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint: // ????????? |
|
1455 |
// ??????????\?? |
|
1456 |
OtherStatusVisible("???"); |
|
1457 |
// ???w?i?F??X |
|
1458 |
groupBox1.BackColor = Color.FromArgb(128, 128, 255); |
|
1459 |
// ?H???S???Z?b?g |
|
1460 |
radioButton2.Checked = true; |
|
1461 |
break; |
|
1462 |
case (int)ClsExcute.ProcessExecuteNo.SafetyPatrol: // ???S?p?g???[?? |
|
1463 |
// ??????????\?? |
|
1464 |
OtherStatusVisible("???F"); |
|
1465 |
// ???w?i?F??X |
|
1466 |
groupBox1.BackColor = Color.DarkGreen; |
|
1467 |
// ?c??S???Z?b?g |
|
1468 |
radioButton1.Checked = true; |
|
1469 |
break; |
|
1470 |
default: |
|
1471 |
break; |
|
1472 |
} |
|
1473 |
// ?O???b?h?w?b?_?[?X?^?C???Z?b?g |
|
1474 |
SetGridColumnHeaderStyle(); |
|
1475 |
} |
|
1476 |
catch (Exception ex) |
|
1284 | 1477 |
{ |
1285 |
m_CellSize[col.Index] = col.Width;
|
|
1478 |
logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message);
|
|
1286 | 1479 |
} |
1480 |
} |
|
1481 |
#endregion |
|
1287 | 1482 |
|
1288 |
// ?f?[?^???????{?^????\?? |
|
1289 |
if (!m_DataAddtionButton) |
|
1483 |
#region ??????????\?? |
|
1484 |
/// <summary> |
|
1485 |
/// ??????????\?? |
|
1486 |
/// </summary> |
|
1487 |
private void OtherStatusVisible(string strStaus) |
|
1488 |
{ |
|
1489 |
try |
|
1290 | 1490 |
{ |
1291 |
btnDataEntry.Visible = false; |
|
1491 |
DataGridView dgv = dgvMaster; |
|
1492 |
// ???\???\?? |
|
1493 |
dgv.Columns[(int)DispColumn.OtherStatus].Visible = true; |
|
1494 |
// ?J?????????X |
|
1495 |
dgv.Columns[(int)DispColumn.ConstructionName].Width -= m_CellSize[(int)DispColumn.OtherStatus]; |
|
1496 |
// ?^?C?g???Z?b?g |
|
1497 |
dgv.Columns[(int)DispColumn.OtherStatus].HeaderCell.Value = strStaus; |
|
1292 | 1498 |
} |
1499 |
catch (Exception ex) |
|
1500 |
{ |
|
1501 |
logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message); |
|
1502 |
} |
|
1503 |
} |
|
1504 |
#endregion |
|
1293 | 1505 |
|
1294 |
switch (m_ExecuteFlg) |
|
1506 |
#region ?O???b?h?w?b?_?[?X?^?C???Z?b?g |
|
1507 |
/// <summary> |
|
1508 |
/// ?O???b?h?w?b?_?[?X?^?C???Z?b?g |
|
1509 |
/// </summary> |
|
1510 |
private void SetGridColumnHeaderStyle() |
|
1511 |
{ |
|
1512 |
try |
|
1295 | 1513 |
{ |
1296 |
case (int)ClsExcute.ProcessExecuteNo.ConstructionBaseInfo: // ?H????{???? |
|
1297 |
case (int)ClsExcute.ProcessExecuteNo.EstimateInput: // ??Z??????? |
|
1298 |
case (int)ClsExcute.ProcessExecuteNo.EstimatePrint: // ??Z?????? |
|
1299 |
case (int)ClsExcute.ProcessExecuteNo.EstimateBudget: // ??Z??????? |
|
1300 |
// ???w?i?F??X |
|
1301 |
groupBox1.BackColor = Color.RoyalBlue; |
|
1302 |
// ?c??S???Z?b?g |
|
1303 |
radioButton1.Checked = true; |
|
1304 |
break; |
|
1305 |
case (int)ClsExcute.ProcessExecuteNo.ConstructionBudget: // ?H???{?H?\?Z???? |
|
1306 |
// ???w?i?F??X |
|
1307 |
groupBox1.BackColor = Color.FromArgb(128, 128, 255); |
|
1308 |
// ?H???S???Z?b?g |
|
1309 |
radioButton2.Checked = true; |
|
1310 |
break; |
|
1311 |
case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderEntry: // ?????????? |
|
1312 |
case (int)ClsExcute.ProcessExecuteNo.PurchaseOrderPrint: // ????????? |
|
1313 |
// ?t???O?\?? |
|
1314 |
dgv.Columns[(int)DispColumn.PrintOutFlg].Visible = true; |
|
1315 |
// ???J?????????X |
|
1316 |
dgv.Columns[(int)DispColumn.ConstructionPerson].Width = m_CellSize[(int)DispColumn.ConstructionPerson] - m_CellSize[(int)DispColumn.PrintOutFlg]; |
|
1317 |
// ?H???S???Z?b?g |
|
1318 |
radioButton2.Checked = true; |
|
1319 |
break; |
|
1320 |
default: |
|
1321 |
break; |
|
1514 |
DataGridView dgv = dgvMaster; |
|
1515 |
for (int i = 0; i < dgv.ColumnCount; i++) |
|
1516 |
{ |
|
1517 |
dgv.Columns[i].HeaderCell.Style.BackColor = Color.LightGray; |
|
1518 |
dgv.Columns[i].HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter; |
|
1519 |
} |
|
1520 |
dgv.Columns[(int)DispColumn.OtherStatus].HeaderCell.Style.Font = new Font("?l?r ????", 10, FontStyle.Bold); |
|
1322 | 1521 |
} |
1522 |
catch (Exception ex) |
|
1523 |
{ |
|
1524 |
logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message); |
|
1525 |
} |
|
1323 | 1526 |
} |
1324 | 1527 |
#endregion |
1325 | 1528 |
|
... | ... | |
1742 | 1945 |
} |
1743 | 1946 |
} |
1744 | 1947 |
#endregion |
1948 |
|
|
1949 |
#region ?O???b?h?w?b?_?[?N???b?N?????s???????? |
|
1950 |
/// <summary> |
|
1951 |
/// ?O???b?h?w?b?_?[?N???b?N?????s???????? |
|
1952 |
/// </summary> |
|
1953 |
private void GridHearderClick() |
|
1954 |
{ |
|
1955 |
try |
|
1956 |
{ |
|
1957 |
DataGridView dgv = dgvMaster; |
|
1958 |
for (int i = (dgv.RowCount - 1); i >= 0; i--) |
|
1959 |
{ |
|
1960 |
if (CommonMotions.cnvInt(dgv.Rows[i].Cells[(int)DispColumn.No].Value) == 0) |
|
1961 |
{ |
|
1962 |
dgv.Rows.Remove(dgv.Rows[i]); |
|
1963 |
} |
|
1964 |
} |
|
1965 |
} |
|
1966 |
catch (Exception ex) |
|
1967 |
{ |
|
1968 |
logger.ErrorFormat("?V?X?e???G???[?F{0}?F{1}", CommonMotions.GetMethodName(), ex.Message); |
|
1969 |
} |
|
1970 |
} |
|
1971 |
#endregion |
|
1745 | 1972 |
} |
1746 | 1973 |
} |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/FrmConstructionBaseInfo.designer.cs | ||
---|---|---|
4049 | 4049 |
private System.Windows.Forms.TextBox txtInput07; |
4050 | 4050 |
private System.Windows.Forms.Label label6; |
4051 | 4051 |
private System.Windows.Forms.Label label8; |
4052 |
private CustomControls.ComboBoxEX cmbDisplayPerson; |
|
4052 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX cmbDisplayPerson;
|
|
4053 | 4053 |
private System.Windows.Forms.Label label4; |
4054 | 4054 |
private System.Windows.Forms.Panel panel2; |
4055 | 4055 |
private System.Windows.Forms.RadioButton rdbEstimateType2; |
4056 | 4056 |
private System.Windows.Forms.RadioButton rdbEstimateType3; |
4057 | 4057 |
private System.Windows.Forms.RadioButton rdbEstimateType1; |
4058 |
private CustomControls.ComboBoxEX cmbConstructionType; |
|
4058 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX cmbConstructionType;
|
|
4059 | 4059 |
private System.Windows.Forms.TextBox txtInput08; |
4060 | 4060 |
private System.Windows.Forms.Button btnSerchZip; |
4061 | 4061 |
private System.Windows.Forms.Label label20; |
... | ... | |
4087 | 4087 |
private System.Windows.Forms.Label label44; |
4088 | 4088 |
private System.Windows.Forms.Label label14; |
4089 | 4089 |
private System.Windows.Forms.Label label5; |
4090 |
private CustomControls.ComboBoxEX cmbOrdersDivision; |
|
4090 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX cmbOrdersDivision;
|
|
4091 | 4091 |
private System.Windows.Forms.Button btnOrderer; |
4092 |
private CustomControls.ComboBoxEX cmbDisplayOrderers; |
|
4092 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX cmbDisplayOrderers;
|
|
4093 | 4093 |
private System.Windows.Forms.TextBox txtInput05; |
4094 | 4094 |
private System.Windows.Forms.Label label9; |
4095 | 4095 |
private System.Windows.Forms.Panel panel4; |
4096 | 4096 |
private System.Windows.Forms.Label label39; |
4097 | 4097 |
private System.Windows.Forms.Label label30; |
4098 |
private CustomControls.TextBoxEX txtInput28; |
|
4098 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput28;
|
|
4099 | 4099 |
private System.Windows.Forms.Label label27; |
4100 |
private CustomControls.TextBoxEX txtInput25; |
|
4100 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput25;
|
|
4101 | 4101 |
private System.Windows.Forms.Label lblTransferDate; |
4102 | 4102 |
private System.Windows.Forms.Label label36; |
4103 |
private CustomControls.ComboBoxEX cmbTransferConstruction; |
|
4103 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX cmbTransferConstruction;
|
|
4104 | 4104 |
private System.Windows.Forms.Label label10; |
4105 | 4105 |
private System.Windows.Forms.TextBox txtInput01; |
4106 | 4106 |
private System.Windows.Forms.Label label33; |
4107 |
private CustomControls.TextBoxEX txtInput27; |
|
4108 |
private CustomControls.TextBoxEX txtInput02; |
|
4107 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput27;
|
|
4108 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput02;
|
|
4109 | 4109 |
private System.Windows.Forms.Label label24; |
4110 |
private CustomControls.TextBoxEX txtInput06; |
|
4110 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput06;
|
|
4111 | 4111 |
private System.Windows.Forms.Label label22; |
4112 |
private CustomControls.TextBoxEX txtInput12; |
|
4112 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput12;
|
|
4113 | 4113 |
private System.Windows.Forms.Label label12; |
4114 |
private CustomControls.TextBoxEX txtInput13; |
|
4114 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput13;
|
|
4115 | 4115 |
private System.Windows.Forms.Label label15; |
4116 | 4116 |
private System.Windows.Forms.Label label38; |
4117 | 4117 |
private System.Windows.Forms.Label label68; |
... | ... | |
4122 | 4122 |
private System.Windows.Forms.Label label23; |
4123 | 4123 |
private System.Windows.Forms.Label label70; |
4124 | 4124 |
private System.Windows.Forms.Label label71; |
4125 |
private CustomControls.TextBoxEX txtInput03; |
|
4125 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput03;
|
|
4126 | 4126 |
private System.Windows.Forms.Label label62; |
4127 | 4127 |
private System.Windows.Forms.Label label72; |
4128 | 4128 |
private System.Windows.Forms.Label label73; |
4129 | 4129 |
private System.Windows.Forms.Label label61; |
4130 | 4130 |
private System.Windows.Forms.Label label55; |
4131 |
private CustomControls.TextBoxEX txtInput38; |
|
4131 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput38;
|
|
4132 | 4132 |
private System.Windows.Forms.Label label54; |
4133 |
private CustomControls.TextBoxEX txtInput34; |
|
4133 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput34;
|
|
4134 | 4134 |
private System.Windows.Forms.Label label66; |
4135 | 4135 |
private System.Windows.Forms.Label label56; |
4136 | 4136 |
private System.Windows.Forms.Label label75; |
... | ... | |
4146 | 4146 |
private System.Windows.Forms.Label label53; |
4147 | 4147 |
private System.Windows.Forms.Panel panel7; |
4148 | 4148 |
private System.Windows.Forms.Label label31; |
4149 |
private CustomControls.ComboBoxEX cmbConstructionInstructor; |
|
4150 |
private CustomControls.ComboBoxEX cmbDisplayConstructionPerson; |
|
4149 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX cmbConstructionInstructor;
|
|
4150 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX cmbDisplayConstructionPerson;
|
|
4151 | 4151 |
private System.Windows.Forms.Label label21; |
4152 | 4152 |
private System.Windows.Forms.Label label50; |
4153 |
private CustomControls.TextBoxEX txtInput35; |
|
4153 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput35;
|
|
4154 | 4154 |
private System.Windows.Forms.Label label25; |
4155 |
private CustomControls.TextBoxEX txtInput04; |
|
4155 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput04;
|
|
4156 | 4156 |
private System.Windows.Forms.Label label42; |
4157 |
private CustomControls.TextBoxEX txtInput29; |
|
4158 |
private CustomControls.TextBoxEX txtInput30; |
|
4157 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput29;
|
|
4158 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput30;
|
|
4159 | 4159 |
private System.Windows.Forms.Label label81; |
4160 | 4160 |
private System.Windows.Forms.Label label82; |
4161 | 4161 |
private System.Windows.Forms.Label label77; |
... | ... | |
4182 | 4182 |
private System.Windows.Forms.Panel panel9; |
4183 | 4183 |
private System.Windows.Forms.Label label91; |
4184 | 4184 |
private System.Windows.Forms.Label label60; |
4185 |
private CustomControls.TextBoxEX txtInput36; |
|
4185 |
private ProcessManagement.Forms.CustomControls.TextBoxEX txtInput36;
|
|
4186 | 4186 |
private System.Windows.Forms.Label label98; |
4187 | 4187 |
private System.Windows.Forms.Label label96; |
4188 | 4188 |
private System.Windows.Forms.Label label95; |
4189 | 4189 |
private System.Windows.Forms.Label label93; |
4190 | 4190 |
private System.Windows.Forms.Label label92; |
4191 | 4191 |
private System.Windows.Forms.Label label97; |
4192 |
private CustomControls.ComboBoxEX comboBoxEX1; |
|
4192 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX comboBoxEX1;
|
|
4193 | 4193 |
private System.Windows.Forms.TextBox textBox1; |
4194 | 4194 |
private System.Windows.Forms.Label label101; |
4195 | 4195 |
private System.Windows.Forms.Label label100; |
4196 | 4196 |
private System.Windows.Forms.Label label99; |
4197 |
private CustomControls.TextBoxEX textBoxEX2; |
|
4198 |
private CustomControls.TextBoxEX textBoxEX1; |
|
4199 |
private CustomControls.TextBoxEX textBoxEX3; |
|
4200 |
private CustomControls.TextBoxEX textBoxEX5; |
|
4201 |
private CustomControls.TextBoxEX textBoxEX4; |
|
4202 |
private CustomControls.ComboBoxEX comboBoxEX2; |
|
4197 |
private ProcessManagement.Forms.CustomControls.TextBoxEX textBoxEX2;
|
|
4198 |
private ProcessManagement.Forms.CustomControls.TextBoxEX textBoxEX1;
|
|
4199 |
private ProcessManagement.Forms.CustomControls.TextBoxEX textBoxEX3;
|
|
4200 |
private ProcessManagement.Forms.CustomControls.TextBoxEX textBoxEX5;
|
|
4201 |
private ProcessManagement.Forms.CustomControls.TextBoxEX textBoxEX4;
|
|
4202 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX comboBoxEX2;
|
|
4203 | 4203 |
private System.Windows.Forms.Label label103; |
4204 | 4204 |
private System.Windows.Forms.Label label102; |
4205 | 4205 |
private System.Windows.Forms.TextBox textBox2; |
... | ... | |
4207 | 4207 |
private System.Windows.Forms.RadioButton radioButton1; |
4208 | 4208 |
private System.Windows.Forms.Label label108; |
4209 | 4209 |
private System.Windows.Forms.Label label109; |
4210 |
private CustomControls.ComboBoxEX cmbDisplayConstrSubPerson; |
|
4210 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX cmbDisplayConstrSubPerson;
|
|
4211 | 4211 |
private System.Windows.Forms.Label label112; |
4212 |
private CustomControls.ComboBoxEX comboBoxEX4; |
|
4213 |
private CustomControls.ComboBoxEX comboBoxEX3; |
|
4212 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX comboBoxEX4;
|
|
4213 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX comboBoxEX3;
|
|
4214 | 4214 |
private System.Windows.Forms.Label label113; |
4215 | 4215 |
private System.Windows.Forms.Label label114; |
4216 | 4216 |
private System.Windows.Forms.Label label115; |
... | ... | |
4259 | 4259 |
private System.Windows.Forms.DataGridViewTextBoxColumn BillingGridColumn3; |
4260 | 4260 |
private System.Windows.Forms.DataGridViewTextBoxColumn BillingGridColumn4; |
4261 | 4261 |
private System.Windows.Forms.Label label129; |
4262 |
private CustomControls.TextBoxEX textBoxEX6; |
|
4262 |
private ProcessManagement.Forms.CustomControls.TextBoxEX textBoxEX6;
|
|
4263 | 4263 |
private System.Windows.Forms.Label label87; |
4264 | 4264 |
private System.Windows.Forms.Label label86; |
4265 | 4265 |
private System.Windows.Forms.DataGridView dgvPayment; |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionJoin/FrmConstructionJoin.Designer.cs | ||
---|---|---|
42 | 42 |
this.btnNewWork = new System.Windows.Forms.Button(); |
43 | 43 |
this.dgvMaster = new System.Windows.Forms.DataGridView(); |
44 | 44 |
this.label2 = new System.Windows.Forms.Label(); |
45 |
this.groupBox1 = new System.Windows.Forms.GroupBox();
|
|
45 |
this.groupBox1 = new ProcessManagement.Forms.CustomControls.GroupBoxEx();
|
|
46 | 46 |
this.label13 = new System.Windows.Forms.Label(); |
47 | 47 |
this.cmbConstructionPerson = new System.Windows.Forms.ComboBox(); |
48 | 48 |
this.cmbDepartment = new System.Windows.Forms.ComboBox(); |
... | ... | |
466 | 466 |
private System.Windows.Forms.Button btnNewWork; |
467 | 467 |
private System.Windows.Forms.DataGridView dgvMaster; |
468 | 468 |
private System.Windows.Forms.Label label2; |
469 |
private System.Windows.Forms.GroupBox groupBox1;
|
|
469 |
private ProcessManagement.Forms.CustomControls.GroupBoxEx groupBox1;
|
|
470 | 470 |
private System.Windows.Forms.Label label4; |
471 | 471 |
private System.Windows.Forms.NumericUpDown numUDConstPro; |
472 | 472 |
private System.Windows.Forms.Label label5; |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedger/FrmSelectPerson.Designer.cs | ||
---|---|---|
233 | 233 |
private System.Windows.Forms.Button btnExecute; |
234 | 234 |
private System.Windows.Forms.Button btnCancel; |
235 | 235 |
private System.Windows.Forms.Panel panel1; |
236 |
private CustomControls.ComboBoxEX cmbDepartment; |
|
237 |
private CustomControls.ComboBoxEX cmbPerson; |
|
236 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX cmbDepartment;
|
|
237 |
private ProcessManagement.Forms.CustomControls.ComboBoxEX cmbPerson;
|
|
238 | 238 |
private System.Windows.Forms.Label label113; |
239 | 239 |
private System.Windows.Forms.Label label76; |
240 | 240 |
private System.Windows.Forms.Panel pnlCostParam; |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedgerList/FrmConstructionLedgerList.designer.cs | ||
---|---|---|
48 | 48 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle17 = new System.Windows.Forms.DataGridViewCellStyle(); |
49 | 49 |
this.btnEnd = new System.Windows.Forms.Button(); |
50 | 50 |
this.label1 = new System.Windows.Forms.Label(); |
51 |
this.groupBox1 = new System.Windows.Forms.GroupBox(); |
|
51 |
this.lblCellTotal = new System.Windows.Forms.Label(); |
|
52 |
this.ProgressBar = new System.Windows.Forms.ProgressBar(); |
|
53 |
this.btnLedgerStatus = new System.Windows.Forms.Button(); |
|
54 |
this.btnOtherProc = new System.Windows.Forms.Button(); |
|
55 |
this.dgvMaster = new ProcessManagement.Forms.CustomControls.DataGridViewEX(); |
|
56 |
this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
57 |
this.Column13 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
58 |
this.Column14 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
59 |
this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
60 |
this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
61 |
this.Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
62 |
this.Column15 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
63 |
this.Column5 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
64 |
this.Column6 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
65 |
this.Column7 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
66 |
this.Column8 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
67 |
this.Column9 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
68 |
this.Column10 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
69 |
this.Column11 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
70 |
this.Column12 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
71 |
this.groupBox1 = new ProcessManagement.Forms.CustomControls.GroupBoxEx(); |
|
52 | 72 |
this.pnlPayroll = new System.Windows.Forms.Panel(); |
53 | 73 |
this.label18 = new System.Windows.Forms.Label(); |
54 | 74 |
this.lblEndDate = new System.Windows.Forms.Label(); |
... | ... | |
87 | 107 |
this.label3 = new System.Windows.Forms.Label(); |
88 | 108 |
this.label5 = new System.Windows.Forms.Label(); |
89 | 109 |
this.label7 = new System.Windows.Forms.Label(); |
90 |
this.lblCellTotal = new System.Windows.Forms.Label(); |
|
91 |
this.ProgressBar = new System.Windows.Forms.ProgressBar(); |
|
92 |
this.dgvMaster = new ProcessManagement.Forms.CustomControls.DataGridViewEX(); |
|
93 |
this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
94 |
this.Column13 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
95 |
this.Column14 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
96 |
this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
97 |
this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
98 |
this.Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
99 |
this.Column15 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
100 |
this.Column5 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
101 |
this.Column6 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
102 |
this.Column7 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
103 |
this.Column8 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
104 |
this.Column9 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
105 |
this.Column10 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
106 |
this.Column11 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
107 |
this.Column12 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
108 |
this.btnLedgerStatus = new System.Windows.Forms.Button(); |
|
109 |
this.btnOtherProc = new System.Windows.Forms.Button(); |
|
110 |
((System.ComponentModel.ISupportInitialize)(this.dgvMaster)).BeginInit(); |
|
110 | 111 |
this.groupBox1.SuspendLayout(); |
111 | 112 |
this.pnlPayroll.SuspendLayout(); |
112 | 113 |
((System.ComponentModel.ISupportInitialize)(this.numUDConstPro)).BeginInit(); |
113 |
((System.ComponentModel.ISupportInitialize)(this.dgvMaster)).BeginInit(); |
|
114 | 114 |
this.SuspendLayout(); |
115 | 115 |
// |
116 | 116 |
// btnEnd |
... | ... | |
140 | 140 |
this.label1.Text = "工 事 詳 細 台 帳 一 覧"; |
141 | 141 |
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleCenter; |
142 | 142 |
// |
143 |
// lblCellTotal |
|
144 |
// |
|
145 |
this.lblCellTotal.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); |
|
146 |
this.lblCellTotal.AutoSize = true; |
|
147 |
this.lblCellTotal.BackColor = System.Drawing.Color.Black; |
|
148 |
this.lblCellTotal.Font = new System.Drawing.Font("MS 明朝", 9.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128))); |
|
149 |
this.lblCellTotal.ForeColor = System.Drawing.Color.White; |
|
150 |
this.lblCellTotal.Location = new System.Drawing.Point(200, 628); |
|
151 |
this.lblCellTotal.Name = "lblCellTotal"; |
|
152 |
this.lblCellTotal.Size = new System.Drawing.Size(0, 13); |
|
153 |
this.lblCellTotal.TabIndex = 29; |
|
154 |
// |
|
155 |
// ProgressBar |
|
156 |
// |
|
157 |
this.ProgressBar.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); |
|
158 |
this.ProgressBar.Location = new System.Drawing.Point(5, 619); |
|
159 |
this.ProgressBar.Name = "ProgressBar"; |
|
160 |
this.ProgressBar.Size = new System.Drawing.Size(388, 30); |
|
161 |
this.ProgressBar.TabIndex = 30; |
|
162 |
this.ProgressBar.Visible = false; |
|
163 |
// |
|
164 |
// btnLedgerStatus |
|
165 |
// |
|
166 |
this.btnLedgerStatus.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right))); |
|
167 |
this.btnLedgerStatus.BackColor = System.Drawing.Color.DodgerBlue; |
|
168 |
this.btnLedgerStatus.Font = new System.Drawing.Font("MS 明朝", 12F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128))); |
|
169 |
this.btnLedgerStatus.ForeColor = System.Drawing.Color.Black; |
|
170 |
this.btnLedgerStatus.Location = new System.Drawing.Point(1185, 5); |
|
171 |
this.btnLedgerStatus.Name = "btnLedgerStatus"; |
|
172 |
this.btnLedgerStatus.Size = new System.Drawing.Size(150, 30); |
|
173 |
this.btnLedgerStatus.TabIndex = 47; |
他の形式にエクスポート: Unified diff