94 lines
2.7 KiB
Dart
94 lines
2.7 KiB
Dart
import 'package:peach/entity/_.dart';
|
||
import 'package:peach/db/SQLite.dart';
|
||
|
||
class LikeService {
|
||
|
||
static String TableName = "Like";
|
||
static String tabsNameSingleGraph = "SingleGraph";
|
||
|
||
///====================== 写真收藏 ======================///
|
||
|
||
/// 添加喜欢
|
||
static Future<int> addLike(LikeEntity user) async {
|
||
var _db = await SQLite().db;
|
||
return await _db.insert(LikeService.TableName, user.toJson());
|
||
}
|
||
|
||
/// 查询所有喜欢数据
|
||
static Future<List<LikeEntity>> findAll() async {
|
||
var _db = await await SQLite().db;
|
||
List<Map<String, dynamic>> result = await _db.query(LikeService.TableName);
|
||
|
||
return result.isNotEmpty
|
||
? result.map((e) {
|
||
return LikeEntity.fromJson(e);
|
||
}).toList()
|
||
:[];
|
||
}
|
||
|
||
/// 根据id查询数据，注意这里返回 true，false，
|
||
/// 主要为了在详情页控制收藏按钮的样式，如果需要返回数据
|
||
/// 需要修改类型为： Future<List<LikeEntity>> 和 return的结果
|
||
/// LikeEntity.fromJson(e);
|
||
static Future<bool> find(int id) async {
|
||
var _db = await SQLite().db;
|
||
List<Map<String, dynamic>> result = await _db.query(
|
||
LikeService.TableName,
|
||
where: 'id = ?',
|
||
whereArgs: [id]
|
||
);
|
||
return result.isNotEmpty ? true : false;
|
||
}
|
||
|
||
/// 根据id删除数据
|
||
static Future<int> delete(int id) async {
|
||
var _db = await await SQLite().db;
|
||
return await _db.delete(
|
||
LikeService.TableName,
|
||
where: 'id = ?',
|
||
whereArgs: [id]
|
||
);
|
||
}
|
||
|
||
///====================== 单图收藏 ======================
|
||
|
||
// 查询所有收藏的图片
|
||
static Future<List<SingleGraphEntity>> findAllImg() async {
|
||
var _db = await await SQLite().db;
|
||
List<Map<String, dynamic>> result = await _db.query(LikeService.tabsNameSingleGraph, orderBy: "id DESC");
|
||
return result.isNotEmpty
|
||
? result.map((e) {
|
||
return SingleGraphEntity.fromJson(e);
|
||
}).toList()
|
||
:[];
|
||
}
|
||
|
||
// 添加图片
|
||
static Future<int> addImg(SingleGraphEntity Img) async {
|
||
var _db = await SQLite().db;
|
||
return await _db.insert(LikeService.tabsNameSingleGraph, Img.toJson());
|
||
}
|
||
|
||
// 检测图片是否已经收藏过
|
||
static Future<bool> checkIsLike(String src) async {
|
||
var _db = await SQLite().db;
|
||
List<Map<String, dynamic>> result = await _db.query(
|
||
LikeService.tabsNameSingleGraph,
|
||
where: 'src = ?',
|
||
whereArgs: [src]
|
||
);
|
||
return result.isNotEmpty ? true : false;
|
||
}
|
||
|
||
// 根据 地址删除收藏的图片
|
||
static Future<int> deleteImg(String src) async {
|
||
var _db = await await SQLite().db;
|
||
return await _db.delete(
|
||
LikeService.tabsNameSingleGraph,
|
||
where: 'src = ?',
|
||
whereArgs: [src]
|
||
);
|
||
}
|
||
|
||
}
|