DDMesApi.git - Gitblit

			@@ -320,7 +320,7 @@
			left join TOrganization t on u.stu_torgcode=t.org_code
			left join TGroup g on u.usergroup_code=g.group_code
			left join TUser S on u.lm_user=S.usercode
			where u.is_delete<>1 " + search;
			where u.is_delete='0' and u.userclassid='0' " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -589,7 +589,7 @@
			{
			sql = @"select B.role_code as code,B.role_name as name,(case when C.role_code is null then 'N' else 'Y' end) flag from TRole B
			left join(select role_code from TUserRoleRelation where user_code=@usercode) C on B.role_code=C.role_code
			where B.roletype_code=@roletype_code and B.is_delete='0'";
			where B.roletype_code=@roletype_code and B.is_delete='0' and B.is_system='0'";
			dynamicParams.Add("@roletype_code", data[i].code);
			dynamicParams.Add("@usercode", usercode);
			var data0 = DapperHelper.select<TreeObejctCn>(sql, dynamicParams);
			@@ -1084,7 +1084,7 @@
			from TRole A
			left join TRoleType B on A.roletype_code=B.roletype_code
			left join TUser T on A.lm_user=T.usercode
			where A.is_delete<>'1' " + search;
			where A.is_delete='0' and A.is_system='0' " + search;
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";
			mes.Message = "查询成功!";
			@@ -1270,7 +1270,7 @@
			left join TOrganization B on A.stu_torgcode=B.org_code
			left join (
			select distinct user_code from TUserRoleRelation where role_code=@rolecode
			) C on A.usercode=C.user_code where A.is_delete<>'1' " + search;
			) C on A.usercode=C.user_code where A.is_delete='0' and A.userclassid='0' " + search;
			dynamicParams.Add("@rolecode", rolecode);
			var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
			mes.code = "200";