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

📄 db_struct.51.h

📁 在SCO UNIX制定界面程序 可根据文件配制菜单,而不必修改源程序,非常方便
💻 H
📖 第 1 页 / 共 2 页
字号:

/*=============================================================
功能: 		数据库表对应的 C 结构定义
作者:
===============================================================*/

/*================ program_mode 表 ================*/
$typedef	struct {
	int	hostid;
	char	program_name[41];
	char	exec_name[31];
	char	exec_para[31];
	char	used[2];
} S_program_mode;

/*================ cen_oper 表 ================*/
$typedef	struct {
	char	oper_no[3];
	char	oper_pwd[5];
	char	oper_name[11];
	double	max_auth_amt;		/* 最大授权金额 */
	char	oper_flag[2];
	char	oper_state[2];
	char	power[65];
	char	father[3];
} S_cen_oper;


/*================ posls,history_ls,err_posls 表 ================*/
$typedef	struct {
	char	sd_bankid[12];
	char	fk_bankid[12];
	char	source_bankid[12];
	char	target_bankid[12];

	char	local_date[11];
	char	remote_date[11];
	char	settle_date[11];
	char	equip_date[11];
	char	equip_time[9];

	char	terminal_id[9];
	char	merchant_id[16];
	char	mcc[5];
	char	bank_type[3];

	char	card_type[3];
	char	card_no[20];
	char	expire[5];
	char	person_id[19];
	char	card_no2[20];

	int	trans_type;
	int	old_type;

	long	trace;
	long	invoice;
	long	void_invoice;
	long	hostls;
	long	batch_no;
	char	authno[7];
	char 	rrn[13];
	long	gcc_trace;

	double	amount;
	double	adjust_amount;
	
	char	currency_code[4];

	char	res_flag[2];
	char	flag1[2];
	char	err_flag[2];
	char	ret_code[4];
/* add by xingjun as nas-u-72-990406 */
	char	ret_bank[5];
	char	refunded[2];
	char	oper_no[3];
	char	down_flag[2];
	char	up_flag[2];
	char	manunal_flag[2];
	
	char	dac[17];
} S_posls;


/*============== sys_param 表 =============== */
$typedef struct {
	char	center[12];
	char	center_name[41];
	char	headquarter[12];
	char	bank_type[3];

	char	local_date[11];
	char	settle_time[9];

	char	status[2];
	char	settle[2];

	long	hostls;
	int	keep_history;
	int	keep_saf;

	double	max_auth_amt;

	char	trans_table[33];

	long	void_time;
	char	t_posls[2];
} S_sys_param;

/*================ Store_And_Forward 表 ================*/
$typedef	struct {
	char	sd_bankid[12];
	char	fk_bankid[12];
	char	source_bankid[12];
	char	target_bankid[12];

	char	local_date[11];
	char	remote_date[11];
	char	equip_date[11];
	char	equip_time[9];

	char	terminal_id[9];
	char	merchant_id[16];
	char	mcc[5];
	char	bank_type[3];

	char	card_type[3];
	char	card_no[20];
	char	expire[5];
	char	person_id[19];
	char	card_no2[20];
	char	mode[4];

	int	trans_type;
	int 	old_type;
	int	void_type;
	
	int	target_hostid;

	long	trace;
	long	invoice;
	long	void_invoice;
	long	hostls;
	long	void_hostls;
	long	batch_no;
	char	authno[7];
	char 	rrn[13];
	long	gcc_trace;

	double	amount;
	double	adjust_amount;
	
	char	currency_code[4];

	char	flag1[2];
	char	ret_code[4];
/* add by xingjun as nas-u-72-990406 */
	char	ret_bank[5];
	char	oper_no[3];
	
	char	dac[17];
} S_saf;

/*================ Advice 表 ================*/
$typedef	struct {
	char	sd_bankid[12];
	char	fk_bankid[12];
	char	source_bankid[12];
	char	target_bankid[12];

	char	local_date[11];
	char	remote_date[11];
	char	equip_date[11];
	char	equip_time[9];

	char	terminal_id[9];
	char	merchant_id[16];
	char	mcc[5];
	char	bank_type[3];

	char	card_type[3];
	char	card_no[20];
	char	expire[5];
	char	person_id[19];
	char	card_no2[20];
	char	mode[4];

	char	track2[38];
	char	track3[105];

	int	trans_type;
	int 	old_type;
	int	void_type;
	
	int	target_hostid;

	long	trace;
	long	invoice;
	long	void_invoice;
	long	hostls;
	long	void_hostls;
	long	batch_no;
	char	authno[7];
	char 	rrn[13];
	long	gcc_trace;

	double	amount;
	double	adjust_amount;
	
	char	currency_code[4];

	char	flag1[2];
	char	ret_code[4];
	char	oper_no[3];
	
	char	dac[17];
} S_adv;

/*============== terminal 表 =============== */
$typedef struct {
	char	terminal_id[9];
	char	merchant_id[16];
	char	foreign_mcc[5];
	char	rmbc_mcc[5];
	char	pos_flag[2];
	char	device_name[31];
	char	soft_ver[31];
	char	device_flag[2];
	char	inst_address[41];
	char	inst_date[11];
	char	start_date[11];
	char	download[2];
	int	mode_type;
	char	card_enable[8];		/* 受理卡种项 */
	char	settle_time[9];
} S_terminal;


