//

//? FMDBmanager.m

//? database

//

//? Created by PRL on 16/10/13.

//? Copyright ? 2016年PRL. All rights reserved.

//

#import "FMDBmanager.h"

static FMDBmanager * manager =nil;

@implementation FMDBmanager

//獲取用戶詳細信息

-(MyInfoModel *)getMyInfo:(NSString *)Uid

{

? ? FMResultSet * set = [_dbexecuteQuery:@"select * from USERMESSAGE where userid = ?",Uid];

? ? MyInfoModel * InfoModel= [[MyInfoModelalloc]init];

? ? while ([setnext]) {

? ? ? ? InfoModel.userId = [setstringForColumn:@"userid"];

? ? ? ? InfoModel.myHeadImage = [setstringForColumn:@"myHeadImage"];

? ? ? ? InfoModel.nickName = [setstringForColumn:@"nickName"];

? ? ? ? InfoModel.realName = [setstringForColumn:@"realName"];

? ? ? ? InfoModel.height = [setstringForColumn:@"height"];

? ? ? ? InfoModel.weight = [setstringForColumn:@"weight"];

? ? ? ? InfoModel.phoneNo = [setstringForColumn:@"phoneNo"];

? ? ? ? InfoModel.mySex = [setstringForColumn:@"mySex"];

? ? ? ? InfoModel.idCard = [setstringForColumn:@"idCard"];

? ? ? ? InfoModel.myAddress = [setstringForColumn:@"address"];

? ? ? ? InfoModel.weixin = [setstringForColumn:@"weixin"];

? ? ? ? InfoModel.qq = [setstringForColumn:@"qq"];

? ? ? ? InfoModel.treatmentNo = [setstringForColumn:@"treatmentNo"];

? ? }

? ? return InfoModel;

}

//刪除用戶詳細信息

-(void)deleteInfoMessage:(NSString *)userid

{

? ? BOOL res = [_dbexecuteUpdate:@"delete from USERMESSAGE where userid=?",userid];

? ? if (res ==NO) {

? ? ? ? NSLog(@"刪除失敗");

? ? }

}

//更新用戶信息

-(void)updateInfoMessage:(NSString *)userid andNewString:(NSString *)newString andLabelString:(NSString *)labelString

{

? ? BOOL res =NO;

? ? if ([selfExitUserid:userid]) {

?? ? ? ?

? ? }else{

? ? ? ? res = [_dbexecuteUpdate:@"insert into USERMESSAGE(userid) values(?)",userid];

? ? ? ? if (res ==NO) {

? ? ? ? ? ? NSLog(@"主鍵插入失敗");

? ? ? ? }else{

? ? ? ? ? ? NSLog(@"主鍵插入成功");

? ? ? ? }??

? ? }

? ? if ([labelStringisEqualToString:@"頭像"]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set myHeadImage=? where userid=?",newString,userid];

? ? }

? ? if ([labelStringisEqualToString:@"昵稱"]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set nickName=? where userid=?",newString,userid];

? ? }

? ? if ([labelStringisEqualToString:@"真實姓名"]) {

? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set realName=? where userid=?",newString,userid];

? ? }

? ? if ([labelStringisEqualToString:@"身高"]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set height=? where userid=?",newString,userid];

? ? }

? ? if ([labelStringisEqualToString:@"體重"]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set weight=? where userid=?",newString,userid];

? ? }

? ? if ([labelStringisEqualToString:@"手機號"]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set phoneNo=? where userid=?",newString,userid];

? ? }

? ? if ([labelStringisEqualToString:@"性別"]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set mySex=? where userid=?",newString,userid];

? ? }

? ? if ([labelStringisEqualToString:@"身份證號"]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set idCard=? where userid=?",newString,userid];

? ? }

? ? if ([labelStringisEqualToString:@"地址"]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set address=? where userid=?",newString,userid];

? ? }

? ? if ([labelStringisEqualToString:@"微信"]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set weixin=? where userid=?",newString,userid];

? ? }

? ? if ([labelStringisEqualToString:@"QQ"]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set qq=? where userid=?",newString,userid];

? ? }

? ? if ([labelStringisEqualToString:@"就診號"]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set treatmentNo=? where userid=?",newString,userid];

? ? }

? ? if (res ==NO) {

? ? ? ? DLog(@"屬性修改失敗");

? ? ? ? return;

? ? }

? ? DLog(@"屬性修改成功");

}

