Ejemplo n.º 1
0
        public void btReportDate_Click(object sender, EventArgs e)
        {
            string sql = @"
SELECT    top " + System.Convert.ToString(int.Parse(txtTop.Text)) + @"    dbo.tb_SellDetail.foodID, dbo.tb_FoodAndDrink.foodName, COUNT(dbo.tb_SellDetail.foodID) AS SellAmount, dbo.tb_Unit.UnitName
FROM            dbo.tb_Selling INNER JOIN
dbo.tb_SellDetail ON dbo.tb_Selling.SellID = dbo.tb_SellDetail.SellID INNER JOIN
dbo.tb_FoodAndDrink ON dbo.tb_SellDetail.foodID = dbo.tb_FoodAndDrink.foodID INNER JOIN
dbo.tb_Unit ON dbo.tb_FoodAndDrink.UnitID = dbo.tb_Unit.UnitID
Where (dbo.tb_selldetail.sellID in (select SellID from dbo.tb_selling as Sell where (month(dateCome)='" + System.Convert.ToString(cbMonth.SelectedItem) + "') and (year(dateCome)='" + System.Convert.ToString(cbYear.SelectedItem) + @"')))
GROUP BY dbo.tb_SellDetail.foodID, dbo.tb_FoodAndDrink.foodName, dbo.tb_Unit.UnitName, dbo.tb_Unit.UnitName
order by sellAmount desc";

            DSReport dsr = new DSReport();
            BestSellByMonthAndYear rpt = new BestSellByMonthAndYear();
            var da = new SqlDataAdapter(sql, ConstVar.connect.DatabaseConnection(ConstVar.constr));

            da.Fill(dsr, "DTMonthSellGood");
            if (dsr.Tables["DTMonthSellGood"].Rows.Count == 0)
            {
                MessageBox.Show("ບໍ່ມີຂໍ້ມູນ");
            }
            else
            {
                rpt.SetDataSource(dsr);
                rpt.SetParameterValue("top", txtTop.Text);
                rpt.SetParameterValue("month", cbMonth.SelectedItem);
                rpt.SetParameterValue("year", cbYear.SelectedItem);
                frm_MainReportChoosing.Default.CrystalReportViewer1.ReportSource = rpt;
                frm_MainReportChoosing.Default.Show(this);
            }
        }
Ejemplo n.º 2
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            BestSellByMonthAndYear rpt = new BestSellByMonthAndYear();

            rpt.Site = this.Site;
            return(rpt);
        }