/// <summary>
/// 產生PDF檔案
/// </summary>
private void RrintToPDF()
{
// 匯出檔名的設定
string sReportFileName = @"\rpt\T022_rpt.rpt";
string sMapPath = Server.MapPath("");
string sHost = Request.Url.Host;
string sApplicationPath = Request.ApplicationPath;
string reportID = DBCenter.GetSystemID();
string sExportFileName = Server.MapPath("../../") + @"PDF\T022_rpt" + reportID + ".pdf";
string strPath = sMapPath + sReportFileName;
string ReportPath = "http://" + sHost + sApplicationPath + "/PDF/T022_rpt" + reportID + ".pdf";
DataSet dsLot = (DataSet)Session["T022View"];
rptdoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptdoc.Load(strPath);
rptdoc.SetDataSource(dsLot);
// 設定匯出路徑及檔名
DiskFileDestinationOptions df = new DiskFileDestinationOptions();
df.DiskFileName = sExportFileName;
rptdoc.ExportOptions.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
rptdoc.ExportOptions.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
rptdoc.ExportOptions.DestinationOptions = df;
rptdoc.Export();
rptdoc.Dispose();
//打開文件
Response.Write("<script>window.open('" + ReportPath + "','_blank','resizable,scrollbars=no,menubar=no,toolbar=no,location=no,status=no',false);</script> ");
Response.Write("<script>window.close();</script>");
}
protected void btn_Export_Click(object sender, EventArgs e)
{
try
{
RoutewisePaymentAbstract();
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
DateTime frmdate = DateTime.ParseExact(txt_FromDate.Text, "dd/MM/yyyy", null);
string fdate = frmdate.ToString("dd" + "_" + "MM" + "_" + "yyyy");
DateTime todate = DateTime.ParseExact(txt_ToDate.Text, "dd/MM/yyyy", null);
string tdate = todate.ToString("dd" + "_" + "MM" + "_" + "yyyy");
string CurrentCreateFolderName = fdate + "_" + tdate + "_" + DateTime.Now.ToString("ddMMyyyy");
string path = @"C:\BILL VYSHNAVI\" + ccode + "_" + "_" + pcode + CurrentCreateFolderName + "\\";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
CrDiskFileDestinationOptions.DiskFileName = path + ccode + "_" + pcode + "_" + "RoutewiseAbstract.pdf";
CrExportOptions = cr.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
cr.Export();
WebMsgBox.Show("Report Export Successfully...");
string MFileName = @"C:/BILL VYSHNAVI/" + ccode + "_" + "_" + pcode + CurrentCreateFolderName + "/" + ccode + "_" + pcode + "_" + "RoutewiseAbstract.pdf";
System.IO.FileInfo file = new System.IO.FileInfo(MFileName);
if (File.Exists(MFileName.ToString()))
{
FileStream sourceFile = new FileStream(file.FullName, FileMode.Open);
float FileSize;
FileSize = sourceFile.Length;
byte[] getContent = new byte[(int)FileSize];
sourceFile.Read(getContent, 0, (int)sourceFile.Length);
sourceFile.Close();
Response.ClearContent(); // neded to clear previous (if any) written content
Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name);
Response.AddHeader("Content-Length", file.Length.ToString());
Response.ContentType = "text/plain";
Response.BinaryWrite(getContent);
File.Delete(file.FullName.ToString());
Response.Flush();
Response.End();
}
else
{
Response.Write("File Not Found...");
}
}
catch (Exception ex)
{
WebMsgBox.Show("Please Check the ExportPath...");
}
}
public void RPT_Sub(Int64 QuotationID, string Code, Boolean _IsList)
{
DataTable dt = new DataTable();
LogoBind(dt);
mpdfFile = CurrentUser.DocumentPath + @"pdf\Quotation.pdf";
DataTable dtReport = new DataTable();
dtReport = CommSelect.SelectRecord(QuotationID, "rpt_Quotation", "Quotation - Report");
DataTable dtTNC = new DataTable();
NameValueCollection para = new NameValueCollection();
para.Add("@i_Code", Code);
para.Add("@i_TNC_Sub", "Quotation");
dtTNC = objDA.ExecuteDataTableSP("rpt_Quotation_TNC", para, false, ref mException, ref mErrorMsg, "Quotation TNC");
DataTable dtCompany = new DataTable();
dtCompany = objDA.ExecuteDataTableSP("rpt_Company", null, false, ref mException, ref mErrorMsg, "Quotation TNC");
//dtReport.TableName = "Quotation";
//dtReport.WriteXmlSchema(@"D:\Quotation.xsd");
if (CommSelect.Exception == null)
{
//if (TypeOFSale == "AMC")
//{
// if (System.IO.File.Exists(CurrentUser.ReportPath + "rptQuotation_AMC.rpt"))
// {
// CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
// rptDoc.Load(CurrentUser.ReportPath + "rptQuotation_AMC.rpt");
// //rptDoc.SetDatabaseLogon("sa", "Un!ek3RP");
// CurrentUser.AddReportParameters(rptDoc, dtReport, "", false, false, false, false, false, false, false, false, false, false, false);
// rptDoc.Database.Tables[1].SetDataSource(dtCompany);
// rptDoc.Subreports[0].DataSourceConnections.Clear();
// rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC);
// rptDoc.Refresh();
// Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
// fRptView.Text = "Quotation - [Page Size: A4]";
// fRptView.crViewer.ReportSource = rptDoc;
// if (_IsList == true)
// {
// fRptView.ShowDialog();
// }
// else if (_IsList == false)
// {
// ExportOptions CrExportOptions;
// DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
// PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
// CrDiskFileDestinationOptions.DiskFileName = mpdfFile;
// CrExportOptions = rptDoc.ExportOptions;//Report document object has to be given here
// CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
// CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
// CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
// CrExportOptions.FormatOptions = CrFormatTypeOptions;
// rptDoc.Export();
// }
// }
// else
// {
// MessageBox.Show("File is not exist...");
// }
//}
//else if (TypeOFSale != "AMC")
//{
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptQuotation.rpt"))
{
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptQuotation.rpt");
//rptDoc.Subreports[0].DataSourceConnections.Clear();
rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC);
rptDoc.Database.Tables[1].SetDataSource(dtCompany);
rptDoc.Database.Tables[2].SetDataSource(dt);
rptDoc.Refresh();
CurrentUser.AddReportParameters(rptDoc, dtReport, "", false, false, false, false, false, false, false, false, false, false, false);
CurrentUser.AddExtraParameter(rptDoc);
if (CurrentCompany.Com_Profile != null || CurrentCompany.Com_Profile.Trim() != "")
{
rptDoc.SetParameterValue("pCompanyProfile", CurrentCompany.Com_Profile);
}
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Quotation - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
if (_IsList == true)
{
fRptView.ShowDialog();
}
else if (_IsList == false)
{
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = mpdfFile;
CrExportOptions = rptDoc.ExportOptions;//Report document object has to be given here
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
rptDoc.Export();
}
}
else
{
MessageBox.Show("File is not exist...");
}
//}
}
}
public void RPT_Sub(Int64 PIID, string PurchaseCode, Boolean _IsList)
{
mpdfFile = CurrentUser.DocumentPath + @"pdf\Purchase.pdf";
DataTable dt = new DataTable();
LogoBind(dt);
//if (dgvPurchaseInvoice.CurrentRow != null)
//{
DataTable dtReport = new DataTable();
DataTable dtTNC = new DataTable();
NameValueCollection para = new NameValueCollection();
para.Add("@i_Code", PurchaseCode);
para.Add("@i_TNC_Sub", "Purchase");
para.Add("@i_CompId", CurrentCompany.CompId.ToString());
dtTNC = objDA.ExecuteDataTableSP("rpt_Purchase_TNC", para, false, ref mException, ref mErrorMsg, "Purchase TNC");
//NameValueCollection para = new NameValueCollection();
//para.Add("@i_RecID", Convert.ToInt64(dgvPurchaseInvoice.CurrentRow.Cells["PIID"].Value).ToString());
//dtReport = objList.ListOfRecord("rpt_PO", para, "PurchaseInvoice - Report");
dtReport = CommSelect.SelectRecord(PIID, "rpt_PO", "PurchaseInvoice - Report");
if (CommSelect.Exception == null)
{
if (System.IO.File.Exists(CurrentUser.ReportPath + "rptPurchaseInvoice.rpt"))
{
//dtblPurchaseInvoice.TableName = "PORegister";
//dtblPurchaseInvoice.WriteXmlSchema(@"D:\ERP-CRM\Reports Project\POL_IGMS_Reports\DataSets\PORegister.xsd");
CrystalDecisions.CrystalReports.Engine.ReportDocument rptDoc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
rptDoc.Load(CurrentUser.ReportPath + "rptPurchaseInvoice.rpt");
rptDoc.Subreports[0].Database.Tables[0].SetDataSource(dtTNC);
rptDoc.Database.Tables[1].SetDataSource(dt);
rptDoc.Refresh();
CurrentUser.AddReportParameters(rptDoc, dtReport, "Purchase Order", true, true, true, true, true, true, true, true, true, true, false);
//CurrentUser.AddExtraParameter(rptDoc);
Reports.frmReportViewer fRptView = new Reports.frmReportViewer();
fRptView.Text = "Purchase Order - [Page Size: A4]";
fRptView.crViewer.ReportSource = rptDoc;
if (_IsList == true)
{
fRptView.ShowDialog();
}
else if (_IsList == false)
{
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrDiskFileDestinationOptions.DiskFileName = mpdfFile;
CrExportOptions = rptDoc.ExportOptions;//Report document object has to be given here
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
rptDoc.Export();
}
}
else
{
MessageBox.Show("File is not exist...");
}
}
}
private void ConvertToPdf(string tran_id, string tran_cd, string sp_nm, string rep_nm, string rep_desc)
{
CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
DataSet ds = objFLRep.REPORT_TRANSACTION(tran_id, tran_cd, sp_nm);
CrystalDecisions.CrystalReports.Engine.ReportDocument doc;
if (ds != null && ds.Tables.Count != 0 && ds.Tables[0].Rows.Count != 0)
{
doc = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
doc.Load(AppDomain.CurrentDomain.BaseDirectory + objIni.GetKeyFieldValue("SQL", "initial catalog") + @"\" + rep_nm + ".rpt");
doc.SetDataSource(ds.Tables[0]);
//if (objLicense.License_code == "sZLKa7BcYsepmYbILRVBlg==")
if (ObjBLFD.ObjLoginUser != null && (ObjBLFD.ObjLoginUser.License_type == "SUPPORT LICENSE" || ObjBLFD.ObjLoginUser.License_type == "DEMO LICENSE"))
{
Report_Modification(doc);
}
Type t = typeof(Company);
PropertyInfo[] publicFieldInfos = t.GetProperties(BindingFlags.Instance | BindingFlags.Public);
ParameterFieldDefinitions crParameterdef;
crParameterdef = doc.DataDefinition.ParameterFields;
foreach (PropertyInfo field in publicFieldInfos)
{
foreach (ParameterFieldDefinition def in crParameterdef)
{
if (null != field)
{
if (def.Name.Equals("ORG." + field.Name.ToLower())) // check if parameter exists in report
{
doc.SetParameterValue("ORG." + field.Name.ToLower(), field.GetValue(ObjBLFD.ObjCompany, null) == null ? string.Empty : field.GetValue(ObjBLFD.ObjCompany, null)); // set the parameter value in the report
}
}
}
}
string strApproval = string.Empty;
//DataSet dsetTable = objDL_ADAPTER.dsquery("select i_approved from " + ObjBLFD.Main_tbl_nm + " main_tbl inner join tran_set on main_tbl.tran_cd=tran_set.code where tran_set.isApprove=1 and tran_set.tran_type='Transaction' and "+objBLFD.Primary_id+"='" + tran_id + "' and tran_set.code='" + ObjBLFD.Code + "' and tran_set.compid=" + ObjBLFD.ObjCompany.Compid);
//if (dsetTable != null && dsetTable.Tables.Count != 0 && dsetTable.Tables[0].Rows.Count != 0)
//{
// if (dsetTable.Tables[0].Rows[0]["i_approved"] != null && dsetTable.Tables[0].Rows[0]["i_approved"].ToString() != "" && bool.Parse(dsetTable.Tables[0].Rows[0]["i_approved"].ToString()))
// {
// strApproval = "APPROVE";
// }
// else
// {
// strApproval = "PENDING";
// }
//}
DataSet dsetTable1 = objDL_ADAPTER.dsquery("select code,Main_tbl_nm,Approve_tbl_nm,isReqAuthority from tran_set where isApprove=1 and tran_type='Transaction' and code='" + ObjBLFD.Code + "' and compid=" + ObjBLFD.ObjCompany.Compid);
if (dsetTable1 != null && dsetTable1.Tables.Count != 0 && dsetTable1.Tables[0].Rows.Count != 0)
{
DataSet dsetTable = new DataSet();
if (bool.Parse(dsetTable1.Tables[0].Rows[0]["isReqAuthority"] != null && dsetTable1.Tables[0].Rows[0]["isReqAuthority"].ToString() != "" ? dsetTable1.Tables[0].Rows[0]["isReqAuthority"].ToString() : "False"))
{
// dsetTable = objDL_ADAPTER.dsquery("select i_approved=case when(authorse_by='NOT APPLICABLE') then 1 else i_approved end from " + ObjBLFD.Main_tbl_nm + " main_tbl inner join tran_set on main_tbl.tran_cd=tran_set.code where tran_set.isApprove=1 and tran_set.tran_type='Transaction' and " + ObjBLFD.Primary_id + "='" + tran_id + "' and tran_set.code='" + ObjBLFD.Code + "' and tran_set.compid=" + ObjBLFD.ObjCompany.Compid);
dsetTable = objDL_ADAPTER.dsquery("select i_approved=case when(authorse_by='NOT APPLICABLE') then 'True' else i_approved end from " + ObjBLFD.Main_tbl_nm + " main_tbl where " + ObjBLFD.Primary_id + "='" + tran_id + "' and main_tbl.tran_cd='" + ObjBLFD.Code + "' and main_tbl.compid=" + ObjBLFD.ObjCompany.Compid);
}
else
{
//dsetTable = objDL_ADAPTER.dsquery("select i_approved from " + ObjBLFD.Main_tbl_nm + " main_tbl inner join tran_set on main_tbl.tran_cd=tran_set.code where tran_set.isApprove=1 and tran_set.tran_type='Transaction' and " + ObjBLFD.Primary_id + "='" + tran_id + "' and tran_set.code='" + ObjBLFD.Code + "' and tran_set.compid=" + ObjBLFD.ObjCompany.Compid);
dsetTable = objDL_ADAPTER.dsquery("select i_approved from " + ObjBLFD.Main_tbl_nm + " main_tbl where " + ObjBLFD.Primary_id + "='" + tran_id + "' and main_tbl.code='" + ObjBLFD.Code + "' and main_tbl.compid=" + ObjBLFD.ObjCompany.Compid);
}
if (dsetTable != null && dsetTable.Tables.Count != 0 && dsetTable.Tables[0].Rows.Count != 0)
{
if (dsetTable.Tables[0].Rows[0]["i_approved"] != null && dsetTable.Tables[0].Rows[0]["i_approved"].ToString() != "" && bool.Parse(dsetTable.Tables[0].Rows[0]["i_approved"].ToString()))
{
strApproval = "APPROVE";
}
else
{
strApproval = "PENDING";
}
}
}
foreach (ParameterFieldDefinition def in crParameterdef)
{
if (def.Name.Equals("approval")) // check if parameter exists in report
{
doc.SetParameterValue("approval", strApproval); // set the parameter value in the report
}
}
crystalReportViewer1.ReportSource = doc;
crystalReportViewer1.Visible = false;
CrystalDecisions.Shared.ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
CrExportOptions = doc.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrDiskFileDestinationOptions.DiskFileName = AppDomain.CurrentDomain.BaseDirectory + objBLFD.ObjCompany.Db_nm + "\\FILES\\" + rep_desc.Replace(" ", "_") + tran_id + tran_cd + ".pdf";
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
doc.Export();
if (_hashSendMailAttachements == null || !_hashSendMailAttachements.Contains(rep_nm.Replace(".rpt", "_") + tran_id + tran_cd))
{
_hashSendMailAttachements[rep_nm.Replace(".rpt", "_") + tran_id + tran_cd] = AppDomain.CurrentDomain.BaseDirectory + objBLFD.ObjCompany.Db_nm + "\\FILES\\" + rep_desc.Replace(" ", "_") + tran_id + tran_cd + ".pdf";
}
}
else
{
AutoClosingMessageBox.Show("error in report", "Error");
}
}
protected void btn_Export_Click(object sender, EventArgs e)
{
try
{
pcode = ddl_plantcode.SelectedItem.Value;
CurentRateChartCheck1();
ExportOptions CrExportOptions;
DiskFileDestinationOptions CrDiskFileDestinationOptions = new DiskFileDestinationOptions();
PdfRtfWordFormatOptions CrFormatTypeOptions = new PdfRtfWordFormatOptions();
string path = @"C:\BILL VYSHNAVI\" + ccode + "_" + "_" + pcode + "\\";
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
CrDiskFileDestinationOptions.DiskFileName = path + ccode + "_" + pcode + "_" + "CurrentRateChart.pdf";
CrExportOptions = cr.ExportOptions;
{
CrExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
CrExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
CrExportOptions.DestinationOptions = CrDiskFileDestinationOptions;
CrExportOptions.FormatOptions = CrFormatTypeOptions;
}
cr.Export();
WebMsgBox.Show("Report Export Successfully...");
//
string MFileName = string.Empty;
MFileName = @"C:/BILL VYSHNAVI/" + ccode + "_" + "_" + pcode + "/" + ccode + "_" + pcode + "_" + "CurrentRateChart.pdf";
System.IO.FileInfo file = new System.IO.FileInfo(MFileName);
if (File.Exists(MFileName.ToString()))
{
//
FileStream sourceFile = new FileStream(file.FullName, FileMode.Open);
float FileSize;
FileSize = sourceFile.Length;
byte[] getContent = new byte[(int)FileSize];
sourceFile.Read(getContent, 0, (int)sourceFile.Length);
sourceFile.Close();
//
Response.ClearContent(); // neded to clear previous (if any) written content
Response.AddHeader("Content-Disposition", "attachment; filename=" + file.Name);
Response.AddHeader("Content-Length", file.Length.ToString());
Response.ContentType = "text/plain";
Response.BinaryWrite(getContent);
File.Delete(file.FullName.ToString());
Response.Flush();
Response.End();
}
else
{
Response.Write("File Not Found...");
}
//
}
catch (Exception ex)
{
WebMsgBox.Show("Please Check the ExportPath...");
}
}
