public static Page GetEd(int page_size, int page_number)
{
DataTable dt = SqlHelper.ExecuteDataTable(page_size, page_number,
"select * from auditorium where status=1 and use_time_end < GETDATE() order by use_time_start desc");
List <ApplyForm> apply_lst = new List <ApplyForm>();
for (int i = 0; i < dt.Rows.Count; i++)
{
int id = int.Parse(dt.Rows[i]["id"].ToString());
ApplyForm af = new ApplyForm(id);
apply_lst.Add(af);
}
int total = GetEdCount();
int total_page = total / page_size + 1;
return(new Page(apply_lst, total, page_size, page_number));
}
public static Page GetApplyInfoPage(int page_size, int page_number, int status)
{
DataTable dt = SqlHelper.ExecuteDataTable(page_size, page_number,
"select * from auditorium where status = @status order by use_time_start desc",
new SqlParameter("@status", status));
List <ApplyForm> apply_lst = new List <ApplyForm>();
for (int i = 0; i < dt.Rows.Count; i++)
{
int id = int.Parse(dt.Rows[i]["id"].ToString());
ApplyForm af = new ApplyForm(id);
apply_lst.Add(af);
}
int total = GetNewsCountOfApplyInfo(status);
int total_page = total / page_size + 1;
return(new Page(apply_lst, total, page_size, page_number));
}
