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