public async Task <RManufacturer[]> Search(string name, EnumDefine.StatusEnum status, RefSqlPaging paging) { var datas = await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Name", name, DbType.String); parameters.Add("@Status", status.AsEnumToInt(), DbType.Int32); parameters.Add("@OFFSET", paging.OffSet, DbType.String); parameters.Add("@FETCH", paging.PageSize, DbType.String); return(await connection.QueryAsync <RManufacturer>(ProcName.Manufacturer_SearchByName, parameters, commandType: CommandType.StoredProcedure)); }); return(datas.ToArray()); }
public async Task <RManufacturer[]> Search(string name, EnumDefine.StatusEnum status, RefSqlPaging sqlPaging) { return(await _manufacturerRepository.Search(name, status, sqlPaging)); }