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