clsconn.cpp

用户名：liuxinrui 密码：zhongyong 您可以在 linux 系统上运行 main.exe 文件 IP 应设为192.168.0.1 重新编译请在linux终端提示符后输

/***********************************
*  模块名称：clsConn.cpp           * 
*  模块功能: 实现与数据库连接的类  *
*  作者：刘鑫锐                    *
*  撰写日期：2005-9-15             *
***********************************/

#include <stdio.h>
#include <iostream.h>
#include "head/clsConn.h"
#include "head/clsProduct.h"
#include "head/clsTrade.h"


#define UID "sa"
#define PWD "" 
#define DBSERVER "192.168.0.1:1433"  
#define DBNAME "DepartmentalStore"
    


clsConn::clsConn()
{
    if(dbinit() == FAIL)
    {
        cout << endl << "error" << endl;
        return;
    }
    
    if((login=dblogin())==FAIL)
    {
        cout << endl << "error" << endl;
        return;
    }
    
    DBSETLUSER(login,UID);
    DBSETLPWD(login,PWD);
    
    if((dbconn=dbopen(login,DBSERVER))==NULL)
    {
        cout << endl << "error" << endl;
        return;
    }
    
    dbuse(dbconn,DBNAME);
    dbloginfree(login);
}

clsConn::~clsConn()
{
    dbfreebuf(dbconn);
    dbclose(dbconn);
    dbexit();
}
/******对 clsProduct clsTrade 的操作******/
void clsConn::ClistInfo(char *string)
{
    system("clear");
   	char ch[2];
    do
    {
   	    dbfcmd(dbconn,string);
   	    dbsqlexec(dbconn);
   	    dbresults(dbconn);
   	    cout << "\n\n\n";
   	    dbprhead(dbconn);
   	    dbprrow(dbconn);
   	    cout << endl << endl;
   	    cout << "Is List Again![Y/N]";
   	    cin >> ch;
    }while(*ch != 'n');
   	    dbfreebuf(dbconn);
}

void clsConn::Cwork(char *string)
{
      dbfcmd(dbconn,string);
      (dbsqlexec(dbconn) != FAIL)?(cout << endl << "\t\t   **********WORK SUCCESS**********\n\n"):(cout << endl << "\t\t   **********WORK NOT SUCCESS**********\n\n");    
      dbfreebuf(dbconn);
}
/******对交易表 clsSupplier 的操作******/ 

void clsConn::ClistSupplierInfo(char *string)//供应商信息列表 
{
    system("clear");
    char ch[2];
    do
    {
    	dbfcmd(dbconn,string);
    	dbsqlexec(dbconn);
    	dbresults(dbconn);
    	dbbind(dbconn,1,NTBSTRINGBIND,0,(BYTE*)SupplierId);
    	dbbind(dbconn,2,NTBSTRINGBIND,0,(BYTE*)SupplierName);
    	dbbind(dbconn,3,NTBSTRINGBIND,0,(BYTE*)SupplierAddress);
    	dbbind(dbconn,4,NTBSTRINGBIND,0,(BYTE*)SupplierPhone);
    	dbbind(dbconn,5,NTBSTRINGBIND,0,(BYTE*)ProductId);          
        while(dbnextrow(dbconn) != NO_MORE_ROWS)
        {  
             cout << "\t SupplierId:" << SupplierId << endl;
             cout << "\t SupplierName:" << SupplierName << endl;
             cout << "\t SupplierAddress:" << SupplierAddress << endl;
             cout << "\t SupplierPhone:" << SupplierPhone<< endl;
             cout << "\t ProductId:" << ProductId << endl;
             cout << "\t **************************************************" << endl;       
        }
    	dbfreebuf(dbconn);
    	cout << endl << endl;
    	cout << "Is Supplier List Again![Y/N]";
    	cin >> ch;
    }while(*ch != 'n' && *ch != 'N');
}

void clsConn::ClistTradeInfo(char *string)     //交易详情列表 
{
   system("clear");
    char ch[2];
    do
    {
    	dbfcmd(dbconn,string);
    	dbsqlexec(dbconn);
    	dbresults(dbconn);
    	dbbind(dbconn,1,NTBSTRINGBIND,0,(BYTE*)TradeId);
    	dbbind(dbconn,2,NTBSTRINGBIND,0,(BYTE*)TradeType);
    	dbbind(dbconn,3,NTBSTRINGBIND,0,(BYTE*)TradeTime);
    	dbbind(dbconn,4,NTBSTRINGBIND,0,(BYTE*)OtherName);
    	dbbind(dbconn,5,NTBSTRINGBIND,0,(BYTE*)OtherPhone);
        dbbind(dbconn,6,NTBSTRINGBIND,0,(BYTE*)ProductId);
        dbbind(dbconn,7,NTBSTRINGBIND,0,(BYTE*)Price); 
        dbbind(dbconn,8,NTBSTRINGBIND,0,(BYTE*)ProductCount);
        dbbind(dbconn,9,NTBSTRINGBIND,0,(BYTE*)PriceSum);            
        while(dbnextrow(dbconn) != NO_MORE_ROWS)
        {  
             cout << "\t TradeId: " << TradeId << endl;
             cout << "\t TradeName: "  << TradeType << endl;
             cout << "\t TradeTime: "  << TradeTime << endl;
             cout << "\t OtherName: "  << OtherName<< endl;
             cout << "\t OtherPhone:"  << OtherPhone << endl;
             cout << "\t ProductId: "  << ProductId << endl;
             cout << "\t Price:     "  << Price << endl;
             cout << "\t ProductCount:" << ProductCount << endl;
             cout << "\t PriceSum:  " << PriceSum << endl;
             cout << "\t **************************************************" << endl;       
        }
    	dbfreebuf(dbconn);
    	cout << endl << endl;
    	cout << "\t Is List Again![Y/N]";
    	cin >> ch;
    }while(*ch != 'n' && *ch != 'N');   
}