MES.Service/DB/OracleSQLHelper.cs
@@ -9,10 +9,11 @@ /// </summary> public class OracleSQLHelper { private readonly string ConnectionString =AppsettingsUtility.Settings.DataBaseConn; private readonly string _connectionString; private readonly string ConnectionString = AppsettingsUtility.Settings.DataBaseConn; public OracleSQLHelper() { _connectionString = ConnectionString; MES.Service/Dto/service/MaterialReceipt.cs
@@ -4,12 +4,9 @@ public class MaterialReceipt { public List<MesInvItemOutItems>? ItemsList { get; set; } public List<MesInvItemOutCDetails>? InvItemoutCDetails { get; set; } public MesInvItemOuts? ItemOuts { get; set; } } MES.Service/Dto/service/WarehouseQuery.cs
@@ -24,12 +24,12 @@ public string? Company { get; set; } public string? ItemNo { get; set; } public string? ItemModel { get; set; } public string? OrgName { get; set; } public string? OrgOwner { get; set; } public string? ItemNum { get; set; } public string? Printnumn { get; set; } public string? ItemName { get; set; } } MES.Service/Modes/MesBarcodeType.cs
@@ -1,214 +1,250 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; namespace MES.Service.Modes using SqlSugar; namespace MES.Service.Modes; /// <summary> /// æ¡ç ç±»å表 /// </summary> [SugarTable("MES_BARCODE_TYPE")] public class MesBarcodeType { /// <summary> /// æ¡ç ç±»å表 ///</summary> [SugarTable("MES_BARCODE_TYPE")] public class MesBarcodeType { /// <summary> /// æ¡ç ç±»åID(seq_me_id) ///</summary> [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )] public decimal Id { get; set; } /// <summary> /// 使ç¨åºæ ///</summary> [SugarColumn(ColumnName="USE_SITE" )] public string UseSite { get; set; } /// <summary> /// æ¡ç ç±»åå称 ///</summary> [SugarColumn(ColumnName="BARCODE_TYPE_NAME" )] public string BarcodeTypeName { get; set; } /// <summary> /// ç å¶ ///</summary> [SugarColumn(ColumnName="CODE" )] public string Code { get; set; } /// <summary> /// æ¡ç 纸宽 ///</summary> [SugarColumn(ColumnName="PAPER_WIDTH" )] public decimal? PaperWidth { get; set; } /// <summary> /// æ¡ç çº¸é« ///</summary> [SugarColumn(ColumnName="PAPER_HEIGHT" )] public decimal? PaperHeight { get; set; } /// <summary> /// æ¡ç å¼å§ä½ç½®X ///</summary> [SugarColumn(ColumnName="BARCODE_BEGIN_POSITION_X" )] public decimal? BarcodeBeginPositionX { get; set; } /// <summary> /// æ¡ç å¼å§ä½ç½®Y ///</summary> [SugarColumn(ColumnName="BARCODE_BEGIN_POSITION_Y" )] public decimal? BarcodeBeginPositionY { get; set; } /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¡ç ä¸ªæ° ///</summary> [SugarColumn(ColumnName="PAPER_NUM" )] public decimal? PaperNum { get; set; } /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¯è¡æ¡ç ä¸ªæ° ///</summary> [SugarColumn(ColumnName="PAPER_ROW_NUM" )] public decimal? PaperRowNum { get; set; } /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¡ç åæ° ///</summary> [SugarColumn(ColumnName="PAPER_COLUMN_NUM" )] public decimal? PaperColumnNum { get; set; } /// <summary> /// æ¡ç æµæ°´å·å¾ªç¯ç±»å(æ§å¶æ¡ç æµæ°´å·) ///</summary> [SugarColumn(ColumnName="CYCLE_TYPE" )] public string CycleType { get; set; } /// <summary> /// æ¯å¦ææ(0-æ æ,1-ææ) ///</summary> [SugarColumn(ColumnName="AVAILABLE_FLAG" )] public decimal? AvailableFlag { get; set; } /// <summary> /// æ¡ç é«åº¦ ///</summary> [SugarColumn(ColumnName="BARCODE_HEIGHT" )] public decimal? BarcodeHeight { get; set; } /// <summary> /// æ¡ç åä½æ¹å ///</summary> [SugarColumn(ColumnName="BARCODE_ORIENTATION" )] public string BarcodeOrientation { get; set; } /// <summary> /// æ¡ç æå°æ³¨éè¡(1-æå°ï¼0-ä¸æå°) ///</summary> [SugarColumn(ColumnName="BARCODE_INTERPRETATION" )] public decimal? BarcodeInterpretation { get; set; } /// <summary> /// æ¡ç æå°æ³¨éè¡æå¨æ¡ç ä¸æ¹(1-æå°å¨æ¡ç ä¸æ¹ï¼0-ä¸æå°å¨æ¡ç ä¸æ¹) ///</summary> [SugarColumn(ColumnName="BARCODE_INTERPRETATION_ABOVE" )] public decimal? BarcodeInterpretationAbove { 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> /// æ¡ç 宽度 ///</summary> [SugarColumn(ColumnName="BARCODE_WIDTH" )] public decimal? BarcodeWidth { get; set; } /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]模åï¼çªæ¡ï¼å®½ ///</summary> [SugarColumn(ColumnName="BY_W" )] public decimal? ByW { get; set; } /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]宽æ¡ä¸çªæ¡çæ¯ä¾ ///</summary> [SugarColumn(ColumnName="BY_R" )] public decimal? ByR { get; set; } /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]æ¡ç é«åº¦ ///</summary> [SugarColumn(ColumnName="BY_H" )] public decimal? ByH { get; set; } /// <summary> /// ç¹æ°/毫米 ///</summary> [SugarColumn(ColumnName="JM" )] public string Jm { get; set; } /// <summary> /// èææ°æ®æ å¿(1-æ¯ï¼0ï¼å¦) ///</summary> [SugarColumn(ColumnName="JVM_DATA_FLAG" )] public decimal? JvmDataFlag { get; set; } /// <summary> /// èææ°æ®æµæ°´å·ä½æ° ///</summary> [SugarColumn(ColumnName="JVM_SERIAL_DIGIT" )] public decimal? JvmSerialDigit { get; set; } /// <summary> /// èææ°æ®æ¡ç é¿åº¦ ///</summary> [SugarColumn(ColumnName="JVM_BARCODE_LENGTH" )] public decimal? JvmBarcodeLength { get; set; } /// <summary> /// æå°å½ä»¤ ///</summary> [SugarColumn(ColumnName="PRINT_COMMAND" )] public string PrintCommand { get; set; } /// <summary> /// æå°å½ä»¤å¼å§ ///</summary> [SugarColumn(ColumnName="PRINT_COMMAND_BEGIN" )] public string PrintCommandBegin { get; set; } /// <summary> /// æå°å½ä»¤ç»æ ///</summary> [SugarColumn(ColumnName="PRINT_COMMAND_END" )] public string PrintCommandEnd { get; set; } /// <summary> /// æ¡ç 注éè¡æ° ///</summary> [SugarColumn(ColumnName="BARCODE_INTERPRETATION_ROW" )] public decimal? BarcodeInterpretationRow { get; set; } /// <summary> /// æ¡ç å¼å¸¦ç©æç¼ç ///</summary> [SugarColumn(ColumnName="BARCODE_ITEM" )] public decimal? BarcodeItem { get; set; } /// <summary> /// æ¡ç ç±»åç¼ç ///</summary> [SugarColumn(ColumnName="TYPE_CODE" )] public decimal TypeCode { get; set; } /// <summary> /// æ¯å¦ä½¿ç¨ ///</summary> [SugarColumn(ColumnName="ISUSED" )] public short? Isused { get; set; } /// <summary> /// æå°æ¨¡æ¿ ///</summary> [SugarColumn(ColumnName="MBTYPE" )] public decimal? Mbtype { 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="ORDER_NUM" )] public decimal? OrderNum { get; set; } } } /// <summary> /// æ¡ç ç±»åID(seq_me_id) /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 使ç¨åºæ /// </summary> [SugarColumn(ColumnName = "USE_SITE")] public string UseSite { get; set; } /// <summary> /// æ¡ç ç±»åå称 /// </summary> [SugarColumn(ColumnName = "BARCODE_TYPE_NAME")] public string BarcodeTypeName { get; set; } /// <summary> /// ç å¶ /// </summary> [SugarColumn(ColumnName = "CODE")] public string Code { get; set; } /// <summary> /// æ¡ç 纸宽 /// </summary> [SugarColumn(ColumnName = "PAPER_WIDTH")] public decimal? PaperWidth { get; set; } /// <summary> /// æ¡ç çº¸é« /// </summary> [SugarColumn(ColumnName = "PAPER_HEIGHT")] public decimal? PaperHeight { get; set; } /// <summary> /// æ¡ç å¼å§ä½ç½®X /// </summary> [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_X")] public decimal? BarcodeBeginPositionX { get; set; } /// <summary> /// æ¡ç å¼å§ä½ç½®Y /// </summary> [SugarColumn(ColumnName = "BARCODE_BEGIN_POSITION_Y")] public decimal? BarcodeBeginPositionY { get; set; } /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¡ç ä¸ªæ° /// </summary> [SugarColumn(ColumnName = "PAPER_NUM")] public decimal? PaperNum { get; set; } /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¯è¡æ¡ç ä¸ªæ° /// </summary> [SugarColumn(ColumnName = "PAPER_ROW_NUM")] public decimal? PaperRowNum { get; set; } /// <summary> /// ä¸å¼ æ¡ç 纸ä¸æ¡ç åæ° /// </summary> [SugarColumn(ColumnName = "PAPER_COLUMN_NUM")] public decimal? PaperColumnNum { get; set; } /// <summary> /// æ¡ç æµæ°´å·å¾ªç¯ç±»å(æ§å¶æ¡ç æµæ°´å·) /// </summary> [SugarColumn(ColumnName = "CYCLE_TYPE")] public string CycleType { get; set; } /// <summary> /// æ¯å¦ææ(0-æ æ,1-ææ) /// </summary> [SugarColumn(ColumnName = "AVAILABLE_FLAG")] public decimal? AvailableFlag { get; set; } /// <summary> /// æ¡ç é«åº¦ /// </summary> [SugarColumn(ColumnName = "BARCODE_HEIGHT")] public decimal? BarcodeHeight { get; set; } /// <summary> /// æ¡ç åä½æ¹å /// </summary> [SugarColumn(ColumnName = "BARCODE_ORIENTATION")] public string BarcodeOrientation { get; set; } /// <summary> /// æ¡ç æå°æ³¨éè¡(1-æå°ï¼0-ä¸æå°) /// </summary> [SugarColumn(ColumnName = "BARCODE_INTERPRETATION")] public decimal? BarcodeInterpretation { get; set; } /// <summary> /// æ¡ç æå°æ³¨éè¡æå¨æ¡ç ä¸æ¹(1-æå°å¨æ¡ç ä¸æ¹ï¼0-ä¸æå°å¨æ¡ç ä¸æ¹) /// </summary> [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ABOVE")] public decimal? BarcodeInterpretationAbove { 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> /// æ¡ç 宽度 /// </summary> [SugarColumn(ColumnName = "BARCODE_WIDTH")] public decimal? BarcodeWidth { get; set; } /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]模åï¼çªæ¡ï¼å®½ /// </summary> [SugarColumn(ColumnName = "BY_W")] public decimal? ByW { get; set; } /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]宽æ¡ä¸çªæ¡çæ¯ä¾ /// </summary> [SugarColumn(ColumnName = "BY_R")] public decimal? ByR { get; set; } /// <summary> /// [æ¹åæ¡ç é»è®¤åæ°]æ¡ç é«åº¦ /// </summary> [SugarColumn(ColumnName = "BY_H")] public decimal? ByH { get; set; } /// <summary> /// ç¹æ°/毫米 /// </summary> [SugarColumn(ColumnName = "JM")] public string Jm { get; set; } /// <summary> /// èææ°æ®æ å¿(1-æ¯ï¼0ï¼å¦) /// </summary> [SugarColumn(ColumnName = "JVM_DATA_FLAG")] public decimal? JvmDataFlag { get; set; } /// <summary> /// èææ°æ®æµæ°´å·ä½æ° /// </summary> [SugarColumn(ColumnName = "JVM_SERIAL_DIGIT")] public decimal? JvmSerialDigit { get; set; } /// <summary> /// èææ°æ®æ¡ç é¿åº¦ /// </summary> [SugarColumn(ColumnName = "JVM_BARCODE_LENGTH")] public decimal? JvmBarcodeLength { get; set; } /// <summary> /// æå°å½ä»¤ /// </summary> [SugarColumn(ColumnName = "PRINT_COMMAND")] public string PrintCommand { get; set; } /// <summary> /// æå°å½ä»¤å¼å§ /// </summary> [SugarColumn(ColumnName = "PRINT_COMMAND_BEGIN")] public string PrintCommandBegin { get; set; } /// <summary> /// æå°å½ä»¤ç»æ /// </summary> [SugarColumn(ColumnName = "PRINT_COMMAND_END")] public string PrintCommandEnd { get; set; } /// <summary> /// æ¡ç 注éè¡æ° /// </summary> [SugarColumn(ColumnName = "BARCODE_INTERPRETATION_ROW")] public decimal? BarcodeInterpretationRow { get; set; } /// <summary> /// æ¡ç å¼å¸¦ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "BARCODE_ITEM")] public decimal? BarcodeItem { get; set; } /// <summary> /// æ¡ç ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TYPE_CODE")] public decimal TypeCode { get; set; } /// <summary> /// æ¯å¦ä½¿ç¨ /// </summary> [SugarColumn(ColumnName = "ISUSED")] public short? Isused { get; set; } /// <summary> /// æå°æ¨¡æ¿ /// </summary> [SugarColumn(ColumnName = "MBTYPE")] public decimal? Mbtype { 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 = "ORDER_NUM")] public decimal? OrderNum { get; set; } } MES.Service/Modes/MesDepTaskInfo.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,346 @@ using SqlSugar; namespace MES.Service.Modes; /// <summary> /// é¨é¨ç产订åä¿¡æ¯è¡¨ /// </summary> [SugarTable("MES_DEP_TASK_INFO")] public class MesDepTaskInfo { /// <summary> /// é¨é¨ç产订åID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 订åç¼å· /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// ERPç©æç¼å· /// </summary> [SugarColumn(ColumnName = "ERP_ITEM_NO")] public string ErpItemNo { get; set; } /// <summary> /// å·¥åæ°é /// </summary> [SugarColumn(ColumnName = "PLAN_QTY")] public decimal? PlanQty { get; set; } /// <summary> /// å·²ç产é /// </summary> [SugarColumn(ColumnName = "COMPLETE_QTY")] public decimal? CompleteQty { get; set; } /// <summary> /// å¤ææ°é /// </summary> [SugarColumn(ColumnName = "BACKUP_QTY")] public decimal? BackupQty { get; set; } /// <summary> /// ä¸è½½æ¶é´ /// </summary> [SugarColumn(ColumnName = "DOWN_TIME")] public DateTime? DownTime { get; set; } /// <summary> /// 计åå¼å§æ¶é´ /// </summary> [SugarColumn(ColumnName = "PLAN_BEGIN_TIME")] public DateTime? PlanBeginTime { get; set; } /// <summary> /// 计åç»ææ¶é´ /// </summary> [SugarColumn(ColumnName = "PLAN_FINISH_TIME")] public DateTime? PlanFinishTime { get; set; } /// <summary> /// å®é å®å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "REAL_FINISH_TIME")] public DateTime? RealFinishTime { get; set; } /// <summary> /// ç产ç¶æ(å¾ äº§\ç产\æèµ·\å®å·¥) /// </summary> [SugarColumn(ColumnName = "PRODUCE_STATE")] public string ProduceState { get; set; } /// <summary> /// å®é å¼å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "REAL_BEGIN_TIME")] public DateTime? RealBeginTime { get; set; } /// <summary> /// æ¯å¦æèµ· /// </summary> [SugarColumn(ColumnName = "HANG_UP")] public string HangUp { get; set; } /// <summary> /// ä»åºç¼å· /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// æ¥åºæ°é /// </summary> [SugarColumn(ColumnName = "DISCARD_QTY")] public decimal? DiscardQty { get; set; } /// <summary> /// å§æ¶ææ¶é´ /// </summary> [SugarColumn(ColumnName = "FIRST_ITEM_RECEIPT_TIME")] public DateTime? FirstItemReceiptTime { get; set; } /// <summary> /// å§é½ææ¶é´ /// </summary> [SugarColumn(ColumnName = "FIRST_ITEM_READY_TIME")] public DateTime? FirstItemReadyTime { get; set; } /// <summary> /// 客æ·ç¼å· /// </summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// åºè´§å è£ æ¹å¼ /// </summary> [SugarColumn(ColumnName = "PACK_SHIP_TYPE")] public string PackShipType { get; set; } /// <summary> /// å è£ æ³¨æäºé¡¹ /// </summary> [SugarColumn(ColumnName = "PACK_SHIP_MEMO")] public string PackShipMemo { get; set; } /// <summary> /// æ¯å¦å·²æ产 /// </summary> [SugarColumn(ColumnName = "ISSCHEME")] public short? Isscheme { get; set; } /// <summary> /// æ¡ç ç±»åID /// </summary> [SugarColumn(ColumnName = "BARCODE_TYPE_ID")] public decimal? BarcodeTypeId { get; set; } /// <summary> /// åå¸ç¶æ /// </summary> [SugarColumn(ColumnName = "ISSUE_STATUS")] public short? IssueStatus { get; set; } /// <summary> /// ç¶æï¼0=æ产æªåå¸ã1=æ产已åå¸ã2=å·²é¢æã3=å·²ç产ã4=æåã8=å·²å®å·¥ã9=å¼å¸¸ï¼ /// </summary> [SugarColumn(ColumnName = "FLAG")] public short? Flag { get; set; } /// <summary> /// é¢ææ¶é´ /// </summary> [SugarColumn(ColumnName = "MAT_DATE")] public DateTime? MatDate { get; set; } /// <summary> /// å·¥ä½ä¸å¿ /// </summary> [SugarColumn(ColumnName = "WORKCENTER_NO")] public string WorkcenterNo { get; set; } /// <summary> /// å·²ä¸è½½è®¢åæ è¯Y-å·²ä¸è½½,N-æªä¸è½½ /// </summary> [SugarColumn(ColumnName = "DOWN_FLAG")] public short? DownFlag { get; set; } /// <summary> /// ç¯ä¿ä»£ç /// </summary> [SugarColumn(ColumnName = "ROHSE_CODE")] public string RohseCode { get; set; } /// <summary> /// 客æ·PO /// </summary> [SugarColumn(ColumnName = "CUST_PO")] public string CustPo { get; set; } /// <summary> /// 客æ·åå· /// </summary> [SugarColumn(ColumnName = "CUST_STYLE")] public string CustStyle { get; set; } /// <summary> /// 产åæå°åºå®å¼ /// </summary> [SugarColumn(ColumnName = "PROC_PRINT_VALUE")] public string ProcPrintValue { 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> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "MEMO")] public string Memo { get; set; } /// <summary> /// 审æ¹ç¶æ /// </summary> [SugarColumn(ColumnName = "FCHECK_STATUS")] public string FcheckStatus { get; set; } /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { 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 = "DATA_FROM")] public string DataFrom { get; set; } /// <summary> /// ç产订å表头ID /// </summary> [SugarColumn(ColumnName = "MOID")] public decimal? Moid { get; set; } /// <summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "PARTID")] public decimal? Partid { get; set; } /// <summary> /// ERPå·¥åç¶æ ç¶æï¼NA-å¼ç«/FM-éå®/OP-å®¡æ ¸/CL-å ³éï¼ /// </summary> [SugarColumn(ColumnName = "STATUS")] public string Status { get; set; } /// <summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "MOCODE")] public string Mocode { get; set; } /// <summary> /// å建æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATEDATE")] public DateTime? Createdate { get; set; } /// <summary> /// é¢è² /// </summary> [SugarColumn(ColumnName = "COLOR_NAME")] public string ColorName { get; set; } /// <summary> /// å ³éæ¶é´ /// </summary> [SugarColumn(ColumnName = "CLOSETIME")] public DateTime? Closetime { get; set; } /// <summary> /// ç©æç¼å· /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// ä»è¡¨ID /// </summary> [SugarColumn(ColumnName = "MODID")] public decimal? Modid { get; set; } /// <summary> /// ææ°ä¸è½½æ´æ°æ è¯ /// </summary> [SugarColumn(ColumnName = "UPDATE_FLG")] public decimal? UpdateFlg { get; set; } /// <summary> /// ç产工åè¡å· /// </summary> [SugarColumn(ColumnName = "MOCODE_LINE")] public decimal? MocodeLine { get; set; } /// <summary> /// ä¸å°æ»æ° /// </summary> [SugarColumn(ColumnName = "SILK_QTY")] public decimal? SilkQty { get; set; } /// <summary> /// ä¸å°åä»· /// </summary> [SugarColumn(ColumnName = "SILK_PRICE")] public decimal? SilkPrice { get; set; } /// <summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } } MES.Service/Modes/MesInvBusiness2.cs
@@ -8,220 +8,220 @@ [SugarTable("MES_INV_BUSINESS2")] public class MesInvBusiness2 { /// <summary> /// ID(seq_inv_id) /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID", /// <summary> /// ID(seq_inv_id) /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// ç¶æ|0-æªäº¤æ1-已交æ /// </summary> [SugarColumn(ColumnName = "STATUS")] /// <summary> /// ç¶æ|0-æªäº¤æ1-已交æ /// </summary> [SugarColumn(ColumnName = "STATUS")] public decimal? Status { get; set; } /// <summary> /// åæ®ç±»åID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] /// <summary> /// åæ®ç±»åID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } /// <summary> /// äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSACTION_CODE")] /// <summary> /// äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSACTION_CODE")] public string TransactionCode { 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> /// åæ®ID /// </summary> [SugarColumn(ColumnName = "BILL_ID")] /// <summary> /// åæ®ID /// </summary> [SugarColumn(ColumnName = "BILL_ID")] public decimal? BillId { get; set; } /// <summary> /// åæ®ç¼ç /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// åæ®ç¼ç /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// ç产订åå· /// </summary> [SugarColumn(ColumnName = "TASK_NO")] /// <summary> /// ç产订åå· /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// 客æ·ç¼å· /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NO")] /// <summary> /// 客æ·ç¼å· /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NO")] public string CustomerNo { get; set; } /// <summary> /// åæ®è¡ID /// </summary> [SugarColumn(ColumnName = "BILL_LINE_ID")] /// <summary> /// åæ®è¡ID /// </summary> [SugarColumn(ColumnName = "BILL_LINE_ID")] public decimal? BillLineId { get; set; } /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// æ¬å¸ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// æ¬å¸ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// 客æ·ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] /// <summary> /// 客æ·ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } /// <summary> /// å家æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] /// <summary> /// å家æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ¯å¦ç¯ä¿(0:å¦,1:æ¯) /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] /// <summary> /// æ¯å¦ç¯ä¿(0:å¦,1:æ¯) /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } /// <summary> /// æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] /// <summary> /// æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// æºååºCODE /// </summary> [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")] /// <summary> /// æºååºCODE /// </summary> [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")] public string FromInvDepotsCode { get; set; } /// <summary> /// æºè´§ä½CODE /// </summary> [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")] /// <summary> /// æºè´§ä½CODE /// </summary> [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")] public string FromInvDepotSectionsCode { get; set; } /// <summary> /// ç®çååºCODE /// </summary> [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")] /// <summary> /// ç®çååºCODE /// </summary> [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")] public string ToInvDepotsCode { get; set; } /// <summary> /// ç®çè´§ä½CODE /// </summary> [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")] /// <summary> /// ç®çè´§ä½CODE /// </summary> [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")] public string ToInvDepotSectionsCode { get; set; } /// <summary> /// 交æå¼å¸¸ä¿¡æ¯ /// </summary> [SugarColumn(ColumnName = "DESCRIPTION")] /// <summary> /// 交æå¼å¸¸ä¿¡æ¯ /// </summary> [SugarColumn(ColumnName = "DESCRIPTION")] public string Description { 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 = "ULLAGE_STAT_FLAG")] /// <summary> /// è¶ æç»è®¡æ è¯ /// </summary> [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")] public short? UllageStatFlag { 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 = "ITEM_BARCODE2")] /// <summary> /// ç®±å·æ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE2")] public string ItemBarcode2 { get; set; } /// <summary> /// å¡æ¿æ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE3")] /// <summary> /// å¡æ¿æ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE3")] public string ItemBarcode3 { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// ç产线 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] /// <summary> /// ç产线 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } /// <summary> /// éè´è®¢åid /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] /// <summary> /// éè´è®¢åid /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] public decimal? EbelnK3id { get; set; } /// <summary> /// éè´è®¢åè¡id /// </summary> [SugarColumn(ColumnName = "LINE_K3ID")] /// <summary> /// éè´è®¢åè¡id /// </summary> [SugarColumn(ColumnName = "LINE_K3ID")] public decimal? LineK3id { 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; }
@@ -16,482 +16,481 @@ public decimal Id { get; set; } /// <summary> /// ç©ææ¡ç ///</summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// 客æ·æåç¼ç ///</summary> /// 客æ·æåç¼ç /// </summary> [SugarColumn(ColumnName = "C_PRODUCT_CODE")] public string CProductCode { get; set; } /// <summary> /// 客æ·ç©ææ¡ç ///</summary> /// 客æ·ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "C_ITEM_BARCODE")] public string CItemBarcode { get; set; } /// <summary> /// 客æ·ç©æç¼ç ///</summary> /// 客æ·ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } /// <summary> /// æ¬å¸ç©æç¼ç ///</summary> /// æ¬å¸ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// å家æ¹æ¬¡ ///</summary> /// å家æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ°é ///</summary> /// æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// æ¯å¦ç¯ä¿(0:å¦,1:æ¯) ///</summary> /// æ¯å¦ç¯ä¿(0:å¦,1:æ¯) /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } /// <summary> /// ç产工å ///</summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// å建人 ///</summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ ///</summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº ///</summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ ///</summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// 客æ·ç¼å· ///</summary> /// 客æ·ç¼å· /// </summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// ç©ææ¡ç 注éè¡[åä½ï¼æ¡ç éæ使ç¨] ///</summary> /// ç©ææ¡ç 注éè¡[åä½ï¼æ¡ç éæ使ç¨] /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")] public string ItemBarcodeText { get; set; } /// <summary> /// åPSNç©ææ¡ç ///</summary> /// åPSNç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")] public string OldItemBarcode { get; set; } /// <summary> /// SAPæ¶è´§ç©æåè¯å· --éè´åå· ///</summary> /// SAPæ¶è´§ç©æåè¯å· --éè´åå· /// </summary> [SugarColumn(ColumnName = "MBLNR")] public string Mblnr { get; set; } /// <summary> /// SAPæ¶è´§ç©æåè¯è¡å· --éè´åè¡å· ///</summary> /// SAPæ¶è´§ç©æåè¯è¡å· --éè´åè¡å· /// </summary> [SugarColumn(ColumnName = "ZEILE")] public decimal? Zeile { get; set; } /// <summary> /// æ¶æ表ID ///</summary> /// æ¶æ表ID /// </summary> [SugarColumn(ColumnName = "ROH_IN_ID")] public decimal? RohInId { get; set; } /// <summary> /// 0为æææ¡ç ï¼1为æ ææ¡ç ///</summary> /// 0为æææ¡ç ï¼1为æ ææ¡ç /// </summary> [SugarColumn(ColumnName = "BARCODESTATUS")] public short? Barcodestatus { get; set; } /// <summary> /// åå§æ°é ///</summary> /// åå§æ°é /// </summary> [SugarColumn(ColumnName = "OLDQTY")] public decimal? Oldqty { get; set; } /// <summary> /// 使ç¨æ°é ///</summary> /// 使ç¨æ°é /// </summary> [SugarColumn(ColumnName = "USEQTY")] public decimal? Useqty { get; set; } /// <summary> /// 0å¨åºï¼1å¨çº¿ï¼2ä½åº ///</summary> /// 0å¨åºï¼1å¨çº¿ï¼2ä½åº /// </summary> [SugarColumn(ColumnName = "LOCATION")] public short? Location { get; set; } /// <summary> /// åä½ ///</summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } /// <summary> /// ééï¼åä½ï¼å ¬æ¤ï¼ ///</summary> /// ééï¼åä½ï¼å ¬æ¤ï¼ /// </summary> [SugarColumn(ColumnName = "WEIGHT_UNIT")] public decimal? WeightUnit { get; set; } /// <summary> /// åä»· ///</summary> /// åä»· /// </summary> [SugarColumn(ColumnName = "PRICE")] public decimal? Price { get; set; } /// <summary> /// åæ¡ç æ°é ///</summary> /// åæ¡ç æ°é /// </summary> [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")] public decimal? OldBarQuantity { get; set; } /// <summary> /// æ±æ»æ¡ç ///</summary> /// æ±æ»æ¡ç /// </summary> [SugarColumn(ColumnName = "SUM_BARCODE")] public string SumBarcode { get; set; } /// <summary> /// ç产æ¥æ ///</summary> /// ç产æ¥æ /// </summary> [SugarColumn(ColumnName = "LOT_DATE")] public string LotDate { get; set; } /// <summary> /// æ¨¡å· ///</summary> /// æ¨¡å· /// </summary> [SugarColumn(ColumnName = "MOCODE")] public string Mocode { get; set; } /// <summary> /// æ¥æº ///</summary> /// æ¥æº /// </summary> [SugarColumn(ColumnName = "MEMO")] public string Memo { get; set; } /// <summary> /// ä¾åºåç¼ç ///</summary> /// ä¾åºåç¼ç /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// æ¡£ä½ä½å¼ ///</summary> /// æ¡£ä½ä½å¼ /// </summary> [SugarColumn(ColumnName = "SPOSTION")] public string Spostion { get; set; } /// <summary> /// æ¡£ä½é«å¼ ///</summary> /// æ¡£ä½é«å¼ /// </summary> [SugarColumn(ColumnName = "EPOSTION")] public string Epostion { get; set; } /// <summary> /// ç©æç®ç§° ///</summary> /// ç©æç®ç§° /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } /// <summary> /// æ¯å¦å·²å»ç»,1å»ç» ///</summary> /// æ¯å¦å·²å»ç»,1å»ç» /// </summary> [SugarColumn(ColumnName = "VISABLE")] public short? Visable { get; set; } /// <summary> /// ä¾åºåæ¹æ¬¡ ///</summary> /// ä¾åºåæ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "TR_LOTNO")] public string TrLotno { get; set; } /// <summary> /// å»ç»æ¶é´ ///</summary> /// å»ç»æ¶é´ /// </summary> [SugarColumn(ColumnName = "FLEZZ_DATE")] public DateTime? FlezzDate { get; set; } /// <summary> /// å»ç»åå ///</summary> /// å»ç»åå /// </summary> [SugarColumn(ColumnName = "FLEZZ_REASON")] public string FlezzReason { get; set; } /// <summary> /// å»ç»äºº ///</summary> /// å»ç»äºº /// </summary> [SugarColumn(ColumnName = "FLEZZ_BY")] public string FlezzBy { get; set; } /// <summary> /// 延é¿ä¿è´¨æ ///</summary> /// 延é¿ä¿è´¨æ /// </summary> [SugarColumn(ColumnName = "DELANY_MONTH")] public decimal? DelanyMonth { get; set; } /// <summary> /// æå°å è£ æ è¯ ///</summary> /// æå°å è£ æ è¯ /// </summary> [SugarColumn(ColumnName = "MINPACK_FLAG")] public short? MinpackFlag { get; set; } /// <summary> /// æå°IDï¼ç¨æ¥åºåæå°æ¬¡æ° ///</summary> /// æå°IDï¼ç¨æ¥åºåæå°æ¬¡æ° /// </summary> [SugarColumn(ColumnName = "PRINT_ID")] public string PrintId { get; set; } /// <summary> /// ç¯ä¿é¡¹ç® ///</summary> /// ç¯ä¿é¡¹ç® /// </summary> [SugarColumn(ColumnName = "EP_ITEM")] public string EpItem { get; set; } /// <summary> /// å·¥åç¼å· ///</summary> /// å·¥åç¼å· /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ç¼å· ///</summary> /// å ¬å¸ç¼å· /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// å¡æ¿ç¼ç ///</summary> /// å¡æ¿ç¼ç /// </summary> [SugarColumn(ColumnName = "CB_NO")] public string CbNo { get; set; } /// <summary> /// å家ç产线 ///</summary> /// å家ç产线 /// </summary> [SugarColumn(ColumnName = "LINFLINE")] public string Linfline { get; set; } /// <summary> /// æææ ///</summary> /// æææ /// </summary> [SugarColumn(ColumnName = "VALID_TIME")] public DateTime? ValidTime { get; set; } /// <summary> /// è´¨æ£ç»æ ///</summary> /// è´¨æ£ç»æ /// </summary> [SugarColumn(ColumnName = "IQC_STATUS")] public string IqcStatus { get; set; } /// <summary> /// å°è½¦æ¡ç ///</summary> /// å°è½¦æ¡ç /// </summary> [SugarColumn(ColumnName = "FCAR")] public string Fcar { get; set; } /// <summary> /// æ¯é ///</summary> /// æ¯é /// </summary> [SugarColumn(ColumnName = "GWEIGHT")] public string Gweight { get; set; } /// <summary> /// åé ///</summary> /// åé /// </summary> [SugarColumn(ColumnName = "NWEIGHT")] public string Nweight { get; set; } /// <summary> /// ä¿è´¨æ ///</summary> /// ä¿è´¨æ /// </summary> [SugarColumn(ColumnName = "EXT_DATE")] public decimal? ExtDate { get; set; } /// <summary> /// ä¾åºåãèµ åã客ä¾æãå§å¤ ///</summary> /// ä¾åºåãèµ åã客ä¾æãå§å¤ /// </summary> [SugarColumn(ColumnName = "BARCODETYPE")] public string Barcodetype { get; set; } /// <summary> /// ä¾åºåå称 ///</summary> /// ä¾åºåå称 /// </summary> [SugarColumn(ColumnName = "SUPP_NAME")] public string SuppName { get; set; } /// <summary> /// å°è´§åå·/å ¥åºåå· ///</summary> /// å°è´§åå·/å ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// æ¥ææ è¯ ///</summary> /// æ¥ææ è¯ /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] public short? UrgentFlag { get; set; } /// <summary> /// é¢è² ///</summary> /// é¢è² /// </summary> [SugarColumn(ColumnName = "COLOR_NAME")] public string ColorName { get; set; } /// <summary> /// 产ååå· ///</summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// æ¥ææ¥æ ///</summary> /// æ¥ææ¥æ /// </summary> [SugarColumn(ColumnName = "INS_DATE")] public DateTime? InsDate { get; set; } /// <summary> /// å°è´§åè¡å· ///</summary> /// å°è´§åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ä¸è¯åå ///</summary> /// ä¸è¯åå /// </summary> [SugarColumn(ColumnName = "MEMO_BAD")] public string MemoBad { get; set; } /// <summary> /// ä»»å¡åå· ///</summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// æ¡ç æ¥æºæ è¯ï¼0-åæç©æ,1-éè´å ¥åºï¼2ãç产éæï¼3ãå ¶å®å ¥åºï¼4-客ä¾æ,5-å¨åºåæï¼6-å¶ç¨æ¡ç ///</summary> /// æ¡ç æ¥æºæ è¯ï¼0-åæç©æ,1-éè´å ¥åºï¼2ãç产éæï¼3ãå ¶å®å ¥åºï¼4-客ä¾æ,5-å¨åºåæï¼6-å¶ç¨æ¡ç /// </summary> [SugarColumn(ColumnName = "COME_FLG")] public short? ComeFlg { get; set; } /// <summary> /// çäº§çº¿ä½ ///</summary> /// çäº§çº¿ä½ /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } /// <summary> /// ä¸å°æ¬¡æ° ///</summary> /// ä¸å°æ¬¡æ° /// </summary> [SugarColumn(ColumnName = "SILK_PQTY")] public decimal? SilkPqty { get; set; } /// <summary> /// ä¸å°æ¬¡æ°æ¯ ///</summary> /// ä¸å°æ¬¡æ°æ¯ /// </summary> [SugarColumn(ColumnName = "SILK")] public string Silk { get; set; } /// <summary> /// ä¸å°æ´¾å·¥ä»è¡¨ID ///</summary> /// ä¸å°æ´¾å·¥ä»è¡¨ID /// </summary> [SugarColumn(ColumnName = "SILK_ID")] public decimal? SilkId { get; set; } /// <summary> /// å·²æ¥å·¥æ è¯ ///</summary> /// å·²æ¥å·¥æ è¯ /// </summary> [SugarColumn(ColumnName = "WORK_FLG")] public decimal? WorkFlg { get; set; } /// <summary> /// æåå·¥åº ///</summary> /// æåå·¥åº /// </summary> [SugarColumn(ColumnName = "WORK_LAST")] public decimal? WorkLast { get; set; } /// <summary> /// 0-æªå并æå°ï¼1-å并æå° ///</summary> /// 0-æªå并æå°ï¼1-å并æå° /// </summary> [SugarColumn(ColumnName = "HBDY")] public decimal? Hbdy { get; set; } /// <summary> /// 0-æææ¡ç ï¼1-å并æåçæ¡ç ï¼æ æ ///</summary> /// 0-æææ¡ç ï¼1-å并æåçæ¡ç ï¼æ æ /// </summary> [SugarColumn(ColumnName = "HBDYTM")] public decimal? Hbdytm { get; set; } /// <summary> /// æ¥å·¥æ¶é´ ///</summary> /// æ¥å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "WORK_FLGTIME")] public string WorkFlgtime { get; set; } /// <summary> /// éè´è®¢åID ///</summary> /// éè´è®¢åID /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] public decimal? EbelnK3id { get; set; } /// <summary> /// éè´è®¢åè¡ID ///</summary> /// éè´è®¢åè¡ID /// </summary> [SugarColumn(ColumnName = "LINE_K3ID")] public decimal? LineK3id { get; set; } /// <summary> /// ///</summary> /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } /// <summary> /// ç产工åºID ///</summary> /// ç产工åºID /// </summary> [SugarColumn(ColumnName = "GX_ID")] public decimal? GxId { get; set; } /// <summary> /// ç»ç»id ///</summary> /// ç»ç»id /// </summary> [SugarColumn(ColumnName = "ORG_NAME")] public string OrgName { get; set; } /// <summary> /// 货主id ///</summary> /// 货主id /// </summary> [SugarColumn(ColumnName = "ORG_OWNER")] public string OrgOwner { 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/MesInvItemOutCDetails.cs
@@ -239,4 +239,6 @@ [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; } [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; } [SugarColumn(IsIgnore = true)] public string? Unit { get; set; } [SugarColumn(IsIgnore = true)] public string DepotSectionName { get; set; } } MES.Service/Modes/MesInvItemOutItems.cs
@@ -87,11 +87,13 @@ public string? TaskNo { get; set; } /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string? WorkNo { get; set; } /// <summary> /// å°è´§åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } @@ -179,7 +181,7 @@ public decimal? Allocateid { get; set; } /// <summary> /// é¢æç¼å· /// é¢æç¼å·/ç产工å /// </summary> [SugarColumn(ColumnName = "PBILL_NO")] public string? PbillNo { get; set; } @@ -208,7 +210,17 @@ [SugarColumn(ColumnName = "TL_QTY")] public decimal? TlQty { get; set; } [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } /// <summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } /// <summary> /// ç©æææåID /// </summary> [SugarColumn(ColumnName = "ITEM_DABID")] public decimal? ItemDabid { get; set; } [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; } [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; } MES.Service/Modes/MesInvTransaction.cs
@@ -1,74 +1,82 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; namespace MES.Service.Modes using SqlSugar; namespace MES.Service.Modes; /// <summary> /// åºåäºå¡å¤ç表 /// </summary> [SugarTable("MES_INV_TRANSACTION")] public class MesInvTransaction { /// <summary> /// åºåäºå¡å¤ç表 ///</summary> [SugarTable("MES_INV_TRANSACTION")] public class MesInvTransaction { /// <summary> /// ID ///</summary> [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )] public decimal Id { get; set; } /// <summary> /// äºå¡ç±»å ///</summary> [SugarColumn(ColumnName="TRANSACTION_NAME" )] public string TransactionName { get; set; } /// <summary> /// å¤æ³¨ ///</summary> [SugarColumn(ColumnName="REMARK" )] public string Remark { 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> /// åæ®ID ///</summary> [SugarColumn(ColumnName="BUSINESS_ID" )] public decimal? BusinessId { get; set; } /// <summary> /// 交æç±»å|1-å ¥åº0-转åº-1åºåº ///</summary> [SugarColumn(ColumnName="BUSINESS_TYPE" )] public decimal? BusinessType { get; set; } /// <summary> /// äºå¡ç¼ç ///</summary> [SugarColumn(ColumnName="TRANSACTION_NO" )] public decimal? TransactionNo { get; set; } /// <summary> /// ååç¼ç ///</summary> [SugarColumn(ColumnName="FACTORY" )] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç ///</summary> [SugarColumn(ColumnName="COMPANY" )] public string Company { get; set; } } } /// <summary> /// ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// äºå¡ç±»å /// </summary> [SugarColumn(ColumnName = "TRANSACTION_NAME")] public string TransactionName { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { 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> /// åæ®ID /// </summary> [SugarColumn(ColumnName = "BUSINESS_ID")] public decimal? BusinessId { get; set; } /// <summary> /// 交æç±»å|1-å ¥åº0-转åº-1åºåº /// </summary> [SugarColumn(ColumnName = "BUSINESS_TYPE")] public decimal? BusinessType { get; set; } /// <summary> /// äºå¡ç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSACTION_NO")] public decimal? TransactionNo { get; set; } /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } } MES.Service/Modes/MesItems.cs
@@ -1,322 +1,318 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; using SqlSugar; namespace MES.Service.Modes namespace MES.Service.Modes; /// <summary> /// ç©æä¿¡æ¯ /// </summary> [SugarTable("MES_ITEMS")] public class MesItems { /// <summary> /// ç©æä¿¡æ¯ ///</summary> [SugarTable("MES_ITEMS")] public class MesItems { /// <summary> /// ç©æID ///</summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// ç©æID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// å·¥å ///</summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å·¥å /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ç¼å· ///</summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// å ¬å¸ç¼å· /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// ç©æç¼ç = ERPç©æç¼å·||é¢è²ç¼å· ///</summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// ç©æç¼ç = ERPç©æç¼å·||é¢è²ç¼å· /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// ç©æå称 ///</summary> [SugarColumn(ColumnName = "ITEM_NAME")] public string ItemName { get; set; } /// <summary> /// ç©æå称 /// </summary> [SugarColumn(ColumnName = "ITEM_NAME")] public string ItemName { get; set; } /// <summary> /// ç©æç®ç§° ///</summary> [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } /// <summary> /// ç©æç®ç§° /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } /// <summary> /// è§æ ¼åå· ///</summary> [SugarColumn(ColumnName = "ITEM_MODEL")] public string ItemModel { get; set; } /// <summary> /// è§æ ¼åå· /// </summary> [SugarColumn(ColumnName = "ITEM_MODEL")] public string ItemModel { get; set; } /// <summary> /// ç©ææè¿° ///</summary> [SugarColumn(ColumnName = "ITEM_DESCRIPTION")] public string ItemDescription { get; set; } /// <summary> /// ç©ææè¿° /// </summary> [SugarColumn(ColumnName = "ITEM_DESCRIPTION")] public string ItemDescription { get; set; } /// <summary> /// ç©æåä½ ///</summary> [SugarColumn(ColumnName = "ITEM_UNIT")] public string ItemUnit { get; set; } /// <summary> /// ç©æåä½ /// </summary> [SugarColumn(ColumnName = "ITEM_UNIT")] public string ItemUnit { get; set; } /// <summary> /// ç©æç±»å ///</summary> [SugarColumn(ColumnName = "ITEM_TYPE")] public string ItemType { get; set; } /// <summary> /// ç©æç±»å /// </summary> [SugarColumn(ColumnName = "ITEM_TYPE")] public string ItemType { get; set; } /// <summary> /// 产åçæ¬ ///</summary> [SugarColumn(ColumnName = "ITEM_VERSION")] public string ItemVersion { get; set; } /// <summary> /// 产åçæ¬ /// </summary> [SugarColumn(ColumnName = "ITEM_VERSION")] public string ItemVersion { get; set; } /// <summary> /// 客æ·ç¼å· ///</summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// 客æ·ç¼å· /// </summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// å建人 ///</summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ ///</summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº ///</summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ ///</summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// æä½åºå ///</summary> [SugarColumn(ColumnName = "LOWLIMIT")] public double? Lowlimit { get; set; } /// <summary> /// æä½åºå /// </summary> [SugarColumn(ColumnName = "LOWLIMIT")] public double? Lowlimit { get; set; } /// <summary> /// æ大åºå ///</summary> [SugarColumn(ColumnName = "HIGHLIMIT")] public double? Highlimit { get; set; } /// <summary> /// æ大åºå /// </summary> [SugarColumn(ColumnName = "HIGHLIMIT")] public double? Highlimit { get; set; } /// <summary> /// æå°å è£ æ° ///</summary> [SugarColumn(ColumnName = "PRD_PACK")] public double? PrdPack { get; set; } /// <summary> /// æå°å è£ æ° /// </summary> [SugarColumn(ColumnName = "PRD_PACK")] public double? PrdPack { get; set; } /// <summary> /// 订ååä½ ///</summary> [SugarColumn(ColumnName = "ORDERUNIT")] public string Orderunit { get; set; } /// <summary> /// 订ååä½ /// </summary> [SugarColumn(ColumnName = "ORDERUNIT")] public string Orderunit { get; set; } /// <summary> /// éå®åä½ ///</summary> [SugarColumn(ColumnName = "SALEUNIT")] public string Saleunit { get; set; } /// <summary> /// éå®åä½ /// </summary> [SugarColumn(ColumnName = "SALEUNIT")] public string Saleunit { get; set; } /// <summary> /// åºæ¿åä½ ///</summary> [SugarColumn(ColumnName = "STOREUNIT")] public string Storeunit { get; set; } /// <summary> /// åºæ¿åä½ /// </summary> [SugarColumn(ColumnName = "STOREUNIT")] public string Storeunit { get; set; } /// <summary> /// ç产åä½ ///</summary> [SugarColumn(ColumnName = "PRODUCTUNIT")] public string Productunit { get; set; } /// <summary> /// ç产åä½ /// </summary> [SugarColumn(ColumnName = "PRODUCTUNIT")] public string Productunit { get; set; } /// <summary> /// ç©æID ///</summary> [SugarColumn(ColumnName = "E_ITEM_ID")] public decimal? EItemId { get; set; } /// <summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "E_ITEM_ID")] public decimal? EItemId { get; set; } /// <summary> /// ERPæå· ///</summary> [SugarColumn(ColumnName = "ERP_ITEM_NO")] public string ErpItemNo { get; set; } /// <summary> /// ERPæå· /// </summary> [SugarColumn(ColumnName = "ERP_ITEM_NO")] public string ErpItemNo { get; set; } /// <summary> /// é»è®¤ä»åº ///</summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// é»è®¤ä»åº /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// ç©æåç±»ç¼å· ///</summary> [SugarColumn(ColumnName = "PPBOM00019124")] public string Ppbom00019124 { get; set; } /// <summary> /// ç©æåç±»ç¼å· /// </summary> [SugarColumn(ColumnName = "PPBOM00019124")] public string Ppbom00019124 { get; set; } /// <summary> /// ç©æåç» ///</summary> [SugarColumn(ColumnName = "REMARKS")] public string Remarks { get; set; } /// <summary> /// ç©æåç» /// </summary> [SugarColumn(ColumnName = "REMARKS")] public string Remarks { get; set; } /// <summary> /// éè´å ///</summary> [SugarColumn(ColumnName = "FPURCHASERID")] public string Fpurchaserid { get; set; } /// <summary> /// éè´å /// </summary> [SugarColumn(ColumnName = "FPURCHASERID")] public string Fpurchaserid { get; set; } /// <summary> /// ç¦ç¨ç¶æ ///</summary> [SugarColumn(ColumnName = "FFORBIDSTATUS")] public string Fforbidstatus { get; set; } /// <summary> /// ç¦ç¨ç¶æ /// </summary> [SugarColumn(ColumnName = "FFORBIDSTATUS")] public string Fforbidstatus { get; set; } /// <summary> /// ç©æåç» ///</summary> [SugarColumn(ColumnName = "FMATERIALGROUP")] public string Fmaterialgroup { get; set; } /// <summary> /// ç©æåç» /// </summary> [SugarColumn(ColumnName = "FMATERIALGROUP")] public string Fmaterialgroup { get; set; } /// <summary> /// å®å·¥è¶ æ¶æ¯ä¾ ///</summary> [SugarColumn(ColumnName = "FFINISHRECEIPTOVERRATE")] public decimal? Ffinishreceiptoverrate { get; set; } /// <summary> /// å®å·¥è¶ æ¶æ¯ä¾ /// </summary> [SugarColumn(ColumnName = "FFINISHRECEIPTOVERRATE")] public decimal? Ffinishreceiptoverrate { get; set; } /// <summary> /// åææ¹å¼ ///</summary> [SugarColumn(ColumnName = "FISSUETYPE")] public string Fissuetype { get; set; } /// <summary> /// åææ¹å¼ /// </summary> [SugarColumn(ColumnName = "FISSUETYPE")] public string Fissuetype { get; set; } /// <summary> /// å¯ç¨æ¹å·ç®¡ç ///</summary> [SugarColumn(ColumnName = "FISBATCHMANAGE")] public decimal? Fisbatchmanage { get; set; } /// <summary> /// å¯ç¨æ¹å·ç®¡ç /// </summary> [SugarColumn(ColumnName = "FISBATCHMANAGE")] public decimal? Fisbatchmanage { get; set; } /// <summary> /// éè´åä½ ///</summary> [SugarColumn(ColumnName = "FPURCHASEUNITID")] public string Fpurchaseunitid { get; set; } /// <summary> /// éè´åä½ /// </summary> [SugarColumn(ColumnName = "FPURCHASEUNITID")] public string Fpurchaseunitid { get; set; } /// <summary> /// èªå®ä¹å段1 ///</summary> [SugarColumn(ColumnName = "REMARK1")] public string Remark1 { get; set; } /// <summary> /// èªå®ä¹å段1 /// </summary> [SugarColumn(ColumnName = "REMARK1")] public string Remark1 { get; set; } /// <summary> /// èªå®ä¹å段2 ///</summary> [SugarColumn(ColumnName = "REMARK2")] public string Remark2 { get; set; } /// <summary> /// èªå®ä¹å段2 /// </summary> [SugarColumn(ColumnName = "REMARK2")] public string Remark2 { get; set; } /// <summary> /// èªå®ä¹å段3 ///</summary> [SugarColumn(ColumnName = "REMARK3")] public string Remark3 { get; set; } /// <summary> /// èªå®ä¹å段3 /// </summary> [SugarColumn(ColumnName = "REMARK3")] public string Remark3 { get; set; } /// <summary> /// èªå®ä¹å段4 ///</summary> [SugarColumn(ColumnName = "REMARK4")] public string Remark4 { get; set; } /// <summary> /// èªå®ä¹å段4 /// </summary> [SugarColumn(ColumnName = "REMARK4")] public string Remark4 { get; set; } /// <summary> /// èªå®ä¹å段5 ///</summary> [SugarColumn(ColumnName = "REMARK5")] public string Remark5 { get; set; } /// <summary> /// èªå®ä¹å段5 /// </summary> [SugarColumn(ColumnName = "REMARK5")] public string Remark5 { get; set; } /// <summary> /// çäº§è½¦é´ ///</summary> [SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")] public string ProductionWorkshop { get; set; } /// <summary> /// çäº§è½¦é´ /// </summary> [SugarColumn(ColumnName = "PRODUCTION_WORKSHOP")] public string ProductionWorkshop { get; set; } /// <summary> /// ç©æå±æ§ ///</summary> [SugarColumn(ColumnName = "MATERIAL_PROPERTI")] public string MaterialProperti { get; set; } /// <summary> /// ç©æå±æ§ /// </summary> [SugarColumn(ColumnName = "MATERIAL_PROPERTI")] public string MaterialProperti { get; set; } /// <summary> /// ç产åä½ ///</summary> [SugarColumn(ColumnName = "PRODUCE_UNIT")] public string ProduceUnit { get; set; } /// <summary> /// ç产åä½ /// </summary> [SugarColumn(ColumnName = "PRODUCE_UNIT")] public string ProduceUnit { get; set; } /// <summary> /// å§å¤åä½ ///</summary> [SugarColumn(ColumnName = "SUBCON_UNIT")] public string SubconUnit { get; set; } /// <summary> /// å§å¤åä½ /// </summary> [SugarColumn(ColumnName = "SUBCON_UNIT")] public string SubconUnit { get; set; } /// <summary> /// å¾ç1 ///</summary> [SugarColumn(ColumnName = "BZ06")] public string Bz06 { get; set; } /// <summary> /// å¾ç1 /// </summary> [SugarColumn(ColumnName = "BZ06")] public string Bz06 { get; set; } /// <summary> /// å¾ç2 ///</summary> [SugarColumn(ColumnName = "BZ07")] public string Bz07 { get; set; } /// <summary> /// å¾ç2 /// </summary> [SugarColumn(ColumnName = "BZ07")] public string Bz07 { get; set; } /// <summary> /// å¾ç3 ///</summary> [SugarColumn(ColumnName = "BZ08")] public string Bz08 { get; set; } /// <summary> /// å¾ç3 /// </summary> [SugarColumn(ColumnName = "BZ08")] public string Bz08 { get; set; } /// <summary> /// å¾ç4 ///</summary> [SugarColumn(ColumnName = "BZ09")] public string Bz09 { get; set; } /// <summary> /// å¾ç4 /// </summary> [SugarColumn(ColumnName = "BZ09")] public string Bz09 { get; set; } /// <summary> /// å¾ç5 ///</summary> [SugarColumn(ColumnName = "BZ10")] public string Bz10 { get; set; } /// <summary> /// å¾ç5 /// </summary> [SugarColumn(ColumnName = "BZ10")] public string Bz10 { get; set; } /// <summary> /// QCåç»ID ///</summary> [SugarColumn(ColumnName = "QC_TEAMID")] public string QcTeamid { get; set; } /// <summary> /// QCåç»ID /// </summary> [SugarColumn(ColumnName = "QC_TEAMID")] public string QcTeamid { get; set; } /// <summary> /// ç©æID ///</summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } /// <summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } [SugarColumn(IsIgnore = true)] public string? Type { get; set; } } [SugarColumn(IsIgnore = true)] public string? Type { get; set; } } MES.Service/Modes/MesQaItemsDetect01.cs
@@ -8,324 +8,324 @@ [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; } } MES.Service/Modes/MesQaItemsDetectDetail5.cs
@@ -8,167 +8,167 @@ [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] public class MesQaItemsDetectDetail5 { /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// </summary> [SugarColumn(ColumnName = "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 decimal? 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; } } MES.Service/Modes/MesRfPrnbarcode.cs
@@ -1,155 +1,154 @@ using SqlSugar; namespace MES.Service.Modes namespace MES.Service.Modes; /// <summary> /// æææ¡ç æå°æå表 /// </summary> [SugarTable("MES_RF_PRNBARCODE")] public class MesRfPrnbarcode { /// <summary> /// æææ¡ç æå°æå表 ///</summary> [SugarTable("MES_RF_PRNBARCODE")] public class MesRfPrnbarcode { /// <summary> /// ID ///</summary> [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } /// ID /// </summary> [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } /// <summary> /// æå°é¡ºåº ///</summary> [SugarColumn(ColumnName = "FORDER")] public string? Forder { get; set; } /// <summary> /// æå°é¡ºåº /// </summary> [SugarColumn(ColumnName = "FORDER")] public string? Forder { get; set; } /// <summary> /// æå°ä»½æ° ///</summary> [SugarColumn(ColumnName = "FNO")] public string? Fno { get; set; } /// <summary> /// æå°ä»½æ° /// </summary> [SugarColumn(ColumnName = "FNO")] public string? Fno { get; set; } /// <summary> /// å段1 ///</summary> [SugarColumn(ColumnName = "STRP1")] public string? Strp1 { get; set; } /// <summary> /// å段1 /// </summary> [SugarColumn(ColumnName = "STRP1")] public string? Strp1 { get; set; } /// <summary> /// å段2 ///</summary> [SugarColumn(ColumnName = "STRP2")] public string? Strp2 { get; set; } /// <summary> /// å段2 /// </summary> [SugarColumn(ColumnName = "STRP2")] public string? Strp2 { get; set; } /// <summary> /// å段3 ///</summary> [SugarColumn(ColumnName = "STRP3")] public string? Strp3 { get; set; } /// <summary> /// å段3 /// </summary> [SugarColumn(ColumnName = "STRP3")] public string? Strp3 { get; set; } /// <summary> /// å段4 ///</summary> [SugarColumn(ColumnName = "STRP4")] public string? Strp4 { get; set; } /// <summary> /// å段4 /// </summary> [SugarColumn(ColumnName = "STRP4")] public string? Strp4 { get; set; } /// <summary> /// å段5 ///</summary> [SugarColumn(ColumnName = "STRP5")] public string? Strp5 { get; set; } /// <summary> /// å段5 /// </summary> [SugarColumn(ColumnName = "STRP5")] public string? Strp5 { get; set; } /// <summary> /// å段6 ///</summary> [SugarColumn(ColumnName = "STRP6")] public string? Strp6 { get; set; } /// <summary> /// å段6 /// </summary> [SugarColumn(ColumnName = "STRP6")] public string? Strp6 { get; set; } /// <summary> /// å段7 ///</summary> [SugarColumn(ColumnName = "STRP7")] public string? Strp7 { get; set; } /// <summary> /// å段7 /// </summary> [SugarColumn(ColumnName = "STRP7")] public string? Strp7 { get; set; } /// <summary> /// å段8 ///</summary> [SugarColumn(ColumnName = "STRP8")] public string? Strp8 { get; set; } /// <summary> /// å段8 /// </summary> [SugarColumn(ColumnName = "STRP8")] public string? Strp8 { get; set; } /// <summary> /// å段9 ///</summary> [SugarColumn(ColumnName = "STRP9")] public string? Strp9 { get; set; } /// <summary> /// å段9 /// </summary> [SugarColumn(ColumnName = "STRP9")] public string? Strp9 { get; set; } /// <summary> /// å段10 ///</summary> [SugarColumn(ColumnName = "STRP10")] public string? Strp10 { get; set; } /// <summary> /// å段10 /// </summary> [SugarColumn(ColumnName = "STRP10")] public string? Strp10 { get; set; } /// <summary> /// å段11 ///</summary> [SugarColumn(ColumnName = "STRP11")] public string? Strp11 { get; set; } /// <summary> /// å段11 /// </summary> [SugarColumn(ColumnName = "STRP11")] public string? Strp11 { get; set; } /// <summary> /// å段12 ///</summary> [SugarColumn(ColumnName = "STRP12")] public string? Strp12 { get; set; } /// <summary> /// å段12 /// </summary> [SugarColumn(ColumnName = "STRP12")] public string? Strp12 { get; set; } /// <summary> /// å段13 ///</summary> [SugarColumn(ColumnName = "STRP13")] public string? Strp13 { get; set; } /// <summary> /// å段13 /// </summary> [SugarColumn(ColumnName = "STRP13")] public string? Strp13 { get; set; } /// <summary> /// å段14 ///</summary> [SugarColumn(ColumnName = "STRP14")] public string? Strp14 { get; set; } /// <summary> /// å段14 /// </summary> [SugarColumn(ColumnName = "STRP14")] public string? Strp14 { get; set; } /// <summary> /// å段15 ///</summary> [SugarColumn(ColumnName = "STRP15")] public string? Strp15 { get; set; } /// <summary> /// å段15 /// </summary> [SugarColumn(ColumnName = "STRP15")] public string? Strp15 { get; set; } /// <summary> /// å段16 ///</summary> [SugarColumn(ColumnName = "STRP16")] public string? Strp16 { get; set; } /// <summary> /// å段16 /// </summary> [SugarColumn(ColumnName = "STRP16")] public string? Strp16 { get; set; } /// <summary> /// å段17 ///</summary> [SugarColumn(ColumnName = "STRP17")] public string? Strp17 { get; set; } /// <summary> /// å段17 /// </summary> [SugarColumn(ColumnName = "STRP17")] public string? Strp17 { get; set; } /// <summary> /// å段18 ///</summary> [SugarColumn(ColumnName = "STRP18")] public string? Strp18 { get; set; } /// <summary> /// å段18 /// </summary> [SugarColumn(ColumnName = "STRP18")] public string? Strp18 { get; set; } /// <summary> /// å段19 ///</summary> [SugarColumn(ColumnName = "STRP19")] public string? Strp19 { get; set; } /// <summary> /// å段19 /// </summary> [SugarColumn(ColumnName = "STRP19")] public string? Strp19 { get; set; } /// <summary> /// å段20 ///</summary> [SugarColumn(ColumnName = "STRP20")] public string? Strp20 { get; set; } /// <summary> /// å段20 /// </summary> [SugarColumn(ColumnName = "STRP20")] public string? Strp20 { get; set; } /// <summary> /// çææ¶é´ ///</summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } } /// <summary> /// çææ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } } MES.Service/Modes/Organize.cs
@@ -8,13 +8,12 @@ public class Organize { /// <summary> /// /// </summary> [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } /// <summary> /// ç»ç»è±æ /// ç»ç»è±æ /// </summary> [SugarColumn(ColumnName = "FNUMBER")] public string Fnumber { get; set; } 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/QsItemOqcReq.cs
@@ -1,4 +1,3 @@ using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; using SqlSugar; @@ -20,104 +19,103 @@ public decimal? Id { get; set; } /// <summary> /// æ£éªåå· ///</summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string? ReleaseNo { get; set; } /// <summary> /// æ£éªæ¥æ ///</summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } /// <summary> /// æ£éªäººå ///</summary> /// æ£éªäººå /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] public string? FcheckBy { get; set; } /// <summary> /// ç©æç¼ç ///</summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string? ItemNo { get; set; } /// <summary> /// æ£éªç»æ ///</summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string? FcheckResu { get; set; } /// <summary> /// å建人 ///</summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string? CreateBy { get; set; } /// <summary> /// å建æ¥æ ///</summary> /// å建æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æ´æ°äºº ///</summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string? LastupdateBy { get; set; } /// <summary> /// æ´æ°æ¥æ ///</summary> /// æ´æ°æ¥æ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// ///</summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY")] public string? Modify1By { get; set; } /// <summary> /// å·¥åå· ///</summary> /// å·¥åå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string? BillNo { get; set; } /// <summary> /// æ¨¡å ·å· ///</summary> /// æ¨¡å ·å· /// </summary> [SugarColumn(ColumnName = "MOID_NUM")] public string? MoidNum { get; set; } /// <summary> /// å®¡æ ¸äºº ///</summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "FSUBMIT_BY")] public string? FsubmitBy { get; set; } /// <summary> /// å®¡æ ¸æ¶é´ ///</summary> /// å®¡æ ¸æ¶é´ /// </summary> [SugarColumn(ColumnName = "FSUBMIT_DATE")] public DateTime? FsubmitDate { get; set; } /// <summary> /// å®¡æ ¸ç¶æ ///</summary> /// å®¡æ ¸ç¶æ /// </summary> [SugarColumn(ColumnName = "FSUBMIT")] public decimal? Fsubmit { get; set; } /// <summary> /// å¤æ³¨ ///</summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARKS")] public string? Remarks { get; set; } /// <summary> /// ç©æID ///</summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; }
@@ -21,117 +21,113 @@ public decimal? Id { get; set; } /// <summary> /// æ£éªåå· ///</summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string? ReleaseNo { get; set; } /// <summary> /// æ£éªæ¥æ ///</summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } /// <summary> /// æ£éªäººå ///</summary> /// æ£éªäººå /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] public string? FcheckBy { get; set; } /// <summary> /// ç©æç¼ç ///</summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string? ItemNo { get; set; } /// <summary> /// æ£éªç»æ ///</summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string? FcheckResu { get; set; } /// <summary> /// å建人 ///</summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string? CreateBy { get; set; } /// <summary> /// å建æ¥æ ///</summary> /// å建æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æ´æ°äºº ///</summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string? LastupdateBy { get; set; } /// <summary> /// æ´æ°æ¥æ ///</summary> /// æ´æ°æ¥æ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// ///</summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY")] public string? Modify1By { get; set; } /// <summary> /// åä½ ///</summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "ITEM_UNIT")] public string? ItemUnit { get; set; } /// <summary> /// å·¥åå· ///</summary> /// å·¥åå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string? BillNo { get; set; } /// <summary> /// æ¨¡å ·å· ///</summary> /// æ¨¡å ·å· /// </summary> [SugarColumn(ColumnName = "MOID_NUM")] public string? MoidNum { get; set; } /// <summary> /// ///</summary> /// </summary> [SugarColumn(ColumnName = "FSUBMIT_BY")] public string? FsubmitBy { get; set; } /// <summary> /// ///</summary> /// </summary> [SugarColumn(ColumnName = "FSUBMIT_DATE")] public DateTime? FsubmitDate { get; set; } /// <summary> /// ///</summary> /// </summary> [SugarColumn(ColumnName = "FSUBMIT")] public decimal? Fsubmit { get; set; } /// <summary> /// å¤æ³¨ ///</summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARKS")] public string? Remarks { get; set; } /// <summary> /// ç©æID ///</summary> /// ç©æID /// </summary> [SugarColumn(ColumnName = "ITEM_ID")] public decimal? ItemId { get; set; } [SugarColumn(IsIgnore = true)] public string? Daa020 { get; set; } [SugarColumn(IsIgnore = true)] public decimal? PlanQty { get; set; } [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; } [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; } } MES.Service/Modes/Womdab.cs
@@ -1,124 +1,147 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; namespace MES.Service.Modes using SqlSugar; namespace MES.Service.Modes; /// <summary> /// å·¥åå表 /// </summary> [SugarTable("WOMDAB")] public class Womdab { /// <summary> /// å·¥åå表 ///</summary> [SugarTable("WOMDAB")] public class Womdab { /// <summary> /// èªå¢å ///</summary> [SugarColumn(ColumnName="ID" )] public decimal? Id { get; set; } /// <summary> /// PID ///</summary> [SugarColumn(ColumnName="PID" )] public decimal? Pid { get; set; } /// <summary> /// å·¥ååå· ///</summary> [SugarColumn(ColumnName="DAB001" )] public string Dab001 { get; set; } /// <summary> /// åºå· ///</summary> [SugarColumn(ColumnName="DAB002" )] public string Dab002 { get; set; } /// <summary> /// ææç¼ç ///</summary> [SugarColumn(ColumnName="DAB003" )] public string Dab003 { get; set; } /// <summary> /// ææå称 ///</summary> [SugarColumn(ColumnName="DAB004" )] public string Dab004 { get; set; } /// <summary> /// ææè§æ ¼ ///</summary> [SugarColumn(ColumnName="DAB005" )] public string Dab005 { get; set; } /// <summary> /// éé¢ç¨é ///</summary> [SugarColumn(ColumnName="DAB006" )] public decimal? Dab006 { get; set; } /// <summary> /// å·²é¢ç¨é ///</summary> [SugarColumn(ColumnName="DAB007" )] public decimal? Dab007 { get; set; } /// <summary> /// å·¥èº ///</summary> [SugarColumn(ColumnName="DAB008" )] public string Dab008 { get; set; } /// <summary> /// åä½ ///</summary> [SugarColumn(ColumnName="DAB009" )] public string Dab009 { get; set; } /// <summary> /// ææç±»å ///</summary> [SugarColumn(ColumnName="DAB010" )] public string Dab010 { get; set; } /// <summary> /// 主æ ///</summary> [SugarColumn(ColumnName="DAB011" )] public string Dab011 { get; set; } /// <summary> /// ç»æç¨é ///</summary> [SugarColumn(ColumnName="DAB012" )] public decimal? Dab012 { get; set; } /// <summary> /// åºæ° ///</summary> [SugarColumn(ColumnName="DAB013" )] public decimal? Dab013 { get; set; } /// <summary> /// æ¯å¦æ¿æ ///</summary> [SugarColumn(ColumnName="DAB014" )] public string Dab014 { get; set; } /// <summary> /// ç¹ä½ ///</summary> [SugarColumn(ColumnName="DAB015" )] public string Dab015 { get; set; } /// <summary> /// ææåå· ///</summary> [SugarColumn(ColumnName="DAB016" )] public string Dab016 { get; set; } /// <summary> /// ä»åºç¼ç ///</summary> [SugarColumn(ColumnName="DAB017" )] public string Dab017 { get; set; } /// <summary> /// ä»åºå称 ///</summary> [SugarColumn(ColumnName="DAB018" )] public string Dab018 { get; set; } /// <summary> /// é¢ææ¹å¼ ///</summary> [SugarColumn(ColumnName="DAB019" )] public string Dab019 { get; set; } /// <summary> /// åºå®æè ///</summary> [SugarColumn(ColumnName="SCRAPQTY" )] public decimal? Scrapqty { get; set; } } } /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } /// <summary> /// PID /// </summary> [SugarColumn(ColumnName = "PID")] public decimal? Pid { get; set; } /// <summary> /// å·¥ååå· /// </summary> [SugarColumn(ColumnName = "DAB001")] public string Dab001 { get; set; } /// <summary> /// åºå· /// </summary> [SugarColumn(ColumnName = "DAB002")] public string Dab002 { get; set; } /// <summary> /// ææç¼ç /// </summary> [SugarColumn(ColumnName = "DAB003")] public string Dab003 { get; set; } /// <summary> /// ææå称 /// </summary> [SugarColumn(ColumnName = "DAB004")] public string Dab004 { get; set; } /// <summary> /// ææè§æ ¼ /// </summary> [SugarColumn(ColumnName = "DAB005")] public string Dab005 { get; set; } /// <summary> /// éé¢ç¨é /// </summary> [SugarColumn(ColumnName = "DAB006")] public decimal? Dab006 { get; set; } /// <summary> /// å·²é¢ç¨é /// </summary> [SugarColumn(ColumnName = "DAB007")] public decimal? Dab007 { get; set; } /// <summary> /// å·¥èº /// </summary> [SugarColumn(ColumnName = "DAB008")] public string Dab008 { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "DAB009")] public string Dab009 { get; set; } /// <summary> /// ææç±»å /// </summary> [SugarColumn(ColumnName = "DAB010")] public string Dab010 { get; set; } /// <summary> /// 主æ /// </summary> [SugarColumn(ColumnName = "DAB011")] public string Dab011 { get; set; } /// <summary> /// ç»æç¨é /// </summary> [SugarColumn(ColumnName = "DAB012")] public decimal? Dab012 { get; set; } /// <summary> /// åºæ° /// </summary> [SugarColumn(ColumnName = "DAB013")] public decimal? Dab013 { get; set; } /// <summary> /// æ¯å¦æ¿æ /// </summary> [SugarColumn(ColumnName = "DAB014")] public string Dab014 { get; set; } /// <summary> /// ç¹ä½ /// </summary> [SugarColumn(ColumnName = "DAB015")] public string Dab015 { get; set; } /// <summary> /// ææåå· /// </summary> [SugarColumn(ColumnName = "DAB016")] public string Dab016 { get; set; } /// <summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "DAB017")] public string Dab017 { get; set; } /// <summary> /// ä»åºå称 /// </summary> [SugarColumn(ColumnName = "DAB018")] public string Dab018 { get; set; } /// <summary> /// é¢ææ¹å¼ /// </summary> [SugarColumn(ColumnName = "DAB019")] public string Dab019 { get; set; } /// <summary> /// åºå®æè /// </summary> [SugarColumn(ColumnName = "SCRAPQTY")] public decimal? Scrapqty { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "ERP_ID")] public decimal? ErpId { get; set; } } MES.Service/bin/Debug/net8.0/MES.Service.dllBinary files differ
MES.Service/bin/Debug/net8.0/MES.Service.pdbBinary files differ
MES.Service/service/QC/XJService.cs
@@ -102,7 +102,7 @@ Id = b.Id, ItemNo = b.ItemNo, ItemName = b.ItemName, ItemModel = b.ItemModel, ItemModel = b.ItemModel }).ToList(); }
@@ -28,7 +28,8 @@ c.ItemNo == t.ItemNo && c.Company == t.Company && c.Factory == t.Factory, JoinType.Left, t.Fpurchaseunitid == u.Id.ToString() && t.Factory == u.Factory && t.Fpurchaseunitid == u.Id.ToString() && t.Factory == u.Factory && t.Company == u.Company }) .Where((c, t, u) => c.Mid == query.id) MES.Service/service/Warehouse/MesInvItemOutCDetailsManager.cs
@@ -81,46 +81,36 @@ public MesInvItemOutCDetails GetOutList(WarehouseQuery query) { var mesInvItemBarcodes = Db.Queryable<MesInvItemBarcodes>() .Where(s => s.ItemBarcode == query.barcode).Count(); if (mesInvItemBarcodes <= 0) { throw new Exception("æ¡ç ä¸åå¨"); } if (mesInvItemBarcodes <= 0) throw new Exception("æ¡ç ä¸åå¨"); var mesInvItemOutCDetails = Db.Queryable<MesInvItemOutCDetails>() .Where(s => s.ItemBarcode == query.barcode && s.Receive == 0).Count(); .Where(s => s.ItemBarcode == query.barcode && s.Receive == 0) .Count(); if (mesInvItemOutCDetails <= 0) { throw new Exception("æ¡ç ä¸ç¬¦åæ¥æ¶æ¡ä»¶,请æ£æ¥ï¼"); } if (mesInvItemOutCDetails <= 0) throw new Exception("æ¡ç ä¸ç¬¦åæ¥æ¶æ¡ä»¶,请æ£æ¥ï¼"); var entity = Db.Queryable<MesInvItemOutCDetails, MesInvItemOuts, MesItems>((a, b, c) => new JoinQueryInfos(JoinType.Left, a.ItemOutId == b.Id, JoinType.Left, a.ItemNo == c.ItemNo)) .Where((a, b, c) => a.ItemBarcode == query.barcode) .Select((a, b, c) => new MesInvItemOutCDetails { PbillNo = b.ItemOutNo, WorkNo = a.WorkNo, ItemNo = a.ItemNo, ItemName = c.ItemName, Quantity = a.Quantity }).First(); var entity = Db .Queryable<MesInvItemOutCDetails, MesInvItemOuts, MesItems>( (a, b, c) => new JoinQueryInfos(JoinType.Left, a.ItemOutId == b.Id, JoinType.Left, a.ItemNo == c.ItemNo)) .Where((a, b, c) => a.ItemBarcode == query.barcode) .Select((a, b, c) => new MesInvItemOutCDetails { PbillNo = b.ItemOutNo, WorkNo = a.WorkNo, ItemNo = a.ItemNo, ItemName = c.ItemName, Quantity = a.Quantity }).First(); if (entity == null) { throw new Exception("åºåºæ¡ç " + query.barcode + " ä¸åå¨ï¼è¯·ç¡®è®¤!"); } return entity; @@ -132,19 +122,16 @@ var mesInvItemBarcodes = Db.Queryable<MesInvItemBarcodes>() .Where(s => s.ItemBarcode == query.barcode).Count(); if (mesInvItemBarcodes <= 0) { throw new Exception("æ¡ç ä¸åå¨"); } if (mesInvItemBarcodes <= 0) throw new Exception("æ¡ç ä¸åå¨"); var mesInvItemOutCDetails = Db.Queryable<MesInvItemOutCDetails>() .Where(s => s.ItemBarcode == query.barcode).First(); MaterialReceipt entity = new MaterialReceipt var entity = new MaterialReceipt { InvItemoutCDetails = GetMesInvItemOutCDetails(mesInvItemOutCDetails.PbillNo), InvItemoutCDetails = GetMesInvItemOutCDetails(mesInvItemOutCDetails.PbillNo), ItemOuts = GetMesInvItemOuts(mesInvItemOutCDetails.PbillNo) }; return entity; @@ -154,40 +141,30 @@ public MesInvItemOutCDetails confirmReceipt(WarehouseQuery query) { if (string.IsNullOrWhiteSpace(query.barcode)) { throw new Exception("请æ«åºåºæ¡ç ï¼"); } if (string.IsNullOrWhiteSpace(query.billNo)) { throw new Exception("åºåºåæ®ä¸è½ä¸ºç©ºï¼"); } var barcodeInfo = GetBarcodeInfo(query.barcode); if (barcodeInfo.Receive == 1) { throw new Exception("æ¤æ¡ç å·²ç»æ¥æ¶,请æ£æ¥ï¼"); } if (barcodeInfo.Receive == 1) throw new Exception("æ¤æ¡ç å·²ç»æ¥æ¶,请æ£æ¥ï¼"); UseTransaction(db => { var count = db.Updateable<MesInvItemOutCDetails>() .SetColumns(s => s.Receive == 1) .Where(s => s.ItemBarcode == barcodeInfo.ItemBarcode).ExecuteCommand(); .SetColumns(s => s.Receive == 1) .Where(s => s.ItemBarcode == barcodeInfo.ItemBarcode) .ExecuteCommand(); return 1; }); return barcodeInfo; } public List<MesInvItemOutCDetails> GetMesInvItemOutCDetails(string billno) @@ -203,12 +180,10 @@ } private MesInvItemOutCDetails GetBarcodeInfo(string itemBarcode) { // Get barcode information return Db.Queryable<MesInvItemOutCDetails>() .First(b => b.ItemBarcode == itemBarcode); } } MES.Service/service/Warehouse/MesInvItemOutsManager.cs
@@ -3,6 +3,7 @@ using MES.Service.Dto.service; using MES.Service.Modes; using MES.Service.util; using Newtonsoft.Json; using SqlSugar; using DbType = System.Data.DbType; @@ -12,6 +13,114 @@ { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,å¦æè¦éæ°çæ请å é¤ MesInvItemOutsManager.cs public List<MesInvItemOuts> GetProductionPickPage(WarehouseQuery query) { return Db.Queryable<MesInvItemOuts, MesDepots>((a, o) => new JoinQueryInfos( JoinType.Left, o.DepotCode == a.DepotCode && a.Company == o.Company && a.Factory == o.Factory )) .Where((a, o) => a.BillTypeId == 200 && a.TransactionNo == 201 && a.Factory == "1000" && a.Company == "1000" && a.IsVisual == 1) .WhereIF(query.status != null, (a, o) => a.Status == query.status) .WhereIF(query.id != null, (a, o) => a.Id == query.id) .Select((a, o) => new MesInvItemOuts { Id = a.Id, Sapstatus = a.Sapstatus, OutDate = a.OutDate, CheckDate = a.CheckDate, BoardItem = a.BoardItem, WorkNo = a.WorkNo, OutPart = a.OutPart, PbillNo = a.PbillNo, OutType = a.OutType, CreateBy = a.CreateBy, Status = a.Status, CheckUser = a.CheckUser, ItemOutNo = a.ItemOutNo, DepotName = o.DepotName // éè¦å¨ææ·»å çå段 }) .ToPageList(query.PageIndex, query.Limit); } public MaterialReceipt GetProductionPick(WarehouseQuery query) { var form = new MaterialReceipt(); if (query.id != null) { var mesInvItemOutsList = GetProductionPickPage(query); if (mesInvItemOutsList.Count <= 0) return form; form.ItemOuts = mesInvItemOutsList[0]; form.ItemsList = getProductionItemsList(query); form.InvItemoutCDetails = GetProductionDetails(query); } return form; } private List<MesInvItemOutItems> getProductionItemsList( WarehouseQuery query) { return Db.Queryable<MesInvItemOutItems, MesItems, MesDepTaskInfo>( (c, s, f) => new JoinQueryInfos( JoinType.Inner, c.ItemNo == s.ItemNo, JoinType.Left, f.TaskNo == c.TaskNo && f.ItemNo == c.ItemNo )) .Where((c, s, f) => c.ItemOutId == query.id) .OrderBy(c => c.Id) .Select((c, s, f) => new MesInvItemOutItems { Id = c.Id, ItemNo = c.ItemNo, Quantity = c.Quantity, TaskNo = c.TaskNo, Remark = c.Remark, ItemName = s.ItemName, // å¨æå段 ItemModel = s.ItemModel, // å¨æå段 ItemUnit = SqlFunc.Subqueryable<MesItems>() .Where(si => si.ItemUnit == s.ItemUnit) .Select(si => SqlFunc.MappingColumn<string>( "F_GETUNITNAME(si.Item_Unit)")) // å¨æå段 }) .ToList(); } private List<MesInvItemOutCDetails> GetProductionDetails( WarehouseQuery query) { return Db .Queryable<MesInvItemOutCDetails, MesItems, MesDepots>( (b, c, d) => new JoinQueryInfos( JoinType.Left, b.ItemNo == c.ItemNo && b.Company == c.Company && b.Factory == c.Factory, JoinType.Left, d.DepotCode == b.DepotCode && b.Company == d.Company && b.Factory == d.Factory )) .Where((b, c, d) => b.ItemOutId == query.id) .Select((b, c, d) => new MesInvItemOutCDetails { ForceOutFlag = b.ForceOutFlag, DepotSectionCode = b.DepotSectionCode, ItemNo = b.ItemNo, Quantity = b.Quantity, ItemBarcode = b.ItemBarcode, ItemName = c.ItemName, ItemModel = c.ItemModel, DepotName = d.DepotName, DepotCode = b.DepotCode }) .ToList(); } public bool ScanCode(WarehouseQuery query) { @@ -703,4 +812,157 @@ return ItemOutNos; } //ç产é¢æåå®¡æ ¸åæ ¡éª public MessageCenter SaveProductionMessageCenter(WarehouseQuery entity) { var message = ProductionMesToErpParam(entity); var executeReturnIdentity = Db.Insertable(message).ExecuteReturnIdentity(); if (executeReturnIdentity > 0) { message.Id = executeReturnIdentity; message.Pid = executeReturnIdentity; return message; } throw new Exception("è·åæ°æ®å¤±è´¥"); } private MessageCenter ProductionMesToErpParam(WarehouseQuery query) { var erpParameters = ""; var title = ""; var tableName = "INV_ITEM_OUTS_" + query.Type; if ("A".Equals(query.Type)) { erpParameters = GetProductionErpParameters(query.billNo, query.userName); title = "ç产é¢æå" + query.billNo + "å®¡æ ¸"; } var ErpUrl = AppsettingsUtility.Settings.ProductionErpUrl; var message = new MessageCenter { TableName = tableName, Url = ErpUrl, Status = 1, CreateBy = query.userName, Route = query.billNo, Title = title, PageName = "Warehouse/ProductionPick/Add?id=" + query.id + "&itemOutNo=" + query.billNo, CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), Method = "POST", Seq = 1, Data = erpParameters, IsMessage = 0, ContentType = "application/x-www-form-urlencoded" }; return message; } private string GetProductionErpParameters(string? queryBillNo, string? userName) { userName ??= "system"; var mesInvItemOuts = Db.Queryable<MesInvItemOuts>() .Where(it => it.ItemOutNo == queryBillNo) .First(); if (mesInvItemOuts == null) throw new Exception("é¢æåå·ä¸åå¨"); var womcaa = Db.Queryable<Womcaa>() .Where(it => it.Caa020 == mesInvItemOuts.WorkNo) .First(); if (womcaa == null) throw new Exception("ä»»å¡åå·ä¸åå¨"); var Departmentcode = Db.Queryable<SysDepartment, MesInvItemOuts>( (a, b) => new JoinQueryInfos(JoinType.Left, a.Departmentname == b.OutPart )).Where((a, b) => b.OutPart == mesInvItemOuts.OutPart && b.ItemOutNo == queryBillNo).Select(a => a.Departmentcode) .First(); if (string.IsNullOrEmpty(Departmentcode)) throw new Exception("é¨é¨ä¿¡æ¯ä¸åå¨"); // æ£æ¥é¢æåç¶æ if (mesInvItemOuts.Status == 1) throw new Exception("é¢æåå·²å®¡æ ¸ï¼ä¸è½éå¤æ¨é"); var C_OUT_ITEMS = Db .Queryable<MesInvItemOutItems, Womdab, Womdaa, Womcaa, Womcab>( (c, b, d, e, f) => new JoinQueryInfos( JoinType.Left, b.Id == c.ItemDabid, JoinType.Left, d.Id == b.Pid, JoinType.Left, e.Caa001 == d.Daa021, JoinType.Left, f.Eid == e.Erpid )) .Where((c, b, d, e, f) => c.ItemOutId == mesInvItemOuts.Id) .Select((c, b, d, e, f) => new { c.Id, c.ItemNo, c.Quantity, c.DepotCode, c.DepotSectionCode, c.ItemId, erpId = b.ErpId, e.Caa015, f.PositionNo }).ToList(); var scllentryList = new List<dynamic>(); foreach (var item in C_OUT_ITEMS) { var sql = "SELECT FNAME FROM MES_UNIT WHERE ID = (SELECT ITEM_UNIT FROM MES_ITEMS WHERE ID = '" + item.ItemId + "')"; var C_ITEM_UNIT = Db.Ado.SqlQuerySingle<string>(sql); scllentryList.Add(new { FMaterialId = item.ItemNo, FUnitID = C_ITEM_UNIT, FAppQty = item.Quantity, FActualQty = item.Quantity, FStockId = item.DepotCode, FPPBomEntryId = item.erpId, F_UNW_Text_xsddh = item.Caa015, F_UNW_TEXT_WZH = item.PositionNo, F_MES_ENTRYID = item.Id }); } var dataJson = new { F_MES_ID = mesInvItemOuts.Id, FDate = mesInvItemOuts.CreateBy, FPickerId = userName, F_UNW_LargeText_BZ = " ", F_UNW_KH = " ", F_UNW_DDSL = womcaa.Caa012, F_UNW_Text_CZG = userName, scllentry = scllentryList }; return "taskname=SCLL&mesid=" + mesInvItemOuts.Id + "&optype=create&datajson=" + JsonConvert.SerializeObject( dataJson); } public bool AuditProduction(WarehouseQuery query) { query.status = 1; //å®¡æ ¸ return Update(query); } } MES.Service/service/Warehouse/OrganizeService.cs
@@ -1,4 +1,5 @@ using System.Data; using System.Dynamic; using MES.Service.DB; using MES.Service.Dto.service; using MES.Service.Modes; @@ -28,10 +29,7 @@ var printCommandResult = Db.Queryable<MesBarcodeType>() .Where(t => t.TypeCode == 108) .First(); if (printCommandResult == null) { throw new Exception("模çID为空ï¼è¯·è®¾ç½®æå°æ ¼å¼ï¼"); } if (printCommandResult == null) throw new Exception("模çID为空ï¼è¯·è®¾ç½®æå°æ ¼å¼ï¼"); var cPrintCommand = printCommandResult.Mbtype; var cBid = printCommandResult.Id; @@ -41,40 +39,21 @@ s.ItemNo == query.ItemNo && s.Factory == "1000" && s.Company == "1000") .First(); if (cMesItems == null) { throw new Exception("ç©æä¿¡æ¯ä¸åå¨è¯¥ç©æç¼ç ï¼è¯·ç»´æ¤ï¼"); } if (cMesItems == null) throw new Exception("ç©æä¿¡æ¯ä¸åå¨è¯¥ç©æç¼ç ï¼è¯·ç»´æ¤ï¼"); if (string.IsNullOrEmpty(query.ItemNo)) { throw new Exception("请å½å ¥ç©æç¼ç "); } if (string.IsNullOrEmpty(query.ItemNo)) throw new Exception("请å½å ¥ç©æç¼ç "); if (string.IsNullOrEmpty(query.ItemModel)) { throw new Exception("请è¾å ¥å®ç©æç¼ç åï¼ç¹å»ç¡®è®¤çæè§æ ¼ï¼"); } if (string.IsNullOrEmpty(query.OrgName)) { throw new Exception("请å½å ¥ç»ç»"); } if (string.IsNullOrEmpty(query.OrgName)) throw new Exception("请å½å ¥ç»ç»"); if (string.IsNullOrEmpty(query.OrgOwner)) { throw new Exception("请å½å ¥è´§ä¸»"); } if (string.IsNullOrEmpty(query.OrgOwner)) throw new Exception("请å½å ¥è´§ä¸»"); if (string.IsNullOrEmpty(query.ItemNum)) { throw new Exception("请å½å ¥ç©ææ°é"); } if (string.IsNullOrEmpty(query.ItemNum)) throw new Exception("请å½å ¥ç©ææ°é"); if (string.IsNullOrEmpty(query.Printnumn)) { throw new Exception("请å½å ¥æ¡ç æ°é"); } var cId = Db.Ado.GetInt( @@ -89,7 +68,7 @@ .Where(it => it.CreateDate < DateTime.Now.AddDays(-10)) .ExecuteCommand(); for (int i = 1; i <= int.Parse(query.Printnumn); i++) for (var i = 1; i <= int.Parse(query.Printnumn); i++) { var cIndate = DateTime.Now.ToString("yyyyMMdd"); @@ -104,19 +83,12 @@ query.ItemNo + cIndate, query.ItemNo + cIndate, 0); serial = barcodeResult.Value; poBarcodeComand = barcodeResult.Msg; if (!string.IsNullOrEmpty(poBarcodeComand)) { return null; } if (!string.IsNullOrEmpty(poBarcodeComand)) return null; if (string.IsNullOrEmpty(serial)) { cBarcode2 = "9"; } else { cBarcode2 = "9" + serial[1..]; } itemBarcode = query.ItemNo + cIndate + cBarcode2; } else @@ -135,10 +107,7 @@ query.ItemNo + cIndate, query.ItemNo + cIndate, 0); serial = barcodeResult.Value; poBarcodeComand = barcodeResult.Msg; if (!string.IsNullOrEmpty(poBarcodeComand)) { return null; } if (!string.IsNullOrEmpty(poBarcodeComand)) return null; cBarcode2 = "9" + serial.Substring(1); itemBarcode = query.ItemNo + cIndate + @@ -155,7 +124,6 @@ s.Company == "1000") .Count(); if (cCount == 0) { // Insert new barcode Db.Insertable(new MesInvItemBarcodes { @@ -174,7 +142,6 @@ OrgName = query.OrgName, OrgOwner = query.OrgOwner }).ExecuteCommand(); } // Insert record into MES_RF_PRNBARCODE Db.Insertable(new MesRfPrnbarcode @@ -196,7 +163,7 @@ Strp11 = poBarcode, Strp12 = query.ItemName ?? " ", Strp15 = query.OrgName ?? " ", Strp16 = query.OrgOwner ?? " ", Strp16 = query.OrgOwner ?? " " }).ExecuteCommand(); } @@ -254,7 +221,7 @@ var resultValue = outputResult.Value?.ToString(); var messageValue = outputMessage.Value?.ToString(); dynamic m = new System.Dynamic.ExpandoObject(); dynamic m = new ExpandoObject(); m.Value = resultValue; m.Msg = messageValue;
@@ -22,7 +22,7 @@ private readonly string TableName = "MES_ITEMS"; private readonly string URL = "http://localhost:10054/api/MesItems/"; //GetItemQcPrint [HttpPost("GetItemQcPrint")] public ResponseResult GetItemQcPrint(WarehouseQuery query) @@ -32,7 +32,7 @@ dynamic resultInfos = new ExpandoObject(); var save = m.GetItemQcPrint(query); resultInfos.tbBillList = save; return new ResponseResult { status = 0, MESApplication/Controllers/Warehouse/MesInvItemOutCDetailsController.cs
@@ -14,14 +14,12 @@ private readonly MesInvItemOutCDetailsManager m = new(); /// <summary> /// è·åç©ææ¥æ¶ä¿¡æ¯ /// è·åç©ææ¥æ¶ä¿¡æ¯ /// </summary> /// <returns></returns> [HttpPost("GetOutItemList")] public ResponseResult GetOutItemList(WarehouseQuery query) { try { dynamic resultInfos = new ExpandoObject(); @@ -37,17 +35,13 @@ { return ResponseResult.ResponseError(ex); } } /// <summary> /// è·åæç»èå /// è·åæç»èå /// </summary> /// <param name="query"></param> /// <returns></returns> [HttpPost("GetFormList")] public ResponseResult GetFormList(WarehouseQuery query) { @@ -69,7 +63,7 @@ } /// <summary> /// 确认æ¥æ¶ /// 确认æ¥æ¶ /// </summary> /// <param name="query"></param> /// <returns></returns> @@ -92,7 +86,6 @@ return ResponseResult.ResponseError(ex); } } /***è¿å ¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ MESApplication/Controllers/Warehouse/MesInvItemOutsController.cs
@@ -13,6 +13,89 @@ { private readonly MesInvItemOutsManager m = new(); //GetProductionPick [HttpPost("GetProductionPick")] public ResponseResult GetProductionPick(WarehouseQuery entity) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetProductionPick(entity); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //GetProductionPickPage [HttpPost("GetProductionPickPage")] public ResponseResult GetProductionPickPage(WarehouseQuery entity) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetProductionPickPage(entity); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //AuditProduction [HttpPost("AuditProduction")] public ResponseResult AuditProduction(WarehouseQuery query) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.AuditProduction(query); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //MesToErp [HttpPost("SaveProductionMessageCenter")] public ResponseResult SaveProductionMessageCenter(WarehouseQuery entity) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.SaveProductionMessageCenter(entity); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } [HttpPost("ScanCode")] public ResponseResult ScanCode(WarehouseQuery entity) MESApplication/bin/Debug/net8.0/MES.Service.dllBinary files differ
MESApplication/bin/Debug/net8.0/MES.Service.pdbBinary files differ
MESApplication/bin/Debug/net8.0/MESApplication.dllBinary files differ
MESApplication/bin/Debug/net8.0/MESApplication.exeBinary files differ
MESApplication/bin/Debug/net8.0/MESApplication.pdbBinary files differ
