一些更改

Ben Lin

2024-08-15 29764a01914a42d5e743a7bf1c01546bfea0ee90

 Tiger.Business.MES/iERP/U9C_MES.cs

@@ -29,6 +29,7 @@
            Logger.Scheduler.Info($"{input.triggerDetail}");
            DbClient db = Biz.DataSource["YadaU9C"].Client;
            var list = db.Queryable<dynamic>().AS("mes_ItemMaster").Where("ModifiedOn > @startTime And ModifiedOn < @endTime", new { startTime = input.startTime, endTime = input.endTime }).ToList();
            var orgs = Biz.Db.Queryable<SYS_ORGANIZATION>().ToList();
            List<BAS_ITEM> items = new();
            foreach (var item in list)
            {
@@ -37,6 +38,7 @@
                di = di?.ToDictionary(x => x.Key, x => x.Value);
                if (di != null)
                {
                    var orgId = di["Org"] == null ? "" : di["Org"].ToString();
                    BAS_ITEM basItem = new()
                    {
                        ID = di["ID"].ToString(),
@@ -51,6 +53,7 @@
                        UPDATE_TIME = di["ModifiedOn"].ToDateTime(),
                        IS_ACTIVE = "Y",
                        IS_PROD = ((string)di["Code"]).StartsWith("2") ? "Y" : "N",
                        AUTH_ORG = orgs.Where(x => x.ID == orgId).Select(q => q.ORG_CODE).FirstOrDefault(),
                    };
                    items.Add(basItem);
                }
@@ -110,6 +113,7 @@
            Logger.Scheduler.Info($"{input.triggerDetail}");
            DbClient db = Biz.DataSource["YadaU9C"].Client;
            var list = db.Queryable<dynamic>().AS("mes_Mo").Where("ModifiedOn > @startTime And ModifiedOn < @endTime", new { startTime = input.startTime, endTime = input.endTime }).ToList();
            var orgs = Biz.Db.Queryable<SYS_ORGANIZATION>().ToList();
            List<BIZ_MES_WO> items = new();
            foreach (var item in list)
            {
@@ -118,17 +122,22 @@
                di = di?.ToDictionary(x => x.Key, x => x.Value);
                if (di != null)
                {
                    var orgId = di["Org"] == null ? "" : di["Org"].ToString();
                    var itemId = di["ItemMaster"] == null ? "" : di["ItemMaster"].ToString();
                    var basItem = Biz.Db.Queryable <BAS_ITEM>().Where(x=>x.ID == itemId).First();
                    BIZ_MES_WO woItem = new()
                    {
                        ORDER_NO = di["DocNo"] == null ? "" : di["DocNo"].ToString(),
                        ORDER_TYPE = di["DocTypeCode"] == null ? 0 : di["DocTypeCode"].ToInt32(),
                        PLAN_QTY = di["ProductQty"] == null ? 0 : di["ProductQty"].ToInt32(),
                        CUST_CODE = di["CustomerCode"] == null ? "" : di["CustomerCode"].ToString(),
                        ITEM_CODE = di["ItemMaster"] == null ? "" : di["ItemMaster"].ToString(),
                        ITEM_CODE = basItem != null? basItem.ITEM_CODE: "",
                        CREATE_TIME = di["CreatedOn"].ToDateTime(),
                        UPDATE_TIME = di["ModifiedOn"].ToDateTime(),
                        PLAN_START_TIME = di["CheckDate"].ToDateTime(),
                        STATUS = 0,
                        AUTH_ORG = orgs.Where(x => x.ID == orgId).Select(q=>q.ORG_CODE).FirstOrDefault(),
                        SALES_ORDER = di["SrcDoc_SrcDocNo"] == null ? "" : di["SrcDoc_SrcDocNo"].ToString(),
                    };
                    items.Add(woItem);
                }
@@ -188,6 +197,7 @@
            Logger.Scheduler.Info($"{input.triggerDetail}");
            DbClient db = Biz.DataSource["YadaU9C"].Client;
            var list = db.Queryable<dynamic>().AS("mes_Customer").Where("ModifiedOn > @startTime And ModifiedOn < @endTime", new { startTime = input.startTime, endTime = input.endTime }).ToList();
            var orgs = Biz.Db.Queryable<SYS_ORGANIZATION>().ToList();
            List<BAS_CUSTOMER> items = new();
            foreach (var item in list)
            {
@@ -196,6 +206,7 @@
                di = di?.ToDictionary(x => x.Key, x => x.Value);
                if (di != null)
                {
                    var orgId = di["Org"] == null ? "" : di["Org"].ToString();
                    BAS_CUSTOMER custItem = new()
                    {
                        CUST_CODE = di["Code"] == null ? "" : di["Code"].ToString(),
@@ -203,6 +214,7 @@
                        CUST_TYPE = di["CustomerCategoryName"] == null ? "" : di["CustomerCategoryName"].ToString(),
                        CREATE_TIME = di["CreatedOn"].ToDateTime(),
                        UPDATE_TIME = di["ModifiedOn"].ToDateTime(),
                        AUTH_ORG = orgs.Where(x => x.ID == orgId).Select(q => q.ORG_CODE).FirstOrDefault(),
                    };
                    items.Add(custItem);
                }