public bool ThemBanHang(ref string err, BanHangO bh)
{
return(conn.MyExecuteNonQuery("proThemBanHang",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaPhieuBan", bh.MaPhieuBan),
new SqlParameter("@TenPhieu", bh.TenPhieu),
new SqlParameter("@NgayLapPhieu", bh.NgayLapPhieu),
new SqlParameter("@MaKieuThanhToan", bh.MaKieuTT),
new SqlParameter("@MaHinhThuc", bh.MaHinhThucTT),
new SqlParameter("@ThoiHanThanhToan", bh.ThoiHanThanhToan),
new SqlParameter("@MaKhachHang", bh.MaKhachHang),
new SqlParameter("@NgayGiaoHang", bh.NgayGiaoHang),
new SqlParameter("@MaNhanVien", bh.MaNhanVien),
new SqlParameter("@MaKho", bh.MaKho),
new SqlParameter("@GhiChu", bh.GhiChu),
new SqlParameter("@TongTien", bh.TongTien),
new SqlParameter("@PTramCK", bh.PTramCK),
new SqlParameter("@Thue", bh.Thue),
new SqlParameter("@TuongDuongTien", bh.TuongDuongTien),
new SqlParameter("@TienThanhToan", bh.TienThanhToan)
));
}
public bool ThemNhaCungCap(ref string err, NhaCungCapO ncc)
{
return(conn.MyExecuteNonQuery("proThemNhaCungCap",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaNhaCungCap", ncc.MaNhaCungCap),
new SqlParameter("@TenNhaCungCap", ncc.TenNhaCungCap),
new SqlParameter("@MaKhuVuc", ncc.MaKhuVuc),
new SqlParameter("@DiaChi", ncc.DiaChi),
new SqlParameter("@MaSoThue", ncc.MaSoThue),
new SqlParameter("@Fax", ncc.Fax),
new SqlParameter("@SoDienThoai", ncc.SoDienThoai),
new SqlParameter("@SoDiDong", ncc.SoDiDong),
new SqlParameter("@Email", ncc.Email),
new SqlParameter("@Website", ncc.Website),
new SqlParameter("@TaiKhoan", ncc.TaiKhoan),
new SqlParameter("@NganHang", ncc.NganHang),
new SqlParameter("@GioiHanNo", ncc.GioiHanNo),
new SqlParameter("@NoHienTai", ncc.NoHienTai),
new SqlParameter("@ChietKhau", ncc.ChietKhau),
new SqlParameter("@NguoiLienHe", ncc.NguoiLienHe),
new SqlParameter("@ChucVu", ncc.ChucVu),
new SqlParameter("@ThongTinKhac", ncc.ThongTinKhac),
new SqlParameter("@ConQuanLy", ncc.ConQuanLy)
));
}
public bool ThemKhachHang(ref string err, KhachHangO kh)/*, int SiOrLe, string MaKhachHang, string MaKhuVuc,
* string TenKhachHang, string DiaChi, string MaSoThue, string Fax, string SoDienThoai, string SoDiDong,
* string Email, string Website, string TaiKhoan, string NganHang, double GioiHanNo, double NoHienTai, float ChietKhau,
* string NguoiLienHe, string ThongTinKhac)*/
{
return(conn.MyExecuteNonQuery("proThemKhachHang",
CommandType.StoredProcedure, ref err,
new SqlParameter("@SiOrLe", kh.SiOrLe),
new SqlParameter("@MaKhachHang", kh.MaKhachHang),
new SqlParameter("@MaKhuVuc", kh.MaKhuVuc),
new SqlParameter("@TenKhachHang", kh.TenKhachHang),
new SqlParameter("@DiaChi", kh.DiaChi),
new SqlParameter("@MaSoThue", kh.MaSoThue),
new SqlParameter("@Fax", kh.Fax),
new SqlParameter("@SoDienThoai", kh.SoDienThoai),
new SqlParameter("@SoDiDong", kh.SoDiDong),
new SqlParameter("@Email", kh.Email),
new SqlParameter("@Website", kh.Website),
new SqlParameter("@TaiKhoan", kh.TaiKhoan),
new SqlParameter("@NganHang", kh.NganHang),
new SqlParameter("@GioiHanNo", kh.GioiHanNo),
new SqlParameter("@NoHienTai", kh.NoHienTai),
new SqlParameter("@ChietKhau", kh.ChietKhau),
new SqlParameter("@NguoiLienHe", kh.NguoiLienHe),
new SqlParameter("@ThongTinKhac", kh.ThongTinKhac),
new SqlParameter("@ConQuanLy", kh.ConQuanLy)
));
}
public bool ThemBoPhan(ref string err, BoPhanO bp)
{
return(conn.MyExecuteNonQuery("proThemBoPhan",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaBoPhan", bp.MaBoPhan),
new SqlParameter("@TenBoPhan", bp.TenBoPhan),
new SqlParameter("@GhiChu", bp.GhiChu),
new SqlParameter("@ConQuanLy", bp.ConQuanLy)
));
}
public bool ThemNhomHang(ref string err, NhomHangO nh)
{
return(conn.MyExecuteNonQuery("proThemNhomHang",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaNhomHang", nh.MaNhomHang),
new SqlParameter("@TenNhomHang", nh.TenNhomHang),
new SqlParameter("@GhiChu", nh.GhiChu),
new SqlParameter("@ConQuanLy", nh.ConQuanLy)
));
}
public bool ThemKhuVuc(ref string err, KhuVucO kv)// string MaKhuVuc, string TenKhuVuc, string GhiChu,int ConQuanLy)
{
return(conn.MyExecuteNonQuery("proThemKhuVuc",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaKhuVuc", kv.MaKhuVuc),
new SqlParameter("@TenKhuVuc", kv.TenKhuVuc),
new SqlParameter("@GhiChu", kv.GhiChu),
new SqlParameter("@ConQuanLy", kv.ConQuanLy)
));
}
public bool ThemDonVi(ref string err, DonViO dv)
{
return(conn.MyExecuteNonQuery("proThemDonVi",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaDonVi", dv.MaDonVi),
new SqlParameter("@TenDonVi", dv.TenDonVi),
new SqlParameter("@GhiChu", dv.GhiChu),
new SqlParameter("@ConQuanLy", dv.ConQuanLy)
));
}
public bool ThemChiTietPhieuBanHang(ref string err, ChiTietPhieuBanHangO ctpbh)
{
return(conn.MyExecuteNonQuery("proThemChiTietPhieuBan",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaChiTietPhieuBan", ctpbh.MaChiTietPhieuBan),
new SqlParameter("@MaPhieuBan", ctpbh.MaPhieuBan),
new SqlParameter("@MaHangHoa", ctpbh.MaHangHoa),
new SqlParameter("@SoLuong", ctpbh.SoLuong),
new SqlParameter("@DonGia", ctpbh.DonGia),
new SqlParameter("@ThanhTien", ctpbh.ThanhTien)
));
}
public bool ThemChuyenKho(ref string err, ChuyenKhoO ck)
{
return(conn.MyExecuteNonQuery("proThemChuyenKho",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaPhieuChuyen", ck.MaPhieuChuyen),
new SqlParameter("@NgayLapPhieu", ck.NgayLapPhieu),
new SqlParameter("@GhiChu", ck.GhiChu),
new SqlParameter("@MaKhoChuyen", ck.MaKhoChuyen),
new SqlParameter("@MaKhoNhan", ck.MaKhoNhan),
new SqlParameter("@MaNguoiChuyen", ck.MaNguoiChuyen),
new SqlParameter("@MaNguoiNhan", ck.MaNguoiNhan)
));
}
public bool ThemNhanVien(ref string err, NhanVienO nv)
{
return(conn.MyExecuteNonQuery("proThemNhanVien",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaNhanVien", nv.MaNhanVien),
new SqlParameter("@TenNhanVien", nv.TenNhanVien),
new SqlParameter("@ChucVu", nv.ChucVu),
new SqlParameter("@DiaChi", nv.DiaChi),
new SqlParameter("@SoDienThoai", nv.SoDienThoai),
new SqlParameter("@SoDiDong", nv.SoDiDong),
new SqlParameter("@Email", nv.Email),
new SqlParameter("@MaBoPhan", nv.MaBoPhan),
new SqlParameter("@MaNguoiQuanLy", nv.MaNguoiQuanLy),
new SqlParameter("@ConQuanLy", nv.ConQuanLy)
));
}
public bool ThemKho(ref string err, KhoO k)// string MaKhuVuc, string TenKhuVuc, string GhiChu,int ConQuanLy)
{
return(conn.MyExecuteNonQuery("proThemKho",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaKho", k.MaKho),
new SqlParameter("@TenKho", k.TenKho),
new SqlParameter("@MaNguoiQuanLy", k.MaNguoiQuanLy),
new SqlParameter("@KyHieu", k.KyHieu),
new SqlParameter("@NguoiLienHe", k.NguoiLienHe),
new SqlParameter("@DiaChi", k.DiaChi),
new SqlParameter("@Fax", k.Fax),
new SqlParameter("@SoDienThoai", k.SoDienThoai),
new SqlParameter("@Email", k.Email),
new SqlParameter("@DienGiai", k.DienGiai),
new SqlParameter("@ConQuanLy", k.ConQuanLy)
));
}
public bool ThemHangHoa(ref string err, HangHoaO hh)
{
return(conn.MyExecuteNonQuery("proThemHangHoa",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaHangHoa", hh.MaHangHoa),
new SqlParameter("@TenHangHoa", hh.TenHangHoa),
new SqlParameter("@MaKho", hh.MaKho),
new SqlParameter("@MaNhomHang", hh.MaNhomHang),
new SqlParameter("@MaVachNSX", hh.MaVachNSX),
new SqlParameter("@MaDonVi", hh.MaDonVi),
new SqlParameter("@XuatXu", hh.XuatXu),
new SqlParameter("@Thue", hh.Thue),
new SqlParameter("@TonKhoToiThieu", hh.TonKhoToiThieu),
new SqlParameter("@TonHienTai", hh.TonHienTai),
new SqlParameter("@MaNhaCungCap", hh.MaNhaCungCap),
new SqlParameter("@GiaMua", hh.GiaMua),
new SqlParameter("@GiaBanSi", hh.GiaBanSi),
new SqlParameter("@GiaBanLe", hh.GiaBanLe),
new SqlParameter("@HangHoaOrDichVu", hh.HangHoaOrDichVu),
new SqlParameter("@ConQuanLy", hh.ConQuanLy)
));
}
public bool ThemTonKho(ref string err, TonKhoO tk)
{
return(conn.MyExecuteNonQuery("proThemTonKho",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaHangHoa", tk.MaHangHoa),
new SqlParameter("@MaKho", tk.MaKho),
new SqlParameter("@SoLuong", tk.SoLuong)
));
}
public bool ThemMuaHang(ref string err, MuaHangO mh)
{
return(conn.MyExecuteNonQuery("proThemMuaHang",
CommandType.StoredProcedure, ref err,
new SqlParameter("@MaPhieu", mh.MaPhieu),
new SqlParameter("@TenPhieu", mh.TenPhieu),
new SqlParameter("@NgayLapPhieu", mh.NgayLapPhieu),
new SqlParameter("@SoHoaDonVAT", mh.SoHoaDonVAT),
new SqlParameter("@SoPhieuVietTay", mh.SoPhieuVietTay),
new SqlParameter("@MaThanhToan", mh.MaThanhToan),
new SqlParameter("@MaHinhThuc", mh.MaHinhThuc),
new SqlParameter("@MaNhaCungCap", mh.MaNhaCungCap),
new SqlParameter("@ThoiHanThanhToan", mh.ThoiHanThanhToan),
new SqlParameter("@GhiChu", mh.GhiChu),
new SqlParameter("@MaNhanVien", mh.MaNhanVien),
new SqlParameter("@MaKho", mh.MaKho),
new SqlParameter("@TongTien", mh.TongTien),
new SqlParameter("@PTramCK", mh.PTramCK),
new SqlParameter("@Thue", mh.Thue),
new SqlParameter("@TuongDuongTien", mh.TuongDuongTien),
new SqlParameter("@TienThanhToan", mh.TienThanhToan)
));
}
