| | |
| | | AUTH_ORG = orgs.Where(x => x.ID == orgId).Select(q => q.ORG_CODE).FirstOrDefault(), |
| | | CUST_PROD_CODE = di["CustomerItem"] == null ? "" : di["CustomerItem"].ToString(), |
| | | RULE_CODE = di["BarRule"] == null ? "" : di["BarRule"].ToString(), |
| | | DEFAULT_LOCATION = di["BinCode"] == null ? "" : di["BinCode"].ToString(), |
| | | }; |
| | | items.Add(basItem); |
| | | var extInfo = new BAS_ITEM_EXT() |
| | |
| | | public int GetOtherOutInfoToT100(InputDTO input) |
| | | { |
| | | var DB = Biz.Db; |
| | | var dataList = DB.Queryable<BIZ_ERP_OTH_OUT>().Where(i => i.STATUS == BIZ_WMS_TRANSFER.STATUSs.COMPLETE.GetValue() && string.IsNullOrWhiteSpace(i.ERP_BILL_CODE) && i.AUTH_ORG == input.site).ToList(); |
| | | var dataList = DB.Queryable<BIZ_ERP_OTH_OUT>().Where(i => i.STATUS == BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue() && string.IsNullOrWhiteSpace(i.ERP_BILL_CODE) && i.AUTH_ORG == input.site).ToList(); |
| | | |
| | | Logger.Scheduler.Info("å
¶ä»åºåºåä¿¡æ¯å¼å§æ¨éãããæ°æ®æ£æ¥è¿è¡ä¸ããã"); |
| | | if (!dataList.Any()) |
| | |
| | | public int PutSaleOutInfoToT100(InputDTO input) |
| | | { |
| | | var DB = Biz.Db; |
| | | var dataList = DB.Queryable<BIZ_ERP_SALE_OUT>().Where(i => i.STATUS == BIZ_WMS_TRANSFER.STATUSs.COMPLETE.GetValue() && string.IsNullOrWhiteSpace(i.ERP_BILL_CODE) && i.AUTH_ORG == input.site).ToList();// è·åç¬¦åæ¡ä»¶çéå®åºåºåæ°æ® |
| | | var dataList = DB.Queryable<BIZ_ERP_SALE_OUT>().Where(i => i.STATUS == BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue() && string.IsNullOrWhiteSpace(i.ERP_BILL_CODE) && i.AUTH_ORG == input.site).ToList();// è·åç¬¦åæ¡ä»¶çéå®åºåºåæ°æ® |
| | | |
| | | Logger.Scheduler.Info("éå®åºåºåä¿¡æ¯å¼å§æ¨éãããæ°æ®æ£æ¥è¿è¡ä¸ããã"); |
| | | if (!dataList.Any()) |
| | |
| | | //} |
| | | |
| | | var dataList = DB.Queryable<BIZ_WMS_TRANSFER>(). |
| | | Where(i => i.STATUS == BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue() && string.IsNullOrWhiteSpace(i.ERP_BILL_CODE) && i.AUTH_ORG == input.site) |
| | | Where(i => i.STATUS == BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue() && string.IsNullOrWhiteSpace(i.ERP_ORDER) && i.AUTH_ORG == input.site) |
| | | .ToList(); |
| | | |
| | | Logger.Scheduler.Info("è°æ¨åä¿¡æ¯å¼å§æ¨éãããæ°æ®æ£æ¥è¿è¡ä¸ããã"); |
| | |
| | | return 0; |
| | | } |
| | | |
| | | var billcodeLst = dataList.Select(i => i.BILLCODE).Distinct().ToList(); |
| | | var billcodeLst = dataList.Select(i => i.ORDER_NO).Distinct().ToList(); |
| | | |
| | | var detailData = DB.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(i => billcodeLst.Contains(i.BILLCODE)).ToList();// è·åæç»æ°æ® |
| | | var detailData = DB.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(i => billcodeLst.Contains(i.ORDER_NO)).ToList();// è·åæç»æ°æ® |
| | | var returnData = DB.Queryable<BIZ_ERP_PROD_RETURN>().Where(i => billcodeLst.Contains(i.BILLCODE)).ToList();// è·åéæè¡¨å¤´æ°æ® |
| | | var returnDetailData = DB.Queryable<BIZ_ERP_PROD_RETURN_DTL>().Where(i => billcodeLst.Contains(i.BILLCODE)).ToList();// è·åéæè¡¨å¤´æ°æ® |
| | | |
| | | Logger.Scheduler.Info("è°æ¨åä¿¡æ¯å¼å§æ¨éããã"); |
| | | foreach (var data in dataList) |
| | | { |
| | | var detailLst = detailData.Where(i => i.BILLCODE == data.BILLCODE).ToList(); |
| | | var detailLst = detailData.Where(i => i.ORDER_NO == data.ORDER_NO).ToList(); |
| | | var details = new List<TrasferDetailDTO>(); |
| | | foreach (var detail in detailLst) |
| | | { |
| | | details.Add(new TrasferDetailDTO() |
| | | { |
| | | indd101 = detail.SOURCECODE, |
| | | inddseq = detail.BILLLINE, |
| | | indd101 = detail.SOURCE_ORDER, |
| | | inddseq = detail.ORDER_LINE, |
| | | indd002 = detail.ITEM_CODE, |
| | | indd022 = detail.OUTWAREHOUSECODE, |
| | | indd022 = detail.OUT_WH_CODE, |
| | | indd023 = "", |
| | | indd024 = detail.BATCH_NO_IN, |
| | | indd103 = detail.OUTQTY.ToString(), |
| | | indd032 = detail.INWAREHOUSECODE, |
| | | indd024 = detail.IN_LOTNO, |
| | | indd103 = detail.QTY_OUT.ToString(), |
| | | indd032 = detail.IN_WH_CODE, |
| | | indd033 = "" |
| | | }); |
| | | } |
| | |
| | | indcdocno = "1201", |
| | | indcdocdt = DateTime.Now.ToString("yyyy/MM/dd"), |
| | | indc004 = "L16225", //detailLst[0].CREATE_USER, |
| | | indc008 = data.SOURCECODE, |
| | | indc008 = data.SOURCE_ORDER, |
| | | detail = details |
| | | } |
| | | } |
| | |
| | | |
| | | #endregion åèµ·è¯·æ± |
| | | |
| | | var res = returnData.Where(i => i.BILLCODE == data.BILLCODE).FirstOrDefault(); |
| | | var retuendetailData = returnDetailData.Where(i => i.BILLCODE == data.BILLCODE).ToList(); |
| | | var res = returnData.Where(i => i.BILLCODE == data.ORDER_NO).FirstOrDefault(); |
| | | var retuendetailData = returnDetailData.Where(i => i.BILLCODE == data.ORDER_NO).ToList(); |
| | | |
| | | if (!string.IsNullOrWhiteSpace(result.payload.std_data?.parameter?.docno)) |
| | | { |
| | | data.ERP_BILL_CODE = result.payload.std_data?.parameter?.docno;// æ´æ°åå· |
| | | data.ERP_ORDER = result.payload.std_data?.parameter?.docno;// æ´æ°åå· |
| | | foreach (var item in detailLst) |
| | | { |
| | | item.ERP_BILL_CODE = result.payload.std_data?.parameter?.docno; |
| | | item.ERP_ORDER = result.payload.std_data?.parameter?.docno; |
| | | } |
| | | DB.Updateable(detailLst).ExecuteCommand(); |
| | | |
| | |
| | | DB.Updateable(res).ExecuteCommand();// æ°æ®æ´æ° |
| | | } |
| | | } |
| | | if (result.payload.std_data?.execution.code == "S" && string.IsNullOrWhiteSpace(data.ERP_BILL_CODE)) |
| | | if (result.payload.std_data?.execution.code == "S" && string.IsNullOrWhiteSpace(data.ERP_ORDER)) |
| | | { |
| | | data.ERP_BILL_CODE = "T100è¿åä¿¡æ¯å·²è¿è´¦";// æ´æ°åå· |
| | | data.ERP_ORDER = "T100è¿åä¿¡æ¯å·²è¿è´¦";// æ´æ°åå· |
| | | } |
| | | Logger.Scheduler.Info($"è°æ¨åå·: {data.BILLCODE}ï¼T100è¿ååå·: {result.payload.std_data?.parameter?.docno}"); |
| | | Logger.Scheduler.Info($"è°æ¨åå·: {data.ORDER_NO}ï¼T100è¿ååå·: {result.payload.std_data?.parameter?.docno}"); |
| | | DB.Updateable(data).ExecuteCommand();// æ°æ®æ´æ° |
| | | } |
| | | Logger.Scheduler.Info("è°æ¨åä¿¡æ¯æ¨é宿"); |
| | |
| | | public int GetTrasferInfoToT100Plan2(InputDTO input) |
| | | { |
| | | var DB = Biz.Db; |
| | | var dataList = DB.Queryable<BIZ_WMS_TRANSFER>().Where(i => i.STATUS == BIZ_WMS_TRANSFER.STATUSs.COMPLETE.GetValue() && string.IsNullOrWhiteSpace(i.ERP_BILL_CODE) && i.AUTH_ORG == input.site).ToList(); |
| | | var dataList = DB.Queryable<BIZ_WMS_TRANSFER>().Where(i => i.STATUS == BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue() && string.IsNullOrWhiteSpace(i.ERP_ORDER) && i.AUTH_ORG == input.site).ToList(); |
| | | |
| | | Logger.Scheduler.Info("ç´æ¥è¿è´¦è°æ¨åä¿¡æ¯å¼å§æ¨éãããæ°æ®æ£æ¥è¿è¡ä¸ããã"); |
| | | if (!dataList.Any()) |
| | |
| | | return 0; |
| | | } |
| | | |
| | | var billcodeLst = dataList.Select(i => i.BILLCODE).Distinct().ToList(); |
| | | var detailData = DB.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(i => billcodeLst.Contains(i.BILLCODE)).ToList();// è·åæç»æ°æ® |
| | | var billcodeLst = dataList.Select(i => i.ORDER_NO).Distinct().ToList(); |
| | | var detailData = DB.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(i => billcodeLst.Contains(i.ORDER_NO)).ToList();// è·åæç»æ°æ® |
| | | |
| | | Logger.Scheduler.Info("è°æ¨åä¿¡æ¯å¼å§æ¨éããã"); |
| | | foreach (var data in dataList) |
| | | { |
| | | var detailLst = detailData.Where(i => i.BILLCODE == data.BILLCODE).ToList(); |
| | | var detailLst = detailData.Where(i => i.ORDER_NO == data.ORDER_NO).ToList(); |
| | | var details = new List<TrasferDetailDTO>(); |
| | | foreach (var detail in detailLst) |
| | | { |
| | | details.Add(new TrasferDetailDTO() |
| | | { |
| | | inddseq = detail.BILLLINE, |
| | | indd103 = detail.OUTQTY.ToString(), |
| | | inddseq = detail.ORDER_LINE, |
| | | indd103 = detail.QTY_OUT.ToString(), |
| | | }); |
| | | } |
| | | |
| | |
| | | { |
| | | parameter = new ParameterTrasferInfoDTO() |
| | | { |
| | | indcdocno = data.BILLCODE, |
| | | indcdocno = data.ORDER_NO, |
| | | indc022 = DateTime.Now.ToString("yyyy/MM/dd"), |
| | | detail = details |
| | | } |
| | |
| | | var requestJson = JsonConvert.SerializeObject(model); |
| | | var response = HttpHelper.PostAsync(t100Url, requestJson).Result; |
| | | result = JsonConvert.DeserializeObject<T100ActionResult<resultStd_data<ParameterTransferInfoT100>>>(response.Message); |
| | | Logger.Scheduler.Info($"è°æ¨åè¿è´¦æäº¤Json: {requestJson}ï¼è°æ¨åå·ï¼{data.BILLCODE}ï¼è¿åJson: {response.Message}"); |
| | | Logger.Scheduler.Info($"è°æ¨åè¿è´¦æäº¤Json: {requestJson}ï¼è°æ¨åå·ï¼{data.ORDER_NO}ï¼è¿åJson: {response.Message}"); |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | |
| | | if (!string.IsNullOrWhiteSpace(result.payload.std_data?.parameter?.docno)) |
| | | { |
| | | Result = result.payload.std_data?.parameter?.docno; |
| | | data.ERP_BILL_CODE = result.payload.std_data?.parameter?.docno;// æ´æ°åå· |
| | | Logger.Scheduler.Info($"è°æ¨åå·ï¼{data.BILLCODE}对åºçT100è¿ååå·ï¼{result.payload.std_data?.parameter?.docno}å·²æ´æ°"); |
| | | data.ERP_ORDER = result.payload.std_data?.parameter?.docno;// æ´æ°åå· |
| | | Logger.Scheduler.Info($"è°æ¨åå·ï¼{data.ORDER_NO}对åºçT100è¿ååå·ï¼{result.payload.std_data?.parameter?.docno}å·²æ´æ°"); |
| | | } |
| | | if (result.payload.std_data?.execution.code == "S" && string.IsNullOrWhiteSpace(data.ERP_BILL_CODE)) |
| | | if (result.payload.std_data?.execution.code == "S" && string.IsNullOrWhiteSpace(data.ERP_ORDER)) |
| | | { |
| | | data.ERP_BILL_CODE = "T100è¿åä¿¡æ¯å·²è¿è´¦"; |
| | | data.ERP_ORDER = "T100è¿åä¿¡æ¯å·²è¿è´¦"; |
| | | Result = "T100è¿åä¿¡æ¯å·²è¿è´¦"; |
| | | Logger.Scheduler.Info($"è°æ¨åå·ï¼{data.BILLCODE}对åºçT100è¿åä¿¡æ¯ï¼{"T100è¿åä¿¡æ¯å·²è¿è´¦"}å·²æ´æ°"); |
| | | Logger.Scheduler.Info($"è°æ¨åå·ï¼{data.ORDER_NO}对åºçT100è¿åä¿¡æ¯ï¼{"T100è¿åä¿¡æ¯å·²è¿è´¦"}å·²æ´æ°"); |
| | | } |
| | | if (!string.IsNullOrWhiteSpace(Result)) |
| | | { |
| | |
| | | { |
| | | ID = Guid.NewGuid().ToString("N"), |
| | | AUTH_ORG = input.site, |
| | | BILLCODE = item.indcdocno, |
| | | BILLDATE = item.indcdocdt.ToDateTime(), |
| | | ORDER_NO = item.indcdocno, |
| | | ORDER_DATE = item.indcdocdt.ToDateTime(), |
| | | CREATE_USER = "T100-" + item.indc004 |
| | | }; |
| | | |
| | |
| | | { |
| | | detailData.Add(new BIZ_WMS_TRANSFER_DTL() |
| | | { |
| | | BILLCODE = ser.indddocno, |
| | | BILLLINE = ser.inddseq.ToString(), |
| | | ORDER_NO = ser.indddocno, |
| | | ORDER_LINE = ser.inddseq.ToString(), |
| | | ITEM_CODE = ser.indd002, |
| | | UNITCODE = ser.indd006, |
| | | PRQTY = ser.indd103, |
| | | UNIT = ser.indd006, |
| | | QTY_REQ = ser.indd103, |
| | | AUTH_ORG = input.site, |
| | | OUTWAREHOUSECODE = ser.indd022, |
| | | INWAREHOUSECODE = ser.indd032 |
| | | OUT_WH_CODE = ser.indd022, |
| | | IN_WH_CODE = ser.indd032 |
| | | }); |
| | | transferData.INWAREHOUSECODE = ser.indd032; |
| | | transferData.OUTWAREHOUSECODE = ser.indd022; |
| | | transferData.IN_WH_CODE = ser.indd032; |
| | | transferData.OUT_WH_CODE = ser.indd022; |
| | | } |
| | | } |
| | | |
| | |
| | | |
| | | foreach (var item in masterData) |
| | | { |
| | | var detaildatas = detailData.Where(i => i.BILLCODE == item.BILLCODE).ToList(); |
| | | var detaildatas = detailData.Where(i => i.ORDER_NO == item.ORDER_NO).ToList(); |
| | | var detaildto = new List<TrasferInfoDetailDTO>(); |
| | | foreach (var detailitem in detaildatas) |
| | | { |
| | | detaildto.Add(new TrasferInfoDetailDTO() |
| | | { |
| | | BILLCODE = detailitem.BILLCODE, |
| | | BILLLINE = Convert.ToInt32(detailitem.BILLLINE), |
| | | LINESTATUS = detailitem.LINESTATUS.ToString(), |
| | | OUTQTY = detailitem.OUTQTY, |
| | | BILLCODE = detailitem.ORDER_NO, |
| | | BILLLINE = Convert.ToInt32(detailitem.ORDER_LINE), |
| | | LINESTATUS = detailitem.STATUS.ToString(), |
| | | OUTQTY = detailitem.QTY_OUT, |
| | | ITEM_CODE = detailitem.ITEM_CODE, |
| | | UNITCODE = detailitem.UNITCODE, |
| | | PRQTY = detailitem.PRQTY, |
| | | OUTWAREHOUSECODE = detailitem.OUTWAREHOUSECODE, |
| | | INWAREHOUSECODE = detailitem.INWAREHOUSECODE, |
| | | UNITCODE = detailitem.UNIT, |
| | | PRQTY = detailitem.QTY_REQ, |
| | | OUTWAREHOUSECODE = detailitem.OUT_WH_CODE, |
| | | INWAREHOUSECODE = detailitem.IN_WH_CODE, |
| | | CREATE_TIME = DateTime.Now |
| | | }); |
| | | } |
| | | inputdto.Add(new TrasferInfoDTO() |
| | | { |
| | | AUTH_ORG = input.site, |
| | | BILLCODE = item.BILLCODE, |
| | | BILLDATE = item.BILLDATE, |
| | | OUTWAREHOUSECODE = item.OUTWAREHOUSECODE, |
| | | INWAREHOUSECODE = item.INWAREHOUSECODE, |
| | | BILLCODE = item.ORDER_NO, |
| | | BILLDATE = item.ORDER_DATE, |
| | | OUTWAREHOUSECODE = item.OUT_WH_CODE, |
| | | INWAREHOUSECODE = item.IN_WH_CODE, |
| | | CREATE_TIME = item.CREATE_TIME, |
| | | details = detaildto |
| | | }); |
| | |
| | | snLst.Add(new BIZ_WMS_TRANSFER_SN() |
| | | { |
| | | AUTH_ORG = warehouse.OrgCode, |
| | | BILLCODE = input.BillCode, |
| | | ORDER_NO = input.BillCode, |
| | | SN = item.SN, |
| | | STATUS = WMS_ITEM.STATUSs.WaitIn.GetValue(), |
| | | ITEM_CODE = snData.Where(i => i.SN == item.SN).FirstOrDefault()?.ITEM_CODE, |
| | | QTY = item.Qty, |
| | | BILLLINE = dicitemcode[item.ItemCode] |
| | | ORDER_LINE = dicitemcode[item.ItemCode] |
| | | }); |
| | | } |
| | | } |
| | |
| | | |
| | | if (snLst.Any()) |
| | | { |
| | | var history = db.Queryable<BIZ_WMS_TRANSFER_SN>().Where(i => i.BILLCODE == input.BillCode).ToList(); |
| | | var history = db.Queryable<BIZ_WMS_TRANSFER_SN>().Where(i => i.ORDER_NO == input.BillCode).ToList(); |
| | | if (history.Any()) |
| | | { |
| | | db.Deleteable(history).ExecuteCommand(); |
| | |
| | | { |
| | | foreach (var item in masterData) |
| | | { |
| | | item.SOURCECODE = item.BILLCODE; |
| | | item.SOURCE_ORDER = item.ORDER_NO; |
| | | } |
| | | } |
| | | var detailSource = new List<TrasferInfoDetailDTO>(); |
| | |
| | | //var db = Biz.Db;// åºåæ£å¼åºè¿æ¯æµè¯åº |
| | | var db = Biz.DataSource["WMS57"].Client; // åºåæ£å¼åºè¿æ¯æµè¯åº |
| | | |
| | | var BILLCODELst = masterData.Select(i => i.BILLCODE).Distinct().ToList(); |
| | | var BILLCODELst = masterData.Select(i => i.ORDER_NO).Distinct().ToList(); |
| | | |
| | | #region åºå主表éè¦æå
¥åæ´æ°çæ°æ® |
| | | |
| | | var hostoryMasterData = db.Queryable<BIZ_WMS_TRANSFER>().Where(i => BILLCODELst.Contains(i.BILLCODE)).ToList();// è·åä¸»è¡¨æ§æ°æ® |
| | | var resMaster = hostoryMasterData.Select(i => i.BILLCODE).Distinct().ToList(); |
| | | var masterNeedInsert = masterData.Where(i => !resMaster.Contains(i.BILLCODE)).ToList();// éè¦æå
¥çæ°æ® |
| | | var masterNeedUpdate = masterData.Where(i => resMaster.Contains(i.BILLCODE)).ToList();// éè¦æ´æ°çæ°æ® |
| | | var hostoryMasterData = db.Queryable<BIZ_WMS_TRANSFER>().Where(i => BILLCODELst.Contains(i.ORDER_NO)).ToList();// è·åä¸»è¡¨æ§æ°æ® |
| | | var resMaster = hostoryMasterData.Select(i => i.ORDER_NO).Distinct().ToList(); |
| | | var masterNeedInsert = masterData.Where(i => !resMaster.Contains(i.ORDER_NO)).ToList();// éè¦æå
¥çæ°æ® |
| | | var masterNeedUpdate = masterData.Where(i => resMaster.Contains(i.ORDER_NO)).ToList();// éè¦æ´æ°çæ°æ® |
| | | foreach (var item in masterNeedUpdate) |
| | | { |
| | | item.ID = hostoryMasterData.Where(i => i.BILLCODE == item.BILLCODE).FirstOrDefault()?.ID; |
| | | item.ID = hostoryMasterData.Where(i => i.ORDER_NO == item.ORDER_NO).FirstOrDefault()?.ID; |
| | | } |
| | | |
| | | #endregion åºå主表éè¦æå
¥åæ´æ°çæ°æ® |
| | | |
| | | #region åºåæç»è¡¨éè¦æå
¥åæ´æ°çæ°æ® |
| | | |
| | | var hostoryDetailData = db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(i => BILLCODELst.Contains(i.BILLCODE)).ToList();// è·åæç»è¡¨æ§æ°æ® åé¤ç¶æä¸º2çæ°æ® |
| | | var hostoryDetailData = db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(i => BILLCODELst.Contains(i.ORDER_NO)).ToList();// è·åæç»è¡¨æ§æ°æ® åé¤ç¶æä¸º2çæ°æ® |
| | | var resDetail = hostoryDetailData.Select(i => i.ITEM_CODE).Distinct().ToList();// è·åææçç©æç¼å· |
| | | var ignoreCode = hostoryDetailData.Where(i => i.LINESTATUS == 2 || i.LINESTATUS == 3).Select(i => i.ITEM_CODE).Distinct().ToList();// éè¦å¿½ç¥çç©æç¼å· |
| | | var ignoreCode = hostoryDetailData.Where(i => i.STATUS == 2 || i.STATUS == 3).Select(i => i.ITEM_CODE).Distinct().ToList();// éè¦å¿½ç¥çç©æç¼å· |
| | | var needInsertData = detailData.Where(i => !resDetail.Contains(i.ITEM_CODE) && !ignoreCode.Contains(i.ITEM_CODE)).ToList();// éè¦æå
¥çæ°æ® |
| | | if (type == "1") |
| | | { |
| | | foreach (var item in needInsertData) |
| | | { |
| | | item.OUTQTY = 0; |
| | | item.QTY_OUT = 0; |
| | | } |
| | | } |
| | | |
| | |
| | | |
| | | foreach (var item in needUpdateDetail) |
| | | { |
| | | if (item.LINESTATUS == 0 && type == "1") |
| | | if (item.STATUS == 0 && type == "1") |
| | | { |
| | | item.OUTQTY = 0; |
| | | item.QTY_OUT = 0; |
| | | } |
| | | item.AUTH_ORG = input[0].AUTH_ORG; |
| | | } |
| | |
| | | var exceptCode = detailData.Select(i => i.ITEM_CODE).Distinct().ToList(); |
| | | var deletecode = resDetail.Except(exceptCode).ToList(); |
| | | |
| | | var needDeleteData = hostoryDetailData.Where(i => deletecode.Contains(i.ITEM_CODE) && BILLCODELst.Contains(i.BILLCODE)).ToList(); |
| | | var needDeleteData = hostoryDetailData.Where(i => deletecode.Contains(i.ITEM_CODE) && BILLCODELst.Contains(i.ORDER_NO)).ToList(); |
| | | |
| | | foreach (var item in needUpdateDetail) |
| | | { |
| | |
| | | // _materialInfoBusiness = materialInfoBusiness; |
| | | //} |
| | | |
| | | public static List<string> strongHoldList = new List<string> |
| | | { |
| | | "XCSJ", |
| | | "DGXC", |
| | | "AHXC" |
| | | }; |
| | | |
| | | /// <summary> |
| | | /// åæ¥ç©æä¿¡æ¯å®æ¶ä»»å¡ |
| | | /// </summary> |
| | |
| | | try |
| | | { |
| | | Logger.Scheduler.Info(context.Trigger.ConvertToMonitor()); //计åä»»å¡å¼å§æ¥å¿ |
| | | foreach (var item in BIZ_WMS_TRANSFER.strongHoldList) |
| | | foreach (var item in strongHoldList) |
| | | { |
| | | var model = new InputDTO() |
| | | { |
| | |
| | | return action; |
| | | } |
| | | string billCode = barcodeScanneds?.BUSINESSCODE; |
| | | string billCodeT = barcodeScannedsT?.BILLCODE; |
| | | string billCodeT = barcodeScannedsT?.ORDER_NO; |
| | | //string billLine = barcodeScanneds[0].BILLLINE; |
| | | |
| | | foreach (var item in inv.Items) |
| | |
| | | } |
| | | Logger.Default.Info($"æ´æ°åæ®æç»ä¿¡æ¯:åå·[{billCode}]ï¼é¡¹æ¬¡[{string.Join(",", billDetail.Select(q=>q.BILLLINE))}]ï¼æ°é[{string.Join(",", billDetail.Select(q => q.INVENTORYQTY))}]ï¼ç¶æ[{string.Join(",", billDetail.Select(q => q.LINESTATUS))}]"); |
| | | //è°æ¨å |
| | | var billDetailT = Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(t => t.BILLCODE.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE == inv.ItemInfo.ITEM_CODE).ToList(); |
| | | var billDetailT = Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(t => t.ORDER_NO.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE == inv.ItemInfo.ITEM_CODE).ToList(); |
| | | foreach (var dtl in billDetailT) |
| | | { |
| | | dtl.INWAREHOUSECODE = putOnInfo.Warehouse.WH_CODE; |
| | | dtl.IN_WH_CODE = putOnInfo.Warehouse.WH_CODE; |
| | | } |
| | | var totalT = Biz.Db.Queryable<BIZ_WMS_TRANSFER_SN>() |
| | | .Where(t => t.BILLCODE.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE == inv.ItemInfo.ITEM_CODE) |
| | | .Where(t => t.ORDER_NO.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE == inv.ItemInfo.ITEM_CODE) |
| | | .Where(t => t.STATUS == WMS_ITEM.STATUSs.InStore.GetValue() || inv.Items.Select(q => q.SN).Contains(t.SN)) |
| | | .Sum(x => x.QTY); |
| | | foreach (var dtl in billDetailT) |
| | | { |
| | | dtl.INQTY = total; |
| | | dtl.INVENTORYQTY = total; |
| | | dtl.QTY_IN = total; |
| | | //dtl.INVENTORYQTY = total; |
| | | if (dtl.ITEM_CODE == lotNo?.ITEM_CODE) |
| | | { |
| | | dtl.BATCH_NO_IN = WarehouseName.Contains("客ä¾") ? lotNo.LOTNO : ""; |
| | | dtl.BATCH_NO_OUT = WarehouseName.Contains("客ä¾") ? lotNo.LOTNO : ""; |
| | | dtl.IN_LOTNO = WarehouseName.Contains("客ä¾") ? lotNo.LOTNO : ""; |
| | | dtl.OUT_LOTNO = WarehouseName.Contains("客ä¾") ? lotNo.LOTNO : ""; |
| | | } |
| | | } |
| | | //billDetail.DELIVERYDATE = DateTime.Now.Date; |
| | | //billDetail.QTY = total; //inv.Barcode.Qty.ToDouble(); |
| | | var isCompletedT = false; |
| | | // æ´æ°åæ®HEADERç¶æ |
| | | var billHeaderT = Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(t => t.BILLCODE.ToUpper() == billCodeT).First(); |
| | | if (billDetailT.Sum(t => t.PRQTY) == totalT) |
| | | var billHeaderT = Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(t => t.ORDER_NO.ToUpper() == billCodeT).First(); |
| | | if (billDetailT.Sum(t => t.QTY_REQ) == totalT) |
| | | { |
| | | foreach (var dtl in billDetailT) |
| | | { |
| | | dtl.LINESTATUS = BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue(); |
| | | dtl.STATUS = BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue(); |
| | | } |
| | | |
| | | //barcodeScanned.STATUS = WMS_ITEM.STATUSs.InStore.GetValue(); |
| | | if (!Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(t => t.BILLCODE.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE != inv.ItemInfo.ITEM_CODE && t.LINESTATUS != BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue()).Any()) |
| | | if (!Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(t => t.ORDER_NO.ToUpper() == billCodeT.ToUpper() && t.ITEM_CODE != inv.ItemInfo.ITEM_CODE && t.STATUS != BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue()).Any()) |
| | | { |
| | | billHeaderT.STATUS = BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue(); |
| | | billHeaderT.STATUS = BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue(); |
| | | isCompletedT = true; |
| | | } |
| | | } |
| | |
| | | { |
| | | foreach (var dtl in billDetailT) |
| | | { |
| | | dtl.LINESTATUS = BIZ_WMS_TRANSFER.STATUSs.WORKING.GetValue(); |
| | | dtl.STATUS = BIZ_WMS_TRANSFER.STATUSs.Storing.GetValue(); |
| | | } |
| | | } |
| | | Logger.Default.Info($"æ´æ°åæ®æç»ä¿¡æ¯:åå·[{billCodeT}]ï¼é¡¹æ¬¡[{string.Join(",", billDetailT.Select(q => q.BILLLINE))}]ï¼æ°é[{string.Join(",", billDetailT.Select(q => q.INVENTORYQTY))}]ï¼ç¶æ[{string.Join(",", billDetail.Select(q => q.LINESTATUS))}]"); |
| | | Logger.Default.Info($"æ´æ°åæ®æç»ä¿¡æ¯:åå·[{billCodeT}]ï¼é¡¹æ¬¡[{string.Join(",", billDetailT.Select(q => q.ORDER_LINE))}]ï¼æ°é[{string.Join(",", billDetailT.Select(q => q.QTY_IN))}]ï¼ç¶æ[{string.Join(",", billDetail.Select(q => q.LINESTATUS))}]"); |
| | | |
| | | #endregion |
| | | |
| | |
| | | var MaterialReqTrans = Biz.Db.Queryable<BIZ_ERP_PROD_OUT>().Where(t => t.BILLCODE == ReqNo).Any(); |
| | | var OthReqTrans = Biz.Db.Queryable<BIZ_ERP_OTH_OUT>().Where(t => t.BILLCODE == ReqNo).Any(); |
| | | var SaleReqTrans = Biz.Db.Queryable<BIZ_ERP_SALE_OUT>().Where(t => t.BILLCODE == ReqNo).Any(); |
| | | var TfTrans = Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(t => t.BILLCODE == ReqNo).Any(); |
| | | var TfTrans = Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(t => t.ORDER_NO == ReqNo).Any(); |
| | | ProductionMaterialReq trans = null; |
| | | OutWorkOrder owoTrans = null; |
| | | OutOther othTrans = null; |
| | |
| | | var action = new ApiAction<ProdReqOutput>(); |
| | | try |
| | | { |
| | | req = await Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.BILLCODE == input.ReqNo).Includes(q => q.DtlsWithGhost, d => d.ItemInfo).IncludesAllFirstLayer().FirstAsync(); |
| | | req = await Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.ORDER_NO == input.ReqNo).Includes(q => q.DtlsWithGhost, d => d.ItemInfo).IncludesAllFirstLayer().FirstAsync(); |
| | | //éªè¯æç»æ¯å¦æ£ç¡® |
| | | if (!req.Dtls.Any()) |
| | | { |
| | |
| | | } |
| | | |
| | | //å¦ææ¯æå·¥å建çè°æ¨å |
| | | isManual = req.STATUS == BIZ_WMS_TRANSFER.STATUSs.MANUAL.GetValue(); |
| | | isManual = req.STATUS == BIZ_WMS_TRANSFER.STATUSs.Imported.GetValue(); |
| | | |
| | | Biz.Db.Deleteable<WMS_ITEM_POOL>().Where(q => q.TRANS_CODE == req.BILLCODE).ExecuteCommand(); |
| | | Biz.Db.Deleteable<WMS_ITEM_POOL>().Where(q => q.TRANS_CODE == req.ORDER_NO).ExecuteCommand(); |
| | | //妿ä¸ä¸æ¬¡æ¨èææ°æ®ï¼åå
çæäº®çç¯ |
| | | if (Suggests.Any()) |
| | | { |
| | |
| | | |
| | | var begin = DateTime.Now; |
| | | var ElapsedTime = 0.0; |
| | | var sumDtls = req.Dtls.Where(q => q.LINESTATUS != BIZ_WMS_TRANSFER.STATUSs.COMPLETE.GetValue()) |
| | | .GroupBy(x => new { x.ITEM_CODE }).Select(x => new { ItemCode = x.Key.ITEM_CODE.ToString(), WarehouseCode = x.Max(t => t.OUTWAREHOUSECODE), actQty = x.Sum(t => t.PRQTY - t.OUTQTY), lockObj = new object() }); |
| | | var sumDtls = req.Dtls.Where(q => q.STATUS != BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue()) |
| | | .GroupBy(x => new { x.ITEM_CODE }).Select(x => new { ItemCode = x.Key.ITEM_CODE.ToString(), WarehouseCode = x.Max(t => t.OUT_WH_CODE), actQty = x.Sum(t => t.QTY_REQ - t.QTY_OUT), lockObj = new object() }); |
| | | var dic = sumDtls.ToDictionary(k => k, v => new Result<List<SuggestItem>>()); |
| | | foreach (var item in dic) |
| | | { |
| | |
| | | { |
| | | lock (item.Key.lockObj) |
| | | { |
| | | dic[item.Key] = WMS_ITEM_Biz.WmsItem.Suggest(req.BILLCODE, item.Key.ItemCode, item.Key.WarehouseCode, null, null, null, input.AuthOption, item.Key.actQty); |
| | | dic[item.Key] = WMS_ITEM_Biz.WmsItem.Suggest(req.ORDER_NO, item.Key.ItemCode, item.Key.WarehouseCode, null, null, null, input.AuthOption, item.Key.actQty); |
| | | } |
| | | }); |
| | | } |
| | |
| | | var actQty = sumDtls.ToList().Where(x => x.ItemCode.Trim() == inv.Item.ITEM_CODE.Trim()).Select(x => x.actQty).FirstOrDefault(); |
| | | if (actQty > 0) |
| | | { |
| | | inv.poolItem = inv.Item.GetPoolItem(input.AuthOption.OrgCode, nameof(req), req.BILLCODE, null, actQty, false); |
| | | inv.poolItem = inv.Item.GetPoolItem(input.AuthOption.OrgCode, nameof(req), req.ORDER_NO, null, actQty, false); |
| | | } |
| | | else |
| | | { |
| | |
| | | await Share.Shelf.LightMulti(TransID, light.Color, locs); |
| | | action.Data = new ProdReqOutput() |
| | | { |
| | | ReqNo = req.BILLCODE, |
| | | ReqNo = req.ORDER_NO, |
| | | ReqType = light.ReqType.GetValue() |
| | | }; |
| | | action.LocaleMsg = Biz.L("äº®ç¯æåï¼äº®ç¯é¢è²[{0}]", light.Color.GetDesc()); |
| | |
| | | var action = new ApiAction(); |
| | | try |
| | | { |
| | | var dtls = req.Dtls.GroupBy(x => new { x.BILLLINE, x.ITEM_CODE, x.ItemInfo.ITEM_NAME }).Select(x => new ProdReqDtl() { BillLine = x.Key.BILLLINE.ToInt32(), ItemCode = x.Key.ITEM_CODE, ItemName = x.Key.ITEM_NAME, Status = "", Items = new List<ProdReqDtlItems>() }).ToList(); |
| | | var dtls = req.Dtls.GroupBy(x => new { x.ORDER_LINE, x.ITEM_CODE, x.ItemInfo.ITEM_NAME }).Select(x => new ProdReqDtl() { BillLine = x.Key.ORDER_LINE.ToInt32(), ItemCode = x.Key.ITEM_CODE, ItemName = x.Key.ITEM_NAME, Status = "", Items = new List<ProdReqDtlItems>() }).ToList(); |
| | | foreach (var d in dtls) |
| | | { |
| | | d.Items = Suggests.Where(x => x.Item.ITEM_CODE == d.ItemCode).Select(x => new ProdReqDtlItems { WHCode = x.Warehouse.WH_CODE, LocationCode = x.Location.LOCATION_CODE, SN = x.Item.SN, QTY = x.Item.QTY }).ToList(); |
| | | d.Status = $"{(double)req.Dtls.Where(x => x.ITEM_CODE == d.ItemCode).Sum(x => x.OUTQTY)} / {(double)req.Dtls.Where(x => x.ITEM_CODE == d.ItemCode).Sum(x => x.PRQTY)} {Suggests.FirstOrDefault()?.Item?.UNIT} (è¿é{d.Items.Count}个)"; |
| | | d.Status = $"{(double)req.Dtls.Where(x => x.ITEM_CODE == d.ItemCode).Sum(x => x.QTY_OUT)} / {(double)req.Dtls.Where(x => x.ITEM_CODE == d.ItemCode).Sum(x => x.QTY_REQ)} {Suggests.FirstOrDefault()?.Item?.UNIT} (è¿é{d.Items.Count}个)"; |
| | | } |
| | | action.Data = itemcode.IsNullOrEmpty() ? dtls.OrderBy(q => q.BillLine) : dtls.Where(x => x.ItemCode == itemcode).FirstOrDefault()?.Items.OrderBy(q => q.SN); |
| | | } |
| | |
| | | var action = new ApiAction(); |
| | | try |
| | | { |
| | | action.Data = $"ç©æ{itemcode}ï¼å·²ä¸æ¶[{(double)req.Dtls.Where(x => x.ITEM_CODE == itemcode).Sum(x => x.OUTQTY)}]ï¼å
±{(double)req.Dtls.Where(x => x.ITEM_CODE == itemcode).Sum(x => x.PRQTY)} {Suggests.FirstOrDefault()?.Item?.UNIT}"; |
| | | action.Data = $"ç©æ{itemcode}ï¼å·²ä¸æ¶[{(double)req.Dtls.Where(x => x.ITEM_CODE == itemcode).Sum(x => x.QTY_OUT)}]ï¼å
±{(double)req.Dtls.Where(x => x.ITEM_CODE == itemcode).Sum(x => x.QTY_REQ)} {Suggests.FirstOrDefault()?.Item?.UNIT}"; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | |
| | | } |
| | | |
| | | //ä»åºå¡æ§ |
| | | if (!req.Dtls.Any(q => q.ITEM_CODE == CurInv.ItemInfo.ITEM_CODE && q.OUTWAREHOUSECODE == CurInv.Warehouse.WH_CODE)) |
| | | if (!req.Dtls.Any(q => q.ITEM_CODE == CurInv.ItemInfo.ITEM_CODE && q.OUT_WH_CODE == CurInv.Warehouse.WH_CODE)) |
| | | { |
| | | action.IsSuccessed = false; |
| | | action.LocaleMsg = Biz.L($"æ¡ç [{CurInv.Barcode.SN}]çæå·æè
ä»åºè·åæ®[{req.BILLCODE}]ä¸çä¸ä¸è´"); |
| | | action.LocaleMsg = Biz.L($"æ¡ç [{CurInv.Barcode.SN}]çæå·æè
ä»åºè·åæ®[{req.ORDER_NO}]ä¸çä¸ä¸è´"); |
| | | return action; |
| | | } |
| | | |
| | |
| | | |
| | | //2.æ¯å¦è¶
å |
| | | isExceed = false; |
| | | req = await Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.BILLCODE == req.BILLCODE).Includes(q => q.DtlsWithGhost, d => d.ItemInfo).IncludesAllFirstLayer().FirstAsync(); |
| | | req = await Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.ORDER_NO == req.ORDER_NO).Includes(q => q.DtlsWithGhost, d => d.ItemInfo).IncludesAllFirstLayer().FirstAsync(); |
| | | dtls = req.Dtls.Where(x => x.ITEM_CODE == CurInv.ItemInfo.ITEM_CODE).ToList(); |
| | | if (dtls.IsNullOrEmpty()) |
| | | { |
| | |
| | | } |
| | | |
| | | //å¦æç¶æå®æ |
| | | if (dtls.Where(x => x.LINESTATUS == BIZ_WMS_TRANSFER.STATUSs.COMPLETE.GetValue()).Count() == dtls.Count) |
| | | if (dtls.Where(x => x.STATUS == BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue()).Count() == dtls.Count) |
| | | { |
| | | action.IsSuccessed = false; |
| | | action.LocaleMsg = Biz.L("æå·²ç»åå®"); |
| | | return action; |
| | | } |
| | | var actQty = dtls.Sum(x => x.OUTQTY > x.PRQTY ? 0 : x.PRQTY - x.OUTQTY); |
| | | var actQty = dtls.Sum(x => x.QTY_OUT > x.QTY_REQ ? 0 : x.QTY_REQ - x.QTY_OUT); |
| | | cutQty = 0; |
| | | if (actQty < CurInv.CurPkg.QTY) |
| | | { |
| | |
| | | double curQty = CurInv.CurPkg.QTY; |
| | | foreach (var d in dtls) |
| | | { |
| | | var actPrQty = d.PRQTY - d.OUTQTY; |
| | | var actPrQty = d.QTY_REQ - d.QTY_OUT; |
| | | if (actPrQty > 0 && curQty > 0) |
| | | { |
| | | if (actPrQty >= curQty) |
| | | { |
| | | d.OUTQTY += curQty; |
| | | d.QTY_OUT += curQty; |
| | | curQty = 0; |
| | | } |
| | | else |
| | | { |
| | | d.OUTQTY = d.PRQTY; |
| | | d.QTY_OUT = d.QTY_REQ; |
| | | curQty -= actPrQty; |
| | | } |
| | | d.LINESTATUS = d.OUTQTY >= d.PRQTY ? BIZ_WMS_TRANSFER.STATUSs.COMPLETE.GetValue() : BIZ_WMS_TRANSFER.STATUSs.WORKING.GetValue(); |
| | | d.STATUS = d.QTY_OUT >= d.QTY_REQ ? BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue() : BIZ_WMS_TRANSFER.STATUSs.Storing.GetValue(); |
| | | //d.OUTWAREHOUSECODE = CurInv.Warehouse.WH_CODE; |
| | | } |
| | | } |
| | | if (isExceed) |
| | | { |
| | | if (CurInv.ItemInfo.DLVY_TYPE == BAS_ITEM.DLVY_TYPEs.ByDemand.GetValue() || req.BILLCODE.Substring(2, 4) == "5408" || req.BILLCODE.Substring(2, 4) == "5409") |
| | | if (CurInv.ItemInfo.DLVY_TYPE == BAS_ITEM.DLVY_TYPEs.ByDemand.GetValue() || req.ORDER_NO.Substring(2, 4) == "5408" || req.ORDER_NO.Substring(2, 4) == "5409") |
| | | { |
| | | isCutting = true; |
| | | isExceed = false; |
| | |
| | | else |
| | | { |
| | | //æå¤§æ°éæç»è¡ç¨äºè°æ¨ï¼è¯¥è¡åææ°éå ä¸åºæªææ°é |
| | | var tfdtl = dtls.OrderBy(q => q.BILLLINE.ToDecimal()).Last(); |
| | | tfdtl.OUTQTY += cutQty; |
| | | var tfdtl = dtls.OrderBy(q => q.ORDER_LINE.ToDecimal()).Last(); |
| | | tfdtl.QTY_OUT += cutQty; |
| | | } |
| | | } |
| | | |
| | |
| | | CutQty = CurInv.CurPkg.QTY - cutQty, |
| | | isCutting = isCutting, |
| | | isExceed = isExceed, |
| | | ReqNo = req.BILLCODE, |
| | | ReqNo = req.ORDER_NO, |
| | | regionCode = CurInv.Region.REGION_CODE, |
| | | locationCode = CurInv.Location?.LOCATION_CODE, |
| | | }; |
| | |
| | | SN = CurInv.CurPkg.SN, |
| | | ITEM_CODE = CurInv.ItemInfo.ITEM_CODE, |
| | | QTY = CurInv.CurPkg.QTY, |
| | | META_SN = CurInv.Barcode.MetaSn, |
| | | BILLCODE = req.BILLCODE, |
| | | BILLDATE = req.BILLDATE, |
| | | ORDER_NO = req.ORDER_NO, |
| | | //BILLLINE = tfdtl.BILLLINE |
| | | }; |
| | | |
| | | //4.æ´æ°ä¸å¡åæ®ï¼BIZ_WMS_TRANSFERãBIZ_WMS_TRANSFER_DTLãBIZ_WMS_TRANSFER_SN 夿æç»è¡ç¶ææ¯å¦å®æ |
| | | var isComplete = !req.Dtls.Any(x => x.LINESTATUS != BIZ_WMS_TRANSFER.STATUSs.COMPLETE.GetValue() && x.LINESTATUS != BIZ_WMS_TRANSFER.STATUSs.MANUALCOMPLETE.GetValue() && x.PRQTY > 0); |
| | | var isComplete = !req.Dtls.Any(x => x.STATUS != BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue() && x.STATUS != BIZ_WMS_TRANSFER.STATUSs.Picked.GetValue() && x.QTY_REQ > 0); |
| | | his_isComplete = isComplete; |
| | | if (isComplete) |
| | | { |
| | | //detailå
¨é¨å®æäº |
| | | req.STATUS = isManual ? BIZ_WMS_TRANSFER.STATUSs.MANUALCOMPLETE.GetValue() : BIZ_WMS_TRANSFER.STATUSs.COMPLETE.GetValue(); |
| | | req.STATUS = isManual ? BIZ_WMS_TRANSFER.STATUSs.Picked.GetValue() : BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue(); |
| | | } |
| | | else |
| | | { |
| | | req.STATUS = BIZ_WMS_TRANSFER.STATUSs.WORKING.GetValue(); |
| | | req.STATUS = BIZ_WMS_TRANSFER.STATUSs.Storing.GetValue(); |
| | | } |
| | | //妿æ¯Agv |
| | | if (CurReqType == ReqType.IsAgv) |
| | | { |
| | | req.STATUS = isManual ? BIZ_WMS_TRANSFER.STATUSs.MANUALCOMPLETE.GetValue() : BIZ_WMS_TRANSFER.STATUSs.COMPLETE.GetValue(); |
| | | req.STATUS = isManual ? BIZ_WMS_TRANSFER.STATUSs.Picked.GetValue() : BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue(); |
| | | } |
| | | |
| | | //5.åºåºä¸æ¶ |
| | | foreach (var item in CurInv.Items) |
| | | { |
| | | item.TRANS_CODE = nameof(BIZ_WMS_TRANSFER); |
| | | item.TRANS_NO = req.BILLCODE; |
| | | item.TRANS_LINE = string.Join(",", dtls.Select(x => x.BILLLINE)); |
| | | item.TRANS_NO = req.ORDER_NO; |
| | | item.TRANS_LINE = string.Join(",", dtls.Select(x => x.ORDER_LINE)); |
| | | item.SOURCE_CODE = "WORK_ORDER"; |
| | | item.SOURCE_ORDER = dtls.First().SOURCECODE; |
| | | item.SOURCE_ORDER = dtls.First().SOURCE_ORDER; |
| | | } |
| | | Result<TakeDownInfo> downResult = WMS_ITEM_Biz.WmsItem.TakeDown(CurInv, input.AuthOption, WMS_ITEM.STATUSs.Sended, !isCutting); |
| | | if (!downResult.IsSuccessed) |
| | |
| | | |
| | | //6. 对æ¥MESãAgv |
| | | |
| | | action.LocaleMsg = Biz.L($"è°æ¨åºåºå®æï¼åå·[{req.BILLCODE}]ï¼æ¡ç [{CurInv.SN}]ï¼ç¶æ[{req.STATUS.GetEnumDesc<BIZ_WMS_TRANSFER.STATUSs>()}]"); |
| | | action.LocaleMsg = Biz.L($"è°æ¨åºåºå®æï¼åå·[{req.ORDER_NO}]ï¼æ¡ç [{CurInv.SN}]ï¼ç¶æ[{req.STATUS.GetEnumDesc<BIZ_WMS_TRANSFER.STATUSs>()}]"); |
| | | action.Data = new ProdReqOutput() |
| | | { |
| | | SN = CurInv.SN, |
| | |
| | | CutQty = CurInv.CurPkg.QTY - cutQty, |
| | | isCutting = isCutting, |
| | | isExceed = isExceed, |
| | | ReqNo = req.BILLCODE, |
| | | ReqNo = req.ORDER_NO, |
| | | regionCode = CurInv.Region.REGION_CODE, |
| | | locationCode = CurInv.Location?.LOCATION_CODE, |
| | | }; |
| | |
| | | { |
| | | //needSaveHistoryLog = true; |
| | | CloseLight(LocationHis).Wait(); |
| | | if (!(req?.BILLCODE ?? "").IsNullOrEmpty()) |
| | | if (!(req?.ORDER_NO ?? "").IsNullOrEmpty()) |
| | | { |
| | | Biz.Db.Deleteable<WMS_ITEM_POOL>().Where(x => x.TRANS_NO == req.BILLCODE).ExecuteCommand(); |
| | | Biz.Db.Deleteable<WMS_ITEM_POOL>().Where(x => x.TRANS_NO == req.ORDER_NO).ExecuteCommand(); |
| | | } |
| | | Biz.Db.Deleteable<WMS_ITEM_POOL>().Where(q => CurPoolList.Select(q => q.SN).Contains(q.SN)).ExecuteCommand(); |
| | | //ä¿åæä½æ¥å¿ |
| | |
| | | var tfdtl = dtls.OrderBy(q => q.BILLLINE.ToDecimal()).Last(); |
| | | tfdtl.QTY += cutQty; |
| | | //è°æ¨ |
| | | transferH = Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.SOURCECODE == req.BILLCODE).First() ?? new() |
| | | transferH = Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.SOURCE_ORDER == req.BILLCODE).First() ?? new() |
| | | { |
| | | BILLCODE = "TF-" + req.BILLCODE, |
| | | BILLDATE = DateTime.Now, |
| | | STATUS = BIZ_WMS_TRANSFER.STATUSs.INIT.GetValue(), |
| | | BIZTYPE = null, |
| | | OUTWAREHOUSECODE = CurInv.Warehouse.WH_CODE, |
| | | INWAREHOUSECODE = CurInv.Warehouse.TRANSFER_WH, |
| | | SOURCETYPE = 0, |
| | | SOURCECODE = req.BILLCODE, |
| | | ORDER_NO = "TF-" + req.BILLCODE, |
| | | ORDER_DATE = DateTime.Now, |
| | | STATUS = BIZ_WMS_TRANSFER.STATUSs.Init.GetValue(), |
| | | OUT_WH_CODE = CurInv.Warehouse.WH_CODE, |
| | | IN_WH_CODE = CurInv.Warehouse.TRANSFER_WH, |
| | | SOURCE_CODE = nameof(req), |
| | | SOURCE_ORDER = req.BILLCODE, |
| | | AUTH_ORG = OrgCode |
| | | }; |
| | | |
| | | transferDtl = Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(x => x.BILLCODE == transferH.BILLCODE && x.BILLLINE == tfdtl.BILLLINE).First() ?? new() |
| | | transferDtl = Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(x => x.ORDER_NO == transferH.ORDER_NO && x.ORDER_LINE == tfdtl.BILLLINE).First() ?? new() |
| | | { |
| | | BILLCODE = transferH.BILLCODE, |
| | | BILLLINE = tfdtl.BILLLINE, |
| | | LINESTATUS = BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue(), |
| | | ORDER_NO = transferH.ORDER_NO, |
| | | ORDER_LINE = tfdtl.BILLLINE, |
| | | STATUS = BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue(), |
| | | ITEM_CODE = CurInv.ItemInfo.ITEM_CODE, |
| | | UNITCODE = "", |
| | | PRQTY = remainQty, |
| | | OUTQTY = remainQty, |
| | | INQTY = remainQty, |
| | | OUTWAREHOUSECODE = CurInv.Warehouse.WH_CODE, |
| | | INWAREHOUSECODE = CurInv.Warehouse.TRANSFER_WH, |
| | | SOURCETYPE = transferH.SOURCETYPE, |
| | | SOURCECODE = transferH.SOURCECODE, |
| | | SOURCELINE = tfdtl.BILLLINE, |
| | | UNIT = "", |
| | | QTY_REQ = remainQty, |
| | | QTY_OUT = remainQty, |
| | | QTY_IN = remainQty, |
| | | OUT_WH_CODE = CurInv.Warehouse.WH_CODE, |
| | | IN_WH_CODE = CurInv.Warehouse.TRANSFER_WH, |
| | | SOURCE_CODE = transferH.SOURCE_CODE, |
| | | SOURCE_ORDER = transferH.SOURCE_ORDER, |
| | | SOURCE_LINE = tfdtl.BILLLINE, |
| | | REMARK = "", |
| | | AUTH_ORG = OrgCode |
| | | }; |
| | | Logger.Interface.Info($"å·¥å颿 =>çæè°æ¨æç»ï¼åå·ï¼[{transferH.BILLCODE}]ï¼Qty:{remainQty}ï¼ç¶æ:{transferDtl.LINESTATUS}ï¼é¡¹æ¬¡ï¼[{transferDtl.BILLLINE}]"); |
| | | Logger.Interface.Info($"å·¥å颿 =>çæè°æ¨æç»ï¼åå·ï¼[{transferH.ORDER_NO}]ï¼Qty:{remainQty}ï¼ç¶æ:{transferDtl.STATUS}ï¼é¡¹æ¬¡ï¼[{transferDtl.ORDER_LINE}]"); |
| | | |
| | | transferSn = new() |
| | | { |
| | | BILLCODE = transferH.BILLCODE, |
| | | BILLLINE = tfdtl.BILLLINE, |
| | | ORDER_NO = transferH.ORDER_NO, |
| | | ORDER_LINE = tfdtl.BILLLINE, |
| | | ITEM_CODE = CurInv.ItemInfo.ITEM_CODE, |
| | | SN = CurInv.CurPkg.SN, |
| | | QTY = CurInv.CurPkg.QTY, |
| | |
| | | //detail å
¨é¨å®æäº |
| | | req.STATUS = BIZ_ERP_PROD_OUT.STATUSs.COMPLETE.GetValue(); |
| | | Logger.Interface.Info($"å·¥å颿 =>颿å[{req.BILLCODE}]åæå®æï¼åå¤´ç¶æ:{req.STATUS}"); |
| | | transferH = transferH != null ? transferH : Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.SOURCECODE == req.BILLCODE).First(); |
| | | transferH = transferH != null ? transferH : Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.SOURCE_ORDER == req.BILLCODE).First(); |
| | | if (transferH != null) |
| | | { |
| | | transferH.STATUS = BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue(); |
| | | Logger.Interface.Info($"å·¥å颿 =>æ´æ°è°æ¨å[{transferH.BILLCODE}]ç¶æ:{transferH.STATUS}"); |
| | | transferH.STATUS = BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue(); |
| | | Logger.Interface.Info($"å·¥å颿 =>æ´æ°è°æ¨å[{transferH.ORDER_NO}]ç¶æ:{transferH.STATUS}"); |
| | | } |
| | | } |
| | | else |
| | |
| | | var tfdtl = dtls.OrderBy(q => q.BILLLINE.ToDecimal()).Last(); |
| | | tfdtl.QTY += cutQty; |
| | | //è°æ¨ |
| | | transferH = Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.SOURCECODE == req.BILLCODE).First() ?? new() |
| | | transferH = Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.SOURCE_ORDER == req.BILLCODE).First() ?? new() |
| | | { |
| | | BILLCODE = "TF-" + req.BILLCODE, |
| | | BILLDATE = DateTime.Now, |
| | | STATUS = BIZ_WMS_TRANSFER.STATUSs.INIT.GetValue(), |
| | | BIZTYPE = null, |
| | | OUTWAREHOUSECODE = CurInv.Warehouse.WH_CODE, |
| | | INWAREHOUSECODE = CurInv.Warehouse.TRANSFER_WH, |
| | | SOURCETYPE = 0, |
| | | SOURCECODE = req.BILLCODE, |
| | | ORDER_NO = "TF-" + req.BILLCODE, |
| | | ORDER_DATE = DateTime.Now, |
| | | STATUS = BIZ_WMS_TRANSFER.STATUSs.Init.GetValue(), |
| | | OUT_WH_CODE = CurInv.Warehouse.WH_CODE, |
| | | IN_WH_CODE = CurInv.Warehouse.TRANSFER_WH, |
| | | SOURCE_CODE = nameof(req), |
| | | SOURCE_ORDER = req.BILLCODE, |
| | | AUTH_ORG = OrgCode |
| | | }; |
| | | |
| | | transferDtl = Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(x => x.BILLCODE == transferH.BILLCODE && x.BILLLINE == tfdtl.BILLLINE).First() ?? new() |
| | | transferDtl = Biz.Db.Queryable<BIZ_WMS_TRANSFER_DTL>().Where(x => x.ORDER_NO == transferH.ORDER_NO && x.ORDER_LINE == tfdtl.BILLLINE).First() ?? new() |
| | | { |
| | | BILLCODE = transferH.BILLCODE, |
| | | BILLLINE = tfdtl.BILLLINE, |
| | | LINESTATUS = BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue(), |
| | | ORDER_NO = transferH.ORDER_NO, |
| | | ORDER_LINE = tfdtl.BILLLINE, |
| | | STATUS = BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue(), |
| | | ITEM_CODE = CurInv.ItemInfo.ITEM_CODE, |
| | | UNITCODE = "", |
| | | PRQTY = remainQty, |
| | | OUTQTY = remainQty, |
| | | INQTY = remainQty, |
| | | OUTWAREHOUSECODE = CurInv.Warehouse.WH_CODE, |
| | | INWAREHOUSECODE = CurInv.Warehouse.TRANSFER_WH, |
| | | SOURCETYPE = transferH.SOURCETYPE, |
| | | SOURCECODE = transferH.SOURCECODE, |
| | | SOURCELINE = tfdtl.BILLLINE, |
| | | UNIT = "", |
| | | QTY_REQ = remainQty, |
| | | QTY_OUT = remainQty, |
| | | QTY_IN = remainQty, |
| | | OUT_WH_CODE = CurInv.Warehouse.WH_CODE, |
| | | IN_WH_CODE = CurInv.Warehouse.TRANSFER_WH, |
| | | SOURCE_CODE = transferH.SOURCE_CODE, |
| | | SOURCE_ORDER = transferH.SOURCE_ORDER, |
| | | SOURCE_LINE = tfdtl.BILLLINE, |
| | | REMARK = "", |
| | | AUTH_ORG = OrgCode |
| | | }; |
| | | Logger.Interface.Info($"çäº§é¢æ =>çæè°æ¨æç»ï¼åå·ï¼[{transferH.BILLCODE}]ï¼Qty:{remainQty}ï¼ç¶æ:{transferDtl.LINESTATUS}ï¼é¡¹æ¬¡ï¼[{transferDtl.BILLLINE}]"); |
| | | Logger.Interface.Info($"çäº§é¢æ =>çæè°æ¨æç»ï¼åå·ï¼[{transferH.ORDER_NO}]ï¼Qty:{remainQty}ï¼ç¶æ:{transferDtl.STATUS}ï¼é¡¹æ¬¡ï¼[{transferDtl.ORDER_LINE}]"); |
| | | |
| | | transferSn = new() |
| | | { |
| | | BILLCODE = transferH.BILLCODE, |
| | | BILLLINE = tfdtl.BILLLINE, |
| | | ORDER_NO = transferH.ORDER_NO, |
| | | ORDER_LINE = tfdtl.BILLLINE, |
| | | ITEM_CODE = CurInv.ItemInfo.ITEM_CODE, |
| | | SN = CurInv.CurPkg.SN, |
| | | QTY = CurInv.CurPkg.QTY, |
| | |
| | | //detailå
¨é¨å®æäº |
| | | req.STATUS = BIZ_ERP_PROD_OUT.STATUSs.COMPLETE.GetValue(); |
| | | Logger.Interface.Info($"çäº§é¢æ =>颿å[{req.BILLCODE}]åæå®æï¼åå¤´ç¶æ:{req.STATUS}"); |
| | | transferH = transferH != null ? transferH : Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.SOURCECODE == req.BILLCODE).First(); |
| | | transferH = transferH != null ? transferH : Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => x.SOURCE_ORDER == req.BILLCODE).First(); |
| | | if (transferH != null) |
| | | { |
| | | transferH.STATUS = BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue(); |
| | | Logger.Interface.Info($"çäº§é¢æ =>æ´æ°è°æ¨å[{transferH.BILLCODE}]ç¶æ:{transferH.STATUS}"); |
| | | transferH.STATUS = BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue(); |
| | | Logger.Interface.Info($"çäº§é¢æ =>æ´æ°è°æ¨å[{transferH.ORDER_NO}]ç¶æ:{transferH.STATUS}"); |
| | | } |
| | | } |
| | | else |
| | |
| | | entity_h.Add(prd_h); |
| | | list_dOld.AddRange(list_d); |
| | | //æ£æ¥ææ²¡æè°æ¨åï¼æå°±æ´æ°ç¶æä¸ºå®æ |
| | | var transferList = db.Queryable<BIZ_WMS_TRANSFER>().Where(s => s.SOURCECODE == prd_h.BILLCODE).ToList(); |
| | | var transferList = db.Queryable<BIZ_WMS_TRANSFER>().Where(s => s.SOURCE_ORDER == prd_h.BILLCODE).ToList(); |
| | | if (transferList.Any()) |
| | | { |
| | | foreach (var item in transferList) |
| | | { |
| | | item.STATUS = BIZ_WMS_TRANSFER.STATUSs.FINISHED.GetValue(); |
| | | item.SOURCECODE = prd_h.BILLCODE; |
| | | item.STATUS = BIZ_WMS_TRANSFER.STATUSs.Finished.GetValue(); |
| | | item.SOURCE_ORDER = prd_h.BILLCODE; |
| | | transferH.Add(item); |
| | | action.Message += $"ï¼é¢æå[{prd_h.BILLCODE}]对åºè°æ¨å[{item.BILLCODE}]宿"; |
| | | action.Message += $"ï¼é¢æå[{prd_h.BILLCODE}]对åºè°æ¨å[{item.ORDER_NO}]宿"; |
| | | } |
| | | } |
| | | } |
| | |
| | | { |
| | | var action = new ApiAction<PageAble<BIZ_WMS_TRANSFER>>(); |
| | | var query = Biz.Db.Queryable<BIZ_WMS_TRANSFER>().Where(x => |
| | | (x.STATUS == BIZ_WMS_TRANSFER.STATUSs.INIT.GetValue() |
| | | || x.STATUS == BIZ_WMS_TRANSFER.STATUSs.MANUAL.GetValue() |
| | | || x.STATUS == BIZ_WMS_TRANSFER.STATUSs.WORKING.GetValue()) |
| | | (x.STATUS == BIZ_WMS_TRANSFER.STATUSs.Init.GetValue() |
| | | || x.STATUS == BIZ_WMS_TRANSFER.STATUSs.Imported.GetValue() |
| | | || x.STATUS == BIZ_WMS_TRANSFER.STATUSs.Storing.GetValue()) |
| | | && x.AUTH_ORG == orgcode) |
| | | .WhereIF(!billcode.IsNullOrEmpty(), x => x.BILLCODE.Contains(billcode)) |
| | | .WhereIF(!billcode.IsNullOrEmpty(), x => x.ORDER_NO.Contains(billcode)) |
| | | .OrderByDescending(x => x.UPDATE_TIME.ToString("yyyy-MM-dd")) |
| | | //.OrderBy(x => x.REMARK == "L40774" ? 0 : 1) |
| | | //.OrderBy(x => x.SOURCECODE == null ? 1 : 0) |
| | | .OrderByDescending(x => x.BILLDATE) |
| | | .OrderBy(x => new { x.CREATE_TIME, x.BILLCODE}) |
| | | .OrderByDescending(x => x.ORDER_DATE) |
| | | .OrderBy(x => new { x.CREATE_TIME, x.ORDER_NO}) |
| | | |
| | | //.OrderBy(x => x.CREATE_TIME) |
| | | .ToPage(pageIndex, pageSize); |
| | |
| | | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// å®ä½ï¼ç©ååºç¡ä¿¡æ¯ |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("ç©ååºç¡ä¿¡æ¯")] |
| | | [Serializable] |
| | | [SugarTable("BAS_ITEM")] |
| | | public class BAS_ITEM : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼ç©ååºç¡ä¿¡æ¯ |
| | | /// </summary> |
| | | public BAS_ITEM() { } |
| | | #endregion |
| | | /// <summary> |
| | | /// å®ä½ï¼ç©ååºç¡ä¿¡æ¯ |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("ç©ååºç¡ä¿¡æ¯")] |
| | | [Serializable] |
| | | [SugarTable("BAS_ITEM")] |
| | | public class BAS_ITEM : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼ç©ååºç¡ä¿¡æ¯ |
| | | /// </summary> |
| | | public BAS_ITEM() {} |
| | | #endregion |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | | [DisplayName("ç©æç¼ç ")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// ç©æåç§° |
| | | /// </summary> |
| | | [DisplayName("ç©æåç§°")] |
| | | public string ITEM_NAME { get; set; } |
| | | /// <summary> |
| | | /// ç©ææè¿° |
| | | /// </summary> |
| | | [DisplayName("ç©ææè¿°")] |
| | | public string ITEM_DESC { get; set; } |
| | | /// <summary> |
| | | /// ç©ååç±»ç¼ç |
| | | /// </summary> |
| | | [DisplayName("ç©ååç±»ç¼ç ")] |
| | | public string ITEM_TYPE { get; set; } |
| | | /// <summary> |
| | | /// ç©æçæ¬ |
| | | /// </summary> |
| | | [DisplayName("ç©æçæ¬")] |
| | | public string ITEM_VER { get; set; } |
| | | /// <summary> |
| | | /// è§æ ¼ |
| | | /// </summary> |
| | | [DisplayName("è§æ ¼")] |
| | | public string SPEC { get; set; } |
| | | /// <summary> |
| | | /// å¨ä½è§æ ¼(SmallReelå·è£
å°ç|BigReelå·è£
大ç) |
| | | /// </summary> |
| | | [DisplayName("å¨ä½è§æ ¼(SmallReelå·è£
å°ç|BigReelå·è£
大ç)")] |
| | | public string SPEC_WH { get; set; } |
| | | /// <summary> |
| | | /// é¢è² |
| | | /// </summary> |
| | | [DisplayName("é¢è²")] |
| | | public string COLOR { get; set; } |
| | | /// <summary> |
| | | /// åä½ |
| | | /// </summary> |
| | | [DisplayName("åä½")] |
| | | public string UNIT { get; set; } |
| | | /// <summary> |
| | | /// æ¯å¦æå(Y/N) |
| | | /// </summary> |
| | | [DisplayName("æ¯å¦æå(Y/N)")] |
| | | public string IS_PROD { get; set; } |
| | | /// <summary> |
| | | /// 产åç±»å |
| | | /// </summary> |
| | | [DisplayName("产åç±»å")] |
| | | public string PROD_TYPE { get; set; } |
| | | /// <summary> |
| | | /// 客æ·äº§åç¼ç |
| | | /// </summary> |
| | | [DisplayName("客æ·äº§åç¼ç ")] |
| | | public string CUST_PROD_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¯å¦å¯ç¨(Y/N) |
| | | /// </summary> |
| | | [DisplayName("æ¯å¦å¯ç¨(Y/N)")] |
| | | public string IS_ACTIVE { get; set; } |
| | | /// <summary> |
| | | /// ç®¡æ§æ¹å¼ï¼Batchæ¹æ¬¡ç®¡æ§/Singleå件管æ§ï¼ |
| | | /// </summary> |
| | | [DisplayName("ç®¡æ§æ¹å¼ï¼Batchæ¹æ¬¡ç®¡æ§/Singleå件管æ§ï¼")] |
| | | public string CTRL_MODE { get; set; } |
| | | /// <summary> |
| | | /// å叿¶é´ |
| | | /// </summary> |
| | | [DisplayName("å叿¶é´")] |
| | | public DateTime RELEASE_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// çææ¶é´ |
| | | /// </summary> |
| | | [DisplayName("çææ¶é´")] |
| | | public DateTime EFFECTIVE_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// ææå¤©æ° |
| | | /// </summary> |
| | | [DisplayName("ææå¤©æ°")] |
| | | public double VALIDITY_DAYS { get; set; } |
| | | /// <summary> |
| | | /// åæç®¡æ§(0ByDemandæéåæ|1ByMinPackageæå°å
è£
åæ) |
| | | /// </summary> |
| | | [DisplayName("åæç®¡æ§(0ByDemandæéåæ|1ByMinPackageæå°å
è£
åæ)")] |
| | | public int DLVY_TYPE { get; set; } |
| | | /// <summary> |
| | | /// æ¯å¦å¯ç¨å
è¿å
åº(Y/N) |
| | | /// </summary> |
| | | [DisplayName("æ¯å¦å¯ç¨å
è¿å
åº(Y/N)")] |
| | | public string ENABLE_FIFO { get; set; } |
| | | /// <summary> |
| | | /// æ¡ç è§åç¼ç |
| | | /// </summary> |
| | | [DisplayName("æ¡ç è§åç¼ç ")] |
| | | public string RULE_CODE { get; set; } |
| | | /// <summary> |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | | [DisplayName("ç©æç¼ç ")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// ç©æåç§° |
| | | /// </summary> |
| | | [DisplayName("ç©æåç§°")] |
| | | public string ITEM_NAME { get; set; } |
| | | /// <summary> |
| | | /// ç©ææè¿° |
| | | /// </summary> |
| | | [DisplayName("ç©ææè¿°")] |
| | | public string ITEM_DESC { get; set; } |
| | | /// <summary> |
| | | /// ç©ååç±»ç¼ç |
| | | /// </summary> |
| | | [DisplayName("ç©ååç±»ç¼ç ")] |
| | | public string ITEM_TYPE { get; set; } |
| | | /// <summary> |
| | | /// ç©æçæ¬ |
| | | /// </summary> |
| | | [DisplayName("ç©æçæ¬")] |
| | | public string ITEM_VER { get; set; } |
| | | /// <summary> |
| | | /// è§æ ¼ |
| | | /// </summary> |
| | | [DisplayName("è§æ ¼")] |
| | | public string SPEC { get; set; } |
| | | /// <summary> |
| | | /// å¨ä½è§æ ¼(SmallReelå·è£
å°ç|BigReelå·è£
大ç) |
| | | /// </summary> |
| | | [DisplayName("å¨ä½è§æ ¼(SmallReelå·è£
å°ç|BigReelå·è£
大ç)")] |
| | | public string SPEC_WH { get; set; } |
| | | /// <summary> |
| | | /// é¢è² |
| | | /// </summary> |
| | | [DisplayName("é¢è²")] |
| | | public string COLOR { get; set; } |
| | | /// <summary> |
| | | /// åä½ |
| | | /// </summary> |
| | | [DisplayName("åä½")] |
| | | public string UNIT { get; set; } |
| | | /// <summary> |
| | | /// æ¯å¦æå(Y/N) |
| | | /// </summary> |
| | | [DisplayName("æ¯å¦æå(Y/N)")] |
| | | public string IS_PROD { get; set; } |
| | | /// <summary> |
| | | /// 产åç±»å |
| | | /// </summary> |
| | | [DisplayName("产åç±»å")] |
| | | public string PROD_TYPE { get; set; } |
| | | /// <summary> |
| | | /// 客æ·äº§åç¼ç |
| | | /// </summary> |
| | | [DisplayName("客æ·äº§åç¼ç ")] |
| | | public string CUST_PROD_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¯å¦å¯ç¨(Y/N) |
| | | /// </summary> |
| | | [DisplayName("æ¯å¦å¯ç¨(Y/N)")] |
| | | public string IS_ACTIVE { get; set; } |
| | | /// <summary> |
| | | /// ç®¡æ§æ¹å¼ï¼Batchæ¹æ¬¡ç®¡æ§/Singleå件管æ§ï¼ |
| | | /// </summary> |
| | | [DisplayName("ç®¡æ§æ¹å¼ï¼Batchæ¹æ¬¡ç®¡æ§/Singleå件管æ§ï¼")] |
| | | public string CTRL_MODE { get; set; } |
| | | /// <summary> |
| | | /// å叿¶é´ |
| | | /// </summary> |
| | | [DisplayName("å叿¶é´")] |
| | | public DateTime RELEASE_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// çææ¶é´ |
| | | /// </summary> |
| | | [DisplayName("çææ¶é´")] |
| | | public DateTime EFFECTIVE_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// ææå¤©æ° |
| | | /// </summary> |
| | | [DisplayName("ææå¤©æ°")] |
| | | public double VALIDITY_DAYS { get; set; } |
| | | /// <summary> |
| | | /// åæç®¡æ§(0ByDemandæéåæ|1ByMinPackageæå°å
è£
åæ) |
| | | /// </summary> |
| | | [DisplayName("åæç®¡æ§(0ByDemandæéåæ|1ByMinPackageæå°å
è£
åæ)")] |
| | | public int DLVY_TYPE { get; set; } |
| | | /// <summary> |
| | | /// æ¯å¦å¯ç¨å
è¿å
åº(Y/N) |
| | | /// </summary> |
| | | [DisplayName("æ¯å¦å¯ç¨å
è¿å
åº(Y/N)")] |
| | | public string ENABLE_FIFO { get; set; } |
| | | /// <summary> |
| | | /// æ¡ç è§åç¼ç |
| | | /// </summary> |
| | | [DisplayName("æ¡ç è§åç¼ç ")] |
| | | public string RULE_CODE { get; set; } |
| | | /// <summary> |
| | | /// é»è®¤å·¥èºè·¯çº¿ç¼ç |
| | | /// </summary> |
| | | [DisplayName("é»è®¤å·¥èºè·¯çº¿ç¼ç ")] |
| | | public string DEFAULT_ROUTE { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [DisplayName("夿³¨")] |
| | | public string REMARK { get; set; } |
| | | #endregion |
| | | public string DEFAULT_ROUTE { get; set; } |
| | | /// <summary> |
| | | /// é»è®¤ä»åº |
| | | /// </summary> |
| | | [DisplayName("é»è®¤ä»åº")] |
| | | public string DEFAULT_WH { get; set; } |
| | | /// <summary> |
| | | /// é»è®¤å¨åº |
| | | /// </summary> |
| | | [DisplayName("é»è®¤å¨åº")] |
| | | public string DEFAULT_REGION { get; set; } |
| | | /// <summary> |
| | | /// é»è®¤è´§æ¶/æè½¦ |
| | | /// </summary> |
| | | [DisplayName("é»è®¤è´§æ¶/æè½¦")] |
| | | public string DEFAULT_SHELF { get; set; } |
| | | /// <summary> |
| | | /// é»è®¤å¨ä½ |
| | | /// </summary> |
| | | [DisplayName("é»è®¤å¨ä½")] |
| | | public string DEFAULT_LOCATION { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [DisplayName("夿³¨")] |
| | | public string REMARK { get; set; } |
| | | #endregion |
| | | |
| | | #region èæå±æ§ |
| | | /*ä¾å |
| | | #region èæå±æ§ |
| | | /*ä¾å |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | |
| | | public double DepositDays { get; set; } |
| | | #endregion èæå±æ§ |
| | | |
| | | #region å¤é®å±æ§ |
| | | /*ä¾å |
| | | #region å¤é®å±æ§ |
| | | /*ä¾å |
| | | //ä¸å¯¹ä¸å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//ä¸å¯¹ä¸ ClassAIdæ¯BAS_ITEMç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | |
| | | public BAS_ITEM_EXT ExtInfo { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | #endregion |
| | | |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | public enum FieldNames |
| | | { |
| | | [Description("æä¸¾æè¿°0")] |
| | |
| | | } |
| | | */ |
| | | |
| | | /// <summary> |
| | | /// æä¸¾ï¼åæç®¡æ§(0ByDemandæéåæ|1ByMinPackageæå°å
è£
åæ) |
| | | /// </summary> |
| | | public enum DLVY_TYPEs |
| | | { |
| | | [Description("æéåæ")] |
| | | ByDemand = 0, |
| | | [Description("æå°å
è£
åæ")] |
| | | ByMinPackage = 1, |
| | | } |
| | | #endregion |
| | | /// <summary> |
| | | /// æä¸¾ï¼åæç®¡æ§(0ByDemandæéåæ|1ByMinPackageæå°å
è£
åæ) |
| | | /// </summary> |
| | | public enum DLVY_TYPEs |
| | | { |
| | | [Description("æéåæ")] |
| | | ByDemand = 0, |
| | | [Description("æå°å
è£
åæ")] |
| | | ByMinPackage = 1, |
| | | } |
| | | #endregion |
| | | |
| | | #region å
Œ
±æ¹æ³ |
| | | #region å
Œ
±æ¹æ³ |
| | | |
| | | #endregion |
| | | #endregion |
| | | |
| | | }//endClass |
| | | }//endClass |
| | | } |
| | |
| | | /// æå°æ¨¡å¼ |
| | | /// </summary> |
| | | public int ReceiptMode { get; set; } |
| | | /// <summary> |
| | | /// é»è®¤å¨ä½ |
| | | /// </summary> |
| | | public string BinCode { get; set; } |
| | | #endregion |
| | | |
| | | #region èæå±æ§ |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using SqlSugar; |
| | | using System.Linq; |
| | | using System.ComponentModel; |
| | | using System.Collections.Generic; |
| | | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// å®ä½ï¼ç©å转åå(WMS) |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("ç©å转åå(WMS)")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_ITEM_CVT")] |
| | | public class BIZ_ITEM_CVT : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼ç©å转åå(WMS) |
| | | /// </summary> |
| | | public BIZ_ITEM_CVT() {} |
| | | #endregion |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// 转ååå· |
| | | /// </summary> |
| | | [DisplayName("转ååå·")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// åæ®æ¥æ |
| | | /// </summary> |
| | | [DisplayName("åæ®æ¥æ")] |
| | | public DateTime ORDER_DATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// ç¶æ(0Initæ°å建|1Workingä½ä¸ä¸|2Pendingå¾
å®¡æ ¸|3Finished已宿|4Failedå®¡æ ¸å¤±è´¥|7Cancelå·²ä½åº) |
| | | /// </summary> |
| | | [DisplayName("ç¶æ(0Initæ°å建|1Workingä½ä¸ä¸|2Pendingå¾
å®¡æ ¸|3Finished已宿|4Failedå®¡æ ¸å¤±è´¥|7Cancelå·²ä½åº)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// ERPç±»å |
| | | /// </summary> |
| | | [DisplayName("ERPç±»å")] |
| | | public string ERP_TYPE_CODE { get; set; } |
| | | /// <summary> |
| | | /// ERPç±»ååç§° |
| | | /// </summary> |
| | | [DisplayName("ERPç±»ååç§°")] |
| | | public string ERP_TYPE_NAME { get; set; } |
| | | /// <summary> |
| | | /// ERPåæ®ç¶æ |
| | | /// </summary> |
| | | [DisplayName("ERPåæ®ç¶æ")] |
| | | public string ERP_STATUS_CODE { get; set; } |
| | | /// <summary> |
| | | /// ERPåæ®ç¶æåç§° |
| | | /// </summary> |
| | | [DisplayName("ERPåæ®ç¶æåç§°")] |
| | | public string ERP_STATUS_NAME { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [DisplayName("夿³¨")] |
| | | public string REMARK { get; set; } |
| | | /// <summary> |
| | | /// -1:æªå¤çï¼0:忥å¤çå®ï¼>0:忥å¤çå¤±è´¥æ¬¡æ° |
| | | /// </summary> |
| | | [DisplayName("-1:æªå¤çï¼0:忥å¤çå®ï¼>0:忥å¤ç失败次æ°")] |
| | | public int HANDLED { get; set; } = -1; |
| | | /// <summary> |
| | | /// æå䏿¬¡åæ¥å¤çæ¥æ |
| | | /// </summary> |
| | | [DisplayName("æå䏿¬¡åæ¥å¤çæ¥æ")] |
| | | public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// è¿è´¦æäº¤çJSON |
| | | /// </summary> |
| | | [DisplayName("è¿è´¦æäº¤çJSON")] |
| | | public string COMMIT_JSON { get; set; } |
| | | /// <summary> |
| | | /// è¿è´¦æäº¤çè¿åä¿¡æ¯ |
| | | /// </summary> |
| | | [DisplayName("è¿è´¦æäº¤çè¿åä¿¡æ¯")] |
| | | public string COMMIT_MSG { get; set; } |
| | | #endregion |
| | | |
| | | #region èæå±æ§ |
| | | /*ä¾å |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | |
| | | #region å¤é®å±æ§ |
| | | /*ä¾å |
| | | //ä¸å¯¹ä¸å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//ä¸å¯¹ä¸ ClassAIdæ¯BIZ_ITEM_CVTç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ITEM_CVTId))]//ClassA表ä¸çBIZ_ITEM_CVTId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ITEM_CVTId), nameof(MappingClass.ClassAId))]//注æé¡ºåº |
| | | public List<ClassA> ClassAList { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | */ |
| | | #endregion |
| | | |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | public enum FieldNames |
| | | { |
| | | [Description("æä¸¾æè¿°0")] |
| | | Enum0, |
| | | [Description("æä¸¾æè¿°1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | |
| | | /// <summary> |
| | | /// æä¸¾ï¼ç¶æ(0Initæ°å建|1Workingä½ä¸ä¸|2Pendingå¾
å®¡æ ¸|3Finished已宿|4Failedå®¡æ ¸å¤±è´¥|7Cancelå·²ä½åº) |
| | | /// </summary> |
| | | public enum STATUSs |
| | | { |
| | | [Description("æ°å建")] |
| | | Init = 0, |
| | | [Description("ä½ä¸ä¸")] |
| | | Working = 1, |
| | | [Description("å¾
å®¡æ ¸")] |
| | | Pending = 2, |
| | | [Description("已宿")] |
| | | Finished = 3, |
| | | [Description("å®¡æ ¸å¤±è´¥")] |
| | | Failed = 4, |
| | | [Description("å·²ä½åº")] |
| | | Cancel = 7, |
| | | } |
| | | #endregion |
| | | |
| | | #region å
Œ
±æ¹æ³ |
| | | |
| | | #endregion |
| | | |
| | | }//endClass |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using SqlSugar; |
| | | using System.Linq; |
| | | using System.ComponentModel; |
| | | using System.Collections.Generic; |
| | | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// å®ä½ï¼ç©å转åå(WMS)æç» |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("ç©å转åå(WMS)æç»")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_ITEM_CVT_DTL")] |
| | | public class BIZ_ITEM_CVT_DTL : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼ç©å转åå(WMS)æç» |
| | | /// </summary> |
| | | public BIZ_ITEM_CVT_DTL() {} |
| | | #endregion |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// 转ååå· |
| | | /// </summary> |
| | | [DisplayName("转ååå·")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// 转ååè¡å· |
| | | /// </summary> |
| | | [DisplayName("转ååè¡å·")] |
| | | public string ORDER_LINE { get; set; } |
| | | /// <summary> |
| | | /// ç¶æ(ååæ®ç¶æ) |
| | | /// </summary> |
| | | [DisplayName("ç¶æ(ååæ®ç¶æ)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// åç©æç¼ç |
| | | /// </summary> |
| | | [DisplayName("åç©æç¼ç ")] |
| | | public string ITEM_CODE_BF { get; set; } |
| | | /// <summary> |
| | | /// åç©æåç§° |
| | | /// </summary> |
| | | [DisplayName("åç©æåç§°")] |
| | | public string ITEM_NAME_BF { get; set; } |
| | | /// <summary> |
| | | /// 转ååç©æç¼ç |
| | | /// </summary> |
| | | [DisplayName("转ååç©æç¼ç ")] |
| | | public string ITEM_CODE_AF { get; set; } |
| | | /// <summary> |
| | | /// 转ååç©æåç§° |
| | | /// </summary> |
| | | [DisplayName("转ååç©æåç§°")] |
| | | public string ITEM_NAME_AF { get; set; } |
| | | /// <summary> |
| | | /// è½¬åæ°é |
| | | /// </summary> |
| | | [DisplayName("è½¬åæ°é")] |
| | | public double QTY { get; set; } |
| | | /// <summary> |
| | | /// ERP转åç±»å |
| | | /// </summary> |
| | | [DisplayName("ERP转åç±»å")] |
| | | public string ERP_TYPE_CODE { get; set; } |
| | | /// <summary> |
| | | /// ERP转ååç§° |
| | | /// </summary> |
| | | [DisplayName("ERP转ååç§°")] |
| | | public string ERP_TYPE_NAME { get; set; } |
| | | /// <summary> |
| | | /// åºååä½ |
| | | /// </summary> |
| | | [DisplayName("åºååä½")] |
| | | public string STORE_UNIT { get; set; } |
| | | /// <summary> |
| | | /// åºåå使°é |
| | | /// </summary> |
| | | [DisplayName("åºåå使°é")] |
| | | public double STORE_UNIT_QTY { get; set; } |
| | | /// <summary> |
| | | /// ææ¬åä½ |
| | | /// </summary> |
| | | [DisplayName("ææ¬åä½")] |
| | | public string COST_UNIT { get; set; } |
| | | /// <summary> |
| | | /// ææ¬å使°é |
| | | /// </summary> |
| | | [DisplayName("ææ¬å使°é")] |
| | | public double COST_UNIT_QTY { get; set; } |
| | | /// <summary> |
| | | /// ä»åºç¼ç (ERP) |
| | | /// </summary> |
| | | [DisplayName("ä»åºç¼ç (ERP)")] |
| | | public string WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// ä»åºåç§°(ERP) |
| | | /// </summary> |
| | | [DisplayName("ä»åºåç§°(ERP)")] |
| | | public string WH_NAME { get; set; } |
| | | /// <summary> |
| | | /// å¨ä½ç¼ç (ERP) |
| | | /// </summary> |
| | | [DisplayName("å¨ä½ç¼ç (ERP)")] |
| | | public string LOCATION_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¹æ¬¡å·(ERP) |
| | | /// </summary> |
| | | [DisplayName("æ¹æ¬¡å·(ERP)")] |
| | | public string LOTNO { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [DisplayName("夿³¨")] |
| | | public string REMARK { get; set; } |
| | | #endregion |
| | | |
| | | #region èæå±æ§ |
| | | /*ä¾å |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | |
| | | #region å¤é®å±æ§ |
| | | /*ä¾å |
| | | //ä¸å¯¹ä¸å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//ä¸å¯¹ä¸ ClassAIdæ¯BIZ_ITEM_CVT_DTLç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ITEM_CVT_DTLId))]//ClassA表ä¸çBIZ_ITEM_CVT_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ITEM_CVT_DTLId), nameof(MappingClass.ClassAId))]//注æé¡ºåº |
| | | public List<ClassA> ClassAList { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | */ |
| | | #endregion |
| | | |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | public enum FieldNames |
| | | { |
| | | [Description("æä¸¾æè¿°0")] |
| | | Enum0, |
| | | [Description("æä¸¾æè¿°1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | #endregion |
| | | |
| | | #region å
Œ
±æ¹æ³ |
| | | |
| | | #endregion |
| | | |
| | | }//endClass |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using SqlSugar; |
| | | using System.Linq; |
| | | using System.ComponentModel; |
| | | using System.Collections.Generic; |
| | | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// å®ä½ï¼ç©å转åå(WMS)æ¡ç æç» |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("ç©å转åå(WMS)æ¡ç æç»")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_ITEM_CVT_SN")] |
| | | public class BIZ_ITEM_CVT_SN : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼ç©å转åå(WMS)æ¡ç æç» |
| | | /// </summary> |
| | | public BIZ_ITEM_CVT_SN() {} |
| | | #endregion |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// 转ååå· |
| | | /// </summary> |
| | | [DisplayName("转ååå·")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// 转ååè¡å· |
| | | /// </summary> |
| | | [DisplayName("转ååè¡å·")] |
| | | public string ORDER_LINE { get; set; } |
| | | /// <summary> |
| | | /// ç©åæ ç¾ |
| | | /// </summary> |
| | | [DisplayName("ç©åæ ç¾")] |
| | | public string SN { get; set; } |
| | | /// <summary> |
| | | /// åç©æç¼ç |
| | | /// </summary> |
| | | [DisplayName("åç©æç¼ç ")] |
| | | public string ITEM_CODE_BF { get; set; } |
| | | /// <summary> |
| | | /// åç©æåç§° |
| | | /// </summary> |
| | | [DisplayName("åç©æåç§°")] |
| | | public string ITEM_NAME_BF { get; set; } |
| | | /// <summary> |
| | | /// 转ååç©æç¼ç |
| | | /// </summary> |
| | | [DisplayName("转ååç©æç¼ç ")] |
| | | public string ITEM_CODE_AF { get; set; } |
| | | /// <summary> |
| | | /// 转ååç©æåç§° |
| | | /// </summary> |
| | | [DisplayName("转ååç©æåç§°")] |
| | | public string ITEM_NAME_AF { get; set; } |
| | | /// <summary> |
| | | /// ç©åæ°é |
| | | /// </summary> |
| | | [DisplayName("ç©åæ°é")] |
| | | public double QTY { get; set; } |
| | | /// <summary> |
| | | /// æå¨ä»åº |
| | | /// </summary> |
| | | [DisplayName("æå¨ä»åº")] |
| | | public string WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// æå¨å¨åº |
| | | /// </summary> |
| | | [DisplayName("æå¨å¨åº")] |
| | | public string REGION_CODE { get; set; } |
| | | /// <summary> |
| | | /// æå¨è´§æ¶ |
| | | /// </summary> |
| | | [DisplayName("æå¨è´§æ¶")] |
| | | public string SHELF_CODE { get; set; } |
| | | /// <summary> |
| | | /// æå¨å¨ä½ |
| | | /// </summary> |
| | | [DisplayName("æå¨å¨ä½")] |
| | | public string LOCATION_CODE { get; set; } |
| | | /// <summary> |
| | | /// å½åæä½æ¶é´ |
| | | /// </summary> |
| | | [DisplayName("å½åæä½æ¶é´")] |
| | | public DateTime OPERATION_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [DisplayName("夿³¨")] |
| | | public string REMARK { get; set; } |
| | | #endregion |
| | | |
| | | #region èæå±æ§ |
| | | /*ä¾å |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | |
| | | #region å¤é®å±æ§ |
| | | /*ä¾å |
| | | //ä¸å¯¹ä¸å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//ä¸å¯¹ä¸ ClassAIdæ¯BIZ_ITEM_CVT_SNç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_ITEM_CVT_SNId))]//ClassA表ä¸çBIZ_ITEM_CVT_SNId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_ITEM_CVT_SNId), nameof(MappingClass.ClassAId))]//注æé¡ºåº |
| | | public List<ClassA> ClassAList { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | */ |
| | | #endregion |
| | | |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | public enum FieldNames |
| | | { |
| | | [Description("æä¸¾æè¿°0")] |
| | | Enum0, |
| | | [Description("æä¸¾æè¿°1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | #endregion |
| | | |
| | | #region å
Œ
±æ¹æ³ |
| | | |
| | | #endregion |
| | | |
| | | }//endClass |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using SqlSugar; |
| | | using System.Linq; |
| | | using System.ComponentModel; |
| | | using System.Collections.Generic; |
| | | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// å®ä½ï¼å§å¤åæå(U9) |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("å§å¤åæå(U9)")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_U9_SCM_OUT")] |
| | | public class BIZ_U9_SCM_OUT : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼å§å¤åæå(U9) |
| | | /// </summary> |
| | | public BIZ_U9_SCM_OUT() {} |
| | | #endregion |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// åæ®å· |
| | | /// </summary> |
| | | [DisplayName("åæ®å·")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// ç¶æ(0Initåå§å|1WaitPickå¾
æ¡æ|2Pickingæ¡æä¸|3Pickedå·²æ¡å®|4Sendedå·²åæ|5Closeå·²å
³é|6Cancelä½åº) |
| | | /// </summary> |
| | | [DisplayName("ç¶æ(0Initåå§å|1WaitPickå¾
æ¡æ|2Pickingæ¡æä¸|3Pickedå·²æ¡å®|4Sendedå·²åæ|5Closeå·²å
³é|6Cancelä½åº)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// åæ®æ¥æ |
| | | /// </summary> |
| | | [DisplayName("åæ®æ¥æ")] |
| | | public DateTime ORDER_DATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// ä¾åºåç»ç» |
| | | /// </summary> |
| | | [DisplayName("ä¾åºåç»ç»")] |
| | | public string SUPP_ORG { get; set; } |
| | | /// <summary> |
| | | /// éè´åID |
| | | /// </summary> |
| | | [DisplayName("éè´åID")] |
| | | public string PO_ID { get; set; } |
| | | /// <summary> |
| | | /// éè´åå· |
| | | /// </summary> |
| | | [DisplayName("éè´åå·")] |
| | | public string PO_NO { get; set; } |
| | | /// <summary> |
| | | /// å¤æäºº |
| | | /// </summary> |
| | | [DisplayName("å¤æäºº")] |
| | | public string PREP_PERSON { get; set; } |
| | | /// <summary> |
| | | /// 夿宿æ¶é´ |
| | | /// </summary> |
| | | [DisplayName("夿宿æ¶é´")] |
| | | public DateTime FINISH_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// é¢æäºº |
| | | /// </summary> |
| | | [DisplayName("é¢æäºº")] |
| | | public string REQ_PERSON { get; set; } |
| | | /// <summary> |
| | | /// 颿é¨é¨ |
| | | /// </summary> |
| | | [DisplayName("颿é¨é¨")] |
| | | public string REQ_DEPT { get; set; } |
| | | /// <summary> |
| | | /// åºåºæ¶é´ |
| | | /// </summary> |
| | | [DisplayName("åºåºæ¶é´")] |
| | | public DateTime DLVY_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [DisplayName("夿³¨")] |
| | | public string REMARK { get; set; } |
| | | /// <summary> |
| | | /// -1:æªå¤çï¼0:忥å¤çå®ï¼>0:忥å¤çå¤±è´¥æ¬¡æ° |
| | | /// </summary> |
| | | [DisplayName("-1:æªå¤çï¼0:忥å¤çå®ï¼>0:忥å¤ç失败次æ°")] |
| | | public int HANDLED { get; set; } |
| | | /// <summary> |
| | | /// æå䏿¬¡åæ¥å¤çæ¥æ |
| | | /// </summary> |
| | | [DisplayName("æå䏿¬¡åæ¥å¤çæ¥æ")] |
| | | public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// è¿è´¦æäº¤çJSON |
| | | /// </summary> |
| | | [DisplayName("è¿è´¦æäº¤çJSON")] |
| | | public string COMMIT_JSON { get; set; } |
| | | /// <summary> |
| | | /// è¿è´¦æäº¤çè¿åä¿¡æ¯ |
| | | /// </summary> |
| | | [DisplayName("è¿è´¦æäº¤çè¿åä¿¡æ¯")] |
| | | public string COMMIT_MSG { get; set; } |
| | | #endregion |
| | | |
| | | #region èæå±æ§ |
| | | /*ä¾å |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | |
| | | #region å¤é®å±æ§ |
| | | /*ä¾å |
| | | //ä¸å¯¹ä¸å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//ä¸å¯¹ä¸ ClassAIdæ¯BIZ_U9_SCM_OUTç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_SCM_OUTId))]//ClassA表ä¸çBIZ_U9_SCM_OUTId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_SCM_OUTId), nameof(MappingClass.ClassAId))]//注æé¡ºåº |
| | | public List<ClassA> ClassAList { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | */ |
| | | #endregion |
| | | |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | public enum FieldNames |
| | | { |
| | | [Description("æä¸¾æè¿°0")] |
| | | Enum0, |
| | | [Description("æä¸¾æè¿°1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | |
| | | /// <summary> |
| | | /// æä¸¾ï¼ç¶æ(0Initåå§å|1WaitPickå¾
æ¡æ|2Pickingæ¡æä¸|3Pickedå·²æ¡å®|4Sendedå·²åæ|5Closeå·²å
³é|6Cancelä½åº) |
| | | /// </summary> |
| | | public enum STATUSs |
| | | { |
| | | [Description("åå§å")] |
| | | Init = 0, |
| | | [Description("å¾
æ¡æ")] |
| | | WaitPick = 1, |
| | | [Description("æ¡æä¸")] |
| | | Picking = 2, |
| | | [Description("å·²æ¡å®")] |
| | | Picked = 3, |
| | | [Description("å·²åæ")] |
| | | Sended = 4, |
| | | [Description("å·²å
³é")] |
| | | Close = 5, |
| | | [Description("ä½åº")] |
| | | Cancel = 6, |
| | | } |
| | | #endregion |
| | | |
| | | #region å
Œ
±æ¹æ³ |
| | | |
| | | #endregion |
| | | |
| | | }//endClass |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | using System; |
| | | using SqlSugar; |
| | | using System.Linq; |
| | | using System.ComponentModel; |
| | | using System.Collections.Generic; |
| | | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// å®ä½ï¼å§å¤åæå(U9)æç» |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("å§å¤åæå(U9)æç»")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_U9_SCM_OUT_DTL")] |
| | | public class BIZ_U9_SCM_OUT_DTL : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼å§å¤åæå(U9)æç» |
| | | /// </summary> |
| | | public BIZ_U9_SCM_OUT_DTL() {} |
| | | #endregion |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// åæ®å· |
| | | /// </summary> |
| | | [DisplayName("åæ®å·")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// åæ®è¡å· |
| | | /// </summary> |
| | | [DisplayName("åæ®è¡å·")] |
| | | public string LINE_NO { get; set; } |
| | | /// <summary> |
| | | /// ç¶æ(ååæ®ç¶æ) |
| | | /// </summary> |
| | | [DisplayName("ç¶æ(ååæ®ç¶æ)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// ç©æID |
| | | /// </summary> |
| | | [DisplayName("ç©æID")] |
| | | public string ITEM_ID { get; set; } |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | | [DisplayName("ç©æç¼ç ")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// åä½ |
| | | /// </summary> |
| | | [DisplayName("åä½")] |
| | | public string UNIT { get; set; } |
| | | /// <summary> |
| | | /// åæ®æ°é |
| | | /// </summary> |
| | | [DisplayName("åæ®æ°é")] |
| | | public double QTY { get; set; } |
| | | /// <summary> |
| | | /// 已夿æ°é |
| | | /// </summary> |
| | | [DisplayName("已夿æ°é")] |
| | | public double QTY_PREP { get; set; } |
| | | /// <summary> |
| | | /// 已忿°é |
| | | /// </summary> |
| | | [DisplayName("已忿°é")] |
| | | public double QTY_DLVY { get; set; } |
| | | /// <summary> |
| | | /// 颿æªåæ°é |
| | | /// </summary> |
| | | [DisplayName("颿æªåæ°é")] |
| | | public double QTY_NOTDLVY { get; set; } |
| | | /// <summary> |
| | | /// åææ¹å¼(ERP) |
| | | /// </summary> |
| | | [DisplayName("åææ¹å¼(ERP)")] |
| | | public string DLVY_TYPE { get; set; } |
| | | /// <summary> |
| | | /// åææ¹å¼åç§°(ERP) |
| | | /// </summary> |
| | | [DisplayName("åææ¹å¼åç§°(ERP)")] |
| | | public string DLVY_NAME { get; set; } |
| | | /// <summary> |
| | | /// ä»åºç¼ç (ERP) |
| | | /// </summary> |
| | | [DisplayName("ä»åºç¼ç (ERP)")] |
| | | public string WH_ID { get; set; } |
| | | /// <summary> |
| | | /// ä»åºç¼ç (ERP) |
| | | /// </summary> |
| | | [DisplayName("ä»åºç¼ç (ERP)")] |
| | | public string WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// ä»åºåç§°(ERP) |
| | | /// </summary> |
| | | [DisplayName("ä»åºåç§°(ERP)")] |
| | | public string WH_NAME { get; set; } |
| | | /// <summary> |
| | | /// å¨ä½ç¼ç (ERP) |
| | | /// </summary> |
| | | [DisplayName("å¨ä½ç¼ç (ERP)")] |
| | | public string LOCATION_ID { get; set; } |
| | | /// <summary> |
| | | /// å¨ä½ç¼ç (ERP) |
| | | /// </summary> |
| | | [DisplayName("å¨ä½ç¼ç (ERP)")] |
| | | public string LOCATION_CODE { get; set; } |
| | | /// <summary> |
| | | /// å¨ä½åç§°(ERP) |
| | | /// </summary> |
| | | [DisplayName("å¨ä½åç§°(ERP)")] |
| | | public string LOCATION_NAME { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [DisplayName("夿³¨")] |
| | | public string REMARK { get; set; } |
| | | #endregion |
| | | |
| | | #region èæå±æ§ |
| | | /*ä¾å |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | |
| | | #region å¤é®å±æ§ |
| | | /*ä¾å |
| | | //ä¸å¯¹ä¸å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//ä¸å¯¹ä¸ ClassAIdæ¯BIZ_U9_SCM_OUT_DTLç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_SCM_OUT_DTLId))]//ClassA表ä¸çBIZ_U9_SCM_OUT_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_SCM_OUT_DTLId), nameof(MappingClass.ClassAId))]//注æé¡ºåº |
| | | public List<ClassA> ClassAList { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | */ |
| | | #endregion |
| | | |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | public enum FieldNames |
| | | { |
| | | [Description("æä¸¾æè¿°0")] |
| | | Enum0, |
| | | [Description("æä¸¾æè¿°1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | #endregion |
| | | |
| | | #region å
Œ
±æ¹æ³ |
| | | |
| | | #endregion |
| | | |
| | | }//endClass |
| | | } |
| | |
| | | /// 夿åå· |
| | | /// </summary> |
| | | [DisplayName("夿åå·")] |
| | | public string PREP_NO { get; set; } |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// ç±»å(0Supplyæ£å¸¸å¤æ|1Firsté¦å¥å¤æ) |
| | | /// </summary> |
| | |
| | | /// 夿åå· |
| | | /// </summary> |
| | | [DisplayName("夿åå·")] |
| | | public string PREP_NO { get; set; } |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// 夿åè¡å· |
| | | /// </summary> |
| | | [DisplayName("夿åè¡å·")] |
| | | public string PREP_LINE { get; set; } |
| | | public string ORDER_LINE { get; set; } |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | |
| | | [DisplayName("æ¿ä»£æï¼å¤ä¸ªç¨â'âåé")] |
| | | public string SUBITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// åä½ç¨é |
| | | /// åä½ |
| | | /// </summary> |
| | | [DisplayName("åä½ç¨é")] |
| | | public double UNIT_QTY { get; set; } |
| | | [DisplayName("åä½")] |
| | | public double UNIT { get; set; } |
| | | /// <summary> |
| | | /// ç产计åæèæ¯ä¾(%) |
| | | /// </summary> |
| | |
| | | [DisplayName("ç¶æ(0UnCalcæªè®¡ç®|1FistrLacké¦å¥ç¼ºæ|2SupplyLackè¡¥æç¼ºæ|3Enoughæ»¡è¶³éæ±|4NoCalcä¸åä¸å¤æè®¡ç®|5Cancelå·²ä½åº|6Finish夿宿)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// åä½ç¨é |
| | | /// </summary> |
| | | [DisplayName("åä½ç¨é")] |
| | | public double QTY_UNIT { get; set; } |
| | | /// <summary> |
| | | /// éæ±æ°é |
| | | /// </summary> |
| | | [DisplayName("éæ±æ°é")] |
| | | public double REQ_QTY { get; set; } |
| | | public double QTY_REQ { get; set; } |
| | | /// <summary> |
| | | /// 已夿æ°é |
| | | /// </summary> |
| | | [DisplayName("已夿æ°é")] |
| | | public double PREP_QTY { get; set; } |
| | | public double QTY_PREP { get; set; } |
| | | /// <summary> |
| | | /// ååºæ°é |
| | | /// </summary> |
| | | [DisplayName("ååºæ°é")] |
| | | public double DLVY_QTY { get; set; } |
| | | public double QTY_DLVY { get; set; } |
| | | /// <summary> |
| | | /// å·¥åç¼ç |
| | | /// </summary> |
| | |
| | | /// 夿åå· |
| | | /// </summary> |
| | | [DisplayName("夿åå·")] |
| | | public string PREP_NO { get; set; } |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// 夿åè¡å· |
| | | /// </summary> |
| | | [DisplayName("夿åè¡å·")] |
| | | public string PREP_LINE { get; set; } |
| | | public string ORDER_LINE { get; set; } |
| | | /// <summary> |
| | | /// è´§ç©æ ç¾ |
| | | /// ç©åæ ç¾ |
| | | /// </summary> |
| | | [DisplayName("è´§ç©æ ç¾")] |
| | | [DisplayName("ç©åæ ç¾")] |
| | | public string SN { get; set; } |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// ç©åç¼ç |
| | | /// </summary> |
| | | [DisplayName("ç©æç¼ç ")] |
| | | [DisplayName("ç©åç¼ç ")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// ç©ææ°é |
| | | /// </summary> |
| | | [DisplayName("ç©ææ°é")] |
| | | public double QTY { get; set; } |
| | | /// <summary> |
| | | /// åä½ |
| | | /// </summary> |
| | | [DisplayName("åä½")] |
| | | public string UNIT { get; set; } |
| | | public double UNIT { get; set; } |
| | | /// <summary> |
| | | /// ç©åæ°é |
| | | /// </summary> |
| | | [DisplayName("ç©åæ°é")] |
| | | public string QTY { get; set; } |
| | | /// <summary> |
| | | /// åä½ç¨é |
| | | /// </summary> |
| | | [DisplayName("åä½ç¨é")] |
| | | public double UNIT_QTY { get; set; } |
| | | public double QTY_UNIT { get; set; } |
| | | /// <summary> |
| | | /// ååºæ°é |
| | | /// </summary> |
| | | [DisplayName("ååºæ°é")] |
| | | public double DLVY_QTY { get; set; } |
| | | public double QTY_DLVY { get; set; } |
| | | /// <summary> |
| | | /// ç¶æ(0Initåå§å|1WaitPickå¾
æ£æ|2OffShelf已䏿¶|3Pickedå·²æ¡æ|4Sendedå·²åæ|5Cancelä½åº) |
| | | /// ״̬(ͬWMS_ITEM״̬) |
| | | /// </summary> |
| | | [DisplayName("ç¶æ(0Initåå§å|1WaitPickå¾
æ£æ|2OffShelf已䏿¶|3Pickedå·²æ¡æ|4Sendedå·²åæ|5Cancelä½åº)")] |
| | | [DisplayName("״̬(ͬWMS_ITEM״̬)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// åæä»åº |
| | |
| | | Enum1, |
| | | } |
| | | */ |
| | | |
| | | /// <summary> |
| | | /// æä¸¾ï¼ç¶æ(0Initåå§å|1WaitPickå¾
æ£æ|2OffShelf已䏿¶|3Pickedå·²æ¡æ|4Sendedå·²åæ|5Cancelä½åº) |
| | | /// </summary> |
| | | public enum STATUSs |
| | | { |
| | | [Description("åå§å")] |
| | | Init = 0, |
| | | [Description("å¾
æ£æ")] |
| | | WaitPick = 1, |
| | | [Description("已䏿¶")] |
| | | OffShelf = 2, |
| | | [Description("å·²æ¡æ")] |
| | | Picked = 3, |
| | | [Description("å·²åæ")] |
| | | Sended = 4, |
| | | [Description("ä½åº")] |
| | | Cancel = 5, |
| | | } |
| | | #endregion |
| | | |
| | | #region å
Œ
±æ¹æ³ |
| | |
| | | /// å®ä½ï¼è°æ¨å(WMS) |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("è°æ¨å(WMS)")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_WMS_TRANSFER")] |
| | | public class BIZ_WMS_TRANSFER : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | |
| | | /// <summary> |
| | | /// å®ä½ï¼è°æ¨å(WMS) |
| | | /// </summary> |
| | | public BIZ_WMS_TRANSFER() |
| | | { } |
| | | |
| | | #endregion æé 彿° |
| | | public BIZ_WMS_TRANSFER() { } |
| | | #endregion |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | |
| | | /// <summary> |
| | | /// 忮代ç |
| | | /// è°æ¨åå· |
| | | /// </summary> |
| | | public string BILLCODE { get; set; } |
| | | |
| | | [DisplayName("è°æ¨åå·")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// åæ®æ¥æ |
| | | /// </summary> |
| | | public DateTime BILLDATE { get; set; } = DateTime.MinValue; |
| | | |
| | | [DisplayName("åæ®æ¥æ")] |
| | | public DateTime ORDER_DATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// åæ®ç¶æ |
| | | /// ç¶æ(0Initæ°å建|1Imported已导å
¥|2WaitPickå¾
æ¡æ|3Pickingæ¡æä¸|4Pickedå·²æ¡å®|5Sendedå·²è°åº|6Arrivedå·²éè¾¾|7Countingæ¸
ç¹ä¸|8InQCæ£éªä¸|9Storing䏿¶ä¸|10Finished已宿|11Cancelä½åº) |
| | | /// </summary> |
| | | [DisplayName("ç¶æ(0Initæ°å建|1Imported已导å
¥|2WaitPickå¾
æ¡æ|3Pickingæ¡æä¸|4Pickedå·²æ¡å®|5Sendedå·²è°åº|6Arrivedå·²éè¾¾|7Countingæ¸
ç¹ä¸|8InQCæ£éªä¸|9Storing䏿¶ä¸|10Finished已宿|11Cancelä½åº)")] |
| | | public int STATUS { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ä¸å¡ç±»å |
| | | /// è°åºä»åº |
| | | /// </summary> |
| | | public string BIZTYPE { get; set; } |
| | | |
| | | [DisplayName("è°åºä»åº")] |
| | | public string OUT_WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// åºåºä»åºä»£ç |
| | | /// æ¨å
¥ä»åº |
| | | /// </summary> |
| | | public string OUTWAREHOUSECODE { get; set; } |
| | | |
| | | [DisplayName("æ¨å
¥ä»åº")] |
| | | public string IN_WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// å
¥åºåºä»åºä»£ç |
| | | /// æ¥æºåæ®ç¼ç ï¼å¤ä¸ªç¨â'âåé |
| | | /// </summary> |
| | | public string INWAREHOUSECODE { get; set; } |
| | | |
| | | [DisplayName("æ¥æºåæ®ç¼ç ï¼å¤ä¸ªç¨â'âåé")] |
| | | public string SOURCE_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¥æºåæ®ç±»å |
| | | /// æ¥æºåå·ï¼å¤ä¸ªç¨â'âåéï¼è·ç¼ç ä¸ä¸å¯¹åº |
| | | /// </summary> |
| | | public int SOURCETYPE { get; set; } |
| | | |
| | | [DisplayName("æ¥æºåå·ï¼å¤ä¸ªç¨â'âåéï¼è·ç¼ç ä¸ä¸å¯¹åº")] |
| | | public string SOURCE_ORDER { get; set; } |
| | | /// <summary> |
| | | /// æ¥æºåæ®ä»£ç |
| | | /// ERPåæ®å·ç |
| | | /// </summary> |
| | | public string SOURCECODE { get; set; } |
| | | |
| | | [DisplayName("ERPåæ®å·ç ")] |
| | | public string ERP_ORDER { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [DisplayName("夿³¨")] |
| | | public string REMARK { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERP忮代ç |
| | | /// </summary> |
| | | public string ERP_BILL_CODE { get; set; } |
| | | |
| | | /// <summary> |
| | | /// -1:æªå¤çï¼0:忥å¤çå®ï¼>0:忥å¤çå¤±è´¥æ¬¡æ° |
| | | /// </summary> |
| | | [DisplayName("-1:æªå¤çï¼0:忥å¤çå®ï¼>0:忥å¤ç失败次æ°")] |
| | | public int HANDLED { get; set; } |
| | | |
| | | /// <summary> |
| | | /// æå䏿¬¡åæ¥å¤çæ¥æ |
| | | /// </summary> |
| | | [DisplayName("æå䏿¬¡åæ¥å¤çæ¥æ")] |
| | | public DateTime HANDLED_DATE { get; set; } = DateTime.MinValue; |
| | | |
| | | /// <summary> |
| | | /// è¿è´¦æäº¤çJSON |
| | | /// </summary> |
| | | [DisplayName("è¿è´¦æäº¤çJSON")] |
| | | public string COMMIT_JSON { get; set; } |
| | | |
| | | /// <summary> |
| | | /// è¿è´¦æäº¤çè¿åä¿¡æ¯ |
| | | /// </summary> |
| | | [DisplayName("è¿è´¦æäº¤çè¿åä¿¡æ¯")] |
| | | public string COMMIT_MSG { get; set; } |
| | | |
| | | #endregion å
Œ
±å±æ§ |
| | | #endregion |
| | | |
| | | #region èæå±æ§ |
| | | |
| | | /*ä¾å |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | |
| | | #endregion èæå±æ§ |
| | | #endregion |
| | | |
| | | #region å¤é®å±æ§ |
| | | |
| | | /*ä¾å |
| | | //ä¸å¯¹ä¸å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//ä¸å¯¹ä¸ ClassAIdæ¯BIZ_WMS_TRANSFERç±»éé¢çå¤é®IDåæ®µ |
| | |
| | | public List<ClassA> ClassAList { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | */ |
| | | |
| | | [Navigate(NavigateType.OneToMany, nameof(BIZ_WMS_TRANSFER_DTL.BILLCODE), nameof(BILLCODE))] |
| | | [Navigate(NavigateType.OneToMany, nameof(BIZ_WMS_TRANSFER_DTL.ORDER_NO), nameof(ORDER_NO))] |
| | | public List<BIZ_WMS_TRANSFER_DTL> DtlsWithGhost { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | |
| | | [SugarColumn(IsIgnore = true)] |
| | | public List<BIZ_WMS_TRANSFER_DTL> Dtls => DtlsWithGhost?.Where(q => !q.GHOST_ROW).ToList(); |
| | | |
| | | [Navigate(NavigateType.OneToMany, nameof(BIZ_WMS_TRANSFER_SN.BILLCODE), nameof(BILLCODE))] |
| | | [Navigate(NavigateType.OneToMany, nameof(BIZ_WMS_TRANSFER_SN.ORDER_NO), nameof(ORDER_NO))] |
| | | public List<BIZ_WMS_TRANSFER_SN> SnListWithGhost { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | |
| | | [SugarColumn(IsIgnore = true)] |
| | |
| | | #endregion å¤é®å±æ§ |
| | | |
| | | #region æä¸¾åé |
| | | |
| | | /*ä¾å |
| | | public enum FieldNames |
| | | { |
| | | [Description("æä¸¾æè¿°0")] |
| | | Enum0, |
| | | [Description("æä¸¾æè¿°1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | |
| | | public enum FieldNames |
| | | { |
| | | [Description("æä¸¾æè¿°0")] |
| | | Enum0, |
| | | [Description("æä¸¾æè¿°1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | /// <summary> |
| | | /// æä¸¾ï¼ç¶æ(0Initæ°å建|1Imported已导å
¥|2WaitPickå¾
æ¡æ|3Pickingæ¡æä¸|4Pickedå·²æ¡å®|5Sendedå·²è°åº|6Arrivedå·²éè¾¾|7Countingæ¸
ç¹ä¸|8InQCæ£éªä¸|9Storing䏿¶ä¸|10Finished已宿|11Cancelä½åº) |
| | | /// </summary> |
| | | public enum STATUSs |
| | | { |
| | | /// <summary> |
| | | /// |
| | | /// </summary> |
| | | [Description("æå·¥æ°å¢")] |
| | | MANUAL = -1, |
| | | |
| | | /// <summary> |
| | | /// |
| | | /// </summary> |
| | | [Description("æ°å¢")] |
| | | INIT, |
| | | |
| | | /// <summary> |
| | | /// |
| | | /// </summary> |
| | | [Description("ä½ä¸ä¸")] |
| | | WORKING, |
| | | |
| | | /// <summary> |
| | | /// |
| | | /// </summary> |
| | | [Description("宿")] |
| | | COMPLETE, |
| | | |
| | | /// <summary> |
| | | /// 颿å主å¨è°æ¨è¿è´¦ç¶æ |
| | | /// </summary> |
| | | [Description("è°æ¨å®æ")] |
| | | FINISHED, |
| | | |
| | | /// <summary> |
| | | /// æå¨ä¸æ¶å®æ |
| | | /// </summary> |
| | | [Description("æå¨ä¸æ¶å®æ")] |
| | | MANUALCOMPLETE, |
| | | |
| | | /// <summary> |
| | | /// è°åº |
| | | /// </summary> |
| | | [Description("è°åº")] |
| | | OUTERCOMPLETE, |
| | | [Description("æ°å建")] |
| | | Init = 0, |
| | | [Description("已导å
¥")] |
| | | Imported = 1, |
| | | [Description("å¾
æ¡æ")] |
| | | WaitPick = 2, |
| | | [Description("æ¡æä¸")] |
| | | Picking = 3, |
| | | [Description("å·²æ¡å®")] |
| | | Picked = 4, |
| | | [Description("å·²è°åº")] |
| | | Sended = 5, |
| | | [Description("å·²éè¾¾")] |
| | | Arrived = 6, |
| | | [Description("æ¸
ç¹ä¸")] |
| | | Counting = 7, |
| | | [Description("æ£éªä¸")] |
| | | InQC = 8, |
| | | [Description("䏿¶ä¸")] |
| | | Storing = 9, |
| | | [Description("已宿")] |
| | | Finished = 10, |
| | | [Description("ä½åº")] |
| | | Cancel = 11, |
| | | } |
| | | |
| | | #endregion æä¸¾åé |
| | | #endregion |
| | | |
| | | #region å
Œ
±æ¹æ³ |
| | | |
| | | public static List<string> strongHoldList = new List<string> |
| | | { |
| | | "XCSJ", |
| | | "DGXC", |
| | | "AHXC" |
| | | }; |
| | | #endregion |
| | | |
| | | #endregion å
Œ
±æ¹æ³ |
| | | }//endClass |
| | | } |
| | |
| | | /// å®ä½ï¼è°æ¨å(WMS)æç» |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("è°æ¨å(WMS)æç»")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_WMS_TRANSFER_DTL")] |
| | | public class BIZ_WMS_TRANSFER_DTL : DbEntityWithAuth |
| | |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// 忮代ç |
| | | /// è°æ¨åå· |
| | | /// </summary> |
| | | public string BILLCODE { get; set; } |
| | | [DisplayName("è°æ¨åå·")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// åæ®è¡å· |
| | | /// è°æ¨åè¡å· |
| | | /// </summary> |
| | | public string BILLLINE { get; set; } |
| | | [DisplayName("è°æ¨åè¡å·")] |
| | | public string ORDER_LINE { get; set; } |
| | | /// <summary> |
| | | /// åæ®è¡ç¶æ |
| | | /// </summary> |
| | | public int LINESTATUS { get; set; } |
| | | [DisplayName("åæ®è¡ç¶æ")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | | [DisplayName("ç©æç¼ç ")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// åä½ä»£ç |
| | | /// åä½ |
| | | /// </summary> |
| | | public string UNITCODE { get; set; } |
| | | [DisplayName("åä½")] |
| | | public string UNIT { get; set; } |
| | | /// <summary> |
| | | /// éæ±æ°é |
| | | /// </summary> |
| | | public double PRQTY { get; set; } |
| | | [DisplayName("éæ±æ°é")] |
| | | public double QTY_REQ { get; set; } |
| | | /// <summary> |
| | | /// åºåºæ°é |
| | | /// è°åºæ°é |
| | | /// </summary> |
| | | public double OUTQTY { get; set; } |
| | | [DisplayName("è°åºæ°é")] |
| | | public double QTY_OUT { get; set; } |
| | | /// <summary> |
| | | /// å
¥åºæ°é |
| | | /// æ¨å
¥æ°é |
| | | /// </summary> |
| | | public double INQTY { get; set; } |
| | | [DisplayName("æ¨å
¥æ°é")] |
| | | public double QTY_IN { get; set; } |
| | | /// <summary> |
| | | /// åºåºä»åºä»£ç |
| | | /// è°åºä»åº |
| | | /// </summary> |
| | | public string OUTWAREHOUSECODE { get; set; } |
| | | [DisplayName("è°åºä»åº")] |
| | | public string OUT_WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// å
¥åºä»åºä»£ç |
| | | /// æ¨å
¥ä»åº |
| | | /// </summary> |
| | | public string INWAREHOUSECODE { get; set; } |
| | | [DisplayName("æ¨å
¥ä»åº")] |
| | | public string IN_WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¥æºåæ®ç±»å |
| | | /// æ¨åºæ¹å· |
| | | /// </summary> |
| | | public int SOURCETYPE { get; set; } |
| | | [DisplayName("æ¨åºæ¹å·")] |
| | | public string OUT_LOTNO { get; set; } |
| | | /// <summary> |
| | | /// æ¥æºåæ®ä»£ç |
| | | /// æ¨å
¥æ¹å· |
| | | /// </summary> |
| | | public string SOURCECODE { get; set; } |
| | | [DisplayName("æ¨å
¥æ¹å·")] |
| | | public string IN_LOTNO { get; set; } |
| | | /// <summary> |
| | | /// æ¥æºåæ®è¡å· |
| | | /// æ¥æºåæ®ç¼ç ï¼å¤ä¸ªç¨â'âåé |
| | | /// </summary> |
| | | public string SOURCELINE { get; set; } |
| | | [DisplayName("æ¥æºåæ®ç¼ç ï¼å¤ä¸ªç¨â'âåé")] |
| | | public string SOURCE_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¥æºåå·ï¼å¤ä¸ªç¨â'âåéï¼è·ç¼ç ä¸ä¸å¯¹åº |
| | | /// </summary> |
| | | [DisplayName("æ¥æºåå·ï¼å¤ä¸ªç¨â'âåéï¼è·ç¼ç ä¸ä¸å¯¹åº")] |
| | | public string SOURCE_ORDER { get; set; } |
| | | /// <summary> |
| | | /// æ¥æºåè¡å·ï¼å¤ä¸ªç¨â'âåéï¼è·ç¼ç ä¸ä¸å¯¹åº |
| | | /// </summary> |
| | | [DisplayName("æ¥æºåè¡å·ï¼å¤ä¸ªç¨â'âåéï¼è·ç¼ç ä¸ä¸å¯¹åº")] |
| | | public string SOURCE_LINE { get; set; } |
| | | /// <summary> |
| | | /// ERPåæ®å·ç |
| | | /// </summary> |
| | | [DisplayName("ERPåæ®å·ç ")] |
| | | public string ERP_ORDER { get; set; } |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [DisplayName("夿³¨")] |
| | | public string REMARK { get; set; } |
| | | /// <summary> |
| | | /// ERP忮代ç |
| | | /// </summary> |
| | | public string ERP_BILL_CODE { get; set; } |
| | | /// <summary> |
| | | /// åºåæ°é |
| | | /// </summary> |
| | | public double INVENTORYQTY { get; set; } = 0; |
| | | /// <summary> |
| | | /// æ¨å
¥æ¹å· |
| | | /// </summary> |
| | | public string BATCH_NO_IN { get; set; } |
| | | /// <summary> |
| | | /// æ¨åºæ¹å· |
| | | /// </summary> |
| | | public string BATCH_NO_OUT { get; set; } |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region èæå±æ§ |
| | | /*ä¾å |
| | | #region èæå±æ§ |
| | | /*ä¾å |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region å¤é®å±æ§ |
| | | /*ä¾å |
| | | #region å¤é®å±æ§ |
| | | /*ä¾å |
| | | //ä¸å¯¹ä¸å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//ä¸å¯¹ä¸ ClassAIdæ¯BIZ_WMS_TRANSFER_DTLç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | |
| | | public BAS_ITEM ItemInfo => _ItemInfos?.FirstOrDefault(q => q.AUTH_ORG == AUTH_ORG); |
| | | #endregion |
| | | |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | public enum FieldNames |
| | | { |
| | | [Description("æä¸¾æè¿°0")] |
| | |
| | | Enum1, |
| | | } |
| | | */ |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region å
Œ
±æ¹æ³ |
| | | #region å
Œ
±æ¹æ³ |
| | | |
| | | #endregion |
| | | #endregion |
| | | |
| | | }//endClass |
| | | }//endClass |
| | | } |
| | |
| | | namespace Tiger.Model |
| | | { |
| | | /// <summary> |
| | | /// å®ä½ï¼è°æ¨å(WMS)æ¡ç æç» |
| | | /// å®ä½ï¼è°æ¨å(WMS)æ¡ç æç» |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("è°æ¨å(WMS)æ¡ç æç»")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_WMS_TRANSFER_SN")] |
| | | public class BIZ_WMS_TRANSFER_SN : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼è°æ¨å(WMS)æ¡ç æç» |
| | | /// å®ä½ï¼è°æ¨å(WMS)æ¡ç æç» |
| | | /// </summary> |
| | | public BIZ_WMS_TRANSFER_SN() {} |
| | | #endregion |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// æ¡ç |
| | | /// è°æ¨åå· |
| | | /// </summary> |
| | | [DisplayName("è°æ¨åå·")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// è°æ¨åè¡å· |
| | | /// </summary> |
| | | [DisplayName("è°æ¨åè¡å·")] |
| | | public string ORDER_LINE { get; set; } |
| | | /// <summary> |
| | | /// æ¡ç |
| | | /// </summary> |
| | | [DisplayName("æ¡ç ")] |
| | | public string SN { get; set; } |
| | | /// <summary> |
| | | /// å
æ¡ç |
| | | /// </summary> |
| | | public string META_SN { get; set; } |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ°é |
| | | /// ״̬(ͬWMS_ITEM״̬) |
| | | /// </summary> |
| | | [DisplayName("״̬(ͬWMS_ITEM״̬)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | | [DisplayName("ç©æç¼ç ")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ°é |
| | | /// </summary> |
| | | [DisplayName("æ°é")] |
| | | public double QTY { get; set; } |
| | | /// <summary> |
| | | /// 忮代ç |
| | | /// è°åºä»åº |
| | | /// </summary> |
| | | public string BILLCODE { get; set; } |
| | | [DisplayName("è°åºä»åº")] |
| | | public string OUT_WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// åæ®æ¥æ |
| | | /// è°åºå¨åº |
| | | /// </summary> |
| | | public DateTime BILLDATE { get; set; } = DateTime.MinValue; |
| | | [DisplayName("è°åºå¨åº")] |
| | | public string OUT_REGION_CODE { get; set; } |
| | | /// <summary> |
| | | /// åæ®è¡å· |
| | | /// è°åºè´§æ¶ |
| | | /// </summary> |
| | | public string BILLLINE { get; set; } |
| | | /// <summary> |
| | | /// åæ®ç¶æ |
| | | /// </summary> |
| | | public int STATUS { get; set; } |
| | | #endregion |
| | | [DisplayName("è°åºè´§æ¶")] |
| | | public string OUT_SHELF_CODE { get; set; } |
| | | /// <summary> |
| | | /// è°åºå¨ä½ |
| | | /// </summary> |
| | | [DisplayName("è°åºå¨ä½")] |
| | | public string OUT_LOCATION_CODE { get; set; } |
| | | /// <summary> |
| | | /// è°åºæ¶é´ |
| | | /// </summary> |
| | | [DisplayName("è°åºæ¶é´")] |
| | | public DateTime OUT_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// æ¨å
¥ä»åº |
| | | /// </summary> |
| | | [DisplayName("æ¨å
¥ä»åº")] |
| | | public string IN_WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¨å
¥å¨åº |
| | | /// </summary> |
| | | [DisplayName("æ¨å
¥å¨åº")] |
| | | public string IN_REGION_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¨å
¥è´§æ¶ |
| | | /// </summary> |
| | | [DisplayName("æ¨å
¥è´§æ¶")] |
| | | public string IN_SHELF_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¨å
¥å¨ä½ |
| | | /// </summary> |
| | | [DisplayName("æ¨å
¥å¨ä½")] |
| | | public string IN_LOCATION_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¨å
¥æ¶é´ |
| | | /// </summary> |
| | | [DisplayName("æ¨å
¥æ¶é´")] |
| | | public DateTime IN_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// 夿³¨ |
| | | /// </summary> |
| | | [DisplayName("夿³¨")] |
| | | public string REMARK { get; set; } |
| | | #endregion |
| | | |
| | | #region èæå±æ§ |
| | | /*ä¾å |
| | | #region èæå±æ§ |
| | | /*ä¾å |
| | | [SugarColumn(IsIgnore = true)] |
| | | public string FieldName { get; set; } |
| | | */ |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region å¤é®å±æ§ |
| | | /*ä¾å |
| | | //ä¸å¯¹ä¸å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//ä¸å¯¹ä¸ ClassAIdæ¯BIZ_WMS_TRANSFER_SNç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_WMS_TRANSFER_SNId))]//ClassA表ä¸çBIZ_WMS_TRANSFER_SNId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_WMS_TRANSFER_SNId), nameof(MappingClass.ClassAId))]//注æé¡ºåº |
| | | public List<ClassA> ClassAList { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | #region å¤é®å±æ§ |
| | | /*ä¾å |
| | | //ä¸å¯¹ä¸å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToOne, nameof(ClassAId))]//ä¸å¯¹ä¸ ClassAIdæ¯BIZ_WMS_TRANSFER_SNç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_WMS_TRANSFER_SNId))]//ClassA表ä¸çBIZ_WMS_TRANSFER_SNId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_WMS_TRANSFER_SNId), nameof(MappingClass.ClassAId))]//注æé¡ºåº |
| | | public List<ClassA> ClassAList { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | */ |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | public enum FieldNames |
| | | { |
| | | [Description("æä¸¾æè¿°0")] |
| | | [Description("æä¸¾æè¿°0")] |
| | | Enum0, |
| | | [Description("æä¸¾æè¿°1")] |
| | | [Description("æä¸¾æè¿°1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | #endregion |
| | | #endregion |
| | | |
| | | #region å
Œ
±æ¹æ³ |
| | | #region å
Œ
±æ¹æ³ |
| | | |
| | | #endregion |
| | | #endregion |
| | | |
| | | }//endClass |
| | | }//endClass |
| | | } |