Example #1
0
        public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
        {
            rpt_BaoCaoCacPhieuTrongKhoangThoiGian rpt = new rpt_BaoCaoCacPhieuTrongKhoangThoiGian();

            rpt.Site = this.Site;
            return(rpt);
        }
Example #2
0
        private void btnPrev_Click(object sender, EventArgs e)
        {
            rpt_BaoCaoCacPhieuTrongKhoangThoiGian obj;

            obj = new rpt_BaoCaoCacPhieuTrongKhoangThoiGian();

            string strLenh;

            strLenh = "EXEC SP_PHIEUNHAPXUAT_TRONGKHOANGTHOIGIAN '" + dtpTungay.Value.ToString() + "', '" +
                      dtpDenngay.Value.ToString() + "', '" + cmbLoai.Text.Substring(0, 1) + "' ";
            DataTable MyTable;

            MyTable = Program.ExecSqlDataTable(strLenh, Program.connstr);

            obj.SetDataSource(MyTable);
            obj.SetParameterValue("TENCN", cmbChiNhanh.Text);
            obj.SetParameterValue("LP", cmbLoai.Text);
            obj.SetParameterValue("TUNG", dtpTungay.Value.ToString());
            obj.SetParameterValue("DENNG", dtpDenngay.Value.ToString());
            crptView.ReportSource = obj;
        }