From b2be3b6939b4382f9165c78857a072f1aa7b01d0 Mon Sep 17 00:00:00 2001 From: zyf <1071160500@qq.com> Date: 星期六, 12 四月 2025 12:34:02 +0800 Subject: [PATCH] 更新平板功能,首检页面生成巡检单 --- MES.Service/Modes/Womcaa.cs | 516 ++++++++++++++++++++++++++------------------------------ 1 files changed, 238 insertions(+), 278 deletions(-) diff --git a/MES.Service/Modes/Womcaa.cs b/MES.Service/Modes/Womcaa.cs index fc5e544..634dcf6 100644 --- a/MES.Service/Modes/Womcaa.cs +++ b/MES.Service/Modes/Womcaa.cs @@ -1,282 +1,242 @@ 锘縰sing SqlSugar; - -namespace MES.Service.Modes; - -/// <summary> -/// 宸ュ崟琛� -/// </summary> -[SugarTable("WOMCAA")] -public class Womcaa +namespace MES.Service.Modes { /// <summary> - /// 鑷鍒� SEQ_AOI - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, + /// 浠诲姟鍗曡〃 + ///</summary> + [SugarTable("WOMCAA")] + public class Womcaa + { + /// <summary> + /// 鑷鍒� + ///</summary> + [SugarColumn(ColumnName="ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_AOI")] - public decimal? Id { get; set; } - - /// <summary> - /// ERPID - /// </summary> - [SugarColumn(ColumnName = "ERPID")] - public decimal? Erpid { get; set; } - - /// <summary> - /// 鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "CAA001")] - public string? Caa001 { get; set; } - - /// <summary> - /// 鍗曟嵁绫诲瀷 1銆佺洿鎺ュ叆搴�-鏅�氱敓浜� SCDD03_SYS2銆佺洿鎺ュ叆搴�-杩斿伐鐢熶骇 SCDD04_SYS3銆佸伐搴忔眹鎶�-鏅�氱敓浜� - /// SCDD01_SYS4銆佸伐搴忔眹鎶�-杩斿伐鐢熶骇 SCDD02_SYS - /// </summary> - [SugarColumn(ColumnName = "CAA004")] - public string? Caa004 { get; set; } - - /// <summary> - /// 寮�鍗曟棩鏈� - /// </summary> - [SugarColumn(ColumnName = "CAA005")] - public string? Caa005 { get; set; } - - /// <summary> - /// 浜у搧缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "CAA006")] - public string? Caa006 { get; set; } - - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "CAA009")] - public string? Caa009 { get; set; } - - /// <summary> - /// 棰勮寮�宸ユ椂闂� - /// </summary> - [SugarColumn(ColumnName = "CAA010")] - public string? Caa010 { get; set; } - - /// <summary> - /// 棰勮瀹屽伐鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "CAA011")] - public string? Caa011 { get; set; } - - /// <summary> - /// 鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "CAA012")] - public decimal? Caa012 { get; set; } - - /// <summary> - /// BOM鐗堟 - /// </summary> - [SugarColumn(ColumnName = "CAA013")] - public string? Caa013 { get; set; } - - /// <summary> - /// 閿�鍞鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "CAA015")] - public string? Caa015 { get; set; } - - /// <summary> - /// 澶囨敞 - /// </summary> - [SugarColumn(ColumnName = "CAA016")] - public string? Caa016 { get; set; } - - /// <summary> - /// 宸叉帓鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "CAA017")] - public decimal? Caa017 { get; set; } - - /// <summary> - /// ERP婧愬崟ID - /// </summary> - [SugarColumn(ColumnName = "CAA018")] - public decimal? Caa018 { get; set; } - - /// <summary> - /// ERP婧愬崟琛屽彿 - /// </summary> - [SugarColumn(ColumnName = "CAA019")] - public decimal? Caa019 { get; set; } - - /// <summary> - /// ERP婧愬崟鍗曞彿(浠诲姟鍗曞彿) - /// </summary> - [SugarColumn(ColumnName = "CAA020")] - public string? Caa020 { get; set; } - - /// <summary> - /// 宸ヤ綔杞﹂棿 - /// </summary> - [SugarColumn(ColumnName = "CAA021")] - public string? Caa021 { get; set; } - - /// <summary> - /// 瀹℃牳鐮� - /// </summary> - [SugarColumn(ColumnName = "FSTATUS")] - public decimal? 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 = "CAA022")] - public decimal? Caa022 { get; set; } - - /// <summary> - /// 鐘舵�� 瀹屽伐锛屾湭瀹屽伐 - /// </summary> - [SugarColumn(ColumnName = "CAA023")] - public string? Caa023 { get; set; } - - /// <summary> - /// 宸插叆搴撴暟閲� - /// </summary> - [SugarColumn(ColumnName = "CAA024")] - public decimal? Caa024 { get; set; } - - /// <summary> - /// 宸ヨ壓璺嚎 - /// </summary> - [SugarColumn(ColumnName = "ROUTING_ID")] - public string? RoutingId { get; set; } - - /// <summary> - /// 浜х嚎 - /// </summary> - [SugarColumn(ColumnName = "WORK_SHOP_ID")] - public string? WorkShopId { get; set; } - - /// <summary> - /// 浠撳簱 - /// </summary> - [SugarColumn(ColumnName = "DEPOT_CODE")] - public string? DepotCode { get; set; } - - /// <summary> - /// 鍗曟嵁鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] - public string? CreateDate { get; set; } - - /// <summary> - /// 璁″垝缁� - /// </summary> - [SugarColumn(ColumnName = "WORK_GROUP_ID")] - public string? WorkGroupId { get; set; } - - /// <summary> - /// 璁″垝鍛� - /// </summary> - [SugarColumn(ColumnName = "PLAN_ID")] - public string? PlanId { get; set; } - - /// <summary> - /// 鍏ュ簱涓婇檺 - /// </summary> - [SugarColumn(ColumnName = "STOCK_INLIMITH")] - public string? StockInlimith { get; set; } - - /// <summary> - /// 鍏ュ簱涓嬮檺 - /// </summary> - [SugarColumn(ColumnName = "STOCK_INLIMITL")] - public string? StockInlimitl { get; set; } - - /// <summary> - /// 璁″垝璺熻釜鍙� - /// </summary> - [SugarColumn(ColumnName = "MTONO")] - public string? Mtono { get; set; } - - /// <summary> - /// 鎵瑰彿 - /// </summary> - [SugarColumn(ColumnName = "LOT")] - public string? Lot { get; set; } - - /// <summary> - /// 閿�鍞鍗曡鍙� - /// </summary> - [SugarColumn(ColumnName = "CAA015_HEAD")] - public string? Caa015Head { get; set; } - - /// <summary> - /// 鐢熸垚鏂瑰紡 - /// </summary> - [SugarColumn(ColumnName = "CREATE_TYPE")] - public string? CreateType { get; set; } - - /// <summary> - /// 婧愬崟绫诲瀷 - /// </summary> - [SugarColumn(ColumnName = "SRC_BILL_TYPE")] - public string? SrcBillType { get; set; } - - /// <summary> - /// 婧愬崟缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "SRC_BILL_NO")] - public string? SrcBillNo { get; set; } - - /// <summary> - /// 婧愬崟鍒嗗綍琛屽彿 - /// </summary> - [SugarColumn(ColumnName = "SRC_BILLENTRYSEQ")] - public string? SrcBillentryseq { get; set; } - - /// <summary> - /// 闇�姹傚崟鎹彿 - /// </summary> - [SugarColumn(ColumnName = "SALE_ORDER_NO")] - public string? SaleOrderNo { get; set; } - - /// <summary> - /// 闇�姹傚崟鎹鍙� - /// </summary> - [SugarColumn(ColumnName = "SALE_ORDER_ENTRYSEQ")] - public string? SaleOrderEntryseq { get; set; } - - /// <summary> - /// 缁撴浜� - /// </summary> - [SugarColumn(ColumnName = "FORCE_CLOSERID")] - public string? ForceCloserid { get; set; } - - /// <summary> - /// 缁撴绫诲瀷 - /// </summary> - [SugarColumn(ColumnName = "CLOSE_TYPE")] - public string? CloseType { get; set; } - - /// <summary> - /// 婧愭媶鍒嗚鍗曠紪鍙� - /// </summary> - [SugarColumn(ColumnName = "SRC_SPLIT_BILLNO")] - public string? SrcSplitBillno { get; set; } - - /// <summary> - /// 鐢熶骇璁㈠崟琛屽唴鐮� - /// </summary> - [SugarColumn(ColumnName = "FMOENTRYID")] - public decimal? FMOENTRYID { get; set; } -} \ No newline at end of file + public decimal? Id { get; set; } + /// <summary> + /// ERPID + ///</summary> + [SugarColumn(ColumnName="ERPID" )] + public decimal? Erpid { get; set; } + /// <summary> + /// 鍗曟嵁缂栧彿 + ///</summary> + [SugarColumn(ColumnName="CAA001" )] + public string? Caa001 { get; set; } + /// <summary> + /// 鍗曟嵁绫诲瀷 + ///</summary> + [SugarColumn(ColumnName="CAA004" )] + public string? Caa004 { get; set; } + /// <summary> + /// 璁″垝涓嬭揪鏃ユ湡 + ///</summary> + [SugarColumn(ColumnName="CAA005" )] + public string? Caa005 { get; set; } + /// <summary> + /// 浜у搧缂栫爜 + ///</summary> + [SugarColumn(ColumnName="CAA006" )] + public string? Caa006 { get; set; } + /// <summary> + /// 鍗曚綅 + ///</summary> + [SugarColumn(ColumnName="CAA009" )] + public string? Caa009 { get; set; } + /// <summary> + /// 棰勮寮�宸ユ椂闂� + ///</summary> + [SugarColumn(ColumnName="CAA010" )] + public string? Caa010 { get; set; } + /// <summary> + /// 棰勮瀹屽伐鏃堕棿 + ///</summary> + [SugarColumn(ColumnName="CAA011" )] + public string? Caa011 { get; set; } + /// <summary> + /// 宸ュ崟鏁伴噺 + ///</summary> + [SugarColumn(ColumnName="CAA012" )] + public decimal? Caa012 { get; set; } + /// <summary> + /// BOM鐗堟 + ///</summary> + [SugarColumn(ColumnName="CAA013" )] + public string? Caa013 { get; set; } + /// <summary> + /// 閿�鍞鍗曞彿 + ///</summary> + [SugarColumn(ColumnName="CAA015" )] + public string? Caa015 { get; set; } + /// <summary> + /// 澶囨敞 + ///</summary> + [SugarColumn(ColumnName="CAA016" )] + public string? Caa016 { get; set; } + /// <summary> + /// 宸叉帓鏁伴噺锛堝純鐢級 + ///</summary> + [SugarColumn(ColumnName="CAA017" )] + public decimal? Caa017 { get; set; } + /// <summary> + /// ERP鐢熶骇璁㈠崟ID + ///</summary> + [SugarColumn(ColumnName="CAA018" )] + public decimal? Caa018 { get; set; } + /// <summary> + /// ERP鐢熶骇璁㈠崟搴忓彿 + ///</summary> + [SugarColumn(ColumnName="CAA019" )] + public decimal? Caa019 { get; set; } + /// <summary> + /// ERP鐢熶骇璁㈠崟鍗曞彿 + ///</summary> + [SugarColumn(ColumnName="CAA020" )] + public string? Caa020 { get; set; } + /// <summary> + /// 鐢熶骇杞﹂棿 + ///</summary> + [SugarColumn(ColumnName="CAA021" )] + public string? Caa021 { get; set; } + /// <summary> + /// 瀹℃牳鐮� + ///</summary> + [SugarColumn(ColumnName="FSTATUS" )] + public decimal? 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="CAA022" )] + public decimal? Caa022 { get; set; } + /// <summary> + /// "宸ュ崟鐘舵�� 1銆佽鍒� 2銆佽鍒掔‘璁� 3銆佷笅杈� 4銆佸紑宸� 5銆佸畬宸� 6銆佺粨妗� 7銆佺粨绠�" + ///</summary> + [SugarColumn(ColumnName="CAA023" )] + public string? Caa023 { get; set; } + /// <summary> + /// 宸插叆搴撴暟閲� + ///</summary> + [SugarColumn(ColumnName="CAA024" )] + public decimal? Caa024 { get; set; } + /// <summary> + /// 宸ヨ壓璺嚎 + ///</summary> + [SugarColumn(ColumnName="ROUTING_ID" )] + public string? RoutingId { get; set; } + /// <summary> + /// 浜х嚎 + ///</summary> + [SugarColumn(ColumnName="WORK_SHOP_ID" )] + public string? WorkShopId { get; set; } + /// <summary> + /// 浠撳簱 + ///</summary> + [SugarColumn(ColumnName="DEPOT_CODE" )] + public string? DepotCode { get; set; } + /// <summary> + /// 鍗曟嵁鏃ユ湡 + ///</summary> + [SugarColumn(ColumnName="CREATE_DATE" )] + public string? CreateDate { get; set; } + /// <summary> + /// 璁″垝缁� + ///</summary> + [SugarColumn(ColumnName="WORK_GROUP_ID" )] + public string? WorkGroupId { get; set; } + /// <summary> + /// 璁″垝鍛� + ///</summary> + [SugarColumn(ColumnName="PLAN_ID" )] + public string? PlanId { get; set; } + /// <summary> + /// 鍏ュ簱涓婇檺 + ///</summary> + [SugarColumn(ColumnName="STOCK_INLIMITH" )] + public string? StockInlimith { get; set; } + /// <summary> + /// 鍏ュ簱涓嬮檺 + ///</summary> + [SugarColumn(ColumnName="STOCK_INLIMITL" )] + public string? StockInlimitl { get; set; } + /// <summary> + /// 璁″垝璺熻釜鍙� + ///</summary> + [SugarColumn(ColumnName="MTONO" )] + public string? Mtono { get; set; } + /// <summary> + /// 鎵瑰彿 + ///</summary> + [SugarColumn(ColumnName="LOT" )] + public string? Lot { get; set; } + /// <summary> + /// 閿�鍞鍗曡鍙� + ///</summary> + [SugarColumn(ColumnName="CAA015_HEAD" )] + public string? Caa015Head { get; set; } + /// <summary> + /// 鐢熸垚鏂瑰紡 + ///</summary> + [SugarColumn(ColumnName="CREATE_TYPE" )] + public string? CreateType { get; set; } + /// <summary> + /// 婧愬崟绫诲瀷 + ///</summary> + [SugarColumn(ColumnName="SRC_BILL_TYPE" )] + public string? SrcBillType { get; set; } + /// <summary> + /// 婧愬崟缂栫爜 + ///</summary> + [SugarColumn(ColumnName="SRC_BILL_NO" )] + public string? SrcBillNo { get; set; } + /// <summary> + /// 婧愬崟鍒嗗綍琛屽彿 + ///</summary> + [SugarColumn(ColumnName="SRC_BILLENTRYSEQ" )] + public string? SrcBillentryseq { get; set; } + /// <summary> + /// 闇�姹傚崟鎹彿 + ///</summary> + [SugarColumn(ColumnName="SALE_ORDER_NO" )] + public string? SaleOrderNo { get; set; } + /// <summary> + /// 闇�姹傚崟鎹鍙� + ///</summary> + [SugarColumn(ColumnName="SALE_ORDER_ENTRYSEQ" )] + public string? SaleOrderEntryseq { get; set; } + /// <summary> + /// 缁撴浜� + ///</summary> + [SugarColumn(ColumnName="FORCE_CLOSERID" )] + public string? ForceCloserid { get; set; } + /// <summary> + /// 缁撴绫诲瀷 + ///</summary> + [SugarColumn(ColumnName="CLOSE_TYPE" )] + public string? CloseType { get; set; } + /// <summary> + /// 婧愭媶鍒嗚鍗曠紪鍙� + ///</summary> + [SugarColumn(ColumnName="SRC_SPLIT_BILLNO" )] + public string? SrcSplitBillno { get; set; } + /// <summary> + /// 鐢熶骇璁㈠崟琛屽唴鐮� + ///</summary> + [SugarColumn(ColumnName="FMOENTRYID" )] + public decimal? Fmoentryid { get; set; } + /// <summary> + /// 鎺掍骇绾垮埆 + ///</summary> + [SugarColumn(ColumnName="PROD_LINE" )] + public string? ProdLine { get; set; } + } +} -- Gitblit v1.9.3