//them nha cung cap
public static bool NhaCungCapThem(string ma, string ten, string diachi, string dienthoai, string maKhuVuc)
{
string sql = string.Format("Insert Into NHACUNGCAP(MaNhaCungCap,TenNhaCungCap,DiaChi,DienThoai,MaKhuVuc) Values('{0}','{1}','{2}','{3}','{4}')", ma, ten, diachi, dienthoai, maKhuVuc);
return(DL_LayDuLieu.InsertSQL(sql));
}
//them khu vuc
public static bool KhuVucMoi(string maKhuVuc, string tenKhuVuc)
{
string sql = string.Format("Insert into KHUVUC(MaKhuVuc,TenKhuVuc) Values('{0}','{1}')", maKhuVuc, tenKhuVuc);
return(DL_LayDuLieu.InsertSQL(sql));
}
//them
public static bool NhanVienThem(string ma, string ten, string phai, string ngaysinh, string dienthoai, string mabophan)
{
string sql = string.Format("Insert into NHANVIEN(MaNV,HoTen,GioiTinh,NgaySinh,DienThoai,MaBP) Values('{0}','{1}','{2}','{3}','{4}','{5}')", ma, ten, phai, ngaysinh, dienthoai, mabophan);
return(DL_LayDuLieu.InsertSQL(sql));
}
//them
public static bool TyGiaThem(string ma, string ten, string quydoi)
{
string sql = string.Format("Insert into TYGIA(MaTyGia,TenTyGia,QuyDoiTienViet) Values('{0}','{1}','{2}')", ma, ten, quydoi);
return(DL_LayDuLieu.InsertSQL(sql));
}
//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));
}
//them
public static bool CTPhieuNhapThem(string MaChiTietNhap, string MaPhieuNhap, string MaSP, float DonGiaSP, float ThanhTien, float Thue, int SoLuongMua)
{
string sql = string.Format("Insert into CTPHIEUNHAP(MaChiTietNhap,MaPhieuNhap,MaSP,DonGiaSP,ThanhTien,Thue,SoLuongMua) Values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", MaChiTietNhap, MaPhieuNhap, MaSP, DonGiaSP, ThanhTien, Thue, SoLuongMua);
return(DL_LayDuLieu.InsertSQL(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));
}
//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));
}
//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));
}
//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));
}
//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));
}
//them khach hang
public static bool KhachHangThem(string maKhachHang, string TenKhachHang, string DiaChi, string dienthoai, string makhuvuc)
{
string sql = string.Format("Insert Into KHACHHANG(MaKhachHang,TenKhachHang,DiaChi,DienThoai,MaKhuVuc) Values('{0}','{1}','{2}','{3}','{4}')", maKhachHang, TenKhachHang, DiaChi, dienthoai, makhuvuc);
return(DL_LayDuLieu.InsertSQL(sql));
}
