dbfunc.c

UNIX/LINUX平台下面SMS网管原代码

/*
** Generated code begins here.
*/
# line 1 "dbfunc.cp"

/*
** This file was generated on Sat Dec 17 09:11:17 2005
**  by Sybase Embedded SQL Preprocessor Sybase ESQL/C Precompiler/12.5.1 ASE Ed
** ition/P-EBF11370/DRV.12.5.1/Linux Intel/Enterprise Linux/BUILD1251-004/OPT/M
** on Aug 11 09:43:36 2003
*/
# line 1 "dbfunc.cp"
# line 1 "dbfunc.cp"
#define _SQL_SCOPE extern
# line 1 "dbfunc.cp"
#include <sybhesql.h>

/*
** Generated code ends here.
*/
# line 1 "dbfunc.cp"
#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <time.h>
#include <memory.h>
#include <sys/types.h>

#include "etc.h"
#include "bms_micro.h"
#include "bms_strcdef.h"

#include "sybtesql.h"
#include "sybhesql.h"


/*
** SQL STATEMENT: 1
** EXEC SQL INCLUDE SQLCA;

*/
# line 15 "dbfunc.cp"
# line 15 "dbfunc.cp"
SQLCA sqlca;

/*
** Generated code ends here.
*/
# line 15 "dbfunc.cp"


/*
** SQL STATEMENT: 2
** EXEC SQL INCLUDE "bms_sql.h";
*/
# line 1 "/usr/agent/incl/bms_sql.h"

#ifndef __BMS_SQL
#define __BMS_SQL

#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <time.h>


/*
** SQL STATEMENT: 3
** EXEC SQL INCLUDE SQLCA;

*/
# line 10 "/usr/agent/incl/bms_sql.h"
# line 10 "/usr/agent/incl/bms_sql.h"
SQLCA sqlca;

/*
** Generated code ends here.
*/
# line 10 "/usr/agent/incl/bms_sql.h"



/*
** SQL STATEMENT: 3
** EXEC SQL BEGIN DECLARE SECTION;

*/
# line 12 "/usr/agent/incl/bms_sql.h"

char sZoneno	[  5 + 1];
char sCid	[ 11 + 1];
short sBid	;
char sPwd	[ 16 + 1];
short sStatus	;
char sAid	[  4 + 1];
char sAccount	[ 30 + 1];
char sOptCode	[  4 + 1];
char sHostId	[  4 + 1];
char sDate	[ 10 + 1];
char sTeller	[  5 + 1];

/* bms teller define */
typedef struct {
	char zoneno		[  5 + 1];
	char teller		[  5 + 1];
	char brach		[  9 + 1];
	char name		[ 10 + 1];
	char group_id		[  2 + 1];
	char teller_type	[  1 + 1];
	char teller_level	[  2 + 1];
	char passwd		[ 16 + 1];
	short status		;
	char login_flag		[  1 + 1];
	char login_ip		[ 15 + 1];
	char reg_date		[ 19 + 1];
	char reg_teller		[  5 + 1];
	char disa_date		[ 19 + 1];
	char disa_teller	[  5 + 1];
	char modi_date		[ 19 + 1];
	char modi_teller	[  5 + 1];
} SQL_TELLER;

/* bms trade serial define */
typedef struct 
{
	char teller		[ 5 + 1];
	long serial		;
} SQL_TRADE_SERIAL;

/* bms tellerlog define */
typedef struct
{
	char  brach		[  9 + 1];
	char  teller		[  5 + 1];
	short optcode		;
	char  oper_date		[ 10 + 1];
	char  oper_time		[  8 + 1];
	char  tablename		[ 18 + 1];
	char  pkey		[ 50 + 1];
	short operflag		;
	char  authtlno		[  5 + 1];	
	char  terminal		[  8 + 1];
	char  oper_notes	[ 50 + 1];
} SQL_TELLERLOG;

/* bms trade_ctl define */
typedef struct
{
	short optcode		;
	char opt_name		[  30 + 1];
	char bms_module		[  60 + 1];
	char svr_type		[   1 + 1];
	short busin_type	;
	short trade_type	;
	char svr_mode		[   1 + 1];
	char form1		[ 400 + 1];
	char form2		[ 400 + 1];
	short comm_mode		;
	short host_optcode	;
	char host_ip		[  20 + 1];
	short host_port		;
	short commtimeout	;
	char timectrlf		[   1 + 1];
	char servstarttime	[   8 + 1];
	char servendtime	[   8 + 1];
	short status		;
} SQL_TRADE_CTL;

