SRM-WEBAPI.git - Gitblit

			@@ -10,6 +10,7 @@
			using System.Linq;
			using System.Net;
			using System.Net.Http;
			using System.Text.RegularExpressions;
			using System.Web;
			using System.Web.Http;
			using WebAPI.Code;
			@@ -358,8 +359,43 @@
			int i = 0;
			foreach (Model.ClsCg_POInStockBillSub oItemSub in ls)
			{
			//判断采购订单状态
			objJsonResult = TestPOOrder(oItemSub.HPOOrderEntryID.ToString());
			if (FCusName.Contains("凯贝奈特")) //系统参数客户定制化名称空白为通用
			{
			if (oItemSub.HBatChNo.Length < 8 \|\| Regex.IsMatch(oItemSub.HBatChNo, @"^[0-9]+$") == false)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！第" + i.ToString() + "行生产日期D/C 格式错误无法保存！正确格式为8位数的纯数字日期";
			objJsonResult.data = 1;
			return objJsonResult;
			}

			//获取年月日
			string year = oItemSub.HBatChNo.Substring(0, 4);
			string month = oItemSub.HBatChNo.Substring(4, 2);
			string day = oItemSub.HBatChNo.Substring(6, 2);

			//验证合法性
			if (Convert.ToInt32(year) < 1900 \|\| Convert.ToInt32(year) > 2100)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！第" + i.ToString() + "行生产日期D/C 日期不合法无法保存！正确格式为8位数的纯数字日期";
			objJsonResult.data = 1;
			return objJsonResult;
			}
			if (Convert.ToInt32(month) > 12 \|\| Convert.ToInt32(day) > 31)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "保存失败！第" + i.ToString() + "行生产日期D/C 日期不合法无法保存！";
			objJsonResult.data = 1;
			return objJsonResult;
			}

			}
			//判断采购订单状态
			objJsonResult = TestPOOrder(oItemSub.HPOOrderEntryID.ToString());
			if (objJsonResult.code == "0")
			return objJsonResult;
			//增加判断送货数量超出采购订单数量
			@@ -780,7 +816,7 @@
			,D.FSUPPLIERID,DS.FNUMBER AS FSUPPLIERNUMBER,D.FPURCHASEORGID,DOO.FNUMBER AS FPURCHASEORGNUMBER,CROO.FNUMBER AS FSETTLEORGNUMBER,
			E.FPRICETIMEPOINT,E.FSETTLECURRID,EC.FNUMBER AS FSETTLECURRNUMBER,C.FMATERIALID,CM.FNUMBER AS FMATERIALNUMBER ,C.FUNITID
			,CU.FNUMBER AS FUNITNUMBER,CR.FPRICE,CR.FTAXPRICE,CR.FTAXRATE,D.FPURCHASERID,isnull(T4.FNUMBER,'') AS FPURCHASERNUMBER
			,B.HExpressNumberSub,B.HExpressSupplierSub,B.HRemark,B.HPlanArrivalDate,B.HBoxNumber
			,B.HExpressNumberSub,B.HExpressSupplierSub,B.HRemark,B.HPlanArrivalDate,B.HBoxNumber,B.HBatChNo,D.FBILLTYPEID
			FROM CG_POINSTOCKBILLSUB B
			JOIN CG_POINSTOCKBILLMAIN M ON B.HINTERID = M.HINTERID
			JOIN {0}..T_PUR_POORDERENTRY C ON B.HSOURCEINTERID = C.FID AND B.HSOURCEENTRYID = C.FENTRYID
			@@ -830,6 +866,24 @@
			fTypeName = "SLD04_SYS";
			ywTypeName = "ZCCG";
			}
			if (FCusName == "凯贝奈特")
			{
			//1厂
			if (dr["FBILLTYPEID"].ToString() == "60cfe60fa16dd8")
			{
			fTypeName = "SLD08_SYS";
			}
			//2厂
			if (dr["FBILLTYPEID"].ToString() == "60cfe634a1708f")
			{
			fTypeName = "SLD09_SYS";
			}
			//3厂
			if (dr["FBILLTYPEID"].ToString() == "83d822ca3e374b4ab01e5dd46a0062bd")
			{
			fTypeName = "SLD01_SYS";
			}
			}
			model.Add("FBILLTYPEID", new JObject() { ["Fnumber"] = fTypeName }); //单据类型
			model.Add("FBusinessType", ywTypeName); //业务类型
			model.Add("FBILLNO", dr["HBillNo"].ToString()); //单据编号
			@@ -863,6 +917,7 @@
			FentityModel.Add("FPrice", item["FPRICE"].ToString());//单价
			FentityModel.Add("FTaxPrice", item["FTAXPRICE"].ToString());//含税单价
			FentityModel.Add("FEntryTaxRate", item["FTAXRATE"].ToString());//税率
			FentityModel.Add("FLot", new JObject() { ["Fnumber"] = item["HBatChNo"].ToString() }); // 批号

			FentityModel.Add("F_bsv_Text1", item["HExpressSupplierSub"].ToString());//物流单位 (瑞琪)
			FentityModel.Add("F_bsv_Text2", item["HExpressNumberSub"].ToString());//物流单号 (瑞琪)
			@@ -1208,8 +1263,8 @@
			}

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