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