/* bms person_info define */
typedef struct
{
	char  zoneno		[  5 + 1];
	char  cid		[ 11 + 1];
	char  name		[ 30 + 1];
	char  engname		[ 60 + 1];
	char  engcard		[ 20 + 1];
	short sex		;
	short ic_type		;
	char  ic_no		[ 18 + 1];
	char  ratepayno		[ 20 + 1];
	char  insrncno		[ 20 + 1];
	char  ctrycode		[  3 + 1];
	char  mcall_id		[ 20 + 1];
	char  ncall_id		[ 20 + 1];
	short pacetype	 	;
	char  birthday		[ 10 + 1];
	short marriage		;
	short study		;
	short techlvl		;
	short job		;
	char  consort		[ 10 + 1];
	char  interest		[ 90 + 1];
	char  append_info	[ 40 + 1];
	char  address1		[ 60 + 1];
	char  zip		[  6 + 1];
	char  address2		[ 60 + 1];
	char  mobile		[ 22 + 1]; 
	char  fax		[ 22 + 1];
	char  phone1		[ 22 + 1];
	char  email		[ 40 + 1];
	char  empdate		[ 10 + 1];
	char  job_stat		[  2 + 1];
	char  unitname		[ 60 + 1];
	short utypeid		;
	char  phone2		[ 22 + 1];
	char  postcode		[  6 + 1];
	short mthincome		;
	char  banka   		[  1 + 1];
	char  widno		[ 10 + 1];
	short status		;
	char  vip		[  1 + 1];
	char  func_def		[ 20 + 1];
	short fee_type		;
	char  accofcharge    	[ 20 + 1];
	short crednc		;
	char  remark		[200 + 1];
	char  idexpire  	[ 10 + 1];
	short contactmode	;
	char  lastlogindate	[ 19 + 1]; 
	char  lasttxdate   	[ 19 + 1];  
	char  lasttxchno	[  3 + 1];
	char  txchmask		[ 20 + 1];
	short out_mode		;
	char  reg_mode		[  1 + 1];
	char  reg_teller	[  5 + 1];
	char  reg_brch		[  9 + 1];
	char  reg_date		[ 19 + 1];
	char  modi_teller	[  5 + 1];
	char  modi_brch		[  9 + 1];
	char  modi_date		[ 19 + 1];
} SQL_PERSON_INFO;

/* bms ps_accinfo define */
typedef struct 
{
	char zoneno		[  5 + 1];
	char cid		[ 11 + 1];
	char ppasswd		[ 16 + 1];
	char spasswd		[ 16 + 1];
	short passdaycurr	;
	short passtotcurr	;
	short status		;
	short acct_num		;
	long detail_num		;
	char reg_teller		[  5 + 1];
	char reg_brch		[  9 + 1];
	char reg_date		[ 19 + 1];
	char modi_teller	[  5 + 1];
	char modi_brch		[  9 + 1];
	char modi_date		[ 19 + 1];
	char err_date		[ 10 + 1];
} SQL_PS_ACCINFO;

/* bms ps_passinfo define */
typedef struct 
{
	char zoneno		[  5 + 1];
	char cid		[ 11 + 1];
	short pid		;
	char passwd		[ 16 + 1];
	short status		;
	char reg_teller		[  5 + 1];
	char reg_brch		[  9 + 1];
	char reg_date		[ 19 + 1];
	char modi_teller	[  5 + 1];
	char modi_brch		[  9 + 1];
	char modi_date		[ 19 + 1];
} SQL_PS_PASSINFO;

/* bms cust_phoneinfo */
typedef struct 
{
	char zoneno		[  5 + 1];
	char cid		[ 11 + 1];
	short b_type		;
	char info		[ 30 + 1];
	short call_limit	;
	short out_limit		;
	char out_time		[ 50 + 1];
	char reg_teller		[  5 + 1];
	char reg_brch		[  9 + 1];
	char reg_date		[ 19 + 1];
	char modi_teller	[  5 + 1];
	char modi_brch		[  9 + 1];
	char modi_date		[ 19 + 1];
} SQL_CUST_PHONEINFO;

typedef struct
{
	char zoneno		[  5 + 1];
	char cid		[ 11 + 1];
	char account		[ 30 + 1];
	short b_type			;
	char info		[ 30 + 1];
	short call_type			;
	char out_time		[ 50 + 1];
	char reg_teller		[  5 + 1];
	char reg_brch		[  9 + 1];
	char reg_date		[ 10 + 1];
	char modi_teller	[  5 + 1];
	char modi_brch		[  9 + 1];
	char modi_date		[ 10 + 1];
}SQL_CUST_OUTBANDINFO;

/* bms ps_acc_reg define */
typedef struct 
{
	char zoneno		[  5 + 1];
	char cid		[ 11 + 1];
	char aid		[  4 + 1];
	char account		[ 30 + 1];
	char name		[ 20 + 1];
	short acct_type		;
	char city_no		[ 20 + 1];
	short bill		;
	short curr		;
	char auth_flg		[  3 + 1];
	short que_flag		;	
	short que_pid		;
	short tran_flg		;
	short tran_pid		;
	short over_flg		;
	double limit_amt	;
	short limit_num		;
	double max_limit_amt	;
	short over_pid		;
	short status		;
	char reg_teller		[  5 + 1];
	char reg_brch		[  9 + 1];
	char reg_date		[ 19 + 1];
	char modi_teller	[  5 + 1];
	char modi_brch		[  9 + 1];
	char modi_date		[ 19 + 1];
} SQL_PS_ACC_REG;

