From ed0b898d7f0c05516e83133c8bc5b45e14876a28 Mon Sep 17 00:00:00 2001 From: 南骏 池 <chiffly@163.com> Date: 星期一, 17 二月 2025 14:43:52 +0800 Subject: [PATCH] 1.采购订单时间调整 2.采购订单接口新增route --- MES.Service/Modes/Womcaa.cs | 423 ++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 423 insertions(+), 0 deletions(-) diff --git a/MES.Service/Modes/Womcaa.cs b/MES.Service/Modes/Womcaa.cs new file mode 100644 index 0000000..85694b4 --- /dev/null +++ b/MES.Service/Modes/Womcaa.cs @@ -0,0 +1,423 @@ +锘縰sing SqlSugar; + +namespace MES.Service.Modes; + +/// <summary> +/// 鐢熶骇浠诲姟鍗曡〃 +/// </summary> +[SugarTable("WOMCAA")] +public class Womcaa +{ + /// <summary> + /// 榛樿鍊�: (newid()) + /// </summary> + [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)] + public Guid Guid { get; set; } + + /// <summary> + /// ERPID + /// </summary> + [SugarColumn(ColumnName = "ERPID")] + public int? Erpid { get; set; } + + /// <summary> + /// 鍗曟嵁缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "CAA001")] + public string? Caa001 { get; set; } + + /// <summary> + /// 鍗曟嵁绫诲瀷("1銆佺洿鎺ュ叆搴�-鏅�氱敓浜� 2銆佺洿鎺ュ叆搴�-杩斿伐鐢熶骇 3銆佸伐搴忔眹鎶�-鏅�氱敓浜� 4銆佸伐搴忔眹鎶�-杩斿伐鐢熶骇") + /// </summary> + [SugarColumn(ColumnName = "CAA004")] + public string? Caa004 { get; set; } + + /// <summary> + /// 璁″垝涓嬭揪鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "CAA005")] + public string? Caa005 { get; set; } + + /// <summary> + /// 浜у搧ID + /// </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 int? Caa017 { get; set; } + + /// <summary> + /// ERP鐢熶骇璁㈠崟ID + /// </summary> + [SugarColumn(ColumnName = "CAA018")] + public int? Caa018 { get; set; } + + /// <summary> + /// ERP鐢熶骇璁㈠崟搴忓彿 + /// </summary> + [SugarColumn(ColumnName = "CAA019")] + public int? 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 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 = "CAA022")] + public int? Caa022 { get; set; } + + /// <summary> + /// 涓氬姟鐘舵��("1锛岃鍒掞紝2銆佽鍒掔‘璁� 2銆佷笅杈� 4銆佸紑宸� 5銆佸畬宸� 6銆佺粨妗堬紝7銆佺粨绠�") + /// </summary> + [SugarColumn(ColumnName = "CAA023")] + public string? Caa023 { get; set; } + + /// <summary> + /// 宸插叆搴撴暟閲� + /// </summary> + [SugarColumn(ColumnName = "CAA024")] + public int? 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 = "ERP_SCZZ")] + public int? ErpSczz { get; set; } + + /// <summary> + /// 鏄惁濮旀墭 + /// </summary> + [SugarColumn(ColumnName = "ERP_WTZZ")] + public int? ErpWtzz { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "MAIN_PRODUCT_NO")] + public string? MainProductNo { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")] + public int? MainProductQty { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")] + public string? CustomerItemNumber { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")] + public string? PackingListNumber { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "CUSTOMER_NAME")] + public string? CustomerName { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "CUSTOMER")] + public string? Customer { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "TYPE")] + public string? Type { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "JA_BS")] + public string? JaBs { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "JA_TIME")] + public DateTime? JaTime { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "YP_NUM")] + public int? YpNum { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "CAA011_1")] + public string? Caa0111 { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "ERP_GYZZ")] + public int? ErpGyzz { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "ERP_FLZZ")] + public int? ErpFlzz { get; set; } + + /// <summary> + /// 鏄惁鍏ュ簱 + /// </summary> + [SugarColumn(ColumnName = "ERP_SLZZ")] + public int? ErpSlzz { get; set; } + + /// <summary> + /// 鏄惁閫�搴� + /// </summary> + [SugarColumn(ColumnName = "ERP_RKZZ")] + public int? ErpRkzz { get; set; } + + /// <summary> + /// 鏄惁鎹㈣揣 + /// </summary> + [SugarColumn(ColumnName = "ERP_RKHZ")] + public int? ErpRkhz { get; set; } + + /// <summary> + /// 鏄惁瀵勫敭 + /// </summary> + [SugarColumn(ColumnName = "ERP_JJDS")] + public int? ErpJjds { get; set; } + + /// <summary> + /// 鏄惁鎸夋 + /// </summary> + [SugarColumn(ColumnName = "ERP_BZDS")] + public int? ErpBzds { get; set; } + + /// <summary> + /// 鏄惁鏂板缓 + /// </summary> + [SugarColumn(ColumnName = "CAA025")] + public int? Caa025 { get; set; } + + /// <summary> + /// 閲囪喘璁㈠崟鍙� + /// </summary> + [SugarColumn(ColumnName = "FPURORDERNO")] + public string? Fpurorderno { get; set; } + + /// <summary> + /// 閲囪喘璁㈠崟琛屽彿 + /// </summary> + [SugarColumn(ColumnName = "FPURORDERENTRYSEQ")] + public string? Fpurorderentryseq { get; set; } + + /// <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; } + + /// <summary> + /// 1锛屾柊澧烇紱2锛屽彉鏇� + /// </summary> + [SugarColumn(ColumnName = "TYPEA")] + public string? Typea { get; set; } +} \ No newline at end of file -- Gitblit v1.9.3