From 7e8fbf96c0e985791b7aad451b1b33d933ba77df Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期一, 29 七月 2024 16:56:11 +0800 Subject: [PATCH] 库存检验单 增加 批次号,检验数量,良品数量,报废数量,可疑数 HBatchNo varchar(200) --批号 HInSpectQty dec(18,8) --检验数量 HRightQty dec(18,8) --合格数量 HUnRightQty dec(18,8) --不合格数量 HUnKnowQty dec(18,8) --可疑数量 实验室 仪器检验时,扫码流转卡二维码的, 改为 可以扫 取样单 二维码(即 可以扫流转卡也可以扫取样单)。 检验单里 保存 对应的 取样单 内码; 首件单,巡检单,工序检验单 表头增加 字段 HTakeSampleCheckBillID int --取样单内码 HTakeSampleCheckBillNo int --取样单 出站单 :增加 字段: 返工数,工废数量,料废数量 ,料废返工数量 HBackWorkQty dec(18,8) -- 返工数 HBadByWorkQty dec(18,8) -- 工废数量 HBadByMaterQty dec(18,8) --料废数量 HBackWorkByMaterQty dec(18,8) --料废返工数量 --- WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs index f78b793..e278d45 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs @@ -148,6 +148,7 @@ Int64 HShiftsID = list[0].HShiftsID;//鐢熶骇鐝 double HToCheckQty = list[0].HToCheckQty;//鍙栨牱鏁伴噺 double HLossQty = list[0].HLossQty;//閬楀け鏁伴噺 + double HBackWorkByMaterQty = list[0].HBackWorkByMaterQty;//閬楀け鏁伴噺 LogService.Write($"1.瀛楁璧嬪�硷紝鐢ㄦ椂" + sw.Elapsed ); @@ -390,7 +391,7 @@ ",HMainSourceInterID,HMainSourceBillNo,HMainSourceBillType,HLastSubProc" + ",HEmpID2,HEmpID3,HEmpID4,HEmpID5,HDSQty,HChongQty,HPriceRate,HWorkTimes,HQCCheckID,HMainInterID,HPRDOrgID" + ",HmaterOutqty,HProcPriceRate,HTemporaryAreaID,HWasterQty_Work,HWasterQty_Mater,HBackWorkQty,HShiftsID" + - ",HToCheckQty,HLossQty" + + ",HToCheckQty,HLossQty,HBackWorkByMaterQty" + ") " + " values('" + BillType + "','" + (OperationType == "5" ? "SUB" : HBillSubType) + "'," + HInterID + ",'" + HBillNo + "'," + HBillStatus + ",getdate(),'" + HMaker + "',getdate(),'" + HMouldNum + "'" + "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HSourceName + "'," + HPieceQty + "," + HWasterQty + "," + HPlanPieceQty + "," + HBadPNL + @@ -401,7 +402,7 @@ "," + HMainSourceInterID + ",'" + HMainSourceBillNo + "','" + HMainSourceBillType + "'," + Convert.ToString(HLastSubProc ? 1 : 0) + "," + HEmpID2 + "," + HEmpID3 + "," + HEmpID4 + "," + HEmpID5 + "," + HDSQty + "," + HChongQty + "," + HPriceRate + "," + HWorkTimes + "," + HQCCheckID + "," + HMainInterID + "," + HPRDOrgID + "," + HmaterOutqty + "," + HProcPriceRate + "," + HTemporaryAreaID + "," + HWasterQty_Work + "," + HWasterQty_Mater + "," + HBackWorkQty + - "," + HShiftsID + "," + HToCheckQty + "," + HLossQty + ") "); + "," + HShiftsID + "," + HToCheckQty + "," + HLossQty + ","+ HBackWorkByMaterQty + ") "); LogService.Write($"4.鏂板缁撴潫锛岀敤鏃�" + sw.Elapsed); LogService.Write("鐢ㄦ埛:" + user + ",鏃ユ湡:" + DateTime.Now + ",鏂板宸ュ簭鍑虹珯鍗曟嵁:" + HBillNo); @@ -445,6 +446,7 @@ ",HWasterQty_Mater=" + HWasterQty_Mater + ",HBackWorkQty=" + HBackWorkQty + ",HShiftsID=" + HShiftsID + + ",HBackWorkByMaterQty=" + HBackWorkByMaterQty + " where HInterID=" + HInterID); LogService.Write("鐢ㄦ埛:" + user + ",鏃ユ湡:" + DateTime.Now + ",淇敼宸ュ簭鍑虹珯鍗曟嵁:" + HBillNo); -- Gitblit v1.9.1