public void tt() { string TaskConnectString = "Server=localhost;Database=dyd_bs_task;Uid=root;Pwd=123456;"; using (DbConn PubConn = DbConn.CreateConn(TaskConnectString)) { tb_node_dal dal = new tb_node_dal(); PubConn.Open(); int count; List <tb_node_model> List = dal.GetList(PubConn, null, null, null, 2, 1, out count); Console.WriteLine("list.count" + List.Count); } }
// // GET: /Node/ public ActionResult Index(string keyword, string CStime, string CEtime, int pagesize = 10, int pageindex = 1) { return(this.Visit(EnumUserRole.Admin, () => { ViewBag.sqldatetimenow = DateTime.Now; tb_node_dal dal = new tb_node_dal(); PagedList <tb_node_model> pageList = null; int count = 0; using (DbConn PubConn = DbConn.CreateConn(Config.TaskConnectString)) { PubConn.Open(); List <tb_node_model> List = dal.GetList(PubConn, keyword, CStime, CEtime, pagesize, pageindex, out count); pageList = new PagedList <tb_node_model>(List, pageindex, pagesize, count); ViewBag.sqldatetimenow = PubConn.GetServerDate(); } return View(pageList); })); }