public async Task <RRole[]> Search(string name, EnumDefine.RoleStatusEnum status, string departmentId, RefSqlPaging sqlPaging) { return(await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Name", name, DbType.String); parameters.Add("@Status", status.AsEnumToInt(), DbType.String); parameters.Add("@DepartmentId", departmentId, DbType.String); parameters.Add("@OFFSET", sqlPaging.OffSet, DbType.String); parameters.Add("@FETCH", sqlPaging.PageSize, DbType.String); var data = (await connection.QueryAsync <RRole>(ProcName.Role_Search, parameters, commandType: CommandType.StoredProcedure)).ToArray(); if (data.Length > 0) { sqlPaging.TotalRow = data[0].TotalRow; } return data; })); }
public async Task <RRole[]> RoleSearch(string name, EnumDefine.RoleStatusEnum status, string departmentId, RefSqlPaging sqlPaging) { return(await _roleRepository.Search(name, status, departmentId, sqlPaging)); }