リビジョン 81
発注者・協力業者登録・バグ数件含めた変更
| trunk/src/ProcessManagement/ProcessManagement/Common/CommonDefine.cs | ||
|---|---|---|
| 484 | 484 |
public enum ApprovalStatus |
| 485 | 485 |
{
|
| 486 | 486 |
/// <summary> |
| 487 |
/// 申請中 |
|
| 487 |
/// 0:申請中
|
|
| 488 | 488 |
/// </summary> |
| 489 | 489 |
Petition = 0, |
| 490 | 490 |
/// <summary> |
| 491 |
/// 保 留 |
|
| 491 |
/// 1:保 留
|
|
| 492 | 492 |
/// </summary> |
| 493 | 493 |
Pending, |
| 494 | 494 |
/// <summary> |
| 495 |
/// 承 認 |
|
| 495 |
/// 2:承 認
|
|
| 496 | 496 |
/// </summary> |
| 497 | 497 |
Approval, |
| 498 | 498 |
/// <summary> |
| 499 |
/// 不承認 |
|
| 499 |
/// 3:不承認
|
|
| 500 | 500 |
/// </summary> |
| 501 | 501 |
NotApproval, |
| 502 | 502 |
/// <summary> |
| 503 |
/// 未 定 |
|
| 503 |
/// 4:未 定
|
|
| 504 | 504 |
/// </summary> |
| 505 | 505 |
Undecided, |
| 506 | 506 |
/// <summary> |
| 507 |
/// 未申請 |
|
| 507 |
/// 5:未申請
|
|
| 508 | 508 |
/// </summary> |
| 509 | 509 |
Unclaimed, |
| 510 | 510 |
} |
| trunk/src/ProcessManagement/ProcessManagement/Common/CommonVersion.cs | ||
|---|---|---|
| 14 | 14 |
/// <summary> |
| 15 | 15 |
/// 本体バージョン |
| 16 | 16 |
/// </summary> |
| 17 |
public static int s_SystemVersion = 15;
|
|
| 17 |
public static int s_SystemVersion = 17;
|
|
| 18 | 18 |
|
| 19 | 19 |
/// <summary> |
| 20 | 20 |
/// コピー・環境バージョン |
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsApprovalPermission.cs | ||
|---|---|---|
| 86 | 86 |
IOPersonApproval ApprDB = new IOPersonApproval(); |
| 87 | 87 |
try |
| 88 | 88 |
{
|
| 89 |
string strSQL = ApprDB.CreatePrimarykeyString(Rec.PersonCode, Rec.ApprovalCode, Rec.OrderDate, Rec.SeqNo); |
|
| 89 |
string strSQL = ApprDB.CreatePrimarykeyString(Rec.PersonCode, Rec.ApprovalCode, Rec.OrderDate, Rec.OrderNo, Rec.SeqNo);
|
|
| 90 | 90 |
List<PersonApproval> DataList = new List<PersonApproval>(); |
| 91 | 91 |
// データがあるかをチェックする |
| 92 | 92 |
if (!ApprDB.SelectAction(strSQL, ref DataList)) return false; |
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsChangeLedgerData.cs | ||
|---|---|---|
| 506 | 506 |
// 工事詳細台帳明細データ取得 |
| 507 | 507 |
List<ConstructionLedgerDetail> DetailList = new List<ConstructionLedgerDetail>(); |
| 508 | 508 |
string DetailSQL = LedgerDeDB.CreatePrimarykeyString(LedgerRec.ConstructionCode); |
| 509 |
DetailSQL += string.Format(" AND OperatingFlg = {0}", (int)CommonDefine.SalaryOperateKind.Oparateing); // 対応中フラグ
|
|
| 509 |
DetailSQL += string.Format(" AND OPERATINGFLG = {0}", (int)CommonDefine.SalaryOperateKind.Oparateing); // 対応中フラグ
|
|
| 510 | 510 |
DetailSQL += string.Format(" AND SALARYFLG != {0}", (int)CommonDefine.SalaryDevision.Noting); // 給与振分区分
|
| 511 | 511 |
DetailSQL += string.Format(" AND GROUPCOUNT IN ({0},{1},{2})",
|
| 512 | 512 |
(int)FrmConstructionLedger.DataGroup.Instructor, // 指導員給料 |
| ... | ... | |
| 548 | 548 |
|
| 549 | 549 |
// 1日分の給与を取得する |
| 550 | 550 |
double dSaraly = Get1DaysSalaryForFixed(PersonDB, CurRec.CompanyCode, CurRec.GroupCount); |
| 551 |
//double dSaraly = CurRec.SalaryOnRegist / CommonDefine.s_ManHourUnitMonth; |
|
| 551 | 552 |
|
| 552 | 553 |
switch (CurRec.SalaryFlg) |
| 553 | 554 |
{
|
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsExcute.cs | ||
|---|---|---|
| 79 | 79 |
RequestPrint = 32, // 32:請求書印刷 |
| 80 | 80 |
CostomerRegistList = 33, // 33:発注者登録申請一覧 |
| 81 | 81 |
CostomerRegist = 34, // 34:発注者登録申請 |
| 82 |
SubConstrRegistList = 35, // 35:協力会社登録申請一覧 |
|
| 83 |
SubConstrRegist = 36 // 36:協力会社登録申請 |
|
| 82 | 84 |
} |
| 83 | 85 |
#endregion |
| 84 | 86 |
|
| ... | ... | |
| 138 | 140 |
} |
| 139 | 141 |
#endregion |
| 140 | 142 |
|
| 141 |
#region 処理名称 |
|
| 143 |
#region 通常処理名称
|
|
| 142 | 144 |
/// <summary> |
| 143 |
/// 処理名称一覧 |
|
| 145 |
/// 通常処理名称一覧
|
|
| 144 | 146 |
/// </summary> |
| 145 | 147 |
public static Dictionary<int, string> ProcessExecuteName = new Dictionary<int, string>(){
|
| 146 | 148 |
{ (int)ProcessExecuteNo.MainMenu, "メインメニュー"},
|
| ... | ... | |
| 154 | 156 |
{ (int)ProcessExecuteNo.ConstructionCopyList, "工事案件コピー－機能"},
|
| 155 | 157 |
{ (int)ProcessExecuteNo.PurchaseOrderEntry, "注文書－入力"},
|
| 156 | 158 |
{ (int)ProcessExecuteNo.PurchaseOrderPrint, "注文書－印刷"},
|
| 157 |
{ (int)ProcessExecuteNo.DepartmentExpenssList, "部署別台帳－一覧"},
|
|
| 158 |
{ (int)ProcessExecuteNo.ConstructionLedgerList, "工事詳細台帳－一覧"},
|
|
| 159 |
{ (int)ProcessExecuteNo.DepartmentExpenssList, "部署別台帳－表示"},
|
|
| 160 |
{ (int)ProcessExecuteNo.ConstructionLedgerList, "工事台帳まとめ－表示"},
|
|
| 159 | 161 |
{ (int)ProcessExecuteNo.ConstructionLedger, "工事詳細台帳－入力"},
|
| 160 | 162 |
{ (int)ProcessExecuteNo.TAndPCosts, "交通費及び購入品等－入力"},
|
| 161 |
{ (int)ProcessExecuteNo.DRList, "工事日報－一覧"},
|
|
| 163 |
{ (int)ProcessExecuteNo.DRList, "工事日報一覧－表示"},
|
|
| 162 | 164 |
{ (int)ProcessExecuteNo.DRConstruction, "工事日報－入力"},
|
| 163 | 165 |
{ (int)ProcessExecuteNo.Proceedings, "打合せ議事録－入力"},
|
| 164 | 166 |
{ (int)ProcessExecuteNo.DRWork, "出勤日報－入力"},
|
| 165 | 167 |
{ (int)ProcessExecuteNo.PurchaseOrderStatus, "注文書発給一覧－表示"},
|
| 166 | 168 |
{ (int)ProcessExecuteNo.OrderJoin, "工事結合－入力"},
|
| 167 |
{ (int)ProcessExecuteNo.ConstructionSplit, "工事分割－入力"},
|
|
| 169 |
{ (int)ProcessExecuteNo.ConstructionSplit, "見積分割－入力"},
|
|
| 168 | 170 |
{ (int)ProcessExecuteNo.PersonApprovalList, "担当者承認一覧－表示"},
|
| 169 | 171 |
{ (int)ProcessExecuteNo.MaterialList, "資材入力－入力"},
|
| 170 | 172 |
{ (int)ProcessExecuteNo.MaterialHistory, "資材履歴画面－表示"},
|
| ... | ... | |
| 172 | 174 |
{ (int)ProcessExecuteNo.MaterialReserveEntry, "資材貸出－入力"},
|
| 173 | 175 |
{ (int)ProcessExecuteNo.MaterialReturnEntry, "資材返却－入力"},
|
| 174 | 176 |
{ (int)ProcessExecuteNo.MaterialSelect, "資材選択－入力"},
|
| 175 |
{ (int)ProcessExecuteNo.RequestSummaryList, "請求まとめ"},
|
|
| 176 |
{ (int)ProcessExecuteNo.PaymentConfirmation, "入金確認"},
|
|
| 177 |
{ (int)ProcessExecuteNo.RequestInput, "請求入力"},
|
|
| 178 |
{ (int)ProcessExecuteNo.RequestPrint, "請求書印刷"},
|
|
| 179 |
{ (int)ProcessExecuteNo.CostomerRegistList, "発注者登録申請一覧"},
|
|
| 180 |
{ (int)ProcessExecuteNo.CostomerRegist, "発注者登録申請"},
|
|
| 177 |
{ (int)ProcessExecuteNo.RequestSummaryList, "請求まとめ－入力"},
|
|
| 178 |
{ (int)ProcessExecuteNo.PaymentConfirmation, "入金確認－入力"},
|
|
| 179 |
{ (int)ProcessExecuteNo.RequestInput, "請求入力－入力"},
|
|
| 180 |
{ (int)ProcessExecuteNo.RequestPrint, "請求書発行－印刷"},
|
|
| 181 |
{ (int)ProcessExecuteNo.CostomerRegistList, "発注者登録申請一覧－表示"},
|
|
| 182 |
{ (int)ProcessExecuteNo.CostomerRegist, "発注者登録申請－入力"},
|
|
| 183 |
{ (int)ProcessExecuteNo.SubConstrRegistList, "協力会社登録申請一覧－表示"},
|
|
| 184 |
{ (int)ProcessExecuteNo.SubConstrRegist, "協力会社登録申請－入力"}
|
|
| 181 | 185 |
}; |
| 182 | 186 |
|
| 183 | 187 |
#endregion |
| ... | ... | |
| 219 | 223 |
}; |
| 220 | 224 |
#endregion |
| 221 | 225 |
|
| 226 |
#region サブフォーム処理名定義 |
|
| 227 |
/// <summary> |
|
| 228 |
/// サブフォーム処理名定義 |
|
| 229 |
/// </summary> |
|
| 230 |
public static Dictionary<int, string> subFormExecuteName = new Dictionary<int, string>(){
|
|
| 231 |
{ (int)SubFormExecuteNo.MessageWriter, "掲示板入力－入力" }, // 201
|
|
| 232 |
{ (int)SubFormExecuteNo.MessageReader, "掲示板読込－表示" }, // 202
|
|
| 233 |
{ (int)SubFormExecuteNo.ActionSchdule, "行動予定－入力" }, // 203
|
|
| 234 |
{ (int)SubFormExecuteNo.VehicleSchdule, "車両予約－入力" }, // 204
|
|
| 235 |
{ (int)SubFormExecuteNo.ApprovalScreen, "工事承認画面－機能" }, // 205
|
|
| 236 |
{ (int)SubFormExecuteNo.SubconstractorDiag, "協力会社検索画面－機能" }, // 206
|
|
| 237 |
{ (int)SubFormExecuteNo.SuppliersDiag, "仕入先検索－機能" }, // 207
|
|
| 238 |
{ (int)SubFormExecuteNo.SubConJobDiag, "協力会社職種検索画面－機能" }, // 208
|
|
| 239 |
{ (int)SubFormExecuteNo.ApprovalPerson, "担当者承認画面－機能" }, // 209
|
|
| 240 |
}; |
|
| 241 |
#endregion |
|
| 242 |
|
|
| 222 | 243 |
#region 承認処理定義 |
| 223 | 244 |
/// <summary> |
| 224 | 245 |
/// 承認一覧 |
| ... | ... | |
| 265 | 286 |
/// 9:発注者登録承認 |
| 266 | 287 |
/// </summary> |
| 267 | 288 |
CostomerRegistApproval, |
| 289 |
/// <summary> |
|
| 290 |
///10:協力会社登録承認 |
|
| 291 |
/// </summary> |
|
| 292 |
SubConstregistApproval |
|
| 268 | 293 |
} |
| 269 | 294 |
#endregion |
| 270 | 295 |
|
| ... | ... | |
| 302 | 327 |
{7, "議事録承認"},
|
| 303 | 328 |
{8, "出勤管理承認"},
|
| 304 | 329 |
{9, "発注者登録承認"},
|
| 330 |
{10, "協力会社登録承認"}
|
|
| 305 | 331 |
}; |
| 306 | 332 |
|
| 307 | 333 |
#endregion |
| ... | ... | |
| 325 | 351 |
// Color.MediumVioletRed, |
| 326 | 352 |
// Color.MediumSeaGreen, |
| 327 | 353 |
// }; |
| 328 |
public static Color[] ApprovalTypeColorList = new Color[]{ Color.White,
|
|
| 354 |
public static Color[] ApprovalTypeColorList = new Color[]{
|
|
| 355 |
Color.White, |
|
| 329 | 356 |
Color.RoyalBlue, |
| 330 | 357 |
Color.DarkOrange, |
| 331 | 358 |
Color.IndianRed, |
| 332 |
Color.SlateGray,
|
|
| 359 |
Color.Gray, |
|
| 333 | 360 |
Color.Chartreuse, |
| 334 | 361 |
Color.SteelBlue, |
| 335 | 362 |
Color.LightSeaGreen, |
| 363 |
Color.LawnGreen, |
|
| 336 | 364 |
Color.DarkViolet, |
| 337 | 365 |
Color.MediumVioletRed, |
| 338 | 366 |
Color.MediumSeaGreen, |
| ... | ... | |
| 342 | 370 |
Color.DimGray, |
| 343 | 371 |
Color.LimeGreen, |
| 344 | 372 |
Color.Crimson, |
| 373 |
Color.Sienna, |
|
| 374 |
Color.OliveDrab, |
|
| 375 |
Color.DarkMagenta, |
|
| 376 |
Color.DarkCyan, |
|
| 377 |
Color.DarkSlateBlue, |
|
| 378 |
Color.SeaGreen, |
|
| 379 |
Color.Olive, |
|
| 380 |
Color.Teal, |
|
| 381 |
Color.Purple, |
|
| 382 |
Color.Blue, |
|
| 383 |
Color.Red, |
|
| 384 |
Color.Lime, |
|
| 385 |
Color.Brown, |
|
| 386 |
Color.Firebrick, |
|
| 387 |
Color.DarkOliveGreen, |
|
| 388 |
Color.SaddleBrown, |
|
| 389 |
Color.ForestGreen, |
|
| 390 |
Color.DarkSlateGray, |
|
| 391 |
Color.Indigo, |
|
| 392 |
Color.MediumBlue, |
|
| 393 |
Color.MidnightBlue, |
|
| 394 |
Color.DarkRed, |
|
| 395 |
Color.DarkBlue, |
|
| 396 |
Color.Green, |
|
| 397 |
Color.Navy, |
|
| 398 |
Color.Maroon, |
|
| 399 |
Color.DarkGreen, |
|
| 400 |
Color.Black |
|
| 345 | 401 |
}; |
| 346 | 402 |
|
| 347 | 403 |
#endregion |
| ... | ... | |
| 491 | 547 |
ProcessExecuteNo_CostomerRegist(m_ProcControlPara[NowPoint]); |
| 492 | 548 |
break; |
| 493 | 549 |
|
| 550 |
case (int)ProcessExecuteNo.SubConstrRegistList: // 35:協力会社登録申請一覧 |
|
| 551 |
ProcessExecuteNo_SubConstrRegistList(m_ProcControlPara[NowPoint]); |
|
| 552 |
break; |
|
| 553 |
|
|
| 554 |
case (int)ProcessExecuteNo.SubConstrRegist: // 36:協力会社登録申請 |
|
| 555 |
ProcessExecuteNo_SubConstrRegist(m_ProcControlPara[NowPoint]); |
|
| 556 |
break; |
|
| 557 |
|
|
| 494 | 558 |
#endregion |
| 495 | 559 |
|
| 496 | 560 |
#region マスタメンテ |
| ... | ... | |
| 603 | 667 |
break; |
| 604 | 668 |
|
| 605 | 669 |
#endregion |
| 670 |
|
|
| 671 |
default: |
|
| 672 |
BackProcess(); |
|
| 673 |
break; |
|
| 606 | 674 |
} |
| 607 | 675 |
} |
| 608 | 676 |
} |
| ... | ... | |
| 1730 | 1798 |
try |
| 1731 | 1799 |
{
|
| 1732 | 1800 |
// 自分のハンドルをリストへセットする |
| 1733 |
int ProcessNo = (int)ClsExcute.ProcessExecuteNo.DRWork;
|
|
| 1801 |
int ProcessNo = (int)ClsExcute.ProcessExecuteNo.CostomerRegist;
|
|
| 1734 | 1802 |
ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = ProcessNo; |
| 1735 | 1803 |
ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = (Form)frm; |
| 1736 | 1804 |
|
| ... | ... | |
| 1763 | 1831 |
} |
| 1764 | 1832 |
#endregion |
| 1765 | 1833 |
|
| 1834 |
#region 協力会社登録申請一覧 |
|
| 1835 |
/// <summary> |
|
| 1836 |
/// 協力会社登録申請一覧 |
|
| 1837 |
/// </summary> |
|
| 1838 |
/// <param name="CurrentPara"></param> |
|
| 1839 |
public static void ProcessExecuteNo_SubConstrRegistList(ProcessParameter CurrentPara) |
|
| 1840 |
{
|
|
| 1841 |
// 協力会社登録申請一覧 |
|
| 1842 |
FrmSubConstrRegistList frm = new FrmSubConstrRegistList(); |
|
| 1843 |
try |
|
| 1844 |
{
|
|
| 1845 |
// フォーム表示 |
|
| 1846 |
frm.ShowDialog(); |
|
| 1847 |
} |
|
| 1848 |
catch (Exception ex) |
|
| 1849 |
{
|
|
| 1850 |
logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
|
|
| 1851 |
BackProcess(); |
|
| 1852 |
} |
|
| 1853 |
finally |
|
| 1854 |
{
|
|
| 1855 |
frm.Dispose(); frm = null; |
|
| 1856 |
} |
|
| 1857 |
} |
|
| 1766 | 1858 |
#endregion |
| 1767 | 1859 |
|
| 1860 |
#region 協力会社登録申請一覧 |
|
| 1861 |
/// <summary> |
|
| 1862 |
/// 協力会社登録申請一覧 |
|
| 1863 |
/// </summary> |
|
| 1864 |
/// <param name="CurrentPara"></param> |
|
| 1865 |
public static void ProcessExecuteNo_SubConstrRegist(ProcessParameter CurrentPara) |
|
| 1866 |
{
|
|
| 1867 |
// 協力会社登録申請 |
|
| 1868 |
FrmSubConstrRegist frm = new FrmSubConstrRegist(); |
|
| 1869 |
try |
|
| 1870 |
{
|
|
| 1871 |
// 自分のハンドルをリストへセットする |
|
| 1872 |
int ProcessNo = (int)ClsExcute.ProcessExecuteNo.CostomerRegist; |
|
| 1873 |
ClsExcute.SubFormHandleList[ProcessNo].ProcessNo = ProcessNo; |
|
| 1874 |
ClsExcute.SubFormHandleList[ProcessNo].SubFormHandle = (Form)frm; |
|
| 1875 |
|
|
| 1876 |
// 起動・編集フラグ |
|
| 1877 |
int EditFlg = (int)CommonDefine.ProcessDataEdit.Reference; |
|
| 1878 |
if (!ClsSecurityPermission.GetExecutePermission(ProcessNo, ref EditFlg)) |
|
| 1879 |
{
|
|
| 1880 |
BackProcess(); |
|
| 1881 |
return; |
|
| 1882 |
} |
|
| 1883 |
if (EditFlg == (int)CommonDefine.ProcessDataEdit.Reference) frm.EditLock = true; |
|
| 1884 |
|
|
| 1885 |
// パラメータセット |
|
| 1886 |
frm.PersonCode = CurrentPara.IntExecParameter[0]; |
|
| 1887 |
frm.CreateDate = CurrentPara.DateExecParameter[0]; |
|
| 1888 |
frm.SeqNo = CurrentPara.IntExecParameter[1]; |
|
| 1889 |
|
|
| 1890 |
// フォーム表示 |
|
| 1891 |
frm.ShowDialog(); |
|
| 1892 |
} |
|
| 1893 |
catch (Exception ex) |
|
| 1894 |
{
|
|
| 1895 |
logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
|
|
| 1896 |
BackProcess(); |
|
| 1897 |
} |
|
| 1898 |
finally |
|
| 1899 |
{
|
|
| 1900 |
frm.Dispose(); frm = null; |
|
| 1901 |
} |
|
| 1902 |
} |
|
| 1903 |
#endregion |
|
| 1904 |
|
|
| 1905 |
#endregion |
|
| 1906 |
|
|
| 1768 | 1907 |
#region マスタメンテナンス |
| 1769 | 1908 |
// ----------------- メンテナンス起動 |
| 1770 | 1909 |
#region 管理マスタ |
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsMessageBoradAccess.cs | ||
|---|---|---|
| 213 | 213 |
// 書込み者コードの取得 |
| 214 | 214 |
int FromCode = CommonMotions.cnvInt(objRec[(int)IOMessageBoardData.ColumnCnt.FromCode]); |
| 215 | 215 |
// 書込み者セキュリティランクの取得 |
| 216 |
int TargetSecRank = CommonMotions.cnvInt(objRec[SecBaseDataCnt + (int)IOMSecurity.DataColumn.SecRank]);
|
|
| 216 |
int TargetSecRank = CommonMotions.cnvInt(objRec[SecBaseDataCnt + (int)IOMSecurity.TableColumn.SecRank]);
|
|
| 217 | 217 |
|
| 218 | 218 |
// 秘書からの連絡は編集対象外 |
| 219 | 219 |
if (FromCode == CommonDefine.s_MsgBoardSystemCode) return false; |
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsSecurityPermission.cs | ||
|---|---|---|
| 672 | 672 |
Editflg = (int)CommonDefine.ProcessDataEdit.Edit; |
| 673 | 673 |
return true; |
| 674 | 674 |
} |
| 675 |
// サブウィンドウ等の特殊処理はすべて起動OK |
|
| 676 |
if ((int)ClsExcute.SubFormExecuteNo.MessageWriter <= ExecCode) |
|
| 677 |
{
|
|
| 678 |
Editflg = (int)CommonDefine.ProcessDataEdit.Edit; |
|
| 679 |
return true; |
|
| 680 |
} |
|
| 675 | 681 |
|
| 676 | 682 |
bool bRet = false; |
| 677 | 683 |
if (CommonMotions.LoginUserProcExe.Count != 0) |
| ... | ... | |
| 690 | 696 |
{
|
| 691 | 697 |
bRet = GetExecutePermission(CommonMotions.LoginUserData.PersonCode, ExecCode, ref Editflg); |
| 692 | 698 |
} |
| 693 |
|
|
| 699 |
if (!bRet) Debug.Print("");
|
|
| 694 | 700 |
return bRet; |
| 695 | 701 |
} |
| 696 | 702 |
catch (Exception ex) |
| ... | ... | |
| 781 | 787 |
} |
| 782 | 788 |
#endregion |
| 783 | 789 |
|
| 790 |
#region ログイン者がデータにアクセスできるかを返す（担当者データ） |
|
| 791 |
private enum PersonAppData |
|
| 792 |
{
|
|
| 793 |
DataPersonCode = 0, |
|
| 794 |
DataDepCode, |
|
| 795 |
DataPersonName, |
|
| 796 |
DataSecRank, |
|
| 797 |
DataAffiliationFlg, |
|
| 798 |
RangePersonCode, |
|
| 799 |
RangePersonName, |
|
| 800 |
RangeSecCode, |
|
| 801 |
RangeSecRank, |
|
| 802 |
RangeGeneFlg |
|
| 803 |
} |
|
| 804 |
/// <summary> |
|
| 805 |
/// ログイン者がデータにアクセスできるかを返す |
|
| 806 |
/// </summary> |
|
| 807 |
/// <returns></returns> |
|
| 808 |
public static bool PersonDataAccess2(int PersonCode, int ApprovalCode, DateTime OrderDate, int OrderNo) |
|
| 809 |
{
|
|
| 810 |
IOMPersonInCharge PersonDB = new IOMPersonInCharge(); |
|
| 811 |
try |
|
| 812 |
{
|
|
| 813 |
if (CommonMotions.LoginUserData.PersonCode == CommonDefine.AdminCode) return true; |
|
| 814 |
|
|
| 815 |
bool bRet = false; |
|
| 816 |
|
|
| 817 |
string strSQL ="SELECT"; |
|
| 818 |
strSQL += " A.PERSONCODE, A.DEPARTMENTCODE, A.PERSONNAME, E.SECRANK,"; |
|
| 819 |
strSQL += " B.AFFILIATIONFLG,"; |
|
| 820 |
strSQL += " C.PERSONCODE, C.PERSONNAME, C.SECCODE, D.SECRANK, D.GENERALAFFAIRS"; |
|
| 821 |
strSQL += " FROM PERSONINCHARGEMASTER A, PERSONDEPARTMENTMASTER B, PERSONINCHARGEMASTER C, SECURITYMASTER D, SECURITYMASTER E"; |
|
| 822 |
strSQL += string.Format(" WHERE A.PERSONCODE = {0}", PersonCode);
|
|
| 823 |
strSQL += " AND B.DEPARTMENTCODE = A.DEPARTMENTCODE"; |
|
| 824 |
strSQL += " AND C.PERSONCODE = B.PERSONCODE"; |
|
| 825 |
strSQL += " AND D.SECCODE = C.SECCODE"; |
|
| 826 |
strSQL += " AND E.SECCODE = A.SECCODE"; |
|
| 827 |
strSQL += " ORDER BY B.PERSONCODE"; |
|
| 828 |
|
|
| 829 |
ArrayList arData = new ArrayList(); |
|
| 830 |
if (!PersonDB.ExecuteReader(strSQL, ref arData)) return false; |
|
| 831 |
|
|
| 832 |
object[] objLoginUser = null; |
|
| 833 |
int wrkPersonCode = 0; |
|
| 834 |
foreach (object[] CurRec in arData) |
|
| 835 |
{
|
|
| 836 |
wrkPersonCode = CommonMotions.cnvInt(CurRec[(int)PersonAppData.RangePersonCode]); |
|
| 837 |
if (wrkPersonCode == CommonMotions.LoginUserData.PersonCode) |
|
| 838 |
{
|
|
| 839 |
objLoginUser = CurRec; |
|
| 840 |
break; |
|
| 841 |
} |
|
| 842 |
} |
|
| 843 |
|
|
| 844 |
// 対象データが無ければアクセスできない |
|
| 845 |
if (objLoginUser == null) return false; |
|
| 846 |
|
|
| 847 |
// 総務はアクセスできる |
|
| 848 |
int GeneFlg = CommonMotions.cnvInt(objLoginUser[(int)PersonAppData.RangeGeneFlg]); |
|
| 849 |
if (GeneFlg == (int)CommonDefine.GeneralAffairs.GeneralDep) bRet = true; |
|
| 850 |
|
|
| 851 |
// 保護区分ランクがログイン者以下の場合はアクセスできる |
|
| 852 |
int SecRank = CommonMotions.cnvInt(objLoginUser[(int)PersonAppData.DataSecRank]); |
|
| 853 |
if (SecRank <= CommonMotions.LoginUserSecurity.SecRank) bRet = true; |
|
| 854 |
|
|
| 855 |
return bRet; |
|
| 856 |
} |
|
| 857 |
catch (Exception ex) |
|
| 858 |
{
|
|
| 859 |
logger.ErrorFormat("システムエラー：{0}：{1}", CommonMotions.GetMethodName(), ex.Message);
|
|
| 860 |
return false; |
|
| 861 |
} |
|
| 862 |
finally |
|
| 863 |
{
|
|
| 864 |
PersonDB.close(); PersonDB = null; |
|
| 865 |
} |
|
| 866 |
} |
|
| 867 |
#endregion |
|
| 868 |
|
|
| 784 | 869 |
#region 対象者が対象データにアクセスできるかを返す |
| 785 | 870 |
/// <summary> |
| 786 | 871 |
/// 対象者が対象データにアクセスできるかを返す |
| trunk/src/ProcessManagement/ProcessManagement/Common/Process/ClsSystemOnceExecute.cs | ||
|---|---|---|
| 655 | 655 |
int iCode2 = CommonDefine.ProjectsStatus.First(x => x.Value.Equals("施工完了")).Key;
|
| 656 | 656 |
|
| 657 | 657 |
// 入力完了以外を対象にする |
| 658 |
string strSQL = string.Format(" A WHERE A.ComplateFlg <> {0}", (int)CommonDefine.ComplateTitleNo.Complated);
|
|
| 658 |
string strSQL = string.Format(" A WHERE A.COMPLATEFLG <> {0}", (int)CommonDefine.ComplateTitleNo.Complated);
|
|
| 659 | 659 |
strSQL += " AND A.CONSTRUCTIONCODE IN (SELECT A1.CONSTRUCTIONCODE FROM CONSTRUCTIONBASEINFO A1"; |
| 660 | 660 |
strSQL += string.Format(" WHERE A1.CONSTRUCTIONSTATUSFLG != {0}", iCode1);
|
| 661 | 661 |
strSQL += string.Format(" AND A1.CONSTRUCTIONSTATUSFLG < {0})", iCode2);
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceDailyData.cs | ||
|---|---|---|
| 31 | 31 |
/// <summary> |
| 32 | 32 |
/// データフィールド並び |
| 33 | 33 |
/// </summary> |
| 34 |
public enum DataColumn
|
|
| 34 |
public enum TableColumn
|
|
| 35 | 35 |
{
|
| 36 | 36 |
/// <summary> |
| 37 | 37 |
/// 作成者コード |
| ... | ... | |
| 321 | 321 |
strcmd += " SET"; |
| 322 | 322 |
switch (FeildNo) |
| 323 | 323 |
{
|
| 324 |
case (int)DataColumn.PersonCode:
|
|
| 324 |
case (int)TableColumn.PersonCode:
|
|
| 325 | 325 |
strcmd += string.Format(" PersonCode = {0}", (int)value);
|
| 326 | 326 |
break; |
| 327 |
case (int)DataColumn.AttendanceDate:
|
|
| 327 |
case (int)TableColumn.AttendanceDate:
|
|
| 328 | 328 |
strcmd += string.Format(" AttendanceDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());
|
| 329 | 329 |
break; |
| 330 |
case (int)DataColumn.SeqNo:
|
|
| 330 |
case (int)TableColumn.SeqNo:
|
|
| 331 | 331 |
strcmd += string.Format(" SeqNo = {0}", (int)value);
|
| 332 | 332 |
break; |
| 333 |
case (int)DataColumn.ActionResult:
|
|
| 333 |
case (int)TableColumn.ActionResult:
|
|
| 334 | 334 |
strcmd += string.Format(" ActionResult = '{0}'", value.ToString());
|
| 335 | 335 |
break; |
| 336 |
case (int)DataColumn.OvertimeHours:
|
|
| 336 |
case (int)TableColumn.OvertimeHours:
|
|
| 337 | 337 |
strcmd += string.Format(" OvertimeHours = {0}", (double)value);
|
| 338 | 338 |
break; |
| 339 |
case (int)DataColumn.WorkingComment:
|
|
| 339 |
case (int)TableColumn.WorkingComment:
|
|
| 340 | 340 |
strcmd += string.Format(" WorkingComment = '{0}'", CommonMotions.cnvString(value));
|
| 341 | 341 |
break; |
| 342 | 342 |
} |
| ... | ... | |
| 367 | 367 |
try |
| 368 | 368 |
{
|
| 369 | 369 |
// データ取得 |
| 370 |
wrk.PersonCode = int.Parse(objwrk[(int)DataColumn.PersonCode].ToString()); // 担当者コード
|
|
| 371 |
wrk.AttendanceDate = DateTime.Parse(objwrk[(int)DataColumn.AttendanceDate].ToString()); // 日報作成日
|
|
| 372 |
wrk.SeqNo = int.Parse(objwrk[(int)DataColumn.SeqNo].ToString()); // 明細行番号
|
|
| 373 |
wrk.ActionResult = objwrk[(int)DataColumn.ActionResult].ToString(); // 行動実績
|
|
| 374 |
wrk.OvertimeHours = double.Parse(objwrk[(int)DataColumn.OvertimeHours].ToString()); // 残業時間
|
|
| 375 |
wrk.WorkingComment = objwrk[(int)DataColumn.WorkingComment].ToString(); // 当日作業内容
|
|
| 370 |
wrk.PersonCode = int.Parse(objwrk[(int)TableColumn.PersonCode].ToString()); // 担当者コード
|
|
| 371 |
wrk.AttendanceDate = DateTime.Parse(objwrk[(int)TableColumn.AttendanceDate].ToString()); // 日報作成日
|
|
| 372 |
wrk.SeqNo = int.Parse(objwrk[(int)TableColumn.SeqNo].ToString()); // 明細行番号
|
|
| 373 |
wrk.ActionResult = objwrk[(int)TableColumn.ActionResult].ToString(); // 行動実績
|
|
| 374 |
wrk.OvertimeHours = double.Parse(objwrk[(int)TableColumn.OvertimeHours].ToString()); // 残業時間
|
|
| 375 |
wrk.WorkingComment = objwrk[(int)TableColumn.WorkingComment].ToString(); // 当日作業内容
|
|
| 376 | 376 |
|
| 377 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)DataColumn.EntryDate].ToString());
|
|
| 378 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)DataColumn.UpdateDate].ToString());
|
|
| 377 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
|
|
| 378 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());
|
|
| 379 | 379 |
} |
| 380 | 380 |
catch (OracleException oraex) |
| 381 | 381 |
{
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOAttendanceData.cs | ||
|---|---|---|
| 31 | 31 |
/// <summary> |
| 32 | 32 |
/// データフィールド並び |
| 33 | 33 |
/// </summary> |
| 34 |
public enum DataColumn
|
|
| 34 |
public enum TableColumn
|
|
| 35 | 35 |
{
|
| 36 | 36 |
/// <summary> |
| 37 | 37 |
/// 作成者コード |
| ... | ... | |
| 188 | 188 |
|
| 189 | 189 |
strcmd += "(";
|
| 190 | 190 |
bool bFirst = true; |
| 191 |
foreach (var gender in Enum.GetValues(typeof(DataColumn)))
|
|
| 191 |
foreach (var gender in Enum.GetValues(typeof(TableColumn)))
|
|
| 192 | 192 |
{
|
| 193 | 193 |
if (!bFirst) strcmd += " ,"; |
| 194 | 194 |
strcmd += gender.ToString(); |
| ... | ... | |
| 328 | 328 |
strcmd += " SET"; |
| 329 | 329 |
switch (FeildNo) |
| 330 | 330 |
{
|
| 331 |
case (int)DataColumn.PersonCode:
|
|
| 331 |
case (int)TableColumn.PersonCode:
|
|
| 332 | 332 |
strcmd += string.Format(" PersonCode = {0}", (int)value);
|
| 333 | 333 |
break; |
| 334 |
case (int)DataColumn.AttendanceMonth:
|
|
| 334 |
case (int)TableColumn.AttendanceMonth:
|
|
| 335 | 335 |
strcmd += string.Format(" AttendanceMonth = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());
|
| 336 | 336 |
break; |
| 337 |
case (int)DataColumn.LastDays:
|
|
| 337 |
case (int)TableColumn.LastDays:
|
|
| 338 | 338 |
strcmd += string.Format(" LastDays = {0}", (int)value);
|
| 339 | 339 |
break; |
| 340 |
case (int)DataColumn.AttendDayCount:
|
|
| 340 |
case (int)TableColumn.AttendDayCount:
|
|
| 341 | 341 |
strcmd += string.Format(" AttendDayCount = {0}", (int)value);
|
| 342 | 342 |
break; |
| 343 |
case (int)DataColumn.TotalOverTimes:
|
|
| 343 |
case (int)TableColumn.TotalOverTimes:
|
|
| 344 | 344 |
strcmd += string.Format(" TotalOverTimes = {0}", (double)value);
|
| 345 | 345 |
break; |
| 346 |
case (int)DataColumn.OrderDate:
|
|
| 346 |
case (int)TableColumn.OrderDate:
|
|
| 347 | 347 |
strcmd += string.Format(" OrderDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());
|
| 348 | 348 |
break; |
| 349 |
case (int)DataColumn.OrderNo:
|
|
| 349 |
case (int)TableColumn.OrderNo:
|
|
| 350 | 350 |
strcmd += string.Format(" OrderNo = {0}", (int)value);
|
| 351 | 351 |
break; |
| 352 | 352 |
} |
| ... | ... | |
| 377 | 377 |
try |
| 378 | 378 |
{
|
| 379 | 379 |
// データ取得 |
| 380 |
wrk.PersonCode = int.Parse(objwrk[(int)DataColumn.PersonCode].ToString()); // 担当者コード
|
|
| 381 |
wrk.AttendanceMonth = DateTime.Parse(objwrk[(int)DataColumn.AttendanceMonth].ToString()); // 出勤管理年月
|
|
| 382 |
wrk.LastDays = int.Parse(objwrk[(int)DataColumn.LastDays].ToString()); // 当月最終日
|
|
| 383 |
wrk.AttendDayCount = int.Parse(objwrk[(int)DataColumn.AttendDayCount].ToString()); // 出勤日数
|
|
| 384 |
wrk.TotalOverTimes = double.Parse(objwrk[(int)DataColumn.TotalOverTimes].ToString()); // 残業時間数
|
|
| 385 |
wrk.OrderDate = DateTime.Parse(objwrk[(int)DataColumn.OrderDate].ToString()); // 申請日
|
|
| 386 |
wrk.OrderNo = int.Parse(objwrk[(int)DataColumn.OrderNo].ToString()); // 申請受付番号
|
|
| 380 |
wrk.PersonCode = int.Parse(objwrk[(int)TableColumn.PersonCode].ToString()); // 担当者コード
|
|
| 381 |
wrk.AttendanceMonth = DateTime.Parse(objwrk[(int)TableColumn.AttendanceMonth].ToString()); // 出勤管理年月
|
|
| 382 |
wrk.LastDays = int.Parse(objwrk[(int)TableColumn.LastDays].ToString()); // 当月最終日
|
|
| 383 |
wrk.AttendDayCount = int.Parse(objwrk[(int)TableColumn.AttendDayCount].ToString()); // 出勤日数
|
|
| 384 |
wrk.TotalOverTimes = double.Parse(objwrk[(int)TableColumn.TotalOverTimes].ToString()); // 残業時間数
|
|
| 385 |
wrk.OrderDate = DateTime.Parse(objwrk[(int)TableColumn.OrderDate].ToString()); // 申請日
|
|
| 386 |
wrk.OrderNo = int.Parse(objwrk[(int)TableColumn.OrderNo].ToString()); // 申請受付番号
|
|
| 387 | 387 |
|
| 388 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)DataColumn.EntryDate].ToString());
|
|
| 389 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)DataColumn.UpdateDate].ToString());
|
|
| 388 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
|
|
| 389 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());
|
|
| 390 | 390 |
} |
| 391 | 391 |
catch (OracleException oraex) |
| 392 | 392 |
{
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionBudgetDetail.cs | ||
|---|---|---|
| 31 | 31 |
/// <summary> |
| 32 | 32 |
/// 工事予算データ明細フィールド並び |
| 33 | 33 |
/// </summary> |
| 34 |
public enum DataColumn
|
|
| 34 |
public enum TableColumn
|
|
| 35 | 35 |
{
|
| 36 | 36 |
ConstructionCode = 0, // 工事番号 |
| 37 | 37 |
|
| ... | ... | |
| 342 | 342 |
strcmd += " SET"; |
| 343 | 343 |
switch (FeildNo) |
| 344 | 344 |
{
|
| 345 |
case (int)DataColumn.ConstructionCode: // 工事番号
|
|
| 345 |
case (int)TableColumn.ConstructionCode: // 工事番号
|
|
| 346 | 346 |
strcmd += string.Format(" ConstructionCode = {0}", ((int)value).ToString());
|
| 347 | 347 |
break; |
| 348 |
case (int)DataColumn.GroupCount: // グループ番号
|
|
| 348 |
case (int)TableColumn.GroupCount: // グループ番号
|
|
| 349 | 349 |
strcmd += string.Format(" GroupCount = {0}", ((int)value).ToString());
|
| 350 | 350 |
break; |
| 351 |
case (int)DataColumn.LineCount: // 行番号
|
|
| 351 |
case (int)TableColumn.LineCount: // 行番号
|
|
| 352 | 352 |
strcmd += string.Format(" LineCount = {0}", ((int)value).ToString());
|
| 353 | 353 |
break; |
| 354 |
case (int)DataColumn.ComponentCode: // 構成キー
|
|
| 354 |
case (int)TableColumn.ComponentCode: // 構成キー
|
|
| 355 | 355 |
strcmd += string.Format(" ComponentCode = {0}", ((int)value).ToString());
|
| 356 | 356 |
break; |
| 357 |
case (int)DataColumn.ItemCode: // 工種キー
|
|
| 357 |
case (int)TableColumn.ItemCode: // 工種キー
|
|
| 358 | 358 |
strcmd += string.Format(" ItemCode = {0}", ((int)value).ToString());
|
| 359 | 359 |
break; |
| 360 |
case (int)DataColumn.FirstString: // 項目名称
|
|
| 360 |
case (int)TableColumn.FirstString: // 項目名称
|
|
| 361 | 361 |
strcmd += string.Format(" FirstString = '{0}'", value.ToString());
|
| 362 | 362 |
break; |
| 363 |
case (int)DataColumn.SecondString: // 工事内容
|
|
| 363 |
case (int)TableColumn.SecondString: // 工事内容
|
|
| 364 | 364 |
strcmd += string.Format(" SecondString = '{0}'", value.ToString());
|
| 365 | 365 |
break; |
| 366 |
case (int)DataColumn.CompanyType: // 協力会社コードタイプ
|
|
| 366 |
case (int)TableColumn.CompanyType: // 協力会社コードタイプ
|
|
| 367 | 367 |
strcmd += string.Format(" CompanyType = {0}", ((int)value).ToString());
|
| 368 | 368 |
break; |
| 369 |
case (int)DataColumn.CompanyCode: // 協力会社コード
|
|
| 369 |
case (int)TableColumn.CompanyCode: // 協力会社コード
|
|
| 370 | 370 |
strcmd += string.Format(" CompanyCode = {0}", ((int)value).ToString());
|
| 371 | 371 |
break; |
| 372 |
case (int)DataColumn.CompanyName: // 協力会社名称
|
|
| 372 |
case (int)TableColumn.CompanyName: // 協力会社名称
|
|
| 373 | 373 |
strcmd += string.Format(" CompanyName = '{0}'", value.ToString());
|
| 374 | 374 |
break; |
| 375 |
case (int)DataColumn.EstimatePrice: // 見積時金額
|
|
| 375 |
case (int)TableColumn.EstimatePrice: // 見積時金額
|
|
| 376 | 376 |
strcmd += string.Format(" EstimatePrice = {0}", ((double)value).ToString());
|
| 377 | 377 |
break; |
| 378 |
case (int)DataColumn.NegotiationPrice: // 交渉時金額
|
|
| 378 |
case (int)TableColumn.NegotiationPrice: // 交渉時金額
|
|
| 379 | 379 |
strcmd += string.Format(" NegotiationPrice = {0}", ((double)value).ToString());
|
| 380 | 380 |
break; |
| 381 |
case (int)DataColumn.OrderDesiredAmount: // 発注希望金額
|
|
| 381 |
case (int)TableColumn.OrderDesiredAmount: // 発注希望金額
|
|
| 382 | 382 |
strcmd += string.Format(" OrderDesiredAmount = {0}", ((double)value).ToString());
|
| 383 | 383 |
break; |
| 384 |
case (int)DataColumn.ExecutionAmount: // 実行金額
|
|
| 384 |
case (int)TableColumn.ExecutionAmount: // 実行金額
|
|
| 385 | 385 |
strcmd += string.Format(" ExecutionAmount = {0}", ((double)value).ToString());
|
| 386 | 386 |
break; |
| 387 |
case (int)DataColumn.AmountConfigRate: // 金額構成率
|
|
| 387 |
case (int)TableColumn.AmountConfigRate: // 金額構成率
|
|
| 388 | 388 |
strcmd += string.Format(" AmountConfigRate = {0}", ((double)value).ToString());
|
| 389 | 389 |
break; |
| 390 |
case (int)DataColumn.NegotiateFlg: // 協力業者交渉フラグ
|
|
| 390 |
case (int)TableColumn.NegotiateFlg: // 協力業者交渉フラグ
|
|
| 391 | 391 |
strcmd += string.Format(" NegotiateFlg = {0}", ((int)value).ToString());
|
| 392 | 392 |
break; |
| 393 | 393 |
} |
| ... | ... | |
| 418 | 418 |
try |
| 419 | 419 |
{
|
| 420 | 420 |
// データ取得 |
| 421 |
wrk.ConstructionCode = int.Parse(objwrk[(int)DataColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 421 |
wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 422 | 422 |
|
| 423 |
wrk.GroupCount = int.Parse(objwrk[(int)DataColumn.GroupCount].ToString()); // グループ番号
|
|
| 424 |
wrk.LineCount = int.Parse(objwrk[(int)DataColumn.LineCount].ToString()); // 行番号
|
|
| 425 |
wrk.ComponentCode = int.Parse(objwrk[(int)DataColumn.ComponentCode].ToString()); // 構成キー
|
|
| 426 |
wrk.ItemCode = int.Parse(objwrk[(int)DataColumn.ItemCode].ToString()); // 工種キー
|
|
| 427 |
wrk.FirstString = objwrk[(int)DataColumn.FirstString].ToString(); // 項目名称
|
|
| 428 |
wrk.SecondString = objwrk[(int)DataColumn.SecondString].ToString(); // 工事内容
|
|
| 429 |
wrk.CompanyType = int.Parse(objwrk[(int)DataColumn.CompanyType].ToString()); // 協力会社コードタイプ
|
|
| 430 |
wrk.CompanyCode = int.Parse(objwrk[(int)DataColumn.CompanyCode].ToString()); // 協力会社コード
|
|
| 431 |
wrk.CompanyName = objwrk[(int)DataColumn.CompanyName].ToString(); // 協力会社名称
|
|
| 432 |
wrk.EstimatePrice = double.Parse(objwrk[(int)DataColumn.EstimatePrice].ToString()); // 見積時金額
|
|
| 433 |
wrk.NegotiationPrice = double.Parse(objwrk[(int)DataColumn.NegotiationPrice].ToString()); // 交渉時金額
|
|
| 434 |
wrk.OrderDesiredAmount = double.Parse(objwrk[(int)DataColumn.OrderDesiredAmount].ToString()); // 発注希望金額
|
|
| 435 |
wrk.ExecutionAmount = double.Parse(objwrk[(int)DataColumn.ExecutionAmount].ToString()); // 実行金額
|
|
| 436 |
wrk.AmountConfigRate = double.Parse(objwrk[(int)DataColumn.AmountConfigRate].ToString()); // 金額構成率
|
|
| 437 |
wrk.NegotiateFlg = int.Parse(objwrk[(int)DataColumn.NegotiateFlg].ToString()); // 協力業者交渉フラグ
|
|
| 423 |
wrk.GroupCount = int.Parse(objwrk[(int)TableColumn.GroupCount].ToString()); // グループ番号
|
|
| 424 |
wrk.LineCount = int.Parse(objwrk[(int)TableColumn.LineCount].ToString()); // 行番号
|
|
| 425 |
wrk.ComponentCode = int.Parse(objwrk[(int)TableColumn.ComponentCode].ToString()); // 構成キー
|
|
| 426 |
wrk.ItemCode = int.Parse(objwrk[(int)TableColumn.ItemCode].ToString()); // 工種キー
|
|
| 427 |
wrk.FirstString = objwrk[(int)TableColumn.FirstString].ToString(); // 項目名称
|
|
| 428 |
wrk.SecondString = objwrk[(int)TableColumn.SecondString].ToString(); // 工事内容
|
|
| 429 |
wrk.CompanyType = int.Parse(objwrk[(int)TableColumn.CompanyType].ToString()); // 協力会社コードタイプ
|
|
| 430 |
wrk.CompanyCode = int.Parse(objwrk[(int)TableColumn.CompanyCode].ToString()); // 協力会社コード
|
|
| 431 |
wrk.CompanyName = objwrk[(int)TableColumn.CompanyName].ToString(); // 協力会社名称
|
|
| 432 |
wrk.EstimatePrice = double.Parse(objwrk[(int)TableColumn.EstimatePrice].ToString()); // 見積時金額
|
|
| 433 |
wrk.NegotiationPrice = double.Parse(objwrk[(int)TableColumn.NegotiationPrice].ToString()); // 交渉時金額
|
|
| 434 |
wrk.OrderDesiredAmount = double.Parse(objwrk[(int)TableColumn.OrderDesiredAmount].ToString()); // 発注希望金額
|
|
| 435 |
wrk.ExecutionAmount = double.Parse(objwrk[(int)TableColumn.ExecutionAmount].ToString()); // 実行金額
|
|
| 436 |
wrk.AmountConfigRate = double.Parse(objwrk[(int)TableColumn.AmountConfigRate].ToString()); // 金額構成率
|
|
| 437 |
wrk.NegotiateFlg = int.Parse(objwrk[(int)TableColumn.NegotiateFlg].ToString()); // 協力業者交渉フラグ
|
|
| 438 | 438 |
|
| 439 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)DataColumn.EntryDate].ToString());
|
|
| 440 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)DataColumn.UpdateDate].ToString());
|
|
| 439 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
|
|
| 440 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());
|
|
| 441 | 441 |
} |
| 442 | 442 |
catch (OracleException oraex) |
| 443 | 443 |
{
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLedger.cs | ||
|---|---|---|
| 31 | 31 |
/// <summary> |
| 32 | 32 |
/// 工事詳細台帳データフィールド並び |
| 33 | 33 |
/// </summary> |
| 34 |
public enum DataColumn
|
|
| 34 |
public enum TableColumn
|
|
| 35 | 35 |
{
|
| 36 | 36 |
ConstructionCode = 0, // 工事番号 |
| 37 | 37 |
|
| ... | ... | |
| 394 | 394 |
strcmd += " SET"; |
| 395 | 395 |
switch (FeildNo) |
| 396 | 396 |
{
|
| 397 |
case (int)DataColumn.ConstructionCode: // 工事番号
|
|
| 397 |
case (int)TableColumn.ConstructionCode: // 工事番号
|
|
| 398 | 398 |
strcmd += string.Format(" ConstructionCode = {0}", ((int)value).ToString());
|
| 399 | 399 |
break; |
| 400 |
case (int)DataColumn.ConstructionPeriod: // 事業期
|
|
| 400 |
case (int)TableColumn.ConstructionPeriod: // 事業期
|
|
| 401 | 401 |
strcmd += string.Format(" ConstructionPeriod = {0}", ((int)value).ToString());
|
| 402 | 402 |
break; |
| 403 |
case (int)DataColumn.CreatorCode: // 作成者コード
|
|
| 403 |
case (int)TableColumn.CreatorCode: // 作成者コード
|
|
| 404 | 404 |
strcmd += string.Format(" CreatorCode = {0}", ((int)value).ToString());
|
| 405 | 405 |
break; |
| 406 |
case (int)DataColumn.CreatorName: // 作成者名
|
|
| 406 |
case (int)TableColumn.CreatorName: // 作成者名
|
|
| 407 | 407 |
strcmd += string.Format(" CreatorName = '{0}'", value.ToString());
|
| 408 | 408 |
break; |
| 409 |
case (int)DataColumn.CreateDate: // 作成日
|
|
| 409 |
case (int)TableColumn.CreateDate: // 作成日
|
|
| 410 | 410 |
strcmd += string.Format(" CreateDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());
|
| 411 | 411 |
break; |
| 412 |
case (int)DataColumn.ConstructionTimes: // 工期（単位・月）
|
|
| 412 |
case (int)TableColumn.ConstructionTimes: // 工期（単位・月）
|
|
| 413 | 413 |
strcmd += string.Format(" ConstructionTimes = {0}", ((int)value).ToString());
|
| 414 | 414 |
break; |
| 415 |
case (int)DataColumn.ConstructionStart: // 契約工期開始
|
|
| 415 |
case (int)TableColumn.ConstructionStart: // 契約工期開始
|
|
| 416 | 416 |
strcmd += string.Format(" ConstructionStart = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());
|
| 417 | 417 |
break; |
| 418 |
case (int)DataColumn.ConstructionEnd: // 契約工期完了
|
|
| 418 |
case (int)TableColumn.ConstructionEnd: // 契約工期完了
|
|
| 419 | 419 |
strcmd += string.Format(" ConstructionEnd = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());
|
| 420 | 420 |
break; |
| 421 |
case (int)DataColumn.OrdersDecisionPrice: // 税抜受注決定金額
|
|
| 421 |
case (int)TableColumn.OrdersDecisionPrice: // 税抜受注決定金額
|
|
| 422 | 422 |
strcmd += string.Format(" OrdersDecisionPrice = {0}", ((int)value).ToString());
|
| 423 | 423 |
break; |
| 424 |
case (int)DataColumn.CompanyExpenses: // 会社経費合計
|
|
| 424 |
case (int)TableColumn.CompanyExpenses: // 会社経費合計
|
|
| 425 | 425 |
strcmd += string.Format(" CompanyExpenses = {0}", ((int)value).ToString());
|
| 426 | 426 |
break; |
| 427 |
case (int)DataColumn.DepartmentExpenses: // 部署経費合計
|
|
| 427 |
case (int)TableColumn.DepartmentExpenses: // 部署経費合計
|
|
| 428 | 428 |
strcmd += string.Format(" DepartmentExpenses = {0}", ((int)value).ToString());
|
| 429 | 429 |
break; |
| 430 |
case (int)DataColumn.SalesExpenses: // 営業経費合計
|
|
| 430 |
case (int)TableColumn.SalesExpenses: // 営業経費合計
|
|
| 431 | 431 |
strcmd += string.Format(" SalesExpenses = {0}", ((int)value).ToString());
|
| 432 | 432 |
break; |
| 433 |
case (int)DataColumn.TotalPayment: // 総支払額
|
|
| 433 |
case (int)TableColumn.TotalPayment: // 総支払額
|
|
| 434 | 434 |
strcmd += string.Format(" TotalPayment = {0}", ((int)value).ToString());
|
| 435 | 435 |
break; |
| 436 |
case (int)DataColumn.GrossProfit: // 粗利
|
|
| 436 |
case (int)TableColumn.GrossProfit: // 粗利
|
|
| 437 | 437 |
strcmd += string.Format(" GrossProfit = {0}", ((int)value).ToString());
|
| 438 | 438 |
break; |
| 439 |
case (int)DataColumn.Allowance: // 給与
|
|
| 439 |
case (int)TableColumn.Allowance: // 給与
|
|
| 440 | 440 |
strcmd += string.Format(" Allowance = {0}", ((int)value).ToString());
|
| 441 | 441 |
break; |
| 442 |
case (int)DataColumn.NetProfit: // 純利益
|
|
| 442 |
case (int)TableColumn.NetProfit: // 純利益
|
|
| 443 | 443 |
strcmd += string.Format(" NetProfit = {0}", ((int)value).ToString());
|
| 444 | 444 |
break; |
| 445 |
case (int)DataColumn.ComplateFlg: // 入力完了フラグ
|
|
| 445 |
case (int)TableColumn.ComplateFlg: // 入力完了フラグ
|
|
| 446 | 446 |
strcmd += string.Format(" ComplateFlg = {0}", ((int)value).ToString());
|
| 447 | 447 |
break; |
| 448 |
case (int)DataColumn.IntegrationFlg: // 受注金額積算フラグ
|
|
| 448 |
case (int)TableColumn.IntegrationFlg: // 受注金額積算フラグ
|
|
| 449 | 449 |
strcmd += string.Format(" IntegrationFlg = {0}", ((int)value).ToString());
|
| 450 | 450 |
break; |
| 451 | 451 |
default: |
| ... | ... | |
| 479 | 479 |
{
|
| 480 | 480 |
// データ取得 |
| 481 | 481 |
|
| 482 |
wrk.ConstructionCode = int.Parse(objwrk[(int)DataColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 482 |
wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 483 | 483 |
|
| 484 |
wrk.ConstructionPeriod = int.Parse(objwrk[(int)DataColumn.ConstructionPeriod].ToString()); // 事業期
|
|
| 485 |
wrk.CreatorCode = int.Parse(objwrk[(int)DataColumn.CreatorCode].ToString()); // 作成者コード
|
|
| 486 |
wrk.CreatorName = objwrk[(int)DataColumn.CreatorName].ToString(); // 作成者名
|
|
| 487 |
wrk.CreateDate = DateTime.Parse(objwrk[(int)DataColumn.CreateDate].ToString()); // 作成日
|
|
| 488 |
wrk.ConstructionTimes = double.Parse(objwrk[(int)DataColumn.ConstructionTimes].ToString()); // 工期（単位・月）
|
|
| 489 |
wrk.ConstructionStart = DateTime.Parse(objwrk[(int)DataColumn.ConstructionStart].ToString()); // 契約工期開始
|
|
| 490 |
wrk.ConstructionEnd = DateTime.Parse(objwrk[(int)DataColumn.ConstructionEnd].ToString()); // 契約工期完了
|
|
| 484 |
wrk.ConstructionPeriod = int.Parse(objwrk[(int)TableColumn.ConstructionPeriod].ToString()); // 事業期
|
|
| 485 |
wrk.CreatorCode = int.Parse(objwrk[(int)TableColumn.CreatorCode].ToString()); // 作成者コード
|
|
| 486 |
wrk.CreatorName = objwrk[(int)TableColumn.CreatorName].ToString(); // 作成者名
|
|
| 487 |
wrk.CreateDate = DateTime.Parse(objwrk[(int)TableColumn.CreateDate].ToString()); // 作成日
|
|
| 488 |
wrk.ConstructionTimes = double.Parse(objwrk[(int)TableColumn.ConstructionTimes].ToString()); // 工期（単位・月）
|
|
| 489 |
wrk.ConstructionStart = DateTime.Parse(objwrk[(int)TableColumn.ConstructionStart].ToString()); // 契約工期開始
|
|
| 490 |
wrk.ConstructionEnd = DateTime.Parse(objwrk[(int)TableColumn.ConstructionEnd].ToString()); // 契約工期完了
|
|
| 491 | 491 |
|
| 492 |
wrk.OrdersDecisionPrice = double.Parse(objwrk[(int)DataColumn.OrdersDecisionPrice].ToString()); // 税抜受注決定金額
|
|
| 493 |
wrk.CompanyExpenses = double.Parse(objwrk[(int)DataColumn.CompanyExpenses].ToString()); // 会社経費合計
|
|
| 494 |
wrk.DepartmentExpenses = double.Parse(objwrk[(int)DataColumn.DepartmentExpenses].ToString()); // 部署経費合計
|
|
| 495 |
wrk.SalesExpenses = double.Parse(objwrk[(int)DataColumn.SalesExpenses].ToString()); // 営業経費合計
|
|
| 496 |
wrk.TotalPayment = double.Parse(objwrk[(int)DataColumn.TotalPayment].ToString()); // 総支払額
|
|
| 497 |
wrk.GrossProfit = double.Parse(objwrk[(int)DataColumn.GrossProfit].ToString()); // 粗利
|
|
| 498 |
wrk.Allowance = double.Parse(objwrk[(int)DataColumn.Allowance].ToString()); // 給与
|
|
| 499 |
wrk.NetProfit = double.Parse(objwrk[(int)DataColumn.NetProfit].ToString()); // 純利益
|
|
| 500 |
wrk.ComplateFlg = double.Parse(objwrk[(int)DataColumn.ComplateFlg].ToString()); // 入力完了フラグ
|
|
| 501 |
wrk.IntegrationFlg = int.Parse(objwrk[(int)DataColumn.IntegrationFlg].ToString()); // 受注金額積算フラグ
|
|
| 492 |
wrk.OrdersDecisionPrice = double.Parse(objwrk[(int)TableColumn.OrdersDecisionPrice].ToString()); // 税抜受注決定金額
|
|
| 493 |
wrk.CompanyExpenses = double.Parse(objwrk[(int)TableColumn.CompanyExpenses].ToString()); // 会社経費合計
|
|
| 494 |
wrk.DepartmentExpenses = double.Parse(objwrk[(int)TableColumn.DepartmentExpenses].ToString()); // 部署経費合計
|
|
| 495 |
wrk.SalesExpenses = double.Parse(objwrk[(int)TableColumn.SalesExpenses].ToString()); // 営業経費合計
|
|
| 496 |
wrk.TotalPayment = double.Parse(objwrk[(int)TableColumn.TotalPayment].ToString()); // 総支払額
|
|
| 497 |
wrk.GrossProfit = double.Parse(objwrk[(int)TableColumn.GrossProfit].ToString()); // 粗利
|
|
| 498 |
wrk.Allowance = double.Parse(objwrk[(int)TableColumn.Allowance].ToString()); // 給与
|
|
| 499 |
wrk.NetProfit = double.Parse(objwrk[(int)TableColumn.NetProfit].ToString()); // 純利益
|
|
| 500 |
wrk.ComplateFlg = double.Parse(objwrk[(int)TableColumn.ComplateFlg].ToString()); // 入力完了フラグ
|
|
| 501 |
wrk.IntegrationFlg = int.Parse(objwrk[(int)TableColumn.IntegrationFlg].ToString()); // 受注金額積算フラグ
|
|
| 502 | 502 |
|
| 503 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)DataColumn.EntryDate].ToString());
|
|
| 504 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)DataColumn.UpdateDate].ToString());
|
|
| 503 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
|
|
| 504 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());
|
|
| 505 | 505 |
} |
| 506 | 506 |
catch (OracleException oraex) |
| 507 | 507 |
{
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOConstructionLedgerDetail.cs | ||
|---|---|---|
| 31 | 31 |
/// <summary> |
| 32 | 32 |
/// 工事詳細台帳データ明細フィールド並び |
| 33 | 33 |
/// </summary> |
| 34 |
public enum DataColumn
|
|
| 34 |
public enum TableColumn
|
|
| 35 | 35 |
{
|
| 36 | 36 |
ConstructionCode = 0, // 工事番号 |
| 37 | 37 |
|
| ... | ... | |
| 400 | 400 |
try |
| 401 | 401 |
{
|
| 402 | 402 |
// データ取得 |
| 403 |
wrk.ConstructionCode = int.Parse(objwrk[(int)DataColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 403 |
wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 404 | 404 |
|
| 405 |
wrk.GroupCount = int.Parse(objwrk[(int)DataColumn.GroupCount].ToString()); // グループ番号
|
|
| 406 |
wrk.LineCount = int.Parse(objwrk[(int)DataColumn.LineCount].ToString()); // 行番号
|
|
| 407 |
wrk.ComponentCode = int.Parse(objwrk[(int)DataColumn.ComponentCode].ToString()); // 構成キー
|
|
| 408 |
wrk.ItemCode = int.Parse(objwrk[(int)DataColumn.ItemCode].ToString()); // 工種キー
|
|
| 409 |
wrk.FirstString = objwrk[(int)DataColumn.FirstString].ToString(); // 項目名称
|
|
| 410 |
wrk.SecondString = objwrk[(int)DataColumn.SecondString].ToString(); // 工事内容
|
|
| 411 |
wrk.CompanyType = int.Parse(objwrk[(int)DataColumn.CompanyType].ToString()); // 協力会社コードタイプ
|
|
| 412 |
wrk.CompanyCode = int.Parse(objwrk[(int)DataColumn.CompanyCode].ToString()); // 協力会社コード
|
|
| 413 |
wrk.CompanyName = objwrk[(int)DataColumn.CompanyName].ToString(); // 協力会社名称
|
|
| 414 |
wrk.EstimatePrice = double.Parse(objwrk[(int)DataColumn.EstimatePrice].ToString()); // 予算（見積）金額
|
|
| 415 |
wrk.ExecutionAmount = double.Parse(objwrk[(int)DataColumn.ExecutionAmount].ToString()); // 実行金額
|
|
| 416 |
wrk.AmountConfigRate = double.Parse(objwrk[(int)DataColumn.AmountConfigRate].ToString()); // 金額構成率
|
|
| 417 |
wrk.PaymentBurden = double.Parse(objwrk[(int)DataColumn.PaymentBurden].ToString()); // 支払補填額
|
|
| 405 |
wrk.GroupCount = int.Parse(objwrk[(int)TableColumn.GroupCount].ToString()); // グループ番号
|
|
| 406 |
wrk.LineCount = int.Parse(objwrk[(int)TableColumn.LineCount].ToString()); // 行番号
|
|
| 407 |
wrk.ComponentCode = int.Parse(objwrk[(int)TableColumn.ComponentCode].ToString()); // 構成キー
|
|
| 408 |
wrk.ItemCode = int.Parse(objwrk[(int)TableColumn.ItemCode].ToString()); // 工種キー
|
|
| 409 |
wrk.FirstString = objwrk[(int)TableColumn.FirstString].ToString(); // 項目名称
|
|
| 410 |
wrk.SecondString = objwrk[(int)TableColumn.SecondString].ToString(); // 工事内容
|
|
| 411 |
wrk.CompanyType = int.Parse(objwrk[(int)TableColumn.CompanyType].ToString()); // 協力会社コードタイプ
|
|
| 412 |
wrk.CompanyCode = int.Parse(objwrk[(int)TableColumn.CompanyCode].ToString()); // 協力会社コード
|
|
| 413 |
wrk.CompanyName = objwrk[(int)TableColumn.CompanyName].ToString(); // 協力会社名称
|
|
| 414 |
wrk.EstimatePrice = double.Parse(objwrk[(int)TableColumn.EstimatePrice].ToString()); // 予算（見積）金額
|
|
| 415 |
wrk.ExecutionAmount = double.Parse(objwrk[(int)TableColumn.ExecutionAmount].ToString()); // 実行金額
|
|
| 416 |
wrk.AmountConfigRate = double.Parse(objwrk[(int)TableColumn.AmountConfigRate].ToString()); // 金額構成率
|
|
| 417 |
wrk.PaymentBurden = double.Parse(objwrk[(int)TableColumn.PaymentBurden].ToString()); // 支払補填額
|
|
| 418 | 418 |
|
| 419 |
wrk.FixDataFlg = int.Parse(objwrk[(int)DataColumn.FixDataFlg].ToString()); // 固定データフラグ
|
|
| 420 |
wrk.IndependentFlg = int.Parse(objwrk[(int)DataColumn.IndependentFlg].ToString()); // 独立データフラグ
|
|
| 421 |
wrk.FluctuationFlg = int.Parse(objwrk[(int)DataColumn.FluctuationFlg].ToString()); // 増減データフラグ
|
|
| 419 |
wrk.FixDataFlg = int.Parse(objwrk[(int)TableColumn.FixDataFlg].ToString()); // 固定データフラグ
|
|
| 420 |
wrk.IndependentFlg = int.Parse(objwrk[(int)TableColumn.IndependentFlg].ToString()); // 独立データフラグ
|
|
| 421 |
wrk.FluctuationFlg = int.Parse(objwrk[(int)TableColumn.FluctuationFlg].ToString()); // 増減データフラグ
|
|
| 422 | 422 |
|
| 423 |
wrk.SalaryFlg = int.Parse(objwrk[(int)DataColumn.SalaryFlg].ToString()); // 給与振分区分
|
|
| 424 |
wrk.SalaryDays = int.Parse(objwrk[(int)DataColumn.SalaryDays].ToString()); // 給与振分日数
|
|
| 425 |
wrk.OperatingFlg = int.Parse(objwrk[(int)DataColumn.OperatingFlg].ToString()); // 担当中フラグ
|
|
| 426 |
wrk.SourceCode = int.Parse(objwrk[(int)DataColumn.SourceCode].ToString()); // 元工事番号
|
|
| 427 |
wrk.JoinTitleFlg = int.Parse(objwrk[(int)DataColumn.JoinTitleFlg].ToString()); // 工事名称タイトルフラグ
|
|
| 428 |
wrk.SalaryOnRegist = double.Parse(objwrk[(int)DataColumn.SalaryOnRegist].ToString()); // 登録時月額給与
|
|
| 429 |
wrk.PurchaseOrderFlg = int.Parse(objwrk[(int)DataColumn.PurchaseOrderFlg].ToString()); // 注文書発行フラグ
|
|
| 423 |
wrk.SalaryFlg = int.Parse(objwrk[(int)TableColumn.SalaryFlg].ToString()); // 給与振分区分
|
|
| 424 |
wrk.SalaryDays = int.Parse(objwrk[(int)TableColumn.SalaryDays].ToString()); // 給与振分日数
|
|
| 425 |
wrk.OperatingFlg = int.Parse(objwrk[(int)TableColumn.OperatingFlg].ToString()); // 担当中フラグ
|
|
| 426 |
wrk.SourceCode = int.Parse(objwrk[(int)TableColumn.SourceCode].ToString()); // 元工事番号
|
|
| 427 |
wrk.JoinTitleFlg = int.Parse(objwrk[(int)TableColumn.JoinTitleFlg].ToString()); // 工事名称タイトルフラグ
|
|
| 428 |
wrk.SalaryOnRegist = double.Parse(objwrk[(int)TableColumn.SalaryOnRegist].ToString()); // 登録時月額給与
|
|
| 429 |
wrk.PurchaseOrderFlg = int.Parse(objwrk[(int)TableColumn.PurchaseOrderFlg].ToString()); // 注文書発行フラグ
|
|
| 430 | 430 |
|
| 431 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)DataColumn.EntryDate].ToString());
|
|
| 432 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)DataColumn.UpdateDate].ToString());
|
|
| 431 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
|
|
| 432 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());
|
|
| 433 | 433 |
} |
| 434 | 434 |
catch (OracleException oraex) |
| 435 | 435 |
{
|
| ... | ... | |
| 514 | 514 |
{
|
| 515 | 515 |
switch (FeildNo) |
| 516 | 516 |
{
|
| 517 |
case (int)DataColumn.ConstructionCode: // 工事番号
|
|
| 517 |
case (int)TableColumn.ConstructionCode: // 工事番号
|
|
| 518 | 518 |
strcmd += string.Format(" ConstructionCode = {0}", ((int)value).ToString());
|
| 519 | 519 |
break; |
| 520 |
case (int)DataColumn.GroupCount: // グループ番号
|
|
| 520 |
case (int)TableColumn.GroupCount: // グループ番号
|
|
| 521 | 521 |
strcmd += string.Format(" GroupCount = {0}", ((int)value).ToString());
|
| 522 | 522 |
break; |
| 523 |
case (int)DataColumn.LineCount: // 行番号
|
|
| 523 |
case (int)TableColumn.LineCount: // 行番号
|
|
| 524 | 524 |
strcmd += string.Format(" LineCount = {0}", ((int)value).ToString());
|
| 525 | 525 |
break; |
| 526 |
case (int)DataColumn.ComponentCode: // 構成キー
|
|
| 526 |
case (int)TableColumn.ComponentCode: // 構成キー
|
|
| 527 | 527 |
strcmd += string.Format(" ComponentCode = {0}", ((int)value).ToString());
|
| 528 | 528 |
break; |
| 529 |
case (int)DataColumn.ItemCode: // 工種キー
|
|
| 529 |
case (int)TableColumn.ItemCode: // 工種キー
|
|
| 530 | 530 |
strcmd += string.Format(" ItemCode = {0}", ((int)value).ToString());
|
| 531 | 531 |
break; |
| 532 |
case (int)DataColumn.FirstString: // 項目名称
|
|
| 532 |
case (int)TableColumn.FirstString: // 項目名称
|
|
| 533 | 533 |
strcmd += string.Format(" FirstString = '{0}'", value.ToString());
|
| 534 | 534 |
break; |
| 535 |
case (int)DataColumn.SecondString: // 工事内容
|
|
| 535 |
case (int)TableColumn.SecondString: // 工事内容
|
|
| 536 | 536 |
strcmd += string.Format(" SecondString = '{0}'", value.ToString());
|
| 537 | 537 |
break; |
| 538 |
case (int)DataColumn.CompanyType: // 協力会社コードタイプ
|
|
| 538 |
case (int)TableColumn.CompanyType: // 協力会社コードタイプ
|
|
| 539 | 539 |
strcmd += string.Format(" CompanyType = {0}", ((int)value).ToString());
|
| 540 | 540 |
break; |
| 541 |
case (int)DataColumn.CompanyCode: // 協力会社コード
|
|
| 541 |
case (int)TableColumn.CompanyCode: // 協力会社コード
|
|
| 542 | 542 |
strcmd += string.Format(" CompanyCode = {0}", ((int)value).ToString());
|
| 543 | 543 |
break; |
| 544 |
case (int)DataColumn.CompanyName: // 協力会社名称
|
|
| 544 |
case (int)TableColumn.CompanyName: // 協力会社名称
|
|
| 545 | 545 |
strcmd += string.Format(" CompanyName = '{0}'", value.ToString());
|
| 546 | 546 |
break; |
| 547 |
case (int)DataColumn.EstimatePrice: // 予算（見積）金額
|
|
| 547 |
case (int)TableColumn.EstimatePrice: // 予算（見積）金額
|
|
| 548 | 548 |
strcmd += string.Format(" EstimatePrice = {0}", ((int)value).ToString());
|
| 549 | 549 |
break; |
| 550 |
case (int)DataColumn.ExecutionAmount: // 実行金額
|
|
| 550 |
case (int)TableColumn.ExecutionAmount: // 実行金額
|
|
| 551 | 551 |
strcmd += string.Format(" ExecutionAmount = {0}", ((int)value).ToString());
|
| 552 | 552 |
break; |
| 553 |
case (int)DataColumn.AmountConfigRate: // 金額構成率
|
|
| 553 |
case (int)TableColumn.AmountConfigRate: // 金額構成率
|
|
| 554 | 554 |
strcmd += string.Format(" AmountConfigRate = {0}", ((double)value).ToString());
|
| 555 | 555 |
break; |
| 556 |
case (int)DataColumn.PaymentBurden: // 支払補填額
|
|
| 556 |
case (int)TableColumn.PaymentBurden: // 支払補填額
|
|
| 557 | 557 |
strcmd += string.Format(" PaymentBurden = {0}", ((int)value).ToString());
|
| 558 | 558 |
break; |
| 559 |
case (int)DataColumn.FixDataFlg: // 固定データフラグ
|
|
| 559 |
case (int)TableColumn.FixDataFlg: // 固定データフラグ
|
|
| 560 | 560 |
strcmd += string.Format(" FixDataFlg = {0}", ((int)value).ToString());
|
| 561 | 561 |
break; |
| 562 |
case (int)DataColumn.IndependentFlg: // 独立データフラグ
|
|
| 562 |
case (int)TableColumn.IndependentFlg: // 独立データフラグ
|
|
| 563 | 563 |
strcmd += string.Format(" IndependentFlg = {0}", ((int)value).ToString());
|
| 564 | 564 |
break; |
| 565 |
case (int)DataColumn.FluctuationFlg: // 増減データフラグ
|
|
| 565 |
case (int)TableColumn.FluctuationFlg: // 増減データフラグ
|
|
| 566 | 566 |
strcmd += string.Format(" FluctuationFlg = {0}", ((int)value).ToString());
|
| 567 | 567 |
break; |
| 568 |
case (int)DataColumn.SalaryFlg: // 給与振分区分
|
|
| 568 |
case (int)TableColumn.SalaryFlg: // 給与振分区分
|
|
| 569 | 569 |
strcmd += string.Format(" SalaryFlg = {0}", ((int)value).ToString());
|
| 570 | 570 |
break; |
| 571 |
case (int)DataColumn.SalaryDays: // 給与振分日数
|
|
| 571 |
case (int)TableColumn.SalaryDays: // 給与振分日数
|
|
| 572 | 572 |
strcmd += string.Format(" SalaryDays = {0}", ((int)value).ToString());
|
| 573 | 573 |
break; |
| 574 |
case (int)DataColumn.OperatingFlg: // 担当中フラグ
|
|
| 574 |
case (int)TableColumn.OperatingFlg: // 担当中フラグ
|
|
| 575 | 575 |
strcmd += string.Format(" OperatingFlg = {0}", ((int)value).ToString());
|
| 576 | 576 |
break; |
| 577 |
case (int)DataColumn.SourceCode: // 元工事番号
|
|
| 577 |
case (int)TableColumn.SourceCode: // 元工事番号
|
|
| 578 | 578 |
strcmd += string.Format(" SourceCode = {0}", ((int)value).ToString());
|
| 579 | 579 |
break; |
| 580 |
case (int)DataColumn.JoinTitleFlg: // 工事名称タイトルフラグ
|
|
| 580 |
case (int)TableColumn.JoinTitleFlg: // 工事名称タイトルフラグ
|
|
| 581 | 581 |
strcmd += string.Format(" JoinTitleFlg = {0}", ((int)value).ToString());
|
| 582 | 582 |
break; |
| 583 |
case (int)DataColumn.SalaryOnRegist: // 登録時月額給与
|
|
| 583 |
case (int)TableColumn.SalaryOnRegist: // 登録時月額給与
|
|
| 584 | 584 |
strcmd += string.Format(" SalaryOnRegist = {0}", ((double)value).ToString());
|
| 585 | 585 |
break; |
| 586 |
case (int)DataColumn.PurchaseOrderFlg: // 注文書発行フラグ
|
|
| 586 |
case (int)TableColumn.PurchaseOrderFlg: // 注文書発行フラグ
|
|
| 587 | 587 |
strcmd += string.Format(" PurchaseOrderFlg = {0}", ((int)value).ToString());
|
| 588 | 588 |
break; |
| 589 | 589 |
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IOCostomerRegist.cs | ||
|---|---|---|
| 32 | 32 |
/// <summary> |
| 33 | 33 |
/// 発注者登録申請データフィールド並び |
| 34 | 34 |
/// </summary> |
| 35 |
public enum DataColumn
|
|
| 35 |
public enum TableColumn
|
|
| 36 | 36 |
{
|
| 37 | 37 |
PersonCode = 0, |
| 38 | 38 |
CreateDate, |
| 39 | 39 |
SeqNo, |
| 40 |
DataMode, |
|
| 41 |
SourceCotegory, |
|
| 42 |
SourceCode, |
|
| 40 | 43 |
PetitionPeriod, |
| 41 | 44 |
OrderFlg, |
| 42 | 45 |
CorporateStatusName, |
| ... | ... | |
| 87 | 90 |
strcmd += " ,TO_CHAR(CreateDate, 'YYYY/MM/DD')"; |
| 88 | 91 |
strcmd += " ,SeqNo"; |
| 89 | 92 |
|
| 93 |
strcmd += " ,DataMode"; |
|
| 94 |
strcmd += " ,SourceCotegory"; |
|
| 95 |
strcmd += " ,SourceCode"; |
|
| 90 | 96 |
strcmd += " ,PetitionPeriod"; |
| 91 | 97 |
strcmd += " ,OrderFlg"; |
| 92 | 98 |
strcmd += " ,CorporateStatusName"; |
| ... | ... | |
| 210 | 216 |
strcmd += " (";
|
| 211 | 217 |
|
| 212 | 218 |
bool bFirst = true; |
| 213 |
foreach (var gender in Enum.GetValues(typeof(DataColumn)))
|
|
| 219 |
foreach (var gender in Enum.GetValues(typeof(TableColumn)))
|
|
| 214 | 220 |
{
|
| 215 | 221 |
if (!bFirst) strcmd += " ,"; |
| 216 | 222 |
strcmd += gender.ToString(); |
| ... | ... | |
| 222 | 228 |
strcmd += string.Format(" {0}", work.PersonCode);
|
| 223 | 229 |
strcmd += string.Format(", TO_DATE('{0}','YYYY/MM/DD')", work.CreateDate.ToShortDateString());
|
| 224 | 230 |
strcmd += string.Format(", {0}", work.SeqNo);
|
| 231 |
strcmd += string.Format(", {0}", work.DataMode);
|
|
| 232 |
strcmd += string.Format(", {0}", work.SourceCotegory);
|
|
| 233 |
strcmd += string.Format(", {0}", work.SourceCode);
|
|
| 225 | 234 |
strcmd += string.Format(", {0}", work.PetitionPeriod);
|
| 226 | 235 |
strcmd += string.Format(", {0}", work.OrderFlg);
|
| 227 | 236 |
strcmd += string.Format(", '{0}'", work.CorporateStatusName);
|
| ... | ... | |
| 303 | 312 |
strcmd += string.Format(" PersonCode = {0}", data.PersonCode);
|
| 304 | 313 |
strcmd += string.Format(", CreateDate = TO_DATE('{0}','YYYY/MM/DD')", data.CreateDate.ToShortDateString());
|
| 305 | 314 |
strcmd += string.Format(", SeqNo = {0}", data.SeqNo);
|
| 315 |
strcmd += string.Format(", DataMode = {0}", data.DataMode);
|
|
| 316 |
strcmd += string.Format(", SourceCotegory = {0}", data.SourceCotegory);
|
|
| 317 |
strcmd += string.Format(", SourceCode = {0}", data.SourceCode);
|
|
| 306 | 318 |
strcmd += string.Format(", PetitionPeriod = {0}", data.PetitionPeriod);
|
| 307 | 319 |
strcmd += string.Format(", OrderFlg = {0}", data.OrderFlg);
|
| 308 | 320 |
strcmd += string.Format(", CorporateStatusName = '{0}'", data.CorporateStatusName);
|
| ... | ... | |
| 380 | 392 |
strcmd += " SET"; |
| 381 | 393 |
switch (FeildNo) |
| 382 | 394 |
{
|
| 383 |
case (int)DataColumn.PersonCode:
|
|
| 395 |
case (int)TableColumn.PersonCode:
|
|
| 384 | 396 |
strcmd += string.Format(" PersonCode = {0}", ((int)value).ToString());
|
| 385 | 397 |
break; |
| 386 |
case (int)DataColumn.CreateDate:
|
|
| 398 |
case (int)TableColumn.CreateDate:
|
|
| 387 | 399 |
strcmd += string.Format(" CreateDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());
|
| 388 | 400 |
break; |
| 389 |
case (int)DataColumn.SeqNo:
|
|
| 401 |
case (int)TableColumn.SeqNo:
|
|
| 390 | 402 |
strcmd += string.Format(" SeqNo = {0}", ((int)value).ToString());
|
| 391 | 403 |
break; |
| 392 |
case (int)DataColumn.PetitionPeriod: |
|
| 404 |
case (int)TableColumn.DataMode: |
|
| 405 |
strcmd += string.Format(" DataMode = {0}", ((int)value).ToString());
|
|
| 406 |
break; |
|
| 407 |
case (int)TableColumn.SourceCotegory: |
|
| 408 |
strcmd += string.Format(" SourceCotegory = {0}", ((int)value).ToString());
|
|
| 409 |
break; |
|
| 410 |
case (int)TableColumn.SourceCode: |
|
| 411 |
strcmd += string.Format(" SourceCode = {0}", ((int)value).ToString());
|
|
| 412 |
break; |
|
| 413 |
case (int)TableColumn.PetitionPeriod: |
|
| 393 | 414 |
strcmd += string.Format(" PetitionPeriod = {0}", ((int)value).ToString());
|
| 394 | 415 |
break; |
| 395 |
case (int)DataColumn.OrderFlg:
|
|
| 416 |
case (int)TableColumn.OrderFlg:
|
|
| 396 | 417 |
strcmd += string.Format(" OrderFlg = {0}", ((int)value).ToString());
|
| 397 | 418 |
break; |
| 398 |
case (int)DataColumn.CorporateStatusName:
|
|
| 419 |
case (int)TableColumn.CorporateStatusName:
|
|
| 399 | 420 |
strcmd += string.Format(" CorporateStatusName = '{0}'", value.ToString());
|
| 400 | 421 |
break; |
| 401 |
case (int)DataColumn.CorporateStatusPoint:
|
|
| 422 |
case (int)TableColumn.CorporateStatusPoint:
|
|
| 402 | 423 |
strcmd += string.Format(" CorporateStatusPoint = '{0}'", value.ToString());
|
| 403 | 424 |
break; |
| 404 |
case (int)DataColumn.OrderersName1:
|
|
| 425 |
case (int)TableColumn.OrderersName1:
|
|
| 405 | 426 |
strcmd += string.Format(" OrderersName1 = '{0}'", value.ToString());
|
| 406 | 427 |
break; |
| 407 |
case (int)DataColumn.OrderersName2:
|
|
| 428 |
case (int)TableColumn.OrderersName2:
|
|
| 408 | 429 |
strcmd += string.Format(" OrderersName2 = '{0}'", value.ToString());
|
| 409 | 430 |
break; |
| 410 |
case (int)DataColumn.DepartmentName:
|
|
| 431 |
case (int)TableColumn.DepartmentName:
|
|
| 411 | 432 |
strcmd += string.Format(" DepartmentName = '{0}'", value.ToString());
|
| 412 | 433 |
break; |
| 413 |
case (int)DataColumn.ChargePersonName:
|
|
| 434 |
case (int)TableColumn.ChargePersonName:
|
|
| 414 | 435 |
strcmd += string.Format(" ChargePersonName = '{0}'", value.ToString());
|
| 415 | 436 |
break; |
| 416 |
case (int)DataColumn.ZipCode:
|
|
| 437 |
case (int)TableColumn.ZipCode:
|
|
| 417 | 438 |
strcmd += string.Format(" ZipCode = '{0}'", value.ToString());
|
| 418 | 439 |
break; |
| 419 |
case (int)DataColumn.Address1:
|
|
| 440 |
case (int)TableColumn.Address1:
|
|
| 420 | 441 |
strcmd += string.Format(" Address1 = '{0}'", value.ToString());
|
| 421 | 442 |
break; |
| 422 |
case (int)DataColumn.Address2:
|
|
| 443 |
case (int)TableColumn.Address2:
|
|
| 423 | 444 |
strcmd += string.Format(" Address2 = '{0}'", value.ToString());
|
| 424 | 445 |
break; |
| 425 |
case (int)DataColumn.Address3:
|
|
| 446 |
case (int)TableColumn.Address3:
|
|
| 426 | 447 |
strcmd += string.Format(" Address3 = '{0}'", value.ToString());
|
| 427 | 448 |
break; |
| 428 |
case (int)DataColumn.PhoneNumber:
|
|
| 449 |
case (int)TableColumn.PhoneNumber:
|
|
| 429 | 450 |
strcmd += string.Format(" PhoneNumber = '{0}'", value.ToString());
|
| 430 | 451 |
break; |
| 431 |
case (int)DataColumn.FaxNumber:
|
|
| 452 |
case (int)TableColumn.FaxNumber:
|
|
| 432 | 453 |
strcmd += string.Format(" FaxNumber = '{0}'", value.ToString());
|
| 433 | 454 |
break; |
| 434 |
case (int)DataColumn.MailAddress:
|
|
| 455 |
case (int)TableColumn.MailAddress:
|
|
| 435 | 456 |
strcmd += string.Format(" MailAddress = '{0}'", value.ToString());
|
| 436 | 457 |
break; |
| 437 |
case (int)DataColumn.Note:
|
|
| 458 |
case (int)TableColumn.Note:
|
|
| 438 | 459 |
strcmd += string.Format(" Note = '{0}'", value.ToString());
|
| 439 | 460 |
break; |
| 440 |
case (int)DataColumn.OrderCotegory:
|
|
| 461 |
case (int)TableColumn.OrderCotegory:
|
|
| 441 | 462 |
strcmd += string.Format(" OrderCotegory = {0}", ((int)value).ToString());
|
| 442 | 463 |
break; |
| 443 |
case (int)DataColumn.OrderDate:
|
|
| 464 |
case (int)TableColumn.OrderDate:
|
|
| 444 | 465 |
strcmd += string.Format(" OrderDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());
|
| 445 | 466 |
break; |
| 446 |
case (int)DataColumn.OrderNo:
|
|
| 467 |
case (int)TableColumn.OrderNo:
|
|
| 447 | 468 |
strcmd += string.Format(" OrderNo = {0}", ((int)value).ToString());
|
| 448 | 469 |
break; |
| 449 | 470 |
} |
| ... | ... | |
| 474 | 495 |
try |
| 475 | 496 |
{
|
| 476 | 497 |
// データ取得 |
| 477 |
wrk.PersonCode = int.Parse(objwrk[(int)DataColumn.PersonCode].ToString()); |
|
| 478 |
wrk.CreateDate = DateTime.Parse(objwrk[(int)DataColumn.CreateDate].ToString()); |
|
| 479 |
wrk.SeqNo = int.Parse(objwrk[(int)DataColumn.SeqNo].ToString()); |
|
| 480 |
wrk.PetitionPeriod = int.Parse(objwrk[(int)DataColumn.PetitionPeriod].ToString()); |
|
| 481 |
wrk.OrderFlg = int.Parse(objwrk[(int)DataColumn.OrderFlg].ToString()); |
|
| 482 |
wrk.CorporateStatusName = objwrk[(int)DataColumn.CorporateStatusName].ToString(); |
|
| 483 |
wrk.CorporateStatusPoint = int.Parse(objwrk[(int)DataColumn.CorporateStatusPoint].ToString()); |
|
| 498 |
wrk.PersonCode = int.Parse(objwrk[(int)TableColumn.PersonCode].ToString()); |
|
| 499 |
wrk.CreateDate = DateTime.Parse(objwrk[(int)TableColumn.CreateDate].ToString()); |
|
| 500 |
wrk.SeqNo = int.Parse(objwrk[(int)TableColumn.SeqNo].ToString()); |
|
| 484 | 501 |
|
| 485 |
wrk.OrderersName1 = objwrk[(int)DataColumn.OrderersName1].ToString(); |
|
| 486 |
wrk.OrderersName2 = objwrk[(int)DataColumn.OrderersName2].ToString(); |
|
| 487 |
wrk.DepartmentName = objwrk[(int)DataColumn.DepartmentName].ToString(); |
|
| 488 |
wrk.ChargePersonName = objwrk[(int)DataColumn.ChargePersonName].ToString(); |
|
| 489 |
wrk.ZipCode = objwrk[(int)DataColumn.ZipCode].ToString(); |
|
| 490 |
wrk.Address1 = objwrk[(int)DataColumn.Address1].ToString(); |
|
| 491 |
wrk.Address2 = objwrk[(int)DataColumn.Address2].ToString(); |
|
| 492 |
wrk.Address3 = objwrk[(int)DataColumn.Address3].ToString(); |
|
| 493 |
wrk.PhoneNumber = objwrk[(int)DataColumn.PhoneNumber].ToString(); |
|
| 494 |
wrk.FaxNumber = objwrk[(int)DataColumn.FaxNumber].ToString(); |
|
| 495 |
wrk.MailAddress = objwrk[(int)DataColumn.MailAddress].ToString(); |
|
| 496 |
wrk.Note = objwrk[(int)DataColumn.Note].ToString(); |
|
| 497 |
wrk.OrderCotegory = int.Parse(objwrk[(int)DataColumn.OrderCotegory].ToString()); |
|
| 498 |
wrk.OrderDate = DateTime.Parse(objwrk[(int)DataColumn.OrderDate].ToString()); |
|
| 499 |
wrk.OrderNo = int.Parse(objwrk[(int)DataColumn.OrderNo].ToString()); |
|
| 502 |
wrk.DataMode = int.Parse(objwrk[(int)TableColumn.DataMode].ToString()); |
|
| 503 |
wrk.SourceCotegory = int.Parse(objwrk[(int)TableColumn.SourceCotegory].ToString()); |
|
| 504 |
wrk.SourceCode = int.Parse(objwrk[(int)TableColumn.SourceCode].ToString()); |
|
| 505 |
wrk.PetitionPeriod = int.Parse(objwrk[(int)TableColumn.PetitionPeriod].ToString()); |
|
| 506 |
wrk.OrderFlg = int.Parse(objwrk[(int)TableColumn.OrderFlg].ToString()); |
|
| 507 |
wrk.CorporateStatusName = objwrk[(int)TableColumn.CorporateStatusName].ToString(); |
|
| 508 |
wrk.CorporateStatusPoint = int.Parse(objwrk[(int)TableColumn.CorporateStatusPoint].ToString()); |
|
| 500 | 509 |
|
| 501 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)DataColumn.EntryDate].ToString()); |
|
| 502 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)DataColumn.UpdateDate].ToString()); |
|
| 510 |
wrk.OrderersName1 = objwrk[(int)TableColumn.OrderersName1].ToString(); |
|
| 511 |
wrk.OrderersName2 = objwrk[(int)TableColumn.OrderersName2].ToString(); |
|
| 512 |
wrk.DepartmentName = objwrk[(int)TableColumn.DepartmentName].ToString(); |
|
| 513 |
wrk.ChargePersonName = objwrk[(int)TableColumn.ChargePersonName].ToString(); |
|
| 514 |
wrk.ZipCode = objwrk[(int)TableColumn.ZipCode].ToString(); |
|
| 515 |
wrk.Address1 = objwrk[(int)TableColumn.Address1].ToString(); |
|
| 516 |
wrk.Address2 = objwrk[(int)TableColumn.Address2].ToString(); |
|
| 517 |
wrk.Address3 = objwrk[(int)TableColumn.Address3].ToString(); |
|
| 518 |
wrk.PhoneNumber = objwrk[(int)TableColumn.PhoneNumber].ToString(); |
|
| 519 |
wrk.FaxNumber = objwrk[(int)TableColumn.FaxNumber].ToString(); |
|
| 520 |
wrk.MailAddress = objwrk[(int)TableColumn.MailAddress].ToString(); |
|
| 521 |
wrk.Note = objwrk[(int)TableColumn.Note].ToString(); |
|
| 522 |
wrk.OrderCotegory = int.Parse(objwrk[(int)TableColumn.OrderCotegory].ToString()); |
|
| 523 |
wrk.OrderDate = DateTime.Parse(objwrk[(int)TableColumn.OrderDate].ToString()); |
|
| 524 |
wrk.OrderNo = int.Parse(objwrk[(int)TableColumn.OrderNo].ToString()); |
|
| 525 |
|
|
| 526 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString()); |
|
| 527 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString()); |
|
| 503 | 528 |
} |
| 504 | 529 |
catch (OracleException oraex) |
| 505 | 530 |
{
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyData.cs | ||
|---|---|---|
| 31 | 31 |
/// <summary> |
| 32 | 32 |
/// データフィールド並び |
| 33 | 33 |
/// </summary> |
| 34 |
public enum DataColumn
|
|
| 34 |
public enum TableColumn
|
|
| 35 | 35 |
{
|
| 36 | 36 |
/// <summary> |
| 37 | 37 |
/// 作成者コード |
| ... | ... | |
| 299 | 299 |
try |
| 300 | 300 |
{
|
| 301 | 301 |
// データ取得 |
| 302 |
wrk.PersonCode = int.Parse(objwrk[(int)DataColumn.PersonCode].ToString()); // 担当者コード
|
|
| 303 |
wrk.DailyDataDate = DateTime.Parse(objwrk[(int)DataColumn.DailyDataDate].ToString()); // 日報作成日
|
|
| 304 |
wrk.LineCoount = int.Parse(objwrk[(int)DataColumn.LineCount].ToString()); // 行番号
|
|
| 305 |
wrk.ConstructionCode = int.Parse(objwrk[(int)DataColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 306 |
wrk.WorkContentsText = objwrk[(int)DataColumn.WorkContentsText].ToString(); // 作業内容
|
|
| 302 |
wrk.PersonCode = int.Parse(objwrk[(int)TableColumn.PersonCode].ToString()); // 担当者コード
|
|
| 303 |
wrk.DailyDataDate = DateTime.Parse(objwrk[(int)TableColumn.DailyDataDate].ToString()); // 日報作成日
|
|
| 304 |
wrk.LineCoount = int.Parse(objwrk[(int)TableColumn.LineCount].ToString()); // 行番号
|
|
| 305 |
wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 306 |
wrk.WorkContentsText = objwrk[(int)TableColumn.WorkContentsText].ToString(); // 作業内容
|
|
| 307 | 307 |
|
| 308 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)DataColumn.EntryDate].ToString());
|
|
| 309 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)DataColumn.UpdateDate].ToString());
|
|
| 308 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
|
|
| 309 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());
|
|
| 310 | 310 |
} |
| 311 | 311 |
catch (OracleException oraex) |
| 312 | 312 |
{
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataConstruction.cs | ||
|---|---|---|
| 31 | 31 |
/// <summary> |
| 32 | 32 |
/// データフィールド並び |
| 33 | 33 |
/// </summary> |
| 34 |
public enum DataColumn
|
|
| 34 |
public enum TableColumn
|
|
| 35 | 35 |
{
|
| 36 | 36 |
/// <summary> |
| 37 | 37 |
/// 作成者コード |
| ... | ... | |
| 273 | 273 |
strcmd += " SET"; |
| 274 | 274 |
switch (FeildNo) |
| 275 | 275 |
{
|
| 276 |
case (int)DataColumn.PersonCode:
|
|
| 276 |
case (int)TableColumn.PersonCode:
|
|
| 277 | 277 |
strcmd += string.Format(" PersonCode = {0}", ((int)value).ToString());
|
| 278 | 278 |
break; |
| 279 |
case (int)DataColumn.DailyDataDate:
|
|
| 279 |
case (int)TableColumn.DailyDataDate:
|
|
| 280 | 280 |
strcmd += string.Format(" DailyDataDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());
|
| 281 | 281 |
break; |
| 282 |
case (int)DataColumn.ConstructionCode:
|
|
| 282 |
case (int)TableColumn.ConstructionCode:
|
|
| 283 | 283 |
strcmd += string.Format(" ConstructionCode = {0}", ((int)value).ToString());
|
| 284 | 284 |
break; |
| 285 |
case (int)DataColumn.Weather:
|
|
| 285 |
case (int)TableColumn.Weather:
|
|
| 286 | 286 |
strcmd += string.Format(" Weather = '{0}'", value.ToString());
|
| 287 | 287 |
break; |
| 288 | 288 |
} |
| ... | ... | |
| 340 | 340 |
try |
| 341 | 341 |
{
|
| 342 | 342 |
// データ取得 |
| 343 |
wrk.PersonCode = int.Parse(objwrk[(int)DataColumn.PersonCode].ToString()); // 担当者コード
|
|
| 344 |
wrk.DailyDataDate = DateTime.Parse(objwrk[(int)DataColumn.DailyDataDate].ToString()); // 日報作成日
|
|
| 345 |
wrk.ConstructionCode = int.Parse(objwrk[(int)DataColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 346 |
wrk.Weather = objwrk[(int)DataColumn.Weather].ToString(); // 天気
|
|
| 343 |
wrk.PersonCode = int.Parse(objwrk[(int)TableColumn.PersonCode].ToString()); // 担当者コード
|
|
| 344 |
wrk.DailyDataDate = DateTime.Parse(objwrk[(int)TableColumn.DailyDataDate].ToString()); // 日報作成日
|
|
| 345 |
wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 346 |
wrk.Weather = objwrk[(int)TableColumn.Weather].ToString(); // 天気
|
|
| 347 | 347 |
|
| 348 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)DataColumn.EntryDate].ToString());
|
|
| 349 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)DataColumn.UpdateDate].ToString());
|
|
| 348 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
|
|
| 349 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());
|
|
| 350 | 350 |
} |
| 351 | 351 |
catch (OracleException oraex) |
| 352 | 352 |
{
|
| trunk/src/ProcessManagement/ProcessManagement/DB/IOAccess/IODailyDataDetail.cs | ||
|---|---|---|
| 31 | 31 |
/// <summary> |
| 32 | 32 |
/// データフィールド並び |
| 33 | 33 |
/// </summary> |
| 34 |
public enum DataColumn
|
|
| 34 |
public enum TableColumn
|
|
| 35 | 35 |
{
|
| 36 | 36 |
/// <summary> |
| 37 | 37 |
/// 作成者コード |
| ... | ... | |
| 362 | 362 |
strcmd += " SET"; |
| 363 | 363 |
switch (FeildNo) |
| 364 | 364 |
{
|
| 365 |
case (int)DataColumn.PersonCode:
|
|
| 365 |
case (int)TableColumn.PersonCode:
|
|
| 366 | 366 |
strcmd += string.Format(" PersonCode = {0}", (int)value);
|
| 367 | 367 |
break; |
| 368 |
case (int)DataColumn.DailyDataDate:
|
|
| 368 |
case (int)TableColumn.DailyDataDate:
|
|
| 369 | 369 |
strcmd += string.Format(" DailyDataDate = TO_DATE('{0}','YYYY/MM/DD')", ((DateTime)value).ToShortDateString());
|
| 370 | 370 |
break; |
| 371 |
case (int)DataColumn.ConstructionCode:
|
|
| 371 |
case (int)TableColumn.ConstructionCode:
|
|
| 372 | 372 |
strcmd += string.Format(" ConstructionCode = {0}", (int)value);
|
| 373 | 373 |
break; |
| 374 |
case (int)DataColumn.SeqNo:
|
|
| 374 |
case (int)TableColumn.SeqNo:
|
|
| 375 | 375 |
strcmd += string.Format(" SeqNo = {0}", (int)value);
|
| 376 | 376 |
break; |
| 377 |
case (int)DataColumn.JobCategoryCode:
|
|
| 377 |
case (int)TableColumn.JobCategoryCode:
|
|
| 378 | 378 |
strcmd += string.Format(" JobCategoryCode = {0}", (int)value);
|
| 379 | 379 |
break; |
| 380 |
case (int)DataColumn.CompanyCode:
|
|
| 380 |
case (int)TableColumn.CompanyCode:
|
|
| 381 | 381 |
strcmd += string.Format(" CompanyCode = {0}", (int)value);
|
| 382 | 382 |
break; |
| 383 |
case (int)DataColumn.TodayHeadCount:
|
|
| 383 |
case (int)TableColumn.TodayHeadCount:
|
|
| 384 | 384 |
strcmd += string.Format(" TodayHeadCount = {0}", (double)value);
|
| 385 | 385 |
break; |
| 386 |
case (int)DataColumn.TotalHeadCount:
|
|
| 386 |
case (int)TableColumn.TotalHeadCount:
|
|
| 387 | 387 |
strcmd += string.Format(" TotalHeadCount = {0}", (double)value);
|
| 388 | 388 |
break; |
| 389 |
case (int)DataColumn.TodayWork:
|
|
| 389 |
case (int)TableColumn.TodayWork:
|
|
| 390 | 390 |
strcmd += string.Format(" TodayWork = '{0}'", CommonMotions.cnvString(value));
|
| 391 | 391 |
break; |
| 392 |
case (int)DataColumn.NextdayWork:
|
|
| 392 |
case (int)TableColumn.NextdayWork:
|
|
| 393 | 393 |
strcmd += string.Format(" NextdayWork = '{0}'", CommonMotions.cnvString(value));
|
| 394 | 394 |
break; |
| 395 |
case (int)DataColumn.NextdayHeadCount:
|
|
| 395 |
case (int)TableColumn.NextdayHeadCount:
|
|
| 396 | 396 |
strcmd += string.Format(" NextdayHeadCount = {0}", (double)value);
|
| 397 | 397 |
break; |
| 398 | 398 |
} |
| ... | ... | |
| 423 | 423 |
try |
| 424 | 424 |
{
|
| 425 | 425 |
// データ取得 |
| 426 |
wrk.PersonCode = int.Parse(objwrk[(int)DataColumn.PersonCode].ToString()); // 担当者コード
|
|
| 427 |
wrk.DailyDataDate = DateTime.Parse(objwrk[(int)DataColumn.DailyDataDate].ToString()); // 日報作成日
|
|
| 428 |
wrk.ConstructionCode = int.Parse(objwrk[(int)DataColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 429 |
wrk.SeqNo = int.Parse(objwrk[(int)DataColumn.SeqNo].ToString()); // 明細行番号
|
|
| 430 |
wrk.JobCategoryCode = int.Parse(objwrk[(int)DataColumn.JobCategoryCode].ToString()); // 職種キー
|
|
| 431 |
wrk.CompanyCode = int.Parse(objwrk[(int)DataColumn.CompanyCode].ToString()); // 協力会社コード
|
|
| 432 |
wrk.TodayHeadCount = double.Parse(objwrk[(int)DataColumn.TodayHeadCount].ToString()); // 当日人員数
|
|
| 433 |
wrk.TotalHeadCount = double.Parse(objwrk[(int)DataColumn.TotalHeadCount].ToString()); // 累計人員数
|
|
| 434 |
wrk.TodayWork = objwrk[(int)DataColumn.TodayWork].ToString(); // 当日作業内容
|
|
| 435 |
wrk.NextdayWork = objwrk[(int)DataColumn.NextdayWork].ToString(); // 翌日作業内容
|
|
| 436 |
wrk.NextdayHeadCount = double.Parse(objwrk[(int)DataColumn.NextdayHeadCount].ToString()); // 翌日人員数
|
|
| 426 |
wrk.PersonCode = int.Parse(objwrk[(int)TableColumn.PersonCode].ToString()); // 担当者コード
|
|
| 427 |
wrk.DailyDataDate = DateTime.Parse(objwrk[(int)TableColumn.DailyDataDate].ToString()); // 日報作成日
|
|
| 428 |
wrk.ConstructionCode = int.Parse(objwrk[(int)TableColumn.ConstructionCode].ToString()); // 工事番号
|
|
| 429 |
wrk.SeqNo = int.Parse(objwrk[(int)TableColumn.SeqNo].ToString()); // 明細行番号
|
|
| 430 |
wrk.JobCategoryCode = int.Parse(objwrk[(int)TableColumn.JobCategoryCode].ToString()); // 職種キー
|
|
| 431 |
wrk.CompanyCode = int.Parse(objwrk[(int)TableColumn.CompanyCode].ToString()); // 協力会社コード
|
|
| 432 |
wrk.TodayHeadCount = double.Parse(objwrk[(int)TableColumn.TodayHeadCount].ToString()); // 当日人員数
|
|
| 433 |
wrk.TotalHeadCount = double.Parse(objwrk[(int)TableColumn.TotalHeadCount].ToString()); // 累計人員数
|
|
| 434 |
wrk.TodayWork = objwrk[(int)TableColumn.TodayWork].ToString(); // 当日作業内容
|
|
| 435 |
wrk.NextdayWork = objwrk[(int)TableColumn.NextdayWork].ToString(); // 翌日作業内容
|
|
| 436 |
wrk.NextdayHeadCount = double.Parse(objwrk[(int)TableColumn.NextdayHeadCount].ToString()); // 翌日人員数
|
|
| 437 | 437 |
|
| 438 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)DataColumn.EntryDate].ToString());
|
|
| 439 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)DataColumn.UpdateDate].ToString());
|
|
| 438 |
wrk.EntryDate = DateTime.Parse(objwrk[(int)TableColumn.EntryDate].ToString());
|
|
| 439 |
wrk.UpdateDate = DateTime.Parse(objwrk[(int)TableColumn.UpdateDate].ToString());
|
|
| 440 | 440 |
} |
| 441 | 441 |
catch (OracleException oraex) |
| 442 | 442 |
{
|
他の形式にエクスポート: Unified diff