public void TaskList() { string deviceno = this.GetFormValue("deviceno", ""); string starttime = this.GetFormValue("starttime", ""); int pageindex = this.GetFormValue("page", 1); int pageSize = this.GetFormValue("pagesize", 20); int recordCount = 0; TaskWhere where = new TaskWhere(); where.deviceno = this.GetFormValue("deviceno", ""); where.starttime = this.GetFormValue("starttime", ""); where.status = this.GetFormValue("status", ""); List <TaskModel> result = TaskService.Instance.GetTaskList(pageindex, pageSize, out recordCount, where); int pageCount = recordCount / pageSize; if (recordCount % pageSize != 0) { ++pageCount; } this.Data["PageSize"] = pageSize; this.Data["PageIndex"] = pageindex; this.Data["Total"] = recordCount; this.Data["PageCount"] = pageCount; this.Data["Rows"] = result; }
public List <TaskModel> GetTaskList(int pageIndex, int pageSize, out int recordCount, TaskWhere where) { List <TaskModel> list = taskDal.GetTaskListPage(pageIndex, pageSize, out recordCount, where); return(list); }
public List <TaskModel> GetTaskListPage(int pageIndex, int pageSize, out int recordCount, TaskWhere where) { string sql = @"select * from sayhi_task where 1=1"; if (where != null) { if (!string.IsNullOrEmpty(where.deviceno)) { sql += string.Format(" and deviceno like'%{0}%' ", where.deviceno); } if (!string.IsNullOrEmpty(where.starttime)) { sql += string.Format(" and starttime>= '{0}' ", where.starttime); } if (!string.IsNullOrEmpty(where.status)) { sql += string.Format(" and status={0}", where.status); } } string querySql = DbHelperSQL.buildPageSql(pageIndex, pageSize, sql, "createtime", false); string recordCountSql = DbHelperSQL.buildRecordCountSql(sql); recordCount = Convert.ToInt32(DbHelperSQL.GetSingle(recordCountSql)); List <TaskModel> lst = new List <TaskModel>(); using (SqlDataReader dr = DbHelperSQL.ExecuteReader(querySql)) { lst = DbHelperSQL.GetEntityList <TaskModel>(dr); } return(lst); }