Example #1
0
 public List <DoMatGridObject> GetAll(DoMatTableGridRequest request)
 {
     using (IDbConnection db = new SqlConnection(Connections.Connection))
     {
         DynamicParameters parameters = new DynamicParameters();
         parameters.Add("@DoMat", request.DoMat);
         parameters.Add("@GhiChu", request.GhiChu);
         parameters.Add("@PageIndex", request.PageIndex);
         parameters.Add("@PageSize", request.PageSize);
         var list = db.Query <DoMatGridObject>("SearchallDoMat", parameters, null, true, null, CommandType.StoredProcedure).AsList <DoMatGridObject>();
         return(list);
     }
 }
 public JsonResult getAllSearch([FromBody] DoMatTableGridRequest request)
 {
     return(Json(domatRepo.GetAll(request)));
 }