/// <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); }