+(NSInteger)timeSwitchTimestamp:(NSString *)formatTime andFormatter:(NSString *)format{
NSDateFormatter *formatter = [[NSDateFormatter alloc] init];
[formatter setDateStyle:NSDateFormatterMediumStyle];
[formatter setTimeStyle:NSDateFormatterShortStyle];
[formatter setDateFormat:format]; //(@"YYYY-MM-dd hh:mm:ss") ----------设置你想要的格式,hh与HH的区别:分别表示12小时制,24小时制
NSTimeZone* timeZone = [NSTimeZone timeZoneWithName:@"Asia/Beijing"];
[formatter setTimeZone:timeZone];
NSDate* date = [formatter dateFromString:formatTime]; //------------将字符串按formatter转成nsdate
//时间转时间戳的方法:
NSInteger timeSp = [[NSNumber numberWithDouble:[date timeIntervalSince1970]] integerValue];
NSLog(@"将某个时间转化成 时间戳&&&&&&&timeSp:%ld",(long)timeSp); //时间戳的值
return timeSp;
}
-
(UIImage *)imageMaskWithColor:(UIColor *)maskColor {
if (!maskColor) {
return nil;
}
UIImage *newImage = nil;CGRect imageRect = (CGRect){CGPointZero,self.size};
UIGraphicsBeginImageContextWithOptions(imageRect.size, NO, self.scale);CGContextRef context = UIGraphicsGetCurrentContext();
CGContextScaleCTM(context, 1.0, -1.0);
CGContextTranslateCTM(context, 0.0, -(imageRect.size.height));CGContextClipToMask(context, imageRect, self.CGImage);//选中选区 获取不透明区域路径
CGContextSetFillColorWithColor(context, maskColor.CGColor);//设置颜色
CGContextFillRect(context, imageRect);//绘制
newImage = UIGraphicsGetImageFromCurrentImageContext();//提取图片UIGraphicsEndImageContext();
return newImage;
}
/**
- 打开数据库
*/
- (BOOL)openDb {
NSString path = [NSSearchPathForDirectoriesInDomains(NSDocumentationDirectory, NSUserDomainMask, YES) lastObject];
NSString pathName = [path stringByAppendingString:@"LTGreenDB.sqlite"];
NSLog(@"%@", pathName);
db = [FMDatabase databaseWithPath:pathName];
int result = [db open];
if (result) {
NSLog(@"打开成功");
} else {
NSLog(@"打开失败");
}
return result;
}
/
- 创建表格
*/
- (void)creatShopGreenChildTable {
if ([self openDb]) {
BOOL result = [db executeUpdate:@"CREATE TABLE IF NOT EXISTS LTGreenTableView (ltId integer PRIMARY KEY AUTOINCREMENT, dataId integer NOT NULL, typeId integer NOT NULL, tpyeDicID integer NOT NULL, LTDic TEXT NOT NULL);"];
if (result) {
NSLog(@"创建表格成功");
} else {
NSLog(@"创建表格失败");
}
[db close];
}
}
/**
- 插入了数据
*/
-
(void)insertDataSource:(NSArray *)modelArray WithString:(NSString *)string {
if ([db open]) {
int p = 0;
int q = 0;
for (int i = 0; i < modelArray.count; i++) {
NSMutableDictionary *dic = [modelArray[i] mutableCopy];
NSString dicString = [dic mj_JSONString];
NSString insertSqlite = nil;
int typeDicID = 0;
int forId = 0;
if ([string isEqualToString:@"3"]) {
typeDicID = [dic[@"type"] intValue];
if (typeDicID == 3) {
forId = p;
p++;
} else {
forId = q;
q++;
}
} else {
forId = i;
}
insertSqlite = [NSString stringWithFormat:@"INSERT INTO LTGreenTableView (dataId, tpyeDicID, typeId, LTDic) VALUES ('%d','%d', '%d', '%@')", forId,typeDicID , [string intValue], dicString];
BOOL res = [db executeUpdate:insertSqlite];
if (res) {
// NSLog(@"插入数据成功");
} else {
// NSLog(@"插入数据失败");
}
}
[db close];
}
}
/
- 删除的全部数据
*/
-
(void)deleteAllData {
if ([db open]) {
//清空数据表并将自增字段清零
NSString *deleteSql = @"DELETE FROM LTGreenTableView where 1=1";
[db executeUpdate:@"UPDATE sqlite_sequence set seq = 0 where name = 'LTGreenTableView'"];
BOOL res = [db executeUpdate:deleteSql];
if (res) {
NSLog(@"清空shopCar表数据成功");
} else {
NSLog(@"清空shopCar表数据失败");
}[db close];}
}
/**
- 查找方法
*/
- (NSArray<NSMutableDictionary *> *)selectTypeData:(NSString *)type tpyeDicID:(int)tpyeDicID {
NSMutableArray *arr = [NSMutableArray array];
if ([db open]) {
NSString * sql = [NSString stringWithFormat:@"SELECT * FROM LTGreenTableView WHERE typeId = '%d' and tpyeDicID = '%d'", [type intValue], tpyeDicID];
FMResultSet * rs = [db executeQuery:sql];
while ([rs next]) {
NSString *dic = [rs stringForColumn:@"LTDic"];
NSData *dat = [dic dataUsingEncoding:NSUTF8StringEncoding];
NSMutableDictionary *d = [[NSJSONSerialization JSONObjectWithData:dat options:0 error:nil] mutableCopy];
if ([type isEqualToString:@"3"]) {
int sd = [rs intForColumn:@"dataId"];
[d setObject:[NSString stringWithFormat:@"%d", sd] forKey:@"dataId"];
}
[arr addObject:d];
}
[db close];
}
return arr;
}
/**
- 修改资料的查询方法
*/
- (NSMutableDictionary *)selectType:(NSString *)type tpyeDicID:(int)tpyeDicID dataId:(NSString *)dataId {
NSMutableDictionary *d = [NSMutableDictionary dictionary];
if ([db open]) {
NSString * sql = [NSString stringWithFormat:@"SELECT * FROM LTGreenTableView WHERE typeId = '%d' and tpyeDicID = '%d' and dataId = '%d'", [type intValue], tpyeDicID, [dataId intValue]];
FMResultSet * rs = [db executeQuery:sql];
while ([rs next]) {
NSString *dic = [rs stringForColumn:@"LTDic"];
NSLog(@"%@", dic);
NSData *dat = [dic dataUsingEncoding:NSUTF8StringEncoding];
d = [[NSJSONSerialization JSONObjectWithData:dat options:0 error:nil] mutableCopy];
}
[db close];
}
return d;
}
/**
- 修改数据方法
*/
- (BOOL)updataDbidData:(NSString *)updata Dictype:(int)Dictype seleDataID:(NSString *)seleDataId btnSelect:(BOOL)btnSelect
{
BOOL res = nil;
NSMutableDictionary *dic = [self selectType:updata tpyeDicID:Dictype dataId:seleDataId];
if (btnSelect) {
[dic setObject:@"1" forKey:@"FLAG"];
NSLog(@"/开%d", btnSelect);
} else {
[dic setObject:@"0" forKey:@"FLAG"];
NSLog(@"、关%d", btnSelect);
}
NSString *stringDic = [dic mj_JSONString];
if ([db open]) {
NSLog(@" updata === %@, dictype = %d , seleddataid = %d", updata, Dictype, [seleDataId intValue]);
NSString *updateSql = [NSString stringWithFormat:@"update LTGreenTableView set LTDic = '%@' where typeId = '%d' and tpyeDicID = '%d' and dataId = '%d'", stringDic, [updata intValue], Dictype, [seleDataId intValue]];
res = [db executeUpdate:updateSql];
[db close];
}
return res;
}
