リビジョン 237
積算見積書印刷バグ修正（担当者マスタ項目追加対応）
安全パトロール申請追加
StringBuilder化追加
協力会社マスタ、協力会社ダイアログ表示順修正
| branches/src/ProcessManagement/ProcessManagement/Common/CommonMotions.cs | ||
|---|---|---|
| 2084 | 2084 |
/// <returns></returns> |
| 2085 | 2085 |
public static string ComentSucstring(string Mijiretu, string Delimiter) |
| 2086 | 2086 |
{
|
| 2087 |
string strRet = Mijiretu; |
|
| 2087 | 2088 |
try |
| 2088 | 2089 |
{
|
| 2089 |
if (Mijiretu.IndexOf(Delimiter) < 0) return Mijiretu; |
|
| 2090 | 2090 |
|
| 2091 |
string strRet = Mijiretu.Substring(0, Mijiretu.IndexOf(Delimiter) - 1); |
|
| 2091 |
if (Mijiretu.IndexOf(Delimiter) < 0) return strRet; |
|
| 2092 |
int TargetCnt = Mijiretu.IndexOf(Delimiter) - 1; |
|
| 2093 |
|
|
| 2094 |
if (TargetCnt>0) |
|
| 2095 |
strRet = Mijiretu.Substring(0, TargetCnt); |
|
| 2092 | 2096 |
|
| 2093 | 2097 |
return strRet; |
| 2094 | 2098 |
} |
| branches/src/ProcessManagement/ProcessManagement/Common/CommonVersion.cs | ||
|---|---|---|
| 14 | 14 |
/// <summary> |
| 15 | 15 |
/// 本体バージョン |
| 16 | 16 |
/// </summary> |
| 17 |
public static int s_SystemVersion = 56;
|
|
| 17 |
public static int s_SystemVersion = 57;
|
|
| 18 | 18 |
|
| 19 | 19 |
/// <summary> |
| 20 | 20 |
/// コピー・環境バージョン |
| branches/src/ProcessManagement/ProcessManagement/Common/Process/ClsExcute.cs | ||
|---|---|---|
| 87 | 87 |
PurchaseStatusInput = 40, // 40:注文書状況入力 |
| 88 | 88 |
ReqBillingStatus = 41, // 41:請求書発給一覧 |
| 89 | 89 |
ReqBillingStatInput = 42, // 42:請求書状況入力 |
| 90 |
SafetyPatrol = 43, // 43:安全パトロール申請 |
|
| 90 | 91 |
} |
| 91 | 92 |
#endregion |
| 92 | 93 |
|
| ... | ... | |
| 109 | 110 |
BusinessType = 111, // 111:法人格マスタ |
| 110 | 111 |
//Division = 112, // 112:区分マスタ |
| 111 | 112 |
//Expenses = 113, // 113:経費率マスタ |
| 112 |
SubContractorItem = 114, // 114:協力会社工種マスタ
|
|
| 113 |
SubContrItem = 114, // 114:協力会社工種マスタ
|
|
| 113 | 114 |
Calender = 115, // 115:カレンダーマスタ |
| 114 | 115 |
VehicleMaster = 116, // 116:車両マスタ |
| 115 | 116 |
TermMaster = 117, // 117:期限マスタ |
| ... | ... | |
| 118 | 119 |
ConstructionType = 120, // 120:工事種別マスタ |
| 119 | 120 |
AlwaysEmployment = 121, // 121:常雇者マスタ |
| 120 | 121 |
Suppliers = 122, // 122:仕入先マスタ |
| 121 |
SubContractorJobCategory = 123, // 123:協力会社職種マスタ
|
|
| 122 |
SubContrJobCat = 123, // 123:協力会社職種マスタ
|
|
| 122 | 123 |
Security = 124, // 124:セキュリティ区分マスタ |
| 123 | 124 |
OrderDivision = 125, // 125:発注者区分登録 |
| 124 |
ConstructionExpenses = 126, // 126:施工経費区分登録
|
|
| 125 |
ConstrExpenses = 126, // 126:施工経費区分登録
|
|
| 125 | 126 |
MaterialKind = 127, // 127:資材種類マスタ |
| 126 | 127 |
MaterialItem = 128, // 128:資材品目マスタ |
| 127 | 128 |
SalesConfirm = 129, // 129:売上確認 |
| ... | ... | |
| 194 | 195 |
{ (int)ProcessExecuteNo.PurchaseStatusInput, "注文書状況－入力"},
|
| 195 | 196 |
{ (int)ProcessExecuteNo.ReqBillingStatus, "請求書発給一覧－表示"},
|
| 196 | 197 |
{ (int)ProcessExecuteNo.ReqBillingStatInput, "請求書状況－入力"},
|
| 198 |
{ (int)ProcessExecuteNo.SafetyPatrol, "安全パトロール申請"},
|
|
| 199 |
|
|
| 197 | 200 |
}; |
| 198 | 201 |
|
| 199 | 202 |
#endregion |
| ... | ... | |
| 216 | 219 |
{ (int)MaintenanceExecuteNo.BusinessType, "法人格登録"}, // 111
|
| 217 | 220 |
//{ (int)MaintenanceExecuteNo.Division, "区分登録"}, // 112
|
| 218 | 221 |
//{ (int)MaintenanceExecuteNo.Expenses, "経費率登録"}, // 113
|
| 219 |
{ (int)MaintenanceExecuteNo.SubContractorItem, "協力会社工種登録"}, // 114
|
|
| 222 |
{ (int)MaintenanceExecuteNo.SubContrItem, "協力会社工種登録"}, // 114
|
|
| 220 | 223 |
{ (int)MaintenanceExecuteNo.Calender, "カレンダー登録"}, // 115
|
| 221 | 224 |
{ (int)MaintenanceExecuteNo.VehicleMaster, "車両登録"}, // 116
|
| 222 | 225 |
{ (int)MaintenanceExecuteNo.TermMaster, "期限登録"}, // 117
|
| ... | ... | |
| 225 | 228 |
{ (int)MaintenanceExecuteNo.ConstructionType, "工事種別登録"}, // 120
|
| 226 | 229 |
{ (int)MaintenanceExecuteNo.AlwaysEmployment, "常雇者登録"}, // 121
|
| 227 | 230 |
{ (int)MaintenanceExecuteNo.Suppliers, "仕入先登録"}, // 122
|
| 228 |
{ (int)MaintenanceExecuteNo.SubContractorJobCategory, "協力会社職種登録"}, // 123
|
|
| 231 |
{ (int)MaintenanceExecuteNo.SubContrJobCat, "協力会社職種登録"}, // 123
|
|
| 229 | 232 |
{ (int)MaintenanceExecuteNo.Security, "セキュリティ区分登録"}, // 124
|
| 230 | 233 |
{ (int)MaintenanceExecuteNo.OrderDivision, "発注者区分登録"}, // 125
|
| 231 |
{ (int)MaintenanceExecuteNo.ConstructionExpenses, "施工経費区分登録"}, // 126
|
|
| 234 |
{ (int)MaintenanceExecuteNo.ConstrExpenses, "施工経費区分登録"}, // 126
|
|
| 232 | 235 |
{ (int)MaintenanceExecuteNo.MaterialKind, "資材種類登録"}, // 127
|
| 233 | 236 |
{ (int)MaintenanceExecuteNo.MaterialItem, "資材品目登録"}, // 128
|
| 234 | 237 |
{ (int)MaintenanceExecuteNo.SalesConfirm, "売上確認"}, // 129
|
| ... | ... | |
| 310 | 313 |
/// 12:業者支払 |
| 311 | 314 |
/// </summary> |
| 312 | 315 |
SubConstrPayment, |
| 316 |
/// <summary> |
|
| 317 |
/// 13:安全パトロール |
|
| 318 |
/// </summary> |
|
| 319 |
SafetyPatrol, |
|
| 313 | 320 |
} |
| 314 | 321 |
#endregion |
| 315 | 322 |
|
| ... | ... | |
| 350 | 357 |
{10, "協力会社登録承認"},
|
| 351 | 358 |
{11, "手間支払承認"},
|
| 352 | 359 |
{12, "業者支払承認"},
|
| 360 |
{13, "安全パトロール承認"},
|
|
| 353 | 361 |
}; |
| 354 | 362 |
|
| 355 | 363 |
#endregion |
| ... | ... | |
| 650 | 658 |
ProcessExecuteNo_ReqBillingStatInput(m_ProcControlPara[NowPoint]); |
| 651 | 659 |
break; |
| 652 | 660 |
|
| 661 |
case (int)ProcessExecuteNo.SafetyPatrol: // 43:安全パトロール申請 |
|
| 662 |
ProcessExecuteNo_SafetyPatrol(m_ProcControlPara[NowPoint]); |
|
| 663 |
break; |
|
| 664 |
|
|
| 653 | 665 |
#endregion |
| 654 | 666 |
|
| 655 | 667 |
#region マスタメンテ |
| 656 | 668 |
// ----- マスタメンテ |
| 657 |
case (int)MaintenanceExecuteNo.System: // 1:システム管理
|
|
| 669 |
case (int)MaintenanceExecuteNo.System: // 1011:システム管理
|
|
| 658 | 670 |
MaintenanceExecuteNo_System(m_ProcControlPara[NowPoint]); |
| 659 | 671 |
break; |
| 660 |
case (int)MaintenanceExecuteNo.Department: // 2:部署マスタ
|
|
| 672 |
case (int)MaintenanceExecuteNo.Department: // 1012:部署マスタ
|
|
| 661 | 673 |
MaintenanceExecuteNo_Department(m_ProcControlPara[NowPoint]); |
| 662 | 674 |
break; |
| 663 |
case (int)MaintenanceExecuteNo.PersonInCharge: // 3:担当者マスタ
|
|
| 675 |
case (int)MaintenanceExecuteNo.PersonInCharge: // 1013:担当者マスタ
|
|
| 664 | 676 |
MaintenanceExecuteNo_PersonInCharge(m_ProcControlPara[NowPoint]); |
| 665 | 677 |
break; |
| 666 |
case (int)MaintenanceExecuteNo.Component: // 4:大項目マスタ（構成マスタ）
|
|
| 678 |
case (int)MaintenanceExecuteNo.Component: // 1014:大項目マスタ（構成マスタ）
|
|
| 667 | 679 |
MaintenanceExecuteNo_Component(m_ProcControlPara[NowPoint]); |
| 668 | 680 |
break; |
| 669 |
case (int)MaintenanceExecuteNo.ConstructionItem: // 5:中項目マスタ（工種マスタ）
|
|
| 681 |
case (int)MaintenanceExecuteNo.ConstructionItem: // 1015:中項目マスタ（工種マスタ）
|
|
| 670 | 682 |
MaintenanceExecuteNo_ConstructionItem(m_ProcControlPara[NowPoint]); |
| 671 | 683 |
break; |
| 672 |
case (int)MaintenanceExecuteNo.ConstructionWork: // 6:小項目マスタ（作業マスタ）
|
|
| 684 |
case (int)MaintenanceExecuteNo.ConstructionWork: // 1016:小項目マスタ（作業マスタ）
|
|
| 673 | 685 |
MaintenanceExecuteNo_ConstructionWork(m_ProcControlPara[NowPoint]); |
| 674 | 686 |
break; |
| 675 |
case (int)MaintenanceExecuteNo.Unit: // 7:単位マスタ
|
|
| 687 |
case (int)MaintenanceExecuteNo.Unit: // 1017:単位マスタ
|
|
| 676 | 688 |
MaintenanceExecuteNo_UnitMaster(m_ProcControlPara[NowPoint]); |
| 677 | 689 |
break; |
| 678 |
case (int)MaintenanceExecuteNo.SubContractor: // 8:協力会社マスタ
|
|
| 690 |
case (int)MaintenanceExecuteNo.SubContractor: // 1018:協力会社マスタ
|
|
| 679 | 691 |
MaintenanceExecuteNo_SubContractor(m_ProcControlPara[NowPoint]); |
| 680 | 692 |
break; |
| 681 |
case (int)MaintenanceExecuteNo.Orderers: // 9:発注者マスタ
|
|
| 693 |
case (int)MaintenanceExecuteNo.Orderers: // 1019:発注者マスタ
|
|
| 682 | 694 |
MaintenanceExecuteNo_Orderers(m_ProcControlPara[NowPoint]); |
| 683 | 695 |
break; |
| 684 |
case (int)MaintenanceExecuteNo.BusinessType: // 10:法人格マスタ
|
|
| 696 |
case (int)MaintenanceExecuteNo.BusinessType: // 110:法人格マスタ
|
|
| 685 | 697 |
MaintenanceExecuteNo_BusinessType(m_ProcControlPara[NowPoint]); |
| 686 | 698 |
break; |
| 687 |
//case (int)MaintenanceExecuteNo.Division: // 11:区分マスタ
|
|
| 699 |
//case (int)MaintenanceExecuteNo.Division: // 111:区分マスタ
|
|
| 688 | 700 |
// MaintenanceExecuteNo_Division(m_ProcControlPara[NowPoint]); |
| 689 | 701 |
// break; |
| 690 |
//case (int)MaintenanceExecuteNo.Expenses: // 12:経費率マスタ
|
|
| 702 |
//case (int)MaintenanceExecuteNo.Expenses: // 112:経費率マスタ
|
|
| 691 | 703 |
// MaintenanceExecuteNo_Expenses(m_ProcControlPara[NowPoint]); |
| 692 | 704 |
// break; |
| 693 |
case (int)MaintenanceExecuteNo.SubContractorItem: // 13:協力会社工種マスタ
|
|
| 705 |
case (int)MaintenanceExecuteNo.SubContrItem: // 113:協力会社工種マスタ
|
|
| 694 | 706 |
MaintenanceExecuteNo_SubContractorItem(m_ProcControlPara[NowPoint]); |
| 695 | 707 |
break; |
| 696 |
case (int)MaintenanceExecuteNo.Calender: // 14:カレンダーマスタ
|
|
| 708 |
case (int)MaintenanceExecuteNo.Calender: // 114:カレンダーマスタ
|
|
| 697 | 709 |
MaintenanceExecuteNo_Calender(m_ProcControlPara[NowPoint]); |
| 698 | 710 |
break; |
| 699 |
case (int)MaintenanceExecuteNo.VehicleMaster: // 15:車両マスタ
|
|
| 711 |
case (int)MaintenanceExecuteNo.VehicleMaster: // 115:車両マスタ
|
|
| 700 | 712 |
MaintenanceExecuteNo_VehicleMaster(m_ProcControlPara[NowPoint]); |
| 701 | 713 |
break; |
| 702 |
case (int)MaintenanceExecuteNo.TermMaster: // 16:期限マスタ
|
|
| 714 |
case (int)MaintenanceExecuteNo.TermMaster: // 116:期限マスタ
|
|
| 703 | 715 |
MaintenanceExecuteNo_TermMaster(m_ProcControlPara[NowPoint]); |
| 704 | 716 |
break; |
| 705 |
case (int)MaintenanceExecuteNo.SaleSalesGraphData: // 17:売上グラフデータ入力
|
|
| 717 |
case (int)MaintenanceExecuteNo.SaleSalesGraphData: // 117:売上グラフデータ入力
|
|
| 706 | 718 |
MaintenanceExecuteNo_SalesGraphData(m_ProcControlPara[NowPoint]); |
| 707 | 719 |
break; |
| 708 |
case (int)MaintenanceExecuteNo.ApprovalRoute: // 18:承認経路マスタ
|
|
| 720 |
case (int)MaintenanceExecuteNo.ApprovalRoute: // 118:承認経路マスタ
|
|
| 709 | 721 |
MaintenanceExecuteNo_ApprovalRoute(m_ProcControlPara[NowPoint]); |
| 710 | 722 |
break; |
| 711 |
case (int)MaintenanceExecuteNo.ConstructionType: // 19:工事種別マスタ
|
|
| 723 |
case (int)MaintenanceExecuteNo.ConstructionType: // 119:工事種別マスタ
|
|
| 712 | 724 |
MaintenanceExecuteNo_ConstructionType(m_ProcControlPara[NowPoint]); |
| 713 | 725 |
break; |
| 714 |
case (int)MaintenanceExecuteNo.ComponentLink: // 20:大・中項目関連マスタ
|
|
| 726 |
case (int)MaintenanceExecuteNo.ComponentLink: // 120:大・中項目関連マスタ
|
|
| 715 | 727 |
MaintenanceExecuteNo_ComponentLink(m_ProcControlPara[NowPoint]); |
| 716 | 728 |
break; |
| 717 |
case (int)MaintenanceExecuteNo.AlwaysEmployment: // 21:常雇者マスタ
|
|
| 729 |
case (int)MaintenanceExecuteNo.AlwaysEmployment: // 121:常雇者マスタ
|
|
| 718 | 730 |
MaintenanceExecuteNo_AlwaysEmployment(m_ProcControlPara[NowPoint]); |
| 719 | 731 |
break; |
| 720 |
case (int)MaintenanceExecuteNo.Suppliers: // 22:仕入先マスタ
|
|
| 732 |
case (int)MaintenanceExecuteNo.Suppliers: // 122:仕入先マスタ
|
|
| 721 | 733 |
MaintenanceExecuteNo_Suppliers(m_ProcControlPara[NowPoint]); |
| 722 | 734 |
break; |
| 723 |
case (int)MaintenanceExecuteNo.SubContractorJobCategory: // 23:協力会社職種マスタ
|
|
| 735 |
case (int)MaintenanceExecuteNo.SubContrJobCat: // 123:協力会社職種マスタ
|
|
| 724 | 736 |
MaintenanceExecuteNo_SubContractorJobCategory(m_ProcControlPara[NowPoint]); |
| 725 | 737 |
break; |
| 726 |
case (int)MaintenanceExecuteNo.Security: // 24:セキュリティ区分マスタ
|
|
| 738 |
case (int)MaintenanceExecuteNo.Security: // 124:セキュリティ区分マスタ
|
|
| 727 | 739 |
MaintenanceExecuteNo_Security(m_ProcControlPara[NowPoint]); |
| 728 | 740 |
break; |
| 729 |
case (int)MaintenanceExecuteNo.OrderDivision: // 125:発注者区分登録 |
|
| 741 |
case (int)MaintenanceExecuteNo.OrderDivision: // 125:発注者区分登録
|
|
| 730 | 742 |
MaintenanceExecuteNo_OrderDivision(m_ProcControlPara[NowPoint]); |
| 731 | 743 |
break; |
| 732 |
case (int)MaintenanceExecuteNo.ConstructionExpenses: // 126:施工経費区分登録
|
|
| 744 |
case (int)MaintenanceExecuteNo.ConstrExpenses: // 126:施工経費区分登録
|
|
| 733 | 745 |
MaintenanceExecuteNo_ConstructionExpenses(m_ProcControlPara[NowPoint]); |
| 734 | 746 |
break; |
| 735 |
case (int)MaintenanceExecuteNo.MaterialKind: // 127:資材種類マスタ |
|
| 747 |
case (int)MaintenanceExecuteNo.MaterialKind: // 127:資材種類マスタ
|
|
| 736 | 748 |
MaintenanceExecuteNo_MaterialKind(m_ProcControlPara[NowPoint]); |
| 737 | 749 |
break; |
| 738 |
case (int)MaintenanceExecuteNo.MaterialItem: // 128:資材品目マスタ |
|
| 750 |
case (int)MaintenanceExecuteNo.MaterialItem: // 128:資材品目マスタ
|
|
| 739 | 751 |
MaintenanceExecuteNo_MaterialItems(m_ProcControlPara[NowPoint]); |
| 740 | 752 |
break; |
| 741 |
case (int)MaintenanceExecuteNo.SalesConfirm: // 129:売上確認 |
|
| 753 |
case (int)MaintenanceExecuteNo.SalesConfirm: // 129:売上確認
|
|
| 742 | 754 |
MaintenanceExecuteNo_SalesConfirm(m_ProcControlPara[NowPoint]); |
| 743 | 755 |
break; |
| 744 | 756 |
|
| ... | ... | |
| 2553 | 2565 |
} |
| 2554 | 2566 |
#endregion |
| 2555 | 2567 |
|
| 2568 |
#region 安全パトロール申請 |
|
| 2569 |
/// <summary> |
|
| 2570 |
/// 安全パトロール申請 |
|
| 2571 |
/// </summary> |
|
| 2572 |
/// <returns></returns> |
|
| 2573 |
public static void ProcessExecuteNo_SafetyPatrol(ProcessParameter CurrentPara) |
|
| 2574 |
{
|
|
| 2575 |
// 安全パトロール申請 |
|
| 2576 |
FrmSafetyPatrol frm = new FrmSafetyPatrol(); |
|
| 2577 |
try |
|
| 2578 |
{
|
|
| 2579 |
// 自分のハンドルをリストへセットする |
|
| 2580 |
int ProcessNo = (int)ClsExcute.ProcessExecuteNo.ConstructionBaseInfo; |
|
| 2581 |
ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = ProcessNo; |
|
| 2582 |
ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = (Form)frm; |
|
| 2583 |
|
|
| 2584 |
// 起動・編集フラグ |
|
| 2585 |
int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference; |
|
| 2586 |
ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg); |
|
| 2587 |
if (EditFlg == (int)CommonDefine.ProcessDataEdit.Reference) frm.EditLock = true; |
|
| 2588 |
|
|
| 2589 |
// パラメータセット |
|
| 2590 |
frm.ConstructionCode = CurrentPara.IntExecParameter[0]; |
|
| 2591 |
|
|
| 2592 |
// フォーム表示 |
|
| 2593 |
frm.ShowDialog(); |
|
| 2594 |
} |
|
| 2595 |
catch (Exception ex) |
|
| 2596 |
{
|
|
| 2597 |
logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
|
|
| 2598 |
BackProcess(); |
|
| 2599 |
} |
|
| 2600 |
finally |
|
| 2601 |
{
|
|
| 2602 |
frm.Dispose(); frm = null; |
|
| 2603 |
} |
|
| 2604 |
} |
|
| 2556 | 2605 |
#endregion |
| 2557 | 2606 |
|
| 2607 |
#endregion |
|
| 2608 |
|
|
| 2558 | 2609 |
#region マスタメンテナンス |
| 2559 | 2610 |
// ----------------- メンテナンス起動 |
| 2560 | 2611 |
#region 管理マスタ |
| ... | ... | |
| 2919 | 2970 |
try |
| 2920 | 2971 |
{
|
| 2921 | 2972 |
// 起動・編集フラグ |
| 2922 |
int ProcessNo = (int)MaintenanceExecuteNo.SubContractorItem;
|
|
| 2973 |
int ProcessNo = (int)MaintenanceExecuteNo.SubContrItem; |
|
| 2923 | 2974 |
int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference; |
| 2924 | 2975 |
if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg)) |
| 2925 | 2976 |
{
|
| ... | ... | |
| 3264 | 3315 |
try |
| 3265 | 3316 |
{
|
| 3266 | 3317 |
// 起動・編集フラグ |
| 3267 |
int ProcessNo = (int)MaintenanceExecuteNo.SubContractorJobCategory;
|
|
| 3318 |
int ProcessNo = (int)MaintenanceExecuteNo.SubContrJobCat;
|
|
| 3268 | 3319 |
int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference; |
| 3269 | 3320 |
if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg)) |
| 3270 | 3321 |
{
|
| ... | ... | |
| 3370 | 3421 |
try |
| 3371 | 3422 |
{
|
| 3372 | 3423 |
// 起動・編集フラグ |
| 3373 |
int ProcessNo = (int)MaintenanceExecuteNo.ConstructionExpenses;
|
|
| 3424 |
int ProcessNo = (int)MaintenanceExecuteNo.ConstrExpenses; |
|
| 3374 | 3425 |
int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference; |
| 3375 | 3426 |
if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg)) |
| 3376 | 3427 |
{
|
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMDivision.cs | ||
|---|---|---|
| 55 | 55 |
|
| 56 | 56 |
#endregion |
| 57 | 57 |
|
| 58 |
#region パブリックメソッド
|
|
| 58 |
#region 名称マスタ検索SQL作成
|
|
| 59 | 59 |
/// <summary> |
| 60 | 60 |
/// 名称マスタ検索 |
| 61 | 61 |
/// </summary> |
| ... | ... | |
| 79 | 79 |
|
| 80 | 80 |
return strcmd.ToString(); |
| 81 | 81 |
} |
| 82 |
#endregion |
|
| 83 |
|
|
| 84 |
#region 名称マスタ検索(複数) |
|
| 85 |
/// <summary> |
|
| 86 |
/// 名称マスタ検索(複数) |
|
| 87 |
/// </summary> |
|
| 88 |
/// <param name="AddSQLString"></param> |
|
| 89 |
/// <param name="data"></param> |
|
| 90 |
/// <param name="bConnect"></param> |
|
| 91 |
/// <returns></returns> |
|
| 82 | 92 |
public bool SelectAction(string AddSQLString, ref List<DivisionMaster> data, bool bConnect = true) |
| 83 | 93 |
{
|
| 84 | 94 |
// インターフェース |
| ... | ... | |
| 110 | 120 |
} |
| 111 | 121 |
|
| 112 | 122 |
} |
| 123 |
#endregion |
|
| 124 |
|
|
| 125 |
#region 名称マスタ検索(1件) |
|
| 126 |
/// <summary> |
|
| 127 |
/// 名称マスタ検索(1件) |
|
| 128 |
/// </summary> |
|
| 129 |
/// <param name="AddSQLString"></param> |
|
| 130 |
/// <param name="data"></param> |
|
| 131 |
/// <param name="bConnect"></param> |
|
| 132 |
/// <returns></returns> |
|
| 113 | 133 |
public bool SelectAction(string AddSQLString, ref DivisionMaster data, bool bConnect = true) |
| 114 | 134 |
{
|
| 115 | 135 |
// インターフェース |
| ... | ... | |
| 141 | 161 |
} |
| 142 | 162 |
|
| 143 | 163 |
} |
| 164 |
#endregion |
|
| 144 | 165 |
|
| 166 |
#region 名称マスタ追加 |
|
| 145 | 167 |
/// <summary> |
| 146 | 168 |
/// 名称マスタ追加 |
| 147 | 169 |
/// </summary> |
| ... | ... | |
| 192 | 214 |
return false; |
| 193 | 215 |
} |
| 194 | 216 |
} |
| 217 |
#endregion |
|
| 195 | 218 |
|
| 219 |
#region 名称マスタ更新 |
|
| 196 | 220 |
/// <summary> |
| 197 | 221 |
/// 名称マスタ更新 |
| 198 | 222 |
/// </summary> |
| ... | ... | |
| 228 | 252 |
return false; |
| 229 | 253 |
} |
| 230 | 254 |
} |
| 255 |
#endregion |
|
| 231 | 256 |
|
| 232 |
|
|
| 257 |
#region 名称マスタ削除 |
|
| 233 | 258 |
/// <summary> |
| 234 | 259 |
/// 名称マスタ削除 |
| 235 | 260 |
/// </summary> |
| ... | ... | |
| 254 | 279 |
return false; |
| 255 | 280 |
} |
| 256 | 281 |
} |
| 282 |
#endregion |
|
| 257 | 283 |
|
| 284 |
#region 名称マスタ論理削除 |
|
| 258 | 285 |
/// <summary> |
| 259 | 286 |
/// 論理削除 |
| 260 | 287 |
/// </summary> |
| ... | ... | |
| 289 | 316 |
return false; |
| 290 | 317 |
} |
| 291 | 318 |
} |
| 319 |
#endregion |
|
| 320 |
|
|
| 321 |
#region OracleDataReaderより構造体へセットする |
|
| 292 | 322 |
/// <summary> |
| 293 | 323 |
/// OracleDataReaderより構造体へセットする |
| 294 | 324 |
/// </summary> |
| ... | ... | |
| 317 | 347 |
logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
|
| 318 | 348 |
} |
| 319 | 349 |
} |
| 320 |
|
|
| 321 | 350 |
#endregion |
| 322 | 351 |
|
| 323 |
#region パブリックメソッド（特殊処理） |
|
| 324 |
|
|
| 352 |
#region 区分別の最大値を取得する |
|
| 325 | 353 |
/// <summary> |
| 326 | 354 |
/// 区分別の最大値を取得する |
| 327 | 355 |
/// </summary> |
| ... | ... | |
| 358 | 386 |
|
| 359 | 387 |
return iRet; |
| 360 | 388 |
} |
| 389 |
#endregion |
|
| 361 | 390 |
|
| 391 |
#region 主キー検索の文字列を返す |
|
| 362 | 392 |
/// <summary> |
| 363 | 393 |
/// 主キー検索の文字列を返す |
| 364 | 394 |
/// </summary> |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMExpenses.cs | ||
|---|---|---|
| 55 | 55 |
|
| 56 | 56 |
#endregion |
| 57 | 57 |
|
| 58 |
#region パブリックメソッド
|
|
| 58 |
#region 経費率マスタ検索SQL作成
|
|
| 59 | 59 |
/// <summary> |
| 60 | 60 |
/// 経費率マスタ検索 |
| 61 | 61 |
/// </summary> |
| ... | ... | |
| 64 | 64 |
/// <returns>true：成功 false：失敗</returns> |
| 65 | 65 |
private string CreateSelectSQL() |
| 66 | 66 |
{
|
| 67 |
string strcmd = "SELECT"; |
|
| 67 |
StringBuilder strcmd = new StringBuilder(); |
|
| 68 |
strcmd.Append("SELECT");
|
|
| 68 | 69 |
|
| 69 |
strcmd += " DivisionCode";
|
|
| 70 |
strcmd += " ,NameCode";
|
|
| 71 |
strcmd += " ,DisplayOrder";
|
|
| 72 |
strcmd += " ,ExpensesRaito";
|
|
| 73 |
strcmd += " ,DeleteFlg";
|
|
| 70 |
strcmd.Append(" DivisionCode");
|
|
| 71 |
strcmd.Append(" ,NameCode");
|
|
| 72 |
strcmd.Append(" ,DisplayOrder");
|
|
| 73 |
strcmd.Append(" ,ExpensesRaito");
|
|
| 74 |
strcmd.Append(" ,DeleteFlg");
|
|
| 74 | 75 |
|
| 75 |
strcmd += " ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')";
|
|
| 76 |
strcmd += " ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')";
|
|
| 77 |
strcmd += " FROM ExpensesMaster";
|
|
| 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 ExpensesMaster");
|
|
| 78 | 79 |
|
| 79 |
return strcmd; |
|
| 80 |
return strcmd.ToString();
|
|
| 80 | 81 |
} |
| 82 |
#endregion |
|
| 83 |
|
|
| 84 |
#region 経費率マスタ検索(複数) |
|
| 85 |
/// <summary> |
|
| 86 |
/// 経費率マスタ検索(複数) |
|
| 87 |
/// </summary> |
|
| 88 |
/// <param name="AddSQLString"></param> |
|
| 89 |
/// <param name="data"></param> |
|
| 90 |
/// <param name="bConnect"></param> |
|
| 91 |
/// <returns></returns> |
|
| 81 | 92 |
public bool SelectAction(string AddSQLString, ref List<ExpensesMaster> data, bool bConnect = true) |
| 82 | 93 |
{
|
| 83 | 94 |
// インターフェース |
| 84 |
string strcmd = "";
|
|
| 95 |
StringBuilder strcmd = new StringBuilder();
|
|
| 85 | 96 |
ArrayList arData = new ArrayList(); |
| 86 | 97 |
|
| 87 | 98 |
try |
| 88 | 99 |
{
|
| 89 | 100 |
// SQL作成（DateTime型が変換できないのでCharに変換しておく） |
| 90 |
strcmd = CreateSelectSQL() + AddSQLString; |
|
| 101 |
strcmd.Append(CreateSelectSQL()); |
|
| 102 |
strcmd.Append(AddSQLString); |
|
| 91 | 103 |
|
| 92 | 104 |
// SQL実行 |
| 93 |
if (!ExecuteReader(strcmd, ref arData, bConnect)) return false; |
|
| 105 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
|
|
| 94 | 106 |
|
| 95 | 107 |
// データセット |
| 96 | 108 |
foreach (object[] objwrk in arData) |
| ... | ... | |
| 104 | 116 |
} |
| 105 | 117 |
catch (Exception ex) |
| 106 | 118 |
{
|
| 107 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 119 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 108 | 120 |
return false; |
| 109 | 121 |
} |
| 110 | 122 |
|
| 111 | 123 |
} |
| 124 |
#endregion |
|
| 125 |
|
|
| 126 |
#region 経費率マスタ検索(1件) |
|
| 127 |
/// <summary> |
|
| 128 |
/// 経費率マスタ検索(1件) |
|
| 129 |
/// </summary> |
|
| 130 |
/// <param name="AddSQLString"></param> |
|
| 131 |
/// <param name="data"></param> |
|
| 132 |
/// <param name="bConnect"></param> |
|
| 133 |
/// <returns></returns> |
|
| 112 | 134 |
public bool SelectAction(string AddSQLString, ref ExpensesMaster data, bool bConnect = true) |
| 113 | 135 |
{
|
| 114 | 136 |
// インターフェース |
| 115 |
string strcmd = "";
|
|
| 137 |
StringBuilder strcmd = new StringBuilder();
|
|
| 116 | 138 |
ArrayList arData = new ArrayList(); |
| 117 | 139 |
|
| 118 | 140 |
try |
| 119 | 141 |
{
|
| 120 | 142 |
// SQL作成（DateTime型が変換できないのでCharに変換しておく） |
| 121 |
strcmd = CreateSelectSQL() + AddSQLString; |
|
| 143 |
strcmd.Append(CreateSelectSQL()); |
|
| 144 |
strcmd.Append(AddSQLString); |
|
| 122 | 145 |
|
| 123 | 146 |
// SQL実行 |
| 124 |
if (!ExecuteReader(strcmd, ref arData, bConnect)) return false; |
|
| 147 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
|
|
| 125 | 148 |
if (arData.Count == 0) return false; |
| 126 | 149 |
|
| 127 | 150 |
// データセット |
| ... | ... | |
| 135 | 158 |
} |
| 136 | 159 |
catch (Exception ex) |
| 137 | 160 |
{
|
| 138 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 161 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 139 | 162 |
return false; |
| 140 | 163 |
} |
| 141 | 164 |
|
| 142 | 165 |
} |
| 166 |
#endregion |
|
| 143 | 167 |
|
| 168 |
#region 経費率マスタ追加 |
|
| 144 | 169 |
/// <summary> |
| 145 | 170 |
/// 経費率マスタ追加 |
| 146 | 171 |
/// </summary> |
| ... | ... | |
| 148 | 173 |
/// <returns>true：成功 false：失敗</returns> |
| 149 | 174 |
public bool InsertAction(List<ExpensesMaster> data, bool bConnect = true) |
| 150 | 175 |
{
|
| 151 |
string strcmd = "";
|
|
| 176 |
StringBuilder strcmd = new StringBuilder();
|
|
| 152 | 177 |
try |
| 153 | 178 |
{
|
| 154 | 179 |
|
| 155 | 180 |
foreach (ExpensesMaster work in data) |
| 156 | 181 |
{
|
| 157 |
strcmd = "INSERT INTO ExpensesMaster";
|
|
| 182 |
strcmd.Append("INSERT INTO ExpensesMaster");
|
|
| 158 | 183 |
|
| 159 |
strcmd += " VALUES (";
|
|
| 184 |
strcmd.Append(" VALUES (");
|
|
| 160 | 185 |
|
| 161 |
strcmd += string.Format(" {0}", work.DivisionCode.ToString());
|
|
| 162 |
strcmd += string.Format(", {0}", work.NameCode.ToString());
|
|
| 163 |
strcmd += string.Format(", {0}", work.DisplayOrder.ToString());
|
|
| 164 |
strcmd += string.Format(", {0}", work.ExpensesRaito.ToString());
|
|
| 165 |
strcmd += string.Format(", {0}", work.DeleteFlg.ToString());
|
|
| 186 |
strcmd.AppendFormat(" {0}", work.DivisionCode.ToString());
|
|
| 187 |
strcmd.AppendFormat(", {0}", work.NameCode.ToString());
|
|
| 188 |
strcmd.AppendFormat(", {0}", work.DisplayOrder.ToString());
|
|
| 189 |
strcmd.AppendFormat(", {0}", work.ExpensesRaito.ToString());
|
|
| 190 |
strcmd.AppendFormat(", {0}", work.DeleteFlg.ToString());
|
|
| 166 | 191 |
|
| 167 |
strcmd += ", NOW()";
|
|
| 168 |
strcmd += ", NOW()";
|
|
| 169 |
strcmd += ")";
|
|
| 192 |
strcmd.Append(", NOW()");
|
|
| 193 |
strcmd.Append(", NOW()");
|
|
| 194 |
strcmd.Append(")");
|
|
| 170 | 195 |
|
| 171 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 196 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 172 | 197 |
} |
| 173 | 198 |
return true; |
| 174 | 199 |
} |
| 175 | 200 |
catch (Exception ex) |
| 176 | 201 |
{
|
| 177 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 202 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 178 | 203 |
return false; |
| 179 | 204 |
} |
| 180 | 205 |
} |
| 206 |
#endregion |
|
| 181 | 207 |
|
| 208 |
#region 経費率マスタ更新 |
|
| 182 | 209 |
/// <summary> |
| 183 | 210 |
/// 経費率マスタ更新 |
| 184 | 211 |
/// </summary> |
| ... | ... | |
| 187 | 214 |
/// <returns>true：成功 false：失敗</returns> |
| 188 | 215 |
public bool UpdateAction(string AddSQLString, ExpensesMaster data, bool bConnect = true) |
| 189 | 216 |
{
|
| 190 |
string strcmd = "";
|
|
| 217 |
StringBuilder strcmd = new StringBuilder();
|
|
| 191 | 218 |
try |
| 192 | 219 |
{
|
| 193 | 220 |
|
| 194 |
strcmd = "UPDATE ExpensesMaster";
|
|
| 221 |
strcmd.Append("UPDATE ExpensesMaster");
|
|
| 195 | 222 |
|
| 196 |
strcmd += " SET";
|
|
| 223 |
strcmd.Append(" SET");
|
|
| 197 | 224 |
|
| 198 |
strcmd += string.Format(" DivisionCode = {0}", data.DivisionCode.ToString());
|
|
| 199 |
strcmd += string.Format(",NameCode = {0}", data.NameCode.ToString());
|
|
| 200 |
strcmd += string.Format(",DisplayOrder = {0}", data.DisplayOrder.ToString());
|
|
| 201 |
strcmd += string.Format(",ExpensesRaito = {0}", data.ExpensesRaito.ToString());
|
|
| 202 |
strcmd += string.Format(",DeleteFlg = {0}", data.DeleteFlg.ToString());
|
|
| 225 |
strcmd.AppendFormat(" DivisionCode = {0}", data.DivisionCode.ToString());
|
|
| 226 |
strcmd.AppendFormat(",NameCode = {0}", data.NameCode.ToString());
|
|
| 227 |
strcmd.AppendFormat(",DisplayOrder = {0}", data.DisplayOrder.ToString());
|
|
| 228 |
strcmd.AppendFormat(",ExpensesRaito = {0}", data.ExpensesRaito.ToString());
|
|
| 229 |
strcmd.AppendFormat(",DeleteFlg = {0}", data.DeleteFlg.ToString());
|
|
| 203 | 230 |
|
| 204 |
strcmd += ", UpdateDate = NOW()";
|
|
| 205 |
strcmd += AddSQLString;
|
|
| 231 |
strcmd.Append(", UpdateDate = NOW()");
|
|
| 232 |
strcmd.Append(AddSQLString);
|
|
| 206 | 233 |
|
| 207 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 234 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 208 | 235 |
|
| 209 | 236 |
return true; |
| 210 | 237 |
} |
| 211 | 238 |
catch (Exception ex) |
| 212 | 239 |
{
|
| 213 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 240 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 214 | 241 |
return false; |
| 215 | 242 |
} |
| 216 | 243 |
} |
| 244 |
#endregion |
|
| 217 | 245 |
|
| 218 |
|
|
| 246 |
#region 経費率マスタ削除 |
|
| 219 | 247 |
/// <summary> |
| 220 | 248 |
/// 経費率マスタ削除 |
| 221 | 249 |
/// </summary> |
| ... | ... | |
| 225 | 253 |
public bool DeleteAction(string AddSQLString, bool bConnect = true) |
| 226 | 254 |
{
|
| 227 | 255 |
// インターフェース |
| 228 |
string strcmd = "";
|
|
| 256 |
StringBuilder strcmd = new StringBuilder();
|
|
| 229 | 257 |
try |
| 230 | 258 |
{
|
| 231 |
strcmd = string.Format("{0}{1}", "DELETE FROM ExpensesMaster", AddSQLString);
|
|
| 259 |
strcmd.AppendFormat("{0}{1}", "DELETE FROM ExpensesMaster", AddSQLString);
|
|
| 232 | 260 |
|
| 233 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 261 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 234 | 262 |
|
| 235 | 263 |
return true; |
| 236 | 264 |
} |
| 237 | 265 |
catch (Exception ex) |
| 238 | 266 |
{
|
| 239 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 267 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 240 | 268 |
return false; |
| 241 | 269 |
} |
| 242 | 270 |
} |
| 271 |
#endregion |
|
| 243 | 272 |
|
| 273 |
#region 経費率マスタ論理削除 |
|
| 244 | 274 |
/// <summary> |
| 245 | 275 |
/// 論理削除 |
| 246 | 276 |
/// </summary> |
| ... | ... | |
| 275 | 305 |
return false; |
| 276 | 306 |
} |
| 277 | 307 |
} |
| 308 |
#endregion |
|
| 309 |
|
|
| 310 |
#region OracleDataReaderより構造体へセットする |
|
| 278 | 311 |
/// <summary> |
| 279 | 312 |
/// OracleDataReaderより構造体へセットする |
| 280 | 313 |
/// </summary> |
| ... | ... | |
| 303 | 336 |
logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
|
| 304 | 337 |
} |
| 305 | 338 |
} |
| 306 |
|
|
| 307 | 339 |
#endregion |
| 308 | 340 |
|
| 309 |
#region パブリックメソッド（特殊処理） |
|
| 310 |
|
|
| 341 |
#region 区分別の最大値を取得する |
|
| 311 | 342 |
/// <summary> |
| 312 | 343 |
/// 区分別の最大値を取得する |
| 313 | 344 |
/// </summary> |
| ... | ... | |
| 317 | 348 |
public int SelectMaxCategoryHistoryCount(string AddSQLString, bool bConnect = true) |
| 318 | 349 |
{
|
| 319 | 350 |
// インターフェース |
| 320 |
string strcmd = "";
|
|
| 351 |
StringBuilder strcmd = new StringBuilder();
|
|
| 321 | 352 |
ArrayList arData = new ArrayList(); |
| 322 | 353 |
int iRet = 0; |
| 323 | 354 |
try |
| 324 | 355 |
{
|
| 325 | 356 |
// SQL作成 |
| 326 |
strcmd = "SELECT IFNULL(MAX(NameCode), 0) FROM ExpensesMaster" + AddSQLString; |
|
| 357 |
strcmd.Append("SELECT IFNULL(MAX(NameCode), 0) FROM ExpensesMaster");
|
|
| 358 |
strcmd.Append(AddSQLString); |
|
| 327 | 359 |
|
| 328 | 360 |
// SQL実行 |
| 329 |
if (!ExecuteReader(strcmd, ref arData, bConnect)) return iRet; |
|
| 361 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return iRet;
|
|
| 330 | 362 |
|
| 331 | 363 |
// データセット |
| 332 | 364 |
foreach (object[] objwrk in arData) |
| ... | ... | |
| 339 | 371 |
} |
| 340 | 372 |
catch (Exception ex) |
| 341 | 373 |
{
|
| 342 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 374 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 343 | 375 |
} |
| 344 | 376 |
|
| 345 | 377 |
return iRet; |
| 346 | 378 |
} |
| 379 |
#endregion |
|
| 347 | 380 |
|
| 381 |
#region 主キー検索の文字列を返す |
|
| 348 | 382 |
/// <summary> |
| 349 | 383 |
/// 主キー検索の文字列を返す |
| 350 | 384 |
/// </summary> |
| ... | ... | |
| 352 | 386 |
/// <returns>Where文字列</returns> |
| 353 | 387 |
public string CreatePrimarykeyString(int DivisionCode, int NameCode = 0) |
| 354 | 388 |
{
|
| 355 |
string strWork = string.Empty;
|
|
| 389 |
StringBuilder strWork = new StringBuilder();
|
|
| 356 | 390 |
try |
| 357 | 391 |
{
|
| 358 |
strWork = string.Format(" Where DivisionCode = {0}", DivisionCode);
|
|
| 392 |
strWork.AppendFormat(" Where DivisionCode = {0}", DivisionCode);
|
|
| 359 | 393 |
if (NameCode != 0) |
| 360 |
strWork += string.Format(" And NameCode = {0}", NameCode);
|
|
| 394 |
strWork.AppendFormat(" And NameCode = {0}", NameCode);
|
|
| 361 | 395 |
} |
| 362 | 396 |
catch (Exception ex) |
| 363 | 397 |
{
|
| 364 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strWork);
|
|
| 398 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strWork.ToString());
|
|
| 365 | 399 |
} |
| 366 | 400 |
|
| 367 |
return strWork; |
|
| 401 |
return strWork.ToString();
|
|
| 368 | 402 |
} |
| 369 | 403 |
#endregion |
| 370 | 404 |
} |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMHolidayCalender.cs | ||
|---|---|---|
| 59 | 59 |
/// </summary> |
| 60 | 60 |
private string CreateSelectSQL() |
| 61 | 61 |
{
|
| 62 |
string strcmd = "SELECT"; |
|
| 63 |
strcmd += " DATE_FORMAT(Holiday, '%Y/%m/%d')"; |
|
| 64 |
strcmd += ",BusinessYear"; |
|
| 65 |
strcmd += ",TargetMonth"; |
|
| 66 |
strcmd += ",TargetDay"; |
|
| 67 |
strcmd += " FROM HolidayCalenderMaster"; |
|
| 62 |
StringBuilder strcmd = new StringBuilder(); |
|
| 63 |
strcmd.Append("SELECT");
|
|
| 64 |
strcmd.Append(" DATE_FORMAT(Holiday, '%Y/%m/%d')");
|
|
| 65 |
strcmd.Append(",BusinessYear");
|
|
| 66 |
strcmd.Append(",TargetMonth");
|
|
| 67 |
strcmd.Append(",TargetDay");
|
|
| 68 |
strcmd.Append(" FROM HolidayCalenderMaster");
|
|
| 68 | 69 |
|
| 69 |
return strcmd; |
|
| 70 |
return strcmd.ToString();
|
|
| 70 | 71 |
} |
| 71 | 72 |
#endregion |
| 72 | 73 |
|
| ... | ... | |
| 80 | 81 |
public bool SelectAction(string AddSQLString, ref List<HolidayCalenderMaster> data, bool bConnect = true) |
| 81 | 82 |
{
|
| 82 | 83 |
// インターフェース |
| 83 |
string strcmd = "";
|
|
| 84 |
StringBuilder strcmd = new StringBuilder();
|
|
| 84 | 85 |
ArrayList arData = new ArrayList(); |
| 85 | 86 |
|
| 86 | 87 |
try |
| 87 | 88 |
{
|
| 88 | 89 |
// SQL作成 |
| 89 |
strcmd = CreateSelectSQL() + AddSQLString; |
|
| 90 |
strcmd.Append(CreateSelectSQL()); |
|
| 91 |
strcmd.Append(AddSQLString); |
|
| 90 | 92 |
|
| 91 | 93 |
// SQL実行 |
| 92 |
if (!ExecuteReader(strcmd, ref arData, bConnect)) return false; |
|
| 94 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
|
|
| 93 | 95 |
|
| 94 | 96 |
// データセット |
| 95 | 97 |
foreach (object[] objwrk in arData) |
| ... | ... | |
| 103 | 105 |
} |
| 104 | 106 |
catch (Exception ex) |
| 105 | 107 |
{
|
| 106 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 108 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 107 | 109 |
return false; |
| 108 | 110 |
} |
| 109 | 111 |
|
| ... | ... | |
| 114 | 116 |
public bool SelectAction(string AddSQLString, ref HolidayCalenderMaster data, bool bConnect = true) |
| 115 | 117 |
{
|
| 116 | 118 |
// インターフェース |
| 117 |
string strcmd = "";
|
|
| 119 |
StringBuilder strcmd = new StringBuilder();
|
|
| 118 | 120 |
ArrayList arData = new ArrayList(); |
| 119 | 121 |
|
| 120 | 122 |
try |
| 121 | 123 |
{
|
| 122 | 124 |
// SQL作成（DateTime型が変換できないのでCharに変換しておく） |
| 123 |
strcmd = CreateSelectSQL() + AddSQLString; |
|
| 125 |
strcmd.Append(CreateSelectSQL()); |
|
| 126 |
strcmd.Append(AddSQLString); |
|
| 124 | 127 |
|
| 125 | 128 |
// SQL実行 |
| 126 |
if (!ExecuteReader(strcmd, ref arData, bConnect)) return false; |
|
| 129 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
|
|
| 127 | 130 |
if (arData.Count == 0) return false; |
| 128 | 131 |
|
| 129 | 132 |
// データセット |
| ... | ... | |
| 137 | 140 |
} |
| 138 | 141 |
catch (Exception ex) |
| 139 | 142 |
{
|
| 140 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 143 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 141 | 144 |
return false; |
| 142 | 145 |
} |
| 143 | 146 |
} |
| ... | ... | |
| 151 | 154 |
/// <returns>true：成功 false：失敗</returns> |
| 152 | 155 |
public bool InsertAction(List<HolidayCalenderMaster> data, bool bConnect = true) |
| 153 | 156 |
{
|
| 154 |
string strcmd = "";
|
|
| 157 |
StringBuilder strcmd = new StringBuilder();
|
|
| 155 | 158 |
try |
| 156 | 159 |
{
|
| 157 | 160 |
bool bColFirst = true; |
| 158 |
strcmd = "INSERT INTO HolidayCalenderMaster";
|
|
| 159 |
strcmd += " (";
|
|
| 161 |
strcmd.Append("INSERT INTO HolidayCalenderMaster");
|
|
| 162 |
strcmd.Append(" (");
|
|
| 160 | 163 |
foreach (var gender in Enum.GetValues(typeof(NameColumn))) |
| 161 | 164 |
{
|
| 162 |
if (!bColFirst) strcmd += ", ";
|
|
| 163 |
strcmd += gender.ToString();
|
|
| 165 |
if (!bColFirst) strcmd.Append(", ");
|
|
| 166 |
strcmd.Append(gender.ToString());
|
|
| 164 | 167 |
bColFirst = false; |
| 165 | 168 |
} |
| 166 |
strcmd += ") VALUES";
|
|
| 169 |
strcmd.Append(") VALUES");
|
|
| 167 | 170 |
|
| 168 | 171 |
bool bDataFirst = true; |
| 169 | 172 |
foreach (HolidayCalenderMaster work in data) |
| 170 | 173 |
{
|
| 171 |
if (bDataFirst) strcmd += " (";
|
|
| 172 |
else strcmd += ", (";
|
|
| 174 |
if (bDataFirst) strcmd.Append(" (");
|
|
| 175 |
else strcmd.Append(", (");
|
|
| 173 | 176 |
|
| 174 |
strcmd += string.Format(" STR_TO_DATE('{0}','%Y/%m/%d')", work.Holiday.ToShortDateString());
|
|
| 175 |
strcmd += string.Format(" ,{0}", work.BusinessYear.ToString());
|
|
| 176 |
strcmd += string.Format(" ,{0}", work.TargetMonth.ToString());
|
|
| 177 |
strcmd += string.Format(" ,{0}", work.TargetDay.ToString());
|
|
| 177 |
strcmd.AppendFormat(" STR_TO_DATE('{0}','%Y/%m/%d')", work.Holiday.ToShortDateString());
|
|
| 178 |
strcmd.AppendFormat(" ,{0}", work.BusinessYear.ToString());
|
|
| 179 |
strcmd.AppendFormat(" ,{0}", work.TargetMonth.ToString());
|
|
| 180 |
strcmd.AppendFormat(" ,{0}", work.TargetDay.ToString());
|
|
| 178 | 181 |
|
| 179 |
strcmd += ")";
|
|
| 182 |
strcmd.Append(")");
|
|
| 180 | 183 |
|
| 181 | 184 |
bDataFirst = false; |
| 182 | 185 |
} |
| 183 | 186 |
|
| 184 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 187 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 185 | 188 |
|
| 186 | 189 |
return true; |
| 187 | 190 |
} |
| 188 | 191 |
catch (Exception ex) |
| 189 | 192 |
{
|
| 190 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 193 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 191 | 194 |
return false; |
| 192 | 195 |
} |
| 193 | 196 |
} |
| ... | ... | |
| 202 | 205 |
/// <returns>true：成功 false：失敗</returns> |
| 203 | 206 |
public bool UpdateAction(string AddSQLString, HolidayCalenderMaster data, bool bConnect = true) |
| 204 | 207 |
{
|
| 205 |
string strcmd = "";
|
|
| 208 |
StringBuilder strcmd = new StringBuilder();
|
|
| 206 | 209 |
try |
| 207 | 210 |
{
|
| 208 | 211 |
|
| 209 |
strcmd = "UPDATE HolidayCalenderMaster";
|
|
| 212 |
strcmd.Append("UPDATE HolidayCalenderMaster");
|
|
| 210 | 213 |
|
| 211 |
strcmd += " SET";
|
|
| 214 |
strcmd.Append(" SET");
|
|
| 212 | 215 |
|
| 213 |
strcmd += string.Format(" Holiday = STR_TO_DATE('{0}','%Y/%m/%d')", data.Holiday.ToShortDateString());
|
|
| 214 |
strcmd += string.Format(",BusinessYear = {0}", data.BusinessYear.ToString());
|
|
| 215 |
strcmd += string.Format(",TargetMonth = {0}", data.TargetMonth.ToString());
|
|
| 216 |
strcmd += string.Format(",TargetDay = {0}", data.TargetDay.ToString());
|
|
| 216 |
strcmd.AppendFormat(" Holiday = STR_TO_DATE('{0}','%Y/%m/%d')", data.Holiday.ToShortDateString());
|
|
| 217 |
strcmd.AppendFormat(",BusinessYear = {0}", data.BusinessYear.ToString());
|
|
| 218 |
strcmd.AppendFormat(",TargetMonth = {0}", data.TargetMonth.ToString());
|
|
| 219 |
strcmd.AppendFormat(",TargetDay = {0}", data.TargetDay.ToString());
|
|
| 217 | 220 |
|
| 218 |
strcmd += AddSQLString;
|
|
| 221 |
strcmd.Append(AddSQLString);
|
|
| 219 | 222 |
|
| 220 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 223 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 221 | 224 |
|
| 222 | 225 |
return true; |
| 223 | 226 |
} |
| 224 | 227 |
catch (Exception ex) |
| 225 | 228 |
{
|
| 226 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 229 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 227 | 230 |
return false; |
| 228 | 231 |
} |
| 229 | 232 |
} |
| ... | ... | |
| 239 | 242 |
public bool DeleteAction(string AddSQLString, bool bConnect = true) |
| 240 | 243 |
{
|
| 241 | 244 |
// インターフェース |
| 242 |
string strcmd = "";
|
|
| 245 |
StringBuilder strcmd = new StringBuilder();
|
|
| 243 | 246 |
try |
| 244 | 247 |
{
|
| 245 |
strcmd = string.Format("{0}{1}", "DELETE FROM HolidayCalenderMaster", AddSQLString);
|
|
| 248 |
strcmd.AppendFormat("{0}{1}", "DELETE FROM HolidayCalenderMaster", AddSQLString);
|
|
| 246 | 249 |
|
| 247 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 250 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 248 | 251 |
|
| 249 | 252 |
return true; |
| 250 | 253 |
} |
| 251 | 254 |
catch (Exception ex) |
| 252 | 255 |
{
|
| 253 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 256 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 254 | 257 |
return false; |
| 255 | 258 |
} |
| 256 | 259 |
} |
| ... | ... | |
| 284 | 287 |
|
| 285 | 288 |
#endregion |
| 286 | 289 |
|
| 287 |
#region パブリックメソッド（特殊処理） |
|
| 288 |
|
|
| 290 |
#region 主キー検索の文字列を返す |
|
| 289 | 291 |
/// <summary> |
| 290 | 292 |
/// 主キー検索の文字列を返す |
| 291 | 293 |
/// </summary> |
| ... | ... | |
| 293 | 295 |
/// <returns>Where文字列</returns> |
| 294 | 296 |
public string CreatePrimarykeyString(DateTime Holiday) |
| 295 | 297 |
{
|
| 296 |
string strWork = string.Empty;
|
|
| 298 |
StringBuilder strWork = new StringBuilder(); ;
|
|
| 297 | 299 |
try |
| 298 | 300 |
{
|
| 299 |
strWork = string.Format(" Where Holiday = DATE_FORMAT('{0}','%Y/%m/%d')", Holiday.ToShortDateString());
|
|
| 301 |
strWork.AppendFormat(" Where Holiday = DATE_FORMAT('{0}','%Y/%m/%d')", Holiday.ToShortDateString());
|
|
| 300 | 302 |
} |
| 301 | 303 |
catch (Exception ex) |
| 302 | 304 |
{
|
| 303 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strWork);
|
|
| 305 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strWork.ToString());
|
|
| 304 | 306 |
} |
| 305 | 307 |
|
| 306 |
return strWork; |
|
| 308 |
return strWork.ToString();
|
|
| 307 | 309 |
} |
| 310 |
#endregion |
|
| 308 | 311 |
|
| 312 |
#region 主キー検索の文字列を返す |
|
| 309 | 313 |
/// <summary> |
| 310 | 314 |
/// 主キー検索の文字列を返す |
| 311 | 315 |
/// </summary> |
| ... | ... | |
| 313 | 317 |
/// <returns>Where文字列</returns> |
| 314 | 318 |
public string CreateSubkeyString(int Year, int Month = 0, int Day = 0) |
| 315 | 319 |
{
|
| 316 |
string strWork = string.Empty;
|
|
| 320 |
StringBuilder strWork = new StringBuilder();
|
|
| 317 | 321 |
try |
| 318 | 322 |
{
|
| 319 |
strWork = string.Format(" Where BusinessYear = {0}", Year.ToString());
|
|
| 323 |
strWork.AppendFormat(" Where BusinessYear = {0}", Year.ToString());
|
|
| 320 | 324 |
if(Month != 0) |
| 321 |
strWork += string.Format(" And TargetMonth = {0}", Month.ToString());
|
|
| 325 |
strWork.AppendFormat(" And TargetMonth = {0}", Month.ToString());
|
|
| 322 | 326 |
if (Day != 0) |
| 323 |
strWork += string.Format(" And TargetDay = {0}", Day.ToString());
|
|
| 327 |
strWork.AppendFormat(" And TargetDay = {0}", Day.ToString());
|
|
| 324 | 328 |
} |
| 325 | 329 |
catch (Exception ex) |
| 326 | 330 |
{
|
| 327 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strWork);
|
|
| 331 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strWork.ToString());
|
|
| 328 | 332 |
} |
| 329 | 333 |
|
| 330 |
return strWork; |
|
| 334 |
return strWork.ToString();
|
|
| 331 | 335 |
} |
| 332 | 336 |
|
| 333 | 337 |
#endregion |
| branches/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOMOrderers.cs | ||
|---|---|---|
| 79 | 79 |
/// <returns>true：成功 false：失敗</returns> |
| 80 | 80 |
private string CreateSelectSQL() |
| 81 | 81 |
{
|
| 82 |
string strcmd = "SELECT"; |
|
| 83 |
strcmd += " OrderCotegory"; |
|
| 84 |
strcmd += " ,OrderersCode"; |
|
| 85 |
strcmd += " ,DisplayOrder"; |
|
| 86 |
strcmd += " ,OrderFlg"; |
|
| 87 |
strcmd += " ,CorporateStatusName"; |
|
| 88 |
strcmd += " ,CorporateStatusPoint"; |
|
| 89 |
strcmd += " ,OrderersName1"; |
|
| 90 |
strcmd += " ,OrderersName2"; |
|
| 91 |
strcmd += " ,DepartmentName"; |
|
| 92 |
strcmd += " ,ChargePersonName"; |
|
| 93 |
strcmd += " ,ZipCode"; |
|
| 94 |
strcmd += " ,Address1"; |
|
| 95 |
strcmd += " ,Address2"; |
|
| 96 |
strcmd += " ,Address3"; |
|
| 97 |
strcmd += " ,PhoneNumber"; |
|
| 98 |
strcmd += " ,FaxNumber"; |
|
| 99 |
strcmd += " ,MailAddress"; |
|
| 100 |
strcmd += " ,Note"; |
|
| 101 |
strcmd += " ,DeleteFlg"; |
|
| 82 |
StringBuilder strcmd = new StringBuilder(); |
|
| 83 |
strcmd.Append("SELECT");
|
|
| 84 |
strcmd.Append(" OrderCotegory");
|
|
| 85 |
strcmd.Append(" ,OrderersCode");
|
|
| 86 |
strcmd.Append(" ,DisplayOrder");
|
|
| 87 |
strcmd.Append(" ,OrderFlg");
|
|
| 88 |
strcmd.Append(" ,CorporateStatusName");
|
|
| 89 |
strcmd.Append(" ,CorporateStatusPoint");
|
|
| 90 |
strcmd.Append(" ,OrderersName1");
|
|
| 91 |
strcmd.Append(" ,OrderersName2");
|
|
| 92 |
strcmd.Append(" ,DepartmentName");
|
|
| 93 |
strcmd.Append(" ,ChargePersonName");
|
|
| 94 |
strcmd.Append(" ,ZipCode");
|
|
| 95 |
strcmd.Append(" ,Address1");
|
|
| 96 |
strcmd.Append(" ,Address2");
|
|
| 97 |
strcmd.Append(" ,Address3");
|
|
| 98 |
strcmd.Append(" ,PhoneNumber");
|
|
| 99 |
strcmd.Append(" ,FaxNumber");
|
|
| 100 |
strcmd.Append(" ,MailAddress");
|
|
| 101 |
strcmd.Append(" ,Note");
|
|
| 102 |
strcmd.Append(" ,DeleteFlg");
|
|
| 102 | 103 |
|
| 103 |
strcmd += " ,DATE_FORMAT(EntryDate, '%Y/%m/%d %H:%i:%s')";
|
|
| 104 |
strcmd += " ,DATE_FORMAT(UpdateDate, '%Y/%m/%d %H:%i:%s')";
|
|
| 105 |
strcmd += " FROM OrderersMaster";
|
|
| 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 OrderersMaster");
|
|
| 106 | 107 |
|
| 107 |
return strcmd; |
|
| 108 |
return strcmd.ToString();
|
|
| 108 | 109 |
} |
| 109 | 110 |
#endregion |
| 110 | 111 |
|
| ... | ... | |
| 116 | 117 |
public bool SelectAction(string AddSQLString, ref List<OrderersMaster> data, bool bConnect = true) |
| 117 | 118 |
{
|
| 118 | 119 |
// インターフェース |
| 119 |
string strcmd = "";
|
|
| 120 |
StringBuilder strcmd = new StringBuilder();
|
|
| 120 | 121 |
ArrayList arData = new ArrayList(); |
| 121 | 122 |
|
| 122 | 123 |
try |
| 123 | 124 |
{
|
| 124 | 125 |
// SQL作成（DateTime型が変換できないのでCharに変換しておく） |
| 125 |
strcmd = CreateSelectSQL() + AddSQLString; |
|
| 126 |
strcmd.Append(CreateSelectSQL()); |
|
| 127 |
strcmd.Append(AddSQLString); |
|
| 126 | 128 |
|
| 127 | 129 |
// SQL実行 |
| 128 |
if (!ExecuteReader(strcmd, ref arData, bConnect)) return false; |
|
| 130 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
|
|
| 129 | 131 |
|
| 130 | 132 |
// データセット |
| 131 | 133 |
foreach (object[] objwrk in arData) |
| ... | ... | |
| 139 | 141 |
} |
| 140 | 142 |
catch (Exception ex) |
| 141 | 143 |
{
|
| 142 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 144 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 143 | 145 |
return false; |
| 144 | 146 |
} |
| 145 | 147 |
} |
| ... | ... | |
| 153 | 155 |
public bool SelectAction(string AddSQLString, ref OrderersMaster data, bool bConnect = true) |
| 154 | 156 |
{
|
| 155 | 157 |
// インターフェース |
| 156 |
string strcmd = "";
|
|
| 158 |
StringBuilder strcmd = new StringBuilder();
|
|
| 157 | 159 |
ArrayList arData = new ArrayList(); |
| 158 | 160 |
|
| 159 | 161 |
try |
| 160 | 162 |
{
|
| 161 | 163 |
// SQL作成（DateTime型が変換できないのでCharに変換しておく） |
| 162 |
strcmd = CreateSelectSQL() + AddSQLString; |
|
| 164 |
strcmd.Append(CreateSelectSQL()); |
|
| 165 |
strcmd.Append(AddSQLString); |
|
| 163 | 166 |
|
| 164 | 167 |
// SQL実行 |
| 165 |
if (!ExecuteReader(strcmd, ref arData, bConnect)) return false; |
|
| 168 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return false;
|
|
| 166 | 169 |
if (arData.Count == 0) return false; |
| 167 | 170 |
|
| 168 | 171 |
// データセット |
| ... | ... | |
| 176 | 179 |
} |
| 177 | 180 |
catch (Exception ex) |
| 178 | 181 |
{
|
| 179 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 182 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 180 | 183 |
return false; |
| 181 | 184 |
} |
| 182 | 185 |
} |
| ... | ... | |
| 190 | 193 |
/// <returns>true：成功 false：失敗</returns> |
| 191 | 194 |
public bool InsertAction(List<OrderersMaster> data, bool bConnect = true) |
| 192 | 195 |
{
|
| 193 |
string strcmd = "";
|
|
| 196 |
StringBuilder strcmd = new StringBuilder();
|
|
| 194 | 197 |
try |
| 195 | 198 |
{
|
| 196 | 199 |
bool bColFirst = true; |
| 197 |
strcmd = "INSERT INTO OrderersMaster";
|
|
| 198 |
strcmd += " (";
|
|
| 200 |
strcmd.Append("INSERT INTO OrderersMaster");
|
|
| 201 |
strcmd.Append(" (");
|
|
| 199 | 202 |
foreach (var gender in Enum.GetValues(typeof(OrderersColumn))) |
| 200 | 203 |
{
|
| 201 |
if (!bColFirst) strcmd += ", ";
|
|
| 202 |
strcmd += gender.ToString();
|
|
| 204 |
if (!bColFirst) strcmd.Append(", ");
|
|
| 205 |
strcmd.Append(gender.ToString());
|
|
| 203 | 206 |
bColFirst = false; |
| 204 | 207 |
} |
| 205 |
strcmd += ") VALUES";
|
|
| 208 |
strcmd.Append(") VALUES");
|
|
| 206 | 209 |
|
| 207 | 210 |
bool bDataFirst = true; |
| 208 | 211 |
foreach (OrderersMaster work in data) |
| 209 | 212 |
{
|
| 210 |
if (bDataFirst) strcmd += " (";
|
|
| 211 |
else strcmd += ", (";
|
|
| 213 |
if (bDataFirst) strcmd.Append(" (");
|
|
| 214 |
else strcmd.Append(", (");
|
|
| 212 | 215 |
|
| 213 |
strcmd += string.Format(" {0}", work.OrderCotegory);
|
|
| 214 |
strcmd += string.Format(", {0}", work.OrderersCode);
|
|
| 215 |
strcmd += string.Format(", {0}", work.DisplayOrder);
|
|
| 216 |
strcmd += string.Format(", {0}", work.OrderFlg);
|
|
| 217 |
strcmd += string.Format(",'{0}'", work.CorporateStatusName);
|
|
| 218 |
strcmd += string.Format(", {0}", work.CorporateStatusPoint);
|
|
| 219 |
strcmd += string.Format(",'{0}'", work.OrderersName1);
|
|
| 220 |
strcmd += string.Format(",'{0}'", work.OrderersName2);
|
|
| 221 |
strcmd += string.Format(",'{0}'", work.DepartmentName);
|
|
| 222 |
strcmd += string.Format(",'{0}'", work.ChargePersonName);
|
|
| 223 |
strcmd += string.Format(",'{0}'", work.ZipCode);
|
|
| 224 |
strcmd += string.Format(",'{0}'", work.Address1);
|
|
| 225 |
strcmd += string.Format(",'{0}'", work.Address2);
|
|
| 226 |
strcmd += string.Format(",'{0}'", work.Address3);
|
|
| 227 |
strcmd += string.Format(",'{0}'", work.PhoneNumber);
|
|
| 228 |
strcmd += string.Format(",'{0}'", work.FaxNumber);
|
|
| 229 |
strcmd += string.Format(",'{0}'", work.MailAddress);
|
|
| 230 |
strcmd += string.Format(",'{0}'", work.Note);
|
|
| 231 |
strcmd += string.Format(", {0}", work.DeleteFlg);
|
|
| 216 |
strcmd.AppendFormat(" {0}", work.OrderCotegory);
|
|
| 217 |
strcmd.AppendFormat(", {0}", work.OrderersCode);
|
|
| 218 |
strcmd.AppendFormat(", {0}", work.DisplayOrder);
|
|
| 219 |
strcmd.AppendFormat(", {0}", work.OrderFlg);
|
|
| 220 |
strcmd.AppendFormat(",'{0}'", work.CorporateStatusName);
|
|
| 221 |
strcmd.AppendFormat(", {0}", work.CorporateStatusPoint);
|
|
| 222 |
strcmd.AppendFormat(",'{0}'", work.OrderersName1);
|
|
| 223 |
strcmd.AppendFormat(",'{0}'", work.OrderersName2);
|
|
| 224 |
strcmd.AppendFormat(",'{0}'", work.DepartmentName);
|
|
| 225 |
strcmd.AppendFormat(",'{0}'", work.ChargePersonName);
|
|
| 226 |
strcmd.AppendFormat(",'{0}'", work.ZipCode);
|
|
| 227 |
strcmd.AppendFormat(",'{0}'", work.Address1);
|
|
| 228 |
strcmd.AppendFormat(",'{0}'", work.Address2);
|
|
| 229 |
strcmd.AppendFormat(",'{0}'", work.Address3);
|
|
| 230 |
strcmd.AppendFormat(",'{0}'", work.PhoneNumber);
|
|
| 231 |
strcmd.AppendFormat(",'{0}'", work.FaxNumber);
|
|
| 232 |
strcmd.AppendFormat(",'{0}'", work.MailAddress);
|
|
| 233 |
strcmd.AppendFormat(",'{0}'", work.Note);
|
|
| 234 |
strcmd.AppendFormat(", {0}", work.DeleteFlg);
|
|
| 232 | 235 |
|
| 233 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 234 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 235 |
strcmd += ")";
|
|
| 236 |
strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 237 |
strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 238 |
strcmd.Append(")");
|
|
| 236 | 239 |
|
| 237 | 240 |
bDataFirst = false; |
| 238 | 241 |
} |
| 239 | 242 |
|
| 240 |
if (!ExecuteNonQuery(strcmd, false)) return false; |
|
| 243 |
if (!ExecuteNonQuery(strcmd.ToString(), false)) return false;
|
|
| 241 | 244 |
|
| 242 | 245 |
return true; |
| 243 | 246 |
} |
| 244 | 247 |
catch (Exception ex) |
| 245 | 248 |
{
|
| 246 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 249 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 247 | 250 |
return false; |
| 248 | 251 |
} |
| 249 | 252 |
} |
| ... | ... | |
| 257 | 260 |
/// <returns>true：成功 false：失敗</returns> |
| 258 | 261 |
public bool InsertAction(OrderersMaster work, bool bConnect = true) |
| 259 | 262 |
{
|
| 260 |
string strcmd = "";
|
|
| 263 |
StringBuilder strcmd = new StringBuilder();
|
|
| 261 | 264 |
try |
| 262 | 265 |
{
|
| 263 | 266 |
|
| 264 |
strcmd = "INSERT INTO OrderersMaster";
|
|
| 265 |
strcmd += " (";
|
|
| 267 |
strcmd.Append("INSERT INTO OrderersMaster");
|
|
| 268 |
strcmd.Append(" (");
|
|
| 266 | 269 |
|
| 267 | 270 |
bool bFirst = true; |
| 268 | 271 |
foreach (var gender in Enum.GetValues(typeof(OrderersColumn))) |
| 269 | 272 |
{
|
| 270 |
if (!bFirst) strcmd += " ,";
|
|
| 271 |
strcmd += gender.ToString();
|
|
| 273 |
if (!bFirst) strcmd.Append(" ,");
|
|
| 274 |
strcmd.Append(gender.ToString());
|
|
| 272 | 275 |
bFirst = false; |
| 273 | 276 |
} |
| 274 | 277 |
|
| 275 |
strcmd += ") VALUES (";
|
|
| 278 |
strcmd.Append(") VALUES (");
|
|
| 276 | 279 |
|
| 277 |
strcmd += string.Format(" {0}", work.OrderCotegory);
|
|
| 278 |
strcmd += string.Format(", {0}", work.OrderersCode);
|
|
| 279 |
strcmd += string.Format(", {0}", work.DisplayOrder);
|
|
| 280 |
strcmd += string.Format(", {0}", work.OrderFlg);
|
|
| 281 |
strcmd += string.Format(",'{0}'", work.CorporateStatusName);
|
|
| 282 |
strcmd += string.Format(", {0}", work.CorporateStatusPoint);
|
|
| 283 |
strcmd += string.Format(",'{0}'", work.OrderersName1);
|
|
| 284 |
strcmd += string.Format(",'{0}'", work.OrderersName2);
|
|
| 285 |
strcmd += string.Format(",'{0}'", work.DepartmentName);
|
|
| 286 |
strcmd += string.Format(",'{0}'", work.ChargePersonName);
|
|
| 287 |
strcmd += string.Format(",'{0}'", work.ZipCode);
|
|
| 288 |
strcmd += string.Format(",'{0}'", work.Address1);
|
|
| 289 |
strcmd += string.Format(",'{0}'", work.Address2);
|
|
| 290 |
strcmd += string.Format(",'{0}'", work.Address3);
|
|
| 291 |
strcmd += string.Format(",'{0}'", work.PhoneNumber);
|
|
| 292 |
strcmd += string.Format(",'{0}'", work.FaxNumber);
|
|
| 293 |
strcmd += string.Format(",'{0}'", work.MailAddress);
|
|
| 294 |
strcmd += string.Format(",'{0}'", work.Note);
|
|
| 295 |
strcmd += string.Format(", {0}", work.DeleteFlg);
|
|
| 280 |
strcmd.AppendFormat(" {0}", work.OrderCotegory);
|
|
| 281 |
strcmd.AppendFormat(", {0}", work.OrderersCode);
|
|
| 282 |
strcmd.AppendFormat(", {0}", work.DisplayOrder);
|
|
| 283 |
strcmd.AppendFormat(", {0}", work.OrderFlg);
|
|
| 284 |
strcmd.AppendFormat(",'{0}'", work.CorporateStatusName);
|
|
| 285 |
strcmd.AppendFormat(", {0}", work.CorporateStatusPoint);
|
|
| 286 |
strcmd.AppendFormat(",'{0}'", work.OrderersName1);
|
|
| 287 |
strcmd.AppendFormat(",'{0}'", work.OrderersName2);
|
|
| 288 |
strcmd.AppendFormat(",'{0}'", work.DepartmentName);
|
|
| 289 |
strcmd.AppendFormat(",'{0}'", work.ChargePersonName);
|
|
| 290 |
strcmd.AppendFormat(",'{0}'", work.ZipCode);
|
|
| 291 |
strcmd.AppendFormat(",'{0}'", work.Address1);
|
|
| 292 |
strcmd.AppendFormat(",'{0}'", work.Address2);
|
|
| 293 |
strcmd.AppendFormat(",'{0}'", work.Address3);
|
|
| 294 |
strcmd.AppendFormat(",'{0}'", work.PhoneNumber);
|
|
| 295 |
strcmd.AppendFormat(",'{0}'", work.FaxNumber);
|
|
| 296 |
strcmd.AppendFormat(",'{0}'", work.MailAddress);
|
|
| 297 |
strcmd.AppendFormat(",'{0}'", work.Note);
|
|
| 298 |
strcmd.AppendFormat(", {0}", work.DeleteFlg);
|
|
| 296 | 299 |
|
| 297 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 298 |
strcmd += string.Format(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 299 |
strcmd += ")";
|
|
| 300 |
strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.EntryDate);
|
|
| 301 |
strcmd.AppendFormat(", STR_TO_DATE('{0}','%Y/%m/%d %H:%i:%s')", work.UpdateDate);
|
|
| 302 |
strcmd.Append(")");
|
|
| 300 | 303 |
|
| 301 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 304 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 302 | 305 |
|
| 303 | 306 |
return true; |
| 304 | 307 |
} |
| 305 | 308 |
catch (Exception ex) |
| 306 | 309 |
{
|
| 307 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 310 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 308 | 311 |
return false; |
| 309 | 312 |
} |
| 310 | 313 |
} |
| ... | ... | |
| 319 | 322 |
/// <returns>true：成功 false：失敗</returns> |
| 320 | 323 |
public bool UpdateAction(string AddSQLString, OrderersMaster data, bool bConnect = true) |
| 321 | 324 |
{
|
| 322 |
string strcmd = "";
|
|
| 325 |
StringBuilder strcmd = new StringBuilder();
|
|
| 323 | 326 |
try |
| 324 | 327 |
{
|
| 325 | 328 |
|
| 326 |
strcmd = "UPDATE OrderersMaster";
|
|
| 329 |
strcmd.Append("UPDATE OrderersMaster");
|
|
| 327 | 330 |
|
| 328 |
strcmd += " SET";
|
|
| 331 |
strcmd.Append(" SET");
|
|
| 329 | 332 |
|
| 330 |
strcmd += string.Format(" OrderCotegory = {0}", data.OrderCotegory);
|
|
| 331 |
strcmd += string.Format(", OrderersCode = {0}", data.OrderersCode);
|
|
| 332 |
strcmd += string.Format(", DisplayOrder = {0}", data.DisplayOrder);
|
|
| 333 |
strcmd += string.Format(", OrderFlg = {0}", data.OrderFlg);
|
|
| 334 |
strcmd += string.Format(", CorporateStatusName = '{0}'", data.CorporateStatusName);
|
|
| 335 |
strcmd += string.Format(", CorporateStatusPoint = {0}", data.CorporateStatusPoint);
|
|
| 336 |
strcmd += string.Format(", OrderersName1 = '{0}'", data.OrderersName1);
|
|
| 337 |
strcmd += string.Format(", OrderersName2 = '{0}'", data.OrderersName2);
|
|
| 338 |
strcmd += string.Format(", DepartmentName = '{0}'", data.DepartmentName);
|
|
| 339 |
strcmd += string.Format(", ChargePersonName = '{0}'", data.ChargePersonName);
|
|
| 340 |
strcmd += string.Format(", ZipCode = '{0}'", data.ZipCode);
|
|
| 341 |
strcmd += string.Format(", Address1 = '{0}'", data.Address1);
|
|
| 342 |
strcmd += string.Format(", Address2 = '{0}'", data.Address2);
|
|
| 343 |
strcmd += string.Format(", Address3 = '{0}'", data.Address3);
|
|
| 344 |
strcmd += string.Format(", PhoneNumber = '{0}'", data.PhoneNumber);
|
|
| 345 |
strcmd += string.Format(", FaxNumber = '{0}'", data.FaxNumber);
|
|
| 346 |
strcmd += string.Format(", Note = '{0}'", data.Note);
|
|
| 347 |
strcmd += string.Format(", MailAddress = '{0}'", data.MailAddress);
|
|
| 348 |
strcmd += string.Format(", DeleteFlg = {0}", data.DeleteFlg);
|
|
| 333 |
strcmd.AppendFormat(" OrderCotegory = {0}", data.OrderCotegory);
|
|
| 334 |
strcmd.AppendFormat(", OrderersCode = {0}", data.OrderersCode);
|
|
| 335 |
strcmd.AppendFormat(", DisplayOrder = {0}", data.DisplayOrder);
|
|
| 336 |
strcmd.AppendFormat(", OrderFlg = {0}", data.OrderFlg);
|
|
| 337 |
strcmd.AppendFormat(", CorporateStatusName = '{0}'", data.CorporateStatusName);
|
|
| 338 |
strcmd.AppendFormat(", CorporateStatusPoint = {0}", data.CorporateStatusPoint);
|
|
| 339 |
strcmd.AppendFormat(", OrderersName1 = '{0}'", data.OrderersName1);
|
|
| 340 |
strcmd.AppendFormat(", OrderersName2 = '{0}'", data.OrderersName2);
|
|
| 341 |
strcmd.AppendFormat(", DepartmentName = '{0}'", data.DepartmentName);
|
|
| 342 |
strcmd.AppendFormat(", ChargePersonName = '{0}'", data.ChargePersonName);
|
|
| 343 |
strcmd.AppendFormat(", ZipCode = '{0}'", data.ZipCode);
|
|
| 344 |
strcmd.AppendFormat(", Address1 = '{0}'", data.Address1);
|
|
| 345 |
strcmd.AppendFormat(", Address2 = '{0}'", data.Address2);
|
|
| 346 |
strcmd.AppendFormat(", Address3 = '{0}'", data.Address3);
|
|
| 347 |
strcmd.AppendFormat(", PhoneNumber = '{0}'", data.PhoneNumber);
|
|
| 348 |
strcmd.AppendFormat(", FaxNumber = '{0}'", data.FaxNumber);
|
|
| 349 |
strcmd.AppendFormat(", Note = '{0}'", data.Note);
|
|
| 350 |
strcmd.AppendFormat(", MailAddress = '{0}'", data.MailAddress);
|
|
| 351 |
strcmd.AppendFormat(", DeleteFlg = {0}", data.DeleteFlg);
|
|
| 349 | 352 |
|
| 350 |
strcmd += ", UpdateDate = NOW()";
|
|
| 351 |
strcmd += AddSQLString;
|
|
| 353 |
strcmd.Append(", UpdateDate = NOW()");
|
|
| 354 |
strcmd.Append(AddSQLString);
|
|
| 352 | 355 |
|
| 353 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 356 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 354 | 357 |
|
| 355 | 358 |
return true; |
| 356 | 359 |
} |
| 357 | 360 |
catch (Exception ex) |
| 358 | 361 |
{
|
| 359 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 362 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 360 | 363 |
return false; |
| 361 | 364 |
} |
| 362 | 365 |
} |
| ... | ... | |
| 372 | 375 |
public bool DeleteAction(string AddSQLString, bool bConnect = true) |
| 373 | 376 |
{
|
| 374 | 377 |
// インターフェース |
| 375 |
string strcmd = "";
|
|
| 378 |
StringBuilder strcmd = new StringBuilder();
|
|
| 376 | 379 |
try |
| 377 | 380 |
{
|
| 378 |
strcmd = string.Format("{0}{1}", "DELETE FROM OrderersMaster", AddSQLString);
|
|
| 381 |
strcmd.AppendFormat("{0}{1}", "DELETE FROM OrderersMaster", AddSQLString);
|
|
| 379 | 382 |
|
| 380 |
if (!ExecuteNonQuery(strcmd, bConnect)) return false; |
|
| 383 |
if (!ExecuteNonQuery(strcmd.ToString(), bConnect)) return false;
|
|
| 381 | 384 |
|
| 382 | 385 |
return true; |
| 383 | 386 |
} |
| 384 | 387 |
catch (Exception ex) |
| 385 | 388 |
{
|
| 386 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 389 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 387 | 390 |
return false; |
| 388 | 391 |
} |
| 389 | 392 |
} |
| ... | ... | |
| 445 | 448 |
public int SelectMaxOrderersCodeCount(string AddSQLString, bool bConnect = true) |
| 446 | 449 |
{
|
| 447 | 450 |
// インターフェース |
| 448 |
string strcmd = "";
|
|
| 451 |
StringBuilder strcmd = new StringBuilder();
|
|
| 449 | 452 |
ArrayList arData = new ArrayList(); |
| 450 | 453 |
int iRet = 0; |
| 451 | 454 |
try |
| 452 | 455 |
{
|
| 453 | 456 |
// SQL作成 |
| 454 |
strcmd = "SELECT IFNULL(MAX(OrderersCode), 0) FROM OrderersMaster" + AddSQLString; |
|
| 457 |
strcmd.Append("SELECT IFNULL(MAX(OrderersCode), 0) FROM OrderersMaster");
|
|
| 458 |
strcmd.Append(AddSQLString); |
|
| 455 | 459 |
|
| 456 | 460 |
// SQL実行 |
| 457 |
if (!ExecuteReader(strcmd, ref arData, bConnect)) return iRet; |
|
| 461 |
if (!ExecuteReader(strcmd.ToString(), ref arData, bConnect)) return iRet;
|
|
| 458 | 462 |
|
| 459 | 463 |
// データセット |
| 460 | 464 |
foreach (object[] objwrk in arData) |
| ... | ... | |
| 468 | 472 |
} |
| 469 | 473 |
catch (Exception ex) |
| 470 | 474 |
{
|
| 471 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd);
|
|
| 475 |
logger.ErrorFormat("システムエラー：{0}：{1}：{2}", CommonMotions.GetMethodName(2), ex.Message, strcmd.ToString());
|
|
| 472 | 476 |
} |
| 473 | 477 |
|
| 474 | 478 |
return iRet; |
| ... | ... | |
| 483 | 487 |
/// <returns>Where文字列</returns> |
| 484 | 488 |
public string CreatePrimarykeyString(int OrderCotegory, int OrderersCode =0) |
| 485 | 489 |
{
|
| 486 |
string strWork = "";
|
|
| 490 |
StringBuilder strWork = new StringBuilder();
|
|
| 487 | 491 |
try |
| 488 | 492 |
{
|
| 489 |
strWork = string.Format(" Where OrderCotegory = {0}", OrderCotegory);
|
|
| 493 |
strWork.AppendFormat(" Where OrderCotegory = {0}", OrderCotegory);
|
|
| 490 | 494 |
if (OrderersCode != 0) |
| 491 |
strWork += string.Format(" And OrderersCode = {0}", OrderersCode);
|
|
| 495 |
strWork.AppendFormat(" And OrderersCode = {0}", OrderersCode);
|
|
| 492 | 496 |
} |
| 493 | 497 |
catch (Exception ex) |
| 494 | 498 |
{
|
他の形式にエクスポート: Unified diff