const.h

来自「oracle常用脚本」· C头文件 代码 · 共 63 行

#ifndef CONST_H
#define CONST_H

#define SUCCESS                 0
#define FAIL                    1

#define DB_OK                   0
#define DB_NOTFOUND             1403
#define DB_KEYDUPLICATE         -1
#define DB_DBSFUNCERR           543

#define DBS_SELECT     1
#define DBS_LOCK       2
#define DBS_UPDATE     3
#define DBS_INSERT     4
#define DBS_DELETE     5
#define DBS_INIT       6

#define DBS_OPEN       10   /* include DECLARE and OPEN */
#define DBS_FETCH      11
#define DBS_CLOSE      12

#define SQL_CODE_PROCESS(table,action) \
if(sqlca.sqlcode!=DB_OK && sqlca.sqlcode!=DB_NOTFOUND) \
{ \
    printf("%s: %s --- ISAM Code: %d, Info: %s", \
        table, action, \
        sqlca.sqlcode, sqlca.sqlerrm.sqlerrmc); \
} \
return(sqlca.sqlcode)

typedef struct
{
    double fee_id;
    char create_ts[15];
    char update_ts[15];
    char status[2];
    char user_nm[21];
    char charge_dt[9];
} charge_fee_t;

typedef struct
{
    double fee_id;
    char fee_type[3];
    double fee_at;
} charge_fee_dtl_t;

typedef struct
{
    char fee_type[3];
    char fee_nm[11];
} charge_fee_cfg_t;

#define CHARGE_FEE_STATUS_NOT_PAY		"1"

int random_int(int min_val, int max_val);
int DbsConnect();
int DbsChargeBBJoin(int func, charge_fee_t *pChargeFee,
    charge_fee_dtl_t *pChargeFeeDtl);

#endif