fuzhu.h

大学田径运动会管理系统

//---------------------------------------------------------------------------

#ifndef fuzhuH
#define fuzhuH
#include <inifiles.hpp>
#include <Db.hpp>
#include <ADODB.hpp>
#include <stdlib.h>
AnsiString szTitle=" 简化版本 Beta 1.12 ";
AnsiString m_system_window_title;
class TYuange_QJ{
public:
    AnsiString m_config_file;
    AnsiString m_server_constring;
    AnsiString m_server_ip;
    AnsiString m_server_data_name;
    AnsiString m_server_data_user;
    AnsiString m_server_data_password;
    AnsiString m_server_data_provider;
    AnsiString m_system_window_title;
    AnsiString m_system_remote_path;
public:
        TYuange_QJ();
        void init();
        ~TYuange_QJ();
        setsystem();
};
class TYuange{
  public:
        TYuange();
        ~TYuange();
  public:
        AnsiString m_connectstring;
        bool __fastcall selectlbfz(AnsiString lbfz);
        bool __fastcall getallxiangmu();
        bool __fastcall selectbsfs(int);
        AnsiString __fastcall getcurrentxmbh();
        bool __fastcall selectxiangmu(AnsiString);
        AnsiString __fastcall getxmxj();
        AnsiString __fastcall getxmlb();
        AnsiString __fastcall getcjdw();
        AnsiString __fastcall getcjgs();
        int __fastcall getbhxmgs();
        int __fastcall getbsinfo(AnsiString ,TStringList **);
        AnsiString __fastcall getbszt(int i);
        int __fastcall getlqrs(int i);
        float __fastcall getdf(int mc);
        float __fastcall getqtrdf();
        int __fastcall getpjlgs();
        AnsiString __fastcall getpjlmc(int i);
        float __fastcall getpjldf(int i);
        AnsiString __fastcall getsfgz();
        void __fastcall openconnection();
        void __fastcall closeconnection();
        void __fastcall execute(AnsiString sql);
        void __fastcall init(AnsiString constring);
        void __fastcall connectsql(AnsiString sql);
public:
         TADOQuery *m_query;
         TADOConnection *m_con;
         int index,i;
         TStringList *list_temp;
         AnsiString   temp_str;
         TStringList *list_lbfzmc,*list_lbfzbh;
         TStringList *list_xmbh;
         TStringList *list_xmmc;
         TStringList *list_xmlb;
         TStringList *list_lbfz;
         TStringList *list_lbbh;
         TStringList *list_fzbh;
         TStringList *list_bscs;
         TStringList *list_mcbsmc;
         TStringList *list_mcbssj;
         TStringList *list_mcbszt;
         TStringList *list_mcbslqmc;
         TStringList *list_dfqk;
         TStringList *list_ycjdf;
         TStringList *list_pjlcj;
         TStringList *list_pjlmc;
         TStringList *list_pjldf;
         TStringList *list_xmxj;
         TStringList *list_sfgz;
         TStringList *list_sfdgbs;
         TStringList *list_cjdw;
         TStringList *list_gs;
         TStringList *list_xmgs;
         TStringList *list_jylq;
         TStringList *list_qn_xmxj;
         TStringList *list_qn_xmbh;
        void __fastcall initlist();

};
class TYuange_{
protected:
int index,i;
         TStringList *list_temp;
         AnsiString temp_str;
public:
         TYuange *yuange;
         TYuange_(TYuange * yuange=NULL);
         TStringList * list_list_xmmc;
         TStringList * list_list_xmbh;
         AnsiString list_xmbh;
         AnsiString list_xmmc;
         AnsiString list_xmlb;
         AnsiString list_lbfz;
         AnsiString list_lbbh;
         AnsiString list_fzbh;
         AnsiString list_bscs;
         AnsiString list_mcbsmc;
         AnsiString list_mcbssj;
         AnsiString list_mcbszt;
         AnsiString list_mcbslqmc;
         AnsiString list_dfqk;
         AnsiString list_ycjdf;
         AnsiString list_pjlcj;
         AnsiString list_pjlmc;
         AnsiString list_pjldf;
         AnsiString list_xmxj;
         AnsiString list_sfgz;
         AnsiString list_sfdgbs;
         AnsiString list_cjdw;
         AnsiString list_gs;
         AnsiString list_xmgs;
         AnsiString list_jylq;
         AnsiString list_bssj;
         TStringList *list_zxmmc;
         TStringList *list_zxmbh;
         TStringList *list_zxmzt;
         TStringList *list_zxmgs;
         TStringList *list_zxmbssj;

