void ExpoertExcel() { //Response.Write("<script>CallWriteExportStat('12');</script>"); //Response.Write("<script>CallWriteExportStat(12,35)</script>"); //Page.ClientScript.RegisterClientScriptBlock(this.GetType(),"xx","alert('12');"); // return; string condtion = GetCondtion(); string sql = @"select (select module_name from module_info where id = (select exami_module from exam_layout where id = b.layout_id)) as module_name, (select user_name from user_info where id =b.user_id ) as user_name, (select user_sex from user_info where id = b.user_id) as user_sex, b.user_card, (select work_name from work_info where id = b.work_id) as work_name, (select exami_name from exam_layout where id = b.layout_id ) as exami_name, b.score from exami_info b"; //计算统计总数,总分页数 DataTable Art_Table = DataCenter.Instans.SearchTb(string.Format("select count(id) as ct from exami_info b {0}", condtion)); int Datacount = int.Parse(Art_Table.Rows[0]["ct"].ToString()); double dx = ((double)Datacount / EvPage); int SumPage = (int)Math.Ceiling(dx);//总页数 //组合导出条件 var item = new ExportContion() { sql = sql, condtion = condtion, DataCount = Datacount, SumPage = SumPage, EvePage = EvPage }; DataToExcel.ExportExcelTemplate(item, ExcelPath, "公考成绩查询统计表", 3, 1, "", "", ""); }