/// <summary>
/// 装载分页
/// </summary>
/// <param name="EvePageCount"></param>
/// <param name="zd"></param>
/// <param name="TbName"></param>
/// <param name="gourlname"></param>
/// <param name="CurentIdx"></param>
/// <param name="condtoin"></param>
/// <returns></returns>
public string LoadSpliPage(int EvePageCount, string zd, string TbName, string gourlname, int CurentIdx, string condtoin, ref int count)
{
DataTable Art_Table = DataCenter.Instans.SearchTb(string.Format("select count({0}) as ct from {1} {2}", zd, TbName, condtoin));
count = int.Parse(Art_Table.Rows[0]["ct"].ToString());
double dx = ((double)count / EvePageCount);
int SumPage = (int)Math.Ceiling(dx);
SplicPage sp = new SplicPage(EvePageCount, gourlname, SumPage);
return(sp.GreatSplitPageTakeQs(CurentIdx));
}
public string LoadReslustSplitPage(int EvePageCount, string zd, string TbName, string gourlname, int CurentIdx, string condtoin, ref int count)
{
string sql = string.Format(@"SELECT count(b.id) ct from (select a.id,
(select module_name from module_info where id = (select exami_module from exam_layout where id = a.layout_id)) as module_name,
(select user_name from user_info where id =a.user_id ) as user_name,
(select user_sex from user_info where id = a.user_id) as user_sex,
a.user_card,a.work_id,a.exami_module,start_date,
(select work_name from work_info where id = a.work_id) as work_name,
(select exami_name from exam_layout where id = a.layout_id ) as exami_name,
a.score from exami_info a) b {0}", condtoin);
DataTable Art_Table = DataCenter.Instans.SearchTb(sql);
count = int.Parse(Art_Table.Rows[0]["ct"].ToString());
double dx = ((double)count / EvePageCount);
int SumPage = (int)Math.Ceiling(dx);
SplicPage sp = new SplicPage(EvePageCount, gourlname, SumPage);
return(sp.GreatSplitPageTakeQs(CurentIdx));
}
