/// <summary>
/// 生成EXCEL模板文件和执行文件
/// </summary>
/// <param name="obj"></param>
/// <param name="strFilePath"></param>
/// <param name="strKeyWord"></param>
public void ScEXCEL(SheetPrint obj, string strFilePath, string strKeyWord, ref string error)
{
lock (this)
{
try
{
if (obj == null)
{
return;
}
if (string.IsNullOrEmpty(obj.Parameter))
{
error = "设置参数不全,无法生成模板!";
return;
}
if (string.IsNullOrEmpty(obj.SQLText))
{
error = "设置SQL不全,无法生成模板!";
return;
}
if (string.IsNullOrEmpty(obj.Path))
{
error = "未指定EXCEL模板!";
return;
}
string templeFilePath = obj.Path;
if (!templeFilePath.StartsWith(@"\"))
{
templeFilePath = @"\" + templeFilePath;
}
templeFilePath = AppDomain.CurrentDomain.BaseDirectory + "ExcelTemple\\" + templeFilePath;
if (!File.Exists(templeFilePath))
{
error = "指定的EXCEL模板不存在!";
return;
}
//生成EXCEL模板文件
System.IO.FileStream fs = new System.IO.FileStream(templeFilePath, System.IO.FileMode.Open, System.IO.FileAccess.Read, FileShare.ReadWrite);
byte[] bytes = new byte[(int)fs.Length];
fs.Read(bytes, 0, bytes.Length);
fs.Close();
//if (!File.Exists(strFilePath)) Directory.CreateDirectory(strFilePath);
string strModuleExcel = strFilePath + strKeyWord + ".xls";
File.Delete(strModuleExcel);
FileStream fs_stream = new FileStream(strModuleExcel, FileMode.CreateNew);
BinaryWriter writefile = new BinaryWriter(fs_stream);
writefile.Write(bytes);
writefile.Close();
//2.生成XLEXCEL文件
string strModuleXlt = strFilePath + strKeyWord + ".xrf";
FileStream fsxls = new FileStream(strModuleXlt, FileMode.OpenOrCreate, FileAccess.Write);
StreamWriter sw = new StreamWriter(fsxls, System.Text.Encoding.GetEncoding("GB2312"));//通过指定字符编码方式可以实现对汉字的支持，否则在用记事本打开查看会出现乱码
sw.Flush();
sw.BaseStream.Seek(0, SeekOrigin.Begin);
GetConnectString con = new GetConnectString();
GetDataSouce conn = con.GetDataSouce();
string strText = "";
strText = "ExcelReport Version 2.0" + "\r\n" +
"[Data Source]" + "\r\n" +
"Name1=QswmExcelExport" + "\r\n" +
"User1=" + "sa" + "\r\n" +
"Password1=" + conn.UsePassword + "\r\n" +
"" + "\r\n" +
"[File] " + "\r\n" +
"ReportTemplateFileName=" + strKeyWord + ".xls" + "\r\n" +
"ReportFileName=Report\\" + strKeyWord + ".xls" + "\r\n" +
"LogFileName=" + strFilePath + strKeyWord + ".log" + "\r\n"
;
strText = strText + obj.Parameter + "\r\n" + "[SQL]" + "\r\n" + obj.SQLText;
sw.WriteLine(strText);
sw.Flush();
sw.Close();
}
catch (Exception ex)
{
error = "生成Excel失败！" + ex.Message;
//string strModuleExcel = strFilePath + "Errorxls.txt";
//FileStream fs_stream = new FileStream(strModuleExcel, FileMode.CreateNew);
//BinaryWriter writefile = new BinaryWriter(fs_stream);
//writefile.Write(HttpUtility.UrlEncode(error, System.Text.Encoding.UTF8));
//writefile.Close();
throw ex;
}
}
}
public void ShowPrintView(string strReportName, string tt_no, List <string> parms, ref string strFileName, ref string error)
{
lock (this)
{
try
{
strFileName = "";
string strFilePath = AppDomain.CurrentDomain.BaseDirectory;
if (strFilePath.EndsWith("\\"))
{
strFilePath = strFilePath + "EXCEL\\";
}
else
{
strFilePath = strFilePath + "\\EXCEL\\";
}
#region 判断文件夹,如果不存在则重新创建
//if (Directory.Exists(strFilePath))
//{
// try
// {
// Directory.Delete(strFilePath, true);
// }
// catch
// {
// error = "生成报表文件时删除原报表格式错误,可能是EXCEL 文件夹下文件正在使用,请先关闭!";
// return;
// }
//}
//Directory.CreateDirectory(strFilePath);
if (!Directory.Exists(strFilePath))
{
Directory.CreateDirectory(strFilePath);
}
#endregion
//ChangRegedit(ref error);//注册数据源
SheetPrint print1 = new SheetPrint();
//测试用
//获取导出模板
string[] paras = null;
PubMethod.GetExcelParm(strReportName, tt_no, ref paras);
if (paras == null)
{
return;
}
else
{
print1.Parameter = paras[0];
print1.SQLText = paras[1];
print1.Path = paras[2];
}
strFileName = Guid.NewGuid().ToString();
ScEXCEL(print1, strFilePath, strFileName, ref error);
if (string.IsNullOrEmpty(error))
{
ScBb(parms, strFilePath, strFileName, ref error);//生成报表
if (!string.IsNullOrEmpty(error))
{
strFileName = "";
}
}
else
{
strFileName = "";
}
GC.Collect();
}
catch (Exception ex)
{
if (File.Exists(AppDomain.CurrentDomain.BaseDirectory + "Report\\" + strFileName + ".xls"))
{
File.Delete(AppDomain.CurrentDomain.BaseDirectory + "Report\\" + strFileName + ".xls");
}
strFileName = "";
throw ex;
}
finally
{
GC.Collect();
//GC.WaitForPendingFinalizers();
}
}
}