cc_data_struct0615.h

wince下对sqlserver数据库的操作,增删改操作,单进程单线程

#pragma once

#ifndef __CC_PRIVE_DATA
#define __CC_PRIVE_DATA
#define CC_PSW_LEN			 9  //the length of the user password;
#define CC_OWNER_NAME_LEN	 21 //the length of the owner name;
#define CC_BORN_DATE_LEN	 9  //the length of the user's born date;
#define CC_IDENTI_NUM_LEN	 21 //the length of the user's certificate number; 
#define CC_CELLPHONE_LEN	 21 //the length of the user's cellular telephone;
#define CC_POSTCODE_LEN		 7  //the length of the user's postcode;
#define CC_ZONENUM_LEN	     6  //the length of the user's zonecode;
#define CC_ADDR_LEN		     61 //the length of the user's address;
#define CC_HOMEPHONE_LEN     21 //the length of the user's home phone;
#define CC_CCSERIAL_NUM_LEN	 15 //the length of the user's CC Code;
#define CC_KEEP_CODE_LEN	 10 //the length of the blank segment;
#define CC_DEVIE_NAME_LEN	 21 //the length of the device name;
#define CC_DEVICE_NUM_LEN	 21 //the length of the device number;
#define CC_SCENE_NAME_LEN	 21 //the length of the scene name;
#define CC_SCENE_DESCRIP_LEN 61 //the length of the scene description;
#define CC_TIP_CONTEN_LEN	 31 //the length of the bell's clue content
#define CC_SET_NAME_LEN	     21 //the length of the bell installer's name
#define CC_CARD_NUM_LEN	     16 //the length of the roomcard's number
#define CC_MEMB_NAME_LEN     21 //the length of the member's name
#define CC_ROOM_NAME_LEN     21 //the length of the room's name
#define CC_ROOM_DESCRIP_LEN	 61 //the length of the room's description
#define CC_RING_NAME_LEN	 21 //the length of the ring's name
#define CC_RING_PATH_LEN	 61 //the length of the ring's path
#define CC_DOOR_MAGCODE_LEN	 21 //the length of the door magnetism
#define CC_FRIEND_NAME_LEN	 21 //the length of the friend's name
#define CC_NUM_LEN			 16 //the length of the friend's number
#define CC_TITLE_LEN		 21 //the length of the memo's title
#define CC_TIPCONTENT_LEN	 101//the length of the memo's tip content
#define CC_SM_PHONE_LEN		 81 //the length of the phone which receive short message
#define CC_MAIL_NOTIFY_LEN   81 //the length of the E_mail notify
#define CC_PHONE_NUM_LEN	 81 //the length of the number of the phone which receive alarm
#define CC_EMAIL_LEN		 81 //the length of the E_mail which is used to alarm
#define CC_ALARM_TIP_LEN	 81 //the length of the alarm's tip content
#define CC_NAME_LEN			 21 //the length of the PuMei and common user's name
#define CC_OFFICEPHONE_LEN	 21 //the length of the PuMei and common user's office phone
#define CC_MAIL_LEN			 31 //the length of the PuMei and common user's E_mail
#define CC_ADDRESS_LEN		 61 //the length of the PuMei and common user's address
#define CC_REMARK_LEN		 81 //the length of the PuMei and common user's remark
#define CC_ALARM_NODE_LEN	 81 //the length of the number of the alarm node
#define CC_SPAYER_LEN		 21 //the length of the the storer's or payer's name
#define CC_SPAY_NAME_LEN	 30 //the length of the store or pay reason
#define CC_TEL_PHONE_LEN	 21 //the length of the phone number from another
#define PHONEBOOKGROUP_NAME_LEN 21
#define PHONEBOOK_NAME_LEN 21
#define PHONEBOOK_NUMBER_LEN 21

#define CC_PHOTO_PATH_LEN	 61; 
#define CC_BOROUGH_ID_LEN	 5
#define CC_PROVINCE_ID_LEN   5
#define CC_BOROUGH_NAME_LEN	 31
#define CC_PROVINCE_NAME_LEN 31
#define CC_ROOM_TYPE_NAME_LEN 21
#define CC_VOICE_TITLE_LEN	 21
#define CC_VOICE_USER_NAME_LEN	21
#define CC_VOICE_CONTEXT_LEN  61
#define CC_ALARM_NODE_NUM	10
#define CC_ALARM_ROOM_NODE_LEN	206

