From a1709bcc95fe641126f5c34e0a344e406b467f88 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期二, 16 五月 2023 11:11:15 +0800 Subject: [PATCH] 流转卡和生产订单只能自己删除自己的单据。pda进站单增加白坯发布字段,放在接收数量后面,不允许编辑,每次扫进站单出站单的时候,自动把白坯发布的汇总数量显示。生产订单模块增加一个字段,是否取库存,底部备注,做成下拉框。生产报表这个字段有值的不计算产能。工艺路线批量插入白坯定型和染厂(第一道和第二道)(把以前所有的流水号加20,在把白坯定型(10),和染厂(20)刷进去 --- WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs | 8 +++----- 1 files changed, 3 insertions(+), 5 deletions(-) diff --git a/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs b/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs index 3609431..8281cd6 100644 --- a/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs +++ b/WebAPI/Controllers/SCGL/Sc_CallGoodsBackRequestBillController.cs @@ -59,10 +59,8 @@ //鍙嶅簭鍒楀寲浼犻�掔殑鍊� CallGoodsBackRequest com = JsonConvert.DeserializeObject<CallGoodsBackRequest>(sWhere.ToString()); - oCN.RunProc($"exec h_p_JIT_BackGoodsRequestBillList_Query '{com.HBeginDate}','{com.HEndDate.AddDays(1).AddSeconds(-1)}','{com.HBillNo}','{com.MaterialNumber}'," + - $"'{com.MaterialName}','{com.MaterialModel}','{com.HDeptName}','{com.ProcMul}','{com.Hmaker}','{com.HOrgID}'"); - - ds = oCN.RunProcReturn("select * from ##h_p_JIT_BackGoodsRequestBillList_Query where 1=1 " + com.Arbitrarily + "", "##h_p_JIT_BackGoodsRequestBillList_Query"); + ds = oCN.RunProcReturn($"exec h_p_JIT_BackGoodsRequestBillList_Query '{com.HBeginDate}','{com.HEndDate.AddDays(1).AddSeconds(-1)}','{com.HBillNo}','{com.MaterialNumber}'," + + $"'{com.MaterialName}','{com.MaterialModel}','{com.HDeptName}','{com.ProcMul}','{com.Hmaker}','{com.HOrgID}'", "h_p_JIT_BackGoodsRequestBillList_Query"); objJsonResult.code = "1"; objJsonResult.count = 1; @@ -239,7 +237,7 @@ for (int i = 0; i < listCa.Count; i++) { ds = oCN.RunProcReturn($"exec h_p_JIT_BackGoods_WHReceive {listCa[i].hmainid},{listCa[i].Hsubid}," + - $"{listCa[i].HSPID},{user}", "h_p_JIT_BackGoods_WHReceive"); + $"{listCa[i].HSPID},'{user}'", "h_p_JIT_BackGoods_WHReceive"); if (ds.Tables[0].Rows[0][0].ToString() == "1") { -- Gitblit v1.9.1