/*************************************************

        File name : guest.c
      Description : 来宾模块，拥有所有权限
           Others : Null
         Function : 1. 数据库的查询
          History : 2013-9-2 Gongpei 创建

    Copyright (C), 2013-2014, Gongpei

*************************************************/

#include <stdio.h>
#include <stdlib.h>
#include <string.h>

#include "main.h"
#include "sqlite3.h"

/*----------------------------------------------
       Function : 回调函数
    Description : 输出查询的表单信息
----------------------------------------------*/
int guestPrintRecord(void *params, int column, char **columnValue, char **columnName)
{
    int i;
    char blank[7][10] = { {"  "},{"   "},{"     "},{"      "},{"    "},{"      "},{"      "} };
    for(i = 0; i < column; i++)
    {
        printf("%s",blank[i]);
        printf("%s", columnValue[i]);
    }
    printf("\n");
    return 0;
}

int guestForm()
{
    printf( "===============================================================================\n"
            "|                                                                             |\n"
            "|                               来宾页面                                      |\n"
            "|                                                                             |\n"
            "|                           1、查看学生信息                                   |\n"
            "|                           2、退        出                                   |\n"
            "|                                                                             |\n"
            "-------------------------------------------------------------------------------\n"
          );
    return checkOption(2,"请选择所需操作：","输入错误，请重新输入");
}

void guestViewDB(sqlite3 *ems)
{
    int returnCode;
    char error;
    char *SQL_getInfomation = "SELECT * FROM emp";


    //执行以上SQL
    system("cls");
    printf( "===============================================================================\n"
            "|                           以下是查询结果                                    |\n"
            "-------------------------------------------------------------------------------\n"
            "|  ID  |  姓名  |  性别  |  出生日期   |   部门   |   工资   |      电话      |\n"
            "-------------------------------------------------------------------------------\n"
          );
    returnCode = sqlite3_exec(ems,SQL_getInfomation,guestPrintRecord,NULL,&error);
    if( returnCode != SQLITE_OK || returnCode == SQLITE_NOTFOUND)
    {
        fprintf(stderr,"查找失败: %s\n",error);
    }
    printf( "-------------------------------------------------------------------------------\n");
    system("pause");
    system("cls");
}


/*----------------------------------------------
       Function : 数据库查询
    Description : guest.c主函数
----------------------------------------------*/
void guestMain()
{
    int returnCode = 0;
    char *error;
    sqlite3 *ems;

    returnCode = sqlite3_open("ems.db",&ems);
    if(returnCode != SQLITE_OK)
    {
        fprintf(stderr,"无法打开数据库: %s\n",sqlite3_errmsg(ems));
    }
    else
    {
        while( 1 )
        {
            switch( guestForm() )
            {
                //搜索职工信息
                case 1: system( "cls" );
                        guestViewDB(ems);
                        break;
                //退出程序
                case 2: //关闭数据库
                        sqlite3_free(error);
                        sqlite3_close(ems);
                        userType = VISITOR;
                        break;

                default : exit(0);
            }
            if( userType == VISITOR )
            {
                break;
            }
        }

    }
}