| | |
| | | ASN_NO =asnDtl.ORDER_NO, |
| | | ASN_LINE_ID = item.SrcASNDocLineId.ToString(), |
| | | ASN_LINE = asnDtl.LINE_NO, |
| | | ERP_CODE = item.ItemCode1, |
| | | }; |
| | | receipt.Details.Add(receiptDt); |
| | | } |
| | | |
| | | foreach (var item in order.SnList) |
| | | foreach (var sn in order.SnList) |
| | | { |
| | | var dtl = receipt.Details.First(q => q.ASN_LINE == item.LINE_NO); |
| | | var dtl = receipt.Details.First(q => q.ASN_LINE == sn.LINE_NO); |
| | | BIZ_U9_RECEIPT_SN receiptSn = new() |
| | | { |
| | | |
| | | { |
| | | AUTH_ORG = dtl.AUTH_ORG, |
| | | ORDER_NO = dtl.ORDER_NO, |
| | | LINE_NO = dtl.LINE_NO, |
| | | SN = receipt.Details.First().ORDER_NO, |
| | | //META_SN |
| | | ITEM_CODE = dtl.ITEM_CODE, |
| | | STATUS = BIZ_U9_RECEIPT.STATUSs.Imported.GetValue(), |
| | | // QTY |
| | | //UNIT |
| | | //IS_OK |
| | | // IS_IN |
| | | //IS_SCRAP |
| | | //LOTNO |
| | | //CARTON_NO |
| | | //PALLET_NO |
| | | AUTH_ORG = dtl.AUTH_ORG, |
| | | // REMARK = result.Data[item].Code, |
| | | SN = sn.SN, |
| | | META_SN = sn.META_SN, |
| | | ITEM_CODE = sn.ITEM_CODE, |
| | | STATUS = WMS_ITEM.STATUSs.WaitIn.GetValue(), |
| | | QTY = sn.QTY, |
| | | UNIT = sn.UNIT, |
| | | IS_OK = sn.IS_OK, |
| | | IS_IN = sn.IS_IN, |
| | | LOTNO = sn.LOTNO, |
| | | CARTON_NO = sn.CARTON_NO, |
| | | PALLET_NO = sn.PALLET_NO, |
| | | }; |
| | | receipt.SnList.Add(receiptSn); |
| | | } |
| | | |
| | | } |
| | | // throw new NotImplementedException(); |
| | | |
| | | //æ´æ°åºåè¡¨ä¿¡æ¯ |
| | | var items = MainDB.Queryable<WMS_ITEM>().Where(q => SqlFunc.Subqueryable<BIZ_U9_ASN_SN>().Where(s => s.SN == q.SN && s.ORDER_NO == order.ORDER_NO).Any()).ToList(); |
| | |
| | | /// </summary> |
| | | public string DocNo { get; set; } |
| | | /// <summary> |
| | | /// è¡å· |
| | | /// </summary> |
| | | public int DocLineNo { get; set; } |
| | | /// <summary> |
| | | /// æå· |
| | | /// </summary> |
| | | public string ItemCode { get; set; } |
| | |
| | | /// </summary> |
| | | public string DocNo { get; set; } |
| | | /// <summary> |
| | | /// è¡å· |
| | | /// </summary> |
| | | public int DocLineNo { get; set; } |
| | | /// <summary> |
| | | /// æå· |
| | | /// </summary> |
| | | public string ItemCode { get; set; } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | 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_MISC_IN")] |
| | | public class BIZ_U9_MISC_IN : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼ææ¶å(U9) |
| | | /// </summary> |
| | | public BIZ_U9_MISC_IN() {} |
| | | #endregion |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// åæ®å· |
| | | /// </summary> |
| | | [DisplayName("åæ®å·")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// ç¶æ(0Initåå§å|1Imported已导å
¥|2Arrivedå·²éè¾¾|3Countingæ¸
ç¹ä¸|4InQCæ£éªä¸|5Storing䏿¶ä¸|6Reviewå¾
å®¡æ ¸|7Finished已宿|8Cancelå·²ä½åº) |
| | | /// </summary> |
| | | [DisplayName("ç¶æ(0Initåå§å|1Imported已导å
¥|2Arrivedå·²éè¾¾|3Countingæ¸
ç¹ä¸|4InQCæ£éªä¸|5Storing䏿¶ä¸|6Reviewå¾
å®¡æ ¸|7Finished已宿|8Cancelå·²ä½åº)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// åæ®ç±»åç¼ç |
| | | /// </summary> |
| | | [DisplayName("åæ®ç±»åç¼ç ")] |
| | | public string TYPE_CODE { get; set; } |
| | | /// <summary> |
| | | /// åæ®ç±»ååç§° |
| | | /// </summary> |
| | | [DisplayName("åæ®ç±»ååç§°")] |
| | | public string 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 DateTime ORDER_DATE { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// æ¶è´§äºº |
| | | /// </summary> |
| | | [DisplayName("æ¶è´§äºº")] |
| | | public string RECEIVER { get; set; } |
| | | /// <summary> |
| | | /// æ¶è´§æ¥æ |
| | | /// </summary> |
| | | [DisplayName("æ¶è´§æ¥æ")] |
| | | public DateTime RECEIVE_DATE { 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_MISC_INç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_MISC_INId))]//ClassA表ä¸çBIZ_U9_MISC_INId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_MISC_INId), nameof(MappingClass.ClassAId))]//注æé¡ºåº |
| | | public List<ClassA> ClassAList { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | */ |
| | | #endregion |
| | | |
| | | #region æä¸¾åé |
| | | /*ä¾å |
| | | public enum FieldNames |
| | | { |
| | | [Description("æä¸¾æè¿°0")] |
| | | Enum0, |
| | | [Description("æä¸¾æè¿°1")] |
| | | Enum1, |
| | | } |
| | | */ |
| | | |
| | | /// <summary> |
| | | /// æä¸¾ï¼ç¶æ(0Initåå§å|1Imported已导å
¥|2Arrivedå·²éè¾¾|3Countingæ¸
ç¹ä¸|4InQCæ£éªä¸|5Storing䏿¶ä¸|6Reviewå¾
å®¡æ ¸|7Finished已宿|8Cancelå·²ä½åº) |
| | | /// </summary> |
| | | public enum STATUSs |
| | | { |
| | | [Description("åå§å")] |
| | | Init = 0, |
| | | [Description("已导å
¥")] |
| | | Imported = 1, |
| | | [Description("å·²éè¾¾")] |
| | | Arrived = 2, |
| | | [Description("æ¸
ç¹ä¸")] |
| | | Counting = 3, |
| | | [Description("æ£éªä¸")] |
| | | InQC = 4, |
| | | [Description("䏿¶ä¸")] |
| | | Storing = 5, |
| | | [Description("å¾
å®¡æ ¸")] |
| | | Review = 6, |
| | | [Description("已宿")] |
| | | Finished = 7, |
| | | [Description("å·²ä½åº")] |
| | | Cancel = 8, |
| | | } |
| | | #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_MISC_IN_DTL")] |
| | | public class BIZ_U9_MISC_IN_DTL : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼ææ¶å(U9)æç» |
| | | /// </summary> |
| | | public BIZ_U9_MISC_IN_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> |
| | | /// ç©æç¼ç |
| | | /// </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 string UNIT_COST { get; set; } |
| | | /// <summary> |
| | | /// ææ¬æ°é |
| | | /// </summary> |
| | | [DisplayName("ææ¬æ°é")] |
| | | public double QTY_GIFT { get; set; } |
| | | /// <summary> |
| | | /// åä»· |
| | | /// </summary> |
| | | [DisplayName("åä»·")] |
| | | public double COST_PRICE { get; set; } |
| | | /// <summary> |
| | | /// ææ¬ |
| | | /// </summary> |
| | | [DisplayName("ææ¬")] |
| | | public double COST_MNY { get; set; } |
| | | /// <summary> |
| | | /// åå¨å°ç¹ |
| | | /// </summary> |
| | | [DisplayName("åå¨å°ç¹")] |
| | | public string WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// åå¨å°ç¹åç§° |
| | | /// </summary> |
| | | [DisplayName("åå¨å°ç¹åç§°")] |
| | | public string WH_NAME { get; set; } |
| | | /// <summary> |
| | | /// åçé¨é¨ç¼ç |
| | | /// </summary> |
| | | [DisplayName("åçé¨é¨ç¼ç ")] |
| | | public string BNF_DEPT_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¶çé¨é¨åç§° |
| | | /// </summary> |
| | | [DisplayName("æ¶çé¨é¨åç§°")] |
| | | public string BNF_DEPT_NAME { get; set; } |
| | | /// <summary> |
| | | /// ERPç¼ç |
| | | /// </summary> |
| | | [DisplayName("ERPç¼ç ")] |
| | | public string ERP_CODE { get; set; } |
| | | /// <summary> |
| | | /// éæåå |
| | | /// </summary> |
| | | [DisplayName("éæåå ")] |
| | | public string RETURN_REASON { get; set; } |
| | | /// <summary> |
| | | /// å
¥åºåå |
| | | /// </summary> |
| | | [DisplayName("å
¥åºåå ")] |
| | | public string INSTORE_REASON { 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_MISC_IN_DTLç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_MISC_IN_DTLId))]//ClassA表ä¸çBIZ_U9_MISC_IN_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_MISC_IN_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> |
| | | /// å®ä½ï¼ææ¶å(U9)æ¡ç æç» |
| | | /// </summary> |
| | | [Description("Primary:ID")] |
| | | [DisplayName("ææ¶å(U9)æ¡ç æç»")] |
| | | [Serializable] |
| | | [SugarTable("BIZ_U9_MISC_IN_SN")] |
| | | public class BIZ_U9_MISC_IN_SN : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼ææ¶å(U9)æ¡ç æç» |
| | | /// </summary> |
| | | public BIZ_U9_MISC_IN_SN() {} |
| | | #endregion |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// åæ®å· |
| | | /// </summary> |
| | | [DisplayName("åæ®å·")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// åæ®è¡å· |
| | | /// </summary> |
| | | [DisplayName("åæ®è¡å·")] |
| | | public string LINE_NO { get; set; } |
| | | /// <summary> |
| | | /// æ¡ç |
| | | /// </summary> |
| | | [DisplayName("æ¡ç ")] |
| | | public string SN { get; set; } |
| | | /// <summary> |
| | | /// å
æ¡ç |
| | | /// </summary> |
| | | [DisplayName("å
æ¡ç ")] |
| | | public string META_SN { get; set; } |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | | [DisplayName("ç©æç¼ç ")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// ״̬(ͬWMS_ITEM״̬) |
| | | /// </summary> |
| | | [DisplayName("״̬(ͬWMS_ITEM״̬)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// æ°é |
| | | /// </summary> |
| | | [DisplayName("æ°é")] |
| | | public double QTY { get; set; } |
| | | /// <summary> |
| | | /// åä½ |
| | | /// </summary> |
| | | [DisplayName("åä½")] |
| | | public string UNIT { get; set; } |
| | | /// <summary> |
| | | /// æ¯å¦è¯å(Y/N) |
| | | /// </summary> |
| | | [DisplayName("æ¯å¦è¯å(Y/N)")] |
| | | public string IS_OK { get; set; } |
| | | /// <summary> |
| | | /// æ¯å¦å
¥åº(Y/N) |
| | | /// </summary> |
| | | [DisplayName("æ¯å¦å
¥åº(Y/N)")] |
| | | public string IS_IN { get; set; } |
| | | /// <summary> |
| | | /// æ¯å¦æ¥åº(Y/N) |
| | | /// </summary> |
| | | [DisplayName("æ¯å¦æ¥åº(Y/N)")] |
| | | public string IS_SCRAP { get; set; } |
| | | /// <summary> |
| | | /// æ¹æ¬¡å· |
| | | /// </summary> |
| | | [DisplayName("æ¹æ¬¡å·")] |
| | | public string LOTNO { get; set; } |
| | | /// <summary> |
| | | /// ç®±å· |
| | | /// </summary> |
| | | [DisplayName("ç®±å·")] |
| | | public string CARTON_NO { get; set; } |
| | | /// <summary> |
| | | /// æ æ¿å· |
| | | /// </summary> |
| | | [DisplayName("æ æ¿å·")] |
| | | public string PALLET_NO { 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_MISC_IN_SNç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_MISC_IN_SNId))]//ClassA表ä¸çBIZ_U9_MISC_IN_SNId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_MISC_IN_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_MISC_OUT")] |
| | | public class BIZ_U9_MISC_OUT : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼æåå(U9) |
| | | /// </summary> |
| | | public BIZ_U9_MISC_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 string TYPE_CODE { get; set; } |
| | | /// <summary> |
| | | /// åæ®ç±»ååç§° |
| | | /// </summary> |
| | | [DisplayName("åæ®ç±»ååç§°")] |
| | | public string 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 DateTime ORDER_DATE { get; set; } = DateTime.MinValue; |
| | | /// <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_MISC_OUTç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_MISC_OUTId))]//ClassA表ä¸çBIZ_U9_MISC_OUTId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_MISC_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_MISC_OUT_DTL")] |
| | | public class BIZ_U9_MISC_OUT_DTL : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼æåå(U9)æç» |
| | | /// </summary> |
| | | public BIZ_U9_MISC_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> |
| | | /// ç©æç¼ç |
| | | /// </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 string UNIT_COST { get; set; } |
| | | /// <summary> |
| | | /// ææ¬æ°é |
| | | /// </summary> |
| | | [DisplayName("ææ¬æ°é")] |
| | | public double QTY_GIFT { get; set; } |
| | | /// <summary> |
| | | /// åä»· |
| | | /// </summary> |
| | | [DisplayName("åä»·")] |
| | | public double COST_PRICE { get; set; } |
| | | /// <summary> |
| | | /// ææ¬ |
| | | /// </summary> |
| | | [DisplayName("ææ¬")] |
| | | public double COST_MNY { get; set; } |
| | | /// <summary> |
| | | /// åå¨å°ç¹ |
| | | /// </summary> |
| | | [DisplayName("åå¨å°ç¹")] |
| | | public string WH_CODE { get; set; } |
| | | /// <summary> |
| | | /// åå¨å°ç¹åç§° |
| | | /// </summary> |
| | | [DisplayName("åå¨å°ç¹åç§°")] |
| | | public string WH_NAME { get; set; } |
| | | /// <summary> |
| | | /// åçé¨é¨ç¼ç |
| | | /// </summary> |
| | | [DisplayName("åçé¨é¨ç¼ç ")] |
| | | public string BNF_DEPT_CODE { get; set; } |
| | | /// <summary> |
| | | /// æ¶çé¨é¨åç§° |
| | | /// </summary> |
| | | [DisplayName("æ¶çé¨é¨åç§°")] |
| | | public string BNF_DEPT_NAME { get; set; } |
| | | /// <summary> |
| | | /// ERPç¼ç |
| | | /// </summary> |
| | | [DisplayName("ERPç¼ç ")] |
| | | public string ERP_CODE { get; set; } |
| | | /// <summary> |
| | | /// åºåºåå |
| | | /// </summary> |
| | | [DisplayName("åºåºåå ")] |
| | | public string OUTSTORE_REASON { 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_MISC_OUT_DTLç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_MISC_OUT_DTLId))]//ClassA表ä¸çBIZ_U9_MISC_OUT_DTLId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_MISC_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 |
| | | } |
¶Ô±ÈÐÂÎļþ |
| | |
| | | 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_MISC_OUT_SN")] |
| | | public class BIZ_U9_MISC_OUT_SN : DbEntityWithAuth |
| | | { |
| | | #region æé 彿° |
| | | /// <summary> |
| | | /// å®ä½ï¼æåå(U9)æ¡ç æç» |
| | | /// </summary> |
| | | public BIZ_U9_MISC_OUT_SN() {} |
| | | #endregion |
| | | |
| | | #region å
Œ
±å±æ§ |
| | | /// <summary> |
| | | /// åæ®å· |
| | | /// </summary> |
| | | [DisplayName("åæ®å·")] |
| | | public string ORDER_NO { get; set; } |
| | | /// <summary> |
| | | /// åæ®è¡å· |
| | | /// </summary> |
| | | [DisplayName("åæ®è¡å·")] |
| | | public string LINE_NO { get; set; } |
| | | /// <summary> |
| | | /// æ¡ç |
| | | /// </summary> |
| | | [DisplayName("æ¡ç ")] |
| | | public string SN { get; set; } |
| | | /// <summary> |
| | | /// å
æ¡ç |
| | | /// </summary> |
| | | [DisplayName("å
æ¡ç ")] |
| | | public string META_SN { get; set; } |
| | | /// <summary> |
| | | /// ç©æç¼ç |
| | | /// </summary> |
| | | [DisplayName("ç©æç¼ç ")] |
| | | public string ITEM_CODE { get; set; } |
| | | /// <summary> |
| | | /// ״̬(ͬWMS_ITEM״̬) |
| | | /// </summary> |
| | | [DisplayName("״̬(ͬWMS_ITEM״̬)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// æ°é |
| | | /// </summary> |
| | | [DisplayName("æ°é")] |
| | | public double QTY { get; set; } |
| | | /// <summary> |
| | | /// åä½ |
| | | /// </summary> |
| | | [DisplayName("åä½")] |
| | | public string UNIT { 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 DOWN_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// åºåºæ¶é´ |
| | | /// </summary> |
| | | [DisplayName("åºåºæ¶é´")] |
| | | public DateTime DLVY_TIME { get; set; } = DateTime.MinValue; |
| | | /// <summary> |
| | | /// æ¯å¦åºåº(Y/N) |
| | | /// </summary> |
| | | [DisplayName("æ¯å¦åºåº(Y/N)")] |
| | | public string IS_OUT { get; set; } |
| | | /// <summary> |
| | | /// æ¹æ¬¡å· |
| | | /// </summary> |
| | | [DisplayName("æ¹æ¬¡å·")] |
| | | public string LOTNO { get; set; } |
| | | /// <summary> |
| | | /// ç®±å· |
| | | /// </summary> |
| | | [DisplayName("ç®±å·")] |
| | | public string CARTON_NO { get; set; } |
| | | /// <summary> |
| | | /// æ æ¿å· |
| | | /// </summary> |
| | | [DisplayName("æ æ¿å·")] |
| | | public string PALLET_NO { 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_MISC_OUT_SNç±»éé¢çå¤é®IDåæ®µ |
| | | public ClassA ClassA { get; set; } //注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //ä¸å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(NavigateType.OneToMany, nameof(ClassA.BIZ_U9_MISC_OUT_SNId))]//ClassA表ä¸çBIZ_U9_MISC_OUT_SNId |
| | | public List<ClassA> ClassAList { get; set; }//注æç¦æ¢æå¨èµå¼ï¼åªè½æ¯null |
| | | //å¤å¯¹å¤å¤é®å¯¼èª |
| | | [Navigate(typeof(MappingClass), nameof(MappingClass.BIZ_U9_MISC_OUT_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 |
| | | } |
| | |
| | | [DisplayName("åææ¹å¼(0Wholeæ´ååæ|1SideA/Aé¢åæ|2SideB/Bé¢åæ)")] |
| | | public int DLVY_MODE { get; set; } |
| | | /// <summary> |
| | | /// ç¶æ(0WaitCallå¾
嫿|1WaitPickå¾
æ¡æ|2Pickingæ¡æä¸|3WaitSendå¾
åæ|4Sendedå·²åæ|5Closeå·²å
³é|6Cancelä½åº) |
| | | /// ç¶æ(0Initåå§å|1Called已嫿|2WaitPickå¾
æ¡æ|3Pickingæ¡æä¸|4Pickedå·²æ¡å®|5Sendedå·²åæ|6Closeå·²å
³é|7Cancelä½åº) |
| | | /// </summary> |
| | | [DisplayName("ç¶æ(0WaitCallå¾
嫿|1WaitPickå¾
æ¡æ|2Pickingæ¡æä¸|3WaitSendå¾
åæ|4Sendedå·²åæ|5Closeå·²å
³é|6Cancelä½åº)")] |
| | | [DisplayName("ç¶æ(0Initåå§å|1Called已嫿|2WaitPickå¾
æ¡æ|3Pickingæ¡æä¸|4Pickedå·²æ¡å®|5Sendedå·²åæ|6Closeå·²å
³é|7Cancelä½åº)")] |
| | | public int STATUS { get; set; } |
| | | /// <summary> |
| | | /// æ¥æºåæ®ç¼ç ï¼å¤ä¸ªç¨â'âåé |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æä¸¾ï¼ç¶æ(0WaitCallå¾
嫿|1WaitPickå¾
æ¡æ|2Pickingæ¡æä¸|3WaitSendå¾
åæ|4Sendedå·²åæ|5Closeå·²å
³é|6Cancelä½åº) |
| | | /// æä¸¾ï¼ç¶æ(0Initåå§å|1Called已嫿|2WaitPickå¾
æ¡æ|3Pickingæ¡æä¸|4Pickedå·²æ¡å®|5Sendedå·²åæ|6Closeå·²å
³é|7Cancelä½åº) |
| | | /// </summary> |
| | | public enum STATUSs |
| | | { |
| | | [Description("å¾
嫿")] |
| | | WaitCall = 0, |
| | | [Description("åå§å")] |
| | | Init = 0, |
| | | [Description("已嫿")] |
| | | Called = 1, |
| | | [Description("å¾
æ¡æ")] |
| | | WaitPick = 1, |
| | | WaitPick = 2, |
| | | [Description("æ¡æä¸")] |
| | | Picking = 2, |
| | | [Description("å¾
åæ")] |
| | | WaitSend = 3, |
| | | Picking = 3, |
| | | [Description("å·²æ¡å®")] |
| | | Picked = 4, |
| | | [Description("å·²åæ")] |
| | | Sended = 4, |
| | | Sended = 5, |
| | | [Description("å·²å
³é")] |
| | | Close = 5, |
| | | Close = 6, |
| | | [Description("ä½åº")] |
| | | Cancel = 6, |
| | | Cancel = 7, |
| | | } |
| | | #endregion |
| | | |