//
//  DB_Helper.h
//  Texts
//
//  Created by tongjun on 13-10-12.
//  Copyright (c) 2013年 tongjun. All rights reserved.
//

#import <Foundation/Foundation.h>
#import "FMDatabase.h"
#import "UserInfo.h"
#import "TrainRecord.h"
#import "Grade.h"

#define dataBasePath [[(NSSearchPathForDirectoriesInDomains(NSDocumentDirectory,NSUserDomainMask,YES)) lastObject]stringByAppendingPathComponent:dataBaseName]
#define dataBaseName @"miaxis_new_1230.db"

@interface DB_Helper : NSObject



//创建数据库类的单例对象
+ (FMDatabase *)createDataBase;
//关闭数据库
+ (void)closeDataBase;
//将数据库拷贝到手机
+ (void)copyFileDatabase;

//理论学时
//保存训练明细
+(void)saveTrain:(TrainRecord *)trainRecord;
//读取训练明细 要分科目
+(NSArray *)quearyTrain:(NSString *)stuId Subject:(NSString *)sub;
//训练明细状态修改 0：未上传 1:已上传
+(void)updateTrainState:(TrainRecord *)trainRecord;
// 温州理论计时学时未超过30分钟
+ (void)deleteTrainRecord:(TrainRecord *)trainRecord;
//实操学时表
//保存学时
+ (void)saveSCTrainWithDic:(NSDictionary *)dic;
//删除单条学时
+ (void)deleteSCTrainWithTrainNum:(NSString *)trainNum;
//删除某课堂学时
+ (void)deleteSCTrainWithClassId:(NSString *)classId;
//删除所有学时
+ (void)deleteAllSCTrain;

//实操/模拟学时表
//保存学时
+ (void)saveTrainWithDic:(NSDictionary *)dic type:(NSString *)type;
//删除单条学时
+ (void)deleteTrainWithTrainNum:(NSString *)trainNum type:(NSString *)type;
//删除某课堂学时
+ (void)deleteTrainWithClassId:(NSString *)classId type:(NSString *)type;
//删除所有学时
+ (void)deleteAllTrainWithType:(NSString *)type;
//查询classId下的所有学时
+ (NSArray *)quearyTrainWithClassId:(NSString *)classId type:(NSString *)type;


//将obd的数据覆盖到分钟学时
+ (void)changeSCTrainWithTrainNum:(NSString *)trainNum
                    RotationSpeed:(NSString *)rotationSpeed
                            Speed:(NSString *)speed
                          Mileage:(NSString *)mileage;



//查询classId下的所有学时
+ (NSArray *)quearySCTrainWithClassId:(NSString *)classId;

//理论题目练习成绩表
+(void)saveGrade:(Grade *)aGrade;
/**
 where state = 0
 */
+(NSArray *)quearyGrade;

+(void)updateGrade:(Grade *)aGrade;
@end