From 736fb5782d375908a9097780743913193ffde494 Mon Sep 17 00:00:00 2001
From: kazelee <1847801760@qq.com>
Date: 星期四, 03 七月 2025 17:28:14 +0800
Subject: [PATCH] 完善部分日志内容,优化查询语句和日志打印代码

---
 api/ApiModel.cs |  456 +++++++++++++++++++++++++++++++++++++++++++++------------
 1 files changed, 360 insertions(+), 96 deletions(-)

diff --git a/api/ApiModel.cs b/api/ApiModel.cs
index efdf074..a6b444e 100644
--- a/api/ApiModel.cs
+++ b/api/ApiModel.cs
@@ -22,8 +22,10 @@
         /// </summary>
         /// <param name="code"></param>
         /// <param name="message"></param>
+        /// <param name="log"></param>
         /// <returns></returns>
-        public static SimpleResult NewSimpleResult(int code, string message) {
+        public static SimpleResult NewSimpleResult(int code, string message, bool log = true) {
+            if (log) { LogHelper.Info(message); }
             return new SimpleResult { resultCode = code, resultMsg = message };
         }
 
@@ -440,262 +442,262 @@
             /// <summary>
             /// 璁″垝鍗曞彿锛堝敮涓�爣璇嗭級
             /// </summary>
-            public string jhdh { get; set; }
+            public string jhdh { get; set; } = string.Empty;
 
             /// <summary>
             /// 鍑哄簱鐘舵�
             /// </summary>
-            public string ckzt { get; set; }
+            public string ckzt { get; set; } = string.Empty;// 闇�杩斿洖
 
             /// <summary>
             /// 璁″垝绫诲埆
             /// </summary>
-            public string jhlb { get; set; }
+            public string jhlb { get; set; } = string.Empty;
 
             /// <summary>
             /// 鍙傝�鍗曞彿
             /// </summary>
-            public string ckdh { get; set; }
+            public string ckdh { get; set; } = string.Empty;
 
             /// <summary>
             /// 杞︾墝鍙�             /// </summary>
-            public string cph { get; set; }
+            public string cph { get; set; } = string.Empty;
 
             /// <summary>
             /// 杩愯緭鏂瑰紡
             /// </summary>
-            public string ysfs { get; set; }
+            public string ysfs { get; set; } = string.Empty;
 
             /// <summary>
             /// 浜у搧鐘舵�
             /// </summary>
-            public string cpzt { get; set; }
+            public string cpzt { get; set; } = string.Empty;
 
             /// <summary>
             /// 涔版柇鍗曚綅
             /// </summary>
-            public string mddw { get; set; }
+            public string mddw { get; set; } = string.Empty;
 
             /// <summary>
             /// 浜у搧浠g爜
             /// </summary>
-            public string cpdm { get; set; }
+            public string cpdm { get; set; } = string.Empty;
 
             /// <summary>
             /// 浜у搧绫诲埆
             /// </summary>
-            public string cplb { get; set; }
+            public string cplb { get; set; } = string.Empty;
 
             /// <summary>
             /// 浜у搧绫诲埆鏄庣粏
             /// </summary>
-            public string cplbmx { get; set; }
+            public string cplbmx { get; set; } = string.Empty;
 
             /// <summary>
             /// 鍝佺墝
             /// </summary>
-            public string pp { get; set; }
+            public string pp { get; set; } = string.Empty;
 
             /// <summary>
             /// 绛夌骇
             /// </summary>
-            public string dj { get; set; }
+            public string dj { get; set; } = string.Empty;// 闇�杩斿洖
 
             /// <summary>
             /// 缃愬彿
             /// </summary>
-            public string gh { get; set; }
+            public string gh { get; set; } = string.Empty;
 
             /// <summary>
             /// 鎵瑰彿
             /// </summary>
-            public string ph { get; set; }
+            public string ph { get; set; } = string.Empty;// 闇�杩斿洖
 
             /// <summary>
             /// 鍖呰绫诲瀷
             /// </summary>
-            public string bzlx { get; set; }
+            public string bzlx { get; set; } = string.Empty;
 
             /// <summary>
             /// 娲捐鍗曞彿
             /// </summary>
-            public string pzdh { get; set; }
+            public string pzdh { get; set; } = string.Empty;
 
             /// <summary>
             /// 娲捐鍗曞崟浣�             /// </summary>
-            public string pzd_dw { get; set; }
+            public string pzd_dw { get; set; } = string.Empty;
 
             /// <summary>
             /// 娲捐鍗曡皟杩愮紪鍙�             /// </summary>
-            public string pzd_dybh { get; set; }
+            public string pzd_dybh { get; set; } = string.Empty;
 
             /// <summary>
             /// 娲捐浠舵暟
             /// </summary>
-            public double pzjs { get; set; }
+            public double pzjs { get; set; } = 0;
 
             /// <summary>
             /// 娲捐鏁伴噺
             /// </summary>
-            public decimal pzsl { get; set; }
+            public decimal pzsl { get; set; } = 0;
 
             /// <summary>
             /// 娲捐鏃ユ湡(yyyy-mm-dd)
             /// </summary>
-            public string pz_rq { get; set; }
+            public string pz_rq { get; set; } = string.Empty;
 
             /// <summary>
             /// 娲捐鎿嶄綔鏃ユ湡
             /// </summary>
-            public long pz_czrq { get; set; }
+            public long pz_czrq { get; set; } = 0;
 
             /// <summary>
             /// 娲捐浣滃簾鏍囪
             /// </summary>
-            public int pz_zfbj { get; set; }
+            public int pz_zfbj { get; set; } = 0;
 
             /// <summary>
             /// 娲捐浣滃簾鏃ユ湡
             /// </summary>
-            public long pz_zfrq { get; set; }
+            public long pz_zfrq { get; set; } = 0;
 
             /// <summary>
             /// 娲捐澶囨敞
             /// </summary>
-            public string pz_bz { get; set; }
+            public string pz_bz { get; set; } = string.Empty;
 
             /// <summary>
             /// 鍑哄簱鍗曠紪鍙�             /// </summary>
-            public string ckdbh { get; set; }
+            public string ckdbh { get; set; } = string.Empty;
 
             /// <summary>
             /// 瀹炲彂浠舵暟
             /// </summary>
-            public double sfjs { get; set; }
+            public double sfjs { get; set; } = 0; // 闇�杩斿洖
 
             /// <summary>
             /// 瀹炲彂鏁伴噺
             /// </summary>
-            public decimal sfsl { get; set; }
+            public decimal sfsl { get; set; } = 0; // 闇�杩斿洖
 
             /// <summary>
             /// 瀹炲彂杞︽暟
             /// </summary>
-            public int sfcs { get; set; }
+            public int sfcs { get; set; } = 0; // 闇�杩斿洖
 
             /// <summary>
             /// 瑁呰溅鏃堕棿
             /// </summary>
-            public string zcsj { get; set; }
+            public string zcsj { get; set; } = string.Empty; // 闇�杩斿洖
 
             /// <summary>
             /// 璁¢噺鍗曚綅
             /// </summary>
-            public string jldw { get; set; }
+            public string jldw { get; set; } = string.Empty;// 闇�杩斿洖
 
             /// <summary>
             /// 鍙戣揣鏃ユ湡
             /// </summary>
-            public long fhrq { get; set; }
+            public long fhrq { get; set; } = 0; // 闇�杩斿洖
 
             /// <summary>
             /// 浠撳簱浠g爜
             /// </summary>
-            public string ckdm { get; set; }
+            public string ckdm { get; set; } = string.Empty; // 闇�杩斿洖
 
             /// <summary>
             /// 鍙戣揣浜�             /// </summary>
-            public string fhr { get; set; }
+            public string fhr { get; set; } = string.Empty; // 闇�杩斿洖
 
             /// <summary>
             /// 鎿嶄綔鍛�             /// </summary>
-            public string czydm { get; set; }
+            public string czydm { get; set; } = string.Empty; // 闇�杩斿洖
 
             /// <summary>
             /// 瀹℃牳浜�             /// </summary>
-            public string shr_username { get; set; }
+            public string shr_username { get; set; } = string.Empty;
 
             /// <summary>
             /// 瀹℃牳鏃ユ湡
             /// </summary>
-            public long shrq { get; set; }
+            public long shrq { get; set; } = 0;
 
             /// <summary>
             /// 浣滃簾鏍囪
             /// </summary>
-            public long zfbj { get; set; }
+            public long zfbj { get; set; } = 0;
 
             /// <summary>
             /// 浣滃簾鏃ユ湡
             /// </summary>
-            public long zfrq { get; set; }
+            public long zfrq { get; set; } = 0;
 
             /// <summary>
             /// 缁撶畻鍗曚綅
             /// </summary>
-            public string jsdw { get; set; }
+            public string jsdw { get; set; } = string.Empty;
 
             /// <summary>
             /// 鏀惰揣鍗曚綅
             /// </summary>
-            public string shdw { get; set; }
+            public string shdw { get; set; } = string.Empty;
 
             /// <summary>
             /// 杩愯緭鍗曚綅
             /// </summary>
-            public string ysdw { get; set; }
+            public string ysdw { get; set; } = string.Empty;
 
             /// <summary>
             /// 鑱旂郴浜�             /// </summary>
-            public string lxr { get; set; }
+            public string lxr { get; set; } = string.Empty;
 
             /// <summary>
             /// 瑁呭嵏宸�             /// </summary>
-            public string ry_zxg { get; set; }
+            public string ry_zxg { get; set; } = string.Empty; // 闇�杩斿洖
 
             /// <summary>
             /// 鍙夎溅鍙告満
             /// </summary>
-            public string ry_ccsj { get; set; }
+            public string ry_ccsj { get; set; } = string.Empty; // 闇�杩斿洖
 
             /// <summary>
             /// erp浜よ揣鍗曞彿
             /// </summary>
-            public string erphx_jhdh { get; set; }
+            public string erphx_jhdh { get; set; } = string.Empty;
 
             /// <summary>
             /// erp鐗╂枡缂栫爜
             /// </summary>
-            public string erphx_wlbm { get; set; }
+            public string erphx_wlbm { get; set; } = string.Empty;
 
             /// <summary>
             /// erp鐗╂枡鍚嶇О
             /// </summary>
-            public string erphx_wlmc { get; set; }
+            public string erphx_wlmc { get; set; } = string.Empty;
 
             /// <summary>
             /// erp鍒涘缓鏃ユ湡
             /// </summary>
-            public string erphx_cjrq { get; set; }
+            public string erphx_cjrq { get; set; } = string.Empty;
 
             /// <summary>
             /// 璐т綅
             /// </summary>
-            public string hw { get; set; }
+            public string hw { get; set; } = string.Empty; // 闇�杩斿洖
 
             /// <summary>
             /// 璐т綅鐘舵�
             /// </summary>
-            public string hwzt { get; set; }
+            public string hwzt { get; set; } = string.Empty; // 闇�杩斿洖
         }
 
         public class PickUpReturnErpInfo {
@@ -707,7 +709,7 @@
             /// <summary>
             /// 鍑哄簱鐘舵�
             /// </summary>
-            public string ckzt { get; set; }
+            public string ckzt { get; set; } // 闇�杩斿洖
 
             /// <summary>
             /// 璁″垝绫诲埆
@@ -762,7 +764,7 @@
             /// <summary>
             /// 绛夌骇
             /// </summary>
-            public string dj { get; set; }
+            public string dj { get; set; } // 闇�杩斿洖
 
             /// <summary>
             /// 缃愬彿
@@ -772,7 +774,7 @@
             /// <summary>
             /// 鎵瑰彿
             /// </summary>
-            public string ph { get; set; }
+            public string ph { get; set; } // 闇�杩斿洖
 
             /// <summary>
             /// 鍖呰绫诲瀷
@@ -837,47 +839,47 @@
             /// <summary>
             /// 瀹炲彂浠舵暟
             /// </summary>
-            public double sfjs { get; set; }
+            public double sfjs { get; set; } // 闇�杩斿洖
 
             /// <summary>
             /// 瀹炲彂鏁伴噺
             /// </summary>
-            public decimal sfsl { get; set; }
+            public decimal sfsl { get; set; } // 闇�杩斿洖
 
-            /// <summary>
-            /// 瀹炲彂杞︽暟
-            /// </summary>
-            public int sfcs { get; set; }
+            ///// <summary>
+            ///// 瀹炲彂杞︽暟
+            ///// </summary>
+            //public int sfcs { get; set; } // 闇�杩斿洖
 
-            /// <summary>
-            /// 瑁呰溅鏃堕棿
-            /// </summary>
-            public string zcsj { get; set; }
+            ///// <summary>
+            ///// 瑁呰溅鏃堕棿
+            ///// </summary>
+            //public string zcsj { get; set; } // 闇�杩斿洖
 
-            /// <summary>
-            /// 璁¢噺鍗曚綅
-            /// </summary>
-            public string jldw { get; set; }
+            ///// <summary>
+            ///// 璁¢噺鍗曚綅
+            ///// </summary>
+            //public string jldw { get; set; } // 闇�杩斿洖
 
-            /// <summary>
-            /// 鍙戣揣鏃ユ湡
-            /// </summary>
-            public long fhrq { get; set; }
+            ///// <summary>
+            ///// 鍙戣揣鏃ユ湡
+            ///// </summary>
+            //public long fhrq { get; set; } // 闇�杩斿洖
 
-            /// <summary>
-            /// 浠撳簱浠g爜
-            /// </summary>
-            public string ckdm { get; set; }
+            ///// <summary>
+            ///// 浠撳簱浠g爜
+            ///// </summary>
+            //public string ckdm { get; set; } // 闇�杩斿洖
 
-            /// <summary>
-            /// 鍙戣揣浜�-            /// </summary>
-            public string fhr { get; set; }
+            ///// <summary>
+            ///// 鍙戣揣浜�+            ///// </summary>
+            //public string fhr { get; set; } // 闇�杩斿洖
 
-            /// <summary>
-            /// 鎿嶄綔鍛�-            /// </summary>
-            public string czydm { get; set; }
+            ///// <summary>
+            ///// 鎿嶄綔鍛�+            ///// </summary>
+            //public string czydm { get; set; } // 闇�杩斿洖
 
             /// <summary>
             /// 瀹℃牳浜�@@ -919,15 +921,15 @@
             /// </summary>
             public string lxr { get; set; }
 
-            /// <summary>
-            /// 瑁呭嵏宸�-            /// </summary>
-            public string ry_zxg { get; set; }
+            ///// <summary>
+            ///// 瑁呭嵏宸�+            ///// </summary>
+            //public string ry_zxg { get; set; } // 闇�杩斿洖
 
-            /// <summary>
-            /// 鍙夎溅鍙告満
-            /// </summary>
-            public string ry_ccsj { get; set; }
+            ///// <summary>
+            ///// 鍙夎溅鍙告満
+            ///// </summary>
+            //public string ry_ccsj { get; set; } // 闇�杩斿洖
 
             /// <summary>
             /// erp浜よ揣鍗曞彿
@@ -952,12 +954,274 @@
             /// <summary>
             /// 璐т綅
             /// </summary>
-            public string hw { get; set; }
+            public string hw { get; set; } // 闇�杩斿洖
 
             /// <summary>
             /// 璐т綅鐘舵�
             /// </summary>
-            public string hwzt { get; set; }
+            public string hwzt { get; set; } // 闇�杩斿洖
+        }
+
+        public class CreateTaskReturnErpInfo {
+            /// <summary>
+            /// 璁″垝鍗曞彿锛堝敮涓�爣璇嗭級
+            /// </summary>
+            public string jhdh { get; set; }
+
+            /// <summary>
+            /// 鍑哄簱鐘舵�
+            /// </summary>
+            public string ckzt { get; set; } // 闇�杩斿洖
+
+            /// <summary>
+            /// 璁″垝绫诲埆
+            /// </summary>
+            public string jhlb { get; set; }
+
+            /// <summary>
+            /// 鍙傝�鍗曞彿
+            /// </summary>
+            public string ckdh { get; set; }
+
+            /// <summary>
+            /// 杞︾墝鍙�+            /// </summary>
+            public string cph { get; set; }
+
+            /// <summary>
+            /// 杩愯緭鏂瑰紡
+            /// </summary>
+            public string ysfs { get; set; }
+
+            /// <summary>
+            /// 浜у搧鐘舵�
+            /// </summary>
+            public string cpzt { get; set; }
+
+            /// <summary>
+            /// 涔版柇鍗曚綅
+            /// </summary>
+            public string mddw { get; set; }
+
+            /// <summary>
+            /// 浜у搧浠g爜
+            /// </summary>
+            public string cpdm { get; set; }
+
+            /// <summary>
+            /// 浜у搧绫诲埆
+            /// </summary>
+            public string cplb { get; set; }
+
+            /// <summary>
+            /// 浜у搧绫诲埆鏄庣粏
+            /// </summary>
+            public string cplbmx { get; set; }
+
+            /// <summary>
+            /// 鍝佺墝
+            /// </summary>
+            public string pp { get; set; }
+
+            /// <summary>
+            /// 绛夌骇
+            /// </summary>
+            public string dj { get; set; } // 闇�杩斿洖
+
+            /// <summary>
+            /// 缃愬彿
+            /// </summary>
+            public string gh { get; set; }
+
+            /// <summary>
+            /// 鎵瑰彿
+            /// </summary>
+            public string ph { get; set; } // 闇�杩斿洖
+
+            /// <summary>
+            /// 鍖呰绫诲瀷
+            /// </summary>
+            public string bzlx { get; set; }
+
+            /// <summary>
+            /// 娲捐鍗曞彿
+            /// </summary>
+            public string pzdh { get; set; }
+
+            /// <summary>
+            /// 娲捐鍗曞崟浣�+            /// </summary>
+            public string pzd_dw { get; set; }
+
+            /// <summary>
+            /// 娲捐鍗曡皟杩愮紪鍙�+            /// </summary>
+            public string pzd_dybh { get; set; }
+
+            /// <summary>
+            /// 娲捐浠舵暟
+            /// </summary>
+            public double pzjs { get; set; }
+
+            /// <summary>
+            /// 娲捐鏁伴噺
+            /// </summary>
+            public decimal pzsl { get; set; }
+
+            /// <summary>
+            /// 娲捐鏃ユ湡(yyyy-mm-dd)
+            /// </summary>
+            public string pz_rq { get; set; }
+
+            /// <summary>
+            /// 娲捐鎿嶄綔鏃ユ湡
+            /// </summary>
+            public long pz_czrq { get; set; }
+
+            /// <summary>
+            /// 娲捐浣滃簾鏍囪
+            /// </summary>
+            public int pz_zfbj { get; set; }
+
+            /// <summary>
+            /// 娲捐浣滃簾鏃ユ湡
+            /// </summary>
+            public long pz_zfrq { get; set; }
+
+            /// <summary>
+            /// 娲捐澶囨敞
+            /// </summary>
+            public string pz_bz { get; set; }
+
+            /// <summary>
+            /// 鍑哄簱鍗曠紪鍙�+            /// </summary>
+            public string ckdbh { get; set; }
+
+            ///// <summary>
+            ///// 瀹炲彂浠舵暟
+            ///// </summary>
+            //public double sfjs { get; set; } // 闇�杩斿洖
+
+            ///// <summary>
+            ///// 瀹炲彂鏁伴噺
+            ///// </summary>
+            //public decimal sfsl { get; set; } // 闇�杩斿洖
+
+            ///// <summary>
+            ///// 瀹炲彂杞︽暟
+            ///// </summary>
+            //public int sfcs { get; set; } // 闇�杩斿洖
+
+            ///// <summary>
+            ///// 瑁呰溅鏃堕棿
+            ///// </summary>
+            //public string zcsj { get; set; } // 闇�杩斿洖
+
+            ///// <summary>
+            ///// 璁¢噺鍗曚綅
+            ///// </summary>
+            //public string jldw { get; set; } // 闇�杩斿洖
+
+            ///// <summary>
+            ///// 鍙戣揣鏃ユ湡
+            ///// </summary>
+            //public long fhrq { get; set; } // 闇�杩斿洖
+
+            ///// <summary>
+            ///// 浠撳簱浠g爜
+            ///// </summary>
+            //public string ckdm { get; set; } // 闇�杩斿洖
+
+            ///// <summary>
+            ///// 鍙戣揣浜�+            ///// </summary>
+            //public string fhr { get; set; } // 闇�杩斿洖
+
+            ///// <summary>
+            ///// 鎿嶄綔鍛�+            ///// </summary>
+            //public string czydm { get; set; } // 闇�杩斿洖
+
+            /// <summary>
+            /// 瀹℃牳浜�+            /// </summary>
+            public string shr_username { get; set; }
+
+            /// <summary>
+            /// 瀹℃牳鏃ユ湡
+            /// </summary>
+            public long shrq { get; set; }
+
+            /// <summary>
+            /// 浣滃簾鏍囪
+            /// </summary>
+            public long zfbj { get; set; }
+
+            /// <summary>
+            /// 浣滃簾鏃ユ湡
+            /// </summary>
+            public long zfrq { get; set; }
+
+            /// <summary>
+            /// 缁撶畻鍗曚綅
+            /// </summary>
+            public string jsdw { get; set; }
+
+            /// <summary>
+            /// 鏀惰揣鍗曚綅
+            /// </summary>
+            public string shdw { get; set; }
+
+            /// <summary>
+            /// 杩愯緭鍗曚綅
+            /// </summary>
+            public string ysdw { get; set; }
+
+            /// <summary>
+            /// 鑱旂郴浜�+            /// </summary>
+            public string lxr { get; set; }
+
+            ///// <summary>
+            ///// 瑁呭嵏宸�+            ///// </summary>
+            //public string ry_zxg { get; set; } // 闇�杩斿洖
+
+            ///// <summary>
+            ///// 鍙夎溅鍙告満
+            ///// </summary>
+            //public string ry_ccsj { get; set; } // 闇�杩斿洖
+
+            /// <summary>
+            /// erp浜よ揣鍗曞彿
+            /// </summary>
+            public string erphx_jhdh { get; set; }
+
+            /// <summary>
+            /// erp鐗╂枡缂栫爜
+            /// </summary>
+            public string erphx_wlbm { get; set; }
+
+            /// <summary>
+            /// erp鐗╂枡鍚嶇О
+            /// </summary>
+            public string erphx_wlmc { get; set; }
+
+            /// <summary>
+            /// erp鍒涘缓鏃ユ湡
+            /// </summary>
+            public string erphx_cjrq { get; set; }
+
+            /// <summary>
+            /// 璐т綅
+            /// </summary>
+            public string hw { get; set; } // 闇�杩斿洖
+
+            /// <summary>
+            /// 璐т綅鐘舵�
+            /// </summary>
+            public string hwzt { get; set; } // 闇�杩斿洖
         }
     }
 }

--
Gitblit v1.9.1