From 1cd4e66b490e4b6cc3368771cdff164990e152e7 Mon Sep 17 00:00:00 2001
From: cdk <2441919651@qq.com>
Date: 星期一, 22 十二月 2025 17:35:57 +0800
Subject: [PATCH] 接口增加单位换算，dab增加两个字段
---
MES.Service/Modes/Womcab.cs | 222 ++++++++++++++++++++++++++++++++++++-------------------
1 files changed, 145 insertions(+), 77 deletions(-)
diff --git a/MES.Service/Modes/Womcab.cs b/MES.Service/Modes/Womcab.cs
index 320f88b..7d0e202 100644
--- a/MES.Service/Modes/Womcab.cs
+++ b/MES.Service/Modes/Womcab.cs
@@ -1,206 +1,274 @@
-锘縰sing System;
-using System.Collections.Generic;
-using System.Linq;
-using SqlSugar;
+锘縰sing SqlSugar;
namespace MES.Service.Modes;
/// <summary>
-/// 浠诲姟鍗曠墿鏂欒〃
-///</summary>
+/// 浠诲姟鍗曠墿鏂欒〃bom
+/// </summary>
[SugarTable("WOMCAB")]
public class Womcab
{
/// <summary>
- /// 鑷鍒�
+ /// 榛樿鍊�: (newid())
/// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
- OracleSequenceName = "SEQ_AOI")]
- public decimal? Id { get; set; }
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
/// <summary>
- /// ERPID
- ///</summary>
+ /// ERPID
+ /// </summary>
[SugarColumn(ColumnName = "ERPID")]
- public decimal? Erpid { get; set; }
+ public int? Erpid { get; set; }
/// <summary>
- /// 宸ュ崟鍗曞彿
- ///</summary>
+ /// 宸ュ崟鍗曞彿
+ /// </summary>
[SugarColumn(ColumnName = "CAB001")]
public string Cab001 { get; set; }
/// <summary>
- /// 搴忓彿
- ///</summary>
+ /// 搴忓彿
+ /// </summary>
[SugarColumn(ColumnName = "CAB002")]
- public string Cab002 { get; set; }
+ public int? Cab002 { get; set; }
/// <summary>
- /// 鏉愭枡缂栫爜
- ///</summary>
+ /// 鏉愭枡缂栫爜
+ /// </summary>
[SugarColumn(ColumnName = "CAB003")]
public string Cab003 { get; set; }
/// <summary>
- /// 闇�棰嗙敤閲�
- ///</summary>
+ /// 闇�棰嗙敤閲�
+ /// </summary>
[SugarColumn(ColumnName = "CAB006")]
public decimal? Cab006 { get; set; }
/// <summary>
- /// 宸查鐢ㄩ噺
- ///</summary>
+ /// 宸查鐢ㄩ噺
+ /// </summary>
[SugarColumn(ColumnName = "CAB007")]
public decimal? Cab007 { get; set; }
/// <summary>
- /// 宸ヨ壓
- ///</summary>
+ /// 宸ヨ壓
+ /// </summary>
[SugarColumn(ColumnName = "CAB008")]
public string Cab008 { get; set; }
/// <summary>
- /// 鍗曚綅
- ///</summary>
+ /// 鍗曚綅
+ /// </summary>
[SugarColumn(ColumnName = "CAB009")]
public string Cab009 { get; set; }
/// <summary>
- /// 缁勬垚鐢ㄩ噺
- ///</summary>
+ /// 缁勬垚鐢ㄩ噺
+ /// </summary>
[SugarColumn(ColumnName = "CAB012")]
public decimal? Cab012 { get; set; }
/// <summary>
- /// 鏄惁鏇挎枡
- ///</summary>
+ /// 鏄惁鏇挎枡
+ /// </summary>
[SugarColumn(ColumnName = "CAB014")]
public string Cab014 { get; set; }
/// <summary>
- /// PID
- ///</summary>
+ /// PID
+ /// </summary>
[SugarColumn(ColumnName = "PID")]
- public decimal? Pid { get; set; }
+ public int? Pid { get; set; }
/// <summary>
- /// ERP澶碔D
- ///</summary>
+ /// ERP澶碔D
+ /// </summary>
[SugarColumn(ColumnName = "EID")]
- public decimal? Eid { get; set; }
+ public int? Eid { get; set; }
/// <summary>
- /// 浣嶇疆鍙�
- ///</summary>
+ /// 浣嶇疆鍙�
+ /// </summary>
[SugarColumn(ColumnName = "POSITION_NO")]
public string PositionNo { get; set; }
/// <summary>
- /// 鍙戞枡缁勭粐
- ///</summary>
+ /// 鍙戞枡缁勭粐
+ /// </summary>
[SugarColumn(ColumnName = "ISSUING_ORGANIZATION")]
public string IssuingOrganization { get; set; }
/// <summary>
- /// 渚涘簲缁勭粐
- ///</summary>
+ /// 渚涘簲缁勭粐
+ /// </summary>
[SugarColumn(ColumnName = "SUPPLY_ORGANIZATION")]
public string SupplyOrganization { get; set; }
/// <summary>
- /// 璐т富
- ///</summary>
+ /// 璐т富
+ /// </summary>
[SugarColumn(ColumnName = "OWNER_ID")]
public string OwnerId { get; set; }
/// <summary>
- /// 璁″垝璺熻釜鍙�
- ///</summary>
+ /// 璁″垝璺熻釜鍙�
+ /// </summary>
[SugarColumn(ColumnName = "MTONO")]
public string Mtono { get; set; }
/// <summary>
- /// 鎵瑰彿
- ///</summary>
+ /// 鎵瑰彿
+ /// </summary>
[SugarColumn(ColumnName = "LOT")]
public string Lot { get; set; }
/// <summary>
- /// 浠撳簱
- ///</summary>
+ /// 浠撳簱
+ /// </summary>
[SugarColumn(ColumnName = "DEPOT_CODE")]
public string DepotCode { get; set; }
/// <summary>
- /// 鍙戞枡鏂瑰紡
- ///</summary>
+ /// 鍙戞枡鏂瑰紡
+ /// </summary>
[SugarColumn(ColumnName = "ISSUE_TYPE")]
public string IssueType { get; set; }
/// <summary>
- /// 渚涘簲绫诲瀷(C閲囪喘 Z鑷埗 W濮斿)
- ///</summary>
+ /// 渚涘簲绫诲瀷(C閲囪喘 Z鑷埗 W濮斿)
+ /// </summary>
[SugarColumn(ColumnName = "SUPPLY_TYPE")]
public string SupplyType { get; set; }
/// <summary>
- /// 鍒嗗瓙
- ///</summary>
+ /// 鍒嗗瓙
+ /// </summary>
[SugarColumn(ColumnName = "NUMERATOR")]
public string Numerator { get; set; }
/// <summary>
- /// 鍒嗘瘝
- ///</summary>
+ /// 鍒嗘瘝
+ /// </summary>
[SugarColumn(ColumnName = "DENOMINATOR")]
public string Denominator { get; set; }
/// <summary>
- /// 鍥哄畾鎹熻��
- ///</summary>
+ /// 鍥哄畾鎹熻��
+ /// </summary>
[SugarColumn(ColumnName = "SCRAPQTY")]
public string Scrapqty { get; set; }
/// <summary>
- /// 鍙樺姩鎹熻�楃巼
- ///</summary>
+ /// 鍙樺姩鎹熻�楃巼
+ /// </summary>
[SugarColumn(ColumnName = "SCRAPRATE")]
public string Scraprate { get; set; }
/// <summary>
- /// 瀹㈡埛璐у彿
- ///</summary>
+ /// 瀹㈡埛璐у彿
+ /// </summary>
[SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")]
public string CustomerItemNumber { get; set; }
/// <summary>
- /// 鍖呰鍗曞彿
- ///</summary>
+ /// 鍖呰鍗曞彿
+ /// </summary>
[SugarColumn(ColumnName = "PACKING_LIST_NUMBER")]
public string PackingListNumber { get; set; }
/// <summary>
- /// 涓讳骇鍝�
- ///</summary>
+ /// 涓讳骇鍝�
+ /// </summary>
[SugarColumn(ColumnName = "MAIN_PRODUCT")]
public string MainProduct { get; set; }
/// <summary>
- /// 涓讳骇鍝佹暟閲�
- ///</summary>
+ /// 涓讳骇鍝佹暟閲�
+ /// </summary>
[SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")]
- public decimal? MainProductQty { get; set; }
+ public int? MainProductQty { get; set; }
/// <summary>
- /// 鐖堕」鐗╂枡鍚嶇О
- ///</summary>
+ /// 鐖堕」鐗╂枡鍚嶇О
+ /// </summary>
[SugarColumn(ColumnName = "PARENT_ITEM_NAME")]
public string ParentItemName { get; set; }
/// <summary>
- /// 閿�鍞鍗�
- ///</summary>
+ /// 閿�鍞鍗�
+ /// </summary>
[SugarColumn(ColumnName = "FSALEORDERNO")]
public string Fsaleorderno { get; set; }
+
+ /// <summary>
+ /// 璐т富绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "FOWNERTYPEID")]
+ public string Fownertypeid { get; set; }
+
+ /// <summary>
+ /// 椤规鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "FREPLACEGROUP")]
+ public int? Freplacegroup { get; set; }
+
+ /// <summary>
+ /// 閿�鍞鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "ERP_XSDDH")]
+ public string ErpXsddh { get; set; }
+
+ /// <summary>
+ /// 瀛愰」绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "FMATERIALTYPE")]
+ public string Fmaterialtype { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "FUNITID")]
+ public string Funitid { get; set; }
+
+ /// <summary>
+ /// 搴斿彂鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "Must_Qty")]
+ public decimal? MustQty { get; set; }
+
+ /// <summary>
+ /// 浣跨敤姣斾緥锛�%锛�
+ /// </summary>
+ [SugarColumn(ColumnName = "Use_Rate")]
+ public decimal? UseRate { get; set; }
+
+ /// <summary>
+ /// 瀛愰」绫诲瀷 1鏍囧噯浠� 2杩旇繕浠� 3鏇夸唬浠�
+ /// </summary>
+ [SugarColumn(ColumnName = "Material_Type")]
+ public string MaterialType { get; set; }
+
+ /// <summary>
+ /// A锛屽垱寤� B锛屽鏍镐腑 C锛屽凡瀹℃牳 D锛岄噸鏂板鏍� Z锛屾殏瀛�
+ /// </summary>
+ [SugarColumn(ColumnName = "TYPEB")]
+ public string? Typeb { get; set; }
+
+ /// <summary>
+ /// 搴斿彂鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "F_UNW_QTY_YFSL")]
+ public string? F_UNW_QTY_YFSL { get; set; }
+
+ /// <summary>
+ /// 鏄惁鍔犻攣erp涓嶈兘杩涜鐢ㄦ枡娓呭崟鍙樻洿
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_LOCK")]
+ public bool? IS_LOCK { get; set; }
+
+ /// <summary>
+ /// 鍔犻攣鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "IS_LOCK_DATE")]
+ public DateTime? IS_LOCK_DATE { get; set; }
+
}
\ No newline at end of file
--
Gitblit v1.9.3