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);
}));
}
