private void Inhoadon_Load(object sender, EventArgs e)
{
Hamchung hc = new Hamchung();
SqlConnection cnn = new SqlConnection(hc.sqlCon);
cnn.Open();
SqlDataAdapter da = new SqlDataAdapter("rpHoadon '"+MainForm.frmHoadon.Madangchon+"'", cnn);
DataTable dt = new DataTable();
da.Fill(dt);
SqlCommand cmd = new SqlCommand("Tongtien", cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@MaHD", MainForm.frmHoadon.Madangchon);
SqlDataReader reader = cmd.ExecuteReader();
reader.Read();
string Tongtien = reader[0].ToString();
ReportHoadon cr = new ReportHoadon();
cr.SetDataSource(dt);
cr.SetParameterValue("MaHD", MainForm.frmHoadon.Madangchon);
cr.SetParameterValue("Tenkhachhang", MainForm.frmHoadon.tenkh);
cr.SetParameterValue("Tennhanvien", MainForm.frmHoadon.tennv);
cr.SetParameterValue("Makhachhang", MainForm.frmHoadon.makh);
cr.SetParameterValue("Ngaylap", MainForm.frmHoadon.nl);
try
{
cr.SetParameterValue("Tongtien", Tongtien);
}
catch {
MessageBox.Show("Hóa đơn này rỗng");
return;
}
rptvHoadon.ReportSource = cr;
cnn.Close();
}
private void DanhsachKH_Load(object sender, EventArgs e)
{
Hamchung hc = new Hamchung();
SqlConnection cnn = new SqlConnection(hc.sqlCon);
cnn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from Khachhang", cnn);
DataTable dt = new DataTable();
da.Fill(dt);
ReportKhachhang kh = new ReportKhachhang();
kh.SetDataSource(dt);
rptvKhachhang.ReportSource = kh;
cnn.Close();
}
private void DanhsachNXB_Load(object sender, EventArgs e)
{
Hamchung hc = new Hamchung();
SqlConnection cnn = new SqlConnection(hc.sqlCon);
cnn.Open();
SqlDataAdapter da = new SqlDataAdapter("select * from NXB", cnn);
DataTable dt = new DataTable();
da.Fill(dt);
reportNXB nxb = new reportNXB();
nxb.SetDataSource(dt);
rptvNXB.ReportSource = nxb;
cnn.Close();
}
