コード例 #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            rptInHoaDon rpt = new rptInHoaDon();

            rpt.Site = this.Site;
            return(rpt);
        }
コード例 #2
0
        private void frmINHOADON_Load(object sender, EventArgs e)
        {
            var query = "SELECT DRINKTABLE.tablename, BILLINFO.id, DRINK.drinkname, DRINK.price, BILLINFO.count, BILLDRINKS.timecheckin, BILLDRINKS.timecheckout, BILLDRINKS.giamgia, BILLDRINKS.TongTien" +
                        " FROM BILLDRINKS INNER JOIN " +
                        " BILLINFO ON BILLDRINKS.id = BILLINFO.idbill INNER JOIN " +
                        " DRINK ON BILLINFO.iddrink = DRINK.id INNER JOIN " +
                        "DRINKTABLE ON BILLDRINKS.idtable = DRINKTABLE.id where BILLDRINKS.billstatus = 0 AND DRINKTABLE.tablename = '" + id + "'";
            SqlDataAdapter da = new SqlDataAdapter(query, cnn);

            try
            {
                DataTable tblInHoaDon = new DataTable();
                da.Fill(tblInHoaDon);
                rptInHoaDon rpt = new rptInHoaDon();
                rpt.SetDataSource(tblInHoaDon);
                crvInHoaDon.ReportSource = rpt;
            }catch (SqlException ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }