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