| | |
|---|
| | | 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 |
|---|
| | | { |
|---|
| | |
|---|
| | | 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(() => |
|---|
