MES-WEB-API.git

			@@ -928,14 +928,15 @@
			WebS.ClsXt_SystemParameterMain oSystemParameterMain = new WebS.ClsXt_SystemParameterMain();
			string text = "";
			string text1 = "";
			bool flag = HBillType == "1201";
			//gy_billnumber 单据类型表
			bool flag = HBillType == "1201"; //WMS 采购入库
			if (flag)
			{
			string[] array = sBarCodeNew.Split(new char[]
			{
			'@'
			});
			string str = array[0];
			string str = array[0]; //物料代码
			long num = (long)ClsPub.isInt(array[4]);
			string text2 = array[6];
			DateTime dateTime = ClsPub.isDate(array[3]);
			@@ -946,11 +947,12 @@
			string str3 = ClsPub.isStrNull(dataSet.Tables[0].Rows[0]["HNumber"]);



			//用拆分出来的物料代码查询物料表里的新物料编码
			DataSet Dss7;
			Dss7 = clsCN.RunProcReturn(" select * from AIS20220914133941..T_BD_MATERIAL where FNumber = '" + str + "'", "T_BD_MATERIAL");
			if (Dss7 == null \|\| Dss7.Tables[0].Rows.Count == 0)
			{
			//新物料表里没有返回数据则查询物料表里的旧物料编码
			DataSet Dss8;
			Dss8 = clsCN.RunProcReturn(" select * from AIS20220914133941..T_BD_MATERIAL where FOldNumber = '" + str + "'", "T_BD_MATERIAL");
			str = DBUtility.ClsPub.isStrNull(Dss8.Tables[0].Rows[0]["FNumber"]);
			@@ -968,6 +970,7 @@
			long num3 = (long)ClsPub.isInt(dataSet2.Tables[0].Rows[0]["HUnitID"]);
			text = str3 + num2.ToString() + text2 + "#" + num;
			text1 = str3 + num2.ToString() + text2;
			//找源单
			DataSet dataSet3 = clsCN.RunProcReturn(" select fid,FMATERIALID,FENTRYID,FBILLNO from h_v_RECEIVEQuery where FSRCBILLNO= '" + str2 + "' and FLOT_TEXT = '" + text2 + "' and FMATERIALID = " + num2.ToString(), "h_v_RECEIVEQuery");
			//DataSet dataSet3 = clsCN.RunProcReturn(" select fid,FMATERIALID,FENTRYID,FBILLNO from h_v_RECEIVEQuery where FLOT_TEXT= '" + text2 + "' and FPRODUCEDATE = '" + dateTime + "' and FMATERIALID = " + num2.ToString(), "h_v_RECEIVEQuery");
			num2 = ClsPub.isLong(dataSet3.Tables[0].Rows[0]["FMATERIALID"]);
			@@ -980,6 +983,7 @@
			{
			DataSet dataSet5 = clsCN.RunProcReturn(string.Concat(new string[]
			{
			//扫码临时记录表
			" select * from KF_PonderationBillMain_Temp where HInterID = ",
			hinterid.ToString(),
			" and HBillType = '",
			@@ -991,11 +995,12 @@
			bool flag3 = dataSet5.Tables[0].Rows.Count > 0;
			if (!flag3)
			{
			POStockInBillController postockInBillController = new POStockInBillController();
			postockInBillController.set_SavePonderationBillMain_Temp_Source_Fast_Json("1103", text5, hinterid, HBillNo);
			//POStockInBillController postockInBillController = new POStockInBillController();
			////扫源单方法
			//postockInBillController.set_SavePonderationBillMain_Temp_Source_Fast_Json("1103", text5, hinterid, HBillNo);

			//WEBSController webscontroller4 = new WEBSController();
			//object obj4 = webscontroller4.Get_SourceBarCode_PoStockIn_Json(hinterid, HBillNo, HBillType, text5, "1103", HMaker, HOrgID,1, oSystemParameterMain, ref DBUtility.ClsPub.sErrInfo);
			WEBSController webscontroller4 = new WEBSController();
			object obj4 = webscontroller4.get_SourceBarCode_POStockIn_Json(hinterid, HBillNo, HBillType, text5, "1103", HMaker, HOrgID);



			@@ -1061,12 +1066,15 @@
			bool flag4 = dataSet6.Tables[0].Rows.Count > 0;
			if (!flag4)
			{
			POStockInBillController postockInBillController2 = new POStockInBillController();
			postockInBillController2.set_SavePonderationBillMain_Temp_Source_Fast_Json("1103", text5, hinterid, HBillNo);
			//POStockInBillController postockInBillController2 = new POStockInBillController();
			//postockInBillController2.set_SavePonderationBillMain_Temp_Source_Fast_Json("1103", text5, hinterid, HBillNo);

			WEBSController webscontroller4 = new WEBSController();
			object obj4 = webscontroller4.get_SourceBarCode_POStockIn_Json(hinterid, HBillNo, HBillType, text5, "1103", HMaker, HOrgID);
			}
			}
			}
			bool flag5 = HBillType == "1202";
			bool flag5 = HBillType == "1202"; //WMS 生产入库
			if (flag5)
			{
			string text6 = sBarCodeNew.Remove(0, sBarCodeNew.Length - 4);
			@@ -1074,14 +1082,14 @@
			bool flag6 = text7.Contains("W") \|\| text7.Contains("N");
			if (flag6)
			{
			string text8 = sBarCodeNew.Substring(0, 10);
			string str4 = sBarCodeNew.Substring(10, 10);
			string text8 = sBarCodeNew.Substring(0, 10);//商品码商品码+物料代码+生产日期+批次+失效日期+一位字母+三位数字
			string str4 = sBarCodeNew.Substring(10, 10);//物料代码
			string text9 = "20" + sBarCodeNew.Substring(20, 6);
			long num8 = (long)ClsPub.isInt(text9.Substring(0, 4));
			long num9 = (long)ClsPub.isInt(text9.Substring(4, 2));
			long num10 = (long)ClsPub.isInt(text9.Substring(6, 2));
			long num11 = (long)ClsPub.isInt(sBarCodeNew.Remove(0, sBarCodeNew.Length - 3));
			string text10 = sBarCodeNew.Remove(0, sBarCodeNew.Length - 10);
			long num8 = (long)ClsPub.isInt(text9.Substring(0, 4)); //年
			long num9 = (long)ClsPub.isInt(text9.Substring(4, 2)); //月
			long num10 = (long)ClsPub.isInt(text9.Substring(6, 2)); //日
			long num11 = (long)ClsPub.isInt(sBarCodeNew.Remove(0, sBarCodeNew.Length - 3));//后三位永远都是数字
			string text10 = sBarCodeNew.Remove(0, sBarCodeNew.Length - 10);//失效日期+一位字母+三位数字
			string text11 = "20" + text10.Substring(0, 6);
			long num12 = (long)ClsPub.isInt(text11.Substring(0, 4));
			long num13 = (long)ClsPub.isInt(text11.Substring(4, 2));
			@@ -1236,7 +1244,8 @@
			}
			else
			{
			string str6 = sBarCodeNew.Substring(0, 10);
			/前十位物料代码，后六位生效日期，倒数前三位是数字前六位是失效日期 /
			string str6 = sBarCodeNew.Substring(0, 10);//物料代码
			string text17 = "20" + sBarCodeNew.Substring(10, 6);
			long num21 = (long)ClsPub.isInt(text17.Substring(0, 4));
			long num22 = (long)ClsPub.isInt(text17.Substring(4, 2));
			@@ -1255,9 +1264,9 @@
			"-",
			num27.ToString()
			}));
			string text20 = sBarCodeNew.Remove(0, 16);
			string text21 = text20.Remove(text20.Length - 9, 9);
			ClsCN clsCN3 = new ClsCN();
			string text20 = sBarCodeNew.Remove(0, 16); //SAE1300100 230309 2303704 250308 010
			string text21 = text20.Remove(text20.Length - 9 , 9); //SAE1300100230309 2303704 250308010
			ClsCN clsCN3 = new ClsCN();
			DataSet dataSet13 = clsCN3.RunProcReturn(" select HItemID,HName,HModel,HUnitID from Gy_Material where HNumber= '" + str6 + "' and huseorgid = " + HOrgID.ToString(), "Gy_Material");
			long num28 = ClsPub.isLong(dataSet13.Tables[0].Rows[0]["HItemID"]);
			string text22 = ClsPub.isStrNull(dataSet13.Tables[0].Rows[0]["HName"]);
			@@ -1292,7 +1301,7 @@
			"-",
			num23.ToString()
			}));
			DataSet dataSet16 = clsCN3.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + text1 + "'", "Gy_BarCodeBill");
			DataSet dataSet16 = clsCN3.RunProcReturn(" select * from Gy_BarCodeBill where HBarCode= '" + text1 + "'", "Gy_BarCodeBill");
			bool flag10 = dataSet16.Tables[0].Rows.Count > 0;
			if (flag10)
			{
			@@ -1317,6 +1326,7 @@
			}
			else
			{
			//可能和他们的登录组织有关系
			string billCode3 = "85";
			long num32 = ClsPub.CreateBillID_Prod(billCode3, ref ClsPub.sExeReturnInfo);
			long num33 = 0L;
			@@ -1381,7 +1391,7 @@
			}
			}
			}
			bool flag13 = HBillType == "1244";
			bool flag13 = HBillType == "1244"; //WMS 生产退料单
			if (flag13)
			{
			bool flag14 = sBarCodeNew.Contains("@");
			@@ -1672,7 +1682,7 @@
			}
			}
			}
			bool flag19 = HBillType == "1207";
			bool flag19 = HBillType == "1207"; //WMS 直接调拨
			if (flag19)
			{
			bool flag20 = sBarCodeNew.Contains("@");
			@@ -1947,7 +1957,7 @@
			}
			}
			}
			bool flag25 = HBillType == "1206";
			bool flag25 = HBillType == "1206"; //WMS 销售出库
			if (flag25)
			{
			bool flag26 = sBarCodeNew.Contains("@");
			@@ -2235,8 +2245,8 @@
			}
			}
			}
			}
			bool flag31 = HBillType == "1204";
			}
			bool flag31 = HBillType == "1204"; //WMS 生产领料
			if (flag31)
			{
			bool flag32 = sBarCodeNew.Contains("@");
			@@ -2526,7 +2536,7 @@
			}
			}
			}
			bool flag37 = HBillType == "1254" \|\| HBillType == "1211" \|\| HBillType == "1255";
			bool flag37 = HBillType == "1254" /生产补料/ \|\| HBillType == "1211" \|\| HBillType == "1255";
			if (flag37)
			{
			bool flag38 = sBarCodeNew.Contains("@");
			@@ -2815,7 +2825,7 @@
			}
			}
			}
			bool flag43 = HBillType == "1205";
			bool flag43 = HBillType == "1205";
			if (flag43)
			{
			bool flag44 = sBarCodeNew.Contains("@");
			@@ -3911,8 +3921,8 @@
			List<Model.ClsKf_POStockInBillMain> lsmain = new List<Model.ClsKf_POStockInBillMain>();
			ListModels oListModels = new ListModels();
			lsmain = oListModels.getPOStockInBillMainByJson(msg1);
			lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
			lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
			//lsmain[0].HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year);
			//lsmain[0].HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));
			string sSourceBillType = lsmain[0].HBillType;

			WebAPI.WebS.ClsKf_POStockInBillMain websLsmain = new WebS.ClsKf_POStockInBillMain();
			@@ -3944,7 +3954,8 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "成功！单据号为：";
			objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //成功！
			//objJsonResult.Message = "成功！单据号为：";
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -3952,7 +3963,8 @@
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo;
			objJsonResult.Message = DBUtility.ClsPub.sErrInfo; //失败！
			//objJsonResult.Message = "上传失败！" + DBUtility.ClsPub.sErrInfo;
			objJsonResult.data = null;
			return objJsonResult;
			}
			@@ -4301,6 +4313,14 @@
			{
			DataSet dataSet = this.oCn.RunProcReturn("exec h_p_ReceiveBill_Fast " + hinterID, "h_p_ReceiveBill_Fast");
			DataRow dataRow = dataSet.Tables[0].Rows[0];
			if (dataSet.Tables[0].Rows.Count == 1 && dataSet.Tables[0].Rows[0]["FRECEIVENumber"].ToString() == "0")
			{
			this.objJsonResult.code = "0";
			this.objJsonResult.count = 0;
			this.objJsonResult.Message = "存在多个采购订单单据类型，不允许提交！";
			this.objJsonResult.data = null;
			return this.objJsonResult;
			}
			bool flag4 = dataSet.Tables[0].Rows.Count <= 0;
			bool flag5 = flag4;
			bool flag6 = flag5;
			@@ -4419,6 +4439,7 @@
			jobject16.Add("FSRCENTRYID", dataRow2["FENTRYID"].ToString());
			jobject16.Add("FORDERBILLNO", dataRow2["FBILLNO"].ToString());
			jobject16.Add("FPOORDERENTRYID", dataRow2["FENTRYID"].ToString());
			jobject16.Add("FGiveAway", dataRow2["FGIVEAWAY"].ToString());//是否赠品
			//jobject16.Add("FPrice", dataRow2["FPRICE"].ToString());
			//jobject16.Add("FTaxPrice", dataRow2["FTAXPRICE"].ToString());
			//jobject16.Add("FEntryTaxRate", dataRow2["FTAXRATE"].ToString());
			@@ -5040,6 +5061,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
			,C.FGIVEAWAY AS FGIVEAWAY
			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
			@@ -5123,6 +5145,7 @@
			FentityModel.Add("FPrice", item["FPRICE"].ToString());//单价
			FentityModel.Add("FTaxPrice", item["FTAXPRICE"].ToString());//含税单价
			FentityModel.Add("FEntryTaxRate", item["FTAXRATE"].ToString());//税率
			FentityModel.Add("FGiveAway", item["FGIVEAWAY"].ToString());//是否赠品

			JArray Fentity2 = new JArray();
			JObject FentityModel2 = new JObject();
			@@ -5294,6 +5317,82 @@

			}

			[Route("POStockInBillList/AuditPOInStockBillPost_TianKang")]
			[HttpPost]
			public object AuditPOInStockBill_TianKang([FromBody] JObject msg)
			{
			try
			{
			string _msg = msg["msg"].ToString();
			_msg = _msg.Replace("\\", "");
			_msg = _msg.Replace("\n", "");
			List<Models.ReciveBill_FastModel> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ReciveBill_FastModel>>(_msg);
			DAL.ClsCg_POInStockBill oBill = new DAL.ClsCg_POInStockBill();
			var hinterID = list[0].HInterID;
			var FID = list[0].FID;
			string FCusName = oSystemParameter.GetSingleSystemParameter("WMS_CampanyName", ref DBUtility.ClsPub.sExeReturnInfo);//客户名称
			var kdTbaleName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");
			string sql = string.Empty;

			var json = new
			{
			Ids = FID,
			};
			//LogService.Write(json);
			//登录
			var loginRet = InvokeHelper.Login();
			var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>();
			if (isSuccess <= 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = loginRet;
			objJsonResult.data = null;
			return objJsonResult;
			}
			//提交
			var _result = InvokeHelper.Submit("PUR_ReceiveBill", JsonConvert.SerializeObject(json));
			var _saveObj = JObject.Parse(_result);
			if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
			{
			LogService.Write("收料通知单提交失败jsonRoot:" + json.ToString());
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "金蝶收料通知单提交失败" + _result;
			objJsonResult.data = null;
			return objJsonResult;

			}
			//审核
			_result = InvokeHelper.Audit("PUR_ReceiveBill", JsonConvert.SerializeObject(json));
			_saveObj = JObject.Parse(_result);
			if (_saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE")
			{
			LogService.Write("收料通知单审核失败jsonRoot:" + json.ToString());
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "金蝶收料通知单审核失败jsonRoot" + _result;
			objJsonResult.data = null;
			return objJsonResult;

			}
			objJsonResult.code = "1";
			objJsonResult.count = 1;
			objJsonResult.Message = "操作成功！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			catch (Exception e)
			{
			//oCn.RollBack();
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "异常！" + e.ToString();
			objJsonResult.data = null;
			return objJsonResult;
			}
			}

			/// <summary>
			/// 到货确认扫条码校验
			/// </summary>
			@@ -5312,9 +5411,11 @@
			string sql = string.Empty;
			if (FCusName.Contains("安瑞"))
			sql = $"select top 1 HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID from Gy_BarCodeBill where HSourceInterID =(select distinct HSourceInterID from Cg_POInStockBillSub where HInterID ={HInterID}) and HBarCode = '{HBarcode}' and HBarCodeType ='箱号内条码'";
			else if(FCusName.Contains("添康科技"))
			sql = $"select top 1 HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID,HMaterID,HBatchNo,HProduceDate,HExpiryDate from Gy_BarCodeBill where HSourceInterID = {HInterID} and HBarCode = '{HBarcode}' and HBarCodeType ='箱号内条码'";
			else
			sql = $"select HItemID,HSourceBillNo,HQty,HSourceInterID,HSourceEntryID from Gy_BarCodeBill where HSourceInterID ={HInterID} and HBarCode = '{HBarcode.Split('#')[0]}' and HQty = {HBarcode.Split('#')[1]}";
			DataSet ds = oCn.RunProcReturn(sql, "H_v_SRM_POOrderBillList");
			DataSet ds = oCn.RunProcReturn(sql, "Gy_BarCodeBill");
			if (ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";