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