From 4456f43c6c73185a9f7ce46cdcdf94ab2053f02e Mon Sep 17 00:00:00 2001
From: zs <zhousong@weben-smart.com>
Date: 周三, 07 5月 2025 14:19:43 +0800
Subject: [PATCH] 修改生成器及出入库记录页面

---
 Weben_CMS专用代码生成器/Code/Utility/StructStrHelper.cs |  132 ++++++++++++++++++++++++++++++-------------
 1 files changed, 92 insertions(+), 40 deletions(-)

diff --git "a/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Code/Utility/StructStrHelper.cs" "b/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Code/Utility/StructStrHelper.cs"
index 0235276..c8726a8 100644
--- "a/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Code/Utility/StructStrHelper.cs"
+++ "b/Weben_CMS\344\270\223\347\224\250\344\273\243\347\240\201\347\224\237\346\210\220\345\231\250/Code/Utility/StructStrHelper.cs"
@@ -85,7 +85,7 @@
                         model = new ColumnModel();
                         if (dt.Rows[n]["Precision"].ToString() != "")
                         {
-                            model.Precision = int.Parse(dt.Rows[n]["Precision"].ToString());
+                            model.MyPrecision = int.Parse(dt.Rows[n]["Precision"].ToString());
                         }
                         if (dt.Rows[n]["Scale"].ToString() != "")
                         {
@@ -243,7 +243,7 @@
                     case DataTypeEnum.dt_datetime:
                     case DataTypeEnum.dt_datetime2:
                     case DataTypeEnum.dt_datetimeoffset:
-                        attrStr += "        public datetime" + str_NullFlag + attr + " { get; set; }\n";
+                        attrStr += "        public DateTime" + str_NullFlag + attr + " { get; set; }\n";
                         attrStr += "\n";//鏈�鍚庢槸鍔犱竴涓┖鏍�
                         break;
                     case DataTypeEnum.dt_bigint:
@@ -304,6 +304,30 @@
 
                 string attrStr = "";
                 attrStr += $"        updateObj.{attr} = input.{attr};\n";
+
+
+                return attrStr;
+            }
+            catch (Exception ex)
+            {
+                throw ex;
+            }
+
+        }
+
+        public static string GenerateAttribute_AppService_ImportAsync(ColumnModel columnModel, GenerateCodeParam param)
+        {
+            try
+            {
+                /*
+                 
+                MaterialCode = impItem.MaterialCode,
+                
+                 */
+                string attr = columnModel.ColumnName;
+
+                string attrStr = "";
+                attrStr += $"{attr} = impItem.{attr},\n";
 
 
                 return attrStr;
@@ -540,7 +564,7 @@
                     case DataTypeEnum.dt_datetime:
                     case DataTypeEnum.dt_datetime2:
                     case DataTypeEnum.dt_datetimeoffset:
-                        attrStr += "        public datetime" + str_NullFlag + attr + " { get; set; }\n";
+                        attrStr += "        public DateTime" + str_NullFlag + attr + " { get; set; }\n";
                         attrStr += "\n";//鏈�鍚庢槸鍔犱竴涓┖鏍�
                         break;
                     case DataTypeEnum.dt_bigint:
@@ -863,7 +887,7 @@
                     case DataTypeEnum.dt_decimal:
                     case DataTypeEnum.dt_float:
                         sql.Append("@" + attrColumnName + "  " + columnModel.DataType
-                            + "(" + columnModel.Precision.ToString() + "," + columnModel.Scale.ToString() + ")  " + fuhao + "\n");
+                            + "(" + columnModel.MyPrecision.ToString() + "," + columnModel.Scale.ToString() + ")  " + fuhao + "\n");
                         break;
                     default:
                         break;
@@ -925,7 +949,7 @@
                     case DataTypeEnum.dt_decimal:
                     case DataTypeEnum.dt_float:
                         sql.Append("@" + attrColumnName + "  " + columnModel.DataType
-                            + "(" + columnModel.Precision.ToString() + "," + columnModel.Scale.ToString() + ")  " + fuhao + "\n");
+                            + "(" + columnModel.MyPrecision.ToString() + "," + columnModel.Scale.ToString() + ")  " + fuhao + "\n");
                         break;
                     default:
                         break;
@@ -986,7 +1010,7 @@
                     case DataTypeEnum.dt_decimal:
                     case DataTypeEnum.dt_float:
                         sql.Append("@" + attrColumnName + "  " + columnModel.DataType
-                            + "(" + columnModel.Precision.ToString() + "," + columnModel.Scale.ToString() + ")  " + fuhao);
+                            + "(" + columnModel.MyPrecision.ToString() + "," + columnModel.Scale.ToString() + ")  " + fuhao);
                         break;
                     default:
                         break;
