public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { COF rpt = new COF(); rpt.Site = this.Site; return(rpt); }
private void COF_Printing_Load(object sender, EventArgs e) { try { conn = new SqlConnection(); conn.ConnectionString = str_conn; conn.Open(); //BalloonKingdomDataSetTableAdapters.COFItemOrderlineTableAdapter ord = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.COFItemOrderlineTableAdapter(); //DataTable datatable = ord.cofanditem(cofNo); //BalloonKingdomDataSetTableAdapters.ordersTableAdapter ord = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.ordersTableAdapter(); // DataTable datatable = ord.tryone(cofNo); //BalloonKingdomDataSetTableAdapters.orderanditemTableAdapter orr = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.orderanditemTableAdapter(); //DataTable datatable = orr.Pasta(cofNo); //BalloonKingdomDataSetTableAdapters.TryTryAgainTableAdapter add = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.TryTryAgainTableAdapter(); //DataTable datatable = add.pestepeste(cofNo);; //BalloonKingdomDataSetTableAdapters.OrderNatinTableAdapter are = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.OrderNatinTableAdapter(); // DataTable datatable = are.patay(cofNo); //BalloonKingdomDataSetTableAdapters.cNewSelectCommandTableAdapter are = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.cNewSelectCommandTableAdapter(); //DataTable datatable = are.pagodnako(cofNo); x = Convert.ToInt32(cofNo); //cmd = new SqlCommand("SELECT Orderline.[COF Number], Orderline.Lastname, Orderline.[First Name], Orderline.[Middle Initial], Orderline.[Order Date], Orderline.[Event Date], Orderline.Theme, Orderline.[Color Motif], Orderline.Venue, Item.[COF Number] AS Expr1, Item.[Item Name], Item.Quantity, Item.[Unit Cost], Item.[Sub Cost], Invoice.[COF Number] AS Expr2, Invoice.[Order Amount], Invoice.[Service Charge], Invoice.Total FROM Orderline INNER JOIN Item ON Orderline.[COF Number] = Item.[COF Number] INNER JOIN Invoice ON Orderline.[COF Number] = Invoice.[COF Number] WHERE Orderline.[COF Number]='" + x + "'",conn); //cmd.CommandType = CommandType.Text; //da = new SqlDataAdapter(cmd); //BalloonKingdomDataSet ds = new BalloonKingdomDataSet(); //da.Fill(ds, "fNewSelectCommand"); BalloonKingdomDataSetTableAdapters.jNewSelectCommandTableAdapter or = new WindowsApplication1.BalloonKingdomDataSetTableAdapters.jNewSelectCommandTableAdapter(); DataTable datatable = or.OrderlineItems(x); COF cust = new COF(); cust.SetDataSource(datatable); //COF3 cust = new COF3(); //cust.SetDataSource(datatable); crystalReportViewer1.ReportSource = cust; //cmd.Dispose(); conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.GetBaseException().ToString()); } }
public void AssignCOFPrint(COF rpt) { crystalReportViewer1.ReportSource = rpt; }