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));
}
