From 080b80ecca447039ebeafff33b647d9dacfed5f7 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周二, 06 5月 2025 07:05:05 +0800 Subject: [PATCH] 222 --- Weben_CMS专用代码生成器/Code/Utility/StructStrHelper.cs | 47 +++++++++++++++++++++++++++++++++++++---------- 1 files changed, 37 insertions(+), 10 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 767112b..b05c3d8 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" @@ -199,6 +199,7 @@ attrStr += " public float" + str_NullFlag + attr + " { get; set; }\n"; break; case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: if (columnModel.IsNullable) { str_NullFlag = "? "; } attrStr += " public bool" + str_NullFlag + attr + " { get; set; }\n"; break; @@ -251,6 +252,12 @@ case DataTypeEnum.dt_decimal: if (columnModel.IsNullable) { str_NullFlag = "? "; } attrStr += " public decimal" + str_NullFlag + attr + " { get; set; }\n"; + attrStr += "\n";//鏈�鍚庢槸鍔犱竴涓┖鏍� + break; + case DataTypeEnum.dt_tinyint: + case DataTypeEnum.dt_bit: + if (columnModel.IsNullable) { str_NullFlag = "? "; } + attrStr += " public bool" + str_NullFlag + attr + " { get; set; }\n"; attrStr += "\n";//鏈�鍚庢槸鍔犱竴涓┖鏍� break; case DataTypeEnum.dt_int: @@ -366,17 +373,9 @@ break; case DataTypeEnum.dt_bigint: case DataTypeEnum.dt_decimal: - if (isHaveMaxLength) - { - attrStr += $" Check.NotNull(input.{attr}, \"{columnModel.Description}\", {columnModel.DataLength});\n"; - } - else - { - attrStr += $" Check.NotNull(input.{attr}, \"{columnModel.Description}\");\n"; - } - break; - case DataTypeEnum.dt_int: case DataTypeEnum.dt_tinyint: + case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_int: if (isHaveMaxLength) { attrStr += $" Check.NotNull(input.{attr}, \"{columnModel.Description}\", {columnModel.DataLength});\n"; @@ -445,6 +444,12 @@ case DataTypeEnum.dt_decimal: if (columnModel.IsNullable) { str_NullFlag = "? "; } attrStr += " public decimal" + str_NullFlag + attr + " { get; set; }\n"; + attrStr += "\n";//鏈�鍚庢槸鍔犱竴涓┖鏍� + break; + case DataTypeEnum.dt_tinyint: + case DataTypeEnum.dt_bit: + if (columnModel.IsNullable) { str_NullFlag = "? "; } + attrStr += " public bool" + str_NullFlag + attr + " { get; set; }\n"; attrStr += "\n";//鏈�鍚庢槸鍔犱竴涓┖鏍� break; case DataTypeEnum.dt_int: @@ -537,6 +542,12 @@ attrStr += " public decimal" + str_NullFlag + attr + " { get; set; }\n"; attrStr += "\n";//鏈�鍚庢槸鍔犱竴涓┖鏍� break; + case DataTypeEnum.dt_tinyint: + case DataTypeEnum.dt_bit: + if (columnModel.IsNullable) { str_NullFlag = "? "; } + attrStr += " public bool" + str_NullFlag + attr + " { get; set; }\n"; + attrStr += "\n";//鏈�鍚庢槸鍔犱竴涓┖鏍� + break; case DataTypeEnum.dt_int: if (columnModel.IsNullable) { str_NullFlag = "? "; } var findEnumObj = param.EnumList.Where(x => x.EnumAttrName == attr).FirstOrDefault(); @@ -620,6 +631,7 @@ attrStr += " public int" + str_NullFlag + emptyStr + attr + " { get; set; }\n"; attrStr += "\n";//鏈�鍚庢槸鍔犱竴涓┖鏍� break; + case DataTypeEnum.dt_bit: case DataTypeEnum.dt_tinyint: attrStr += " public bool" + str_NullFlag + emptyStr + attr + " { get; set; }\n"; attrStr += "\n";//鏈�鍚庢槸鍔犱竴涓┖鏍� @@ -775,6 +787,7 @@ defaultValue = "getdate()"; break; case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: defaultValue = "0"; break; default: @@ -833,6 +846,7 @@ case DataTypeEnum.dt_datetime2: case DataTypeEnum.dt_datetimeoffset: case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: sql.Append("@" + attrColumnName + " " + columnModel.DataType + " " + fuhao + "\n"); break; case DataTypeEnum.dt_decimal: @@ -894,6 +908,7 @@ case DataTypeEnum.dt_datetime2: case DataTypeEnum.dt_datetimeoffset: case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: sql.Append("@" + attrColumnName + " " + columnModel.DataType + " " + fuhao + "\n"); break; case DataTypeEnum.dt_decimal: @@ -954,6 +969,7 @@ case DataTypeEnum.dt_datetime2: case DataTypeEnum.dt_datetimeoffset: case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: sql.Append("@" + attrColumnName + " " + columnModel.DataType + " " + fuhao); break; case DataTypeEnum.dt_decimal: @@ -1079,6 +1095,7 @@ case DataTypeEnum.dt_datetime2: case DataTypeEnum.dt_datetimeoffset: case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: updateSql = " " + attrColumnName + "= case @" + attrColumnName + " when NULL then " + attrColumnName + " else @" + attrColumnName + " end "; break; default: @@ -1240,6 +1257,7 @@ str += "SqlDbType.Float," + columnModel.DataLength.ToString(); break; case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: str += "SqlDbType.Bit," + columnModel.DataLength.ToString(); break; } @@ -1310,6 +1328,7 @@ sb.Append("} \n"); break; case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: sb.Append("if (dataRow[\"" + columnModel.ColumnName.ToString() + "\"].ToString() != \"\") \n"); sb.Append("{ \n"); @@ -1560,6 +1579,7 @@ sb.Append(" </el-table-column> \n"); break; case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: sb.Append(" <el-table-column prop=\"" + columnModel.ColumnName + "\" label=\"" + columnModel.Description + "\" align=\"center\" > \n"); sb.Append("<template slot-scope=\"scope\">"); sb.Append("<el-tag :type=\"scope.row." + columnModel.ColumnName + " ? 'danger' : 'success'\""); @@ -1607,6 +1627,7 @@ switch (enumDT) { case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: sb.Append(" <el-switch v-model=\"addForm." + columnModel.ColumnName + "\"></el-switch> \n"); break; case DataTypeEnum.dt_datetime: @@ -1654,6 +1675,7 @@ switch (enumDT) { case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: sb.Append(" <el-switch v-model=\"viewDetailForm." + columnModel.ColumnName + "\"></el-switch> \n"); break; case DataTypeEnum.dt_datetime: @@ -1711,6 +1733,7 @@ elment = "el-date-picker"; break; case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: elment = "el-select"; break; default: @@ -1735,6 +1758,7 @@ switch (enumDT) { case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: sb.Append(" options: [{label: '鏄�',value: 'true'}, {label: '鍚�',value: 'false'}] \n"); break; default: @@ -1847,6 +1871,7 @@ sb.Append("<el-input v-model=\"serachObj." + columnModel.ColumnName + "\" placeholder=\"璇疯緭鍏�" + columnModel.Description + "\"></el-input> \n"); break; case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: sb.Append("<el-checkbox-group v-model=\"ck_delflag\" @change=\"ckDelFlag\">\n"); sb.Append(" <el-checkbox-button label=\"鍚敤\" name=\"ck_delflag\"></el-checkbox-button>\n"); sb.Append(" <el-checkbox-button label=\"绂佺敤\" name=\"ck_delflag\"></el-checkbox-button>\n"); @@ -1892,6 +1917,7 @@ switch (enumDT) { case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: case DataTypeEnum.dt_datetime: case DataTypeEnum.dt_datetime2: case DataTypeEnum.dt_datetimeoffset: @@ -1957,6 +1983,7 @@ sb.Append(" } \n"); break; case DataTypeEnum.dt_bit: + case DataTypeEnum.dt_tinyint: sb.Append(" if (!string.IsNullOrEmpty(queryModel." + columnModel.ColumnName + ")) \n"); sb.Append(" { \n"); sb.Append(" strWhere += \" AND $TableAlias$." + columnModel.ColumnName + " = '\" + queryModel." + columnModel.ColumnName + " + \"'\"; \n"); -- Gitblit v1.9.3