@@ -1821,9 +1845,9 @@
                     var elment = "input";
                     switch (enumDT)
                     {
-                        case DataTypeEnum.dt_datetime:
-                            elment = "date-picker";
-                            break;
+                        //case DataTypeEnum.dt_datetime:
+                        //    elment = "date-picker";
+                        //    break;
                         case DataTypeEnum.dt_bit:
                         case DataTypeEnum.dt_tinyint:
                             elment = "select";
@@ -1839,7 +1863,15 @@
                     switch (enumDT)
                     {
                         case DataTypeEnum.dt_datetime:
-                            sb.Append("                   type: 'datetimerange', \n");
+                            sb.Append("                   el: (props: any, { attrs }: SetupContext) => { \n");
+                            sb.Append("                     return h(datePicker, {  \n");
+                            sb.Append("                       ...props,  \n");
+                            sb.Append("                       clearable: true,  \n");
+                            sb.Append("                       ...attrs,  \n");
+                            sb.Append("                     })  \n");
+                            sb.Append("                   },\n");
+
+                            sb.Append("                   width: '100%',\n");
                             break;
                         default:
                             break;
@@ -1855,12 +1887,14 @@
                         sb.Append("                     })  \n");
                         sb.Append("                   },\n");
 
+                        sb.Append("                   width: '100%',\n");
                         //閰嶇疆绮惧害锛熻繖閲岄渶瑕佽幏鍙栨暟鎹簱涓殑绮惧害锛侊紒锛乀ODO锛�
                         sb.Append("                   step: 0.01,\n");
                         sb.Append("                   precision: 2, \n");
                     }
                     else if (enumDT == DataTypeEnum.dt_int)
                     {
+                        bool isWriteInt = true;
                         //鍒ゆ柇鏄惁鏄笅鎷夌被鍨�
                         //澧炲姞瀵规灇涓剧被鍨嬬殑鏀寔 
                         if (param.EnumList?.Count > 0)
@@ -1870,9 +1904,10 @@
                             {
                                 elment = "select";
                                 sb.Append("                   el: '" + elment + "', \n");
+                                isWriteInt = false;
                             }
                         }
-                        else
+                        if(isWriteInt)
                         {
                             sb.Append("                   el: (props: any, { attrs }: SetupContext) => { \n");
                             sb.Append("                     return h(inputNumber, {  \n");
@@ -1881,7 +1916,7 @@
                             sb.Append("                       ...attrs,  \n");
                             sb.Append("                     })  \n");
                             sb.Append("                   },\n");
-
+                            sb.Append("                   width: '100%',\n");
                             //閰嶇疆绮惧害锛�
                             sb.Append("                   step: 1,\n");
                             sb.Append("                   precision: 0, \n");
@@ -1899,15 +1934,15 @@
                         sb.Append("              rules: [{required: true, message: '" + columnModel.Description + "涓嶈兘涓虹┖', trigger: 'blur' }], \n");
                     }
                     //娣诲姞绫诲瀷
-                    //switch (enumDT)
-                    //{
-                    //    case DataTypeEnum.dt_bit:
-                    //    case DataTypeEnum.dt_tinyint:
-                    //        sb.Append("                 options: [{label: '鏄�',value: 'true'}, {label: '鍚�',value: 'false'}] \n");
-                    //        break;
-                    //    default:
-                    //        break;
-                    //}
+                    switch (enumDT)
+                    {
+                        case DataTypeEnum.dt_bit:
+                        case DataTypeEnum.dt_tinyint:
+                            sb.Append("                 options: [{label: '鏄�',value: 'true'}, {label: '鍚�',value: 'false'}] \n");
+                            break;
+                        default:
+                            break;
+                    }
                     sb.Append("                }, \n");
                 }
                 //鍘绘帀鏈�鍚庝竴涓�,
@@ -1940,8 +1975,8 @@
       placeholder: '璇疯緭鍏ョ墿鏂欑紪鐮�',
     },
                  */
