| | |
| | | }, |
| | | labelPosition: { |
| | | type: String, |
| | | default: 'left', |
| | | default: 'right', |
| | | }, |
| | | formData: { |
| | | type: Object as PropType<{ [key: string]: any }>, |
| | |
| | | import { cloneDeep } from 'lodash' |
| | | |
| | | export const useWmsInOutStockRecordDrawer = (props: any, ctx?: any) => { |
| | | const wmsInOutStockRecordDrawer = injectModel<WmsInOutStockRecordDrawer>('wmsInOutStockRecordDrawer') |
| | | const wmsInOutStockRecordDrawer = injectModel<WmsInOutStockRecordDrawer>( |
| | | 'wmsInOutStockRecordDrawer' |
| | | ) |
| | | /** |
| | | * 鐢ㄦ潵瀵规瘮鐨勫垵濮嬪寲鏁版嵁 |
| | | */ |
| | |
| | | EnumName: 'StockTypeEnum', |
| | | }) |
| | | updateFormItemOptions('stockType', stockTypeEnumEnum) |
| | | |
| | | } |
| | | commonQueryEnumForFrom() |
| | | /** |
| | |
| | | */ |
| | | const onOpen = async () => { |
| | | if (current.value) { |
| | | const res = await wmsInOutStockRecordDrawer.getWmsInOutStockRecordDetail(current.value) |
| | | const res = await wmsInOutStockRecordDrawer.getWmsInOutStockRecordDetail( |
| | | current.value |
| | | ) |
| | | |
| | | formData.value = { |
| | | orderNo: res.orderNo, |
| | |
| | | .header { |
| | | margin-bottom: 12px; |
| | | display: flex; |
| | | justify-content: flex-start; |
| | | justify-content: flex-start !important; |
| | | align-items: center; |
| | | } |
| | | } |
| | |
| | | //string strSql = $"SELECT COLUMN_NAME as ColumnName, COLUMN_TYPE as DataType, IS_NULLABLE as IsNullable, CHARACTER_MAXIMUM_LENGTH as DataLength,COLUMN_COMMENT as Description " + |
| | | // $"FROM INFORMATION_SCHEMA.COLUMNS " + |
| | | // $"WHERE TABLE_NAME = '{tableName}'"; |
| | | string strSql = $"SELECT c.COLUMN_NAME as ColumnName, c.DATA_TYPE as DataType, c.IS_NULLABLE as IsNullable, c.CHARACTER_MAXIMUM_LENGTH as DataLength, c.COLUMN_COMMENT as Description, " + |
| | | string strSql = $"SELECT c.COLUMN_NAME as ColumnName, c.DATA_TYPE as DataType, c.IS_NULLABLE as IsNullable, c.CHARACTER_MAXIMUM_LENGTH as DataLength, c.COLUMN_COMMENT as Description,c.NUMERIC_SCALE as MyPrecision, " + |
| | | $"CASE WHEN kcu.COLUMN_NAME IS NOT NULL THEN 'true' ELSE 'false' END AS IsPrimaryKey " + |
| | | $"FROM INFORMATION_SCHEMA.COLUMNS c " + |
| | | $"LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu " + |
| | |
| | | where ic.object_id=obj.object_id |
| | | and ic.column_id=col.column_id |
| | | ) as IsPrimaryKey, |
| | | col.Precision, |
| | | col.Precision as MyPrecision, |
| | | col.Scale |
| | | from sys.objects obj |
| | | inner join sys.columns col |
| | |
| | | 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() != "") |
| | | { |
| | |
| | | /// </summary> |
| | | public bool IsPrimaryKey { get; set; } |
| | | |
| | | public int Precision { get; set; } |
| | | public int? MyPrecision { get; set; } |
| | | |
| | | public int Scale { get; set; } |
| | | } |
| | |
| | | .header { |
| | | margin-bottom: 12px; |
| | | display: flex; |
| | | justify-content: flex-start; |
| | | justify-content: flex-end; |
| | | align-items: center; |
| | | } |
| | | } |
| | |
| | | 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; |