リビジョン 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("ＭＳ 明朝", 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("ＭＳ 明朝", 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("ＭＳ 明朝", 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("ＭＳ 明朝", 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