busdata.h

关于数据库应用方面的例子

	{BUSINESS_TICKLER,0,sizeof(FieldsTicklerTable)/sizeof(FieldsTicklerTable[0]),
	_T("TicklerTable"),FieldsTicklerTable,0,-1,-1},
	{BUSINESS_CLOCK,0,sizeof(FieldsClockTable)/sizeof(FieldsClockTable[0]),
	_T("ClockTable"),FieldsClockTable,0,-1,-1},
	{BUSINESS_RING,0,sizeof(FieldsRingTable)/sizeof(FieldsRingTable[0]),
	_T("RingTable"),FieldsRingTable,0,-1,-1},
	{BUSINESS_CARD,0,sizeof(FieldsCardTable)/sizeof(FieldsCardTable[0]),
	_T("CardTable"),FieldsCardTable,0,-1,-1},
	{BUSINESS_CARDTIMER,0,sizeof(FieldsCardTimerTable)/sizeof(FieldsCardTimerTable[0]),
	_T("CardTimer"),FieldsCardTimerTable,0,-1,1},
	{BUSINESS_PASSRECORD,0,sizeof(FieldsPassRecord)/sizeof(FieldsPassRecord[0]),
	_T("PassRecord"),FieldsPassRecord,0,-1,1},
	{BUSINESS_VOICEMSG,0,sizeof(FieldsVoiceMsgTable)/sizeof(FieldsVoiceMsgTable[0]),
	_T("VoiceMsgTable"),FieldsVoiceMsgTable,0,-1,-1},
	{BUSINESS_ALARMCONFIG,0,sizeof(FieldsAlarmConfigTable)/sizeof(FieldsAlarmConfigTable[0]),
	_T("AlarmConfigTable"),FieldsAlarmConfigTable,0,-1,-1},
	{BUSINESS_ALARMSPRING,0,sizeof(FieldsAlarmSpringTable)/sizeof(FieldsAlarmSpringTable[0]),
	_T("AlarmSpringTable"),FieldsAlarmSpringTable,0,-1,1},
	{BUSINESS_ALARMNOTIFY,0,sizeof(FieldsAlarmNotifyHisTable)/sizeof(FieldsAlarmNotifyHisTable[0]),
	_T("AlarmNotifyHisTable"),FieldsAlarmNotifyHisTable,0,-1,1},

	{BUSINESS_INFRAREFUN,0,sizeof(FieldsInfrareFunTable)/sizeof(FieldsInfrareFunTable[0]),
	_T("InfrareFunTable"),FieldsInfrareFunTable,0,-1,2},
	{BUSINESS_INFRAREFUNBIND,0,sizeof(FieldsInfrareFunBindTable)/sizeof(FieldsInfrareFunBindTable[0]),
	_T("InfrareFunBindTable"),FieldsInfrareFunBindTable,0,-1,-1},


	{BUSINESS_OUTGOING,0,sizeof(FieldsOutgoingRecordTable)/sizeof(FieldsOutgoingRecordTable[0]),
	_T("OutgoingRecordTable"),FieldsOutgoingRecordTable,0,-1,-1},
	{BUSINESS_ADDRLIST_GROUP,0,sizeof(FieldsAddrGroupTable)/sizeof(FieldsAddrGroupTable[0]),
	_T("AddrGroupTable"),FieldsAddrGroupTable,0,-1,2},
	{BUSINESS_ADDRLIST_PT,0,sizeof(FieldsPTAddrListTable)/sizeof(FieldsPTAddrListTable[0]),
	_T("PTAddrListTable"),FieldsPTAddrListTable,0,-1,1},
	{BUSINESS_ADDRLIST_PM,0,sizeof(FieldsPMAddrListTable)/sizeof(FieldsPMAddrListTable[0]),
	_T("PMAddrListTable"),FieldsPMAddrListTable,0,-1,1},

	{BUSINESS_TELVIDEORECORD,0,sizeof(FieldsTelVideoRecordTable)/sizeof(FieldsTelVideoRecordTable[0]),
	_T("TelVideoRecordTable"),FieldsTelVideoRecordTable,0,-1,-1},
	{BUSINESS_INTERFPHONERECORD,0,sizeof(FieldsInterPhoneRecordTable)/sizeof(FieldsInterPhoneRecordTable[0]),
	_T("InterPhoneRecordTable"),FieldsInterPhoneRecordTable,0,-1,-1},


	{BUSINESS_SHORTMSG,0,sizeof(FieldsShortMsgTable)/sizeof(FieldsShortMsgTable[0]),
	_T("ShortMsgTable"),FieldsShortMsgTable,0,-1,-1}


};
//组合业务字段数据
//MULTIBUS_HOUSE_DEVNUM  房间及其设备数量信息

