public static void Update(KhachHangDTO kh) { string sql = "Update KHACHHANG set HoTenKhachHang =('" + kh.HoTenKhachHang + "'),DienThoai=(" + kh.DienThoai + "), DiaChi=('" + kh.DiaChi + "'),Email=('" + kh.Email + "') where MaKhachHang=" + kh.MaKhachHang + ""; DataAccess.ExcuNonQuery(sql); }
public static bool Delete(HoaDonDTO hd) { try { string sql = "delete from HOADON where MaHoaDon= " + hd.MaHoaDon + ""; DataAccess.ExcuNonQuery(sql); return(true); } catch { return(false); } }
public static bool Delete(KhachHangDTO kh) { try { string sql = "delete from KHACHHANG where MaKhachHang= " + kh.MaKhachHang + ""; DataAccess.ExcuNonQuery(sql); return(true); } catch { return(false); } }
public static bool Delete(SachDTO s) { try { string sql = "delete from SACH where MaSach= " + s.MaSach + ""; DataAccess.ExcuNonQuery(sql); return(true); } catch { return(false); } }
public static bool Delete(PhieuThuDTO pt) { try { string sql = "delete from PHIEUTHU where MaPhieuThu= " + pt.MaPhieuThu + ""; DataAccess.ExcuNonQuery(sql); return(true); } catch { return(false); } }
public static bool Delete(TheLoaiDTO tl) { try { string sql = "delete from THELOAI where TenTheLoai= '" + tl.TenTheLoai + "'"; DataAccess.ExcuNonQuery(sql); return(true); } catch { return(false); } }
static public void Update(ThamSoDTO ts) { string sql = "update THAMSO set SoLuongNhapItNhat=(" + ts.SoLuongNhapMin + "),LuongTonItNhat=(" + ts.LuongTonMin + "),NoKhongQua=(" + ts.NoMin + "),LuongTonSauKhiBan=(" + ts.TonSauKhiBan + "),DieuKienThu=(" + ts.DieuKienThu + ") where MaThamSo = " + ts.MaThamSo + ""; DataAccess.ExcuNonQuery(sql); }
static public void Insert(SachDTO s) { string sql = "insert into SACH(TenSach,TacGia,MaTheLoai,GiaBan,SoLuongTon) values('" + s.TenSach + "','" + s.TacGia + "'," + s.MaTheLoai + "," + s.GiaBan + "," + s.SoLuongTon + ")"; DataAccess.ExcuNonQuery(sql); }
public static void Update(TheLoaiDTO tl) { string sql = "Update THELOAI set TenTheLoai ='" + tl.TenTheLoai + "'where MaTheLoai=" + tl.MaTheLoai + ""; DataAccess.ExcuNonQuery(sql); }
public static void Insert(TheLoaiDTO tl) { string sql = "insert into THELOAI(TenTheLoai) values('" + tl.TenTheLoai + "')"; DataAccess.ExcuNonQuery(sql); }
public static void InsertChitiet(HoaDonDTO hd) { string sql = "insert into CHITIETHOADON(MaHoaDon,MaSach,SoLuongMua) values(" + hd.MaHoaDon + "," + hd.MaSach + "," + hd.SoLuongMua + ")"; DataAccess.ExcuNonQuery(sql); }
public static void Insert(PhieuThuDTO pt) { string sql = "insert into PHIEUTHU(NgayThu,SoTienThu,MaKhachHang) values('" + pt.NgayThu + "'," + pt.SoTienThu + "," + pt.MaKhachHang + ")"; DataAccess.ExcuNonQuery(sql); }
static public void Update(SachDTO s) { string sql = "update SACH set TenSach=('" + s.TenSach + "'),TacGia=('" + s.TacGia + "'),MaTheLoai=(" + s.MaTheLoai + "),GiaBan=(" + s.GiaBan + "),SoLuongTon=(" + s.SoLuongTon + ") where MaSach = " + s.MaSach + ""; DataAccess.ExcuNonQuery(sql); }
public static void UpdateTienNo(KhachHangDTO kh) { string sql = "Update KHACHHANG set TienNo=(" + kh.TienNo + ") where MaKhachHang=" + kh.MaKhachHang + ""; DataAccess.ExcuNonQuery(sql); }
public static void Update(HoaDonDTO hd) { string sql = "Update HOADON set NgayLapHoaDon =('" + hd.NgayLapHoaDon + "'),MaSach=(" + hd.MaSach + "), MaKhachHang=(" + hd.MaKhachHang + ") where MaHoaDon=" + hd.MaHoaDon + ""; DataAccess.ExcuNonQuery(sql); }
public static void Insert(KhachHangDTO kh) { string sql = "insert into KHACHHANG(HoTenKhachHang,DienThoai,DiaChi,Email) values('" + kh.HoTenKhachHang + "'," + kh.DienThoai + ",'" + kh.DiaChi + "','" + kh.Email + "')"; DataAccess.ExcuNonQuery(sql); }
public static void Insert(BaoCaoCongNoDTO bc) { string sql = "insert into BAOCAOCONGNO(MaKhachHang,NgayPhatSinh,NoDau,PhatSinh,NoCuoi) values(" + bc.MaKhachHang + ",'" + bc.NgayPhatSinh + "'," + bc.NoDau + ",'" + bc.PhatSinh + "'," + bc.NoCuoi + ")"; DataAccess.ExcuNonQuery(sql); }
static public void UpdateSoLuongTon(SachDTO s) { string sql = "update SACH set SoLuongTon=(" + s.SoLuongTon + ") where MaSach = " + s.MaSach + ""; DataAccess.ExcuNonQuery(sql); }
static public void Insert(PhieuNhapDTO p) { string sql = "insert into CHITIETPHIEU(MaPhieuNhap,MaSach,SoLuongNhap) values(" + p.MaPhieuNhap + "," + p.MaSach + "," + p.SoLuong + ")"; DataAccess.ExcuNonQuery(sql); }
public static void Update(PhieuThuDTO pt) { string sql = "Update PHIEUTHU set NgayThu =('" + pt.NgayThu + "'),SoTienThu=(" + pt.SoTienThu + ") where MaPhieuThu=" + pt.MaPhieuThu + ""; DataAccess.ExcuNonQuery(sql); }
static public void Insertphieunhap(PhieuNhapDTO p) { string sql = "insert into PHIEUNHAP(NgayNhap) values('" + p.NgayNhap + "')"; DataAccess.ExcuNonQuery(sql); }
public static void Insert(BaoCaoTonDTO bc) { string sql = "insert into BAOCAOTON(MaSach,NgayPhatSinh,TonDau,PhatSinh,TonCuoi) values(" + bc.MaSach + ",'" + bc.NgayPhatSinh + "'," + bc.TonDau + ",'" + bc.PhatSinh + "'," + bc.TonCuoi + ")"; DataAccess.ExcuNonQuery(sql); }
public static void Insert(HoaDonDTO hd) { string sql = "insert into HOADON(NgayLapHoaDon,MaKhachHang) values('" + hd.NgayLapHoaDon + "'," + hd.MaKhachHang + ")"; DataAccess.ExcuNonQuery(sql); }