public static DataTable DuLieuHinhThucThanhToan()
{
return(DL_LayDuLieu.LayDuLieuTuBang("HINHTHUCTHANHTOAN"));
}
//them nhom hang
public static bool NhomHangThem(string ma, string ten)
{
string sql = string.Format("Insert into NHOMHANG(MaNhomHang,TenNhomHang) Values('{0}','{1}')", ma, ten);
return(DL_LayDuLieu.InsertSQL(sql));
}
//xoa
public static bool NhomHangXoa(string ma)
{
string sql = string.Format("Delete From NHOMHANG where MaNhomHang='{0}'", ma);
return(DL_LayDuLieu.DeleteSQL(sql));
}
//them
public static bool CTPhieuXuatThem(string MaChiTietXuat, string MaPhieuXuat, string MaSP, string MaKho, float DonGiaSP, double ThanhTien, float Thue, int SoLuongMua)
{
string sql = string.Format("Insert into CTPHIEUXUAT(MaChiTietXuat,MaPhieuXuat,MaSP,MaKho,DonGiaSP,ThanhTien,Thue,SoLuongMua) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", MaChiTietXuat, MaPhieuXuat, MaSP, MaKho, DonGiaSP, ThanhTien, Thue, SoLuongMua);
return(DL_LayDuLieu.InsertSQL(sql));
}
//doi mat khau
public static bool MatKhauMoi(string tk, string mk)
{
string sql = string.Format("Update TAIKHOAN set MatKhau='{0}' where TenTaiKhoan='{1}'", mk, tk);
return(DL_LayDuLieu.UpdateSQL(sql));
}
//them
public static bool DonViTinhThem(string ma, string ten)
{
string sql = string.Format("Insert into DONVITINH(MaDonViTinh,TenDonViTinh) Values('{0}','{1}')", ma, ten);
return(DL_LayDuLieu.InsertSQL(sql));
}
//xoa
public static bool DonViTinhXoa(string ma)
{
string sql = string.Format("Delete From DONVITINH Where MaDonViTinh='{0}'", ma);
return(DL_LayDuLieu.DeleteSQL(sql));
}
//lay thong tin tai khoan
public static DataTable LayThongTinTaiKhoan(string tk)
{
string sql = string.Format("Select * from TAIKHOAN Where TenTaiKhoan = '{0}'", tk);
return(DL_LayDuLieu.LayDuLieuSQL(sql));
}
//them
public static bool PhieuNhapThem(string maphieunhap, string ngaynhap, string manhanvien, string kho, string manhacungcap, string hinhthucthanhtoan, string dieukhoan, double tongtien, string hanthanhtoan, string tientratruoc)
{
string sql = string.Format("Insert Into PHIEUNHAP(MaPhieuNhap,NgayNhap,MaNV,MaKho,MaNhaCungCap,MaHinhThucThanhToan,MaDKThanhToan,TongTienThanhToan,HanThanhToan,TienTraTruoc) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')", maphieunhap, ngaynhap, manhanvien, kho, manhacungcap, hinhthucthanhtoan, dieukhoan, tongtien, hanthanhtoan, tientratruoc);
return(DL_LayDuLieu.InsertSQL(sql));
}
//sua
public static bool BoPhanSua(string maBoPhan, string TenBoPhan)
{
string sql = string.Format("Update BOPHAN set TenBP='{0}' where MaBP='{1}'", TenBoPhan, maBoPhan);
return(DL_LayDuLieu.UpdateSQL(sql));
}
//xoa
public static bool BoPhanXoa(string maBoPhan)
{
string sql = string.Format("Delete From BOPHAN where MaBP='{0}'", maBoPhan);
return(DL_LayDuLieu.DeleteSQL(sql));
}
//them
public static bool BoPhanThem(string maBoPhan, string TenBoPhan)
{
string sql = string.Format("Insert into BOPHAN(MABP,TENBP) Values('{0}','{1}')", maBoPhan, TenBoPhan);
return(DL_LayDuLieu.InsertSQL(sql));
}
// lay du lieu tu ban khu vuc
public static DataTable DuLieuBoPhan()
{
return(DL_LayDuLieu.LayDuLieuTuBang("BOPHAN"));
}
public static DataTable DuLieuDieuKhoan()
{
return(DL_LayDuLieu.LayDuLieuTuBang("DIEUKHOAN"));
}
//them
public static bool PhieuXuatThem(string maphieuxuat, string ngayxuat, string manhanvien, string khachang, string hinhthucthanhtoan, string dieukhoan, double TongTien, string hanthanhtoan, string tientratruoc, string ngaygiao)
{
string sql = string.Format("Insert Into PHIEUXUAT(MaPhieuXuat,NgayXuat,MaNV,MaKhachHang,MaHinhThucThanhToan,MaDKThanhToan,TongTienThanhToan,HanThanhToan,TienTraTruoc,NgayGiao) Values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')", maphieuxuat, ngayxuat, manhanvien, khachang, hinhthucthanhtoan, dieukhoan, TongTien, hanthanhtoan, tientratruoc, ngaygiao);
return(DL_LayDuLieu.InsertSQL(sql));
}
//them kho hang
public static bool KhachHangThem(string ma, string ten, string makhuvuc)
{
string sql = string.Format("Insert into KHO(MaKho,TenKho,MaKhuVuc) Values('{0}','{1}','{2}')", ma, ten, makhuvuc);
return(DL_LayDuLieu.InsertSQL(sql));
}
// lay du lieu tu ban khu vuc
public static DataTable DuLieuDonViTinh()
{
return(DL_LayDuLieu.LayDuLieuTuBang("DONVITINH"));
}
//sua kho hang
public static bool KhoHangSua(string ma, string ten, string makhuvuc)
{
string sql = string.Format("Update KHO Set TenKho='{0}',MaKhuVuc='{1}' Where MaKho='{2}'", ten, makhuvuc, ma);
return(DL_LayDuLieu.UpdateSQL(sql));
}
//sua
public static bool DonViTinhSua(string ma, string ten)
{
string sql = string.Format("Update DONVITINH set TenDonViTinh='{0}' Where MaDonViTinh='{1}'", ten, ma);
return(DL_LayDuLieu.UpdateSQL(sql));
}
//xoa kho hang
public static bool KhoHangXoa(string ma)
{
string sql = string.Format("Delete From KHO Where MaKho='{0}'", ma);
return(DL_LayDuLieu.DeleteSQL(sql));
}
public static DataTable DuLieuCTPhieuXuat()
{
return(DL_LayDuLieu.LayDuLieuTuBang("CTPHIEUXUAT"));
}
//lay du lieu bang VAITROCHUCNANG
public static DataTable LayThongTinVaiTroChucNang(string MaVaiTro)
{
string sql = string.Format("Select vt.*,cn.TenTrongHeThong from VAITROCHUCNANG vt, CHUCNANG cn Where MaVaiTro='{0}' and vt.MaChucNang=cn.id", MaVaiTro);
return DL_LayDuLieu.LayDuLieuSQL(sql);
}
//ktra dang nhap neu co tra ve ma vai tro
public static string DangNhap(string tk, string mk)
{
string sql = string.Format("Select MaVaiTro from TAIKHOAN Where TenTaiKhoan = '{0}' and MatKhau = '{1}'", tk, mk);
return(DL_LayDuLieu.ScalarKieuString(sql));
}
public static DataTable DuLieuSanPham()
{
string sql = string.Format("Select DISTINCT(MaSP),TenSP,MaDonViTinh,XuatXu,GiaLucNhap,HinhAnh From SANPHAM");
return(DL_LayDuLieu.LayDuLieuSQL(sql));
}
public static DataTable DuLieuKhoHang()
{
return(DL_LayDuLieu.LayDuLieuTuBang("NHOMHANG"));
}
public static DataTable DuLieuSanPhamTheoSP(string masp)
{
string sql = string.Format("Select MaKho From SANPHAM Where MaSP='{0}'", masp);
return(DL_LayDuLieu.LayDuLieuSQL(sql));
}
//sua nhom hang
public static bool NhomHangSua(string ma, string ten)
{
string sql = string.Format("Update NHOMHANG set TenNhomHang='{0}' where MaNhomHang='{1}'", ten, ma);
return(DL_LayDuLieu.UpdateSQL(sql));
}
public static bool SanPhamCapNhat(string kho, string MaSP, int SoLuongMua)
{
string sql = string.Format("Update SANPHAM set SoLuongTon=SoLuongTon-{0} Where MaKho='{1}' and MaSP='{2}'", SoLuongMua, kho, MaSP);
return(DL_LayDuLieu.UpdateSQL(sql));
}
public static DataTable DuLieuCTPhieuNhap()
{
return(DL_LayDuLieu.LayDuLieuTuBang("CTPHIEUNHAP"));
}
//xoa khach hang
public static bool KhachHangXoa(string makhachhang)
{
string sql = string.Format("Delete From KHACHHANG Where MaKhachHang='{0}'", makhachhang);
return(DL_LayDuLieu.DeleteSQL(sql));
}