private void btnSua_Click(object sender, EventArgs e)
{
ET_Kho k = new ET_Kho(txtMaKho.Text, txtTenKho.Text, dtpNgayNhap.Text, int.Parse(txtSLNhap.Text), dtpNgayXuat.Text, int.Parse(txtSoLuongXuat.Text), int.Parse(txtSoTon.Text), txtSoPhieu.Text);
if (kho.SuaKho(k) == true)
{
MessageBox.Show("Sửa thành công ");
}
else
{
MessageBox.Show("Sua khong thanh cong ");
}
load();
}
//cap nhat kho
public bool capNhapKho(ET_Kho k)
{
try
{
_cn.Open();
SqlCommand cmd = new SqlCommand("sp_capnhapKho", _cn);
cmd.CommandText = "sp_capnhapKho";
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter p_ma = new SqlParameter("@MaKho", k.MaKho);
cmd.Parameters.Add(p_ma);
SqlParameter p_ten = new SqlParameter("@TenKho", k.TenKho);
cmd.Parameters.Add(p_ten);
SqlParameter p_ngayNhap = new SqlParameter("@NgayNhapKho", k.NgayNhapKho);
cmd.Parameters.Add(p_ngayNhap);
SqlParameter p_slNhap = new SqlParameter("@SoLuongNhap", k.SoLuongNhap);
cmd.Parameters.Add(p_slNhap);
SqlParameter p_ngayXuat = new SqlParameter("@NgayXuat", k.NgayXuat);
cmd.Parameters.Add(p_ngayXuat);
SqlParameter p_slXuat = new SqlParameter("@SoLuongXuat", k.SoLuongXuat);
cmd.Parameters.Add(p_slXuat);
SqlParameter p_slTon = new SqlParameter("@SoLuongTon", k.SoLuongTon);
cmd.Parameters.Add(p_slTon);
SqlParameter p_soPhieu = new SqlParameter("@SoPhieu", k.SoPhieu);
cmd.Parameters.Add(p_soPhieu);
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
finally
{
_cn.Close();
}
}
private void btnThem_Click(object sender, EventArgs e)
{
ET_Kho k = new ET_Kho(txtMaKho.Text, txtTenKho.Text, dtpNgayNhap.Text, int.Parse(txtSLNhap.Text), dtpNgayXuat.Text, int.Parse(txtSoLuongXuat.Text), int.Parse(txtSoTon.Text), txtSoPhieu.Text);
if (kho.ThemKho(k) == true)
{
MessageBox.Show("Them thanh cong ");
txtMaKho.Text = "";
txtTenKho.Text = "";
dtpNgayNhap.Text = "";
dtpNgayXuat.Text = "";
txtSLNhap.Text = "";
txtSoLuongXuat.Text = "";
txtSoPhieu.Text = "";
txtSoTon.Text = "";
txtMaKho.Focus();
}
else
{
MessageBox.Show("Them khong thanh cong ");
}
load();
}
public bool SuaKho(ET_Kho k)
{
return(kho.capNhapKho(k));
}
public bool ThemKho(ET_Kho k)
{
return(kho.themKho(k));
}