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(); }
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(); }
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(); }