public ActionResult Query() { string json = Request["data"]; if (string.IsNullOrWhiteSpace(json)) { throw new BusinessException("传入数据不能为空"); } QF_Role qf = JsonConvert.DeserializeObject <QF_Role>(json); var result = role_sevice.QueryRoleList(qf); return(AjaxJsonTableData(result)); }
/// <summary> /// 分页查询Role信息 /// </summary> public static QueryResult <Role> QueryRoleList(QF_Role filter) { DataCommand cmd = new DataCommand("QueryRoleList"); cmd.QuerySetCondition("r.SysNo", ConditionOperation.Equal, DbType.Int32, filter.SysNo); cmd.QuerySetCondition("r.RoleName", ConditionOperation.Like, DbType.String, cmd.SetSafeParameter(filter.RoleName)); cmd.QuerySetCondition("r.CommonStatus", ConditionOperation.Equal, DbType.Int32, filter.CommonStatus); cmd.QuerySetCondition("r.CommonStatus", ConditionOperation.NotEqual, DbType.Int32, CommonStatus.Deleted);//TOOD: 查询需不需要排除角色删除(已禁用)的? cmd.QuerySetCondition("r.ApplicationID", ConditionOperation.Equal, DbType.String, cmd.SetSafeParameter(filter.ApplicationID)); QueryResult <Role> result = cmd.Query <Role>(filter, " r.SysNo DESC"); return(result); }
/// <summary> /// 分页查询Role信息 /// </summary> public QueryResult <Role> QueryRoleList(QF_Role filter) { return(RoleDA.QueryRoleList(filter)); }