⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 busdata.h

📁 关于数据库应用方面的例子
💻 H
📖 第 1 页 / 共 3 页
字号:
🔍
123 

#include "busdef.h"
#include "cc_data_struct.h"
#include "db_struct_ext.h"
#ifndef HEADFILE_BUSDATA
#define HEADFILE_BUSDATA
/*
功能：定义数据库表达的结构数据
版权所有：深圳普美有限公司
编写人：吕黄梁
日期：2004-12-31

*/
//#define VALUE_SHORT	10001
//#define VALUE_INT	10002

//实际数据库字段的定义

BusFieldStruct  FieldsValueShort[]=
{
	{_T("value"),DATA_SMALLINT,2}
};
BusFieldStruct  FieldsValueInt[]=
{
	{_T("value"),DATA_INT,4}
};
BusFieldStruct  FieldsCCInfoTable[]=
{
	{_T("CCID"),DATA_INT,4},
	{_T("Name"),DATA_NVARCHAR,CC_OWNER_NAME_LEN},
	{_T("Password"),DATA_NVARCHAR,CC_PSW_LEN},
	{_T("SuperPsw"),DATA_NVARCHAR,CC_PSW_LEN},
	{_T("TelPsw"),DATA_NVARCHAR,CC_PSW_LEN},
	{_T("UserName"),DATA_NVARCHAR,CC_OWNER_NAME_LEN},
	{_T("Sex"),DATA_TINYINT,1},
	{_T("Birthday"),DATA_NVARCHAR,CC_BORN_DATE_LEN},
	{_T("CertificateType"),DATA_TINYINT,1},
	{_T("Certificate"),DATA_NVARCHAR,CC_IDENTI_NUM_LEN},
	{_T("MobileNum"),DATA_NVARCHAR,CC_CELLPHONE_LEN},
	{_T("ZipCode"),DATA_NVARCHAR,CC_POSTCODE_LEN},
	{_T("Section"),DATA_NVARCHAR,CC_ZONENUM_LEN},
	{_T("Addr"),DATA_NVARCHAR,CC_ADDR_LEN},
	{_T("HomePhone"),DATA_NVARCHAR,CC_HOMEPHONE_LEN},
	{_T("SeriaL"),DATA_NVARCHAR,CC_CCSERIAL_NUM_LEN},
	{_T("GardenID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsSectionTable[]=
{
//	{_T("SectionID"),DATA_INT,4},
	{_T("Section"),DATA_NVARCHAR,CC_ZONENUM_LEN},
	{_T("ProvinceID"),DATA_INT,4},
	{_T("SectionName"),DATA_NVARCHAR,CC_BOROUGH_NAME_LEN},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};

BusFieldStruct  FieldsProvinceTable[]=
{
	{_T("ProvinceID"),DATA_INT,4},
	{_T("Name"),DATA_NVARCHAR,CC_PROVINCE_NAME_LEN},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
#define DEV_VALUE_POS 14+CC_DEVIE_NAME_LEN+CC_DEVICE_NUM_LEN
#define DEV_ADDR_POS	8+CC_DEVIE_NAME_LEN+CC_DEVICE_NUM_LEN//将系统地址和节点地址作为一个int类型来处理
BusFieldStruct  FieldsDevTable[]=
{
	{_T("DevID"),DATA_INT,4},
	{_T("Name"),DATA_NVARCHAR,CC_DEVIE_NAME_LEN},
	{_T("SeriaL"),DATA_NVARCHAR,CC_DEVICE_NUM_LEN},
	{_T("HouseID"),DATA_INT,4},
	{_T("SysAddr"),DATA_SMALLINT,2},
	{_T("DevAddr"),DATA_SMALLINT,2},
	{_T("DevType"),DATA_SMALLINT,2},
	{_T("Value"),DATA_SMALLINT,2},
	{_T("IsOnLine"),DATA_TINYINT,1},
	{_T("SysStatus"),DATA_TINYINT,1},
	{_T("RealDevID"),DATA_INT,4},
	{_T("OperSource"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsHouseTable[]=
{
	{_T("HouseID"),DATA_INT,4},
	{_T("Name"),DATA_NVARCHAR,CC_ROOM_NAME_LEN},
	{_T("TypeID"),DATA_INT,4},
	{_T("Description"),DATA_NVARCHAR,CC_ROOM_DESCRIP_LEN},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsHouseTypeTable[]=
{
	{_T("HouseTypeID"),DATA_INT,4},
	{_T("TypeName"),DATA_NVARCHAR,CC_ROOM_TYPE_NAME_LEN},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsPartDefenceTable[]=
{
	{_T("ID"),DATA_INT,4},
	{_T("HouseID"),DATA_INT,4},
	{_T("Type"),DATA_TINYINT,1},
	{_T("StartTime"),DATA_INT,4},
	{_T("EndTime"),DATA_INT,4}
};
BusFieldStruct  FieldsSceneTable[]=
{
	{_T("SceneID"),DATA_INT,4},
	{_T("Name"),DATA_NVARCHAR,CC_SCENE_NAME_LEN},
	{_T("HouseID"),DATA_INT,4},
	{_T("Attrib"),DATA_TINYINT,1},
	{_T("Type"),DATA_TINYINT,1},
	{_T("Description"),DATA_NVARCHAR,CC_SCENE_DESCRIP_LEN},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsSceneDevTable[]=
{
	{_T("SceneID"),DATA_INT,4},
	{_T("DevID"),DATA_INT,4},
	{_T("Oper"),DATA_TINYINT,1},
	{_T("Value"),DATA_SMALLINT,2},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsGuardLockTable[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("GuardID"),DATA_INT,4},
	{_T("LockID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsLockCodeTable[]=
{
	{_T("LockID"),DATA_INT,4},
	{_T("Code"),DATA_NVARCHAR,CC_DOOR_MAGCODE_LEN},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsScheduleTable[]=
{
	{_T("ID"),DATA_INT,4},
	{_T("ObjectID"),DATA_INT,4},
	{_T("Type"),DATA_TINYINT,1},
	{_T("StartTimerID"),DATA_INT,4},
	{_T("StartOper"),DATA_TINYINT,1},
	{_T("StartValue"),DATA_SMALLINT,2},
	{_T("EndTimerID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsTimerTable[]=
{
	{_T("TimerID"),DATA_INT,4},
	{_T("TimerTyper"),DATA_TINYINT,1},
	{_T("Time"),DATA_INT,4},
	{_T("BusType"),DATA_TINYINT,1},
	{_T("BusID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsTicklerTable[]=
{
	{_T("Idx"),DATA_INT,4}, 
	{_T("Title"),DATA_NVARCHAR,CC_TITLE_LEN},
	{_T("Content"),DATA_NVARCHAR,CC_TIPCONTENT_LEN},
	{_T("Time"),DATA_INT,4},
	{_T("NotifyFlag"),DATA_TINYINT,1},
	{_T("MobileNum"),DATA_NVARCHAR,CC_SM_PHONE_LEN},
	{_T("MailAddr"),DATA_NVARCHAR,CC_MAIL_NOTIFY_LEN},
	{_T("TimerID"),DATA_INT,4},
	{_T("RingID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsClockTable[]=
{
	{_T("ClockID"),DATA_INT,4},
	{_T("Text"),DATA_NVARCHAR,CC_TIP_CONTEN_LEN},
	{_T("UserName"),DATA_NVARCHAR,CC_SET_NAME_LEN},
	{_T("RingID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsRingTable[]=
{
	{_T("RingID"),DATA_INT,4},
	{_T("Name"),DATA_NVARCHAR,CC_RING_NAME_LEN},
	{_T("FilePath"),DATA_NVARCHAR,CC_RING_PATH_LEN},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsCardTable[]=
{
	{_T("CardID"),DATA_INT,4},
	{_T("Number"),DATA_NVARCHAR,CC_CARD_NUM_LEN},
	{_T("UserName"),DATA_NVARCHAR,CC_MEMB_NAME_LEN},
	{_T("RegTime"),DATA_INT,4},
	{_T("CardType"),DATA_TINYINT,1},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsCardTimerTable[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("CardID"),DATA_INT,4},
	{_T("Type"),DATA_TINYINT,1},
	{_T("StartTime"),DATA_INT,4},
	{_T("EndTime"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsPassRecord[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("CardID"),DATA_INT,4},
	{_T("UserName"),DATA_NVARCHAR,CC_MEMB_NAME_LEN},
	{_T("Time"),DATA_INT,4},
	{_T("GuardID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};

BusFieldStruct  FieldsVoiceMsgTable[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("Title"),DATA_NVARCHAR,VOICETITLE_NAME_LEN},
	{_T("FromID"),DATA_INT,4},
	{_T("FromName"),DATA_NVARCHAR,VOICEUSER_NAME_LEN},
	{_T("ToID"),DATA_INT,4},
	{_T("ToName"),DATA_NVARCHAR,VOICEUSER_NAME_LEN},
	{_T("Length"),DATA_INT,4},
	{_T("Time"),DATA_INT,4},
	{_T("ReadFlag"),DATA_TINYINT,1}
};
BusFieldStruct  FieldsAlarmConfigTable[]=
{
	{_T("ID"),DATA_INT,4},
	{_T("SendType"),DATA_TINYINT,1},
	{_T("MobileNum"),DATA_NVARCHAR,CC_SM_PHONE_LEN},
	{_T("TelNum"),DATA_NVARCHAR,CC_PHONE_NUM_LEN},
	{_T("MailAddr"),DATA_NVARCHAR,CC_EMAIL_LEN},
	{_T("Content"),DATA_NVARCHAR,CC_ALARM_TIP_LEN},
	{_T("RingID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsAlarmSpringTable[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("AlarmTypeID"),DATA_INT,4},
	{_T("DevNum"),DATA_TINYINT,1},
	{_T("Devs"),DATA_NVARCHAR,CC_ALARM_ROOM_NODE_LEN},
	{_T("Time"),DATA_INT,4},
	{_T("IsCurAlarm"),DATA_TINYINT,1},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsAlarmSpringDevTable[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("SpringID"),DATA_INT,4},
	{_T("DevID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};


BusFieldStruct  FieldsAlarmNotifyHisTable[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("AlarmSpingID"),DATA_INT,4},
	{_T("SendType"),DATA_TINYINT,1},
	{_T("NotifyObject"),DATA_NVARCHAR,31},
	{_T("RingID"),DATA_INT,4},
	{_T("Result"),DATA_TINYINT,1},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
//BUSINESS_INFRAREFUN		1022	          //	红外功能表
BusFieldStruct  FieldsInfrareFunTable[]=
{
	{_T("ID"),DATA_INT,4},
	{_T("FunID"),DATA_INT,4},
	{_T("DevID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
//BUSINESS_INFRAREFUNBIND	1023	          //	红外功能绑定表
BusFieldStruct  FieldsInfrareFunBindTable[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("KeyVal"),DATA_INT,4},
	{_T("ObjectType"),DATA_TINYINT,1},
	{_T("ObjectID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};


BusFieldStruct  FieldsOutgoingRecordTable[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("Type"),DATA_TINYINT,1},
	{_T("DoTime"),DATA_INT,4},
	{_T("RecordTime"),DATA_INT,4},
	{_T("UserName"),DATA_NVARCHAR,CC_SPAYER_LEN},
	{_T("InOut"),DATA_TINYINT,1},
	{_T("Value"),DATA_INT,4},		//
	{_T("Description"),DATA_NVARCHAR,CC_REMARK_LEN},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsAddrGroupTable[]=
{
	{_T("ID"),DATA_INT,4},
	{_T("Name"),DATA_NVARCHAR,PHONEBOOKGROUP_NAME_LEN},
	{_T("Type"),DATA_TINYINT,1},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsPTAddrListTable[]=
{
	{_T("UserID"),DATA_INT,4},
	{_T("GroupID"),DATA_INT,4},
	{_T("Name"),DATA_NVARCHAR,CC_NAME_LEN},
	{_T("Sex"),DATA_TINYINT,1},
	{_T("Birthday"),DATA_NVARCHAR,9},
	{_T("HomePhone"),DATA_NVARCHAR,21},
	{_T("OfficePhone"),DATA_NVARCHAR,CC_OFFICEPHONE_LEN},
	{_T("MobileNum"),DATA_NVARCHAR,15},
	{_T("MailAddr"),DATA_NVARCHAR,CC_MAIL_LEN},
	{_T("Addr"),DATA_NVARCHAR,CC_ADDRESS_LEN},
	{_T("Description"),DATA_NVARCHAR,CC_REMARK_LEN},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsPMAddrListTable[]=
{
	{_T("UserID"),DATA_INT,4},
	{_T("GroupID"),DATA_INT,4},
	{_T("Name"),DATA_NVARCHAR,21},
	{_T("Number"),DATA_NVARCHAR,21},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};
BusFieldStruct  FieldsTelVideoRecordTable[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("FromTel"),DATA_NVARCHAR,21},
	{_T("time"),DATA_INT,4},
	{_T("FromUserType"),DATA_TINYINT,1},
	{_T("Status"),DATA_TINYINT,1}
};
BusFieldStruct  FieldsInterPhoneRecordTable[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("Type"),DATA_TINYINT,1},
	{_T("time"),DATA_INT,4},
	{_T("Status"),DATA_TINYINT,1}
};



BusFieldStruct  FieldsShortMsgTable[]=	//BUSINESS_SHORTMSG			1034		//短信
{
	{_T("RecordID"),DATA_INT,4},
	{_T("SendState"),DATA_TINYINT,1},
	{_T("ReadFlag"),DATA_TINYINT,1},
	{_T("SrcMobile"),DATA_NVARCHAR,21},
	{_T("MsgContent"),DATA_NVARCHAR,101},
	{_T("DestMobile"),DATA_NVARCHAR,21},
	{_T("Time"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN}
};


BusTableStruct BusList[]=
{
	{
		BUSINESS_CCINFO,
		0,
		sizeof(FieldsCCInfoTable)/sizeof(FieldsCCInfoTable[0]),
		_T("CCInfoTable"),FieldsCCInfoTable,
		0,
		-1,
		-1
	},
	{BUSINESS_SECTION,0,sizeof(FieldsSectionTable)/sizeof(FieldsSectionTable[0]),
	_T("SectionTable"),FieldsSectionTable,0,-1,1},
	{BUSINESS_PROVINCE,0,sizeof(FieldsProvinceTable)/sizeof(FieldsProvinceTable[0]),
	_T("ProvinceTable"),FieldsProvinceTable,0,-1,-1},
	{BUSINESS_DEV,0,sizeof(FieldsDevTable)/sizeof(FieldsDevTable[0]),
	_T("DevTable"),FieldsDevTable,0,-1,3},
	{BUSINESS_HOUSE,0,sizeof(FieldsHouseTable)/sizeof(FieldsHouseTable[0]),
	_T("HouseTable"),FieldsHouseTable,0,-1,2},
	{BUSINESS_HOUSETYPE,0,sizeof(FieldsHouseTypeTable)/sizeof(FieldsHouseTypeTable[0]),
	_T("HouseTypeTable"),FieldsHouseTypeTable,0,-1,-1},
	{BUSINESS_PARTDEFENCE,0,sizeof(FieldsPartDefenceTable)/sizeof(FieldsPartDefenceTable[0]),
	_T("PartDefenceTable"),FieldsPartDefenceTable,0,-1,1},
	{BUSINESS_SCENE,0,sizeof(FieldsSceneTable)/sizeof(FieldsSceneTable[0]),
	_T("SceneTable"),FieldsSceneTable,0,-1,2},
	{BUSINESS_SCENEDEV,0,sizeof(FieldsSceneDevTable)/sizeof(FieldsSceneDevTable[0]),
	_T("SceneDevTable"),FieldsSceneDevTable,0,1,0},
	{BUSINESS_GUARDLOCK,0,sizeof(FieldsGuardLockTable)/sizeof(FieldsGuardLockTable[0]),
	_T("GuardLockTable"),FieldsGuardLockTable,0,-1,-1},
	{BUSINESS_LOCKCODE,0,sizeof(FieldsLockCodeTable)/sizeof(FieldsLockCodeTable[0]),
	_T("LockCodeTable"),FieldsLockCodeTable,0,-1,-1},
	{BUSINESS_SCHEDULE,0,sizeof(FieldsScheduleTable)/sizeof(FieldsScheduleTable[0]),
	_T("ScheduleTable"),FieldsScheduleTable,0,-1,-1},
	{BUSINESS_TIMER,0,sizeof(FieldsTimerTable)/sizeof(FieldsTimerTable[0]),
	_T("TimerTable"),FieldsTimerTable,0,-1,-1},
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -