派生自 MES-WEB-API
WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
@@ -10,6 +10,7 @@ using System.IO; using System.Web; using System.Web.Http; using System.Windows.Forms; using WebAPI.Models; namespace WebAPI.Controllers @@ -39,6 +40,7 @@ //反序列化 string msg2 = "[" + sArray[0].ToString() + "]"; string user = sArray[1].ToString();//用户名 string HComputerName = SystemInformation.ComputerName; //设备名称 //判断是否有编辑权限 if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Edit", 1, false, user)) @@ -118,6 +120,7 @@ double HWorkTimes = list[0].HWorkTimes;//工时 long HQCCheckID = list[0].HQCCheckID;//检验员ID long HPRDOrgID = list[0].HPRDOrgID;//组织ID double HmaterOutqty = list[0].HmaterOutqty;//白坯发布 //单据完整性判断 if (HProcExchInterID <= 0) { @@ -176,14 +179,6 @@ objJsonResult.data = null; return objJsonResult; } if (HEmpID == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "操作员没有选择！"; objJsonResult.data = null; return objJsonResult; } //if (HQCCheckID == 0) //{ // objJsonResult.code = "0"; @@ -192,14 +187,42 @@ // objJsonResult.data = null; // return objJsonResult; //} //if (HSourceID == 0) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "生产资源没有选择！"; // objJsonResult.data = null; // return objJsonResult; //} //获取系统参数 string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //判断客户不为龙山汽配 if (oSystemParameter.omodel.WMS_CampanyName != "龙山汽配"&& oSystemParameter.omodel.WMS_CampanyName != "瑞与祺") //系统参数 { if (HSourceID == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "生产资源没有选择！"; objJsonResult.data = null; return objJsonResult; } } //判断客户为龙山汽配 else if (oSystemParameter.omodel.WMS_CampanyName == "龙山汽配") { //判断是否为多工位 ds = oCN.RunProcReturn("select * from h_v_GetStationOutBill_Detail where 工序ID = " + HProcID + " and 物料ID = " + HMaterID + " and 流转卡号 = '" + HProcExchBillNo + "'", "h_v_GetStationOutBill_Detail"); if (ds != null && ds.Tables[0].Rows.Count <= 1) { if (HEmpID == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "操作员没有选择！"; objJsonResult.data = null; return objJsonResult; } } } } //if (HCenterID == 0) //{ // objJsonResult.code = "0"; @@ -282,6 +305,7 @@ ",HSupID,HQty,HPrice,HMoney,HBadCount,HCenterID,HProcNo,HOrderProcNO,HSourceNameList" + ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HLastSubProc" + ",HEmpID2,HEmpID3,HEmpID4,HEmpID5,HDSQty,HChongQty,HPriceRate,HWorkTimes,HQCCheckID,HMainInterID,HPRDOrgID" + ",HmaterOutqty" + ") " + " values('" + BillType + "','" + HBillSubType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate(),'" + HMouldNum + "'" + "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL + @@ -291,7 +315,10 @@ "," + HSupID + "," + HQty + "," + HPrice + "," + HMoney + "," + HBadCount + "," + HCenterID + "," + HProcNo + ",'" + HOrderProcNO + "'" + ",'" + HSourceNameList + "'" + "," + HMainSourceInterID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + Convert.ToString(HLastSubProc ? 1 : 0) + "," + HEmpID2 + "," + HEmpID3 + "," + HEmpID4 + "," + HEmpID5 + "," + HDSQty + "," + HChongQty + "," + HPriceRate + "," + HWorkTimes + "," + HQCCheckID + "," + HMainInterID + "," + HPRDOrgID + ") "); ","+ HmaterOutqty + ") "); 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 ("Modify".Equals(eventType)) { @@ -324,6 +351,9 @@ ",HWasterQty=" + HWasterQty + ",HLastSubProc=" + Convert.ToString(HLastSubProc ? 1 : 0) + " where HInterID=" + HInterID); 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 { @@ -1590,7 +1620,7 @@ { try { string HComputerName = SystemInformation.ComputerName; //设备名称 //编辑权限 if (!DBUtility.ClsPub.Security_Log("Cj_StationOutBill_Drop", 1, false, HDeleteMan)) { @@ -1603,14 +1633,22 @@ DAL.ClsSc_StationOutBill oBill = new DAL.ClsSc_StationOutBill(); if (oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo)) { if (oBill.omodel.HMaker != HDeleteMan && (HDeleteMan != "admin" && HDeleteMan != "Admin")) string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "只能删除本人的单据！"; objJsonResult.data = null; return objJsonResult; if (oSystemParameter.omodel.MES_StationOutBill_DeleteCtl == "Y") { if (oBill.omodel.HMaker != HDeleteMan && (HDeleteMan != "admin" && HDeleteMan != "Admin")) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "只能删除本人的单据！"; objJsonResult.data = null; return objJsonResult; } } } SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet ds; @@ -1641,8 +1679,17 @@ return objJsonResult; } //写入删除日志 string WorkList = "删除出站单：" + oBill.omodel.HBillNo; ds = oCn.RunProcReturn($"exec h_p_DelOutInBill {HInterID},'MES_StationOutBill_DeleteRelationCtl'", "h_p_DelOutInBill"); if (ds.Tables[0].Rows[0][0].ToString()== "0") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "系统参数控制,已有下道工序,不能删除！"; objJsonResult.data = null; return objJsonResult; } if (!oBill.DeleteBill(oBill.omodel.HInterID, oBill.omodel.HProcExchInterID, oBill.omodel.HProcExchEntryID, ref DBUtility.ClsPub.sExeReturnInfo)) { objJsonResult.code = "0"; @@ -1653,6 +1700,10 @@ } else { //写入删除日志 LogService.Write("用户:" + HDeleteMan + ",日期:" + DateTime.Now + ",删除工序出站单据:" + oBill.omodel.HBillNo); oCN.RunProc("Insert into System_log (GeginDate, userid, WorkstationName, WorkList, SystemName, NetuserName, State) select GETDATE(),'" + HDeleteMan + "','" + HComputerName + "','" + "删除工序出站单据：" + oBill.omodel.HBillNo + "','LMES-工序出站模块','" + DBUtility.ClsPub.IPAddress + "','删除单据'", ref DBUtility.ClsPub.sExeReturnInfo); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "删除成功！"; @@ -2190,6 +2241,7 @@ List<ClsSc_StationOutBillSub_Emp> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg2); List<ClsSc_StationOutBillSub_Emp> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsSc_StationOutBillSub_Emp>>(msg3); long HInterID = mainList[0].HInterID; long HWorkEmpID = subList[0].HWorkEmpID; long HWorkSourceID = subList[0].HWorkSourceID; decimal HQty = subList[0].HQty; @@ -2197,21 +2249,23 @@ decimal HProcPrice = subList[0].HProcPrice; decimal HMoney = subList[0].HMoney; long HWorkProcID = mainList[0].HWorkProcID; var EntryID = 0; foreach (ClsSc_StationOutBillSub_Emp oSub in subList) { //ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where hmainid=" + HInterID + " and 单据号='" + HBillNo + "'", "h_v_IF_ICMOBillList"); if ((OperationType == 1 || OperationType == 2))//新增 && ds.Tables[0].Rows.Count == 0 { EntryID++; string sql = string.Empty; sql = $@" Insert into Sc_StationOutBillSub_Emp (HInterID,HEntryID,HBillNo_bak ,HRemark ,HSourceInterID ,HSourceEntryID ,HSourceBillNo ,HSourceBillType ,HRelationQty ,HRelationMoney ,HWorkEmpID ,HWorkSourceID ,HQty ,HRate ,HProcPrice ,HMoney ,HWorkProcID) values(" + 1 + "," + 2 + "," + "'" + mainList[0].HBillNo_bak + "','" + "HRemark" + "'," + 0 + "," + 0 + ",'" + " " + "','" + "HSource" + "'," + "0" + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + "," + 0 + ")"; values(" + HInterID + "," + EntryID + "," + "'" + mainList[0].HBillNo_bak + "','" + mainList[0].HRemark + "'," + 0 + "," + 0 + ",'" + " " + "','" + " " + "'," + "0" + "," + 0 + "," + oSub.HWorkEmpID + "," + oSub.HWorkSourceID + "," + oSub.HQty + "," + oSub.HRate + "," + oSub.HProcPrice + "," + oSub.HMoney + "," + HWorkProcID + ")"; oCN.RunProc(sql); }
