public int AddHoaDon(vo_HoaDon hoaDon) { try { dao_HoaDon dao = new dao_HoaDon(); hoaDon.ThoiGian = Utilities.StandardTime(DateTime.Now.ToString()); int id = dao.InsertHoaDon(hoaDon); if (id > 0) { int row = dao.InsertChiTietHoaDon(hoaDon); return(row); } return(0); } catch (Exception ex) { throw ex; } }
public ObservableCollection <vo_HoaDon> getListHoaDon() { try { dao_HoaDon dao = new dao_HoaDon(); DataTable dtHoaDon = dao.getAllHoaDon(); ObservableCollection <vo_HoaDon> dsHoaDon = new ObservableCollection <vo_HoaDon>(); foreach (DataRow row in dtHoaDon.Rows) { vo_HoaDon hoadon = new vo_HoaDon(row["MAHOADONBANHANG"].ToString(), row["MAKHACHHANG"].ToString(), row["TENKHACHHANG"].ToString(), row["THOIGIAN"].ToString(), int.Parse(row["CANTHANHTOAN"].ToString()), int.Parse(row["TONGGIAM"].ToString()), int.Parse(row["DATRA"].ToString())); dsHoaDon.Add(hoadon); } ; return(dsHoaDon); } catch (Exception ex) { return(null); throw ex; } }
//tra về số chi tiết hàng hóa hóa đơn đã thêm thành công public int InsertChiTietHoaDon(params object[] oParams) { try { if (oParams != null) { vo_HoaDon vo_HD = (vo_HoaDon)oParams[0]; ObservableCollection <vo_HangHoaHoaDon> dsHangHoa = vo_HD.DsHangHoaHoaDon; ConnectionString cnn = new ConnectionString(); int soHangHoa = 0; foreach (vo_HangHoaHoaDon vo in dsHangHoa) { string query = "INSERT INTO CHITIETHOADON(MAHANGHOA, MAHOADONBANHANG, SOLUONG, DONGIA, GIAGIAM) OUTPUT 1" + "VALUES(@maHH, @maHD, @soLuong, @donGia, @giaGiam)"; string[] arrParam = new string[] { "@maHH", "@maHD", "@soLuong", "@donGia", "@giaGiam" }; SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.Int }; object[] arrvalues = new object[] { vo.MaHangHoa, vo_HD.MaHoaDon, vo.SoLuong, vo.DonGia, vo.GiaGiam }; cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType); string _query = "UPDATE HANGHOA SET TONKHO=@tonkho OUTPUT INSERTED.ID WHERE MAHANGHOA=@mahh"; ConnectionString _cnn = new ConnectionString(); string[] _arrParam = new string[] { "@tonkho", "@mahh" }; SqlDbType[] _arrType = new SqlDbType[] { SqlDbType.Int, SqlDbType.NVarChar }; object[] _arrvalues = new object[] { vo.TonKho, vo.MaHangHoa }; int id = cnn.conn.ExecuteQueryReturnID(_query, _arrParam, _arrvalues, _arrType); soHangHoa++; } return(soHangHoa); } return(0); } catch (Exception ex) { throw ex; } }
private void loadPage() { try { hoaDon = new vo_HoaDon(); //load danh sach hang hoa dsHangHoa = bus_hangHoa.GetAllHangHoa(); lvHangHoa.ItemsSource = dsHangHoa; //danh sach chi tiet hoa don dsHangHoaHoaDon = new ObservableCollection <vo_HangHoaHoaDon>(); gvHoaDon.ItemsSource = dsHangHoaHoaDon; //danh sach khach hang this.hoaDon.TenNhanVien = CurrentUser.User.HoTen; this.hoaDon.MaNhanVien = CurrentUser.User.MaNhanVien; hoaDon.MaHoaDon = bus_hoaDon.GenerateMaHoaDon(); this.hoaDon.ThoiGian = Utilities.DotNetToVietNam(DateTime.Now.ToString()); this.DataContext = hoaDon; } catch (Exception ex) { MessageBox.Show(ex.Message, "Loi!", MessageBoxButton.OK, MessageBoxImage.Error); } }
public int InsertHoaDon(params object[] oParams) { try { if (oParams != null) { vo_HoaDon vo = (vo_HoaDon)oParams[0]; ConnectionString cnn = new ConnectionString(); string query = "INSERT INTO HOADONBANHANG(MAHOADONBANHANG,MANHANVIEN,CANTHANHTOAN,DATRA,THOIGIAN,GHICHU,TONGGIAM,MAKHACHHANG) output INSERTED.ID " + "VALUES (@mahoadon, @manhanvien, @canthanhtoan, @datra, @thoigian, @ghichu, @tonggiam,@makhachhang)"; string[] arrParam = new string[] { "@mahoadon", "@manhanvien", "@canthanhtoan", "@datra", "@thoigian", "@ghichu", "@tonggiam", "@makhachhang" }; SqlDbType[] arrType = new SqlDbType[] { SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.Int, SqlDbType.NVarChar, SqlDbType.NVarChar, SqlDbType.Int, SqlDbType.NVarChar }; object[] arrvalues = new object[] { vo.MaHoaDon, vo.MaNhanVien, vo.CanThanhToan, vo.DaTra, vo.ThoiGian, vo.GhiChu, vo.TongGiam, vo.MaKhachHang }; return(cnn.conn.ExecuteQueryReturnID(query, arrParam, arrvalues, arrType)); } return(0); } catch (Exception ex) { throw ex; } }