~kyy/LW_MesService.git

			@@ -38,6 +38,9 @@
			[RequestMethod(RequestMethods.POST)]
			public ReturnDto<PageList<dynamic>> GetListPage([FromBody] PageQuery model)
			{

			//(case a.isStatus when 1 then '正常' when - 1 then '禁用' else cast(a.isStatus as nvarchar(4)) end) as isStatusTxt

			var currentPage = model.currentPage;
			var everyPageSize = model.everyPageSize;
			var sortName = string.IsNullOrEmpty(model.sortName)
			@@ -49,7 +52,7 @@
			sbSql.Append("( ");
			sbSql.Append("select top 100000 ROW_NUMBER() over(order by " +
			sortName + " " + model.sortOrder +
			") as rowIndex,cast(0 as bit) as chkInt, a.*,(a.processNo+':'+a.processName) as processNoAndName,(case a.isStatus when 1 then '正常' when -1 then '禁用' else cast(a.isStatus as nvarchar(4)) end) as isStatusTxt from WORK_PROCESS a where 1=1" +
			") as rowIndex,cast(0 as bit) as chkInt, a.*,(a.PROC_NO+':'+a.PROC_NAME) as processNoAndName from MES_PROC_INFO a where 1=1" +
			keyWhere);
			sbSql.Append(") as T ");
			sbSql.Append(" where T.rowindex>(" + currentPage + "-1)*" +
			@@ -57,8 +60,8 @@
			everyPageSize);
			sbSql.Append(" order by rowindex asc ");
			sbSql.Append(
			" select count(1) as intTotal from WORK_PROCESS a where 1=1 " +
			keyWhere);
			" select count(1) as intTotal from MES_PROC_INFO a where 1=1 " +
			keyWhere);
			var dset = new DataSet();
			try
			{
			@@ -120,7 +123,7 @@
			return ReturnDto<int>.QuickReturn(default(int?),
			ReturnCode.Exception, "删除失败，该信息已被审核！");
			System.Text.StringBuilder sbSql = new StringBuilder();
			sbSql.Append("delete from WORK_PROCESS ");
			sbSql.Append("delete from MES_PROC_INFO ");
			sbSql.Append(" where guid in (select line from dbo.fn_split('" + sbGuid.ToString() + "',','))");
			var rows = DbHelperSQL.ExecuteSql(sbSql.ToString());
			rtnInt = rows;