////////////////////////////////////////////////////////////////////////// // dindan表系列; typedef struct __Tbl_dindan__ { TString _id; TString _name1; TString _name2; TString _taoxiname; TString _taoxijiage; TString _curno; }Tbldindan,*pTbldindan; #define INSERT_dindan _T("INSERT INTO [dindan](\ id,\ name1,\ name2,\ taoxiname,\ taoxijiage,\ curno\ )VALUES(\ '%s',\ '%s',\ '%s',\ '%s',\ '%s',\ '%s')") #define SELECT_dindan _T("SELECT id,name1,name2,taoxiname,taoxijiage,curno FROM dindan") ////////////////////////////////////////////////////////////////////////// // NetShareInfo表系列; typedef struct __Tbl_NetShareInfo__ { bool _enable; TString _branchid; TString _sharepath; int _mincapacity; int _maxcapacity; int _phototype; int _priority; }TblNetShareInfo,*pTblNetShareInfo; #define SELECT_NetShareInfo _T("SELECT enable,branchid,sharepath,mincapacity,maxcapacity,phototype,priority FROM NetShareInfo") #define INSERT_NetShareInfo _T("INSERT INTO [NetShareInfo](\ enable,\ branchid,\ sharepath,\ mincapacity,\ maxcapacity,\ phototype,\ priority\ )VALUES(\ %d,\ '%s',\ '%s',\ %d,\ %d,\ %d,\ %d)") #define UPDATE_NetShareInfo _T("UPDATE [NetShareInfo] SET \ enable,\ branchid,\ sharepath,\ mincapacity,\ maxcapacity,\ phototype,\ priority\ )VALUES(\ %d,\ '%s',\ '%s',\ %d,\ %d,\ %d,\ %d)")