//绑定搜索的课程信息 public void DataBindSearchCourse() { DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); // Response.Write(ddlCourses.SelectedValue); DataTable dt = dal.GetAllStudentGradeCheckApply(ddlCourses.SelectedValue == "all" ? "all_" + ddlTermTags.SelectedValue : ddlCourses.SelectedValue, ddlApplyResult.SelectedValue, ddlApplyLocale.SelectedValue).Tables[0]; DataView dv = dt.DefaultView; this.AspNetPager1.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); //定义一个PagedDataSource类来执行分页功 pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; pds.PageSize = CommonUtility.pageSize; this.dlstGradeCheckApply.DataSource = pds; this.dlstGradeCheckApply.DataBind(); if (dt.Rows.Count == 0) { this.dlstGradeCheckApply.ShowFooter = true; } else { this.dlstGradeCheckApply.ShowFooter = false; } }
public void ProcessRequest(HttpContext context) { CommonFunction.CheckUser(); context.Response.CacheControl = "no-cache"; string termTagCourseNoClassID = context.Server.UrlDecode(context.Request["termTagCourseNoClassID"]); string termTag = (context.Request["termTag"] == null ? string.Empty : context.Request["termTag"]); string courseName = (context.Request["courseName"] == null ? string.Empty : context.Server.UrlDecode(context.Request["courseName"])); string gradeCheckApplyExcel = System.Configuration.ConfigurationManager.AppSettings["GradeCheckApplyExcel"]; //StringBuilder sb = new StringBuilder(); HSSFWorkbook workbook = new HSSFWorkbook(); DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); //// Response.Write(ddlCourses.SelectedValue); DataTable dt = dal.GetAllStudentGradeCheckApply(termTagCourseNoClassID, "all","all").Tables[0]; //创建WorkSheet HSSFSheet sheet1 = workbook.CreateSheet(CommonUtility.ChangeTermToString(termTag) + "_" + courseName); sheet1.CreateRow(0).CreateCell(0).SetCellValue("序号"); sheet1.CreateRow(0).CreateCell(1).SetCellValue("学号"); sheet1.CreateRow(0).CreateCell(2).SetCellValue("姓名"); sheet1.CreateRow(0).CreateCell(3).SetCellValue("专业"); sheet1.CreateRow(0).CreateCell(4).SetCellValue("班级"); sheet1.CreateRow(0).CreateCell(5).SetCellValue("手机号"); sheet1.CreateRow(0).CreateCell(6).SetCellValue("邮件地址"); sheet1.CreateRow(0).CreateCell(7).SetCellValue("所属学期"); sheet1.CreateRow(0).CreateCell(8).SetCellValue("课程名称"); sheet1.CreateRow(0).CreateCell(9).SetCellValue("重修重考类型"); sheet1.CreateRow(0).CreateCell(10).SetCellValue("审核结果"); sheet1.CreateRow(0).CreateCell(11).SetCellValue("备注"); int drRowCount = dt.Rows.Count; for (int i = 0; i < drRowCount; i++) { sheet1.CreateRow(i + 1).CreateCell(0).SetCellValue(i + 1); sheet1.CreateRow(i + 1).CreateCell(1).SetCellValue(dt.Rows[i]["studentNo"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(2).SetCellValue(dt.Rows[i]["studentName"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(3).SetCellValue(dt.Rows[i]["studentSpeciality"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(4).SetCellValue(dt.Rows[i]["SchoolClassName"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(5).SetCellValue(dt.Rows[i]["mobileNo"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(6).SetCellValue(dt.Rows[i]["emailAddress"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(7).SetCellValue(CommonUtility.ChangeTermToString(termTag)); sheet1.CreateRow(i + 1).CreateCell(8).SetCellValue(courseName); sheet1.CreateRow(i + 1).CreateCell(9).SetCellValue(dt.Rows[i]["gradeCheckApplyType"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(10).SetCellValue(dt.Rows[i]["applyResult"].ToString().Trim()); sheet1.CreateRow(i + 1).CreateCell(11).SetCellValue(dt.Rows[i]["applyChecKSuggestion"].ToString().Trim()); } string fileName = CommonUtility.ChangeTermToString(termTag) + "_" + courseName + UploadFiles.DateTimeString(); if (!Directory.Exists(context.Server.MapPath(gradeCheckApplyExcel))) { Directory.CreateDirectory(context.Server.MapPath(gradeCheckApplyExcel)); } System.IO.FileStream file = new System.IO.FileStream(HttpContext.Current.Server.MapPath(gradeCheckApplyExcel + fileName + ".xls"), System.IO.FileMode.Create); workbook.Write(file); file.Dispose(); ////插入值 FileInfo DownloadFile = new FileInfo(context.Server.MapPath(gradeCheckApplyExcel + fileName + ".xls")); context.Response.Clear(); context.Response.ClearHeaders(); context.Response.Buffer = false; Encoding code = Encoding.GetEncoding("gb2312"); context.Response.ContentEncoding = Encoding.UTF8; context.Response.HeaderEncoding = code;//这句很重要 context.Response.ContentType = "application/octet-stream"; context.Response.AppendHeader("Content-Disposition", "attachment;filename=" + fileName + ".xls"); context.Response.AppendHeader("Content-Length", DownloadFile.Length.ToString()); context.Response.WriteFile(DownloadFile.FullName); if (File.Exists(context.Server.MapPath(gradeCheckApplyExcel + fileName + ".xls"))) { File.Delete(context.Server.MapPath(gradeCheckApplyExcel + fileName + ".xls")); } context.Response.Flush(); }