private void BaoCaoF_Load(object sender, EventArgs e)
{
if (keyn == 1)
{
SqlConnection con = new SqlConnection();
string sql = @"Data Source=TRANG\SQLEXPRESS;Initial Catalog=QLKH;Integrated Security=True";
con.ConnectionString = sql;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "BCN";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TENNV", TenNv));
cmd.Parameters.Add(new SqlParameter("@TENSP", TenSp));
cmd.Parameters.Add(new SqlParameter("@TENNCC", TenNcc_Kh));
cmd.Parameters.Add(new SqlParameter("@TENKHO", TenKho));
cmd.Parameters.Add(new SqlParameter("@NGAYNHAP", NgayNh_Xu));
cmd.Parameters.Add(new SqlParameter("@GIA", Gia));
cmd.Parameters.Add(new SqlParameter("@TUNGAY", TuNgay));
cmd.Parameters.Add(new SqlParameter("@DENNGAY", DenNgay));
cmd.Connection = con;
cmd.ExecuteNonQuery();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
//ReportParameter tungay = new ReportParameter("Tungay", TuNgay);
//ReportParameter denngay = new ReportParameter("Denngay", DenNgay);
//ReportParameter tu = new ReportParameter("Tu", "Từ");
//ReportParameter den = new ReportParameter("Den", "Đến");
rpv_baocao.ProcessingMode = ProcessingMode.Local;
rpv_baocao.LocalReport.ReportPath = "BaoCaoNhap.rdlc";
if (ds.Tables[0].Rows.Count > 0)
{
ReportDataSource rds = new ReportDataSource();
rds.Name = "BaoCaoNhap";
rds.Value = ds.Tables[0];
rpv_baocao.LocalReport.DataSources.Clear();
rpv_baocao.LocalReport.DataSources.Add(rds);
//rpv_baocao.LocalReport.SetParameters(new ReportParameter[] { tu });
//rpv_baocao.LocalReport.SetParameters(new ReportParameter[] { den });
//rpv_baocao.LocalReport.SetParameters(new ReportParameter[] { tungay });
//rpv_baocao.LocalReport.SetParameters(new ReportParameter[] { denngay });
rpv_baocao.RefreshReport();
}
else
{
MessageBox.Show("Không Có Dữ Liệu!");
BaoCaoF bcf = new BaoCaoF();
bcf.Hide();
}
}
if (keyn == 2)
{
SqlConnection con = new SqlConnection();
string sql = @"Data Source=TRANG\SQLEXPRESS;Initial Catalog=QLKH;Integrated Security=True";
con.ConnectionString = sql;
con.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "BCX";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@TENNV", TenNv));
cmd.Parameters.Add(new SqlParameter("@TENSP", TenSp));
cmd.Parameters.Add(new SqlParameter("@TENKH", TenNcc_Kh));
cmd.Parameters.Add(new SqlParameter("@TENKHO", TenKho));
cmd.Parameters.Add(new SqlParameter("@NGAYXUAT", NgayNh_Xu));
cmd.Parameters.Add(new SqlParameter("@GIA", Gia));
cmd.Parameters.Add(new SqlParameter("@TUNGAY", TuNgay));
cmd.Parameters.Add(new SqlParameter("@DENNGAY", DenNgay));
cmd.Connection = con;
cmd.ExecuteNonQuery();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
rpv_baocao.ProcessingMode = ProcessingMode.Local;
rpv_baocao.LocalReport.ReportPath = "BaoCaoXuat.rdlc";
if (ds.Tables[0].Rows.Count > 0)
{
ReportDataSource rds = new ReportDataSource();
rds.Name = "BaoCaoXuat";
rds.Value = ds.Tables[0];
rpv_baocao.LocalReport.DataSources.Clear();
rpv_baocao.LocalReport.DataSources.Add(rds);
rpv_baocao.RefreshReport();
}
else
{
MessageBox.Show("Không Có Dữ Liệu!");
BaoCaoF bcf = new BaoCaoF();
bcf.Hide();
}
}
if (keyn == 3)
{
SqlConnection con = new SqlConnection();
string sql = @"Data Source=TRANG\SQLEXPRESS;Initial Catalog=QLKH;Integrated Security=True";
con.ConnectionString = sql;
con.Open();
acc.OpenConnect();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "HOADONBANHANG";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MAPX", MAPX));
cmd.Connection = con;
cmd.ExecuteNonQuery();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
rpv_baocao.ProcessingMode = ProcessingMode.Local;
rpv_baocao.LocalReport.ReportPath = "HoaDonBanHang.rdlc";
if (ds.Tables[0].Rows.Count > 0)
{
ReportDataSource rds = new ReportDataSource();
rds.Name = "HoaDonBanHang";
rds.Value = ds.Tables[0];
rpv_baocao.LocalReport.DataSources.Clear();
rpv_baocao.LocalReport.DataSources.Add(rds);
rpv_baocao.RefreshReport();
}
else
{
MessageBox.Show("Không Có Dữ Liệu!");
BaoCaoF bcf = new BaoCaoF();
bcf.Hide();
}
}
if (keyn == 4)
{
SqlConnection con = new SqlConnection();
string sql = @"Data Source=TRANG\SQLEXPRESS;Initial Catalog=QLKH;Integrated Security=True";
con.ConnectionString = sql;
con.Open();
acc.OpenConnect();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "HOADONMUAHANG";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@MAPN", MAPN));
cmd.Connection = con;
cmd.ExecuteNonQuery();
DataSet ds = new DataSet();
SqlDataAdapter sda = new SqlDataAdapter(cmd);
sda.Fill(ds);
rpv_baocao.ProcessingMode = ProcessingMode.Local;
rpv_baocao.LocalReport.ReportPath = "PhieuNhapKho.rdlc";
if (ds.Tables[0].Rows.Count > 0)
{
ReportDataSource rds = new ReportDataSource();
rds.Name = "PhieuNhapKho";
rds.Value = ds.Tables[0];
rpv_baocao.LocalReport.DataSources.Clear();
rpv_baocao.LocalReport.DataSources.Add(rds);
rpv_baocao.RefreshReport();
}
else
{
MessageBox.Show("Không Có Dữ Liệu!");
BaoCaoF bcf = new BaoCaoF();
bcf.Hide();
}
}
}
