myglobals.h

在WinCe平台上开发的数据库管理程序,里面有一个可排序列表控件的实现和Excel的CVS文件的读写类

#if  !defined(_MyGlobals_H_)
#define _MyGlobals_H_

extern CDataManage	g_hisOrder;					//1交易历史
extern CDataManage	g_todayOrder;				//2今日交易
extern CDataManage	g_hisViolation;				//3违规历史
extern CDataManage	g_secondNeed;				//4潜在需求
extern CDataManage	g_cigaretteInfo;			//5产品信息
extern CDataManage	g_adverProd;				//6竞争者产品
extern CDataManage  g_clientInfor;				//7客户信息
extern CDataManage	g_numberLimit;				//8产品数量限制
extern CDataManage	g_productLimit;				//9产品品牌限制
extern CDataManage	g_netResume;				//10出入网简历
extern CDataManage	g_resideArea;				//11辖区基本情况
extern CDataManage	g_monthPlan;				//12香烟月销售计划
extern CDataManage	g_sysInfo;					//13系统可更新的列表数据

WORD LoadAllFromTxt(void);
WORD SaveAllToTxt(void);


//1历史交易数据
#define HIS_PROD_NUMBER		0
#define HIS_IC_KEY			1
#define HIS_TIME			2
#define HIS_FACT_NUM		3
#define HIS_FACT_MONEY		4
#define HIS_VISIT_NUM		5
#define HIS_VISIT_MONEY		6
#define HIS_REMARK			7

//2今日交易数据
#define TOD_PROD_NUMBER		0
#define TOD_IC_KEY			1
#define TOD_TIME			2
#define TOD_VISIT_NUM		3
#define TOD_REMARK			4

//3违规数据字段宏
#define HVI_MANAGE			0
#define HVI_DATE			1
#define HVI_ADDRESS			2
#define HVI_REMARK			3
#define HVI_WRITER			4
#define HVI_UNIT			5
#define HVI_CONT1			6
#define HVI_CONT2			7
#define HVI_CONT3			8
#define HVI_CONT4			9
#define HVI_CONT5			10
#define HVI_CONT6			11
#define HVI_CONT7			12
#define HVI_CONT8			13
#define HVI_CONT9			14

//4潜在需求字段宏
#define SEC_NAME			0
#define SEC_TIME			1
#define SEC_CIG				2
#define SEC_OTHER			3
#define SEC_PRICE			4
#define SEC_MASS			5
#define SEC_SEVER			6
#define SEC_MODE			7

//5产品信息数据库字段宏
#define CIG_PROD_NUMBER		0	//产品编码
#define CIG_PROD_AREA		1	//产地
#define CIG_TRADEMARK		2	//牌号
#define CIG_SPEC			3	//规格
#define CIG_SORT			4	//类别
#define CIG_TUNE_PRICE		5	//调拨价
#define CIG_WHOL_PRICE		6	//批发价
#define CIG_RETAIL_PRICE	7	//零售价
#define CIG_REMARK			8	//备注

//6竞争者产品数据库字段宏
#define ADV_PROD_AREA		0
#define ADV_TRADEMARK		1
#define ADV_SPEC			2
#define ADV_SORT			3
#define ADV_NUMBER			4
#define ADV_IN_PRICE		5
#define ADV_RETAIL_PRICE	6
#define ADV_KEEP_INCOME		7
#define ADV_BATCH_RETAL_DIF	8
#define ADV_YEILD			9
#define ADV_CLIENT_JUDGE	10
#define ADV_REMARK			11
#define ADV_NET_MANAGE		12
#define ADV_RET_INCOME		13
#define ADV_HORT_DIVIDE		14
#define ADV_GOODS_HORT		15
#define ADV_BALANCE			16


//7客户信息数据库字段定义
#define CLI_IC_KEY			0
#define CLI_WRITE_DATE		1
#define CLI_NAME			2
#define CLI_SEX				3
#define CLI_BIRTHDAY		4
#define CLI_EDU_LEVEL		5
#define CLI_FAM_ADDRESS		6
#define CLI_COM_ADDRESS		7
#define CLI_ID_CARD			8
#define CLI_TELEPHONE		9
#define CLI_MAIL_NUM		10
#define CLI_REMARK			11

