using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
namespace PIS_Billing.Packing.PackingList_Report
{
public partial class reporton : Form
{
public reporton()
{
InitializeComponent();
}
string PackingId;
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["PIS_Billing_Connection"].ToString());
//----tanking value main form to report form
public string _textBox
{
set { label1.Text = value;
PackingId = value;
}
}
private void reporton_Load(object sender, EventArgs e)
{
try
{
DataSet ds = new DataSet();
DataTable dt1 = MyPackingList().Copy();
DataTable dt2 = SpPackingList().Copy();
DataTable dt3 = Summary_Vw().Copy();
ds.Tables.Add(dt1);
ds.Tables.Add(dt2);
ds.Tables.Add(dt3);
ReportDocument myreport = new ReportDocument();
myreport.Load("D:\\PIS_Billing\\PIS_Billing\\PIS_Billing\\Packing\\PackingList_Report\\packingListReport.rpt");
myreport.SetDataSource(ds);
crystalReportViewer1.ReportSource = myreport;
}
catch (Exception)
{
//throw;
}
}
protected DataTable MyPackingList()
{
string Query = "SELECT * FROM dbo.PackingList WHERE PackingId='" + PackingId + "' ";
SqlDataAdapter da = new SqlDataAdapter(Query, con);
DataSet ds = new DataSet();
da.Fill(ds, "PackingList");
DataTable Pack = ds.Tables[0];
return Pack;
}
protected DataTable SpPackingList()
{
string Query = "SELECT DISTINCT SpId,Specification FROM dbo.PackingList WHERE PackingId='" + PackingId + "'";
SqlDataAdapter da = new SqlDataAdapter(Query, con);
DataSet ds = new DataSet();
da.Fill(ds, "SpecificationInfo");
DataTable SpecificationInfo = ds.Tables[0];
return SpecificationInfo;
}
private DataTable Summary_Vw()
{
string Query = "SELECT * FROM pack_Summary_Vw WHERE PackingId='" + PackingId + "'";
SqlDataAdapter da = new SqlDataAdapter(Query, con);
DataSet ds = new DataSet();
da.Fill(ds, "Pack_Summary_VW");
DataTable Summary_Vw = ds.Tables[0];
return Summary_Vw;
}
}
}
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
namespace PIS_Billing.Packing.PackingList_Report
{
public partial class reporton : Form
{
public reporton()
{
InitializeComponent();
}
string PackingId;
SqlConnection con = new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["PIS_Billing_Connection"].ToString());
//----tanking value main form to report form
public string _textBox
{
set { label1.Text = value;
PackingId = value;
}
}
private void reporton_Load(object sender, EventArgs e)
{
try
{
DataSet ds = new DataSet();
DataTable dt1 = MyPackingList().Copy();
DataTable dt2 = SpPackingList().Copy();
DataTable dt3 = Summary_Vw().Copy();
ds.Tables.Add(dt1);
ds.Tables.Add(dt2);
ds.Tables.Add(dt3);
ReportDocument myreport = new ReportDocument();
myreport.Load("D:\\PIS_Billing\\PIS_Billing\\PIS_Billing\\Packing\\PackingList_Report\\packingListReport.rpt");
myreport.SetDataSource(ds);
crystalReportViewer1.ReportSource = myreport;
}
catch (Exception)
{
//throw;
}
}
protected DataTable MyPackingList()
{
string Query = "SELECT * FROM dbo.PackingList WHERE PackingId='" + PackingId + "' ";
SqlDataAdapter da = new SqlDataAdapter(Query, con);
DataSet ds = new DataSet();
da.Fill(ds, "PackingList");
DataTable Pack = ds.Tables[0];
return Pack;
}
protected DataTable SpPackingList()
{
string Query = "SELECT DISTINCT SpId,Specification FROM dbo.PackingList WHERE PackingId='" + PackingId + "'";
SqlDataAdapter da = new SqlDataAdapter(Query, con);
DataSet ds = new DataSet();
da.Fill(ds, "SpecificationInfo");
DataTable SpecificationInfo = ds.Tables[0];
return SpecificationInfo;
}
private DataTable Summary_Vw()
{
string Query = "SELECT * FROM pack_Summary_Vw WHERE PackingId='" + PackingId + "'";
SqlDataAdapter da = new SqlDataAdapter(Query, con);
DataSet ds = new DataSet();
da.Fill(ds, "Pack_Summary_VW");
DataTable Summary_Vw = ds.Tables[0];
return Summary_Vw;
}
}
}
No comments:
Post a Comment