/// <summary>
/// 转成PDF
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ToPDFbtn_Click(object sender, EventArgs e)
{
try
{
//reportDataBind();
string ExportPath;
string Fname;
ExportPath = User.rootpath + "\\" + drawingno + "附页";
if (!Directory.Exists(ExportPath))
{
System.IO.Directory.CreateDirectory(ExportPath);
}
Fname = "Accessories";
CrystalDecisions.Shared.DiskFileDestinationOptions opts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
//导出为磁盘文件
CrystalDecisions.Shared.ExportOptions myExportOptiions = tpm.ExportOptions;
myExportOptiions.ExportDestinationOptions = opts;
myExportOptiions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
tpm.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
Fname = Fname + ".PDF";
opts.DiskFileName = ExportPath + "\\" + Fname;
tpm.Export();
MessageBox.Show("--------转换成功---------");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
return;
}
}
private void Btn_Excel_Click(object sender, EventArgs e)
{
SaveFileDialog Archivo = new SaveFileDialog();
if (Archivo.ShowDialog() == DialogResult.OK)
{
CrystalDecisions.Shared.ExportOptions Opt = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.Shared.ExcelFormatOptions Opt_Exc = new CrystalDecisions.Shared.ExcelFormatOptions();
CrystalDecisions.Shared.DiskFileDestinationOptions Opt_Dsk = new CrystalDecisions.Shared.DiskFileDestinationOptions();
Opt.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.Excel;
Opt.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
Opt_Exc.ExcelUseConstantColumnWidth = false;
Opt.ExportFormatOptions = Opt_Exc;
Opt_Dsk.DiskFileName = Archivo.FileName;
Opt.ExportDestinationOptions = Opt_Dsk;
Reporte.Export(Opt);
}
}
private void ExportPDF()
{
try
{
string exportPath;
string fileName;
exportPath = User.rootpath + "\\" + DrawingNo + "附页";
if (!Directory.Exists(exportPath))
{
System.IO.Directory.CreateDirectory(exportPath);
}
fileName = "TotalPipeMaterialCR.pdf";
CrystalDecisions.Shared.DiskFileDestinationOptions opts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
//导出为磁盘文件
CrystalDecisions.Shared.ExportOptions myExportOptions = cr.ExportOptions;
myExportOptions.DestinationOptions = opts;
myExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
//导出为pdf格式
cr.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
//目的路径
fileName = exportPath + "\\" + fileName;
opts.DiskFileName = fileName;
if (File.Exists(fileName))
File.Delete(fileName);
//导出操作
cr.Export();
MessageBox.Show("--------转换成功---------");
button1.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show("导出PDF时：" + ex.Message.ToString());
this.Close();
}
}
private void ExportPDF()
{
try
{
string exportPath;
string fileName;
exportPath = User.rootpath + "\\" + DrawingNo + "附页";
if (!Directory.Exists(exportPath))
{
System.IO.Directory.CreateDirectory(exportPath);
}
fileName = "TotalPipeMaterialCR.pdf";
CrystalDecisions.Shared.DiskFileDestinationOptions opts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
//导出为磁盘文件
CrystalDecisions.Shared.ExportOptions myExportOptions = cr.ExportOptions;
myExportOptions.DestinationOptions = opts;
myExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
//导出为pdf格式
cr.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
//目的路径
fileName = exportPath + "\\" + fileName;
opts.DiskFileName = fileName;
if (File.Exists(fileName))
{
File.Delete(fileName);
}
//导出操作
cr.Export();
MessageBox.Show("--------转换成功---------");
button1.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show("导出PDF时：" + ex.Message.ToString());
this.Close();
}
}
//private void EXPORTTOPDF(object sender, EventArgs e)
//{
// try
// {
// string exportPath;
// string fileName;
// exportPath = Application.StartupPath + "\\" + DrawingNo + "附页";
// if (!Directory.Exists(exportPath))
// {
// System.IO.Directory.CreateDirectory(exportPath);
// }
// fileName = "WeightBarycenterCR.pdf";
// CrystalDecisions.Shared.DiskFileDestinationOptions opts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
// //导出为磁盘文件
// CrystalDecisions.Shared.ExportOptions myExportOptions = cr.ExportOptions;
// myExportOptions.DestinationOptions = opts;
// myExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
// //导出为pdf格式
// cr.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
// //目的路径
// fileName = exportPath + "\\" + fileName;
// opts.DiskFileName = fileName;
// if (File.Exists(fileName))
// File.Delete(fileName);
// //导出操作
// cr.Export();
// MessageBox.Show("--------转换成功---------");
// }
// catch (Exception ex)
// {
// MessageBox.Show("导出PDF时：" + ex.Message.ToString());
// this.Close();
// }
//}
//private void ReplaceExportButton()
//{
// //遍历crystalReportViewer1控件里的控件
// foreach (object ctl in crystalReportViewer1.Controls)
// {
// string sControl = ctl.GetType().Name.ToString().ToLower();
// if (sControl == "toolstrip")
// {
// ToolStrip tab1 = (ToolStrip)ctl;
// for (int i = 0; i <= tab1.Items.Count - 1; i++)
// {
// if (tab1.Items[i].ToolTipText == "导出报表")
// {
// ToolStripButton tbutton = new ToolStripButton();
// Image img1 = tab1.Items[i].Image;
// tab1.Items.Remove(tab1.Items[i]);
// tbutton.Image = img1;
// tbutton.ToolTipText = "导出报表";
// tab1.Items.Insert(0, tbutton);
// tbutton.Click += new System.EventHandler(this.EXPORTTOPDF);
// break;
// }
// }
// }
// }
//}
private void button1_Click(object sender, EventArgs e)
{
try
{
string exportPath;
string fileName;
exportPath = Application.StartupPath + "\\" + DrawingNo + "附页";
if (!Directory.Exists(exportPath))
{
System.IO.Directory.CreateDirectory(exportPath);
}
fileName = "WeightBarycenterCR.pdf";
CrystalDecisions.Shared.DiskFileDestinationOptions opts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
//导出为磁盘文件
CrystalDecisions.Shared.ExportOptions myExportOptions = cr.ExportOptions;
myExportOptions.DestinationOptions = opts;
myExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
//导出为pdf格式
cr.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
//目的路径
fileName = exportPath + "\\" + fileName;
opts.DiskFileName = fileName;
if (File.Exists(fileName))
{
File.Delete(fileName);
}
//导出操作
cr.Export();
MessageBox.Show("--------转换成功---------");
}
catch (Exception ex)
{
MessageBox.Show("导出PDF时：" + ex.Message.ToString());
this.Close();
}
}
/// <summary>
/// 转成PDF
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ToPDFbtn_Click(object sender, EventArgs e)
{
try
{
//reportDataBind();
string ExportPath;
string Fname;
ExportPath = User.rootpath + "\\" + drawingno +"附页";
if (!Directory.Exists(ExportPath))
{
System.IO.Directory.CreateDirectory(ExportPath);
}
Fname = "Accessories";
CrystalDecisions.Shared.DiskFileDestinationOptions opts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
//导出为磁盘文件
CrystalDecisions.Shared.ExportOptions myExportOptiions = tpm.ExportOptions;
myExportOptiions.ExportDestinationOptions = opts;
myExportOptiions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
tpm.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
Fname = Fname + ".PDF";
opts.DiskFileName = ExportPath + "\\"+ Fname;
tpm.Export();
MessageBox.Show("--------转换成功---------");
}
catch(Exception ex)
{
MessageBox.Show(ex.Message.ToString());
return;
}
}
private void exportReport(CrystalDecisions.CrystalReports.Engine.ReportClass selectedReport, CrystalDecisions.Shared.ExportFormatType eft)
{
selectedReport.ExportOptions.ExportFormatType = eft;
string contentType = "";
// Make sure asp.net has create and delete permissions in the directory
string tempDir = System.Configuration.ConfigurationSettings.AppSettings["TempDir"];
string tempFileName = Session.SessionID.ToString() + ".";
switch (eft)
{
case CrystalDecisions.Shared.ExportFormatType.PortableDocFormat:
tempFileName += "pdf";
contentType = "application/pdf";
break;
case CrystalDecisions.Shared.ExportFormatType.WordForWindows:
tempFileName += "doc";
contentType = "application/msword";
break;
case CrystalDecisions.Shared.ExportFormatType.Excel:
tempFileName += "xls";
contentType = "application/vnd.ms-excel";
break;
case CrystalDecisions.Shared.ExportFormatType.HTML32:
case CrystalDecisions.Shared.ExportFormatType.HTML40:
tempFileName += "htm";
contentType = "text/html";
CrystalDecisions.Shared.HTMLFormatOptions hop = new CrystalDecisions.Shared.HTMLFormatOptions();
hop.HTMLBaseFolderName = tempDir;
hop.HTMLFileName = tempFileName;
selectedReport.ExportOptions.FormatOptions = hop;
break;
}
CrystalDecisions.Shared.DiskFileDestinationOptions dfo = new CrystalDecisions.Shared.DiskFileDestinationOptions();
dfo.DiskFileName = tempDir + tempFileName;
selectedReport.ExportOptions.DestinationOptions = dfo;
selectedReport.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
selectedReport.Export();
selectedReport.Close();
string tempFileNameUsed;
//if (eft == CrystalDecisions.Shared.ExportFormatType.HTML32 || eft == CrystalDecisions.Shared.ExportFormatType.HTML40)
//{
// string[] fp = selectedReport.FilePath.Split("\\".ToCharArray());
// string leafDir = fp[fp.Length - 1];
// // strip .rpt extension
// leafDir = leafDir.Substring(0, leafDir.Length–4);
// tempFileNameUsed = string.Format("{0}{1}\\{2}", tempDir, leafDir, tempFileName);
//}
//else
tempFileNameUsed = tempDir + tempFileName;
Response.ClearContent();
Response.ClearHeaders();
Response.ContentType = contentType;
Response.WriteFile(tempFileNameUsed);
Response.Flush();
Response.Close();
System.IO.File.Delete(tempFileNameUsed);
}
public byte[] RunReport(String reportName, String fileName, string travelRequestId)
{
byte[] response = null;
ConnectionInfo crConnectionInFo = new ConnectionInfo();
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo crTableLogonInfo = new TableLogOnInfo();
DiskFileDestinationOptions crDiskFileDestinationOptions = new CrystalDecisions.Shared.DiskFileDestinationOptions();
ExportOptions crExportOptions = new CrystalDecisions.Shared.ExportOptions();
CrystalDecisions.CrystalReports.Engine.ReportDocument dReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
String rptPath = System.Web.Hosting.HostingEnvironment.MapPath(System.Configuration.ConfigurationManager.AppSettings["rptPath"]);
String fName = fileName;
dReport.Load(rptPath + reportName);
dReport.SetParameterValue("p_travelrequestID", travelRequestId);
if (reportName == "Travel_Business_Expense.rpt")
{
dReport.SetParameterValue("p_travelrequestID", travelRequestId);
}
string defaultConnectionString = ConfigurationManager.ConnectionStrings["CrystalReport"].ConnectionString;
var builder = new DbConnectionStringBuilder();
builder.ConnectionString = defaultConnectionString;
crConnectionInFo.DatabaseName = "";
crConnectionInFo.ServerName = builder["SERVICE_NAME"].ToString();
crConnectionInFo.UserID = builder["User ID"].ToString();
crConnectionInFo.Password = builder["Password"].ToString();
crTables = dReport.Database.Tables;
crTableLogonInfo.ConnectionInfo = crConnectionInFo;
foreach (CrystalDecisions.CrystalReports.Engine.Table rTable in crTables)
{
rTable.ApplyLogOnInfo(crTableLogonInfo);
}
foreach (CrystalDecisions.CrystalReports.Engine.ReportDocument subrpt in dReport.Subreports)
{
foreach (CrystalDecisions.CrystalReports.Engine.Table rTable in subrpt.Database.Tables)
{
rTable.ApplyLogOnInfo(crTableLogonInfo);
}
}
try
{
var memoryStream = new MemoryStream();
var data = dReport.ExportToStream(ExportFormatType.PortableDocFormat);
data.CopyTo(memoryStream);
response = memoryStream.ToArray();
if (File.Exists(rptPath + "Exported/" + fileName + ".pdf"))
{
File.Delete(rptPath + "Exported/" + fileName + ".pdf");
}
FileStream file = new FileStream(rptPath + "Exported/" + fileName + ".pdf", FileMode.Create, FileAccess.ReadWrite);
memoryStream.WriteTo(file);
file.Close();
file.Dispose();
memoryStream.Close();
memoryStream.Dispose();
//File.WriteAllBytes(rptPath+"Exported/"+fileName+".pdf", response);
}
catch (Exception ex)
{
LogMessage.Log("Error generating crystal report : " + ex.Message);
throw new Exception(ex.Message);
}
finally
{
dReport.Close();
dReport.Dispose();
}
return(response);
}
public static string GenerateExport(CrystalDecisions.CrystalReports.Engine.ReportDocument selectedReport, CrystalDecisions.Shared.ExportFormatType eft, string ExportFileName)
{
selectedReport.ExportOptions.ExportFormatType = eft;
string contentType = "";
// Make sure asp.net has create and delete permissions in the directory
string tempDir = HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["tempDir"]);
string tempFileName = string.Concat(Path.GetFileNameWithoutExtension(selectedReport.FileName), ".");
if (! string.IsNullOrEmpty(ExportFileName))
{
tempFileName = string.Concat(ExportFileName, ".");
}
switch (eft)
{
case CrystalDecisions.Shared.ExportFormatType.PortableDocFormat:
tempFileName += "pdf";
break;
case CrystalDecisions.Shared.ExportFormatType.WordForWindows:
tempFileName += "doc";
break;
case CrystalDecisions.Shared.ExportFormatType.Excel:
tempFileName += "xls";
break;
case CrystalDecisions.Shared.ExportFormatType.HTML32:
case CrystalDecisions.Shared.ExportFormatType.HTML40:
tempFileName += "htm";
CrystalDecisions.Shared.HTMLFormatOptions hop = new CrystalDecisions.Shared.HTMLFormatOptions();
hop.HTMLBaseFolderName = tempDir;
hop.HTMLFileName = tempFileName;
selectedReport.ExportOptions.FormatOptions = hop;
break;
}
CrystalDecisions.Shared.DiskFileDestinationOptions dfo = new CrystalDecisions.Shared.DiskFileDestinationOptions();
dfo.DiskFileName = Path.Combine(tempDir, tempFileName);
selectedReport.ExportOptions.DestinationOptions = dfo;
selectedReport.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
selectedReport.Export();
selectedReport.Close();
string tempFileNameUsed;
if (eft == CrystalDecisions.Shared.ExportFormatType.HTML32 || eft == CrystalDecisions.Shared.ExportFormatType.HTML40)
{
string[] fp = selectedReport.FilePath.Split("\\" .ToCharArray());
string leafDir = fp[fp.Length - 1];
// strip .rpt extension
leafDir = leafDir.Substring(0, leafDir.Length - 4);
tempFileNameUsed = string.Format("{0}{1}\\{2}", tempDir, leafDir, tempFileName);
}
else
{
tempFileNameUsed = Path.Combine(tempDir, tempFileName);
}
return tempFileNameUsed;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//先处理下附件文件夹中的备案表，防止过大
DeleteSignedFile(Server.MapPath(Request.ApplicationPath + "/AttachStorage/"));
HeTongBeiAn_ND myReport = new HeTongBeiAn_ND();
string strSql = "";
string WatermarkImageUrl = Server.MapPath(Request.ApplicationPath + "/HTProject/Pages/Images/合同备案公章.gif");
//先初始化项目信息
//看看该公司所在的地区
CRS_BeiAn.Report.FileName = System.Configuration.ConfigurationManager.AppSettings["BeiAnPrint_ND"];
#region 人员
HeTongInfo ds = new HeTongInfo();
strSql = "select * from RG_XMAndRY RY where XMGuid='" + Request["RowGuid"] + "' order by substring(RY.ZhuanYeCode,1,4) asc,ddrole desc";
DataView dvRY = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
for (int i = 0; i < dvRY.Count; i++)
{
DataRow dr4;
dr4 = ds.Tables["RYOfXM"].NewRow();
dr4["ZiZhiText"] = dvRY[i]["ZiZhiText"].ToString();
dr4["ZhuanYeText"] = dvRY[i]["ZhuanYeText"].ToString();
dr4["RYName"] = dvRY[i]["RYName"].ToString();
dr4["IDNum"] = dvRY[i]["IDNum"];//Convert.ToDecimal(
dr4["ZhiCheng"] = DB_CM.GetCodeText_FromHash("职称", Convert.ToString(dvRY[i]["ZhiCheng"]));;
dr4["YinZhangNo"] = dvRY[i]["YinZhangNo"].ToString();
dr4["ZhuanYeSX"] = dvRY[i]["ZhuanYeSX"].ToString();
//处理下从事的专业，尽量缩小
string ZhuanYeCS = dvRY[i]["ZhuanYeCS"].ToString();
dr4["ZhuanYeCS"] = ZhuanYeCS;
dr4["GongLing"] = dvRY[i]["GongLing"];
dr4["DDRole"] = DB_CM.GetCodeText_FromHash("项目角色", Convert.ToString(dvRY[i]["DDRole"]));
dr4["OrNo"] = i + 1;
ds.Tables["RYOfXM"].Rows.Add(dr4);
}
myReport.SetDataSource(ds.Tables["RYOfXM"]);
#endregion
#region 参数
strSql = "select * from RG_XMBeiAn where RowGuid='" + Request["RowGuid"] + "'";
DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
string DWName = "";
string TJDate = "";
string XMName = "";
string XMAdd = "";
string ToTalMoney = "";
string GuiMoDJ = "";
string JSDWName = "";
string XMLXR_JS = "";
string LXDH_JS = "";
string XMLXR_KS = "";
string LXDH_KS = "";
string XMFZR = "";
string ZiZhiDJ = "";
string ZiZhiDJ_ZH = "";
string HeTongMoney = "";
string XMBH = "";
string STATUS = "";
//有效期
string YXQ = "";
if (dv.Count > 0)
{
STATUS = dv[0]["STATUS"].ToString();
strSql = "select EnterpriseName from RG_OUInfo where RowGuid='" + dv[0]["DWGuid"] + "'";
DWName = Epoint.MisBizLogic2.DB.ExecuteToString(strSql);
myReport.SetParameterValue("DWName", DWName);
if (dv[0]["TJDate"].ToString() != "")
{
TJDate = DateTime.Parse(dv[0]["TJDate"].ToString()).ToString("yyyy-MM-dd");
}
else
{
TJDate = "";
}
myReport.SetParameterValue("TJDate", TJDate);
XMName = dv[0]["XMName"].ToString();
myReport.SetParameterValue("XMName", XMName);
XMAdd = DB_CM.GetCodeText_FromHash("项目地点", Convert.ToString(dv[0]["XMAddress"]));
myReport.SetParameterValue("XMAddress", XMAdd);
ToTalMoney = dv[0]["ToTalMoney"] + "万元";
myReport.SetParameterValue("ToTalMoney", ToTalMoney);
ZiZhiDJ = dv[0]["ZiZhiDJ"].ToString();
ZiZhiDJ_ZH = dv[0]["ZiZhiBH"].ToString();
myReport.SetParameterValue("ZiZhiDJ", ZiZhiDJ);
//myReport.SetParameterValue("ZiZhiDJ_ZH", ZiZhiDJ_ZH);
HeTongMoney = dv[0]["HeTongMoney"] + "万元";
myReport.SetParameterValue("HeTongMoney", HeTongMoney);
GuiMoDJ = DB_CM.GetCodeText_FromHash("项目规模等级", Convert.ToString(dv[0]["GuiMoDJ"]));
myReport.SetParameterValue("GuiMoDJ", GuiMoDJ);
//JSDWName = dv[0]["JSDWName"].ToString();
//myReport.SetParameterValue("JSDWName", JSDWName);
//XMLXR_JS = dv[0]["XMLXR_JS"].ToString();
//myReport.SetParameterValue("XMLXR_JS", XMLXR_JS);
//LXDH_JS = dv[0]["LXDH_JS"].ToString();
//myReport.SetParameterValue("LXDH_JS", LXDH_JS);
XMLXR_KS = dv[0]["XMLXR_KS"].ToString();
myReport.SetParameterValue("XMLXR_KS", XMLXR_KS);
LXDH_KS = dv[0]["LXDH_KS"].ToString();//+ "/" + dv[0]["SJ_KS"].ToString()
myReport.SetParameterValue("LXDH_KS", LXDH_KS);
XMFZR = dv[0]["XMFZR"].ToString();
myReport.SetParameterValue("XMFZR", XMFZR);
XMBH = dv[0]["XMBH"].ToString();
//注意处理，如果没有的话，就把编号的前面取出来
XMBH = RG_DW.GetXMBH(dv[0]["RowGuid"], dv[0]["DWGuid"], dv[0]["XMAdd"], dv[0]["XMBH"], dv[0]["XMLB"]);
myReport.SetParameterValue("XMBH", XMBH);
//获取最后一次审核通过意见
if (dv[0]["Status"].ToString() == "90")
{
//myReport.SetParameterValue("SHOpinion", RG_DW.GetLastSHOpinion(Request["RowGuid"], ""));
if (dv[0]["TGDate"].ToString() != "")
{
//myReport.SetParameterValue("TGDate", DateTime.Parse(dv[0]["TGDate"].ToString()).ToString("yyyy年MM月dd日"));
DateTime dtPass = DateTime.Parse(dv[0]["TGDate"].ToString());
YXQ = "有效期至：" + dtPass.AddYears(2).ToString("yyyy年MM月dd日");
myReport.SetParameterValue("TGDate", dtPass.ToString("yyyy年MM月dd日") + "\n" + YXQ);
}
else
{
myReport.SetParameterValue("TGDate", " 年 月 日");
}
}
else
{
//myReport.SetParameterValue("SHOpinion", "");
myReport.SetParameterValue("TGDate", " 年 月 日");
}
//重点注意，要分地区加盖相应的公章，宜兴的就加盖宜兴，江阴的就加盖江阴公章
//判断是否是宜兴的或江阴的
if (dv[0]["XMAdd"].ToString() == "320281")//江阴
{
WatermarkImageUrl = Server.MapPath(Request.ApplicationPath + "/HTProject/Pages/Images/江阴合同备案公章.gif");
}
else if (dv[0]["XMAdd"].ToString() == "320282")//宜兴
{
WatermarkImageUrl = Server.MapPath(Request.ApplicationPath + "/HTProject/Pages/Images/宜兴合同备案公章.gif");
}
}
#endregion
CrystalDecisions.Shared.DiskFileDestinationOptions DiskOpts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
myReport.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
myReport.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
string thisTime = DateTime.Now.ToString("yyyyMMddHHmmssfff");
string fileName = thisTime + "XMBA.pdf";
DiskOpts.DiskFileName = Server.MapPath(Request.ApplicationPath + "/AttachStorage/" + fileName);
myReport.ExportOptions.DestinationOptions = DiskOpts;
myReport.Export();
//判断下状态，如果是已经审核通过了，那么就处理公章，否则直接加载
if (STATUS != "90")
{
if (this.LoginID == "admin")
{
string message = "";
string fileNewName = thisTime + "_2XMBA.pdf";
string fileNew = Request.ApplicationPath + "/AttachStorage/" + fileNewName;
WatermarkPDF(DiskOpts.DiskFileName, Server.MapPath(fileNew), WatermarkImageUrl, 400, 500, 115, 115, out message, dvRY.Count);
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileNewName + "'; </script> ");
}
else
{
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileName + "'; </script> ");
}
}
else
{
//string WatermarkImageUrl = Server.MapPath(Request.ApplicationPath + "/HTProject/Pages/Images/合同备案公章.gif");
string message = "";
string fileNewName = thisTime + "_2XMBA.pdf";
string fileNew = Request.ApplicationPath + "/AttachStorage/" + fileNewName;
WatermarkPDF(DiskOpts.DiskFileName, Server.MapPath(fileNew), WatermarkImageUrl, 400, 500, 115, 115, out message, dvRY.Count);
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileNewName + "'; </script> ");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//先处理下附件文件夹中的备案表，防止过大
DeleteSignedFile(Server.MapPath(Request.ApplicationPath + "/AttachStorage/"));
HeTongBeiAn myReport = new HeTongBeiAn();
string strSql = "";
//先初始化项目信息
//看看该公司所在的地区
CRS_BeiAn.Report.FileName = System.Configuration.ConfigurationManager.AppSettings["BeiAnPrint_SN"]; //Epoint.Frame.Common.ApplicationOperate.GetConfigValueByName("BeiAnPrint_SN", ""); ;
//CRS_BeiAn.Report.
#region 人员
HeTongInfo ds = new HeTongInfo();
strSql = "select * from RG_XMAndRY RY where XMGuid='" + Request["RowGuid"] + "' order by substring(RY.ZhuanYeCode,1,4) asc,RY.DDRole desc ";
DataView dvRY = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
int count = dvRY.Count;
for (int i = 0; i < dvRY.Count; i++)
{
DataRow dr4;
dr4 = ds.Tables["RYOfXM"].NewRow();
dr4["ZiZhiText"] = dvRY[i]["ZiZhiText"].ToString();
dr4["ZhuanYeText"] = dvRY[i]["ZhuanYeText"].ToString();
dr4["RYName"] = dvRY[i]["RYName"].ToString();
dr4["IDNum"] = dvRY[i]["IDNum"];//Convert.ToDecimal(
dr4["ZhiCheng"] = DB_CM.GetCodeText_FromHash("职称", Convert.ToString(dvRY[i]["ZhiCheng"])); ;
dr4["YinZhangNo"] = dvRY[i]["YinZhangNo"].ToString();
dr4["ZhuanYeSX"] = dvRY[i]["ZhuanYeSX"].ToString();
//处理下从事的专业，尽量缩小
string ZhuanYeCS = dvRY[i]["ZhuanYeCS"].ToString();
//string ZYCS = "";// RG_DW.GetItemTextByLen2("29b7967e-8098-42d5-8b40-ec757b0865a5", ZhuanYeCS, 4);
//string[] CS = ZhuanYeCS.Split(';');
//for (int m = 0; m < CS.Length; m++)
//{
// ZYCS += RG_DW.GetItemTextByLen2("29b7967e-8098-42d5-8b40-ec757b0865a5", CS[m], 4);
// ZYCS += ";";
//}
//if (ZYCS.Length > 0)
//{
// ZYCS = ZYCS.Substring(0, ZYCS.Length - 1);
//}
dr4["ZhuanYeCS"] = ZhuanYeCS;
dr4["GongLing"] = dvRY[i]["GongLing"];
dr4["DDRole"] = DB_CM.GetCodeText_FromHash("项目角色", Convert.ToString(dvRY[i]["DDRole"]));
dr4["OrNo"] = i + 1;
ds.Tables["RYOfXM"].Rows.Add(dr4);
}
//for (int m = 19; m > dvRY.Count; m--)
//{
// DataRow dr4;
// dr4 = ds.Tables["RYOfXM"].NewRow();
// dr4["ZiZhiText"] = "";
// dr4["ZhuanYeText"] = "";
// dr4["RYName"] = "";
// dr4["IDNum"] = "";//Convert.ToDecimal(
// dr4["ZhiCheng"] = ""; ;
// dr4["YinZhangNo"] = "";
// dr4["ZhuanYeSX"] = "";
// dr4["ZhuanYeCS"] = "";
// dr4["GongLing"] = "";
// dr4["DDRole"] = "";
// dr4["OrNo"] = dvRY.Count + 19 - m;
// ds.Tables["RYOfXM"].Rows.Add(dr4);
//}
//HeTongBeiAn oCR = new HeTongBeiAn();
myReport.SetDataSource(ds.Tables["RYOfXM"]);
#endregion
#region 参数
strSql = "select * from RG_XMBeiAn where RowGuid='" + Request["RowGuid"] + "' ";
DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
string DWName = "";
string TJDate = "";
string XMName = "";
string XMAdd = "";
string ToTalMoney = "";
string GuiMoDJ = "";
string JSDWName = "";
string XMLXR_JS = "";
string LXDH_JS = "";
string XMLXR_KS = "";
string LXDH_KS = "";
string XMFZR = "";
string ZiZhiDJ = "";
string ZiZhiDJ_ZH = "";
string HeTongMoney = "";
string XMBH = "";
string STATUS = "";
if (dv.Count > 0)
{
STATUS = dv[0]["STATUS"].ToString();
strSql = "select EnterpriseName from RG_OUInfo where RowGuid='" + dv[0]["DWGuid"] + "'";
DWName = Epoint.MisBizLogic2.DB.ExecuteToString(strSql);
myReport.SetParameterValue("DWName", DWName);
if (dv[0]["TJDate"].ToString() != "")
{
TJDate = DateTime.Parse(dv[0]["TJDate"].ToString()).ToString("yyyy-MM-dd");
}
else
{
TJDate = "";
}
myReport.SetParameterValue("TJDate", TJDate);
XMName = dv[0]["XMName"].ToString();
myReport.SetParameterValue("XMName", XMName);
XMAdd = DB_CM.GetCodeText_FromHash("项目地点", Convert.ToString(dv[0]["XMAddress"]));
myReport.SetParameterValue("XMAddress", XMAdd);
ToTalMoney = dv[0]["ToTalMoney"] + "万元";
myReport.SetParameterValue("ToTalMoney", ToTalMoney);
ZiZhiDJ = dv[0]["ZiZhiDJ"].ToString();
ZiZhiDJ_ZH = dv[0]["ZiZhiBH"].ToString();
myReport.SetParameterValue("ZiZhiDJ", ZiZhiDJ);
myReport.SetParameterValue("ZiZhiDJ_ZH", ZiZhiDJ_ZH);
HeTongMoney = dv[0]["HeTongMoney"] + "万元";
myReport.SetParameterValue("HeTongMoney", HeTongMoney);
GuiMoDJ = DB_CM.GetCodeText_FromHash("项目规模等级", Convert.ToString(dv[0]["GuiMoDJ"]));
myReport.SetParameterValue("GuiMoDJ", GuiMoDJ);
JSDWName = dv[0]["JSDWName"].ToString();
myReport.SetParameterValue("JSDWName", JSDWName);
XMLXR_JS = dv[0]["XMLXR_JS"].ToString();
myReport.SetParameterValue("XMLXR_JS", XMLXR_JS);
LXDH_JS = dv[0]["LXDH_JS"].ToString();
myReport.SetParameterValue("LXDH_JS", LXDH_JS);
XMLXR_KS = dv[0]["XMLXR_KS"].ToString();
myReport.SetParameterValue("XMLXR_KS", XMLXR_KS);
LXDH_KS = dv[0]["LXDH_KS"].ToString();//+ "/" + dv[0]["SJ_KS"].ToString()
myReport.SetParameterValue("LXDH_KS", LXDH_KS);
XMFZR = dv[0]["XMFZR"].ToString();
myReport.SetParameterValue("XMFZR", XMFZR);
XMBH = dv[0]["XMBH"].ToString();
//注意处理，如果没有的话，就把编号的前面取出来
XMBH = RG_DW.GetXMBH(dv[0]["RowGuid"], dv[0]["DWGuid"], dv[0]["XMAdd"], dv[0]["XMBH"], dv[0]["XMLB"]);
myReport.SetParameterValue("XMBH", XMBH);
//有效期
string YXQ = "";
//获取最后一次审核通过意见
if (dv[0]["Status"].ToString() == "90")
{
myReport.SetParameterValue("SHOpinion", RG_DW.GetLastSHOpinion(Request["RowGuid"], ""));
if (dv[0]["TGDate"].ToString() != "")
{
DateTime dtPass = DateTime.Parse(dv[0]["TGDate"].ToString());
YXQ = "有效期至：" + dtPass.AddYears(2).ToString("yyyy年MM月dd日");
myReport.SetParameterValue("TGDate", dtPass.ToString("yyyy年MM月dd日") + "\n" + YXQ);
}
else
{
myReport.SetParameterValue("TGDate", " 年 月 日");
}
}
else
{
myReport.SetParameterValue("SHOpinion", "");
myReport.SetParameterValue("TGDate", " 年 月 日");
}
//myReport.SetParameterValue("YXQ", YXQ);
}
#endregion
CrystalDecisions.Shared.DiskFileDestinationOptions DiskOpts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
myReport.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
myReport.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
string thisTime = DateTime.Now.ToString("yyyyMMddHHmmssfff");
string fileName = thisTime + "XMBA.pdf";
DiskOpts.DiskFileName = Server.MapPath(Request.ApplicationPath + "/AttachStorage/" + fileName);
myReport.ExportOptions.DestinationOptions = DiskOpts;
myReport.Export();
//判断下状态，如果是已经审核通过了，那么就处理公章，否则直接加载
if (STATUS != "90")
{
if (this.LoginID == "admin")
{
string WatermarkImageUrl = Server.MapPath(Request.ApplicationPath + "/HTProject/Pages/Images/合同备案公章.gif");
string message = "";
string fileNewName = thisTime + "_2XMBA.pdf";
string fileNew = Request.ApplicationPath + "/AttachStorage/" + fileNewName;
WatermarkPDF(DiskOpts.DiskFileName, Server.MapPath(fileNew), WatermarkImageUrl, 400, 500, 115, 115, out message, dvRY.Count);
//Response.Write("<script language=javascript> window.location.href = '../../../AttachStorage/" + fileNewName + "'; </script> ");
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileNewName + "'; </script> ");
//Response.Redirect(fileNew);
}
else
{
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileName + "'; </script> ");
}
}
else
{
string WatermarkImageUrl = Server.MapPath(Request.ApplicationPath + "/HTProject/Pages/Images/合同备案公章.gif");
string message = "";
string fileNewName = thisTime + "_2XMBA.pdf";
string fileNew = Request.ApplicationPath + "/AttachStorage/" + fileNewName;
WatermarkPDF(DiskOpts.DiskFileName, Server.MapPath(fileNew), WatermarkImageUrl, 400, 500, 115, 115, out message, dvRY.Count);
//Response.Write("<script language=javascript> window.location.href = '../../../AttachStorage/" + fileNewName + "'; </script> ");
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileNewName + "'; </script> ");
//Response.Redirect(fileNew);
}
}
}
/// <summary>
/// Genera el reporte
/// </summary>
/// <param name="reportPath">Ruta del reporte</param>
/// <param name="outputPath">Regresa el reporte</param>
/// <param name="fechaInicial">Valor fecha inicial</param>
/// <param name="fechaFinal">Valor fecha final</param>
/// <param name="oficinaVentas">Código de la oficina</param>
/// <param name="Usuario">Código del usuario</param>
/// <param name="_Company">Objeto de SAP</param>
/// <param name="msgError">Mensaje de error</param>
/// <returns>true/false</returns>
public bool RunReport(string reportPath, string outputPath, DateTime fechaInicial, DateTime fechaFinal, string oficinaVentas, SAPbobsCOM.Company _Company, ref string msgError)
{
msgError = string.Empty;
if (System.IO.File.Exists(outputPath))
{
try
{
System.IO.File.Delete(outputPath);
}
catch (Exception ex)
{
throw new Exception("No se pudo reemplazar el archivo " + System.IO.Path.GetFileName(outputPath) + ", revise que no se esté ejecutando.");
}
}
try
{
rpt = new ReportDocument();
loginfo = new CrystalDecisions.Shared.ConnectionInfo();
loginfo.ServerName = _Company.Server;
loginfo.DatabaseName = _Company.CompanyDB;
loginfo.UserID = _Company.DbUserName;
loginfo.Password = Extensor.Configuracion.PBD.PBD; //ConfigurationManager.AppSettings["PBD"].ToString();
rpt.Load(reportPath);
Actualiza(ref rpt, loginfo);
rpt.SetParameterValue("@FechaInicial", fechaInicial);
rpt.SetParameterValue("@FechaFinal", fechaFinal);
rpt.SetParameterValue("@AlmacenOficina", oficinaVentas);
//rpt.SetParameterValue("@Usuario", Usuario);
CrystalDecisions.Shared.DiskFileDestinationOptions filedest = new CrystalDecisions.Shared.DiskFileDestinationOptions();
CrystalDecisions.Shared.ExportOptions o = default(CrystalDecisions.Shared.ExportOptions);
o = new CrystalDecisions.Shared.ExportOptions();
ExportOptions opt = new ExportOptions();
opt = rpt.ExportOptions;
o.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
o.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
filedest.DiskFileName = outputPath;
o.ExportDestinationOptions = (ExportDestinationOptions)filedest.Clone();
rpt.Export(o);
o = null;
filedest = null;
rpt.Dispose();
rpt.Close();
opt = null;
rpt = null;
return(true);
}
catch (Exception ex)
{
msgError = "No se creó el archivo: " + ex.Message + Environment.NewLine +
"Detalles: " + ex.InnerException.Message;
return(false);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//先处理下附件文件夹中的备案表，防止过大
DeleteSignedFile(Server.MapPath(Request.ApplicationPath + "/AttachStorage/"));
HeTongBeiAn_WS myReport = new HeTongBeiAn_WS();
string strSql = "";
//先初始化项目信息
//看看该公司所在的地区
CRS_BeiAn.Report.FileName = System.Configuration.ConfigurationManager.AppSettings["BeiAnPrint_SW"];// Epoint.Frame.Common.ApplicationOperate.GetConfigValueByName("BeiAnPrint_SW", ""); ;
//CRS_BeiAn.Report.
#region
HeTongInfo ds = new HeTongInfo();
strSql = "select * from RG_XMAndRY RY where XMGuid='" + Request["RowGuid"] + "' order by substring(RY.ZhuanYeCode,1,4) asc,ddrole desc";
DataView dvRY = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
for (int i = 0; i < dvRY.Count; i++)
{
DataRow dr4;
dr4 = ds.Tables["RYOfXM"].NewRow();
dr4["ZiZhiText"] = dvRY[i]["ZiZhiText"].ToString();
dr4["ZhuanYeText"] = dvRY[i]["ZhuanYeText"].ToString();
dr4["RYName"] = dvRY[i]["RYName"].ToString();
dr4["IDNum"] = dvRY[i]["IDNum"];//Convert.ToDecimal(
dr4["ZhiCheng"] = DB_CM.GetCodeText_FromHash("职称", Convert.ToString(dvRY[i]["ZhiCheng"]));;
dr4["YinZhangNo"] = dvRY[i]["YinZhangNo"].ToString();
dr4["ZhuanYeSX"] = dvRY[i]["ZhuanYeSX"].ToString();
//处理下从事的专业，尽量缩小
string ZhuanYeCS = dvRY[i]["ZhuanYeCS"].ToString();
dr4["ZhuanYeCS"] = ZhuanYeCS;
dr4["GongLing"] = dvRY[i]["GongLing"];
dr4["DDRole"] = DB_CM.GetCodeText_FromHash("项目角色", Convert.ToString(dvRY[i]["DDRole"]));
dr4["OrNo"] = i + 1;
ds.Tables["RYOfXM"].Rows.Add(dr4);
}
//HeTongBeiAn oCR = new HeTongBeiAn();
myReport.SetDataSource(ds.Tables["RYOfXM"]);
#endregion
#region 参数
strSql = "select * from RG_XMBeiAn where RowGuid='" + Request["RowGuid"] + "'";
DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
string XMAdd = "";
string XMBH = "";
string STATUS = "";
if (dv.Count > 0)
{
strSql = "select * from RG_OUInfo where RowGuid='" + dv[0]["DWGuid"] + "'";
DataView dvDW = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
if (dvDW.Count > 0)
{
STATUS = dv[0]["STATUS"].ToString();
myReport.SetParameterValue("DWName", dvDW[0]["EnterpriseName"]);
myReport.SetParameterValue("DWAddress", dvDW[0]["ZhuCeDi_XX"].ToString());
myReport.SetParameterValue("DWYB", dvDW[0]["YouZhengCode"].ToString());
myReport.SetParameterValue("DWXZ", dvDW[0]["DanWeiXZ"].ToString());
myReport.SetParameterValue("DWFR", dvDW[0]["FaRen"].ToString());
myReport.SetParameterValue("DWDH", dvDW[0]["DanWeiTel"].ToString());
myReport.SetParameterValue("DWLXR", dvDW[0]["LianXiRen"].ToString());
myReport.SetParameterValue("DWLXRDH", dvDW[0]["LianXiRenTel"].ToString());
string tb = dv[0]["TJDate"].ToString() == "" ? dv[0]["OperateDate"].ToString() : dv[0]["TJDate"].ToString();
myReport.SetParameterValue("TBDate", DateTime.Parse(tb).ToString("yyyy-MM-dd"));
myReport.SetParameterValue("FuZaCD", dv[0]["FuZaCD"].ToString());
myReport.SetParameterValue("YeWuFW", dv[0]["YeWuFW"].ToString());
}
else
{
myReport.SetParameterValue("DWName", "");
myReport.SetParameterValue("DWAddress", "");
myReport.SetParameterValue("DWYB", "");
myReport.SetParameterValue("DWXZ", "");
myReport.SetParameterValue("DWFR", "");
myReport.SetParameterValue("DWDH", "");
myReport.SetParameterValue("DWLXR", "");
myReport.SetParameterValue("DWLXRDH", "");
}
//注意处理，如果没有的话，就把编号的前面取出来
XMBH = RG_DW.GetXMBH(dv[0]["RowGuid"], dv[0]["DWGuid"], dv[0]["XMAdd"], dv[0]["XMBH"], dv[0]["XMLB"]);
myReport.SetParameterValue("XMBH", XMBH);
XMAdd = dv[0]["XMAdd"].ToString();
//加区县通过时间和市建设局通过时间
//看看有没有市的通过时间，如果有就加在后面，否则加在区县的后面
string YXQ = "";
if (dv[0]["TGDate"].ToString() == "")
{
if (dv[0]["QXTG_Date"].ToString() != "")
{
DateTime dtPass = DateTime.Parse(dv[0]["QXTG_Date"].ToString());
string qxTGDate = dtPass.ToString("yyyy 年 MM 月 dd 日 ");
YXQ = "有效期至：" + dtPass.AddYears(2).ToString("yyyy年MM月dd日");
myReport.SetParameterValue("QXTGDate", qxTGDate + "\n" + YXQ);
}
else
{
string qxTGDate = " 年 月 日 ";
myReport.SetParameterValue("QXTGDate", qxTGDate);
}
myReport.SetParameterValue("TGDate", " 年 月 日 ");
}
else
{
if (dv[0]["QXTG_Date"].ToString() != "")
{
myReport.SetParameterValue("QXTGDate", DateTime.Parse(dv[0]["QXTG_Date"].ToString()).ToString("yyyy年MM月dd日"));
}
else
{
myReport.SetParameterValue("QXTGDate", " 年 月 日 ");
}
DateTime dtPass = DateTime.Parse(dv[0]["TGDate"].ToString());
string TGDate = dtPass.ToString("yyyy年MM月dd日");
YXQ = "有效期至：" + dtPass.AddYears(2).ToString("yyyy年MM月dd日");
myReport.SetParameterValue("TGDate", TGDate + "\n" + YXQ);
}
}
#endregion
CrystalDecisions.Shared.DiskFileDestinationOptions DiskOpts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
myReport.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
myReport.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
string timeNow = DateTime.Now.ToString("yyyyMMddHHmmssfff");
string fileName = timeNow + "XMBA.pdf";
DiskOpts.DiskFileName = Server.MapPath(Request.ApplicationPath + "/AttachStorage/" + fileName);
myReport.ExportOptions.DestinationOptions = DiskOpts;
myReport.Export();
//判断下状态，如果是已经审核通过了，那么就处理公章，否则直接加载
if (STATUS != "90")
{
if (this.LoginID == "admin")
{
string WatermarkImageUrl = Server.MapPath(Request.ApplicationPath + "/HTProject/Pages/Images/合同备案公章.gif");
string message = "";
string fileNewName = timeNow + "_2XMBA.pdf";
string fileNew = Request.ApplicationPath + "/AttachStorage/" + fileNewName;
WatermarkPDF(DiskOpts.DiskFileName, Server.MapPath(fileNew), WatermarkImageUrl, 568, 500, 115, 115, out message, XMAdd);
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileNewName + "'; </script> ");
}
else
{
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileName + "'; </script> ");
}
}
else
{
string WatermarkImageUrl = Server.MapPath(Request.ApplicationPath + "/HTProject/Pages/Images/合同备案公章.gif");
string message = "";
string fileNewName = timeNow + "_2XMBA.pdf";
string fileNew = Request.ApplicationPath + "/AttachStorage/" + fileNewName;
WatermarkPDF(DiskOpts.DiskFileName, Server.MapPath(fileNew), WatermarkImageUrl, 568, 500, 115, 115, out message, XMAdd);
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileNewName + "'; </script> ");
}
}
}
//private void EXPORTTOPDF(object sender, EventArgs e)
//{
// try
// {
// string exportPath;
// string fileName;
// exportPath = Application.StartupPath + "\\" + DrawingNo + "附页";
// if (!Directory.Exists(exportPath))
// {
// System.IO.Directory.CreateDirectory(exportPath);
// }
// fileName = "WeightBarycenterCR.pdf";
// CrystalDecisions.Shared.DiskFileDestinationOptions opts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
// //导出为磁盘文件
// CrystalDecisions.Shared.ExportOptions myExportOptions = cr.ExportOptions;
// myExportOptions.DestinationOptions = opts;
// myExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
// //导出为pdf格式
// cr.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
// //目的路径
// fileName = exportPath + "\\" + fileName;
// opts.DiskFileName = fileName;
// if (File.Exists(fileName))
// File.Delete(fileName);
// //导出操作
// cr.Export();
// MessageBox.Show("--------转换成功---------");
// }
// catch (Exception ex)
// {
// MessageBox.Show("导出PDF时：" + ex.Message.ToString());
// this.Close();
// }
//}
//private void ReplaceExportButton()
//{
// //遍历crystalReportViewer1控件里的控件
// foreach (object ctl in crystalReportViewer1.Controls)
// {
// string sControl = ctl.GetType().Name.ToString().ToLower();
// if (sControl == "toolstrip")
// {
// ToolStrip tab1 = (ToolStrip)ctl;
// for (int i = 0; i <= tab1.Items.Count - 1; i++)
// {
// if (tab1.Items[i].ToolTipText == "导出报表")
// {
// ToolStripButton tbutton = new ToolStripButton();
// Image img1 = tab1.Items[i].Image;
// tab1.Items.Remove(tab1.Items[i]);
// tbutton.Image = img1;
// tbutton.ToolTipText = "导出报表";
// tab1.Items.Insert(0, tbutton);
// tbutton.Click += new System.EventHandler(this.EXPORTTOPDF);
// break;
// }
// }
// }
// }
//}
private void button1_Click(object sender, EventArgs e)
{
try
{
string exportPath;
string fileName;
exportPath = Application.StartupPath + "\\" + DrawingNo + "附页";
if (!Directory.Exists(exportPath))
{
System.IO.Directory.CreateDirectory(exportPath);
}
fileName = "WeightBarycenterCR.pdf";
CrystalDecisions.Shared.DiskFileDestinationOptions opts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
//导出为磁盘文件
CrystalDecisions.Shared.ExportOptions myExportOptions = cr.ExportOptions;
myExportOptions.DestinationOptions = opts;
myExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
//导出为pdf格式
cr.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
//目的路径
fileName = exportPath + "\\" + fileName;
opts.DiskFileName = fileName;
if (File.Exists(fileName))
File.Delete(fileName);
//导出操作
cr.Export();
MessageBox.Show("--------转换成功---------");
}
catch (Exception ex)
{
MessageBox.Show("导出PDF时：" + ex.Message.ToString());
this.Close();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//先处理下附件文件夹中的备案表，防止过大
DeleteSignedFile(Server.MapPath(Request.ApplicationPath + "/AttachStorage/"));
HeTongBeiAn_WS myReport = new HeTongBeiAn_WS();
string strSql = "";
//先初始化项目信息
//看看该公司所在的地区
CRS_BeiAn.Report.FileName = System.Configuration.ConfigurationManager.AppSettings["BeiAnPrint_SW"];// Epoint.Frame.Common.ApplicationOperate.GetConfigValueByName("BeiAnPrint_SW", ""); ;
//CRS_BeiAn.Report.
#region
HeTongInfo ds = new HeTongInfo();
strSql = "select * from RG_XMAndRY RY where XMGuid='" + Request["RowGuid"] + "' order by substring(RY.ZhuanYeCode,1,4) asc,ddrole desc";
DataView dvRY = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
for (int i = 0; i < dvRY.Count; i++)
{
DataRow dr4;
dr4 = ds.Tables["RYOfXM"].NewRow();
dr4["ZiZhiText"] = dvRY[i]["ZiZhiText"].ToString();
dr4["ZhuanYeText"] = dvRY[i]["ZhuanYeText"].ToString();
dr4["RYName"] = dvRY[i]["RYName"].ToString();
dr4["IDNum"] = dvRY[i]["IDNum"];//Convert.ToDecimal(
dr4["ZhiCheng"] = DB_CM.GetCodeText_FromHash("职称", Convert.ToString(dvRY[i]["ZhiCheng"])); ;
dr4["YinZhangNo"] = dvRY[i]["YinZhangNo"].ToString();
dr4["ZhuanYeSX"] = dvRY[i]["ZhuanYeSX"].ToString();
//处理下从事的专业，尽量缩小
string ZhuanYeCS = dvRY[i]["ZhuanYeCS"].ToString();
dr4["ZhuanYeCS"] = ZhuanYeCS;
dr4["GongLing"] = dvRY[i]["GongLing"];
dr4["DDRole"] = DB_CM.GetCodeText_FromHash("项目角色", Convert.ToString(dvRY[i]["DDRole"]));
dr4["OrNo"] = i + 1;
ds.Tables["RYOfXM"].Rows.Add(dr4);
}
//HeTongBeiAn oCR = new HeTongBeiAn();
myReport.SetDataSource(ds.Tables["RYOfXM"]);
#endregion
#region 参数
strSql = "select * from RG_XMBeiAn where RowGuid='" + Request["RowGuid"] + "'";
DataView dv = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
string XMAdd = "";
string XMBH = "";
string STATUS = "";
if (dv.Count > 0)
{
strSql = "select * from RG_OUInfo where RowGuid='" + dv[0]["DWGuid"] + "'";
DataView dvDW = Epoint.MisBizLogic2.DB.ExecuteDataView(strSql);
if (dvDW.Count > 0)
{
STATUS = dv[0]["STATUS"].ToString();
myReport.SetParameterValue("DWName", dvDW[0]["EnterpriseName"]);
myReport.SetParameterValue("DWAddress", dvDW[0]["ZhuCeDi_XX"].ToString());
myReport.SetParameterValue("DWYB", dvDW[0]["YouZhengCode"].ToString());
myReport.SetParameterValue("DWXZ", dvDW[0]["DanWeiXZ"].ToString());
myReport.SetParameterValue("DWFR", dvDW[0]["FaRen"].ToString());
myReport.SetParameterValue("DWDH", dvDW[0]["DanWeiTel"].ToString());
myReport.SetParameterValue("DWLXR", dvDW[0]["LianXiRen"].ToString());
myReport.SetParameterValue("DWLXRDH", dvDW[0]["LianXiRenTel"].ToString());
string tb = dv[0]["TJDate"].ToString() == "" ? dv[0]["OperateDate"].ToString() : dv[0]["TJDate"].ToString();
myReport.SetParameterValue("TBDate", DateTime.Parse(tb).ToString("yyyy-MM-dd"));
myReport.SetParameterValue("FuZaCD", dv[0]["FuZaCD"].ToString());
myReport.SetParameterValue("YeWuFW", dv[0]["YeWuFW"].ToString());
}
else
{
myReport.SetParameterValue("DWName", "");
myReport.SetParameterValue("DWAddress", "");
myReport.SetParameterValue("DWYB", "");
myReport.SetParameterValue("DWXZ", "");
myReport.SetParameterValue("DWFR", "");
myReport.SetParameterValue("DWDH", "");
myReport.SetParameterValue("DWLXR", "");
myReport.SetParameterValue("DWLXRDH", "");
}
//注意处理，如果没有的话，就把编号的前面取出来
XMBH = RG_DW.GetXMBH(dv[0]["RowGuid"], dv[0]["DWGuid"], dv[0]["XMAdd"], dv[0]["XMBH"], dv[0]["XMLB"]);
myReport.SetParameterValue("XMBH", XMBH);
XMAdd = dv[0]["XMAdd"].ToString();
//加区县通过时间和市建设局通过时间
//看看有没有市的通过时间，如果有就加在后面，否则加在区县的后面
string YXQ = "";
if (dv[0]["TGDate"].ToString() == "")
{
if (dv[0]["QXTG_Date"].ToString() != "")
{
DateTime dtPass = DateTime.Parse(dv[0]["QXTG_Date"].ToString());
string qxTGDate = dtPass.ToString("yyyy 年 MM 月 dd 日 ");
YXQ = "有效期至：" + dtPass.AddYears(2).ToString("yyyy年MM月dd日");
myReport.SetParameterValue("QXTGDate", qxTGDate + "\n" + YXQ);
}
else
{
string qxTGDate = " 年 月 日 ";
myReport.SetParameterValue("QXTGDate", qxTGDate);
}
myReport.SetParameterValue("TGDate", " 年 月 日 ");
}
else
{
if (dv[0]["QXTG_Date"].ToString() != "")
{
myReport.SetParameterValue("QXTGDate", DateTime.Parse(dv[0]["QXTG_Date"].ToString()).ToString("yyyy年MM月dd日"));
}
else
{
myReport.SetParameterValue("QXTGDate", " 年 月 日 ");
}
DateTime dtPass = DateTime.Parse(dv[0]["TGDate"].ToString());
string TGDate = dtPass.ToString("yyyy年MM月dd日");
YXQ = "有效期至：" + dtPass.AddYears(2).ToString("yyyy年MM月dd日");
myReport.SetParameterValue("TGDate", TGDate + "\n" + YXQ);
}
}
#endregion
CrystalDecisions.Shared.DiskFileDestinationOptions DiskOpts = new CrystalDecisions.Shared.DiskFileDestinationOptions();
myReport.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
myReport.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
string timeNow = DateTime.Now.ToString("yyyyMMddHHmmssfff");
string fileName = timeNow + "XMBA.pdf";
DiskOpts.DiskFileName = Server.MapPath(Request.ApplicationPath + "/AttachStorage/" + fileName);
myReport.ExportOptions.DestinationOptions = DiskOpts;
myReport.Export();
//判断下状态，如果是已经审核通过了，那么就处理公章，否则直接加载
if (STATUS != "90")
{
if (this.LoginID == "admin")
{
string WatermarkImageUrl = Server.MapPath(Request.ApplicationPath + "/HTProject/Pages/Images/合同备案公章.gif");
string message = "";
string fileNewName = timeNow + "_2XMBA.pdf";
string fileNew = Request.ApplicationPath + "/AttachStorage/" + fileNewName;
WatermarkPDF(DiskOpts.DiskFileName, Server.MapPath(fileNew), WatermarkImageUrl, 568, 500, 115, 115, out message, XMAdd);
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileNewName + "'; </script> ");
}
else
{
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileName + "'; </script> ");
}
}
else
{
string WatermarkImageUrl = Server.MapPath(Request.ApplicationPath + "/HTProject/Pages/Images/合同备案公章.gif");
string message = "";
string fileNewName = timeNow + "_2XMBA.pdf";
string fileNew = Request.ApplicationPath + "/AttachStorage/" + fileNewName;
WatermarkPDF(DiskOpts.DiskFileName, Server.MapPath(fileNew), WatermarkImageUrl, 568, 500, 115, 115, out message, XMAdd);
Response.Write("<script language=javascript> window.location.href = 'pdfReader.aspx?fileName=" + fileNewName + "'; </script> ");
}
}
}