/*============== pos_param 表 =============== */
$typedef struct {
	int	mode_type;
	char	tel1[16];
	char	tel2[16];
	char	tel3[16];
	int	time_out;
	char	printer[3];
	char	cre_trans_enb[33];
	char	deb_trans_enb[33];
	char	for_trans_enb[33];
	long	start_trace;
	long	start_invoice;
	long	start_batchno;
} S_pos_param;

/*============== shop_base 表 =============== */
$typedef struct {
	char	merchant_id[16];
	char	merchant_name_chn[31];
	char	merchant_name_eng[31];
	char	abr_merchant_name_chn[16];
	char	abr_merchant_name_eng[16];
	char	address_chn[41];
	char	address_eng[41];
	char	telephone[16];
	char	zipcode[7];
	char	fax[16];
	char	manager[9];
	long	hmd_number;
	long	edc_number;
	char	state[2];
	char	date[11];
} S_shop_base;

/*============== shop_card 表 =============== */
$typedef struct {
	char 	merchant_id[16];
	char	card_enable[8];
	
	char 	visa_merchant_id[16];
	char	visa_mcc[5];
	double	visa_rebate;
	double	visa_limit;
	
	char 	master_merchant_id[16];
	char	master_mcc[5];
	double	master_rebate;
	double	master_limit;
	
	char 	ae_merchant_id[16];
	char	ae_mcc[5];
	double	ae_rebate;
	double	ae_limit;
	
	char 	dinner_merchant_id[16];
	char	dinner_mcc[5];
	double	dinner_rebate;
	double	dinner_limit;
	
	char 	jcb_merchant_id[16];
	char	jcb_mcc[5];
	double	jcb_rebate;
	double	jcb_limit;
	
	char	rmbc_mcc[5];
	double	rmbc_rebate;
	double	rmbc_limit;

	double	debit_rebate;
} S_shop_card;

/* add by xingjun as nas-a-148-990425 */
/*=============== jgbm_ctrl 表 ==============*/
typedef struct {
	char	bankid[12];
	char	bankid_father[12];
	char	bank_ctrl[65];
} S_jgbm_ctrl;

/*============== shop_account 表 ==============*/
$typedef struct {
	char	merchant_id[16];
	char	currency_code[4];
	char	settle_currency_code[4];
	char	rate_level[2];
	
	char	rmb_account_no[41];
	char	rmb_bank[51];
	char	usd_account_no[41];
	char	usd_bank[51];
	char	jpy_account_no[41];
	char	jpy_bank[51];
	char	hkd_account_no[41];
	char	hkd_bank[51];
	
	char	settle_time[9];
} S_shop_account;

/*============== pos_oper 表 =============== */
$typedef struct {
	char	terminal_id[9];
	char	oper_no[3];
	char	oper_name[11];
	char	oper_pwd[5];
	char	oper_flag[2];
} S_pos_oper;

/*============== jgbm_basic 表 =============*/
$typedef struct {
	char	bankid[12];
	char	bankname[31];
	char	headquarter[12];	/* 管辖行 */
	char	bank_type[3];
	char	address[51];
	char	zipcode[7];
	char	fax[16];
	char	telex[16];
	char	stl_tele[16];
	char	auth_tele[16];
	char	head_name[11];
	char	head_tele[16];
	char	mng1_name[11];
	char	mng1_tele[16];
	char	mng2_name[11];
	char	mng2_tele[16];
	char	mng3_name[11];
	char	mng3_tele[16];
	char	auth_mng_name[11];
	char	auth_mng_tele[16];
	char	stl_mng_name[11];
	char	stl_mng_tele[16];
	char	card_mng_name[11];
	char	card_mng_tele[16];
	char	mark_mng_name[11];
	char	mark_mng_tele[16];
	char	tech_mng_name[11];
	char	tech_mng_tele[16];
	char	sum_mng_name[11];
	char	sum_mng_tele[16];
	char	email[45];
	long	employee;
	long	cardnum;
	long	shopnum;
} S_jgbm_basic;

/*============== jgbm_equip 表 =============*/
$typedef struct {
	char	bankid[12];
	char	nas_host[16];
	char	freq[6];
	char	memory[6];
	char	hdisk[6];
	char	nas_sdate[11];
	char	connect_mode[16];
	char	data_format[16];
	char	x25_card[16];
	char	nac[16];
	char	router[16];
	char	soft_ver[6];
	char	opera_host[21];
	char	database[16];
	char	app_system[16];
	char	opera_sdate[11];
	char	developer[16];
	char	os[16];
	char	pcm[16];
	long	edc_num;
	char	nap_sdate[11];
	char	cardpool_sdate[11];
} S_jgbm_equip;

/*============== jgbm_base 表 =============*/
$typedef struct {
	char	bankid[12];
	char	bankname[31];
	char	bank_type[3];
	char	ip_addr[21];
	char	ip_gateway[21];
	char	ip_addr2[21];
	char	ip_gateway2[21];
	char	ip_addr3[21];
	char	ip_gateway3[21];
	char	x25_addr[21];
	int	time_out;
	char	settle_flag[2];
	char	moni_enable[2];
	int	interval;
	char	log_stat[2];
	char	e_settle[2];
	char	hostno[3];
} S_jgbm_base;

/*=============== jgbm_account 表 ==============*/
$typedef struct {
	char	bankid[12];
	char	currency_code[4];
	char	rate_level[2];
	char	settle_flag[2];
	char	rmb_account_no[41];
	char	rmb_bank[51];
	char	usd_account_no[41];
	char	usd_bank[51];
	char	jpy_account_no[41];
	char	jpy_bank[51];
	char	hkd_account_no[41];
	char	hkd_bank[51];

⌨️ 快捷键说明

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