public async Task <RDepartment[]> Search(string name, EnumDefine.DepartmentStatusEnum status, RefSqlPaging sqlPaging)
{
return(await WithConnection(async (connection) =>
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@Name", name, DbType.String);
parameters.Add("@Status", status.AsEnumToInt(), DbType.Int64);
parameters.Add("@OFFSET", sqlPaging.OffSet, DbType.Int32);
parameters.Add("@FETCH", sqlPaging.PageSize, DbType.Int32);
var data = (await connection.QueryAsync <RDepartment>(ProcName.Department_Search, parameters, commandType: CommandType.StoredProcedure)).ToArray();
if (data.Length > 0)
{
sqlPaging.TotalRow = data[0].TotalRow;
}
return data.ToArray();
}));
}
public void Init(DepartmentChangeCommand mesage)
{
Id = mesage.Id;
Name = mesage.Name;
Status = mesage.Status;
}
public async Task <RDepartment[]> DepartmentSearchFromDb(string name, EnumDefine.DepartmentStatusEnum status, RefSqlPaging sqlPaging)
{
return(await _departmentRepository.Search(name, status, sqlPaging));
}