| | |
| | | using System.Collections; |
| | | using System.Data.Entity.Core.Common.CommandTrees.ExpressionBuilder; |
| | | using static IronPython.Modules.PythonDateTime; |
| | | using System.Net; |
| | | |
| | | namespace Tiger.Business.WMS |
| | | { |
| | |
| | | DbClient db = Biz.DataSource["YadaU9C"].Client; |
| | | string UserCode = "U9C_In_DocASN"; |
| | | var list = db.Queryable<mes_AsnDocInfo>().Where(x => x.ModifiedOn > input.startTime.ToDateTime() && x.ModifiedOn < input.endTime.ToDateTime()).ToList(); |
| | | //var list = db.Ado.SqlQuery<mes_AsnDocInfo>($"select * from mes_AsnDocInfo where ModifiedOn > '{input.startTime}' And ModifiedOn < '{input.endTime}'"); |
| | | var orgs = Biz.Db.Queryable<SYS_ORGANIZATION>().ToList(); |
| | | List<BIZ_U9_ASN> asns = new(); |
| | | List<BIZ_U9_ASN_DTL> items = new(); |
| | |
| | | PLANARRIVED_DATE = x.Max(t => t.PlanArriveDate), |
| | | ORDER_DATE = x.Max(t => t.ModifiedOn), |
| | | CREATE_TIME = x.Max(t => t.ModifiedOn).ToDateTime(),//--æ¶é´ä¸æ´æ° |
| | | CREATE_USER = "U9C_In_DocASN", |
| | | CREATE_USER= UserCode, |
| | | UPDATE_TIME = x.Max(t => t.ModifiedOn).ToDateTime(), |
| | | UPDATE_USER = "U9C_In_DocASN", |
| | | UPDATE_USER = UserCode, |
| | | AUTH_ORG = orgs.FirstOrDefault(q => q.ID == x.Max(t => t.Org).ToString())?.ORG_CODE, |
| | | HANDLED=0, |
| | | HANDLED=-1, //æªå¤ç |
| | | HANDLED_DATE=DateTime.Now, |
| | | }) |
| | | .ToList(); |
| | |
| | | LOTNO = item.LotMater, |
| | | AUTH_ORG = orgs.FirstOrDefault(q => q.ID == item.Org.ToString())?.ORG_CODE, |
| | | CREATE_TIME = item.ModifiedOn,//--æ¶é´ä¸æ´æ° |
| | | CREATE_USER = "U9C_In_DocASN", |
| | | CREATE_USER = UserCode, |
| | | UPDATE_TIME = item.ModifiedOn, |
| | | UPDATE_USER = "U9C_In_DocASN", |
| | | }; |
| | | UPDATE_USER = UserCode }; |
| | | items.Add(info); |
| | | } |
| | | Logger.Scheduler.Info($"éè´§åæç»è¡ä¿¡æ¯åå
¥å®ä½ä¸ï¼æ»æ°ï¼[{items.Count}]"); |
| | |
| | | LOTNO = item.Segment7, |
| | | AUTH_ORG = asn.AUTH_ORG, |
| | | CREATE_TIME = DateTime.Now,//--æ¶é´ä¸æ´æ° |
| | | CREATE_USER = "U9C_In_DocASN", |
| | | CREATE_USER = UserCode, |
| | | UPDATE_TIME = DateTime.Now, |
| | | UPDATE_USER = "U9C_In_DocASN", |
| | | UPDATE_USER = UserCode, |
| | | }; |
| | | sns.Add(info); |
| | | } |
| | | Logger.Scheduler.Info($"éè´§å[{asn.ORDER_NO}]æ¡ç æç»ä¿¡æ¯åå
¥å®ä½ä¸ï¼æ»æ°ï¼[{snlist.Count}]"); |
| | | } |
| | | db = Biz.Db; |
| | | //var dbTran = db.UseTran(() => |
| | | //{ |
| | | if (asns.Any()) |
| | | { |
| | | if (asns.Count > 100) |
| | |
| | | .WhereColumns(t => new { t.ORDER_NO, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | y.AsInsertable.ExecuteCommand(); |
| | | y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.ORDER_NO, q.SUPP_CODE, q.SUPP_NAME, q.DELIVERY_DATE, q.PLANARRIVED_DATE, q.ORDER_DATE, q.CREATE_USER, q.UPDATE_TIME,q.AUTH_ORG ,q.UPDATE_USER }).ExecuteCommand(); |
| | | y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.ORDER_NO, q.SUPP_CODE, q.SUPP_NAME, q.DELIVERY_DATE, q.PLANARRIVED_DATE, q.ORDER_DATE, q.CREATE_USER, q.UPDATE_TIME,q.AUTH_ORG ,q.UPDATE_USER , }).ExecuteCommand(); |
| | | }); |
| | | } |
| | | else |
| | |
| | | .WhereColumns(t => new { t.ORDER_NO, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | s.AsInsertable.ExecuteCommand(); |
| | | s.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.ORDER_NO, q.SUPP_CODE, q.SUPP_NAME, q.DELIVERY_DATE, q.PLANARRIVED_DATE, q.ORDER_DATE, q.CREATE_USER, q.UPDATE_TIME, q.AUTH_ORG, q.UPDATE_USER }).ExecuteCommand(); |
| | | s.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.ORDER_NO, q.SUPP_CODE, q.SUPP_NAME, q.DELIVERY_DATE, q.PLANARRIVED_DATE, q.ORDER_DATE, q.CREATE_USER, q.UPDATE_TIME, q.AUTH_ORG, q.UPDATE_USER, }).ExecuteCommand(); |
| | | } |
| | | } |
| | | if (items.Any()) |
| | |
| | | .WhereColumns(t => new { t.ORDER_NO,t.ID, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | y.AsInsertable.ExecuteCommand(); |
| | | y.AsUpdateable.UpdateColumns(q => new { q.ORDER_NO,q.LINE_NO, q.SUPP_CODE, q.ID, q.ITEM_CODE, q.QTY_PACKING, q.QTY, q.SUPP_LOTNO, q.LOTNO, q.AUTH_ORG,q.CREATE_USER, q.UPDATE_TIME ,q.UPDATE_USER }).ExecuteCommand(); |
| | | y.AsUpdateable.UpdateColumns(q => new { q.ORDER_NO,q.LINE_NO, q.SUPP_CODE, q.ID, q.ITEM_CODE, q.QTY_PACKING, q.QTY, q.SUPP_LOTNO, q.LOTNO, q.AUTH_ORG,q.CREATE_USER, q.UPDATE_TIME ,q.UPDATE_USER, }).ExecuteCommand(); |
| | | }); |
| | | } |
| | | else |
| | |
| | | .WhereColumns(t => new { t.ORDER_NO,t.ID, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | s.AsInsertable.ExecuteCommand(); |
| | | s.AsUpdateable.UpdateColumns(q => new { q.ORDER_NO,q.LINE_NO, q.SUPP_CODE, q.ID, q.ITEM_CODE, q.QTY_PACKING, q.QTY, q.SUPP_LOTNO, q.LOTNO, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER }).ExecuteCommand(); |
| | | s.AsUpdateable.UpdateColumns(q => new { q.ORDER_NO,q.LINE_NO, q.SUPP_CODE, q.ID, q.ITEM_CODE, q.QTY_PACKING, q.QTY, q.SUPP_LOTNO, q.LOTNO, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER, }).ExecuteCommand(); |
| | | } |
| | | } |
| | | if (sns.Any()) |
| | |
| | | s.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.ORDER_NO, q.LINE_NO, q.SN, q.ITEM_CODE, q.QTY, q.LOTNO, q.AUTH_ORG, q.CREATE_TIME, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER, }).ExecuteCommand(); |
| | | } |
| | | } |
| | | |
| | | //}); |
| | | //if (!dbTran.IsSuccess) |
| | | //{ |
| | | // action.CatchExceptionWithLog(dbTran.ErrorException, $"æ°æ®å¤ç失败"); |
| | | // Logger.Scheduler.Error(action.Message); |
| | | //} |
| | | Logger.Scheduler.Info($"éè´§å表头信æ¯åå
¥æ°æ®åºï¼æ»æ°ï¼[{asns.Count}]"); |
| | | action.Message = $"éè´§å表头信æ¯åå
¥æ°æ®åºï¼æ»æ°ï¼[{asns.Count}]"; |
| | | } |
| | | return action; |
| | | } |
| | | |
| | | /// <summary> |
| | | /// 忥æ¶è´§åAsnä¿¡æ¯ |
| | | /// </summary> |
| | | /// <param name="input"></param> |
| | | /// <returns></returns> |
| | | public ApiAction In_GetReceipt(U9C_Base_Input input) |
| | | { |
| | | var action = new ApiAction(); |
| | | Logger.Scheduler.Info($"æ¶è´§åä¿¡æ¯å¼å§åæ¥ãããæ°æ®æ£æ¥è¿è¡ä¸ããã"); |
| | | Logger.Scheduler.Info($"{input.triggerDetail}"); |
| | | DbClient db = Biz.DataSource["YadaU9C"].Client; |
| | | string UserCode = "U9C_In_GetReceipt"; |
| | | var list = db.Queryable<mes_ReturnedDocInfo>().Where(x => x.SplitFlag == 0 && x.ReceivementType == 0&& x.ModifiedOn > input.startTime.ToDateTime() && x.ModifiedOn < input.endTime.ToDateTime()).ToList(); |
| | | var orgs = Biz.Db.Queryable<SYS_ORGANIZATION>().ToList(); |
| | | List<BIZ_U9_RECEIPT> result = new(); |
| | | List<BIZ_U9_RECEIPT_DTL> resultDt = new(); |
| | | if (list != null && list.Count > 0) |
| | | { |
| | | result = list |
| | | .GroupBy(x => new { x.DocNo }) |
| | | .Select(x => new BIZ_U9_RECEIPT |
| | | { |
| | | STATUS = BIZ_U9_RECEIPT.STATUSs.Init.GetValue(), |
| | | ORDER_NO = x.Key.DocNo, |
| | | SUPP_CODE = x.Max(t => t.SupplierCode), |
| | | SUPP_NAME = x.Max(t => t.SupplierName), |
| | | ORDER_DATE = x.Max(t => t.ModifiedOn), |
| | | //RECEIVER æ¶è´§äºº |
| | | //RECEIVE_DATE æ¶è´§æ¥æ |
| | | CREATE_TIME = x.Max(t => t.ModifiedOn).ToDateTime(),//--æ¶é´ä¸æ´æ° |
| | | CREATE_USER = UserCode, |
| | | UPDATE_TIME = x.Max(t => t.ModifiedOn).ToDateTime(), |
| | | UPDATE_USER = UserCode, |
| | | AUTH_ORG = orgs.FirstOrDefault(q => q.ID == x.Max(t => t.Org).ToString())?.ORG_CODE, |
| | | HANDLED = -1, |
| | | HANDLED_DATE = DateTime.Now, |
| | | }) |
| | | .ToList(); |
| | | Logger.Scheduler.Info($"æ¶è´§å表头信æ¯åå
¥å®ä½ä¸ï¼æ»æ°ï¼[{result.Count}]"); |
| | | foreach (var item in list) |
| | | { |
| | | BIZ_U9_RECEIPT_DTL info = new() |
| | | { |
| | | STATUS = BIZ_U9_RETURN.STATUSs.Imported.GetValue(), //ç¶æ |
| | | ORDER_NO = item.DocNo, //åæ®å· |
| | | LINE_NO = item.DocLineNo.ToString(), //åæ®è¡å· |
| | | ITEM_CODE = item.ItemCode, //ç©æç¼ç |
| | | QTY = item.RtnFillQtyTU.ToDouble(), // mesåæ®æ°é --U9éè¡¥æ°é |
| | | AUTH_ORG = orgs.FirstOrDefault(q => q.ID == item.Org.ToString())?.ORG_CODE, //ç产åå
æææ è¯å符 |
| | | CREATE_TIME = item.ModifiedOn,//--æ¶é´ä¸æ´æ° |
| | | CREATE_USER = UserCode, |
| | | UPDATE_TIME = item.ModifiedOn, |
| | | UPDATE_USER = UserCode |
| | | }; |
| | | resultDt.Add(info); |
| | | } |
| | | Logger.Scheduler.Info($"æ¶è´§åæç»è¡ä¿¡æ¯åå
¥å®ä½ä¸ï¼æ»æ°ï¼[{resultDt.Count}]"); |
| | | db = Biz.Db; |
| | | if (result.Any()) |
| | | { |
| | | if (result.Count > 100) |
| | | { |
| | | db.Utilities.PageEach(result, 100, pageList => |
| | | { |
| | | var y = db.Storageable(pageList, UserCode) |
| | | .WhereColumns(t => new { t.ORDER_NO, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | y.AsInsertable.ExecuteCommand(); |
| | | y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.STATUS, q.ORDER_NO, q.SUPP_CODE, q.SUPP_NAME, q.ORDER_DATE,q.AUTH_ORG, q.CREATE_USER,q.UPDATE_TIME,q.UPDATE_USER, q.HANDLED, q.HANDLED_DATE, }).ExecuteCommand(); |
| | | }); |
| | | } |
| | | else |
| | | { |
| | | var s = db.Storageable(result, UserCode) |
| | | .WhereColumns(t => new { t.ORDER_NO, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | s.AsInsertable.ExecuteCommand(); |
| | | s.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns( q => new { q.STATUS, q.ORDER_NO, q.SUPP_CODE, q.SUPP_NAME, q.ORDER_DATE, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER, q.HANDLED, q.HANDLED_DATE, }).ExecuteCommand(); |
| | | } |
| | | } |
| | | |
| | | if (resultDt.Any()) |
| | | { |
| | | if (resultDt.Count > 100) |
| | | { |
| | | db.Utilities.PageEach(resultDt, 100, pageList => |
| | | { |
| | | var y = db.Storageable(pageList, UserCode) |
| | | .WhereColumns(t => new { t.ORDER_NO, t.LINE_NO, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | y.AsInsertable.ExecuteCommand(); |
| | | y.AsUpdateable.UpdateColumns(q => new { q.STATUS, q.ORDER_NO, q.LINE_NO, q.ITEM_CODE, q.QTY, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_USER,q.UPDATE_TIME }).ExecuteCommand(); |
| | | }); |
| | | } |
| | | else |
| | | { |
| | | var s = db.Storageable(resultDt, UserCode) |
| | | .WhereColumns(t => new { t.ORDER_NO, t.LINE_NO, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | s.AsInsertable.ExecuteCommand(); |
| | | s.AsUpdateable.UpdateColumns(q => new { q.STATUS, q.ORDER_NO, q.LINE_NO, q.ITEM_CODE, q.QTY, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_USER,q.UPDATE_TIME }).ExecuteCommand(); |
| | | } |
| | | } |
| | | Logger.Scheduler.Info($"æ¶è´§å表头信æ¯åå
¥æ°æ®åºï¼æ»æ°ï¼[{resultDt.Count}]"); |
| | | action.Message = $"æ¶è´§å表头信æ¯åå
¥æ°æ®åºï¼æ»æ°ï¼[{resultDt.Count}]"; |
| | | } |
| | | return action; |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// 忥éè´§åAsnä¿¡æ¯ |
| | | /// </summary> |
| | | /// <param name="input"></param> |
| | | /// <returns></returns> |
| | | public ApiAction In_GetReturn(U9C_Base_Input input) |
| | | { |
| | | var action = new ApiAction(); |
| | | Logger.Scheduler.Info($"éè´§åä¿¡æ¯å¼å§åæ¥ãããæ°æ®æ£æ¥è¿è¡ä¸ããã"); |
| | | Logger.Scheduler.Info($"{input.triggerDetail}"); |
| | | DbClient db = Biz.DataSource["YadaU9C"].Client; |
| | | string UserCode = "U9C_In_GetReturn"; |
| | | var list = db.Queryable<mes_ReturnedDocInfo>().Where(x => x.SplitFlag == 0 && x.ReceivementType == 1 && x.ModifiedOn > input.startTime.ToDateTime() && x.ModifiedOn < input.endTime.ToDateTime()).ToList(); |
| | | var orgs = Biz.Db.Queryable<SYS_ORGANIZATION>().ToList(); |
| | | List<BIZ_U9_RETURN> result = new(); |
| | | List<BIZ_U9_RETURN_DTL> resultDt = new(); |
| | | if (list != null && list.Count > 0) |
| | | { |
| | | result = list |
| | | .GroupBy(x => new { x.DocNo }) |
| | | .Select(x => new BIZ_U9_RETURN |
| | | { |
| | | STATUS = BIZ_U9_RECEIPT.STATUSs.Init.GetValue(), //ç¶æ |
| | | ORDER_NO = x.Key.DocNo, //åå· |
| | | SUPP_CODE = x.Max(t => t.SupplierCode), //ä¾åºåç¼ç |
| | | SUPP_NAME = x.Max(t => t.SupplierName),//ä¾åºååç§° |
| | | ORDER_DATE = x.Max(t => t.ModifiedOn), //åæ®æ¥æ |
| | | CREATE_TIME = x.Max(t => t.ModifiedOn).ToDateTime(),//--æ¶é´ä¸æ´æ° |
| | | CREATE_USER = UserCode, |
| | | UPDATE_TIME = x.Max(t => t.ModifiedOn).ToDateTime(), |
| | | UPDATE_USER = UserCode, |
| | | AUTH_ORG = orgs.FirstOrDefault(q => q.ID == x.Max(t => t.Org).ToString())?.ORG_CODE, |
| | | HANDLED = -1, |
| | | HANDLED_DATE = DateTime.Now, |
| | | GHOST_ROW = false, |
| | | }) |
| | | .ToList(); |
| | | Logger.Scheduler.Info($"éè´§å表头信æ¯åå
¥å®ä½ä¸ï¼æ»æ°ï¼[{result.Count}]"); |
| | | foreach (var item in list) |
| | | { |
| | | BIZ_U9_RETURN_DTL info = new() |
| | | { |
| | | STATUS = BIZ_U9_RETURN.STATUSs.Imported.GetValue(), //ç¶æ |
| | | ORDER_NO = item.DocNo, //åæ®å· |
| | | LINE_NO = item.DocLineNo.ToString(), //åæ®è¡å· |
| | | ITEM_CODE = item.ItemCode, //ç©æç¼ç |
| | | QTY = item.RtnFillQtyTU.ToDouble(), // mesåæ®æ°é --U9éè¡¥æ°é |
| | | AUTH_ORG = orgs.FirstOrDefault(q => q.ID == item.Org.ToString())?.ORG_CODE, //ç产åå
æææ è¯å符 |
| | | CREATE_TIME = item.ModifiedOn,//--æ¶é´ä¸æ´æ° |
| | | CREATE_USER = UserCode, |
| | | UPDATE_TIME = item.ModifiedOn, |
| | | UPDATE_USER = UserCode |
| | | }; |
| | | resultDt.Add(info); |
| | | } |
| | | Logger.Scheduler.Info($"éè´§åæç»è¡ä¿¡æ¯åå
¥å®ä½ä¸ï¼æ»æ°ï¼[{resultDt.Count}]"); |
| | | db = Biz.Db; |
| | | if (result.Any()) |
| | | { |
| | | if (result.Count > 100) |
| | | { |
| | | db.Utilities.PageEach(result, 100, pageList => |
| | | { |
| | | var y = db.Storageable(pageList, UserCode) |
| | | .WhereColumns(t => new { t.ORDER_NO, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | y.AsInsertable.ExecuteCommand(); |
| | | y.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.STATUS, q.ORDER_NO, q.SUPP_CODE, q.SUPP_NAME, q.ORDER_DATE, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER, q.HANDLED, q.HANDLED_DATE, }).ExecuteCommand(); |
| | | }); |
| | | } |
| | | else |
| | | { |
| | | var s = db.Storageable(result, UserCode) |
| | | .WhereColumns(t => new { t.ORDER_NO, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | s.AsInsertable.ExecuteCommand(); |
| | | s.AsUpdateable.IgnoreColumns(x => x.ID).UpdateColumns(q => new { q.STATUS, q.ORDER_NO, q.SUPP_CODE, q.SUPP_NAME, q.ORDER_DATE, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_TIME, q.UPDATE_USER, q.HANDLED, q.HANDLED_DATE, }).ExecuteCommand(); |
| | | } |
| | | } |
| | | |
| | | if (resultDt.Any()) |
| | | { |
| | | if (resultDt.Count > 100) |
| | | { |
| | | db.Utilities.PageEach(resultDt, 100, pageList => |
| | | { |
| | | var y = db.Storageable(pageList, UserCode) |
| | | .WhereColumns(t => new { t.ORDER_NO, t.LINE_NO, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | y.AsInsertable.ExecuteCommand(); |
| | | y.AsUpdateable.UpdateColumns(q => new { q.STATUS, q.ORDER_NO, q.LINE_NO, q.ITEM_CODE, q.QTY, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_USER, q.UPDATE_TIME }).ExecuteCommand(); |
| | | }); |
| | | } |
| | | else |
| | | { |
| | | var s = db.Storageable(resultDt, UserCode) |
| | | .WhereColumns(t => new { t.ORDER_NO, t.LINE_NO, t.GHOST_ROW }) |
| | | .ToStorage(); |
| | | s.AsInsertable.ExecuteCommand(); |
| | | s.AsUpdateable.UpdateColumns(q => new { q.STATUS, q.ORDER_NO, q.LINE_NO, q.ITEM_CODE, q.QTY, q.AUTH_ORG, q.CREATE_USER, q.UPDATE_USER, q.UPDATE_TIME }).ExecuteCommand(); |
| | | } |
| | | } |
| | | Logger.Scheduler.Info($"éè´§å表头信æ¯åå
¥æ°æ®åºï¼æ»æ°ï¼[{resultDt.Count}]"); |
| | | action.Message = $"éè´§å表头信æ¯åå
¥æ°æ®åºï¼æ»æ°ï¼[{resultDt.Count}]"; |
| | | } |
| | | return action; |
| | | } |
| | | |
| | | |
| | | } |
| | | } |