private void ExportWord() { WordHelper helper = new WordHelper(); String file = Server.MapPath("/resource/sciProject.dot"); helper.CreateNewWordDocument(file); DataClassesDataContext dc = new DataClassesDataContext(); String F_ID = Session[SessionMgm.SciProjectID].ToString(); ScienceProject project = dc.ScienceProject.SingleOrDefault(sp => sp.F_ID.Equals(F_ID)); if (project != null) { fillContent(helper, project); } project.F_name = UtilHelper.getValidatePath(project.F_name); String fileName = Server.MapPath("/resource/" + project.F_name + ".doc"); bool result = helper.SaveAs(fileName); helper.Close(); Response.ClearContent(); Response.ClearHeaders(); Response.ContentType = "Application/msword"; Response.AddHeader("Content-Disposition", "attachment;filename=" + Server.UrlEncode(project.F_name) + ".doc"); Response.TransmitFile(fileName); Response.Flush(); Response.Close(); Response.End(); }
private void ExportData(String F_ID, String selectCMD) { SqlDataAdapter adapter = new SqlDataAdapter(); String orderCmd = " order by F_seq "; String sql = "select F_code, F_name, F_leader, F_unit, F_type, CONVERT(varchar(100), F_applicantDate, 23), CONVERT(varchar(100), F_completeDate, 23) , F_status, F_fund from ViewAuditedBySchool where "; adapter.SelectCommand = new SqlCommand(sql + selectCMD + orderCmd); adapter.SelectCommand.Connection = new SqlConnection(UtilHelper.ConnectionString); DataTable dt = new DataTable(); adapter.Fill(dt); if (dt.Rows.Count == 0) { UtilHelper.AlertMsg("没有数据"); return; } sql = "select F_code, F_name, F_leader, F_unit, F_type, CONVERT(varchar(100), F_applicantDate, 23), CONVERT(varchar(100), F_completeDate, 23) , " + " F_status, F_fund from ViewAuditedBySchool where F_projectType='科技项目' and "; adapter.SelectCommand = new SqlCommand(sql + selectCMD + orderCmd); adapter.SelectCommand.Connection = new SqlConnection(UtilHelper.ConnectionString); dt = new DataTable(); adapter.Fill(dt); DataClassesDataContext dc = new DataClassesDataContext(); ProjectDetail projectDetail = dc.ProjectDetail.SingleOrDefault(_pd => _pd.F_ID.Equals(F_ID)); String sciFileName = Server.MapPath("/resource/" + UtilHelper.getValidatePath(projectDetail.F_code) + "科技项目汇总表.xls"); ExportFile(dt, sciFileName); sql = "select F_code, F_name, F_leader, F_unit, F_type, CONVERT(varchar(100), F_applicantDate, 23), CONVERT(varchar(100), F_completeDate, 23) , " + " F_status, F_fund from ViewAuditedBySchool where F_projectType='社科项目' and "; adapter.SelectCommand = new SqlCommand(sql + selectCMD + orderCmd); adapter.SelectCommand.Connection = new SqlConnection(UtilHelper.ConnectionString); dt = new DataTable(); adapter.Fill(dt); String socialFileName = Server.MapPath("/resource/" + UtilHelper.getValidatePath(projectDetail.F_code) + "社科项目汇总表.xls"); ExportFile(dt, socialFileName); List <String> outputFiles = new List <string>(); if (File.Exists(sciFileName)) { outputFiles.Add(sciFileName); } if (File.Exists(socialFileName)) { outputFiles.Add(socialFileName); } String zipFile = Server.MapPath("/resource/" + UtilHelper.getValidatePath(projectDetail.F_code) + "项目汇总表.zip"); UtilHelper.ZipFileMain(outputFiles, zipFile); DownloadFile("项目汇总表.zip", zipFile); }
protected void Unnamed_Click(object sender, EventArgs e) { WordHelper helper = new WordHelper(); String file = Server.MapPath("/resource/socialProject.dot"); helper.CreateNewWordDocument(file); DataClassesDataContext dc = new DataClassesDataContext(); String F_ID = (sender as LinkButton).CommandArgument; SocialProject project = dc.SocialProject.SingleOrDefault(sp => sp.F_ID.Equals(F_ID)); fillContent(helper, project); fillParticipants(helper, project); fillAudit(helper, project); project.F_name = UtilHelper.getValidatePath(project.F_name); String fileName = Server.MapPath("/resource/" + project.F_name + ".doc"); bool result = helper.SaveAs(fileName); helper.Close(); Response.Clear(); Response.ContentType = "Application/msword"; Response.AddHeader("content-disposition", "attachment;filename=" + HttpUtility.HtmlEncode(Path.GetFileName(fileName))); Response.TransmitFile(fileName); Response.End(); }