private void btnThem_Click(object sender, RoutedEventArgs e) { try { this.vo_HH.IdLoaiHangHoa = int.Parse(this.cboLoaiHH.SelectedValue.ToString()); if (string.IsNullOrEmpty(this.vo_HH.TenHangHoa)) { MessageBox.Show("Chưa nhập tên hàng hóa", "Loi!", MessageBoxButton.OK, MessageBoxImage.Warning); return; } if (this.vo_HH.IdLoaiHangHoa == 0) { //this.vo_HH.IdLoaiHangHoa = -1; MessageBox.Show("Chưa chọn loại hàng hóa", "Loi!", MessageBoxButton.OK, MessageBoxImage.Warning); } int id = this.bus_HH.AddHangHoa(vo_HH); if (id > 0) { MessageBox.Show("Them hang hoa thanh cong!", "Loi!", MessageBoxButton.OK, MessageBoxImage.Information); this.vo_HH = new vo_HangHoa(); this.initValue(); } else { MessageBox.Show("Them hang hoa that bai!", "Loi!", MessageBoxButton.OK, MessageBoxImage.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error); } }
public int UpdateHangHoa(params object[] oParams) { try { if (oParams != null) { vo_HangHoa vo = (vo_HangHoa)oParams[0]; string query = "UPDATE HANGHOA SET MAHANGHOA=@mahh, TENHANGHOA=@tenhh, GIABAN=@giaban, GIAVON=@giavon, TONKHO=@tonkho" + ", URL_IMAGE=@image, ID_LOAIHANGHOA=@idloaihh, GIAGIAM=@giagiam OUTPUT INSERTED.ID WHERE ID=@id"; ConnectionString cnn = new ConnectionString(); string[] arrParam = new string[] { "@mahh", "@tenhh", "@giaban", "@giavon", "@tonkho", "@image", "@ghichu", "@idloaihh", "@giagiam", "@id" }; SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.Int, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.Int }; object[] arrvalues = new object[] { vo.MaHangHoa, vo.TenHangHoa, vo.GiaBan, vo.GiaVon, vo.TonKho, vo.UrlImage, vo.GhiChu, vo.IdLoaiHangHoa, vo.GiaGiam, vo.Id }; int id = cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType); return(id); } return(0); } catch (Exception ex) { throw ex; } }
public pl_windowThemHangHoa(vo_HangHoa _voHH) { try { bus_HH = new bus_HangHoa(); this.vo_HH = _voHH; bus_LoaiHH = new bus_LoaiHangHoa(); this.cancelFlag = 1; InitializeComponent(); this.tenHH.IsEnabled = false; this.giaBan.IsEnabled = false; this.giaGiam.IsEnabled = false; this.giaVon.IsEnabled = false; this.ghiChu.IsEnabled = false; this.cboLoaiHH.IsEnabled = false; this.tonKho.IsEnabled = false; this.btnDoiAnh.IsEnabled = false; this.btnThem.Visibility = Visibility.Hidden; this.cboLoaiHH.ItemsSource = this.bus_LoaiHH.getAllLoaiHangHoa(); this.cboLoaiHH.SelectedValue = vo_HH.IdLoaiHangHoa; this.DataContext = this.vo_HH; } catch (Exception ex) { MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error); } }
public ObservableCollection <vo_HangHoa> GetAllHangHoa() { try { dao_HangHoa dao = new dao_HangHoa(); DataTable dt = dao.getAllHangHoa(); ObservableCollection <vo_HangHoa> dsHangHoa = new ObservableCollection <vo_HangHoa>(); foreach (DataRow dr in dt.Rows) { vo_HangHoa vo = new vo_HangHoa(); vo.Id = int.Parse(dr["ID"].ToString()); vo.IdLoaiHangHoa = int.Parse(dr["ID_LOAIHANGHOA"].ToString()); vo.LoaiHangHoa = dr["LOAIHANGHOA"].ToString(); vo.GiaVon = int.Parse(dr["GIAVON"].ToString()); vo.GiaBan = int.Parse(dr["GIABAN"].ToString()); vo.GiaGiam = int.Parse(dr["GIAGIAM"].ToString()); vo.GhiChu = dr["GHICHU"].ToString(); vo.MaHangHoa = dr["MAHANGHOA"].ToString(); vo.TenHangHoa = dr["TENHANGHOA"].ToString(); vo.UrlImage = dr["URL_IMAGE"].ToString(); vo.TonKho = int.Parse(dr["TONKHO"].ToString()); dsHangHoa.Add(vo); } return(dsHangHoa); } catch (Exception ex) { throw ex; } }
public int InsertHangHoa(params object[] oParams) { try { if (oParams != null) { vo_HangHoa vo = (vo_HangHoa)oParams[0]; ConnectionString cnn = new ConnectionString(); string query = "INSERT INTO HANGHOA (MAHANGHOA, TENHANGHOA, GIABAN, GIAVON, TONKHO, URL_IMAGE, GHICHU, ID_LOAIHANGHOA, GIAGIAM) " + "output INSERTED.ID VALUES(@mahh, @tenhh, @giaban, @giavon, @tonkho, @image, @ghichu, @idloaihh, @giagiam)"; string[] arrParam = new string[] { "@mahh", "@tenhh", "@giaban", "@giavon", "@tonkho", "@image", "@ghichu", "@idloaihh", "@giagiam" }; SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.Int, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int }; object[] arrvalues = new object[] { vo.MaHangHoa, vo.TenHangHoa, vo.GiaBan, vo.GiaVon, vo.TonKho, vo.UrlImage, vo.GhiChu, vo.IdLoaiHangHoa, vo.GiaGiam }; return(cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType)); } return(0); } catch (Exception ex) { throw ex; } }
public vo_HangHoa getHangHoaById(int _id) { try { dao_HangHoa dao = new dao_HangHoa(); vo_HangHoa vo = new vo_HangHoa(); DataTable dt = dao.GetHangHoaById(_id); vo.Id = int.Parse(dt.Rows[0]["ID"].ToString()); vo.IdLoaiHangHoa = int.Parse(dt.Rows[0]["ID_LOAIHANGHOA"].ToString()); vo.LoaiHangHoa = dt.Rows[0]["LOAIHANGHOA"].ToString(); vo.GiaVon = int.Parse(dt.Rows[0]["GIAVON"].ToString()); vo.GiaBan = int.Parse(dt.Rows[0]["GIABAN"].ToString()); vo.GiaGiam = int.Parse(dt.Rows[0]["GIAGIAM"].ToString()); vo.GhiChu = dt.Rows[0]["GHICHU"].ToString(); vo.MaHangHoa = dt.Rows[0]["MAHANGHOA"].ToString(); vo.TenHangHoa = dt.Rows[0]["TENHANGHOA"].ToString(); vo.UrlImage = dt.Rows[0]["URL_IMAGE"].ToString(); vo.TonKho = int.Parse(dt.Rows[0]["TONKHO"].ToString()); return(vo); } catch (Exception ex) { throw ex; } }
protected void handleDownProduct(object sender, MouseButtonEventArgs e) { vo_HangHoa track = ((ListViewItem)sender).Content as vo_HangHoa; //Casting back to the binded Track this.dsHangHoaCuaPhieuNhap.Add(track); this.TinhToanPhieuNhap(); return; }
private void TableView_CellValueChanged(object sender, DevExpress.Xpf.Grid.CellValueChangedEventArgs e) { try { vo_HangHoa row = (vo_HangHoa)this.iGridViewPhieuNhap.SelectedItem; this.TinhToanPhieuNhap(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Lỗi!", MessageBoxButton.OK, MessageBoxImage.Information); } }
private void TableView_RowDoubleClick(object sender, DevExpress.Xpf.Grid.RowDoubleClickEventArgs e) { try { vo_HangHoa _vo = (vo_HangHoa)this.iGridViewPhieuNhap.SelectedItem; pl_windowThemHangHoa _plThemHH = new pl_windowThemHangHoa(_vo); _plThemHH.ShowDialog(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error); } }
public int UpdateHangHoa(vo_HangHoa _vo) { try { dao_HangHoa _dao = new dao_HangHoa(); int id = _dao.UpdateHangHoa(_vo); return(id); } catch (Exception ex) { throw ex; } }
public int AddHangHoa(vo_HangHoa vo) { try { dao_HangHoa dao = new dao_HangHoa(); int id = dao.InsertHangHoa(vo); return(id); } catch (Exception ex) { throw ex; } }
private void btnThoat_Click(object sender, RoutedEventArgs e) { try { if (this.cancelFlag != 0) { this.Close(); return; } this.vo_HH = new vo_HangHoa(); this.initValue(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error); } }
public pl_windowThemHangHoa() { try { bus_HH = new bus_HangHoa(); vo_HH = new vo_HangHoa(); bus_LoaiHH = new bus_LoaiHangHoa(); InitializeComponent(); this.lblLuu.Content = " Lưu"; this.btnLuu.Visibility = Visibility.Hidden; this.initValue(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error); } }
protected void handleDownProduct(object sender, MouseButtonEventArgs e) { vo_HangHoa hangHoa = ((ListViewItem)sender).Content as vo_HangHoa; vo_HangHoaHoaDon hangHoaHD = new vo_HangHoaHoaDon(hangHoa.MaHangHoa, hangHoa.TenHangHoa, 1, hangHoa.GiaBan, hangHoa.GiaGiam, hangHoa.TonKho); dsHangHoaHoaDon.Add(hangHoaHD); int tongHD = 0; int tongGiamHD = 0; foreach (vo_HangHoaHoaDon item in dsHangHoaHoaDon) { tongHD += item.ThanhTien; tongGiamHD += item.TongGiamChiTiet; } hoaDon.TongTienHang = tongHD; hoaDon.TongGiam = tongGiamHD; return; }
private void deleteRowItem_ItemClick(object sender, DevExpress.Xpf.Bars.ItemClickEventArgs e) { try { vo_HangHoa _vo = (vo_HangHoa)this.iGridViewPhieuNhap.SelectedItem; if (MessageBox.Show("Bạn có muốn xóa hàng hóa" + _vo.TenHangHoa + " ra khỏi kho", "Xác nhận", MessageBoxButton.YesNo, MessageBoxImage.Question) == MessageBoxResult.No) { return; } int _id = this.bus_HH.DeleteHangHoa(_vo.Id); if (_id > 0) { this.dsHangHoa = this.bus_HH.GetAllHangHoa(); this.iGridViewPhieuNhap.ItemsSource = this.dsHangHoa; MessageBox.Show("Đã xpas " + _vo.TenHangHoa + "ra khỏi kho", "Thông báo", MessageBoxButton.OK, MessageBoxImage.Information); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error); } }
// lay chi tiet phieu nhap hang public vo_PhieuNhapHang GetChiTietPhieuNhapHang(string _code) { try { dao_PhieuNhapHang dao = new dao_PhieuNhapHang(); vo_PhieuNhapHang vo_phieuNhap = new vo_PhieuNhapHang(); //lay thong tin phieu nhap DataTable dt = dao.GetPhieuNhapById(_code); if (dt != null && dt.Rows.Count > 0) { vo_phieuNhap.DaTra = int.Parse(dt.Rows[0]["DATRA"].ToString()); vo_phieuNhap.GhiChu = dt.Rows[0]["GHICHU"].ToString(); vo_phieuNhap.Id = int.Parse(dt.Rows[0]["ID"].ToString()); vo_phieuNhap.MaNhaCungCap = dt.Rows[0]["MANHACUNGCAP"].ToString(); vo_phieuNhap.NhaCungCap = dt.Rows[0]["TENNHACUNGCAP"].ToString(); vo_phieuNhap.MaNhanVien = dt.Rows[0]["MANHANVIEN"].ToString(); vo_phieuNhap.TenNhanVien = dt.Rows[0]["HOTEN"].ToString(); vo_phieuNhap.MaPhieuNhap = dt.Rows[0]["MAPHIEUNHAP"].ToString(); vo_phieuNhap.ThoiGian = Utilities.DotNetToVietNam(dt.Rows[0]["THOIGIAN"].ToString()); vo_phieuNhap.TongGiam = int.Parse(dt.Rows[0]["TONGGIAM"].ToString()); vo_phieuNhap.TongTien = int.Parse(dt.Rows[0]["TONGTIENCANTRA"].ToString()); vo_phieuNhap.DsHangHoa = new ObservableCollection <vo_HangHoa>(); } // lay danh sach hang hoa trong phieu nhap DataTable dtDsHangHoa = dao.GetDanhSachHangHoaByPhieuNhap(_code); if (dtDsHangHoa != null && dtDsHangHoa.Rows.Count > 0) { foreach (DataRow dr in dtDsHangHoa.Rows) { vo_HangHoa vo = new vo_HangHoa(); // lay nhung du lieu can thiet vo.MaHangHoa = dr["MAHANGHOA"].ToString(); vo.TenHangHoa = dr["TENHANGHOA"].ToString(); vo.SoLuong = int.Parse(dr["SOLUONG"].ToString()); //don gia vo.GiaVon = int.Parse(dr["DONGIA"].ToString()); //gia giam if (string.IsNullOrEmpty(dr["GIAGIAM"].ToString())) { vo.GiaGiam = 0; } else { vo.GiaGiam = int.Parse(dr["GIAGIAM"].ToString()); } vo.LoaiHangHoa = dr["LOAIHANGHOA"].ToString(); vo_phieuNhap.DsHangHoa.Add(vo); } } return(vo_phieuNhap); } catch (Exception ex) { throw ex; } }