private void Do()
{
tb_sqlhash_url_contrast_dal Dal = new tb_sqlhash_url_contrast_dal();
bool c = Dal.GenerationTask();
if (c)
{
base.OpenOperator.Log("统计SQLHASH和URL的对照信息成功");
}
}
//
// GET: /TimeWatchCustomer/SqlHashContrastUrl/
public ActionResult Index(string sqlhash, string sql, string url, string orderby = "", int connid = 0, int pagesize = 10, int pageindex = 1)
{
return(this.ConnVisit(connid, (conn) =>
{
ViewBag.sqlhash = sqlhash; ViewBag.sql = sql; ViewBag.url = url; ViewBag.orderby = orderby;
tb_sqlhash_url_contrast_dal dal = new tb_sqlhash_url_contrast_dal();
PagedList <tb_sqlhash_url_contrast_model> pageList = null;
int count = 0;
using (DbConn PubConn = DbConfig.CreateConn(conn))
{
PubConn.Open();
List <tb_sqlhash_url_contrast_model> List = dal.GetList(PubConn, sqlhash, sql, url, orderby, pagesize, pageindex, out count);
pageList = new PagedList <tb_sqlhash_url_contrast_model>(List, pageindex, pagesize, count);
}
if (Request.IsAjaxRequest())
{
return PartialView("List", pageList);
}
return View(pageList);
}));
}