/*************************************************************/
/*************************************************************/
/****			Create by Eagegao  in 2004-12-17          ****/
/****		this struct identified the infomation of a    ****/
/****       user.if the infomation of the user is         ****/
/****       added,it the cell of the struct that is       ****/
/****       szKeepCode will be used as the added          ****/
/****       infomation.                                   ****/
/****       this struct won't be saved in the database    ****/
/*************************************************************/
/*************************************************************/  										
struct user_info_struct
{
	int  nCCID;								//中控ID	      int	4	由中控编号后4个字节生成
	char szLittleName[CC_OWNER_NAME_LEN];	//用户呢称	      char	20+1
	char szUserPsw[CC_PSW_LEN];				//用户密码	      char	8+1	数字,字符(不分大小写)
	char szAdminPsw[CC_PSW_LEN];			//超级管理员密码  char	8+1	数字,字符(不分大小写)
	char szPhonePsw[CC_PSW_LEN];			//电话密码	      char	8+1	数字,字符(不分大小写)
	char szOwnName[CC_OWNER_NAME_LEN];		//户主姓名	      char	20+1	
	char cSex;								//性别	          char	1	
	char szBornDate[CC_BORN_DATE_LEN];		//出生年月	      char	8+1	YYYYMMDD
	char cIdentiType;						//证件类型	      char	1	1_身份证, 2_军官证
	char szIdentiNum[CC_IDENTI_NUM_LEN];   	//证件号码	      char	20+1	
	char szCellPhone[CC_CELLPHONE_LEN];		//手机号码	      char	21	联系手机号码
	char szPostCode[CC_POSTCODE_LEN];		//邮编	          char	6+1	
	char szZoneNum[CC_ZONENUM_LEN];			//区号	          char	5+1
	char szAddress[CC_ADDR_LEN];			//地址	          char	60+1	
	char szHomePhone[CC_HOMEPHONE_LEN];		//住宅电话	      char	20+1	
	char szCcSerialNum[CC_CCSERIAL_NUM_LEN];//中控编号	      char 	14+1	
	int  nCircletId;						//小区ID	      int	4	0－表示没有选择小区
	char szKeepCode[CC_KEEP_CODE_LEN];		//保留字段	      char	10	保留
};
/*************************************************************/
/*************************************************************/
/****			Create by Eagegao  in 2004-12-17          ****/
/****		this struct identified the infomation of a    ****/
/****       user.if the infomation of the user is         ****/
/****       added,it the cell of the struct that is       ****/
/****       szKeepCode will be used as the added          ****/
/****       infomation.                                   ****/
/****       this struct won't be saved in the database    ****/
/*************************************************************/
/*************************************************************/  										
struct pc_user_info_struct
{
	int  nID;								//用户ID	      	 int	4	由服务器生成 
	char szUserPsw[CC_PSW_LEN];				//用户密码	      char	8+1	数字,字符(不分大小写)
	char szOwnName[CC_OWNER_NAME_LEN];		//户主姓名	      char	20+1	
	char szLittleName[CC_OWNER_NAME_LEN];	//用户呢称	      char	20+1
	char cSex;								//性别	          char	1	
	char szBornDate[CC_BORN_DATE_LEN];		//出生年月	      char	8+1	YYYYMMDD
	char cIdentiType;						//证件类型	      char	1	1_身份证, 2_军官证
	char szIdentiNum[CC_IDENTI_NUM_LEN];   	//证件号码	      char	20+1	
	char szCellPhone[CC_CELLPHONE_LEN];		//手机号码	      char	21	联系手机号码
	char szMail[CC_MAIL_LEN];				//邮件			  Char	31
	char szPostCode[CC_POSTCODE_LEN];		//邮编	          char	6+1	
	char szZoneNum[CC_ZONENUM_LEN];			//区号	          char	5+1	
	char szAddress[CC_ADDR_LEN];			//地址	          char	60+1