BusFieldStruct  FieldsHouseDevNumInfo[]=
{
	{_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},

	{_T("TypeName"),DATA_NVARCHAR,CC_ROOM_TYPE_NAME_LEN},
	{_T("DevCount"),DATA_INT,4}
};

//#define MULTIBUS_CCINFO				5020	//中控用户信息
BusFieldStruct  FieldsCCInfoDetail[]=
{
	{_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},

	{_T("SectionName"),DATA_NVARCHAR,CC_BOROUGH_NAME_LEN},

};
//#define	MULTIBUS_DEV_HOUSENAME		//设备房间信息
#define DEVHOUSE_DEVADDR_POS	8+CC_DEVIE_NAME_LEN+CC_DEVICE_NUM_LEN
#define DEVHOUSE_DEVVALUE_POS	14+CC_DEVIE_NAME_LEN+CC_DEVICE_NUM_LEN
BusFieldStruct  FieldsDevHouseName[]=
{
	{_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},

	{_T("HouseName"),DATA_NVARCHAR,CC_ROOM_NAME_LEN}

};

//#define	MULTIBUS_SENCE_HOUSENAME	//查询场景及其房间信息
BusFieldStruct  FieldsSceneHouseName[]=
{
	{_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},

	{_T("HouseName"),DATA_NVARCHAR,CC_ROOM_NAME_LEN}

};


//#define	MULTIBUS_SENCE_HOUSENAME_DEVNUM	//场景及其房间设备信息
//查询所有，查询指定房间ID（关联外键）
BusFieldStruct  FieldsSceneHouseNameDevNum[]=
{
	{_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},

	{_T("HouseName"),DATA_NVARCHAR,CC_ROOM_NAME_LEN},
	{_T("DevNum"),DATA_INT,4}

};


//#define	MULTIBUS_SENCE_HOUSENAME_DEVNAME	//场景、房间、设备
BusFieldStruct  FieldsSceneHouseNameDevName[]=
{

	{_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},

	{_T("Type"),DATA_SMALLINT,2},
	{_T("DevName"),DATA_NVARCHAR,CC_DEVIE_NAME_LEN},
	{_T("HouseName"),DATA_NVARCHAR,CC_ROOM_NAME_LEN}
};
//#define	MULTIBUS_CARD_TIME			//门卡及其有效时间
BusFieldStruct  FieldsCardTime[]=
{
	{_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},

	{_T("Idx"),DATA_INT,4},
	{_T("Type"),DATA_TINYINT,1},
	{_T("BeginTime"),DATA_INT,4},
	{_T("EndTime"),DATA_INT,4}

};

//#define	MULTIBUS_SCHEDULEDETAIL		//日程详细信息	
BusFieldStruct  FieldsScheduleDetail[]=
{
	{_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},

	{_T("HouseName"),DATA_NVARCHAR,CC_ROOM_NAME_LEN},	//添加房间名称
	{_T("ObjectName"),DATA_NVARCHAR,CC_DEVIE_NAME_LEN},
	{_T("ObjectType"),DATA_TINYINT,1},		//添加对象类型，主要处理场景的

	{_T("BeginType"),DATA_TINYINT,1},
	{_T("BeginTime"),DATA_INT,4},
	{_T("EndType"),DATA_TINYINT,1},
	{_T("EndTime"),DATA_INT,4}

};

