派生自 MES-WEB-API
WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
@@ -41,6 +41,7 @@ //反序列化 string msg2 = "[" + sArray[0].ToString() + "]"; string user = sArray[1].ToString();//用户名 string OperationType = sArray[2].ToString();//类型 string HComputerName = SystemInformation.ComputerName; //设备名称 //判断是否有编辑权限 @@ -67,8 +68,8 @@ int HBillStatus = 0; string HMaker = user;//制单人 string HMouldNum = list[0].HMouldNum;//模穴号 int HYear = 2021; double HPeriod = 1; int HYear = DateTime.Now.Year; double HPeriod = DateTime.Now.Month; string HRemark = list[0].HRemark;//备注 string HSourceName = list[0].HSourceName;//生产资源名称 double HPieceQty = list[0].HPieceQty;//进站PCS数 @@ -124,6 +125,8 @@ long HQCCheckID = list[0].HQCCheckID;//检验员ID long HPRDOrgID = list[0].HPRDOrgID;//组织ID double HmaterOutqty = list[0].HmaterOutqty;//白坯发布 double HProcPriceRate = list[0].HProcPriceRate;//工价系数 int HTemporaryAreaID = list[0].HTemporaryAreaID;//暂放区 LogService.Write($"1.字段赋值，用时" + sw.Elapsed ); @@ -299,10 +302,10 @@ // return objJsonResult; //} LogService.Write($"2.条件判断，用时" + sw.Elapsed); //LogService.Write($"2.条件判断，用时" + sw.Elapsed); var num = 0; LogService.Write($"3.事务开始，用时" + sw.Elapsed); //LogService.Write($"3.事务开始，用时" + sw.Elapsed); //若MAINDI重复则重新获取 oCN.BeginTran(); @@ -328,9 +331,9 @@ ",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" + ",HmaterOutqty,HProcPriceRate,HTemporaryAreaID" + ") " + " values('" + BillType + "','" + HBillSubType + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate(),'" + HMouldNum + "'" + " values('" + BillType + "','" + (OperationType == "5" ? "SUB" : HBillSubType) + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate(),'" + HMouldNum + "'" + "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL + "," + HICMOInterID + ",'" + HICMOBillNo + "'," + HProcPlanInterID + "," + HProcPlanEntryID + ",'" + HProcPlanBillNo + "'," + HProcExchInterID + "," + HProcExchEntryID + ",'" + HProcExchBillNo + "'," + HMaterID + "," + HProcID + "," + HICMOQty + "," + HPlanQty + ",getdate()," + HSourceID + "," + HPayProcID + @@ -338,7 +341,7 @@ "," + 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 + ") "); ","+ HmaterOutqty + "," + HProcPriceRate + ","+ HTemporaryAreaID + ") "); LogService.Write($"4.新增结束，用时" + sw.Elapsed); LogService.Write("用户:" + user + ",日期:" + DateTime.Now + ",新增工序出站单据:" + HBillNo); @@ -370,6 +373,7 @@ ",HQty=" + HQty + ",HDSQty=" + HDSQty + ",HChongQty=" + HChongQty + ",HTemporaryAreaID=" + HTemporaryAreaID + ",HMouldNum='" + HMouldNum + "'" + ",HSourceNameList='" + HSourceNameList + "'" + ",HWasterQty=" + HWasterQty + @@ -390,7 +394,7 @@ } //主表 LogService.Write($"5.系统控制查询判断，用时" + sw.Elapsed); //LogService.Write($"5.系统控制查询判断，用时" + sw.Elapsed); ds = oCN.RunProcReturn("exec h_p_MES_StationOutBill_QtyCtrl " + HInterID + "", "h_p_MES_StationOutBill_QtyCtrl"); if (ds == null) { @@ -401,7 +405,7 @@ objJsonResult.data = null; return objJsonResult; } LogService.Write($"5.1，用时" + sw.Elapsed); //LogService.Write($"5.1，用时" + sw.Elapsed); if (ds.Tables[0].Rows.Count == 0) { oCN.RollBack(); @@ -411,7 +415,7 @@ objJsonResult.data = null; return objJsonResult; } LogService.Write($"5.2，用时" + sw.Elapsed); //LogService.Write($"5.2，用时" + sw.Elapsed); if (ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2") { oCN.RollBack(); @@ -421,13 +425,13 @@ objJsonResult.data = null; return objJsonResult; } LogService.Write($"6.判断结束，用时" + sw.Elapsed); //LogService.Write($"6.判断结束，用时" + sw.Elapsed); oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_Out " + HInterID + ","+ num + ""); LogService.Write($"6.1，用时" + sw.Elapsed); //LogService.Write($"6.1，用时" + sw.Elapsed); oCN.RunProc("exec h_p_Mes_ProcessExchangeChangeStatus " + HInterID + " "); LogService.Write($"6.2，用时" + sw.Elapsed); //LogService.Write($"6.2，用时" + sw.Elapsed); oCN.RunProc("exec h_p_Mes_StationOutBillBackBarCode " + HInterID + " "); LogService.Write($"7.存储过程结束，用时" + sw.Elapsed); //LogService.Write($"7.存储过程结束，用时" + sw.Elapsed); //判断是否是 末道工序 ds1 = oCN.RunProcReturn(" select HLastProc,HFstProc from Sc_ProcessExchangeBillMain a " + " inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID " + @@ -445,10 +449,10 @@ //判断末道 生产汇报汇报 是否勾选 if (oSystemParameter.omodel.MES_StationOutBill_LastAutoICMOReport == "Y") //系统参数 { LogService.Write($"7.1，用时" + sw.Elapsed); //LogService.Write($"7.1，用时" + sw.Elapsed); //同步生产汇报单 objJsonResult = (json)SaveICMOReportBill(HInterID.ToString(), user, HBillNo, HPRDOrgID.ToString()); LogService.Write($"7.2，用时" + sw.Elapsed); //LogService.Write($"7.2，用时" + sw.Elapsed); if (objJsonResult.count == 0) { oCN.RollBack(); @@ -458,15 +462,15 @@ objJsonResult.data = null; return objJsonResult; } LogService.Write($"8.生产汇报结束，用时" + sw.Elapsed); //LogService.Write($"8.生产汇报结束，用时" + sw.Elapsed); } //判断末道 生产入库 是否勾选 else if (oSystemParameter.omodel.MES_StationOutBill_AutoStockIn == "Y") //系统参数 { LogService.Write($"8.1，用时" + sw.Elapsed); //LogService.Write($"8.1，用时" + sw.Elapsed); //同步生产入库单 objJsonResult =(json)SaveProcdutInBill(HBillNo); LogService.Write($"8.2，用时" + sw.Elapsed); //LogService.Write($"8.2，用时" + sw.Elapsed); if (objJsonResult.count == 0) { oCN.RollBack(); @@ -476,7 +480,7 @@ objJsonResult.data = null; return objJsonResult; } LogService.Write($"9.生产入库结束，用时" + sw.Elapsed); //LogService.Write($"9.生产入库结束，用时" + sw.Elapsed); } } @@ -484,7 +488,7 @@ } LogService.Write($"10.事务结束，用时" + sw.Elapsed); //LogService.Write($"10.事务结束，用时" + sw.Elapsed); oCN.Commit(); string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn) == true)
