| | |
| | | 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; |
| | |
| | | /// </summary> |
| | | /// <param name="columnModel"></param> |
| | | /// <returns></returns> |
| | | public static string GenerateAttributeForAddModel(ColumnModel columnModel,GenerateCodeParam param) |
| | | public static string GenerateAttributeForAddModel(ColumnModel columnModel, GenerateCodeParam param) |
| | | { |
| | | try |
| | | { |
| | |
| | | attrStr += " public long" + str_NullFlag + attr + " { get; set; }\n"; |
| | | attrStr += "\n";//æåæ¯å ä¸ä¸ªç©ºæ ¼ |
| | | break; |
| | | 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: |
| | | if (columnModel.IsNullable) { str_NullFlag = "? "; } |
| | | var findEnumObj = param.EnumList.Where(x => x.EnumAttrName == attr).FirstOrDefault(); |
| | |
| | | break; |
| | | } |
| | | |
| | | return attrStr; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw ex; |
| | | } |
| | | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// çæå±æ§å符串ForAddModel-æ´æ°å®ä½ä¸ç¨ |
| | | /// </summary> |
| | | /// <param name="columnModel"></param> |
| | | /// <returns></returns> |
| | | public static string GenerateAttributeForUpdateModel(ColumnModel columnModel, GenerateCodeParam param) |
| | | { |
| | | try |
| | | { |
| | | string attr = columnModel.ColumnName; |
| | | |
| | | string attrStr = ""; |
| | | attrStr += $" updateObj.{attr} = input.{attr};\n"; |
| | | |
| | | |
| | | return attrStr; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw ex; |
| | | } |
| | | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// çæå±æ§å符串ForAddModel-æ´æ°å®ä½ä¸ç¨(导å
¥æ¶) |
| | | /// </summary> |
| | | /// <param name="columnModel"></param> |
| | | /// <returns></returns> |
| | | public static string GenerateAttributeForUpdateModelByImport(ColumnModel columnModel, GenerateCodeParam param) |
| | | { |
| | | try |
| | | { |
| | | string attr = columnModel.ColumnName; |
| | | |
| | | string attrStr = ""; |
| | | attrStr += $" {attr} = {param.EntityInstanceName}.{attr},\n"; |
| | | |
| | | |
| | | return attrStr; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw ex; |
| | | } |
| | | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// çæå±æ§å符串ForAddModel-CheckCreateOrUpdateDtoAsyncä¸ç¨ |
| | | /// </summary> |
| | | /// <param name="columnModel"></param> |
| | | /// <returns></returns> |
| | | public static string GenerateAttributeForCheckCreateOrUpdateDtoAsync(ColumnModel columnModel, GenerateCodeParam param) |
| | | { |
| | | try |
| | | { |
| | | string attr = columnModel.ColumnName; |
| | | |
| | | string attrStr = ""; |
| | | bool isHaveMaxLength = false; |
| | | if (!string.IsNullOrEmpty(columnModel.DataLength)) |
| | | { |
| | | isHaveMaxLength = true; |
| | | } |
| | | if (columnModel.IsNullable == false) |
| | | {//å¿
å¡« |
| | | DataTypeEnum myDataType = (DataTypeEnum)Enum.Parse(typeof(DataTypeEnum), "dt_" + columnModel.DataType); |
| | | switch (myDataType) |
| | | { |
| | | case DataTypeEnum.dt_datetime: |
| | | case DataTypeEnum.dt_datetime2: |
| | | case DataTypeEnum.dt_datetimeoffset: |
| | | 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_bigint: |
| | | case DataTypeEnum.dt_decimal: |
| | | case DataTypeEnum.dt_tinyint: |
| | | case DataTypeEnum.dt_bit: |
| | | case DataTypeEnum.dt_int: |
| | | if (isHaveMaxLength) |
| | | { |
| | | attrStr += $" Check.NotNull(input.{attr}, \"{columnModel.Description}\", {columnModel.DataLength});\n"; |
| | | } |
| | | else |
| | | { |
| | | attrStr += $" Check.NotNull(input.{attr}, \"{columnModel.Description}\");\n"; |
| | | } |
| | | break; |
| | | default: |
| | | if (isHaveMaxLength) |
| | | { |
| | | attrStr += $" Check.NotNullOrWhiteSpace(input.{attr}, \"{columnModel.Description}\", {columnModel.DataLength});\n"; |
| | | } |
| | | else |
| | | { |
| | | attrStr += $" Check.NotNullOrWhiteSpace(input.{attr}, \"{columnModel.Description}\");\n"; |
| | | } |
| | | break; |
| | | } |
| | | } |
| | | return attrStr; |
| | | } |
| | | catch (Exception ex) |
| | |
| | | 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: |
| | | if (columnModel.IsNullable) { str_NullFlag = "? "; } |
| | | attrStr += " public long" + str_NullFlag + attr + " { get; set; }\n"; |
| | | attrStr += "\n";//æåæ¯å ä¸ä¸ªç©ºæ ¼ |
| | | break; |
| | | 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: |
| | |
| | | attrStr += " /// <summary>\n"; |
| | | attrStr += " /// " + columnModel.Description + "\n"; |
| | | attrStr += " /// </summary>\n"; |
| | | attrStr += " public string" + str_NullFlag + findEnumObj.EnumTypeDesc + " { get; set; }\n"; |
| | | attrStr += " public string" + str_NullFlag + findEnumObj.EnumTypeDesc + "\n"; |
| | | attrStr += " { \n"; |
| | | attrStr += " get \n"; |
| | | attrStr += " { \n"; |
| | |
| | | attrStr += " } \n"; |
| | | } |
| | | } |
| | | |
| | | return attrStr; |
| | | } |
| | | catch (Exception ex) |
| | | { |
| | | throw ex; |
| | | } |
| | | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// çæå±æ§å符串ForAddModel-Exportå®ä½ä¸ç¨ |
| | | /// </summary> |
| | | /// <param name="columnModel"></param> |
| | | /// <returns></returns> |
| | | public static string GenerateAttributeForExport(ColumnModel columnModel, GenerateCodeParam param) |
| | | { |
| | | try |
| | | { |
| | | string attr = columnModel.ColumnName; |
| | | //if (attr.ToUpper() == "DBId".ToUpper()) |
| | | //{ |
| | | // var bb = ""; |
| | | //} |
| | | string str_NullFlag = " "; |
| | | |
| | | string attrStr = ""; |
| | | attrStr += " /// <summary>\n"; |
| | | attrStr += " /// " + columnModel.Description + "\n"; |
| | | attrStr += " /// </summary>\n"; |
| | | attrStr += $" [ExcelColumn(Name = \"{columnModel.Description}\", Width = 25)]\n"; |
| | | |
| | | DataTypeEnum myDataType = (DataTypeEnum)Enum.Parse(typeof(DataTypeEnum), "dt_" + columnModel.DataType); |
| | | switch (myDataType) |
| | | { |
| | | case DataTypeEnum.dt_datetime: |
| | | case DataTypeEnum.dt_datetime2: |
| | | case DataTypeEnum.dt_datetimeoffset: |
| | | attrStr += " public datetime" + str_NullFlag + attr + " { get; set; }\n"; |
| | | attrStr += "\n";//æåæ¯å ä¸ä¸ªç©ºæ ¼ |
| | | break; |
| | | case DataTypeEnum.dt_bigint: |
| | | if (columnModel.IsNullable) { str_NullFlag = "? "; } |
| | | attrStr += " public long" + str_NullFlag + attr + " { get; set; }\n"; |
| | | attrStr += "\n";//æåæ¯å ä¸ä¸ªç©ºæ ¼ |
| | | break; |
| | | 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: |
| | | if (columnModel.IsNullable) { str_NullFlag = "? "; } |
| | | var findEnumObj = param.EnumList.Where(x => x.EnumAttrName == attr).FirstOrDefault(); |
| | | if (findEnumObj != null) |
| | | { |
| | | attrStr += $" public {findEnumObj.EnumType}" + str_NullFlag + attr + " { get; set; }\n"; |
| | | attrStr += "\n";//æåæ¯å ä¸ä¸ªç©ºæ ¼ |
| | | } |
| | | else |
| | | { |
| | | attrStr += " public int" + str_NullFlag + attr + " { get; set; }\n"; |
| | | attrStr += "\n";//æåæ¯å ä¸ä¸ªç©ºæ ¼ |
| | | } |
| | | |
| | | break; |
| | | default: |
| | | attrStr += " public string" + str_NullFlag + attr + " { get; set; }\n"; |
| | | attrStr += "\n";//æåæ¯å ä¸ä¸ªç©ºæ ¼ |
| | | break; |
| | | } |
| | | |
| | | |
| | | |
| | | return attrStr; |
| | | } |
| | |
| | | attrStr += " public long" + str_NullFlag + emptyStr + attr + " { get; set; }\n"; |
| | | attrStr += "\n";//æåæ¯å ä¸ä¸ªç©ºæ ¼ |
| | | break; |
| | | case DataTypeEnum.dt_decimal: |
| | | attrStr += " public decimal" + str_NullFlag + emptyStr + attr + " { get; set; }\n"; |
| | | attrStr += "\n";//æåæ¯å ä¸ä¸ªç©ºæ ¼ |
| | | break; |
| | | case DataTypeEnum.dt_int: |
| | | 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";//æåæ¯å ä¸ä¸ªç©ºæ ¼ |
| | |
| | | case DataTypeEnum.dt_datetimeoffset: |
| | | return "\n"; |
| | | case DataTypeEnum.dt_bigint: |
| | | case DataTypeEnum.dt_decimal: |
| | | case DataTypeEnum.dt_int: |
| | | case DataTypeEnum.dt_tinyint: |
| | | attrStr += " public SearchFilterModeEnum " + attr + highSearchModeSuffix + " { get; set; }= SearchFilterModeEnum.ç²¾åæ¥è¯¢;\n"; |
| | |
| | | defaultValue = "getdate()"; |
| | | break; |
| | | case DataTypeEnum.dt_bit: |
| | | case DataTypeEnum.dt_tinyint: |
| | | defaultValue = "0"; |
| | | break; |
| | | default: |
| | |
| | | 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: |
| | |
| | | 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: |
| | |
| | | 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: |
| | |
| | | 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: |
| | |
| | | str += "SqlDbType.Float," + columnModel.DataLength.ToString(); |
| | | break; |
| | | case DataTypeEnum.dt_bit: |
| | | case DataTypeEnum.dt_tinyint: |
| | | str += "SqlDbType.Bit," + columnModel.DataLength.ToString(); |
| | | break; |
| | | } |
| | |
| | | sb.Append("} \n"); |
| | | break; |
| | | case DataTypeEnum.dt_bit: |
| | | case DataTypeEnum.dt_tinyint: |
| | | sb.Append("if (dataRow[\"" + columnModel.ColumnName.ToString() + "\"].ToString() != \"\") \n"); |
| | | sb.Append("{ \n"); |
| | | |
| | |
| | | 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'\""); |
| | |
| | | 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: |
| | |
| | | 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: |
| | |
| | | elment = "el-date-picker"; |
| | | break; |
| | | case DataTypeEnum.dt_bit: |
| | | case DataTypeEnum.dt_tinyint: |
| | | elment = "el-select"; |
| | | break; |
| | | default: |
| | |
| | | switch (enumDT) |
| | | { |
| | | case DataTypeEnum.dt_bit: |
| | | case DataTypeEnum.dt_tinyint: |
| | | sb.Append(" options: [{label: 'æ¯',value: 'true'}, {label: 'å¦',value: 'false'}] \n"); |
| | | break; |
| | | default: |
| | |
| | | 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"); |
| | |
| | | switch (enumDT) |
| | | { |
| | | case DataTypeEnum.dt_bit: |
| | | case DataTypeEnum.dt_tinyint: |
| | | case DataTypeEnum.dt_datetime: |
| | | case DataTypeEnum.dt_datetime2: |
| | | case DataTypeEnum.dt_datetimeoffset: |
| | |
| | | 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"); |