StandardPda/MES.Service/Dto/service/RkDaa002.cs
@@ -25,6 +25,5 @@ [SugarColumn(ColumnName = "ITEM_NAME")] public string? ItemName { get; set; } [SugarColumn(ColumnName = "DAA020")] public string? Daa020 { get; set; } [SugarColumn(ColumnName = "DAA020")] public string? Daa020 { get; set; } } StandardPda/MES.Service/Dto/service/XJPageResult.cs
@@ -8,8 +8,9 @@ public string? result { get; set; } public string? id { get; set; } /// <summary> /// æç´¢æ¡ä»¶ï¼æ ¹æ®æ¤æ¡ä»¶çéä¾åºå ç©æç¼ç ç©æå称çæ°æ® /// æç´¢æ¡ä»¶ï¼æ ¹æ®æ¤æ¡ä»¶çéä¾åºå ç©æç¼ç ç©æå称çæ°æ® /// </summary> public string? SearchValue { get; set; } } StandardPda/MES.Service/Dto/webApi/ErpRohinData.cs
@@ -33,6 +33,6 @@ public string? FCHECKRETQTY { get; set; } //æ¶æå¯éæ° public string? FSTOCKRETQTY { get; set; } //åºåå¯éæ° public string? FEntryNote { get; set; } public string? FDeliveryDate { get; set; } } StandardPda/MES.Service/Dto/webApi/ErpStaff.cs
@@ -2,16 +2,16 @@ public class ErpStaff { public string? Id{ get; set; } public string? Type{ get; set; } public string? FStaffNumber{ get; set; } public string? FName{ get; set; } public string? FPostId{ get; set; } public string? KeyPosts{ get; set; } public string? FStaffStartDate{ get; set; } public string? SeparationTime{ get; set; } public string? FforbidStatus{ get; set; } public string? DepartmentName{ get; set; } public string? FUseOrgId{ get; set; } public string? Remark{ get; set; } public string? Id { get; set; } public string? Type { get; set; } public string? FStaffNumber { get; set; } public string? FName { get; set; } public string? FPostId { get; set; } public string? KeyPosts { get; set; } public string? FStaffStartDate { get; set; } public string? SeparationTime { get; set; } public string? FforbidStatus { get; set; } public string? DepartmentName { get; set; } public string? FUseOrgId { get; set; } public string? Remark { get; set; } } StandardPda/MES.Service/Modes/IqcBefore.cs
@@ -1,33 +1,34 @@  using SqlSugar; namespace MES.Service.Modes using SqlSugar; namespace MES.Service.Modes; /// <summary> /// ç¨æ·å¯¹åºçç©ææ£éªè¡¨ /// </summary> [SugarTable("IQC_BEFORE")] public class IqcBefore { /// <summary> /// ç¨æ·å¯¹åºçç©ææ£éªè¡¨ ///</summary> [SugarTable("IQC_BEFORE")] public class IqcBefore { /// <summary> /// SEQ_IQC_Before ///</summary> [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )] public decimal Id { get; set; } /// <summary> /// ç¨æ·id ///</summary> [SugarColumn(ColumnName="SID" )] public decimal Sid { get; set; } /// <summary> /// ç©æid ///</summary> [SugarColumn(ColumnName="ITEM_ID" )] public decimal ItemId { get; set; } /// SEQ_IQC_Before /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// PID ///</summary> [SugarColumn(ColumnName = "PID")] public decimal PID { get; set; } } } /// <summary> /// ç¨æ·id /// </summary> [SugarColumn(ColumnName = "SID")] public decimal Sid { get; set; } /// <summary> /// ç©æid /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal ItemId { get; set; } /// <summary> /// PID /// </summary> [SugarColumn(ColumnName = "PID")] public decimal PID { get; set; } } StandardPda/MES.Service/Modes/IqcBeforeFrom.cs
@@ -1,53 +1,52 @@ using SqlSugar; namespace MES.Service.Modes namespace MES.Service.Modes; /// <summary> /// ç¨æ·å¯¹åºçç©ææ£éªä¸»è¡¨ /// </summary> [SugarTable("IQC_BEFORE_FROM")] public class IqcBeforeFrom { /// <summary> /// ç¨æ·å¯¹åºçç©ææ£éªä¸»è¡¨ ///</summary> [SugarTable("IQC_BEFORE_FROM")] public class IqcBeforeFrom { /// <summary> /// SEQ_IQC_Before ///</summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// SEQ_IQC_Before /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// ç¨æ·id ///</summary> [SugarColumn(ColumnName = "SID")] public decimal? Sid { get; set; } /// <summary> /// ç¨æ·id /// </summary> [SugarColumn(ColumnName = "SID")] public decimal? Sid { get; set; } /// <summary> /// ç¨æ·å ///</summary> [SugarColumn(ColumnName = "USER_NAME")] public string? UserName { get; set; } /// <summary> /// ç¨æ·å /// </summary> [SugarColumn(ColumnName = "USER_NAME")] public string? UserName { get; set; } /// <summary> /// ç»ç»id ///</summary> [SugarColumn(ColumnName = "ORGANIZE_ID")] public string? OrganizeId { get; set; } /// <summary> /// ç»ç»id /// </summary> [SugarColumn(ColumnName = "ORGANIZE_ID")] public string? OrganizeId { get; set; } /// <summary> /// å®¡æ ¸äºº ///</summary> [SugarColumn(ColumnName = "CHECK_USER")] public string? CheckUser { get; set; } /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "CHECK_USER")] public string? CheckUser { get; set; } /// <summary> /// å®¡æ ¸æ¶é´ ///</summary> [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// <summary> /// å®¡æ ¸æ¶é´ /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// <summary> /// å®¡æ ¸ç¶æ(é»è®¤å¼ï¼0) ///</summary> [SugarColumn(ColumnName = "STATUS")] public short? Status { get; set; } } /// <summary> /// å®¡æ ¸ç¶æ(é»è®¤å¼ï¼0) /// </summary> [SugarColumn(ColumnName = "STATUS")] public short? Status { get; set; } } StandardPda/MES.Service/Modes/LtsLlj.cs
@@ -169,19 +169,24 @@ /// </summary> [SugarColumn(ColumnName = "F_TYPE")] public int Ftype { get; set; } [SugarColumn(IsIgnore = true)] public string? UserName { get; set; } /// <summary> /// ç©ææ è¯ï¼0ï¼éé¦æ¬¡ã1ï¼é¦æ¬¡ï¼ /// </summary> [SugarColumn(IsIgnore = true)] public int? FIRST { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(IsIgnore = true)] public string? CreateUserName { get; set; } /// <summary> /// ä¸æ¬¡ä¸è¯æè¿° /// ç©ææ è¯ï¼0ï¼éé¦æ¬¡ã1ï¼é¦æ¬¡ï¼ /// </summary> [SugarColumn(IsIgnore = true)] public string? NewFngDesc { get; set; } [SugarColumn(IsIgnore = true)] public int? FIRST { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(IsIgnore = true)] public string? CreateUserName { get; set; } /// <summary> /// ä¸æ¬¡ä¸è¯æè¿° /// </summary> [SugarColumn(IsIgnore = true)] public string? NewFngDesc { get; set; } } StandardPda/MES.Service/Modes/MesBarcodeType.cs
@@ -8,243 +8,243 @@ [SugarTable("MES_BARCODE_TYPE")] public class MesBarcodeType { /// <summary> /// æ¡ç ç±»åID(seq_me_id) /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// æ¡ç ç±»åID(seq_me_id) /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 使ç¨åºæ /// </summary> [SugarColumn(ColumnName = "USE_SITE")] /// <summary> /// 使ç¨åºæ /// </summary> [SugarColumn(ColumnName = "USE_SITE")] public string UseSite { get; set; } /// <summary> /// æ¡ç ç±»åå称 /// </summary> [SugarColumn(ColumnName = "BARCODE_TYPE_NAME")] /// <summary> /// æ¡ç ç±»åå称 /// </summary> [SugarColumn(ColumnName = "BARCODE_TYPE_NAME")] public string BarcodeTypeName { get; set; } /// <summary> /// ç å¶ /// </summary> [SugarColumn(ColumnName = "CODE")] /// <summary> /// ç å¶ /// </summary> [SugarColumn(ColumnName = "CODE")] public string Code { get; set; } /// <summary> /// æ¡ç 纸宽 /// </summary> [SugarColumn(ColumnName = "PAPER_WIDTH")] /// <summary> /// æ¡ç 纸宽 /// </summary> [SugarColumn(ColumnName = "PAPER_WIDTH")] public decimal? PaperWidth { get; set; } /// <summary> /// æ¡ç çº¸é« /// </summary> [SugarColumn(ColumnName = "PAPER_HEIGHT")] /// <summary> /// æ¡ç çº¸é« /// </summary> [SugarColumn(ColumnName = "PAPER_HEIGHT")] public decimal? PaperHeight { get; set; } /// <summary> /// æ¡ç å¼å§ä½ç½®X /// </summary> [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_X")] /// <summary> /// æ¡ç å¼å§ä½ç½®X /// </summary> [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_X")] public decimal? BarcodeBeginPositionX { get; set; } /// <summary> /// æ¡ç å¼å§ä½ç½®Y /// </summary> [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_Y")] /// <summary> /// æ¡ç å¼å§ä½ç½®Y /// </summary> [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_Y")] public decimal? BarcodeBeginPositionY { get; set; } /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¡ç ä¸ªæ° /// </summary> [SugarColumn(ColumnName = "PAPER_NUM")] /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¡ç ä¸ªæ° /// </summary> [SugarColumn(ColumnName = "PAPER_NUM")] public decimal? PaperNum { get; set; } /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¯è¡æ¡ç ä¸ªæ° /// </summary> [SugarColumn(ColumnName = "PAPER_ROW_NUM")] /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¯è¡æ¡ç ä¸ªæ° /// </summary> [SugarColumn(ColumnName = "PAPER_ROW_NUM")] public decimal? PaperRowNum { get; set; } /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¡ç åæ° /// </summary> [SugarColumn(ColumnName = "PAPER_COLUMN_NUM")] /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¡ç åæ° /// </summary> [SugarColumn(ColumnName = "PAPER_COLUMN_NUM")] public decimal? PaperColumnNum { get; set; } /// <summary> /// æ¡ç æµæ°´å·å¾ªç¯ç±»å(æ§å¶æ¡ç æµæ°´å·) /// </summary> [SugarColumn(ColumnName = "CYCLE_TYPE")] /// <summary> /// æ¡ç æµæ°´å·å¾ªç¯ç±»å(æ§å¶æ¡ç æµæ°´å·) /// </summary> [SugarColumn(ColumnName = "CYCLE_TYPE")] public string CycleType { get; set; } /// <summary> /// æ¯å¦ææ(0-æ æ,1-ææ) /// </summary> [SugarColumn(ColumnName = "AVAILABLE_FLAG")] /// <summary> /// æ¯å¦ææ(0-æ æ,1-ææ) /// </summary> [SugarColumn(ColumnName = "AVAILABLE_FLAG")] public decimal? AvailableFlag { get; set; } /// <summary> /// æ¡ç é«åº¦ /// </summary> [SugarColumn(ColumnName = "BARCODE_HEIGHT")] /// <summary> /// æ¡ç é«åº¦ /// </summary> [SugarColumn(ColumnName = "BARCODE_HEIGHT")] public decimal? BarcodeHeight { get; set; } /// <summary> /// æ¡ç åä½æ¹å /// </summary> [SugarColumn(ColumnName = "BARCODE_ORIENTATION")] /// <summary> /// æ¡ç åä½æ¹å /// </summary> [SugarColumn(ColumnName = "BARCODE_ORIENTATION")] public string BarcodeOrientation { get; set; } /// <summary> /// æ¡ç æå°æ³¨éè¡(1-æå°ï¼0-ä¸æå°) /// </summary> [SugarColumn(ColumnName = "BARCODE_INTERPRETATION")] /// <summary> /// æ¡ç æå°æ³¨éè¡(1-æå°ï¼0-ä¸æå°) /// </summary> [SugarColumn(ColumnName = "BARCODE_INTERPRETATION")] public decimal? BarcodeInterpretation { get; set; } /// <summary> /// æ¡ç æå°æ³¨éè¡æå¨æ¡ç ä¸æ¹(1-æå°å¨æ¡ç ä¸æ¹ï¼0-ä¸æå°å¨æ¡ç ä¸æ¹) /// </summary> [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ABOVE")] /// <summary> /// æ¡ç æå°æ³¨éè¡æå¨æ¡ç ä¸æ¹(1-æå°å¨æ¡ç ä¸æ¹ï¼0-ä¸æå°å¨æ¡ç ä¸æ¹) /// </summary> [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ABOVE")] public decimal? BarcodeInterpretationAbove { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// æ¡ç 宽度 /// </summary> [SugarColumn(ColumnName = "BARCODE_WIDTH")] /// <summary> /// æ¡ç 宽度 /// </summary> [SugarColumn(ColumnName = "BARCODE_WIDTH")] public decimal? BarcodeWidth { get; set; } /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]模åï¼çªæ¡ï¼å®½ /// </summary> [SugarColumn(ColumnName = "BY_W")] /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]模åï¼çªæ¡ï¼å®½ /// </summary> [SugarColumn(ColumnName = "BY_W")] public decimal? ByW { get; set; } /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]宽æ¡ä¸çªæ¡çæ¯ä¾ /// </summary> [SugarColumn(ColumnName = "BY_R")] /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]宽æ¡ä¸çªæ¡çæ¯ä¾ /// </summary> [SugarColumn(ColumnName = "BY_R")] public decimal? ByR { get; set; } /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]æ¡ç é«åº¦ /// </summary> [SugarColumn(ColumnName = "BY_H")] /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]æ¡ç é«åº¦ /// </summary> [SugarColumn(ColumnName = "BY_H")] public decimal? ByH { get; set; } /// <summary> /// ç¹æ°/毫米 /// </summary> [SugarColumn(ColumnName = "JM")] /// <summary> /// ç¹æ°/毫米 /// </summary> [SugarColumn(ColumnName = "JM")] public string Jm { get; set; } /// <summary> /// èææ°æ®æ å¿(1-æ¯ï¼0ï¼å¦) /// </summary> [SugarColumn(ColumnName = "JVM_DATA_FLAG")] /// <summary> /// èææ°æ®æ å¿(1-æ¯ï¼0ï¼å¦) /// </summary> [SugarColumn(ColumnName = "JVM_DATA_FLAG")] public decimal? JvmDataFlag { get; set; } /// <summary> /// èææ°æ®æµæ°´å·ä½æ° /// </summary> [SugarColumn(ColumnName = "JVM_SERIAL_DIGIT")] /// <summary> /// èææ°æ®æµæ°´å·ä½æ° /// </summary> [SugarColumn(ColumnName = "JVM_SERIAL_DIGIT")] public decimal? JvmSerialDigit { get; set; } /// <summary> /// èææ°æ®æ¡ç é¿åº¦ /// </summary> [SugarColumn(ColumnName = "JVM_BARCODE_LENGTH")] /// <summary> /// èææ°æ®æ¡ç é¿åº¦ /// </summary> [SugarColumn(ColumnName = "JVM_BARCODE_LENGTH")] public decimal? JvmBarcodeLength { get; set; } /// <summary> /// æå°å½ä»¤ /// </summary> [SugarColumn(ColumnName = "PRINT_COMMAND")] /// <summary> /// æå°å½ä»¤ /// </summary> [SugarColumn(ColumnName = "PRINT_COMMAND")] public string PrintCommand { get; set; } /// <summary> /// æå°å½ä»¤å¼å§ /// </summary> [SugarColumn(ColumnName = "PRINT_COMMAND_BEGIN")] /// <summary> /// æå°å½ä»¤å¼å§ /// </summary> [SugarColumn(ColumnName = "PRINT_COMMAND_BEGIN")] public string PrintCommandBegin { get; set; } /// <summary> /// æå°å½ä»¤ç»æ /// </summary> [SugarColumn(ColumnName = "PRINT_COMMAND_END")] /// <summary> /// æå°å½ä»¤ç»æ /// </summary> [SugarColumn(ColumnName = "PRINT_COMMAND_END")] public string PrintCommandEnd { get; set; } /// <summary> /// æ¡ç 注éè¡æ° /// </summary> [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ROW")] /// <summary> /// æ¡ç 注éè¡æ° /// </summary> [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ROW")] public decimal? BarcodeInterpretationRow { get; set; } /// <summary> /// æ¡ç å¼å¸¦ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "BARCODE_ITEM")] /// <summary> /// æ¡ç å¼å¸¦ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "BARCODE_ITEM")] public decimal? BarcodeItem { get; set; } /// <summary> /// æ¡ç ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TYPE_CODE")] /// <summary> /// æ¡ç ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TYPE_CODE")] public decimal TypeCode { get; set; } /// <summary> /// æ¯å¦ä½¿ç¨ /// </summary> [SugarColumn(ColumnName = "ISUSED")] /// <summary> /// æ¯å¦ä½¿ç¨ /// </summary> [SugarColumn(ColumnName = "ISUSED")] public short? Isused { get; set; } /// <summary> /// æå°æ¨¡æ¿ /// </summary> [SugarColumn(ColumnName = "MBTYPE")] /// <summary> /// æå°æ¨¡æ¿ /// </summary> [SugarColumn(ColumnName = "MBTYPE")] public decimal? Mbtype { get; set; } /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// æµæ°´å·ä½æ° /// </summary> [SugarColumn(ColumnName = "ORDER_NUM")] /// <summary> /// æµæ°´å·ä½æ° /// </summary> [SugarColumn(ColumnName = "ORDER_NUM")] public decimal? OrderNum { get; set; } } StandardPda/MES.Service/Modes/MesDepTaskInfo.cs
@@ -8,339 +8,339 @@ [SugarTable("MES_DEP_TASK_INFO")] public class MesDepTaskInfo { /// <summary> /// é¨é¨ç产订åID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// é¨é¨ç产订åID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 订åç¼å· /// </summary> [SugarColumn(ColumnName = "TASK_NO")] /// <summary> /// 订åç¼å· /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// ERPç©æç¼å· /// </summary> [SugarColumn(ColumnName = "ERP_ITEM_NO")] /// <summary> /// ERPç©æç¼å· /// </summary> [SugarColumn(ColumnName = "ERP_ITEM_NO")] public string ErpItemNo { get; set; } /// <summary> /// å·¥åæ°é /// </summary> [SugarColumn(ColumnName = "PLAN_QTY")] /// <summary> /// å·¥åæ°é /// </summary> [SugarColumn(ColumnName = "PLAN_QTY")] public decimal? PlanQty { get; set; } /// <summary> /// å·²ç产é /// </summary> [SugarColumn(ColumnName = "COMPLETE_QTY")] /// <summary> /// å·²ç产é /// </summary> [SugarColumn(ColumnName = "COMPLETE_QTY")] public decimal? CompleteQty { get; set; } /// <summary> /// å¤ææ°é /// </summary> [SugarColumn(ColumnName = "BACKUP_QTY")] /// <summary> /// å¤ææ°é /// </summary> [SugarColumn(ColumnName = "BACKUP_QTY")] public decimal? BackupQty { get; set; } /// <summary> /// ä¸è½½æ¶é´ /// </summary> [SugarColumn(ColumnName = "DOWN_TIME")] /// <summary> /// ä¸è½½æ¶é´ /// </summary> [SugarColumn(ColumnName = "DOWN_TIME")] public DateTime? DownTime { get; set; } /// <summary> /// 计åå¼å§æ¶é´ /// </summary> [SugarColumn(ColumnName = "PLAN_BEGIN_TIME")] /// <summary> /// 计åå¼å§æ¶é´ /// </summary> [SugarColumn(ColumnName = "PLAN_BEGIN_TIME")] public DateTime? PlanBeginTime { get; set; } /// <summary> /// 计åç»ææ¶é´ /// </summary> [SugarColumn(ColumnName = "PLAN_FINISH_TIME")] /// <summary> /// 计åç»ææ¶é´ /// </summary> [SugarColumn(ColumnName = "PLAN_FINISH_TIME")] public DateTime? PlanFinishTime { get; set; } /// <summary> /// å®é å®å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "REAL_FINISH_TIME")] /// <summary> /// å®é å®å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "REAL_FINISH_TIME")] public DateTime? RealFinishTime { get; set; } /// <summary> /// ç产ç¶æ(å¾ äº§\ç产\æèµ·\å®å·¥) /// </summary> [SugarColumn(ColumnName = "PRODUCE_STATE")] /// <summary> /// ç产ç¶æ(å¾ äº§\ç产\æèµ·\å®å·¥) /// </summary> [SugarColumn(ColumnName = "PRODUCE_STATE")] public string ProduceState { get; set; } /// <summary> /// å®é å¼å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "REAL_BEGIN_TIME")] /// <summary> /// å®é å¼å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "REAL_BEGIN_TIME")] public DateTime? RealBeginTime { get; set; } /// <summary> /// æ¯å¦æèµ· /// </summary> [SugarColumn(ColumnName = "HANG_UP")] /// <summary> /// æ¯å¦æèµ· /// </summary> [SugarColumn(ColumnName = "HANG_UP")] public string HangUp { get; set; } /// <summary> /// ä»åºç¼å· /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] /// <summary> /// ä»åºç¼å· /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// æ¥åºæ°é /// </summary> [SugarColumn(ColumnName = "DISCARD_QTY")] /// <summary> /// æ¥åºæ°é /// </summary> [SugarColumn(ColumnName = "DISCARD_QTY")] public decimal? DiscardQty { get; set; } /// <summary> /// å§æ¶ææ¶é´ /// </summary> [SugarColumn(ColumnName = "FIRST_ITEM_RECEIPT_TIME")] /// <summary> /// å§æ¶ææ¶é´ /// </summary> [SugarColumn(ColumnName = "FIRST_ITEM_RECEIPT_TIME")] public DateTime? FirstItemReceiptTime { get; set; } /// <summary> /// å§é½ææ¶é´ /// </summary> [SugarColumn(ColumnName = "FIRST_ITEM_READY_TIME")] /// <summary> /// å§é½ææ¶é´ /// </summary> [SugarColumn(ColumnName = "FIRST_ITEM_READY_TIME")] public DateTime? FirstItemReadyTime { get; set; } /// <summary> /// 客æ·ç¼å· /// </summary> [SugarColumn(ColumnName = "CUST_NO")] /// <summary> /// 客æ·ç¼å· /// </summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// åºè´§å è£ æ¹å¼ /// </summary> [SugarColumn(ColumnName = "PACK_SHIP_TYPE")] /// <summary> /// åºè´§å è£ æ¹å¼ /// </summary> [SugarColumn(ColumnName = "PACK_SHIP_TYPE")] public string PackShipType { get; set; } /// <summary> /// å è£ æ³¨æäºé¡¹ /// </summary> [SugarColumn(ColumnName = "PACK_SHIP_MEMO")] /// <summary> /// å è£ æ³¨æäºé¡¹ /// </summary> [SugarColumn(ColumnName = "PACK_SHIP_MEMO")] public string PackShipMemo { get; set; } /// <summary> /// æ¯å¦å·²æ产 /// </summary> [SugarColumn(ColumnName = "ISSCHEME")] /// <summary> /// æ¯å¦å·²æ产 /// </summary> [SugarColumn(ColumnName = "ISSCHEME")] public short? Isscheme { get; set; } /// <summary> /// æ¡ç ç±»åID /// </summary> [SugarColumn(ColumnName = "BARCODE_TYPE_ID")] /// <summary> /// æ¡ç ç±»åID /// </summary> [SugarColumn(ColumnName = "BARCODE_TYPE_ID")] public decimal? BarcodeTypeId { get; set; } /// <summary> /// åå¸ç¶æ /// </summary> [SugarColumn(ColumnName = "ISSUE_STATUS")] /// <summary> /// åå¸ç¶æ /// </summary> [SugarColumn(ColumnName = "ISSUE_STATUS")] public short? IssueStatus { get; set; } /// <summary> /// ç¶æï¼0=æ产æªåå¸ã1=æ产已åå¸ã2=å·²é¢æã3=å·²ç产ã4=æåã8=å·²å®å·¥ã9=å¼å¸¸ï¼ /// </summary> [SugarColumn(ColumnName = "FLAG")] /// <summary> /// ç¶æï¼0=æ产æªåå¸ã1=æ产已åå¸ã2=å·²é¢æã3=å·²ç产ã4=æåã8=å·²å®å·¥ã9=å¼å¸¸ï¼ /// </summary> [SugarColumn(ColumnName = "FLAG")] public short? Flag { get; set; } /// <summary> /// é¢ææ¶é´ /// </summary> [SugarColumn(ColumnName = "MAT_DATE")] /// <summary> /// é¢ææ¶é´ /// </summary> [SugarColumn(ColumnName = "MAT_DATE")] public DateTime? MatDate { get; set; } /// <summary> /// å·¥ä½ä¸å¿ /// </summary> [SugarColumn(ColumnName = "WORKCENTER_NO")] /// <summary> /// å·¥ä½ä¸å¿ /// </summary> [SugarColumn(ColumnName = "WORKCENTER_NO")] public string WorkcenterNo { get; set; } /// <summary> /// å·²ä¸è½½è®¢åæ è¯Y-å·²ä¸è½½,N-æªä¸è½½ /// </summary> [SugarColumn(ColumnName = "DOWN_FLAG")] /// <summary> /// å·²ä¸è½½è®¢åæ è¯Y-å·²ä¸è½½,N-æªä¸è½½ /// </summary> [SugarColumn(ColumnName = "DOWN_FLAG")] public short? DownFlag { get; set; } /// <summary> /// ç¯ä¿ä»£ç /// </summary> [SugarColumn(ColumnName = "ROHSE_CODE")] /// <summary> /// ç¯ä¿ä»£ç /// </summary> [SugarColumn(ColumnName = "ROHSE_CODE")] public string RohseCode { get; set; } /// <summary> /// 客æ·PO /// </summary> [SugarColumn(ColumnName = "CUST_PO")] /// <summary> /// 客æ·PO /// </summary> [SugarColumn(ColumnName = "CUST_PO")] public string CustPo { get; set; } /// <summary> /// 客æ·åå· /// </summary> [SugarColumn(ColumnName = "CUST_STYLE")] /// <summary> /// 客æ·åå· /// </summary> [SugarColumn(ColumnName = "CUST_STYLE")] public string CustStyle { get; set; } /// <summary> /// 产åæå°åºå®å¼ /// </summary> [SugarColumn(ColumnName = "PROC_PRINT_VALUE")] /// <summary> /// 产åæå°åºå®å¼ /// </summary> [SugarColumn(ColumnName = "PROC_PRINT_VALUE")] public string ProcPrintValue { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// æ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "MEMO")] /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "MEMO")] public string Memo { get; set; } /// <summary> /// 审æ¹ç¶æ /// </summary> [SugarColumn(ColumnName = "FCHECK_STATUS")] /// <summary> /// 审æ¹ç¶æ /// </summary> [SugarColumn(ColumnName = "FCHECK_STATUS")] public string FcheckStatus { get; set; } /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } /// <summary> /// å·¥å /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// å·¥å /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// å ¬å¸ /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// æ°æ®æ¥æº /// </summary> [SugarColumn(ColumnName = "DATA_FROM")] /// <summary> /// æ°æ®æ¥æº /// </summary> [SugarColumn(ColumnName = "DATA_FROM")] public string DataFrom { get; set; } /// <summary> /// ç产订å表头ID /// </summary> [SugarColumn(ColumnName = "MOID")] /// <summary> /// ç产订å表头ID /// </summary> [SugarColumn(ColumnName = "MOID")] public decimal? Moid { get; set; } /// <summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "PARTID")] /// <summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "PARTID")] public decimal? Partid { get; set; } /// <summary> /// ERPå·¥åç¶æ ç¶æï¼NA-å¼ç«/FM-éå®/OP-å®¡æ ¸/CL-å ³éï¼ /// </summary> [SugarColumn(ColumnName = "STATUS")] /// <summary> /// ERPå·¥åç¶æ ç¶æï¼NA-å¼ç«/FM-éå®/OP-å®¡æ ¸/CL-å ³éï¼ /// </summary> [SugarColumn(ColumnName = "STATUS")] public string Status { get; set; } /// <summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "MOCODE")] /// <summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "MOCODE")] public string Mocode { get; set; } /// <summary> /// å建æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATEDATE")] /// <summary> /// å建æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATEDATE")] public DateTime? Createdate { get; set; } /// <summary> /// é¢è² /// </summary> [SugarColumn(ColumnName = "COLOR_NAME")] /// <summary> /// é¢è² /// </summary> [SugarColumn(ColumnName = "COLOR_NAME")] public string ColorName { get; set; } /// <summary> /// å ³éæ¶é´ /// </summary> [SugarColumn(ColumnName = "CLOSETIME")] /// <summary> /// å ³éæ¶é´ /// </summary> [SugarColumn(ColumnName = "CLOSETIME")] public DateTime? Closetime { get; set; } /// <summary> /// ç©æç¼å· /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// ç©æç¼å· /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// ä»è¡¨ID /// </summary> [SugarColumn(ColumnName = "MODID")] /// <summary> /// ä»è¡¨ID /// </summary> [SugarColumn(ColumnName = "MODID")] public decimal? Modid { get; set; } /// <summary> /// ææ°ä¸è½½æ´æ°æ è¯ /// </summary> [SugarColumn(ColumnName = "UPDATE_FLG")] /// <summary> /// ææ°ä¸è½½æ´æ°æ è¯ /// </summary> [SugarColumn(ColumnName = "UPDATE_FLG")] public decimal? UpdateFlg { get; set; } /// <summary> /// ç产工åè¡å· /// </summary> [SugarColumn(ColumnName = "MOCODE_LINE")] /// <summary> /// ç产工åè¡å· /// </summary> [SugarColumn(ColumnName = "MOCODE_LINE")] public decimal? MocodeLine { get; set; } /// <summary> /// ä¸å°æ»æ° /// </summary> [SugarColumn(ColumnName = "SILK_QTY")] /// <summary> /// ä¸å°æ»æ° /// </summary> [SugarColumn(ColumnName = "SILK_QTY")] public decimal? SilkQty { get; set; } /// <summary> /// ä¸å°åä»· /// </summary> [SugarColumn(ColumnName = "SILK_PRICE")] /// <summary> /// ä¸å°åä»· /// </summary> [SugarColumn(ColumnName = "SILK_PRICE")] public decimal? SilkPrice { get; set; } /// <summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] /// <summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } } StandardPda/MES.Service/Modes/MesDeptUser.cs
@@ -1,80 +1,75 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; using SqlSugar; namespace MES.Service.Modes namespace MES.Service.Modes; /// <summary> /// </summary> [SugarTable("MES_DEPT_USER")] public class MesDeptUser { /// <summary> /// ///</summary> [SugarTable("MES_DEPT_USER")] public class MesDeptUser { /// <summary> /// SEQ_USER ///</summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// SEQ_USER /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// è½¦é´ ///</summary> [SugarColumn(ColumnName = "WORKSHOP")] public string Workshop { get; set; } /// <summary> /// è½¦é´ /// </summary> [SugarColumn(ColumnName = "WORKSHOP")] public string Workshop { get; set; } /// <summary> /// ç¼ç ///</summary> [SugarColumn(ColumnName = "CODE")] public string Code { get; set; } /// <summary> /// ç¼ç /// </summary> [SugarColumn(ColumnName = "CODE")] public string Code { get; set; } /// <summary> /// ç¨æ· ///</summary> [SugarColumn(ColumnName = "USER_NO")] public string UserNo { get; set; } /// <summary> /// ç¨æ· /// </summary> [SugarColumn(ColumnName = "USER_NO")] public string UserNo { get; set; } /// <summary> /// å²ä½ ///</summary> [SugarColumn(ColumnName = "POST")] public string Post { get; set; } /// <summary> /// å²ä½ /// </summary> [SugarColumn(ColumnName = "POST")] public string Post { get; set; } /// <summary> /// çµè¯ ///</summary> [SugarColumn(ColumnName = "PHONE")] public string Phone { get; set; } /// <summary> /// çµè¯ /// </summary> [SugarColumn(ColumnName = "PHONE")] public string Phone { get; set; } /// <summary> /// æ¯å¦ç¦»è ///</summary> [SugarColumn(ColumnName = "IS_DEPARTURE")] public short? IsDeparture { get; set; } /// <summary> /// æ¯å¦ç¦»è /// </summary> [SugarColumn(ColumnName = "IS_DEPARTURE")] public short? IsDeparture { get; set; } /// <summary> /// 0æªå®¡æ ¸ 1å®¡æ ¸ ///</summary> [SugarColumn(ColumnName = "STATUS")] public decimal? Status { get; set; } /// <summary> /// 0æªå®¡æ ¸ 1å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "STATUS")] public decimal? Status { get; set; } /// <summary> /// å®¡æ ¸äºº ///</summary> [SugarColumn(ColumnName = "ISSUED_BY")] public string IssuedBy { get; set; } /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "ISSUED_BY")] public string IssuedBy { get; set; } /// <summary> /// å®¡æ ¸æ¶é´ ///</summary> [SugarColumn(ColumnName = "ISSUED_DATE")] public DateTime? IssuedDate { get; set; } /// <summary> /// å®¡æ ¸æ¶é´ /// </summary> [SugarColumn(ColumnName = "ISSUED_DATE")] public DateTime? IssuedDate { get; set; } /// <summary> /// ç¨æ·å ///</summary> [SugarColumn(ColumnName = "USER_NAME")] public string UserName { get; set; } } /// <summary> /// ç¨æ·å /// </summary> [SugarColumn(ColumnName = "USER_NAME")] public string UserName { get; set; } } StandardPda/MES.Service/Modes/MesInvItemArn.cs
@@ -8,232 +8,232 @@ [SugarTable("MES_INV_ITEM_ARN")] public class MesInvItemArn { /// <summary> /// ID(SEQ_INV_ID) /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// ID(SEQ_INV_ID) /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// ç¶æ|0-æªå®¡æ ¸1-å®¡æ ¸å ¥åº\ç»æ¡ /// </summary> [SugarColumn(ColumnName = "STATUS")] /// <summary> /// ç¶æ|0-æªå®¡æ ¸1-å®¡æ ¸å ¥åº\ç»æ¡ /// </summary> [SugarColumn(ColumnName = "STATUS")] public short? Status { get; set; } /// <summary> /// åå /// </summary> [SugarColumn(ColumnName = "REASON")] /// <summary> /// åå /// </summary> [SugarColumn(ColumnName = "REASON")] public string Reason { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// åæ®ç±»åID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] /// <summary> /// åæ®ç±»åID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } /// <summary> /// äºå¡ç±»åID /// </summary> [SugarColumn(ColumnName = "TRANSACTION_ID")] /// <summary> /// äºå¡ç±»åID /// </summary> [SugarColumn(ColumnName = "TRANSACTION_ID")] public decimal? TransactionId { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARK")] /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// éè´§åå· /// </summary> [SugarColumn(ColumnName = "PAPER_BILL_NO")] /// <summary> /// éè´§åå· /// </summary> [SugarColumn(ColumnName = "PAPER_BILL_NO")] public string PaperBillNo { get; set; } /// <summary> /// éæäººå·¥å· /// </summary> [SugarColumn(ColumnName = "USER_NO_BACK")] /// <summary> /// éæäººå·¥å· /// </summary> [SugarColumn(ColumnName = "USER_NO_BACK")] public string UserNoBack { get; set; } /// <summary> /// æ交人 /// </summary> [SugarColumn(ColumnName = "CHECK_USER")] /// <summary> /// æ交人 /// </summary> [SugarColumn(ColumnName = "CHECK_USER")] public string CheckUser { get; set; } /// <summary> /// æ交æ¥æ /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] /// <summary> /// æ交æ¥æ /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// <summary> /// å ¥åºæ¥æ /// </summary> [SugarColumn(ColumnName = "INS_DATE")] /// <summary> /// å ¥åºæ¥æ /// </summary> [SugarColumn(ColumnName = "INS_DATE")] public DateTime? InsDate { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "CHECK_RES")] /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "CHECK_RES")] public string CheckRes { get; set; } /// <summary> /// å·²æ¡æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] /// <summary> /// å·²æ¡æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] public decimal? CheckQty { get; set; } /// <summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] /// <summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] public string DepotsCode { get; set; } /// <summary> /// äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSCTION_NO")] /// <summary> /// äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSCTION_NO")] public string TransctionNo { get; set; } /// <summary> /// ä¾åºåç¼ç /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// ä¾åºåç¼ç /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// æ交ç¶æ /// </summary> [SugarColumn(ColumnName = "FSTATUS")] /// <summary> /// æ交ç¶æ /// </summary> [SugarColumn(ColumnName = "FSTATUS")] public short? Fstatus { get; set; } /// <summary> /// å·¥åç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// å·¥åç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// æ¯å¦å·²ååSAP /// </summary> [SugarColumn(ColumnName = "SAPSTATUS")] /// <summary> /// æ¯å¦å·²ååSAP /// </summary> [SugarColumn(ColumnName = "SAPSTATUS")] public short? Sapstatus { get; set; } /// <summary> /// ç¡®è®¤å ¥åºæ¥æ /// </summary> [SugarColumn(ColumnName = "INS_DATE")] /// <summary> /// ç¡®è®¤å ¥åºæ¥æ /// </summary> [SugarColumn(ColumnName = "INS_DATE")] public DateTime? Insdate { get; set; } /// <summary> /// æ¯å¦æ£éª /// </summary> [SugarColumn(ColumnName = "ISCHECK")] /// <summary> /// æ¯å¦æ£éª /// </summary> [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } /// <summary> /// å®¡æ ¸å ¥åºäºº /// </summary> [SugarColumn(ColumnName = "INSBY")] /// <summary> /// å®¡æ ¸å ¥åºäºº /// </summary> [SugarColumn(ColumnName = "INSBY")] public string Insby { get; set; } /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// æ¥ææ è¯ /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] /// <summary> /// æ¥ææ è¯ /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] public short? UrgentFlag { get; set; } /// <summary> /// å²éäºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "MTTRANSCTION_NO")] /// <summary> /// å²éäºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "MTTRANSCTION_NO")] public decimal? MttransctionNo { get; set; } /// <summary> /// IQCæ£éªåå· /// </summary> [SugarColumn(ColumnName = "IQC_RELEASE_NO")] /// <summary> /// IQCæ£éªåå· /// </summary> [SugarColumn(ColumnName = "IQC_RELEASE_NO")] public string IqcReleaseNo { get; set; } /// <summary> /// æ¯å¦æ¾ç¤º /// </summary> [SugarColumn(ColumnName = "IS_VISUAL")] /// <summary> /// æ¯å¦æ¾ç¤º /// </summary> [SugarColumn(ColumnName = "IS_VISUAL")] public decimal? IsVisual { get; set; } /// <summary> /// 0=éè´ï¼1=å§å¤ /// </summary> [SugarColumn(ColumnName = "F_TYPE")] /// <summary> /// 0=éè´ï¼1=å§å¤ /// </summary> [SugarColumn(ColumnName = "F_TYPE")] public decimal? FType { get; set; } /// <summary> /// ERPå°è´§åID /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] /// <summary> /// ERPå°è´§åID /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] public string EbelnK3id { get; set; } /// <summary> /// æ¡ç æ¡å°è¿åº¦ /// </summary> [SugarColumn(ColumnName = "BARCODE_RATIO")] /// <summary> /// æ¡ç æ¡å°è¿åº¦ /// </summary> [SugarColumn(ColumnName = "BARCODE_RATIO")] public decimal? BarcodeRatio { get; set; } /// <summary> /// ERPåå· /// </summary> [SugarColumn(ColumnName = "ERPNO")] /// <summary> /// ERPåå· /// </summary> [SugarColumn(ColumnName = "ERPNO")] public string Erpno { get; set; } /// <summary> /// æ¯å¦å·²éè´§0-æªéè´§ï¼1-éè´§ /// </summary> [SugarColumn(ColumnName = "THSTATUS")] /// <summary> /// æ¯å¦å·²éè´§0-æªéè´§ï¼1-éè´§ /// </summary> [SugarColumn(ColumnName = "THSTATUS")] public short? Thstatus { get; set; } /// <summary> /// ERPéè´§åå· /// </summary> [SugarColumn(ColumnName = "ERPTHNO")] /// <summary> /// ERPéè´§åå· /// </summary> [SugarColumn(ColumnName = "ERPTHNO")] public string Erpthno { get; set; }
@@ -1,368 +1,364 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; using SqlSugar; namespace MES.Service.Modes namespace MES.Service.Modes; /// <summary> /// ç©ææåå ¥åºç³è¯·æ¡ç æç» /// </summary> [SugarTable("MES_INV_ITEM_IN_C_DETAILS2")] public class MesInvItemInCDetails2 { /// <summary> /// ç©ææåå ¥åºç³è¯·æ¡ç æç» ///</summary> [SugarTable("MES_INV_ITEM_IN_C_DETAILS2")] public class MesInvItemInCDetails2 { /// <summary> /// SEQ_OUT ///</summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// SEQ_OUT /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// å ¥åºåid ///</summary> [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] public decimal ItemInId { get; set; } /// <summary> /// å ¥åºåid /// </summary> [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] public decimal ItemInId { get; set; } /// <summary> /// ç©ææ¡ç PSN ///</summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// ç©ææ¡ç PSN /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// 客æ·ç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ ///</summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } /// <summary> /// 客æ·ç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } /// <summary> /// 客æ·ç©ææ¡ç ///</summary> [SugarColumn(ColumnName = "C_ITEM_BARCODE")] public string CItemBarcode { get; set; } /// <summary> /// 客æ·ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "C_ITEM_BARCODE")] public string CItemBarcode { get; set; } /// <summary> /// éªæ¶æ°é ///</summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// éªæ¶æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// å ¥åºæ¹å¼(1:ææ¡ç ,0:æ æ¡ç ) ///</summary> [SugarColumn(ColumnName = "BARCODE_FLAG")] public short? BarcodeFlag { get; set; } /// <summary> /// å ¥åºæ¹å¼(1:ææ¡ç ,0:æ æ¡ç ) /// </summary> [SugarColumn(ColumnName = "BARCODE_FLAG")] public short? BarcodeFlag { get; set; } /// <summary> /// ç¯ä¿æ å¿ï¼0-éç¯ä¿,1-ç¯ä¿.æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ ///</summary> [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } /// <summary> /// ç¯ä¿æ å¿ï¼0-éç¯ä¿,1-ç¯ä¿.æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } /// <summary> /// å建人 ///</summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ ///</summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº ///</summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ ///</summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// ä½ä¸æ¹å¼0-æ线æ¡ç æª1-æ 线æ¡ç æª ///</summary> [SugarColumn(ColumnName = "WORK_TYPE")] public decimal? WorkType { get; set; } /// <summary> /// ä½ä¸æ¹å¼0-æ线æ¡ç æª1-æ 线æ¡ç æª /// </summary> [SugarColumn(ColumnName = "WORK_TYPE")] public decimal? WorkType { get; set; } /// <summary> /// æ¬å¸ç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ ///</summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// æ¬å¸ç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// å家æ¹æ¬¡ ///</summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// å家æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ¯å¦å ±ç®¡ç©æ(0:å¦ï¼1:æ¯) ///</summary> [SugarColumn(ColumnName = "COMANAGEMENT_FLAG")] public short? ComanagementFlag { get; set; } /// <summary> /// æ¯å¦å ±ç®¡ç©æ(0:å¦ï¼1:æ¯) /// </summary> [SugarColumn(ColumnName = "COMANAGEMENT_FLAG")] public short? ComanagementFlag { get; set; } /// <summary> /// 客æ·ç¼ç ///</summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// 客æ·ç¼ç /// </summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// æ£éªç»æ ///</summary> [SugarColumn(ColumnName = "CHECK_RES")] public string CheckRes { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "CHECK_RES")] public string CheckRes { get; set; } /// <summary> /// è¿è´§æ°é ///</summary> [SugarColumn(ColumnName = "CHECK_QTY")] public decimal? CheckQty { get; set; } /// <summary> /// è¿è´§æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] public decimal? CheckQty { get; set; } /// <summary> /// æ£éªç¶æ ///</summary> [SugarColumn(ColumnName = "CHECK_STATES")] public string CheckStates { get; set; } /// <summary> /// æ£éªç¶æ /// </summary> [SugarColumn(ColumnName = "CHECK_STATES")] public string CheckStates { get; set; } /// <summary> /// 强å¶å ¥åºæ è®°0æ ï¼1-强å¶å ¥åº éæåä½¿ç¨ ///</summary> [SugarColumn(ColumnName = "FORCE_IN_FLAG")] public short? ForceInFlag { get; set; } /// <summary> /// 强å¶å ¥åºæ è®°0æ ï¼1-强å¶å ¥åº éæåä½¿ç¨ /// </summary> [SugarColumn(ColumnName = "FORCE_IN_FLAG")] public short? ForceInFlag { get; set; } /// <summary> /// ä»åºç¼ç ///</summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// è´§ä½ç¼ç ///</summary> [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] public string DepotSectionCode { get; set; } /// <summary> /// è´§ä½ç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] public string DepotSectionCode { get; set; } /// <summary> /// ç¹è®°äºé¡¹ ///</summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// ç¹è®°äºé¡¹ /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// ç©ææ¡ç ///</summary> [SugarColumn(ColumnName = "ITEM_BARCODE2")] public string ItemBarcode2 { get; set; } /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE2")] public string ItemBarcode2 { get; set; } /// <summary> /// æ°æ¡ç ///</summary> [SugarColumn(ColumnName = "ITEM_BARCODE3")] public string ItemBarcode3 { get; set; } /// <summary> /// æ°æ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE3")] public string ItemBarcode3 { get; set; } /// <summary> /// 使ç¨æ°é ///</summary> [SugarColumn(ColumnName = "USE_QTY")] public decimal? UseQty { get; set; } /// <summary> /// 使ç¨æ°é /// </summary> [SugarColumn(ColumnName = "USE_QTY")] public decimal? UseQty { get; set; } /// <summary> /// é¢ææ°é ///</summary> [SugarColumn(ColumnName = "OUT_QTY")] public decimal? OutQty { get; set; } /// <summary> /// é¢ææ°é /// </summary> [SugarColumn(ColumnName = "OUT_QTY")] public decimal? OutQty { get; set; } /// <summary> /// ç©æç®ç§° ///</summary> [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } /// <summary> /// ç©æç®ç§° /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } /// <summary> /// æ¡£ä½ä½å¼ ///</summary> [SugarColumn(ColumnName = "SPOSTION")] public decimal? Spostion { get; set; } /// <summary> /// æ¡£ä½ä½å¼ /// </summary> [SugarColumn(ColumnName = "SPOSTION")] public decimal? Spostion { get; set; } /// <summary> /// æ¡£ä½é«å¼ ///</summary> [SugarColumn(ColumnName = "EPOSTION")] public decimal? Epostion { get; set; } /// <summary> /// æ¡£ä½é«å¼ /// </summary> [SugarColumn(ColumnName = "EPOSTION")] public decimal? Epostion { get; set; } /// <summary> /// æ£éªæ¥æ ///</summary> [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// <summary> /// åä½ ///</summary> [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } /// <summary> /// æ¯å¦æ£éª ///</summary> [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } /// <summary> /// æ¯å¦æ£éª /// </summary> [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } /// <summary> /// éè´è®¢å ///</summary> [SugarColumn(ColumnName = "EBELN")] public string Ebeln { get; set; } /// <summary> /// éè´è®¢å /// </summary> [SugarColumn(ColumnName = "EBELN")] public string Ebeln { get; set; } /// <summary> /// ç产æ¥æ ///</summary> [SugarColumn(ColumnName = "LOT_DATE")] public string LotDate { get; set; } /// <summary> /// ç产æ¥æ /// </summary> [SugarColumn(ColumnName = "LOT_DATE")] public string LotDate { get; set; } /// <summary> /// å ¥åºåå· ///</summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// å ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// å ¥åºå®¡æ ¸æ å¿ ///</summary> [SugarColumn(ColumnName = "STOCK_OK")] public short? StockOk { get; set; } /// <summary> /// å ¥åºå®¡æ ¸æ å¿ /// </summary> [SugarColumn(ColumnName = "STOCK_OK")] public short? StockOk { get; set; } /// <summary> /// ååç¼ç ///</summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç ///</summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// å¡æ¿ç¼ç ///</summary> [SugarColumn(ColumnName = "CB_NO")] public string CbNo { get; set; } /// <summary> /// å¡æ¿ç¼ç /// </summary> [SugarColumn(ColumnName = "CB_NO")] public string CbNo { get; set; } /// <summary> /// ç®±å· ///</summary> [SugarColumn(ColumnName = "BOX_NO")] public string BoxNo { get; set; } /// <summary> /// ç®±å· /// </summary> [SugarColumn(ColumnName = "BOX_NO")] public string BoxNo { get; set; } /// <summary> /// ä»åºID ///</summary> [SugarColumn(ColumnName = "DEPOT_ID")] public decimal? DepotId { get; set; } /// <summary> /// ä»åºID /// </summary> [SugarColumn(ColumnName = "DEPOT_ID")] public decimal? DepotId { get; set; } /// <summary> /// è´§ä½ID ///</summary> [SugarColumn(ColumnName = "DEPOT_SECTION_ID")] public decimal? DepotSectionId { get; set; } /// <summary> /// è´§ä½ID /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_ID")] public decimal? DepotSectionId { get; set; } /// <summary> /// è¡å· ///</summary> [SugarColumn(ColumnName = "LINE_NUM")] public string LineNum { get; set; } /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "LINE_NUM")] public string LineNum { get; set; } /// <summary> /// æ«ç æ°é ///</summary> [SugarColumn(ColumnName = "SM_QTY")] public decimal? SmQty { get; set; } /// <summary> /// æ«ç æ°é /// </summary> [SugarColumn(ColumnName = "SM_QTY")] public decimal? SmQty { get; set; } /// <summary> /// éå®è®¢å ///</summary> [SugarColumn(ColumnName = "VGBEL")] public string Vgbel { get; set; } /// <summary> /// éå®è®¢å /// </summary> [SugarColumn(ColumnName = "VGBEL")] public string Vgbel { get; set; } /// <summary> /// éå®è®¢åè¡å· ///</summary> [SugarColumn(ColumnName = "KDPOS")] public decimal? Kdpos { get; set; } /// <summary> /// éå®è®¢åè¡å· /// </summary> [SugarColumn(ColumnName = "KDPOS")] public decimal? Kdpos { get; set; } /// <summary> /// ä»»å¡åå· ///</summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// è¡å· ///</summary> [SugarColumn(ColumnName = "EBELN_LINE_NO")] public decimal? EbelnLineNo { get; set; } /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "EBELN_LINE_NO")] public decimal? EbelnLineNo { get; set; } /// <summary> /// å°è´§åå· ///</summary> [SugarColumn(ColumnName = "CBILL_NO")] public string CbillNo { get; set; } /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "CBILL_NO")] public string CbillNo { get; set; } /// <summary> /// æ¥ææ è¯ ///</summary> [SugarColumn(ColumnName = "URGENT_FLAG")] public decimal? UrgentFlag { get; set; } /// <summary> /// æ¥ææ è¯ /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] public decimal? UrgentFlag { get; set; } /// <summary> /// 产ååå· ///</summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// ä»»å¡åè¡å· ///</summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ç产工å ///</summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// ä¾åºå ///</summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// ä»»å¡æ±æ¥å ///</summary> [SugarColumn(ColumnName = "RBILL_NO")] public string RbillNo { get; set; } /// <summary> /// ä»»å¡æ±æ¥å /// </summary> [SugarColumn(ColumnName = "RBILL_NO")] public string RbillNo { get; set; } /// <summary> /// ç©æID ///</summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } /// <summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } /// <summary> /// å·¥åæ¥å·¥ID (ç¨äºæ£éªåæ´æ°æ¥å·¥è¡¨ä¸çæ£éªç»æ) ///</summary> [SugarColumn(ColumnName = "MES_SCGD_GX_ID")] public decimal? MesScgdGxId { get; set; } } /// <summary> /// å·¥åæ¥å·¥ID (ç¨äºæ£éªåæ´æ°æ¥å·¥è¡¨ä¸çæ£éªç»æ) /// </summary> [SugarColumn(ColumnName = "MES_SCGD_GX_ID")] public decimal? MesScgdGxId { get; set; } } StandardPda/MES.Service/Modes/MesInvItemInCItems.cs
@@ -8,141 +8,141 @@ [SugarTable("MES_INV_ITEM_IN_C_ITEMS")] public class MesInvItemInCItems { /// <summary> /// SEQ_OUT /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// SEQ_OUT /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// å ¥åºåid /// </summary> [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] /// <summary> /// å ¥åºåid /// </summary> [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] public decimal ItemInId { get; set; } /// <summary> /// éªæ¶æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] /// <summary> /// éªæ¶æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] /// <summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// è´§ä½ç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] /// <summary> /// è´§ä½ç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] public string DepotSectionCode { get; set; } /// <summary> /// ç¹è®°äºé¡¹ /// </summary> [SugarColumn(ColumnName = "REMARK")] /// <summary> /// ç¹è®°äºé¡¹ /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// ç©æç®ç§° /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] /// <summary> /// ç©æç®ç§° /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "UNIT")] /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } /// <summary> /// éè´è®¢å /// </summary> [SugarColumn(ColumnName = "EBELN")] /// <summary> /// éè´è®¢å /// </summary> [SugarColumn(ColumnName = "EBELN")] public string Ebeln { get; set; } /// <summary> /// å ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// å ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "EBELN_LINE_NO")] /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "EBELN_LINE_NO")] public decimal? EbelnLineNo { get; set; } /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "CBILL_NO")] /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "CBILL_NO")] public string CbillNo { get; set; } /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] /// <summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } } StandardPda/MES.Service/Modes/MesInvItemIns.cs
@@ -16,302 +16,302 @@ public decimal Id { get; set; } /// <summary> /// å ¥åºåå· ///</summary> /// å ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// ç¶æ|0-æªå®¡æ ¸1-å®¡æ ¸å ¥åº\ç»æ¡ ///</summary> /// ç¶æ|0-æªå®¡æ ¸1-å®¡æ ¸å ¥åº\ç»æ¡ /// </summary> [SugarColumn(ColumnName = "STATUS")] public short? Status { get; set; } /// <summary> /// ä»åº ///</summary> /// ä»åº /// </summary> [SugarColumn(ColumnName = "DEPOTS_ID")] public decimal? DepotsId { get; set; } /// <summary> /// åå ///</summary> /// åå /// </summary> [SugarColumn(ColumnName = "REASON")] public string Reason { get; set; } /// <summary> /// å建人 ///</summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ ///</summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº ///</summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ ///</summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// åæ®ç±»åID ///</summary> /// åæ®ç±»åID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } /// <summary> /// äºå¡ç±»åID ///</summary> /// äºå¡ç±»åID /// </summary> [SugarColumn(ColumnName = "TRANSACTION_ID")] public decimal? TransactionId { get; set; } /// <summary> /// å¤æ³¨ ///</summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// éè´§åå· ///</summary> /// éè´§åå· /// </summary> [SugarColumn(ColumnName = "PAPER_BILL_NO")] public string PaperBillNo { get; set; } /// <summary> /// éæäººå·¥å· ///</summary> /// éæäººå·¥å· /// </summary> [SugarColumn(ColumnName = "USER_NO_BACK")] public string UserNoBack { get; set; } /// <summary> /// å®¡æ ¸äºº ///</summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "CHECK_USER")] public string CheckUser { get; set; } /// <summary> /// å®¡æ ¸æ¥æ ///</summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// <summary> /// ç产订åå· ///</summary> /// ç产订åå· /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// å ¥åºæ¥æ ///</summary> /// å ¥åºæ¥æ /// </summary> [SugarColumn(ColumnName = "INS_DATE")] public DateTime? InsDate { get; set; } /// <summary> /// æ£éªç»æ ///</summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "CHECK_RES")] public string CheckRes { get; set; } /// <summary> /// å·²æ¡æ°é ///</summary> /// å·²æ¡æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] public decimal? CheckQty { get; set; } /// <summary> /// é¢æ工段 ///</summary> /// é¢æ工段 /// </summary> [SugarColumn(ColumnName = "MMLIST")] public string Mmlist { get; set; } /// <summary> /// SAPéè´è®¢åå· ///</summary> /// SAPéè´è®¢åå· /// </summary> [SugarColumn(ColumnName = "EBELN")] public string Ebeln { get; set; } /// <summary> /// ä»åºç¼ç ///</summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] public string DepotsCode { get; set; } /// <summary> /// äºå¡ç±»åç¼ç ///</summary> /// äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSCTION_NO")] public string TransctionNo { get; set; } /// <summary> /// ä¾åºåç¼ç ///</summary> /// ä¾åºåç¼ç /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// å ¥åºç¶æ ///</summary> /// å ¥åºç¶æ /// </summary> [SugarColumn(ColumnName = "FSTATUS")] public short? Fstatus { get; set; } /// <summary> /// å·¥åç¼ç ///</summary> /// å·¥åç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// æ¯å¦å·²ååSAP ///</summary> /// æ¯å¦å·²ååSAP /// </summary> [SugarColumn(ColumnName = "SAPSTATUS")] public short? Sapstatus { get; set; } /// <summary> /// SAPè¿ååæ® ///</summary> /// SAPè¿ååæ® /// </summary> [SugarColumn(ColumnName = "SAPNO")] public string Sapno { get; set; } /// <summary> /// SAPè¿å年份 ///</summary> /// SAPè¿å年份 /// </summary> [SugarColumn(ColumnName = "SAPYEAR")] public short? Sapyear { get; set; } /// <summary> /// SAPè¿åä¿¡æ¯ ///</summary> /// SAPè¿åä¿¡æ¯ /// </summary> [SugarColumn(ColumnName = "SAPTEXT")] public string Saptext { get; set; } /// <summary> /// ç¡®è®¤å ¥åºæ¥æ ///</summary> /// ç¡®è®¤å ¥åºæ¥æ /// </summary> [SugarColumn(ColumnName = "INSDATE")] public DateTime? Insdate { get; set; } /// <summary> /// æ¯å¦æ£éª ///</summary> /// æ¯å¦æ£éª /// </summary> [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } /// <summary> /// å®¡æ ¸å ¥åºäºº ///</summary> /// å®¡æ ¸å ¥åºäºº /// </summary> [SugarColumn(ColumnName = "INSBY")] public string Insby { get; set; } /// <summary> /// æ¯å¦æ¾ç¤º ///</summary> /// æ¯å¦æ¾ç¤º /// </summary> [SugarColumn(ColumnName = "IS_VISUAL")] public decimal? IsVisual { get; set; } /// <summary> /// å ¬å¸ä»£ç ///</summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// æ¥ææ è¯ ///</summary> /// æ¥ææ è¯ /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] public short? UrgentFlag { get; set; } /// <summary> /// éè´åè¡å· ///</summary> /// éè´åè¡å· /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } /// <summary> /// å²éäºå¡ç±»åç¼ç ///</summary> /// å²éäºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "MTTRANSCTION_NO")] public decimal? MttransctionNo { get; set; } /// <summary> /// å·¥åè¡å· ///</summary> /// å·¥åè¡å· /// </summary> [SugarColumn(ColumnName = "TASK_LINO")] public string TaskLino { get; set; } /// <summary> /// ææéç¥ååå· ///</summary> /// ææéç¥ååå· /// </summary> [SugarColumn(ColumnName = "FBILLNO")] public string Fbillno { get; set; } /// <summary> /// ææåè¡å· ///</summary> /// ææåè¡å· /// </summary> [SugarColumn(ColumnName = "FBILL_LINO")] public string FbillLino { get; set; } /// <summary> /// 客æ·ç¼å· ///</summary> /// 客æ·ç¼å· /// </summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// 客æ·å称 ///</summary> /// 客æ·å称 /// </summary> [SugarColumn(ColumnName = "CUST_NAME")] public string CustName { get; set; } /// <summary> /// IQCæ£éªåå· ///</summary> /// IQCæ£éªåå· /// </summary> [SugarColumn(ColumnName = "IQC_RELEASE_NO")] public string IqcReleaseNo { get; set; } /// <summary> /// å°è´§åå· ///</summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "CBILL_NO")] public string CbillNo { get; set; } /// <summary> /// 0 ç³è¯·åï¼1å ¥åºåæ è¯ ///</summary> /// 0 ç³è¯·åï¼1å ¥åºåæ è¯ /// </summary> [SugarColumn(ColumnName = "PICK_INS")] public decimal? PickIns { get; set; } /// <summary> /// å ¥åºå®¡æ ¸äºº ///</summary> /// å ¥åºå®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "FCHECK_USER")] public string FcheckUser { get; set; } /// <summary> /// å ¥åºå®¡æ ¸æ¥æ ///</summary> /// å ¥åºå®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } /// <summary> /// ä»»å¡æ±æ¥å/å·¥åå·ï¼æåå ¥åºï¼ ///</summary> /// ä»»å¡æ±æ¥å/å·¥åå·ï¼æåå ¥åºï¼ /// </summary> [SugarColumn(ColumnName = "RBILL_NO")] public string RbillNo { get; set; } /// <summary> /// æ¥å·¥äºº ///</summary> /// æ¥å·¥äºº /// </summary> [SugarColumn(ColumnName = "BGR")] public string Bgr { get; set; }
@@ -8,171 +8,171 @@ [SugarTable("MES_INV_ITEM_MOVES")] public class MesInvItemMoves { /// <summary> /// SEQ_INV_ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// SEQ_INV_ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 移åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// 移åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// ç§»å ¥ååºid /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_ID")] /// <summary> /// ç§»å ¥ååºid /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_ID")] public decimal? InvDepotsId { get; set; } /// <summary> /// ç§»å ¥è´§ä½id /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] /// <summary> /// ç§»å ¥è´§ä½id /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] public decimal? InvDepotSectionsId { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// ç¶æ|0-å¶å1-è¿è´¦ /// </summary> [SugarColumn(ColumnName = "STATUS")] /// <summary> /// ç¶æ|0-å¶å1-è¿è´¦ /// </summary> [SugarColumn(ColumnName = "STATUS")] public decimal? Status { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARK")] /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// åæ®ç±»åID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] /// <summary> /// åæ®ç±»åID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } /// <summary> /// äºå¡ç±»åID /// </summary> [SugarColumn(ColumnName = "TRANSACTION_ID")] /// <summary> /// äºå¡ç±»åID /// </summary> [SugarColumn(ColumnName = "TRANSACTION_ID")] public decimal? TransactionId { get; set; } /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "CHECKUSER")] /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "CHECKUSER")] public string Checkuser { get; set; } /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "CHECKDATE")] /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "CHECKDATE")] public DateTime? Checkdate { get; set; } /// <summary> /// ç§»å ¥ååºcode /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] /// <summary> /// ç§»å ¥ååºcode /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] public string InvDepotsCode { get; set; } /// <summary> /// ç§»å ¥è´§ä½code /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] /// <summary> /// ç§»å ¥è´§ä½code /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] public string InvDepotSectionsCode { get; set; } /// <summary> /// äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSACTION_NO")] /// <summary> /// äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSACTION_NO")] public decimal? TransactionNo { get; set; } /// <summary> /// 移åºååºcode /// </summary> [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] /// <summary> /// 移åºååºcode /// </summary> [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] public string FromDepotsCode { get; set; } /// <summary> /// å·¥åç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY_CODE")] /// <summary> /// å·¥åç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY_CODE")] public string FactoryCode { get; set; } /// <summary> /// SAPè¿ååæ® /// </summary> [SugarColumn(ColumnName = "SAPNO")] /// <summary> /// SAPè¿ååæ® /// </summary> [SugarColumn(ColumnName = "SAPNO")] public string Sapno { get; set; } /// <summary> /// å·²ååSAP /// </summary> [SugarColumn(ColumnName = "SAPSTATUS")] /// <summary> /// å·²ååSAP /// </summary> [SugarColumn(ColumnName = "SAPSTATUS")] public short? Sapstatus { get; set; } /// <summary> /// SAPè¿å年份 /// </summary> [SugarColumn(ColumnName = "SAPYEAR")] /// <summary> /// SAPè¿å年份 /// </summary> [SugarColumn(ColumnName = "SAPYEAR")] public short? Sapyear { get; set; } /// <summary> /// SAPè¿åä¿¡æ¯ /// </summary> [SugarColumn(ColumnName = "SAPTEXT")] /// <summary> /// SAPè¿åä¿¡æ¯ /// </summary> [SugarColumn(ColumnName = "SAPTEXT")] public string Saptext { get; set; } /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// åå®¡æ ¸äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "MTRANSACTION_NO")] /// <summary> /// åå®¡æ ¸äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "MTRANSACTION_NO")] public decimal? MtransactionNo { get; set; } /// <summary> /// èªå¨ä¿åå段 /// </summary> [SugarColumn(ColumnName = "ZD_NUM")] /// <summary> /// èªå¨ä¿åå段 /// </summary> [SugarColumn(ColumnName = "ZD_NUM")] public decimal? ZdNum { get; set; } /// <summary> /// æ¯å¦æ¨éERP1-æ¯ï¼2-å¦ /// </summary> [SugarColumn(ColumnName = "TS")] /// <summary> /// æ¯å¦æ¨éERP1-æ¯ï¼2-å¦ /// </summary> [SugarColumn(ColumnName = "TS")] public decimal? Ts { get; set; } } StandardPda/MES.Service/Modes/MesInvTransaction.cs
@@ -8,75 +8,75 @@ [SugarTable("MES_INV_TRANSACTION")] public class MesInvTransaction { /// <summary> /// ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// äºå¡ç±»å /// </summary> [SugarColumn(ColumnName = "TRANSACTION_NAME")] /// <summary> /// äºå¡ç±»å /// </summary> [SugarColumn(ColumnName = "TRANSACTION_NAME")] public string TransactionName { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARK")] /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// åæ®ID /// </summary> [SugarColumn(ColumnName = "BUSINESS_ID")] /// <summary> /// åæ®ID /// </summary> [SugarColumn(ColumnName = "BUSINESS_ID")] public decimal? BusinessId { get; set; } /// <summary> /// 交æç±»å|1-å ¥åº0-转åº-1åºåº /// </summary> [SugarColumn(ColumnName = "BUSINESS_TYPE")] /// <summary> /// 交æç±»å|1-å ¥åº0-转åº-1åºåº /// </summary> [SugarColumn(ColumnName = "BUSINESS_TYPE")] public decimal? BusinessType { get; set; } /// <summary> /// äºå¡ç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSACTION_NO")] /// <summary> /// äºå¡ç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSACTION_NO")] public decimal? TransactionNo { get; set; } /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } } StandardPda/MES.Service/Modes/MesQaItemsDetect01.cs
@@ -1,488 +1,480 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; using SqlSugar; namespace MES.Service.Modes namespace MES.Service.Modes; /// <summary> /// æ¥æå ¥åºæ£éªè¡¨å¤´ /// </summary> [SugarTable("MES_QA_ITEMS_DETECT_01")] public class MesQaItemsDetect01 { /// <summary> /// æ¥æå ¥åºæ£éªè¡¨å¤´ ///</summary> [SugarTable("MES_QA_ITEMS_DETECT_01")] public class MesQaItemsDetect01 { /// <summary> /// ///</summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// æ£éªåå· ///</summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } /// <summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } /// <summary> /// æ£éªæ¥æ ///</summary> [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } /// <summary> /// æ£éªäººå ///</summary> [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } /// <summary> /// æ£éªäººå /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } /// <summary> /// ç©æç¼ç ///</summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// æ¥ææ°é ///</summary> [SugarColumn(ColumnName = "FBATCH_QTY")] public decimal? FbatchQty { get; set; } /// <summary> /// æ¥ææ°é /// </summary> [SugarColumn(ColumnName = "FBATCH_QTY")] public decimal? FbatchQty { get; set; } /// <summary> /// æ¥æ¶æ°é ///</summary> [SugarColumn(ColumnName = "FRECE_QTY")] public string FreceQty { get; set; } /// <summary> /// æ¥æ¶æ°é /// </summary> [SugarColumn(ColumnName = "FRECE_QTY")] public string FreceQty { get; set; } /// <summary> /// ä¾åºåç¼å· ///</summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// ä¾åºåç¼å· /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// å¤æ³¨ ///</summary> [SugarColumn(ColumnName = "FNG_DESC")] public string? FngDesc { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "FNG_DESC")] public string? FngDesc { get; set; } /// <summary> /// æ£éªç»æ ///</summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } /// <summary> /// OAè¯å®¡åé¦ ///</summary> [SugarColumn(ColumnName = "FREVIEW")] public string Freview { get; set; } /// <summary> /// OAè¯å®¡åé¦ /// </summary> [SugarColumn(ColumnName = "FREVIEW")] public string Freview { get; set; } /// <summary> /// æ£éªæ°´å ///</summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } /// <summary> /// æ£éªæ°´å /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } /// <summary> /// æ£éªæ°´å¹³ ///</summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } /// <summary> /// ææ¶æ°´å¹³ ///</summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } /// <summary> /// ææ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } /// <summary> /// æ½æ£æ°é ///</summary> [SugarColumn(ColumnName = "CHECK_QTY")] public string CheckQty { get; set; } /// <summary> /// æ½æ£æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] public string CheckQty { get; set; } /// <summary> /// æ¹æ¬¡å· --å°è´§åå· ///</summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ¹æ¬¡å· --å°è´§åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ¯å¦æ¨é ///</summary> [SugarColumn(ColumnName = "FMOVE")] public string Fmove { get; set; } /// <summary> /// æ¯å¦æ¨é /// </summary> [SugarColumn(ColumnName = "FMOVE")] public string Fmove { get; set; } /// <summary> /// æ¯å¦å¤ç ///</summary> [SugarColumn(ColumnName = "FHANDLE")] public string Fhandle { get; set; } /// <summary> /// æ¯å¦å¤ç /// </summary> [SugarColumn(ColumnName = "FHANDLE")] public string Fhandle { get; set; } /// <summary> /// å建人 ///</summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¥æ ///</summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// å建æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æ´æ°äºº ///</summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æ´æ°æ¥æ ///</summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// æ´æ°æ¥æ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// æ¯å¦å®¡æ ¸ ///</summary> [SugarColumn(ColumnName = "MODIFY1_FLAG")] public decimal? Modify1Flag { get; set; } /// <summary> /// æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG")] public decimal? Modify1Flag { get; set; } /// <summary> /// å®¡æ ¸äºº ///</summary> [SugarColumn(ColumnName = "MODIFY1_BY")] public string Modify1By { get; set; } /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY")] public string Modify1By { get; set; } /// <summary> /// å®¡æ ¸æ¥æ ///</summary> [SugarColumn(ColumnName = "MODIFY1_DATE")] public DateTime? Modify1Date { get; set; } /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE")] public DateTime? Modify1Date { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// XRFæµè¯æ¥åç¼å· ///</summary> [SugarColumn(ColumnName = "FCHECK_REPNO")] public string FcheckRepno { get; set; } /// <summary> /// XRFæµè¯æ¥åç¼å· /// </summary> [SugarColumn(ColumnName = "FCHECK_REPNO")] public string FcheckRepno { get; set; } /// <summary> /// 第ä¸æ¹æ¥å ///</summary> [SugarColumn(ColumnName = "FTHIRD_REP")] public string FthirdRep { get; set; } /// <summary> /// 第ä¸æ¹æ¥å /// </summary> [SugarColumn(ColumnName = "FTHIRD_REP")] public string FthirdRep { get; set; } /// <summary> /// æ¯å¦ä½åº ///</summary> [SugarColumn(ColumnName = "FCANCEL")] public decimal? Fcancel { get; set; } /// <summary> /// æ¯å¦ä½åº /// </summary> [SugarColumn(ColumnName = "FCANCEL")] public decimal? Fcancel { get; set; } /// <summary> /// æ交æ è¯ ///</summary> [SugarColumn(ColumnName = "FSUBMIT")] public decimal? Fsubmit { get; set; } /// <summary> /// æ交æ è¯ /// </summary> [SugarColumn(ColumnName = "FSUBMIT")] public decimal? Fsubmit { get; set; } /// <summary> /// æ£éªä¾æ® ///</summary> [SugarColumn(ColumnName = "FCHECK_ACCORD")] public string FcheckAccord { get; set; } /// <summary> /// æ£éªä¾æ® /// </summary> [SugarColumn(ColumnName = "FCHECK_ACCORD")] public string FcheckAccord { get; set; } /// <summary> /// ç±»å(0 æ¥æ 1 å¨åº) ///</summary> [SugarColumn(ColumnName = "FTYPE")] public short? Ftype { get; set; } /// <summary> /// ç±»å(0 æ¥æ 1 å¨åº) /// </summary> [SugarColumn(ColumnName = "FTYPE")] public short? Ftype { get; set; } /// <summary> /// åä½ ///</summary> [SugarColumn(ColumnName = "ITEM_UNIT")] public string ItemUnit { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "ITEM_UNIT")] public string ItemUnit { get; set; } /// <summary> /// åºè´§æ¥æ ///</summary> [SugarColumn(ColumnName = "OUT_DATE")] public string OutDate { get; set; } /// <summary> /// åºè´§æ¥æ /// </summary> [SugarColumn(ColumnName = "OUT_DATE")] public string OutDate { get; set; } /// <summary> /// æ¯å¦å æ£ ///</summary> [SugarColumn(ColumnName = "FEXEMPTION")] public decimal? Fexemption { get; set; } /// <summary> /// æ¯å¦å æ£ /// </summary> [SugarColumn(ColumnName = "FEXEMPTION")] public decimal? Fexemption { get; set; } /// <summary> /// æ¡£ä½æ å ///</summary> [SugarColumn(ColumnName = "FGEAR_STAND")] public string FgearStand { get; set; } /// <summary> /// æ¡£ä½æ å /// </summary> [SugarColumn(ColumnName = "FGEAR_STAND")] public string FgearStand { get; set; } /// <summary> /// ä¸è¯æç»å¤çæ¹å¼ ///</summary> [SugarColumn(ColumnName = "FNG_HANDLE")] public string FngHandle { get; set; } /// <summary> /// ä¸è¯æç»å¤çæ¹å¼ /// </summary> [SugarColumn(ColumnName = "FNG_HANDLE")] public string FngHandle { get; set; } /// <summary> /// 管çç¼å· ///</summary> [SugarColumn(ColumnName = "FMANAGE_NO")] public string FmanageNo { get; set; } /// <summary> /// 管çç¼å· /// </summary> [SugarColumn(ColumnName = "FMANAGE_NO")] public string FmanageNo { get; set; } /// <summary> /// 转æ¢æ°é ///</summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] public string FcovertQty { get; set; } /// <summary> /// 转æ¢æ°é /// </summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] public string FcovertQty { get; set; } /// <summary> /// çæ¬ ///</summary> [SugarColumn(ColumnName = "FVERSION")] public decimal? Fversion { get; set; } /// <summary> /// çæ¬ /// </summary> [SugarColumn(ColumnName = "FVERSION")] public decimal? Fversion { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "FSECOND_RESU")] public string FsecondResu { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FSECOND_RESU")] public string FsecondResu { get; set; } /// <summary> /// æ大æ½æ£æ° ///</summary> [SugarColumn(ColumnName = "MAX_CHECK_QTY")] public decimal? MaxCheckQty { get; set; } /// <summary> /// æ大æ½æ£æ° /// </summary> [SugarColumn(ColumnName = "MAX_CHECK_QTY")] public decimal? MaxCheckQty { get; set; } /// <summary> /// ç¹å®ä¿®æ¹æ¯å¦å®¡æ ¸ ///</summary> [SugarColumn(ColumnName = "MODIFY1_FLAG1")] public decimal? Modify1Flag1 { get; set; } /// <summary> /// ç¹å®ä¿®æ¹æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG1")] public decimal? Modify1Flag1 { get; set; } /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸äºº ///</summary> [SugarColumn(ColumnName = "MODIFY1_BY1")] public string Modify1By1 { get; set; } /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY1")] public string Modify1By1 { get; set; } /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸æ¶é´ ///</summary> [SugarColumn(ColumnName = "MODIFY1_DATE1")] public DateTime? Modify1Date1 { get; set; } /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸æ¶é´ /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE1")] public DateTime? Modify1Date1 { get; set; } /// <summary> /// å°æ¹æ¬¡å· ///</summary> [SugarColumn(ColumnName = "LOT_NO1")] public string LotNo1 { get; set; } /// <summary> /// å°æ¹æ¬¡å· /// </summary> [SugarColumn(ColumnName = "LOT_NO1")] public string LotNo1 { get; set; } /// <summary> /// éè´åå· ///</summary> [SugarColumn(ColumnName = "LOT_NO2")] public string LotNo2 { get; set; } /// <summary> /// éè´åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO2")] public string LotNo2 { get; set; } /// <summary> /// 产ååå· ///</summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// ä»»å¡åå· ///</summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// å°è´§æ¶é´ ///</summary> [SugarColumn(ColumnName = "DHA018")] public string Dha018 { get; set; } /// <summary> /// å°è´§æ¶é´ /// </summary> [SugarColumn(ColumnName = "DHA018")] public string Dha018 { get; set; } /// <summary> /// è¡å· ///</summary> [SugarColumn(ColumnName = "DHB002")] public decimal? Dhb002 { get; set; } /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "DHB002")] public decimal? Dhb002 { get; set; } /// <summary> /// å°è´§åå· ///</summary> [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } /// <summary> /// ä¾åºå ///</summary> [SugarColumn(ColumnName = "LIFNR")] public string Lifnr { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "LIFNR")] public string Lifnr { get; set; } /// <summary> /// éææ¹å¼ ///</summary> [SugarColumn(ColumnName = "FMRMODE")] public string Fmrmode { get; set; } /// <summary> /// éææ¹å¼ /// </summary> [SugarColumn(ColumnName = "FMRMODE")] public string Fmrmode { get; set; } /// <summary> /// erpè¿åä¿¡æ¯ ///</summary> [SugarColumn(ColumnName = "MSG")] public string Msg { get; set; } /// <summary> /// erpè¿åä¿¡æ¯ /// </summary> [SugarColumn(ColumnName = "MSG")] public string Msg { get; set; } /// <summary> /// ç¶æ ///</summary> [SugarColumn(ColumnName = "STATES")] public string States { get; set; } /// <summary> /// ç¶æ /// </summary> [SugarColumn(ColumnName = "STATES")] public string States { get; set; } /// <summary> /// IQCæ交æ¶é´ ///</summary> [SugarColumn(ColumnName = "IQC_DATE")] public DateTime? IqcDate { get; set; } /// <summary> /// IQCæ交æ¶é´ /// </summary> [SugarColumn(ColumnName = "IQC_DATE")] public DateTime? IqcDate { get; set; } /// <summary> /// éè´è®¢åID ///</summary> [SugarColumn(ColumnName = "EBELN_K3ID")] public decimal? EbelnK3id { get; set; } /// <summary> /// éè´è®¢åID /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] public decimal? EbelnK3id { get; set; } /// <summary> /// éè´è®¢åè¡ID ///</summary> [SugarColumn(ColumnName = "LINE_K3ID")] public decimal? LineK3id { get; set; } /// <summary> /// éè´è®¢åè¡ID /// </summary> [SugarColumn(ColumnName = "LINE_K3ID")] public decimal? LineK3id { get; set; } /// <summary> /// åè´¨å®¡æ ¸æ è¯ ///</summary> [SugarColumn(ColumnName = "QUALITY_AUDIT")] public decimal? QualityAudit { get; set; } /// <summary> /// åè´¨å®¡æ ¸æ è¯ /// </summary> [SugarColumn(ColumnName = "QUALITY_AUDIT")] public decimal? QualityAudit { get; set; } /// <summary> /// ç©æID ///</summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } /// <summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } /// <summary> /// éªæ¶æ° ///</summary> [SugarColumn(ColumnName = "YANS_NUM")] public decimal? YansNum { get; set; } /// <summary> /// éªæ¶æ° /// </summary> [SugarColumn(ColumnName = "YANS_NUM")] public decimal? YansNum { get; set; } /// <summary> /// éªéæ° ///</summary> [SugarColumn(ColumnName = "YANT_NUM")] public decimal? YantNum { get; set; } /// <summary> /// éªéæ° /// </summary> [SugarColumn(ColumnName = "YANT_NUM")] public decimal? YantNum { get; set; } /// <summary> /// éè´å®¡æ ¸æ è¯ ///</summary> [SugarColumn(ColumnName = "CG_AUDIT")] public decimal? CgAudit { get; set; } /// <summary> /// éè´å®¡æ ¸æ è¯ /// </summary> [SugarColumn(ColumnName = "CG_AUDIT")] public decimal? CgAudit { get; set; } /// <summary> /// éè´æè§ ///</summary> [SugarColumn(ColumnName = "CG_OPINION")] public string CgOpinion { get; set; } /// <summary> /// éè´æè§ /// </summary> [SugarColumn(ColumnName = "CG_OPINION")] public string CgOpinion { get; set; } /// <summary> /// éè´å¤çæ¹å¼ ///</summary> [SugarColumn(ColumnName = "CG_HANDLE")] public string CgHandle { get; set; } /// <summary> /// éè´å¤çæ¹å¼ /// </summary> [SugarColumn(ColumnName = "CG_HANDLE")] public string CgHandle { get; set; } /// <summary> /// åè´¨æè§ ///</summary> [SugarColumn(ColumnName = "QC_OPINION")] public string QcOpinion { get; set; } /// <summary> /// åè´¨æè§ /// </summary> [SugarColumn(ColumnName = "QC_OPINION")] public string QcOpinion { get; set; } /// <summary> /// åè´¨å¤çæ¹å¼ ///</summary> [SugarColumn(ColumnName = "QC_HANDLE")] public string QcHandle { get; set; } /// <summary> /// åè´¨å¤çæ¹å¼ /// </summary> [SugarColumn(ColumnName = "QC_HANDLE")] public string QcHandle { get; set; } /// <summary> /// ç»çå®¡æ ¸æ è¯ ///</summary> [SugarColumn(ColumnName = "MANAGER_AUDIT")] public decimal? ManagerAudit { get; set; } /// <summary> /// ç»çå®¡æ ¸æ è¯ /// </summary> [SugarColumn(ColumnName = "MANAGER_AUDIT")] public decimal? ManagerAudit { get; set; } /// <summary> /// ç»çæè§ ///</summary> [SugarColumn(ColumnName = "MANAGER_OPINION")] public string ManagerOpinion { get; set; } /// <summary> /// ç»çæè§ /// </summary> [SugarColumn(ColumnName = "MANAGER_OPINION")] public string ManagerOpinion { get; set; } /// <summary> /// ç»çå¤çæ¹å¼ ///</summary> [SugarColumn(ColumnName = "MANAGER_HANDLE")] public string ManagerHandle { get; set; } /// <summary> /// ç»çå¤çæ¹å¼ /// </summary> [SugarColumn(ColumnName = "MANAGER_HANDLE")] public string ManagerHandle { get; set; } /// <summary> /// éå®è®¢å ///</summary> [SugarColumn(ColumnName = "SALES_ORDER")] public string SalesOrder { get; set; } /// <summary> /// éå®è®¢å /// </summary> [SugarColumn(ColumnName = "SALES_ORDER")] public string SalesOrder { get; set; } /// <summary> /// éè´å®¡æ ¸äºº ///</summary> [SugarColumn(ColumnName = "CG_USER")] public string CgUser { get; set; } /// <summary> /// éè´å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "CG_USER")] public string CgUser { get; set; } /// <summary> /// åè´¨å®¡æ ¸äºº ///</summary> [SugarColumn(ColumnName = "QC_USER")] public string QcUser { get; set; } /// <summary> /// åè´¨å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "QC_USER")] public string QcUser { get; set; } /// <summary> /// ç»çå®¡æ ¸äºº ///</summary> [SugarColumn(ColumnName = "MANAGER_USER")] public string ManagerUser { get; set; } /// <summary> /// ç»çå®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "MANAGER_USER")] public string ManagerUser { get; set; } /// <summary> /// 计åè·è¸ªå· ///</summary> [SugarColumn(ColumnName = "FMTONO")] public string Fmtono { get; set; } /// <summary> /// 计åè·è¸ªå· /// </summary> [SugarColumn(ColumnName = "FMTONO")] public string Fmtono { get; set; } /// <summary> /// å®éªå®¤éæ£æ è¯ ///</summary> [SugarColumn(ColumnName = "IS_SJ")] public decimal? IsSj { get; set; } /// <summary> /// å®éªå®¤éæ£æ è¯ /// </summary> [SugarColumn(ColumnName = "IS_SJ")] public decimal? IsSj { get; set; } /// <summary> /// å®éªå®¤éæ£åå· ///</summary> [SugarColumn(ColumnName = "SJ_NO")] public string SjNo { get; set; } } /// <summary> /// å®éªå®¤éæ£åå· /// </summary> [SugarColumn(ColumnName = "SJ_NO")] public string SjNo { get; set; } } StandardPda/MES.Service/Modes/MesQaItemsDetectDetail12.cs
@@ -1,88 +1,77 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; using SqlSugar; namespace MES.Service.Modes namespace MES.Service.Modes; /// <summary> /// IQCæ£éª /// </summary> [SugarTable("MES_QA_ITEMS_DETECT_DETAIL12")] public class MesQaItemsDetectDetail12 { /// <summary> /// IQCæ£éª ///</summary> [SugarTable("MES_QA_ITEMS_DETECT_DETAIL12")] public class MesQaItemsDetectDetail12 { /// <summary> /// ///</summary> [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_QM_ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_QM_ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// æ£éªç»æ ///</summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string? FcheckResu { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string? FcheckResu { get; set; } /// <summary> /// æ£éªé¡¹ç® ///</summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] public string? FcheckItem { get; set; } /// <summary> /// æ£éªé¡¹ç® /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] public string? FcheckItem { get; set; } /// <summary> /// ç©ææ¡ç ///</summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string? ItemBarcode { get; set; } /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string? ItemBarcode { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string? ReleaseNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string? ReleaseNo { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "MAIN_ID")] public decimal? MainId { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MAIN_ID")] public decimal? MainId { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "COMPANY")] public string? Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string? Company { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "FACTORY")] public string? Factory { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string? Factory { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "FSTAND")] public string? Fstand { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FSTAND")] public string? Fstand { get; set; } /// <summary> /// çæ人 ///</summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string? LastupdateBy { get; set; } /// <summary> /// çæ人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string? LastupdateBy { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "CREATE_BY")] public string? CreateBy { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string? CreateBy { get; set; } [SugarColumn(IsIgnore = true)] public int? count { get; set; } } [SugarColumn(IsIgnore = true)] public int? count { get; set; } } StandardPda/MES.Service/Modes/MesQaItemsDetectDetail5.cs
@@ -1,184 +1,176 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; using SqlSugar; namespace MES.Service.Modes namespace MES.Service.Modes; /// <summary> /// æ¥ææ£éªä»è¡¨ /// </summary> [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] public class MesQaItemsDetectDetail5 { /// <summary> /// æ¥ææ£éªä»è¡¨ ///</summary> [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] public class MesQaItemsDetectDetail5 { /// <summary> /// ///</summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// æ åå¼ç±»å ///</summary> [SugarColumn(ColumnName = "FTEXT_TYPE")] public string FtextType { get; set; } /// <summary> /// æ åå¼ç±»å /// </summary> [SugarColumn(ColumnName = "FTEXT_TYPE")] public string FtextType { get; set; } /// <summary> /// æ åå¼ ///</summary> [SugarColumn(ColumnName = "FSTAND")] public decimal? Fstand { get; set; } /// <summary> /// æ åå¼ /// </summary> [SugarColumn(ColumnName = "FSTAND")] public decimal? Fstand { get; set; } /// <summary> /// ä¸å ¬å·® ///</summary> [SugarColumn(ColumnName = "FUP_ALLOW")] public string FupAllow { get; set; } /// <summary> /// ä¸å ¬å·® /// </summary> [SugarColumn(ColumnName = "FUP_ALLOW")] public string FupAllow { get; set; } /// <summary> /// ä¸å ¬å·® ///</summary> [SugarColumn(ColumnName = "FDOWN_ALLOW")] public string FdownAllow { get; set; } /// <summary> /// ä¸å ¬å·® /// </summary> [SugarColumn(ColumnName = "FDOWN_ALLOW")] public string FdownAllow { get; set; } /// <summary> /// æ£éªæ°´å ///</summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } /// <summary> /// æ£éªæ°´å /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } /// <summary> /// æ£éªæ°´å¹³ ///</summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } /// <summary> /// ææ¶æ°´å¹³ ///</summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } /// <summary> /// ææ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } /// <summary> /// æ£éªé¡¹ç® ///</summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] public string FcheckItem { get; set; } /// <summary> /// æ£éªé¡¹ç® /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] public string FcheckItem { get; set; } /// <summary> /// è§æ ¼è¦æ± ///</summary> [SugarColumn(ColumnName = "FSPEC_REQU")] public string FspecRequ { get; set; } /// <summary> /// è§æ ¼è¦æ± /// </summary> [SugarColumn(ColumnName = "FSPEC_REQU")] public string FspecRequ { get; set; } /// <summary> /// æ½æ£æ°é ///</summary> [SugarColumn(ColumnName = "CHECK_QYT")] public decimal? CheckQyt { get; set; } /// <summary> /// æ½æ£æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QYT")] public decimal? CheckQyt { get; set; } /// <summary> /// æ£éªç»æ ///</summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } /// <summary> /// ACæ°é ///</summary> [SugarColumn(ColumnName = "FAC_QTY")] public decimal? FacQty { get; set; } /// <summary> /// ACæ°é /// </summary> [SugarColumn(ColumnName = "FAC_QTY")] public decimal? FacQty { get; set; } /// <summary> /// REæ°é ///</summary> [SugarColumn(ColumnName = "FRE_QTY")] public decimal? FreQty { get; set; } /// <summary> /// REæ°é /// </summary> [SugarColumn(ColumnName = "FRE_QTY")] public decimal? FreQty { get; set; } /// <summary> /// ä¸åæ ¼æ° ///</summary> [SugarColumn(ColumnName = "FNG_QTY")] public decimal? FngQty { get; set; } /// <summary> /// ä¸åæ ¼æ° /// </summary> [SugarColumn(ColumnName = "FNG_QTY")] public decimal? FngQty { get; set; } /// <summary> /// ä¸è¯ç ///</summary> [SugarColumn(ColumnName = "FNG_RATE")] public decimal? FngRate { get; set; } /// <summary> /// ä¸è¯ç /// </summary> [SugarColumn(ColumnName = "FNG_RATE")] public decimal? FngRate { get; set; } /// <summary> /// å·²å½å ¥æ°é ///</summary> [SugarColumn(ColumnName = "FENTER_QTY")] public decimal? FenterQty { get; set; } /// <summary> /// å·²å½å ¥æ°é /// </summary> [SugarColumn(ColumnName = "FENTER_QTY")] public decimal? FenterQty { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// æ£éªé¡¹ç®æè¿° ///</summary> [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")] public string FcheckItemDesc { get; set; } /// <summary> /// æ£éªé¡¹ç®æè¿° /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")] public string FcheckItemDesc { get; set; } /// <summary> /// å·¥åºå· ///</summary> [SugarColumn(ColumnName = "PROC_NO")] public string ProcNo { get; set; } /// <summary> /// å·¥åºå· /// </summary> [SugarColumn(ColumnName = "PROC_NO")] public string ProcNo { get; set; } /// <summary> /// å·¥ä½ä¸å¿ç¼ç ///</summary> [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] public string WorkshopCenterCode { get; set; } /// <summary> /// å·¥ä½ä¸å¿ç¼ç /// </summary> [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] public string WorkshopCenterCode { get; set; } /// <summary> /// åä½ ///</summary> [SugarColumn(ColumnName = "FUNIT")] public string Funit { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "FUNIT")] public string Funit { get; set; } /// <summary> /// ç¹å®ä¿®æ¹ ///</summary> [SugarColumn(ColumnName = "GIVEN_MODIFY")] public short? GivenModify { get; set; } /// <summary> /// ç¹å®ä¿®æ¹ /// </summary> [SugarColumn(ColumnName = "GIVEN_MODIFY")] public short? GivenModify { get; set; } /// <summary> /// æ£éªå·¥å · ///</summary> [SugarColumn(ColumnName = "FCHECK_TOOL")] public string FcheckTool { get; set; } /// <summary> /// æ£éªå·¥å · /// </summary> [SugarColumn(ColumnName = "FCHECK_TOOL")] public string FcheckTool { get; set; } /// <summary> /// æ´æ°äºº ///</summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æ´æ°æ¶é´ ///</summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// æ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } [SugarColumn(IsIgnore = true)] public int? Unqualified { get; set; } } [SugarColumn(IsIgnore = true)] public int? Unqualified { get; set; } } StandardPda/MES.Service/Modes/MesScgdGx.cs
@@ -1,128 +1,122 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; using SqlSugar; namespace MES.Service.Modes namespace MES.Service.Modes; /// <summary> /// å·¥åæ¥å·¥ä¿¡æ¯è¡¨ /// </summary> [SugarTable("MES_SCGD_GX")] public class MesScgdGx { /// <summary> /// å·¥åæ¥å·¥ä¿¡æ¯è¡¨ ///</summary> [SugarTable("MES_SCGD_GX")] public class MesScgdGx { /// <summary> /// ///</summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal? Id { get; set; } /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal? Id { get; set; } /// <summary> /// ç产工å ///</summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// ç产æ¡ç ///</summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// ç产æ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// æ¡ç æ°é ///</summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// æ¡ç æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// æ¥å·¥æ°é ///</summary> [SugarColumn(ColumnName = "QUANT")] public decimal? Quant { get; set; } /// <summary> /// æ¥å·¥æ°é /// </summary> [SugarColumn(ColumnName = "QUANT")] public decimal? Quant { get; set; } /// <summary> /// å·¥åº ///</summary> [SugarColumn(ColumnName = "GX")] public string Gx { get; set; } /// <summary> /// å·¥åº /// </summary> [SugarColumn(ColumnName = "GX")] public string Gx { get; set; } /// <summary> /// å·¥åºID ///</summary> [SugarColumn(ColumnName = "GX_ID")] public string GxId { get; set; } /// <summary> /// å·¥åºID /// </summary> [SugarColumn(ColumnName = "GX_ID")] public string GxId { get; set; } /// <summary> /// æ¥å·¥äºº ///</summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// æ¥å·¥äºº /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// æ¥å·¥æ¶é´ ///</summary> [SugarColumn(ColumnName = "CREATE_BY_DATE")] public DateTime? CreateByDate { get; set; } /// <summary> /// æ¥å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_BY_DATE")] public DateTime? CreateByDate { get; set; } /// <summary> /// å°è´§åå·/å ¥åºåå· ///</summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// å°è´§åå·/å ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// ç次 ///</summary> [SugarColumn(ColumnName = "F_BC")] public string FBc { get; set; } /// <summary> /// ç次 /// </summary> [SugarColumn(ColumnName = "F_BC")] public string FBc { get; set; } /// <summary> /// å·¥åºå®æ¯æ è¯ ///</summary> [SugarColumn(ColumnName = "GX_FLAE")] public decimal? GxFlae { get; set; } /// <summary> /// å·¥åºå®æ¯æ è¯ /// </summary> [SugarColumn(ColumnName = "GX_FLAE")] public decimal? GxFlae { get; set; } /// <summary> /// æ¥å·¥æ¶é´ï¼å¹´ææ¥ï¼ ///</summary> [SugarColumn(ColumnName = "CREATE_BY1")] public string CreateBy1 { get; set; } /// <summary> /// æ¥å·¥æ¶é´ï¼å¹´ææ¥ï¼ /// </summary> [SugarColumn(ColumnName = "CREATE_BY1")] public string CreateBy1 { get; set; } /// <summary> /// æåæ° ///</summary> [SugarColumn(ColumnName = "C_QUANT")] public decimal? CQuant { get; set; } /// <summary> /// æåæ° /// </summary> [SugarColumn(ColumnName = "C_QUANT")] public decimal? CQuant { get; set; } /// <summary> /// å¼å·¥æ¶é´ ///</summary> [SugarColumn(ColumnName = "KG_TIME")] public string KgTime { get; set; } /// <summary> /// å¼å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "KG_TIME")] public string KgTime { get; set; } /// <summary> /// å®å·¥æ¶é´ ///</summary> [SugarColumn(ColumnName = "WG_TIME")] public string WgTime { get; set; } /// <summary> /// å®å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "WG_TIME")] public string WgTime { get; set; } /// <summary> /// æºå° ///</summary> [SugarColumn(ColumnName = "JT")] public string Jt { get; set; } /// <summary> /// æºå° /// </summary> [SugarColumn(ColumnName = "JT")] public string Jt { get; set; } /// <summary> /// æ¥å·¥äººç¼ç ///</summary> [SugarColumn(ColumnName = "CREATE_CODE")] public string CreateCode { get; set; } /// <summary> /// æ¥å·¥äººç¼ç /// </summary> [SugarColumn(ColumnName = "CREATE_CODE")] public string CreateCode { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName = "CHECK_FLAG")] public string CheckFlag { get; set; } } /// <summary> /// </summary> [SugarColumn(ColumnName = "CHECK_FLAG")] public string CheckFlag { get; set; } } StandardPda/MES.Service/Modes/MesStaff.cs
@@ -9,158 +9,158 @@ public class MesStaff { /// <summary> /// ID ///</summary> /// ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// åå·¥ç¼ç ///</summary> /// åå·¥ç¼ç /// </summary> [SugarColumn(ColumnName = "STAFF_NO")] public string? StaffNo { get; set; } /// <summary> /// åå·¥å§å ///</summary> /// åå·¥å§å /// </summary> [SugarColumn(ColumnName = "STAFF_NAME")] public string? StaffName { get; set; } /// <summary> /// é¨é¨ç¼ç ///</summary> /// é¨é¨ç¼ç /// </summary> [SugarColumn(ColumnName = "DEPARTMENT_NO")] public string? DepartmentNo { get; set; } /// <summary> /// é¨é¨å称 ///</summary> /// é¨é¨å称 /// </summary> [SugarColumn(ColumnName = "DEPARTMENT_NAME")] public string? DepartmentName { get; set; } /// <summary> /// å²ä½ç¼ç ///</summary> /// å²ä½ç¼ç /// </summary> [SugarColumn(ColumnName = "POSITION_CODE")] public string? PositionCode { get; set; } /// <summary> /// å²ä½å称 ///</summary> /// å²ä½å称 /// </summary> [SugarColumn(ColumnName = "POSITION_NAME")] public string? PositionName { get; set; } /// <summary> /// ææºå· ///</summary> /// ææºå· /// </summary> [SugarColumn(ColumnName = "PHONE_NUMBER")] public string? PhoneNumber { get; set; } /// <summary> /// ä»»å²å¼å§æ¥æ ///</summary> /// ä»»å²å¼å§æ¥æ /// </summary> [SugarColumn(ColumnName = "START_DATE")] public DateTime? StartDate { get; set; } /// <summary> /// å¤æ³¨ 人åç±»åï¼1ï¼æ£å¼å·¥ï¼2ï¼æ´¾é£å·¥ ///</summary> /// å¤æ³¨ 人åç±»åï¼1ï¼æ£å¼å·¥ï¼2ï¼æ´¾é£å·¥ /// </summary> [SugarColumn(ColumnName = "REMARK")] public string? Remark { get; set; } /// <summary> /// å建ç»ç» ///</summary> /// å建ç»ç» /// </summary> [SugarColumn(ColumnName = "CREATE_ORG")] public decimal? CreateOrg { get; set; } /// <summary> /// 使ç¨ç»ç» ///</summary> /// 使ç¨ç»ç» /// </summary> [SugarColumn(ColumnName = "USE_ORG")] public string? UseOrg { get; set; } /// <summary> /// èªå®ä¹å段3 ///</summary> /// èªå®ä¹å段3 /// </summary> [SugarColumn(ColumnName = "REMARK3")] public string? Remark3 { get; set; } /// <summary> /// èªå®ä¹å段4 ///</summary> /// èªå®ä¹å段4 /// </summary> [SugarColumn(ColumnName = "REMARK4")] public string? Remark4 { get; set; } /// <summary> /// èªå®ä¹å段5 ///</summary> /// èªå®ä¹å段5 /// </summary> [SugarColumn(ColumnName = "REMARK5")] public string? Remark5 { get; set; } /// <summary> /// å建人 ///</summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string? CreateBy { get; set; } /// <summary> /// å建æ¶é´ ///</summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æ´æ°äºº ///</summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string? LastupdateBy { get; set; } /// <summary> /// æ´æ°æ¶é´ ///</summary> /// æ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// å¤æ³¨ ///</summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "MEMO")] public string? Memo { get; set; } /// <summary> /// ç产线 ///</summary> /// ç产线 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string? LineNo { get; set; } /// <summary> /// ç产åå·¥æ è¯ ///</summary> /// ç产åå·¥æ è¯ /// </summary> [SugarColumn(ColumnName = "WORK_MK")] public decimal? WorkMk { get; set; } /// <summary> /// æ¯å¦ç¦ç¨ å·¥ä½ç¶æï¼1ï¼å¨èï¼2ï¼ç¦»è ///</summary> /// æ¯å¦ç¦ç¨ å·¥ä½ç¶æï¼1ï¼å¨èï¼2ï¼ç¦»è /// </summary> [SugarColumn(ColumnName = "FFORBID_STATUS")] public string? FforbidStatus { get; set; } /// <summary> /// ä¸å¡åç±»å ///</summary> /// ä¸å¡åç±»å /// </summary> [SugarColumn(ColumnName = "OPERATOR_TYPE")] public string? OperatorType { get; set; } /// <summary> /// æ¯å¦æ¯å ³é®å²ä½ 0ï¼å¦ï¼1ï¼æ¯ ///</summary> /// æ¯å¦æ¯å ³é®å²ä½ 0ï¼å¦ï¼1ï¼æ¯ /// </summary> [SugarColumn(ColumnName = "KEY_POSTS")] public string? KeyPosts { get; set; } /// <summary> /// 离èæ¶é´ ///</summary> /// 离èæ¶é´ /// </summary> [SugarColumn(ColumnName = "SEPARATION_TIME")] public DateTime? SeparationTime { get; set; } } StandardPda/MES.Service/Modes/Purdhb.cs
@@ -8,267 +8,267 @@ [SugarTable("PURDHB")] public class Purdhb { /// <summary> /// åå· /// </summary> [SugarColumn(ColumnName = "DHB001")] /// <summary> /// åå· /// </summary> [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } /// <summary> /// åºå· /// </summary> [SugarColumn(ColumnName = "DHB002")] /// <summary> /// åºå· /// </summary> [SugarColumn(ColumnName = "DHB002")] public string Dhb002 { get; set; } /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "DHB003")] /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "DHB003")] public string Dhb003 { get; set; } /// <summary> /// ç©æå称 /// </summary> [SugarColumn(ColumnName = "DHB004")] /// <summary> /// ç©æå称 /// </summary> [SugarColumn(ColumnName = "DHB004")] public string Dhb004 { get; set; } /// <summary> /// ç©æè§æ ¼ /// </summary> [SugarColumn(ColumnName = "DHB005")] /// <summary> /// ç©æè§æ ¼ /// </summary> [SugarColumn(ColumnName = "DHB005")] public string Dhb005 { get; set; } /// <summary> /// 交货æ°é /// </summary> [SugarColumn(ColumnName = "DHB006")] /// <summary> /// 交货æ°é /// </summary> [SugarColumn(ColumnName = "DHB006")] public decimal? Dhb006 { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "DHB007")] /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "DHB007")] public string Dhb007 { get; set; } /// <summary> /// ä»åº /// </summary> [SugarColumn(ColumnName = "DHB008")] /// <summary> /// ä»åº /// </summary> [SugarColumn(ColumnName = "DHB008")] public string Dhb008 { get; set; } /// <summary> /// ä»åºå称 /// </summary> [SugarColumn(ColumnName = "DHB009")] /// <summary> /// ä»åºå称 /// </summary> [SugarColumn(ColumnName = "DHB009")] public string Dhb009 { get; set; } /// <summary> /// æ¹å· /// </summary> [SugarColumn(ColumnName = "DHB010")] /// <summary> /// æ¹å· /// </summary> [SugarColumn(ColumnName = "DHB010")] public string Dhb010 { get; set; } /// <summary> /// æ¥æºåå· /// </summary> [SugarColumn(ColumnName = "DHB011")] /// <summary> /// æ¥æºåå· /// </summary> [SugarColumn(ColumnName = "DHB011")] public string Dhb011 { get; set; } /// <summary> /// æ¥æºåºå· /// </summary> [SugarColumn(ColumnName = "DHB012")] /// <summary> /// æ¥æºåºå· /// </summary> [SugarColumn(ColumnName = "DHB012")] public decimal? Dhb012 { get; set; } /// <summary> /// æ¸ ç¹æ°é /// </summary> [SugarColumn(ColumnName = "DHB013")] /// <summary> /// æ¸ ç¹æ°é /// </summary> [SugarColumn(ColumnName = "DHB013")] public decimal? Dhb013 { get; set; } /// <summary> /// å°åæ¥æ /// </summary> [SugarColumn(ColumnName = "DHB014")] /// <summary> /// å°åæ¥æ /// </summary> [SugarColumn(ColumnName = "DHB014")] public string Dhb014 { get; set; } /// <summary> /// éªæ¶æ°é /// </summary> [SugarColumn(ColumnName = "DHB015")] /// <summary> /// éªæ¶æ°é /// </summary> [SugarColumn(ColumnName = "DHB015")] public decimal? Dhb015 { get; set; } /// <summary> /// éªéæ°é /// </summary> [SugarColumn(ColumnName = "DHB016")] /// <summary> /// éªéæ°é /// </summary> [SugarColumn(ColumnName = "DHB016")] public decimal? Dhb016 { get; set; } /// <summary> /// è¿è´§åä»· /// </summary> [SugarColumn(ColumnName = "DHB017")] /// <summary> /// è¿è´§åä»· /// </summary> [SugarColumn(ColumnName = "DHB017")] public decimal? Dhb017 { get; set; } /// <summary> /// è¿è´§éé¢ /// </summary> [SugarColumn(ColumnName = "DHB018")] /// <summary> /// è¿è´§éé¢ /// </summary> [SugarColumn(ColumnName = "DHB018")] public decimal? Dhb018 { get; set; } /// <summary> /// 客æ·æå· /// </summary> [SugarColumn(ColumnName = "DHB019")] /// <summary> /// 客æ·æå· /// </summary> [SugarColumn(ColumnName = "DHB019")] public string Dhb019 { get; set; } /// <summary> /// é¨é¨ç¼å· /// </summary> [SugarColumn(ColumnName = "DHB020")] /// <summary> /// é¨é¨ç¼å· /// </summary> [SugarColumn(ColumnName = "DHB020")] public string Dhb020 { get; set; } /// <summary> /// èµ åæ° /// </summary> [SugarColumn(ColumnName = "DHB021")] /// <summary> /// èµ åæ° /// </summary> [SugarColumn(ColumnName = "DHB021")] public decimal? Dhb021 { get; set; } /// <summary> /// æ´æ°ERP /// </summary> [SugarColumn(ColumnName = "DHB022")] /// <summary> /// æ´æ°ERP /// </summary> [SugarColumn(ColumnName = "DHB022")] public string Dhb022 { get; set; } /// <summary> /// æ£éªç¶æ /// </summary> [SugarColumn(ColumnName = "DHB023")] /// <summary> /// æ£éªç¶æ /// </summary> [SugarColumn(ColumnName = "DHB023")] public string Dhb023 { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "DHB024")] /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "DHB024")] public string Dhb024 { get; set; } /// <summary> /// å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "AUDITING")] /// <summary> /// å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "AUDITING")] public decimal? Auditing { get; set; } /// <summary> /// ERPéè´åå·ID /// </summary> [SugarColumn(ColumnName = "DHB026")] /// <summary> /// ERPéè´åå·ID /// </summary> [SugarColumn(ColumnName = "DHB026")] public decimal? Dhb026 { get; set; } /// <summary> /// ERPéè´åºå·ID /// </summary> [SugarColumn(ColumnName = "DHB027")] /// <summary> /// ERPéè´åºå·ID /// </summary> [SugarColumn(ColumnName = "DHB027")] public decimal? Dhb027 { get; set; } /// <summary> /// ERPç©æID /// </summary> [SugarColumn(ColumnName = "DHB028")] /// <summary> /// ERPç©æID /// </summary> [SugarColumn(ColumnName = "DHB028")] public decimal? Dhb028 { get; set; } /// <summary> /// å¾ æ£æ°é /// </summary> [SugarColumn(ColumnName = "DHB029")] /// <summary> /// å¾ æ£æ°é /// </summary> [SugarColumn(ColumnName = "DHB029")] public decimal? Dhb029 { get; set; } /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "DHB030")] /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "DHB030")] public string Dhb030 { get; set; } /// <summary> /// æ£éªå /// </summary> [SugarColumn(ColumnName = "DHB031")] /// <summary> /// æ£éªå /// </summary> [SugarColumn(ColumnName = "DHB031")] public string Dhb031 { get; set; } /// <summary> /// å ¥åºæ°é /// </summary> [SugarColumn(ColumnName = "DHB032")] /// <summary> /// å ¥åºæ°é /// </summary> [SugarColumn(ColumnName = "DHB032")] public decimal? Dhb032 { get; set; } /// <summary> /// å ¥åºäºº /// </summary> [SugarColumn(ColumnName = "DHB033")] /// <summary> /// å ¥åºäºº /// </summary> [SugarColumn(ColumnName = "DHB033")] public string Dhb033 { get; set; } /// <summary> /// å ¥åºæ¶é´ /// </summary> [SugarColumn(ColumnName = "DHB034")] /// <summary> /// å ¥åºæ¶é´ /// </summary> [SugarColumn(ColumnName = "DHB034")] public string Dhb034 { get; set; } /// <summary> /// éè´§æ°é /// </summary> [SugarColumn(ColumnName = "DHB035")] /// <summary> /// éè´§æ°é /// </summary> [SugarColumn(ColumnName = "DHB035")] public decimal? Dhb035 { get; set; } /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "DHB037")] /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "DHB037")] public decimal? Dhb037 { get; set; } /// <summary> /// é货人 /// </summary> [SugarColumn(ColumnName = "DHB036")] /// <summary> /// é货人 /// </summary> [SugarColumn(ColumnName = "DHB036")] public string Dhb036 { get; set; } /// <summary> /// ERPååå½å· /// </summary> [SugarColumn(ColumnName = "DHB038")] /// <summary> /// ERPååå½å· /// </summary> [SugarColumn(ColumnName = "DHB038")] public decimal? Dhb038 { get; set; } /// <summary> /// ERPæºåå ç /// </summary> [SugarColumn(ColumnName = "DHB039")] /// <summary> /// ERPæºåå ç /// </summary> [SugarColumn(ColumnName = "DHB039")] public decimal? Dhb039 { get; set; } /// <summary> /// ERPæºåç±»å /// </summary> [SugarColumn(ColumnName = "DHB040")] /// <summary> /// ERPæºåç±»å /// </summary> [SugarColumn(ColumnName = "DHB040")] public decimal? Dhb040 { get; set; } /// <summary> /// ERP订åå ç /// </summary> [SugarColumn(ColumnName = "DHB041")] /// <summary> /// ERP订åå ç /// </summary> [SugarColumn(ColumnName = "DHB041")] public decimal? Dhb041 { get; set; } /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID")] /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } /// <summary> /// æ¯å¦æ£éªï¼1ä¸ºå·²æ£ /// </summary> [SugarColumn(ColumnName = "ISCHECK")] /// <summary> /// æ¯å¦æ£éªï¼1ä¸ºå·²æ£ /// </summary> [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } /// <summary> /// ä»åº /// </summary> [SugarColumn(ColumnName = "DHB042")] /// <summary> /// ä»åº /// </summary> [SugarColumn(ColumnName = "DHB042")] public string Dhb042 { get; set; } } StandardPda/MES.Service/Modes/Purdka.cs
@@ -8,123 +8,123 @@ [SugarTable("PURDKA")] public class Purdka { /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID")] /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } /// <summary> /// å建人å /// </summary> [SugarColumn(ColumnName = "CREATEUSER")] /// <summary> /// å建人å /// </summary> [SugarColumn(ColumnName = "CREATEUSER")] public string Createuser { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATETIME")] /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATETIME")] public string Createtime { get; set; } /// <summary> /// ä¿®æ¹æ¶é´ /// </summary> [SugarColumn(ColumnName = "MODIFYTIME")] /// <summary> /// ä¿®æ¹æ¶é´ /// </summary> [SugarColumn(ColumnName = "MODIFYTIME")] public string Modifytime { get; set; } /// <summary> /// ä¿®æ¹äººå /// </summary> [SugarColumn(ColumnName = "MODIFYUSER")] /// <summary> /// ä¿®æ¹äººå /// </summary> [SugarColumn(ColumnName = "MODIFYUSER")] public string Modifyuser { get; set; } /// <summary> /// å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "AUDITING")] /// <summary> /// å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "AUDITING")] public string Auditing { get; set; } /// <summary> /// éè´§åå· /// </summary> [SugarColumn(ColumnName = "DKA001")] /// <summary> /// éè´§åå· /// </summary> [SugarColumn(ColumnName = "DKA001")] public string Dka001 { get; set; } /// <summary> /// é货类å /// </summary> [SugarColumn(ColumnName = "DKA002")] /// <summary> /// é货类å /// </summary> [SugarColumn(ColumnName = "DKA002")] public string Dka002 { get; set; } /// <summary> /// éè´§æ¥æ /// </summary> [SugarColumn(ColumnName = "DKA003")] /// <summary> /// éè´§æ¥æ /// </summary> [SugarColumn(ColumnName = "DKA003")] public string Dka003 { get; set; } /// <summary> /// éè´§æ¶é´ /// </summary> [SugarColumn(ColumnName = "DKA004")] /// <summary> /// éè´§æ¶é´ /// </summary> [SugarColumn(ColumnName = "DKA004")] public string Dka004 { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "DKA005")] /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "DKA005")] public string Dka005 { get; set; } /// <summary> /// ä¾åºåå称 /// </summary> [SugarColumn(ColumnName = "DKA006")] /// <summary> /// ä¾åºåå称 /// </summary> [SugarColumn(ColumnName = "DKA006")] public string Dka006 { get; set; } /// <summary> /// é¨é¨ /// </summary> [SugarColumn(ColumnName = "DKA007")] /// <summary> /// é¨é¨ /// </summary> [SugarColumn(ColumnName = "DKA007")] public string Dka007 { get; set; } /// <summary> /// å®¡æ ¸è /// </summary> [SugarColumn(ColumnName = "DKA008")] /// <summary> /// å®¡æ ¸è /// </summary> [SugarColumn(ColumnName = "DKA008")] public string Dka008 { get; set; } /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "DKA009")] /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "DKA009")] public string Dka009 { get; set; } /// <summary> /// éè´§ç¶æï¼0æ空为æªéè´§ï¼1为已éå® /// </summary> [SugarColumn(ColumnName = "DKA010")] /// <summary> /// éè´§ç¶æï¼0æ空为æªéè´§ï¼1为已éå® /// </summary> [SugarColumn(ColumnName = "DKA010")] public string Dka010 { get; set; } /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "ERPID")] /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "ERPID")] public decimal? Erpid { get; set; } /// <summary> /// ä¿ç®¡åç¼ç /// </summary> [SugarColumn(ColumnName = "DKA011")] /// <summary> /// ä¿ç®¡åç¼ç /// </summary> [SugarColumn(ColumnName = "DKA011")] public string Dka011 { get; set; } /// <summary> /// éªæ¶åç¼ç /// </summary> [SugarColumn(ColumnName = "DKA012")] /// <summary> /// éªæ¶åç¼ç /// </summary> [SugarColumn(ColumnName = "DKA012")] public string Dka012 { get; set; } /// <summary> /// æ¯å¦æ¨é红åå ¥åº1-æ¨éï¼0-æªæ¨é /// </summary> [SugarColumn(ColumnName = "DKA013")] /// <summary> /// æ¯å¦æ¨é红åå ¥åº1-æ¨éï¼0-æªæ¨é /// </summary> [SugarColumn(ColumnName = "DKA013")] public decimal? Dka013 { get; set; } } StandardPda/MES.Service/Modes/VLineUser.cs
@@ -1,23 +1,22 @@ using SqlSugar; namespace MES.Service.Modes namespace MES.Service.Modes; /// <summary> /// 产线ä¸ç¨æ·å¯¹ç § /// </summary> [SugarTable("V_LINE_USER")] public class VLineUser { /// <summary> /// 产线ä¸ç¨æ·å¯¹ç § ///</summary> [SugarTable("V_LINE_USER")] public class VLineUser { /// <summary> /// 产线å ///</summary> [SugarColumn(ColumnName = "LINE_NO")] public string? LineNo { get; set; } /// 产线å /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string? LineNo { get; set; } /// <summary> /// ç¨æ·å ///</summary> [SugarColumn(ColumnName = "FNAME")] public string? FName { get; set; } } /// <summary> /// ç¨æ·å /// </summary> [SugarColumn(ColumnName = "FNAME")] public string? FName { get; set; } } StandardPda/MES.Service/Modes/VMesQaItemsDetect01.cs
@@ -1,47 +1,38 @@ using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using SqlSugar; namespace MES.Service.Modes namespace MES.Service.Modes; [SugarTable("V_MES_QA_ITEMS_DETECT_01")] public class VMesQaItemsDetect01 { /// <summary> /// 对åºè§å¾ä¸ç id å段 /// </summary> [SugarColumn(ColumnName = "id")] public int Id { get; set; } [SugarTable("V_MES_QA_ITEMS_DETECT_01")] public class VMesQaItemsDetect01 { /// <summary> /// 对åºè§å¾ä¸ç id å段 /// </summary> [SugarColumn(ColumnName = "id")] public int Id { get; set; } /// <summary> /// 对åºè§å¾ä¸ç ITEM_ID å段 /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public string ItemId { get; set; } /// <summary> /// 对åºè§å¾ä¸ç ITEM_ID å段 /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public string ItemId { get; set; } /// <summary> /// 对åºè§å¾ä¸ç SUPP_NO å段 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// 对åºè§å¾ä¸ç SUPP_NO å段 /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// 对åºè§å¾ä¸ç first å段 /// </summary> [SugarColumn(ColumnName = "first")] public int First { get; set; } /// <summary> /// 对åºè§å¾ä¸ç first å段 /// </summary> [SugarColumn(ColumnName = "first")] public int First { get; set; } /// <summary> /// 对åºè§å¾ä¸ç NEW_FNG_DESC å段 /// </summary> [SugarColumn(ColumnName = "NEW_FNG_DESC")] public string NewFngDesc { get; set; } } } /// <summary> /// 对åºè§å¾ä¸ç NEW_FNG_DESC å段 /// </summary> [SugarColumn(ColumnName = "NEW_FNG_DESC")] public string NewFngDesc { get; set; } } StandardPda/MES.Service/Modes/Womcaa.cs
@@ -3,39 +3,37 @@ namespace MES.Service.Modes; /// <summary> /// å·¥å表 /// ä»»å¡å表 /// </summary> [SugarTable("WOMCAA")] public class Womcaa { /// <summary> /// èªå¢å SEQ_AOI /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_CAA")] public decimal? Id { get; set; } [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// ERPID /// ç产订åè¡å ç /// </summary> [SugarColumn(ColumnName = "ERPID")] public decimal? Erpid { get; set; } /// <summary> /// åå· /// åæ®ç¼å· /// </summary> [SugarColumn(ColumnName = "CAA001")] public string? Caa001 { get; set; } /// <summary> /// åæ®ç±»å 1ãç´æ¥å ¥åº-æ®éç产 SCDD03_SYS2ãç´æ¥å ¥åº-è¿å·¥ç产 SCDD04_SYS3ãå·¥åºæ±æ¥-æ®éç产 /// SCDD01_SYS4ãå·¥åºæ±æ¥-è¿å·¥ç产 SCDD02_SYS /// åæ®ç±»å /// </summary> [SugarColumn(ColumnName = "CAA004")] public string? Caa004 { get; set; } /// <summary> /// å¼åæ¥æ /// 计åä¸è¾¾æ¥æ /// </summary> [SugarColumn(ColumnName = "CAA005")] public string? Caa005 { get; set; } @@ -65,7 +63,7 @@ public string? Caa011 { get; set; } /// <summary> /// æ°é /// å·¥åæ°é /// </summary> [SugarColumn(ColumnName = "CAA012")] public decimal? Caa012 { get; set; } @@ -95,25 +93,25 @@ public decimal? Caa017 { get; set; } /// <summary> /// ERPæºåID /// ERPç产订åID /// </summary> [SugarColumn(ColumnName = "CAA018")] public decimal? Caa018 { get; set; } /// <summary> /// ERPæºåè¡å· /// ERPç产订ååºå· /// </summary> [SugarColumn(ColumnName = "CAA019")] public string? Caa019 { get; set; } public decimal? Caa019 { get; set; } /// <summary> /// ERPæºååå·(ä»»å¡åå·) /// ERPç产订ååå· /// </summary> [SugarColumn(ColumnName = "CAA020")] public string? Caa020 { get; set; } /// <summary> /// å·¥ä½è½¦é´ /// çäº§è½¦é´ /// </summary> [SugarColumn(ColumnName = "CAA021")] public string? Caa021 { get; set; } @@ -143,7 +141,7 @@ public decimal? Caa022 { get; set; } /// <summary> /// ç¶æ å®å·¥ï¼æªå®å·¥ /// ä¸å¡ç¶æ /// </summary> [SugarColumn(ColumnName = "CAA023")] public string? Caa023 { get; set; } @@ -233,7 +231,7 @@ public string? SrcBillType { get; set; } /// <summary> /// æºåç¼å· /// æºåç¼ç /// </summary> [SugarColumn(ColumnName = "SRC_BILL_NO")] public string? SrcBillNo { get; set; } @@ -275,18 +273,6 @@ public string? SrcSplitBillno { get; set; } /// <summary> /// å®¢æ· /// </summary> [SugarColumn(ColumnName = "F_ZSXG_KH")] public string? F_ZSXG_KH { get; set; } /// <summary> /// è¦è´§æ¥æ /// </summary> [SugarColumn(ColumnName = "F_ZJXF_YHRQ")] public string? F_ZJXF_YHRQ { get; set; } /// <summary> /// ç产ç»ç» /// </summary> [SugarColumn(ColumnName = "PRD_ORG")] @@ -314,7 +300,49 @@ /// ç»æ¡æ è¯ /// </summary> [SugarColumn(ColumnName = "JA_BS")] public string? JaBs { get; set; } public decimal? JaBs { get; set; } /// <summary> /// æ§ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "F_WWC_BASEPROPERTY")] public string? FWwcBaseproperty { get; set; } /// <summary> /// 计åå®å·¥æºå¸¦æ¥æ /// </summary> [SugarColumn(ColumnName = "F_WWC_DATETIME")] public DateTime? FWwcDatetime { get; set; } /// <summary> /// çäº§å ¥åºæ¥æ /// </summary> [SugarColumn(ColumnName = "F_WWC_SCRKRQ")] public DateTime? FWwcScrkrq { get; set; } /// <summary> /// å·¥æ¶ /// </summary> [SugarColumn(ColumnName = "FGS")] public decimal? Fgs { get; set; } /// <summary> /// äº§çº¿äººæ° /// </summary> [SugarColumn(ColumnName = "F_WWC_DECIMAL")] public decimal? FWwcDecimal { get; set; } /// <summary> /// çº¿å« /// </summary> [SugarColumn(ColumnName = "F_WWC_XB")] public string? FWwcXb { get; set; } /// <summary> /// éå®å /// </summary> [SugarColumn(ColumnName = "F_WWC_BASE")] public string? FWwcBase { get; set; } /// <summary> /// ä¿®æ¹æ è¯ @@ -323,118 +351,32 @@ public decimal? IsXg { get; set; } /// <summary> /// 1ï¼æ°å¢ï¼2ï¼åæ´ /// </summary> [SugarColumn(ColumnName = "TYPEA")] public string? Typea { get; set; } /// <summary> /// ç产éç¥å ï¼æ²å°æ°å¢ï¼ /// </summary> [SugarColumn(ColumnName = "WR_F_SCDD_SCTZD")] public string? WR_F_SCDD_SCTZD { get; set; } /// <summary> /// åå· ï¼æ²å°æ°å¢ï¼ /// </summary> [SugarColumn(ColumnName = "WR_F_SCDD_XH")] public string? WR_F_SCDD_XH { get; set; } /// <summary> /// å¤æ³¨(表ä½) /// </summary> [SugarColumn(ColumnName = "BTBZ")] public string? BTBZ { get; set; } /// <summary> /// 计å确认æ¶é´ï¼æ§è¡æ¥æï¼ --å§å¤ /// </summary> [SugarColumn(ColumnName = "PLANCONFIRMATION")] public string? PLANCONFIRMATION { get; set; } /// <summary> /// ERPç产订åID --å§å¤ /// </summary> [SugarColumn(ColumnName = "FSUBID")] public string? FSUBID { get; set; } /// <summary> /// ERPç产订ååºå· --å§å¤ /// </summary> [SugarColumn(ColumnName = "FSUBBILLNOSEQ")] public string? FSUBBILLNOSEQ { get; set; } /// <summary> /// ERPç产订ååå· --å§å¤ /// </summary> [SugarColumn(ColumnName = "FSUBBILLNO")] public string? FSUBBILLNO { get; set; } /// <summary> /// éæ±æ¥æº --å§å¤ /// </summary> [SugarColumn(ColumnName = "FREQSRC")] public string? FREQSRC { get; set; } /// <summary> /// æºæå订åè¡å· --å§å¤ /// </summary> [SugarColumn(ColumnName = "SRCSPLITSEQ")] public string? SRCSPLITSEQ { get; set; } /// <summary> /// ERPå§å¤è®¢ååå½å ç -- å§å¤ /// </summary> [SugarColumn(ColumnName = "FSUBENTRYID")] public string? FSUBENTRYID { get; set; } /// <summary> /// ERPå§å¤è®¢ååå½å ç -- å§å¤ /// å§å¤éè´è®¢å /// </summary> [SugarColumn(ColumnName = "FPURORDERNO")] public string? FPURORDERNO { get; set; } public string? Fpurorderno { get; set; } /// <summary> /// éè´è®¢åè¡å· -- å§å¤ /// å§å¤éè´è®¢åè¡å· /// </summary> [SugarColumn(ColumnName = "FPURORDERENTRYSEQ")] public string? FPURORDERENTRYSEQ { get; set; } public decimal? Fpurorderentryseq { get; set; } /// <summary> /// åºæ¬åä½å ¥åºæ°é -- å§å¤ /// å§å¤è®¢ååå½å ç /// </summary> [SugarColumn(ColumnName = "FBASESTOCKINQTY")] public decimal? FBASESTOCKINQTY { get; set; } [SugarColumn(ColumnName = "FSUBENTRYID")] public decimal? Fsubentryid { get; set; } /// <summary> /// åºæ¬åä½æªå ¥åºæ°é -- å§å¤ /// å§å¤å ¥åºæ° /// </summary> [SugarColumn(ColumnName = "FBASENOSTOCKINQTY")] public decimal? FBASENOSTOCKINQTY { get; set; } [SugarColumn(ColumnName = "FSTOCKINQTY")] public decimal? Fstockinqty { get; set; } /// <summary> /// å ¥åºè´§ä¸» -- å§å¤ /// å§å¤æªå ¥åºæ° /// </summary> [SugarColumn(ColumnName = "FINSTOCKOWNERID")] public string? FINSTOCKOWNERID { get; set; } /// <summary> /// ç产éç¥å -- å§å¤ /// </summary> [SugarColumn(ColumnName = "F_WWDD_SCTZD")] public string? F_WWDD_SCTZD { get; set; } /// <summary> /// åå· -- å§å¤ /// </summary> [SugarColumn(ColumnName = "F_WWDD_XH")] public string? F_WWDD_XH { get; set; } /// <summary> /// BOMå¤æ³¨ -- å§å¤ /// </summary> [SugarColumn(ColumnName = "F_XIFG_TEXT_TZK")] public string? F_XIFG_TEXT_TZK { get; set; } [SugarColumn(ColumnName = "FNOSTOCKINQTY")] public decimal? Fnostockinqty { get; set; } } StandardPda/MES.Service/Modes/Womcab.cs
@@ -3,7 +3,7 @@ namespace MES.Service.Modes; /// <summary> /// å·¥åå表 /// ä»»å¡åç©æ表 /// </summary> [SugarTable("WOMCAB")] public class Womcab @@ -11,18 +11,17 @@ /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_CAB")] public decimal? Id { get; set; } [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// ERPID /// ç产ç¨ææ¸ åè¡å ç /// </summary> [SugarColumn(ColumnName = "ERPID")] public decimal? Erpid { get; set; } /// <summary> /// åå· /// å·¥ååå· /// </summary> [SugarColumn(ColumnName = "CAB001")] public string? Cab001 { get; set; } @@ -73,16 +72,16 @@ /// æ¯å¦æ¿æ /// </summary> [SugarColumn(ColumnName = "CAB014")] public string? Cab014 { get; set; } public decimal? Cab014 { get; set; } /// <summary> /// PID /// ç产订åè¡å ç /// </summary> [SugarColumn(ColumnName = "PID")] public decimal? Pid { get; set; } /// <summary> /// ERP头ID /// ç产订åè¡å ç /// </summary> [SugarColumn(ColumnName = "EID")] public decimal? Eid { get; set; } @@ -136,7 +135,7 @@ public string? IssueType { get; set; } /// <summary> /// ä¾åºç±»å /// ä¾åºç±»å Céè´ Zèªå¶ Wå§å¤ /// </summary> [SugarColumn(ColumnName = "SUPPLY_TYPE")] public string? SupplyType { get; set; } @@ -157,112 +156,47 @@ /// åºå®æè /// </summary> [SugarColumn(ColumnName = "SCRAPQTY")] public decimal? SCRAPQTY { get; set; } public decimal? Scrapqty { get; set; } /// <summary> /// åå¨æèç /// </summary> [SugarColumn(ColumnName = "SCRAPRATE")] public decimal? SCRAPRATE { get; set; } public decimal? Scraprate { get; set; } /// <summary> /// åºåæ°é /// éå®è®¢åå· /// </summary> [SugarColumn(ColumnName = "Must_Qty")] public decimal? MustQty { get; set; } [SugarColumn(ColumnName = "SALES_ORDER")] public string? SalesOrder { get; set; } /// <summary> /// é¡¹æ¬¡å· /// éæ±åæ® /// </summary> [SugarColumn(ColumnName = "FREPLACEGROUP")] public int? Freplacegroup { get; set; } [SugarColumn(ColumnName = "F_WWC_TEXT1")] public string? FWwcText1 { get; set; } /// <summary> /// 使ç¨æ¯ä¾ï¼%ï¼ /// 计åå®å·¥æ¥æ /// </summary> [SugarColumn(ColumnName = "USE_RATE")] public decimal? UseRate { get; set; } [SugarColumn(ColumnName = "F_WWC_DATE")] public DateTime? FWwcDate { get; set; } /// <summary> /// æ§ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "F_WWC_BASEPROPERTY")] public string? FWwcBaseproperty { get; set; } /// <summary> /// 使ç¨æ¯ä¾ /// </summary> [SugarColumn(ColumnName = "FUSERATE")] public decimal? Fuserate { get; set; } /// <summary> /// å项类å 1æ å件 2è¿è¿ä»¶ 3æ¿ä»£ä»¶ /// </summary> [SugarColumn(ColumnName = "MATERIAL_TYPE")] public string? MaterialType { get; set; } /// <summary> /// Aï¼å建 Bï¼å®¡æ ¸ä¸ Cï¼å·²å®¡æ ¸ Dï¼éæ°å®¡æ ¸ Zï¼æå /// </summary> [SugarColumn(ColumnName = "TYPEB")] public string? Typeb { get; set; } /// <summary> /// Aï¼å建 Bï¼å®¡æ ¸ä¸ Cï¼å·²å®¡æ ¸ Dï¼éæ°å®¡æ ¸ Zï¼æå /// </summary> [SugarColumn(ColumnName = "WR_F_XIFG_BASE_QTR")] public string? WR_F_XIFG_Base_qtr { get; set; } /// <summary> /// Aï¼å建 Bï¼å®¡æ ¸ä¸ Cï¼å·²å®¡æ ¸ Dï¼éæ°å®¡æ ¸ Zï¼æå /// </summary> [SugarColumn(ColumnName = "WR_F_XIFG_BASE_83G")] public string? WR_F_XIFG_Base_83g { get; set; } /////----å§å¤æ°å¢ /// <summary> /// æ¯å¦åæè -- å§å¤æ°å¢ /// </summary> [SugarColumn(ColumnName = "FISGETSCRAP")] public string? Fisgetscrap { get; set; } /// <summary> /// æ¯å¦å ³é®ä»¶ -- å§å¤æ°å¢ /// </summary> [SugarColumn(ColumnName = "FISKEYCOMPONENT")] public string? Fiskeycomponent { get; set; } /// <summary> /// æ¨åºç»ç» -- å§å¤æ°å¢ /// </summary> [SugarColumn(ColumnName = "FSRCTRANSORGID")] public string? Fsrctransorgid { get; set; } /// <summary> /// æ¨åºä»åº -- å§å¤æ°å¢ /// </summary> [SugarColumn(ColumnName = "FSRCTRANSSTOCKID")] public string? Fsrctransstockid { get; set; } /// <summary> /// åºåç¶æ -- å§å¤æ°å¢ /// </summary> [SugarColumn(ColumnName = "FSTOCKSTATUSID")] public string? Fstockstatusid { get; set; } /// <summary> /// éæ±æ¥æ -- å§å¤æ°å¢ /// </summary> [SugarColumn(ColumnName = "FNEEDDATE")] public DateTime? Fneeddate { get; set; } /// <summary> /// é¢çç±»å -- å§å¤æ°å¢ /// </summary> [SugarColumn(ColumnName = "FRESERVETYPE")] public string? Freservetype { get; set; } /// <summary> /// ç¨ææ¸ åå¤æ³¨ -- å§å¤æ°å¢ /// </summary> [SugarColumn(ColumnName = "FMEMO")] public string? Fmemo { get; set; } /// <summary> /// ERPç产订ååå½å ç -- å§å¤æ°å¢ /// </summary> [SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")] public string? ErpProductionEntryCode { get; set; } [SugarColumn(ColumnName = "FMATERIALTYPE")] public decimal? Fmaterialtype { get; set; } } StandardPda/MES.Service/service/BasicData/MesRohInManager.cs
@@ -102,10 +102,7 @@ && s.OrgId == rohIn.FReceiveOrgId && s.TableType == "MES_SUPPLIER").First(); if (mesLinkU9 != null) { mesRohIn.Supplier = mesLinkU9.MesId; } if (mesLinkU9 != null) mesRohIn.Supplier = mesLinkU9.MesId; mesRohIn.EbelnK3id = eid; mesRohIn.BillNo = rohIn.FBillNo; @@ -203,7 +200,7 @@ RdProject = s.RdProject, ProjectPurchaser = s.ProjectPurchaser }; if (s.FDeliveryDate != null) entity.DeliveryDate = DateTime.ParseExact(s.FDeliveryDate, @@ -219,10 +216,7 @@ && x.OrgId == s.FReceiveOrgId && x.TableType == "MES_ITEMS").First(); if (mesLinkU9 != null) { entity.ItemId = mesLinkU9.MesId; } if (mesLinkU9 != null) entity.ItemId = mesLinkU9.MesId; var mesLinkU92 = Db.Queryable<MesLinkU9>() @@ -230,10 +224,7 @@ && x.OrgId == s.FReceiveOrgId && x.TableType == "MES_PROJECT").First(); if (mesLinkU92 != null) { entity.Project = mesLinkU92.MesId; } if (mesLinkU92 != null) entity.Project = mesLinkU92.MesId; return entity; }).ToList(); StandardPda/MES.Service/service/BasicData/MesStaffManager.cs
@@ -62,11 +62,8 @@ MesStaff entity) { var exists = db.Queryable<SysUser>().Any(u => u.Sid == sysUser.Sid); if (!exists) { db.Insertable(sysUser).ExecuteCommand(); } if (!exists) db.Insertable(sysUser).ExecuteCommand(); db.Deleteable<MesStaff>() .Where(s => s.Id == entity.Id) .ExecuteCommand(); @@ -78,12 +75,12 @@ } /// <summary> /// "å é¤åå·¥çæ¹æ³"è°æ´ï¼è°æ´ä¼ å ¥åæ°ï¼å°idæ¹ä¸ºMesStaffç±»ï¼å é¤ä½¿ç¨idåPositionCodeä½ä¸ºå¤æä¾æ® /// "å é¤åå·¥çæ¹æ³"è°æ´ï¼è°æ´ä¼ å ¥åæ°ï¼å°idæ¹ä¸ºMesStaffç±»ï¼å é¤ä½¿ç¨idåPositionCodeä½ä¸ºå¤æä¾æ® /// </summary> /// <remarks> /// ä¿®æ¹äººï¼æ± åéª /// ä¿®æ¹æ¥æï¼2024-12-30 /// ä¿®æ¹è¯´æï¼` /// ä¿®æ¹äººï¼æ± åéª /// ä¿®æ¹æ¥æï¼2024-12-30 /// ä¿®æ¹è¯´æï¼` /// </remarks> private bool DeleteStaff(SqlSugarScope db, SysUser sysUser, MesStaff entity) { StandardPda/MES.Service/service/BasicData/ProductionOrderManager.cs
@@ -128,7 +128,7 @@ Caa011 = erpDto.FPlanFinishDate, //ParseDateTime(erpDto.FPlanFinishDate) ?? null, PLANCONFIRMATION = erpDto.PlanConfirmation, //PLANCONFIRMATION = erpDto.PlanConfirmation, StockInlimith = erpDto .FStockInLimitH, //Convert.ToDecimal(erpDto.FStockInLimitH), @@ -140,36 +140,36 @@ Caa013 = erpDto.FBomId, //SalesOrderNo = erpDto.F_UNW_XSDDH, CreateType = erpDto.FCreateType, FSUBID = erpDto.FSUBID, FSUBBILLNOSEQ = erpDto.FSUBBILLNOSEQ, FSUBBILLNO = erpDto.FSUBBILLNO, //FSUBID = erpDto.FSUBID, //FSUBBILLNOSEQ = erpDto.FSUBBILLNOSEQ, //FSUBBILLNO = erpDto.FSUBBILLNO, SrcBillType = erpDto.FSrcBillType, SrcBillNo = erpDto.FSrcBillNo, SrcBillentryseq = erpDto.FSrcBillEntrySeq, FREQSRC = erpDto.FReqSrc, //FREQSRC = erpDto.FReqSrc, SaleOrderNo = erpDto.FSALEORDERNO, SaleOrderEntryseq = erpDto.FSaleOrderEntrySeq, ForceCloserid = erpDto.FFORCECLOSERID, CloseType = erpDto.FCloseType, SrcSplitBillno = erpDto.FDescription, SRCSPLITSEQ = erpDto.SrcSplitSeq, Erpid = Convert.ToDecimal(erpDto.FID), FSUBENTRYID = erpDto.FSUBENTRYID, FPURORDERNO = erpDto.FPurOrderNo, FPURORDERENTRYSEQ = erpDto .FPurOrderEntrySeq, //Convert.ToInt32(erpDto.FPurOrderEntrySeq), FBASESTOCKINQTY = Convert.ToDecimal(erpDto.FBaseStockInQty), FBASENOSTOCKINQTY = Convert.ToDecimal(erpDto.FBaseNoStockInQty), FINSTOCKOWNERID = erpDto.FInStockOwnerId, //SRCSPLITSEQ = erpDto.SrcSplitSeq, Erpid = Convert.ToDecimal(erpDto.FID) //FSUBENTRYID = erpDto.FSUBENTRYID, //FPURORDERNO = erpDto.FPurOrderNo, //FPURORDERENTRYSEQ = //erpDto // .FPurOrderEntrySeq, //Convert.ToInt32(erpDto.FPurOrderEntrySeq), //FBASESTOCKINQTY = Convert.ToDecimal(erpDto.FBaseStockInQty), //FBASENOSTOCKINQTY = Convert.ToDecimal(erpDto.FBaseNoStockInQty), //FINSTOCKOWNERID = erpDto.FInStockOwnerId, //PlanConfirmation = erpDto.PlanConfirmation != null // ? DateTime.ParseExact(erpDto.PlanConfirmation, // "yyyy-MM-dd HH:mm:ss", null) // : null, Typea = erpDto.TypeA, F_WWDD_SCTZD = erpDto.F_WWDD_SCTZD, F_WWDD_XH = erpDto.F_WWDD_XH, F_XIFG_TEXT_TZK = erpDto.F_XIFG_Text_tzk // Typea = erpDto.TypeA, // F_WWDD_SCTZD = erpDto.F_WWDD_SCTZD, // F_WWDD_XH = erpDto.F_WWDD_XH, // F_XIFG_TEXT_TZK = erpDto.F_XIFG_Text_tzk }; var single = base.GetSingle(it => it.Erpid == entity.Erpid); @@ -191,7 +191,7 @@ Cab001 = erpDto.FBillNo, Cab002 = erpDto.FSEQ, //Convert.ToInt32(erpDto.FSEQ), Cab003 = erpDto.FMaterialID2, MustQty = Convert.ToDecimal(erpDto.FMustQty), // MustQty = Convert.ToDecimal(erpDto.FMustQty), Cab006 = Convert.ToDecimal(erpDto.FMustQty), Cab007 = Convert.ToDecimal(erpDto.FPickedQty), PositionNo = erpDto.FPositionNO, @@ -207,28 +207,28 @@ Numerator = Convert.ToDecimal(erpDto.FNumerator), Denominator = Convert.ToDecimal(erpDto.FDenominator), Erpid = Convert.ToDecimal(erpDto.FPPOMENTRYID), Eid = Convert.ToDecimal(erpDto.FPPOMID), SCRAPQTY = Convert.ToDecimal(erpDto.FFixScrapQty), SCRAPRATE = Convert.ToDecimal(erpDto.FScrapRate), MaterialType = erpDto.FMaterialType, //Unit2 = erpDto.FUnitID3, Freplacegroup = Convert.ToInt32(erpDto.FReplaceGroup), Eid = Convert.ToDecimal(erpDto.FPPOMID) // SCRAPQTY = Convert.ToDecimal(erpDto.FFixScrapQty), // SCRAPRATE = Convert.ToDecimal(erpDto.FScrapRate), // MaterialType = erpDto.FMaterialType, // //Unit2 = erpDto.FUnitID3, // Freplacegroup = Convert.ToInt32(erpDto.FReplaceGroup), //OwnerType = erpDto.FOwnerTypeId, //Owner = erpDto.FOwnerID2, Fisgetscrap = erpDto.FISGETSCRAP, Fiskeycomponent = erpDto.FISKEYCOMPONENT, Fsrctransorgid = erpDto.FSRCTRANSORGID, Fsrctransstockid = erpDto.FSRCTRANSSTOCKID, Fstockstatusid = erpDto.FSTOCKSTATUSID, Fneeddate = erpDto.FNEEDDATE != null ? DateTime.ParseExact(erpDto.FNEEDDATE, "yyyy-MM-dd HH:mm:ss", null) : null, Freservetype = erpDto.FRESERVETYPE, Fmemo = erpDto.FMEMO, Typeb = erpDto.TypeB, ErpProductionEntryCode = erpDto.FSUBENTRYID // Fisgetscrap = erpDto.FISGETSCRAP, // Fiskeycomponent = erpDto.FISKEYCOMPONENT, // Fsrctransorgid = erpDto.FSRCTRANSORGID, // Fsrctransstockid = erpDto.FSRCTRANSSTOCKID, // Fstockstatusid = erpDto.FSTOCKSTATUSID, // Fneeddate = erpDto.FNEEDDATE != null // ? DateTime.ParseExact(erpDto.FNEEDDATE, // "yyyy-MM-dd HH:mm:ss", null) // : null, // Freservetype = erpDto.FRESERVETYPE, // Fmemo = erpDto.FMEMO, // Typeb = erpDto.TypeB, // ErpProductionEntryCode = erpDto.FSUBENTRYID }; var single = StandardPda/MES.Service/service/QC/LljService.cs
@@ -4,25 +4,20 @@ using MES.Service.Dto.service; using MES.Service.Modes; using MES.Service.util; using Microsoft.EntityFrameworkCore.Metadata.Internal; using Newtonsoft.Json; using SqlSugar; using DbType = System.Data.DbType; using System.Net.Http; using System.Threading.Tasks; namespace MES.Service.service.QC; public class LljService { private static readonly HttpClient client = new(); public (List<LtsLlj> item, int TotalCount) GetPage(XJPageResult queryObj) { if (queryObj.createUser.IsNullOrEmpty()) { return ([], 0); } if (queryObj.createUser.IsNullOrEmpty()) return ([], 0); var db = SqlSugarHelper.GetInstance(); @@ -32,18 +27,19 @@ //var itemIds = GetQaItem(db, queryObj.createUser); var pageList = db.Queryable<LtsLlj, IqcBefore, VMesQaItemsDetect01, SysUser, IqcBeforeFrom, SysUser>((a, b,d,e,f,g) => var pageList = db .Queryable<LtsLlj, IqcBefore, VMesQaItemsDetect01, SysUser, IqcBeforeFrom, SysUser>((a, b, d, e, f, g) => new JoinQueryInfos(JoinType.Left, a.ItemId == b.ItemId, JoinType.Inner, a.Id == d.Id, JoinType.Left, a.CreateBy == e.Fcode, JoinType.Left,f.Id==b.PID, JoinType.Left, f.Sid == g.Fid JoinType.Left, a.CreateBy == e.Fcode, JoinType.Left, f.Id == b.PID, JoinType.Left, f.Sid == g.Fid )) .WhereIF( StringUtil.IsNotNullOrEmpty(queryObj.result) && "æªå®æ".Equals(queryObj.result), (a, b, d) => a.FcheckResu == null ) (a, b, d) => a.FcheckResu == null) .WhereIF( StringUtil.IsNotNullOrEmpty(queryObj.result) && !"æªå®æ".Equals(queryObj.result), @@ -60,17 +56,16 @@ || a.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) || a.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower()))) .OrderByDescending((a, b, d) => a.Id) .Select((a, b, d,e,f,g) => new LtsLlj .Select((a, b, d, e, f, g) => new LtsLlj { UserName = g.Fname, FIRST=d.First, CreateUserName=e.Fname, NewFngDesc=d.NewFngDesc FIRST = d.First, CreateUserName = e.Fname, NewFngDesc = d.NewFngDesc }, true) .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount); return (pageList, totalCount); } @@ -142,7 +137,7 @@ mesQaIqcItem.ForEach(item => { string LEV = item.FcheckLevel switch var LEV = item.FcheckLevel switch { null => "" // é»è®¤å¼ , @@ -302,7 +297,7 @@ Company = "1000", FenterQty = SqlFunc.AggregateCount(b.Id), FcheckResu = a.FcheckResu, FcheckItemDesc=a.FcheckItemDesc FcheckItemDesc = a.FcheckItemDesc }).ToList(); } @@ -562,8 +557,8 @@ return SqlSugarHelper.UseTransactionWithOracle(db => { return db.Updateable<MesQaItemsDetect01>() .SetColumns(it => it.FngDesc == dto.Remarks) //SetColumnsæ¯å¯ä»¥å å ç å2个就2个å段èµå¼ .SetColumns(it => it.FngDesc == dto.Remarks) //SetColumnsæ¯å¯ä»¥å å ç å2个就2个å段èµå¼ .Where(it => it.ReleaseNo == dto.releaseNo) .ExecuteCommand(); }); @@ -655,51 +650,47 @@ throw new Exception(ex.Message); } } /// <summary> /// æå·å¾çº¸æ¥å£è¿å对象 /// </summary> public class ApiResponse { [JsonProperty("status")] public int Status { get; set; } [JsonProperty("message")] public string Message { get; set; } [JsonProperty("data")] public string[] Data { get; set; } [JsonProperty("totalCount")] public int TotalCount { get; set; } } private static readonly HttpClient client = new HttpClient(); /// <summary> /// ä»U9è·åæå·å¾çº¸å表 /// ä»U9è·åæå·å¾çº¸å表 /// </summary> /// <param name="Type">u9Noï¼u9ç©æç¼å·</param> /// <param name="U9No">typeï¼1ï¼å¾çº¸è§æ ¼ä¹¦ 2ï¼è¿ææ£éªæ件 </param> /// <returns></returns> /// <exception cref="Exception"></exception> public async Task<string[]> GetFileUrlByU9List(string Type,string U9No) public async Task<string[]> GetFileUrlByU9List(string Type, string U9No) { try { var requestUrl = $"https://erp.dream-maker.com/api/public/getFileUrlByU9No?u9No={Uri.EscapeDataString(U9No)}&type={Type}"; var requestUrl = $"https://erp.dream-maker.com/api/public/getFileUrlByU9No?u9No={Uri.EscapeDataString(U9No)}&type={Type}"; var response = await client.GetAsync(requestUrl); response.EnsureSuccessStatusCode(); // æ£æ¥HTTPç¶æç var responseContent = await response.Content.ReadAsStringAsync(); var result = JsonConvert.DeserializeObject<ApiResponse>(responseContent); var result = JsonConvert.DeserializeObject<ApiResponse>(responseContent); if (result.Status == 0 && result.Data != null) { return result.Data; } else { return null; } if (result.Status == 0 && result.Data != null) return result.Data; return null; } catch (Exception ex) { throw new Exception(ex.Message); } } /// <summary> /// æå·å¾çº¸æ¥å£è¿å对象 /// </summary> public class ApiResponse { [JsonProperty("status")] public int Status { get; set; } [JsonProperty("message")] public string Message { get; set; } [JsonProperty("data")] public string[] Data { get; set; } [JsonProperty("totalCount")] public int TotalCount { get; set; } } } StandardPda/MES.Service/service/QC/RKJService.cs
@@ -319,15 +319,10 @@ .Where(o => o.Id == detail.Gid) .First(); if (qsItemOqcReq == null) { throw new Exception("该æ£éªåä¸åå¨ï¼è¯·åå°å ¥åºæ£å表éæ°æ¥ç"); } if (qsItemOqcReq == null) throw new Exception("该æ£éªåä¸åå¨ï¼è¯·åå°å ¥åºæ£å表éæ°æ¥ç"); if (!string.IsNullOrEmpty(qsItemOqcReq.FcheckResu)) { throw new Exception("该æ£éªåå·²" + qsItemOqcReq.FcheckResu + "ï¼ä¸è¿è¡ä¿®æ¹ç»æ"); } var oracle = SqlSugarHelper.UseTransactionWithOracle(db => { @@ -439,12 +434,12 @@ } /// <summary> /// å½æ£éªåä¸åæ ¼æ¶ï¼ /// åæ¶mes_inv_item_barcodes çæ¥å·¥æ è¯ WORK_FLG /// womdaa å·²ç产é DAA011å åæ¡ç æ¥å·¥æ°é /// MES_SCGD_GX æ£éªæ è¯ CHECK_FLAGï¼('â','Ã') /// éè¿mes_inv_item_in_c_details2çMES_SCGD_GX_IDè¿æ¥ ///</summary> /// å½æ£éªåä¸åæ ¼æ¶ï¼ /// åæ¶mes_inv_item_barcodes çæ¥å·¥æ è¯ WORK_FLG /// womdaa å·²ç产é DAA011å åæ¡ç æ¥å·¥æ°é /// MES_SCGD_GX æ£éªæ è¯ CHECK_FLAGï¼('â','Ã') /// éè¿mes_inv_item_in_c_details2çMES_SCGD_GX_IDè¿æ¥ /// </summary> private void setBarCodes(string? FcheckResu, QsItemOqcItemDetail detail, SqlSugarClient db) { @@ -462,10 +457,7 @@ }) .ToList(); if (oqcReqList.Count <= 0) { return; } if (oqcReqList.Count <= 0) return; var qsItemOqcReq = oqcReqList.First(); // è·å第ä¸ä¸ªå ç´ @@ -499,7 +491,7 @@ .ExecuteCommand(); if (count <= 0) return; //åæ¶mes_inv_item_barcodes çæ¥å·¥æ è¯ WORK_FLG 使ç¨æ¡ç var executeCommand = db.Updateable<MesInvItemBarcodes>() .SetColumns(a => a.WorkFlg == 1) @@ -507,13 +499,11 @@ .ExecuteCommand(); if (executeCommand > 0) { //womdaa å·²ç产é DAA011å åæ¡ç æ¥å·¥æ°é db.Updateable<Womdaa>() .SetColumns(b => b.Daa011 == b.Daa011 + sumQty) .Where(b => b.Daa001 == qsItemOqcReq.Daa001) .ExecuteCommand(); } } else if ("ä¸åæ ¼".Equals(FcheckResu)) { @@ -530,13 +520,11 @@ .ExecuteCommand(); if (executeCommand > 0) { //womdaa å·²ç产é DAA011å åæ¡ç æ¥å·¥æ°é db.Updateable<Womdaa>() .SetColumns(b => b.Daa011 == b.Daa011 - sumQty) .Where(b => b.Daa001 == qsItemOqcReq.Daa001) .ExecuteCommand(); } } } @@ -609,7 +597,7 @@ c.Factory == ca.Factory, JoinType.Left, c.Id == m.ItemInId && a.ItemNo == m.ItemNo, JoinType.Left, da.Daa001 == c.RbillNo, JoinType.Left, da.Daa015 == z.LineNo//, JoinType.Left, da.Daa015 == z.LineNo //, //JoinType.Left,c.Bgr == d.UserNo )) // .WhereIF(lineNo != null && lineNo.Length > 0, @@ -629,8 +617,11 @@ //å çéæ¡ä»¶,æ ¹æ®ä¾åºåï¼ç©æç¼ç ï¼ç©æå称æç´¢ //.WhereIF(queryObj.SearchValue!=null && queryObj.SearchValue!="", (a) => a.SuppName == queryObj.SearchValue|| a.ItemName == queryObj.SearchValue || a.ItemNo == queryObj.SearchValue ) .WhereIF(queryObj.SearchValue != null && queryObj.SearchValue != "", (a, b, c, ca, m, da, z) => b.ItemName.ToLower().Contains(queryObj.SearchValue.ToLower()) || a.ItemNo.ToLower().Contains(queryObj.SearchValue.ToLower())) (a, b, c, ca, m, da, z) => b.ItemName.ToLower() .Contains(queryObj.SearchValue.ToLower()) || a.ItemNo.ToLower() .Contains(queryObj.SearchValue.ToLower())) .Select((a, b, c, ca, m, da, z) => new QsItemOqcReq { BillNo = a.BillNo, @@ -650,7 +641,7 @@ ItemInId = m.ItemInId, Daa015 = da.Daa015, LineNo = c.LineNo, Quantity = m.Quantity, Quantity = m.Quantity //Bgr = d.UserName }) .OrderBy(a => a.CreateDate, OrderByType.Desc) @@ -727,15 +718,10 @@ .Where(o => o.Id == detail.Gid) .First(); if (qsItemOqcReq == null) { throw new Exception("该æ£éªåä¸åå¨ï¼è¯·åå°å ¥åºæ£å表éæ°æ¥ç"); } if (qsItemOqcReq == null) throw new Exception("该æ£éªåä¸åå¨ï¼è¯·åå°å ¥åºæ£å表éæ°æ¥ç"); if (!string.IsNullOrEmpty(qsItemOqcReq.FcheckResu)) { throw new Exception("该æ£éªåå·²" + qsItemOqcReq.FcheckResu + "ï¼ä¸è¿è¡ä¿®æ¹ç»æ"); } var withOracle = SqlSugarHelper.UseTransactionWithOracle(db => { @@ -852,13 +838,15 @@ private bool isRk(int? gid) { var db = SqlSugarHelper.GetInstance(); return db.Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails2,MesInvItemStocks>( (a, b, c,d) => new JoinQueryInfos( return db .Queryable<QsItemOqcReq, MesInvItemIns, MesInvItemInCDetails2, MesInvItemStocks>( (a, b, c, d) => new JoinQueryInfos( JoinType.Inner, a.BillNo == b.BillNo, JoinType.Inner, b.Id == c.ItemInId, JoinType.Inner,c.ItemBarcode == d.ItemBarcode JoinType.Inner, c.ItemBarcode == d.ItemBarcode )) .Where((a, b, c,d) => a.Id == gid) .Where((a, b, c, d) => a.Id == gid) .Count() > 0; } } StandardPda/MES.Service/service/WomcaaManager.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,184 @@ using MES.Service.DB; using MES.Service.Dto.webApi; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service; public class WomcaaManager : Repository<Womcaa> { private readonly WomcabManager _womcabManager = new(); public bool SaveList(List<ErpWOM> rohIns) { var result = rohIns.Select(Save).ToList(); return result.All(b => b); } public bool Save(ErpWOM wom) { var womErpCaa = wom.ErpCaa; var mesWomcaa = MapErpCAAtoWomcaa(womErpCaa); var mesWomcabs = MapErpCABtoWomcab(wom.ErpCabs); return UseTransaction(db => { switch (womErpCaa.Type) { case "3": return UpdateData(db, mesWomcaa, mesWomcabs) ? 1 : 0; case "2": case "4": case "5": return SaveOrUpdateData(db, mesWomcaa, mesWomcabs) ? 1 : 0; default: throw new NotImplementedException( $"typeç±»å为{womErpCaa.Type}çä¸åå¨"); } }) > 0; } private bool SaveOrUpdateData(SqlSugarScope db, Womcaa mesWomcaa, List<Womcab> mesWomcabs) { if (mesWomcaa.Id != null) base.DeleteById(mesWomcaa.Id); if (mesWomcabs.Count > 0) db.Deleteable<Womcab>() .Where(s => s.Eid == mesWomcaa.Erpid).ExecuteCommand(); var orUpdate = db.Insertable(mesWomcaa) .IgnoreColumns(true).ExecuteCommand() > 0; var baOrUpdate = db.Insertable(mesWomcabs).PageSize(1) .IgnoreColumnsNull() .ExecuteCommand() > 0; if (orUpdate && baOrUpdate) return true; throw new NotImplementedException("æ´æ°å¤±è´¥"); } private bool UpdateData(SqlSugarScope db, Womcaa mesWomcaa, List<Womcab> mesWomcabs) { var decimals = mesWomcabs.Select(s => s.Id).ToArray(); var update = base.DeleteById(mesWomcaa.Id); var insertOrUpdate = db .Deleteable<Womcab>().In(decimals) .ExecuteCommand() > 0; if (update && insertOrUpdate) return true; throw new NotImplementedException("æ´æ°å¤±è´¥"); } private Womcaa MapErpCAAtoWomcaa(ErpCAA dto) { var entity = new Womcaa { Erpid = Convert.ToInt32(dto.Id), Caa001 = dto.FBillNo, Caa021 = dto.FWorkShopID, RoutingId = dto.FRoutingId, WorkShopId = dto.FREMWorkShopId, DepotCode = dto.FStockId, CreateDate = dto.FDate, Caa004 = dto.FBillType, Caa023 = dto.FStatus, Caa006 = dto.FMaterialId, Caa009 = dto.FUnitId, Caa012 = !string.IsNullOrEmpty(dto.FQty) ? Convert.ToDecimal(dto.FQty) : null, WorkGroupId = dto.FWorkGroupId, PlanId = dto.FPlannerID, Caa010 = dto.FPlanStartDate, Caa011 = dto.FPlanFinishDate, Caa005 = dto.FConveyDate, StockInlimith = dto.FStockInLimitH, StockInlimitl = dto.FStockInLimitL, Mtono = dto.FMTONO, Lot = dto.FLot, Caa013 = dto.FBomId, CreateType = dto.FCreateType, Caa018 = !string.IsNullOrEmpty(dto.PLAN_ID) ? Convert.ToInt32(dto.PLAN_ID) : null, Caa019 = Convert.ToInt32(dto.PLAN_SEQ), Caa020 = dto.PLAN_NUM, SrcBillType = dto.FSrcBillType, SrcBillNo = dto.FSrcBillNo, SrcBillentryseq = dto.FSrcBillEntrySeq, SaleOrderNo = dto.FSaleOrderNo, SaleOrderEntryseq = dto.FSaleOrderEntrySeq, ForceCloserid = dto.FForceCloserId, CloseType = dto.FCloseType, SrcSplitBillno = dto.FSrcSplitBillNo, Caa016 = dto.FDescription, //BTBZ = dto.BTBZ, PrdOrg = dto.FPrdOrgId, TrustOrg = dto.FEnTrustOrgId //Typea = dto.TypeA }; var single = base.GetSingle(it => it.Erpid == entity.Erpid); if (single != null) entity.Id = single.Id; return entity; } private List<Womcab> MapErpCABtoWomcab(List<ErpCAB> dtoList) { var womcabList = new List<Womcab>(); foreach (var dto in dtoList) { var womcab = new Womcab { Erpid = Convert.ToDecimal(dto.ID), Cab001 = dto.FBillNo, Cab002 = dto.FSeq, Cab003 = dto.FMaterialID, Cab006 = Convert.ToDecimal(dto.FNeedQty), //MustQty = Convert.ToDecimal(dto.FMustQty), Cab007 = Convert.ToDecimal(dto.FPickedQty), PositionNo = dto.FPositionNO, SupplyOrganization = dto.FChildSupplyOrgId, IssuingOrganization = dto.FSupplyOrg, OwnerId = dto.FOwnerID, Mtono = dto.FMTONO, Lot = dto.FLot, DepotCode = dto.FStockID, IssueType = dto.FIssueType, Cab009 = dto.FUnitID, SupplyType = dto.FSupplyType, Cab012 = Convert.ToDecimal(dto.FStdQty), // Freplacegroup = Convert.ToInt32(dto.FReplaceGroup), // UseRate = Convert.ToDecimal(dto.FUseRate), // MaterialType = dto.FMaterialType, Cab014 = Convert.ToInt32(dto.FIsKeyItem), Numerator = Convert.ToDecimal(dto.FNumerator), Denominator = Convert.ToDecimal(dto.FDenominator), Pid = Convert.ToDecimal(dto.FID), Eid = Convert.ToDecimal(dto.FID) // SCRAPQTY = Convert.ToDecimal(dto.FFixScrapQty), // SCRAPRATE = Convert.ToDecimal(dto.FScrapRate), // Typeb = dto.TypeB, // WR_F_XIFG_Base_qtr = dto.F_XIFG_Base_qtr, // WR_F_XIFG_Base_83g = dto.F_XIFG_Base_83g }; var entity = Db.Queryable<Womcab>() .Where(s => s.Erpid == womcab.Erpid).Single(); if (entity != null) womcab.Id = entity.Id; womcabList.Add(womcab); } return womcabList; } } StandardPda/MES.Service/service/WomcabManager.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,8 @@ using MES.Service.DB; using MES.Service.Modes; namespace MES.Service.service; public class WomcabManager : Repository<Womcab> { }
