MES-WEB-API.git

			@@ -49,6 +49,7 @@
			public ClsKF_PonderationBillMain_Temp model =new ClsKF_PonderationBillMain_Temp();
			public ClsKf_ICStockBill_WMS oBar = new Model.ClsKf_ICStockBill_WMS();
			public double sRelQty = 0;
			SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
			// private DataBaseServices objDataBaseServices = new DataBaseServices();

			private JsonResult objJsonResult = new JsonResult();
			@@ -789,5 +790,125 @@

			}


			#region 到货点数
			[Route("POStockInBillList/get_InfoByBillNo")]
			[HttpGet]
			public object get_InfoByBillNo(string HBillno)
			{
			try
			{
			string sqlwhere = " where 1=1 ";
			if (!String.IsNullOrEmpty(HBillno))
			sqlwhere += "and 单据号='" + HBillno + "'";
			string sql = $"select * from h_v_Cg_POInStockBillList {sqlwhere} ";
			ds = oCn.RunProcReturn(sql, "h_v_Cg_POInStockBillList");
			if (ds == null \|\| ds.Tables[0].Rows.Count == 0)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "没有返回任何记录！";
			objJsonResult.data = null;
			return objJsonResult;
			}
			else
			{
			objJsonResult.code = "0";
			objJsonResult.count = 1;
			objJsonResult.Message = "Sucess！";
			objJsonResult.data = ds.Tables[0];
			return objJsonResult;
			}
			}
			catch (Exception)
			{
			objJsonResult.code = "0";
			objJsonResult.count = 0;
			objJsonResult.Message = "失败！";
			objJsonResult.data = null;
			return objJsonResult;
			}

			}

			//[Route("POStockInBillList/confirm")]
			//public object confirm(string hmainid)
			//{
			// try
			// {
			// JObject model = new JObject();
			// model.Add("FBILLTYPEID", new JObject() { ["Fnumber"] = "SLD01_SYS" }); //单据类型
			// model.Add("FDate", DateTime.Now.ToString("yyyy-MM-dd")); //通知日期
			// model.Add("FStockOrgId", new JObject() { ["Fnumber"] = (this.Model.GetValue("FHPURCHASEORGID") as DynamicObject)?["Number"].ToString() ?? "" }); // 收料组织
			// model.Add("FPurOrgId", new JObject() { ["Fnumber"] = (this.Model.GetValue("FHPURCHASEORGID") as DynamicObject)?["Number"].ToString() ?? "" }); //采购组织
			// model.Add("FSupplierId", new JObject() { ["Fnumber"] = (this.Model.GetValue("FSupplierID") as DynamicObject)?["Number"].ToString() ?? "" }); //供应商
			// model.Add("FOwnerTypeIdHead", "BD_OwnerOrg");// 货主类型
			// model.Add("FOwnerIdHead", new JObject() { ["Fnumber"] = (this.Model.GetValue("FHPURCHASEORGID") as DynamicObject)?["Number"].ToString() ?? "" });//货主
			// //子表数据模型
			// JArray Fentity = new JArray();
			// foreach (var item in entityRows)
			// {
			// if (Convert.ToBoolean(item["FCloseStatus"]))
			// continue;
			// JObject FentityModel = new JObject();
			// FentityModel.Add("FMaterialId", new JObject() { ["Fnumber"] = (item["FHMaterID"] as DynamicObject)?["Number"].ToString() ?? "" }); // 物料编码
			// FentityModel.Add("FUnitID", new JObject() { ["Fnumber"] = (item["FUnitID"] as DynamicObject)?["Number"].ToString() ?? "" }); // 单位
			// FentityModel.Add("FPreDeliveryDate", this.Model.GetValue("FHDate").ToString()); //预计到货日期
			// FentityModel.Add("FPriceUnitId", new JObject() { ["Fnumber"] = (item["FUnitID"] as DynamicObject)?["Number"].ToString() ?? "" }); // 计价单位
			// FentityModel.Add("FStockUnitID", new JObject() { ["Fnumber"] = (item["FUnitID"] as DynamicObject)?["Number"].ToString() ?? "" }); // 库存单位
			// FentityModel.Add("FActReceiveQty", Convert.ToDecimal(item["FHQty"]) - Convert.ToDecimal(item["FReciveCount"])); // 供应商送货数量（提料计划数量 - 已生成送货单数量）
			// FentityModel.Add("FOwnerTypeId", "BD_OwnerOrg");//货主类型
			// FentityModel.Add("FOwnerID", new JObject() { ["Fnumber"] = (this.Model.GetValue("FHPURCHASEORGID") as DynamicObject)?["Number"].ToString() ?? "" });//货主
			// FentityModel.Add("FSrcId", item["FHPOOrderInterID"].ToString());//源单内码
			// FentityModel.Add("FSRCFORMID", "PUR_PurchaseOrder");//源单类型
			// FentityModel.Add("FSrcBillNo", item["FHPOOrderBillNo"].ToString());//源单单号
			// FentityModel.Add("FSRCENTRYID", item["FHPOOrderEntryID"].ToString());//源单分录内码
			// FentityModel.Add("FORDERBILLNO", item["FHPOOrderBillNo"].ToString());//源单单号
			// FentityModel.Add("FPOORDERENTRYID", item["FHPOOrderEntryID"].ToString());//源单分录内码


			// JArray Fentity2 = new JArray();
			// JObject FentityModel2 = new JObject();
			// FentityModel2.Add("FDetailEntity_Link_FRULEID", "a8c6b6e5-a8c0-4fc1-8592-6b76c2136cf9");
			// FentityModel2.Add("FDetailEntity_Link_FSTableName", "t_PUR_POOrderEntry");
			// FentityModel2.Add("FDetailEntity_Link_FSBillId", item["FHPOOrderInterID"].ToString());
			// FentityModel2.Add("FDetailEntity_Link_FSId", item["FHPOOrderEntryID"].ToString());
			// Fentity2.Add(FentityModel2);
			// FentityModel.Add("FDetailEntity_Link", Fentity2);
			// Fentity.Add(FentityModel);
			// }
			// model.Add("FDetailEntity", Fentity); //明细信息

			// JObject _FentityModel = new JObject();
			// _FentityModel.Add("FSettleOrgId", new JObject() { ["Fnumber"] = (this.Model.GetValue("FHPURCHASEORGID") as DynamicObject)?["Number"].ToString() ?? "" }); // 结算组织
			// _FentityModel.Add("FSettleCurrId", new JObject() { ["Fnumber"] = (this.Model.GetValue("FSettleCurrId") as DynamicObject)?["Number"].ToString() ?? "" }); // 结算币别
			// _FentityModel.Add("FPricePoint", 0); // 定价时点
			// model.Add("FinanceEntity ", _FentityModel);//财务信息
			// JObject jsonRoot = new JObject()
			// {
			// ["Creator"] = "",
			// ["NeedUpDateFields"] = new JArray(),
			// ["NeedReturnFields"] = new JArray(),
			// ["IsDeleteEntry"] = "false",
			// ["SubSystemId"] = "",
			// ["IsVerifyBaseDataField"] = "false",
			// //["IsAutoSubmitAndAudit"] = true,//自动调用提交和审核功能
			// ["Model"] = model
			// };
			// var result = cloudClient.Save("PUR_ReceiveBill", jsonRoot.ToString());
			// JObject saveObj = JObject.Parse(result);
			// string saveIsSuc = saveObj["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper();
			// }
			// catch (Exception)
			// {
			// objJsonResult.code = "0";
			// objJsonResult.count = 0;
			// objJsonResult.Message = "失败！";
			// objJsonResult.data = null;
			// return objJsonResult;
			// }

			//}
			#endregion
			}
			}