Esempio n. 1
0
 public List <LoaiVanBanGridObject> GetAll(LoaiVanBanTableGridRequest request)
 {
     using (IDbConnection db = new SqlConnection(Connections.Connection))
     {
         DynamicParameters parameters = new DynamicParameters();
         parameters.Add("@MaLoaiVB", request.MaLoaiVB);
         parameters.Add("@TenLoaiVB", request.TenLoaiVB);
         parameters.Add("@TenVietTat", request.TenVietTat);
         parameters.Add("@KieuVanBan", request.KieuVanBan);
         parameters.Add("@PageIndex", request.PageIndex);
         parameters.Add("@PageSize", request.PageSize);
         var list = db.Query <LoaiVanBanGridObject>("SearchallLoaiVanBan", parameters, null, true, null, CommandType.StoredProcedure).AsList <LoaiVanBanGridObject>();
         return(list);
     }
 }
Esempio n. 2
0
 public JsonResult getAllSearch([FromBody] LoaiVanBanTableGridRequest request)
 {
     return(Json(loaivanbanRepo.GetAll(request)));
 }