MES.Service/Dto/service/MovesDto.cs
@@ -8,8 +8,8 @@ public List<MesInvItemMoves>? FromList { get; set; } public List<MesInvItemOutItems>? OutItems { get; set; } public List<MesInvItemMovesCDetails>? BarcodeList { get; set; } //å ¥åºå public bool? InAudit{ get; set; } public MesInvItemBarcodes? BarcodesInfo{ get; set; } public bool? InAudit { get; set; } public MesInvItemBarcodes? BarcodesInfo { get; set; } } MES.Service/Dto/service/OutItemDto.cs
@@ -7,7 +7,7 @@ public MesInvItemOuts? Form { get; set; } public List<MesInvItemOutItems>? SaveItems { get; set; } public List<MESInvItemOutItems>? SelectItems { get; set; } public string? ItemNo { get; set; } public decimal? Quantity { get; set; } MES.Service/Dto/service/SJPageResult.cs
@@ -1,4 +1,4 @@ using MES.Service.Dto.@base; using MES.Service.Dto.@base; using SqlSugar; namespace MES.Service.Dto.service; @@ -57,37 +57,29 @@ [SugarColumn(ColumnName = "DAA001")] //ç¨äºSqlSugar public string? daa001 { get; set; } [SugarColumn(ColumnName = "CAT_QTY")] //ç¨äºSqlSugar public decimal? catQty { get; set; } [SugarColumn(ColumnName = "DETAIL_MEM")] //ç¨äºSqlSugar public string? detailMem { get; set; } [SugarColumn(ColumnName = "TASK_NO")] //ç¨äºSqlSugar public string? taskNo { get; set; } //LINE [SugarColumn(ColumnName = "LINE")] //ç¨äºSqlSugar public string? line { get; set; } /// <summary> /// æ¨¡å ·å· /// </summary> [SugarColumn(ColumnName = "MOID_NUM")] //ç¨äºSqlSugar public string? MoidNum { get; set; } [SugarColumn(ColumnName = "Remarks")] //ç¨äºSqlSugar public string? Remarks { get; set; } //BOARD_MODEL [SugarColumn(ColumnName = "BOARD_MODEL")] public string? BoardModel { get; set; } /// <summary> /// 产åå称 /// </summary> [SugarColumn(ColumnName = "DAA003")] public string? Daa003 { get; set; } [SugarColumn(ColumnName = "PLAN_QTY")] public decimal? PlanQty { get; set; } /// <summary> /// 产åè§æ ¼ /// </summary> [SugarColumn(ColumnName = "DAA004")] public string? Daa004 { get; set; } [SugarColumn(ColumnName = "MOCODE")] public string? Mocode { get; set; } [SugarColumn(ColumnName = "BOARD_STYLE")] public string? BoardStyle { get; set; } /// <summary> /// å·¥åæ°é /// </summary> [SugarColumn(ColumnName = "DAA008")] public decimal? Daa008 { get; set; } } MES.Service/Modes/MesBoardBaseInfo.cs
ÎļþÒÑɾ³ý MES.Service/Modes/MesDepTask.cs
ÎļþÒÑɾ³ý MES.Service/Modes/MesInvBusiness2.cs
@@ -8,221 +8,221 @@ [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; } /// <summary> 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; }
@@ -8,448 +8,448 @@ [SugarTable("MES_INV_ITEM_BARCODES")] public class MesInvItemBarcodes { /// <summary> /// SEQ_BARCODE_PSN_ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// SEQ_BARCODE_PSN_ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// 客æ·æåç¼ç /// </summary> [SugarColumn(ColumnName = "C_PRODUCT_CODE")] /// <summary> /// 客æ·æåç¼ç /// </summary> [SugarColumn(ColumnName = "C_PRODUCT_CODE")] public string CProductCode { get; set; } /// <summary> /// 客æ·ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "C_ITEM_BARCODE")] /// <summary> /// 客æ·ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "C_ITEM_BARCODE")] public string CItemBarcode { 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 = "ITEM_NO")] /// <summary> /// æ¬å¸ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// å家æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] /// <summary> /// å家æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] /// <summary> /// æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { 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 = "TASK_NO")] /// <summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { 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 = "CUST_NO")] /// <summary> /// 客æ·ç¼å· /// </summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// ç©ææ¡ç 注éè¡[åä½ï¼æ¡ç éæ使ç¨] /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")] /// <summary> /// ç©ææ¡ç 注éè¡[åä½ï¼æ¡ç éæ使ç¨] /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")] public string ItemBarcodeText { get; set; } /// <summary> /// åPSNç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")] /// <summary> /// åPSNç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")] public string OldItemBarcode { get; set; } /// <summary> /// SAPæ¶è´§ç©æåè¯å· --éè´åå· /// </summary> [SugarColumn(ColumnName = "MBLNR")] /// <summary> /// SAPæ¶è´§ç©æåè¯å· --éè´åå· /// </summary> [SugarColumn(ColumnName = "MBLNR")] public string Mblnr { get; set; } /// <summary> /// SAPæ¶è´§ç©æåè¯è¡å· --éè´åè¡å· /// </summary> [SugarColumn(ColumnName = "ZEILE")] /// <summary> /// SAPæ¶è´§ç©æåè¯è¡å· --éè´åè¡å· /// </summary> [SugarColumn(ColumnName = "ZEILE")] public decimal? Zeile { get; set; } /// <summary> /// æ¶æ表ID /// </summary> [SugarColumn(ColumnName = "ROH_IN_ID")] /// <summary> /// æ¶æ表ID /// </summary> [SugarColumn(ColumnName = "ROH_IN_ID")] public decimal? RohInId { get; set; } /// <summary> /// 0为æææ¡ç ï¼1为æ ææ¡ç /// </summary> [SugarColumn(ColumnName = "BARCODESTATUS")] /// <summary> /// 0为æææ¡ç ï¼1为æ ææ¡ç /// </summary> [SugarColumn(ColumnName = "BARCODESTATUS")] public short? Barcodestatus { get; set; } /// <summary> /// åå§æ°é /// </summary> [SugarColumn(ColumnName = "OLDQTY")] /// <summary> /// åå§æ°é /// </summary> [SugarColumn(ColumnName = "OLDQTY")] public decimal? Oldqty { get; set; } /// <summary> /// 使ç¨æ°é /// </summary> [SugarColumn(ColumnName = "USEQTY")] /// <summary> /// 使ç¨æ°é /// </summary> [SugarColumn(ColumnName = "USEQTY")] public decimal? Useqty { get; set; } /// <summary> /// 0å¨åºï¼1å¨çº¿ï¼2ä½åº /// </summary> [SugarColumn(ColumnName = "LOCATION")] /// <summary> /// 0å¨åºï¼1å¨çº¿ï¼2ä½åº /// </summary> [SugarColumn(ColumnName = "LOCATION")] public short? Location { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "UNIT")] /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } /// <summary> /// ééï¼åä½ï¼å ¬æ¤ï¼ /// </summary> [SugarColumn(ColumnName = "WEIGHT_UNIT")] /// <summary> /// ééï¼åä½ï¼å ¬æ¤ï¼ /// </summary> [SugarColumn(ColumnName = "WEIGHT_UNIT")] public decimal? WeightUnit { get; set; } /// <summary> /// åä»· /// </summary> [SugarColumn(ColumnName = "PRICE")] /// <summary> /// åä»· /// </summary> [SugarColumn(ColumnName = "PRICE")] public decimal? Price { get; set; } /// <summary> /// åæ¡ç æ°é /// </summary> [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")] /// <summary> /// åæ¡ç æ°é /// </summary> [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")] public decimal? OldBarQuantity { get; set; } /// <summary> /// æ±æ»æ¡ç /// </summary> [SugarColumn(ColumnName = "SUM_BARCODE")] /// <summary> /// æ±æ»æ¡ç /// </summary> [SugarColumn(ColumnName = "SUM_BARCODE")] public string SumBarcode { get; set; } /// <summary> /// ç产æ¥æ /// </summary> [SugarColumn(ColumnName = "LOT_DATE")] /// <summary> /// ç产æ¥æ /// </summary> [SugarColumn(ColumnName = "LOT_DATE")] public string LotDate { get; set; } /// <summary> /// æ¨¡å· /// </summary> [SugarColumn(ColumnName = "MOCODE")] /// <summary> /// æ¨¡å· /// </summary> [SugarColumn(ColumnName = "MOCODE")] public string Mocode { get; set; } /// <summary> /// æ¥æº /// </summary> [SugarColumn(ColumnName = "MEMO")] /// <summary> /// æ¥æº /// </summary> [SugarColumn(ColumnName = "MEMO")] public string Memo { get; set; } /// <summary> /// ä¾åºåç¼ç /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// ä¾åºåç¼ç /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// æ¡£ä½ä½å¼ /// </summary> [SugarColumn(ColumnName = "SPOSTION")] /// <summary> /// æ¡£ä½ä½å¼ /// </summary> [SugarColumn(ColumnName = "SPOSTION")] public string Spostion { get; set; } /// <summary> /// æ¡£ä½é«å¼ /// </summary> [SugarColumn(ColumnName = "EPOSTION")] /// <summary> /// æ¡£ä½é«å¼ /// </summary> [SugarColumn(ColumnName = "EPOSTION")] public string Epostion { get; set; } /// <summary> /// ç©æç®ç§° /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] /// <summary> /// ç©æç®ç§° /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } /// <summary> /// æ¯å¦å·²å»ç»,1å»ç» /// </summary> [SugarColumn(ColumnName = "VISABLE")] /// <summary> /// æ¯å¦å·²å»ç»,1å»ç» /// </summary> [SugarColumn(ColumnName = "VISABLE")] public short? Visable { get; set; } /// <summary> /// ä¾åºåæ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "TR_LOTNO")] /// <summary> /// ä¾åºåæ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "TR_LOTNO")] public string TrLotno { get; set; } /// <summary> /// å»ç»æ¶é´ /// </summary> [SugarColumn(ColumnName = "FLEZZ_DATE")] /// <summary> /// å»ç»æ¶é´ /// </summary> [SugarColumn(ColumnName = "FLEZZ_DATE")] public DateTime? FlezzDate { get; set; } /// <summary> /// å»ç»åå /// </summary> [SugarColumn(ColumnName = "FLEZZ_REASON")] /// <summary> /// å»ç»åå /// </summary> [SugarColumn(ColumnName = "FLEZZ_REASON")] public string FlezzReason { get; set; } /// <summary> /// å»ç»äºº /// </summary> [SugarColumn(ColumnName = "FLEZZ_BY")] /// <summary> /// å»ç»äºº /// </summary> [SugarColumn(ColumnName = "FLEZZ_BY")] public string FlezzBy { get; set; } /// <summary> /// 延é¿ä¿è´¨æ /// </summary> [SugarColumn(ColumnName = "DELANY_MONTH")] /// <summary> /// 延é¿ä¿è´¨æ /// </summary> [SugarColumn(ColumnName = "DELANY_MONTH")] public decimal? DelanyMonth { get; set; } /// <summary> /// æå°å è£ æ è¯ /// </summary> [SugarColumn(ColumnName = "MINPACK_FLAG")] /// <summary> /// æå°å è£ æ è¯ /// </summary> [SugarColumn(ColumnName = "MINPACK_FLAG")] public short? MinpackFlag { get; set; } /// <summary> /// æå°IDï¼ç¨æ¥åºåæå°æ¬¡æ° /// </summary> [SugarColumn(ColumnName = "PRINT_ID")] /// <summary> /// æå°IDï¼ç¨æ¥åºåæå°æ¬¡æ° /// </summary> [SugarColumn(ColumnName = "PRINT_ID")] public string PrintId { get; set; } /// <summary> /// ç¯ä¿é¡¹ç® /// </summary> [SugarColumn(ColumnName = "EP_ITEM")] /// <summary> /// ç¯ä¿é¡¹ç® /// </summary> [SugarColumn(ColumnName = "EP_ITEM")] public string EpItem { 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 = "CB_NO")] /// <summary> /// å¡æ¿ç¼ç /// </summary> [SugarColumn(ColumnName = "CB_NO")] public string CbNo { get; set; } /// <summary> /// å家ç产线 /// </summary> [SugarColumn(ColumnName = "LINFLINE")] /// <summary> /// å家ç产线 /// </summary> [SugarColumn(ColumnName = "LINFLINE")] public string Linfline { get; set; } /// <summary> /// æææ /// </summary> [SugarColumn(ColumnName = "VALID_TIME")] /// <summary> /// æææ /// </summary> [SugarColumn(ColumnName = "VALID_TIME")] public DateTime? ValidTime { get; set; } /// <summary> /// è´¨æ£ç»æ /// </summary> [SugarColumn(ColumnName = "IQC_STATUS")] /// <summary> /// è´¨æ£ç»æ /// </summary> [SugarColumn(ColumnName = "IQC_STATUS")] public string IqcStatus { get; set; } /// <summary> /// å°è½¦æ¡ç /// </summary> [SugarColumn(ColumnName = "FCAR")] /// <summary> /// å°è½¦æ¡ç /// </summary> [SugarColumn(ColumnName = "FCAR")] public string Fcar { get; set; } /// <summary> /// æ¯é /// </summary> [SugarColumn(ColumnName = "GWEIGHT")] /// <summary> /// æ¯é /// </summary> [SugarColumn(ColumnName = "GWEIGHT")] public string Gweight { get; set; } /// <summary> /// åé /// </summary> [SugarColumn(ColumnName = "NWEIGHT")] /// <summary> /// åé /// </summary> [SugarColumn(ColumnName = "NWEIGHT")] public string Nweight { get; set; } /// <summary> /// ä¿è´¨æ /// </summary> [SugarColumn(ColumnName = "EXT_DATE")] /// <summary> /// ä¿è´¨æ /// </summary> [SugarColumn(ColumnName = "EXT_DATE")] public decimal? ExtDate { get; set; } /// <summary> /// ä¾åºåãèµ åã客ä¾æãå§å¤ /// </summary> [SugarColumn(ColumnName = "BARCODETYPE")] /// <summary> /// ä¾åºåãèµ åã客ä¾æãå§å¤ /// </summary> [SugarColumn(ColumnName = "BARCODETYPE")] public string Barcodetype { get; set; } /// <summary> /// ä¾åºåå称 /// </summary> [SugarColumn(ColumnName = "SUPP_NAME")] /// <summary> /// ä¾åºåå称 /// </summary> [SugarColumn(ColumnName = "SUPP_NAME")] public string SuppName { get; set; } /// <summary> /// å°è´§åå·/å ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// å°è´§åå·/å ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// æ¥ææ è¯ /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] /// <summary> /// æ¥ææ è¯ /// </summary> [SugarColumn(ColumnName = "URGENT_FLAG")] public short? UrgentFlag { get; set; } /// <summary> /// é¢è² /// </summary> [SugarColumn(ColumnName = "COLOR_NAME")] /// <summary> /// é¢è² /// </summary> [SugarColumn(ColumnName = "COLOR_NAME")] public string ColorName { get; set; } /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// æ¥ææ¥æ /// </summary> [SugarColumn(ColumnName = "INS_DATE")] /// <summary> /// æ¥ææ¥æ /// </summary> [SugarColumn(ColumnName = "INS_DATE")] public DateTime? InsDate { get; set; } /// <summary> /// å°è´§åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] /// <summary> /// å°è´§åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ä¸è¯åå /// </summary> [SugarColumn(ColumnName = "MEMO_BAD")] /// <summary> /// ä¸è¯åå /// </summary> [SugarColumn(ColumnName = "MEMO_BAD")] public string MemoBad { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// æ¡ç æ¥æºæ è¯ï¼0-åæç©æ,1-éè´å ¥åºï¼2ãç产éæï¼3ãå ¶å®å ¥åºï¼4-客ä¾æ,5-å¨åºåæï¼6-å¶ç¨æ¡ç /// </summary> [SugarColumn(ColumnName = "COME_FLG")] /// <summary> /// æ¡ç æ¥æºæ è¯ï¼0-åæç©æ,1-éè´å ¥åºï¼2ãç产éæï¼3ãå ¶å®å ¥åºï¼4-客ä¾æ,5-å¨åºåæï¼6-å¶ç¨æ¡ç /// </summary> [SugarColumn(ColumnName = "COME_FLG")] public short? ComeFlg { get; set; } /// <summary> /// çäº§çº¿ä½ /// </summary> [SugarColumn(ColumnName = "LINE_NO")] /// <summary> /// çäº§çº¿ä½ /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } /// <summary> /// ä¸å°æ¬¡æ° /// </summary> [SugarColumn(ColumnName = "SILK_PQTY")] /// <summary> /// ä¸å°æ¬¡æ° /// </summary> [SugarColumn(ColumnName = "SILK_PQTY")] public decimal? SilkPqty { get; set; } /// <summary> /// ä¸å°æ¬¡æ°æ¯ /// </summary> [SugarColumn(ColumnName = "SILK")] /// <summary> /// ä¸å°æ¬¡æ°æ¯ /// </summary> [SugarColumn(ColumnName = "SILK")] public string Silk { get; set; } /// <summary> /// ä¸å°æ´¾å·¥ä»è¡¨ID /// </summary> [SugarColumn(ColumnName = "SILK_ID")] /// <summary> /// ä¸å°æ´¾å·¥ä»è¡¨ID /// </summary> [SugarColumn(ColumnName = "SILK_ID")] public decimal? SilkId { get; set; } /// <summary> /// å·²æ¥å·¥æ è¯ /// </summary> [SugarColumn(ColumnName = "WORK_FLG")] /// <summary> /// å·²æ¥å·¥æ è¯ /// </summary> [SugarColumn(ColumnName = "WORK_FLG")] public decimal? WorkFlg { get; set; } /// <summary> /// æåå·¥åº /// </summary> [SugarColumn(ColumnName = "WORK_LAST")] /// <summary> /// æåå·¥åº /// </summary> [SugarColumn(ColumnName = "WORK_LAST")] public decimal? WorkLast { get; set; } /// <summary> /// 0-æªå并æå°ï¼1-å并æå° /// </summary> [SugarColumn(ColumnName = "HBDY")] /// <summary> /// 0-æªå并æå°ï¼1-å并æå° /// </summary> [SugarColumn(ColumnName = "HBDY")] public decimal? Hbdy { get; set; } /// <summary> /// 0-æææ¡ç ï¼1-å并æåçæ¡ç ï¼æ æ /// </summary> [SugarColumn(ColumnName = "HBDYTM")] /// <summary> /// 0-æææ¡ç ï¼1-å并æåçæ¡ç ï¼æ æ /// </summary> [SugarColumn(ColumnName = "HBDYTM")] public decimal? Hbdytm { get; set; } /// <summary> MES.Service/Modes/MesInvItemInCItems.cs
@@ -8,142 +8,142 @@ [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; } /// <summary> 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/MesLine.cs
@@ -1,258 +1,167 @@ using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; using SqlSugar; using SqlSugar; namespace MES.Service.Modes; /// <summary> /// çº¿ä½ /// </summary> [Table("MES_LINE")] [SugarTable("MES_LINE")] //ç¨äºSqlSugar [SugarTable("MES_LINE")] public class MesLine { /// <summary> /// ä¸»é® /// </summary> [Key] [Column("ID")] [SugarColumn(ColumnName = "ID")] //ç¨äºSqlSugar [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// æ¡ç ç±»å /// 线ä½ç¼å· /// </summary> [Column("BARTYPE")] [SugarColumn(ColumnName = "BARTYPE")] //ç¨äºSqlSugar [StringLength(20, ErrorMessage = "æ¡ç ç±»åé¿åº¦ä¸è½è¶ åº20")] public string Bartype { get; set; } [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } /// <summary> /// å¡æ¿åç±» /// 线ä½å称 /// </summary> [Column("BK01")] [SugarColumn(ColumnName = "BK01")] //ç¨äºSqlSugar [StringLength(50, ErrorMessage = "å¡æ¿åç±»é¿åº¦ä¸è½è¶ åº50")] public string Bk01 { get; set; } [SugarColumn(ColumnName = "LINE_NAME")] public string LineName { get; set; } /// <summary> /// å®¡æ ¸äºº /// å·¥ä½ä¸å¿ç¼å· /// </summary> [Column("CHECK_BY")] [SugarColumn(ColumnName = "CHECK_BY")] //ç¨äºSqlSugar [StringLength(30, ErrorMessage = "å®¡æ ¸äººé¿åº¦ä¸è½è¶ åº30")] public string CheckBy { get; set; } [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] public string WorkshopCenterCode { get; set; } /// <summary> /// å®¡æ ¸æ¥æ /// å¤æ³¨ /// </summary> [Column("CHECK_DATE")] [SugarColumn(ColumnName = "CHECK_DATE")] //ç¨äºSqlSugar public DateTime? CheckDate { get; set; } /// <summary> /// å®¡æ ¸ç¶æ /// </summary> [Column("CHECK_STATUS")] [SugarColumn(ColumnName = "CHECK_STATUS")] //ç¨äºSqlSugar public decimal? CheckStatus { get; set; } /// <summary> /// </summary> [Column("COMPANY")] [SugarColumn(ColumnName = "COMPANY")] //ç¨äºSqlSugar [StringLength(20, ErrorMessage = "Companyé¿åº¦ä¸è½è¶ åº20")] public string Company { get; set; } [SugarColumn(ColumnName = "MEMO")] public string Memo { get; set; } /// <summary> /// å建人 /// </summary> [Column("CREATE_BY")] [SugarColumn(ColumnName = "CREATE_BY")] //ç¨äºSqlSugar [StringLength(30, ErrorMessage = "å建人é¿åº¦ä¸è½è¶ åº30")] [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¥æ /// </summary> [Column("CREATE_DATE")] [SugarColumn(ColumnName = "CREATE_DATE")] //ç¨äºSqlSugar [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// é¨é¨ç¼å· /// </summary> [Column("DEPARTMENTCODE")] [SugarColumn(ColumnName = "DEPARTMENTCODE")] //ç¨äºSqlSugar [StringLength(32, ErrorMessage = "é¨é¨ç¼å·é¿åº¦ä¸è½è¶ åº32")] public string Departmentcode { get; set; } /// <summary> /// 线边ä»åº /// </summary> [Column("DEPOT_CODE")] [SugarColumn(ColumnName = "DEPOT_CODE")] //ç¨äºSqlSugar [StringLength(50, ErrorMessage = "线边ä»åºé¿åº¦ä¸è½è¶ åº50")] public string DepotCode { get; set; } /// <summary> /// é»è®¤åºä½ /// </summary> [Column("DEPOT_SECTION_CODE")] [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] //ç¨äºSqlSugar [StringLength(50, ErrorMessage = "é»è®¤åºä½é¿åº¦ä¸è½è¶ åº50")] public string DepotSectionCode { get; set; } /// <summary> /// </summary> [Column("FACTORY")] [SugarColumn(ColumnName = "FACTORY")] //ç¨äºSqlSugar [StringLength(20, ErrorMessage = "Factoryé¿åº¦ä¸è½è¶ åº20")] public string Factory { get; set; } /// <summary> /// æ ç¾æ¾ç¤ºå¼ /// </summary> [Column("LABEL")] [SugarColumn(ColumnName = "LABEL")] //ç¨äºSqlSugar [StringLength(100, ErrorMessage = "æ ç¾æ¾ç¤ºå¼é¿åº¦ä¸è½è¶ åº100")] public string Label { get; set; } /// <summary> /// æåä¿®æ¹äºº /// </summary> [Column("LASTUPDATE_BY")] [SugarColumn(ColumnName = "LASTUPDATE_BY")] //ç¨äºSqlSugar [StringLength(30, ErrorMessage = "æåä¿®æ¹äººé¿åº¦ä¸è½è¶ åº30")] [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåä¿®æ¹æ¥æ /// </summary> [Column("LASTUPDATE_DATE")] [SugarColumn(ColumnName = "LASTUPDATE_DATE")] //ç¨äºSqlSugar [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// ç»é¿ç¼å· /// å¡æ¿åç±» /// </summary> [Column("L_CODE")] [SugarColumn(ColumnName = "L_CODE")] //ç¨äºSqlSugar [StringLength(32, ErrorMessage = "ç»é¿ç¼å·é¿åº¦ä¸è½è¶ åº32")] public string LCode { get; set; } [SugarColumn(ColumnName = "BK01")] public string Bk01 { get; set; } /// <summary> /// 线ç®ç /// æ ç¾æ¾ç¤ºå¼ /// </summary> [Column("LINEJM")] [SugarColumn(ColumnName = "LINEJM")] //ç¨äºSqlSugar [StringLength(20, ErrorMessage = "线ç®ç é¿åº¦ä¸è½è¶ åº20")] public string Linejm { get; set; } /// <summary> /// 线ä½å称 /// </summary> [Column("LINE_NAME")] [SugarColumn(ColumnName = "LINE_NAME")] //ç¨äºSqlSugar [StringLength(64, ErrorMessage = "线ä½å称é¿åº¦ä¸è½è¶ åº64")] public string LineName { get; set; } /// <summary> /// 线ä½ç¼å· /// </summary> [Column("LINE_NO")] [SugarColumn(ColumnName = "LINE_NO")] //ç¨äºSqlSugar [StringLength(32, ErrorMessage = "线ä½ç¼å·é¿åº¦ä¸è½è¶ åº32")] public string LineNo { get; set; } /// <summary> /// äº§çº¿ç±»å« /// </summary> [Column("LINE_STYLE")] [SugarColumn(ColumnName = "LINE_STYLE")] //ç¨äºSqlSugar [StringLength(32, ErrorMessage = "产线类å«é¿åº¦ä¸è½è¶ åº32")] public string LineStyle { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [Column("MEMO")] [SugarColumn(ColumnName = "MEMO")] //ç¨äºSqlSugar [StringLength(1000, ErrorMessage = "å¤æ³¨é¿åº¦ä¸è½è¶ åº1000")] public string Memo { get; set; } /// <summary> /// æå±å·¥åº /// </summary> [Column("PROC_NO")] [SugarColumn(ColumnName = "PROC_NO")] //ç¨äºSqlSugar [StringLength(32, ErrorMessage = "æå±å·¥åºé¿åº¦ä¸è½è¶ åº32")] public string ProcNo { get; set; } /// <summary> /// </summary> [Column("SHOW_INDEX")] [SugarColumn(ColumnName = "SHOW_INDEX")] //ç¨äºSqlSugar public decimal? ShowIndex { get; set; } /// <summary> /// </summary> [Column("SIMPLENAME")] [SugarColumn(ColumnName = "SIMPLENAME")] //ç¨äºSqlSugar [StringLength(20, ErrorMessage = "Simplenameé¿åº¦ä¸è½è¶ åº20")] public string Simplename { get; set; } /// <summary> /// æ åå·¥æ¶ /// </summary> [Column("STAND_TIME")] [SugarColumn(ColumnName = "STAND_TIME")] //ç¨äºSqlSugar public decimal? StandTime { get; set; } /// <summary> /// ç»é¿ /// </summary> [Column("USERCODE")] [SugarColumn(ColumnName = "USERCODE")] //ç¨äºSqlSugar [StringLength(50, ErrorMessage = "ç»é¿é¿åº¦ä¸è½è¶ åº50")] public string Usercode { get; set; } /// <summary> /// åºåéé°éäº /// </summary> [Column("WORKCENTERTYPE")] [SugarColumn(ColumnName = "WORKCENTERTYPE")] //ç¨äºSqlSugar [StringLength(50, ErrorMessage = "åºåéé°éäºé¿åº¦ä¸è½è¶ åº50")] public string Workcentertype { get; set; } [SugarColumn(ColumnName = "LABEL")] public string Label { get; set; } /// <summary> /// 车é´ç®ç /// </summary> [Column("WORKHOMEJM")] [SugarColumn(ColumnName = "WORKHOMEJM")] //ç¨äºSqlSugar [StringLength(20, ErrorMessage = "车é´ç®ç é¿åº¦ä¸è½è¶ åº20")] [SugarColumn(ColumnName = "WORKHOMEJM")] public string Workhomejm { get; set; } /// <summary> /// å·¥ä½ä¸å¿ç¼å· /// 线ç®ç /// </summary> [Column("WORKSHOP_CENTER_CODE")] [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] //ç¨äºSqlSugar [StringLength(20, ErrorMessage = "å·¥ä½ä¸å¿ç¼å·é¿åº¦ä¸è½è¶ åº20")] public string WorkshopCenterCode { get; set; } [SugarColumn(ColumnName = "LINEJM")] public string Linejm { get; set; } /// <summary> /// æ¥å·¥æ¹å¼ï¼0ã离æ£æ¥å·¥ï¼1ãæ´çº¿æ¥å·¥ï¼ /// æ¡ç ç±»å /// </summary> [Column("WORK_TYPE")] [SugarColumn(ColumnName = "WORK_TYPE")] //ç¨äºSqlSugar public decimal? WorkType { get; set; } [SugarColumn(ColumnName = "BARTYPE")] public string Bartype { get; set; } /// <summary> /// 微信æ¾ç¤ºå¼ /// </summary> [Column("WX_LABLE")] [SugarColumn(ColumnName = "WX_LABLE")] //ç¨äºSqlSugar [StringLength(50, ErrorMessage = "微信æ¾ç¤ºå¼é¿åº¦ä¸è½è¶ åº50")] [SugarColumn(ColumnName = "WX_LABLE")] public string WxLable { get; set; } /// <summary> /// åºåéé°éäº /// </summary> [SugarColumn(ColumnName = "WORKCENTERTYPE")] public string Workcentertype { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "SIMPLENAME")] public string Simplename { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "SHOW_INDEX")] public decimal? ShowIndex { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// 线边ä»åº /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// é»è®¤åºä½ /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] public string DepotSectionCode { get; set; } /// <summary> /// æ¥å·¥æ¹å¼ï¼0ã离æ£æ¥å·¥ï¼1ãæ´çº¿æ¥å·¥ï¼ /// </summary> [SugarColumn(ColumnName = "WORK_TYPE")] public decimal? WorkType { get; set; } /// <summary> /// é¨é¨ç¼å· /// </summary> [SugarColumn(ColumnName = "DEPARTMENTCODE")] public string Departmentcode { get; set; } /// <summary> /// æå±å·¥åº /// </summary> [SugarColumn(ColumnName = "PROC_NO")] public string ProcNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "LINE_STYLE")] public string LineStyle { get; set; } /// <summary> /// ç»é¿ç¼å· /// </summary> [SugarColumn(ColumnName = "L_CODE")] public string LCode { get; set; } } MES.Service/Modes/MesQaItemsDetect01.cs
@@ -8,325 +8,325 @@ [SugarTable("MES_QA_ITEMS_DETECT_01")] public class MesQaItemsDetect01 { /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] /// <summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } /// <summary> /// æ£éªäººå /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] /// <summary> /// æ£éªäººå /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// æ¥ææ°é /// </summary> [SugarColumn(ColumnName = "FBATCH_QTY")] /// <summary> /// æ¥ææ°é /// </summary> [SugarColumn(ColumnName = "FBATCH_QTY")] public decimal? FbatchQty { get; set; } /// <summary> /// å¤å®ç»æ /// </summary> [SugarColumn(ColumnName = "FRECE_QTY")] /// <summary> /// å¤å®ç»æ /// </summary> [SugarColumn(ColumnName = "FRECE_QTY")] public string FreceQty { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FNG_DESC")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FNG_DESC")] public string FngDesc { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FREVIEW")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FREVIEW")] public string Freview { get; set; } /// <summary> /// æ£éªæ°´å /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] /// <summary> /// æ£éªæ°´å /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } /// <summary> /// ææ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] /// <summary> /// ææ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } /// <summary> /// æ½æ£æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] /// <summary> /// æ½æ£æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] public string CheckQty { get; set; } /// <summary> /// æ¹æ¬¡å· --å°è´§åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO")] /// <summary> /// æ¹æ¬¡å· --å°è´§åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ¯å¦æ¨é /// </summary> [SugarColumn(ColumnName = "FMOVE")] /// <summary> /// æ¯å¦æ¨é /// </summary> [SugarColumn(ColumnName = "FMOVE")] public string Fmove { get; set; } /// <summary> /// æ¯å¦å¤ç /// </summary> [SugarColumn(ColumnName = "FHANDLE")] /// <summary> /// æ¯å¦å¤ç /// </summary> [SugarColumn(ColumnName = "FHANDLE")] public string Fhandle { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// å建æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æ´æ°æ¥æ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// æ´æ°æ¥æ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG")] /// <summary> /// æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG")] public decimal? Modify1Flag { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY")] public string Modify1By { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE")] /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE")] public DateTime? Modify1Date { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// XRFæµè¯æ¥åç¼å· /// </summary> [SugarColumn(ColumnName = "FCHECK_REPNO")] /// <summary> /// XRFæµè¯æ¥åç¼å· /// </summary> [SugarColumn(ColumnName = "FCHECK_REPNO")] public string FcheckRepno { get; set; } /// <summary> /// 第ä¸æ¹æ¥å /// </summary> [SugarColumn(ColumnName = "FTHIRD_REP")] /// <summary> /// 第ä¸æ¹æ¥å /// </summary> [SugarColumn(ColumnName = "FTHIRD_REP")] public string FthirdRep { get; set; } /// <summary> /// æ¯å¦ä½åº /// </summary> [SugarColumn(ColumnName = "FCANCEL")] /// <summary> /// æ¯å¦ä½åº /// </summary> [SugarColumn(ColumnName = "FCANCEL")] public decimal? Fcancel { get; set; } /// <summary> /// æ交æ è¯ /// </summary> [SugarColumn(ColumnName = "FSUBMIT")] /// <summary> /// æ交æ è¯ /// </summary> [SugarColumn(ColumnName = "FSUBMIT")] public decimal? Fsubmit { get; set; } /// <summary> /// æ£éªä¾æ® /// </summary> [SugarColumn(ColumnName = "FCHECK_ACCORD")] /// <summary> /// æ£éªä¾æ® /// </summary> [SugarColumn(ColumnName = "FCHECK_ACCORD")] public string FcheckAccord { get; set; } /// <summary> /// ç±»å(0 æ¥æ 1 å¨åº) /// </summary> [SugarColumn(ColumnName = "FTYPE")] /// <summary> /// ç±»å(0 æ¥æ 1 å¨åº) /// </summary> [SugarColumn(ColumnName = "FTYPE")] public short? Ftype { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "ITEM_UNIT")] /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "ITEM_UNIT")] public string ItemUnit { get; set; } /// <summary> /// åºè´§æ¥æ /// </summary> [SugarColumn(ColumnName = "OUT_DATE")] /// <summary> /// åºè´§æ¥æ /// </summary> [SugarColumn(ColumnName = "OUT_DATE")] public string OutDate { get; set; } /// <summary> /// æ¯å¦å æ£ /// </summary> [SugarColumn(ColumnName = "FEXEMPTION")] /// <summary> /// æ¯å¦å æ£ /// </summary> [SugarColumn(ColumnName = "FEXEMPTION")] public decimal? Fexemption { get; set; } /// <summary> /// æ¡£ä½æ å /// </summary> [SugarColumn(ColumnName = "FGEAR_STAND")] /// <summary> /// æ¡£ä½æ å /// </summary> [SugarColumn(ColumnName = "FGEAR_STAND")] public string FgearStand { get; set; } /// <summary> /// ä¸è¯å¤çæ¹æ³ /// </summary> [SugarColumn(ColumnName = "FNG_HANDLE")] /// <summary> /// ä¸è¯å¤çæ¹æ³ /// </summary> [SugarColumn(ColumnName = "FNG_HANDLE")] public string FngHandle { get; set; } /// <summary> /// 管çç¼å· /// </summary> [SugarColumn(ColumnName = "FMANAGE_NO")] /// <summary> /// 管çç¼å· /// </summary> [SugarColumn(ColumnName = "FMANAGE_NO")] public string FmanageNo { get; set; } /// <summary> /// 转æ¢æ°é /// </summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] /// <summary> /// 转æ¢æ°é /// </summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] public string FcovertQty { get; set; } /// <summary> /// çæ¬ /// </summary> [SugarColumn(ColumnName = "FVERSION")] /// <summary> /// çæ¬ /// </summary> [SugarColumn(ColumnName = "FVERSION")] public decimal? Fversion { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FSECOND_RESU")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FSECOND_RESU")] public string FsecondResu { get; set; } /// <summary> /// æ大æ½æ£æ° /// </summary> [SugarColumn(ColumnName = "MAX_CHECK_QTY")] /// <summary> /// æ大æ½æ£æ° /// </summary> [SugarColumn(ColumnName = "MAX_CHECK_QTY")] public decimal? MaxCheckQty { get; set; } /// <summary> /// ç¹å®ä¿®æ¹æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG1")] /// <summary> /// ç¹å®ä¿®æ¹æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG1")] public decimal? Modify1Flag1 { get; set; } /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY1")] /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY1")] public string Modify1By1 { get; set; } /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸æ¶é´ /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE1")] /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸æ¶é´ /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE1")] public DateTime? Modify1Date1 { get; set; } /// <summary> /// å°æ¹æ¬¡å· /// </summary> [SugarColumn(ColumnName = "LOT_NO1")] /// <summary> /// å°æ¹æ¬¡å· /// </summary> [SugarColumn(ColumnName = "LOT_NO1")] public string LotNo1 { get; set; } /// <summary> /// éè´åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO2")] /// <summary> /// éè´åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO2")] public string LotNo2 { get; set; } /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// å°è´§æ¶é´ /// </summary> [SugarColumn(ColumnName = "DHA018")] /// <summary> /// å°è´§æ¶é´ /// </summary> [SugarColumn(ColumnName = "DHA018")] public string Dha018 { get; set; } /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "DHB002")] /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "DHB002")] public decimal? Dhb002 { get; set; } /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "DHB001")] /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "LIFNR")] /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "LIFNR")] public string Lifnr { get; set; } /// <summary> /// éææ¹å¼ /// </summary> [SugarColumn(ColumnName = "FMRMODE")] /// <summary> /// éææ¹å¼ /// </summary> [SugarColumn(ColumnName = "FMRMODE")] public string Fmrmode { get; set; } /// <summary> 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/MesSchemeResult.cs
ÎļþÒÑɾ³ý 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/Womdaa.cs
@@ -11,11 +11,11 @@ /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, IsIdentity = true)] public decimal Id { get; set; } [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal? Id { get; set; } /// <summary> /// PID /// æ产ID /// </summary> [SugarColumn(ColumnName = "PID")] public decimal? Pid { get; set; } @@ -27,7 +27,7 @@ public string? Daa001 { get; set; } /// <summary> /// 产åç¼ç /// 产åID /// </summary> [SugarColumn(ColumnName = "DAA002")] public string? Daa002 { get; set; } @@ -51,13 +51,13 @@ public string? Daa005 { get; set; } /// <summary> /// é¢è®¡å¼å·¥æ¶é´ /// ERPé¢è®¡å¼å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "DAA006")] public DateTime? Daa006 { get; set; } /// <summary> /// é¢è®¡å®å·¥æ¶é´ /// ERPé¢è®¡å®å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "DAA007")] public DateTime? Daa007 { get; set; } @@ -229,4 +229,88 @@ /// </summary> [SugarColumn(ColumnName = "DAA028")] public string? Daa028 { get; set; } /// <summary> /// æ åå·¥æ¶ /// </summary> [SugarColumn(ColumnName = "PROD_HOUR")] public decimal? ProdHour { get; set; } /// <summary> /// å人å°æ¶äº§è½ /// </summary> [SugarColumn(ColumnName = "PERSON_HOUR_CAPACITY")] public decimal? PersonHourCapacity { get; set; } /// <summary> /// ç论æ 产 /// </summary> [SugarColumn(ColumnName = "THE_CAPACITY")] public decimal? TheCapacity { get; set; } /// <summary> /// 计åç¨äººæ° /// </summary> [SugarColumn(ColumnName = "PLAN_PERSONNEL")] public decimal? PlanPersonnel { get; set; } /// <summary> /// 计åæ åäº§è½ /// </summary> [SugarColumn(ColumnName = "PLAN_CAPACITY")] public decimal? PlanCapacity { get; set; } /// <summary> /// ç论ç¨æ¶/M /// </summary> [SugarColumn(ColumnName = "THE_MIN")] public decimal? TheMin { get; set; } /// <summary> /// ç论ç¨æ¶/H /// </summary> [SugarColumn(ColumnName = "THE_HOUR")] public decimal? TheHour { get; set; } /// <summary> /// 线ä½ç±»å« /// </summary> [SugarColumn(ColumnName = "LINE_TYPE")] public string? LineType { get; set; } /// <summary> /// æ åäººæ° /// </summary> [SugarColumn(ColumnName = "PERSONNEL")] public decimal? Personnel { get; set; } /// <summary> /// æ¢çº¿æ¶é´ /// </summary> [SugarColumn(ColumnName = "CHANGE_LINE_TIME")] public decimal? ChangeLineTime { get; set; } /// <summary> /// ä¼æ¯æ¶é´ /// </summary> [SugarColumn(ColumnName = "REST_TIME")] public decimal? RestTime { get; set; } /// <summary> /// æ产åºå· /// </summary> [SugarColumn(ColumnName = "SCHEDULE_ORDER")] public decimal? ScheduleOrder { get; set; } /// <summary> /// MESé¢è®¡å¼å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "MES_START_PROD")] public DateTime? MesStartProd { get; set; } /// <summary> /// MESé¢è®¡å®å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "MES_END_PROD")] public DateTime? MesEndProd { get; set; } } MES.Service/service/QC/RKJService.cs
@@ -418,14 +418,14 @@ var mesInvItemIns = db.Queryable<MesInvItemIns>() .Single(s => s.BillNo == qsItemOqcReq.BillNo); var mesSchemeResult = db.Queryable<MesSchemeResult>() .Single(s => s.BillNo == mesInvItemIns.CbillNo); var mesSchemeResult = db.Queryable<Womdaa>() .Single(s => s.Daa001 == mesInvItemIns.CbillNo); var entity = new MesQaItemsDetect02(); entity.ItemNo = mesSchemeResult.BoardItem; entity.BoardItem = mesSchemeResult.BoardItem; entity.LineNo = mesSchemeResult.LineNo; entity.Aufnr = mesSchemeResult.TaskNo; // entity.ItemNo = mesSchemeResult.BoardItem; // entity.BoardItem = mesSchemeResult.BoardItem; entity.LineNo = mesSchemeResult.Daa015; // entity.Aufnr = mesSchemeResult.TaskNo; entity.ReleaseNo = qsItemOqcReq.ReleaseNo; entity.LotNo = qsItemOqcReq.BillNo; entity.FcheckDate = qsItemOqcReq.FcheckDate; MES.Service/service/QC/SJService.cs
@@ -99,7 +99,7 @@ var count = db.Queryable<MesQa>().Where(s => s.QsType == "1" && s.ItemNo == itemNo && s.Fsubmit == 1).Count(); if (count <= 0) return new List<QsItemIpiItem>(); if (count <= 0) return []; return db .Queryable<MesQualityStandard>() MES.Service/service/QC/SuspendService.cs
@@ -6,20 +6,21 @@ public class SuspendService { private readonly string[] statusArray = ["ç产", "å¾ äº§", "æå"]; private readonly string[] statusArray = ["å¼å·¥", "å¾ å¼å·¥"]; public List<SysDepartment> getDept() { var db = SqlSugarHelper.GetInstance(); //return db.Queryable<SysDepartment>().ToList(); return db .Queryable<MesSchemeResult, MesLine, QsQaItemXj, SysDepartment>( .Queryable<Womdaa, MesLine, QsQaItemXj, SysDepartment>( (a, b, c, d) => new JoinQueryInfos(JoinType.Left, a.LineNo == b.LineNo, JoinType.Inner, a.BillNo == c.BillNo, new JoinQueryInfos(JoinType.Left, a.Daa002 == b.Id.ToString(), JoinType.Inner, a.Daa001 == c.BillNo, JoinType.Left, b.Departmentcode == d.Departmentcode)) .Where((a, b, c, d) => a.PmoveMk == 0 && b.LineName != null && statusArray.Contains(a.ProcStatus)) .Where((a, b, c, d) => b.LineName != null && statusArray.Contains(a.Daa018)) .GroupBy((a, b, c, d) => new { b.Departmentcode, d.Departmentname @@ -34,20 +35,21 @@ public List<MesLine> GetLines(string deptCode) { var db = SqlSugarHelper.GetInstance(); var mesLines = db.Queryable<MesSchemeResult, MesLine, QsQaItemXj>( var mesLines = db.Queryable<Womdaa, MesLine, QsQaItemXj>( (a, b, c) => new JoinQueryInfos(JoinType.Left, a.LineNo == b.LineNo, JoinType.Inner, a.BillNo == c.BillNo)) new JoinQueryInfos(JoinType.Left, a.Daa002 == b.Id.ToString(), JoinType.Inner, a.Daa001 == c.BillNo)) .Where((a, b, c) => b.LineName != null && statusArray.Contains(a.ProcStatus) statusArray.Contains(a.Daa018) && b.Departmentcode == deptCode) .GroupBy((a, b, c) => new { a.LineNo, b.LineName b.LineNo, b.LineName }) .Select((a, b, c) => new MesLine { LineNo = a.LineNo, LineNo = b.LineNo, LineName = b.LineName }).ToList();
@@ -13,7 +13,7 @@ private readonly BaseService _baseService = new(); private readonly string[] statusArray = ["ç产", "å¾ äº§"]; private readonly string[] statusArray = ["å¼å·¥", "å¾ å¼å·¥"]; //çæææ°çæ£éªåå· public string getMaxReleaseNo() @@ -38,35 +38,16 @@ return "XJN" + date + number; } public List<MesSchemeResult> getItem(string daa001) public List<Womdaa> getItem(string daa001) { var db = SqlSugarHelper.GetInstance(); //inçåæ³ https://www.donet5.com/Home/Doc?typeId=1187 return db.Queryable<MesSchemeResult, MesDepTask, MesBoardBaseInfo>( (a, c, b) => new JoinQueryInfos( JoinType.Left, a.TaskNo == c.TaskNo, JoinType.Left, c.BoardItem == b.BoardItem ) ) .Where(a => a.PmoveMk == 0 && a.BillNo == daa001 && statusArray.Contains(a.ProcStatus)) .Select((a, c, b) => new MesSchemeResult { BillNo = a.BillNo, CatQty = a.CatQty, DetailMem = a.DetailMem, TaskNo = a.TaskNo, BoardItem = a.BoardItem, BoardModel = b.BoardModel, PlanQty = c.PlanQty, Mocode = a.Mocode, // BoardStyle = c.BoardStyle, Id = a.Id }) return db.Queryable<Womdaa>() .Where(a => a.Daa001 == daa001 && statusArray.Contains(a.Daa018)) .ToList(); } @@ -74,50 +55,52 @@ { var db = SqlSugarHelper.GetInstance(); return db.Queryable<MesSchemeResult, MesLine>((a, b) => new JoinQueryInfos(JoinType.Left, a.LineNo == b.LineNo)) .Where((a, b) => a.PmoveMk == 0 && b.LineName != null && statusArray.Contains(a.ProcStatus)) .Where("BOARD_ITEM like @BoardItem", new { BoardItem = "20%" }) return db.Queryable<Womdaa, MesLine>((a, b) => new JoinQueryInfos(JoinType.Left, a.Daa015 == b.LineNo)) .Where((a, b) => b.LineName != null && statusArray.Contains(a.Daa018)) .GroupBy((a, b) => new { a.LineNo, b.LineName b.LineNo, b.LineName }) .Select((a, b) => new MesLine { LineNo = a.LineNo, LineNo = b.LineNo, LineName = b.LineName }).OrderBy("a.LINE_NO").ToList(); }).OrderBy("b.LINE_NO").ToList(); } public List<MesSchemeResult> getDaa001(string daa020, string item) public List<Womdaa> getDaa001(string daa020, string item) { var db = SqlSugarHelper.GetInstance(); return db.Queryable<MesSchemeResult>().Where(a => a.PmoveMk == 0 && a.LineNo == daa020 && a.BillNo != null && a.BoardItem == item && statusArray.Contains(a.ProcStatus)) .Select<MesSchemeResult>(a => new MesSchemeResult return db.Queryable<Womdaa, MesItems>((a, b) => new JoinQueryInfos(JoinType.Inner, a.Daa002 == b.Id.ToString())) .Where((a, b) => a.Daa015 == daa020 && b.ItemNo == item && statusArray.Contains(a.Daa018)) .Select<Womdaa>(a => new Womdaa { BillNo = a.BillNo, DetailMem = a.DetailMem Id = a.Id, Daa001 = a.Daa001, Daa003 = a.Daa003 }).ToList(); } public List<MesSchemeResult> getBoardItem(string lineNo) public List<MesItems> getBoardItem(string lineNo) { var db = SqlSugarHelper.GetInstance(); return db.Queryable<MesSchemeResult>() .Where(a => a.PmoveMk == 0 && statusArray.Contains(a.ProcStatus) && a.LineNo == lineNo) .Where("BOARD_ITEM like @BoardItem", new { BoardItem = "20%" }) .Select<MesSchemeResult>(a => new MesSchemeResult return db.Queryable<Womdaa, MesItems>((a, b) => new JoinQueryInfos(JoinType.Inner, a.Daa002 == b.Id.ToString())) .Where((a, b) => statusArray.Contains(a.Daa018) && a.Daa015 == lineNo) .OrderBy((a, b) => b.ItemName) .Select<MesItems>((a, b) => new MesItems { BoardItem = a.BoardItem, DetailMem = a.DetailMem }).OrderBy(a => a.BoardItem).ToList(); ItemNo = b.ItemNo, ItemName = b.ItemName }).ToList(); } public List<QsQaItemXj> getPage(XJPageResult queryObj) @@ -132,16 +115,16 @@ lineNo = _baseService.getUserLineNo(queryObj.createUser); return db .Queryable<QsQaItemXj, MesSchemeResult, MesDepTask, MesBoardBaseInfo>((s, a, c, b) => .Queryable<QsQaItemXj, Womdaa, MesLine, MesItems>((s, a, c, b) => new JoinQueryInfos( JoinType.Inner, s.BillNo == a.BillNo, JoinType.Left, a.TaskNo == c.TaskNo, JoinType.Left, c.BoardItem == b.BoardItem JoinType.Inner, s.BillNo == a.Daa001, JoinType.Left, a.Daa015 == c.LineNo, JoinType.Left, s.ItemNo == b.ItemNo ) ) .WhereIF(lineNo != null && lineNo.Length > 0, (s, a, c, b) => lineNo.Contains(a.LineNo)) (s, a, c, b) => lineNo.Contains(c.LineNo)) .WhereIF( StringUtil.IsNotNullOrEmpty(queryObj.result) && "æªå®æ".Equals(queryObj.result), @@ -153,11 +136,8 @@ .WhereIF(id > 0, (s, a, c, b) => s.Id == id) .Select((s, a, c, b) => new QsQaItemXj { CatQty = a.CatQty, MoidNum = s.MoidNum, Daa020 = a.LineNo, // DetailMem = a.DetailMem, TaskNo = a.TaskNo, Daa020 = c.LineNo, Id = s.Id, CreateBy = s.CreateBy, CreateDate = s.CreateDate, @@ -167,11 +147,7 @@ BillNo = s.BillNo, FcheckBy = s.FcheckBy, FcheckResu = s.FcheckResu, Remarks = s.Remarks, BoardModel = b.BoardModel, PlanQty = c.PlanQty // Mocode = a.Mocode, // BoardStyle = c.BoardStyle Remarks = s.Remarks }).OrderBy(s => s.CreateDate, OrderByType.Desc) .ToPageList(queryObj.PageIndex, queryObj.Limit); } MES.Service/service/Warehouse/MesInvItemMovesManager.cs
@@ -15,12 +15,10 @@ public MovesDto ScanInBarcode(WarehouseQuery query) { if (string.IsNullOrEmpty(query.sectionCode)) { throw new Exception("请æ«åºä½æ¡ç ï¼"); } int pBillTypeId = 300; int pTransctionNo = 301; var pBillTypeId = 300; var pTransctionNo = 301; var depotQuery = Db.Queryable<MesDepotSections, MesDepots>((a, b) => new JoinQueryInfos( @@ -30,9 +28,7 @@ .First(); if (depotQuery == null) { throw new Exception($"002[åºä½ç¼ç {query.sectionCode} ä¸åå¨ï¼è¯·ç¡®è®¤ï¼"); } var cDepotCode = depotQuery.DepotCode; @@ -48,10 +44,7 @@ .Select((a, b) => new { a.Id, a.BillNo, a.InvDepotsCode }) .First(); if (itemMoveQuery == null) { throw new Exception("æ¡ç æªåè°æåºåºæ«ç ï¼è¯·æ ¸å¯¹ï¼"); } if (itemMoveQuery == null) throw new Exception("æ¡ç æªåè°æåºåºæ«ç ï¼è¯·æ ¸å¯¹ï¼"); var cBillNo = itemMoveQuery.BillNo; var iDepotCode = itemMoveQuery.InvDepotsCode; @@ -66,14 +59,10 @@ .First(); if (depotValidationQuery == null) { throw new Exception($"002[åºä½ç¼ç {query.sectionCode} ä¸åå¨ï¼è¯·ç¡®è®¤ï¼"); } if (iDepotCode != depotValidationQuery.DepotCode) { throw new Exception("å®é ä»åºä¸ç³è¯·è°å ¥ä»åºä¸ç¬¦ï¼è¯·æ ¸å¯¹ï¼"); } var barcodeCount = Db.Queryable<MesInvItemMovesCDetails>() .Where(b => @@ -81,19 +70,13 @@ b.ItemMoveId == itemMoveQuery.Id && b.MoveOk == 1) .Count(); if (barcodeCount > 0) { throw new Exception("æ¡ç è°æå·²å®æï¼è¯·æ ¸å¯¹ï¼"); } if (barcodeCount > 0) throw new Exception("æ¡ç è°æå·²å®æï¼è¯·æ ¸å¯¹ï¼"); var barcodeInfo = Db.Queryable<MesInvItemBarcodes>() .Where(t => t.ItemBarcode == query.barcode) .First(); if (barcodeInfo == null) { throw new Exception("æ¡ç ä¸åå¨ï¼è¯·æ ¸å¯¹ï¼"); } if (barcodeInfo == null) throw new Exception("æ¡ç ä¸åå¨ï¼è¯·æ ¸å¯¹ï¼"); var isAudit = UseTransaction(db => { @@ -140,15 +123,12 @@ .Where(a => a.ItemMoveId == itemMoveQuery.Id && a.MoveOk == 1) .Sum(a => SqlFunc.IsNull(a.Quantity, 0)); if (totalQuantity == scannedQuantity) { return 1; } if (totalQuantity == scannedQuantity) return 1; return 0; }); MovesDto dto = new MovesDto(); var dto = new MovesDto(); dto.InAudit = isAudit == 1; dto.BarcodesInfo = barcodeInfo; return dto; @@ -180,7 +160,7 @@ public MovesDto GetItems(WarehouseQuery query) { MovesDto dto = new MovesDto(); var dto = new MovesDto(); dto.BarcodeList = GetItemMovesCDetails(query); dto.OutItems = GetItemOutItems(query); @@ -287,7 +267,7 @@ if (sumqty > quantity) throw new Exception( "å·²æ«æ¡ç æ°éææ¬æ¬¡æ«ç æ°éï¼" + sumqty + " 大äºç³è¯·æ°éï¼" + quantity + "ï¼è¯·æ ¸å¯¹ï¼"); UseTransaction(db => { SaveMesInvItemMovesCDetails(db, query, mesInvItemMoves, MESApplication/Controllers/Base/DemoController.cs
@@ -3,6 +3,7 @@ using MES.Service.util; using Microsoft.AspNetCore.Mvc; using Newtonsoft.Json.Linq; namespace MESApplication.Controllers.Base; [Route("api/[controller]")] MESApplication/Controllers/Base/LoginController.cs
@@ -8,14 +8,14 @@ namespace MESApplication.Controllers.Base; /// <summary> /// ç¨æ· /// ç¨æ· /// </summary> [Route("api/[controller]")] [ApiController] public class LoginController : ControllerBase { /// <summary> /// ç»å½ /// ç»å½ /// </summary> /// <param name="model"></param> /// <returns></returns> @@ -43,7 +43,7 @@ } /// <summary> /// é设å¯ç /// é设å¯ç /// </summary> /// <param name="data"></param> /// <returns></returns> @@ -80,7 +80,7 @@ } /// <summary> /// ç¨æ·èå /// ç¨æ·èå /// </summary> /// <param name="data"></param> /// <returns></returns> MESApplication/Controllers/QC/XJController.cs
@@ -82,7 +82,9 @@ } //getDaa001 /// <summary> /// è·åå·¥å /// </summary> [HttpPost("getDaa001")] public ResponseResult getDaa001([FromBody] JObject data) { @@ -107,7 +109,10 @@ } } //getBoardItem /// <summary> /// æ ¹æ®äº§çº¿è·åç©æç¼ç lineNo /// </summary> /// <returns></returns> [HttpPost("getBoardItem")] public ResponseResult getBoardItem([FromBody] JObject data) { MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs
@@ -12,7 +12,7 @@ public class MesInvItemMovesController : ControllerBase { private readonly MesInvItemMovesManager m = new(); //ScanInBarcode [HttpPost("ScanInBarcode")] public ResponseResult ScanInBarcode(WarehouseQuery query) @@ -33,7 +33,7 @@ return ResponseResult.ResponseError(ex); } } [HttpPost("Audit")] public ResponseResult Audit(WarehouseQuery query) { @@ -53,7 +53,7 @@ return ResponseResult.ResponseError(ex); } } [HttpPost("SaveMessageCenter")] public ResponseResult SaveMessageCenter(WarehouseQuery entity) { @@ -94,7 +94,7 @@ return ResponseResult.ResponseError(ex); } } //GetItems [HttpPost("GetItems")] public ResponseResult GetItems(WarehouseQuery query) @@ -115,7 +115,7 @@ return ResponseResult.ResponseError(ex); } } //ScanMoveBarcode [HttpPost("ScanMoveBarcode")] public ResponseResult ScanMoveBarcode(WarehouseQuery query) @@ -157,7 +157,7 @@ return ResponseResult.ResponseError(ex); } } /// <summary> /// è·åææ /// </summary> MESApplication/Filter/ActionFilter.cs
@@ -1,160 +1,163 @@ using Microsoft.AspNetCore.Mvc; using System.Diagnostics; using System.Text; using Microsoft.AspNetCore.Mvc; using Microsoft.AspNetCore.Mvc.Controllers; using Microsoft.AspNetCore.Mvc.Filters; using Newtonsoft.Json; using System.Diagnostics; using System.Text; namespace MESApplication namespace MESApplication; /// <summary> /// æ¹æ³è¿æ»¤å¨ /// </summary> public class ActionFilter : IActionFilter { private Stopwatch _stopwatch; /// <summary> /// æ¹æ³è¿æ»¤å¨ /// çæ§æ¥å¿ /// </summary> public class ActionFilter : IActionFilter public static ILogger LoggerMonitor { get; set; } /// <summary> /// é误æ¥å¿ /// </summary> public static ILogger LoggerError { get; set; } /// <summary> /// æ¹æ³æ§è¡å /// </summary> /// <param name="context"></param> /// <exception cref="NotImplementedException"></exception> public async void OnActionExecuting(ActionExecutingContext context) { /// <summary> /// çæ§æ¥å¿ /// </summary> public static ILogger LoggerMonitor { get; set; } /// <summary> /// é误æ¥å¿ /// </summary> public static ILogger LoggerError { get; set; } private Stopwatch _stopwatch; /// <summary> /// å建请æ±æ¥å¿ææ¬ /// </summary> /// <param name="method"></param> /// <param name="controllerName"></param> /// <param name="actionName"></param> /// <param name="actionArgs"></param> /// <returns></returns> private static string CreateRequestLogText(string method, string controllerName, string actionName, string requestHead, string requestBody) // ErrorLog.Write("=================================================================================================================================="); _stopwatch = new Stopwatch(); _stopwatch.Start(); //throw new NotImplementedException(); if (LoggerMonitor != null) { StringBuilder sb = new StringBuilder(); sb.Append($"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} 请æ±{method}/{controllerName}/{actionName}æ¥å£ï¼è¯·æ±Headï¼{requestHead}\n"); sb.Append($"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} 请æ±{method}/{controllerName}/{actionName}æ¥å£ï¼è¯·æ±Bodyï¼{requestBody}\n"); return sb.ToString(); } /// <summary> /// å建ååºæ¥å¿ææ¬ /// </summary> /// <param name="method"></param> /// <param name="controllerName"></param> /// <param name="actionName"></param> /// <param name="result"></param> /// <returns></returns> private static string CreateResponseLogText(string method, string controllerName, string actionName, object result) { StringBuilder sb = new StringBuilder(); sb.Append($"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} å®æ请æ±{method}/{controllerName}/{actionName}æ¥å£ï¼è¿åç»æï¼"); if (result != null) //è®°å½è¯·æ±åæ°æ¥å¿ var desc = context.ActionDescriptor as ControllerActionDescriptor; if (desc != null) { sb.Append($"{JsonConvert.SerializeObject(result)}"); } else { sb.Append($"æ "); } return sb.ToString(); } var headers = new Dictionary<string, object>(); var requestHeaders = context.HttpContext.Request.Headers; // 访é®è¯·æ±ä¸ç header ä¿¡æ¯ foreach (var header in requestHeaders) headers.Add(header.Key, header.Value); var requestHead = JsonConvert.SerializeObject(headers); /// <summary> /// æ¹æ³æ§è¡å /// </summary> /// <param name="context"></param> /// <exception cref="NotImplementedException"></exception> public async void OnActionExecuting(ActionExecutingContext context) { // ErrorLog.Write("=================================================================================================================================="); _stopwatch = new Stopwatch(); _stopwatch.Start(); //throw new NotImplementedException(); if (LoggerMonitor != null) { //è®°å½è¯·æ±åæ°æ¥å¿ ControllerActionDescriptor desc = context.ActionDescriptor as ControllerActionDescriptor; if (desc != null) var bodys = new Dictionary<string, object>(); var actionArguments = context.ActionArguments; // 访é®è¯·æ±ä¸çåæ° foreach (var argument in actionArguments) { Dictionary<string, object> headers = new Dictionary<string, object>(); var requestHeaders = context.HttpContext.Request.Headers; // 访é®è¯·æ±ä¸ç header ä¿¡æ¯ foreach (var header in requestHeaders) { headers.Add(header.Key, header.Value); } var requestHead = JsonConvert.SerializeObject(headers); Dictionary<string, object> bodys = new Dictionary<string, object>(); var actionArguments = context.ActionArguments; // 访é®è¯·æ±ä¸çåæ° foreach (var argument in actionArguments) { //dic.Add(argument.Key, argument.Value); var parameter = JsonConvert.DeserializeObject<Dictionary<string, object>>(argument.Value.ToString()); foreach (var item in parameter) { bodys.Add(item.Key, item.Value); } } var requestBody = JsonConvert.SerializeObject(bodys); var logText = CreateRequestLogText(context.HttpContext.Request.Method, desc.ControllerName, desc.ActionName, requestHead, requestBody); //LoggerMonitor.LogDebug(logText); //ErrorLog.Write(logText); //dic.Add(argument.Key, argument.Value); var parameter = JsonConvert .DeserializeObject<Dictionary<string, object>>( argument.Value.ToString()); foreach (var item in parameter) bodys.Add(item.Key, item.Value); } var requestBody = JsonConvert.SerializeObject(bodys); var logText = CreateRequestLogText( context.HttpContext.Request.Method, desc.ControllerName, desc.ActionName, requestHead, requestBody); //LoggerMonitor.LogDebug(logText); //ErrorLog.Write(logText); } } public void OnActionExecuted(ActionExecutedContext context) { //throw new NotImplementedException(); _stopwatch.Stop(); long elaspsedMillisedconds = _stopwatch.ElapsedMilliseconds; string msg = ""; //string msg = $"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} æ¥å£æ§è¡æ¶é´ï¼{elaspsedMillisedconds}毫ç§"; //ErrorLog.Write(msg); if (context.Exception != null) { // è®°å½å¼å¸¸æ¥å¿ if (LoggerError != null) { LoggerError.LogError(context.Exception, context.Exception.Message); ErrorLog.Write($@"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} æ¥å£å¼å¸¸ï¼{JsonConvert.SerializeObject(context.Exception)}"); ErrorLog.Write($@"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} å¼å¸¸æ示信æ¯ï¼{JsonConvert.SerializeObject(context.Exception.Message)}"); ErrorLog.Write("=================================================================================================================================="); } } if (LoggerMonitor != null) { // è®°å½è¯·æ±ç»ææ¥å¿ ControllerActionDescriptor desc = context.ActionDescriptor as ControllerActionDescriptor; if (desc != null) { ObjectResult rst = context.Result as ObjectResult; object rstValue = rst != null ? rst.Value : null; var logText = CreateResponseLogText( context.HttpContext.Request.Method, desc.ControllerName, desc.ActionName, rstValue); LoggerMonitor.LogDebug(logText); ErrorLog.Write(logText); } } // ErrorLog.Write(msg); // ErrorLog.Write("=================================================================================================================================="); } } } public void OnActionExecuted(ActionExecutedContext context) { //throw new NotImplementedException(); _stopwatch.Stop(); var elaspsedMillisedconds = _stopwatch.ElapsedMilliseconds; var msg = ""; //string msg = $"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} æ¥å£æ§è¡æ¶é´ï¼{elaspsedMillisedconds}毫ç§"; //ErrorLog.Write(msg); if (context.Exception != null) // è®°å½å¼å¸¸æ¥å¿ if (LoggerError != null) { LoggerError.LogError(context.Exception, context.Exception.Message); ErrorLog.Write( $@"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} æ¥å£å¼å¸¸ï¼{JsonConvert.SerializeObject(context.Exception)}"); ErrorLog.Write( $@"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} å¼å¸¸æ示信æ¯ï¼{JsonConvert.SerializeObject(context.Exception.Message)}"); ErrorLog.Write( "=================================================================================================================================="); } if (LoggerMonitor != null) { // è®°å½è¯·æ±ç»ææ¥å¿ var desc = context.ActionDescriptor as ControllerActionDescriptor; if (desc != null) { var rst = context.Result as ObjectResult; var rstValue = rst != null ? rst.Value : null; var logText = CreateResponseLogText( context.HttpContext.Request.Method, desc.ControllerName, desc.ActionName, rstValue); LoggerMonitor.LogDebug(logText); ErrorLog.Write(logText); } } // ErrorLog.Write(msg); // ErrorLog.Write("=================================================================================================================================="); } /// <summary> /// å建请æ±æ¥å¿ææ¬ /// </summary> /// <param name="method"></param> /// <param name="controllerName"></param> /// <param name="actionName"></param> /// <param name="actionArgs"></param> /// <returns></returns> private static string CreateRequestLogText(string method, string controllerName, string actionName, string requestHead, string requestBody) { var sb = new StringBuilder(); sb.Append( $"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} 请æ±{method}/{controllerName}/{actionName}æ¥å£ï¼è¯·æ±Headï¼{requestHead}\n"); sb.Append( $"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} 请æ±{method}/{controllerName}/{actionName}æ¥å£ï¼è¯·æ±Bodyï¼{requestBody}\n"); return sb.ToString(); } /// <summary> /// å建ååºæ¥å¿ææ¬ /// </summary> /// <param name="method"></param> /// <param name="controllerName"></param> /// <param name="actionName"></param> /// <param name="result"></param> /// <returns></returns> private static string CreateResponseLogText(string method, string controllerName, string actionName, object result) { var sb = new StringBuilder(); sb.Append( $"{DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff")} å®æ请æ±{method}/{controllerName}/{actionName}æ¥å£ï¼è¿åç»æï¼"); if (result != null) sb.Append($"{JsonConvert.SerializeObject(result)}"); else sb.Append("æ "); return sb.ToString(); } } MESApplication/Filter/ErrorLog.cs
@@ -1,70 +1,67 @@ namespace MESApplication namespace MESApplication; public class ErrorLog { public class ErrorLog private static readonly string DirectoryPath = AppDomain.CurrentDomain.BaseDirectory; /// <summary> /// åå ¥æä½æ¥å¿å°æä»¶ä¸ /// </summary> /// <param name="moduleName">模ååå</param> /// <param name="message">é误ææ¬ä¿¡æ¯</param> /// <param name="ex">å¼å¸¸</param> public static void Write(string moduleName, string message, Exception ex) { //string directoryPath = $@"C:\è³ç®ç§æ\MyDemoData\.NetCoreæ¥å£è¿æ»¤å¨é¡¹ç®\FilterText\FilterText\Logger\{DateTime.Now.ToString("yyyyMMdd")}"; // ç®æ ç®å½è·¯å¾ var directoryPath = $@"{DirectoryPath}{"log"}"; // ç®æ ç®å½è·¯å¾ private static string DirectoryPath = AppDomain.CurrentDomain.BaseDirectory; if (!Directory.Exists(directoryPath)) // å¦æç®å½ä¸åå¨ï¼åæ°å»ºæ件夹 Directory.CreateDirectory(directoryPath); /// <summary> /// åå ¥æä½æ¥å¿å°æä»¶ä¸ /// </summary> /// <param name="moduleName">模ååå</param> /// <param name="message">é误ææ¬ä¿¡æ¯</param> /// <param name="ex">å¼å¸¸</param> public static void Write(string moduleName, string message, Exception ex) { //string directoryPath = $@"C:\è³ç®ç§æ\MyDemoData\.NetCoreæ¥å£è¿æ»¤å¨é¡¹ç®\FilterText\FilterText\Logger\{DateTime.Now.ToString("yyyyMMdd")}"; // ç®æ ç®å½è·¯å¾ string directoryPath = $@"{DirectoryPath}{"log"}"; // ç®æ ç®å½è·¯å¾ var filePath = directoryPath + $@"\{DateTime.Now.ToString("yyyyMMddHH")}.log"; // ç®æ æä»¶è·¯å¾ if (!Directory.Exists(directoryPath)) if (!File.Exists(filePath)) // å¦ææ件ä¸åå¨ï¼åå建æ件 using (File.Create(filePath)) { // å¦æç®å½ä¸åå¨ï¼åæ°å»ºæ件夹 Directory.CreateDirectory(directoryPath); //Console.WriteLine("æ件已å建"); } string filePath = directoryPath + $@"\{DateTime.Now.ToString("yyyyMMddHH")}.log"; // ç®æ æä»¶è·¯å¾ LogToFile(filePath, message); } if (!File.Exists(filePath)) { // å¦ææ件ä¸åå¨ï¼åå建æ件 using (File.Create(filePath)) { //Console.WriteLine("æ件已å建"); } } LogToFile(filePath, message); } /// <summary> /// åå ¥æä½æ¥å¿å°æä»¶ä¸ /// </summary> /// <param name="moduleName">模ååå</param> /// <param name="ex">å¼å¸¸</param> public static void Write(string moduleName, Exception ex) { Write(moduleName, moduleName, ex); } /// <summary> /// åå ¥æä½æ¥å¿å°æä»¶ä¸ /// </summary> /// <param name="moduleName">模ååå</param> /// <param name="ex">å¼å¸¸</param> public static void Write(string moduleName, Exception ex) /// <summary> /// åå ¥è¿ç¨æ°æ®æ说æå°æ件ä¸ï¼ä»¥ä¾¿è·è¸ª /// </summary> /// <param name="moduleName">模ååå</param> /// <param name="ex">å¼å¸¸</param> public static void Write(string message) { Write(string.Empty, message, null); } /// <summary> /// ææ¬åå ¥ /// </summary> /// <param name="logMessage"></param> private static void LogToFile(string logFilePath, string logMessage) { using (var sw = File.AppendText(logFilePath)) { Write(moduleName, moduleName, ex); } /// <summary> /// åå ¥è¿ç¨æ°æ®æ说æå°æ件ä¸ï¼ä»¥ä¾¿è·è¸ª /// </summary> /// <param name="moduleName">模ååå</param> /// <param name="ex">å¼å¸¸</param> public static void Write(string message) { Write(String.Empty, message, null); } /// <summary> /// ææ¬åå ¥ /// </summary> /// <param name="logMessage"></param> private static void LogToFile(string logFilePath, string logMessage) { using (StreamWriter sw = File.AppendText(logFilePath)) { sw.WriteLine($"{logMessage}"); } sw.WriteLine($"{logMessage}"); } } } } MESApplication/MESApplication.csproj
@@ -9,7 +9,7 @@ </PropertyGroup> <ItemGroup> <PackageReference Include="Microsoft.AspNetCore.Mvc.NewtonsoftJson" Version="8.0.0" /> <PackageReference Include="Microsoft.AspNetCore.Mvc.NewtonsoftJson" Version="8.0.0"/> <PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="8.0.1"> <PrivateAssets>all</PrivateAssets> <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets> @@ -18,12 +18,12 @@ <PrivateAssets>all</PrivateAssets> <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets> </PackageReference> <PackageReference Include="Oracle.EntityFrameworkCore" Version="8.21.121" /> <PackageReference Include="Swashbuckle.AspNetCore" Version="6.4.0" /> <PackageReference Include="Oracle.EntityFrameworkCore" Version="8.21.121"/> <PackageReference Include="Swashbuckle.AspNetCore" Version="6.4.0"/> </ItemGroup> <ItemGroup> <ProjectReference Include="..\MES.Service\MES.Service.csproj" /> <ProjectReference Include="..\MES.Service\MES.Service.csproj"/> </ItemGroup> </Project> MESApplication/Startup.cs
@@ -1,10 +1,10 @@ using MES.Service.Dto.@base; using System.Reflection; using MES.Service.Dto.@base; using MES.Service.util; using Microsoft.OpenApi.Models; using Newtonsoft.Json; using Newtonsoft.Json.Serialization; using Swashbuckle.AspNetCore.SwaggerUI; using System.Reflection; namespace MESApplication; @@ -36,7 +36,8 @@ c.SwaggerDoc("v1", new OpenApiInfo { Title = "MESApplication.Api", Version = "v1" }); var xmlFile = $"{Assembly.GetExecutingAssembly().GetName().Name}.xml"; var xmlFile = $"{Assembly.GetExecutingAssembly().GetName().Name}.xml"; var xmlPath = Path.Combine(AppContext.BaseDirectory, xmlFile); c.IncludeXmlComments(xmlPath, true); }); @@ -72,11 +73,15 @@ }); #region æ¥å£è¡å¨è¿æ»¤å¨ services.AddControllers(options => { services.AddControllers(options => { options.Filters.Add(new ActionFilter()); }); var serviceProvider = services.BuildServiceProvider(); ActionFilter.LoggerError = serviceProvider.GetRequiredService<ILogger<ActionFilter>>(); ActionFilter.LoggerError = serviceProvider.GetRequiredService<ILogger<ActionFilter>>(); #endregion } @@ -108,6 +113,5 @@ ////////////////////////// /////////////////////////// } }
