From 13f8c1efe9aaf7b7d1e4e77107de61a56d6f9646 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周五, 09 5月 2025 08:42:20 +0800 Subject: [PATCH] 222 --- Weben_CMS专用代码生成器/Code/Utility/StructStrHelper.cs | 366 ++++++++++++++++++++++++++++++++++++++------------- 1 files changed, 272 insertions(+), 94 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 d03814a..c1a638d 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; @@ -1736,6 +1760,8 @@ List<ColumnModel> newList = ListHelper.RemoveIdOperationRemarkCreateIdModifyId(columnModelList); foreach (var columnModel in newList) { + //棣栧瓧姣嶅皬鍐� + var low_prop_ColumnName = CommonHelper.FirstLowercase(columnModel.ColumnName); DataTypeEnum enumDT = (DataTypeEnum)Enum.Parse(typeof(DataTypeEnum), "dt_" + columnModel.DataType.ToString()); var elment = "el-input"; switch (enumDT) @@ -1752,7 +1778,7 @@ } sb.Append(" { \n"); sb.Append(" label: '" + columnModel.Description + "', \n"); - sb.Append(" prop: '" + columnModel.ColumnName + "', \n"); + sb.Append(" prop: '" + low_prop_ColumnName + "', \n"); //娣诲姞绫诲瀷 switch (enumDT) @@ -1770,7 +1796,7 @@ { case DataTypeEnum.dt_bit: case DataTypeEnum.dt_tinyint: - sb.Append(" options: [{label: '鏄�',value: 'true'}, {label: '鍚�',value: 'false'}] \n"); + sb.Append(" options: [{label: '鏄�',value: true}, {label: '鍚�',value: false}] \n"); break; default: break; @@ -1794,7 +1820,7 @@ /// </summary> /// <param name="columnModelList"></param> /// <returns></returns> - public static string GetVueFormOptionsStrForPageAddFormAttributes(List<ColumnModel> columnModelList, GenerateCodeParam param) + public static string GetVueFormOptionsStrForPageAddFormAttributes_formItems(List<ColumnModel> columnModelList, GenerateCodeParam param) { StringBuilder sb = new StringBuilder(); try @@ -1812,13 +1838,16 @@ List<ColumnModel> newList = ListHelper.RemoveForPageAddFormAttributes(columnModelList); foreach (var columnModel in newList) { + + //棣栧瓧姣嶅皬鍐� + var low_prop_ColumnName = CommonHelper.FirstLowercase(columnModel.ColumnName); DataTypeEnum enumDT = (DataTypeEnum)Enum.Parse(typeof(DataTypeEnum), "dt_" + columnModel.DataType.ToString()); 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"; @@ -1828,34 +1857,56 @@ } sb.Append(" { \n"); sb.Append(" label: '" + columnModel.Description + "', \n"); - sb.Append(" prop: '" + columnModel.ColumnName + "', \n"); + sb.Append(" prop: '" + low_prop_ColumnName + "', \n"); //娣诲姞绫诲瀷 - switch (enumDT) - { - case DataTypeEnum.dt_datetime: - sb.Append(" type: 'datetimerange', \n"); - break; - default: - break; - } + //switch (enumDT) + //{ + // case DataTypeEnum.dt_datetime: + // 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"); - if (enumDT == DataTypeEnum.dt_decimal) + // sb.Append(" width: '100%',\n"); + // break; + // default: + // break; + //} + if (enumDT == DataTypeEnum.dt_datetime) { sb.Append(" el: (props: any, { attrs }: SetupContext) => { \n"); - sb.Append(" return h(inputNumber, { { \n"); - sb.Append(" ...props, { \n"); - sb.Append(" clearable: true, { \n"); - sb.Append(" ...attrs, { \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"); + } + + else if (enumDT == DataTypeEnum.dt_decimal) + { + sb.Append(" el: (props: any, { attrs }: SetupContext) => { \n"); + sb.Append(" return h(inputNumber, { \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"); //閰嶇疆绮惧害锛熻繖閲岄渶瑕佽幏鍙栨暟鎹簱涓殑绮惧害锛侊紒锛乀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) @@ -1865,18 +1916,20 @@ { elment = "select"; sb.Append(" el: '" + elment + "', \n"); + sb.Append(" options: [], \n"); + isWriteInt = false; } } - else + if (isWriteInt) { sb.Append(" el: (props: any, { attrs }: SetupContext) => { \n"); - sb.Append(" return h(inputNumber, { { \n"); - sb.Append(" ...props, { \n"); - sb.Append(" clearable: true, { \n"); - sb.Append(" ...attrs, { \n"); + sb.Append(" return h(inputNumber, { \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"); //閰嶇疆绮惧害锛� sb.Append(" step: 1,\n"); sb.Append(" precision: 0, \n"); @@ -1887,22 +1940,22 @@ sb.Append(" el: '" + elment + "', \n"); } - sb.Append(" disabled: disabled, \n"); + sb.Append(" //disabled: disabled, \n"); sb.Append(" placeholder: '璇疯緭鍏�" + columnModel.Description + "', \n"); if (columnModel.IsNullable == false) { 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"); } //鍘绘帀鏈�鍚庝竴涓�, @@ -1933,19 +1986,20 @@ el: 'input', disabled: disabled, placeholder: '璇疯緭鍏ョ墿鏂欑紪鐮�', - rules: [{ required: true, message: '鐗╂枡缂栫爜涓嶈兘涓虹┖', trigger: 'blur' }], }, */ - 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); DataTypeEnum enumDT = (DataTypeEnum)Enum.Parse(typeof(DataTypeEnum), "dt_" + columnModel.DataType.ToString()); 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"; @@ -1955,34 +2009,55 @@ } sb.Append(" { \n"); sb.Append(" label: '" + columnModel.Description + "', \n"); - sb.Append(" prop: '" + columnModel.ColumnName + "', \n"); + sb.Append(" prop: '" + low_prop_ColumnName + "', \n"); //娣诲姞绫诲瀷 - switch (enumDT) - { - case DataTypeEnum.dt_datetime: - sb.Append(" type: 'datetimerange', \n"); - break; - default: - break; - } + //switch (enumDT) + //{ + // case DataTypeEnum.dt_datetime: + // 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"); - if (enumDT == DataTypeEnum.dt_decimal) + // sb.Append(" width: '100%',\n"); + // break; + // default: + // break; + //} + if (enumDT == DataTypeEnum.dt_datetime) { sb.Append(" el: (props: any, { attrs }: SetupContext) => { \n"); - sb.Append(" return h(inputNumber, { { \n"); - sb.Append(" ...props, { \n"); - sb.Append(" clearable: true, { \n"); - sb.Append(" ...attrs, { \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"); + } + else if (enumDT == DataTypeEnum.dt_decimal) + { + sb.Append(" el: (props: any, { attrs }: SetupContext) => { \n"); + sb.Append(" return h(inputNumber, { \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"); //閰嶇疆绮惧害锛熻繖閲岄渶瑕佽幏鍙栨暟鎹簱涓殑绮惧害锛侊紒锛乀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) @@ -1992,18 +2067,21 @@ { elment = "select"; sb.Append(" el: '" + elment + "', \n"); + sb.Append(" option: [], \n"); + isWriteInt = false; } } - else + if (isWriteInt) { sb.Append(" el: (props: any, { attrs }: SetupContext) => { \n"); - sb.Append(" return h(inputNumber, { { \n"); - sb.Append(" ...props, { \n"); - sb.Append(" clearable: true, { \n"); - sb.Append(" ...attrs, { \n"); + sb.Append(" return h(inputNumber, { \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"); //閰嶇疆绮惧害锛� sb.Append(" step: 1,\n"); sb.Append(" precision: 0, \n"); @@ -2014,22 +2092,19 @@ sb.Append(" el: '" + elment + "', \n"); } - sb.Append(" disabled: disabled, \n"); + sb.Append(" //disabled: disabled, \n"); sb.Append(" placeholder: '璇疯緭鍏�" + columnModel.Description + "', \n"); - if (columnModel.IsNullable == false) - { - 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"); } //鍘绘帀鏈�鍚庝竴涓�, @@ -2108,13 +2183,13 @@ //灞炴�у皬鍐� var instanceName = CommonHelper.FirstLowercase(item.EnumType); var _enumAttrName = CommonHelper.FirstLowercase(item.EnumAttrName); - sb.Append("const "+ instanceName + "Data = await getWmsEnumData({ \n"); + sb.Append("const " + instanceName + "Data = await getWmsEnumData({ \n"); sb.Append(" EnumName: '" + item.EnumType + "', \n"); sb.Append("}) \n"); - sb.Append("enumOptions."+ instanceName + " = "+ instanceName + "Data.map((item) => ({ \n"); + sb.Append("enumOptions." + _enumAttrName + " = " + instanceName + "Data.map((item) => ({ \n"); sb.Append(" label: item.description, \n"); sb.Append(" value: item.value, \n"); - sb.Append("}) \n"); + sb.Append("})) \n"); } } var res = sb.ToString(); @@ -2142,7 +2217,9 @@ List<ColumnModel> newList = ListHelper.RemoveForPageAddFormAttributes(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(); @@ -2163,10 +2240,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(); @@ -2198,16 +2280,35 @@ foreach (var columnModel in newList) { sb.Append("{ \n"); + //棣栧瓧姣嶅皬鍐� + var lowerCaseColumnName = CommonHelper.FirstLowercase(columnModel.ColumnName); var findEnumObj = param.EnumList.Where(x => x.EnumAttrName == columnModel.ColumnName).FirstOrDefault(); if (findEnumObj != null) { - sb.Append(" field: '" + columnModel.ColumnName + "Desc', \n"); + sb.Append(" field: '" + lowerCaseColumnName + "Desc', \n"); } - else { - sb.Append(" field: '" + columnModel.ColumnName + "', \n"); + else + { + sb.Append(" field: '" + lowerCaseColumnName + "', \n"); } - sb.Append(" field: '" + columnModel.Description + "', \n"); - sb.Append("} \n"); + sb.Append(" title: '" + columnModel.Description + "', \n"); + //鑾峰彇鏁版嵁绫诲瀷 + //璁剧疆瀹藉害 + DataTypeEnum enumDT = (DataTypeEnum)Enum.Parse(typeof(DataTypeEnum), "dt_" + columnModel.DataType.ToString()); + switch (enumDT) + { + case DataTypeEnum.dt_datetime: + sb.Append(" width:180, \n"); + break; + case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: + sb.Append(" width:80, \n"); + break; + default: + sb.Append(" width:160, \n"); + break; + } + sb.Append("}, \n"); } //鍘绘帀鏈�鍚庝竴涓�, var res = sb.ToString(); @@ -2231,7 +2332,9 @@ List<ColumnModel> newList = ListHelper.RemoveForPageAddFormAttributes(columnModelList); foreach (var columnModel in newList) { - sb.Append($"{columnModel.ColumnName}: res.{columnModel.ColumnName}, \n"); + //棣栧瓧姣嶅皬鍐� + var low_prop_ColumnName = CommonHelper.FirstLowercase(columnModel.ColumnName); + sb.Append($"{low_prop_ColumnName}: res.{low_prop_ColumnName}, \n"); } //鍘绘帀鏈�鍚庝竴涓�, var res = sb.ToString(); @@ -2285,8 +2388,83 @@ var _enumAttrName = CommonHelper.FirstLowercase(item.EnumAttrName); sb.Append(_enumAttrName + ": [] as Array<{label: string; value: any }>, \n"); } + //鍘绘帀鏈�鍚庝竴涓�, + var res = sb.ToString(); + res = res.Substring(0, res.Length - 1); + return res; } - + else + { + return ""; + } + } + catch (Exception ex) + { + throw ex; + } + } + + public static string GetVueFormOptionsStrForPageAdd_QueryTableListForBool(List<ColumnModel> columnModelList, GenerateCodeParam param) + { + StringBuilder sb = new StringBuilder(); + try + { + /* + + isRead: ({ row }: any) => { + return ( + <div> + {row.isRead != null ? (row.isRead ? '鏄�' : '鍚�') : '-'} + </div> + ) + }, + + creationTime: ({ row }: any) => { + return ( + <div> + {row.creationTime != null + ? dayjs(row.creationTime).format('YYYY-MM-DD HH:mm:ss') + : '-'} + </div> + ) + }, + + */ + + foreach (var columnModel in columnModelList) + { + //灞炴�у皬鍐� + var instanceColumnName = CommonHelper.FirstLowercase(columnModel.ColumnName); + //鑾峰彇鏁版嵁绫诲瀷 + DataTypeEnum enumDT = (DataTypeEnum)Enum.Parse(typeof(DataTypeEnum), "dt_" + columnModel.DataType.ToString()); + switch (enumDT) + { + case DataTypeEnum.dt_datetime: + sb.Append(instanceColumnName + ": ({ row }: any) => { \n"); + sb.Append(" return ( \n"); + sb.Append(" <div> \n"); + sb.Append(" {row." + instanceColumnName + " != null \n"); + sb.Append(" ? dayjs(row." + instanceColumnName + ").format('YYYY-MM-DD HH:mm:ss') \n"); + sb.Append(" : '-'} \n"); + sb.Append(" </div> \n"); + sb.Append(" ) \n"); + sb.Append("},\n"); + break; + + case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: + sb.Append(instanceColumnName + ": ({ row }: any) => { \n"); + sb.Append(" return ( \n"); + sb.Append(" <div> \n"); + sb.Append(" {row." + instanceColumnName + " != null ? (row." + instanceColumnName + " ? '鏄�' : '鍚�') : '-'} \n"); + sb.Append(" </div> \n"); + sb.Append(" ) \n"); + sb.Append("},\n"); + break; + } + + } + //鍘绘帀鏈�鍚庝竴涓�, var res = sb.ToString(); res = res.Substring(0, res.Length - 1); -- Gitblit v1.9.3