| | |
| | | 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() != "") |
| | | { |
| | |
| | | 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; |
| | |
| | | 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; |
| | |
| | | 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; |
| | |
| | | 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; |
| | |
| | | sb.Append(" }) \n"); |
| | | sb.Append(" },\n"); |
| | | |
| | | sb.Append(" width: '100%',\n"); |
| | | //é
置精度ï¼è¿ééè¦è·åæ°æ®åºä¸ç精度ï¼ï¼ï¼TODOï¼ |
| | | 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) |
| | |
| | | { |
| | | 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"); |
| | |
| | | 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"); |
| | |
| | | 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"); |
| | | } |
| | | //廿æåä¸ä¸ª, |
| | |
| | | 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); |
| | |
| | | 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"; |
| | |
| | | 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; |
| | |
| | | sb.Append(" }) \n"); |
| | | sb.Append(" },\n"); |
| | | |
| | | sb.Append(" width: '100%',\n"); |
| | | //é
置精度ï¼è¿ééè¦è·åæ°æ®åºä¸ç精度ï¼ï¼ï¼TODOï¼ |
| | | 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) |
| | |
| | | { |
| | | 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"); |
| | |
| | | sb.Append(" }) \n"); |
| | | sb.Append(" },\n"); |
| | | |
| | | sb.Append(" width: '100%',\n"); |
| | | //é
ç½®ç²¾åº¦ï¼ |
| | | sb.Append(" step: 1,\n"); |
| | | sb.Append(" precision: 0, \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"); |
| | | } |
| | | //廿æåä¸ä¸ª, |
| | |
| | | /* |
| | | 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(); |