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