	char szKeepCode[CC_KEEP_CODE_LEN];		//保留字段	      char	10	保留
};


/*************************************************************/
/*************************************************************/
/****			Create by Eagegao  in 2004-12-17          ****/
/****		this struct identified the infomation of a    ****/
/****       borough.if the infomation of the borough is   ****/
/****       added,it the cell of the struct that is       ****/
/****       szKeepCode will be used as the added          ****/
/****       infomation.                                   ****/
/****       this struct won't be saved in the database    ****/
/*************************************************************/
/*************************************************************/
struct borough_info_struct
{
	char szBoroughNum[CC_ZONENUM_LEN];		//区号		char	5+1		只能是数字
	int nProvinceID;							//省ID		Int		4+1	
	char szBoroughName[CC_BOROUGH_NAME_LEN];	//区名字	Char	30+1	区号代表的名字
	char szKeepCode[CC_KEEP_CODE_LEN];			//保留字段	char	10		保留
};
/*************************************************************/
/*************************************************************/
/****			Create by Eagegao  in 2004-12-17          ****/
/****		this struct identified the infomation of a    ****/
/****       province.if the infomation of the province is ****/
/****       added,it the cell of the struct that is       ****/
/****       szKeepCode will be used as the added          ****/
/****       infomation.                                   ****/
/****       this struct won't be saved in the database    ****/
/*************************************************************/
/*************************************************************/
struct province_info_struct
{
	int nProvinceID;							//省ID		Int		4+1	
	char szProvinceName[CC_PROVINCE_NAME_LEN];	//省名称	Char	30+1	全国的所有省的名称
	char szKeepCode[CC_KEEP_CODE_LEN];			//保留字段	char	10		保留
};

/*************************************************************/
/*************************************************************/
/****			Create by Eagegao  in 2004-12-17          ****/
/****		this struct identified the infomation of a    ****/
/****       device.if the infomation of the device is     ****/
/****       added,it the cell of the struct that is       ****/
/****       szKeepCode will be used as the added          ****/
/****       infomation.                                   ****/
/****       this struct won't be saved in the database    ****/
/*************************************************************/
/*************************************************************/
struct device_info_struct
{
	int   nDeviceId;								//设备ID			int		4		设备的标识ID
	char  szDevieName[CC_DEVIE_NAME_LEN];			//设备名称			char	20+1	
	char  szDevieSerialNum[CC_DEVICE_NUM_LEN];	    //设备编号			char	10+1	厂家的设备编号
	int   nRoomId;									//房间ID			int		4		设备所属房间ID
	short nSystemAddr;								//系统地址			short	2		设备系统地址
	short nDeviceAddr;								//设备地址			short	2		节点的地址  0－表示虚设备
	short nDeviceType;								//设备类型			short	2		1－红外设备  2－用户设备  。。。其他待定义	
	short nDeviceStatus;							//设备当前状态      short	2		设备当前状态值,值范围根据设备类型而异,请参阅<设备规范说明>
	char  cDeviceIsOnline;							//设备在线状态      char	1		0－离线  1－在线	
	char  cDeviceIsEnable;							//设备停用/启用状态	char	1		0－启用 1－停用	
	int   nBindDeviceId;							//实设备ID			int		4		绑定的实设备ID
	int   nObjOpearation;							//操作源			int		4		0:中控 1：遥控器 2：设备面板 3：电话 4：web远控
	char  szKeepCode[CC_KEEP_CODE_LEN];				//保留字段			char	10		保留	
};
/*************************************************************/
/*************************************************************/
/****			Create by Eagegao  in 2004-12-17          ****/
/****		this struct identified the infomation of a    ****/
/****       sence.if the infomation of the sence is		  ****/
/****       added,it the cell of the struct that is       ****/
/****       szKeepCode will be used as the added          ****/
/****       infomation.                                   ****/
/****       this struct won't be saved in the database    ****/
/*************************************************************/
/*************************************************************/