//更新model信息

-(void)EditInfoRequest:(MyInfoModel *)model

{

? ? BOOL res =NO;

? ? if ([selfExitUserid:model.userId]) {

? ? ? ? res = [_dbexecuteUpdate:@"update USERMESSAGE set treatmentNo=?,nickName=?,realName=?,height=?,weight=?,phoneNo=?,mySex=?,idCard=?,address=?,weixin=?,qq=? where userid=?",model.treatmentNo,model.nickName,model.realName,model.height,model.weight,model.phoneNo,model.mySex,model.idCard,model.myAddress,model.weixin,model.qq,model.userId];

? ? ? ? if (res) {

? ? ? ? ? ? NSLog(@"用戶資料修改成功");

? ? ? ? }else{

? ? ? ? ? ? NSLog(@"用戶資料修改失敗");

? ? ? ? }

? ? }else{

? ? ? ? //myHeadImage,nickName,realName,height,weight,phoneNo,mySex,idCard,address,weixin,qq,treatmentNo

? ? ? ? res = [_dbexecuteUpdate:@"insert into USERMESSAGE(userid,myHeadImage,nickName,realName,height,weight,phoneNo,mySex,idCard,address,weixin,qq,treatmentNo) values(?,?,?,?,?,?,?,?,?,?,?,?,?)",model.userId,@"",model.nickName,model.realName,model.height,model.weight,model.phoneNo,model.mySex,model.idCard,model.myAddress,model.weixin,model.qq,model.treatmentNo];

? ? ? ? if (res) {

? ? ? ? ? ? NSLog(@"用戶資料插入成功");

? ? ? ? }else{

? ? ? ? ? ? NSLog(@"用戶資料插入失敗");

? ? ? ? }

? ? }

}

-(id)init{

? ? if (self = [superinit]) {

? ? ? ? NSString * path = [NSHomeDirectory()stringByAppendingPathComponent:@"Documents/userMessage.db"];

? ? ? ? DLog(@"數據庫地址 %@",path);

?? ? ? ?

? ? ? ? _db = [[FMDatabasealloc]initWithPath:path];

? ? ? ? BOOL res = [_dbopen];

?? ? ? ?

? ? ? ? if (res ==NO) {

? ? ? ? ? ? DLog(@"數據庫創建失敗");

? ? ? ? ? ? returnself;

? ? ? ? }

? ? ? ? DLog(@"數據庫創建成功");

? ? ? ? res = [_dbexecuteUpdate:@"create table if not exists USERMESSAGE(userid varchar(2048),myHeadImage,nickName,realName,height,weight,phoneNo,mySex,idCard,address,weixin,qq,treatmentNo)"];

? ? ? ? if (res ==NO) {

? ? ? ? ? ? DLog(@"用戶表創建失敗");

? ? ? ? ? ? returnself;

? ? ? ? }

? ? ? ? DLog(@"用戶表創建成功");

? ? }

? ? returnself;

}

+(FMDBmanager *)sharedManager

{

? ? if (manager ==nil) {

? ? ? ? manager = [[FMDBmanageralloc]init];

? ? }

? ? returnmanager;

}

-(BOOL)ExitUserid:(NSString *)userid

{

? ? FMResultSet * set = [_dbexecuteQuery:@"select * from USERMESSAGE;"];

? ? NSMutableArray * arr = [[NSMutableArrayalloc]init];

? ? if (!set) {

? ? ? ? returnNO;

? ? }else{

? ? ? ? while ([setnext]) {

? ? ? ? ? ? NSString * string = [setstringForColumn:@"userid"];

? ? ? ? ? ? [arr addObject:string];

? ? ? ? }

? ? ? ? if ([arrcontainsObject:userid]) {

? ? ? ? ? ? //有相應的userid

? ? ? ? ? ? returnYES;

? ? ? ? }else{

? ? ? ? ? ? returnNO;

? ? ? ? }

? ? }

?? ?

}

@end