/* bms remit_city_info define */
typedef struct
{
	char province_name	[ 20 + 1]; 
	char city_name		[ 30 + 1];
	char country_name	[ 30 + 1];	
	char city_code		[  6 + 1];  
	char memo		[ 64 + 1];	

} SQL_REMIT_CITY_INFO;

/* bms ps_obacc_reg define */
typedef struct 
{
	char zoneno		[  5 + 1];
	char cid		[ 11 + 1];
	char aid		[  4 + 1];
	short acct_type			 ;
	char in_acct		[ 30 + 1];
	char bankcode		[  2 + 1];
	char openunit		[ 40 + 1];
	char reg_teller		[  5 + 1];
	char reg_brch		[  9 + 1];
	char reg_date		[ 19 + 1];
	char modi_teller	[  5 + 1];
	char modi_brch		[  9 + 1];
	char modi_date		[ 19 + 1];
} SQL_PS_OBACC_REG;

/* bms proxyfixauth define */
typedef struct 
{
	char zoneno		[  5 + 1];
	char cid		[ 11 + 1];
	short datumno		;
	short unitno		;
	char aid		[ 30 + 1];
	char said		[ 20 + 1];
	char name		[ 20 + 1];
	char address		[ 60 + 1];
	short status		;
	char reg_teller		[  5 + 1];
	char reg_brch		[  9 + 1];
	char reg_date		[ 19 + 1];
	char modi_teller	[  5 + 1];
	char modi_brch		[  9 + 1];
	char modi_date		[ 19 + 1];
} SQL_PROXYFIXAUTH;

/* bms ps_relinfo define */
typedef struct 
{
	char zoneno		[  5 + 1];
	char cid		[ 11 + 1];
	char shstkhdno		[ 20 + 1];
	char shfundno		[ 20 + 1];
	char shstockcono	[ 20 + 1];
	char shsbailno		[ 20 + 1];
	char shaid		[ 30 + 1];
	char shfuncodno		[ 20 + 1];
	char shfbailno		[ 20 + 1];
	char szstkhdno		[ 20 + 1];
	char szfundno		[ 20 + 1];
	char szstockcono	[ 20 + 1];
	char szsbailno		[ 20 + 1];
	char szaid		[ 30 + 1];
	char szfuncodno		[ 20 + 1];
	char szfbailno		[ 20 + 1];	
	char reg_teller		[  5 + 1];
	char reg_brch		[  9 + 1];
	char reg_date		[ 19 + 1];
	char modi_teller	[  5 + 1];
	char modi_brch		[  9 + 1];
	char modi_date		[ 19 + 1];
} SQL_PS_RELINFO;

typedef struct{
	char zoneno		[  5 + 1];
	char cid		[ 11 + 1];
	char updatepre		[255 + 1];
	char updatenex		[255 + 1];
	char modi_telle		[  5 + 1];
	char modi_brch		[  9 + 1];
	char modi_date		[ 19 + 1];
	char auth_teller	[  5 + 1];
} SQL_PS_UPDATEINFO;
	
typedef struct{
	char zoneno		[  5 + 1];
	char cid		[ 11 + 1];
	char happen_date	[ 10 + 1];
	char notes		[500 + 1];
	char valid_date		[ 10 + 1];
	char reg_date		[ 19 + 1];
	char reg_teller		[  5 + 1];
} SQL_PS_KEYINFO;

/* bms co_info define */
typedef struct 
{
	char zoneno		[  5 + 1];
	char cid		[ 11 + 1];
	char unitname		[ 80 + 1];
	short unitcdtp		;
	char regist_id		[ 20 + 1];
	char country_tax	[ 20 + 1];
	char local_tax		[ 20 + 1];
	char credit_no		[ 20 + 1];
	char license		[ 18 + 1];
	char basaccd		[ 30 + 1];
	char reg_bank		[ 20 + 1];
	char agent		[ 16 + 1];
	short ic_type		;
	char ic_no		[ 18 + 1];
	char finacemas		[ 16 + 1];
	short mas_type		;
	char mas_no		[ 18 + 1];
	char address		[ 60 + 1];
	char postcode		[  6 + 1];
	char phone1		[ 22 + 1];
	char phone2		[ 22 + 1];
	char fax		[ 22 + 1];
	char email		[ 40 + 1];
	short fee_type		;
	char fee_acct		[ 30 + 1];
	char type		[  1 + 1];
	short status		;
	char func_def		[ 20 + 1];
	char txchmask		[ 20 + 1];
	short out_mode		;
	char remark		[200 + 1];
	char reg_teller		[  5 + 1];
	char reg_brch		[  9 + 1];
	char reg_date		[ 19 + 1];
	char modi_teller	[  5 + 1];
	char modi_brch		[  9 + 1];
	char modi_date		[ 19 + 1];
} SQL_CO_INFO;

/* bms broker_info define */
typedef struct