-                List<ColumnModel> newList = ListHelper.RemoveForPageAddFormAttributes(columnModelList);
-                foreach (var columnModel in newList)
+                //List<ColumnModel> newList = ListHelper.RemoveForPageAddFormAttributes(columnModelList);
+                foreach (var columnModel in columnModelList)
                 {
                     //棣栧瓧姣嶅皬鍐�
                     var low_prop_ColumnName = CommonHelper.FirstLowercase(columnModel.ColumnName);
@@ -1949,9 +1984,9 @@
                     var elment = "input";
                     switch (enumDT)
                     {
-                        case DataTypeEnum.dt_datetime:
-                            elment = "date-picker";
-                            break;
+                        //case DataTypeEnum.dt_datetime:
+                        //    elment = "date-picker";
+                        //    break;
                         case DataTypeEnum.dt_bit:
                         case DataTypeEnum.dt_tinyint:
                             elment = "select";
@@ -1967,7 +2002,15 @@
                     switch (enumDT)
                     {
                         case DataTypeEnum.dt_datetime:
-                            sb.Append("                   type: 'datetimerange', \n");
+                            sb.Append("                   el: (props: any, { attrs }: SetupContext) => { \n");
+                            sb.Append("                     return h(dateTimePickerRange, {  \n");
+                            sb.Append("                       ...props,\n");
+                            sb.Append("                       clearable: true, \n");
+                            sb.Append("                       ...attrs,  \n");
+                            sb.Append("                     })  \n");
+                            sb.Append("                   },\n");
+
+                            sb.Append("                   width: '100%',\n");
                             break;
                         default:
                             break;
@@ -1983,12 +2026,14 @@
                         sb.Append("                     })  \n");
                         sb.Append("                   },\n");
 
+                        sb.Append("                   width: '100%',\n");
                         //閰嶇疆绮惧害锛熻繖閲岄渶瑕佽幏鍙栨暟鎹簱涓殑绮惧害锛侊紒锛乀ODO锛�
                         sb.Append("                   step: 0.01,\n");
                         sb.Append("                   precision: 2, \n");
                     }
                     else if (enumDT == DataTypeEnum.dt_int)
                     {
+                        bool isWriteInt = true;
                         //鍒ゆ柇鏄惁鏄笅鎷夌被鍨�
                         //澧炲姞瀵规灇涓剧被鍨嬬殑鏀寔 
                         if (param.EnumList?.Count > 0)
@@ -1998,9 +2043,10 @@
                             {
                                 elment = "select";
                                 sb.Append("                   el: '" + elment + "', \n");
+                                isWriteInt = false;
                             }
                         }
-                        else
+                        if (isWriteInt)
                         {
                             sb.Append("                   el: (props: any, { attrs }: SetupContext) => { \n");
                             sb.Append("                     return h(inputNumber, {  \n");
@@ -2010,6 +2056,7 @@
                             sb.Append("                     })  \n");
                             sb.Append("                   },\n");
 
+                            sb.Append("                   width: '100%',\n");
                             //閰嶇疆绮惧害锛�
                             sb.Append("                   step: 1,\n");
                             sb.Append("                   precision: 0, \n");
@@ -2022,17 +2069,17 @@
 
                     sb.Append("                   //disabled: disabled, \n");
                     sb.Append("                   placeholder: '璇疯緭鍏�" + columnModel.Description + "', \n");
-                  
+
                     //娣诲姞绫诲瀷
-                    //switch (enumDT)
-                    //{
-                    //    case DataTypeEnum.dt_bit:
-                    //    case DataTypeEnum.dt_tinyint:
-                    //        sb.Append("                 options: [{label: '鏄�',value: 'true'}, {label: '鍚�',value: 'false'}] \n");
-                    //        break;
-                    //    default:
-                    //        break;
-                    //}
+                    switch (enumDT)
+                    {
+                        case DataTypeEnum.dt_bit:
+                        case DataTypeEnum.dt_tinyint:
+                            sb.Append("                 options: [{label: '鏄�',value: 'true'}, {label: '鍚�',value: 'false'}] \n");
+                            break;
+                        default:
+                            break;
+                    }
                     sb.Append("                }, \n");
                 }
                 //鍘绘帀鏈�鍚庝竴涓�,
@@ -2168,10 +2215,15 @@
                 /*
                   materialCode: formData.value.materialCode,
                  */
-                List<ColumnModel> newList = ListHelper.RemoveForPageAddFormAttributes(columnModelList);
+                List<ColumnModel> newList = ListHelper.RemoveAttrForQueryMode(columnModelList);
                 foreach (var columnModel in newList)
                 {
-                    sb.Append($"{columnModel.ColumnName}: formData.value.{columnModel.ColumnName}, \n");
+
+                    //棣栧瓧姣嶅皬鍐�
+                    var low_prop_ColumnName = CommonHelper.FirstLowercase(columnModel.ColumnName);
+                    sb.Append($"{low_prop_ColumnName}: formData.value.{low_prop_ColumnName} || '', \n");
+
+
                 }
                 //鍘绘帀鏈�鍚庝竴涓�,
                 var res = sb.ToString();

--
Gitblit v1.9.3