protected void rptList_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { DataRowView drv = (DataRowView)e.Item.DataItem; string reportStatus = drv["当前状态"].ToString(); Button updateStatus = (Button)e.Item.FindControl("btnUpdateStatus"); if (reportStatus == "等待确认") { updateStatus.CommandName = "ConfirmReport"; updateStatus.Text = "确认"; } else if (reportStatus == "等待上传") { //updateStatus.CommandName = "CancelConfirm"; //updateStatus.Text = "取消确认"; updateStatus.Visible = false; } else { updateStatus.Visible = false; } int reportUploadStatus = NumberTools.getInt(drv["网页"].ToString()); Literal litHref = (Literal)e.Item.FindControl("litHref"); if (reportUploadStatus == 1) { litHref.Text = "<a style='color:#06c;' data-title=\"2申报主表\" _href='ExcelDetail.aspx?type=1&Pid=A02&ReportName=" + HttpUtility.UrlEncode(drv["报告号"].ToString(), Encoding.GetEncoding("utf-8")) + "&CompanyName=" + HttpUtility.UrlEncode(drv["公司名称"].ToString(), Encoding.GetEncoding("utf-8")) + "' onclick=\"Hui_admin_tab(this)\" href=\"javascript:;\">查看报表</a>"; } else { litHref.Text = "查看报表"; } } }
protected void Page_Load(object sender, EventArgs e) { int fromType; fromType = NumberTools.getInt(Request.QueryString["Type"]); string reportName; string reportNo; string rootPath = Server.MapPath("~/"); if (!rootPath.EndsWith("\\")) { rootPath = rootPath + "\\"; } //报表导出 if (fromType == 2) { if (Session["ReportName"] == null || Session["ReportNo"] == null) { ScriptHelper.addMsg(this.Page, "请选择报告后再下载"); return; } reportName = Session["ReportName"].ToString(); reportNo = Session["ReportNo"].ToString(); string exportExcelFilePath; int fType = NumberTools.getInt(Request["ftype"]); if (fType == 1) { exportExcelFilePath = rootPath + "Report\\" + reportName + "\\" + reportName + reportNo + ".xls"; } else { //ZipOut zipOut = new ZipOut(); //string strZipPath = rootPath + "Zip\\" + reportName + ".Zip"; //string strZipTopDirectoryPath = rootPath + "Report\\" + reportName; //int intZipLevel = 6; //string strPassword = ""; //string[] filesOrDirectoriesPaths = new string[] { strZipTopDirectoryPath }; //zipOut.Zip(strZipPath, strZipTopDirectoryPath, intZipLevel, strPassword, filesOrDirectoriesPaths); //Response.Redirect("Zip\\"+reportName+".Zip"); exportExcelFilePath = rootPath + "Report\\" + reportName + "\\" + reportName + "ALL.xls"; } if (!System.IO.File.Exists(exportExcelFilePath)) { ScriptHelper.addMsg(this.Page, "报告还没有生成"); return; } if (fType == 1) { Response.Redirect("Report\\" + reportName + "\\" + reportName + reportNo + ".xls"); } else { Response.Redirect("Report\\" + reportName + "\\" + reportName + "ALL.xls"); } return; } reportName = HttpUtility.UrlDecode(Request.QueryString["ReportName"]); reportNo = Request.QueryString["Pid"]; Session["ReportName"] = reportName; string htmlClientFolderName = reportName.Replace('[', '_').Replace(']', '_'); if (string.IsNullOrEmpty(reportName) || string.IsNullOrEmpty(reportNo)) { ScriptHelper.addMsg(this.Page, "参数不全"); return; } else { Session["ReportNo"] = reportNo; } string fileName = reportNo; string excelDirectoryName = rootPath + "Report\\" + reportName + "\\"; string excelFilePath = rootPath + "Report\\" + reportName + "\\" + reportName + fileName + ".xls"; string htmlDirectoryName = rootPath + "HTML\\" + htmlClientFolderName + "\\"; string htmlFilePath = rootPath + "HTML\\" + htmlClientFolderName + "\\" + fileName + ".html"; if (!System.IO.File.Exists(excelFilePath)) { ScriptHelper.addMsg(this.Page, "报告还没有生成"); return; } if (System.IO.Directory.Exists(htmlDirectoryName) == false)//如果不存在就创建file文件夹 { System.IO.Directory.CreateDirectory(htmlDirectoryName); } //if (!System.IO.File.Exists(htmlFilePath)) { string outputDirPath = rootPath + @"HTML\" + htmlClientFolderName + "\\"; //Word和Excel转换成Html,Html文件存放的位置 ExcelPreview.Excel2Html(this, excelFilePath, outputDirPath, fileName); } //formType 为1 的时候,为右边结果打开左边菜单 if (fromType == 1) { string companyName = ""; if (Request.QueryString["CompanyName"] != null) { companyName = HttpUtility.UrlDecode(Request.QueryString["CompanyName"]);; } ScriptHelper.addScript(this.Page, "Hui_Menu_Change(\"" + companyName + "\",\"" + reportName + "\")"); return; } Response.Redirect("HTML\\" + htmlClientFolderName + "\\" + fileName + ".html"); }