リビジョン 346
削除フラグをCommonに定義
経費名称可変対応
工事詳細台帳一覧クラス名変更
branches/src/ProcessManagement/ProcessManagement/Common/CommonDefine.cs | ||
---|---|---|
43 | 43 |
/// パスを定数で定義する |
44 | 44 |
/// </summary> |
45 | 45 |
public const string s_UPDATECOPY_NAME = "UpDateCopy.exe"; |
46 |
// ▼自動更新VPS対応▼ |
|
46 |
// ▼自動更新VPS対応▼
|
|
47 | 47 |
// FTPユーザ名 |
48 | 48 |
public const string s_FTP_USER_NAME = "pmaint"; |
49 | 49 |
// FTPパスワード |
... | ... | |
60 | 60 |
public const string s_VERSION_SECTION = "genbaKantokuHisyo"; |
61 | 61 |
// 起動パラメータ |
62 | 62 |
public const string s_KIDOU_PARAM = "/NOCHECK"; |
63 |
// ▲自動更新VPS対応▲ |
|
63 |
// ▲自動更新VPS対応▲
|
|
64 | 64 |
#endregion |
65 | 65 |
|
66 | 66 |
#region システム定義ファイルパス |
... | ... | |
256 | 256 |
public static string[] DayOfTheWeekString = new string[] { "日", "月", "火", "水", "木", "金", "土" }; |
257 | 257 |
#endregion |
258 | 258 |
|
259 |
#region データ削除フラグ |
|
260 |
/// <summary> |
|
261 |
/// データ削除フラグ |
|
262 |
/// </summary> |
|
263 |
public enum DataRowDeleteDef |
|
264 |
{ |
|
265 |
/// <summary> |
|
266 |
/// 存在中 |
|
267 |
/// </summary> |
|
268 |
Exists = 0, |
|
269 |
/// <summary> |
|
270 |
/// 削除済み |
|
271 |
/// </summary> |
|
272 |
Deleted, |
|
273 |
} |
|
274 |
#endregion |
|
275 |
|
|
259 | 276 |
#region 掲示板:関連定義 |
260 | 277 |
#region 掲示板グリッド返信文字 |
261 | 278 |
/// <summary> |
... | ... | |
1031 | 1048 |
/// <summary> |
1032 | 1049 |
/// 通常業者 |
1033 | 1050 |
/// </summary> |
1034 |
Normal = 0,
|
|
1051 |
Normal = 0, |
|
1035 | 1052 |
/// <summary> |
1036 | 1053 |
/// 手間業者 |
1037 | 1054 |
/// </summary> |
... | ... | |
1043 | 1060 |
/// <summary> |
1044 | 1061 |
/// 資材返却期限コントロールアイテム // Add BIT 2017/03/18 |
1045 | 1062 |
/// </summary> |
1046 |
public static string[,] MaterualLimitItem = new string[2,4] { |
|
1063 |
public static string[,] MaterualLimitItem = new string[2, 4] {
|
|
1047 | 1064 |
{ "資材返却", "本日返却期限の資材があります。", "0xFF0000", "0x000000" }, |
1048 | 1065 |
{ "資材返却", "返却期限を過ぎた資材があります。", "0x808080", "0xFF0000" } |
1049 | 1066 |
}; |
... | ... | |
1079 | 1096 |
AsNormalEnd, |
1080 | 1097 |
} |
1081 | 1098 |
#endregion |
1099 |
|
|
1100 |
#region 期数運用時文字列 |
|
1101 |
/// <summary> |
|
1102 |
/// 期数運用時文字列 |
|
1103 |
/// </summary> |
|
1104 |
public static string[] Type1YearString = new string[] { "対象期", "期" }; |
|
1105 |
#endregion |
|
1106 |
|
|
1107 |
#region 年数運用時文字列 |
|
1108 |
/// <summary> |
|
1109 |
/// 年数運用時文字列 |
|
1110 |
/// </summary> |
|
1111 |
public static string[] Type2YearString = new string[] { "対象年", "年" }; |
|
1112 |
#endregion |
|
1082 | 1113 |
} |
1083 | 1114 |
} |
branches/src/ProcessManagement/ProcessManagement/Common/CommonMotions.cs | ||
---|---|---|
3341 | 3341 |
} |
3342 | 3342 |
#endregion |
3343 | 3343 |
|
3344 |
#region 今期の判定を行う |
|
3344 |
#region 今期以降の判定を行う
|
|
3345 | 3345 |
/// <summary> |
3346 |
/// 今期の判定を行う |
|
3346 |
/// 今期以降の判定を行う
|
|
3347 | 3347 |
/// </summary> |
3348 | 3348 |
/// <returns></returns> |
3349 | 3349 |
public static bool CheckNowSeason(int nTarget) |
... | ... | |
3352 | 3352 |
{ |
3353 | 3353 |
if (m_systemMaster.ConstructionNoBase == (int)SystemMaster.ConstrNoBaseDef.BusinessPeriod) |
3354 | 3354 |
{ // 営業期数 |
3355 |
if (nTarget != m_systemMaster.BusinessPeriod) return false;
|
|
3355 |
if (nTarget < m_systemMaster.BusinessPeriod) return false;
|
|
3356 | 3356 |
} |
3357 | 3357 |
else |
3358 | 3358 |
{ // 工事年度 |
3359 |
if (nTarget != m_systemMaster.ConstrYear) return false;
|
|
3359 |
if (nTarget < m_systemMaster.ConstrYear) return false;
|
|
3360 | 3360 |
} |
3361 | 3361 |
return true; |
3362 | 3362 |
} |
... | ... | |
3454 | 3454 |
strSQL.Append(" WHERE"); |
3455 | 3455 |
|
3456 | 3456 |
// 削除されていないもの |
3457 |
strSQL.Append(" A.DELETEFLG = 0");
|
|
3457 |
strSQL.AppendFormat(" A.DELETEFLG = {0}", (int)CommonDefine.DataRowDeleteDef.Exists);
|
|
3458 | 3458 |
DateTime dtDefaultEnd = CommonMotions.GetOpeningEndDate(nTargetCount, false); |
3459 | 3459 |
|
3460 | 3460 |
strSQL.AppendFormat(" And DATE(A.StartDate) <= DATE('{0}')", dtDefaultEnd.ToShortDateString()); |
... | ... | |
3610 | 3610 |
/// 3:部署コード |
3611 | 3611 |
/// </summary> |
3612 | 3612 |
DepCode, |
3613 |
/// <summary> |
|
3614 |
/// 4:削除フラグ(部署経費マスタ) |
|
3615 |
/// </summary> |
|
3616 |
DeleteFlg, |
|
3613 | 3617 |
} |
3614 | 3618 |
#endregion |
3615 | 3619 |
|
... | ... | |
3632 | 3636 |
strSQL.Append(", IFNULL(B.EXPENSESRAITO, 0)"); |
3633 | 3637 |
strSQL.Append(", A.NAMECODE"); |
3634 | 3638 |
strSQL.Append(", B.DEPARTMENTCODE"); |
3639 |
strSQL.Append(", A.DeleteFlg"); |
|
3635 | 3640 |
strSQL.Append(" FROM"); |
3636 | 3641 |
strSQL.Append(" DIVISIONMASTER AS A"); |
3642 |
|
|
3637 | 3643 |
strSQL.Append(" LEFT JOIN ("); |
3638 | 3644 |
strSQL.Append("SELECT"); |
3639 |
strSQL.Append(" NAMECODE"); |
|
3640 |
strSQL.Append(", DEPARTMENTCODE"); |
|
3641 |
strSQL.Append(", EXPENSESRAITO"); |
|
3642 |
strSQL.Append(", EXPENSESPERIOD"); |
|
3645 |
strSQL.Append(" BB.NAMECODE"); |
|
3646 |
strSQL.Append(", BB.DEPARTMENTCODE"); |
|
3647 |
strSQL.Append(", BB.EXPENSESRAITO"); |
|
3648 |
strSQL.Append(", BB.EXPENSESPERIOD"); |
|
3649 |
strSQL.Append(", BB.DisplayOrder"); |
|
3643 | 3650 |
strSQL.Append(" FROM"); |
3644 |
strSQL.Append(" DEPARTMENTEXPENSESMASTER) AS B"); |
|
3651 |
strSQL.Append(" DEPARTMENTEXPENSESMASTER AS BB) AS B");
|
|
3645 | 3652 |
strSQL.Append(" ON A.NAMECODE = B.NAMECODE"); |
3646 | 3653 |
strSQL.AppendFormat(" AND B.EXPENSESPERIOD = {0}", Preiod); |
3647 | 3654 |
if(DepartmentCode > 0) strSQL.AppendFormat(" AND B.DEPARTMENTCODE = {0}", DepartmentCode); |
3655 |
|
|
3656 |
strSQL.Append(" LEFT JOIN departmentmaster AS C"); |
|
3657 |
strSQL.Append(" On C.DepartmentCode = B.DEPARTMENTCODE"); |
|
3658 |
|
|
3648 | 3659 |
strSQL.AppendFormat(" WHERE A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses); |
3649 |
strSQL.Append(" ORDER BY A.DISPLAYORDER"); |
|
3660 |
strSQL.AppendFormat(" AND A.DeleteFlg = {0}", (int)CommonDefine.DataRowDeleteDef.Exists); |
|
3661 |
|
|
3662 |
strSQL.Append(" ORDER BY A.DISPLAYORDER, C.DISPLAYORDER"); |
|
3650 | 3663 |
} |
3651 | 3664 |
else |
3652 | 3665 |
{ // 以前のデータ |
3653 | 3666 |
strSQL.Append("SELECT"); |
3654 |
strSQL.Append(" NAMESTRING"); |
|
3655 |
strSQL.Append(", EXPENSESRAITO"); |
|
3656 |
strSQL.Append(", NAMECODE"); |
|
3657 |
strSQL.Append(", DEPARTMENTCODE"); |
|
3667 |
strSQL.Append(" B.NAMESTRING"); |
|
3668 |
strSQL.Append(", B.EXPENSESRAITO"); |
|
3669 |
strSQL.Append(", B.NAMECODE"); |
|
3670 |
strSQL.Append(", B.DEPARTMENTCODE"); |
|
3671 |
strSQL.Append(", B.DeleteFlg"); |
|
3658 | 3672 |
strSQL.Append(" FROM"); |
3659 | 3673 |
strSQL.Append(" DEPARTMENTEXPENSESMASTER AS B"); |
3674 |
|
|
3675 |
strSQL.Append(" INNER JOIN departmentmaster AS C"); |
|
3676 |
strSQL.Append(" On C.DepartmentCode = B.DEPARTMENTCODE"); |
|
3677 |
|
|
3678 |
strSQL.Append(" INNER JOIN divisionmaster AS D"); |
|
3679 |
strSQL.AppendFormat(" ON D.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses); |
|
3680 |
strSQL.Append(" And D.NameCode = B.NameCode"); |
|
3681 |
|
|
3660 | 3682 |
strSQL.AppendFormat(" WHERE B.EXPENSESPERIOD = {0}", Preiod); |
3661 | 3683 |
if (DepartmentCode > 0) strSQL.AppendFormat(" AND B.DEPARTMENTCODE = {0}", DepartmentCode); |
3662 |
strSQL.Append(" ORDER BY B.DISPLAYORDER"); |
|
3684 |
strSQL.Append(" ORDER BY D.DeleteFlg, C.DISPLAYORDER, B.DISPLAYORDER");
|
|
3663 | 3685 |
} |
3664 | 3686 |
|
3665 | 3687 |
ExpensesList.Clear(); |
branches/src/ProcessManagement/ProcessManagement/Common/CommonVersion.cs | ||
---|---|---|
14 | 14 |
/// <summary> |
15 | 15 |
/// 本体バージョン |
16 | 16 |
/// </summary> |
17 |
public static int s_SystemVersion = 196;
|
|
17 |
public static int s_SystemVersion = 197;
|
|
18 | 18 |
|
19 | 19 |
/// <summary> |
20 | 20 |
/// コピー・環境バージョン |
branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsExcute.cs | ||
---|---|---|
1384 | 1384 |
public static void ProcessExecuteNo_ConstructionLedgerList(ProcessParameter CurrentPara) |
1385 | 1385 |
{ |
1386 | 1386 |
// 工事詳細台帳一覧 |
1387 |
FrmLedgerStatus frm = new FrmLedgerStatus();
|
|
1387 |
FrmLedgerList frm = new FrmLedgerList();
|
|
1388 | 1388 |
try |
1389 | 1389 |
{ |
1390 | 1390 |
int ProcessNo = (int)ProcessExecuteNo.ConstructionLedgerList; |
... | ... | |
1692 | 1692 |
public static void ProcessExecuteNo_ConstrLedgerPersonList(ProcessParameter CurrentPara) |
1693 | 1693 |
{ |
1694 | 1694 |
// 工事詳細台帳一覧 |
1695 |
FrmLedgerStatus frm = new FrmLedgerStatus();
|
|
1695 |
FrmLedgerList frm = new FrmLedgerList();
|
|
1696 | 1696 |
try |
1697 | 1697 |
{ |
1698 | 1698 |
int ProcessNo = (int)ProcessExecuteNo.ConstructionLedgerList; |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMApproval.cs | ||
---|---|---|
56 | 56 |
|
57 | 57 |
#endregion |
58 | 58 |
|
59 |
#region 検索文字列作成 |
|
60 |
/// <summary> |
|
61 |
/// 検索文字列作成 |
|
62 |
/// </summary> |
|
63 |
/// <returns></returns> |
|
64 |
private string CreateSelectSQL() |
|
65 |
{ |
|
66 |
StringBuilder strcmd = new StringBuilder(); |
|
67 |
|
|
68 |
// SQL作成(DateTime型が変換できないのでCharに変換しておく) |
|
69 |
strcmd.Append("SELECT"); |
|
70 |
strcmd.Append(" ApprovalCode"); |
|
71 |
strcmd.Append(",DepartmentCode"); |
|
72 |
strcmd.Append(",SeqNo"); |
|
73 |
strcmd.Append(",DisplayOrder"); |
|
74 |
strcmd.Append(",ApprovalPerson"); |
|
75 |
strcmd.Append(",ApprovalAuthority"); |
|
76 |
strcmd.Append(",DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')"); |
|
77 |
strcmd.Append(",DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')"); |
|
78 |
strcmd.Append(" FROM ApprovalMaster"); |
|
79 |
|
|
80 |
return strcmd.ToString(); |
|
81 |
} |
|
82 |
#endregion |
|
83 |
|
|
59 | 84 |
#region 承認経路登録マスタ検索 |
60 | 85 |
/// <summary> |
61 | 86 |
/// 承認経路登録マスタ検索 |
... | ... | |
71 | 96 |
|
72 | 97 |
try |
73 | 98 |
{ |
74 |
// SQL作成(DateTime型が変換できないのでCharに変換しておく) |
|
75 |
strcmd.Append("SELECT"); |
|
76 |
strcmd.Append(" ApprovalCode"); |
|
77 |
strcmd.Append(",DepartmentCode"); |
|
78 |
strcmd.Append(",SeqNo"); |
|
79 |
strcmd.Append(",DisplayOrder"); |
|
80 |
strcmd.Append(",ApprovalPerson"); |
|
81 |
strcmd.Append(",ApprovalAuthority"); |
|
82 |
strcmd.Append(",DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')"); |
|
83 |
strcmd.Append(",DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')"); |
|
84 |
strcmd.Append(" FROM ApprovalMaster"); |
|
85 |
strcmd.Append(AddSQLString); |
|
86 |
|
|
99 |
// SQL作成 |
|
100 |
strcmd.AppendFormat("{0}{1}", CreateSelectSQL(), AddSQLString); |
|
87 | 101 |
// SQL実行 |
88 | 102 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false; |
89 | 103 |
|
... | ... | |
264 | 278 |
} |
265 | 279 |
#endregion |
266 | 280 |
|
281 |
#region 1項目の更新 |
|
282 |
/// <summary> |
|
283 |
/// 1項目の更新 |
|
284 |
/// </summary> |
|
285 |
/// <returns></returns> |
|
286 |
public bool UpdateFeild(int DepCode, int FeildNo, object value, bool bConnect = true) |
|
287 |
{ |
|
288 |
StringBuilder strcmd = new StringBuilder(); |
|
289 |
try |
|
290 |
{ |
|
291 |
strcmd.Append("UPDATE ApprovalMaster"); |
|
292 |
|
|
293 |
strcmd.Append(" SET"); |
|
294 |
switch (FeildNo) |
|
295 |
{ |
|
296 |
case (int)NameColumn.ApprovalCode: |
|
297 |
strcmd.AppendFormat(" ApprovalCode = {0}", ((int)value).ToString()); |
|
298 |
break; |
|
299 |
case (int)NameColumn.DepartmentCode: |
|
300 |
strcmd.AppendFormat(" DepartmentCode = {0}", ((int)value).ToString()); |
|
301 |
break; |
|
302 |
case (int)NameColumn.SeqNo: |
|
303 |
strcmd.AppendFormat(" SeqNo = {0}", ((int)value).ToString()); |
|
304 |
break; |
|
305 |
case (int)NameColumn.DisplayOrder: |
|
306 |
strcmd.AppendFormat(" DisplayOrder = {0}", ((int)value).ToString()); |
|
307 |
break; |
|
308 |
case (int)NameColumn.ApprovalPerson: |
|
309 |
strcmd.AppendFormat(" ApprovalPerson = {0}", ((int)value).ToString()); |
|
310 |
break; |
|
311 |
case (int)NameColumn.ApprovalAuthority: |
|
312 |
strcmd.AppendFormat(" ApprovalAuthority = {0}", ((int)value).ToString()); |
|
313 |
break; |
|
314 |
} |
|
315 |
|
|
316 |
strcmd.Append(", UpdateDate = NOW()"); |
|
317 |
strcmd.Append(CreatePrimarykeyString(DepCode)); |
|
318 |
|
|
319 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false; |
|
320 |
|
|
321 |
return true; |
|
322 |
} |
|
323 |
catch (Exception ex) |
|
324 |
{ |
|
325 |
logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString()); |
|
326 |
return false; |
|
327 |
} |
|
328 |
} |
|
329 |
#endregion |
|
330 |
|
|
267 | 331 |
#region MySQLDataReaderより構造体へセットする |
268 | 332 |
/// <summary> |
269 | 333 |
/// MySQLDataReaderより構造体へセットする |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDepartment.cs | ||
---|---|---|
329 | 329 |
} |
330 | 330 |
#endregion |
331 | 331 |
|
332 |
#region 1項目の更新 |
|
333 |
/// <summary> |
|
334 |
/// 1項目の更新 |
|
335 |
/// </summary> |
|
336 |
/// <returns></returns> |
|
337 |
public bool UpdateFeild(int DepCode, int FeildNo, object value, bool bConnect = true) |
|
338 |
{ |
|
339 |
StringBuilder strcmd = new StringBuilder(); |
|
340 |
try |
|
341 |
{ |
|
342 |
strcmd.Append("UPDATE DepartmentMaster"); |
|
343 |
|
|
344 |
strcmd.Append(" SET"); |
|
345 |
switch (FeildNo) |
|
346 |
{ |
|
347 |
case (int)NameColumn.DepartmentCode: |
|
348 |
strcmd.AppendFormat(" DepartmentCode = {0}", ((int)value).ToString()); |
|
349 |
break; |
|
350 |
case (int)NameColumn.DisplayOrder: |
|
351 |
strcmd.AppendFormat(" DisplayOrder = {0}", ((int)value).ToString()); |
|
352 |
break; |
|
353 |
case (int)NameColumn.DepartmentString: |
|
354 |
strcmd.AppendFormat(" DepartmentString = '{0}'", value.ToString()); |
|
355 |
break; |
|
356 |
case (int)NameColumn.ActionScheduleFlg: |
|
357 |
strcmd.AppendFormat(" ActionScheduleFlg = {0}", ((int)value).ToString()); |
|
358 |
break; |
|
359 |
case (int)NameColumn.StaffAssignFlg: |
|
360 |
strcmd.AppendFormat(" StaffAssignFlg = {0}", ((int)value).ToString()); |
|
361 |
break; |
|
362 |
case (int)NameColumn.StartDate: |
|
363 |
strcmd.AppendFormat(" StartDate = STR_TO_DATE('{0}','%Y/%m/%d')", ((DateTime)value).ToShortDateString()); |
|
364 |
break; |
|
365 |
case (int)NameColumn.CompDate: |
|
366 |
strcmd.AppendFormat(" CompDate = STR_TO_DATE('{0}','%Y/%m/%d')", ((DateTime)value).ToShortDateString()); |
|
367 |
break; |
|
368 |
case (int)NameColumn.DeleteFlg: |
|
369 |
strcmd.AppendFormat(" DeleteFlg = {0}", ((int)value).ToString()); |
|
370 |
break; |
|
371 |
} |
|
372 |
|
|
373 |
strcmd.Append(", UpdateDate = NOW()"); |
|
374 |
strcmd.Append(CreatePrimarykeyString(DepCode)); |
|
375 |
|
|
376 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false; |
|
377 |
|
|
378 |
return true; |
|
379 |
} |
|
380 |
catch (Exception ex) |
|
381 |
{ |
|
382 |
logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString()); |
|
383 |
return false; |
|
384 |
} |
|
385 |
} |
|
386 |
#endregion |
|
387 |
|
|
332 | 388 |
#region MySQLDataReaderより構造体へセットする |
333 | 389 |
/// <summary> |
334 | 390 |
/// MySQLDataReaderより構造体へセットする |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDepartmentExpenses.cs | ||
---|---|---|
400 | 400 |
} |
401 | 401 |
#endregion |
402 | 402 |
|
403 |
#region 1項目の更新 |
|
404 |
/// <summary> |
|
405 |
/// 1項目の更新 |
|
406 |
/// </summary> |
|
407 |
/// <returns></returns> |
|
408 |
public bool UpdateFeild(int DepCode, int ExpYear, int NmCode, int FeildNo, object value, bool bConnect = true) |
|
409 |
{ |
|
410 |
StringBuilder strcmd = new StringBuilder(); |
|
411 |
try |
|
412 |
{ |
|
413 |
strcmd.Append("UPDATE DepartmentExpensesMaster"); |
|
414 |
|
|
415 |
strcmd.Append(" SET"); |
|
416 |
switch (FeildNo) |
|
417 |
{ |
|
418 |
case (int)NameColumn.DepartmentCode: |
|
419 |
// 部署コード |
|
420 |
strcmd.AppendFormat(" DepartmentCode = {0}", ((int)value).ToString()); |
|
421 |
break; |
|
422 |
case (int)NameColumn.ExpensesPeriod: |
|
423 |
// 事業期 |
|
424 |
strcmd.AppendFormat(" ExpensesPeriod = {0}", ((int)value).ToString()); |
|
425 |
break; |
|
426 |
case (int)NameColumn.NameCode: |
|
427 |
// 経費名称コード |
|
428 |
strcmd.AppendFormat(" NameCode = {0}", ((int)value).ToString()); |
|
429 |
break; |
|
430 |
case (int)NameColumn.NameString: |
|
431 |
// 名称 |
|
432 |
strcmd.AppendFormat(" NameString = '{0}'", value.ToString()); |
|
433 |
break; |
|
434 |
case (int)NameColumn.DisplayOrder: |
|
435 |
// 表示順 |
|
436 |
strcmd.AppendFormat(" DisplayOrder = {0}", ((int)value).ToString()); |
|
437 |
break; |
|
438 |
case (int)NameColumn.ExpensesRaito: |
|
439 |
// 経費率 |
|
440 |
strcmd.AppendFormat(" ExpensesRaito = {0}", ((int)value).ToString()); |
|
441 |
break; |
|
442 |
case (int)NameColumn.DeleteFlg: |
|
443 |
// 削除フラグ |
|
444 |
strcmd.AppendFormat(" DeleteFlg = {0}", ((int)value).ToString()); |
|
445 |
break; |
|
446 |
} |
|
447 |
|
|
448 |
strcmd.Append(", UpdateDate = NOW()"); |
|
449 |
strcmd.Append(CreatePrimarykeyString(DepCode, ExpYear, NmCode)); |
|
450 |
|
|
451 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false; |
|
452 |
|
|
453 |
return true; |
|
454 |
} |
|
455 |
catch (Exception ex) |
|
456 |
{ |
|
457 |
logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString()); |
|
458 |
return false; |
|
459 |
} |
|
460 |
} |
|
461 |
#endregion |
|
462 |
|
|
403 | 463 |
#region MySQLDataReaderより構造体へセットする |
404 | 464 |
/// <summary> |
405 | 465 |
/// MySQLDataReaderより構造体へセットする |
branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDivision.cs | ||
---|---|---|
287 | 287 |
/// </summary> |
288 | 288 |
/// <param name="NameCode">名称コード</param> |
289 | 289 |
/// <returns>成功時:true 失敗時:false</returns> |
290 |
public bool LogicalDeleteAction(int NameCode, bool bConnect = true) |
|
290 |
public bool LogicalDeleteAction(int DivCode, int NameCode, bool bConnect = true)
|
|
291 | 291 |
{ |
292 | 292 |
// Where文字列作成 |
293 |
string strWhere = CreatePrimarykeyString(NameCode);
|
|
293 |
StringBuilder strWhere = new StringBuilder();
|
|
294 | 294 |
try |
295 | 295 |
{ |
296 |
// Where文字列作成 |
|
297 |
strWhere.Append(CreatePrimarykeyString(DivCode, NameCode)); |
|
298 |
|
|
296 | 299 |
List<DivisionMaster> workList = new List<DivisionMaster>(); |
297 | 300 |
// データ読込 |
298 |
if (SelectAction(strWhere, ref workList, bConnect)) |
|
301 |
if (!SelectAction(strWhere.ToString(), ref workList, bConnect)) return false; |
|
302 |
// 無い場合は処理しない |
|
303 |
if (workList.Count == 0) return true; |
|
304 |
|
|
305 |
// 削除フラグ |
|
306 |
workList[0].DeleteFlg = (int)CommonDefine.DataRowDeleteDef.Deleted; |
|
307 |
// データ更新 |
|
308 |
if (!UpdateAction(strWhere.ToString(), workList[0], bConnect)) |
|
299 | 309 |
{ |
300 |
if (workList.Count == 0) return true; |
|
310 |
rollback(); |
|
311 |
return false; |
|
312 |
} |
|
301 | 313 |
|
302 |
// 削除フラグ |
|
303 |
workList[0].DeleteFlg = 1; |
|
304 |
// データ更新 |
|
305 |
if (!UpdateAction(strWhere, workList[0], bConnect)) |
|
306 |
{ |
|
307 |
rollback(); |
|
308 |
return false; |
|
309 |
} |
|
314 |
return true; |
|
315 |
} |
|
316 |
catch (Exception ex) |
|
317 |
{ |
|
318 |
logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strWhere.ToString()); |
|
319 |
return false; |
|
320 |
} |
|
321 |
} |
|
322 |
#endregion |
|
323 |
|
|
324 |
#region 1項目の更新 |
|
325 |
/// <summary> |
|
326 |
/// 1項目の更新 |
|
327 |
/// </summary> |
|
328 |
/// <returns></returns> |
|
329 |
public bool UpdateFeild(int DivCode, int NameCode, int FeildNo, object value, bool bConnect = true) |
|
330 |
{ |
|
331 |
StringBuilder strcmd = new StringBuilder(); |
|
332 |
try |
|
333 |
{ |
|
334 |
strcmd.Append("UPDATE DivisionMaster"); |
|
335 |
|
|
336 |
strcmd.Append(" SET"); |
|
337 |
switch (FeildNo) |
|
338 |
{ |
|
339 |
case (int)NameColumn.DivisionCode: |
|
340 |
strcmd.AppendFormat(" DivisionCode = {0}", ((int)value).ToString()); |
|
341 |
break; |
|
342 |
case (int)NameColumn.NameCode: |
|
343 |
strcmd.AppendFormat(" NameCode = {0}", ((int)value).ToString()); |
|
344 |
break; |
|
345 |
case (int)NameColumn.DisplayOrder: |
|
346 |
strcmd.AppendFormat(" DisplayOrder = {0}", ((int)value).ToString()); |
|
347 |
break; |
|
348 |
case (int)NameColumn.NameString: |
|
349 |
strcmd.AppendFormat(" NameString = '{0}'", value.ToString()); |
|
350 |
break; |
|
351 |
case (int)NameColumn.DeleteFlg: |
|
352 |
strcmd.AppendFormat(" DeleteFlg = {0}", ((int)value).ToString()); |
|
353 |
break; |
|
310 | 354 |
} |
355 |
|
|
356 |
strcmd.Append(", UpdateDate = NOW()"); |
|
357 |
strcmd.Append(CreatePrimarykeyString(DivCode, NameCode)); |
|
358 |
|
|
359 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false; |
|
360 |
|
|
311 | 361 |
return true; |
312 | 362 |
} |
313 | 363 |
catch (Exception ex) |
314 | 364 |
{ |
315 |
logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strWhere);
|
|
365 |
logger.ErrorFormat("システムエラー:{0}:{1}:{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
316 | 366 |
return false; |
317 | 367 |
} |
318 | 368 |
} |
... | ... | |
365 | 415 |
try |
366 | 416 |
{ |
367 | 417 |
// SQL作成 |
368 |
strcmd.AppendFormat("SELECT IFNULL(MAX(NameCode), 0) FROM DivisionMaster{0}", AddSQLString); |
|
418 |
strcmd.AppendFormat("SELECT IFNULL(MAX(NameCode), 0) FROM DivisionMaster {0}", AddSQLString);
|
|
369 | 419 |
|
370 | 420 |
// SQL実行 |
371 | 421 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return iRet; |
branches/src/ProcessManagement/ProcessManagement/DataModel/PersonExpensesCost.cs | ||
---|---|---|
6 | 6 |
namespace ProcessManagement.DataModel |
7 | 7 |
{ |
8 | 8 |
/// <summary> |
9 |
/// 経費退避クラス(台帳一覧で使用)
|
|
9 |
/// 交通費・購入品退避クラス(台帳一覧で使用)
|
|
10 | 10 |
/// </summary> |
11 | 11 |
public class PersonExpensesCost |
12 | 12 |
{ |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalList/FrmApprovalListAuxiliary.cs | ||
---|---|---|
290 | 290 |
m_bInitFlg = true; |
291 | 291 |
try |
292 | 292 |
{ |
293 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(this.cmbDepartment_SelectedIndexChanged); |
|
294 | 293 |
int nBeforeCode = CommonMotions.cnvInt(cmbDepartment.SelectedValue); |
295 | 294 |
|
296 |
cmbDepartment.DataSource = null; |
|
297 |
cmbDepartment.Items.Clear(); |
|
298 |
cmbDepartment.Text = ""; |
|
299 |
|
|
300 | 295 |
int nTargetCount = (int)numUDConstPro.Value; |
301 | 296 |
// ?????}?X?^?????????? |
302 | 297 |
StringBuilder strSQL = new StringBuilder(); |
... | ... | |
317 | 312 |
ConstructionDataList.Add(keyval); |
318 | 313 |
} |
319 | 314 |
|
315 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(this.cmbDepartment_SelectedIndexChanged); |
|
316 |
|
|
317 |
cmbDepartment.DataSource = null; |
|
318 |
cmbDepartment.Items.Clear(); |
|
319 |
cmbDepartment.Text = ""; |
|
320 |
|
|
320 | 321 |
// ?R???{?{?b?N?X?????\?? |
321 | 322 |
ComboBoxAction.InitDataSetCombBox(cmbDepartment, ConstructionDataList); |
322 | 323 |
|
... | ... | |
395 | 396 |
m_bInitFlg = true; |
396 | 397 |
try |
397 | 398 |
{ |
398 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(this.cmbConstructionPerson_SelectedIndexChanged); |
|
399 | 399 |
int nBeforeCode = CommonMotions.cnvInt(cmbConstructionPerson.SelectedValue); |
400 | 400 |
if (CommonMotions.cnvInt(cmbDepartment.SelectedValue) < 1) nBeforeCode = 0; |
401 | 401 |
|
402 |
cmbConstructionPerson.DataSource = null; |
|
403 |
cmbConstructionPerson.Items.Clear(); |
|
404 |
cmbConstructionPerson.Text = ""; |
|
405 |
|
|
406 | 402 |
int nTargetCount = (int)numUDConstPro.Value; |
407 | 403 |
int DepartmentCode = GetDepartmentCode(); |
408 | 404 |
StringBuilder strSQL = new StringBuilder(); |
... | ... | |
424 | 420 |
ConstructionDataList.Add(keyval); |
425 | 421 |
} |
426 | 422 |
|
423 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(this.cmbConstructionPerson_SelectedIndexChanged); |
|
424 |
|
|
425 |
cmbConstructionPerson.DataSource = null; |
|
426 |
cmbConstructionPerson.Items.Clear(); |
|
427 |
cmbConstructionPerson.Text = ""; |
|
428 |
|
|
427 | 429 |
// ?R???{?{?b?N?X?????\?? |
428 | 430 |
ComboBoxAction.InitDataSetCombBox(cmbConstructionPerson, ConstructionDataList); |
429 | 431 |
|
... | ... | |
1215 | 1217 |
int minval = 0; |
1216 | 1218 |
int maxval = 0; |
1217 | 1219 |
CommonMotions.GetPeriodYearMinMax(ref minval, ref maxval); |
1220 |
|
|
1221 |
this.numUDConstPro.ValueChanged -= new System.EventHandler(this.numUDConstPro_ValueChanged); |
|
1218 | 1222 |
numUDConstPro.Minimum = minval; |
1219 | 1223 |
numUDConstPro.Maximum = maxval; |
1220 | 1224 |
numUDConstPro.Value = CommonMotions.GetPeriodYear(); |
1221 |
|
|
1225 |
this.numUDConstPro.ValueChanged += new System.EventHandler(this.numUDConstPro_ValueChanged); |
|
1222 | 1226 |
} |
1223 | 1227 |
catch (Exception ex) |
1224 | 1228 |
{ |
... | ... | |
1275 | 1279 |
IOMPersonInCharge PersonDB = new IOMPersonInCharge(); |
1276 | 1280 |
try |
1277 | 1281 |
{ |
1278 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(cmbDepartment_SelectedIndexChanged); |
|
1279 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(cmbConstructionPerson_SelectedIndexChanged); |
|
1280 |
|
|
1281 | 1282 |
// ?R???{?{?b?N?X???I??S??????????? |
1282 | 1283 |
int PersonCode = GetConstructionPersonCode(); |
1283 | 1284 |
if (PersonCode < 1) return true; |
... | ... | |
1303 | 1304 |
|
1304 | 1305 |
// ?????R???{?{?b?N?X??????R?[?h?Z?b?g |
1305 | 1306 |
SetcmbDepartment(); |
1307 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(cmbDepartment_SelectedIndexChanged); |
|
1306 | 1308 |
cmbDepartment.SelectedValue = PersonRec.DepartmentCode; |
1309 |
|
|
1307 | 1310 |
SetcmbPersons(); // ?S????R???{?{?b?N?X??X |
1311 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(cmbConstructionPerson_SelectedIndexChanged); |
|
1308 | 1312 |
cmbConstructionPerson.SelectedValue = PersonCode; |
1309 | 1313 |
|
1310 | 1314 |
return true; |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstractionList/FrmConstructionListAuxiliary.cs | ||
---|---|---|
1453 | 1453 |
int minval = 0; |
1454 | 1454 |
int maxval = 0; |
1455 | 1455 |
CommonMotions.GetPeriodYearMinMax(ref minval, ref maxval); |
1456 |
|
|
1457 |
this.numUDConstPro.ValueChanged -= new System.EventHandler(this.numUDConstPro_ValueChanged); |
|
1456 | 1458 |
numUDConstPro.Minimum = minval; |
1457 | 1459 |
numUDConstPro.Maximum = maxval; |
1458 | 1460 |
numUDConstPro.Value = CommonMotions.GetPeriodYear(); |
1459 |
|
|
1461 |
this.numUDConstPro.ValueChanged += new System.EventHandler(this.numUDConstPro_ValueChanged); |
|
1460 | 1462 |
} |
1461 | 1463 |
catch (Exception ex) |
1462 | 1464 |
{ |
... | ... | |
2084 | 2086 |
m_initDataLoad = true; |
2085 | 2087 |
try |
2086 | 2088 |
{ |
2087 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(cmbDepartment_SelectedIndexChanged); |
|
2088 | 2089 |
int nBeforeCode = CommonMotions.cnvInt(cmbDepartment.SelectedValue); |
2089 | 2090 |
|
2090 |
cmbDepartment.DataSource = null; |
|
2091 |
cmbDepartment.Items.Clear(); |
|
2092 |
cmbDepartment.Text = ""; |
|
2093 |
|
|
2094 | 2091 |
int nTargetCount = (int)numUDConstPro.Value; |
2095 | 2092 |
// ?????}?X?^?????????? |
2096 | 2093 |
StringBuilder strSQL = new StringBuilder(); |
... | ... | |
2111 | 2108 |
ConstructionDataList.Add(keyval); |
2112 | 2109 |
} |
2113 | 2110 |
|
2111 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(cmbDepartment_SelectedIndexChanged); |
|
2112 |
|
|
2113 |
cmbDepartment.DataSource = null; |
|
2114 |
cmbDepartment.Items.Clear(); |
|
2115 |
cmbDepartment.Text = ""; |
|
2116 |
|
|
2114 | 2117 |
// ?R???{?{?b?N?X?????\?? |
2115 | 2118 |
ComboBoxAction.InitDataSetCombBox(cmbDepartment, ConstructionDataList); |
2116 | 2119 |
|
... | ... | |
2140 | 2143 |
m_initDataLoad = true; |
2141 | 2144 |
try |
2142 | 2145 |
{ |
2143 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(cmbConstructionPerson_SelectedIndexChanged); |
|
2144 | 2146 |
int nBeforeCode = CommonMotions.cnvInt(cmbConstructionPerson.SelectedValue); |
2145 | 2147 |
if (CommonMotions.cnvInt(cmbDepartment.SelectedValue) < 1) nBeforeCode = 0; |
2146 | 2148 |
|
2147 |
cmbConstructionPerson.DataSource = null; |
|
2148 |
cmbConstructionPerson.Items.Clear(); |
|
2149 |
cmbConstructionPerson.Text = ""; |
|
2150 |
|
|
2151 | 2149 |
int nTargetCount = (int)numUDConstPro.Value; |
2152 | 2150 |
int DepartmentCode = GetDepartmentCode(); |
2153 | 2151 |
StringBuilder strSQL = new StringBuilder(); |
... | ... | |
2169 | 2167 |
ConstructionDataList.Add(keyval); |
2170 | 2168 |
} |
2171 | 2169 |
|
2170 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(cmbConstructionPerson_SelectedIndexChanged); |
|
2171 |
|
|
2172 |
cmbConstructionPerson.DataSource = null; |
|
2173 |
cmbConstructionPerson.Items.Clear(); |
|
2174 |
cmbConstructionPerson.Text = ""; |
|
2175 |
|
|
2172 | 2176 |
// ?R???{?{?b?N?X?????\?? |
2173 | 2177 |
ComboBoxAction.InitDataSetCombBox(cmbConstructionPerson, ConstructionDataList); |
2174 | 2178 |
|
2175 | 2179 |
cmbConstructionPerson.SelectedValue= nBeforeCode; |
2176 |
|
|
2177 | 2180 |
} |
2178 | 2181 |
catch (Exception ex) |
2179 | 2182 |
{ |
... | ... | |
2198 | 2201 |
IOMPersonInCharge PersonDB = new IOMPersonInCharge(); |
2199 | 2202 |
try |
2200 | 2203 |
{ |
2201 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(cmbDepartment_SelectedIndexChanged); |
|
2202 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(cmbConstructionPerson_SelectedIndexChanged); |
|
2203 |
|
|
2204 | 2204 |
// ?R???{?{?b?N?X???I??S??????????? |
2205 | 2205 |
int PersonCode = GetConstructionPersonCode(); |
2206 | 2206 |
if (PersonCode < 1) return true; |
... | ... | |
2226 | 2226 |
|
2227 | 2227 |
// ?????R???{?{?b?N?X??????R?[?h?Z?b?g |
2228 | 2228 |
SetcmbDepartment(); |
2229 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(cmbDepartment_SelectedIndexChanged); |
|
2229 | 2230 |
cmbDepartment.SelectedValue = PersonRec.DepartmentCode; |
2231 |
|
|
2230 | 2232 |
SetcmbPersons(); // ?S????R???{?{?b?N?X??X |
2233 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(cmbConstructionPerson_SelectedIndexChanged); |
|
2231 | 2234 |
cmbConstructionPerson.SelectedValue = PersonCode; |
2232 | 2235 |
|
2233 | 2236 |
return true; |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionBaseInfo/FrmConstructionBaseInfoAuxiliary.cs | ||
---|---|---|
2589 | 2589 |
try |
2590 | 2590 |
{ |
2591 | 2591 |
// ?????}?X?^???? |
2592 |
string strSQL2 = " Where DeleteFlg = 0 Order By DisplayOrder ASC"; |
|
2592 |
StringBuilder strSQL = new StringBuilder(); |
|
2593 |
strSQL.AppendFormat(" Where DeleteFlg = {0} Order By DisplayOrder ASC", (int)CommonDefine.DataRowDeleteDef.Exists); |
|
2593 | 2594 |
// ?????}?X?^??? |
2594 |
if (!dmDB.SelectAction(strSQL2, ref dmList)) return;
|
|
2595 |
if (!dmDB.SelectAction(strSQL.ToString(), ref dmList)) return;
|
|
2595 | 2596 |
// ?f?[?^?\?? |
2596 | 2597 |
List<KeyValuePair<int, string>> DataList = new List<KeyValuePair<int, string>>(); |
2597 | 2598 |
DataList.Add(new KeyValuePair<int, string>(0, "")); |
... | ... | |
2604 | 2605 |
|
2605 | 2606 |
DataList.Add(new KeyValuePair<int, string>(0, "")); |
2606 | 2607 |
// ?S????}?X?^???? |
2607 |
string strSQL = " Where DeleteFlg = 0 Order By DisplayOrder ASC, PersonCode ASC"; |
|
2608 |
strSQL.Clear(); |
|
2609 |
strSQL.AppendFormat(" Where DeleteFlg = {0} Order By DisplayOrder ASC, PersonCode ASC", (int)CommonDefine.DataRowDeleteDef.Exists); |
|
2608 | 2610 |
// ?S????}?X?^??? |
2609 |
if (!picDB.SelectAction(strSQL, ref workList)) return; |
|
2611 |
if (!picDB.SelectAction(strSQL.ToString(), ref workList)) return;
|
|
2610 | 2612 |
// ?f?[?^?\?? |
2611 | 2613 |
foreach (PersonInChargeMaster wrk in workList) |
2612 | 2614 |
{ |
... | ... | |
2642 | 2644 |
List<DivisionMaster> bvList = new List<DivisionMaster>(); |
2643 | 2645 |
|
2644 | 2646 |
// Value????Key?????? |
2645 |
//string DivisionName = CommonDefine.DivisionMasterCode[1];
|
|
2646 |
//int DivisionCode = CommonDefine.DivisionMasterCode.First(x => x.Value == DivisionName).Key;
|
|
2647 |
string strSQL = dvDB.CreatePrimarykeyString((int)DivisionMaster.DivisionMasterCodeDef.OrderDivision) + " And DeleteFlg = 0 ORDER BY DISPLAYORDER";
|
|
2648 |
if (!dvDB.SelectAction(strSQL, ref bvList)) return; |
|
2647 |
StringBuilder strSQL = new StringBuilder();
|
|
2648 |
strSQL.Append(dvDB.CreatePrimarykeyString((int)DivisionMaster.DivisionMasterCodeDef.OrderDivision));
|
|
2649 |
strSQL.AppendFormat(" And DeleteFlg = {0} ORDER BY DISPLAYORDER", (int)CommonDefine.DataRowDeleteDef.Exists);
|
|
2650 |
if (!dvDB.SelectAction(strSQL.ToString(), ref bvList)) return;
|
|
2649 | 2651 |
if (bvList.Count == 0) return; |
2650 | 2652 |
|
2651 | 2653 |
List<KeyValuePair<int, string>> DataList = new List<KeyValuePair<int, string>>(); |
... | ... | |
2689 | 2691 |
int idivision = CommonMotions.cnvInt(cmbOrdersDivision.SelectedValue.ToString()); |
2690 | 2692 |
if (idivision == 0) return true; |
2691 | 2693 |
// ??????}?X?^?????????? |
2692 |
string strSQL = orDB.CreatePrimarykeyString(idivision) + " And DeleteFlg = 0 Order By DisplayOrder ASC"; |
|
2694 |
StringBuilder strSQL = new StringBuilder(); |
|
2695 |
strSQL.Append(orDB.CreatePrimarykeyString(idivision)); |
|
2696 |
strSQL.AppendFormat(" And DeleteFlg = {0} Order By DisplayOrder ASC", (int)CommonDefine.DataRowDeleteDef.Exists); |
|
2693 | 2697 |
|
2694 | 2698 |
// ??????}?X?^??? |
2695 |
if (!orDB.SelectAction(strSQL, ref workList)) return false; |
|
2699 |
if (!orDB.SelectAction(strSQL.ToString(), ref workList)) return false;
|
|
2696 | 2700 |
|
2697 | 2701 |
List<KeyValuePair<int, string>> DataList = new List<KeyValuePair<int, string>>(); |
2698 | 2702 |
// ?f?[?^?\?? |
... | ... | |
2816 | 2820 |
{ |
2817 | 2821 |
List<ConstructionTypeMaster> typeList = new List<ConstructionTypeMaster>(); |
2818 | 2822 |
|
2819 |
string strSQL = " WHERE DeleteFlg = 0 ORDER BY DISPLAYORDER"; |
|
2823 |
StringBuilder strSQL = new StringBuilder(); |
|
2824 |
strSQL.AppendFormat(" WHERE DeleteFlg = {0} ORDER BY DISPLAYORDER", (int)CommonDefine.DataRowDeleteDef.Exists); |
|
2820 | 2825 |
|
2821 |
if (!TypeDB.SelectAction(strSQL, ref typeList)) return; |
|
2826 |
if (!TypeDB.SelectAction(strSQL.ToString(), ref typeList)) return;
|
|
2822 | 2827 |
if (typeList.Count == 0) return; |
2823 | 2828 |
|
2824 | 2829 |
List<KeyValuePair<int, string>> DataList = new List<KeyValuePair<int, string>>(); |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionJoin/FrmConstructionJoinAuxiliary.cs | ||
---|---|---|
258 | 258 |
m_bInitFlag = true; |
259 | 259 |
try |
260 | 260 |
{ |
261 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(cmbDepartment_SelectedIndexChanged); |
|
262 | 261 |
int nBeforeCode = CommonMotions.cnvInt(cmbDepartment.SelectedValue); |
263 | 262 |
|
264 |
cmbDepartment.DataSource = null; |
|
265 |
cmbDepartment.Items.Clear(); |
|
266 |
cmbDepartment.Text = ""; |
|
267 |
|
|
268 | 263 |
int nTargetCount = (int)numUDConstPro.Value; |
269 | 264 |
// 部署マスタを検索する |
270 | 265 |
StringBuilder strSQL = new StringBuilder(); |
... | ... | |
285 | 280 |
ConstructionDataList.Add(keyval); |
286 | 281 |
} |
287 | 282 |
|
283 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(cmbDepartment_SelectedIndexChanged); |
|
284 |
|
|
285 |
cmbDepartment.DataSource = null; |
|
286 |
cmbDepartment.Items.Clear(); |
|
287 |
cmbDepartment.Text = ""; |
|
288 |
|
|
288 | 289 |
// コンボボックス初期表示 |
289 | 290 |
ComboBoxAction.InitDataSetCombBox(cmbDepartment, ConstructionDataList); |
290 | 291 |
|
... | ... | |
314 | 315 |
m_bInitFlag = true; |
315 | 316 |
try |
316 | 317 |
{ |
317 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(cmbConstructionPerson_SelectedIndexChanged); |
|
318 | 318 |
int nBeforeCode = CommonMotions.cnvInt(cmbConstructionPerson.SelectedValue); |
319 | 319 |
if (CommonMotions.cnvInt(cmbDepartment.SelectedValue) < 1) nBeforeCode = 0; |
320 | 320 |
|
321 |
cmbConstructionPerson.DataSource = null; |
|
322 |
cmbConstructionPerson.Items.Clear(); |
|
323 |
cmbConstructionPerson.Text = ""; |
|
324 |
|
|
325 | 321 |
int nTargetCount = (int)numUDConstPro.Value; |
326 | 322 |
int DepartmentCode = GetDepartmentCode(); |
327 | 323 |
StringBuilder strSQL = new StringBuilder(); |
... | ... | |
343 | 339 |
ConstructionDataList.Add(keyval); |
344 | 340 |
} |
345 | 341 |
|
342 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(cmbConstructionPerson_SelectedIndexChanged); |
|
343 |
|
|
344 |
cmbConstructionPerson.DataSource = null; |
|
345 |
cmbConstructionPerson.Items.Clear(); |
|
346 |
cmbConstructionPerson.Text = ""; |
|
347 |
|
|
346 | 348 |
// コンボボックス初期表示 |
347 | 349 |
ComboBoxAction.InitDataSetCombBox(cmbConstructionPerson, ConstructionDataList); |
348 | 350 |
|
349 | 351 |
cmbConstructionPerson.SelectedValue = nBeforeCode; |
350 |
|
|
351 | 352 |
} |
352 | 353 |
catch (Exception ex) |
353 | 354 |
{ |
... | ... | |
373 | 374 |
IOMPersonInCharge PersonDB = new IOMPersonInCharge(); |
374 | 375 |
try |
375 | 376 |
{ |
376 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(cmbDepartment_SelectedIndexChanged); |
|
377 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(cmbConstructionPerson_SelectedIndexChanged); |
|
378 |
|
|
379 | 377 |
// コンボボックスより選択担当者を取得する |
380 | 378 |
int PersonCode = GetConstructionPersonCode(); |
381 | 379 |
if (PersonCode < 1) return true; |
... | ... | |
401 | 399 |
|
402 | 400 |
// 部署コンボボックスへ部署コードセット |
403 | 401 |
SetcmbDepartment(); |
402 |
cmbDepartment.SelectedIndexChanged -= new EventHandler(cmbDepartment_SelectedIndexChanged); |
|
404 | 403 |
cmbDepartment.SelectedValue = PersonRec.DepartmentCode; |
404 |
|
|
405 | 405 |
SetcmbPersons(); // 担当者コンボボックス変更 |
406 |
cmbConstructionPerson.SelectedIndexChanged -= new EventHandler(cmbConstructionPerson_SelectedIndexChanged); |
|
406 | 407 |
cmbConstructionPerson.SelectedValue = PersonCode; |
407 | 408 |
|
408 | 409 |
return true; |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedger/FrmConstructionLedger.cs | ||
---|---|---|
1018 | 1018 |
return; |
1019 | 1019 |
} |
1020 | 1020 |
|
1021 |
// 16????~??????????o???????
|
|
1021 |
// 16????O????o??
|
|
1022 | 1022 |
if (m_ConstructionBaseInfo.ConstructionPeriod < 16) |
1023 | 1023 |
{ // ???o?????????? |
1024 | 1024 |
m_ExpensesList.Add(new object[] { CommonDefine.BeforeExpenses[0].Key, CommonDefine.BeforeExpenses[0].Value }); |
... | ... | |
1027 | 1027 |
} |
1028 | 1028 |
else |
1029 | 1029 |
{ |
1030 |
// 16????~??????????o??????? |
|
1030 | 1031 |
// ?????????o????????? |
1031 | 1032 |
if (!GetExpensesList()) |
1032 | 1033 |
{ |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedgerList/FrmConstructionLedgerList.cs | ||
---|---|---|
26 | 26 |
//*----------------------------------------------------------------------------* |
27 | 27 |
namespace ProcessManagement.Forms.DataEntry |
28 | 28 |
{ |
29 |
public partial class FrmLedgerStatus : Form
|
|
29 |
public partial class FrmLedgerList : Form
|
|
30 | 30 |
{ |
31 | 31 |
#region ?g?p??` |
32 | 32 |
//log4net???O???g?p???? |
... | ... | |
41 | 41 |
private enum DispColumn |
42 | 42 |
{ |
43 | 43 |
/// <summary> |
44 |
/// ?? |
|
44 |
/// 0:??
|
|
45 | 45 |
/// </summary> |
46 | 46 |
No = 0, |
47 | 47 |
/// <summary> |
48 |
/// ??t???O |
|
48 |
/// 1:??t???O
|
|
49 | 49 |
/// </summary> |
50 | 50 |
ComplateFlg, |
51 | 51 |
/// <summary> |
52 |
/// ???? |
|
52 |
/// 2:????
|
|
53 | 53 |
/// </summary> |
54 | 54 |
Department, |
55 | 55 |
/// <summary> |
56 |
/// ?S????? |
|
56 |
/// 3:?S?????
|
|
57 | 57 |
/// </summary> |
58 | 58 |
PersonName, |
59 | 59 |
/// <summary> |
60 |
/// ?H???R?[?h |
|
60 |
/// 4:?H???R?[?h
|
|
61 | 61 |
/// </summary> |
62 | 62 |
SelectionCode, |
63 | 63 |
/// <summary> |
64 |
/// ?H?????? |
|
64 |
/// 5:?H??????
|
|
65 | 65 |
/// </summary> |
66 | 66 |
SelectionName, |
67 | 67 |
/// <summary> |
68 |
/// ?H???i????? |
|
68 |
/// 6:?H???i?????
|
|
69 | 69 |
/// </summary> |
70 | 70 |
ConstructionStatus, |
71 | 71 |
/// <summary> |
72 |
/// ????z |
|
72 |
/// 7:????z
|
|
73 | 73 |
/// </summary> |
74 | 74 |
OrdersDecisionPrice, |
75 | 75 |
/// <summary> |
76 |
/// ???o?? |
|
76 |
/// 8:???o??
|
|
77 | 77 |
/// </summary> |
78 | 78 |
CompanyExpenses, |
79 | 79 |
/// <summary> |
80 |
/// ?????o?? |
|
80 |
/// 9:?????o??
|
|
81 | 81 |
/// </summary> |
82 | 82 |
DepartmentExpenses, |
83 | 83 |
/// <summary> |
84 |
/// ?c??o?? |
|
84 |
/// 10:?c??o??
|
|
85 | 85 |
/// </summary> |
86 | 86 |
SalesExpenses, |
87 | 87 |
/// <summary> |
88 |
/// ???x???z |
|
88 |
/// 11:???x???z
|
|
89 | 89 |
/// </summary> |
90 | 90 |
TotalPayment, |
91 | 91 |
/// <summary> |
92 |
/// ?e?? |
|
92 |
/// 12:?e??
|
|
93 | 93 |
/// </summary> |
94 | 94 |
GrossProfit, |
95 | 95 |
/// <summary> |
96 |
/// ???^ |
|
96 |
/// 13:???^
|
|
97 | 97 |
/// </summary> |
98 | 98 |
Allowance, |
99 | 99 |
/// <summary> |
100 |
/// ?????v |
|
100 |
/// 14:?????v
|
|
101 | 101 |
/// </summary> |
102 | 102 |
NetProfit, |
103 | 103 |
} |
104 | 104 |
#endregion |
105 | 105 |
|
106 |
#region ?\???J?????O?? |
|
107 |
/// <summary> |
|
108 |
/// ?\???J?????O?? |
|
109 |
/// </summary> |
|
110 |
private enum DCFirstHalf |
|
111 |
{ |
|
112 |
/// <summary> |
|
113 |
/// 0:?? |
|
114 |
/// </summary> |
|
115 |
No = 0, |
|
116 |
/// <summary> |
|
117 |
/// 1:??t???O |
|
118 |
/// </summary> |
|
119 |
ComplateFlg, |
|
120 |
/// <summary> |
|
121 |
/// 2:???? |
|
122 |
/// </summary> |
|
123 |
Department, |
|
124 |
/// <summary> |
|
125 |
/// 3:?S????? |
|
126 |
/// </summary> |
|
127 |
PersonName, |
|
128 |
/// <summary> |
|
129 |
/// 4:?H???R?[?h |
|
130 |
/// </summary> |
|
131 |
SelectionCode, |
|
132 |
/// <summary> |
|
133 |
/// 5:?H?????? |
|
134 |
/// </summary> |
|
135 |
SelectionName, |
|
136 |
/// <summary> |
|
137 |
/// 6:?H???i????? |
|
138 |
/// </summary> |
|
139 |
ConstructionStatus, |
|
140 |
/// <summary> |
|
141 |
/// 7:????z |
|
142 |
/// </summary> |
|
143 |
OrdersDecisionPrice, |
|
144 |
} |
|
145 |
#endregion |
|
146 |
|
|
147 |
#region ?\???J?????? |
|
148 |
/// <summary> |
|
149 |
/// ?\???J?????? |
|
150 |
/// </summary> |
|
151 |
private enum DCLatterHalf |
|
152 |
{ |
|
153 |
/// <summary> |
|
154 |
/// 11:???x???z |
|
155 |
/// </summary> |
|
156 |
TotalPayment = -4, |
|
157 |
/// <summary> |
|
158 |
/// 12:?e?? |
|
159 |
/// </summary> |
|
160 |
GrossProfit = -3, |
|
161 |
/// <summary> |
|
162 |
/// 13:???^ |
|
163 |
/// </summary> |
|
164 |
Allowance = -2, |
|
165 |
/// <summary> |
|
166 |
/// 14:?????v |
|
167 |
/// </summary> |
|
168 |
NetProfit = -1, |
|
169 |
} |
|
170 |
#endregion |
|
171 |
|
|
106 | 172 |
#region ?s?I??F |
107 | 173 |
/// <summary> |
108 | 174 |
/// ?s?I??F |
... | ... | |
188 | 254 |
|
189 | 255 |
#region ??? |
190 | 256 |
/// <summary> |
191 |
/// ?t?B?[???h?l????t???O |
|
192 |
/// </summary> |
|
193 |
//private bool m_bChengeAns = false; |
|
194 |
|
|
195 |
/// <summary> |
|
196 | 257 |
/// ???????t???O |
197 | 258 |
/// </summary> |
198 | 259 |
private bool m_initDataLoad = true; |
... | ... | |
220 | 281 |
/// <summary> |
221 | 282 |
/// ?O???b?h?J?????T?C?Y |
222 | 283 |
/// </summary> |
223 |
int[] m_CellSize = null;
|
|
284 |
List<int> m_CellSize = new List<int>();
|
|
224 | 285 |
#endregion |
225 | 286 |
|
226 | 287 |
#region ?t?H?[???? |
... | ... | |
308 | 369 |
/// ?Y???H???S???? |
309 | 370 |
/// </summary> |
310 | 371 |
private PersonInChargeMaster m_PersonInChargeMaster = new PersonInChargeMaster(); |
372 |
|
|
373 |
/// <summary> |
|
374 |
/// ?\???o?????G???A |
|
375 |
/// </summary> |
|
376 |
List<KeyValuePair<int, string>> m_ExpList = new List<KeyValuePair<int, string>>(); |
|
377 |
List<DepartmentExpenses> m_DepExpList = new List<DepartmentExpenses>(); |
|
378 |
|
|
311 | 379 |
#endregion |
312 | 380 |
|
313 | 381 |
#region ?v???p?e?B |
... | ... | |
430 | 498 |
#endregion |
431 | 499 |
|
432 | 500 |
#region ?R???X?g???N?^ |
433 |
public FrmLedgerStatus()
|
|
501 |
public FrmLedgerList()
|
|
434 | 502 |
{ |
435 | 503 |
InitializeComponent(); |
436 | 504 |
} |
437 | 505 |
#endregion |
438 | 506 |
#region ?f?X?g???N?^ |
439 |
~FrmLedgerStatus()
|
|
507 |
~FrmLedgerList()
|
|
440 | 508 |
{ |
441 | 509 |
try |
442 | 510 |
{ |
... | ... | |
510 | 578 |
// ?R???{?{?b?N?X???C?x???g?Z?b?g |
511 | 579 |
SetControlEvent((int)EventDef.ConstPro | (int)EventDef.Person | (int)EventDef.Person); |
512 | 580 |
|
581 |
// ?O???b?h??????? |
|
582 |
SetDisplayObject(); |
|
583 |
|
|
513 | 584 |
SetInitnumUDConstPro(); |
514 | 585 |
// ?R???{?{?b?N?X?Z?b?g |
515 | 586 |
SetcmbDepartment(); |
... | ... | |
518 | 589 |
// ?R???{?{?b?N?X?????\?? |
519 | 590 |
InitCombBox(); |
520 | 591 |
|
521 |
// ?O???b?h??????? |
|
522 |
SetDisplayObject(); |
|
523 |
|
|
524 | 592 |
// ???O?C?????Z?b?g |
525 | 593 |
InitDepPersonCode(); |
526 | 594 |
|
... | ... | |
550 | 618 |
// ????s????????\?????? |
551 | 619 |
if (NextOtherCostExecute()) return; |
552 | 620 |
|
553 |
if (CommonMotions.chkCellBlank(CurRow.Cells[(int)DispColumn.SelectionCode].Value)) return;
|
|
554 |
if (CommonMotions.chkCellBlank(CurRow.Cells[(int)DispColumn.SelectionName].Value)) return;
|
|
621 |
if (CommonMotions.chkCellBlank(CurRow.Cells[(int)DCFirstHalf.SelectionCode].Value)) return;
|
|
622 |
if (CommonMotions.chkCellBlank(CurRow.Cells[(int)DCFirstHalf.SelectionName].Value)) return;
|
|
555 | 623 |
|
556 | 624 |
// ????s??O?????????? |
557 |
string strCode = CommonMotions.cnvString(CurRow.Cells[(int)DispColumn.SelectionCode].Value);
|
|
625 |
string strCode = CommonMotions.cnvString(CurRow.Cells[(int)DCFirstHalf.SelectionCode].Value);
|
|
558 | 626 |
if (CommonMotions.cnvInt(strCode.Replace("-", "")) == 0) return; |
559 | 627 |
|
560 | 628 |
// ?e?????N?? |
561 |
SubProcessExecute(CommonMotions.cnvIntFromStringCode(CurRow.Cells[(int)DispColumn.SelectionCode].Value.ToString(), "-"));
|
|
629 |
SubProcessExecute(CommonMotions.cnvIntFromStringCode(CurRow.Cells[(int)DCFirstHalf.SelectionCode].Value.ToString(), "-"));
|
|
562 | 630 |
} |
563 | 631 |
#endregion |
564 | 632 |
|
... | ... | |
758 | 826 |
|
759 | 827 |
// ?f?[?^?????????????? |
760 | 828 |
if (dgv.RowCount == 0) return; |
761 |
if (CommonMotions.chkCellBlank(CurRow.Cells[(int)DispColumn.SelectionCode].Value) &&
|
|
762 |
CommonMotions.chkCellBlank(CurRow.Cells[(int)DispColumn.SelectionName].Value))
|
|
829 |
if (CommonMotions.chkCellBlank(CurRow.Cells[(int)DCFirstHalf.SelectionCode].Value) &&
|
|
830 |
CommonMotions.chkCellBlank(CurRow.Cells[(int)DCFirstHalf.SelectionName].Value))
|
|
763 | 831 |
{ |
764 | 832 |
return; |
765 | 833 |
} |
766 | 834 |
else |
767 | 835 |
{ |
768 | 836 |
// ???v?s?????????? |
769 |
string strWork = CommonMotions.cnvString(CurRow.Cells[(int)DispColumn.SelectionName].Value);
|
|
837 |
string strWork = CommonMotions.cnvString(CurRow.Cells[(int)DCFirstHalf.SelectionName].Value);
|
|
770 | 838 |
bool bTitle = false; |
771 | 839 |
foreach (string strTitle in s_TotalTitleArray) |
772 | 840 |
{ |
branches/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ConstructionLedgerList/FrmConstructionLedgerList.designer.cs | ||
---|---|---|
1 | 1 |
namespace ProcessManagement.Forms.DataEntry |
2 | 2 |
{ |
3 |
partial class FrmLedgerStatus
|
|
3 |
partial class FrmLedgerList
|
|
4 | 4 |
{ |
5 | 5 |
/// <summary> |
6 | 6 |
/// 必要なデザイナ変数です。 |
... | ... | |
28 | 28 |
/// </summary> |
29 | 29 |
private void InitializeComponent() |
30 | 30 |
{ |
31 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle19 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
32 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle20 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
33 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle36 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
34 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle21 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
35 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle22 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
36 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle23 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
37 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle24 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
38 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle25 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
39 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle26 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
40 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle27 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
41 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle28 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
42 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle29 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
43 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle30 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
44 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle31 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
45 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle32 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
46 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle33 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
47 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle34 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
48 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle35 = 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 dataGridViewCellStyle18 = 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 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle13 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
45 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle14 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
46 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle15 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
47 |
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle16 = new System.Windows.Forms.DataGridViewCellStyle();
|
|
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 | 51 |
this.lblCellTotal = new System.Windows.Forms.Label(); |
... | ... | |
53 | 53 |
this.btnLedgerStatus = new System.Windows.Forms.Button(); |
54 | 54 |
this.btnOtherProc = new System.Windows.Forms.Button(); |
55 | 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 | 56 |
this.groupBox1 = new ProcessManagement.Forms.CustomControls.GroupBoxEx(); |
72 | 57 |
this.pnlPayroll = new System.Windows.Forms.Panel(); |
73 | 58 |
this.label6 = new System.Windows.Forms.Label(); |
... | ... | |
86 | 71 |
this.label20 = new System.Windows.Forms.Label(); |
87 | 72 |
this.label22 = new System.Windows.Forms.Label(); |
88 | 73 |
this.label23 = new System.Windows.Forms.Label(); |
74 |
this.label24 = new System.Windows.Forms.Label(); |
|
75 |
this.label25 = new System.Windows.Forms.Label(); |
|
89 | 76 |
this.lblStartDate = new System.Windows.Forms.Label(); |
90 | 77 |
this.lblEndDate = new System.Windows.Forms.Label(); |
91 | 78 |
this.lblTotalCalcValue = new System.Windows.Forms.Label(); |
92 | 79 |
this.lblTotalCalcValue1 = new System.Windows.Forms.Label(); |
93 | 80 |
this.lblTotalCalcValue2 = new System.Windows.Forms.Label(); |
94 |
this.label24 = new System.Windows.Forms.Label(); |
|
95 |
this.label25 = new System.Windows.Forms.Label(); |
|
96 | 81 |
this.lblCalcValue1 = new System.Windows.Forms.Label(); |
97 | 82 |
this.lblCalcValue2 = new System.Windows.Forms.Label(); |
98 | 83 |
this.lblCalcValue3 = new System.Windows.Forms.Label(); |
... | ... | |
107 | 92 |
this.label3 = new System.Windows.Forms.Label(); |
108 | 93 |
this.label5 = new System.Windows.Forms.Label(); |
109 | 94 |
this.label7 = new System.Windows.Forms.Label(); |
95 |
this.Column1 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
96 |
this.Column13 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
97 |
this.Column14 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
98 |
this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
99 |
this.Column3 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
100 |
this.Column4 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
101 |
this.Column15 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
102 |
this.Column5 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
103 |
this.Column6 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
104 |
this.Column7 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
105 |
this.Column8 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
106 |
this.Column9 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
107 |
this.Column10 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
108 |
this.Column11 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
109 |
this.Column12 = new System.Windows.Forms.DataGridViewTextBoxColumn(); |
|
110 | 110 |
((System.ComponentModel.ISupportInitialize)(this.dgvMaster)).BeginInit(); |
111 | 111 |
this.groupBox1.SuspendLayout(); |
112 | 112 |
this.pnlPayroll.SuspendLayout(); |
... | ... | |
192 | 192 |
// |
193 | 193 |
this.dgvMaster.AllowUserToAddRows = false; |
194 | 194 |
this.dgvMaster.AllowUserToDeleteRows = false; |
195 |
this.dgvMaster.AllowUserToResizeColumns = false; |
|
196 | 195 |
this.dgvMaster.AllowUserToResizeRows = false; |
197 |
dataGridViewCellStyle19.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192)))));
|
|
198 |
this.dgvMaster.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle19;
|
|
196 |
dataGridViewCellStyle1.BackColor = System.Drawing.Color.FromArgb(((int)(((byte)(192)))), ((int)(((byte)(255)))), ((int)(((byte)(192))))); |
|
197 |
this.dgvMaster.AlternatingRowsDefaultCellStyle = dataGridViewCellStyle1; |
|
199 | 198 |
this.dgvMaster.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) |
200 | 199 |
| System.Windows.Forms.AnchorStyles.Left) |
201 | 200 |
| System.Windows.Forms.AnchorStyles.Right))); |
202 | 201 |
this.dgvMaster.BackgroundColor = System.Drawing.Color.White; |
203 | 202 |
this.dgvMaster.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D; |
204 |
dataGridViewCellStyle20.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
|
|
205 |
dataGridViewCellStyle20.BackColor = System.Drawing.SystemColors.Control;
|
|
206 |
dataGridViewCellStyle20.Font = new System.Drawing.Font("MS 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
|
|
207 |
dataGridViewCellStyle20.ForeColor = System.Drawing.SystemColors.WindowText;
|
|
208 |
dataGridViewCellStyle20.SelectionBackColor = System.Drawing.SystemColors.Highlight;
|
|
209 |
dataGridViewCellStyle20.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
|
|
210 |
dataGridViewCellStyle20.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
|
|
211 |
this.dgvMaster.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle20;
|
|
203 |
dataGridViewCellStyle2.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; |
|
204 |
dataGridViewCellStyle2.BackColor = System.Drawing.SystemColors.Control; |
|
205 |
dataGridViewCellStyle2.Font = new System.Drawing.Font("MS 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128))); |
|
206 |
dataGridViewCellStyle2.ForeColor = System.Drawing.SystemColors.WindowText; |
|
207 |
dataGridViewCellStyle2.SelectionBackColor = System.Drawing.SystemColors.Highlight; |
|
208 |
dataGridViewCellStyle2.SelectionForeColor = System.Drawing.SystemColors.HighlightText; |
|
209 |
dataGridViewCellStyle2.WrapMode = System.Windows.Forms.DataGridViewTriState.True; |
|
210 |
this.dgvMaster.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle2; |
|
212 | 211 |
this.dgvMaster.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.DisableResizing; |
213 | 212 |
this.dgvMaster.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { |
214 | 213 |
this.Column1, |
... | ... | |
226 | 225 |
this.Column10, |
227 | 226 |
this.Column11, |
228 | 227 |
this.Column12}); |
229 |
dataGridViewCellStyle36.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
|
|
230 |
dataGridViewCellStyle36.BackColor = System.Drawing.SystemColors.Window;
|
|
231 |
dataGridViewCellStyle36.Font = new System.Drawing.Font("MS 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
|
|
232 |
dataGridViewCellStyle36.ForeColor = System.Drawing.SystemColors.ControlText;
|
|
233 |
dataGridViewCellStyle36.SelectionBackColor = System.Drawing.Color.LightSeaGreen;
|
|
234 |
dataGridViewCellStyle36.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
|
|
235 |
dataGridViewCellStyle36.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
|
|
236 |
this.dgvMaster.DefaultCellStyle = dataGridViewCellStyle36;
|
|
228 |
dataGridViewCellStyle18.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
|
|
229 |
dataGridViewCellStyle18.BackColor = System.Drawing.SystemColors.Window;
|
|
230 |
dataGridViewCellStyle18.Font = new System.Drawing.Font("MS 明朝", 11.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(128)));
|
|
231 |
dataGridViewCellStyle18.ForeColor = System.Drawing.SystemColors.ControlText;
|
|
232 |
dataGridViewCellStyle18.SelectionBackColor = System.Drawing.Color.LightSeaGreen;
|
|
233 |
dataGridViewCellStyle18.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
|
|
234 |
dataGridViewCellStyle18.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
|
|
235 |
this.dgvMaster.DefaultCellStyle = dataGridViewCellStyle18;
|
|
237 | 236 |
this.dgvMaster.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter; |
238 | 237 |
this.dgvMaster.EnableHeadersVisualStyles = false; |
239 | 238 |
this.dgvMaster.Location = new System.Drawing.Point(5, 168); |
... | ... | |
250 | 249 |
this.dgvMaster.Leave += new System.EventHandler(this.dgvMaster_Leave); |
251 | 250 |
this.dgvMaster.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dgvMaster_MouseUp); |
252 | 251 |
// |
253 |
// Column1 |
|
254 |
// |
|
255 |
dataGridViewCellStyle21.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; |
|
256 |
this.Column1.DefaultCellStyle = dataGridViewCellStyle21; |
|
257 |
this.Column1.Frozen = true; |
|
258 |
this.Column1.HeaderText = "№"; |
|
259 |
this.Column1.Name = "Column1"; |
|
260 |
this.Column1.ReadOnly = true; |
|
261 |
this.Column1.Resizable = System.Windows.Forms.DataGridViewTriState.False; |
|
262 |
this.Column1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
|
263 |
this.Column1.Width = 50; |
|
264 |
// |
|
265 |
// Column13 |
|
266 |
// |
|
267 |
dataGridViewCellStyle22.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; |
|
268 |
this.Column13.DefaultCellStyle = dataGridViewCellStyle22; |
|
269 |
this.Column13.Frozen = true; |
|
270 |
this.Column13.HeaderText = "済"; |
|
271 |
this.Column13.Name = "Column13"; |
|
272 |
this.Column13.ReadOnly = true; |
|
273 |
this.Column13.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
|
274 |
this.Column13.Width = 30; |
|
275 |
// |
|
276 |
// Column14 |
|
277 |
// |
|
278 |
dataGridViewCellStyle23.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; |
|
279 |
this.Column14.DefaultCellStyle = dataGridViewCellStyle23; |
|
280 |
this.Column14.Frozen = true; |
|
281 |
this.Column14.HeaderText = "部署"; |
|
282 |
this.Column14.Name = "Column14"; |
|
283 |
this.Column14.ReadOnly = true; |
|
284 |
// |
|
285 |
// Column2 |
|
286 |
// |
|
287 |
dataGridViewCellStyle24.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; |
|
288 |
this.Column2.DefaultCellStyle = dataGridViewCellStyle24; |
|
289 |
this.Column2.Frozen = true; |
|
290 |
this.Column2.HeaderText = "担当者名"; |
|
291 |
this.Column2.Name = "Column2"; |
|
292 |
this.Column2.ReadOnly = true; |
|
293 |
this.Column2.Resizable = System.Windows.Forms.DataGridViewTriState.False; |
|
294 |
this.Column2.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
|
295 |
// |
|
296 |
// Column3 |
|
297 |
// |
|
298 |
dataGridViewCellStyle25.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter; |
|
299 |
this.Column3.DefaultCellStyle = dataGridViewCellStyle25; |
|
300 |
this.Column3.Frozen = true; |
|
301 |
this.Column3.HeaderText = "工事コード"; |
|
302 |
this.Column3.Name = "Column3"; |
|
303 |
this.Column3.ReadOnly = true; |
|
304 |
this.Column3.Resizable = System.Windows.Forms.DataGridViewTriState.False; |
|
305 |
this.Column3.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
|
306 |
this.Column3.Visible = false; |
|
307 |
this.Column3.Width = 5; |
|
308 |
// |
|
309 |
// Column4 |
|
310 |
// |
|
311 |
dataGridViewCellStyle26.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft; |
|
312 |
this.Column4.DefaultCellStyle = dataGridViewCellStyle26; |
|
313 |
this.Column4.Frozen = true; |
|
314 |
this.Column4.HeaderText = "工 事 名 称"; |
|
315 |
this.Column4.Name = "Column4"; |
|
316 |
this.Column4.ReadOnly = true; |
|
317 |
this.Column4.Resizable = System.Windows.Forms.DataGridViewTriState.False; |
|
318 |
this.Column4.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable; |
|
319 |
this.Column4.Width = 210; |
|
320 |
// |
他の形式にエクスポート: Unified diff