public static void XoaNhaCungCap(string MaNCC) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "XoaNhaCungCap", new SqlParameter { ParameterName = "@ma", Value = MaNCC }); }
public static void SuaNhanVien(NhanVien kq) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaNhanVien", new SqlParameter { ParameterName = "@ma", Value = kq.Ma }, new SqlParameter { ParameterName = "@ten", Value = kq.Ten }, new SqlParameter { ParameterName = "@diachi", Value = kq.DiaChi }, new SqlParameter { ParameterName = "@dienthoai", Value = kq.DienThoai }, new SqlParameter { ParameterName = "@DiDong", Value = kq.DiDong }, new SqlParameter { ParameterName = "@email", Value = kq.Email }, new SqlParameter { ParameterName = "@conquanly", Value = kq.ConQL }, new SqlParameter { ParameterName = "@mabophan", Value = kq.MaBoPhan }); }
public static void SuaNhaCungCap(NhaCungCap kq) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaNhaCungCap", new SqlParameter { ParameterName = "@ma", Value = kq.MaNCC }, new SqlParameter { ParameterName = "@ten", Value = kq.TenNCC }, new SqlParameter { ParameterName = "@nguoilienhe", Value = kq.NguoiLienHe }, new SqlParameter { ParameterName = "@chucvu", Value = kq.ChucVu }, new SqlParameter { ParameterName = "@diachi", Value = kq.DiaChi }, new SqlParameter { ParameterName = "@DienThoai", Value = kq.DienThoai }, new SqlParameter { ParameterName = "@DiDong", Value = kq.DiDong }, new SqlParameter { ParameterName = "@fax", Value = kq.Fax }, new SqlParameter { ParameterName = "@conquanly", Value = kq.ConQL }, new SqlParameter { ParameterName = "@makhuvuc", Value = kq.MaKhuVuc }); }
public static void XoaTyGia(string Ma) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "XoaTyGia", new SqlParameter { ParameterName = "@ma", Value = Ma }); }
public static void XoaKhachHang(string MaKH) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "XoaKhachHang", new SqlParameter { ParameterName = "@ma", Value = MaKH }); }
public static void ThemHangHoa(HangHoa h) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "ThemHangHoa", new SqlParameter { ParameterName = "@ma", Value = h.MaHang }, new SqlParameter { ParameterName = "@ten", Value = h.TenHang }, new SqlParameter { ParameterName = "@giamua", Value = h.GiaMua }, new SqlParameter { ParameterName = "@giabansi", Value = h.GiaBanSi }, new SqlParameter { ParameterName = "@giabanle", Value = h.GiaBanLe }, new SqlParameter { ParameterName = "@tinhchat", Value = h.TinhChat }, new SqlParameter { ParameterName = "@conquanli", Value = h.ConQuanLi }, new SqlParameter { ParameterName = "@mavach", Value = h.MaVach }, new SqlParameter { ParameterName = "@manhomhang", Value = h.MaNhomHang }, new SqlParameter { ParameterName = "@makhohang", Value = h.MaKhoHang }, new SqlParameter { ParameterName = "@madonvi", Value = h.MaDonViTinh }, new SqlParameter { ParameterName = "@soluong", Value = h.SoLuong }, new SqlParameter { ParameterName = "@soluongton", Value = h.SoLuongTon }, new SqlParameter { ParameterName = "@tonkhotoithieu", Value = h.TonKhoToiThieu }, new SqlParameter { ParameterName = "@maNCC", Value = h.MaNCC }); }
public static void SuaTyGia(TyGia kq) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaTyGia", new SqlParameter { ParameterName = "@ma", Value = kq.Ma }, new SqlParameter { ParameterName = "@ten", Value = kq.Ten }, new SqlParameter { ParameterName = "@tygiaquydoi", Value = kq.TyGiaQuyDoi }, new SqlParameter { ParameterName = "@conquanly", Value = kq.ConQL }); }
public static void ThemVaiTro(VaiTro vt) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "ThemVaiTro", new SqlParameter { ParameterName = "@mavt", Value = vt.MaVaiTro }, new SqlParameter { ParameterName = "@tenvt", Value = vt.TenVaiTro }, new SqlParameter { ParameterName = "@diengiai", Value = vt.DienGiai }, new SqlParameter { ParameterName = "@kichhoat", Value = vt.KichHoat }); }
public static void ThemNhomHang(NhomHang kq) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "ThemNhomHang", new SqlParameter { ParameterName = "@ma", Value = kq.Ma }, new SqlParameter { ParameterName = "@ten", Value = kq.Ten }, new SqlParameter { ParameterName = "@ghichu", Value = kq.GhiChu }, new SqlParameter { ParameterName = "@conquanly", Value = kq.ConQL }); }
public static void SuaBoPhan(BoPhan kq) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaBoPhan", new SqlParameter { ParameterName = "@ma", Value = kq.Ma }, new SqlParameter { ParameterName = "@ten", Value = kq.Ten }, new SqlParameter { ParameterName = "@ghichu", Value = kq.GhiChu }, new SqlParameter { ParameterName = "@conquanly", Value = kq.ConQL }); }
public static void SuaKhuVuc(KhuVuc kv) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaKhuVuc", new SqlParameter { ParameterName = "@ma", Value = kv.MaKhuVuc }, new SqlParameter { ParameterName = "@ten", Value = kv.TenKhuVuc }, new SqlParameter { ParameterName = "@ghichu", Value = kv.GhiChu }, new SqlParameter { ParameterName = "@conquanly", Value = kv.ConQuanLi }); }
public static void SuaKhachHang(KhachHang kh) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "SuaKhachHang", new SqlParameter { ParameterName = "@ma", Value = kh.MaKH }, new SqlParameter { ParameterName = "@ten", Value = kh.TenKH }, new SqlParameter { ParameterName = "@nguoilienhe", Value = kh.NguoiLienHe }, new SqlParameter { ParameterName = "@diachi", Value = kh.DiaChi }, new SqlParameter { ParameterName = "@dienthoai", Value = kh.DienThoai }, new SqlParameter { ParameterName = "@didong", Value = kh.DiDong }, new SqlParameter { ParameterName = "@fax", Value = kh.Fax }, new SqlParameter { ParameterName = "@email", Value = kh.Email }, new SqlParameter { ParameterName = "@website", Value = kh.Website }, new SqlParameter { ParameterName = "@masothue", Value = kh.MaSoThue }, new SqlParameter { ParameterName = "@nganhang", Value = kh.TenNganHang }, new SqlParameter { ParameterName = "@conquanly", Value = kh.ConQuanLi }, new SqlParameter { ParameterName = "@makhuvuc", Value = kh.MaKhuVuc }, new SqlParameter { ParameterName = "@sotaikhoan", Value = kh.SoTaiKhoan }); }
public static void ThemNguoiDung(NguoiDung nd) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "ThemNguoiDung", new SqlParameter { ParameterName = "@tennd", Value = nd.TenNguoiDung }, new SqlParameter { ParameterName = "@tenhienthi", Value = nd.TenHienThi }, new SqlParameter { ParameterName = "@matkhau", Value = nd.MatKhau }, new SqlParameter { ParameterName = "@kichhoat", Value = nd.KichHoat }, new SqlParameter { ParameterName = "@mavaitro", Value = nd.MaVaiTro }); }
public static void ThemKhoHang(KhoHang kho) { XL_DULIEU.ThucThi(CommandType.StoredProcedure, "ThemKhoHang", new SqlParameter { ParameterName = "@makho", Value = kho.MaKho }, new SqlParameter { ParameterName = "@tenkho", Value = kho.TenKho }, new SqlParameter { ParameterName = "@nguoilienhe", Value = kho.NguoiLienHe }, new SqlParameter { ParameterName = "@diachi", Value = kho.DiaChi }, new SqlParameter { ParameterName = "@dienthoai", Value = kho.DienThoai }, new SqlParameter { ParameterName = "@fax", Value = kho.Fax }, new SqlParameter { ParameterName = "@email", Value = kho.Email }, new SqlParameter { ParameterName = "@kyhieu", Value = kho.KyHieu }, new SqlParameter { ParameterName = "@conquanli", Value = kho.ConQuanLi }, new SqlParameter { ParameterName = "@manguoiquanli", Value = kho.MaNguoiQuanLi }, new SqlParameter { ParameterName = "@ghichu", Value = kho.GhiChu }); }
public static DataTable LoadHangHoa() { return(XL_DULIEU.LayDuLieuTuBang("HangHoa")); }
public static DataTable LoadNhomHang() { string sql = "select Ma,Ten from NhomHang"; return(XL_DULIEU.LayDuLieu(sql)); }
public static DataTable LoadNhaCungCap() { string sql = "select MaSo,TenNhaCungCap from NhaCungCap"; return(XL_DULIEU.LayDuLieu(sql)); }
public static DataTable LoadMaKhachHang() { string sql = "select MaKH,TenKH from KhachHang"; return(XL_DULIEU.LayDuLieu(sql)); }
public static DataTable LayDuLieuKhuVuc() { return(XL_DULIEU.LayDuLieuTuBang("KhuVuc")); }
public static DataTable LayDuLieuKhachHang() { return(XL_DULIEU.LayDuLieuTuBang("KhachHang")); }
public static DataTable LayDuLieuNhanVien() { string sql = "select nv.Ma,nv.Ten,nv.DiaChi,nv.DienThoai,nv.DiDong,nv.Email,nv.ConQuanLy,bp.Ten as TenBoPhan from NhanVien nv left join BoPhan bp on nv.MaBoPhan=bp.Ma"; return(XL_DULIEU.LayDuLieu(sql)); }
public static DataTable LoadCbBoPhan() { string sql = "select Ma, Ten from BoPhan"; return(XL_DULIEU.LayDuLieu(sql)); }
public static DataTable LayThongTin(int maVaiTro) { string sql = "select * from VAITRO_CHUCNANG th,CHUCNANG cn where th.MaChucNang=cn.ID and th.MaVaiTro='" + maVaiTro + "'"; return(XL_DULIEU.LayDuLieu(sql)); }
public static DataTable HienThiQuyenHan() { string sql = "select cn.TenChucNang,th.TatCa,th.TruyCap,th.Them,th.Xoa,th.Sua,th.InAn,th.Nhap,th.Xuat from VAITRO_CHUCNANG th,CHUCNANG cn,NGUOIDUNG nd where cn.ID=th.MaChucNang and nd.MaVaiTro = th.MaVaiTro and nd.MaVaiTro=1"; return(XL_DULIEU.LayDuLieu(sql)); }
public static DataTable LayDuLieuNhomHang() { return(XL_DULIEU.LayDuLieuTuBang("NhomHang")); }
public static DataTable LayDuLieuKhoHang() { string sql = "select k.Ma,k.Ten,k.LienHe,k.DiaChi,k.DienThoai,k.ConQuanLy,nv.Ten as TenNV,k.Fax,k.Email,k.KyHieu,k.GhiChu from KhoHang k left join NhanVien nv on k.MaNguoiQuanLy=nv.Ma"; return(XL_DULIEU.LayDuLieu(sql)); }
public static DataTable LayDuLieuTyGia() { return(XL_DULIEU.LayDuLieuTuBang("TyGia")); }
public static DataTable LoadDonVi() { string sql = "select Ma,Ten from DonViTinh"; return(XL_DULIEU.LayDuLieu(sql)); }
public static DataTable LoadNhaCungCap() { string sql = "select ncc.MaSo,ncc.TenNhaCungCap,ncc.NguoiLienHe,ncc.ChucVu,ncc.DiaChi,ncc.DienThoai,ncc.DiDong,ncc.Fax,ncc.ConQuanLy,kv.Ten from NhaCungCap ncc,KhuVuc kv where ncc.MaKhuVuc = kv.Ma"; return(XL_DULIEU.LayDuLieu(sql)); }
public static DataTable LoadKhuVuc() { string sql = "select Ma,Ten from KhuVuc"; return(XL_DULIEU.LayDuLieu(sql)); }