/// <summary>
/// 遍历服务文件夹，生成对应的HTML文件
/// </summary>
public static void GenHTML()
{
//string excelDirectoryName = @"E:\ZSHJ\Web\Report\";
//string htmlDirectoryName = @"E:\ZSHJ\Web\HTML\";
string excelDirectoryName = ConfigurationManager.AppSettings["ExcelDirectroy"].ToString();
string htmlDirectoryName = ConfigurationManager.AppSettings["HTMLDirectroy"].ToString();
if (!Directory.Exists(htmlDirectoryName))
{
Directory.CreateDirectory(htmlDirectoryName);
}
if (Directory.Exists(excelDirectoryName))
{
XmlDocument xmlDoc = LoadXML();
//所有子文件夹
DirectoryInfo reportDirInfo;
FileInfo fileinfo;
string clientName, reportNo, htmlFilePath, htmlDocName;
string fileLastWriteTime, lastModifyTime;
int i = 0, j = 0;
string log = "";
foreach (string item in Directory.GetDirectories(excelDirectoryName))
{
i++;
reportDirInfo = new DirectoryInfo(item);
clientName = reportDirInfo.Name;
//所有子文件
foreach (string fileItem in Directory.GetFiles(reportDirInfo.FullName))
{
j++;
fileinfo = new FileInfo(fileItem);
lastModifyTime = GetLastModifyDateTime(ref xmlDoc, fileinfo.Name);
fileLastWriteTime = fileinfo.LastWriteTime.ToString("yyyy-MM-dd HH:mm:ss");
reportNo = fileinfo.Name.Substring(fileinfo.Name.IndexOf('.') - 3, 3);
if (fileLastWriteTime != lastModifyTime)
{
htmlDocName = reportNo + ".html";
htmlFilePath = htmlDirectoryName + clientName.Replace('[', '_').Replace(']', '_') + "\\";
if (!Directory.Exists(htmlFilePath))
{
Directory.CreateDirectory(htmlFilePath);
}
if (!System.IO.File.Exists(htmlFilePath + htmlDocName))
{
ExcelPreview.Excel2Html(fileinfo.FullName, htmlFilePath, htmlDocName);
}
UpdateNode(ref xmlDoc, fileinfo.Name, fileLastWriteTime);
}
}
log += "第" + i + "个文件夹，共处理了" + j + "个文件";
}
SaveXML(xmlDoc);
}
}
public Response UploadIForm(IFormFile file, string pcode, string scode)
{
string outputDirPath = $"/OfficeFiles/";
Response result = new Infrastructure.Response();
var fileName = file.FileName;
String suffixName = fileName.Substring(fileName.LastIndexOf("."));
Console.WriteLine(fileName);
var newfilename = pcode + scode + suffixName;
fileName = $"/UploadFile/{newfilename}";
fileName = _hostingEnvironment.WebRootPath + fileName;
using (FileStream fs = System.IO.File.Create(fileName))
{
file.CopyTo(fs);
fs.Flush();
}
Step step = _unitWork.Find <Step>(u => u.ProductCode == pcode && u.Code == scode).FirstOrDefault();
if (suffixName.ToUpper() == ".XLSX" || suffixName.ToUpper() == ".XLS")
{
ExcelPreview.Priview(fileName, pcode + scode, _hostingEnvironment.WebRootPath + outputDirPath);
step.LinkSop = "/OfficeFiles/" + pcode + scode + ".html";
}
else if (suffixName.ToUpper() == ".DOC" || suffixName.ToUpper() == ".DOCX")
{
WordPreview.Priview(fileName, pcode + scode, _hostingEnvironment.WebRootPath + outputDirPath);
step.LinkSop = "/OfficeFiles/" + pcode + scode + ".html";
}
else
{
step.LinkSop = "/UploadFile/" + newfilename;
};
_app.Update(step);
return(result);
}
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");
}
protected void btnExcel_Click(object sender, EventArgs e)
{
string filePath = Server.MapPath("~") + @"\DemoFiles\Test.xlsx";
ExcelPreview.Priview(this, filePath, outputDirPath);
}
