MES.Service/Dto/service/RKJDaa001.cs
@@ -17,9 +17,8 @@ [SugarColumn(ColumnName = "ITEM_SNAME")] public string? ItemName { get; set; } [SugarColumn(ColumnName = "LOT_NO")] public string? LotNo { get; set; } [SugarColumn(ColumnName = "LOT_NO")] public string? LotNo { get; set; } // 订åæ°é [SugarColumn(ColumnName = "QUANTITY")] MES.Service/Modes/LtsLlj.cs
@@ -8,152 +8,152 @@ [SugarTable("LTS_LLJ")] public class LtsLlj { /// <summary> /// </summary> [SugarColumn(ColumnName = "Id")] /// <summary> /// </summary> [SugarColumn(ColumnName = "Id")] public decimal? Id { get; set; } /// <summary> /// å®¡æ ¸æ è¯ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG")] /// <summary> /// å®¡æ ¸æ è¯ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG")] public decimal? Modify1Flag { get; set; } /// <summary> /// éæ£æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] /// <summary> /// éæ£æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// å¤çæ¹æ³ /// </summary> [SugarColumn(ColumnName = "FNG_HANDLE")] /// <summary> /// å¤çæ¹æ³ /// </summary> [SugarColumn(ColumnName = "FNG_HANDLE")] public string FngHandle { get; set; } /// <summary> /// ç©æçæ¬ /// </summary> [SugarColumn(ColumnName = "FVERSION")] /// <summary> /// ç©æçæ¬ /// </summary> [SugarColumn(ColumnName = "FVERSION")] public decimal? Fversion { get; set; } /// <summary> /// å¤æ³¨ä¿¡æ¯ /// </summary> [SugarColumn(ColumnName = "LOT_NO1")] /// <summary> /// å¤æ³¨ä¿¡æ¯ /// </summary> [SugarColumn(ColumnName = "LOT_NO1")] public string LotNo1 { get; set; } /// <summary> /// 转æ¢æ°é /// </summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] /// <summary> /// 转æ¢æ°é /// </summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] public string FcovertQty { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } /// <summary> /// ä¾åºåç¼ç /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// ä¾åºåç¼ç /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] /// <summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } /// <summary> /// éè´æ°é /// </summary> [SugarColumn(ColumnName = "FBATCH_QTY")] /// <summary> /// éè´æ°é /// </summary> [SugarColumn(ColumnName = "FBATCH_QTY")] public string FbatchQty { get; set; } /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// æ£éªäººå /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] /// <summary> /// æ£éªäººå /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } /// <summary> /// ä¸è¯æè¿° /// </summary> [SugarColumn(ColumnName = "FNG_DESC")] /// <summary> /// ä¸è¯æè¿° /// </summary> [SugarColumn(ColumnName = "FNG_DESC")] public string FngDesc { 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 string CreateDate { get; set; } /// <summary> /// æ¯å¦æ¥æ /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] /// <summary> /// æ¯å¦æ¥æ /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] public short? UrgentFlag { get; set; } /// <summary> /// ç©æå称 /// </summary> [SugarColumn(ColumnName = "ITEM_NAME")] /// <summary> /// ç©æå称 /// </summary> [SugarColumn(ColumnName = "ITEM_NAME")] public string ItemName { get; set; } /// <summary> /// æ£éªç±»å /// </summary> [SugarColumn(ColumnName = "QATYPE")] /// <summary> /// æ£éªç±»å /// </summary> [SugarColumn(ColumnName = "QATYPE")] public string Qatype { get; set; } /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "DATE_01")] /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "DATE_01")] public string Date01 { get; set; } /// <summary> /// ä¾åºåå称 /// </summary> [SugarColumn(ColumnName = "SUPP_NAME")] /// <summary> /// ä¾åºåå称 /// </summary> [SugarColumn(ColumnName = "SUPP_NAME")] public string SuppName { get; set; } /// <summary> /// ç©æè§æ ¼ /// </summary> [SugarColumn(ColumnName = "ITEM_MODEL")] /// <summary> /// ç©æè§æ ¼ /// </summary> [SugarColumn(ColumnName = "ITEM_MODEL")] public string ItemModel { get; set; } /// <summary> /// åºåæ°é /// </summary> [SugarColumn(ColumnName = "KC_QTY")] /// <summary> /// åºåæ°é /// </summary> [SugarColumn(ColumnName = "KC_QTY")] public decimal? KcQty { get; set; } /// <summary> /// åæ®ç¶æ /// </summary> [SugarColumn(ColumnName = "STATUS")] /// <summary> /// åæ®ç¶æ /// </summary> [SugarColumn(ColumnName = "STATUS")] public string STATUS { get; set; } /// <summary> /// å§å¤æ è¯ï¼0ï¼éè´ ã1ï¼å§å¤ï¼ /// </summary> [SugarColumn(ColumnName = "F_TYPE")] /// <summary> /// å§å¤æ è¯ï¼0ï¼éè´ ã1ï¼å§å¤ï¼ /// </summary> [SugarColumn(ColumnName = "F_TYPE")] public int Ftype { get; set; } } 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; } } 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; } } 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; }
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,358 @@ using SqlSugar; namespace MES.Service.Modes; /// <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; } /// <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> /// 客æ·ç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </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 = "QUANTITY")] public decimal? Quantity { 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> /// å建人 /// </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 = "LASTUPDATE_BY")] public string LastupdateBy { 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> /// æ¬å¸ç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { 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> /// 客æ·ç¼ç /// </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_QTY")] public decimal? CheckQty { 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> /// ä»åºç¼ç /// </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 = "REMARK")] public string Remark { 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 = "USE_QTY")] public decimal? UseQty { 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 = "SPOSTION")] public decimal? Spostion { 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 = "UNIT")] public string Unit { 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 = "LOT_DATE")] public string LotDate { 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 = "FACTORY")] public string Factory { 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 = "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_SECTION_ID")] public decimal? DepotSectionId { 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 = "VGBEL")] public string Vgbel { 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 = "EBELN_LINE_NO")] public decimal? EbelnLineNo { 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 = "BOARD_STYLE")] public string BoardStyle { 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 = "SUPP_NO")] public string SuppNo { 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; } } 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; } } MES.Service/Modes/MesInvItemMoves.cs
@@ -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; } } 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; } } MES.Service/Modes/MesQaIqc.cs
@@ -8,78 +8,78 @@ [SugarTable("Mes_Qa_Iqc")] public class MesQaIqc { /// <summary> /// æ¥æ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// æ¥æ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// æ¥æ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] /// <summary> /// æ¥æ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } /// <summary> /// æ£éªé¡¹ç® /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] /// <summary> /// æ£éªé¡¹ç® /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] public string FcheckItem { get; set; } /// <summary> /// æ£éªå·¥å · /// </summary> [SugarColumn(ColumnName = "FCHECK_TOOL")] /// <summary> /// æ£éªå·¥å · /// </summary> [SugarColumn(ColumnName = "FCHECK_TOOL")] public string FcheckTool { get; set; } /// <summary> /// ä¸é /// </summary> [SugarColumn(ColumnName = "FDOWN_ALLOW")] /// <summary> /// ä¸é /// </summary> [SugarColumn(ColumnName = "FDOWN_ALLOW")] public string FdownAllow { get; set; } /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FREQUENCY")] /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FREQUENCY")] public string FREQUENCY { get; set; } /// <summary> /// æ å /// </summary> [SugarColumn(ColumnName = "FSTAND")] /// <summary> /// æ å /// </summary> [SugarColumn(ColumnName = "FSTAND")] public string FSTAND { get; set; } /// <summary> /// ä¸é /// </summary> [SugarColumn(ColumnName = "FUP_ALLOW")] /// <summary> /// ä¸é /// </summary> [SugarColumn(ColumnName = "FUP_ALLOW")] public string FupAllow { get; set; } /// <summary> /// æ£éªæ°´åç¼ç /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] /// <summary> /// æ£éªæ°´åç¼ç /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } /// <summary> /// è§æ ¼è¦æ± /// </summary> [SugarColumn(ColumnName = "FSPEC_REQU")] /// <summary> /// è§æ ¼è¦æ± /// </summary> [SugarColumn(ColumnName = "FSPEC_REQU")] public string FspecRequ { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "ISENABLED")] /// <summary> /// </summary> [SugarColumn(ColumnName = "ISENABLED")] public short? ISENABLED { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "EE")] /// <summary> /// </summary> [SugarColumn(ColumnName = "EE")] public short? EE { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FTYPE")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FTYPE")] public string FTYPE { get; set; } } MES.Service/Modes/MesQaItemsDetect01.cs
@@ -8,330 +8,330 @@ [SugarTable("MES_QA_ITEMS_DETECT_01")] public class MesQaItemsDetect01 { /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] /// <summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } /// <summary> /// æ£éªäººå /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] /// <summary> /// æ£éªäººå /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// æ¥ææ°é /// </summary> [SugarColumn(ColumnName = "FBATCH_QTY")] /// <summary> /// æ¥ææ°é /// </summary> [SugarColumn(ColumnName = "FBATCH_QTY")] public decimal? FbatchQty { get; set; } /// <summary> /// å¤å®ç»æ /// </summary> [SugarColumn(ColumnName = "FRECE_QTY")] /// <summary> /// å¤å®ç»æ /// </summary> [SugarColumn(ColumnName = "FRECE_QTY")] public string FreceQty { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FNG_DESC")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FNG_DESC")] public string FngDesc { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FREVIEW")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FREVIEW")] public string Freview { get; set; } /// <summary> /// æ£éªæ°´å /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] /// <summary> /// æ£éªæ°´å /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } /// <summary> /// ææ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] /// <summary> /// ææ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } /// <summary> /// æ½æ£æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] /// <summary> /// æ½æ£æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] public string CheckQty { get; set; } /// <summary> /// æ¹æ¬¡å· --å°è´§åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO")] /// <summary> /// æ¹æ¬¡å· --å°è´§åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ¯å¦æ¨é /// </summary> [SugarColumn(ColumnName = "FMOVE")] /// <summary> /// æ¯å¦æ¨é /// </summary> [SugarColumn(ColumnName = "FMOVE")] public string Fmove { get; set; } /// <summary> /// æ¯å¦å¤ç /// </summary> [SugarColumn(ColumnName = "FHANDLE")] /// <summary> /// æ¯å¦å¤ç /// </summary> [SugarColumn(ColumnName = "FHANDLE")] public string Fhandle { 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 = "MODIFY1_FLAG")] /// <summary> /// æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG")] public decimal? Modify1Flag { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY")] public string Modify1By { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE")] /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE")] public DateTime? Modify1Date { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// XRFæµè¯æ¥åç¼å· /// </summary> [SugarColumn(ColumnName = "FCHECK_REPNO")] /// <summary> /// XRFæµè¯æ¥åç¼å· /// </summary> [SugarColumn(ColumnName = "FCHECK_REPNO")] public string FcheckRepno { get; set; } /// <summary> /// 第ä¸æ¹æ¥å /// </summary> [SugarColumn(ColumnName = "FTHIRD_REP")] /// <summary> /// 第ä¸æ¹æ¥å /// </summary> [SugarColumn(ColumnName = "FTHIRD_REP")] public string FthirdRep { get; set; } /// <summary> /// æ¯å¦ä½åº /// </summary> [SugarColumn(ColumnName = "FCANCEL")] /// <summary> /// æ¯å¦ä½åº /// </summary> [SugarColumn(ColumnName = "FCANCEL")] public decimal? Fcancel { get; set; } /// <summary> /// æ交æ è¯ /// </summary> [SugarColumn(ColumnName = "FSUBMIT")] /// <summary> /// æ交æ è¯ /// </summary> [SugarColumn(ColumnName = "FSUBMIT")] public decimal? Fsubmit { get; set; } /// <summary> /// æ£éªä¾æ® /// </summary> [SugarColumn(ColumnName = "FCHECK_ACCORD")] /// <summary> /// æ£éªä¾æ® /// </summary> [SugarColumn(ColumnName = "FCHECK_ACCORD")] public string FcheckAccord { get; set; } /// <summary> /// ç±»å(0 æ¥æ 1 å¨åº) /// </summary> [SugarColumn(ColumnName = "FTYPE")] /// <summary> /// ç±»å(0 æ¥æ 1 å¨åº) /// </summary> [SugarColumn(ColumnName = "FTYPE")] public short? Ftype { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "ITEM_UNIT")] /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "ITEM_UNIT")] public string ItemUnit { get; set; } /// <summary> /// åºè´§æ¥æ /// </summary> [SugarColumn(ColumnName = "OUT_DATE")] /// <summary> /// åºè´§æ¥æ /// </summary> [SugarColumn(ColumnName = "OUT_DATE")] public string OutDate { get; set; } /// <summary> /// æ¯å¦å æ£ /// </summary> [SugarColumn(ColumnName = "FEXEMPTION")] /// <summary> /// æ¯å¦å æ£ /// </summary> [SugarColumn(ColumnName = "FEXEMPTION")] public decimal? Fexemption { get; set; } /// <summary> /// æ¡£ä½æ å /// </summary> [SugarColumn(ColumnName = "FGEAR_STAND")] /// <summary> /// æ¡£ä½æ å /// </summary> [SugarColumn(ColumnName = "FGEAR_STAND")] public string FgearStand { get; set; } /// <summary> /// ä¸è¯å¤çæ¹æ³ /// </summary> [SugarColumn(ColumnName = "FNG_HANDLE")] /// <summary> /// ä¸è¯å¤çæ¹æ³ /// </summary> [SugarColumn(ColumnName = "FNG_HANDLE")] public string FngHandle { get; set; } /// <summary> /// 管çç¼å· /// </summary> [SugarColumn(ColumnName = "FMANAGE_NO")] /// <summary> /// 管çç¼å· /// </summary> [SugarColumn(ColumnName = "FMANAGE_NO")] public string FmanageNo { get; set; } /// <summary> /// 转æ¢æ°é /// </summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] /// <summary> /// 转æ¢æ°é /// </summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] public string FcovertQty { get; set; } /// <summary> /// çæ¬ /// </summary> [SugarColumn(ColumnName = "FVERSION")] /// <summary> /// çæ¬ /// </summary> [SugarColumn(ColumnName = "FVERSION")] public decimal? Fversion { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FSECOND_RESU")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FSECOND_RESU")] public string FsecondResu { get; set; } /// <summary> /// æ大æ½æ£æ° /// </summary> [SugarColumn(ColumnName = "MAX_CHECK_QTY")] /// <summary> /// æ大æ½æ£æ° /// </summary> [SugarColumn(ColumnName = "MAX_CHECK_QTY")] public decimal? MaxCheckQty { get; set; } /// <summary> /// ç¹å®ä¿®æ¹æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG1")] /// <summary> /// ç¹å®ä¿®æ¹æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG1")] public decimal? Modify1Flag1 { get; set; } /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY1")] /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY1")] public string Modify1By1 { get; set; } /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸æ¶é´ /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE1")] /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸æ¶é´ /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE1")] public DateTime? Modify1Date1 { get; set; } /// <summary> /// å°æ¹æ¬¡å· /// </summary> [SugarColumn(ColumnName = "LOT_NO1")] /// <summary> /// å°æ¹æ¬¡å· /// </summary> [SugarColumn(ColumnName = "LOT_NO1")] public string LotNo1 { get; set; } /// <summary> /// éè´åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO2")] /// <summary> /// éè´åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO2")] public string LotNo2 { get; set; } /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// å°è´§æ¶é´ /// </summary> [SugarColumn(ColumnName = "DHA018")] /// <summary> /// å°è´§æ¶é´ /// </summary> [SugarColumn(ColumnName = "DHA018")] public string Dha018 { get; set; } /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "DHB002")] /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "DHB002")] public decimal? Dhb002 { get; set; } /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "DHB001")] /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "LIFNR")] /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "LIFNR")] public string Lifnr { get; set; } /// <summary> /// éææ¹å¼ /// </summary> [SugarColumn(ColumnName = "FMRMODE")] /// <summary> /// éææ¹å¼ /// </summary> [SugarColumn(ColumnName = "FMRMODE")] public string Fmrmode { get; set; } /// <summary> /// ä¸è¯æè¿° /// </summary> [SugarColumn(ColumnName = "Remarks")] /// <summary> /// ä¸è¯æè¿° /// </summary> [SugarColumn(ColumnName = "Remarks")] public string Remarks { get; set; } } MES.Service/Modes/MesQaItemsDetectDetail12.cs
@@ -8,64 +8,64 @@ [SugarTable("MES_QA_ITEMS_DETECT_DETAIL12")] public class MesQaItemsDetectDetail12 { /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_QM_ID", /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_QM_ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string? FcheckResu { get; set; } /// <summary> /// æ£éªé¡¹ç® /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] /// <summary> /// æ£éªé¡¹ç® /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] public string? FcheckItem { get; set; } /// <summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] /// <summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string? ReleaseNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MAIN_ID")] /// <summary> /// </summary> [SugarColumn(ColumnName = "MAIN_ID")] public decimal? MainId { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string? Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string? Factory { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FSTAND")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FSTAND")] public string? Fstand { get; set; } /// <summary> /// çæ人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// çæ人 /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string? LastupdateBy { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string? CreateBy { get; set; } [SugarColumn(IsIgnore = true)] public int? count { get; set; } MES.Service/Modes/MesQaItemsDetectDetail5.cs
@@ -9,176 +9,176 @@ [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] public class MesQaItemsDetectDetail5 { /// <summary> /// </summary> [Column("ID")] /// <summary> /// </summary> [Column("ID")] [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_QM_ID", IsPrimaryKey = true)] public decimal? Id { get; set; } /// <summary> /// æ åå¼ç±»å /// </summary> [SugarColumn(ColumnName = "FTEXT_TYPE")] /// <summary> /// æ åå¼ç±»å /// </summary> [SugarColumn(ColumnName = "FTEXT_TYPE")] public string? FtextType { get; set; } /// <summary> /// æ åå¼ /// </summary> [SugarColumn(ColumnName = "FSTAND")] /// <summary> /// æ åå¼ /// </summary> [SugarColumn(ColumnName = "FSTAND")] public string? Fstand { get; set; } /// <summary> /// ä¸å ¬å·® /// </summary> [SugarColumn(ColumnName = "FUP_ALLOW")] /// <summary> /// ä¸å ¬å·® /// </summary> [SugarColumn(ColumnName = "FUP_ALLOW")] public string? FupAllow { get; set; } /// <summary> /// ä¸å ¬å·® /// </summary> [SugarColumn(ColumnName = "FDOWN_ALLOW")] /// <summary> /// ä¸å ¬å·® /// </summary> [SugarColumn(ColumnName = "FDOWN_ALLOW")] public string? FdownAllow { get; set; } /// <summary> /// æ£éªæ°´å /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] /// <summary> /// æ£éªæ°´å /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string? SampleSizeNo { get; set; } /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string? FcheckLevel { get; set; } /// <summary> /// ææ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] /// <summary> /// ææ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string? FacLevel { get; set; } /// <summary> /// æ£éªé¡¹ç® /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] /// <summary> /// æ£éªé¡¹ç® /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] public string? FcheckItem { get; set; } /// <summary> /// è§æ ¼è¦æ± /// </summary> [SugarColumn(ColumnName = "FSPEC_REQU")] /// <summary> /// è§æ ¼è¦æ± /// </summary> [SugarColumn(ColumnName = "FSPEC_REQU")] public string? FspecRequ { get; set; } /// <summary> /// æ½æ£æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QYT")] /// <summary> /// æ½æ£æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QYT")] public decimal? CheckQyt { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string? FcheckResu { get; set; } /// <summary> /// ACæ°é /// </summary> [SugarColumn(ColumnName = "FAC_QTY")] /// <summary> /// ACæ°é /// </summary> [SugarColumn(ColumnName = "FAC_QTY")] public decimal? FacQty { get; set; } /// <summary> /// REæ°é /// </summary> [SugarColumn(ColumnName = "FRE_QTY")] /// <summary> /// REæ°é /// </summary> [SugarColumn(ColumnName = "FRE_QTY")] public decimal? FreQty { get; set; } /// <summary> /// ä¸åæ ¼æ° /// </summary> [SugarColumn(ColumnName = "FNG_QTY")] /// <summary> /// ä¸åæ ¼æ° /// </summary> [SugarColumn(ColumnName = "FNG_QTY")] public decimal? FngQty { get; set; } /// <summary> /// ä¸è¯ç /// </summary> [SugarColumn(ColumnName = "FNG_RATE")] /// <summary> /// ä¸è¯ç /// </summary> [SugarColumn(ColumnName = "FNG_RATE")] public decimal? FngRate { get; set; } /// <summary> /// å·²å½å ¥æ°é /// </summary> [SugarColumn(ColumnName = "FENTER_QTY")] /// <summary> /// å·²å½å ¥æ°é /// </summary> [SugarColumn(ColumnName = "FENTER_QTY")] public decimal? FenterQty { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] /// <summary> /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string? ReleaseNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string? Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string? Factory { get; set; } /// <summary> /// æ£éªé¡¹ç®æè¿° /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")] /// <summary> /// æ£éªé¡¹ç®æè¿° /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")] public string? FcheckItemDesc { get; set; } /// <summary> /// å·¥åºå· /// </summary> [SugarColumn(ColumnName = "PROC_NO")] /// <summary> /// å·¥åºå· /// </summary> [SugarColumn(ColumnName = "PROC_NO")] public string? ProcNo { get; set; } /// <summary> /// å·¥ä½ä¸å¿ç¼ç /// </summary> [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] /// <summary> /// å·¥ä½ä¸å¿ç¼ç /// </summary> [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] public string? WorkshopCenterCode { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "FUNIT")] /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "FUNIT")] public string? Funit { get; set; } /// <summary> /// ç¹å®ä¿®æ¹ /// </summary> [SugarColumn(ColumnName = "GIVEN_MODIFY")] /// <summary> /// ç¹å®ä¿®æ¹ /// </summary> [SugarColumn(ColumnName = "GIVEN_MODIFY")] public short? GivenModify { get; set; } /// <summary> /// æ£éªå·¥å · /// </summary> [SugarColumn(ColumnName = "FCHECK_TOOL")] /// <summary> /// æ£éªå·¥å · /// </summary> [SugarColumn(ColumnName = "FCHECK_TOOL")] public string? FcheckTool { 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 = "REMARKS")] /// <summary> /// ä¸è¯æè¿° /// </summary> [SugarColumn(ColumnName = "REMARKS")] public string? Remarks { get; set; } [SugarColumn(IsIgnore = true)] public int? Unqualified { get; set; } MES.Service/Modes/MesRfPrnbarcode.cs
@@ -11,7 +11,7 @@ /// <summary> /// ID /// </summary> [SugarColumn(ColumnName = "ID",IsPrimaryKey = true)] [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal? Id { get; set; } /// <summary> MES.Service/Modes/MessageCenter.cs
@@ -1,11 +1,12 @@ using SqlSugar; using MES.Service.Dto.@base; using SqlSugar; namespace MES.Service.Modes; /// <summary> /// </summary> [SugarTable("MESSAGE_CENTER")] public class MessageCenter public class MessageCenter : Page { /// <summary> /// 对åºåºåSEQ_MSG 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; } } 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; } } MES.Service/Modes/QsItemOqcItemDetail.cs
@@ -84,4 +84,6 @@ public string? Remarks { get; set; } [SugarColumn(IsIgnore = true)] public int? count { get; set; } [SugarColumn(IsIgnore = true)] public decimal? ItemInId { get; set; } } MES.Service/Modes/QsItemOqcReq.cs
@@ -124,10 +124,6 @@ [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; } [SugarColumn(IsIgnore = true)] public string? TaskNo { get; set; } [SugarColumn(IsIgnore = true)] public string? CbillNo { get; set; } [SugarColumn(IsIgnore = true)] public string? Dab001 { get; set; } [SugarColumn(IsIgnore = true)] public string? Daa015 { get; set; } @@ -135,4 +131,6 @@ [SugarColumn(IsIgnore = true)] public string? LineNo { get; set; } [SugarColumn(IsIgnore = true)] public decimal? Quantity { get; set; } [SugarColumn(IsIgnore = true)] public decimal? ItemInId { get; set; } } MES.Service/service/MesRfPrnbarcodeManager.cs
@@ -1,78 +1,78 @@ using SqlSugar; using System; using System.Collections.Generic; using MES.Service.DB; using MES.Service.DB; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service { namespace MES.Service.service; public class MesRfPrnbarcodeManager : Repository<MesRfPrnbarcode> { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,å¦æè¦éæ°çæ请å é¤ MesRfPrnbarcodeManager.cs #region æå¦æ¹æ³ /// <summary> /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ /// </summary> public void Study() { /*********æ¥è¯¢*********/ /*********æ¥è¯¢*********/ var data1 = base.GetById(1);//æ ¹æ®IDæ¥è¯¢ var data2 = base.GetList();//æ¥è¯¢ææ var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ var data1 = base.GetById(1); //æ ¹æ®IDæ¥è¯¢ var data2 = base.GetList(); //æ¥è¯¢ææ var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,å¦æè¶ è¿ä¸æ¡ä¼æ¥é var p = new PageModel() { PageIndex = 1, PageSize = 2 };// å页æ¥è¯¢ var p = new PageModel { PageIndex = 1, PageSize = 2 }; // å页æ¥è¯¢ var data5 = base.GetPageList(it => 1 == 1, p); Console.Write(p.TotalCount);//è¿åæ»æ° Console.Write(p.TotalCount); //è¿åæ»æ° var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// å页æ¥è¯¢å æåº Console.Write(p.TotalCount);//è¿åæ»æ° List<IConditionalModel> conModels = new List<IConditionalModel>(); //ç»è£ æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº conModels.Add(new ConditionalModel() { FieldName= typeof(MesRfPrnbarcode).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1 var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc); var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom()); // å页æ¥è¯¢å æåº Console.Write(p.TotalCount); //è¿åæ»æ° base.AsQueryable().Where(x => 1 == 1).ToList();//æ¯æäºè½¬æ¢æqueryable,æ们å¯ä»¥ç¨queryableå®ç°å¤æåè½ var conModels = new List<IConditionalModel>(); //ç»è£ æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº conModels.Add(new ConditionalModel { FieldName = typeof(MesRfPrnbarcode).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" }); //id=1 var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); AsQueryable().Where(x => 1 == 1) .ToList(); //æ¯æäºè½¬æ¢æqueryable,æ们å¯ä»¥ç¨queryableå®ç°å¤æåè½ /*********æå ¥*********/ var insertData = new MesRfPrnbarcode() { };//æµè¯åæ° var insertArray = new MesRfPrnbarcode[] { insertData }; base.Insert(insertData);//æå ¥ base.InsertRange(insertArray);//æ¹éæå ¥ var id = base.InsertReturnIdentity(insertData);//æå ¥è¿åèªå¢å base.AsInsertable(insertData).ExecuteCommand();//æ们å¯ä»¥è½¬æ Insertableå®ç°å¤ææå ¥ var insertData = new MesRfPrnbarcode(); //æµè¯åæ° var insertArray = new[] { insertData }; base.Insert(insertData); //æå ¥ base.InsertRange(insertArray); //æ¹éæå ¥ var id = base.InsertReturnIdentity(insertData); //æå ¥è¿åèªå¢å AsInsertable(insertData).ExecuteCommand(); //æ们å¯ä»¥è½¬æ Insertableå®ç°å¤ææå ¥ /*********æ´æ°*********/ var updateData = new MesRfPrnbarcode() { };//æµè¯åæ° var updateArray = new MesRfPrnbarcode[] { updateData };//æµè¯åæ° base.Update(updateData);//æ ¹æ®å®ä½æ´æ° base.UpdateRange(updateArray);//æ¹éæ´æ° /*********æ´æ°*********/ var updateData = new MesRfPrnbarcode(); //æµè¯åæ° var updateArray = new[] { updateData }; //æµè¯åæ° base.Update(updateData); //æ ¹æ®å®ä½æ´æ° base.UpdateRange(updateArray); //æ¹éæ´æ° //base.Update(it => new MesRfPrnbarcode() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å ¶å®åä¸æ´æ°ï¼æ¡ä»¶id=1 base.AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå ¥ AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå ¥ /*********å é¤*********/ var deldata = new MesRfPrnbarcode(); //æµè¯åæ° base.Delete(deldata); //æ ¹æ®å®ä½å é¤ base.DeleteById(1); //æ ¹æ®ä¸»é®å é¤ base.DeleteById(new[] { 1, 2 }); //æ ¹æ®ä¸»é®æ°ç»å é¤ base.Delete(it => 1 == 2); //æ ¹æ®æ¡ä»¶å é¤ AsDeleteable().Where(it => 1 == 2) .ExecuteCommand(); //转æDeleteableå®ç°å¤æçæä½ } /*********å é¤*********/ var deldata = new MesRfPrnbarcode() { };//æµè¯åæ° base.Delete(deldata);//æ ¹æ®å®ä½å é¤ base.DeleteById(1);//æ ¹æ®ä¸»é®å é¤ base.DeleteById(new int[] { 1,2});//æ ¹æ®ä¸»é®æ°ç»å é¤ base.Delete(it=>1==2);//æ ¹æ®æ¡ä»¶å é¤ base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//转æDeleteableå®ç°å¤æçæä½ } #endregion } } MES.Service/service/MessageCenterManager.cs
@@ -8,17 +8,50 @@ { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ public List<MessageCenter> GetPushFailedPage(MessageCenter query) public (List<MessageCenter> item, int TotalCount) GetPushFailedPage( MessageCenter query) { var totalCount = IsShow(query); //计ç®å页åæ° var startRow = (query.PageIndex - 1) * query.Limit + 1; var endRow = query.PageIndex * query.Limit; var sql = string.Format( "SELECT * FROM (SELECT \"ID\",\"TABLE_NAME\",\"URL\",\"METHOD\",\"DATA\",\"RESULT\",\"RESULT_DATA\",\"STATUS\",\"CREATE_BY\",\"CREATE_DATE\",\"TITLE\",\"PAGE_NAME\",\"DEAL_WITH\",\"PID\",\"SEQ\",\"ROUTE\",\"CONTENT_TYPE\",\"IS_MESSAGE\",\"UPDATE_BY\",\"UPDATE_DATE\", ROW_NUMBER() OVER (ORDER BY DEAL_WITH) AS RowIndex\n FROM (SELECT \"ID\",\"TABLE_NAME\",\"URL\",\"METHOD\",\"DATA\",\"RESULT\",\"RESULT_DATA\",\"STATUS\",\"CREATE_BY\",\"CREATE_DATE\",\"TITLE\",\"PAGE_NAME\",\"DEAL_WITH\",\"PID\",\"SEQ\",\"ROUTE\",\"CONTENT_TYPE\",\"IS_MESSAGE\",\"UPDATE_BY\",\"UPDATE_DATE\" FROM MESSAGE_CENTER WHERE RESULT = 0 AND SEQ = 1 AND TITLE IS NOT NULL ORDER BY CREATE_DATE DESC)) T WHERE RowIndex BETWEEN {0} AND {1} ", startRow, endRow); var messageCenters = Db.Ado.SqlQuery<MessageCenter>(sql); return (messageCenters, totalCount); } //æ¥çæ¯å¦ææªå¤ççæ¶æ¯ public int IsShow(MessageCenter query) { return Context.Queryable<MessageCenter>() .Where(it => it.Result == 0 && it.Status == 1 && it.Seq == 1 && it.Title != null) .WhereIF(query.isShow == 1, it => it.DealWith == 0) .OrderByDescending(it => it.CreateDate) .ToPageList(1, 20); .Count(); } //å°æ¶æ¯è®¾ç½®ä¸ºå·²è¯»ç public int UpdateRead(MessageCenter query) { return Db.Updateable<MessageCenter>() .SetColumns(s => s.DealWith == 1) .SetColumns(s => s.UpdateBy == query.UpdateBy) .SetColumns(s => s.UpdateDate == DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")) .Where(s => s.Id == query.Id) .ExecuteCommand(); } public int save(MessageCenter entity) { entity.CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); MES.Service/service/QC/RKJService.cs
@@ -132,6 +132,8 @@ break; } if (string.IsNullOrEmpty(LEV)) throw new Exception("æ£éªæ°´å¹³ç»´æ¤çä¸æ£ç¡®"); var sql = "SELECT " + LEV + " FROM MES_QM_AQL1 A LEFT JOIN MES_QM_AQL2 B ON B.AQL1_ID=A.ID WHERE A.SAMPLE_SIZE_NO='" + @@ -140,9 +142,13 @@ var maxBillNo = db.Ado.SqlQuerySingle<string>(sql); if (string.IsNullOrEmpty(maxBillNo)) throw new Exception("没æ" + quantity + "è¿ä¸ªèå´çæ½æ ·åºå"); var result = ExtractSubstring(item.FacLevel, '(', ')'); if (string.IsNullOrEmpty(result)) throw new Exception("ç»´æ¤çæ¥æ¶æ°´å¹³ä¸æ£ç¡®ï¼åºè¯¥æ¯0.010---(AQL_0_0010)åè¿æ ·ç"); sql = "SELECT FSAMPLE_SIZE_WORD, " + result + " Result FROM MES_QM_AQL1 A LEFT JOIN MES_QM_AQL3 C ON C.AQL1_ID=A.ID WHERE A.SAMPLE_SIZE_NO= '" + @@ -402,9 +408,9 @@ .ExecuteCommand(); }); if (FcheckResu.Equals("ä¸åæ ¼")) //èªå¨çæå ¥åºæ£å¼å¸¸å¯¹ç saveDetect02(detail.Gid, detail.CreateBy); // if (FcheckResu.Equals("ä¸åæ ¼")) // //èªå¨çæå ¥åºæ£å¼å¸¸å¯¹ç // saveDetect02(detail.Gid, detail.CreateBy); return useTransactionWithOracle; } @@ -454,11 +460,12 @@ } public (List<QsItemOqcReq> items, int TotalCount) getPage(XJPageResult queryObj) public (List<QsItemOqcReq> items, int TotalCount) getPage( XJPageResult queryObj) { var db = SqlSugarHelper.GetInstance(); int totalCount = 0; var totalCount = 0; var qsItemOqcReqs = db .Queryable<QsItemOqcReq, MesItems, MesInvItemIns, MesInvTransaction, @@ -498,12 +505,13 @@ ItemName = b.ItemName, ItemModel = b.ItemModel, Dab001 = m.LotNo, ItemInId = m.ItemInId, Daa015 = da.Daa015, LineNo = c.LineNo, Quantity = m.Quantity }) .OrderBy(a => a.CreateDate, OrderByType.Desc) .ToPageList(queryObj.PageIndex, queryObj.Limit,ref totalCount); .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount); return (qsItemOqcReqs, totalCount); } @@ -568,6 +576,8 @@ public int UpdateQSItemDetail(QsItemOqcItemDetail detail) { if (isRk(detail.ItemInId)) throw new Exception("å·²ææ¡ç å ¥åºï¼ä¸å 许修æ¹æ£éªç»æ"); var withOracle = SqlSugarHelper.UseTransactionWithOracle(db => { return db.Updateable<QsItemOqcItemDetail>() @@ -588,6 +598,14 @@ return withOracle; } //ä¿®æ¹ç»æåéªè¯æ¯å¦å ¥åº private bool isRk(decimal? ItemInId) { var db = SqlSugarHelper.GetInstance(); return db.Queryable<MesInvItemInCDetails>() .Where(s => s.ItemInId == ItemInId).Count() > 0; } //主表修æ¹å¤æ³¨å段 public int saveRemarksGid(RKJDto dto) MES.Service/service/Warehouse/MesInvItemInCDetails2Manager.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,10 @@ using MES.Service.DB; using MES.Service.Modes; namespace MES.Service.service.Warehouse; public class MesInvItemInCDetails2Manager : Repository<MesInvItemInCDetails2> { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ } MESApplication/Controllers/Base/MessageCenterController.cs
@@ -109,7 +109,51 @@ try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetPushFailedPage(query); var (item, totalCount) = m.GetPushFailedPage(query); resultInfos.tbBillList = item; return new ResponseResult { status = 0, message = "OK", data = resultInfos, TotalCount = totalCount }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //IsShow [HttpPost("IsShow")] public ResponseResult IsShow(MessageCenter query) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.IsShow(query); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //UpdateRead [HttpPost("UpdateRead")] public ResponseResult UpdateRead(MessageCenter query) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.UpdateRead(query); return new ResponseResult { status = 0, MESApplication/Controllers/BasicData/ProductionOrderController.cs
@@ -15,14 +15,14 @@ { private readonly MessageCenterManager _manager = new(); private readonly ProductionOrderManager m = new(); private readonly string METHOD = "POST"; private readonly string TableName = "PRODUCTION_ORDER"; private readonly string URL = "http://localhost:10054/api/PRODUCTION_ORDER/"; private readonly ProductionOrderManager m = new(); // [HttpPost("Save")] MESApplication/Controllers/MesRfPrnbarcodeController.cs
@@ -1,163 +1,162 @@ using Microsoft.AspNetCore.Mvc; using System.Dynamic; using System.Dynamic; using MES.Service.Modes; using MES.Service.service; using MES.Service.util; using Microsoft.AspNetCore.Mvc; namespace MESApplication.Controllers namespace MESApplication.Controllers; [ApiController] [Route("api/[controller]")] public class MesRfPrnbarcodeController : ControllerBase { [ApiController] [Route("api/[controller]")] public class MesRfPrnbarcodeController : ControllerBase private readonly MesRfPrnbarcodeManager m = new(); /***è¿å ¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ /// <summary> /// è·åææ /// </summary> /// <returns></returns> [HttpPost("GetList")] public ResponseResult GetList() { private MesRfPrnbarcodeManager m = new MesRfPrnbarcodeManager(); /***è¿å ¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ /// <summary> /// è·åææ /// </summary> /// <returns></returns> [HttpPost("GetList")] public ResponseResult GetList() try { try dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetList(); return new ResponseResult { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetList(); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } status = 0, message = "OK", data = resultInfos }; } /// <summary> /// æ ¹æ®ä¸»é®è·å /// </summary> /// <returns></returns> [HttpPost("GetById")] public ResponseResult GetById(int id) catch (Exception ex) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetById(id); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®å é¤ /// </summary> /// <returns></returns> [HttpPost("DeleteByIds")] public ResponseResult DeleteByIds([FromBody] object[] ids) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.DeleteByIds(ids); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å /// </summary> /// <returns></returns> [HttpPost("Insert")] public ResponseResult Add([FromBody] MesRfPrnbarcode data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Insert(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å è¿åèªå¢ /// </summary> /// <returns></returns> [HttpPost("InsertReturnIdentity")] public ResponseResult InsertReturnIdentity([FromBody] MesRfPrnbarcode data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.InsertReturnIdentity(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// ä¿®æ¹ /// </summary> /// <returns></returns> [HttpPost("Update")] public ResponseResult Update([FromBody] MesRfPrnbarcode data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Update(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } return ResponseResult.ResponseError(ex); } } } /// <summary> /// æ ¹æ®ä¸»é®è·å /// </summary> /// <returns></returns> [HttpPost("GetById")] public ResponseResult GetById(int id) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetById(id); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®å é¤ /// </summary> /// <returns></returns> [HttpPost("DeleteByIds")] public ResponseResult DeleteByIds([FromBody] object[] ids) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.DeleteByIds(ids); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å /// </summary> /// <returns></returns> [HttpPost("Insert")] public ResponseResult Add([FromBody] MesRfPrnbarcode data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Insert(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å è¿åèªå¢ /// </summary> /// <returns></returns> [HttpPost("InsertReturnIdentity")] public ResponseResult InsertReturnIdentity([FromBody] MesRfPrnbarcode data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.InsertReturnIdentity(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// ä¿®æ¹ /// </summary> /// <returns></returns> [HttpPost("Update")] public ResponseResult Update([FromBody] MesRfPrnbarcode data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Update(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } } MESApplication/Controllers/QC/RKJController.cs
@@ -136,7 +136,7 @@ { dynamic resultInfos = new ExpandoObject(); var (items, totalCount) = new RKJService().getPage(queryObj); var tbBillList =items; var tbBillList = items; resultInfos.tbBillList = tbBillList; return new ResponseResult {
