From d1b14d00d9ee4ff4a1b271e6b4fe094f5049a55f Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期一, 17 三月 2025 09:23:16 +0800 Subject: [PATCH] 采购入库单:下推采购退料单 --- WebAPI/Controllers/仓存管理/条码生成/Sc_BarCodeController.cs | 28 ++++++++++++++++++++++++++++ 1 files changed, 28 insertions(+), 0 deletions(-) diff --git "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs" "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs" index a1d9e86..81390b2 100644 --- "a/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs" +++ "b/WebAPI/Controllers/\344\273\223\345\255\230\347\256\241\347\220\206/\346\235\241\347\240\201\347\224\237\346\210\220/Sc_BarCodeController.cs" @@ -127,6 +127,10 @@ list.Add("浠櫒鎴愬搧鏉$爜瑙勫垯"); list.Add("璇曞墏鎴愬搧鏉$爜瑙勫垯"); } + else if (sCapName == "娣诲悍绉戞妧") + { + list.Add("鎵规鏉$爜"); + } else { list.Add("鍞竴鏉$爜"); @@ -232,6 +236,11 @@ tabname = "h_v_IF_ProcessExchangeBillList_Source"; count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_ProcessExchangeBillList_Source " + sWhere + " order by 鍗曟嵁鍙� desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by 鍗曟嵁鍙� desc,hsubid) as HRowNumber,* from h_v_IF_ProcessExchangeBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); + break; + case "閿�鍞嚭搴撳崟": + tabname = "h_v_IF_SellOutBillList_Source"; + count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_SellOutBillList_Source " + sWhere + " order by 鍗曟嵁鍙� desc,hsubid", tabname).Tables[0].Rows.Count; + sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by 鍗曟嵁鍙� desc,hsubid) as HRowNumber,* from h_v_IF_SellOutBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); break; default: break; @@ -346,6 +355,12 @@ case "3711": //鐢熶骇姹囨姤鍗� //寰楀埌淇℃伅 ds = oCN.RunProcReturn("select * from h_v_IF_ICMOReportList where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IF_ICMOReportList"); + //鍐欏叆淇℃伅 + ListRows.Add(HSourceOrderList1(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType)); + break; + case "1205": //閿�鍞嚭搴撳崟 + //寰楀埌淇℃伅 + ds = oCN.RunProcReturn("select * from h_v_IF_SellOutBillList_BarCode where hmainid=" + oSelectRow.BillMainID + " and hsubid=" + oSelectRow.BillSubID, "h_v_IF_SellOutBillList_BarCode"); //鍐欏叆淇℃伅 ListRows.Add(HSourceOrderList1(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType)); break; @@ -577,6 +592,15 @@ ordrlist.HSPID = dt.Rows[i]["HSPID"].ToString(); ordrlist.HSPNumber = dt.Rows[i]["浠撲綅浠g爜"].ToString(); ordrlist.HSPName = dt.Rows[i]["浠撲綅"].ToString(); + } + if(HSourceBillType == "閿�鍞嚭搴撳崟") + { + ordrlist.HWhID = dt.Rows[i]["HWhID"].ToString(); + ordrlist.HWhNumber = dt.Rows[i]["浠撳簱浠g爜"].ToString(); + ordrlist.HWhName = dt.Rows[i]["浠撳簱"].ToString(); + //ordrlist.HSPID = dt.Rows[i]["HSPID"].ToString(); + //ordrlist.HSPNumber = dt.Rows[i]["浠撲綅浠g爜"].ToString(); + //ordrlist.HSPName = dt.Rows[i]["浠撲綅"].ToString(); } } return ordrlist; @@ -1284,6 +1308,10 @@ { HBarCodeType = "鍞竴鏉$爜"; } + if (CampanyName == "涔濊彵") + { + HBarCode = HBarCode + ClsPub.isStrNull(ListRows[i].HMTONo2); + } // HMaterID = ClsPub.isLong(ListRows[i].HMaterID2); HEntryID = ClsPub.isLong(ListRows[i].HEntryID2); -- Gitblit v1.9.1