public List <DoKhanGridObject> GetAll(DoKhanTableGridRequest request)
 {
     using (IDbConnection db = new SqlConnection(Connections.Connection))
     {
         DynamicParameters parameters = new DynamicParameters();
         parameters.Add("@DoKhan", request.DoKhan);
         parameters.Add("@GhiChu", request.GhiChu);
         parameters.Add("@PageIndex", request.PageIndex);
         parameters.Add("@PageSize", request.PageSize);
         var list = db.Query <DoKhanGridObject>("SearchallDoKhan", parameters, null, true, null, CommandType.StoredProcedure).AsList <DoKhanGridObject>();
         return(list);
     }
 }
Exemple #2
0
 public JsonResult getAllSearch([FromBody] DoKhanTableGridRequest request)
 {
     return(Json(dokhanRepo.GetAll(request)));
 }