public ActionResult ChartJson(int connid, int count = 0) { return(this.ConnVisit(connid, (conn) => { tb_sqlhash_noparam_dal dal = new tb_sqlhash_noparam_dal(); List <tb_sqlhash_noparam_model> model = new List <tb_sqlhash_noparam_model>(); using (DbConn PubConn = DbConfig.CreateConn(conn)) { PubConn.Open(); model = dal.GetChartJson(PubConn, count); } return Json(new { data = model }); })); }
// // GET: /TimeWatchCustomer/SqlHashNoParam/ public ActionResult Index(string sqlhash, string sql, string orderby = "count desc", int connid = 0, int pagesize = 15, int pageindex = 1) { return(this.ConnVisit(connid, (conn) => { ViewBag.sqlhash = sqlhash; ViewBag.sql = sql; ViewBag.orderby = orderby; tb_sqlhash_noparam_dal dal = new tb_sqlhash_noparam_dal(); PagedList <tb_sqlhash_noparam_model> pageList = null; int count = 0; using (DbConn PubConn = DbConfig.CreateConn(conn)) { PubConn.Open(); List <tb_sqlhash_noparam_model> List = dal.GetList(PubConn, sqlhash, sql, orderby, pagesize, pageindex, out count); pageList = new PagedList <tb_sqlhash_noparam_model>(List, pageindex, pagesize, count); } if (Request.IsAjaxRequest()) { return PartialView("List", pageList); } return View(pageList); })); }