public async Task <RTemplateConfig[]> Search(string id, string templateId, EnumDefine.TemplateConfigComponentTypeEnum componentType, EnumDefine.CommonStatusEnum status, RefSqlPaging paging) { return(await WithConnection(async (connection) => { DynamicParameters parameters = new DynamicParameters(); parameters.Add("@Id", string.IsNullOrEmpty(id) ? string.Empty : id, DbType.String); parameters.Add("@TemplateId", string.IsNullOrEmpty(templateId) ? string.Empty : templateId, DbType.String); parameters.Add("@ComponentType", componentType.AsEnumToInt(), DbType.Int32); parameters.Add("@Status", status.AsEnumToInt(), DbType.Int32); parameters.Add("@OFFSET", paging.OffSet, DbType.Int32); parameters.Add("@FETCH", paging.PageSize, DbType.Int32); parameters.Add("@DeletedStatus", EnumDefine.CommonStatusEnum.Deleted.AsEnumToInt(), DbType.Int32); var data = await connection.QueryAsync <RTemplateConfig>(ProcName.TemplateConfig_Search, parameters, commandType: CommandType.StoredProcedure); var dataReturn = data.ToArray(); if (dataReturn.Length > 0) { paging.TotalRow = dataReturn[0].TotalRow; } return dataReturn; })); }
public async Task <RTemplateConfig[]> SearchTemplateConfig(string id, string templateId, EnumDefine.TemplateConfigComponentTypeEnum componentType, EnumDefine.CommonStatusEnum status, RefSqlPaging paging) { return(await _templateConfigRepository.Search(id, templateId, componentType, status, paging)); }