         AnsiString list_ppzxmbssj,list_ppzxmmc,list_ppzxmbh,list_ppzxmzt,list_ppzxmgs;
         int zxm_index;
        AnsiString qn_xmxz;
        AnsiString qn_xmbh;
        bool __fastcall selectlbfz(AnsiString lbfz);
        ~TYuange_();
        AnsiString __fastcall selectbsxm(AnsiString xmmc);
       bool __fastcall setxminfo(AnsiString xmbh);
       virtual void __fastcall getzxm(TStringList ** list);
        AnsiString __fastcall getrandomtable();
        void __fastcall setzxminfo(int zxmindex);
        void __fastcall getqninfo();
};
class TYuange_SR: public TYuange_
 {
public:
         TADOQuery *m_query;
         TADOConnection *m_con;
         AnsiString m_sql;
          TYuange_SR(TYuange *yuange):TYuange_(yuange){
                   m_table_name="";
                   m_con=new TADOConnection(NULL);
                   m_query=new TADOQuery(NULL);
                   m_con->ConnectionString=this->yuange->m_connectstring;
                   m_query->Connection=m_con;
                   m_con->LoginPrompt=false;     
                   };
    ~TYuange_SR(){
            dropsrtable();
         }
    AnsiString m_table_name;
    int curbsfs;
        int cur_xzh;
    bool __fastcall validebsfs(int i);
        void __fastcall createsrtable(int type=1);
        void close();
        void open();
        void __fastcall exe(AnsiString sql);
        void __fastcall open(AnsiString sql);
        void __fastcall dropsrtable(int type=1);
        void __fastcall selectydy(int type = 1);
        void __fastcall setcj(AnsiString ydybh, AnsiString cj, AnsiString bz, int pjldf,int pjlindex);
        void setbszt(int);
        void __fastcall updatecj(int type=1);
        void __fastcall getnewsinfo();
        void __fastcall sr_paiming();
        updatedata(TStringList * list_pdydybh, TStringList * list_value, AnsiString field, int type = 1);
};

class TYuange_JL: public TYuange_
 {
public:
         TADOQuery *m_query;
         TADOConnection *m_con;
         AnsiString m_sql;
          TYuange_JL(TYuange *yuange):TYuange_(yuange){
                   m_table_name="";
                   m_con=new TADOConnection(NULL);
                   m_query=new TADOQuery(NULL);
                   m_con->ConnectionString=this->yuange->m_connectstring;
                   m_query->Connection=m_con;
                   m_con->LoginPrompt=false;
                   };
    ~TYuange_JL(){
            dropsrtable();
         }
    AnsiString m_table_name;
    int curbsfs;
    bool __fastcall validebsfs(int i);
        void __fastcall createsrtable(int type=1);
        void close();
        void open();
        void __fastcall exe(AnsiString sql);
        void __fastcall open(AnsiString sql);
        void __fastcall dropsrtable(int type=1);
        void __fastcall selectydy(int type = 1);
        void __fastcall setxzhpdh(AnsiString ydybh, int xzh,int pdh);
        void setbszt(int);
        void __fastcall updatejl(int type=1);
        void __fastcall getnewsinfo();
        void __fastcall setydyzt(AnsiString m_ydybh,int index);
};

