コード例 #1
0
        void Print5()
        {
            dsSanPhamTheoCty1.cty.Clear();
            SqlDataAdapter d = new SqlDataAdapter("select * from DM_CONGTY where CTY_MA='" + lueCongTy.EditValue + "'", clsConnection._conn);

            d.Fill(dsSanPhamTheoCty1.cty);

            rptDsSanPhamTheoCty5 rpt = new rptDsSanPhamTheoCty5();

            rpt.pGoiThau.Value        = lueGoiThau.Text;
            rpt.pHospital.Value       = clsParameter.pHospital;
            rpt.pParentHospital.Value = clsParameter.pParentHospital;

            rpt.p1.Value = dtCol.Rows[0]["VIET_TAT"].ToString();
            rpt.p2.Value = dtCol.Rows[1]["VIET_TAT"].ToString();
            rpt.p3.Value = dtCol.Rows[2]["VIET_TAT"].ToString();
            rpt.p4.Value = dtCol.Rows[3]["VIET_TAT"].ToString();
            rpt.p5.Value = dtCol.Rows[4]["VIET_TAT"].ToString();


            rpt.dc1.Value = dtCol.Rows[0]["DIEM_CHUAN"] + string.Empty;
            rpt.dc2.Value = dtCol.Rows[1]["DIEM_CHUAN"] + string.Empty;
            rpt.dc3.Value = dtCol.Rows[2]["DIEM_CHUAN"] + string.Empty;
            rpt.dc4.Value = dtCol.Rows[3]["DIEM_CHUAN"] + string.Empty;
            rpt.dc5.Value = dtCol.Rows[4]["DIEM_CHUAN"] + string.Empty;


            rpt.d1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
                new DevExpress.XtraReports.UI.XRBinding("Text", null, "DsSanPhamTheoCty." + dtCol.Rows[0]["VIET_TAT"].ToString())
            });

            rpt.d2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
                new DevExpress.XtraReports.UI.XRBinding("Text", null, "DsSanPhamTheoCty." + dtCol.Rows[1]["VIET_TAT"].ToString())
            });

            rpt.d3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
                new DevExpress.XtraReports.UI.XRBinding("Text", null, "DsSanPhamTheoCty." + dtCol.Rows[2]["VIET_TAT"].ToString())
            });

            rpt.d4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
                new DevExpress.XtraReports.UI.XRBinding("Text", null, "DsSanPhamTheoCty." + dtCol.Rows[3]["VIET_TAT"].ToString())
            });

            rpt.d5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
                new DevExpress.XtraReports.UI.XRBinding("Text", null, "DsSanPhamTheoCty." + dtCol.Rows[4]["VIET_TAT"].ToString())
            });



            rpt.DataSource = dsSanPhamTheoCty1;
            rpt.DataMember = "DsSanPhamTheoCty";
            frmPrint f = new frmPrint(rpt);

            f.ShowDialog();
        }
コード例 #2
0
        private void btnControl_btnEventPrint_Click(object sender, EventArgs e)
        {
            rptTongHopSPChenhLech rpt = new rptTongHopSPChenhLech();

            rpt.pHospital.Value       = clsParameter.pHospital;
            rpt.pParentHospital.Value = clsParameter.pParentHospital;
            rpt.pNgayMoThau.Value     = clsParameter.pNgayMoThau;

            rpt.pQuyetDinh.Value   = clsParameter.pQuyetDinh;
            rpt.pTitleFooter.Value = ReportHelper.getTitleFooter(LoaiBaoCao.BM28);
            rpt.pValueFooter.Value = ReportHelper.getValueFooter(LoaiBaoCao.BM28);
            rpt.DataSource         = ds.Tables["sp_CtyTrungTenThuongMai"];
            rpt.DataMember         = "SANPHAM";
            frmPrint f = new frmPrint(rpt);

            f.ShowDialog();
        }
