public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rpDonThuoc rpt = new rpDonThuoc(); rpt.Site = this.Site; return rpt; }
private void btnDonThuoc_In_Click(object sender, EventArgs e) { btnDonThuoc_In.Visible = false; btnTroLai.Visible = true; expandableSplitter1.Expanded = true; SqlConnection cnn; string connectionString = null; string sql = null; connectionString = connectData.ChuoiKetNoi(); cnn = new SqlConnection(connectionString); cnn.Open(); string mabenhnhan = txtDonThuoc_MaBenhNhan.Text.ToString(); sql = "EXEC CHITIETDONTHUOC_TENTHUOC1 '" + mabenhnhan + "'"; //sql = "Select distinct c.NhomThuoc, b.MaThuoc, TenThuoc, b.SoLuong, ThoiDiemSuDung "+ // "from DONTHUOC as a, CHITIETDONTHUOC as b, THUOC as c, BENHNHAN as d "+ // "where (a.MaBenhNhan = '" txtDonThuoc_MaBenhNhan.Text +"') and (c.MaThuoc = b.MaThuoc) and (a.MaDonThuoc = b.MaDonThuoc)"; SqlDataAdapter dscmd = new SqlDataAdapter(sql, cnn); QLBVDataSet ds = new QLBVDataSet(); dscmd.Fill(ds, "CHITIETDONTHUOC_TENTHUOC1"); //MessageBox.Show(ds.Tables[1].Rows.Count.ToString()); cnn.Close(); rpDonThuoc objRpt = new rpDonThuoc(); //objRpt.SetDataSource(ds.Tables[0]); objRpt.Database.Tables["CHITIETDONTHUOC_TENTHUOC1"].SetDataSource(ds); ParameterValues a = new ParameterValues(); ParameterDiscreteValue b = new ParameterDiscreteValue(); b.Value = txtDonThuoc_MaDonThuoc.Text; a.Add(b); objRpt.DataDefinition.ParameterFields["MaPhieuKham"].ApplyCurrentValues(a); b.Value = txtDonThuoc_HoBN.Text; a.Add(b); objRpt.DataDefinition.ParameterFields["HoBenhNhan"].ApplyCurrentValues(a); b.Value = txtDonThuoc_TenBN.Text; a.Add(b); objRpt.DataDefinition.ParameterFields["TenBenhNhan"].ApplyCurrentValues(a); b.Value = txtDonThuoc_GioiTinhBN.Text; a.Add(b); objRpt.DataDefinition.ParameterFields["GioiTinh"].ApplyCurrentValues(a); b.Value = dtPickerDonThuoc_NgaySinh.Text; a.Add(b); objRpt.DataDefinition.ParameterFields["NgaySinh"].ApplyCurrentValues(a); b.Value = txtDonThuoc_HoBacSi.Text; a.Add(b); objRpt.DataDefinition.ParameterFields["HoBacSi"].ApplyCurrentValues(a); b.Value = txtDonThuoc_TenBacSi.Text; a.Add(b); objRpt.DataDefinition.ParameterFields["TenBacSi"].ApplyCurrentValues(a); crystalReportViewer1.ReportSource = objRpt; crystalReportViewer1.Refresh(); }