MES-WEB-API.git

			@@ -450,7 +450,7 @@

			oCN.BeginTran();//开始事务
			ds = oCN.RunProcReturn("select * from Kf_ICStockBillMain a inner join Kf_ICStockBillSub b on a.HInterID=b.HInterID where a.HInterID= '"+ Hmainid+"'", "Kf_ICStockBillMain");
			dss = oCN.RunProcReturn("exec h_p_Cg_POInStockBillMain " + HQty + ", '" + HSourceInterID + "', '" + HSourceEntryID + "','" + user + " '", "h_p_Cg_POInStockBillMain");
			dss = oCN.RunProcReturn("exec h_p_Cg_POInStockBillMain_Delete " + HQty + ", '" + HSourceInterID + "', '" + HSourceEntryID + "','" + user + " '", "h_p_Cg_POInStockBillMain_Delete");
			var sReturn = "";
			if (DBUtility.ClsPub.isLong(dss.Tables[0].Rows[0]["HBack"]) != 0)
			{

			@@ -356,14 +356,15 @@
			",'" + HERPBillType + "'," + HDFflag + ")";

			oCN.RunProc(sql);

			}
			else if (OperationType == 3 \|\| ds.Tables[0].Rows.Count != 0)
			{ //修改
			string sql = $@"update Xs_SeOutStockBillMain set " +
			"HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" +
			",HCurID=" + HCurID + ", HWHID = " + HWHID
			+ ",HExRate=" + HExRate + ",HEmpID=" + HEmpID + ",HSeOrderBillNo_M=" + HSeOrderBillNo_M + ",HManagerID=" + HManagerID + ",HDeptID=" + HDeptID + ",HOWNERID=" + HOWNERID
			+ ",HAddress='" + HAddress + "'where HInterID=" + HInterID;
			"HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" +
			",HCusID='" + HCusID + "', HCurID='" + HCurID + "', HWHID = '" + HWHID
			+ "',HExRate='" + HExRate + "',HEmpID='" + HEmpID + "',HSeOrderBillNo_M='" + HSeOrderBillNo_M + "',HManagerID='" + HManagerID + "',HDeptID='" + HDeptID + "',HOWNERID='" + HOWNERID
			+ "',HAddress='" + HAddress + "' where HInterID=" + HInterID;
			oCN.RunProc(sql);

			//删除子表

	WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs	9 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史