コード例 #3
0
        void Print6()
        {
            dsSanPhamTheoCty1.cty.Clear();
            SqlDataAdapter d = new SqlDataAdapter("select * from DM_CONGTY where CTY_MA='" + lueCongTy.EditValue + "'", clsConnection._conn);

            d.Fill(dsSanPhamTheoCty1.cty);

            rptDsSanPhamTheoCty6 rpt = new rptDsSanPhamTheoCty6();

            rpt.pGoiThau.Value        = lueGoiThau.Text;
            rpt.pHospital.Value       = clsParameter.pHospital;
            rpt.pParentHospital.Value = clsParameter.pParentHospital;
            rpt.pThuKy.Value          = clsParameter.pThuKy;
            rpt.pUyVien.Value         = clsParameter.pUyVien;
            rpt.pToTruong.Value       = clsParameter.pToTruongToXetThau;
            rpt.pNgayMoThau.Value     = clsParameter.pNgayMoThau;

            //rpt.p1.Value = dtCol.Rows[0]["VIET_TAT"].ToString();
            //rpt.p2.Value = dtCol.Rows[1]["VIET_TAT"].ToString();
            //rpt.p3.Value = dtCol.Rows[2]["VIET_TAT"].ToString();
            //rpt.p4.Value = dtCol.Rows[3]["VIET_TAT"].ToString();
            //rpt.p5.Value = dtCol.Rows[4]["VIET_TAT"].ToString();
            //rpt.p6.Value = dtCol.Rows[5]["VIET_TAT"].ToString();

            rpt.p1.Value = "1";
            rpt.p2.Value = "2";
            rpt.p3.Value = "3";
            rpt.p4.Value = "4";
            rpt.p5.Value = "5";
            rpt.p6.Value = "6";

            rpt.dc1.Value = dtCol.Rows[0]["DIEM_CHUAN"] + string.Empty;
            rpt.dc2.Value = dtCol.Rows[1]["DIEM_CHUAN"] + string.Empty;
            rpt.dc3.Value = dtCol.Rows[2]["DIEM_CHUAN"] + string.Empty;
            rpt.dc4.Value = dtCol.Rows[3]["DIEM_CHUAN"] + string.Empty;
            rpt.dc5.Value = dtCol.Rows[4]["DIEM_CHUAN"] + string.Empty;
            rpt.dc6.Value = dtCol.Rows[5]["DIEM_CHUAN"] + string.Empty;

            //rpt.dc1.Value = "(1)";
            //rpt.dc2.Value = "(2)";
            //rpt.dc3.Value = "(3)";
            //rpt.dc4.Value = "(4)";
            //rpt.dc5.Value = "(5)";
            //rpt.dc6.Value = "(6)";

            rpt.d1.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
                new DevExpress.XtraReports.UI.XRBinding("Text", null, "DsSanPhamTheoCty." + dtCol.Rows[0]["VIET_TAT"].ToString())
            });

            rpt.d2.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
                new DevExpress.XtraReports.UI.XRBinding("Text", null, "DsSanPhamTheoCty." + dtCol.Rows[1]["VIET_TAT"].ToString())
            });

            rpt.d3.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
                new DevExpress.XtraReports.UI.XRBinding("Text", null, "DsSanPhamTheoCty." + dtCol.Rows[2]["VIET_TAT"].ToString())
            });

            rpt.d4.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
                new DevExpress.XtraReports.UI.XRBinding("Text", null, "DsSanPhamTheoCty." + dtCol.Rows[3]["VIET_TAT"].ToString())
            });

            rpt.d5.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
                new DevExpress.XtraReports.UI.XRBinding("Text", null, "DsSanPhamTheoCty." + dtCol.Rows[4]["VIET_TAT"].ToString())
            });

            rpt.d6.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
                new DevExpress.XtraReports.UI.XRBinding("Text", null, "DsSanPhamTheoCty." + dtCol.Rows[5]["VIET_TAT"].ToString())
            });

            rpt.DataSource         = dsSanPhamTheoCty1;
            rpt.DataMember         = "DsSanPhamTheoCty";
            rpt.pTitleFooter.Value = ReportHelper.getTitleFooter(LoaiBaoCao.BM27);
            rpt.pValueFooter.Value = ReportHelper.getValueFooter(LoaiBaoCao.BM27);
            frmPrint f = new frmPrint(rpt);

            f.ShowDialog();
        }