#ifndef _DB_FUNC_H_
#define _DB_FUNC_H_

#include "stdio.h"
#include "stdlib.h"
#include "windows.h"
#include "sqltypes.h"



// 車站類型結構體
typedef struct station_type_infor
{    
	char Station_Type_Name[24];     // 車站的類型                     
	station_type_infor *next;
}STATION_TYPE;  


// 車站信息結構體
typedef struct station_infor
{                
//	int  Station_Number;          // 車站的編號                    
    char Station_Name[24];        // 車站名稱
	char Bus_Number[128];       // 在此車站停車的車號
	char Station_Type_Name[24];      // 車站的類型標號 (A.B.C……)
	station_infor *next;
}STATION_INFOR;      


// 車次信息結構體
typedef struct bus_infor
{  
    int  Bus_Number;           //  車次名稱
	char Bus_Route[2048];        //  車次路線
	char Bus_Type_Name[12];        //  班車類型
	char Bus_Remark[64];         //  備注：時間
	int  Bus_Ticket;            //  有無月票
   	bus_infor *next;
}BUS_INFOR;    

//管理員信息表
typedef struct bus_type_infor
{
    char Bus_Type_Name[12];       //   類型名稱
  	bus_type_infor *next;
}BUS_TYPE;

//函數定義
int DB_Open(SQLHENV *henv,
			SQLHDBC *hdbc,
			SQLHSTMT *hstmt);

int DB_Close(SQLHENV henv,
			 SQLHDBC hdbc,
			 SQLHSTMT hstmt);

//////////////////////////////////////////////////////////////////////////
int DB_BUS_TYPE_Query(SQLHSTMT hstmt, BUS_TYPE *bus_type, BUS_TYPE *bus_type_head);   

int DB_BUS_TYPE_Modify(SQLHSTMT hstmt, char *old_bus_type, char *new_bus_type);   

int DB_BUS_TYPE_Delete(SQLHSTMT hstmt, char *bus_type);  
 
int DB_BUS_TYPE_Delete_All(SQLHSTMT hstmt); 

int DB_BUS_TYPE_Insert(SQLHSTMT hstmt, char *bus_type);   

//////////////////////////////////////////////////////////////////////////

int DB_STATION_TYPE_Query(SQLHSTMT hstmt, STATION_TYPE *station_type, STATION_TYPE *station_type_head);   

int DB_STATION_TYPE_Modify(SQLHSTMT hstmt, char *old_station_type, char *new_station_type);   

int DB_STATION_TYPE_Delete(SQLHSTMT hstmt, char *station_type);  

int DB_STATION_TYPE_Delete_All(SQLHSTMT hstmt); 

int DB_STATION_TYPE_Insert(SQLHSTMT hstmt, char *station_type);   

//////////////////////////////////////////////////////////////////////////
int DB_STATION_INFOR_Query(SQLHSTMT hstmt, STATION_INFOR *station_infor, STATION_INFOR *station_infor_head);   

int DB_STATION_INFOR_Modify(SQLHSTMT hstmt, STATION_INFOR *station_infor, char *station_name);   

int DB_STATION_INFOR_Delete(SQLHSTMT hstmt, char *station_name);  

int DB_STATION_INFOR_Delete_All(SQLHSTMT hstmt); 

int DB_STATION_INFOR_Insert(SQLHSTMT hstmt, STATION_INFOR station_infor);   

int DB_STATION_INFOR_Modify_BusNumber(SQLHSTMT hstmt, char *station_name, char *bus_number); 

int DB_STATION_INFOR_Query_BusNumber(SQLHSTMT hstmt, char *station_name, char *bus_number); 

int DB_STATION_INFOR_Query_StationName(SQLHSTMT g_hstmt, STATION_INFOR *station_infor, STATION_INFOR *head, char *station_type_name);

//////////////////////////////////////////////////////////////////////////

int DB_BUS_INFOR_Query(SQLHSTMT hstmt, BUS_INFOR *bus_infor, BUS_INFOR *bus_infor_head);   

int DB_BUS_INFOR_Query_BusNumber(SQLHSTMT hstmt, BUS_INFOR *bus_infor, BUS_INFOR *bus_infor_head, int bus_number);   

int DB_BUS_INFOR_Query_IsTrue(SQLHSTMT hstmt, int bus_number, char *bus_type_name);  

int DB_BUS_INFOR_Modify(SQLHSTMT hstmt, BUS_INFOR bus_infor, int bus_number, char *bus_type_name);   

int DB_BUS_INFOR_Delete(SQLHSTMT hstmt, int bus_number, char *bus_type_name);  

int DB_BUS_INFOR_Delete_All(SQLHSTMT hstmt); 

int DB_BUS_INFOR_Insert(SQLHSTMT hstmt, BUS_INFOR bus_infor);
 
//////////////////////////////////////////////////////////////////////////

int DB_SYSTEM_INFOR_Query(SQLHSTMT hstmt, char *year, char *month, char *day, char *address);   

//////////////////////////////////////////////////////////////////////////

long double BusNumAddStation(int nBusNumber, long double ldOldNumber);   

long double StrToLDouble(unsigned char strTemp[128]);  

void LDoubleToStr(long double ldNumber, unsigned char strTemp[128]);   

void CompareLNumber(long double ldNumberFirst, long double ldNumberSecond, long double *ldResult);

//////////////////////////////////////////////////////////////////////////


#endif