class TYuange_CL: public TYuange_
 {
public:
         TADOQuery *m_query;
         TADOConnection *m_con;
         AnsiString m_sql;
          TYuange_CL(TYuange *yuange):TYuange_(yuange){
                   m_table_name="";
                   m_con=new TADOConnection(NULL);
                   m_query=new TADOQuery(NULL);
                   m_con->ConnectionString=this->yuange->m_connectstring;
                   m_query->Connection=m_con;
                   m_con->LoginPrompt=false;
                   };
    ~TYuange_CL(){
            dropsrtable();
         }
    AnsiString m_table_name;
    int curbsfs;
        int shifoukaishichuli;
    bool __fastcall validebsfs(int i);
        void __fastcall createsrtable(int type=1);
        void close();
        void open();
        void __fastcall exe(AnsiString sql);
        void __fastcall open(AnsiString sql);
        void __fastcall dropsrtable(int type=1);
        void __fastcall selectydy(int type = 1);
        void __fastcall setcj(AnsiString ydybh, AnsiString cj, AnsiString bz, int pjldf);
        void setbszt(int);
        void __fastcall updatecj(int type=1);
        void __fastcall getnewsinfo();
        void __fastcall cl_paiming(int type=1 );
        void __fastcall cl_caldf(TStringList * list_pydybh, TStringList *list_pmc,TStringList *list_jingji,TStringList **list_defen,int type=1);
        void __fastcall cl_bingli(TStringList * list_pydybh, TStringList *list_pcj,TStringList **list_pmc,TStringList **list_bingli,int type=1);
        void __fastcall cl_jingji(TStringList * list_pydybh, TStringList *list_pmc,TStringList **list_jingji,int type=1);
        void __fastcall updatedata(TStringList * list_pydybh, TStringList * list_value, AnsiString field,int type=1);
        void __fastcall cl_bingli(TStringList * list_pydybh,TStringList *list_pmc,TStringList **list_bingli,int type=1);
        void __fastcall cl_dxqn();
        void __fastcall cl_allqn();
        void __fastcall setcj(AnsiString, AnsiString, AnsiString, AnsiString, AnsiString, AnsiString, AnsiString, AnsiString  );
        void __fastcall cl_handledf();
        void __fastcall manhandle(int type=1);
};

class TYuange_SJ: public TYuange_
 {
public:
         TADOQuery *m_query;
         TADOConnection *m_con;
         AnsiString m_sql;
          TYuange_SJ(TYuange *yuange):TYuange_(yuange){
                   m_table_name="";
                   m_con=new TADOConnection(NULL);
                   m_query=new TADOQuery(NULL);
                   m_con->ConnectionString=this->yuange->m_connectstring;
                   m_query->Connection=m_con;
                   m_con->LoginPrompt=false;
                   };
    ~TYuange_SJ(){
            dropsrtable();
         }
    AnsiString m_table_name;
    int curbsfs;
    int totalxzh,tailcount,totalcount;
    bool __fastcall validebsfs(int i);
        void __fastcall createsrtable(int type=1);
        void close();
        void open();
        void __fastcall exe(AnsiString sql);
        void __fastcall open(AnsiString sql);
        void __fastcall dropsrtable(int type=1);
        void __fastcall selectydy(int type = 1);
        void __fastcall setxzhpdh(AnsiString ydybh, int xzh,int pdh);
        void kaishifenzu(int gs);
        void __fastcall updatesj(int type=1);
        void __fastcall getnewsinfo();
        void __fastcall chongxin();
};
class TYuange_CX: public TYuange_
 {
public:
          TYuange_CX(TYuange *yuange):TYuange_(yuange){
                   };
    ~TYuange_CX(){
         }
};
TYuange *m_yuange;
TYuange_QJ *Yuange_QJ;
void parsestr(AnsiString str,TStringList **list,char sep);
void  list_str(AnsiString &str, TStringList *list,AnsiString sep);
int cal_function (AnsiString cj,AnsiString gs);
AnsiString parsegs(AnsiString gs);
AnsiString getsqlcjgs(AnsiString gs,AnsiString field);
bool showok(AnsiString str);
AnsiString returngs(AnsiString str);
//---------------------------------------------------------------------------
#endif