MES.Service/DB/OracleSQLHelper.cs
@@ -9,10 +9,11 @@ /// </summary> public class OracleSQLHelper { public readonly string ConnectionString =AppsettingsUtility.Settings.DataBaseConn; private readonly string _connectionString; public readonly string ConnectionString = AppsettingsUtility.Settings.DataBaseConn; //public static string connectionString = "Data Source = 192.168.1.19; Persist Security Info=True;User ID = abtdev; Password=abt_dev"; public string connectionString = "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd"; // è¿éæ¿æ¢æä½ çå®é è¿æ¥å符串 MES.Service/DB/SqlSugarHelper.cs
@@ -5,7 +5,8 @@ public class SqlSugarHelper { private static readonly string _connectionString =AppsettingsUtility.Settings.DataBaseConn; // è¿éæ¿æ¢æä½ çå®é è¿æ¥å符串 private static readonly string _connectionString = AppsettingsUtility.Settings.DataBaseConn; // è¿éæ¿æ¢æä½ çå®é è¿æ¥å符串 public static SqlSugarClient GetInstance() { MES.Service/Dto/service/OutItemDto.cs
@@ -4,7 +4,14 @@ public class OutItemDto { public MesInvItemOuts Form { get; set; } public List<MesInvItemOutItems> SaveItems { get; set; } public List<MESInvItemOutItems> SelectItems { get; set; } public MesInvItemOuts? Form { get; set; } public List<MesInvItemOutItems>? SaveItems { get; set; } public List<MESInvItemOutItems>? SelectItems { get; set; } public string? ItemNo { get; set; } public decimal? Quantity { get; set; } public List<InventoryItem>? SumItem { 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/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/MesInvItemOutCDetails.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,242 @@ using SqlSugar; namespace MES.Service.Modes; /// <summary> /// ç©æåºåºæ¡ç æç» /// </summary> [SugarTable("MES_INV_ITEM_OUT_C_DETAILS")] public class MesInvItemOutCDetails { /// <summary> /// SEQ_INV_ID /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// åºåºåid /// </summary> [SugarColumn(ColumnName = "ITEM_OUT_ID")] public decimal? ItemOutId { get; set; } /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// 客æ·ç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } /// <summary> /// æ¬å¸ç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// å家æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ°éï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// æªææ å¿ï¼0ï¼å¦ï¼1ï¼æ¯ï¼ /// </summary> [SugarColumn(ColumnName = "FORCE_OUT_FLAG")] public decimal? ForceOutFlag { 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 = "CUST_NO")] public string CustNo { get; set; } /// <summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// è´§ä½ç¼ç /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] public string DepotSectionCode { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } /// <summary> /// å æ£æ è¯(0-å¦ï¼1-æ¯) /// </summary> [SugarColumn(ColumnName = "FORCE_EXEMPT_FLAG")] public short? ForceExemptFlag { get; set; } /// <summary> /// æææ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "PRD_LOT_NO")] public string PrdLotNo { get; set; } /// <summary> /// æ¯å¦åæ¥æ¶æ£æ¥ /// </summary> [SugarColumn(ColumnName = "CHECK_STATUS")] public short? CheckStatus { 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 = "TASK_NOY")] public string TaskNoy { get; set; } /// <summary> /// ç®±å· /// </summary> [SugarColumn(ColumnName = "BOX_NO")] public string BoxNo { get; set; } /// <summary> /// å è£ æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "TASK_PACK")] public string TaskPack { get; set; } /// <summary> /// å¡æ¿ /// </summary> [SugarColumn(ColumnName = "KB_NO")] public string KbNo { get; set; } /// <summary> /// 产åæºå /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// ç产工å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ä¾åºåç¼å· /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// é¢æåå·/å§å¤è®¢å /// </summary> [SugarColumn(ColumnName = "PBILL_NO")] public string PbillNo { get; set; } /// <summary> /// æ¥æ¶æ è¯/1å·²æ¥æ¶ /// </summary> [SugarColumn(ColumnName = "RECEIVE")] public decimal? Receive { get; set; } /// <summary> /// æ¥æ¶æ¶é´ /// </summary> [SugarColumn(ColumnName = "RTIME")] public DateTime? Rtime { get; set; } /// <summary> /// æ¥æ¶äºº /// </summary> [SugarColumn(ColumnName = "RCV_BY")] public string RcvBy { get; set; } /// <summary> /// æ¥æ¶è½¦é´ /// </summary> [SugarColumn(ColumnName = "RCV_PART")] public string RcvPart { get; set; } /// <summary> /// å ¥åºåå· /// </summary> [SugarColumn(ColumnName = "RK_NO")] public string RkNo { 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; } [SugarColumn(IsIgnore = true)] public string? DepotName { get; set; } [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; } [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; } [SugarColumn(IsIgnore = true)] public string? Unit { get; set; } } MES.Service/Modes/MesInvItemStocks.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,201 @@ using SqlSugar; namespace MES.Service.Modes; /// <summary> /// ç©æåºå表 /// </summary> [SugarTable("MES_INV_ITEM_STOCKS")] public class MesInvItemStocks { /// <summary> /// </summary> [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> /// ç产订å /// </summary> [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } /// <summary> /// ç©ææ¡ç /// </summary> [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } /// <summary> /// 客æ·ç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } /// <summary> /// æ¬å¸ç©æç¼ç ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½åæ®µï¼ /// </summary> [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } /// <summary> /// ååºid /// </summary> [SugarColumn(ColumnName = "DEPOTS_ID")] public decimal? DepotsId { get; set; } /// <summary> /// è´§ä½id /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")] public decimal? DepotSectionsId { get; set; } /// <summary> /// å家æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } /// <summary> /// æ°é /// </summary> [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } /// <summary> /// ç¯ä¿æ å¿ï¼æ æ¡ç æå·¥å½å ¥ï¼ææ¡ç 为åä½å段ï¼(0-å¦ï¼1-æ¯) /// </summary> [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } /// <summary> /// 客æ·ç¼ç /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NO")] public string CustomerNo { get; set; } /// <summary> /// éé /// </summary> [SugarColumn(ColumnName = "ITEM_WT")] public decimal? ItemWt { get; set; } /// <summary> /// ååºCODE /// </summary> [SugarColumn(ColumnName = "DEPOTS_CODE")] public string DepotsCode { get; set; } /// <summary> /// è´§ä½CODE /// </summary> [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")] public string DepotSectionsCode { get; set; } /// <summary> /// æ£éªæ¥æ /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// <summary> /// 0 ç©æ 1 åæå 2 æå /// </summary> [SugarColumn(ColumnName = "ITEM_TYPE")] public short? ItemType { get; set; } /// <summary> /// å ¥åºæ¥æ /// </summary> [SugarColumn(ColumnName = "INDEP_DATE")] public DateTime? IndepDate { 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 = "IQC_STATUS")] public string IqcStatus { get; set; } /// <summary> /// å°è½¦æ¡ç /// </summary> [SugarColumn(ColumnName = "FCAR")] public string Fcar { get; set; } /// <summary> /// å»ç»æ交éæ£ï¼0ï¼å»ç»æªæ交éæ£ï¼1ï¼å»ç»å¹¶æ交éæ£ /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT")] public short? VisableSubmit { get; set; } /// <summary> /// æ交éæ£äºº /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")] public string VisableSubmitBy { get; set; } /// <summary> /// æ交éæ£æ¶é´ /// </summary> [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")] public DateTime? VisableSubmitDate { get; set; } /// <summary> /// 产ååå· /// </summary> [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } /// <summary> /// ä»»å¡åå· /// </summary> [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } /// <summary> /// ä»»å¡åè¡å· /// </summary> [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } /// <summary> /// ä¾åºå /// </summary> [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } /// <summary> /// ç产线 /// </summary> [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } /// <summary> /// åæåå ¥åºåå· /// </summary> [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { 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/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/MessageCenter.cs
@@ -111,6 +111,13 @@ [SugarColumn(ColumnName = "Content_Type")] public string? ContentType { get; set; } // /// <summary> /// æ¯å¦æ¯æ¶æ¯ 0为æ¨é失败 1为æ¶æ¯,é»è®¤ä¸º0 /// </summary> [SugarColumn(ColumnName = "is_message")] public short? IsMessage { get; set; } [SugarColumn(IsIgnore = true)] public int? isShow { get; set; }
@@ -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/GetErpParametersServer.cs
@@ -54,6 +54,8 @@ centers.Add(messageCenter); break; default: throw new Exception("æ æ³è¯å«TableNameç±»å"); } MES.Service/service/Warehouse/MesInvItemInCDetailsManager.cs
@@ -1,10 +1,8 @@ using System.Data; using MES.Service.DB; using MES.Service.Dto.@base; using MES.Service.Dto.service; using MES.Service.Modes; using MES.Service.util; using Microsoft.Extensions.Options; using Newtonsoft.Json; using SqlSugar; using DbType = System.Data.DbType; @@ -49,7 +47,7 @@ base.GetSingle(it => it.ItemBarcode == entity.barcode); if (mesInvItemInCDetails == null) throw new Exception("åºç°å¼å¸¸"); // æåºå¼å¸¸ä»¥ä¾åå°å¤ç throw new Exception("ç©æå ¥åºæ¡ç æç»ä¸åå¨"); // æåºå¼å¸¸ä»¥ä¾åå°å¤ç var itemInId = mesInvItemInCDetails.ItemInId; entity.id = itemInId; @@ -145,7 +143,7 @@ return result; } public MessageCenter MesToErpParam(WarehouseQuery query) { var erpParameters = ""; @@ -162,7 +160,7 @@ title = "éè´å ¥åºå" + query.billNo + "åå®¡æ ¸"; } string ErpUrl = AppsettingsUtility.Settings.TestErpUrl; var ErpUrl = AppsettingsUtility.Settings.ProductionErpUrl; var message = new MessageCenter { TableName = tableName, @@ -177,6 +175,7 @@ Method = "POST", Seq = 1, Data = erpParameters, IsMessage = 0, ContentType = "application/x-www-form-urlencoded" }; return message; MES.Service/service/Warehouse/MesInvItemOutCDetailsManager.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,78 @@ using MES.Service.DB; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service.Warehouse; public class MesInvItemOutCDetailsManager : Repository<MesInvItemOutCDetails> { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,å¦æè¦éæ°çæ请å é¤ MesInvItemOutCDetailsManager.cs #region æå¦æ¹æ³ /// <summary> /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ /// </summary> public void Study() { /*********æ¥è¯¢*********/ var data1 = base.GetById(1); //æ ¹æ®IDæ¥è¯¢ var data2 = base.GetList(); //æ¥è¯¢ææ var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,å¦æè¶ è¿ä¸æ¡ä¼æ¥é var p = new PageModel { PageIndex = 1, PageSize = 2 }; // å页æ¥è¯¢ var data5 = base.GetPageList(it => 1 == 1, p); Console.Write(p.TotalCount); //è¿åæ»æ° var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom()); // å页æ¥è¯¢å æåº Console.Write(p.TotalCount); //è¿åæ»æ° var conModels = new List<IConditionalModel>(); //ç»è£ æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº conModels.Add(new ConditionalModel { FieldName = typeof(MesInvItemOutCDetails).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" }); //id=1 var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); AsQueryable().Where(x => 1 == 1) .ToList(); //æ¯æäºè½¬æ¢æqueryable,æ们å¯ä»¥ç¨queryableå®ç°å¤æåè½ /*********æå ¥*********/ var insertData = new MesInvItemOutCDetails(); //æµè¯åæ° var insertArray = new[] { insertData }; base.Insert(insertData); //æå ¥ base.InsertRange(insertArray); //æ¹éæå ¥ var id = base.InsertReturnIdentity(insertData); //æå ¥è¿åèªå¢å AsInsertable(insertData).ExecuteCommand(); //æ们å¯ä»¥è½¬æ Insertableå®ç°å¤ææå ¥ /*********æ´æ°*********/ var updateData = new MesInvItemOutCDetails(); //æµè¯åæ° var updateArray = new[] { updateData }; //æµè¯åæ° base.Update(updateData); //æ ¹æ®å®ä½æ´æ° base.UpdateRange(updateArray); //æ¹éæ´æ° //base.Update(it => new MesInvItemOutCDetails() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å ¶å®åä¸æ´æ°ï¼æ¡ä»¶id=1 AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå ¥ /*********å é¤*********/ var deldata = new MesInvItemOutCDetails(); //æµè¯åæ° base.Delete(deldata); //æ ¹æ®å®ä½å é¤ base.DeleteById(1); //æ ¹æ®ä¸»é®å é¤ base.DeleteById(new[] { 1, 2 }); //æ ¹æ®ä¸»é®æ°ç»å é¤ base.Delete(it => 1 == 2); //æ ¹æ®æ¡ä»¶å é¤ AsDeleteable().Where(it => 1 == 2) .ExecuteCommand(); //转æDeleteableå®ç°å¤æçæä½ } #endregion } MES.Service/service/Warehouse/MesInvItemOutsManager.cs
@@ -1,7 +1,10 @@ using MES.Service.DB; using System.Data; using MES.Service.DB; using MES.Service.Dto.service; using MES.Service.Modes; using MES.Service.util; using SqlSugar; using DbType = System.Data.DbType; namespace MES.Service.service.Warehouse; @@ -10,16 +13,190 @@ //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,å¦æè¦éæ°çæ请å é¤ MesInvItemOutsManager.cs public bool ScanCode(WarehouseQuery query) { decimal billTypeId = 200; decimal transactionNo = 203; var count = Db.Queryable<MesInvItemOutCDetails>() .Where(a => a.ItemBarcode == query.barcode && a.TaskNo == query.billNo) .Count(); if (count > 0) throw new Exception("æ¡ç éå¤æ«æï¼è¯·æ ¸å¯¹ï¼"); //éªè¯æ¡ç var mesInvItemStocks = Db.Queryable<MesInvItemStocks>() .Where(a => a.ItemBarcode == query.barcode && a.Quantity > 0).Single(); if (mesInvItemStocks == null) throw new Exception(query.barcode + "åºåä¸æ æ¤æ¡ç ï¼è¯·æ ¸å¯¹ï¼"); //éªè¯åºåºåmes_inv_item_outs var mesInvItemOuts = Db.Queryable<MesInvItemOuts>() .Where(d => d.ItemOutNo == query.billNo && d.BillTypeId == billTypeId && d.TransactionNo == transactionNo).Single(); //åºåºåçæ ¡éª if (mesInvItemOuts == null) throw new Exception("åºåºå " + query.billNo + " ä¸åå¨ï¼è¯·ç¡®è®¤ï¼"); //æªå®¡æ ¸çä¸å è®¸ç»§ç» if (mesInvItemOuts.Status == null || mesInvItemOuts.Status == 0) throw new Exception("åºåºå " + query.billNo + "æªå®¡æ ¸"); //å·²æ¨éçä¸å è®¸ç»§ç» if (mesInvItemOuts.Nflag == 1) throw new Exception("åºåºå " + query.billNo + "å·²ç»æ¨éï¼æ æ³éå¤æ¨é"); var depotCodeOut = mesInvItemOuts.DepotCode ?? "0"; var depotsCodeStock = mesInvItemStocks.DepotsCode ?? "0"; if (!depotCodeOut.Equals(depotsCodeStock)) { // å建é误æ¶æ¯ var errorMessage = $"002[æ¡ç ä»åº{depotsCodeStock}ä¸ç³è¯·ä»åº{depotCodeOut}ä¸ä¸è´ï¼è¯·æ ¸å¯¹ï¼"; throw new Exception(errorMessage); } var StocksNum = mesInvItemStocks.Quantity; var sql = string.Format( @"select nvl(SUM(S.QUANTITY),0) - nvl(SUM(S.TL_QTY),0) from MES_INV_ITEM_OUT_ITEMS S LEFT JOIN mes_inv_item_outs d ON S.ITEM_OUT_ID = D.ID where d.item_out_no = '{0}' and d.bill_type_id = {1} and d.transaction_no = {2} AND S.item_no = '{3}' and nvl(d.status, 0) = 1 and nvl(d.nflag, 0) = 0", query.billNo, billTypeId, transactionNo, mesInvItemStocks.ItemNo); var cqty = Db.Ado.SqlQuerySingle<decimal>(sql); if (cqty == null) throw new Exception("ç©æ" + mesInvItemStocks.ItemNo + "çè¾ å©å±æ§ä¸æ¡ç ä¸ä¸è´ï¼è¯·æ£æ¥"); if (cqty < StocksNum) throw new Exception("请确认åææ°é"); //è°ç¨åå¨è¿ç¨ try { // å®ä¹è¾åºåæ° var outputResult = new SugarParameter("C_RESULT", null, DbType.Int32, ParameterDirection.Output, 4000); var outputMessage = new SugarParameter("MSG", null, DbType.String, ParameterDirection.Output, 4000); // å®ä¹è¾å ¥åæ° var parameters = new List<SugarParameter> { new("p_item_barcode", query.barcode, DbType.String, ParameterDirection.Input), new("p_bill_no", query.billNo, DbType.String, ParameterDirection.Input), new("pi_factory", "1000", DbType.String, ParameterDirection.Input), new("pi_company", "1000", DbType.String, ParameterDirection.Input), new("c_user", query.userName, DbType.String, ParameterDirection.Input), outputResult, outputMessage }; // ä½¿ç¨ SqlSugar æ§è¡åå¨è¿ç¨ Db.Ado.ExecuteCommand( "BEGIN MES_CG_UPDATE_BARCODES(:p_item_barcode, :p_bill_no, :pi_factory, :pi_company, :c_user, :C_RESULT, :MSG); END;", parameters.ToArray()); // è·åè¾åºåæ°çå¼ var resultValue = outputResult.Value?.ToString(); var messageValue = outputMessage.Value?.ToString(); if ("1".Equals(resultValue)) throw new Exception("æ¡ç æ£é¤å¤±è´¥"); } catch (Exception ex) { throw new Exception(ex.Message); } // åéç¨äºä¿åæ¥è¯¢ç»æ decimal? C_SQ_QTY = 0; decimal? C_OK_QTY = 0; var c_result = string.Empty; var C_COUNT = 0; sql = string.Format(@" SELECT SUM(C.QUANTITY) AS SQ_QTY, SUM(D.QUANTITY_OK) AS OK_QTY FROM MES_INV_ITEM_OUT_ITEMS C LEFT JOIN ( SELECT ITEM_OUT_ID, ITEM_NO, PBILL_NO, RK_NO, SUM(QUANTITY) AS QUANTITY_OK FROM MES_INV_ITEM_OUT_C_DETAILS GROUP BY ITEM_OUT_ID, ITEM_NO, PBILL_NO, RK_NO ) D ON D.ITEM_OUT_ID = C.ITEM_OUT_ID AND D.ITEM_NO = C.ITEM_NO AND D.RK_NO = C.RK_NO AND NVL(C.PBILL_NO, '0') = NVL(D.PBILL_NO, '0') WHERE C.ITEM_OUT_ID = {0}", mesInvItemOuts.Id); var queryResult = Db.Ado.SqlQuerySingle<dynamic>(sql); C_SQ_QTY = queryResult?.SQ_QTY; C_OK_QTY = queryResult?.OK_QTY; // å¤æé»è¾ if (C_SQ_QTY < C_OK_QTY) throw new Exception("æ«ææ°éè¶ è¿ç³è¯·æ°é,请éæ°æ«æï¼"); if (C_SQ_QTY == C_OK_QTY) return true; return false; } public bool Audit(WarehouseQuery query) { // å®¡æ ¸åæ ¡éª Validate(query); query.status = 1; //å®¡æ ¸ return Update(query); } public bool SetNFlag(WarehouseQuery query) { return Db.Updateable<MesInvItemOuts>() .SetColumns(s => s.Status == 1) .SetColumns(s => s.CheckUser == query.userName) .SetColumns(s => s.Nflag == 1) .Where(s => s.ItemOutNo == query.billNo) .ExecuteCommand() > 0; } public bool DeApprove(WarehouseQuery query) { query.date = null; query.status = 0; return Update(query); } private bool Update(WarehouseQuery entity) { return Db.Updateable<MesInvItemOuts>() .SetColumns(s => s.Status == entity.status) .SetColumns(s => s.CheckUser == entity.userName) .SetColumns(s => s.CheckDate == DateTime.Now) .Where(s => s.Id == query.id).ExecuteCommand() > 0; .Where(s => s.Id == entity.id).ExecuteCommand() > 0; } @@ -218,6 +395,8 @@ a.CheckUser == u3.Fcode)) .WhereIF(query.id > 0, (a, e, i, u1, u3) => a.Id == query.id) .WhereIF(!string.IsNullOrEmpty(query.billNo), (a, e, i, u1, u3) => a.ItemOutNo == query.billNo) .Select((a, e, i, u1, u3) => new MesInvItemOuts { Id = a.Id, @@ -240,6 +419,35 @@ Status = a.Status, ItemOutNo = a.ItemOutNo }).ToPageList(query.PageIndex, query.Limit); } public List<MesInvItemOutCDetails> GetScanBarcode(WarehouseQuery query) { return Db.Queryable<MesInvItemOutCDetails, MesInvItemBarcodes, MesItems, MesDepots>( (b, bar, c, d) => new JoinQueryInfos( JoinType.Left, b.ItemBarcode == bar.ItemBarcode, JoinType.Left, b.ItemNo == c.ItemNo && b.Company == c.Company && b.Factory == c.Factory, JoinType.Left, b.DepotCode == d.DepotCode && b.Company == d.Company && b.Factory == d.Factory )) .Where((b, bar, c, d) => b.ItemOutId == query.id) .Select((b, bar, c, d) => new MesInvItemOutCDetails { Quantity = b.Quantity, DepotSectionCode = b.DepotSectionCode, DepotCode = b.DepotCode, ItemNo = b.ItemNo, ItemBarcode = b.ItemBarcode, ItemName = c.ItemName, ItemModel = c.ItemModel, DepotName = d.DepotName, Unit = bar.Unit }).ToList(); } //MESInvItemOutItems @@ -280,8 +488,11 @@ return results; } public List<InventoryItem> GetSumItem(WarehouseQuery query) public OutItemDto GetSumItem(WarehouseQuery query) { var mesInvItemOuts = base.GetSingle(it => it.ItemOutNo == query.billNo); if (mesInvItemOuts == null) throw new Exception("éè´éè´§åä¸åå¨"); var sql = string.Format(@"SELECT DEPOT ,ITEM_NO,ITEM_MODEL, ITEM_NAME,QTY FROM (SELECT SUM(QTY) QTY, DEPOT, ITEM_NO, ITEM_MODEL, ITEM_NAME FROM (SELECT f_get_section_code2('1000', '1000', b.ITEM_NO,'{0}') DEPOT, @@ -300,11 +511,25 @@ AND nvl(b.QUANTITY, 0) - nvl(D.QUANTITY_OK, 0) > 0 ORDER BY f_get_section_code2('1000','1000',b.ITEM_NO,'{0}'), A.ITEM_MODEL,A.ITEM_NAME) GROUP BY DEPOT, ITEM_NO, ITEM_MODEL, ITEM_NAME)", query.DepotCode, query.id); GROUP BY DEPOT, ITEM_NO, ITEM_MODEL, ITEM_NAME)", mesInvItemOuts.DepotCode, mesInvItemOuts.Id); var results = Db.Ado.SqlQuery<InventoryItem>(sql); return results; var mesInvItemStocks = Db.Queryable<MesInvItemStocks>() .Where(a => a.ItemBarcode == query.barcode).Single(); var dto = new OutItemDto(); dto.SumItem = results; if (mesInvItemStocks != null) { dto.ItemNo = mesInvItemStocks.ItemNo; dto.Quantity = mesInvItemStocks.Quantity; } return dto; } public List<InventoryItemDetail> SelectMaterials(WarehouseQuery query) @@ -369,4 +594,112 @@ return "NTL" + date + number; } public MessageCenter SaveMessageCenter(WarehouseQuery query) { var message = MesToErpParam(query); var executeReturnIdentity = Db.Insertable(message).ExecuteReturnIdentity(); if (executeReturnIdentity > 0) { message.Id = executeReturnIdentity; message.Pid = executeReturnIdentity; return message; } throw new Exception("è·åæ°æ®å¤±è´¥"); } public MessageCenter MesToErpParam(WarehouseQuery query) { var erpParameters = ""; var title = ""; var tableName = "MES_INV_ITEM_OUTS_" + query.Type; if ("A".Equals(query.Type)) { erpParameters = GetErpParameters(query.billNo); title = "éè´éè´§å" + query.billNo + "å®¡æ ¸"; } else if ("B".Equals(query.Type)) { erpParameters = GetDeApprovePam(query.id); title = "éè´éè´§å" + query.billNo + "åå®¡æ ¸"; } var ErpUrl = AppsettingsUtility.Settings.ProductionErpUrl; var message = new MessageCenter { TableName = tableName, Url = ErpUrl, Status = 1, CreateBy = query.userName, Route = query.billNo, Title = title, PageName = "Warehouse/PurchaseReturn/Add?id=" + query.id + "&itemOutNo=" + query.billNo, CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"), Method = "POST", Seq = 1, Data = erpParameters, IsMessage = 0, ContentType = "application/x-www-form-urlencoded" }; return message; } public bool DeApproveBefore(WarehouseQuery query) { var mesInvItemOuts = base.GetById(query.id); if (mesInvItemOuts == null) throw new Exception("åºåºåä¸åå¨"); var nflag = mesInvItemOuts.Nflag ?? 0; if (nflag != 0) return true; return false; } private string GetDeApprovePam(decimal? id) { var sid = (int)id; var encodedUrl = "taskname=CGTL&mesid=" + sid + "&optype=delete&datajson={}"; return encodedUrl; } private string GetErpParameters(string? billNo) { var invItemIns = Db.Queryable<MesInvItemOuts>() .Single(x => x.ItemOutNo == billNo); //è°ç¨functionå½æ° var sql = $"SELECT F_GENERATE_DATA_INSERTED('{billNo}') FROM DUAL;"; var jsonString = Db.Ado.SqlQuerySingle<string>(sql); var encodedUrl = "taskname=CGTL&mesid=" + invItemIns.Id + "&optype=create&datajson=" + jsonString; return encodedUrl; } public List<string> GetItemOutNo() { var data5 = Db.Queryable<MesInvItemOuts>().Where(it => it.BillTypeId == 200 && it.TransactionNo == 203 && it.Status == 1) .OrderBy(it => it.Id, OrderByType.Desc) .ToPageList(1, 20); var ItemOutNos = data5.FindAll(a => a.Nflag == null || a.Nflag == 0) .Select(s => s.ItemOutNo).ToList(); // // var ItemOutNos = data5 // .Select(s => s.ItemOutNo).ToList(); return ItemOutNos; } } MES.Service/service/Warehouse/MesInvItemStocksManager.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,78 @@ using MES.Service.DB; using MES.Service.Modes; using SqlSugar; namespace MES.Service.service.Warehouse; public class MesInvItemStocksManager : Repository<MesInvItemStocks> { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,å¦æè¦éæ°çæ请å é¤ MesInvItemStocksManager.cs #region æå¦æ¹æ³ /// <summary> /// ä»å¨æ¹æ³æ»¡è¶³ä¸äºå¤æä¸å¡éæ±ï¼ä¸å¡ä»£ç 请å¨è¿éé¢å®ä¹æ¹æ³ /// </summary> public void Study() { /*********æ¥è¯¢*********/ var data1 = base.GetById(1); //æ ¹æ®IDæ¥è¯¢ var data2 = base.GetList(); //æ¥è¯¢ææ var data3 = base.GetList(it => 1 == 1); //æ ¹æ®æ¡ä»¶æ¥è¯¢ //var data4 = base.GetSingle(it => 1 == 1);//æ ¹æ®æ¡ä»¶æ¥è¯¢ä¸æ¡,å¦æè¶ è¿ä¸æ¡ä¼æ¥é var p = new PageModel { PageIndex = 1, PageSize = 2 }; // å页æ¥è¯¢ var data5 = base.GetPageList(it => 1 == 1, p); Console.Write(p.TotalCount); //è¿åæ»æ° var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom()); // å页æ¥è¯¢å æåº Console.Write(p.TotalCount); //è¿åæ»æ° var conModels = new List<IConditionalModel>(); //ç»è£ æ¡ä»¶æ¥è¯¢ä½ä¸ºæ¡ä»¶å®ç° å页æ¥è¯¢å æåº conModels.Add(new ConditionalModel { FieldName = typeof(MesInvItemStocks).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" }); //id=1 var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); AsQueryable().Where(x => 1 == 1) .ToList(); //æ¯æäºè½¬æ¢æqueryable,æ们å¯ä»¥ç¨queryableå®ç°å¤æåè½ /*********æå ¥*********/ var insertData = new MesInvItemStocks(); //æµè¯åæ° var insertArray = new[] { insertData }; base.Insert(insertData); //æå ¥ base.InsertRange(insertArray); //æ¹éæå ¥ var id = base.InsertReturnIdentity(insertData); //æå ¥è¿åèªå¢å AsInsertable(insertData).ExecuteCommand(); //æ们å¯ä»¥è½¬æ Insertableå®ç°å¤ææå ¥ /*********æ´æ°*********/ var updateData = new MesInvItemStocks(); //æµè¯åæ° var updateArray = new[] { updateData }; //æµè¯åæ° base.Update(updateData); //æ ¹æ®å®ä½æ´æ° base.UpdateRange(updateArray); //æ¹éæ´æ° //base.Update(it => new MesInvItemStocks() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// åªæ´æ°ClassNameååCreateTimeåï¼å ¶å®åä¸æ´æ°ï¼æ¡ä»¶id=1 AsUpdateable(updateData).ExecuteCommand(); //转æUpdateableå¯ä»¥å®ç°å¤æçæå ¥ /*********å é¤*********/ var deldata = new MesInvItemStocks(); //æµè¯åæ° base.Delete(deldata); //æ ¹æ®å®ä½å é¤ base.DeleteById(1); //æ ¹æ®ä¸»é®å é¤ base.DeleteById(new[] { 1, 2 }); //æ ¹æ®ä¸»é®æ°ç»å é¤ base.Delete(it => 1 == 2); //æ ¹æ®æ¡ä»¶å é¤ AsDeleteable().Where(it => 1 == 2) .ExecuteCommand(); //转æDeleteableå®ç°å¤æçæä½ } #endregion } MES.Service/service/WomcaaManager.cs
@@ -2,8 +2,6 @@ using MES.Service.Dto.webApi; using MES.Service.Modes; using SqlSugar; using System; using System.Security.Cryptography; namespace MES.Service.service; @@ -76,8 +74,7 @@ private Womcaa MapErpCAAtoWomcaa(ErpCAA dto) { var entity = new Womcaa var entity = new Womcaa { Erpid = Convert.ToDecimal(dto.Id), Caa001 = dto.FBillNo, @@ -161,7 +158,8 @@ Eid = Convert.ToDecimal(dto.PID) }; var entity = Db.Queryable<Womcab>().Where(s => s.Erpid == womcab.Erpid).Single(); var entity = Db.Queryable<Womcab>() .Where(s => s.Erpid == womcab.Erpid).Single(); if (entity != null) womcab.Id = entity.Id; womcabList.Add(womcab); MES.Service/util/AppsettingsUtility.cs
@@ -5,20 +5,15 @@ public class AppsettingsUtility { private static AppSettings _appSettings; public static AppSettings Settings { get { return _appSettings; } } public static AppSettings Settings { get; private set; } public void Initial(IConfiguration configuration) { AppSettings myOwn = new AppSettings(); var myOwn = new AppSettings(); //注æï¼å¯ä»¥ä½¿ç¨åå·æ¥è·åå å±çé 置项 myOwn.TestErpUrl = configuration["AppSettings:TestErpUrl"]; myOwn.ProductionErpUrl = configuration["AppSettings:ProductionErpUrl"]; myOwn.DataBaseConn = configuration["AppSettings:DataBaseConn"]; _appSettings = myOwn; Settings = myOwn; } } MESApplication/Controllers/Warehouse/MesInvItemOutCDetailsController.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,163 @@ using System.Dynamic; using MES.Service.Modes; using MES.Service.service.Warehouse; using MES.Service.util; using Microsoft.AspNetCore.Mvc; namespace MESApplication.Controllers.Warehouse; [ApiController] [Route("api/[controller]")] public class MesInvItemOutCDetailsController : ControllerBase { private readonly MesInvItemOutCDetailsManager m = new(); /***è¿å ¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ /// <summary> /// è·åææ /// </summary> /// <returns></returns> [HttpPost("GetList")] public ResponseResult GetList() { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetList(); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®è·å /// </summary> /// <returns></returns> [HttpPost("GetById")] public ResponseResult GetById(int id) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetById(id); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®å é¤ /// </summary> /// <returns></returns> [HttpPost("DeleteByIds")] public ResponseResult DeleteByIds([FromBody] object[] ids) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.DeleteByIds(ids); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å /// </summary> /// <returns></returns> [HttpPost("Insert")] public ResponseResult Add([FromBody] MesInvItemOutCDetails 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] MesInvItemOutCDetails 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] MesInvItemOutCDetails 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/MesInvItemOutsController.cs
@@ -13,6 +13,89 @@ { private readonly MesInvItemOutsManager m = new(); [HttpPost("ScanCode")] public ResponseResult ScanCode(WarehouseQuery entity) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.ScanCode(entity); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } [HttpPost("GetScanBarcode")] public ResponseResult GetScanBarcode(WarehouseQuery entity) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetScanBarcode(entity); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } [HttpPost("SaveMessageCenter")] public ResponseResult SaveMessageCenter(WarehouseQuery entity) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.SaveMessageCenter(entity); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //GetItemOutNo [HttpPost("GetItemOutNo")] public ResponseResult GetItemOutNo() { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetItemOutNo(); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //Audit [HttpPost("Audit")] public ResponseResult Audit(WarehouseQuery query) @@ -34,6 +117,68 @@ } } //SetNFlag [HttpPost("SetNFlag")] public ResponseResult SetNFlag(WarehouseQuery query) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.SetNFlag(query); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //DeApproveBefore [HttpPost("DeApproveBefore")] public ResponseResult DeApproveBefore(WarehouseQuery entity) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.DeApproveBefore(entity); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } [HttpPost("DeApprove")] public ResponseResult DeApprove(WarehouseQuery entity) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.DeApprove(entity); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } //SaveCombination [HttpPost("SaveCombination")] public ResponseResult SaveCombination(OutItemDto dto) MESApplication/Controllers/Warehouse/MesInvItemStocksController.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,162 @@ using System.Dynamic; using MES.Service.Modes; using MES.Service.service.Warehouse; using MES.Service.util; using Microsoft.AspNetCore.Mvc; namespace MESApplication.Controllers.Warehouse; [ApiController] [Route("api/[controller]")] public class MesInvItemStocksController : ControllerBase { private readonly MesInvItemStocksManager m = new(); /***è¿å ¥æ¨¡ç管çå¯ä»¥ä¿®æ¹æ¨¡ç***/ /// <summary> /// è·åææ /// </summary> /// <returns></returns> [HttpPost("GetList")] public ResponseResult GetList() { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetList(); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®è·å /// </summary> /// <returns></returns> [HttpPost("GetById")] public ResponseResult GetById(int id) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.GetById(id); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ ¹æ®ä¸»é®å é¤ /// </summary> /// <returns></returns> [HttpPost("DeleteByIds")] public ResponseResult DeleteByIds([FromBody] object[] ids) { try { dynamic resultInfos = new ExpandoObject(); resultInfos.tbBillList = m.DeleteByIds(ids); return new ResponseResult { status = 0, message = "OK", data = resultInfos }; } catch (Exception ex) { return ResponseResult.ResponseError(ex); } } /// <summary> /// æ·»å /// </summary> /// <returns></returns> [HttpPost("Insert")] public ResponseResult Add([FromBody] MesInvItemStocks 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] MesInvItemStocks 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] MesInvItemStocks 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/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/appsettings.json
@@ -6,5 +6,10 @@ "Microsoft.Hosting.Lifetime": "Information" } }, "AllowedHosts": "*" "AllowedHosts": "*", "AppSettings": { "TestErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfo", "ProductionErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfoFormal", "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd" } } 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
MESApplication/bin/Release/net8.0/publish/appsettings.json
@@ -6,5 +6,10 @@ "Microsoft.Hosting.Lifetime": "Information" } }, "AllowedHosts": "*" "AllowedHosts": "*", "AppSettings": { "TestErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfo", "ProductionErpUrl": "http://192.168.11.120:8098/WebService1.asmx/mesToErpinfoFormal", "DataBaseConn": "Data Source = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.251)(PORT = 1521))(CONNECT_DATA = (SERVICE_NAME = ORCL))); Persist Security Info=True;User ID = sg_prd; Password=sgprd" } }
