Пример #1
0
        private void XuatHoaDon()
        {
            string sidhd = "";

            try { sidhd = txtID.Text.Trim(); }
            catch { }
            if (sidhd.Trim().Equals("") == false && sidhd.Trim().Equals("-1") == false)
            {
                Application.DoEvents();
                tsProgressBar1.Visible = true;
                tsProgressBar1.PerformStep();
                DataTable dt = new DataTable();
                dt = (DataTable)flxMatHang.DataSource;
                Application.DoEvents();
                tsProgressBar1.PerformStep();
                frmReportHDBan  frm            = new frmReportHDBan();
                rptHoaDonBan    _rptHoaDonBan  = new rptHoaDonBan();
                ReportDocument  reportDocument = new ReportDocument();
                ParameterFields pfields        = new ParameterFields();
                #region Khai báo parametter tiêu đề ngày tháng
                ParameterField         pTenKH        = new ParameterField();
                ParameterDiscreteValue dispTenKH     = new ParameterDiscreteValue();
                ParameterField         pDienThoai    = new ParameterField();
                ParameterDiscreteValue dispDienThoai = new ParameterDiscreteValue();
                ParameterField         pNgayXuat     = new ParameterField();
                ParameterDiscreteValue dispNgayXuat  = new ParameterDiscreteValue();
                ParameterField         pNoCu         = new ParameterField();
                ParameterDiscreteValue dispNoCu      = new ParameterDiscreteValue();
                ParameterField         pTienDaTT     = new ParameterField();
                ParameterDiscreteValue dispTienDaTT  = new ParameterDiscreteValue();
                ParameterField         pGhiChu       = new ParameterField();
                ParameterDiscreteValue disGhiChu     = new ParameterDiscreteValue();
                ParameterField         pChietKhau    = new ParameterField();
                ParameterDiscreteValue disChietKhau  = new ParameterDiscreteValue();
                string tenKH     = "";
                string DT        = "";
                string ngayXuat  = "";
                string noCu      = "";
                string tienTT    = "";
                string ghiChu    = "";
                string chietKhau = "";
                tenKH     = txtTenKH.Text.Trim();
                DT        = txtDienThoai.Text.Trim();
                ngayXuat  = txtNgayXuat.Text.Trim();
                noCu      = txtNoToaTruoc.Text.Trim();
                tienTT    = txtTienThanhToan.Text.Trim();
                ghiChu    = txtGhiChu.Text.Trim();
                chietKhau = txtChietKhau.Text.Trim();
                Application.DoEvents();
                tsProgressBar1.PerformStep();
                dispTenKH.Value = tenKH;
                pTenKH.Name     = "pTenKH";
                pTenKH.CurrentValues.Add(dispTenKH);
                pfields.Add(pTenKH);
                Application.DoEvents();
                tsProgressBar1.PerformStep();
                dispDienThoai.Value = DT;
                pDienThoai.Name     = "pDienThoai";
                pDienThoai.CurrentValues.Add(dispDienThoai);
                pfields.Add(pDienThoai);
                Application.DoEvents();
                tsProgressBar1.PerformStep();
                dispNgayXuat.Value = ngayXuat;
                pNgayXuat.Name     = "pNgayXuat";
                pNgayXuat.CurrentValues.Add(dispNgayXuat);
                pfields.Add(pNgayXuat);
                Application.DoEvents();
                tsProgressBar1.PerformStep();
                dispNoCu.Value = noCu;
                pNoCu.Name     = "pNoCu";
                pNoCu.CurrentValues.Add(dispNoCu);
                pfields.Add(pNoCu);
                Application.DoEvents();
                tsProgressBar1.PerformStep();
                dispTienDaTT.Value = tienTT;
                pTienDaTT.Name     = "pTienDaTT";
                pTienDaTT.CurrentValues.Add(dispTienDaTT);
                pfields.Add(pTienDaTT);
                Application.DoEvents();
                tsProgressBar1.PerformStep();
                disGhiChu.Value = ghiChu;
                pGhiChu.Name    = "pGhiChu";
                pGhiChu.CurrentValues.Add(disGhiChu);
                pfields.Add(pGhiChu);
                Application.DoEvents();
                tsProgressBar1.PerformStep();
                disChietKhau.Value = chietKhau;
                pChietKhau.Name    = "pChietKhau";
                pChietKhau.CurrentValues.Add(disChietKhau);
                pfields.Add(pChietKhau);
                #endregion
                Application.DoEvents();
                tsProgressBar1.PerformStep();
                frm.crystalReportViewer1.ParameterFieldInfo = pfields;
                Application.DoEvents();
                tsProgressBar1.PerformStep();
                frm.crystalReportViewer1.ReportSource = _rptHoaDonBan;
                Application.DoEvents();
                tsProgressBar1.PerformStep();
                _rptHoaDonBan.SetDataSource(dt);
                Application.DoEvents();
                tsProgressBar1.Value = tsProgressBar1.Maximum;
                frm.ShowDialog();
                Application.DoEvents();
                tsProgressBar1.Value   = 0;
                tsProgressBar1.Visible = false;
            }
        }
