public List <VanBanGridObject> GetAll(VanBanTableGridRequest request)
{
using (IDbConnection db = new SqlConnection(Connections.Connection))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@VBDiDen", request.VbdiDen);
parameters.Add("@MaLoaiVB", request.MaLoaiVb);
parameters.Add("@MaCQBH", request.MaCqbh);
parameters.Add("@SoVB", request.SoVb);
parameters.Add("@SoDen", request.SoDen);
parameters.Add("NgayDen", request.NgayDen);
parameters.Add("@DoMat", request.DoMat);
parameters.Add("@DoKhan", request.DoKhan);
parameters.Add("@TrichYeu", request.TrichYeu);
parameters.Add("@NoiNhan", request.NoiNhan);
parameters.Add("@NgayKy", request.NgayKy);
parameters.Add("@NguoiKy", request.NguoiKy);
parameters.Add("@KetQuaXuLy", request.KetQuaXuLy);
parameters.Add("@FileDinhKem", request.FileDinhKem);
parameters.Add("@HanXuLy", request.HanXuLy);
parameters.Add("@PageIndex", request.PageIndex);
parameters.Add("@PageSize", request.PageSize);
var list = db.Query <VanBanGridObject>("SearchallVanBan", parameters, null, true, null, CommandType.StoredProcedure).AsList <VanBanGridObject>();
return(list);
}
}
public JsonResult getAllSearch([FromBody] VanBanTableGridRequest request)
{
return(Json(vanbanRepo.GetAll(request)));
}
