private void TonKho_Load(object sender, EventArgs e)
{
string sql1 = "CapNhat";
string sql2 = "sp_TonKho";
string sql3 = "sp_Nhap";
string sql4 = "sp_Xuat";
try
{
if (acc.excuteNonQuery(sql1) == true)
{
DataTable ds1 = new DataTable();
DataTable ds2 = new DataTable();
DataTable ds3 = new DataTable();
SqlDataAdapter dap1 = acc.executeDatatable(sql2);
SqlDataAdapter dap2 = acc.executeDatatable(sql3);
SqlDataAdapter dap3 = acc.executeDatatable(sql4);
dap1.Fill(ds1);
dgvTonKho.DataSource = ds1;
dgvTonKho.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dap2.Fill(ds2);
dgvNhapHang.DataSource = ds2;
dgvNhapHang.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dap3.Fill(ds3);
dgvHangXuat.DataSource = ds3;
dgvHangXuat.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
txtTong1.Text = acc.executeScalar("select sum(a.Soluong) from SanPham a").ToString();
txtTong2.Text = acc.executeScalar("select sum(a.Soluong) from PhieuNhap a").ToString();
txtTong3.Text = acc.executeScalar("select sum(a.Soluong) from PhieuXuat a").ToString();
txtTien1.Text = ds1.Compute("Sum([Tổng giá])", "").ToString();
txtTien2.Text = ds2.Compute("Sum([Tổng giá])", "").ToString();
txtTien3.Text = ds3.Compute("Sum([Tổng giá])", "").ToString();
}
}
catch
{
MessageBox.Show("cap nhat khong thanh cong", "bao loi");
}
}
private void TonKho_Load(object sender, EventArgs e)
{
tbxSoLuong.Enabled = false;
tbxMaSP.Enabled = false;
tbxMaHSX.Enabled = false;
string sql = "select *from TonKho";
DataSet ds = new DataSet();
SqlDataAdapter dap = acc.executeDatatable(sql);
dap.Fill(ds);
dgvTonKho.DataSource = ds.Tables[0];
}
private void LoaiSP_Load(object sender, EventArgs e)
{
tbxMaLSP.Enabled = false;
tbxTenLSP.Enabled = false;
string sql = "select *from LoaiSP";
DataSet ds = new DataSet();
SqlDataAdapter dap = acc.executeDatatable(sql);
dap.Fill(ds);
dgvLoaiSP.DataSource = ds.Tables[0];
}
private void HangSanXuat_Load(object sender, EventArgs e)
{
tbxTenHSX.Enabled = false;
tbxMaHSX.Enabled = false;
tbxDiaChi.Enabled = false;
string sql = "select *from HangSX";
DataSet ds = new DataSet();
SqlDataAdapter dap = acc.executeDatatable(sql);
dap.Fill(ds);
dgvHangSanXuat.DataSource = ds.Tables[0];
}
private void CTPhieuXuat_Load(object sender, EventArgs e)
{
tbxSoLuong.Enabled = false;
dtNgayXuat.Enabled = false;
tbxMaSP.Enabled = false;
tbxMaPX.Enabled = false;
tbxMaNV.Enabled = false;
tbxDonGia.Enabled = false;
string sql = "select *from PhieuXuat";
DataSet ds = new DataSet();
SqlDataAdapter dap = acc.executeDatatable(sql);
dap.Fill(ds);
dgvPhieuXuat.DataSource = ds.Tables[0];
}
private void CTPhieuBH_Load(object sender, EventArgs e)
{
tbxMaPBH.Enabled = false;
tbxMaSP.Enabled = false;
tbxTGBH.Enabled = false;
tbxMaNV.Enabled = false;
dtNgayLap.Enabled = false;
string sql = "select *from PhieuBH";
DataSet ds = new DataSet();
SqlDataAdapter dap = acc.executeDatatable(sql);
dap.Fill(ds);
dgvPhieuBH.DataSource = ds.Tables[0];
}
private void NhanVien_Load(object sender, EventArgs e)
{
tbxMaNV.Enabled = false;
tbxHoTen.Enabled = false;
tbxDiaChi.Enabled = false;
tbxSoDienThoai.Enabled = false;
cbxGioiTinh.Enabled = false;
dtNgaySinh.Enabled = false;
string sql = "select *from NhanVien";
DataSet ds = new DataSet();
SqlDataAdapter dap = acc.executeDatatable(sql);
dap.Fill(ds);
dgvNhanVien.DataSource = ds.Tables[0];
dgvNhanVien.Refresh();
}
private void btnTim_Click(object sender, EventArgs e)
{
try {
string sql = "SELECT *FROM SanPham WHERE MaSP='" + tbxMaSP.Text + "';";
SqlDataAdapter dap = acc.executeDatatable(sql);
DataSet ds = new DataSet();
DataTable dtbTimKiem = new DataTable();
dap.Fill(ds);
dgvTimKiem.DataSource = ds.Tables[0];
dgvTimKiem.Refresh();
}
catch (Exception)
{
MessageBox.Show("error");
}
}
private void SanPham_Load(object sender, EventArgs e)
{
tbxBaoHanh.Enabled = false;
tbxGiaBan.Enabled = false;
tbxMaHSX.Enabled = false;
tbxMaLSP.Enabled = false;
tbxMaSP.Enabled = false;
tbxTenSP.Enabled = false;
tbxTinhNang.Enabled = false;
string sql = "select *from SanPham";
DataSet ds = new DataSet();
SqlDataAdapter dap = acc.executeDatatable(sql);
dap.Fill(ds);
dataGridView1.DataSource = ds.Tables[0];
}
private void btnTim_Click(object sender, EventArgs e)
{
try
{
switch (cbTimKiem.Text)
{
case "Mã sản phẩm":
{
string sql = "SELECT *FROM SanPham WHERE MaSP like N'%" + txtNhap.Text + "%'";
DataTable ds = new DataTable();
SqlDataAdapter da = acc.executeDatatable(sql);
da.Fill(ds);
dgvTimKiem.DataSource = ds;
dgvTimKiem.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvTimKiem.Refresh();
break;
}
case "Tên sản phẩm":
{
string sql = "SELECT *FROM SanPham WHERE TenSP like N'%" + txtNhap.Text + "%'";
DataTable ds = new DataTable();
SqlDataAdapter da = acc.executeDatatable(sql);
da.Fill(ds);
dgvTimKiem.DataSource = ds;
dgvTimKiem.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvTimKiem.Refresh();
break;
}
case "Loại sản phẩm":
{
string sql = "SELECT *FROM SanPham WHERE MaLSP like N'%" + txtNhap.Text + "%'";
DataTable ds = new DataTable();
SqlDataAdapter da = acc.executeDatatable(sql);
da.Fill(ds);
dgvTimKiem.DataSource = ds;
dgvTimKiem.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvTimKiem.Refresh();
break;
}
case "Hãng sản xuất":
{
string sql = "SELECT *FROM SanPham WHERE MaHSX like N'%" + txtNhap.Text + "%'";
DataTable ds = new DataTable();
SqlDataAdapter da = acc.executeDatatable(sql);
da.Fill(ds);
dgvTimKiem.DataSource = ds;
dgvTimKiem.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvTimKiem.Refresh();
break;
}
}
}
catch (Exception)
{
MessageBox.Show("error");
}
//try {
// string sql = "SELECT *FROM SanPham WHERE MaSP='" + tbxMaSP.Text + "';";
// SqlDataAdapter dap = acc.executeDatatable(sql);
// DataSet ds = new DataSet();
// DataTable dtbTimKiem = new DataTable();
// dap.Fill(ds);
// dgvTimKiem.DataSource = ds.Tables[0];
// dgvTimKiem.Refresh();
//}
//catch (Exception)
//{
// MessageBox.Show("error");
//}
}
