/// <summary>
/// Cập nhật hàng hóa
/// </summary>
public static void Update(EHangHoa eHangHoa)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@MaHang", eHangHoa.MaHang),
new SqlParameter("@MaVach", eHangHoa.MaVach),
new SqlParameter("@TenHang", eHangHoa.TenHang),
new SqlParameter("@MaKho", eHangHoa.MaKho),
new SqlParameter("@MaNhomHangHoa", eHangHoa.MaNhomHangHoa),
new SqlParameter("@MaNCC", eHangHoa.MaNCC),
new SqlParameter("@MaDVT", eHangHoa.MaDVT),
new SqlParameter("@CreateID", eHangHoa.CreateID),
new SqlParameter("@CreateDate", eHangHoa.CreateDate),
new SqlParameter("@EditID", eHangHoa.EditID),
new SqlParameter("@EditDate", eHangHoa.EditDate),
};
DataAccess.excuteNonQuery("HangHoa_Update", CommandType.StoredProcedure, para);
}
catch (Exception ex)
{
throw ex;
}
}
private void FillData(EHangHoa eHangHoa)
{
if (eHangHoa == null)
{
txtMaHangHoa.Text = string.Empty;
txtTenHangHoa.Text = string.Empty;
txtMaVachNSX.Text = string.Empty;
cbbDVT.Text = null;
cbbKhoQuay.Text = null;
cbbNhomHang.Text = null;
txtMaHangHoa.Select();
txtMaHangHoa.Focus();
}
else
{
isAddnew = false;
txtMaHangHoa.Text = eHangHoa.MaHang;
txtTenHangHoa.Text = eHangHoa.TenHang;
txtMaVachNSX.Text = eHangHoa.MaVach;
cbbDVT.Text = eHangHoa.MaDVT.ToString();
cbbKhoQuay.Text = eHangHoa.MaKho.ToString();
cbbNhomHang.Text = eHangHoa.MaNhomHangHoa.ToString();
}
}
public FrmThongTinHangHoa(EHangHoa eHangHoa)
{
InitializeComponent();
txtMaHangHoa.Focus();
FillData(eHangHoa);
LoadDVT();
}
private void ThemHangHoa()
{
EHangHoa eHangHoa = new EHangHoa();
eHangHoa.MaHang = txtMaHangHoa.Text.Trim();
eHangHoa.TenHang = txtTenHangHoa.Text.Trim();
eHangHoa.MaDVT = Convert.ToInt32(cbbDVT.SelectedValue.ToString());
//eHangHoa.MaNhomHangHoa = Convert.ToInt32(cbbNhomHang.SelectedValue.ToString());
//eHangHoa.MaKho = Convert.ToInt32(cbbKhoQuay.SelectedValue.ToString());
eHangHoa.MaKho = 1;
eHangHoa.MaNhomHangHoa = 1;
eHangHoa.GiaNhap = Convert.ToDouble(txtGiaNhapHang.Text.Trim());
eHangHoa.GiaBan = Convert.ToDouble(txtGiaBanHang.Text.Trim());
eHangHoa.MaVach = txtMaVachNSX.Text.Trim();
eHangHoa.CreateDate = UnixTime.GetUnixTime(DateTime.Now);// dùng unix time
eHangHoa.CreateID = Session.MaNhanVien;
eHangHoa.MaNCC = 1;
eHangHoa.EditDate = UnixTime.GetUnixTime(DateTime.Now);
eHangHoa.EditID = Session.MaNhanVien;
try
{
BHangHoa.Insert(eHangHoa);
MessageBox.Show("Thêm thành công");
}
catch (Exception ex)
{
MessageBox.Show("Lỗi:" + ex.ToString());
}
}
/// <summary>
/// Ngừng kinh doanh
/// </summary>
public static void Delete(EHangHoa eHangHoa)
{
try
{
SqlParameter[] para =
{
new SqlParameter("@MaHang", eHangHoa.MaHang)
};
DataAccess.excuteNonQuery("HangHoa_Delete", CommandType.StoredProcedure, para);
}
catch (Exception ex)
{
throw ex;
}
}
private void CapNhatHangHoa()
{
EHangHoa eHangHoa = new EHangHoa();
eHangHoa.MaHang = txtMaHangHoa.Text.Trim();
eHangHoa.TenHang = txtTenHangHoa.Text.Trim();
eHangHoa.MaDVT = Convert.ToInt32(cbbDVT.SelectedValue.ToString());
//eHangHoa.MaNhomHangHoa = Convert.ToInt32(cbbNhomHang.SelectedValue.ToString());
//eHangHoa.MaKho = Convert.ToInt32(cbbKhoQuay.SelectedValue.ToString());
eHangHoa.MaNhomHangHoa = 1;
eHangHoa.MaKho = 1;
eHangHoa.GiaBan = Convert.ToDouble(txtGiaNhap.Text.Trim());
eHangHoa.MaVach = txtMaVach.Text.Trim();
try
{
BHangHoa.Update(eHangHoa);
MessageBox.Show("Cập nhật thành công");
}
catch (Exception ex)
{
MessageBox.Show("Lỗi:" + ex.ToString());
}
}
private void btnSua_Click(object sender, EventArgs e)
{
EHangHoa eHangHoa = new EHangHoa();
eHangHoa.EditID = Session.MaNhanVien;
}
/// <summary>
/// Ngừng kinh doanh
/// </summary>
public static void Delete(EHangHoa eHangHoa)
{
HangHoaDAO.Delete(eHangHoa);
}
/// <summary>
/// Cập nhật hàng hóa
/// </summary>
public static void Update(EHangHoa eHangHoa)
{
HangHoaDAO.Update(eHangHoa);
}
/// <summary>
/// Thêm mới hàng hóa
/// </summary>
public static void Insert(EHangHoa eHangHoa)
{
HangHoaDAO.Insert(eHangHoa);
}