//#define	MULTIBUS_CLOCKDETAIL	//闹钟详细信息	5007
BusFieldStruct  FieldsClockDetail[]=
{
	{_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},
	
	{_T("TimerID"),DATA_INT,4},
	{_T("Type"),DATA_TINYINT,1},
	{_T("Time"),DATA_INT,4},
	{_T("RingName"),DATA_NVARCHAR,CC_RING_NAME_LEN},
	{_T("FilePath"),DATA_NVARCHAR,CC_RING_PATH_LEN}
};

//#define	MULTIBUS_TICKLERDETAIL	//备忘录详细信息	5008
BusFieldStruct  FieldsTicklerDetail[]=
{
	{_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},

	{_T("TimeType"),DATA_TINYINT,1},
	{_T("RunTime"),DATA_INT,4},
	{_T("RingName"),DATA_NVARCHAR,CC_RING_NAME_LEN},
	{_T("RingPath"),DATA_NVARCHAR,CC_RING_PATH_LEN}

};

//#define	MULTIBUS_PARTSAFTY_HOUSENAME	//局部设防信息
BusFieldStruct  FieldsPartSaftyHouseName[]=
{
	{_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},

	{_T("HouseName"),DATA_NVARCHAR,CC_ROOM_NAME_LEN}

};

//#define	MULTIBUS_LOCK_GUARD		//门磁门禁信息
BusFieldStruct  FieldsLockGuard[]=
{
	{_T("LockID"),DATA_INT,4},
	{_T("Code"),DATA_NVARCHAR,CC_DOOR_MAGCODE_LEN},
	{_T("Reserve"),DATA_NVARCHAR,10},

	{_T("LockName"),DATA_NVARCHAR,CC_DEVIE_NAME_LEN},
	{_T("Idx"),DATA_INT,4},
	{_T("GuardID"),DATA_INT,4},
	{_T("GuardName"),DATA_NVARCHAR,CC_DEVIE_NAME_LEN}

};
//#define	MULTIBUS_GUARD_NOLOCK	//未绑定的门禁信息
BusFieldStruct  FieldsGuardNoLock[]=
{

	{_T("GuardID"),DATA_INT,4},
	{_T("GuardName"),DATA_NVARCHAR,CC_DEVIE_NAME_LEN},
	{_T("HouseName"),DATA_NVARCHAR,CC_ROOM_NAME_LEN}
};
//#define	MULTIBUS_PASSRECORD_DETAIL	5013	//进出记录的详细信息
BusFieldStruct  FieldsPassRecordDetail[]=
{

	{_T("RecordID"),DATA_INT,4},
	{_T("CardID"),DATA_INT,4},
	{_T("UserName"),DATA_NVARCHAR,CC_MEMB_NAME_LEN},
	{_T("Time"),DATA_INT,4},
	{_T("DevID"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN},

	{_T("DevName"),DATA_NVARCHAR,CC_DEVIE_NAME_LEN},	//门禁设备名称
	{_T("CardNum"),DATA_NVARCHAR,CC_CARD_NUM_LEN}		//卡号
};
//#define	MULTIBUS_ALARMCONFIG_DETAIL	5015	//报警设置的详细信息（根据ID查询一条记录）
BusFieldStruct  FieldsAlarmConfigDetail[]=
{
	{_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},

	{_T("RingName"),DATA_NVARCHAR,CC_RING_NAME_LEN}
};
//#define	MULTIBUS_ALARMSPRING_DETAIL	5014	//查询所有的报警触发详细记录(或者当前报警)
BusFieldStruct  FieldsAlarmSpringDetail[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("AlarmTypeID"),DATA_INT,4},
	{_T("DevNum"),DATA_TINYINT,1},
	{_T("DevIDs"),DATA_NVARCHAR,CC_ALARM_NODE_NUM*sizeof(int)},
	{_T("Time"),DATA_INT,4},
	{_T("IsCurAlarm"),DATA_TINYINT,1},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN},

	{_T("AlarmNodes"),DATA_NVARCHAR,CC_ALARM_NODE_NAME_LEN},
	{_T("AlarmRooms"),DATA_NVARCHAR,CC_ALARM_ROOM_NAME_LEN}

};
//#define	MULTIBUS_ALARMNOTIFY_DETAIL	5016	//报警通知的详细信息
BusFieldStruct  FieldsAlarmNotifyDetail[]=
{
	{_T("Idx"),DATA_INT,4},
	{_T("AlarmSpingID"),DATA_INT,4},
	{_T("SendType"),DATA_INT,4},
	{_T("NotifyObject"),DATA_INT,4},
	{_T("RingID"),DATA_INT,4},
	{_T("Result"),DATA_INT,4},
	{_T("Reserve"),DATA_NVARCHAR,CC_KEEP_CODE_LEN},

	{_T("AlarmTypeID"),DATA_INT,4},
	{_T("SpringTime"),DATA_INT,4}

};
//MULTIBUS_REMOTE_BIND		5017	//遥控器绑定信息表
BusFieldStruct  FieldsRemoteFunBind[]=
{
	{_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},

	{_T("Name"),DATA_NVARCHAR,CC_DEVIE_NAME_LEN},

};
//#define MULTIBUS_SCENEDEVALL		5021	//场景下设备＋虚设备＋加同一房间的红外收发节点
#define DEVALL_ORGADDR_POS	4
#define DEVALL_ORGADDR_VALUE	10
#define DEVALL_REALADDR_POS	18
#define DEVALL_REALADDR_VALUE	24
#define DEVALL_IRADDR_POS	32
#define DEVALL_IRADDR_VALUE	38
BusFieldStruct  FieldsSceneDevAll[]=
{

	{_T("OrgDevID"),DATA_INT,4},
	{_T("OrgSysAddr"),DATA_SMALLINT,2},
	{_T("OrgDevAddr"),DATA_SMALLINT,2},
	{_T("OrgDevType"),DATA_SMALLINT,2},
	{_T("OrgValue"),DATA_SMALLINT,2},
	{_T("OrgIsOnLine"),DATA_TINYINT,1},
	{_T("OrgSysStatus"),DATA_TINYINT,1},

	{_T("RealDevID"),DATA_INT,4},
	{_T("RealSysAddr"),DATA_SMALLINT,2},
	{_T("RealDevAddr"),DATA_SMALLINT,2},
	{_T("RealDevType"),DATA_SMALLINT,2},
	{_T("RealValue"),DATA_SMALLINT,2},
	{_T("RealIsOnLine"),DATA_TINYINT,1},
	{_T("RealSysStatus"),DATA_TINYINT,1},

	{_T("IRDevID"),DATA_INT,4},
	{_T("IRSysAddr"),DATA_SMALLINT,2},
	{_T("IRDevAddr"),DATA_SMALLINT,2},
	{_T("IRDevType"),DATA_SMALLINT,2},
	{_T("IRValue"),DATA_SMALLINT,2},
	{_T("IRIsOnLine"),DATA_TINYINT,1},
	{_T("IRSysStatus"),DATA_TINYINT,1},

	{_T("Oper"),DATA_TINYINT,1},
	{_T("Value"),DATA_SMALLINT,2},

};
//ACTION_ROOMIR_QUERYBYADDR			21//根据系统地址、设备地址查找同一房间下的房间及红外设备MULTIBUS_ROOM_IR		5022	//房间及红外设备，结构Dev_Room_IR
BusFieldStruct  FieldsRoomIr[]=
{
	{_T("roomname"),DATA_NVARCHAR,CC_ROOM_NAME_LEN},
	{_T("irname"),DATA_NVARCHAR,CC_DEVIE_NAME_LEN},
	{_T("sysAddr"),DATA_SMALLINT,2},
	{_T("DevAddr"),DATA_SMALLINT,2},
};
//ACTION_ROOM_GUARDLOCK_QUERYBYADDR	21//根据系统地址设备地址查找 MULTIBUS_ROOM_GUARDLOCK		5023	//门禁房间及门磁码 Dev_Room_GuardLock
BusFieldStruct  FieldsRoomGuardLock[]=
{