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