| | |
|---|
| | | 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 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) |
|---|
