MES.Service/DB/Repository.cs
@@ -5,7 +5,7 @@ public class Repository<T> : SimpleClient<T> where T : class, new() { public static SqlSugarScope Db = new(new ConnectionConfig protected static SqlSugarScope Db = new(new ConnectionConfig { DbType = DbType.Oracle, ConnectionString = AppsettingsUtility.Settings.DataBaseConn, @@ -25,7 +25,7 @@ if (context == null) Context = Db; } public int UseTransaction(Func<SqlSugarScope, int> action) protected int UseTransaction(Func<SqlSugarScope, int> action) { try { MES.Service/DB/RepositoryNoEntity.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,39 @@ using MES.Service.util; using SqlSugar; namespace MES.Service.DB; public class RepositoryNoEntity { protected static SqlSugarScope Db = new(new ConnectionConfig { DbType = DbType.Oracle, ConnectionString = AppsettingsUtility.Settings.DataBaseConn, IsAutoCloseConnection = true }, db => { db.Aop.OnLogExecuting = (sql, pars) => { Console.WriteLine( UtilMethods.GetSqlString(DbType.Oracle, sql, pars)); }; }); protected int UseTransaction(Func<SqlSugarScope, int> action) { try { Db.Ado.BeginTran(); // å¼å§äºå¡ var affectedRows = action.Invoke(Db); // æ§è¡ä¼ å ¥çæä½å¹¶è·ååå½±åçè¡æ° Db.Ado.CommitTran(); // æ交äºå¡ return affectedRows; // è¿ååå½±åçè¡æ° } catch (Exception) { Db.Ado.RollbackTran(); // åæ»äºå¡ throw; // éæ°æåºå¼å¸¸ } } } MES.Service/Modes/MesDepotSections.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,103 @@ using SqlSugar; namespace MES.Service.Modes; /// <summary> /// ä»ä½ä¿¡æ¯ /// </summary> [SugarTable("MES_DEPOT_SECTIONS")] public class MesDepotSections { /// <summary> /// ID(SEQ_INV_ID)ï¼ERPIDï¼ /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_ID", IsPrimaryKey = true)] public decimal DepotSectionId { get; set; } /// <summary> /// è´§ä½ç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] public string DepotSectionCode { get; set; } /// <summary> /// è´§ä½å称 /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_NAME")] public string DepotSectionName { get; set; } /// <summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_ID")] public decimal? DepotId { get; set; } /// <summary> /// åä¸é½å¥æ ¡éª(0:å¦,1:æ¯) /// </summary> [SugarColumn(ColumnName = "COMPLETENESS_FLAG")] public short? CompletenessFlag { 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 = "COMPANY")] public string Company { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } /// <summary> /// å¡æ¿æ° /// </summary> [SugarColumn(ColumnName = "KB_QTY")] public decimal? KbQty { get; set; } /// <summary> /// ä»ä½ç»ID /// </summary> [SugarColumn(ColumnName = "ZUID")] public decimal? Zuid { get; set; } /// <summary> /// ä»ä½å ¨å /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_NAMET")] public string DepotSectionNamet { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "ERPID")] public decimal? Erpid { get; set; } } MES.Service/Modes/MesInvBusiness2.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,194 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; namespace MES.Service.Modes { /// <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; } } } 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,7 @@ /// <summary> /// SEQ_OUT /// </summary> [SugarColumn(ColumnName = "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/MesInvItemIns.cs
@@ -11,7 +11,8 @@ /// <summary> /// ID(SEQ_INV_ID) /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> MES.Service/Modes/MesInvItemStocks.cs
@@ -8,194 +8,196 @@ [SugarTable("MES_INV_ITEM_STOCKS")] public class MesInvItemStocks { /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] /// <summary> /// SEQ_ME_ID /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ME_ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// ç产订å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] /// <summary> /// ç产订å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { 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> /// ååºid /// </summary> [SugarColumn(ColumnName = "DEPOTS_ID")] /// <summary> /// ååºid /// </summary> [SugarColumn(ColumnName = "DEPOTS_ID")] public decimal? DepotsId { get; set; } /// <summary> /// è´§ä½id /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")] /// <summary> /// è´§ä½id /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")] public decimal? DepotSectionsId { 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 = "CUSTOMER_NO")] /// <summary> /// 客æ·ç¼ç /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NO")] public string CustomerNo { get; set; } /// <summary> /// éé /// </summary> [SugarColumn(ColumnName = "ITEM_WT")] /// <summary> /// éé /// </summary> [SugarColumn(ColumnName = "ITEM_WT")] public decimal? ItemWt { get; set; } /// <summary> /// ååºCODE /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] /// <summary> /// ååºCODE /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] public string DepotsCode { get; set; } /// <summary> /// è´§ä½CODE /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")] /// <summary> /// è´§ä½CODE /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")] public string DepotSectionsCode { get; set; } /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// <summary> /// 0 ç©æ 1 åæå 2 æå /// </summary> [SugarColumn(ColumnName = "ITEM_TYPE")] /// <summary> /// 0 ç©æ 1 åæå 2 æå /// </summary> [SugarColumn(ColumnName = "ITEM_TYPE")] public short? ItemType { get; set; } /// <summary> /// å ¥åºæ¥æ /// </summary> [SugarColumn(ColumnName = "INDEP_DATE")] /// <summary> /// å ¥åºæ¥æ /// </summary> [SugarColumn(ColumnName = "INDEP_DATE")] public DateTime? IndepDate { 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 = "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> /// å»ç»æ交éæ£ï¼0ï¼å»ç»æªæ交éæ£ï¼1ï¼å»ç»å¹¶æ交éæ£ /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT")] /// <summary> /// å»ç»æ交éæ£ï¼0ï¼å»ç»æªæ交éæ£ï¼1ï¼å»ç»å¹¶æ交éæ£ /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT")] public short? VisableSubmit { get; set; } /// <summary> /// æ交éæ£äºº /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")] /// <summary> /// æ交éæ£äºº /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")] public string VisableSubmitBy { get; set; } /// <summary> /// æ交éæ£æ¶é´ /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")] /// <summary> /// æ交éæ£æ¶é´ /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")] public DateTime? VisableSubmitDate { 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 = "WORK_LINE")] /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// ç产线 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] /// <summary> /// ç产线 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } /// <summary> /// åæåå ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] /// <summary> /// åæåå ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } /// <summary> /// éè´è®¢åid /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] /// <summary> /// éè´è®¢åid /// </summary> [SugarColumn(ColumnName = "EBELN_K3ID")] public decimal? EbelnK3id { get; set; } /// <summary> /// éè´è®¢åè¡id /// </summary> [SugarColumn(ColumnName = "LINE_K3ID")] /// <summary> /// éè´è®¢åè¡id /// </summary> [SugarColumn(ColumnName = "LINE_K3ID")] public decimal? LineK3id { get; set; } } MES.Service/Modes/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
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,154 @@ using System; using System.Collections.Generic; using System.Linq; using SqlSugar; namespace MES.Service.Modes { /// <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; } } } 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/bin/Debug/net8.0/MES.Service.dllBinary files differ
MES.Service/bin/Debug/net8.0/MES.Service.pdbBinary files differ
MES.Service/bin/Release/net8.0/MES.Service.dllBinary files differ
MES.Service/bin/Release/net8.0/MES.Service.pdbBinary files differ
MES.Service/service/BasicData/MesStaffManager.cs
@@ -141,7 +141,15 @@ Lever = 0, Fcompany = "1000", Ffactory = "1000", DelFlag = 0 DelFlag = 0, Ismanager = 0, Isacq = 0, ExpField9 = "1020", QmUser = 0, Status = 0, Isdeparture = 0, CheckFlag = 0, ExpFiel12 = 0, }; }
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,78 @@ using SqlSugar; using System; using System.Collections.Generic; using MES.Service.DB; using MES.Service.Modes; namespace MES.Service.service.QC { 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 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(), 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); base.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 updateData = new MesQaItemsDetectDetail5() { };//æµè¯åæ° var updateArray = new MesQaItemsDetectDetail5[] { 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å¯ä»¥å®ç°å¤æçæå ¥ /*********å é¤*********/ 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
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,26 @@ using MES.Service.DB; using MES.Service.Dto.service; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service.Warehouse; public class MesDepotSectionsManager : Repository<MesDepotSections> { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ public string GetSectionName(WarehouseQuery query) { var sectionName = Db.Queryable<MesDepotSections, MesDepots>((a, b) => new JoinQueryInfos(JoinType.Inner, a.DepotId == b.DepotId)) .Where((a, b) => a.DepotSectionCode == query.sectionCode) .Select((a, b) => a.DepotSectionName).Single(); if (sectionName == null) { throw new Exception("åºä½ç¼ç " + query.sectionCode + " ä¸åå¨ï¼è¯·ç¡®è®¤ï¼"); } return sectionName; } } MES.Service/service/Warehouse/MesInvBusiness2Manager.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,78 @@ using SqlSugar; using System; using System.Collections.Generic; using MES.Service.DB; using MES.Service.Modes; 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 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(), 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); base.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 updateData = new MesInvBusiness2() { };//æµè¯åæ° var updateArray = new MesInvBusiness2[] { 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å¯ä»¥å®ç°å¤æçæå ¥ /*********å é¤*********/ 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,17 +59,19 @@ // æ¥è¯¢ var result = Db .Queryable<MesQaItemsDetect01, MesInvItemArn, MesInvItemArnDetail, MesItems, MesUnit>( (a, d, b, c, t) => 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, JoinType.Inner, a.ItemNo == c.ItemNo && a.Company == c.Company && a.Factory == c.Factory, JoinType.Inner, c.Fpurchaseunitid == t.Id JoinType.Inner, c.Fpurchaseunitid == t.Id, JoinType.Inner, z.ReleaseNo == a.ReleaseNo }) .Where((a, d, b, c, t) => a.FngHandle == "éè´§" && .Where((a, d, b, c, t,z) => a.FngHandle == "éè´§" && z.FcheckResu == "ä¸åæ ¼" && query.ItemArnDetailIds.Contains(b.Id)) .Select((a, d, b, c, t) => new Material { MES.Service/service/Warehouse/OpeningReceiptServer.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,262 @@ using MES.Service.DB; using MES.Service.Dto.service; using MES.Service.Modes; using MES.Service.util; using SqlSugar; namespace MES.Service.service.Warehouse; public class OpeningReceiptServer :RepositoryNoEntity { private const string Factory = "1000"; private const string Company = "1000"; 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} ä¸åå¨ï¼è¯·ç¡®è®¤ï¼"); } int billTypeId = 100; int transactionNo = 601; var checkBarcodeAlreadyReceived = CheckBarcodeAlreadyReceived(query.barcode); 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, transactionNo, out string billNo); UseTransaction(db => { // Insert records InsertInventoryDetails(inventoryItemInId, billNo, barcodeInfo, depotCode, query.sectionCode, query.userName); InsertBusinessRecord(barcodeInfo, depotCode, query.sectionCode, billNo, query.userName); InsertStockRecord(barcodeInfo, depotCode, query.sectionCode, query.userName); return 1; }); return barcodeInfo; } private void InsertInventoryDetails(decimal itemInId, string billNo, MesInvItemBarcodes barcodeInfo, string depotCode, string sectionCode, string user) { // Insert inventory details record var executeCommand = Db.Insertable(new MesInvItemInCDetails { ItemInId = itemInId, BillNo = billNo, ItemBarcode = barcodeInfo.ItemBarcode, Quantity = barcodeInfo.Quantity, BarcodeFlag = 1, EpFlag = 1, WorkType = 1, ItemNo = barcodeInfo.ItemNo, LotNo = barcodeInfo.LotNo, SuppNo = barcodeInfo.SuppNo, DepotCode = depotCode, DepotSectionCode = sectionCode, ItemSname = barcodeInfo.ItemSname, Unit = barcodeInfo.Unit, CreateBy = user, CreateDate = DateTime.Now, LastupdateBy = user, LastupdateDate = DateTime.Now, Remark = barcodeInfo.Memo, Factory = Factory, Company = Company, Ebeln = barcodeInfo.Mblnr, EbelnLineNo = barcodeInfo.Zeile, WorkNo = barcodeInfo.WorkNo, WorkLine = barcodeInfo.WorkLine, CbillNo = barcodeInfo.BillNo, UrgentFlag = barcodeInfo.UrgentFlag, BoardStyle = barcodeInfo.BoardStyle, TaskNo = barcodeInfo.TaskNo }).ExecuteCommand(); if (executeCommand <= 0) { throw new Exception("åå ¥å¤±è´¥"); } } private decimal GetOrCreateInventoryItemInId(MesInvItemBarcodes barcodeInfo, string depotCode, string userName, int transactionNo, out string billNo) { var inventory = Db.Queryable<MesInvItemIns>() .Where(d => d.InsDate >= DateTime.Today && d.InsDate < DateTime.Today.AddDays(1) && d.Sapstatus == 0 && d.Status == 0 && d.TransctionNo == transactionNo.ToString() && d.CbillNo == barcodeInfo.BillNo && d.SuppNo == barcodeInfo.SuppNo && d.DepotsCode == depotCode) .First(); if (inventory != null) { billNo = inventory.BillNo; return inventory.Id; } var sql = $"SELECT getbillcode1('{Factory}','{Company}','QCRK') FROM DUAL;"; billNo = Db.Ado.SqlQuerySingle<string>(sql); var executeReturnIdentity = Db.Insertable(new MesInvItemIns { BillNo = billNo, BillTypeId = 100, InsDate = DateTime.Now, DepotsCode = depotCode, TransctionNo = transactionNo.ToString(), SuppNo = barcodeInfo.SuppNo, CreateBy = userName, CreateDate = DateTime.Now, LastupdateBy = userName, LastupdateDate = DateTime.Now, Factory = Factory, Company = Company, UrgentFlag = barcodeInfo.UrgentFlag, CbillNo = barcodeInfo.BillNo, Fstatus = 0 }).ExecuteReturnIdentity(); return executeReturnIdentity; } private MesInvItemBarcodes GetBarcodeInfo(string itemBarcode) { // Get barcode information return Db.Queryable<MesInvItemBarcodes>() .First(b => b.ItemBarcode == itemBarcode); } private int CheckBarcodeInStock(string itemBarcode) { // Check if the barcode is in stock return Db.Queryable<MesInvItemStocks>() .Where(stock => stock.ItemBarcode == itemBarcode).Count(); } private int CheckBarcodeAlreadyReceived(string itemBarcode) { // Check if the barcode is already received return Db.Queryable<MesInvItemIns, MesInvItemInCDetails>( (ins, details) => new JoinQueryInfos(JoinType.Inner, ins.Id == details.ItemInId)) .Where((ins, details) => details.ItemBarcode == itemBarcode) .Count(); } private string GetDepotCode(string sectionCode) { // This would be your query to get depot code based on section code return Db.Queryable<MesDepotSections, MesDepots>((d, t) => new JoinQueryInfos(JoinType.Inner, d.Zuid.ToString() == t.Zuid)) .Where((d, t) => d.DepotSectionCode == sectionCode) .Select<string>((d, t) => t.DepotCode) .First(); } private void InsertStockRecord(MesInvItemBarcodes barcodeInfo, string depotCode, string sectionCode, string user) { var executeCommand = Db.Insertable(new MesInvItemStocks { TaskNo = barcodeInfo.TaskNo, ItemBarcode = barcodeInfo.ItemBarcode, ItemNo = barcodeInfo.ItemNo, LotNo = barcodeInfo.LotNo, Quantity = barcodeInfo.Quantity, EpFlag = barcodeInfo.EpFlag, DepotsCode = depotCode, DepotSectionsCode = sectionCode, CheckDate = barcodeInfo.CreateDate, IndepDate = barcodeInfo.CreateDate, Factory = Factory, Company = Company, BoardStyle = barcodeInfo.BoardStyle, WorkNo = barcodeInfo.WorkNo, WorkLine = barcodeInfo.WorkLine, SuppNo = barcodeInfo.SuppNo }).ExecuteCommand(); if (executeCommand <= 0) { throw new Exception("åå ¥å¤±è´¥"); } } private void InsertBusinessRecord(MesInvItemBarcodes barcodeInfo, string depotCode, string sectionCode, string billNo, string user) { // Insert business record var executeCommand = Db.Insertable(new MesInvBusiness2 { Status = 1, BillTypeId = 100, TransactionCode = "601", BusinessType = 1, ItemBarcode = barcodeInfo.ItemBarcode, ItemNo = barcodeInfo.ItemNo, LotNo = barcodeInfo.LotNo, EpFlag = 1, Quantity = barcodeInfo.Quantity, ToInvDepotsCode = depotCode, ToInvDepotSectionsCode = sectionCode, CreateBy = user, CreateDate = DateTime.Now, LastupdateBy = user, LastupdateDate = DateTime.Now, Factory = Factory, Company = Company, TaskNo = barcodeInfo.TaskNo, BillNo = billNo, WorkNo = barcodeInfo.WorkNo, WorkLine = barcodeInfo.WorkLine, SuppNo = barcodeInfo.SuppNo }).ExecuteCommand(); if (executeCommand <= 0) { throw new Exception("åå ¥å¤±è´¥"); } } } MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,184 @@ 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 MesDepotSectionsController : ControllerBase { private readonly MesDepotSectionsManager m = new(); /***è¿å ¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ //GetSectionName [HttpPost("GetSectionName")] public ResponseResult GetSectionName(WarehouseQuery query) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetSectionName(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] MesDepotSections 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] MesDepotSections 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] MesDepotSections 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/MesInvBusiness2Controller.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,170 @@ 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 MES.Service.Modes; using MES.Service.service; using MES.Service.service.Warehouse; using MES.Service.util; namespace MESApplication.Controllers.Warehouse { [ApiController] [Route("api/[controller]")] public class MesInvBusiness2Controller : ControllerBase { private MesInvBusiness2Manager m = new MesInvBusiness2Manager(); /***è¿å ¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ /// <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] 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/OpeningReceiptController.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,34 @@ using System.Dynamic; using MES.Service.Dto.service; using MES.Service.service.Warehouse; using MES.Service.util; using Microsoft.AspNetCore.Mvc; namespace MESApplication.Controllers.Warehouse; [ApiController] [Route("api/[controller]")] public class OpeningReceiptController : ControllerBase { private readonly OpeningReceiptServer m = new(); [HttpPost("ScanInBarcodeQC")] public ResponseResult ScanInBarcodeQC(WarehouseQuery query) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.ScanInBarcodeQC(query); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } } MESApplication/bin/Debug/net8.0/MES.Service.dllBinary files differ
MESApplication/bin/Debug/net8.0/MES.Service.pdbBinary files differ
MESApplication/bin/Debug/net8.0/MESApplication.dllBinary files differ
MESApplication/bin/Debug/net8.0/MESApplication.exeBinary files differ
MESApplication/bin/Debug/net8.0/MESApplication.pdbBinary files differ
MESApplication/bin/Release/net8.0/MES.Service.dllBinary files differ
MESApplication/bin/Release/net8.0/MES.Service.pdbBinary files differ
MESApplication/bin/Release/net8.0/MESApplication.dllBinary files differ
MESApplication/bin/Release/net8.0/MESApplication.exeBinary files differ
MESApplication/bin/Release/net8.0/MESApplication.pdbBinary files differ
MESApplication/bin/Release/net8.0/publish/MES.Service.dllBinary files differ
MESApplication/bin/Release/net8.0/publish/MES.Service.pdbBinary files differ
MESApplication/bin/Release/net8.0/publish/MESApplication.dllBinary files differ
MESApplication/bin/Release/net8.0/publish/MESApplication.exeBinary files differ
MESApplication/bin/Release/net8.0/publish/MESApplication.pdbBinary files differ
