TigerClouds-Tech/Server/TigerApi6_2024.git

			@@ -64,5 +64,5 @@
			"WillMsgDelay": 5,
			"WillMsgExpiry": 300
			},
			"RunInterface": true
			"RunInterface": false
			}

			@@ -41,7 +41,7 @@
			item.Segment5 = barcode.ItemCode;
			item.PROD_DATE = barcode.DateCode.ToDateTime();
			item.Unit = barcode.Unit;
			item.LotNo= barcode.LotNo;
			item.LotNo= barcode.LotNo.IsNullOrEmpty() ? item.Segment7 : barcode.LotNo;
			}

			//保存到数据库

			@@ -19,6 +19,8 @@
			using static Microsoft.CodeAnalysis.CSharp.SyntaxTokenParser;
			using Tiger.Model.Entitys.MES.U9C;
			using Tiger.Model.Entitys.MES.BizPrintInstoreDoc;
			using Tiger.Model.Entitys.MES.Position;
			using IronPython.Runtime.Operations;

			namespace Tiger.Business.WMS.Transaction
			{
			@@ -470,6 +472,35 @@
			ErpProdInSns = new();
			inStoreInfos = new() { };

			//临时代码
			//DbClient _db = Biz.DataSource["YadaU9C"].Client;
			//var items = Biz.Db.Queryable<WMS_ITEM>().Where(q=> SqlFunc.IsNullOrEmpty(q.SUPP_LOTNO)).ToList();
			//var snlist = items.Select(q=>q.SN).ToList();
			////var list = _db.Ado.SqlQuery<mes_MaterialBarCodeByBin>($"select *,cast('{DateTime.Now.ToString("yyyy-MM-dd")}' as DATETIME) as PROD_DATE,'' as Unit,'' as LotNo from mes_MaterialBarCodeByBin where Code in ({string.Join(',', snlist.Select(x=> $"'{x}'"))})");
			//var list = _db.Queryable<mes_MaterialBarCode>().Where(q => snlist.Contains(q.Code)).ToList();
			//foreach (var item in list)
			//{
			// var wmsitem = items.Where(q => q.SN == item.Code).FirstOrDefault();
			// if (!wmsitem.IsNullOrEmpty())
			// {
			// wmsitem.SUPP_LOTNO = item.Segment7;
			// }
			//}


			////保存数据库
			//var db = Business.Biz.Db;
			//var dbTran = db.UseTran(() =>
			//{
			// db.Updateable(items).UpdateColumns(q => new { q.SUPP_LOTNO }).ExecuteCommand();
			//});
			//if (!dbTran.IsSuccess)
			//{
			// Logger.Default.Fatal(dbTran.ErrorException, "Database transaction save exception");
			// this.Close(!dbTran.IsSuccess);
			// throw dbTran.ErrorException;
			//}

			//保存数据库
			var db = Business.Biz.Db;
			var dbTran = db.UseTran(() =>

			@@ -214,6 +214,7 @@
			if (receiptDtl.QTY_IN == receiptDtl.QTY)
			{
			receiptDtl.STATUS = BIZ_U9_RECEIPT.STATUSs.Review.GetValue();
			//当前单据明细已经全部上架完成，可以调用U9行审接口
			}
			else
			{
			@@ -236,9 +237,9 @@
			//使用统一的事务DB对象
			var db = GetCommitDB();
			//数据保存逻辑
			db.Storageable(receipt, UserCode).ExecuteCommand();
			db.Storageable(receiptDtl, UserCode).ExecuteCommand();
			db.Storageable(receiptSn, UserCode).ExecuteCommand();
			db.Updateable(receipt, UserCode).UpdateColumns(q => new { q.STATUS, q.UPDATE_TIME, q.UPDATE_USER }).ExecuteCommand();
			db.Updateable(receiptDtl, UserCode).UpdateColumns(q => new { q.STATUS, q.QTY_IN, q.UPDATE_TIME, q.UPDATE_USER }).ExecuteCommand();
			db.Updateable(receiptSn, UserCode).UpdateColumns(q => new { q.STATUS, q.IS_IN, q.UPDATE_TIME, q.UPDATE_USER }).ExecuteCommand();
			});

			//完成所有处理后使用事务保存数据

	Tiger.Api/appsettings.json	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Tiger.Business.WMS/ERP/U9C_WMS.cs	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Tiger.Business.WMS/Transaction/In_SemiProd.cs	31 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	Tiger.Business.WMS/Transaction/Yada/In_BIZ_U9_RECEIPT.cs	7 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史