Example #1
0
        private void btnPrintBaoCaoTre_Click(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            ketnoi    kn = new ketnoi();

            dt = kn.laybang(@"select * from viewDonHangTre where IDSP like '" + txtIDSP.Text + "'");
            RpDonHangTre rpDonHangTre = new RpDonHangTre();

            rpDonHangTre.DataSource = dt;
            rpDonHangTre.DataMember = "Table";
            rpDonHangTre.ShowPreviewDialog();
        }
Example #2
0
        private void btnPrint_Click(object sender, EventArgs e)
        {
            DataTable dt = new DataTable();
            ketnoi    kn = new ketnoi();

            dt = kn.laybang(@"SELECT IDSP,DanhGia,mabv,madh,SPLR,sanpham,soluongyc,BTPT11,
                    KetThucTo11,AllProgress,STATUS,ngoaiquang
                    FROM PHANTICH_CHUNG WHERE STATUS =N'Trễ' or STATUS =N'Đỏ'");
            RpDonHangTre rpDonHangTre = new RpDonHangTre();

            rpDonHangTre.DataSource = dt;
            rpDonHangTre.DataMember = "Table";
            rpDonHangTre.ShowPreviewDialog();
        }