| | |
| | | using GenerateCode_WeiBen_WMS.Model; |
| | | using GenerateCode_WeiBen_WMS.Const; |
| | | using GenerateCode_WeiBen_WMS.Model; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Configuration; |
| | |
| | | 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; |
| | |
| | | // var bb = ""; |
| | | //} |
| | | string str_NullFlag = " "; |
| | | if (columnModel.IsNullable) { str_NullFlag = "? "; } |
| | | |
| | | string attrStr = ""; |
| | | attrStr += " /// <summary>\n"; |
| | |
| | | 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: |
| | |
| | | string attr = columnModel.ColumnName; |
| | | |
| | | string attrStr = ""; |
| | | attrStr += $" {attr} = {param.EntityInstanceName}.{attr};\n"; |
| | | attrStr += $" {attr} = {param.EntityInstanceName}.{attr},\n"; |
| | | |
| | | |
| | | return attrStr; |
| | |
| | | } |
| | | break; |
| | | case DataTypeEnum.dt_bigint: |
| | | 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_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"; |
| | |
| | | // var bb = ""; |
| | | //} |
| | | string str_NullFlag = " "; |
| | | if (columnModel.IsNullable) { str_NullFlag = "? "; } |
| | | |
| | | string attrStr = ""; |
| | | attrStr += " /// <summary>\n"; |
| | |
| | | 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: |
| | |
| | | |
| | | break; |
| | | default: |
| | | //ç¹æ®å¤ç åæ®µ ExtraProperties |
| | | if (columnModel.ColumnName.ToUpper() == SystemConst.pro_ExtraProperties.ToUpper()) |
| | | { |
| | | attrStr += " public ExtraPropertyDictionary" + str_NullFlag + attr + " { get; set; }\n"; |
| | | } |
| | | else |
| | | { |
| | | attrStr += " public string" + str_NullFlag + attr + " { get; set; }\n"; |
| | | } |
| | | attrStr += "\n";//æåæ¯å ä¸ä¸ªç©ºæ ¼ |
| | | break; |
| | | } |
| | |
| | | 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"; |
| | |
| | | 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 += " 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"); |