struct sence_info_struct
{
	int  nSceneId;								//场景ID	int		4		场景的标识ID
	char szSceneName[CC_SCENE_NAME_LEN];		//场景名称	char	20		用户可自定义的名称
	int  nRoomId;								//房间ID	int		4		场景所属的房间ID 
	char cSceneProperty;						//场景属性	char	1		0－关 1－开	
	char cSceneType;							//场景类型	char	1		0－起夜 1－睡眠 2－离家 3－归家 4－会客 5－自定 6－家庭影院
	char szSceneDescrip[CC_SCENE_DESCRIP_LEN];	//描述		char	60+1	对场景的详细描述
	char szKeepCode[CC_KEEP_CODE_LEN];		    //保留字段	char	10		保留		
};
/*************************************************************/
/*************************************************************/
/****			Create by Eagegao  in 2004-12-17          ****/
/****		this struct identified the infomation of a    ****/
/****       sence_device.if the infomation of the		  ****/
/****        sence_device is added,it the cell of         ****/
/****       the struct that is szKeepCode will be         ****/
/****       used as the added infomation.                 ****/
/****       this struct won't be saved in the database    ****/
/*************************************************************/
/*************************************************************/
struct sence_device_info_struct
{
	int   nSceneId;						//场景ID	int		4	场景的标识ID
	int   nDeviceId;					//设备ID	int		4	设备的标识ID
	char  cSysStatus;					//系统状态	char	1	定义见设备表－>设备系统状态
	short nDevieValue;					//设备值	short	2	定义见设备表－>设备状态
	char  szKeepCode[CC_KEEP_CODE_LEN];	//保留字段	char	10	保留		
};
/*************************************************************/
/*************************************************************/
/****			Create by Eagegao  in 2004-12-17          ****/
/****		this struct identified the infomation of a    ****/
/****       timer.if the infomation of the timer is		  ****/
/****       added,it the cell of the struct that is       ****/
/****       szKeepCode will be used as the added          ****/
/****       infomation.                                   ****/
/****       this struct won't be saved in the database    ****/
/*************************************************************/
/*************************************************************/
struct timer_info_struct
{
	int   nTimerId;					//定时器ID		int		4	定时器的标识ID
	char  cTimerType;				//类型			char	1	1－一次性 2－每日 3－每周 4－每月 5－每年	
	int   nDate;					/*时间			int	4	根据类型决定
									类型―>时间定义
									1―>日期时间，time_t类型  
									2―>一天内的累计分钟，范围0－24×60－1
									3―>一周内的累计分钟，范围0－7×24×60－1，周日为0，
									4―>一月内的累计分钟，范围0－31×24×60－1
									5―>一年内的累计分钟，范围0－365×24×60－1*/
	char  cBusiType;				//业务类型		char	1	1－闹钟 2－日程 3－备忘录
	int   nBusiId;					//业务ID		int		4	根据业务类型确定的业务ID
	char  szKeepCode[CC_KEEP_CODE_LEN];//保留字段		char	10	保留		
};

/*************************************************************/
/*************************************************************/
/****			Create by Eagegao  in 2004-12-17          ****/
/****		this struct identified the infomation of a    ****/
/****       clock.if the infomation of the clock is		  ****/
/****       added,it the cell of the struct that is       ****/
/****       szKeepCode will be used as the added          ****/
/****       infomation.                                   ****/
/****       this struct won't be saved in the database    ****/
/*************************************************************/
/*************************************************************/
struct clock_info_struct
{
	int  nId;								//闹钟ID	int		4		闹钟的标识ID
	char szTipContent[CC_TIP_CONTEN_LEN];	//提示内容	char	30+1	
	char szSetName[CC_SET_NAME_LEN];	    //设置人	char	20+1	用卡用户名让用户选择
	int  nRingId;							//铃声ID	int		4		见铃声表－>铃声ID
	char szKeepCode[CC_KEEP_CODE_LEN];		//保留字段	char	10		保留
};

/*************************************************************/
/*************************************************************/
/****			Create by Eagegao  in 2004-12-17          ****/
/****		this struct identified the infomation of a    ****/
/****       ring.if the infomation of the ring is		  ****/
/****       added,it the cell of the struct that is       ****/
/****       szKeepCode will be used as the added          ****/
/****       infomation.                                   ****/
/****       this struct won't be saved in the database    ****/