public static void CapNhatKhuyenMai() { string query = string.Format("Select * from SanPham as sp,KhuyenMai as km where sp.MaKhuyenMai = km.MaKhuyenMai AND sp.MaKhuyenMai != 4 AND km.NgayKetThuc <= '{0}' ", DateTime.Now.ToString("yyyy-MM-dd")); DataTable sanPhamHetHan = XuLyDuLieu.LayBang(query); foreach (DataRow row in sanPhamHetHan.Rows) { string maSP = row["MaSP"].ToString(); query = string.Format("Update SanPham set MaKhuyenMai = {0} where MaSP = '{1}'", 4, maSP); XuLyDuLieu.ThucThiCauLenh(query); } }
public static bool CapNhatSoLuong(string maCTSP, int soLuong) { clsChiTietSP_DTO chiTiet = LayChiTiet(maCTSP); if (chiTiet != null) { int tongSLSP = chiTiet.SoLuong - soLuong; string query = string.Format("UPDATE ChiTietSanPham SET SoLuong = {0} WHERE MaCTSP = '{1}'", tongSLSP, maCTSP); return(XuLyDuLieu.ThucThiCauLenh(query) >= 1); } else { return(false); } }
public static int XoaNhaCungCap(string MaNhaCungCap) { string query = string.Format("UPDATE NhaCungCap Set TrangThai = 0 WHERE MaNhaCungCap = '{0}'", MaNhaCungCap); return(XuLyDuLieu.ThucThiCauLenh(query)); }
public static int XoaSanPham(string idSanPham) { string query = string.Format("UPDATE ChiTietSanPham SET TrangThai = 0 WHERE MaCTSP ='{0}'", idSanPham); return(XuLyDuLieu.ThucThiCauLenh(query)); }
public static bool CapNhatKhuyenMai(string maSP, int maKhuyenMai) { string query = string.Format("Update SanPham set MaKhuyenMai = {0} where MaSP = '{1}'", maKhuyenMai, maSP); return(XuLyDuLieu.ThucThiCauLenh(query) >= 1); }
public static bool CapNhatKhuyenMai(int maCu, int maMoi) { string query = string.Format("Update SanPham set MaKhuyenMai = {0} where MaKhuyenMai = {1}", maMoi, maCu); return(XuLyDuLieu.ThucThiCauLenh(query) >= 1); }
public static bool XoaTaiKhoan(string tenTaiKhoan) { string query = string.Format("UPDATE TaiKhoan SET TrangThai = 0 WHERE TenTaiKhoan ='{0}'", tenTaiKhoan); return(XuLyDuLieu.ThucThiCauLenh(query) >= 1); }
public static bool CapNhatDangNhap(string maNV) { string query = string.Format("Update TaiKhoan Set LastLogon = '{0}' where MaNV = '{1}'", DateTime.Now, maNV); return(XuLyDuLieu.ThucThiCauLenh(query) >= 1); }
public static bool Xoa(int _maKhuyenMai) { string query = string.Format("UPDATE KhuyenMai set TrangThai = 0 where MaKhuyenMai = '{0}'", _maKhuyenMai); return(XuLyDuLieu.ThucThiCauLenh(query) >= 1); }