| Dto/service/ProductionPickDto.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| entity/MesFile.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| entity/MesSysPageview.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| entity/Womcaa.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| entity/Womcab.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| entity/Womdaa.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| entity/Womdab.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| service/Warehouse/WomdaaManager.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| service/base/LoginService.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
Dto/service/ProductionPickDto.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@  using NewPdaSqlServer.entity; namespace NewPdaSqlServer.Dto.service; public class ProductionPickDto { public string? ItemModel { get; set; } public List<Womdab>? totals { get; set; } public List<Womdab>? daisao { get; set; } public List<MesInvItemOutCDetails> yisao { get; set; } } entity/MesFile.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,53 @@ using SqlSugar; namespace NewPdaSqlServer.entity { /// <summary> /// ///</summary> [SugarTable("MES_FILE")] public class MesFile { /// <summary> /// ä¸»é® ///</summary> [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )] public Guid Guid { get; set; } /// <summary> /// ç¶äº²Guid ///</summary> [SugarColumn(ColumnName="parent_Guid" )] public Guid? ParentGuid { get; set; } /// <summary> /// æ件æ é¢ ///</summary> [SugarColumn(ColumnName="file_Title" )] public string FileTitle { get; set; } /// <summary> /// æ件类å ///</summary> [SugarColumn(ColumnName="file_Type" )] public string FileType { get; set; } /// <summary> /// æä»¶è·¯å¾ ///</summary> [SugarColumn(ColumnName="url_Path" )] public string UrlPath { get; set; } /// <summary> /// ä¸ä¼ è ///</summary> [SugarColumn(ColumnName="create_by" )] public string CreateBy { get; set; } /// <summary> /// ä¸ä¼ æ¶é´ ///</summary> [SugarColumn(ColumnName="create_date" )] public DateTime? CreateDate { get; set; } } } entity/MesSysPageview.cs
@@ -9,42 +9,45 @@ public class MesSysPageview { /// <summary> /// ä¸»é® /// é»è®¤å¼: (newid()) /// </summary> /// ä¸»é® /// é»è®¤å¼: (newid()) ///</summary> [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)] public Guid Guid { get; set; } /// <summary> /// 页é¢ä¸æå /// </summary> /// 页é¢ä¸æå ///</summary> [SugarColumn(ColumnName = "PAGE_VIEW")] public string PageView { get; set; } /// <summary> /// 页é¢è·¯å¾ /// </summary> /// 页é¢è·¯å¾ ///</summary> [SugarColumn(ColumnName = "PATH")] public string Path { get; set; } /// <summary> /// 页é¢å¾æ /// </summary> /// 页é¢å¾æ ///</summary> [SugarColumn(ColumnName = "ICOIMG")] public string Icoimg { get; set; } /// <summary> /// </summary> /// ///</summary> [SugarColumn(ColumnName = "PAGE_GROUP")] public string PageGroup { get; set; } /// <summary> /// </summary> /// ///</summary> [SugarColumn(ColumnName = "PAGE_IDX")] public int? PageIdx { get; set; } /// <summary> /// </summary> /// ///</summary> [SugarColumn(ColumnName = "PAGE_STATUS")] public bool? PageStatus { get; set; } } entity/Womcaa.cs
@@ -3,403 +3,415 @@ namespace NewPdaSqlServer.entity; /// <summary> /// ä»»å¡å表 /// ç产任å¡å表 /// </summary> [SugarTable("WOMCAA")] public class Womcaa { /// <summary> /// é»è®¤å¼: (newid()) /// </summary> [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)] /// <summary> /// é»è®¤å¼: (newid()) /// </summary> [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)] public Guid Guid { get; set; } /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "ERPID")] /// <summary> /// ERPID /// </summary> [SugarColumn(ColumnName = "ERPID")] public int? Erpid { get; set; } /// <summary> /// åæ®ç¼å· /// </summary> [SugarColumn(ColumnName = "CAA001")] /// <summary> /// åæ®ç¼å· /// </summary> [SugarColumn(ColumnName = "CAA001")] public string Caa001 { get; set; } /// <summary> /// åæ®ç±»å("1ãç´æ¥å ¥åº-æ®éç产 2ãç´æ¥å ¥åº-è¿å·¥ç产 3ãå·¥åºæ±æ¥-æ®éç产 4ãå·¥åºæ±æ¥-è¿å·¥ç产") /// </summary> [SugarColumn(ColumnName = "CAA004")] /// <summary> /// åæ®ç±»å("1ãç´æ¥å ¥åº-æ®éç产 2ãç´æ¥å ¥åº-è¿å·¥ç产 3ãå·¥åºæ±æ¥-æ®éç产 4ãå·¥åºæ±æ¥-è¿å·¥ç产") /// </summary> [SugarColumn(ColumnName = "CAA004")] public string Caa004 { get; set; } /// <summary> /// 计åä¸è¾¾æ¥æ /// </summary> [SugarColumn(ColumnName = "CAA005")] /// <summary> /// 计åä¸è¾¾æ¥æ /// </summary> [SugarColumn(ColumnName = "CAA005")] public string Caa005 { get; set; } /// <summary> /// 产åç¼ç /// </summary> [SugarColumn(ColumnName = "CAA006")] /// <summary> /// 产åID /// </summary> [SugarColumn(ColumnName = "CAA006")] public string Caa006 { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "CAA009")] /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "CAA009")] public string Caa009 { get; set; } /// <summary> /// é¢è®¡å¼å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "CAA010")] /// <summary> /// é¢è®¡å¼å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "CAA010")] public string Caa010 { get; set; } /// <summary> /// é¢è®¡å®å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "CAA011")] /// <summary> /// é¢è®¡å®å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "CAA011")] public string Caa011 { get; set; } /// <summary> /// å·¥åæ°é /// </summary> [SugarColumn(ColumnName = "CAA012")] /// <summary> /// å·¥åæ°é /// </summary> [SugarColumn(ColumnName = "CAA012")] public decimal? Caa012 { get; set; } /// <summary> /// BOMç次 /// </summary> [SugarColumn(ColumnName = "CAA013")] /// <summary> /// BOMç次 /// </summary> [SugarColumn(ColumnName = "CAA013")] public string Caa013 { get; set; } /// <summary> /// éå®è®¢åå· /// </summary> [SugarColumn(ColumnName = "CAA015")] /// <summary> /// éå®è®¢åå· /// </summary> [SugarColumn(ColumnName = "CAA015")] public string Caa015 { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "CAA016")] /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "CAA016")] public string Caa016 { get; set; } /// <summary> /// å·²ææ°éï¼å¼ç¨ï¼ /// </summary> [SugarColumn(ColumnName = "CAA017")] /// <summary> /// å·²ææ°éï¼å¼ç¨ï¼ /// </summary> [SugarColumn(ColumnName = "CAA017")] public int? Caa017 { get; set; } /// <summary> /// ERPç产订åID /// </summary> [SugarColumn(ColumnName = "CAA018")] /// <summary> /// ERPç产订åID /// </summary> [SugarColumn(ColumnName = "CAA018")] public int? Caa018 { get; set; } /// <summary> /// ERPç产订ååºå· /// </summary> [SugarColumn(ColumnName = "CAA019")] /// <summary> /// ERPç产订ååºå· /// </summary> [SugarColumn(ColumnName = "CAA019")] public int? Caa019 { get; set; } /// <summary> /// ERPç产订ååå· /// </summary> [SugarColumn(ColumnName = "CAA020")] /// <summary> /// ERPç产订ååå· /// </summary> [SugarColumn(ColumnName = "CAA020")] public string Caa020 { get; set; } /// <summary> /// çäº§è½¦é´ /// </summary> [SugarColumn(ColumnName = "CAA021")] /// <summary> /// çäº§è½¦é´ /// </summary> [SugarColumn(ColumnName = "CAA021")] public string Caa021 { get; set; } /// <summary> /// å®¡æ ¸ç /// </summary> [SugarColumn(ColumnName = "FSTATUS")] /// <summary> /// å®¡æ ¸ç /// </summary> [SugarColumn(ColumnName = "FSTATUS")] public int? Fstatus { get; set; } /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "CHECK_USER")] /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "CHECK_USER")] public string CheckUser { get; set; } /// <summary> /// æªææ°éï¼å¼ç¨ï¼ /// </summary> [SugarColumn(ColumnName = "CAA022")] /// <summary> /// æªææ°éï¼å¼ç¨ï¼ /// </summary> [SugarColumn(ColumnName = "CAA022")] public int? Caa022 { get; set; } /// <summary> /// ä¸å¡ç¶æ("1ï¼è®¡åï¼2ã计å确认 2ãä¸è¾¾ 4ãå¼å·¥ 5ãå®å·¥ 6ãç»æ¡ï¼7ãç»ç®") /// </summary> [SugarColumn(ColumnName = "CAA023")] /// <summary> /// ä¸å¡ç¶æ("1ï¼è®¡åï¼2ã计å确认 2ãä¸è¾¾ 4ãå¼å·¥ 5ãå®å·¥ 6ãç»æ¡ï¼7ãç»ç®") /// </summary> [SugarColumn(ColumnName = "CAA023")] public string Caa023 { get; set; } /// <summary> /// å·²å ¥åºæ°é /// </summary> [SugarColumn(ColumnName = "CAA024")] /// <summary> /// å·²å ¥åºæ°é /// </summary> [SugarColumn(ColumnName = "CAA024")] public int? Caa024 { get; set; } /// <summary> /// å·¥èºè·¯çº¿ /// </summary> [SugarColumn(ColumnName = "ROUTING_ID")] /// <summary> /// å·¥èºè·¯çº¿ /// </summary> [SugarColumn(ColumnName = "ROUTING_ID")] public string RoutingId { get; set; } /// <summary> /// 产线 /// </summary> [SugarColumn(ColumnName = "WORK_SHOP_ID")] /// <summary> /// 产线 /// </summary> [SugarColumn(ColumnName = "WORK_SHOP_ID")] public string WorkShopId { get; set; } /// <summary> /// ä»åº /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] /// <summary> /// ä»åº /// </summary> [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } /// <summary> /// åæ®æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] /// <summary> /// åæ®æ¥æ /// </summary> [SugarColumn(ColumnName = "CREATE_DATE")] public string CreateDate { get; set; } /// <summary> /// 计åç» /// </summary> [SugarColumn(ColumnName = "WORK_GROUP_ID")] /// <summary> /// 计åç» /// </summary> [SugarColumn(ColumnName = "WORK_GROUP_ID")] public string WorkGroupId { get; set; } /// <summary> /// 计åå /// </summary> [SugarColumn(ColumnName = "PLAN_ID")] /// <summary> /// 计åå /// </summary> [SugarColumn(ColumnName = "PLAN_ID")] public string PlanId { get; set; } /// <summary> /// å ¥åºä¸é /// </summary> [SugarColumn(ColumnName = "STOCK_INLIMITH")] /// <summary> /// å ¥åºä¸é /// </summary> [SugarColumn(ColumnName = "STOCK_INLIMITH")] public string StockInlimith { get; set; } /// <summary> /// å ¥åºä¸é /// </summary> [SugarColumn(ColumnName = "STOCK_INLIMITL")] /// <summary> /// å ¥åºä¸é /// </summary> [SugarColumn(ColumnName = "STOCK_INLIMITL")] public string StockInlimitl { get; set; } /// <summary> /// 主车é´è°åº¦å /// </summary> [SugarColumn(ColumnName = "MTONO")] /// <summary> /// 主车é´è°åº¦å /// </summary> [SugarColumn(ColumnName = "MTONO")] public string Mtono { get; set; } /// <summary> /// æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT")] /// <summary> /// æ¹æ¬¡ /// </summary> [SugarColumn(ColumnName = "LOT")] public string Lot { get; set; } /// <summary> /// å¼ç¨åå· /// </summary> [SugarColumn(ColumnName = "CAA015_HEAD")] /// <summary> /// å¼ç¨åå· /// </summary> [SugarColumn(ColumnName = "CAA015_HEAD")] public string Caa015Head { get; set; } /// <summary> /// å¶åç±»å /// </summary> [SugarColumn(ColumnName = "CREATE_TYPE")] /// <summary> /// å¶åç±»å /// </summary> [SugarColumn(ColumnName = "CREATE_TYPE")] public string CreateType { get; set; } /// <summary> /// æ¥æºåæ®ç±»å /// </summary> [SugarColumn(ColumnName = "SRC_BILL_TYPE")] /// <summary> /// æ¥æºåæ®ç±»å /// </summary> [SugarColumn(ColumnName = "SRC_BILL_TYPE")] public string SrcBillType { get; set; } /// <summary> /// æ¥æºåå· /// </summary> [SugarColumn(ColumnName = "SRC_BILL_NO")] /// <summary> /// æ¥æºåå· /// </summary> [SugarColumn(ColumnName = "SRC_BILL_NO")] public string SrcBillNo { get; set; } /// <summary> /// æ¥æºè¡å· /// </summary> [SugarColumn(ColumnName = "SRC_BILLENTRYSEQ")] /// <summary> /// æ¥æºè¡å· /// </summary> [SugarColumn(ColumnName = "SRC_BILLENTRYSEQ")] public string SrcBillentryseq { get; set; } /// <summary> /// éå®è®¢åå· /// </summary> [SugarColumn(ColumnName = "SALE_ORDER_NO")] /// <summary> /// éå®è®¢åå· /// </summary> [SugarColumn(ColumnName = "SALE_ORDER_NO")] public string SaleOrderNo { get; set; } /// <summary> /// éå®è®¢åè¡å· /// </summary> [SugarColumn(ColumnName = "SALE_ORDER_ENTRYSEQ")] /// <summary> /// éå®è®¢åè¡å· /// </summary> [SugarColumn(ColumnName = "SALE_ORDER_ENTRYSEQ")] public string SaleOrderEntryseq { get; set; } /// <summary> /// 强å¶å ³é人 /// </summary> [SugarColumn(ColumnName = "FORCE_CLOSERID")] /// <summary> /// 强å¶å ³é人 /// </summary> [SugarColumn(ColumnName = "FORCE_CLOSERID")] public string ForceCloserid { get; set; } /// <summary> /// å ³éç±»å /// </summary> [SugarColumn(ColumnName = "CLOSE_TYPE")] /// <summary> /// å ³éç±»å /// </summary> [SugarColumn(ColumnName = "CLOSE_TYPE")] public string CloseType { get; set; } /// <summary> /// ååå· /// </summary> [SugarColumn(ColumnName = "SRC_SPLIT_BILLNO")] /// <summary> /// ååå· /// </summary> [SugarColumn(ColumnName = "SRC_SPLIT_BILLNO")] public string SrcSplitBillno { get; set; } /// <summary> /// æ¯å¦ç®¡æ§ /// </summary> [SugarColumn(ColumnName = "ERP_SCZZ")] /// <summary> /// æ¯å¦ç®¡æ§ /// </summary> [SugarColumn(ColumnName = "ERP_SCZZ")] public int? ErpSczz { get; set; } /// <summary> /// æ¯å¦å§æ /// </summary> [SugarColumn(ColumnName = "ERP_WTZZ")] /// <summary> /// æ¯å¦å§æ /// </summary> [SugarColumn(ColumnName = "ERP_WTZZ")] public int? ErpWtzz { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MAIN_PRODUCT_NO")] /// <summary> /// </summary> [SugarColumn(ColumnName = "MAIN_PRODUCT_NO")] public string MainProductNo { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")] /// <summary> /// </summary> [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")] public int? MainProductQty { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")] /// <summary> /// </summary> [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")] public string CustomerItemNumber { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")] /// <summary> /// </summary> [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")] public string PackingListNumber { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NAME")] /// <summary> /// </summary> [SugarColumn(ColumnName = "CUSTOMER_NAME")] public string CustomerName { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "CUSTOMER")] /// <summary> /// </summary> [SugarColumn(ColumnName = "CUSTOMER")] public string Customer { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "TYPE")] /// <summary> /// </summary> [SugarColumn(ColumnName = "TYPE")] public string Type { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "JA_BS")] /// <summary> /// </summary> [SugarColumn(ColumnName = "JA_BS")] public string JaBs { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "JA_TIME")] /// <summary> /// </summary> [SugarColumn(ColumnName = "JA_TIME")] public DateTime? JaTime { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "YP_NUM")] /// <summary> /// </summary> [SugarColumn(ColumnName = "YP_NUM")] public int? YpNum { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "CAA011_1")] /// <summary> /// </summary> [SugarColumn(ColumnName = "CAA011_1")] public string Caa0111 { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "ERP_GYZZ")] /// <summary> /// </summary> [SugarColumn(ColumnName = "ERP_GYZZ")] public int? ErpGyzz { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "ERP_FLZZ")] /// <summary> /// </summary> [SugarColumn(ColumnName = "ERP_FLZZ")] public int? ErpFlzz { get; set; } /// <summary> /// æ¯å¦å ¥åº /// </summary> [SugarColumn(ColumnName = "ERP_SLZZ")] /// <summary> /// æ¯å¦å ¥åº /// </summary> [SugarColumn(ColumnName = "ERP_SLZZ")] public int? ErpSlzz { get; set; } /// <summary> /// æ¯å¦éåº /// </summary> [SugarColumn(ColumnName = "ERP_RKZZ")] /// <summary> /// æ¯å¦éåº /// </summary> [SugarColumn(ColumnName = "ERP_RKZZ")] public int? ErpRkzz { get; set; } /// <summary> /// æ¯å¦æ¢è´§ /// </summary> [SugarColumn(ColumnName = "ERP_RKHZ")] /// <summary> /// æ¯å¦æ¢è´§ /// </summary> [SugarColumn(ColumnName = "ERP_RKHZ")] public int? ErpRkhz { get; set; } /// <summary> /// æ¯å¦å¯å® /// </summary> [SugarColumn(ColumnName = "ERP_JJDS")] /// <summary> /// æ¯å¦å¯å® /// </summary> [SugarColumn(ColumnName = "ERP_JJDS")] public int? ErpJjds { get; set; } /// <summary> /// æ¯å¦æ款 /// </summary> [SugarColumn(ColumnName = "ERP_BZDS")] /// <summary> /// æ¯å¦æ款 /// </summary> [SugarColumn(ColumnName = "ERP_BZDS")] public int? ErpBzds { get; set; } /// <summary> /// æ¯å¦æ°å»º /// </summary> [SugarColumn(ColumnName = "CAA025")] /// <summary> /// æ¯å¦æ°å»º /// </summary> [SugarColumn(ColumnName = "CAA025")] public int? Caa025 { get; set; } /// <summary> /// éè´è®¢åå· /// </summary> [SugarColumn(ColumnName = "FPURORDERNO")] /// <summary> /// éè´è®¢åå· /// </summary> [SugarColumn(ColumnName = "FPURORDERNO")] public string Fpurorderno { get; set; } /// <summary> /// éè´è®¢åè¡å· /// </summary> [SugarColumn(ColumnName = "FPURORDERENTRYSEQ")] /// <summary> /// éè´è®¢åè¡å· /// </summary> [SugarColumn(ColumnName = "FPURORDERENTRYSEQ")] public string Fpurorderentryseq { get; set; } /// <summary> /// å¤æ³¨ï¼è¡¨ä½ï¼ /// </summary> [SugarColumn(ColumnName = "Btbz")] /// <summary> /// å¤æ³¨ï¼è¡¨ä½ï¼ /// </summary> [SugarColumn(ColumnName = "Btbz")] public string Btbz { get; set; } /// <summary> /// æºæå订åç¼å· /// </summary> [SugarColumn(ColumnName = "fmoentryid")] public string Fmoentryid { get; set; } /// <summary> /// æäº§çº¿å« /// </summary> [SugarColumn(ColumnName = "prod_line")] public string ProdLine { get; set; } } entity/Womcab.cs
@@ -3,7 +3,7 @@ namespace NewPdaSqlServer.entity; /// <summary> /// ä»»å¡åç©æ表 /// ä»»å¡åç©æ表bom /// </summary> [SugarTable("WOMCAB")] public class Womcab entity/Womdaa.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,410 @@ using SqlSugar; namespace NewPdaSqlServer.entity; /// <summary> /// </summary> [SugarTable("WOMDAA")] public class Womdaa { /// <summary> /// é»è®¤å¼: (newid()) /// </summary> [SugarColumn(ColumnName = "guid")] public Guid? Guid { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "pbaGuid")] public Guid? PbaGuid { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "caaGuid")] public Guid? CaaGuid { get; set; } /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "id")] public int? Id { get; set; } /// <summary> /// æ产ID /// </summary> [SugarColumn(ColumnName = "pid")] public int? Pid { get; set; } /// <summary> /// åå· /// </summary> [SugarColumn(ColumnName = "daa001")] public string Daa001 { get; set; } /// <summary> /// 产åID /// </summary> [SugarColumn(ColumnName = "daa002")] public string Daa002 { get; set; } /// <summary> /// 产åå称 /// </summary> [SugarColumn(ColumnName = "daa003")] public string Daa003 { get; set; } /// <summary> /// 产åè§æ ¼ /// </summary> [SugarColumn(ColumnName = "daa004")] public string Daa004 { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "daa005")] public string Daa005 { get; set; } /// <summary> /// ERPé¢è®¡å¼å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "daa006")] public DateTime? Daa006 { get; set; } /// <summary> /// ERPé¢è®¡å®å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "daa007")] public DateTime? Daa007 { get; set; } /// <summary> /// å·¥åæ°é /// </summary> [SugarColumn(ColumnName = "daa008")] public int? Daa008 { get; set; } /// <summary> /// å¤æ³¨ /// </summary> [SugarColumn(ColumnName = "daa009")] public string Daa009 { get; set; } /// <summary> /// å ¥åºæ°é /// </summary> [SugarColumn(ColumnName = "daa010")] public int? Daa010 { get; set; } /// <summary> /// å·²ç产é /// </summary> [SugarColumn(ColumnName = "daa011")] public int? Daa011 { get; set; } /// <summary> /// æ¥åºæ°é /// </summary> [SugarColumn(ColumnName = "daa012")] public int? Daa012 { get; set; } /// <summary> /// å·¥ä½è½¦é´ /// </summary> [SugarColumn(ColumnName = "daa013")] public string Daa013 { get; set; } /// <summary> /// ææååå· /// </summary> [SugarColumn(ColumnName = "daa014")] public string Daa014 { get; set; } /// <summary> /// çäº§çº¿å« /// </summary> [SugarColumn(ColumnName = "daa015")] public string Daa015 { get; set; } /// <summary> /// å®é å¼å·¥æ¥ /// </summary> [SugarColumn(ColumnName = "daa016")] public DateTime? Daa016 { get; set; } /// <summary> /// å®é å®å·¥æ¥ /// </summary> [SugarColumn(ColumnName = "daa017")] public DateTime? Daa017 { get; set; } /// <summary> /// å·¥åç¶æ /// </summary> [SugarColumn(ColumnName = "daa018")] public string Daa018 { get; set; } /// <summary> /// é½å¥ç¶æ /// </summary> [SugarColumn(ColumnName = "daa019")] public string Daa019 { get; set; } /// <summary> /// å®¡æ ¸ç /// </summary> [SugarColumn(ColumnName = "fstatus")] public int? Fstatus { get; set; } /// <summary> /// å®¡æ ¸æ¥æ /// </summary> [SugarColumn(ColumnName = "check_date")] public DateTime? CheckDate { get; set; } /// <summary> /// å®¡æ ¸äºº /// </summary> [SugarColumn(ColumnName = "check_user")] public string CheckUser { get; set; } /// <summary> /// 线å«ç¼ç /// </summary> [SugarColumn(ColumnName = "daa020")] public string Daa020 { get; set; } /// <summary> /// ä»»å¡ååå· /// </summary> [SugarColumn(ColumnName = "daa021")] public string Daa021 { get; set; } /// <summary> /// éç¥å¤æï¼0-æªéç¥ï¼1-éç¥ /// é»è®¤å¼: ((0)) /// </summary> [SugarColumn(ColumnName = "daa022")] public int? Daa022 { get; set; } /// <summary> /// ç产åºå· /// </summary> [SugarColumn(ColumnName = "daa023")] public int? Daa023 { get; set; } /// <summary> /// æ产æ¥æ /// </summary> [SugarColumn(ColumnName = "daa024")] public string Daa024 { get; set; } /// <summary> /// é¦ä»¶æ¯å¦æ£éª1-æ£éªï¼0æªæ£éª /// </summary> [SugarColumn(ColumnName = "daa025")] public string Daa025 { get; set; } /// <summary> /// é¦ä»¶æ£éªç»æ /// </summary> [SugarColumn(ColumnName = "daa026")] public string Daa026 { get; set; } /// <summary> /// å·²æ¥æ£ï¼0-æªæ¥æ£ï¼1-å·²æ¥æ£ /// </summary> [SugarColumn(ColumnName = "is_reportcheck")] public int? IsReportcheck { get; set; } /// <summary> /// æ¥æ£äºº /// </summary> [SugarColumn(ColumnName = "usname")] public string Usname { get; set; } /// <summary> /// æ¥æ£æ¶é´ /// </summary> [SugarColumn(ColumnName = "reporttime")] public DateTime? Reporttime { get; set; } /// <summary> /// æºå°ç¼å· /// </summary> [SugarColumn(ColumnName = "machine_no")] public string MachineNo { get; set; } /// <summary> /// å¤æå®æ1-å®æï¼0æªå®æ /// </summary> [SugarColumn(ColumnName = "daa027")] public int? Daa027 { get; set; } /// <summary> /// å¤æå®ææ¶é´ /// </summary> [SugarColumn(ColumnName = "daa028")] public string Daa028 { get; set; } /// <summary> /// æ åå·¥æ¶ /// </summary> [SugarColumn(ColumnName = "prod_hour")] public int? ProdHour { get; set; } /// <summary> /// å人å°æ¶äº§è½ /// </summary> [SugarColumn(ColumnName = "person_hour_capacity")] public int? PersonHourCapacity { get; set; } /// <summary> /// ç论æ 产 /// </summary> [SugarColumn(ColumnName = "the_capacity")] public int? TheCapacity { get; set; } /// <summary> /// 计åç¨äººæ° /// </summary> [SugarColumn(ColumnName = "plan_personnel")] public int? PlanPersonnel { get; set; } /// <summary> /// 计åæ åäº§è½ /// </summary> [SugarColumn(ColumnName = "plan_capacity")] public int? PlanCapacity { get; set; } /// <summary> /// ç论ç¨æ¶/M /// </summary> [SugarColumn(ColumnName = "the_min")] public int? TheMin { get; set; } /// <summary> /// ç论ç¨æ¶/H /// </summary> [SugarColumn(ColumnName = "the_hour")] public int? TheHour { get; set; } /// <summary> /// 线ä½ç±»å« /// </summary> [SugarColumn(ColumnName = "line_type")] public string LineType { get; set; } /// <summary> /// æ åäººæ° /// </summary> [SugarColumn(ColumnName = "personnel")] public int? Personnel { get; set; } /// <summary> /// æ¢çº¿æ¶é´ /// </summary> [SugarColumn(ColumnName = "change_line_time")] public int? ChangeLineTime { get; set; } /// <summary> /// ä¼æ¯æ¶é´ /// </summary> [SugarColumn(ColumnName = "rest_time")] public int? RestTime { get; set; } /// <summary> /// æ产åºå· /// </summary> [SugarColumn(ColumnName = "schedule_order")] public int? ScheduleOrder { get; set; } /// <summary> /// MESé¢è®¡å¼å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "mes_start_prod")] public DateTime? MesStartProd { get; set; } /// <summary> /// MESé¢è®¡å®å·¥æ¶é´ /// </summary> [SugarColumn(ColumnName = "mes_end_prod")] public DateTime? MesEndProd { get; set; } /// <summary> /// æ产æ¨éæ è¯ /// </summary> [SugarColumn(ColumnName = "prodts")] public int? Prodts { get; set; } /// <summary> /// é¢è®¡å¤ææ¶é´ /// </summary> [SugarColumn(ColumnName = "prepare_time")] public DateTime? PrepareTime { get; set; } /// <summary> /// æ件æå ¥äººæ° /// </summary> [SugarColumn(ColumnName = "cj_worker")] public int? CjWorker { get; set; } /// <summary> /// æ件计åæå ¥äººæ° /// </summary> [SugarColumn(ColumnName = "p_cj_worker")] public int? PCjWorker { get; set; } /// <summary> /// æ件æ¥äº§é /// </summary> [SugarColumn(ColumnName = "cj_daily_out")] public int? CjDailyOut { get; set; } /// <summary> /// æ件æ åå·¥æ¶ /// </summary> [SugarColumn(ColumnName = "cj_std_hour")] public int? CjStdHour { get; set; } /// <summary> /// é¡çæå ¥äººæ° /// </summary> [SugarColumn(ColumnName = "hx_worker")] public int? HxWorker { get; set; } /// <summary> /// é¡ç计åæå ¥äººæ° /// </summary> [SugarColumn(ColumnName = "p_hx_worker")] public int? PHxWorker { get; set; } /// <summary> /// é¡çæ¥äº§é /// </summary> [SugarColumn(ColumnName = "hx_daily_out")] public int? HxDailyOut { get; set; } /// <summary> /// é¡çæ åå·¥æ¶ /// </summary> [SugarColumn(ColumnName = "hx_std_hour")] public int? HxStdHour { get; set; } /// <summary> /// æ件æ°é /// </summary> [SugarColumn(ColumnName = "cj_num")] public int? CjNum { get; set; } /// <summary> /// å®¢æ· /// </summary> [SugarColumn(ColumnName = "cust")] public string Cust { get; set; } /// <summary> /// æ¯å¦é¦æ£ /// </summary> [SugarColumn(ColumnName = "IS_SJ")] public int? IsSj { get; set; } } entity/Womdab.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,239 @@ using SqlSugar; namespace NewPdaSqlServer.entity; /// <summary> /// </summary> [SugarTable("WOMDAB")] public class Womdab { /// <summary> /// é»è®¤å¼: (newid()) /// </summary> [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)] public Guid Guid { get; set; } /// <summary> /// </summary> [SugarColumn(ColumnName = "daaGuid")] public Guid? DaaGuid { get; set; } /// <summary> /// èªå¢å /// </summary> [SugarColumn(ColumnName = "id")] public int? Id { get; set; } /// <summary> /// PID /// </summary> [SugarColumn(ColumnName = "pid")] public int? Pid { get; set; } /// <summary> /// å·¥ååå· /// </summary> [SugarColumn(ColumnName = "dab001")] public string Dab001 { get; set; } /// <summary> /// åºå· /// </summary> [SugarColumn(ColumnName = "dab002")] public int? Dab002 { get; set; } /// <summary> /// ææç¼ç /// </summary> [SugarColumn(ColumnName = "dab003")] public string Dab003 { get; set; } /// <summary> /// ææå称 /// </summary> [SugarColumn(ColumnName = "dab004")] public string Dab004 { get; set; } /// <summary> /// ææè§æ ¼ /// </summary> [SugarColumn(ColumnName = "dab005")] public string Dab005 { get; set; } /// <summary> /// éé¢ç¨é /// </summary> [SugarColumn(ColumnName = "dab006")] public int? Dab006 { get; set; } /// <summary> /// å·²é¢ç¨é /// </summary> [SugarColumn(ColumnName = "dab007")] public int? Dab007 { get; set; } /// <summary> /// å·¥èº /// </summary> [SugarColumn(ColumnName = "dab008")] public string Dab008 { get; set; } /// <summary> /// åä½ /// </summary> [SugarColumn(ColumnName = "dab009")] public string Dab009 { get; set; } /// <summary> /// ææç±»å /// </summary> [SugarColumn(ColumnName = "dab010")] public string Dab010 { get; set; } /// <summary> /// 主æ /// </summary> [SugarColumn(ColumnName = "dab011")] public string Dab011 { get; set; } /// <summary> /// ç»æç¨é /// </summary> [SugarColumn(ColumnName = "dab012")] public int? Dab012 { get; set; } /// <summary> /// åºæ° /// </summary> [SugarColumn(ColumnName = "dab013")] public int? Dab013 { get; set; } /// <summary> /// æ¯å¦æ¿æ /// </summary> [SugarColumn(ColumnName = "dab014")] public string Dab014 { get; set; } /// <summary> /// ç¹ä½ /// </summary> [SugarColumn(ColumnName = "dab015")] public string Dab015 { get; set; } /// <summary> /// ææåå· /// </summary> [SugarColumn(ColumnName = "dab016")] public string Dab016 { get; set; } /// <summary> /// ä»åºç¼ç /// </summary> [SugarColumn(ColumnName = "dab017")] public string Dab017 { get; set; } /// <summary> /// ä»åºå称 /// </summary> [SugarColumn(ColumnName = "dab018")] public string Dab018 { get; set; } /// <summary> /// é¢ææ¹å¼ /// </summary> [SugarColumn(ColumnName = "dab019")] public string Dab019 { get; set; } /// <summary> /// åºå®æè /// </summary> [SugarColumn(ColumnName = "scrapqty")] public int? Scrapqty { get; set; } /// <summary> /// åå¨æèç /// </summary> [SugarColumn(ColumnName = "scraprate")] public int? Scraprate { get; set; } /// <summary> /// ææåè¡id /// </summary> [SugarColumn(ColumnName = "erpid")] public int? Erpid { get; set; } /// <summary> /// ææå头id /// </summary> [SugarColumn(ColumnName = "eid")] public int? Eid { get; set; } /// <summary> /// å®é¢ç¨é /// é»è®¤å¼: ((0)) /// </summary> [SugarColumn(ColumnName = "dab020")] public int? Dab020 { get; set; } /// <summary> /// è¡¥é¢æ°é /// é»è®¤å¼: ((0)) /// </summary> [SugarColumn(ColumnName = "dab021")] public int? Dab021 { get; set; } /// <summary> /// éææ°é /// é»è®¤å¼: ((0)) /// </summary> [SugarColumn(ColumnName = "dab022")] public int? Dab022 { get; set; } /// <summary> /// è¶ é¢æ°é /// é»è®¤å¼: ((0)) /// </summary> [SugarColumn(ColumnName = "dab023")] public int? Dab023 { get; set; } /// <summary> /// è¯åéæ /// é»è®¤å¼: ((0)) /// </summary> [SugarColumn(ColumnName = "lp_tl")] public int? LpTl { get; set; } /// <summary> /// æ¥æä¸è¯ /// é»è®¤å¼: ((0)) /// </summary> [SugarColumn(ColumnName = "ll_bl")] public int? LlBl { get; set; } /// <summary> /// ä½ä¸ä¸è¯ /// é»è®¤å¼: ((0)) /// </summary> [SugarColumn(ColumnName = "zy_bl")] public int? ZyBl { get; set; } /// <summary> /// å并æ è¯ /// é»è®¤å¼: ((0)) /// </summary> [SugarColumn(ColumnName = "hb_flag")] public int? HbFlag { get; set; } /// <summary> /// å并åå· /// </summary> [SugarColumn(ColumnName = "hb_no")] public string HbNo { get; set; } // å¨ææ·»å çå±æ§ [SugarColumn(IsIgnore = true)] public decimal? wNum { get; set; } [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; } [SugarColumn(IsIgnore = true)] public string? ItemNo { get; set; } } service/Warehouse/WomdaaManager.cs
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,74 @@ using NewPdaSqlServer.DB; using NewPdaSqlServer.Dto.service; using NewPdaSqlServer.entity; using SqlSugar; namespace NewPdaSqlServer.service.Warehouse; public class WomdaaManager : Repository<Womdaa> { //å½å类已ç»ç»§æ¿äº Repository å¢ãå ãæ¥ãæ¹çæ¹æ³ //è¿éé¢åç代ç ä¸ä¼ç»è¦ç,å¦æè¦éæ°çæ请å é¤ WomdaaManager.cs //è·åå·¥åå· public List<string> GetProductionPickDaa001(WarehouseQuery query) { var sql = "SELECT DAA001 FROM WOMDAA A LEFT JOIN (SELECT COUNT(1) UN_NUM, PID FROM WOMDAB WHERE DAB006 > DAB007 GROUP BY PID) B ON A.ID = B.PID WHERE DAA001 LIKE '%" + query.daa001 + "%' and DAA018 != 'å®å·¥' AND DAA022 = 1 AND UN_NUM > 0 AND ROWNUM <= 10 order by a.id desc"; return Db.Ado.SqlQuery<string>(sql); } //æ ¹æ®å·¥åå·è¿å产ååå·åå¾ é¢ç©æ public ProductionPickDto GetItemsByDaa001(WarehouseQuery query) { if (string.IsNullOrEmpty(query.daa001)) throw new Exception("å·¥åå·ä¸ºç©º"); var womdaa = Db.Queryable<Womdaa, MesItems>((a, i) => new JoinQueryInfos(JoinType.Left, a.Daa002 == i.ItemId.ToString())) .Where((a, i) => a.Daa001 == query.daa001) .Select((a, i) => new { i.ItemModel }).First(); if (womdaa?.ItemModel == null) throw new Exception("å·¥åå·ä¸åå¨"); var womdabs = Db.Queryable<Womdaa, Womdab, MesItems>((a, b, c) => new JoinQueryInfos( JoinType.Left, a.Id == b.Pid, JoinType.Inner, c.Id.ToString() == b.Dab003 )) .Where((a, b, c) => a.Daa001 == query.daa001) .Select((a, b, c) => new Womdab { Pid = b.Pid, Dab003 = b.Dab003, Dab006 = b.Dab006, Dab007 = b.Dab007, wNum = b.Dab006 - b.Dab007, // 计ç®å段 W_NUM ItemName = c.ItemName, // å¨æå段 ITEM_NAME ItemNo = c.ItemNo // å¨æå段 ITEM_NO }) .ToList(); var list = womdabs.Where(s=>s.wNum > 0).ToList(); var dto = new ProductionPickDto { ItemModel = womdaa.ItemModel, totals = womdabs, daisao = list }; return dto; } } service/base/LoginService.cs
@@ -47,16 +47,22 @@ groupObj.child = new List<MesSysPageview>(); foreach (var pageView in group) { var mesFile = Db.Queryable<MesFile>() .Where(s => s.ParentGuid == pageView.Guid).First(); groupObj.child.Add(new MesSysPageview { Guid = pageView.Guid, PageView = pageView.PageView, Path = pageView.Path, Icoimg = pageView.Icoimg, Icoimg = "http://192.168.1.145:81/upload/" + mesFile.UrlPath, PageGroup = pageView.PageGroup, PageIdx = pageView.PageIdx, PageStatus = pageView.PageStatus }); } result.Add(groupObj); }
