lyfz_repos/经典版源码/Others/Imgcommon/test/tblst.h

//////////////////////////////////////////////////////////////////////////
// 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)")