Пример #2
0
        private void frmBC_InHDPhieu_Load(object sender, EventArgs e)
        {
            string strCaption = "";
            string ReportFile = Declare.AppPath;
            string sql        = "";

            cnn = ConnectionUtil.Instance.GetConnection();
            switch (ReportType)
            {
            case "PT":
            {
                strCaption = "In phiếu thu";
                sql        = " SELECT     SoPhieu, NgayLap, HoTen, DiaChi, SoTien, SoTaiKhoan, NoiDungThuChi, TyGia, SoTienChu,  SoChungTuKem, ChungTuGoc, Ngay, Thang, Nam  FROM vPhieuThu  ";
                sql        = sql + " WHERE SoPhieu = '" + SoHD_Phieu.Trim() + "'";
                ReportFile = ReportFile + "Reports\\rptPhieuThu.rpt";
                break;
            }

            case "THPT": {
                strCaption = "Tổng hợp phiếu thu";
                sql        = " SELECT     *  FROM vBCThu  ";
                ReportFile = ReportFile + "Reports\\rptBC_Thu.rpt";
                break;
            }

            case "PC":
            {
                strCaption = "In phiếu chi";
                sql        = " SELECT     SoPhieuChi, NgayChi, SoTaiKhoan, SoTKDoiUng, LyDoChi, TienChi, TyGia, TongTienVN, TongTien_Chu, ChungTuGoc, HoTen, QuyenSo, TenTienTe, TenNhaCungCap, DiaChi, SL_ChungTuKem, ngay_chi, thang_chi, nam_chi, ngay, thang, nam  FROM vPhieuChi ";
                sql        = sql + " WHERE SoPhieuChi = '" + SoHD_Phieu.Trim() + "' and QuyenSo='" + this.QuyenSo + "'";
                ReportFile = ReportFile + "Reports\\rptPhieuChi.rpt";
                break;
            }

            case "HDM":
            {
                this.Text = "In hóa đơn mua";
                sql       = " select * from vThongTinNhaThuoc;select * from vHoaDonMua where SoHoaDonMua=N'" + SoHD_Phieu + "';select * from vChiTiet_HoaDonMua where SoHoaDonMua=N'" + SoHD_Phieu + "'";
                da        = new GtidDataAdapter(sql, cnn);
                da.Fill(ds);
                ds.Tables[0].TableName = "vThongTinNhaThuoc";
                ds.Tables[1].TableName = "vHoaDonMua";
                ds.Tables[2].TableName = "vChiTiet_HoaDonMua";
                ReportFile             = ReportFile + "Reports\\rptHoaDonMua.rpt";
                if (ds.Tables[1].Rows.Count > 0)
                {
                    rptHoaDonMua rpt = new rptHoaDonMua();
                    rpt.SetDataSource(ds);
                    rptViewer.ReportSource = rpt;
                    rptViewer.RefreshReport();
                    return;
                }
                break;
            }

            case "HDB":
            {
                this.Text = "In hóa đơn bán";
                sql       = " select * from vThongTinNhaThuoc;select * from vHoaDonBan where SoHoaDonBan=N'" + SoHD_Phieu + "';select * from vChiTiet_HoaDonBan where SoHoaDonBan=N'" + SoHD_Phieu + "'";
                da        = new GtidDataAdapter(sql, cnn);
                da.Fill(ds);
                ds.Tables[0].TableName = "vThongTinNhaThuoc";
                ds.Tables[1].TableName = "vHoaDonBan";
                ds.Tables[2].TableName = "vChiTiet_HoaDonBan";
                ReportFile             = ReportFile + "Reports\\rptHoaDonBan.rpt";
                if (ds.Tables[1].Rows.Count > 0)
                {
                    rptHoaDonBan rpt = new rptHoaDonBan();
                    rpt.SetDataSource(ds);
                    rptViewer.ReportSource = rpt;
                    rptViewer.RefreshReport();
                    return;
                }
                break;
            }
            }
            this.Text = strCaption;

            if (!DBTools.ExistData(sql))
            {
                MessageBox.Show("Không có dữ liệu. Chọn số phiếu khác để in!", Declare.titleWarning, MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }
            else
            {
                DBTools.LoadReportFile(ReportFile, sql, rptViewer);
                this.rptViewer.RefreshReport();
            }
        }