MES.Service/Dto/service/InventoryItem.cs
@@ -16,4 +16,12 @@ [SugarColumn(ColumnName = "QTY")] public decimal Qty { get; set; } // ä½¿ç¨ decimal æ¥è¡¨ç¤ºæ°é [SugarColumn(ColumnName = "sections_code")] public string SectionsCode { get; set; } [SugarColumn(ColumnName = "erp_item_no")] public string ErpItemNo { get; set; } [SugarColumn(ColumnName = "flist")] public string Flist { get; set; } } MES.Service/Dto/service/WarehouseQuery.cs
@@ -19,4 +19,8 @@ public string? Type { get; set; } public string? DepotCode { get; set; } public string? SuppNo { get; set; } public string Factory { get; set; } public string Company { get; set; } } MES.Service/Modes/MesInvBusiness2.cs
@@ -1,194 +1,227 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; namespace MES.Service.Modes using SqlSugar; namespace MES.Service.Modes; /// <summary> /// åºå交æè®°å½è¡¨ /// </summary> [SugarTable("MES_INV_BUSINESS2")] public class MesInvBusiness2 { /// <summary> /// åºå交æè®°å½è¡¨ ///</summary> [SugarTable("MES_INV_BUSINESS2")] public class MesInvBusiness2 { /// <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" )] public decimal? Status { get; set; } /// <summary> /// åæ®ç±»åID ///</summary> [SugarColumn(ColumnName="BILL_TYPE_ID" )] public decimal? BillTypeId { get; set; } /// <summary> /// äºå¡ç±»åç¼ç ///</summary> [SugarColumn(ColumnName="TRANSACTION_CODE" )] public string TransactionCode { get; set; } /// <summary> /// 交æç±»å|1-å ¥åº0-转åº-1åºåº ///</summary> [SugarColumn(ColumnName="BUSINESS_TYPE" )] public decimal? BusinessType { get; set; } /// <summary> /// åæ®ID ///</summary> [SugarColumn(ColumnName="BILL_ID" )] public decimal? BillId { get; set; } /// <summary> /// åæ®ç¼ç ///</summary> [SugarColumn(ColumnName="BILL_NO" )] public string BillNo { get; set; } /// <summary> /// ç产订åå· ///</summary> [SugarColumn(ColumnName="TASK_NO" )] public string TaskNo { get; set; } /// <summary> /// 客æ·ç¼å· ///</summary> [SugarColumn(ColumnName="CUSTOMER_NO" )] public string CustomerNo { get; set; } /// <summary> /// åæ®è¡ID ///</summary> [SugarColumn(ColumnName="BILL_LINE_ID" )] public decimal? BillLineId { get; set; } /// <summary> /// ç©ææ¡ç ///</summary> [SugarColumn(ColumnName="ITEM_BARCODE" )] public string ItemBarcode { get; set; } /// <summary> /// æ¬å¸ç©æç¼ç ///</summary> [SugarColumn(ColumnName="ITEM_NO" )] public string ItemNo { get; set; } /// <summary> /// 客æ·ç©æç¼ç ///</summary> [SugarColumn(ColumnName="C_ITEM_CODE" )] public string CItemCode { get; set; } /// <summary> /// å家æ¹æ¬¡ ///</summary> [SugarColumn(ColumnName="LOT_NO" )] public string LotNo { get; set; } /// <summary> /// æ¯å¦ç¯ä¿(0:å¦,1:æ¯) ///</summary> [SugarColumn(ColumnName="EP_FLAG" )] public short? EpFlag { get; set; } /// <summary> /// æ°é ///</summary> [SugarColumn(ColumnName="QUANTITY" )] public decimal? Quantity { get; set; } /// <summary> /// æºååºCODE ///</summary> [SugarColumn(ColumnName="FROM_INV_DEPOTS_CODE" )] public string FromInvDepotsCode { get; set; } /// <summary> /// æºè´§ä½CODE ///</summary> [SugarColumn(ColumnName="FROM_INV_DEPOT_SECTIONS_CODE" )] public string FromInvDepotSectionsCode { get; set; } /// <summary> /// ç®çååºCODE ///</summary> [SugarColumn(ColumnName="TO_INV_DEPOTS_CODE" )] public string ToInvDepotsCode { get; set; } /// <summary> /// ç®çè´§ä½CODE ///</summary> [SugarColumn(ColumnName="TO_INV_DEPOT_SECTIONS_CODE" )] public string ToInvDepotSectionsCode { get; set; } /// <summary> /// 交æå¼å¸¸ä¿¡æ¯ ///</summary> [SugarColumn(ColumnName="DESCRIPTION" )] public string Description { get; set; } /// <summary> /// å建人 ///</summary> [SugarColumn(ColumnName="CREATE_BY" )] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ ///</summary> [SugarColumn(ColumnName="CREATE_DATE" )] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº ///</summary> [SugarColumn(ColumnName="LASTUPDATE_BY" )] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ ///</summary> [SugarColumn(ColumnName="LASTUPDATE_DATE" )] public DateTime? LastupdateDate { get; set; } /// <summary> /// è¶ æç»è®¡æ è¯ ///</summary> [SugarColumn(ColumnName="ULLAGE_STAT_FLAG" )] public short? UllageStatFlag { get; set; } /// <summary> /// ååç¼ç ///</summary> [SugarColumn(ColumnName="FACTORY" )] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç ///</summary> [SugarColumn(ColumnName="COMPANY" )] public string Company { get; set; } /// <summary> /// ç®±å·æ¡ç ///</summary> [SugarColumn(ColumnName="ITEM_BARCODE2" )] public string ItemBarcode2 { get; set; } /// <summary> /// å¡æ¿æ¡ç ///</summary> [SugarColumn(ColumnName="ITEM_BARCODE3" )] public string ItemBarcode3 { get; set; } /// <summary> /// ä»»å¡åå· ///</summary> [SugarColumn(ColumnName="WORK_NO" )] public string WorkNo { get; set; } /// <summary> /// ä»»å¡åè¡å· ///</summary> [SugarColumn(ColumnName="WORK_LINE" )] public decimal? WorkLine { get; set; } /// <summary> /// ä¾åºå ///</summary> [SugarColumn(ColumnName="SUPP_NO" )] public string SuppNo { get; set; } /// <summary> /// ç产线 ///</summary> [SugarColumn(ColumnName="LINE_NO" )] public string LineNo { get; set; } /// <summary> /// éè´è®¢åid ///</summary> [SugarColumn(ColumnName="EBELN_K3ID" )] public decimal? EbelnK3id { get; set; } /// <summary> /// éè´è®¢åè¡id ///</summary> [SugarColumn(ColumnName="LINE_K3ID" )] public decimal? LineK3id { get; set; } } } /// <summary> /// ID(seq_inv_id) /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// ç¶æ|0-æªäº¤æ1-已交æ /// </summary> [SugarColumn(ColumnName = "STATUS")] public decimal? Status { get; set; } /// <summary> /// åæ®ç±»åID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } /// <summary> /// äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSACTION_CODE")] public string TransactionCode { get; set; } /// <summary> /// 交æç±»å|1-å ¥åº0-转åº-1åºåº /// </summary> [SugarColumn(ColumnName = "BUSINESS_TYPE")] public decimal? BusinessType { get; set; } /// <summary> /// åæ®ID /// </summary> [SugarColumn(ColumnName = "BILL_ID")] public decimal? BillId { get; set; } /// <summary> /// åæ®ç¼ç /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// ç产订åå· /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// 客æ·ç¼å· /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NO")] public string CustomerNo { get; set; } /// <summary> /// åæ®è¡ID /// </summary> [SugarColumn(ColumnName = "BILL_LINE_ID")] public decimal? BillLineId { get; set; } /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// æ¬å¸ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// 客æ·ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } /// <summary> /// å家æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ¯å¦ç¯ä¿(0:å¦,1:æ¯) /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } /// <summary> /// æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// æºååºCODE /// </summary> [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")] public string FromInvDepotsCode { get; set; } /// <summary> /// æºè´§ä½CODE /// </summary> [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")] public string FromInvDepotSectionsCode { get; set; } /// <summary> /// ç®çååºCODE /// </summary> [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")] public string ToInvDepotsCode { get; set; } /// <summary> /// ç®çè´§ä½CODE /// </summary> [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")] public string ToInvDepotSectionsCode { get; set; } /// <summary> /// 交æå¼å¸¸ä¿¡æ¯ /// </summary> [SugarColumn(ColumnName = "DESCRIPTION")] public string Description { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// è¶ æç»è®¡æ è¯ /// </summary> [SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")] public short? UllageStatFlag { get; set; } /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// ç®±å·æ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE2")] public string ItemBarcode2 { get; set; } /// <summary> /// å¡æ¿æ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE3")] public string ItemBarcode3 { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// ç产线 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } /// <summary> /// éè´è®¢åid /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] public decimal? EbelnK3id { get; set; } /// <summary> /// éè´è®¢åè¡id /// </summary> [SugarColumn(ColumnName = "LINE_K3ID")] public decimal? LineK3id { get; set; } } 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,453 +8,453 @@ [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> /// æ¥å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "WORK_FLGTIME")] /// <summary> /// æ¥å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "WORK_FLGTIME")] public string WorkFlgtime { get; set; } } MES.Service/Modes/MesInvItemInCDetails.cs
@@ -11,7 +11,8 @@ /// <summary> /// SEQ_OUT /// </summary> [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_INV_ID", IsPrimaryKey = true)] [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> MES.Service/Modes/MesInvItemInCItems.cs
@@ -8,141 +8,141 @@ [SugarTable("MES_INV_ITEM_IN_C_ITEMS")] public class MesInvItemInCItems { /// <summary> /// SEQ_OUT /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// SEQ_OUT /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// å ¥åºåid /// </summary> [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] /// <summary> /// å ¥åºåid /// </summary> [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] public decimal ItemInId { get; set; } /// <summary> /// éªæ¶æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] /// <summary> /// éªæ¶æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] /// <summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// è´§ä½ç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] /// <summary> /// è´§ä½ç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] public string DepotSectionCode { get; set; } /// <summary> /// ç¹è®°äºé¡¹ /// </summary> [SugarColumn(ColumnName = "REMARK")] /// <summary> /// ç¹è®°äºé¡¹ /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// ç©æç®ç§° /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] /// <summary> /// ç©æç®ç§° /// </summary> [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "UNIT")] /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } /// <summary> /// éè´è®¢å /// </summary> [SugarColumn(ColumnName = "EBELN")] /// <summary> /// éè´è®¢å /// </summary> [SugarColumn(ColumnName = "EBELN")] public string Ebeln { get; set; } /// <summary> /// å ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// å ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "EBELN_LINE_NO")] /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "EBELN_LINE_NO")] public decimal? EbelnLineNo { get; set; } /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "CBILL_NO")] /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "CBILL_NO")] public string CbillNo { get; set; } /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] /// <summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } } MES.Service/Modes/MesInvItemMoves.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,178 @@ using SqlSugar; namespace MES.Service.Modes; /// <summary> /// ç©æ移åºä¸»è¡¨ /// </summary> [SugarTable("MES_INV_ITEM_MOVES")] public class MesInvItemMoves { /// <summary> /// SEQ_INV_ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// 移åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// ç§»å ¥ååºid /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_ID")] public decimal? InvDepotsId { get; set; } /// <summary> /// ç§»å ¥è´§ä½id /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] public decimal? InvDepotSectionsId { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// ç¶æ|0-å¶å1-è¿è´¦ /// </summary> [SugarColumn(ColumnName = "STATUS")] public decimal? Status { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// åæ®ç±»åID /// </summary> [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } /// <summary> /// äºå¡ç±»åID /// </summary> [SugarColumn(ColumnName = "TRANSACTION_ID")] public decimal? TransactionId { get; set; } /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "CHECKUSER")] public string Checkuser { get; set; } /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "CHECKDATE")] public DateTime? Checkdate { get; set; } /// <summary> /// ç§»å ¥ååºcode /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] public string InvDepotsCode { get; set; } /// <summary> /// ç§»å ¥è´§ä½code /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] public string InvDepotSectionsCode { get; set; } /// <summary> /// äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "TRANSACTION_NO")] public decimal? TransactionNo { get; set; } /// <summary> /// 移åºååºcode /// </summary> [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] public string FromDepotsCode { get; set; } /// <summary> /// å·¥åç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY_CODE")] public string FactoryCode { get; set; } /// <summary> /// SAPè¿ååæ® /// </summary> [SugarColumn(ColumnName = "SAPNO")] public string Sapno { get; set; } /// <summary> /// å·²ååSAP /// </summary> [SugarColumn(ColumnName = "SAPSTATUS")] public short? Sapstatus { get; set; } /// <summary> /// SAPè¿å年份 /// </summary> [SugarColumn(ColumnName = "SAPYEAR")] public short? Sapyear { get; set; } /// <summary> /// SAPè¿åä¿¡æ¯ /// </summary> [SugarColumn(ColumnName = "SAPTEXT")] public string Saptext { get; set; } /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// åå®¡æ ¸äºå¡ç±»åç¼ç /// </summary> [SugarColumn(ColumnName = "MTRANSACTION_NO")] public decimal? MtransactionNo { get; set; } /// <summary> /// èªå¨ä¿åå段 /// </summary> [SugarColumn(ColumnName = "ZD_NUM")] public decimal? ZdNum { get; set; } /// <summary> /// æ¯å¦æ¨éERP1-æ¯ï¼2-å¦ /// </summary> [SugarColumn(ColumnName = "TS")] public decimal? Ts { get; set; } } MES.Service/Modes/MesInvItemMovesCDetails.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,231 @@ using SqlSugar; namespace MES.Service.Modes; /// <summary> /// ç©æ移åºæ¡ç æç»ä»è¡¨ /// </summary> [SugarTable("MES_INV_ITEM_MOVES_C_DETAILS")] public class MesInvItemMovesCDetails { /// <summary> /// seq_inv_id /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "ITEM_MOVE_ID")] public decimal? ItemMoveId { get; set; } /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// 客æ·ç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } /// <summary> /// ä¿¡åç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// å家æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ°éï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// åºåºæ¹å¼(1:ææ¡ç ,0:æ æ¡ç ) /// </summary> [SugarColumn(ColumnName = "BARCODE_FLAG")] public short? BarcodeFlag { get; set; } /// <summary> /// ç¯ä¿æ å¿ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æåæ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æåæ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// ååºid /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_ID")] public decimal? InvDepotsId { get; set; } /// <summary> /// è´§ä½id /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")] public decimal? InvDepotSectionsId { get; set; } /// <summary> /// 客æ·ç¼ç /// </summary> [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// ä»»å¡ä»¤å· /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// 移åºä»åºç¼å· /// </summary> [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] public string FromDepotsCode { get; set; } /// <summary> /// 移åºåºä½ç¼å· /// </summary> [SugarColumn(ColumnName = "FROM_DEPOT_SECTIONS_CODE")] public string FromDepotSectionsCode { get; set; } /// <summary> /// æ¡ç å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// ååç¼ç /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å ¬å¸ä»£ç /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// ç®±å· /// </summary> [SugarColumn(ColumnName = "BOX_NO")] public string BoxNo { get; set; } /// <summary> /// å¡æ¿å· /// </summary> [SugarColumn(ColumnName = "KO_NO")] public string KoNo { get; set; } /// <summary> /// ç§»å ¥ä»åºç¼å· /// </summary> [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] public string InvDepotsCode { get; set; } /// <summary> /// ç§»å ¥åºä½ç¼å· /// </summary> [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] public string InvDepotSectionsCode { get; set; } /// <summary> /// è´¨æ£ç»æ /// </summary> [SugarColumn(ColumnName = "IQC_STATUS")] public string IqcStatus { get; set; } /// <summary> /// å°è½¦ç¼å· /// </summary> [SugarColumn(ColumnName = "FCAR")] public string Fcar { get; set; } /// <summary> /// å ¥åºæ¥æ /// </summary> [SugarColumn(ColumnName = "INDEP_DATE")] public DateTime? IndepDate { get; set; } /// <summary> /// å»ç»æ交éæ£ï¼0ï¼å»ç»æªæ交éæ£ï¼1ï¼å»ç»å¹¶æ交éæ£ /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT")] public short? VisableSubmit { get; set; } /// <summary> /// æ交éæ£äºº /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")] public string VisableSubmitBy { get; set; } /// <summary> /// æ交éæ£æ¶é´ /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")] public DateTime? VisableSubmitDate { get; set; } /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ä¾åºåç¼å· /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// è°å ¥ /// </summary> [SugarColumn(ColumnName = "MOVE_OK")] public decimal? MoveOk { get; set; } } MES.Service/Modes/MesInvItemStocks.cs
@@ -9,7 +9,7 @@ public class MesInvItemStocks { /// <summary> /// SEQ_ME_ID /// SEQ_ME_ID /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ME_ID", IsPrimaryKey = true)] MES.Service/Modes/MesQaItemsDetect01.cs
@@ -8,324 +8,324 @@ [SugarTable("MES_QA_ITEMS_DETECT_01")] public class MesQaItemsDetect01 { /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] /// <summary> /// æ£éªåå· /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } /// <summary> /// æ£éªäººå /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] /// <summary> /// æ£éªäººå /// </summary> [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// æ¥ææ°é /// </summary> [SugarColumn(ColumnName = "FBATCH_QTY")] /// <summary> /// æ¥ææ°é /// </summary> [SugarColumn(ColumnName = "FBATCH_QTY")] public decimal? FbatchQty { get; set; } /// <summary> /// å¤å®ç»æ /// </summary> [SugarColumn(ColumnName = "FRECE_QTY")] /// <summary> /// å¤å®ç»æ /// </summary> [SugarColumn(ColumnName = "FRECE_QTY")] public string FreceQty { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FNG_DESC")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FNG_DESC")] public string FngDesc { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FREVIEW")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FREVIEW")] public string Freview { get; set; } /// <summary> /// æ£éªæ°´å /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] /// <summary> /// æ£éªæ°´å /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } /// <summary> /// ææ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] /// <summary> /// ææ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } /// <summary> /// æ½æ£æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] /// <summary> /// æ½æ£æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QTY")] public string CheckQty { get; set; } /// <summary> /// æ¹æ¬¡å· --å°è´§åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO")] /// <summary> /// æ¹æ¬¡å· --å°è´§åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ¯å¦æ¨é /// </summary> [SugarColumn(ColumnName = "FMOVE")] /// <summary> /// æ¯å¦æ¨é /// </summary> [SugarColumn(ColumnName = "FMOVE")] public string Fmove { get; set; } /// <summary> /// æ¯å¦å¤ç /// </summary> [SugarColumn(ColumnName = "FHANDLE")] /// <summary> /// æ¯å¦å¤ç /// </summary> [SugarColumn(ColumnName = "FHANDLE")] public string Fhandle { get; set; } /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] /// <summary> /// å建人 /// </summary> [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } /// <summary> /// å建æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// å建æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } /// <summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] /// <summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æ´æ°æ¥æ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] /// <summary> /// æ´æ°æ¥æ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } /// <summary> /// æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG")] /// <summary> /// æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG")] public decimal? Modify1Flag { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY")] public string Modify1By { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE")] /// <summary> /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE")] public DateTime? Modify1Date { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// XRFæµè¯æ¥åç¼å· /// </summary> [SugarColumn(ColumnName = "FCHECK_REPNO")] /// <summary> /// XRFæµè¯æ¥åç¼å· /// </summary> [SugarColumn(ColumnName = "FCHECK_REPNO")] public string FcheckRepno { get; set; } /// <summary> /// 第ä¸æ¹æ¥å /// </summary> [SugarColumn(ColumnName = "FTHIRD_REP")] /// <summary> /// 第ä¸æ¹æ¥å /// </summary> [SugarColumn(ColumnName = "FTHIRD_REP")] public string FthirdRep { get; set; } /// <summary> /// æ¯å¦ä½åº /// </summary> [SugarColumn(ColumnName = "FCANCEL")] /// <summary> /// æ¯å¦ä½åº /// </summary> [SugarColumn(ColumnName = "FCANCEL")] public decimal? Fcancel { get; set; } /// <summary> /// æ交æ è¯ /// </summary> [SugarColumn(ColumnName = "FSUBMIT")] /// <summary> /// æ交æ è¯ /// </summary> [SugarColumn(ColumnName = "FSUBMIT")] public decimal? Fsubmit { get; set; } /// <summary> /// æ£éªä¾æ® /// </summary> [SugarColumn(ColumnName = "FCHECK_ACCORD")] /// <summary> /// æ£éªä¾æ® /// </summary> [SugarColumn(ColumnName = "FCHECK_ACCORD")] public string FcheckAccord { get; set; } /// <summary> /// ç±»å(0 æ¥æ 1 å¨åº) /// </summary> [SugarColumn(ColumnName = "FTYPE")] /// <summary> /// ç±»å(0 æ¥æ 1 å¨åº) /// </summary> [SugarColumn(ColumnName = "FTYPE")] public short? Ftype { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "ITEM_UNIT")] /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "ITEM_UNIT")] public string ItemUnit { get; set; } /// <summary> /// åºè´§æ¥æ /// </summary> [SugarColumn(ColumnName = "OUT_DATE")] /// <summary> /// åºè´§æ¥æ /// </summary> [SugarColumn(ColumnName = "OUT_DATE")] public string OutDate { get; set; } /// <summary> /// æ¯å¦å æ£ /// </summary> [SugarColumn(ColumnName = "FEXEMPTION")] /// <summary> /// æ¯å¦å æ£ /// </summary> [SugarColumn(ColumnName = "FEXEMPTION")] public decimal? Fexemption { get; set; } /// <summary> /// æ¡£ä½æ å /// </summary> [SugarColumn(ColumnName = "FGEAR_STAND")] /// <summary> /// æ¡£ä½æ å /// </summary> [SugarColumn(ColumnName = "FGEAR_STAND")] public string FgearStand { get; set; } /// <summary> /// ä¸è¯å¤çæ¹æ³ /// </summary> [SugarColumn(ColumnName = "FNG_HANDLE")] /// <summary> /// ä¸è¯å¤çæ¹æ³ /// </summary> [SugarColumn(ColumnName = "FNG_HANDLE")] public string FngHandle { get; set; } /// <summary> /// 管çç¼å· /// </summary> [SugarColumn(ColumnName = "FMANAGE_NO")] /// <summary> /// 管çç¼å· /// </summary> [SugarColumn(ColumnName = "FMANAGE_NO")] public string FmanageNo { get; set; } /// <summary> /// 转æ¢æ°é /// </summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] /// <summary> /// 转æ¢æ°é /// </summary> [SugarColumn(ColumnName = "FCOVERT_QTY")] public string FcovertQty { get; set; } /// <summary> /// çæ¬ /// </summary> [SugarColumn(ColumnName = "FVERSION")] /// <summary> /// çæ¬ /// </summary> [SugarColumn(ColumnName = "FVERSION")] public decimal? Fversion { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FSECOND_RESU")] /// <summary> /// </summary> [SugarColumn(ColumnName = "FSECOND_RESU")] public string FsecondResu { get; set; } /// <summary> /// æ大æ½æ£æ° /// </summary> [SugarColumn(ColumnName = "MAX_CHECK_QTY")] /// <summary> /// æ大æ½æ£æ° /// </summary> [SugarColumn(ColumnName = "MAX_CHECK_QTY")] public decimal? MaxCheckQty { get; set; } /// <summary> /// ç¹å®ä¿®æ¹æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG1")] /// <summary> /// ç¹å®ä¿®æ¹æ¯å¦å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "MODIFY1_FLAG1")] public decimal? Modify1Flag1 { get; set; } /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY1")] /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "MODIFY1_BY1")] public string Modify1By1 { get; set; } /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸æ¶é´ /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE1")] /// <summary> /// ç¹å®ä¿®æ¹å®¡æ ¸æ¶é´ /// </summary> [SugarColumn(ColumnName = "MODIFY1_DATE1")] public DateTime? Modify1Date1 { get; set; } /// <summary> /// å°æ¹æ¬¡å· /// </summary> [SugarColumn(ColumnName = "LOT_NO1")] /// <summary> /// å°æ¹æ¬¡å· /// </summary> [SugarColumn(ColumnName = "LOT_NO1")] public string LotNo1 { get; set; } /// <summary> /// éè´åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO2")] /// <summary> /// éè´åå· /// </summary> [SugarColumn(ColumnName = "LOT_NO2")] public string LotNo2 { get; set; } /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// å°è´§æ¶é´ /// </summary> [SugarColumn(ColumnName = "DHA018")] /// <summary> /// å°è´§æ¶é´ /// </summary> [SugarColumn(ColumnName = "DHA018")] public string Dha018 { get; set; } /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "DHB002")] /// <summary> /// è¡å· /// </summary> [SugarColumn(ColumnName = "DHB002")] public decimal? Dhb002 { get; set; } /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "DHB001")] /// <summary> /// å°è´§åå· /// </summary> [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "LIFNR")] /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "LIFNR")] public string Lifnr { get; set; } /// <summary> /// éææ¹å¼ /// </summary> [SugarColumn(ColumnName = "FMRMODE")] /// <summary> /// éææ¹å¼ /// </summary> [SugarColumn(ColumnName = "FMRMODE")] public string Fmrmode { get; set; } } MES.Service/Modes/MesQaItemsDetectDetail5.cs
@@ -1,154 +1,174 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; namespace MES.Service.Modes using SqlSugar; namespace MES.Service.Modes; /// <summary> /// æ¥ææ£éªä»è¡¨ /// </summary> [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] public class MesQaItemsDetectDetail5 { /// <summary> /// æ¥ææ£éªä»è¡¨ ///</summary> [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] public class MesQaItemsDetectDetail5 { /// <summary> /// ///</summary> [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )] public decimal Id { get; set; } /// <summary> /// æ åå¼ç±»å ///</summary> [SugarColumn(ColumnName="FTEXT_TYPE" )] public string FtextType { get; set; } /// <summary> /// æ åå¼ ///</summary> [SugarColumn(ColumnName="FSTAND" )] public decimal? Fstand { get; set; } /// <summary> /// ä¸å ¬å·® ///</summary> [SugarColumn(ColumnName="FUP_ALLOW" )] public string FupAllow { get; set; } /// <summary> /// ä¸å ¬å·® ///</summary> [SugarColumn(ColumnName="FDOWN_ALLOW" )] public string FdownAllow { get; set; } /// <summary> /// æ£éªæ°´å ///</summary> [SugarColumn(ColumnName="SAMPLE_SIZE_NO" )] public string SampleSizeNo { get; set; } /// <summary> /// æ£éªæ°´å¹³ ///</summary> [SugarColumn(ColumnName="FCHECK_LEVEL" )] public string FcheckLevel { get; set; } /// <summary> /// ææ¶æ°´å¹³ ///</summary> [SugarColumn(ColumnName="FAC_LEVEL" )] public string FacLevel { get; set; } /// <summary> /// æ£éªé¡¹ç® ///</summary> [SugarColumn(ColumnName="FCHECK_ITEM" )] public string FcheckItem { get; set; } /// <summary> /// è§æ ¼è¦æ± ///</summary> [SugarColumn(ColumnName="FSPEC_REQU" )] public string FspecRequ { get; set; } /// <summary> /// æ½æ£æ°é ///</summary> [SugarColumn(ColumnName="CHECK_QYT" )] public decimal? CheckQyt { get; set; } /// <summary> /// æ£éªç»æ ///</summary> [SugarColumn(ColumnName="FCHECK_RESU" )] public string FcheckResu { get; set; } /// <summary> /// ACæ°é ///</summary> [SugarColumn(ColumnName="FAC_QTY" )] public decimal? FacQty { get; set; } /// <summary> /// REæ°é ///</summary> [SugarColumn(ColumnName="FRE_QTY" )] public decimal? FreQty { get; set; } /// <summary> /// ä¸åæ ¼æ° ///</summary> [SugarColumn(ColumnName="FNG_QTY" )] public decimal? FngQty { get; set; } /// <summary> /// ä¸è¯ç ///</summary> [SugarColumn(ColumnName="FNG_RATE" )] public decimal? FngRate { get; set; } /// <summary> /// å·²å½å ¥æ°é ///</summary> [SugarColumn(ColumnName="FENTER_QTY" )] public decimal? FenterQty { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName="RELEASE_NO" )] public string ReleaseNo { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName="COMPANY" )] public string Company { get; set; } /// <summary> /// ///</summary> [SugarColumn(ColumnName="FACTORY" )] public string Factory { get; set; } /// <summary> /// æ£éªé¡¹ç®æè¿° ///</summary> [SugarColumn(ColumnName="FCHECK_ITEM_DESC" )] public string FcheckItemDesc { get; set; } /// <summary> /// å·¥åºå· ///</summary> [SugarColumn(ColumnName="PROC_NO" )] public string ProcNo { get; set; } /// <summary> /// å·¥ä½ä¸å¿ç¼ç ///</summary> [SugarColumn(ColumnName="WORKSHOP_CENTER_CODE" )] public string WorkshopCenterCode { get; set; } /// <summary> /// åä½ ///</summary> [SugarColumn(ColumnName="FUNIT" )] public string Funit { get; set; } /// <summary> /// ç¹å®ä¿®æ¹ ///</summary> [SugarColumn(ColumnName="GIVEN_MODIFY" )] public short? GivenModify { get; set; } /// <summary> /// æ£éªå·¥å · ///</summary> [SugarColumn(ColumnName="FCHECK_TOOL" )] public string FcheckTool { get; set; } /// <summary> /// æ´æ°äºº ///</summary> [SugarColumn(ColumnName="LASTUPDATE_BY" )] public string LastupdateBy { get; set; } /// <summary> /// æ´æ°æ¶é´ ///</summary> [SugarColumn(ColumnName="LASTUPDATE_DATE" )] public DateTime? LastupdateDate { get; set; } } } /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// æ åå¼ç±»å /// </summary> [SugarColumn(ColumnName = "FTEXT_TYPE")] public string FtextType { get; set; } /// <summary> /// æ åå¼ /// </summary> [SugarColumn(ColumnName = "FSTAND")] public decimal? Fstand { get; set; } /// <summary> /// ä¸å ¬å·® /// </summary> [SugarColumn(ColumnName = "FUP_ALLOW")] public string FupAllow { get; set; } /// <summary> /// ä¸å ¬å·® /// </summary> [SugarColumn(ColumnName = "FDOWN_ALLOW")] public string FdownAllow { get; set; } /// <summary> /// æ£éªæ°´å /// </summary> [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } /// <summary> /// æ£éªæ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } /// <summary> /// ææ¶æ°´å¹³ /// </summary> [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } /// <summary> /// æ£éªé¡¹ç® /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM")] public string FcheckItem { get; set; } /// <summary> /// è§æ ¼è¦æ± /// </summary> [SugarColumn(ColumnName = "FSPEC_REQU")] public string FspecRequ { get; set; } /// <summary> /// æ½æ£æ°é /// </summary> [SugarColumn(ColumnName = "CHECK_QYT")] public decimal? CheckQyt { get; set; } /// <summary> /// æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } /// <summary> /// ACæ°é /// </summary> [SugarColumn(ColumnName = "FAC_QTY")] public decimal? FacQty { get; set; } /// <summary> /// REæ°é /// </summary> [SugarColumn(ColumnName = "FRE_QTY")] public decimal? FreQty { get; set; } /// <summary> /// ä¸åæ ¼æ° /// </summary> [SugarColumn(ColumnName = "FNG_QTY")] public decimal? FngQty { get; set; } /// <summary> /// ä¸è¯ç /// </summary> [SugarColumn(ColumnName = "FNG_RATE")] public decimal? FngRate { get; set; } /// <summary> /// å·²å½å ¥æ°é /// </summary> [SugarColumn(ColumnName = "FENTER_QTY")] public decimal? FenterQty { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// æ£éªé¡¹ç®æè¿° /// </summary> [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")] public string FcheckItemDesc { get; set; } /// <summary> /// å·¥åºå· /// </summary> [SugarColumn(ColumnName = "PROC_NO")] public string ProcNo { get; set; } /// <summary> /// å·¥ä½ä¸å¿ç¼ç /// </summary> [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] public string WorkshopCenterCode { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "FUNIT")] public string Funit { get; set; } /// <summary> /// ç¹å®ä¿®æ¹ /// </summary> [SugarColumn(ColumnName = "GIVEN_MODIFY")] public short? GivenModify { get; set; } /// <summary> /// æ£éªå·¥å · /// </summary> [SugarColumn(ColumnName = "FCHECK_TOOL")] public string FcheckTool { get; set; } /// <summary> /// æ´æ°äºº /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } /// <summary> /// æ´æ°æ¶é´ /// </summary> [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } } MES.Service/Modes/Purdhb.cs
@@ -8,267 +8,267 @@ [SugarTable("PURDHB")] public class Purdhb { /// <summary> /// åå· /// </summary> [SugarColumn(ColumnName = "DHB001")] /// <summary> /// åå· /// </summary> [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } /// <summary> /// åºå· /// </summary> [SugarColumn(ColumnName = "DHB002")] /// <summary> /// åºå· /// </summary> [SugarColumn(ColumnName = "DHB002")] public string Dhb002 { get; set; } /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "DHB003")] /// <summary> /// ç©æç¼ç /// </summary> [SugarColumn(ColumnName = "DHB003")] public string Dhb003 { get; set; } /// <summary> /// ç©æå称 /// </summary> [SugarColumn(ColumnName = "DHB004")] /// <summary> /// ç©æå称 /// </summary> [SugarColumn(ColumnName = "DHB004")] public string Dhb004 { get; set; } /// <summary> /// ç©æè§æ ¼ /// </summary> [SugarColumn(ColumnName = "DHB005")] /// <summary> /// ç©æè§æ ¼ /// </summary> [SugarColumn(ColumnName = "DHB005")] public string Dhb005 { get; set; } /// <summary> /// 交货æ°é /// </summary> [SugarColumn(ColumnName = "DHB006")] /// <summary> /// 交货æ°é /// </summary> [SugarColumn(ColumnName = "DHB006")] public decimal? Dhb006 { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "DHB007")] /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "DHB007")] public string Dhb007 { get; set; } /// <summary> /// ä»åº /// </summary> [SugarColumn(ColumnName = "DHB008")] /// <summary> /// ä»åº /// </summary> [SugarColumn(ColumnName = "DHB008")] public string Dhb008 { get; set; } /// <summary> /// ä»åºå称 /// </summary> [SugarColumn(ColumnName = "DHB009")] /// <summary> /// ä»åºå称 /// </summary> [SugarColumn(ColumnName = "DHB009")] public string Dhb009 { get; set; } /// <summary> /// æ¹å· /// </summary> [SugarColumn(ColumnName = "DHB010")] /// <summary> /// æ¹å· /// </summary> [SugarColumn(ColumnName = "DHB010")] public string Dhb010 { get; set; } /// <summary> /// æ¥æºåå· /// </summary> [SugarColumn(ColumnName = "DHB011")] /// <summary> /// æ¥æºåå· /// </summary> [SugarColumn(ColumnName = "DHB011")] public string Dhb011 { get; set; } /// <summary> /// æ¥æºåºå· /// </summary> [SugarColumn(ColumnName = "DHB012")] /// <summary> /// æ¥æºåºå· /// </summary> [SugarColumn(ColumnName = "DHB012")] public decimal? Dhb012 { get; set; } /// <summary> /// æ¸ ç¹æ°é /// </summary> [SugarColumn(ColumnName = "DHB013")] /// <summary> /// æ¸ ç¹æ°é /// </summary> [SugarColumn(ColumnName = "DHB013")] public decimal? Dhb013 { get; set; } /// <summary> /// å°åæ¥æ /// </summary> [SugarColumn(ColumnName = "DHB014")] /// <summary> /// å°åæ¥æ /// </summary> [SugarColumn(ColumnName = "DHB014")] public string Dhb014 { get; set; } /// <summary> /// éªæ¶æ°é /// </summary> [SugarColumn(ColumnName = "DHB015")] /// <summary> /// éªæ¶æ°é /// </summary> [SugarColumn(ColumnName = "DHB015")] public decimal? Dhb015 { get; set; } /// <summary> /// éªéæ°é /// </summary> [SugarColumn(ColumnName = "DHB016")] /// <summary> /// éªéæ°é /// </summary> [SugarColumn(ColumnName = "DHB016")] public decimal? Dhb016 { get; set; } /// <summary> /// è¿è´§åä»· /// </summary> [SugarColumn(ColumnName = "DHB017")] /// <summary> /// è¿è´§åä»· /// </summary> [SugarColumn(ColumnName = "DHB017")] public decimal? Dhb017 { get; set; } /// <summary> /// è¿è´§éé¢ /// </summary> [SugarColumn(ColumnName = "DHB018")] /// <summary> /// è¿è´§éé¢ /// </summary> [SugarColumn(ColumnName = "DHB018")] public decimal? Dhb018 { get; set; } /// <summary> /// 客æ·æå· /// </summary> [SugarColumn(ColumnName = "DHB019")] /// <summary> /// 客æ·æå· /// </summary> [SugarColumn(ColumnName = "DHB019")] public string Dhb019 { get; set; } /// <summary> /// é¨é¨ç¼å· /// </summary> [SugarColumn(ColumnName = "DHB020")] /// <summary> /// é¨é¨ç¼å· /// </summary> [SugarColumn(ColumnName = "DHB020")] public string Dhb020 { get; set; } /// <summary> /// èµ åæ° /// </summary> [SugarColumn(ColumnName = "DHB021")] /// <summary> /// èµ åæ° /// </summary> [SugarColumn(ColumnName = "DHB021")] public decimal? Dhb021 { get; set; } /// <summary> /// æ´æ°ERP /// </summary> [SugarColumn(ColumnName = "DHB022")] /// <summary> /// æ´æ°ERP /// </summary> [SugarColumn(ColumnName = "DHB022")] public string Dhb022 { get; set; } /// <summary> /// æ£éªç¶æ /// </summary> [SugarColumn(ColumnName = "DHB023")] /// <summary> /// æ£éªç¶æ /// </summary> [SugarColumn(ColumnName = "DHB023")] public string Dhb023 { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "DHB024")] /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "DHB024")] public string Dhb024 { get; set; } /// <summary> /// å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "AUDITING")] /// <summary> /// å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "AUDITING")] public decimal? Auditing { get; set; } /// <summary> /// ERPéè´åå·ID /// </summary> [SugarColumn(ColumnName = "DHB026")] /// <summary> /// ERPéè´åå·ID /// </summary> [SugarColumn(ColumnName = "DHB026")] public decimal? Dhb026 { get; set; } /// <summary> /// ERPéè´åºå·ID /// </summary> [SugarColumn(ColumnName = "DHB027")] /// <summary> /// ERPéè´åºå·ID /// </summary> [SugarColumn(ColumnName = "DHB027")] public decimal? Dhb027 { get; set; } /// <summary> /// ERPç©æID /// </summary> [SugarColumn(ColumnName = "DHB028")] /// <summary> /// ERPç©æID /// </summary> [SugarColumn(ColumnName = "DHB028")] public decimal? Dhb028 { get; set; } /// <summary> /// å¾ æ£æ°é /// </summary> [SugarColumn(ColumnName = "DHB029")] /// <summary> /// å¾ æ£æ°é /// </summary> [SugarColumn(ColumnName = "DHB029")] public decimal? Dhb029 { get; set; } /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "DHB030")] /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "DHB030")] public string Dhb030 { get; set; } /// <summary> /// æ£éªå /// </summary> [SugarColumn(ColumnName = "DHB031")] /// <summary> /// æ£éªå /// </summary> [SugarColumn(ColumnName = "DHB031")] public string Dhb031 { get; set; } /// <summary> /// å ¥åºæ°é /// </summary> [SugarColumn(ColumnName = "DHB032")] /// <summary> /// å ¥åºæ°é /// </summary> [SugarColumn(ColumnName = "DHB032")] public decimal? Dhb032 { get; set; } /// <summary> /// å ¥åºäºº /// </summary> [SugarColumn(ColumnName = "DHB033")] /// <summary> /// å ¥åºäºº /// </summary> [SugarColumn(ColumnName = "DHB033")] public string Dhb033 { get; set; } /// <summary> /// å ¥åºæ¶é´ /// </summary> [SugarColumn(ColumnName = "DHB034")] /// <summary> /// å ¥åºæ¶é´ /// </summary> [SugarColumn(ColumnName = "DHB034")] public string Dhb034 { get; set; } /// <summary> /// éè´§æ°é /// </summary> [SugarColumn(ColumnName = "DHB035")] /// <summary> /// éè´§æ°é /// </summary> [SugarColumn(ColumnName = "DHB035")] public decimal? Dhb035 { get; set; } /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "DHB037")] /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "DHB037")] public decimal? Dhb037 { get; set; } /// <summary> /// é货人 /// </summary> [SugarColumn(ColumnName = "DHB036")] /// <summary> /// é货人 /// </summary> [SugarColumn(ColumnName = "DHB036")] public string Dhb036 { get; set; } /// <summary> /// ERPååå½å· /// </summary> [SugarColumn(ColumnName = "DHB038")] /// <summary> /// ERPååå½å· /// </summary> [SugarColumn(ColumnName = "DHB038")] public decimal? Dhb038 { get; set; } /// <summary> /// ERPæºåå ç /// </summary> [SugarColumn(ColumnName = "DHB039")] /// <summary> /// ERPæºåå ç /// </summary> [SugarColumn(ColumnName = "DHB039")] public decimal? Dhb039 { get; set; } /// <summary> /// ERPæºåç±»å /// </summary> [SugarColumn(ColumnName = "DHB040")] /// <summary> /// ERPæºåç±»å /// </summary> [SugarColumn(ColumnName = "DHB040")] public decimal? Dhb040 { get; set; } /// <summary> /// ERP订åå ç /// </summary> [SugarColumn(ColumnName = "DHB041")] /// <summary> /// ERP订åå ç /// </summary> [SugarColumn(ColumnName = "DHB041")] public decimal? Dhb041 { get; set; } /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID")] /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } /// <summary> /// æ¯å¦æ£éªï¼1ä¸ºå·²æ£ /// </summary> [SugarColumn(ColumnName = "ISCHECK")] /// <summary> /// æ¯å¦æ£éªï¼1ä¸ºå·²æ£ /// </summary> [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } /// <summary> /// ä»åº /// </summary> [SugarColumn(ColumnName = "DHB042")] /// <summary> /// ä»åº /// </summary> [SugarColumn(ColumnName = "DHB042")] public string Dhb042 { get; set; } } MES.Service/Modes/Purdka.cs
@@ -8,123 +8,123 @@ [SugarTable("PURDKA")] public class Purdka { /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID")] /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } /// <summary> /// å建人å /// </summary> [SugarColumn(ColumnName = "CREATEUSER")] /// <summary> /// å建人å /// </summary> [SugarColumn(ColumnName = "CREATEUSER")] public string Createuser { get; set; } /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATETIME")] /// <summary> /// å建æ¶é´ /// </summary> [SugarColumn(ColumnName = "CREATETIME")] public string Createtime { get; set; } /// <summary> /// ä¿®æ¹æ¶é´ /// </summary> [SugarColumn(ColumnName = "MODIFYTIME")] /// <summary> /// ä¿®æ¹æ¶é´ /// </summary> [SugarColumn(ColumnName = "MODIFYTIME")] public string Modifytime { get; set; } /// <summary> /// ä¿®æ¹äººå /// </summary> [SugarColumn(ColumnName = "MODIFYUSER")] /// <summary> /// ä¿®æ¹äººå /// </summary> [SugarColumn(ColumnName = "MODIFYUSER")] public string Modifyuser { get; set; } /// <summary> /// å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "AUDITING")] /// <summary> /// å®¡æ ¸ /// </summary> [SugarColumn(ColumnName = "AUDITING")] public string Auditing { get; set; } /// <summary> /// éè´§åå· /// </summary> [SugarColumn(ColumnName = "DKA001")] /// <summary> /// éè´§åå· /// </summary> [SugarColumn(ColumnName = "DKA001")] public string Dka001 { get; set; } /// <summary> /// é货类å /// </summary> [SugarColumn(ColumnName = "DKA002")] /// <summary> /// é货类å /// </summary> [SugarColumn(ColumnName = "DKA002")] public string Dka002 { get; set; } /// <summary> /// éè´§æ¥æ /// </summary> [SugarColumn(ColumnName = "DKA003")] /// <summary> /// éè´§æ¥æ /// </summary> [SugarColumn(ColumnName = "DKA003")] public string Dka003 { get; set; } /// <summary> /// éè´§æ¶é´ /// </summary> [SugarColumn(ColumnName = "DKA004")] /// <summary> /// éè´§æ¶é´ /// </summary> [SugarColumn(ColumnName = "DKA004")] public string Dka004 { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "DKA005")] /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "DKA005")] public string Dka005 { get; set; } /// <summary> /// ä¾åºåå称 /// </summary> [SugarColumn(ColumnName = "DKA006")] /// <summary> /// ä¾åºåå称 /// </summary> [SugarColumn(ColumnName = "DKA006")] public string Dka006 { get; set; } /// <summary> /// é¨é¨ /// </summary> [SugarColumn(ColumnName = "DKA007")] /// <summary> /// é¨é¨ /// </summary> [SugarColumn(ColumnName = "DKA007")] public string Dka007 { get; set; } /// <summary> /// å®¡æ ¸è /// </summary> [SugarColumn(ColumnName = "DKA008")] /// <summary> /// å®¡æ ¸è /// </summary> [SugarColumn(ColumnName = "DKA008")] public string Dka008 { get; set; } /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "DKA009")] /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "DKA009")] public string Dka009 { get; set; } /// <summary> /// éè´§ç¶æï¼0æ空为æªéè´§ï¼1为已éå® /// </summary> [SugarColumn(ColumnName = "DKA010")] /// <summary> /// éè´§ç¶æï¼0æ空为æªéè´§ï¼1为已éå® /// </summary> [SugarColumn(ColumnName = "DKA010")] public string Dka010 { get; set; } /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "ERPID")] /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "ERPID")] public decimal? Erpid { get; set; } /// <summary> /// ä¿ç®¡åç¼ç /// </summary> [SugarColumn(ColumnName = "DKA011")] /// <summary> /// ä¿ç®¡åç¼ç /// </summary> [SugarColumn(ColumnName = "DKA011")] public string Dka011 { get; set; } /// <summary> /// éªæ¶åç¼ç /// </summary> [SugarColumn(ColumnName = "DKA012")] /// <summary> /// éªæ¶åç¼ç /// </summary> [SugarColumn(ColumnName = "DKA012")] public string Dka012 { get; set; } /// <summary> /// æ¯å¦æ¨é红åå ¥åº1-æ¨éï¼0-æªæ¨é /// </summary> [SugarColumn(ColumnName = "DKA013")] /// <summary> /// æ¯å¦æ¨é红åå ¥åº1-æ¨éï¼0-æªæ¨é /// </summary> [SugarColumn(ColumnName = "DKA013")] public decimal? Dka013 { get; set; } } MES.Service/service/BasicData/MesStaffManager.cs
@@ -149,7 +149,7 @@ Status = 0, Isdeparture = 0, CheckFlag = 0, ExpFiel12 = 0, ExpFiel12 = 0 }; }
@@ -1,78 +1,79 @@ using SqlSugar; using System; using System.Collections.Generic; using MES.Service.DB; using MES.Service.DB; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service.QC namespace MES.Service.service.QC; public class MesQaItemsDetectDetail5Manager : Repository<MesQaItemsDetectDetail5> { public class MesQaItemsDetectDetail5Manager : Repository<MesQaItemsDetectDetail5> { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,å¦æè¦éæ°çæ请å é¤ MesQaItemsDetectDetail5Manager.cs #region æå¦æ¹æ³ /// <summary> /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ /// </summary> public void Study() { /*********æ¥è¯¢*********/ /*********æ¥è¯¢*********/ var data1 = base.GetById(1);//æ ¹æ®IDæ¥è¯¢ var data2 = base.GetList();//æ¥è¯¢ææ var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ var data1 = base.GetById(1); //æ ¹æ®IDæ¥è¯¢ var data2 = base.GetList(); //æ¥è¯¢ææ var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,å¦æè¶ è¿ä¸æ¡ä¼æ¥é var p = new PageModel() { PageIndex = 1, PageSize = 2 };// å页æ¥è¯¢ var p = new PageModel { PageIndex = 1, PageSize = 2 }; // å页æ¥è¯¢ var data5 = base.GetPageList(it => 1 == 1, p); Console.Write(p.TotalCount);//è¿åæ»æ° Console.Write(p.TotalCount); //è¿åæ»æ° var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// å页æ¥è¯¢å æåº Console.Write(p.TotalCount);//è¿åæ»æ° List<IConditionalModel> conModels = new List<IConditionalModel>(); //ç»è£ æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº conModels.Add(new ConditionalModel() { FieldName= typeof(MesQaItemsDetectDetail5).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1 var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc); var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom()); // å页æ¥è¯¢å æåº Console.Write(p.TotalCount); //è¿åæ»æ° base.AsQueryable().Where(x => 1 == 1).ToList();//æ¯æäºè½¬æ¢æqueryable,æ们å¯ä»¥ç¨queryableå®ç°å¤æåè½ var conModels = new List<IConditionalModel>(); //ç»è£ æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº conModels.Add(new ConditionalModel { FieldName = typeof(MesQaItemsDetectDetail5).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" }); //id=1 var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); AsQueryable().Where(x => 1 == 1) .ToList(); //æ¯æäºè½¬æ¢æqueryable,æ们å¯ä»¥ç¨queryableå®ç°å¤æåè½ /*********æå ¥*********/ var insertData = new MesQaItemsDetectDetail5() { };//æµè¯åæ° var insertArray = new MesQaItemsDetectDetail5[] { insertData }; base.Insert(insertData);//æå ¥ base.InsertRange(insertArray);//æ¹éæå ¥ var id = base.InsertReturnIdentity(insertData);//æå ¥è¿åèªå¢å base.AsInsertable(insertData).ExecuteCommand();//æ们å¯ä»¥è½¬æ Insertableå®ç°å¤ææå ¥ var insertData = new MesQaItemsDetectDetail5(); //æµè¯åæ° var insertArray = new[] { insertData }; base.Insert(insertData); //æå ¥ base.InsertRange(insertArray); //æ¹éæå ¥ var id = base.InsertReturnIdentity(insertData); //æå ¥è¿åèªå¢å AsInsertable(insertData).ExecuteCommand(); //æ们å¯ä»¥è½¬æ Insertableå®ç°å¤ææå ¥ /*********æ´æ°*********/ var updateData = new MesQaItemsDetectDetail5() { };//æµè¯åæ° var updateArray = new MesQaItemsDetectDetail5[] { updateData };//æµè¯åæ° base.Update(updateData);//æ ¹æ®å®ä½æ´æ° base.UpdateRange(updateArray);//æ¹éæ´æ° /*********æ´æ°*********/ var updateData = new MesQaItemsDetectDetail5(); //æµè¯åæ° var updateArray = new[] { updateData }; //æµè¯åæ° base.Update(updateData); //æ ¹æ®å®ä½æ´æ° base.UpdateRange(updateArray); //æ¹éæ´æ° //base.Update(it => new MesQaItemsDetectDetail5() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å ¶å®åä¸æ´æ°ï¼æ¡ä»¶id=1 base.AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå ¥ AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå ¥ /*********å é¤*********/ var deldata = new MesQaItemsDetectDetail5(); //æµè¯åæ° base.Delete(deldata); //æ ¹æ®å®ä½å é¤ base.DeleteById(1); //æ ¹æ®ä¸»é®å é¤ base.DeleteById(new[] { 1, 2 }); //æ ¹æ®ä¸»é®æ°ç»å é¤ base.Delete(it => 1 == 2); //æ ¹æ®æ¡ä»¶å é¤ AsDeleteable().Where(it => 1 == 2) .ExecuteCommand(); //转æDeleteableå®ç°å¤æçæä½ } /*********å é¤*********/ var deldata = new MesQaItemsDetectDetail5() { };//æµè¯åæ° base.Delete(deldata);//æ ¹æ®å®ä½å é¤ base.DeleteById(1);//æ ¹æ®ä¸»é®å é¤ base.DeleteById(new int[] { 1,2});//æ ¹æ®ä¸»é®æ°ç»å é¤ base.Delete(it=>1==2);//æ ¹æ®æ¡ä»¶å é¤ base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//转æDeleteableå®ç°å¤æçæä½ } #endregion } } MES.Service/service/Warehouse/MesDepotSectionsManager.cs
@@ -17,21 +17,17 @@ .Select((a, b) => a.DepotSectionName).Single(); if (sectionName == null) { throw new Exception("åºä½ç¼ç " + query.sectionCode + " ä¸åå¨ï¼è¯·ç¡®è®¤ï¼"); } return sectionName; } //åºä½åæ´ public MesDepotSections ScanInDepotSectionsName(WarehouseQuery query) { if (string.IsNullOrEmpty(query.sectionCode)) { throw new Exception("请æ«åºä½æ¡ç !"); } var mesDepotSections = Db.Queryable<MesDepotSections, MesDepots>( (a, b) => new JoinQueryInfos(JoinType.Inner, a.DepotId == b.DepotId)) @@ -44,20 +40,47 @@ }).First(); if (mesDepotSections == null) { throw new Exception("åºä½ç¼ç " + query.sectionCode + " ä¸åå¨ï¼è¯·ç¡®è®¤!"); } return mesDepotSections; } //åºä½åæ´ public MesInvItemStocks ScanEditBarcode(WarehouseQuery entity) { if (string.IsNullOrEmpty(entity.sectionCode)) { throw new Exception("请æ«åºä½æ¡ç !"); } return null; var mesDepotSections = Db.Queryable<MesDepotSections, MesDepots>( (a, b) => new JoinQueryInfos(JoinType.Inner, a.Zuid.ToString() == b.Zuid)) .Where((a, b) => a.DepotSectionCode == entity.sectionCode) .First(); if (mesDepotSections == null) throw new Exception("åºä½ç¼ç " + entity.sectionCode + " ä¸åå¨ï¼è¯·ç¡®è®¤ï¼"); var mesInvItemStocks = Db.Queryable<MesInvItemStocks>() .Where(s => s.ItemBarcode == entity.barcode).First(); if (mesInvItemStocks == null) throw new Exception("æ¡ç å¨ä»åºä¸ä¸åå¨ï¼è¯·æ ¸å¯¹ï¼"); if (mesInvItemStocks.DepotsCode != mesDepotSections.DepotCode) throw new Exception( "æ¡ç åä»åºï¼" + mesInvItemStocks.DepotsCode + " ä¸ç®æ ä»åºï¼" + mesDepotSections.DepotCode + " ä¸ä¸è´ï¼åºä½åæ´å¤±è´¥ï¼"); UseTransaction(db => { return db.Updateable<MesInvItemStocks>() .SetColumns(s => s.DepotsCode == mesDepotSections.DepotCode) .SetColumns(s => s.DepotSectionsCode == entity.sectionCode) .Where(s => s.ItemBarcode == entity.barcode) .ExecuteCommand(); }); return mesInvItemStocks; } //è°æ¨å ¥åº } MES.Service/service/Warehouse/MesInvBusiness2Manager.cs
@@ -1,78 +1,78 @@ using SqlSugar; using System; using System.Collections.Generic; using MES.Service.DB; using MES.Service.DB; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service.Warehouse { namespace MES.Service.service.Warehouse; public class MesInvBusiness2Manager : Repository<MesInvBusiness2> { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,å¦æè¦éæ°çæ请å é¤ MesInvBusiness2Manager.cs #region æå¦æ¹æ³ /// <summary> /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ /// </summary> public void Study() { /*********æ¥è¯¢*********/ /*********æ¥è¯¢*********/ var data1 = base.GetById(1);//æ ¹æ®IDæ¥è¯¢ var data2 = base.GetList();//æ¥è¯¢ææ var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ var data1 = base.GetById(1); //æ ¹æ®IDæ¥è¯¢ var data2 = base.GetList(); //æ¥è¯¢ææ var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,å¦æè¶ è¿ä¸æ¡ä¼æ¥é var p = new PageModel() { PageIndex = 1, PageSize = 2 };// å页æ¥è¯¢ var p = new PageModel { PageIndex = 1, PageSize = 2 }; // å页æ¥è¯¢ var data5 = base.GetPageList(it => 1 == 1, p); Console.Write(p.TotalCount);//è¿åæ»æ° Console.Write(p.TotalCount); //è¿åæ»æ° var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// å页æ¥è¯¢å æåº Console.Write(p.TotalCount);//è¿åæ»æ° List<IConditionalModel> conModels = new List<IConditionalModel>(); //ç»è£ æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº conModels.Add(new ConditionalModel() { FieldName= typeof(MesInvBusiness2).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1 var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc); var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom()); // å页æ¥è¯¢å æåº Console.Write(p.TotalCount); //è¿åæ»æ° base.AsQueryable().Where(x => 1 == 1).ToList();//æ¯æäºè½¬æ¢æqueryable,æ们å¯ä»¥ç¨queryableå®ç°å¤æåè½ var conModels = new List<IConditionalModel>(); //ç»è£ æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº conModels.Add(new ConditionalModel { FieldName = typeof(MesInvBusiness2).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" }); //id=1 var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); AsQueryable().Where(x => 1 == 1) .ToList(); //æ¯æäºè½¬æ¢æqueryable,æ们å¯ä»¥ç¨queryableå®ç°å¤æåè½ /*********æå ¥*********/ var insertData = new MesInvBusiness2() { };//æµè¯åæ° var insertArray = new MesInvBusiness2[] { insertData }; base.Insert(insertData);//æå ¥ base.InsertRange(insertArray);//æ¹éæå ¥ var id = base.InsertReturnIdentity(insertData);//æå ¥è¿åèªå¢å base.AsInsertable(insertData).ExecuteCommand();//æ们å¯ä»¥è½¬æ Insertableå®ç°å¤ææå ¥ var insertData = new MesInvBusiness2(); //æµè¯åæ° var insertArray = new[] { insertData }; base.Insert(insertData); //æå ¥ base.InsertRange(insertArray); //æ¹éæå ¥ var id = base.InsertReturnIdentity(insertData); //æå ¥è¿åèªå¢å AsInsertable(insertData).ExecuteCommand(); //æ们å¯ä»¥è½¬æ Insertableå®ç°å¤ææå ¥ /*********æ´æ°*********/ var updateData = new MesInvBusiness2() { };//æµè¯åæ° var updateArray = new MesInvBusiness2[] { updateData };//æµè¯åæ° base.Update(updateData);//æ ¹æ®å®ä½æ´æ° base.UpdateRange(updateArray);//æ¹éæ´æ° /*********æ´æ°*********/ var updateData = new MesInvBusiness2(); //æµè¯åæ° var updateArray = new[] { updateData }; //æµè¯åæ° base.Update(updateData); //æ ¹æ®å®ä½æ´æ° base.UpdateRange(updateArray); //æ¹éæ´æ° //base.Update(it => new MesInvBusiness2() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å ¶å®åä¸æ´æ°ï¼æ¡ä»¶id=1 base.AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå ¥ AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå ¥ /*********å é¤*********/ var deldata = new MesInvBusiness2(); //æµè¯åæ° base.Delete(deldata); //æ ¹æ®å®ä½å é¤ base.DeleteById(1); //æ ¹æ®ä¸»é®å é¤ base.DeleteById(new[] { 1, 2 }); //æ ¹æ®ä¸»é®æ°ç»å é¤ base.Delete(it => 1 == 2); //æ ¹æ®æ¡ä»¶å é¤ AsDeleteable().Where(it => 1 == 2) .ExecuteCommand(); //转æDeleteableå®ç°å¤æçæä½ } /*********å é¤*********/ var deldata = new MesInvBusiness2() { };//æµè¯åæ° base.Delete(deldata);//æ ¹æ®å®ä½å é¤ base.DeleteById(1);//æ ¹æ®ä¸»é®å é¤ base.DeleteById(new int[] { 1,2});//æ ¹æ®ä¸»é®æ°ç»å é¤ base.Delete(it=>1==2);//æ ¹æ®æ¡ä»¶å é¤ base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//转æDeleteableå®ç°å¤æçæä½ } #endregion } } MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs
@@ -59,8 +59,8 @@ // æ¥è¯¢ var result = Db .Queryable<MesQaItemsDetect01, MesInvItemArn, MesInvItemArnDetail, MesItems, MesUnit,MesQaItemsDetectDetail5>( (a, d, b, c, t,z) => new object[] MesItems, MesUnit, MesQaItemsDetectDetail5>( (a, d, b, c, t, z) => new object[] { JoinType.Inner, d.BillNo == a.LotNo, JoinType.Inner, d.Id == b.Mid && b.ItemNo == a.ItemNo, @@ -70,9 +70,9 @@ JoinType.Inner, c.Fpurchaseunitid == t.Id, JoinType.Inner, z.ReleaseNo == a.ReleaseNo }) .Where((a, d, b, c, t,z) => a.FngHandle == "éè´§" && z.FcheckResu == "ä¸åæ ¼" && query.ItemArnDetailIds.Contains(b.Id)) .Where((a, d, b, c, t, z) => a.FngHandle == "éè´§" && z.FcheckResu == "ä¸åæ ¼" && query.ItemArnDetailIds.Contains(b.Id)) .Select((a, d, b, c, t) => new Material { FmrMode = a.Fmrmode, MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,79 @@ using MES.Service.DB; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service.Warehouse; public class MesInvItemMovesCDetailsManager : Repository<MesInvItemMovesCDetails> { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,å¦æè¦éæ°çæ请å é¤ MesInvItemMovesCDetailsManager.cs #region æå¦æ¹æ³ /// <summary> /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ /// </summary> public void Study() { /*********æ¥è¯¢*********/ var data1 = base.GetById(1); //æ ¹æ®IDæ¥è¯¢ var data2 = base.GetList(); //æ¥è¯¢ææ var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,å¦æè¶ è¿ä¸æ¡ä¼æ¥é var p = new PageModel { PageIndex = 1, PageSize = 2 }; // å页æ¥è¯¢ var data5 = base.GetPageList(it => 1 == 1, p); Console.Write(p.TotalCount); //è¿åæ»æ° var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom()); // å页æ¥è¯¢å æåº Console.Write(p.TotalCount); //è¿åæ»æ° var conModels = new List<IConditionalModel>(); //ç»è£ æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº conModels.Add(new ConditionalModel { FieldName = typeof(MesInvItemMovesCDetails).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" }); //id=1 var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); AsQueryable().Where(x => 1 == 1) .ToList(); //æ¯æäºè½¬æ¢æqueryable,æ们å¯ä»¥ç¨queryableå®ç°å¤æåè½ /*********æå ¥*********/ var insertData = new MesInvItemMovesCDetails(); //æµè¯åæ° var insertArray = new[] { insertData }; base.Insert(insertData); //æå ¥ base.InsertRange(insertArray); //æ¹éæå ¥ var id = base.InsertReturnIdentity(insertData); //æå ¥è¿åèªå¢å AsInsertable(insertData).ExecuteCommand(); //æ们å¯ä»¥è½¬æ Insertableå®ç°å¤ææå ¥ /*********æ´æ°*********/ var updateData = new MesInvItemMovesCDetails(); //æµè¯åæ° var updateArray = new[] { updateData }; //æµè¯åæ° base.Update(updateData); //æ ¹æ®å®ä½æ´æ° base.UpdateRange(updateArray); //æ¹éæ´æ° //base.Update(it => new MesInvItemMovesCDetails() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å ¶å®åä¸æ´æ°ï¼æ¡ä»¶id=1 AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå ¥ /*********å é¤*********/ var deldata = new MesInvItemMovesCDetails(); //æµè¯åæ° base.Delete(deldata); //æ ¹æ®å®ä½å é¤ base.DeleteById(1); //æ ¹æ®ä¸»é®å é¤ base.DeleteById(new[] { 1, 2 }); //æ ¹æ®ä¸»é®æ°ç»å é¤ base.Delete(it => 1 == 2); //æ ¹æ®æ¡ä»¶å é¤ AsDeleteable().Where(it => 1 == 2) .ExecuteCommand(); //转æDeleteableå®ç°å¤æçæä½ } #endregion } MES.Service/service/Warehouse/MesInvItemMovesManager.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,45 @@ using MES.Service.DB; using MES.Service.Dto.service; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service.Warehouse; public class MesInvItemMovesManager : Repository<MesInvItemMoves> { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,å¦æè¦éæ°çæ请å é¤ MesInvItemMovesManager.cs public List<MesInvItemMoves> GetBillNo(WarehouseQuery query) { query.Factory = "1000"; query.Company = "1000"; return Db.Queryable<MesInvItemMoves>() .Where(it => SqlFunc.IsNull(it.Status, 0) == 1 && SqlFunc.IsNull(it.Ts, 0) != 1) .Where(it => it.Factory == query.Factory && it.Company == query.Company) .OrderBy(it => it.Id, OrderByType.Desc).ToList(); } //scan_out_show_DB public List<InventoryItem> ScanOutShowDb(WarehouseQuery query) { var BillTypeId = 300; var TransctionNo = 301; query.Factory = "1000"; query.Company = "1000"; var sql = string.Format( "select f_get_sections_code({0}, {1}, b.item_no) sections_code , s.erp_item_no , S.ITEM_MODEL , to_char(nvl(b.quantity, 0) - nvl(quantity_ok, 0), 'FM9999999990.00') flist from mes_inv_item_moves a join mes_inv_item_out_items b on b.item_out_id = a.id join mes_items s on b.item_no = s.item_no left join (select ITEM_MOVE_ID, item_no, sum(quantity) quantity_ok from MES_INV_ITEM_MOVES_C_DETAILS group by ITEM_MOVE_ID, item_no) c on c.ITEM_MOVE_ID = a.id and b.item_no = c.item_no where 1 = 1 and a.bill_type_id = {2} and a.transaction_no = {3} and a.bill_no = {4} and nvl(b.quantity, 0) - nvl(quantity_ok, 0) > 0 and rownum < 500 AND A.STATUS = 1 order by f_get_sections_code({0}, {1}, b.item_no), s.erp_item_no ", query.Factory, query.Company, BillTypeId, TransctionNo, query.billNo); var results = Db.Ado.SqlQuery<InventoryItem>(sql); return results; } } MES.Service/service/Warehouse/OpeningReceiptServer.cs
@@ -18,37 +18,26 @@ public MesInvItemBarcodes ScanInBarcodeQC(WarehouseQuery query) { if (string.IsNullOrWhiteSpace(query.sectionCode)) { throw new Exception("请æ«åºä½æ¡ç ï¼"); } var depotCode = GetDepotCode(query.sectionCode); if (depotCode == null) { throw new Exception($"002[åºä½ç¼ç {query.sectionCode} ä¸åå¨ï¼è¯·ç¡®è®¤ï¼"); } var checkBarcodeAlreadyReceived = CheckBarcodeAlreadyReceived(query.barcode); if (checkBarcodeAlreadyReceived > 0) { throw new Exception("æ¡ç éå¤æ«æï¼è¯·æ ¸å¯¹ï¼"); } if (checkBarcodeAlreadyReceived > 0) throw new Exception("æ¡ç éå¤æ«æï¼è¯·æ ¸å¯¹ï¼"); if (CheckBarcodeInStock(query.barcode) > 0) { throw new Exception("æ¡ç å·²å¨åºåä¸ï¼è¯·æ ¸å¯¹ï¼"); } var barcodeInfo = GetBarcodeInfo(query.barcode); if (barcodeInfo == null || barcodeInfo.ComeFlg != 0) { throw new Exception("æ¡ç ä¸æ¯æåæ¡ç ï¼æ æ³ç¨æåå ¥åºï¼"); } var inventoryItemInId = GetOrCreateInventoryItemInId(barcodeInfo, depotCode, query.userName, out string billNo); depotCode, query.userName, out var billNo); UseTransaction(db => { @@ -71,15 +60,12 @@ var mesInvItemBarcodes = Db.Queryable<MesInvItemBarcodes>() .Where(s => s.ItemBarcode == query.barcode).Count(); if (mesInvItemBarcodes <= 0) { throw new Exception("æ¡ç ä¸åå¨"); } if (mesInvItemBarcodes <= 0) throw new Exception("æ¡ç ä¸åå¨"); var mesInvItemInCDetails = Db.Queryable<MesInvItemInCDetails>() .Where(s => s.ItemBarcode == query.barcode).Single(); PurchaseInventory entity = new PurchaseInventory var entity = new PurchaseInventory { ItemIns = GetMesInvItemIns(mesInvItemInCDetails.ItemInId), InvItemInCDetails = @@ -153,10 +139,7 @@ TaskNo = barcodeInfo.TaskNo }).ExecuteCommand(); if (executeCommand <= 0) { throw new Exception("åå ¥å¤±è´¥"); } if (executeCommand <= 0) throw new Exception("åå ¥å¤±è´¥"); } private decimal GetOrCreateInventoryItemInId(MesInvItemBarcodes barcodeInfo, @@ -264,10 +247,7 @@ SuppNo = barcodeInfo.SuppNo }).ExecuteCommand(); if (executeCommand <= 0) { throw new Exception("åå ¥å¤±è´¥"); } if (executeCommand <= 0) throw new Exception("åå ¥å¤±è´¥"); } private void InsertBusinessRecord(MesInvItemBarcodes barcodeInfo, @@ -300,9 +280,6 @@ SuppNo = barcodeInfo.SuppNo }).ExecuteCommand(); if (executeCommand <= 0) { throw new Exception("åå ¥å¤±è´¥"); } if (executeCommand <= 0) throw new Exception("åå ¥å¤±è´¥"); } } MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs
@@ -16,6 +16,48 @@ /***è¿å ¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ //ScanInDepotSectionsName [HttpPost("ScanInDepotSectionsName")] public ResponseResult ScanInDepotSectionsName(WarehouseQuery query) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.ScanInDepotSectionsName(query); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //ScanEditBarcode [HttpPost("ScanEditBarcode")] public ResponseResult ScanEditBarcode(WarehouseQuery query) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.ScanEditBarcode(query); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //GetSectionName [HttpPost("GetSectionName")] public ResponseResult GetSectionName(WarehouseQuery query) MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs
@@ -1,170 +1,162 @@ using Microsoft.AspNetCore.Mvc; using Microsoft.Extensions.Logging; using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Threading.Tasks; using System.Dynamic; using System.Dynamic; using MES.Service.Modes; using MES.Service.service; using MES.Service.service.Warehouse; using MES.Service.util; using Microsoft.AspNetCore.Mvc; namespace MESApplication.Controllers.Warehouse namespace MESApplication.Controllers.Warehouse; [ApiController] [Route("api/[controller]")] public class MesInvBusiness2Controller : ControllerBase { [ApiController] [Route("api/[controller]")] public class MesInvBusiness2Controller : ControllerBase private readonly MesInvBusiness2Manager m = new(); /***è¿å ¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ /// <summary> /// è·åææ /// </summary> /// <returns></returns> [HttpPost("GetList")] public ResponseResult GetList() { private MesInvBusiness2Manager m = new MesInvBusiness2Manager(); /***è¿å ¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ /// <summary> /// è·åææ /// </summary> /// <returns></returns> [HttpPost("GetList")] public ResponseResult GetList() try { try dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetList(); return new ResponseResult { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetList(); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } status = 0, message = "OK", data = resultInfos }; } /// <summary> /// æ ¹æ®ä¸»é®è·å /// </summary> /// <returns></returns> [HttpPost("GetById")] public ResponseResult GetById(int id) catch (Exception ex) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetById(id); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®å é¤ /// </summary> /// <returns></returns> [HttpPost("DeleteByIds")] public ResponseResult DeleteByIds([FromBody] object[] ids) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.DeleteByIds(ids); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å /// </summary> /// <returns></returns> [HttpPost("Insert")] public ResponseResult Add([FromBody] MesInvBusiness2 data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Insert(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å è¿åèªå¢ /// </summary> /// <returns></returns> [HttpPost("InsertReturnIdentity")] public ResponseResult InsertReturnIdentity([FromBody] MesInvBusiness2 data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.InsertReturnIdentity(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// ä¿®æ¹ /// </summary> /// <returns></returns> [HttpPost("Update")] public ResponseResult Update([FromBody] MesInvBusiness2 data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Update(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } return ResponseResult.ResponseError(ex); } } } /// <summary> /// æ ¹æ®ä¸»é®è·å /// </summary> /// <returns></returns> [HttpPost("GetById")] public ResponseResult GetById(int id) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetById(id); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®å é¤ /// </summary> /// <returns></returns> [HttpPost("DeleteByIds")] public ResponseResult DeleteByIds([FromBody] object[] ids) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.DeleteByIds(ids); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å /// </summary> /// <returns></returns> [HttpPost("Insert")] public ResponseResult Add([FromBody] MesInvBusiness2 data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Insert(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å è¿åèªå¢ /// </summary> /// <returns></returns> [HttpPost("InsertReturnIdentity")] public ResponseResult InsertReturnIdentity([FromBody] MesInvBusiness2 data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.InsertReturnIdentity(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// ä¿®æ¹ /// </summary> /// <returns></returns> [HttpPost("Update")] public ResponseResult Update([FromBody] MesInvBusiness2 data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Update(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } } MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,163 @@ using System.Dynamic; using MES.Service.Modes; using MES.Service.service.Warehouse; using MES.Service.util; using Microsoft.AspNetCore.Mvc; namespace MESApplication.Controllers.Warehouse; [ApiController] [Route("api/[controller]")] public class MesInvItemMovesCDetailsController : ControllerBase { private readonly MesInvItemMovesCDetailsManager m = new(); /***è¿å ¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ /// <summary> /// è·åææ /// </summary> /// <returns></returns> [HttpPost("GetList")] public ResponseResult GetList() { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetList(); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®è·å /// </summary> /// <returns></returns> [HttpPost("GetById")] public ResponseResult GetById(int id) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetById(id); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®å é¤ /// </summary> /// <returns></returns> [HttpPost("DeleteByIds")] public ResponseResult DeleteByIds([FromBody] object[] ids) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.DeleteByIds(ids); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å /// </summary> /// <returns></returns> [HttpPost("Insert")] public ResponseResult Add([FromBody] MesInvItemMovesCDetails data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Insert(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å è¿åèªå¢ /// </summary> /// <returns></returns> [HttpPost("InsertReturnIdentity")] public ResponseResult InsertReturnIdentity( [FromBody] MesInvItemMovesCDetails data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.InsertReturnIdentity(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// ä¿®æ¹ /// </summary> /// <returns></returns> [HttpPost("Update")] public ResponseResult Update([FromBody] MesInvItemMovesCDetails data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Update(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } } MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,204 @@ using System.Dynamic; using MES.Service.Dto.service; using MES.Service.Modes; using MES.Service.service.Warehouse; using MES.Service.util; using Microsoft.AspNetCore.Mvc; namespace MESApplication.Controllers.Warehouse; [ApiController] [Route("api/[controller]")] public class MesInvItemMovesController : ControllerBase { private readonly MesInvItemMovesManager m = new(); // GetBillNo [HttpPost("GetBillNo")] public ResponseResult GetBillNo(WarehouseQuery query) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetBillNo(query); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //ScanOutShowDb [HttpPost("ScanOutShowDb")] public ResponseResult ScanOutShowDb(WarehouseQuery query) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetBillNo(query); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// è·åææ /// </summary> /// <returns></returns> [HttpPost("GetList")] public ResponseResult GetList() { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetList(); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®è·å /// </summary> /// <returns></returns> [HttpPost("GetById")] public ResponseResult GetById(int id) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetById(id); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®å é¤ /// </summary> /// <returns></returns> [HttpPost("DeleteByIds")] public ResponseResult DeleteByIds([FromBody] object[] ids) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.DeleteByIds(ids); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å /// </summary> /// <returns></returns> [HttpPost("Insert")] public ResponseResult Add([FromBody] MesInvItemMoves data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Insert(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å è¿åèªå¢ /// </summary> /// <returns></returns> [HttpPost("InsertReturnIdentity")] public ResponseResult InsertReturnIdentity( [FromBody] MesInvItemMoves data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.InsertReturnIdentity(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// ä¿®æ¹ /// </summary> /// <returns></returns> [HttpPost("Update")] public ResponseResult Update([FromBody] MesInvItemMoves data) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.Update(data); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } } MESApplication/Controllers/Warehouse/OpeningReceiptController.cs
@@ -31,7 +31,7 @@ return ResponseResult.ResponseError(ex); } } [HttpPost("GetForm")] public ResponseResult GetForm(WarehouseQuery query) {
