From 0b8fe1800ff22f33f44079ab17fae70dc7f853ad Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期一, 03 六月 2024 14:54:16 +0800 Subject: [PATCH] 工序流转卡 工艺路线 工序过站控制 --- WebAPI/Controllers/项目管理/工作任务/PM_WorkTaskBillController.cs | 13 +++++++++---- 1 files changed, 9 insertions(+), 4 deletions(-) diff --git "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskBillController.cs" "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskBillController.cs" index 844703b..500cb9a 100644 --- "a/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskBillController.cs" +++ "b/WebAPI/Controllers/\351\241\271\347\233\256\347\256\241\347\220\206/\345\267\245\344\275\234\344\273\273\345\212\241/PM_WorkTaskBillController.cs" @@ -66,6 +66,7 @@ public string HMainSourceBillNo; public string HMainSourceBillType; public int HOrderLevID; + public int HTaskClassID; } #endregion @@ -184,7 +185,7 @@ string HMainSourceBillNo = mainList[0].HMainSourceBillNo; string HMainSourceBillType = mainList[0].HMainSourceBillType; int HOrderLevID = mainList[0].HOrderLevID; - + int HTaskClassID = mainList[0].HTaskClassID; if (OperationType == 2) @@ -206,7 +207,7 @@ { string sql = "insert into PM_WorkTaskBillMain" + "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HProjectID,HProNumber,HProjectStageID,HName,HDate,HTaskNote,HPlanTimes" + - ",HSelfTimes,HLastDate,HSendEmp,HReceiveEmp,HType,HCopyEmp,HRemark,HOrgID,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HOrderLevID)" + + ",HSelfTimes,HLastDate,HSendEmp,HReceiveEmp,HType,HCopyEmp,HRemark,HOrgID,HMaker,HMakeDate,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType,HOrderLevID,HTaskClassID)" + "values(" + "" + HYear + "," + HPeriod + @@ -236,6 +237,7 @@ ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "','" + HOrderLevID + + "','"+ HTaskClassID+ "')"; //涓昏〃 @@ -273,6 +275,7 @@ ",HMainSourceBillNo = '" + HMainSourceBillNo + "',HMainSourceBillType = '" + HMainSourceBillType + "',HOrderLevID = '" + HOrderLevID + + "',HTaskClassID = '" + HTaskClassID + "' where HInterID = " + HInterID; oCN.RunProc(sql); @@ -282,7 +285,8 @@ //璁板綍鏃ュ織 LogService.Write("鐢ㄦ埛:" + user + ",鏃ユ湡:" + DateTime.Now + ",淇敼宸ヤ綔浠诲姟:" + HBillNo); oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "淇敼宸ヤ綔浠诲姟锛�" + HBillNo + "','LMES-宸ヤ綔浠诲姟妯″潡','" + DBUtility.ClsPub.IPAddress + "','淇敼鍗曟嵁'", ref DBUtility.ClsPub.sExeReturnInfo); - }else if (OperationType == 4 && ds.Tables[0].Rows.Count == 0) //涓嬫帹 + } + else if (OperationType == 4 && ds.Tables[0].Rows.Count == 0) //涓嬫帹 { string sql = "insert into PM_WorkTaskBillMain" + "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HProjectID,HProNumber,HProjectStageID,HName,HDate,HTaskNote,HPlanTimes" + @@ -1443,7 +1447,8 @@ //璁板綍鏃ュ織 LogService.Write("鐢ㄦ埛:" + user + ",鏃ユ湡:" + DateTime.Now + ",淇敼椤圭洰闃舵娓呭崟:" + HBillNo); oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + user + "','" + HComputerName + "','" + "淇敼椤圭洰闃舵娓呭崟锛�" + HBillNo + "','LMES-椤圭洰闃舵娓呭崟妯″潡','" + DBUtility.ClsPub.IPAddress + "','淇敼鍗曟嵁'", ref DBUtility.ClsPub.sExeReturnInfo); - }else if(OperationType == 4 && ds.Tables[0].Rows.Count == 0) //涓嬫帹 + } + else if(OperationType == 4 && ds.Tables[0].Rows.Count == 0) //涓嬫帹 { string sql = "insert into PM_WorkTaskReportBillMain" + "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate,HBillNo,HBillStatus,HRemark,HMaker,HMakeDate,HOrgID,HReportEmpID,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillType,HMainSourceBillNo) " + -- Gitblit v1.9.1