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());
        }
Пример #2
0
 public async Task <RManufacturer[]> Search(string name, EnumDefine.StatusEnum status, RefSqlPaging sqlPaging)
 {
     return(await _manufacturerRepository.Search(name, status, sqlPaging));
 }