SRM-WEBAPI.git - Gitblit

			@@ -1452,7 +1452,7 @@

			//判断未关联数量是否为0
			//安瑞：AIS20220914133941 瑞与琪：AIS20220308151944 本地：AIS20210811135644 夏宝：AIS20211130140219 凯贝：AIS20210820164804
			DataSet ds = oCn.RunProcReturn($"select T1.hqty-T1.hrelationqty+q.FMRBQTY as hqty,单据号,物料编码 from H_v_SRM_POOrderBillList t1 left join AIS20210820164804..T_PUR_POORDERENTRY_R q on q.FENTRYID=t1.HEntryID where hentryid in ({string.Join(", ", entryList)}) ", "H_v_SRM_POOrderBillList");
			DataSet ds = oCn.RunProcReturn($"select T1.hqty-T1.hrelationqty+q.FMRBQTY as hqty,单据号,物料编码 from H_v_SRM_POOrderBillList t1 left join AIS20220308151944..T_PUR_POORDERENTRY_R q on q.FENTRYID=t1.HEntryID where hentryid in ({string.Join(", ", entryList)}) ", "H_v_SRM_POOrderBillList");
			DataTable dt = ds.Tables[0];
			if (dt.Rows.Count > 0)
			{

			@@ -233,7 +233,7 @@
			{
			error = error + "物料代码中不能出现连续‘.’并且首位末位不能为‘.’！";
			}
			ds = oCn.RunProcReturn("select * from Gy_Material where HNumber='" + dt.Rows[i]["物料编码"].ToString() + "' ", "Gy_Material");
			ds = oCn.RunProcReturn("select top 1 HItemID from Gy_Material where HNumber='" + dt.Rows[i]["物料编码"].ToString() + "' ", "Gy_Material");
			if (ds.Tables[0].Rows.Count == 0)
			{
			error = error + $"第{(i + 1)}行,物料编码为{dt.Rows[i]["物料编码"].ToString()}不存在!";
			@@ -246,7 +246,7 @@
			}

			//判断导入物料的数量是否大于单据物料的总和数量
			ds = oCn.RunProcReturn("select * from h_v_POOrderBill_Excel " +
			ds = oCn.RunProcReturn("select 剩余收料数量 from h_v_POOrderBill_Excel " +
			$"where 采购组织='{dt.Rows[i]["组织"].ToString()}' and 供应商='{dt.Rows[i]["供应商"].ToString()}' " +
			$"and 包装标识='{dt.Rows[i]["包装标识"].ToString()}'" +
			$"and 物料编码='{dt.Rows[i]["物料编码"].ToString()}' and 关闭状态='未关闭' ", "h_v_POOrderBill_Excel");

	WebAPI/Controllers/POInStockController.cs	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebAPI/Controllers/POOrderBillExcelController.cs	4 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史