HIA24016N_PipeLineDemo.git

			@@ -85,7 +85,7 @@
			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() != "")
			{
			@@ -887,7 +887,7 @@
			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;
			@@ -949,7 +949,7 @@
			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;
			@@ -1010,7 +1010,7 @@
			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;
			@@ -1796,7 +1796,7 @@
			{
			case DataTypeEnum.dt_bit:
			case DataTypeEnum.dt_tinyint:
			sb.Append(" options: [{label: 'æ¯',value: 'true'}, {label: 'å¦',value: 'false'}] \n");
			sb.Append(" options: [{label: 'æ¯',value: true}, {label: 'å¦',value: false}] \n");
			break;
			default:
			break;
			@@ -1845,9 +1845,9 @@
			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";
			@@ -1863,7 +1863,15 @@
			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;
			@@ -1879,12 +1887,14 @@
			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)
			@@ -1894,9 +1904,10 @@
			{
			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");
			@@ -1905,7 +1916,7 @@
			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");
			@@ -1923,15 +1934,15 @@
			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");
			}
			//å»ææåä¸ä¸ª,
			@@ -1964,8 +1975,8 @@
			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);
			@@ -1973,9 +1984,9 @@
			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";
			@@ -1991,7 +2002,15 @@
			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;
			@@ -2007,12 +2026,14 @@
			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)
			@@ -2022,9 +2043,10 @@
			{
			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");
			@@ -2034,6 +2056,7 @@
			sb.Append(" }) \n");
			sb.Append(" },\n");

			sb.Append(" width: '100%',\n");
			//éç½®ç²¾åº¦ï¼
			sb.Append(" step: 1,\n");
			sb.Append(" precision: 0, \n");
			@@ -2048,15 +2071,15 @@
			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");
			}
			//å»ææåä¸ä¸ª,
			@@ -2192,10 +2215,15 @@
			/*
			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();
			@@ -2332,6 +2360,78 @@
			}
			}

			public static string GetVueFormOptionsStrForPageAdd_QueryTableListForBool(List<ColumnModel> columnModelList, GenerateCodeParam param)
			{
			StringBuilder sb = new StringBuilder();
			try
			{
			/*

			isRead: ({ row }: any) => {
			return (
			<div>
			{row.isRead != null ? (row.isRead ? 'æ¯' : 'å¦') : '-'}
			</div>
			)
			},

			creationTime: ({ row }: any) => {
			return (
			<div>
			{row.creationTime != null
			? dayjs(row.creationTime).format('YYYY-MM-DD HH:mm:ss')
			: '-'}
			</div>
			)
			},

			*/

			foreach (var columnModel in columnModelList)
			{
			//å±æ§å°å
			var instanceColumnName = CommonHelper.FirstLowercase(columnModel.ColumnName);
			//è·åæ°æ®ç±»å
			DataTypeEnum enumDT = (DataTypeEnum)Enum.Parse(typeof(DataTypeEnum), "dt_" + columnModel.DataType.ToString());
			switch (enumDT)
			{
			case DataTypeEnum.dt_datetime:
			sb.Append(instanceColumnName + ": ({ row }: any) => { \n");
			sb.Append(" return ( \n");
			sb.Append(" <div> \n");
			sb.Append(" {row." + instanceColumnName + " != null \n");
			sb.Append(" ? dayjs(row." + instanceColumnName + ").format('YYYY-MM-DD HH:mm:ss') \n");
			sb.Append(" : '-'} \n");
			sb.Append(" </div> \n");
			sb.Append(" ) \n");
			sb.Append("},\n");
			break;

			case DataTypeEnum.dt_bit:
			case DataTypeEnum.dt_tinyint:
			sb.Append(instanceColumnName + ": ({ row }: any) => { \n");
			sb.Append(" return ( \n");
			sb.Append(" <div> \n");
			sb.Append(" {row." + instanceColumnName + " != null ? (row." + instanceColumnName + " ? 'æ¯' : 'å¦') : '-'} \n");
			sb.Append(" </div> \n");
			sb.Append(" ) \n");
			sb.Append("},\n");
			break;
			}

			}

			//å»ææåä¸ä¸ª,
			var res = sb.ToString();
			res = res.Substring(0, res.Length - 1);
			return res;
			}
			catch (Exception ex)
			{
			throw ex;
			}
			}

			/// <summary>
			/// è·åVUE å¯¼åºæ°ç»åç¬¦ä¸²-æ±å+å±æ§
			/// </summary>