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

#import <Foundation/Foundation.h>

#import "UserInfo.h"
#import "TrainRecord.h"
#import "Grade.h"

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


@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;
+ (void)deleteTrain:(TrainRecord *)trainRecord;
//实操/模拟学时表
//保存学时
+ (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;
+ (void)deleteTrainRecord:(TrainRecord *)trainRecord;

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

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