From 8a53164b2ff75612596a7c65eda284b5a03e01f1 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期四, 24 七月 2025 23:31:04 +0800
Subject: [PATCH] Update SJService getPage method to return total count like LljService
---
StandardPda/MES.Service/Modes/Womcaa.cs | 167 ++++++++++++++++++++++++++++++++++++++++++++++++++++---
1 files changed, 158 insertions(+), 9 deletions(-)
diff --git a/StandardPda/MES.Service/Modes/Womcaa.cs b/StandardPda/MES.Service/Modes/Womcaa.cs
index b0b4511..87476d1 100644
--- a/StandardPda/MES.Service/Modes/Womcaa.cs
+++ b/StandardPda/MES.Service/Modes/Womcaa.cs
@@ -9,10 +9,9 @@
public class Womcaa
{
/// <summary>
- /// 鑷鍒� SEQ_CAA
+ /// 鑷鍒�
/// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_CAA",
- IsPrimaryKey = true)]
+ [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_CAA", IsPrimaryKey = true)]
public decimal Id { get; set; }
/// <summary>
@@ -307,19 +306,19 @@
/// 鏃х墿鏂欑紪鐮�
/// </summary>
[SugarColumn(ColumnName = "F_WWC_BASEPROPERTY")]
- public string? FWwcBaseproperty { get; set; }
+ public string? FwwcBaseproperty { get; set; }
/// <summary>
/// 璁″垝瀹屽伐鎼哄甫鏃ユ湡
/// </summary>
[SugarColumn(ColumnName = "F_WWC_DATETIME")]
- public DateTime? FWwcDatetime { get; set; }
+ public DateTime? FwwcDatetime { get; set; }
/// <summary>
/// 鐢熶骇鍏ュ簱鏃ユ湡
/// </summary>
[SugarColumn(ColumnName = "F_WWC_SCRKRQ")]
- public DateTime? FWwcScrkrq { get; set; }
+ public DateTime? FwwcScrkrq { get; set; }
/// <summary>
/// 宸ユ椂
@@ -331,19 +330,19 @@
/// 浜х嚎浜烘暟
/// </summary>
[SugarColumn(ColumnName = "F_WWC_DECIMAL")]
- public decimal? FWwcDecimal { get; set; }
+ public decimal? FwwcDecimal { get; set; }
/// <summary>
/// 绾垮埆
/// </summary>
[SugarColumn(ColumnName = "F_WWC_XB")]
- public string? FWwcXb { get; set; }
+ public string? FwwcXb { get; set; }
/// <summary>
/// 閿�鍞憳
/// </summary>
[SugarColumn(ColumnName = "F_WWC_BASE")]
- public string? FWwcBase { get; set; }
+ public string? FwwcBase { get; set; }
/// <summary>
/// 淇敼鏍囪瘑
@@ -380,4 +379,154 @@
/// </summary>
[SugarColumn(ColumnName = "FNOSTOCKINQTY")]
public decimal? Fnostockinqty { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛
+ /// </summary>
+ [SugarColumn(ColumnName = "F_ZSXG_KH")]
+ public string? FZsxgKh { get; set; }
+
+ /// <summary>
+ /// 瑕佽揣鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "F_ZJXF_YHRQ")]
+ public string? FZjxfYhrq { get; set; }
+
+ /// <summary>
+ /// BOM绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "BOMTYPE")]
+ public string? Bomtype { get; set; }
+
+ /// <summary>
+ /// BOM姣嶉」
+ /// </summary>
+ [SugarColumn(ColumnName = "BOMMASTER")]
+ public decimal? Bommaster { get; set; }
+
+ /// <summary>
+ /// BOM鐢熶骇鐩殑
+ /// </summary>
+ [SugarColumn(ColumnName = "BOMALTRNATE")]
+ public string? Bomaltrnate { get; set; }
+
+ /// <summary>
+ /// BOM鏈夋晥鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "BOMEFFEDATE")]
+ public string? Bomeffedate { get; set; }
+
+ /// <summary>
+ /// 宸ヨ壓鐢熶骇鐩殑
+ /// </summary>
+ [SugarColumn(ColumnName = "ROUTINGALTERNATE")]
+ public string? Routingalternate { get; set; }
+
+ /// <summary>
+ /// 宸ヨ壓鏈夋晥鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "ROUTINGEFFEDATE")]
+ public string? Routingeffedate { get; set; }
+
+ /// <summary>
+ /// MRP鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "MRPQTY")]
+ public decimal? Mrpqty { get; set; }
+
+ /// <summary>
+ /// 涓氬姟寮�濮嬫椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "ACTUALSTARTDATE")]
+ public DateTime? Actualstartdate { get; set; }
+
+ /// <summary>
+ /// 涓氬姟缁撴潫鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "ACTUALCOMPLETEDATE")]
+ public DateTime? Actualcompletedate { get; set; }
+
+ /// <summary>
+ /// 鏉ユ簮绫诲瀷
+ /// </summary>
+ [SugarColumn(ColumnName = "MOSOURCEDOCTYPE")]
+ public string? Mosourcedoctype { get; set; }
+
+ /// <summary>
+ /// 椤圭洰
+ /// </summary>
+ [SugarColumn(ColumnName = "PROJECT")]
+ public decimal? Project { get; set; }
+
+ /// <summary>
+ /// 璐т富缁勭粐
+ /// </summary>
+ [SugarColumn(ColumnName = "OWNERORG")]
+ public decimal? Ownerorg { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATEDBY")]
+ public string? Createdby { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "CREATEDON")]
+ public DateTime? Createdon { get; set; }
+
+ /// <summary>
+ /// 寮�宸ユ暟閲�
+ /// </summary>
+ [SugarColumn(ColumnName = "TOTALSTARTQTY")]
+ public decimal? Totalstartqty { get; set; }
+
+ /// <summary>
+ /// 瀹屽伐鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "TOTALCOMPLETEQTY")]
+ public decimal? Totalcompleteqty { get; set; }
+
+ /// <summary>
+ /// 鍏ュ簱鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "TOTALRCVQTY")]
+ public decimal? Totalrcvqty { get; set; }
+
+ /// <summary>
+ /// 杩斿伐鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "TOTALREWORKINGQTY")]
+ public decimal? Totalreworkingqty { get; set; }
+
+ /// <summary>
+ /// 杩斿伐鍘熷洜
+ /// </summary>
+ [SugarColumn(ColumnName = "REASONFORREWORK")]
+ public string? Reasonforrework { get; set; }
+
+ /// <summary>
+ /// 寮哄埗榻愬
+ /// </summary>
+ [SugarColumn(ColumnName = "ISFORCEWHOLESET")]
+ public decimal? Isforcewholeset { get; set; }
+
+ /// <summary>
+ /// 鍒嗗壊鍓嶅師璁㈠崟缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "PREVMO")]
+ public string? PREVMO { get; set; }
+
+ /// <summary>
+ /// 1锛屾柊澧烇紱2锛屽彉鏇�
+ /// </summary>
+ [SugarColumn(ColumnName = "TYPEA")]
+ public string? Typea { get; set; }
+
+ /// <summary>
+ /// 鎺ㄩ�佹椂闂�
+ /// </summary>
+ [SugarColumn(ColumnName = "TS_DATE")]
+ public DateTime? TsDate { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3