private void Do() { tb_sqlhash_consult_dal Dal = new tb_sqlhash_consult_dal(); int SqlJudgeBase = Convert.ToInt32(base.AppConfig["SqlJudgeBase"]); bool c = Dal.SqlHashContrast(SqlJudgeBase); if (c) { base.OpenOperator.Log("性能监控定时统计SQL性能成功"); } }
public ActionResult ChartJson(int connid, int count = 0) { return(this.ConnVisit(connid, (conn) => { tb_sqlhash_consult_dal dal = new tb_sqlhash_consult_dal(); List <tb_sqlhash_consult_model> model = new List <tb_sqlhash_consult_model>(); using (DbConn PubConn = DbConfig.CreateConn(conn)) { PubConn.Open(); model = dal.GetChartJson(PubConn, count); } return Json(new { data = model }); })); }
// // GET: /TimeWatchCustomer/SqlHashConsult/ public ActionResult Index(string sqlhash, string sql, string orderby = "count desc", int connid = 0, int extime = 0, int pagesize = 15, int pageindex = 1) { return(this.ConnVisit(connid, (conn) => { ViewBag.sqlhash = sqlhash; ViewBag.sql = sql; ViewBag.orderby = orderby; ViewBag.extime = extime; tb_sqlhash_consult_dal dal = new tb_sqlhash_consult_dal(); PagedList <tb_sqlhash_consult_model> pageList = null; int count = 0; using (DbConn PubConn = DbConfig.CreateConn(conn)) { PubConn.Open(); List <tb_sqlhash_consult_model> List = dal.GetList(PubConn, sqlhash, sql, orderby, extime, pagesize, pageindex, out count); pageList = new PagedList <tb_sqlhash_consult_model>(List, pageindex, pagesize, count); } if (Request.IsAjaxRequest()) { return PartialView("List", pageList); } return View(pageList); })); }