リビジョン 490
協力会社マスタ：法人名称位置定義を協力会社マスタへ移動
サブ画面呼出終了時フォームクロース処理修正
業者支払通知実装中
Web入力請求書実装中
業者支払一覧実装
SQL'*'対応
| trunk/src/DataCheckExcute/DataCheckExcute/Common/Process/ClsExcute.cs | ||
|---|---|---|
| 99 | 99 |
OnHandVolume = 55, // 55:手持工事高一覧 |
| 100 | 100 |
DRNoticeCalender = 56, // 56:勤怠届カレンダー |
| 101 | 101 |
PurchaseOrderList = 57, // 57:注文書入力一覧 |
| 102 |
WebInputBillingList = 58, // 58:Web業者請求データ一覧 |
|
| 103 |
PaymentNotice = 59, // 59:支払通知書印刷 |
|
| 102 | 104 |
} |
| 103 | 105 |
#endregion |
| 104 | 106 |
|
| ... | ... | |
| 120 | 122 |
Orderers = 110, // 110:発注者マスタ |
| 121 | 123 |
BusinessType = 111, // 111:法人格マスタ |
| 122 | 124 |
ApprovalRouteList = 112, // 112:承認経路一覧 |
| 123 |
//Expenses = 113, // 113:経費率マスタ
|
|
| 125 |
Expenses = 113, // 113:経費率マスタ（---------- ※廃止 ----------）
|
|
| 124 | 126 |
SubContrItem = 114, // 114:協力会社工種マスタ |
| 125 | 127 |
Calender = 115, // 115:会社休日マスタ |
| 126 | 128 |
VehicleMaster = 116, // 116:車両マスタ |
| ... | ... | |
| 146 | 148 |
WorkingTime = 136, // 136:就業時間マスタ |
| 147 | 149 |
EvalScore = 137, // 137:評価点数登録 |
| 148 | 150 |
AverageScore = 138, // 138:評価点一覧確認 |
| 151 |
CalcCoefficient = 139, // 139:共通費計算係数マスタ |
|
| 149 | 152 |
} |
| 150 | 153 |
#endregion |
| 151 | 154 |
|
| ... | ... | |
| 155 | 158 |
/// </summary> |
| 156 | 159 |
public enum SubFormExecuteNo |
| 157 | 160 |
{
|
| 158 |
MessageWriter = 201, // 201:掲示板入力(新バージョン)
|
|
| 161 |
MessageWriter = 201, // 201:掲示板入力 |
|
| 159 | 162 |
MessageReader = 202, // 202:掲示板読込 |
| 160 | 163 |
ActionSchdule = 203, // 203:行動予定入力 |
| 161 | 164 |
VehicleSchdule = 204, // 204:車両予約入力 |
| ... | ... | |
| 168 | 171 |
} |
| 169 | 172 |
#endregion |
| 170 | 173 |
|
| 174 |
#region 経営情報プロセス処理番号 |
|
| 175 |
/// <summary> |
|
| 176 |
/// 経営情報プロセス処理番号 |
|
| 177 |
/// </summary> |
|
| 178 |
public enum MISExecuteNo |
|
| 179 |
{
|
|
| 180 |
SalesConfirm = 301, // 301:売上一覧確認 |
|
| 181 |
EvalScore = 302, // 302:評価点数登録 |
|
| 182 |
AverageScore = 303, // 303:評価点一覧確認 |
|
| 183 |
SalesGraph = 304, // 304:売上グラフ |
|
| 184 |
QuarterlySales = 305, // 305:月別売上計算表 |
|
| 185 |
} |
|
| 186 |
#endregion |
|
| 187 |
|
|
| 171 | 188 |
#region 起動プロセス処理番号（固定処理） |
| 172 | 189 |
/// <summary> |
| 173 | 190 |
/// 起動プロセス処理番号（固定処理） |
| ... | ... | |
| 282 | 299 |
{ (int)ProcessExecuteNo.OnHandVolume, "手持工事高－印刷" },
|
| 283 | 300 |
{ (int)ProcessExecuteNo.DRNoticeCalender, "勤怠届カレンダー－表示" },
|
| 284 | 301 |
{ (int)ProcessExecuteNo.PurchaseOrderList, "注文書入力一覧－表示" },
|
| 302 |
{ (int)ProcessExecuteNo.WebInputBillingList, "Web業者請求データ一覧－表示" },
|
|
| 303 |
{ (int)ProcessExecuteNo.PaymentNotice, "支払通知書印刷－印刷" },
|
|
| 285 | 304 |
}; |
| 286 |
|
|
| 287 | 305 |
#endregion |
| 288 | 306 |
|
| 289 | 307 |
#region マスタメンテンナス処理名称 |
| ... | ... | |
| 329 | 347 |
{ (int)MaintenanceExecuteNo.WorkingTime, "就業時間マスタ" }, // 136
|
| 330 | 348 |
{ (int)MaintenanceExecuteNo.EvalScore, "評価点数登録" }, // 137
|
| 331 | 349 |
{ (int)MaintenanceExecuteNo.AverageScore, "評価点一覧確認" }, // 138
|
| 350 |
{ (int)MaintenanceExecuteNo.CalcCoefficient, "共通費計算係数マスタ" }, // 139
|
|
| 332 | 351 |
}; |
| 333 | 352 |
#endregion |
| 334 | 353 |
|
| ... | ... | |
| 350 | 369 |
}; |
| 351 | 370 |
#endregion |
| 352 | 371 |
|
| 372 |
#region 経営情報プロセス処理名称 |
|
| 373 |
/// <summary> |
|
| 374 |
/// 経営情報プロセス処理名称 |
|
| 375 |
/// </summary> |
|
| 376 |
public static Dictionary<int, string> MISExecuteName = new Dictionary<int, string>() {
|
|
| 377 |
{ (int)MISExecuteNo.SalesConfirm, "売上一覧確認" },
|
|
| 378 |
{ (int)MISExecuteNo.EvalScore, "評価点数登録" },
|
|
| 379 |
{ (int)MISExecuteNo.AverageScore, "評価点一覧確認" },
|
|
| 380 |
{ (int)MISExecuteNo.SalesGraph, "売上グラフ－表示" },
|
|
| 381 |
{ (int)MISExecuteNo.QuarterlySales, "月別売上計算表－表示" },
|
|
| 382 |
}; |
|
| 383 |
#endregion |
|
| 384 |
|
|
| 353 | 385 |
#region 承認処理定義一覧 |
| 354 | 386 |
/// <summary> |
| 355 | 387 |
/// 承認処理定義一覧 |
| trunk/src/DataCheckExcute/DataCheckExcute/Common/Process/ClsSystemOnceExecute.cs | ||
|---|---|---|
| 550 | 550 |
// 工事基本情報を期限テーブルに設定している状態分取得する |
| 551 | 551 |
StringBuilder strSQL = new StringBuilder(); |
| 552 | 552 |
|
| 553 |
strSQL.Append("Select * From constructionbaseinfo As Atbl");
|
|
| 554 |
strSQL.Append(" Left Join PeriodAvoidance As Ctbl");
|
|
| 555 |
strSQL.Append(" On Ctbl.ConstructionCode = Atbl.ConstructionCode");
|
|
| 556 |
strSQL.Append(" And Ctbl.ConstructionStatusFlg = Atbl.ConstructionStatusFlg");
|
|
| 553 |
strSQL.Append("Select ");
|
|
| 554 |
strSQL.Append(IOConstructionBaseInfo.CreateFieldNameList("Atbl."));
|
|
| 555 |
strSQL.Append(", ");
|
|
| 556 |
strSQL.Append(IOPeriodAvoidance.CreateFieldNameList("Ctbl."));
|
|
| 557 |
strSQL.Append(" From constructionbaseinfo As Atbl");
|
|
| 558 |
strSQL.Append(" Left Join PeriodAvoidance As Ctbl");
|
|
| 559 |
strSQL.Append(" On Ctbl.ConstructionCode = Atbl.ConstructionCode");
|
|
| 560 |
strSQL.Append(" And Ctbl.ConstructionStatusFlg = Atbl.ConstructionStatusFlg");
|
|
| 557 | 561 |
strSQL.Append(" WHERE Atbl.CONSTRUCTIONSTATUSFLG IN (SELECT DISTINCT A1.CONSTRUCTIONSTATUSFLG FROM TERMMASTER A1)");
|
| 558 | 562 |
strSQL.Append(" AND NOT EXISTS (SELECT * From PeriodAvoidance As Btbl");
|
| 559 | 563 |
strSQL.Append(" Where Btbl.ConstructionCode = Atbl.ConstructionCode");
|
| ... | ... | |
| 583 | 587 |
bool procflg = true; |
| 584 | 588 |
ConstructionBaseInfo wrkBaseRec = new ConstructionBaseInfo(); |
| 585 | 589 |
PeriodAvoidance wrkAvoRec = new PeriodAvoidance(); |
| 586 |
int offset = Enum.GetNames(typeof(IOConstructionBaseInfo.TableColumn)).Length + 1;
|
|
| 590 |
int offset = Enum.GetNames(typeof(IOConstructionBaseInfo.TableColumn)).Length; |
|
| 587 | 591 |
// 経過日数分処理を行う |
| 588 | 592 |
for (int ix = 0; ix < diffDays; ix++) |
| 589 | 593 |
{
|
| ... | ... | |
| 1334 | 1338 |
{
|
| 1335 | 1339 |
StringBuilder strSQL = new StringBuilder(); |
| 1336 | 1340 |
// 就業終了日が今日より小さくて削除されていないデータを検索する |
| 1337 |
strSQL.Append("Select * From personinchargemaster");
|
|
| 1341 |
strSQL.Append("Select ");
|
|
| 1342 |
strSQL.Append(IOMPersonInCharge.CreateFieldNameList()); |
|
| 1343 |
strSQL.Append(" From personinchargemaster");
|
|
| 1338 | 1344 |
strSQL.AppendFormat(" Where (DATE(EndDate) != DATE('{0}')", DateTime.MinValue.ToShortDateString());
|
| 1339 | 1345 |
strSQL.Append(" And DATE(EndDate) < DATE(NOW()))");
|
| 1340 | 1346 |
strSQL.AppendFormat(" And DeleteFlg = {0}",(int)CommonDefine.DataDeleteDef.Exists);
|
| ... | ... | |
| 1576 | 1582 |
{
|
| 1577 | 1583 |
StringBuilder strSQL = new StringBuilder(); |
| 1578 | 1584 |
// 本日以前に移動が対象者 |
| 1579 |
strSQL.Append("Select * From personinchargemaster As A");
|
|
| 1580 |
strSQL.Append(" , (Select * From chgchargedep As BA");
|
|
| 1585 |
strSQL.Append("Select");
|
|
| 1586 |
strSQL.Append(IOMPersonInCharge.CreateFieldNameList("A."));
|
|
| 1587 |
strSQL.Append(", B.*");
|
|
| 1588 |
strSQL.Append(" From personinchargemaster As A");
|
|
| 1589 |
strSQL.AppendFormat(", (Select {0} From chgchargedep As BA", IOMChgChargeDep.CreateFieldNameList("BA."));
|
|
| 1581 | 1590 |
strSQL.Append(" Where (BA.PersonCode, BA.StartDate)");
|
| 1582 | 1591 |
strSQL.Append(" in (Select BB.PersonCode, MAX(BB.StartDate) From chgchargedep AS BB");
|
| 1583 | 1592 |
strSQL.Append(" group by BB.PersonCode)) As B");
|
| trunk/src/ProcessManagement/ProcessManagement/Common/CommonMotions.cs | ||
|---|---|---|
| 1940 | 1940 |
case (int)ProductDefine.ProductTypeDef.Originals: |
| 1941 | 1941 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType2_1: |
| 1942 | 1942 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType2_2: |
| 1943 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType3: |
|
| 1944 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType4: |
|
| 1945 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType5: |
|
| 1946 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType6: |
|
| 1943 | 1947 |
break; |
| 1944 | 1948 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType1: |
| 1945 | 1949 |
// 一人親方バージョンはtrue |
| ... | ... | |
| 2584 | 2588 |
{
|
| 2585 | 2589 |
string strRet = string.Empty; |
| 2586 | 2590 |
|
| 2587 |
if (master.CorporateStatusPoint == (int)BusinessTypeMaster.StatusNamePointDef.Forword)
|
|
| 2591 |
if (master.CorporateStatusPoint == (int)SubContractorMaster.StatusNamePointDef.Forword)
|
|
| 2588 | 2592 |
strRet = master.CorporateStatusName + " " + master.OrderersName1 + " " + master.OrderersName2; |
| 2589 |
else if (master.CorporateStatusPoint == (int)BusinessTypeMaster.StatusNamePointDef.Back)
|
|
| 2593 |
else if (master.CorporateStatusPoint == (int)SubContractorMaster.StatusNamePointDef.Back)
|
|
| 2590 | 2594 |
strRet = master.OrderersName1 + " " + master.CorporateStatusName + " " + master.OrderersName2; |
| 2591 | 2595 |
else |
| 2592 | 2596 |
strRet = master.OrderersName1 + " " + master.OrderersName2; |
| ... | ... | |
| 4494 | 4498 |
strSQL.Append(" WHERE");
|
| 4495 | 4499 |
strSQL.AppendFormat(" A.DIVISIONCODE = {0}", (int)DivisionMaster.DivisionMasterCodeDef.ConstructionExpenses);
|
| 4496 | 4500 |
strSQL.AppendFormat(" AND A.DeleteFlg = {0}", (int)CommonDefine.DataDeleteDef.Exists);
|
| 4497 |
strSQL.Append(" And B.EXPENSESRAITO > 0.00");
|
|
| 4501 |
//strSQL.Append(" And B.EXPENSESRAITO > 0.00");
|
|
| 4498 | 4502 |
|
| 4499 | 4503 |
strSQL.Append(" ORDER BY A.DISPLAYORDER, C.DISPLAYORDER");
|
| 4500 | 4504 |
} |
| ... | ... | |
| 4518 | 4522 |
strSQL.Append(" WHERE");
|
| 4519 | 4523 |
strSQL.AppendFormat(" B.EXPENSESPERIOD = {0}", Preiod);
|
| 4520 | 4524 |
if (DepartmentCode > 0) strSQL.AppendFormat(" AND B.DEPARTMENTCODE = {0}", DepartmentCode);
|
| 4521 |
strSQL.Append(" And B.EXPENSESRAITO > 0.00");
|
|
| 4525 |
//strSQL.Append(" And B.EXPENSESRAITO > 0.00");
|
|
| 4522 | 4526 |
|
| 4523 | 4527 |
strSQL.Append(" ORDER BY D.DeleteFlg, C.DISPLAYORDER, B.DISPLAYORDER");
|
| 4524 | 4528 |
} |
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsChangeLedgerData.cs | ||
|---|---|---|
| 65 | 65 |
{
|
| 66 | 66 |
// 工事台帳実行データよりグループごとの合計金額を取得する |
| 67 | 67 |
strSQL.Clear(); |
| 68 |
strSQL.Append("SELECT GROUPCOUNT, SUM(PAYMENTAMOUNT)");
|
|
| 68 |
strSQL.Append("SELECT");
|
|
| 69 |
strSQL.Append(" GROUPCOUNT");
|
|
| 70 |
strSQL.Append(", SUM(PAYMENTAMOUNT)");
|
|
| 69 | 71 |
strSQL.Append(" FROM CONSTRUCTIONLEDGEREXCUTE");
|
| 70 |
strSQL.AppendFormat(" WHERE CONSTRUCTIONCODE = {0}", ConstrCode);
|
|
| 72 |
strSQL.Append(" WHERE");
|
|
| 73 |
strSQL.AppendFormat(" CONSTRUCTIONCODE = {0}", ConstrCode);
|
|
| 71 | 74 |
strSQL.Append(" GROUP BY GROUPCOUNT");
|
| 72 | 75 |
strSQL.Append(" ORDER BY GROUPCOUNT");
|
| 73 | 76 |
|
| ... | ... | |
| 87 | 90 |
|| CommonMotions.cnvInt(x[0]) == (int)ConstructionLedgerDetail.GroupCountDef.ParkingCosts // 6:駐車場・資材置き場 |
| 88 | 91 |
|| CommonMotions.cnvInt(x[0]) == (int)ConstructionLedgerDetail.GroupCountDef.RoomChargeCosts // 7:宿泊費 |
| 89 | 92 |
|| CommonMotions.cnvInt(x[0]) == (int)ConstructionLedgerDetail.GroupCountDef.DisposeCosts) // 8:処分費等 |
| 90 |
.Sum(y=>CommonMotions.cnvDecimal(y[1]));
|
|
| 93 |
.Sum(y => CommonMotions.cnvDecimal(y[1]));
|
|
| 91 | 94 |
|
| 92 | 95 |
decimal PExpenses = InData.Cast<object[]>() // ----- 人件費 |
| 93 | 96 |
.Where(x => CommonMotions.cnvInt(x[0]) == (int)ConstructionLedgerDetail.GroupCountDef.Instructor // 9:指導員給料行 |
| ... | ... | |
| 191 | 194 |
|
| 192 | 195 |
object[] objRec = (object[])arList[0]; |
| 193 | 196 |
DateTime dtADate = CommonMotions.cnvDate(objRec[0]); |
| 194 |
int nAPoint = CommonMotions.cnvInt(objRec[1]);
|
|
| 197 |
int nAPoint = CommonMotions.cnvInt(objRec[1]); |
|
| 195 | 198 |
|
| 196 | 199 |
int Columncnt = 0; |
| 197 | 200 |
DateTime dtBDate = new DateTime(TargetMonth.Year, TargetMonth.Month, 1); |
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsExcute.cs | ||
|---|---|---|
| 102 | 102 |
OnHandVolume = 55, // 55:手持工事高一覧 |
| 103 | 103 |
DRNoticeCalender = 56, // 56:勤怠届カレンダー |
| 104 | 104 |
PurchaseOrderList = 57, // 57:注文書入力一覧 |
| 105 |
|
|
| 105 |
WebInputBillingList = 58, // 58:Web業者請求データ一覧 |
|
| 106 |
PaymentNotice = 59, // 59:支払通知書印刷 |
|
| 106 | 107 |
} |
| 107 | 108 |
#endregion |
| 108 | 109 |
|
| ... | ... | |
| 301 | 302 |
{ (int)ProcessExecuteNo.OnHandVolume, "手持工事高－印刷" },
|
| 302 | 303 |
{ (int)ProcessExecuteNo.DRNoticeCalender, "勤怠届カレンダー－表示" },
|
| 303 | 304 |
{ (int)ProcessExecuteNo.PurchaseOrderList, "注文書入力一覧－表示" },
|
| 305 |
{ (int)ProcessExecuteNo.WebInputBillingList, "Web業者請求データ一覧－表示" },
|
|
| 306 |
{ (int)ProcessExecuteNo.PaymentNotice, "支払通知書－印刷" },
|
|
| 304 | 307 |
}; |
| 305 |
|
|
| 306 | 308 |
#endregion |
| 307 | 309 |
|
| 308 | 310 |
#region マスタメンテンナス処理名称 |
| ... | ... | |
| 606 | 608 |
break; |
| 607 | 609 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType2_1: |
| 608 | 610 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType2_2: |
| 611 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType3: |
|
| 612 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType4: |
|
| 613 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType5: |
|
| 614 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType6: |
|
| 609 | 615 |
// ----- 製品版（承認バージョン） |
| 610 | 616 |
keyValues = FrmSecurity.GetExecKeyValuesProType2; |
| 611 | 617 |
break; |
| ... | ... | |
| 908 | 914 |
ProcessExecuteNo_PurchaseOrderList(m_ProcControlPara[NowPoint]); |
| 909 | 915 |
break; |
| 910 | 916 |
|
| 917 |
case (int)ProcessExecuteNo.WebInputBillingList: // 58:Web業者請求データ一覧 |
|
| 918 |
ProcessExecuteNo_WebInputBillingList(m_ProcControlPara[NowPoint]); |
|
| 919 |
break; |
|
| 911 | 920 |
|
| 921 |
case (int)ProcessExecuteNo.PaymentNotice: // 59:支払通知書印刷 |
|
| 922 |
ProcessExecuteNo_PaymentNotice(m_ProcControlPara[NowPoint]); |
|
| 923 |
break; |
|
| 924 |
|
|
| 912 | 925 |
#endregion |
| 913 | 926 |
|
| 914 | 927 |
#region マスタメンテ |
| ... | ... | |
| 3379 | 3392 |
} |
| 3380 | 3393 |
#endregion |
| 3381 | 3394 |
|
| 3395 |
#region Web業者請求データ一覧 |
|
| 3396 |
/// <summary> |
|
| 3397 |
/// Web業者請求データ一覧 |
|
| 3398 |
/// </summary> |
|
| 3399 |
/// <returns></returns> |
|
| 3400 |
public static void ProcessExecuteNo_WebInputBillingList(ProcessParameter CurrentPara) |
|
| 3401 |
{
|
|
| 3402 |
// 注文書入力一覧 |
|
| 3403 |
FrmInputBillingList frm = new FrmInputBillingList(); |
|
| 3404 |
int ProcessNo = (int)ClsExcute.ProcessExecuteNo.PurchaseOrderList; |
|
| 3405 |
try |
|
| 3406 |
{
|
|
| 3407 |
// 自分のハンドルをリストへセットする |
|
| 3408 |
ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = ProcessNo; |
|
| 3409 |
ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = (Form)frm; |
|
| 3410 |
|
|
| 3411 |
// 起動・編集フラグ |
|
| 3412 |
int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference; |
|
| 3413 |
if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg)) return; |
|
| 3414 |
|
|
| 3415 |
// ----- パラメータセット |
|
| 3416 |
// 会社番号 |
|
| 3417 |
frm.CompanyCode = CurrentPara.IntExecParameter[0]; |
|
| 3418 |
// 対象年月 |
|
| 3419 |
frm.TargetDate = CurrentPara.IntExecParameter[1]; |
|
| 3420 |
|
|
| 3421 |
// フォーム表示 |
|
| 3422 |
frm.ShowDialog(); |
|
| 3423 |
} |
|
| 3424 |
catch (Exception ex) |
|
| 3425 |
{
|
|
| 3426 |
logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
|
|
| 3427 |
BackProcess(); |
|
| 3428 |
} |
|
| 3429 |
finally |
|
| 3430 |
{
|
|
| 3431 |
frm.Dispose(); frm = null; |
|
| 3432 |
} |
|
| 3433 |
} |
|
| 3382 | 3434 |
#endregion |
| 3383 | 3435 |
|
| 3436 |
#region 59:支払通知書印刷 |
|
| 3437 |
/// <summary> |
|
| 3438 |
/// 59:支払通知書印刷 |
|
| 3439 |
/// </summary> |
|
| 3440 |
/// <returns></returns> |
|
| 3441 |
public static void ProcessExecuteNo_PaymentNotice(ProcessParameter CurrentPara) |
|
| 3442 |
{
|
|
| 3443 |
// 注文書入力一覧 |
|
| 3444 |
FrmPaymentNotice frm = new FrmPaymentNotice(); |
|
| 3445 |
int ProcessNo = (int)ClsExcute.ProcessExecuteNo.PurchaseOrderList; |
|
| 3446 |
try |
|
| 3447 |
{
|
|
| 3448 |
// 自分のハンドルをリストへセットする |
|
| 3449 |
ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = ProcessNo; |
|
| 3450 |
ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = (Form)frm; |
|
| 3451 |
|
|
| 3452 |
// 起動・編集フラグ |
|
| 3453 |
int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference; |
|
| 3454 |
if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg)) return; |
|
| 3455 |
|
|
| 3456 |
// ----- パラメータセット |
|
| 3457 |
// 対象年月 |
|
| 3458 |
frm.RequestMonth = CurrentPara.IntExecParameter[0]; |
|
| 3459 |
// 支払区分 |
|
| 3460 |
frm.LabourLind = CurrentPara.IntExecParameter[1]; |
|
| 3461 |
|
|
| 3462 |
// フォーム表示 |
|
| 3463 |
frm.ShowDialog(); |
|
| 3464 |
} |
|
| 3465 |
catch (Exception ex) |
|
| 3466 |
{
|
|
| 3467 |
logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
|
|
| 3468 |
BackProcess(); |
|
| 3469 |
} |
|
| 3470 |
finally |
|
| 3471 |
{
|
|
| 3472 |
frm.Dispose(); frm = null; |
|
| 3473 |
} |
|
| 3474 |
} |
|
| 3475 |
#endregion |
|
| 3476 |
|
|
| 3477 |
#endregion |
|
| 3478 |
|
|
| 3384 | 3479 |
#region マスタメンテナンス |
| 3385 | 3480 |
// ----------------- メンテナンス起動 |
| 3386 | 3481 |
#region 管理マスタ |
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsMessageBoradAccess.cs | ||
|---|---|---|
| 533 | 533 |
|
| 534 | 534 |
// 対象者のメッセージ書込時、過去所属部署を取得する |
| 535 | 535 |
StringBuilder strSQL = new StringBuilder(); |
| 536 |
strSQL.Append("Select * From chgchargedep As A");
|
|
| 536 |
strSQL.Append("Select");
|
|
| 537 |
strSQL.Append(IOMChgChargeDep.CreateFieldNameList("A."));
|
|
| 538 |
strSQL.Append(" From chgchargedep As A");
|
|
| 537 | 539 |
strSQL.AppendFormat(" Where A.PersonCode = {0}", SourceCode);
|
| 538 | 540 |
strSQL.AppendFormat(" And (Date(A.StartDate) <= DATE('{0}')", dtMsgDate.ToShortDateString());
|
| 539 | 541 |
strSQL.AppendFormat(" And DATE('{0}') <= Date(A.CompDate))", dtMsgDate.ToShortDateString());
|
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsMoveDepOfInfo.cs | ||
|---|---|---|
| 75 | 75 |
// 対象年分データを取得する |
| 76 | 76 |
ArrayList arList = new ArrayList(); |
| 77 | 77 |
if (!ChgPersonDepGetData(BaseDB, PersonCode, ref arList)) return false; |
| 78 |
if (arList.Count < 1) return true; |
|
| 78 | 79 |
|
| 79 | 80 |
// 工事情報対象部署コード変更 |
| 80 | 81 |
if (!ChgPersonDepBaseInfo(BaseDB, arList, PersonCode, nAfterDepCode)) return false; |
| ... | ... | |
| 172 | 173 |
try |
| 173 | 174 |
{
|
| 174 | 175 |
StringBuilder strSQL = new StringBuilder(); |
| 176 |
|
|
| 177 |
strSQL.Append("Select Count(*) From constructionbaseinfo");
|
|
| 178 |
strSQL.Append(" WHERE ConstructionCode IN (");
|
|
| 179 |
bool bFirst = true; |
|
| 180 |
foreach (object[] objRec in arList) |
|
| 181 |
{
|
|
| 182 |
int nConstrCode = CommonMotions.cnvInt(objRec[(int)GetChgDepData.ConstronCode]); |
|
| 183 |
if (bFirst) strSQL.AppendFormat("{0}", nConstrCode);
|
|
| 184 |
else strSQL.AppendFormat(",{0}", nConstrCode);
|
|
| 185 |
bFirst = false; |
|
| 186 |
} |
|
| 187 |
strSQL.Append(" )");
|
|
| 188 |
|
|
| 189 |
ArrayList DataCount = new ArrayList(); |
|
| 190 |
if (!BaseDB.ExecuteReader(strSQL.ToString(), ref DataCount, false)) return false; |
|
| 191 |
int nCount = 0; |
|
| 192 |
if (DataCount.Count > 0) |
|
| 193 |
{
|
|
| 194 |
object[] objList = (object[])DataCount[0]; |
|
| 195 |
nCount = CommonMotions.cnvInt(objList[0]); |
|
| 196 |
} |
|
| 197 |
if (nCount < 1) return true; |
|
| 198 |
|
|
| 199 |
strSQL.Clear(); |
|
| 175 | 200 |
strSQL.Append("Update constructionbaseinfo");
|
| 176 | 201 |
strSQL.Append(" SET");
|
| 177 | 202 |
strSQL.Append(" SalesDepCode = case SalesPersonCode");
|
| ... | ... | |
| 196 | 221 |
strSQL.Append(" END");
|
| 197 | 222 |
strSQL.Append(", UpdateDate = NOW()");
|
| 198 | 223 |
strSQL.Append(" WHERE ConstructionCode IN (");
|
| 199 |
|
|
| 200 |
bool bFirst = true; |
|
| 224 |
bFirst = true; |
|
| 201 | 225 |
foreach (object[] objRec in arList) |
| 202 | 226 |
{
|
| 203 | 227 |
int nConstrCode = CommonMotions.cnvInt(objRec[(int)GetChgDepData.ConstronCode]); |
| ... | ... | |
| 475 | 499 |
try |
| 476 | 500 |
{
|
| 477 | 501 |
StringBuilder strSQL = new StringBuilder(); |
| 502 |
|
|
| 503 |
strSQL.Append("Select Count(*) From constructionledgerdetail");
|
|
| 504 |
strSQL.Append(" WHERE ConstructionCode IN (");
|
|
| 505 |
|
|
| 506 |
bool bFirst = true; |
|
| 507 |
foreach (object[] objRec in arList) |
|
| 508 |
{
|
|
| 509 |
int nConstrCode = CommonMotions.cnvInt(objRec[(int)GetChgDepData.ConstronCode]); |
|
| 510 |
if (!bFirst) strSQL.Append(", ");
|
|
| 511 |
strSQL.AppendFormat("{0}", nConstrCode);
|
|
| 512 |
bFirst = false; |
|
| 513 |
} |
|
| 514 |
strSQL.Append(" )");
|
|
| 515 |
strSQL.AppendFormat(" And GroupCount in ({0}, {1}, {2})", (int)ConstructionLedgerDetail.GroupCountDef.Instructor
|
|
| 516 |
, (int)ConstructionLedgerDetail.GroupCountDef.Assistant |
|
| 517 |
, (int)ConstructionLedgerDetail.GroupCountDef.Payroll); |
|
| 518 |
strSQL.AppendFormat(" And CompanyCode = {0}", PersonCode);
|
|
| 519 |
|
|
| 520 |
ArrayList DataCount = new ArrayList(); |
|
| 521 |
if (!LedgerDB.ExecuteReader(strSQL.ToString(), ref DataCount, false)) return false; |
|
| 522 |
int nCount = 0; |
|
| 523 |
if (DataCount.Count > 0) |
|
| 524 |
{
|
|
| 525 |
object[] objList = (object[])DataCount[0]; |
|
| 526 |
nCount = CommonMotions.cnvInt(objList[0]); |
|
| 527 |
} |
|
| 528 |
if (nCount < 1) return true; |
|
| 529 |
|
|
| 530 |
strSQL.Clear(); |
|
| 478 | 531 |
strSQL.Append("Update constructionledgerdetail");
|
| 479 | 532 |
strSQL.Append(" SET");
|
| 480 | 533 |
strSQL.AppendFormat(" ComponentCode = {0}", nAfterDepCode);
|
| 481 | 534 |
strSQL.Append(", UpdateDate = NOW()");
|
| 482 | 535 |
strSQL.Append(" WHERE ConstructionCode IN (");
|
| 483 | 536 |
|
| 484 |
bool bFirst = true;
|
|
| 537 |
bFirst = true; |
|
| 485 | 538 |
foreach (object[] objRec in arList) |
| 486 | 539 |
{
|
| 487 | 540 |
int nConstrCode = CommonMotions.cnvInt(objRec[(int)GetChgDepData.ConstronCode]); |
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsProcessExist.cs | ||
|---|---|---|
| 367 | 367 |
break; |
| 368 | 368 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType2_1: |
| 369 | 369 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType2_2: |
| 370 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType3: |
|
| 371 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType4: |
|
| 372 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType5: |
|
| 373 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType6: |
|
| 370 | 374 |
// ----- 製品版（承認バージョン） |
| 371 | 375 |
GetProcessListMassProductionType2(ref ProcList, OperationPrcess); |
| 372 | 376 |
break; |
| ... | ... | |
| 1444 | 1448 |
|
| 1445 | 1449 |
// 工事情報データの存在チェック |
| 1446 | 1450 |
StringBuilder strSQL = new StringBuilder(); |
| 1447 |
strSQL.Append("Select * From constructionbaseinfo As A");
|
|
| 1451 |
strSQL.Append("Select count(*) From constructionbaseinfo As A");
|
|
| 1448 | 1452 |
strSQL.Append(" Inner Join constructionmaterialinfo As B");
|
| 1449 | 1453 |
strSQL.Append(" On B.CONSTRUCTIONCODE = A.ConstructionCode");
|
| 1450 | 1454 |
strSQL.Append(" And B.COMPLETEFLG = 0");
|
| ... | ... | |
| 1452 | 1456 |
|
| 1453 | 1457 |
ArrayList ArList = new ArrayList(); |
| 1454 | 1458 |
if (!BaseDB.ExecuteReader(strSQL.ToString(), ref ArList)) return false; |
| 1455 |
if (ArList.Count < 1) return false; |
|
| 1459 |
object[] objCnt = (object[])ArList[0]; |
|
| 1460 |
if (CommonMotions.cnvInt(objCnt[0]) < 1) return false; |
|
| 1456 | 1461 |
|
| 1457 | 1462 |
return true; |
| 1458 | 1463 |
} |
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsSecurityPermission.cs | ||
|---|---|---|
| 537 | 537 |
if (!bRet) |
| 538 | 538 |
{
|
| 539 | 539 |
strSQL.Clear(); |
| 540 |
strSQL.Append("Select * From approvalmaster As A");
|
|
| 540 |
strSQL.Append("Select");
|
|
| 541 |
strSQL.Append(IOMApproval.CreateFieldNameList("A."));
|
|
| 542 |
strSQL.Append(" From approvalmaster As A");
|
|
| 541 | 543 |
strSQL.AppendFormat(" Where A.ApprovalCode = {0}", ApprovalCode);
|
| 542 | 544 |
strSQL.AppendFormat(" And A.DepartmentCode = {0}", iDepartCode);
|
| 543 | 545 |
|
| 544 | 546 |
ArrayList arApprovalData = new ArrayList(); |
| 545 | 547 |
if (!FreeDB.ExecuteReader(strSQL.ToString(), ref arApprovalData)) return false; |
| 546 | 548 |
|
| 547 |
int nCount2 = arApprovalData.Cast<Object[]>().Where(x => CommonMotions.cnvInt(x[(int)IOMApproval.NameColumn.ApprovalPerson]) == CommonMotions.LoginUserData.PersonCode).Count(); |
|
| 549 |
int nPersonPos = (int)IOMApproval.NameColumn.ApprovalPerson; |
|
| 550 |
int nCount2 = arApprovalData.Cast<Object[]>() |
|
| 551 |
.Where(x => CommonMotions.cnvInt(x[nPersonPos]) == CommonMotions.LoginUserData.PersonCode) |
|
| 552 |
.Count(); |
|
| 548 | 553 |
if (nCount2 > 0) bRet = true; |
| 549 | 554 |
} |
| 550 | 555 |
|
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsSystemOnceExecute.cs | ||
|---|---|---|
| 559 | 559 |
// 工事基本情報を期限テーブルに設定している状態分取得する |
| 560 | 560 |
StringBuilder strSQL = new StringBuilder(); |
| 561 | 561 |
|
| 562 |
strSQL.Append("Select * From constructionbaseinfo As Atbl");
|
|
| 563 |
strSQL.Append(" Left Join PeriodAvoidance As Ctbl");
|
|
| 564 |
strSQL.Append(" On Ctbl.ConstructionCode = Atbl.ConstructionCode");
|
|
| 565 |
strSQL.Append(" And Ctbl.ConstructionStatusFlg = Atbl.ConstructionStatusFlg");
|
|
| 562 |
strSQL.Append("Select ");
|
|
| 563 |
strSQL.Append(IOConstructionBaseInfo.CreateFieldNameList("Atbl."));
|
|
| 564 |
strSQL.Append(", ");
|
|
| 565 |
strSQL.Append(IOPeriodAvoidance.CreateFieldNameList("Btbl."));
|
|
| 566 |
strSQL.Append(" From constructionbaseinfo As Atbl");
|
|
| 567 |
strSQL.Append(" Left Join PeriodAvoidance As Ctbl");
|
|
| 568 |
strSQL.Append(" On Ctbl.ConstructionCode = Atbl.ConstructionCode");
|
|
| 569 |
strSQL.Append(" And Ctbl.ConstructionStatusFlg = Atbl.ConstructionStatusFlg");
|
|
| 566 | 570 |
strSQL.Append(" WHERE Atbl.CONSTRUCTIONSTATUSFLG IN (SELECT DISTINCT A1.CONSTRUCTIONSTATUSFLG FROM TERMMASTER A1)");
|
| 567 | 571 |
strSQL.Append(" AND NOT EXISTS (SELECT * From PeriodAvoidance As Btbl");
|
| 568 | 572 |
strSQL.Append(" Where Btbl.ConstructionCode = Atbl.ConstructionCode");
|
| ... | ... | |
| 592 | 596 |
bool procflg = true; |
| 593 | 597 |
ConstructionBaseInfo wrkBaseRec = new ConstructionBaseInfo(); |
| 594 | 598 |
PeriodAvoidance wrkAvoRec = new PeriodAvoidance(); |
| 595 |
int offset = Enum.GetNames(typeof(IOConstructionBaseInfo.TableColumn)).Length + 1;
|
|
| 599 |
int offset = Enum.GetNames(typeof(IOConstructionBaseInfo.TableColumn)).Length; |
|
| 596 | 600 |
// 経過日数分処理を行う |
| 597 | 601 |
for (int ix = 0; ix < diffDays; ix++) |
| 598 | 602 |
{
|
| ... | ... | |
| 1216 | 1220 |
{
|
| 1217 | 1221 |
StringBuilder strSQL = new StringBuilder(); |
| 1218 | 1222 |
// 就業終了日が今日より小さくて削除されていないデータを検索する |
| 1219 |
strSQL.Append("Select * From personinchargemaster");
|
|
| 1223 |
strSQL.Append("Select ");
|
|
| 1224 |
strSQL.Append(IOMPersonInCharge.CreateFieldNameList()); |
|
| 1225 |
strSQL.Append(" From personinchargemaster");
|
|
| 1220 | 1226 |
strSQL.AppendFormat(" Where (DATE(EndDate) != DATE('{0}')", DateTime.MinValue.ToShortDateString());
|
| 1221 | 1227 |
strSQL.Append(" And DATE(EndDate) < DATE(NOW()))");
|
| 1222 | 1228 |
strSQL.AppendFormat(" And DeleteFlg = {0}",(int)CommonDefine.DataDeleteDef.Exists);
|
| ... | ... | |
| 1458 | 1464 |
{
|
| 1459 | 1465 |
StringBuilder strSQL = new StringBuilder(); |
| 1460 | 1466 |
// 本日以前に移動が対象者 |
| 1461 |
strSQL.Append("Select * From personinchargemaster As A");
|
|
| 1462 |
strSQL.Append(" , (Select * From chgchargedep As BA");
|
|
| 1467 |
strSQL.Append("Select");
|
|
| 1468 |
strSQL.Append(IOMPersonInCharge.CreateFieldNameList("A."));
|
|
| 1469 |
strSQL.Append(", B.*");
|
|
| 1470 |
strSQL.Append(" From personinchargemaster As A");
|
|
| 1471 |
strSQL.AppendFormat(", (Select {0} From chgchargedep As BA", IOMChgChargeDep.CreateFieldNameList("BA."));
|
|
| 1463 | 1472 |
strSQL.Append(" Where (BA.PersonCode, BA.StartDate)");
|
| 1464 | 1473 |
strSQL.Append(" in (Select BB.PersonCode, MAX(BB.StartDate) From chgchargedep AS BB");
|
| 1465 | 1474 |
strSQL.Append(" group by BB.PersonCode)) As B");
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOChgConstrCharge.cs | ||
|---|---|---|
| 59 | 59 |
} |
| 60 | 60 |
#endregion |
| 61 | 61 |
|
| 62 |
#region テーブルのフィールドリストを作成する |
|
| 63 |
/// <summary> |
|
| 64 |
/// テーブルのフィールドリストを作成する |
|
| 65 |
/// </summary> |
|
| 66 |
/// <returns></returns> |
|
| 67 |
public static string CreateFieldNameList(string strAlias = "") |
|
| 68 |
{
|
|
| 69 |
StringBuilder strcmd = new StringBuilder(); |
|
| 70 |
try |
|
| 71 |
{
|
|
| 72 |
strcmd.Append(" ");
|
|
| 73 |
bool bColFirst = true; |
|
| 74 |
string strWork = string.Empty; |
|
| 75 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 76 |
{
|
|
| 77 |
strWork = gender.ToString(); |
|
| 78 |
if (!bColFirst) strcmd.Append(",");
|
|
| 79 |
if (strWork.Equals("EntryDate") || strWork.Equals("UpdateDate"))
|
|
| 80 |
{
|
|
| 81 |
strcmd.AppendFormat(" DATE_FORMAT({0}{1}, '%Y/%m/%d %H:%i:%s')", strAlias, strWork);
|
|
| 82 |
} |
|
| 83 |
else |
|
| 84 |
{
|
|
| 85 |
strcmd.AppendFormat(" {0}{1}", strAlias, strWork);
|
|
| 86 |
} |
|
| 87 |
bColFirst = false; |
|
| 88 |
} |
|
| 89 |
|
|
| 90 |
return strcmd.ToString(); |
|
| 91 |
} |
|
| 92 |
catch (Exception ex) |
|
| 93 |
{
|
|
| 94 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 95 |
return string.Empty; |
|
| 96 |
} |
|
| 97 |
} |
|
| 98 |
#endregion |
|
| 99 |
|
|
| 62 | 100 |
#region SQL作成 |
| 63 | 101 |
/// <summary> |
| 64 | 102 |
/// SQL作成 |
| ... | ... | |
| 67 | 105 |
{
|
| 68 | 106 |
// SQL作成 |
| 69 | 107 |
StringBuilder strcmd = new StringBuilder(); |
| 70 |
strcmd.Append("SELECT");
|
|
| 108 |
try |
|
| 109 |
{
|
|
| 110 |
strcmd.AppendFormat("SELECT {0} FROM ChgConstrCharge", CreateFieldNameList());
|
|
| 71 | 111 |
|
| 72 |
bool bColFirst = true;
|
|
| 73 |
string strWork = string.Empty;
|
|
| 74 |
foreach (var gender in Enum.GetValues(typeof(TableColumn)))
|
|
| 112 |
return strcmd.ToString();
|
|
| 113 |
}
|
|
| 114 |
catch (Exception ex)
|
|
| 75 | 115 |
{
|
| 76 |
strWork = gender.ToString(); |
|
| 77 |
if (!bColFirst) strcmd.Append(",");
|
|
| 78 |
if (strWork.Equals("EntryDate") || strWork.Equals("UpdateDate"))
|
|
| 79 |
{
|
|
| 80 |
strcmd.AppendFormat(" DATE_FORMAT({0}, '%Y/%m/%d %H:%i:%s')", strWork);
|
|
| 81 |
} |
|
| 82 |
else |
|
| 83 |
{
|
|
| 84 |
strcmd.AppendFormat(" {0}", strWork);
|
|
| 85 |
} |
|
| 86 |
bColFirst = false; |
|
| 116 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 117 |
return string.Empty; |
|
| 87 | 118 |
} |
| 88 |
|
|
| 89 |
strcmd.Append(" FROM ChgConstrCharge");
|
|
| 90 |
|
|
| 91 |
return strcmd.ToString(); |
|
| 92 | 119 |
} |
| 93 | 120 |
#endregion |
| 94 | 121 |
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOInputBillingStatus.cs | ||
|---|---|---|
| 53 | 53 |
|
| 54 | 54 |
#endregion |
| 55 | 55 |
|
| 56 |
#region テーブルのフィールドリストを作成する |
|
| 57 |
/// <summary> |
|
| 58 |
/// テーブルのフィールドリストを作成する |
|
| 59 |
/// </summary> |
|
| 60 |
/// <returns></returns> |
|
| 61 |
public static string CreateFieldNameList(string strAlias = "") |
|
| 62 |
{
|
|
| 63 |
StringBuilder strcmd = new StringBuilder(); |
|
| 64 |
try |
|
| 65 |
{
|
|
| 66 |
strcmd.Append(" ");
|
|
| 67 |
bool bColFirst = true; |
|
| 68 |
string strWork = string.Empty; |
|
| 69 |
foreach (var gender in Enum.GetValues(typeof(NameColumn))) |
|
| 70 |
{
|
|
| 71 |
strWork = gender.ToString(); |
|
| 72 |
if (!bColFirst) strcmd.Append(",");
|
|
| 73 |
if (strWork.Equals("EntryDate") || strWork.Equals("UpdateDate"))
|
|
| 74 |
{
|
|
| 75 |
strcmd.AppendFormat(" DATE_FORMAT({0}{1}, '%Y/%m/%d %H:%i:%s')", strAlias, strWork);
|
|
| 76 |
} |
|
| 77 |
else |
|
| 78 |
{
|
|
| 79 |
strcmd.AppendFormat(" {0}{1}", strAlias, strWork);
|
|
| 80 |
} |
|
| 81 |
bColFirst = false; |
|
| 82 |
} |
|
| 83 |
|
|
| 84 |
return strcmd.ToString(); |
|
| 85 |
} |
|
| 86 |
catch (Exception ex) |
|
| 87 |
{
|
|
| 88 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 89 |
return string.Empty; |
|
| 90 |
} |
|
| 91 |
} |
|
| 92 |
#endregion |
|
| 93 |
|
|
| 56 | 94 |
#region 業者請求入力状態検索文字列作成 |
| 57 | 95 |
/// <summary> |
| 58 | 96 |
/// 業者請求入力状態検索文字列作成 |
| ... | ... | |
| 60 | 98 |
private string CreateSelectSQL() |
| 61 | 99 |
{
|
| 62 | 100 |
StringBuilder strcmd = new StringBuilder(); |
| 63 |
strcmd.Append("SELECT");
|
|
| 101 |
try |
|
| 102 |
{
|
|
| 103 |
strcmd.AppendFormat("SELECT {0} FROM InputBillingStatus", CreateFieldNameList());
|
|
| 64 | 104 |
|
| 65 |
bool bColFirst = true;
|
|
| 66 |
string strWork = string.Empty;
|
|
| 67 |
foreach (var gender in Enum.GetValues(typeof(NameColumn)))
|
|
| 105 |
return strcmd.ToString();
|
|
| 106 |
}
|
|
| 107 |
catch (Exception ex)
|
|
| 68 | 108 |
{
|
| 69 |
strWork = gender.ToString(); |
|
| 70 |
if (!bColFirst) strcmd.Append(",");
|
|
| 71 |
if (strWork.Equals("EntryDate") || strWork.Equals("UpdateDate"))
|
|
| 72 |
{
|
|
| 73 |
strcmd.AppendFormat(" DATE_FORMAT({0}, '%Y/%m/%d %H:%i:%s')", strWork);
|
|
| 74 |
} |
|
| 75 |
else |
|
| 76 |
{
|
|
| 77 |
strcmd.AppendFormat(" {0}", strWork);
|
|
| 78 |
} |
|
| 79 |
bColFirst = false; |
|
| 109 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 110 |
return string.Empty; |
|
| 80 | 111 |
} |
| 81 |
|
|
| 82 |
strcmd.Append(" FROM InputBillingStatus");
|
|
| 83 |
|
|
| 84 |
return strcmd.ToString(); |
|
| 85 | 112 |
} |
| 86 | 113 |
#endregion |
| 87 | 114 |
|
| trunk/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 |
public static string CreateFieldNameList(string strAlias = "") |
|
| 65 |
{
|
|
| 66 |
StringBuilder strcmd = new StringBuilder(); |
|
| 67 |
try |
|
| 68 |
{
|
|
| 69 |
strcmd.Append(" ");
|
|
| 70 |
bool bColFirst = true; |
|
| 71 |
string strWork = string.Empty; |
|
| 72 |
foreach (var gender in Enum.GetValues(typeof(NameColumn))) |
|
| 73 |
{
|
|
| 74 |
strWork = gender.ToString(); |
|
| 75 |
if (!bColFirst) strcmd.Append(",");
|
|
| 76 |
if (strWork.Equals("EntryDate") || strWork.Equals("UpdateDate"))
|
|
| 77 |
{
|
|
| 78 |
strcmd.AppendFormat(" DATE_FORMAT({0}{1}, '%Y/%m/%d %H:%i:%s') As {1}", strAlias, strWork);
|
|
| 79 |
} |
|
| 80 |
else |
|
| 81 |
{
|
|
| 82 |
strcmd.AppendFormat(" {0}{1}", strAlias, strWork);
|
|
| 83 |
} |
|
| 84 |
bColFirst = false; |
|
| 85 |
} |
|
| 86 |
|
|
| 87 |
return strcmd.ToString(); |
|
| 88 |
} |
|
| 89 |
catch (Exception ex) |
|
| 90 |
{
|
|
| 91 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 92 |
return string.Empty; |
|
| 93 |
} |
|
| 94 |
} |
|
| 95 |
#endregion |
|
| 96 |
|
|
| 59 | 97 |
#region 検索文字列作成 |
| 60 | 98 |
/// <summary> |
| 61 | 99 |
/// 検索文字列作成 |
| ... | ... | |
| 65 | 103 |
{
|
| 66 | 104 |
StringBuilder strcmd = new StringBuilder(); |
| 67 | 105 |
|
| 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");
|
|
| 106 |
strcmd.AppendFormat("SELECT {0} FROM ApprovalMaster", CreateFieldNameList());
|
|
| 79 | 107 |
|
| 80 | 108 |
return strcmd.ToString(); |
| 81 | 109 |
} |
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMVehicle.cs | ||
|---|---|---|
| 70 | 70 |
|
| 71 | 71 |
#endregion |
| 72 | 72 |
|
| 73 |
#region テーブルのフィールドリストを作成する |
|
| 74 |
/// <summary> |
|
| 75 |
/// テーブルのフィールドリストを作成する |
|
| 76 |
/// </summary> |
|
| 77 |
/// <returns></returns> |
|
| 78 |
public static string CreateFieldNameList(string strAlias = "") |
|
| 79 |
{
|
|
| 80 |
StringBuilder strcmd = new StringBuilder(); |
|
| 81 |
try |
|
| 82 |
{
|
|
| 83 |
strcmd.Append(" ");
|
|
| 84 |
bool bColFirst = true; |
|
| 85 |
string strWork = string.Empty; |
|
| 86 |
foreach (var gender in Enum.GetValues(typeof(NameColumn))) |
|
| 87 |
{
|
|
| 88 |
strWork = gender.ToString(); |
|
| 89 |
if (!bColFirst) strcmd.Append(",");
|
|
| 90 |
if (strWork.Equals("EntryDate") || strWork.Equals("UpdateDate"))
|
|
| 91 |
{
|
|
| 92 |
strcmd.AppendFormat(" DATE_FORMAT({0}{1}, '%Y/%m/%d %H:%i:%s') As {1}", strAlias, strWork);
|
|
| 93 |
} |
|
| 94 |
else if (strWork.Equals("PurchaseDate") || strWork.Equals("LeaseDate"))
|
|
| 95 |
{
|
|
| 96 |
strcmd.AppendFormat(" DATE_FORMAT({0}{1}, '%Y/%m/%d') As {1}", strAlias, strWork);
|
|
| 97 |
} |
|
| 98 |
else |
|
| 99 |
{
|
|
| 100 |
strcmd.AppendFormat(" {0}{1}", strAlias, strWork);
|
|
| 101 |
} |
|
| 102 |
bColFirst = false; |
|
| 103 |
} |
|
| 104 |
|
|
| 105 |
return strcmd.ToString(); |
|
| 106 |
} |
|
| 107 |
catch (Exception ex) |
|
| 108 |
{
|
|
| 109 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 110 |
return string.Empty; |
|
| 111 |
} |
|
| 112 |
} |
|
| 113 |
#endregion |
|
| 114 |
|
|
| 115 |
#region 検索文字列作成 |
|
| 116 |
/// <summary> |
|
| 117 |
/// 検索文字列作成 |
|
| 118 |
/// </summary> |
|
| 119 |
/// <returns></returns> |
|
| 120 |
private string CreateSelectSQL() |
|
| 121 |
{
|
|
| 122 |
StringBuilder strcmd = new StringBuilder(); |
|
| 123 |
try |
|
| 124 |
{
|
|
| 125 |
strcmd.AppendFormat("SELECT {0} FROM VehicleMaster", CreateFieldNameList());
|
|
| 126 |
|
|
| 127 |
return strcmd.ToString(); |
|
| 128 |
} |
|
| 129 |
catch (Exception ex) |
|
| 130 |
{
|
|
| 131 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 132 |
return string.Empty; |
|
| 133 |
} |
|
| 134 |
} |
|
| 135 |
#endregion |
|
| 136 |
|
|
| 73 | 137 |
#region 車両マスタ検索 |
| 74 | 138 |
/// <summary> |
| 75 | 139 |
/// 車両マスタ検索 |
| ... | ... | |
| 86 | 150 |
try |
| 87 | 151 |
{
|
| 88 | 152 |
// SQL作成 |
| 89 |
strcmd.Append("SELECT");
|
|
| 153 |
strcmd.AppendFormat("{0}{1}", CreateSelectSQL(), AddSQLString);
|
|
| 90 | 154 |
|
| 91 |
strcmd.Append(" VehicleCode");
|
|
| 92 |
strcmd.Append(",DisplayOrder");
|
|
| 93 |
strcmd.Append(",VehicleName");
|
|
| 94 |
strcmd.Append(",RegistrationNumber");
|
|
| 95 |
strcmd.Append(",IdentificationNumber");
|
|
| 96 |
strcmd.Append(",ModelCode");
|
|
| 97 |
strcmd.Append(",DepartmentCode");
|
|
| 98 |
strcmd.Append(",VehicleScheduleFlg");
|
|
| 99 |
strcmd.Append(",DATE_FORMAT(PurchaseDate, '%Y/%m/%d')");
|
|
| 100 |
strcmd.Append(",PurchaseName");
|
|
| 101 |
strcmd.Append(",PurchaseContactPersons");
|
|
| 102 |
strcmd.Append(",PurchasePhone");
|
|
| 103 |
strcmd.Append(",DATE_FORMAT(LeaseDate, '%Y/%m/%d')");
|
|
| 104 |
strcmd.Append(",LeaseDestination");
|
|
| 105 |
strcmd.Append(",LeaseContactPersons");
|
|
| 106 |
strcmd.Append(",LeasePhone");
|
|
| 107 |
strcmd.Append(",InsuranceCompany");
|
|
| 108 |
strcmd.Append(",InsuranceContactPersons");
|
|
| 109 |
strcmd.Append(",InsurancePhone");
|
|
| 110 |
strcmd.Append(",Note");
|
|
| 111 |
|
|
| 112 |
strcmd.Append(", DATE_FORMAT(EntryDate,'%Y/%m/%d %H:%i:%s')");
|
|
| 113 |
strcmd.Append(", DATE_FORMAT(UpdateDate,'%Y/%m/%d %H:%i:%s')");
|
|
| 114 |
strcmd.Append(" FROM VehicleMaster");
|
|
| 115 |
strcmd.Append(AddSQLString); |
|
| 116 |
|
|
| 117 | 155 |
// SQL実行 |
| 118 | 156 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false; |
| 119 | 157 |
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMessageBoardData.cs | ||
|---|---|---|
| 107 | 107 |
/// <summary> |
| 108 | 108 |
/// 掲示板データ検索文字作成 |
| 109 | 109 |
/// </summary> |
| 110 |
/// <param name="AddSQLString">検索条件SQL文字列</param> |
|
| 111 |
/// <param name="data">掲示板データデータ</param> |
|
| 112 |
/// <returns>true：成功 false：失敗</returns> |
|
| 113 | 110 |
private string CreateSelectSQL() |
| 114 | 111 |
{
|
| 115 | 112 |
StringBuilder strcmd = new StringBuilder(); |
| ... | ... | |
| 540 | 537 |
|
| 541 | 538 |
// データ存在確認 |
| 542 | 539 |
strcmd.Clear(); |
| 543 |
strcmd.Append("Select * From MessageBoardData");
|
|
| 540 |
strcmd.Append("Select count(*) From MessageBoardData");
|
|
| 544 | 541 |
strcmd.AppendFormat(" Where RecordNumber = {0}", nRecNo);
|
| 545 | 542 |
arData.Clear(); |
| 546 | 543 |
if (!DataDB.ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return 0; |
| 544 |
object[] objcnt = (object[])arData[0]; |
|
| 547 | 545 |
// 無ければそのまま |
| 548 |
if (arData.Count < 1) return nRecNo;
|
|
| 546 |
if (CommonMotions.cnvInt(objcnt[0]) < 1) return nRecNo;
|
|
| 549 | 547 |
|
| 550 | 548 |
// あれば削除する |
| 551 | 549 |
DelAllMessageData(DataDB, TergetDB, HistroyDB, nRecNo, bConnect); |
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsDataAttend.cs | ||
|---|---|---|
| 80 | 80 |
|
| 81 | 81 |
#endregion |
| 82 | 82 |
|
| 83 |
#region テーブルのフィールドリストを作成する |
|
| 84 |
/// <summary> |
|
| 85 |
/// テーブルのフィールドリストを作成する |
|
| 86 |
/// </summary> |
|
| 87 |
/// <returns></returns> |
|
| 88 |
public static string CreateFieldNameList(string strAlias = "") |
|
| 89 |
{
|
|
| 90 |
StringBuilder strcmd = new StringBuilder(); |
|
| 91 |
try |
|
| 92 |
{
|
|
| 93 |
strcmd.Append(" ");
|
|
| 94 |
bool bColFirst = true; |
|
| 95 |
string strWork = string.Empty; |
|
| 96 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 97 |
{
|
|
| 98 |
strWork = gender.ToString(); |
|
| 99 |
if (!bColFirst) strcmd.Append(",");
|
|
| 100 |
if (strWork.Equals("WritingDate") || strWork.Equals("EntryDate") || strWork.Equals("UpdateDate"))
|
|
| 101 |
{
|
|
| 102 |
strcmd.AppendFormat(" DATE_FORMAT({0}{1}, '%Y/%m/%d %H:%i:%s') As {1}", strAlias, strWork);
|
|
| 103 |
} |
|
| 104 |
else if (strWork.Equals("ProceedingsDataDate"))
|
|
| 105 |
{
|
|
| 106 |
strcmd.AppendFormat(" DATE_FORMAT({0}{1}, '%Y/%m/%d') As {1}", strAlias, strWork);
|
|
| 107 |
} |
|
| 108 |
else |
|
| 109 |
{
|
|
| 110 |
strcmd.AppendFormat(" {0}{1}", strAlias, strWork);
|
|
| 111 |
} |
|
| 112 |
bColFirst = false; |
|
| 113 |
} |
|
| 114 |
|
|
| 115 |
return strcmd.ToString(); |
|
| 116 |
} |
|
| 117 |
catch (Exception ex) |
|
| 118 |
{
|
|
| 119 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 120 |
return string.Empty; |
|
| 121 |
} |
|
| 122 |
} |
|
| 123 |
#endregion |
|
| 124 |
|
|
| 83 | 125 |
#region SQL作成 |
| 84 | 126 |
/// <summary> |
| 85 | 127 |
/// SQL作成 |
| ... | ... | |
| 88 | 130 |
{
|
| 89 | 131 |
// SQL作成 |
| 90 | 132 |
StringBuilder strcmd = new StringBuilder(); |
| 91 |
strcmd.Append("SELECT");
|
|
| 133 |
try |
|
| 134 |
{
|
|
| 135 |
strcmd.AppendFormat("SELECT {0} FROM ProceedingsDataAttend", CreateFieldNameList());
|
|
| 92 | 136 |
|
| 93 |
strcmd.Append(" ConstructionCode"); // 工事番号
|
|
| 94 |
strcmd.Append(", DATE_FORMAT(ProceedingsDataDate, '%Y/%m/%d')"); // 議事録作成日
|
|
| 95 |
strcmd.Append(", StartMeetingTime"); // 会議時間開始
|
|
| 96 |
strcmd.Append(", SeqNo"); // データ行番号
|
|
| 97 |
strcmd.Append(", Department"); // 出席者所属
|
|
| 98 |
strcmd.Append(", AttendName"); // 出席者氏名
|
|
| 99 |
strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')"); // 更新年月日
|
|
| 100 |
strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')"); // 登録年月日
|
|
| 101 |
strcmd.Append(" FROM ProceedingsDataAttend");
|
|
| 102 |
|
|
| 103 |
return strcmd.ToString(); |
|
| 137 |
return strcmd.ToString(); |
|
| 138 |
} |
|
| 139 |
catch (Exception ex) |
|
| 140 |
{
|
|
| 141 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 142 |
return string.Empty; |
|
| 143 |
} |
|
| 104 | 144 |
} |
| 105 | 145 |
#endregion |
| 106 | 146 |
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOProceedingsDataDetail.cs | ||
|---|---|---|
| 84 | 84 |
|
| 85 | 85 |
#endregion |
| 86 | 86 |
|
| 87 |
#region テーブルのフィールドリストを作成する |
|
| 88 |
/// <summary> |
|
| 89 |
/// テーブルのフィールドリストを作成する |
|
| 90 |
/// </summary> |
|
| 91 |
/// <returns></returns> |
|
| 92 |
public static string CreateFieldNameList(string strAlias = "") |
|
| 93 |
{
|
|
| 94 |
StringBuilder strcmd = new StringBuilder(); |
|
| 95 |
try |
|
| 96 |
{
|
|
| 97 |
strcmd.Append(" ");
|
|
| 98 |
bool bColFirst = true; |
|
| 99 |
string strWork = string.Empty; |
|
| 100 |
foreach (var gender in Enum.GetValues(typeof(TableColumn))) |
|
| 101 |
{
|
|
| 102 |
strWork = gender.ToString(); |
|
| 103 |
if (!bColFirst) strcmd.Append(",");
|
|
| 104 |
if (strWork.Equals("EntryDate") || strWork.Equals("UpdateDate"))
|
|
| 105 |
{
|
|
| 106 |
strcmd.AppendFormat(" DATE_FORMAT({0}{1}, '%Y/%m/%d %H:%i:%s') As {1}", strAlias, strWork);
|
|
| 107 |
} |
|
| 108 |
else if (strWork.Equals("ProceedingsDataDate"))
|
|
| 109 |
{
|
|
| 110 |
strcmd.AppendFormat(" DATE_FORMAT({0}{1}, '%Y/%m/%d') As {1}", strAlias, strWork);
|
|
| 111 |
} |
|
| 112 |
else |
|
| 113 |
{
|
|
| 114 |
strcmd.AppendFormat(" {0}{1}", strAlias, strWork);
|
|
| 115 |
} |
|
| 116 |
bColFirst = false; |
|
| 117 |
} |
|
| 118 |
|
|
| 119 |
return strcmd.ToString(); |
|
| 120 |
} |
|
| 121 |
catch (Exception ex) |
|
| 122 |
{
|
|
| 123 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 124 |
return string.Empty; |
|
| 125 |
} |
|
| 126 |
} |
|
| 127 |
#endregion |
|
| 128 |
|
|
| 87 | 129 |
#region SQL作成 |
| 88 | 130 |
/// <summary> |
| 89 | 131 |
/// SQL作成 |
| ... | ... | |
| 92 | 134 |
{
|
| 93 | 135 |
// SQL作成 |
| 94 | 136 |
StringBuilder strcmd = new StringBuilder(); |
| 137 |
try |
|
| 138 |
{
|
|
| 139 |
strcmd.AppendFormat("SELECT {0} FROM ProceedingsDataDetail", CreateFieldNameList());
|
|
| 95 | 140 |
|
| 96 |
strcmd.Append("SELECT");
|
|
| 97 |
strcmd.Append(" ConstructionCode"); // 工事番号
|
|
| 98 |
strcmd.Append(", DATE_FORMAT(ProceedingsDataDate, '%Y/%m/%d')"); // 議事録作成日
|
|
| 99 |
strcmd.Append(", StartMeetingTime"); // 会議時間開始
|
|
| 100 |
strcmd.Append(", SeqNo"); // データ行番号
|
|
| 101 |
strcmd.Append(", TitleNo"); // 議題番号
|
|
| 102 |
strcmd.Append(", Title"); // 議題
|
|
| 103 |
strcmd.Append(", ContentsText"); // 内容
|
|
| 104 |
strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')"); // 更新年月日
|
|
| 105 |
strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')"); // 登録年月日
|
|
| 106 |
strcmd.Append(" FROM ProceedingsDataDetail");
|
|
| 107 |
|
|
| 108 |
return strcmd.ToString(); |
|
| 141 |
return strcmd.ToString(); |
|
| 142 |
} |
|
| 143 |
catch (Exception ex) |
|
| 144 |
{
|
|
| 145 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 146 |
return string.Empty; |
|
| 147 |
} |
|
| 109 | 148 |
} |
| 110 | 149 |
#endregion |
| 111 | 150 |
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOVehicleScheduleData.cs | ||
|---|---|---|
| 57 | 57 |
|
| 58 | 58 |
#endregion |
| 59 | 59 |
|
| 60 |
#region テーブルのフィールドリストを作成する |
|
| 61 |
/// <summary> |
|
| 62 |
/// テーブルのフィールドリストを作成する |
|
| 63 |
/// </summary> |
|
| 64 |
/// <returns></returns> |
|
| 65 |
public static string CreateFieldNameList(string strAlias = "") |
|
| 66 |
{
|
|
| 67 |
StringBuilder strcmd = new StringBuilder(); |
|
| 68 |
try |
|
| 69 |
{
|
|
| 70 |
strcmd.Append(" ");
|
|
| 71 |
bool bColFirst = true; |
|
| 72 |
string strWork = string.Empty; |
|
| 73 |
foreach (var gender in Enum.GetValues(typeof(NameColumn))) |
|
| 74 |
{
|
|
| 75 |
strWork = gender.ToString(); |
|
| 76 |
if (!bColFirst) strcmd.Append(",");
|
|
| 77 |
if (strWork.Equals("EntryDate") || strWork.Equals("UpdateDate"))
|
|
| 78 |
{
|
|
| 79 |
strcmd.AppendFormat(" DATE_FORMAT({0}{1}, '%Y/%m/%d %H:%i:%s') As {1}", strAlias, strWork);
|
|
| 80 |
} |
|
| 81 |
else if (strWork.Equals("TargetDate"))
|
|
| 82 |
{
|
|
| 83 |
strcmd.AppendFormat(" DATE_FORMAT({0}{1}, '%Y/%m/%d') As {1}", strAlias, strWork);
|
|
| 84 |
} |
|
| 85 |
else |
|
| 86 |
{
|
|
| 87 |
strcmd.AppendFormat(" {0}{1}", strAlias, strWork);
|
|
| 88 |
} |
|
| 89 |
bColFirst = false; |
|
| 90 |
} |
|
| 91 |
|
|
| 92 |
return strcmd.ToString(); |
|
| 93 |
} |
|
| 94 |
catch (Exception ex) |
|
| 95 |
{
|
|
| 96 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 97 |
return string.Empty; |
|
| 98 |
} |
|
| 99 |
} |
|
| 100 |
#endregion |
|
| 101 |
|
|
| 102 |
#region 検索文字列作成 |
|
| 103 |
/// <summary> |
|
| 104 |
/// 検索文字列作成 |
|
| 105 |
/// </summary> |
|
| 106 |
/// <returns></returns> |
|
| 107 |
private string CreateSelectSQL() |
|
| 108 |
{
|
|
| 109 |
StringBuilder strcmd = new StringBuilder(); |
|
| 110 |
try |
|
| 111 |
{
|
|
| 112 |
strcmd.AppendFormat("SELECT {0} FROM VehicleScheduleData", CreateFieldNameList());
|
|
| 113 |
|
|
| 114 |
return strcmd.ToString(); |
|
| 115 |
} |
|
| 116 |
catch (Exception ex) |
|
| 117 |
{
|
|
| 118 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 119 |
return string.Empty; |
|
| 120 |
} |
|
| 121 |
} |
|
| 122 |
#endregion |
|
| 123 |
|
|
| 60 | 124 |
#region 車両予約検索 |
| 61 | 125 |
/// <summary> |
| 62 | 126 |
/// 車両予約検索 |
| ... | ... | |
| 72 | 136 |
|
| 73 | 137 |
try |
| 74 | 138 |
{
|
| 75 |
// SQL作成（DateTime型が変換できないのでCharに変換しておく） |
|
| 76 |
strcmd.Append("SELECT");
|
|
| 77 |
strcmd.Append(" DATE_FORMAT(TargetDate, '%Y/%m/%d')");
|
|
| 78 |
strcmd.Append(", VehicleCode");
|
|
| 79 |
strcmd.Append(", MorningAfternoon");
|
|
| 80 |
strcmd.Append(", PersonCode");
|
|
| 81 |
strcmd.Append(", TargetYear");
|
|
| 82 |
strcmd.Append(", TargetMonth");
|
|
| 83 |
strcmd.Append(", TargetDay");
|
|
| 84 |
strcmd.Append(", DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')");
|
|
| 85 |
strcmd.Append(", DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')");
|
|
| 86 |
strcmd.Append(" FROM VehicleScheduleData");
|
|
| 87 |
strcmd.Append(AddSQLString); |
|
| 139 |
strcmd.AppendFormat("{0}{1}", CreateSelectSQL(), AddSQLString);
|
|
| 88 | 140 |
|
| 89 | 141 |
// SQL実行 |
| 90 | 142 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false; |
| trunk/src/ProcessManagement/ProcessManagement/DataModel/BusinessTypeMaster.cs | ||
|---|---|---|
| 11 | 11 |
public class BusinessTypeMaster |
| 12 | 12 |
{
|
| 13 | 13 |
#region 定数 |
| 14 |
#region 法人格マスタ：法人格名称位置定義 |
|
| 15 |
/// <summary> |
|
| 16 |
/// 法人格名称位置 |
|
| 17 |
/// </summary> |
|
| 18 |
public enum StatusNamePointDef |
|
| 19 |
{
|
|
| 20 |
None = 0, |
|
| 21 |
Forword, |
|
| 22 |
Back, |
|
| 23 |
} |
|
| 24 | 14 |
#endregion |
| 25 |
#endregion |
|
| 26 | 15 |
|
| 27 | 16 |
#region メンバ変数 |
| 28 | 17 |
private int m_BusinessTypeCode = 0; // キー項目 |
| trunk/src/ProcessManagement/ProcessManagement/DataModel/SubContractorMaster.cs | ||
|---|---|---|
| 11 | 11 |
public class SubContractorMaster |
| 12 | 12 |
{
|
| 13 | 13 |
#region 定数 |
| 14 |
|
|
| 14 |
|
|
| 15 |
#region 協力会社マスタ：法人格名称位置定義 |
|
| 16 |
/// <summary> |
|
| 17 |
/// 法人格名称位置 |
|
| 18 |
/// </summary> |
|
| 19 |
public enum StatusNamePointDef |
|
| 20 |
{
|
|
| 21 |
None = 0, |
|
| 22 |
Forword, |
|
| 23 |
Back, |
|
| 24 |
} |
|
| 25 |
#endregion |
|
| 26 |
|
|
| 15 | 27 |
#region 協力会社マスタ：協力業者支払区分 |
| 16 | 28 |
/// <summary> |
| 17 | 29 |
/// 協力業者支払区分 |
| trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalPerson/FrmAppManAux.cs | ||
|---|---|---|
| 2158 | 2158 |
|
| 2159 | 2159 |
// 存在確認を行う |
| 2160 | 2160 |
strSQL.Clear(); |
| 2161 |
strSQL.Append("Select * From AttendanceDailyData");
|
|
| 2161 |
strSQL.Append("Select count(*) From AttendanceDailyData");
|
|
| 2162 | 2162 |
strSQL.Append(" Where (PersonCode, AttendanceDate, SeqNo, WorkKindFlg)");
|
| 2163 | 2163 |
strSQL.Append(strInSel.ToString()); |
| 2164 | 2164 |
ArrayList arList = new ArrayList(); |
| 2165 | 2165 |
dayDB.ExecuteReader(strSQL.ToString(), ref arList, false); |
| 2166 |
if (arList.Count < 1) return true; |
|
| 2166 |
object[] objCnt = (object[])arList[0]; |
|
| 2167 |
if (CommonMotions.cnvInt(objCnt[0]) < 1) return true; |
|
| 2167 | 2168 |
|
| 2168 | 2169 |
strSQL.Clear(); |
| 2169 | 2170 |
strSQL.Append("Delete From AttendanceDailyData");
|
| trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalPerson/FrmApprovalPersonAuxiliary.cs | ||
|---|---|---|
| 1342 | 1342 |
, (m_OrderDate % 100) |
| 1343 | 1343 |
, 1); |
| 1344 | 1344 |
StringBuilder strSQL = new StringBuilder(); |
| 1345 |
strSQL.Append("Select * From chgchargedep A");
|
|
| 1346 |
strSQL.Append(" Left Join(Select PAPP.PersonCode");
|
|
| 1345 |
strSQL.Append("Select ");
|
|
| 1346 |
strSQL.Append(IOMChgChargeDep.CreateFieldNameList("A."));
|
|
| 1347 |
strSQL.Append(" From chgchargedep A");
|
|
| 1348 |
strSQL.Append(" Left Join (Select PAPP.PersonCode");
|
|
| 1347 | 1349 |
strSQL.Append(" , DATE(EntryDate) As PetAppDate");
|
| 1348 | 1350 |
strSQL.Append(" From personapproval As PAPP");
|
| 1349 | 1351 |
strSQL.AppendFormat(" Where PAPP.ApprovalCode = {0}", m_ApprovalCode);
|
| ... | ... | |
| 1611 | 1613 |
|
| 1612 | 1614 |
strSQL.Append(" LEFT JOIN personinchargemaster As PersonM ON PersonM.PersonCode = PersonApp.PersonCode");
|
| 1613 | 1615 |
|
| 1614 |
strSQL.Append(" Inner Join(Select * From ChgChargeDep As H) As ChgMan");
|
|
| 1616 |
strSQL.Append(" Inner Join (Select");
|
|
| 1617 |
strSQL.Append(IOMChgChargeDep.CreateFieldNameList("H."));
|
|
| 1618 |
strSQL.Append(" From ChgChargeDep As H) As ChgMan");
|
|
| 1615 | 1619 |
strSQL.Append(" On ChgMan.PersonCode = P.PersonCode");
|
| 1616 | 1620 |
strSQL.Append(" And(DATE(ChgMan.StartDate) <= DATE(PersonApp.PetitionApprovalDate)");
|
| 1617 | 1621 |
strSQL.Append(" And DATE(PersonApp.PetitionApprovalDate) <= DATE(ChgMan.CompDate))");
|
| 1618 | 1622 |
|
| 1619 | 1623 |
strSQL.Append(" LEFT JOIN approvalmaster As AppM");
|
| 1620 |
strSQL.Append(" ON AppM.ApprovalCode = PersonApp.ApprovalCode");
|
|
| 1621 |
strSQL.Append(" And AppM.DepartmentCode = ChgMan.DepartmentCode");
|
|
| 1624 |
strSQL.Append(" ON AppM.ApprovalCode = PersonApp.ApprovalCode");
|
|
| 1625 |
strSQL.Append(" And AppM.DepartmentCode = ChgMan.DepartmentCode");
|
|
| 1622 | 1626 |
|
| 1623 |
strSQL.Append(" LEFT JOIN personinchargemaster As AppPersonM ON AppPersonM.PersonCode = AppM.ApprovalPerson");
|
|
| 1627 |
strSQL.Append(" LEFT JOIN personinchargemaster As AppPersonM");
|
|
| 1628 |
strSQL.Append(" ON AppPersonM.PersonCode = AppM.ApprovalPerson");
|
|
| 1624 | 1629 |
|
| 1625 | 1630 |
strSQL.Append(" LEFT JOIN paymentdatadetail As payDataDetail");
|
| 1626 |
strSQL.Append(" ON payDataDetail.APPROVALPERSONCODE = PersonApp.PersonCode");
|
|
| 1627 |
strSQL.Append(" And DATE (payDataDetail.APPROVALDATE) = DATE (PersonApp.EntryDate)");
|
|
| 1628 |
strSQL.Append(" And payDataDetail.APPROVALENDFLG = 1");
|
|
| 1631 |
strSQL.Append(" ON payDataDetail.APPROVALPERSONCODE = PersonApp.PersonCode");
|
|
| 1632 |
strSQL.Append(" And DATE (payDataDetail.APPROVALDATE) = DATE (PersonApp.EntryDate)");
|
|
| 1633 |
strSQL.Append(" And payDataDetail.APPROVALENDFLG = 1");
|
|
| 1629 | 1634 |
|
| 1630 | 1635 |
strSQL.Append(" LEFT JOIN paymentapprovalinfo As payAppInfo");
|
| 1631 |
strSQL.Append(" ON payAppInfo.COMPANYCODE = payDataDetail.COMPANYCODE");
|
|
| 1632 |
strSQL.Append(" And payAppInfo.TARGETDATE = payDataDetail.TARGETDATE");
|
|
| 1633 |
strSQL.Append(" And payAppInfo.SEQNO = payDataDetail.SEQNO");
|
|
| 1634 |
strSQL.Append(" And payAppInfo.LINECOUNT = payDataDetail.LINECOUNT");
|
|
| 1635 |
strSQL.Append(" And payAppInfo.APPROVALPERSON = AppM.ApprovalPerson");
|
|
| 1636 |
strSQL.Append(" ON payAppInfo.COMPANYCODE = payDataDetail.COMPANYCODE");
|
|
| 1637 |
strSQL.Append(" And payAppInfo.TARGETDATE = payDataDetail.TARGETDATE");
|
|
| 1638 |
strSQL.Append(" And payAppInfo.SEQNO = payDataDetail.SEQNO");
|
|
| 1639 |
strSQL.Append(" And payAppInfo.LINECOUNT = payDataDetail.LINECOUNT");
|
|
| 1640 |
strSQL.Append(" And payAppInfo.APPROVALPERSON = AppM.ApprovalPerson");
|
|
| 1636 | 1641 |
|
| 1637 | 1642 |
strSQL.Append(" Where");
|
| 1638 | 1643 |
strSQL.AppendFormat(" PersonApp.PersonCode = {0}", m_PersonCode);
|
| trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalScreen/FrmAppScrnAux.cs | ||
|---|---|---|
| 56 | 56 |
// ----- 製品版（一人親方バージョン） |
| 57 | 57 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType2_1: |
| 58 | 58 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType2_2: |
| 59 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType3: |
|
| 60 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType4: |
|
| 61 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType5: |
|
| 62 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType6: |
|
| 59 | 63 |
// ----- 製品版（承認バージョン） |
| 60 | 64 |
break; |
| 61 | 65 |
default: |
| ... | ... | |
| 83 | 87 |
// ----- 製品版（一人親方バージョン） |
| 84 | 88 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType2_1: |
| 85 | 89 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType2_2: |
| 90 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType3: |
|
| 91 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType4: |
|
| 92 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType5: |
|
| 93 |
case (int)ProductDefine.ProductTypeDef.ProductsModelType6: |
|
| 86 | 94 |
// ----- 製品版（承認バージョン） |
| 87 | 95 |
break; |
| 88 | 96 |
default: |
| trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/ApprovalScreen/FrmApprovalScreenAuxiliary.cs | ||
|---|---|---|
| 199 | 199 |
// 増減工事の子データのみ表示 |
| 200 | 200 |
StringBuilder strSQL = new StringBuilder(); |
| 201 | 201 |
strSQL.Append("SELECT");
|
| 202 |
strSQL.Append(" *");
|
|
| 202 |
strSQL.Append(" count(*)");
|
|
| 203 | 203 |
strSQL.Append(" FROM");
|
| 204 | 204 |
strSQL.Append(" CONSTRUCTIONLINK A");
|
| 205 | 205 |
strSQL.Append(", CONSTRUCTIONLEDGER B");
|
| ... | ... | |
| 207 | 207 |
strSQL.Append(" AND B.CONSTRUCTIONCODE = A.CONSTRUCTIONCODE");
|
| 208 | 208 |
ArrayList arList = new ArrayList(); |
| 209 | 209 |
if (!LinkDB.ExecuteReader(strSQL.ToString(), ref arList)) return false; |
| 210 |
if (arList.Count == 0) return false; |
|
| 210 |
object[] objCnt = (object[])arList[0]; |
|
| 211 |
if (CommonMotions.cnvInt(objCnt[0]) == 0) return false; |
|
| 211 | 212 |
|
| 212 | 213 |
return true; |
| 213 | 214 |
} |
| trunk/src/ProcessManagement/ProcessManagement/Forms/DataEntry/AverageScore/FrmAverageScore.designer.cs | ||
|---|---|---|
| 282 | 282 |
this.radioButton1.Size = new System.Drawing.Size(127, 19); |
他の形式にエクスポート: Unified diff