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