db_func.h

一个简单的公交查询管理系统

#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