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