TigerClouds-Tech/Server/TigerApi6_2024.git

			@@ -64,127 +64,138 @@
			}

			//保存成功，调用U9C接口-测试用
			int i = 1;
			List<BIZ_ERP_PROD_IN_BTH> ErpProdInBths = new List<BIZ_ERP_PROD_IN_BTH>();
			foreach (var item in input.RcvRptDocBases.Where(q => q.Status != "Y"))
			{
			var ErpProdInBth = Biz.Db.Queryable<BIZ_ERP_PROD_IN_BTH>().Where(q => q.WORK_ORDER == item.WorkOrder).First();
			item.Status = "Y";
			if (!ErpProdInBth.IsNullOrEmpty())
			{
			ErpProdInBth.ORDER_NO = $"XX001-{i}";
			ErpProdInBth.IS_HANDLED = "Y";
			ErpProdInBth.HANDLED_DATE = DateTime.Now;
			ErpProdInBths.Add(ErpProdInBth);
			}
			foreach (var p in input.PrintJsons)
			{
			var d = p.Items.Where(q => q.WORK_ORDER == item.WorkOrder).FirstOrDefault();
			if (!d.IsNullOrEmpty())
			{
			d.ORDER_NO = $"XX001-{i}";
			d.STATUS = "Y";
			}
			}
			i++;
			}
			var _db = Biz.Db;
			var _dbTran = _db.UseTran(() =>
			{
			_db.Updateable(ErpProdInBths, "U9C_RcvRptDocCreate").UpdateColumns(x => new { x.ORDER_NO, x.REMARK, x.IS_HANDLED, x.HANDLED_DATE }).ExecuteCommand();
			});
			if (!dbTran.IsSuccess)
			{
			action.CatchExceptionWithLog(dbTran.ErrorException, $"数据处理失败");
			Logger.Interface.Error(action.Message);
			IsSuccessed = false;
			}
			input.ErpProdInBths = ErpProdInBths;
			//int i = 1;
			//List<BIZ_ERP_PROD_IN_BTH> ErpProdInBths = new List<BIZ_ERP_PROD_IN_BTH>();
			//foreach (var item in input.RcvRptDocBases.Where(q => q.Status != "Y"))
			//{
			// var ErpProdInBth = Biz.Db.Queryable<BIZ_ERP_PROD_IN_BTH>().Where(q => q.WORK_ORDER == item.WorkOrder).First();
			// item.Status = "Y";
			// if (!ErpProdInBth.IsNullOrEmpty())
			// {
			// ErpProdInBth.ORDER_NO = $"XX001-{i}";
			// ErpProdInBth.IS_HANDLED = "Y";
			// ErpProdInBth.HANDLED_DATE = DateTime.Now;
			// ErpProdInBths.Add(ErpProdInBth);
			// }
			// foreach (var p in input.PrintJsons)
			// {
			// var d = p.Items.Where(q => q.WORK_ORDER == item.WorkOrder).FirstOrDefault();
			// if (!d.IsNullOrEmpty())
			// {
			// d.ORDER_NO = $"XX001-{i}";
			// d.STATUS = "Y";
			// }
			// }
			// i++;
			//}
			//var _db = Biz.Db;
			//var _dbTran = _db.UseTran(() =>
			//{
			// _db.Updateable(ErpProdInBths, "U9C_RcvRptDocCreate").UpdateColumns(x => new { x.ORDER_NO, x.REMARK, x.IS_HANDLED, x.HANDLED_DATE }).ExecuteCommand();
			//});
			//if (!dbTran.IsSuccess)
			//{
			// action.CatchExceptionWithLog(dbTran.ErrorException, $"数据处理失败");
			// Logger.Interface.Error(action.Message);
			// IsSuccessed = false;
			//}
			//input.ErpProdInBths = ErpProdInBths;

			//保存成功，调用U9C接口
			//if (IsSuccessed)
			//{
			// var u9CLoginResult = await HttpHelper.GetAsync<U9CLoginResult>($"{U9CAuthLoginUrl}userCode=admin{secret}");
			// if (u9CLoginResult.Success)
			// {
			// var token = u9CLoginResult.Data;
			// Logger.Interface.Info($"U9C登录token: {token}");
			// List<BIZ_ERP_PROD_IN_BTH> ErpProdInBths = new List<BIZ_ERP_PROD_IN_BTH>();
			// foreach (var item in input.RcvRptDocBases.Where(q=>q.Status != "Y"))
			// {
			// List<RcvRptDocCreateParam> param = new() {
			// new() {
			// CompleteList = new(){
			// new CompleteList
			// {
			// MOKey = new MOKey { DocNo = item.WorkOrder },
			// Wh = new Wh { Code = item.WhCode },
			// DescFlexField = new DescFlexField { PrivateDescSeg1 = item.PkgQty.ToString() },
			// Item = new Item { Code = item.ItemCode },
			// CompleteQty = item.CompleteQty,
			// OutputType = item.OutputType,
			// StorageType = item.StorageType,
			// DocState = item.DocState,
			// }
			// }
			// }
			// };
			// var response = await HttpHelper.PostAsync(RcvRptDocCreateUrl, JsonConvert.SerializeObject(param), new Dictionary<string, string>() { { "token", token } });
			// var result = JsonConvert.DeserializeObject<U9CResult>(response.Message);
			// var ErpProdInBth = Biz.Db.Queryable<BIZ_ERP_PROD_IN_BTH>().Where(q => q.WORK_ORDER == item.WorkOrder).First();
			// if (result != null)
			// {
			// if (result.Success && result.Data[0].m_isSucess)
			// {
			// Logger.Interface.Info($"生成入库单接口提交Json: {JsonConvert.SerializeObject(param)}，返回Json: {response.Message}");
			// item.Status = "Y";
			// if (!ErpProdInBth.IsNullOrEmpty())
			// {
			// ErpProdInBth.ORDER_NO = result.Data[0].m_code;
			// ErpProdInBth.IS_HANDLED = "Y";
			// ErpProdInBth.HANDLED_DATE = DateTime.Now;
			// ErpProdInBths.Add(ErpProdInBth);
			// }
			// foreach (var p in input.PrintJsons)
			// {
			// var d = p.Items.Where(q => q.WORK_ORDER == item.WorkOrder).FirstOrDefault();
			// if (!d.IsNullOrEmpty())
			// {
			// d.ORDER_NO = result.Data[0].m_code;
			// }
			// }
			// Logger.Interface.Info($"生成入库单成功");
			// }
			// else
			// {
			// action.IsSuccessed = false;
			// action.LocaleMsg = new($"{action.Message}; {result.Data[0].m_errorMsg}");
			// item.Status = "F";
			// if (!ErpProdInBth.IsNullOrEmpty())
			// {
			// ErpProdInBth.REMARK = result.Data[0].m_errorMsg;
			// ErpProdInBth.IS_HANDLED = "F";
			// ErpProdInBth.HANDLED_DATE = DateTime.Now;
			// ErpProdInBths.Add(ErpProdInBth);
			// }
			// Logger.Interface.Info($"生成入库单失败:{result.Data[0].m_errorMsg}");
			// }
			// }
			// }
			// var _db = Biz.Db;
			// var _dbTran = _db.UseTran(() =>
			// {
			// _db.Updateable(ErpProdInBths, "U9C_RcvRptDocCreate").UpdateColumns(x => new { x.ORDER_NO, x.REMARK, x.IS_HANDLED, x.HANDLED_DATE }).ExecuteCommand();
			// });
			// if (!dbTran.IsSuccess)
			// {
			// action.CatchExceptionWithLog(dbTran.ErrorException, $"数据处理失败");
			// Logger.Interface.Error(action.Message);
			// IsSuccessed = false;
			// }
			// input.ErpProdInBths = ErpProdInBths;
			// }
			//}
			if (IsSuccessed)
			{
			var u9CLoginResult = await HttpHelper.GetAsync<U9CLoginResult>($"{U9CAuthLoginUrl}userCode=admin{secret}");
			if (u9CLoginResult.Success)
			{
			var token = u9CLoginResult.Data;
			Logger.Interface.Info($"U9C登录token: {token}");
			List<BIZ_ERP_PROD_IN_BTH> ErpProdInBths = new List<BIZ_ERP_PROD_IN_BTH>();
			foreach (var item in input.RcvRptDocBases.Where(q => q.Status != "Y"))
			{
			List<RcvRptDocCreateParam> param = new() {
			new() {
			CompleteList = new(){
			new CompleteList
			{
			MOKey = new MOKey { DocNo = item.WorkOrder },
			Wh = new Wh { Code = item.WhCode },
			DescFlexField = new DescFlexField { PrivateDescSeg1 = item.PkgQty.ToString() },
			Item = new Item { Code = item.ItemCode },
			CompleteQty = item.CompleteQty,
			OutputType = item.OutputType,
			StorageType = item.StorageType,
			DocState = item.DocState,
			}
			}
			}
			};
			var response = await HttpHelper.PostAsync(RcvRptDocCreateUrl, JsonConvert.SerializeObject(param), new Dictionary<string, string>() { { "token", token } });
			var result = JsonConvert.DeserializeObject<U9CResult>(response.Message);
			var ErpProdInBth = Biz.Db.Queryable<BIZ_ERP_PROD_IN_BTH>().Where(q => q.WORK_ORDER == item.WorkOrder).First();
			if (result != null)
			{
			if (result.Success && result.Data[0].m_isSucess)
			{
			Logger.Interface.Info($"生成入库单接口提交Json: {JsonConvert.SerializeObject(param)}，返回Json: {response.Message}");
			item.Status = "Y";
			if (!ErpProdInBth.IsNullOrEmpty())
			{
			ErpProdInBth.ORDER_NO = result.Data[0].m_code;
			ErpProdInBth.IS_HANDLED = "Y";
			ErpProdInBth.HANDLED_DATE = DateTime.Now;
			ErpProdInBths.Add(ErpProdInBth);
			}
			foreach (var p in input.PrintJsons)
			{
			var d = p.Items.Where(q => q.WORK_ORDER == item.WorkOrder && q.STATUS !="P").FirstOrDefault();
			if (!d.IsNullOrEmpty())
			{
			d.ORDER_NO = result.Data[0].m_code;
			d.STATUS = "Y";
			}
			}
			Logger.Interface.Info($"生成入库单成功");
			}
			else
			{
			action.IsSuccessed = false;
			action.LocaleMsg = new($"{action.Message}; {result.Data[0].m_errorMsg}");
			item.Status = "F";
			if (!ErpProdInBth.IsNullOrEmpty())
			{
			ErpProdInBth.REMARK = result.Data[0].m_errorMsg;
			ErpProdInBth.IS_HANDLED = "F";
			ErpProdInBth.HANDLED_DATE = DateTime.Now;
			ErpProdInBths.Add(ErpProdInBth);
			}
			foreach (var p in input.PrintJsons)
			{
			var d = p.Items.Where(q => q.WORK_ORDER == item.WorkOrder && q.STATUS != "P").FirstOrDefault();
			if (!d.IsNullOrEmpty())
			{
			d.ORDER_NO = result.Data[0].m_code;
			d.STATUS = "F";
			}
			}
			Logger.Interface.Info($"生成入库单失败:{result.Data[0].m_errorMsg}");
			}
			}
			}
			var _db = Biz.Db;
			var _dbTran = _db.UseTran(() =>
			{
			_db.Updateable(ErpProdInBths, "U9C_RcvRptDocCreate").UpdateColumns(x => new { x.ORDER_NO, x.REMARK, x.IS_HANDLED, x.HANDLED_DATE }).ExecuteCommand();
			});
			if (!dbTran.IsSuccess)
			{
			action.CatchExceptionWithLog(dbTran.ErrorException, $"数据处理失败");
			Logger.Interface.Error(action.Message);
			IsSuccessed = false;
			}
			input.ErpProdInBths = ErpProdInBths;
			}
			}
			input.labels = GetLabels(input.PrintJsons);
			action.Data = input;
			}
			catch (System.Exception ex)
			@@ -194,5 +205,77 @@
			Logger.Interface.Info($"/* 入库单接口结束 */\r\n"); //固定写法
			return action;
			}

			private List<BAS_LABEL_TEMP> GetLabels(List<InStorePrintJson> printJsons) {
			List<BAS_LABEL_TEMP> labels = new List<BAS_LABEL_TEMP>();
			int i = 1;
			int j = 1;
			foreach (var p in printJsons)
			{
			BAS_LABEL_TEMP label = Biz.Db.Queryable<BAS_LABEL_TEMP>().Where(q => q.LABEL_CODE == "InstoreTemplate").First();
			foreach (var item in label.Variables.OrderBy(q => q.VAR_TYPE == BAS_LABEL_VAR.VAR_TYPEs.BarcodeGenerate.GetValue() ? 0 : 1))
			{
			foreach (var v in p.Items.Where(q=>q.STATUS !="F" && q.STATUS !="P"))
			{
			if (item.VAR_NAME.StartsWith("RcvDoc"))
			{
			item.Value = v.ORDER_NO;
			}
			if (item.VAR_NAME.StartsWith("SoDoc"))
			{
			item.Value = v.SALES_ORDER;
			}
			if (item.VAR_NAME.StartsWith("MoDoc"))
			{
			item.Value = v.WORK_ORDER;
			}
			if (item.VAR_NAME.StartsWith("ItemCode"))
			{
			item.Value = v.ITEM_CODE;
			}
			if (item.VAR_NAME.StartsWith("Description"))
			{
			item.Value = v.ITEM_NAME;
			}
			if (item.VAR_NAME.StartsWith("BoxQty"))
			{
			item.Value = v.PLAN_QTY.ToString();
			}
			if (item.VAR_NAME.StartsWith("InQty"))
			{
			item.Value = v.SCAN_QTY.ToString();
			}
			if (item.VAR_NAME.StartsWith("RcvQrCode"))
			{
			item.Value = v.ORDER_NO.ToString();
			}
			if (item.VAR_NAME.StartsWith("SapCode"))
			{
			item.Value = v.SapCode;
			}
			if (item.VAR_NAME.StartsWith("Seq"))
			{
			item.Value = i.ToString();
			}
			i++;
			}
			if (item.VAR_NAME == "PageNum")
			{
			item.Value = j.ToString();
			}
			if (item.VAR_NAME == "PageSize")
			{
			item.Value = printJsons.Count.ToString();
			}
			if (item.VAR_NAME == "BusinessDate")
			{
			item.Value = DateTime.Now.ToString("yyyyy.MM.dd");
			}
			}
			labels.Add(label);
			j++;
			}
			return labels;
			}
			}
			}