#define CLI_SHOP_NAME		12
#define CLI_PRINCIPAL		13
#define CLI_ADDRESS			14
#define CLI_PRI_TEL			15
#define CLI_VISIT_ROAD		16
#define CLI_LICENCE_NUM		17
#define CLI_SELL_NUM		18
#define CLI_MANAGE_AREA		19
#define CLI_MAIN_SELL		20
#define CLI_MANAGE_SIZE		21
#define CLI_SHELL_AREA		22

#define CLI_INNET_TIME		23
#define CLI_RESUM			24
#define CLI_HOUSE_MASTER	25
#define CLI_POPLATION		26
#define CLI_INCOME_LEVEL	27
#define CLI_DEPEND_LEVEL	28
#define CLI_MANAGE_STATION	29
#define CLI_MANAGE_ROAD		30
#define CLI_MANAGE_MAN		31
#define CLI_VSELL_DEPT		32
#define CLI_VSELL_ROAD		33
#define CLI_CLIENT_MANAGE	34
#define CLI_WHOLESALE_DEPT	35
#define CLI_GOODS_ROAD		36
#define CLI_GOODS_MAN		37

#define CLI_MANA_SORT		38
#define CLI_SERV_SORT		39
#define CLI_WORK_STYLE		40
#define CLI_ORDER_MODE		41
#define CLI_INNET_STATUS	42
#define CLI_STABILITY		43
#define CLI_SIZE_CLASS		44
#define CLI_WORTH_CLASS		45
#define CLI_PAYMENT_MODE	46

#define CLI_TOTAL_CAPITAL	47
#define CLI_SMOKE_CAPITAL	48
#define CLI_MOSTLY_WORK		49
#define CLI_SECOND_WORK		50
#define CLI_MANAGE_STATUS	51
#define CLI_TOTAL_LEVEL		52

#define CLI_GOODS_PLAN		53
#define CLI_GOODS_CYC		54
#define CLI_SEND_CYC		55
#define CLI_PRICE_AIM		56
#define CLI_HELP_PLAN		57
#define CLI_HELP_NOTE		58

#define CLI_RESIDE_AREA		59

//8产品数据限制数据库字段宏
#define NLI_IC_KEY			0					//IC卡号
#define NLI_DAY_LIMIT		1					//日限量
#define NLI_MON_LIMIT		2					//月限量

//9产品品牌限量数据库字段宏
#define PLI_IC_KEY			0					//IC卡号
#define PLI_PRO_NUM			1					//产品编码
#define PLI_DAY_LIMIT		2					//每日数量限制

//10出入网简历数据库字段宏
#define NRE_IC_KEY			0					//IC卡号
#define NRE_DATE			1					//时间
#define NRE_STATUS			2					//状态
#define NRE_REASON			3					//原因
#define NRE_TYPE			4					//类型
#define NRE_REMARK			5					//备注

//11辖区基本情况数据库
#define POP_RESIDE_AREA		0					//区域标识
#define POP_POPULATION		1					//区域内人口
#define POP_AVE_INCOME		2					//人均收入水平

//12香烟月销售计划
#define MPL_PROD_NUMBER		0					//产品编码
#define MPL_TIME			1					//时间
#define MPL_MONTH_PLAN		2					//月计划（条数）

//13系统可更新的列表数据记录索引宏
#define SIN_MANAGE_DEPT		0					//专卖管理所信息
#define SIN_MANAGE_ROAD		1					//稽查线信息
#define SIN_MANAGE_MAN		2					//专管员信息
#define SIN_VSELL_DEPT		3					//访销部信息
#define SIN_VSELL_ROAD		4					//访销线信息
#define SIN_VSELL_MANAGE	5					//客户经理信息
#define SIN_GOODS_DEPT		6					//配送中心（批发部）信息
#define SIN_GOODS_ROAD		7					//送货线信息
#define SIN_GOODS_MANAGE	8					//送货员信息
#define SIN_MANA_SORT		9					//专卖管理分类信息

#endif