河北地质大学本科生毕业设计
if ([_dbopen] == NO) {
[_dbclose]; return; }
[_dbexecuteUpdateWithFormat:@\]; [_dbclose]; }
#pragma mark - 查询group_recordTable中的数据 +(NSMutableArray *)searchGroup_RecordTable {
if ([_dbopen] == NO) {
[_dbclose]; returnnil; }
FMResultSet * rs = [_dbexecuteQueryWithFormat:@\]; NSMutableArray * array = [[NSMutableArrayalloc]init]; while ([rs next]) {
group_record * gRecord = [[group_recordalloc]init];
gRecord.gRecord_id = [rs intForColumn:@\];
gRecord.gRecord_date = [rs stringForColumn:@\]; gRecord.gRecord_time = [rs stringForColumn:@\]; gRecord.gRecord_room = [rs stringForColumn:@\]; [arrayaddObject:gRecord]; [gRecordrelease]; }
[rsclose]; [_dbclose];
return [array autorelease]; }
#pragma mark - 向group_recordTable中插入数据
+(void)insertGroup_RecordTableWith:(group_record *)gRecord {
if ([_dbopen] == NO) {
[_dbclose]; return; }
[_dbexecuteUpdateWithFormat:@\VALUES
(%@,%@,%@)\,gRecord.gRecord_date,gRecord.gRecord_time,gRecord.gRecord_room];
28
河北地质大学本科生毕业设计
[_dbclose]; }
#pragma mark - 移除group_RecordTable中的所有数据 +(void)deleteGroup_RecordTable {
if ([_dbopen] == NO) {
[_dbclose]; return; }
[_dbexecuteUpdateWithFormat:@\]; [_dbclose]; }
#pragma mark - 删除group_recordTable中的一条记录
+ (void)deleteGroup_RecordTableWithgRecordTime:(NSString *)gRecordTime {
if ([_dbopen] == NO) {
[_dbclose]; return; }
[_dbexecuteUpdateWithFormat:@\LIKE %@\,gRecordTime]; [_dbclose]; }
#pragma mark - 查询recordTable中的数据
+(NSMutableArray *)searchRecordTableWithNum:(int)num {
if ([_dbopen] == NO) {
[_dbclose]; returnnil; }
FMResultSet * rs =[_dbexecuteQueryWithFormat:@\stateNum = %d\,num];
NSMutableArray * array = [[NSMutableArrayalloc]init]; while ([rs next]) {
Record * record = [[Recordalloc]init];
record.record_id = [rs intForColumn:@\];
record.record_stateNum = [rs intForColumn:@\];
record.record_menuName = [rs stringForColumn:@\];
29
河北地质大学本科生毕业设计
record.record_menuPrice = [rs stringForColumn:@\]; record.record_menuKind = [rs stringForColumn:@\]; record.record_menuNum = [rs intForColumn:@\];
record.record_menuRemark = [rs stringForColumn:@\]; record.record_groupID = [rs intForColumn:@\]; [arrayaddObject:record]; [recordrelease]; }
[rsclose]; [_dbclose];
return [array autorelease]; }
//删除recordTable中的一条数据
+(void)deleteRecordTableWithNum:(int)num {
if ([_dbopen] == NO) {
[_dbclose]; return; }
[_dbexecuteUpdateWithFormat:@\= %d\,num]; [_dbclose]; }
#pragma mark - 向recordTable中插入数据 +(void)insertRecordTableWith:(Record *)record {
if ([_dbopen] == NO) {
[_dbclose]; return; }
[_dbexecuteUpdateWithFormat:@\
recordTable(stateNum,menuName,menuPrice,menuKind,menuNum,menuRemark,groupID) VALUES
(%d,%@,%@,%@,%d,%@,%d)\,record.record_stateNum,record.record_menuName,record.record_menuPrice,record.record_menuKind,record.record_menuNum,record.record_menuRemark,record.record_groupID]; [_dbclose]; }
#pragma mark - 删除recordTable中的数据 +(void)deleteRecordTable
30
河北地质大学本科生毕业设计
{
if ([_dbopen] == NO) {
[_dbclose]; return; }
[_dbexecuteUpdateWithFormat:@\]; [_dbclose]; }
@end
附录C：
@implementation ChangeVCTool
//找window切换根视图控制器并做翻转动画
+(void)changeViewController:(UIViewController *)vc {
UIWindow * window = [UIApplicationsharedApplication].delegate.window; window.rootViewController = vc;
[UIViewbeginAnimations:nilcontext:nil]; [UIViewsetAnimationDuration:0.5];
[UIViewsetAnimationTransition:6forView:window cache:YES]; [UIViewcommitAnimations]; }
//cell做UIView动画
+(void)flipSelectCell:(UITableViewCell *)cell {
[UIViewbeginAnimations:nilcontext:nil]; [UIViewsetAnimationDuration:0.5];
[UIViewsetAnimationTransition:2forView:cell cache:YES]; [UIViewcommitAnimations]; }
@end
附录D：
#pragma mark - 网站首页
- (IBAction)loadWebClick:(id)sender {
//用系统浏览器加载网页(这里以百度首页为例,可以写本餐厅的网站首页) [[UIApplicationsharedApplication]
openURL:[NSURLURLWithString:@\]]; }
31
河北地质大学本科生毕业设计
#pragma mark - 点菜系统
- (IBAction)orderDishSystemClick:(id)sender {
LanguageVC * languageVC =[[LanguageVCalloc]init]; // 跳转界面
[ChangeVCToolchangeViewController:languageVC]; }
附录E：
#pragma mark - 点击进入主界面 - (IBAction)goMainVC:(id)sender {
MainViewController * mainVC = [[MainViewControlleralloc]init]; [ChangeVCToolchangeViewController:mainVC]; }
#pragma mark - 返回按钮
- (IBAction)goBackClick:(id)sender {
WelcomeVC * welcomeVC =[[WelcomeVCalloc]init];
[ChangeVCToolchangeViewController:welcomeVC]; }
#pragma mark - 历史菜单
- (IBAction)historyOrderClick:(id)sender {
HistoryOrderViewController * historyOrderVC = [[HistoryOrderViewControlleralloc]init]; [selfpresentViewController:historyOrderVC animated:YEScompletion:nil]; }
附录F：
- (void)viewDidLoad {
[superviewDidLoad]; //注册单元格
[self.historyOrderTableViewregisterNib:[UINibnibWithNibName:@\bundle:nil] forCellReuseIdentifier:@\];
_groupRecordArr = [DataBaseToolsearchGroup_RecordTable]; [_groupRecordArrretain]; }
#pragma mark - 表的协议方法
32