//写卡异常处理
static int WriteCardExcept(ST_PACK *rPack)
{
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
des2src(trans.refno,rPack->sphone3); //交易参考号
if(strlen(trans.refno)!=14)
{
ERRTIP("交易参考号错误");
return E_COMMON_ERR;
}
T_t_refno tRefno;
memset(&tRefno,0,sizeof(tRefno));
ret=DB_t_refno_read_by_refno(trans.refno,&tRefno);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_REFNO_N;
else
return E_DB_REFNO_R;
}
if(strncmp(tRefno.mac,rPack->saddr,8)!=0)
{
ERRTIP("交易参考号MAC校验错误");
return E_COMMON_ERR;
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
ret=DB_t_transdtl_read_lock_by_c0_and_accdate_and_termid_and_termseqno(tRefno.accdate,tRefno.termid,tRefno.termseqno,&transdtl);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_TRANSDTL_N;
else
return E_DB_TRANSDTL_U;
}
if(transdtl.status[0]!=DTLSTATUS_SUCCESS)
transdtl.status[0]=DTLSTATUS_FAIL;
transdtl.errcode = 2;
strcpy(transdtl.remark,"中途拔卡,写卡失败");
ret=DB_t_transdtl_update_lock_by_c0(&transdtl);
if(ret)
{
return E_DB_TRANSDTL_U;
}
return 0;
}
int ClearCardInfo(TRUSERID *handle,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans& ats=CAccTrans::GetInst();
TRANS& trans=ats.trans;
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=DB_t_card_read_by_cardphyid_and_status(trans.cardphyid,"1",&tCard);
if(ret)
{
writelog(LOG_ERR,"cardno[%d]",trans.cardno);
if(DB_NOTFOUND==ret)
{
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL0,F_VSMESS,0);
strcpy(outPack->vsmess,"该卡信息可以清空");
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
else
return E_DB_CARD_R;
}
ERRTIP("该卡未注销，不能清空卡信息");
return E_COMMON_ERR;
}
static int doCard(TRANS& trans,T_t_card& tCard)
{
int ret=0;
ret=DB_t_card_read_by_cardno(trans.cardno,&tCard);
if(ret)
{
writelog(LOG_ERR,"cardno[%d]",trans.cardno);
if(DB_NOTFOUND==ret)
return E_NOTEXIST_CARDNO;
else
return E_DB_CARD_R;
}
trans.cardtype=tCard.cardtype;
trans.feetype=tCard.feetype;
if(tCard.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_CARD_LOGOUT,trans.cardno);
}
if('1'==tCard.lockflag[0])
{
ERRTIP("请将该卡注销");
return ERRINFO(E_CARDNO_LOCKED,trans.cardno);
}
if('1'==tCard.frozeflag[0])
{
return ERRINFO(E_CARD_FREEZE,trans.cardno);
}
if('1'==tCard.lossflag[0])
{
return ERRINFO(E_CARD_LOST,trans.cardno);
}
if('1'==tCard.badflag[0])
{
return ERRINFO(E_CARD_BADRECORD,trans.cardno);
}
//比较卡物理ID是否相同
if(strcmp(tCard.cardphyid,trans.cardphyid)!=0)
{
writelog(LOG_ERR,"db cardphyid[%s],input cardphyid[%s]",tCard.cardphyid,trans.cardphyid);
return E_CARD_PHYNO_DIFFER;
}
//检查卡的有效期
if(strcmp(tCard.expiredate,trans.transdate)<=0)
return E_CARD_EXPIRED;
return 0;
}
int F846328(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret;
//支付交易
switch(rPack->lbank_acc_type)
{
//试入账
case 1:
ret=TestTrans(handle,rPack,pRetCode,szMsg);
break;
//正式入账
case 2:
ret=NormalTrans(handle,rPack,pRetCode,szMsg);
break;
case 3://写卡失败
ret=WriteCardExcept(rPack);
break;
default:
ERRTIP("交易标志错误");
return E_COMMON_ERR;
}
return ret;
}
static int TestTrans(TRUSERID *handle,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL0,F_LVOL1,F_LVOL2,F_LVOL8,F_LVOL10,F_LVOL11,F_LVOL12,F_SDATE0,F_SPHONE3,F_SADDR,F_LSAFE_LEVEL2,
F_SDATE3,F_STIME3,F_SEMP,F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,0);
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
trans.transcode=TC_CARD2CARD;
des2src(trans.opercode,rPack->semp);
trans.termid=rPack->lwithdraw_flag;
ret=pAccTrans->InitTrans();
if(ret)
return ret;
if(rPack->lvol0<1)
{
ERRTIP("请输入付款方卡号");
return E_COMMON_ERR;
}
if(rPack->lvol2<1)
{
ERRTIP("请输入收款方卡号");
return E_COMMON_ERR;
}
if(rPack->lvol1<0)
{
ERRTIP("请输入转账金额");
return E_COMMON_ERR;
}
T_t_card tInCard;
memset(&tInCard,0,sizeof(tInCard));
T_t_account tInAccount;
memset(&tInAccount,0,sizeof(tInAccount));
pAccTrans->trans.cardno=rPack->lvol2;
ret=pAccTrans->CheckAcc(&tInCard,&tInAccount);
if(ret)
{
char sErrMsg[256];
strcpy(sErrMsg,"收款方卡账户状态错误:");
strcat(sErrMsg,pAccTrans->GetErrTip().c_str());
ERRTIP(sErrMsg);
return ret;
}
T_t_card tOutCard;
memset(&tOutCard,0,sizeof(tOutCard));
T_t_account tOutAccount;
memset(&tOutAccount,0,sizeof(tOutAccount));
pAccTrans->trans.cardno=rPack->lvol0;
ret=pAccTrans->CheckAcc(&tOutCard,&tOutAccount);
if(ret)
{
char sErrMsg[256];
strcpy(sErrMsg,"付款方卡账户状态错误:");
strcat(sErrMsg,pAccTrans->GetErrTip().c_str());
ERRTIP(sErrMsg);
return ret;
}
double dInCardAftBal=(rPack->lvol1+rPack->lsafe_level)/100.0;
trans.cardflag=0;
trans.usecardflag=0;
trans.purseno=PURSE_NO_ONE;
trans.paycnt=rPack->lvol6+1;
des2src(trans.cardphyid,rPack->sstation1);
trans.inputamt= D4U5(rPack->lvol1/100.0);
trans.unusedamt = trans.inputamt;
trans.cardbefbal=rPack->lvol7/100.0;
trans.cardaftbal=trans.cardbefbal - trans.inputamt;
if(amtcmp(trans.inputamt,trans.cardbefbal)>0)
{
return ERRINFO(E_CARD_BALANCE_SHORTAGE,trans.cardbefbal);
}
//检查收款方账户余额是否超过最大值
double CardMaxBal=0;
ret=GetPurseMaxBal(PURSE_NO_ONE,CardMaxBal);
if(ret)
return ret;
if(amtcmp(dInCardAftBal,CardMaxBal)>=0)
{
return ERRINFO(E_AMT_EXCEED_MAX,CardMaxBal);
}
// 保持第三方账号
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
transdtl.exttype = 0;
sprintf(transdtl.voucherno,"%d",tInCard.cardno);
transdtl.exttype=EXTTYPE_OPPSNO;
GetStuempnoByCustid(tInCard.custid,transdtl.extdata);
sprintf(transdtl.remark,"向(%s)转入",tInAccount.accname);
ret = pAccTrans->GenTransdtl(&transdtl,DTLSTATUS_INIT);
if(ret)
{
writelog(LOG_ERR,"GenTransdtl ret=%d",ret);
return ret;
}
ret=db_commit();
if(ret)
{
return ret;
}
//trans.cardaftbal=trans.cardbefbal;
strcpy(pAccTrans->trans.draccno,tOutAccount.accno);
strcpy(pAccTrans->trans.craccno,tInAccount.accno);
ret=pAccTrans->doTrans();
if(ret)
{
writelog(LOG_ERR,"doTrans err=%d",ret);
return ret;
}
ret=pAccTrans->doTransEnd();
if(ret)
{
writelog(LOG_ERR,"doTransEnd err=%d",ret);
return ret;
}
if(amtcmp(trans.cardaftbal,transdtl.cardaftbal)!=0)
{
ERRTIP("卡余额计算有误");
return E_COMMON_ERR;
}
ret=db_rollback();
if(ret)
{
writelog(LOG_ERR,"db_rollback err");
return ret;
}
// 输出参数
outPack->lvol0=tOutCard.cardno;
outPack->lvol1=D4U5(trans.inputamt*100,0);
outPack->lvol8=D4U5(transdtl.cardaftbal*100,0);
outPack->lvol2=tInCard.cardno;
outPack->lsafe_level2=D4U5(dInCardAftBal*100,0);
des2src(outPack->sdate3,trans.accdate);
des2src(outPack->stime3,trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
des2src(outPack->sphone3,trans.refno);
des2src(outPack->saddr,trans.cardpwd); //mac
sprintf(trans.remark,"%s卡余额%.2lf元",pAccTrans->remark.c_str(),pAccTrans->trans.cardaftbal);
des2src(outPack->vsmess,trans.remark);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
int UpdCardBaseInfo(TRUSERID *handle,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans& ats=CAccTrans::GetInst();
TRANS& trans=ats.trans;
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
if(trans.cardno<1)
{
ret=DB_t_card_read_by_cardphyid_and_status(trans.cardphyid,"1",&tCard);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDPHYID,trans.cardphyid);
else
return E_DB_CARD_R;
}
trans.cardno=tCard.cardno;
}
ret=DB_t_card_read_by_cardno(trans.cardno,&tCard);
if(ret)
{
writelog(LOG_ERR,"cardno[%d]",trans.cardno);
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,trans.cardno);
else
return E_DB_CARD_R;
}
trans.custid=tCard.custid;
trans.cardtype=tCard.cardtype;
trans.feetype=tCard.feetype;
if(tCard.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_CARD_LOGOUT,trans.cardno);
}
if('1'==tCard.frozeflag[0])
{
return ERRINFO(E_CARD_FREEZE,trans.cardno);
}
if('1'==tCard.lossflag[0])
{
return ERRINFO(E_CARD_LOST,trans.cardno);
}
T_t_customer customer;
memset(&customer,0,sizeof(customer));
if(tCard.custid)
{
ret=DB_t_customer_read_by_custid(tCard.custid,&customer);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CUSTOMER,tCard.custid);
else
return E_DB_CUSTOMER_R;
}
}
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_lock_by_c0_and_accno(tCard.accno,&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_ACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
if(tCardAccount.status[0]!=STATUS_NORMAL)
{
DB_t_account_free_lock_by_c0();
return ERRINFO(E_CARDACC_LOGOUT,tCardAccount.accno);
}
if(amtcmp(rPack->damt11,0)>=0)
{
tCardAccount.singlemaxamt=rPack->damt11;
if(amtcmp(tCardAccount.singlemaxamt,500)>0)
{
DB_t_account_free_lock_by_c0();
ERRTIP("单次消费限额不能超过500元");
return E_COMMON_ERR;
}
}
if(amtcmp(rPack->damt12,0)>=0)
{
tCardAccount.daycostmaxamt=rPack->damt12;
if(amtcmp(tCardAccount.daycostmaxamt,10000)>0)
{
DB_t_account_free_lock_by_c0();
ERRTIP("日累计消费限额不能超过10000元");
return E_COMMON_ERR;
}
}
ret=DB_t_account_update_lock_by_c0(&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_CARDNO_PURSENO_NOACCNO,trans.cardno,trans.purseno);
else
return E_DB_ACCOUNT_U;
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.paytype=trans.fundtype;
des2src(transdtl.voucherno,trans.voucherno);
transdtl.cardno=trans.cardno;
transdtl.purseno=trans.purseno;
transdtl.cardbefbal=trans.cardbefbal;
// transdtl.cardcnt=trans.cardcnt;
transdtl.cardaftbal=trans.cardbefbal;
transdtl.managefee=trans.totalfeeamt;
transdtl.amount=trans.totaltransamt;
transdtl.custid=trans.custid;
des2src(transdtl.custname,customer.custname);
des2src(transdtl.opercode,trans.opercode);
transdtl.status[0]=DTLSTATUS_SUCCESS;
des2src(transdtl.showcardno,tCard.showcardno);
GetStuempnoByCustid(transdtl.custid,transdtl.stuempno);
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL1,F_LSAFE_LEVEL2,F_LVOL4,F_LVOL5,F_LVOL6,
F_SALL_NAME,F_SPAGER,F_SCERT_NO,F_SHOLDER_AC_NO,
F_SEMAIL2,F_SMARKET_CODE,F_SMARKET_CODE2,F_SDATE0,F_SNOTE,
F_SSTAT_TYPE,F_SSTAT_TYPE2,F_SNATION_CODE,F_SBRANCH_CODE0,
F_LVOL0,F_STX_PWD,F_LVOL8,F_LVOL11,F_LVOL12,
F_SORDER0,F_SORDER1,F_SORDER2,F_SDATE3,F_SEMP,
F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,F_STIME3,0);
outPack->lvol1=customer.custid;
outPack->lsafe_level2=customer.custtype;
outPack->lvol5=tCard.feetype;
des2src(outPack->sall_name,customer.custname);
des2src(outPack->spager,customer.stuempno);
des2src(outPack->smarket_code2,customer.idtype);
des2src(outPack->scert_no,customer.deptcode);
des2src(outPack->semail2,customer.idno);
des2src(outPack->smarket_code,customer.sex);
des2src(outPack->sdate0,tCard.expiredate);
outPack->lvol0=tCard.cardno;
// des2src(outPack->stx_pwd,cardpwd);
des2src(outPack->sorder0,tCard.showcardno);
strcpy(outPack->snote,CARD_STRUCT_VERSION); //制卡版本号
strcpy(outPack->sorder1,CARD_REGISTER_PUBLISH_CODE); //发卡注册标识号
strcpy(outPack->sorder2,CARD_REGISTER_SERVICE_CODE); //服务注册标识号
outPack->lvol8=D4U5(ats.trans.cardaftbal*100,0);
outPack->lvol11=D4U5(tCardAccount.singlemaxamt*100,0);
outPack->lvol12=D4U5(tCardAccount.daycostmaxamt*100,0);
sprintf(outPack->sholder_ac_no,"%d",customer.custid); //客户号
des2src(outPack->sstat_type,customer.idtype); //证件类型
des2src(outPack->snation_code,customer.country); //国籍
des2src(outPack->sstat_type2,customer.nation); //民族
des2src(outPack->sbranch_code0,customer.areacode); //院校代码
des2src(outPack->sdate3,ats.trans.accdate);
des2src(outPack->stime3,ats.trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
outPack->lvol0=tCard.cardno;
outPack->lvol6=tCardAccount.paycnt;
// outPack->lvol4=tCardAccount.subsidyno;
des2src(outPack->vsmess,"更新卡信息成功");
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
static int NormalTrans(TRUSERID *handle,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL0,F_LVOL1,F_LVOL8,F_LVOL10,F_LVOL11,F_LVOL12,F_SDATE0,F_SPHONE3,F_SADDR,F_LSAFE_LEVEL2,
F_SDATE3,F_STIME3,F_SEMP,F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,0);
des2src(trans.refno,rPack->sphone3); //交易参考号
if(strlen(trans.refno)!=14)
{
ERRTIP("交易参考号错误");
return E_COMMON_ERR;
}
T_t_refno tRefno;
memset(&tRefno,0,sizeof(tRefno));
ret=DB_t_refno_read_by_refno(trans.refno,&tRefno);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_REFNO_N;
else
return E_DB_REFNO_R;
}
if(strncmp(tRefno.mac,rPack->saddr,8)!=0)
{
ERRTIP("交易参考号MAC校验错误");
return E_COMMON_ERR;
}
if(RS_FAIL==tRefno.status)
{
ERRTIP("交易已失败");
return E_COMMON_ERR;
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
ret=DB_t_transdtl_read_by_accdate_and_termid_and_termseqno(tRefno.accdate,tRefno.termid,tRefno.termseqno,&transdtl);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_NOTEXIST_TRANSDTL;
else
return E_DB_TRANSDTL_R;
}
int waterflag=0;
if(transdtl.exttype/1000==1)//水控
waterflag=1;
if(RS_SUCC==tRefno.status)
{
outPack->lvol0=transdtl.cardno;
outPack->lvol1=D4U5(transdtl.amount*100,0);
outPack->lvol8=D4U5(transdtl.cardaftbal*100,0);
if(waterflag)//水控
{
double wateraftbal= atof(transdtl.extdata);
outPack->lsafe_level2=D4U5(wateraftbal*100,0);
}
des2src(outPack->sdate3,transdtl.transdate);
des2src(outPack->stime3,transdtl.transtime);
des2src(outPack->semp,transdtl.opercode);
outPack->lwithdraw_flag=transdtl.termid;
outPack->lserial1=transdtl.termseqno;
des2src(outPack->sphone3,transdtl.refno);
des2src(outPack->saddr,tRefno.mac);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
if(transdtl.status[0]!=DTLSTATUS_INIT)
{
ERRTIP("交易流水表状态错误");
return E_COMMON_ERR;
}
des2src(trans.opercode,transdtl.opercode);
trans.termid=transdtl.termid;
trans.termseqno=transdtl.termseqno;
trans.cardflag=1;
trans.usecardflag=1;
trans.transcode=transdtl.transcode;
trans.cardno=transdtl.cardno;
trans.purseno=transdtl.purseno;
trans.paycnt=transdtl.cardcnt;
trans.cardbefbal=transdtl.cardbefbal;
trans.cardaftbal=transdtl.cardbefbal;
trans.inputamt= transdtl.amount;
trans.unusedamt = trans.inputamt;
CPaymentBase *payment;
payment = CPaymentBase::find_payment(transdtl.exttype);
if(NULL == payment)
{
return E_TRANS_FUNC_NONSUPPORT;
}
rPack->lcert_code = transdtl.exttype;
strcpy(rPack->sbank_acc,transdtl.extdata);
ret = payment->init(handle,&aPack,rPack);
if(ret)
{
writelog(LOG_ERR,"trade[%d],ret[%d]",transdtl.exttype,ret);
return ret;
}
pAccTrans->SetSummary(payment->payment_.summary);
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=DB_t_card_read_by_cardno(trans.cardno,&tCard);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,trans.cardno);
else
return E_DB_CARD_R;
}
strcpy(trans.cardaccno,tCard.accno);
trans.feetype=tCard.feetype;
trans.custid=tCard.custid;
ret=pAccTrans->doTrans();
if(ret)
return ret;
ret=pAccTrans->doTransEnd();
if(ret)
return ret;
ret=UpdateCardBitmap(trans.cardno,trans.paycnt,CARDBITMAPTYPE_SYS_ONLINE);
if(ret)
return ret;
transdtl.status[0]=DTLSTATUS_SUCCESS;
ret=DB_t_transdtl_update_by_accdate_and_termid_and_termseqno(tRefno.accdate,tRefno.termid,tRefno.termseqno,&transdtl);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_TRANSDTL_N;
else
return E_DB_TRANSDTL_U;
}
tRefno.status=RS_SUCC;
strcpy(tRefno.lastsaved,trans.sysdatetime);
ret=DB_t_refno_update_by_refno(tRefno.refno,&tRefno);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_REFNO_N;
else
return E_DB_REFNO_U;
}
outPack->lvol0=tCard.cardno;
outPack->lvol1=D4U5(trans.inputamt*100,0);
outPack->lvol8=D4U5(trans.cardaftbal*100,0);
if(waterflag)//水控
{
double wateraftbal= atof(transdtl.extdata);
outPack->lsafe_level2=D4U5(wateraftbal*100,0);
}
des2src(outPack->sdate3,trans.accdate);
des2src(outPack->stime3,trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
des2src(outPack->sphone3,trans.refno);
des2src(outPack->saddr,tRefno.mac);
sprintf(trans.remark,"%s卡余额%.2lf元",pAccTrans->remark.c_str(),pAccTrans->trans.cardaftbal);
des2src(outPack->vsmess,trans.remark);
// AnswerData(handle,*pRetCode,szMsg);
//进行第三方支付
if(payment->payment_.onlinepay)
{
ret=db_commit();
if(ret)
{
writelog(LOG_ERR,"数据库事务提交失败 ret=%d",ret);
return E_DB_COMMIT;
}
rPack->lwithdraw_flag=outPack->lwithdraw_flag;
rPack->lserial1=outPack->lserial1;
rPack->lvol0=outPack->lvol0;
rPack->lvol1=outPack->lvol1;
rPack->lvol8=outPack->lvol8;
rPack->lsafe_level2=outPack->lsafe_level2;
des2src(rPack->sdate3,outPack->sdate3);
des2src(rPack->stime3,outPack->stime3);
des2src(rPack->sphone3,outPack->sphone3);
des2src(rPack->saddr,outPack->saddr); //mac
des2src(rPack->semp,outPack->semp);
ret=payment->transfer(handle,rPack,outPack);
if(ret)
{
writelog(LOG_ERR,"与第三方系统交易失败 ret=%d",ret);
return ret;
}
if(payment->pushflag_ != 1)
PutRow(handle,outPack,pRetCode,szMsg);
}
else
{
PutRow(handle,outPack,pRetCode,szMsg);
}
return 0;
}
int F846323(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans& ats=CAccTrans::GetInst();
TRANS& trans=ats.trans;
des2src(ats.trans.opercode,rPack->semp);
if(strlen(ats.trans.opercode)<1)
{
ats.trans.termid=rPack->lwithdraw_flag;
}
ats.trans.transcode=TC_WATERCARDBALMOD;
ret=ats.InitTrans();
if(ret)
return ret;
trans.transamt=rPack->damt0;
trans.cardflag=1;
trans.usecardflag=1;
trans.cardno=rPack->lvol0;
trans.purseno=PURSE_NO_THREE;
trans.cardbefbal=rPack->lvol7/100.0;
trans.cardaftbal= D4U5(trans.cardbefbal+trans.transamt);
des2src(trans.cardphyid,rPack->sstation1);
if(amtcmp(trans.transamt,0)==0)
{
ERRTIP("充值金额不能为0");
return E_COMMON_ERR;
}
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=doCard(trans,tCard);
if(ret)
{
return ret;
}
trans.feetype=tCard.feetype;
trans.cardtype=tCard.cardtype;
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_by_accno(tCard.accno,&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
if(tCardAccount.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_CARDACC_LOGOUT,tCardAccount.accno);
}
trans.custid=tCard.custid;
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.paytype=trans.fundtype;
des2src(transdtl.voucherno,trans.voucherno);
transdtl.cardno=trans.cardno;
transdtl.purseno=trans.purseno;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.amount=trans.transamt;
transdtl.managefee=trans.totalfeeamt;
transdtl.cardaftbal=trans.cardaftbal;
transdtl.custid=tCardAccount.custid;
des2src(transdtl.custname,tCardAccount.accname);
des2src(transdtl.opercode,trans.opercode);
des2src(transdtl.showcardno,tCard.showcardno);
transdtl.status[0]=DTLSTATUS_SUCCESS;
GetStuempnoByCustid(transdtl.custid,transdtl.stuempno);
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,F_LVOL0,F_LVOL8,F_SDATE0,
F_SDATE3,F_SEMP,F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,0);
outPack->lvol0=tCard.cardno;
outPack->lvol8=D4U5(ats.trans.cardaftbal*100,0);
des2src(outPack->sdate3,ats.trans.accdate);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
sprintf(trans.remark,"%s卡余额%.2lf元",ats.remark.c_str(),ats.trans.cardaftbal);
des2src(outPack->vsmess,trans.remark);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
static int DoCardInstead(TRUSERID *handle,ST_PACK *rPack,int *pRetCode,char *szMsg) {
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL1,F_LSAFE_LEVEL2,F_LVOL4,F_LVOL5,
F_SALL_NAME,F_SPAGER,F_SCERT_NO,F_LSAFE_LEVEL,F_SMARKET_CODE2,F_SHOLDER_AC_NO,
F_SEMAIL2,F_SMARKET_CODE,F_SDATE0,
F_LVOL0,F_STX_PWD,F_LVOL8,F_LVOL6,
F_SORDER0,F_SEMP,F_SDATE3,F_STIME3,F_LVOL11,F_LVOL12,
F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,F_SNAME2,0);
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=DB_t_card_read_lock_by_cur_and_cardno(trans.cardno,&tCard);
if(ret) {
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,trans.cardno);
else
return E_DB_CARD_R;
}
if(tCard.status[0]!=STATUS_NORMAL) {
DB_t_card_free_lock_by_cur();
return ERRINFO(E_CARD_LOGOUT,trans.cardno);
}
if('1'==tCard.frozeflag[0]) {
DB_t_card_free_lock_by_cur();
return ERRINFO(E_CARD_FREEZE,trans.cardno);
}
if('1'==tCard.lossflag[0]) {
DB_t_card_free_lock_by_cur();
return ERRINFO(E_CARD_LOST,trans.cardno);
}
if('1'==tCard.badflag[0]) {
DB_t_card_free_lock_by_cur();
return ERRINFO(E_CARD_BADRECORD,trans.cardno);
}
tCard.status[0]=STATUS_DELETE;
des2src(tCard.closedate,trans.transdate);
ret=DB_t_card_update_lock_by_cur(&tCard);
if(ret) {
return E_DB_CARD_U;
}
memset(tCard.closedate,0,sizeof(tCard.closedate));
tCard.status[0]=STATUS_NORMAL;
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_by_accno(tCard.accno,&tCardAccount);
if(ret) {
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
int existflag=0;
ret=IsExistUnGetSubsidy(tCard.cardno,&existflag);
if(ret) {
return ret;
}
if(existflag) {
ERRTIP("有未领补助，请领取补助后再换卡");
return E_COMMON_ERR;
}
T_t_customer customer;
memset(&customer,0,sizeof(customer));
if(tCard.custid) {
ret=DB_t_customer_read_by_custid(tCard.custid,&customer);
if(ret) {
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CUSTOMER,tCard.custid);
else
return E_DB_CUSTOMER_R;
}
des2src(trans.stuempno,customer.stuempno);
des2src(trans.custname,customer.custname);
trans.custid=customer.custid;
}
char cardpwd[33]="";
char key[17]="";
strcpy(key,STATIC_SEED_KEY);
EncodePwd(key,cardpwd,tCard.cardpwd, 1);
T_t_cardinsteaddtl cardinsteaddtl;
memset(&cardinsteaddtl,0,sizeof(cardinsteaddtl));
ret=DB_t_cardinsteaddtl_read_lock_by_c0_and_cardno(trans.cardno,&cardinsteaddtl);
if(ret) {
if(DB_NOTFOUND==ret)
return E_DB_CARDINSTEADDTL_N;
else
return E_DB_CARDINSTEADDTL_R;
}
//核对登记信息与卡表是否一致
if(strcmp(cardinsteaddtl.oldcardphyid,tCard.cardphyid)!=0) {
DB_t_cardinsteaddtl_free_lock_by_c0();
strcpy(szMsg,"保存的卡信息与原卡物理ID不一致");
return E_CARD_PHYNO_DIFFER;
}
//核对原物理ID是否一致
if(strcmp(cardinsteaddtl.oldcardphyid,rPack->scust_no)!=0) {
DB_t_cardinsteaddtl_free_lock_by_c0();
return E_CARD_PHYNO_DIFFER;
}
if(cardinsteaddtl.revflag[0]=='1') {
DB_t_cardinsteaddtl_free_lock_by_c0();
return E_CARDINSTEAD_CANCEL;
}
if(cardinsteaddtl.status[0]=='2') {
DB_t_cardinsteaddtl_free_lock_by_c0();
if(strcmp(cardinsteaddtl.cardphyid,trans.cardphyid)!=0) {
return ERRINFO(E_CARD_PHYNO_DIFFER,trans.cardphyid,cardinsteaddtl.cardphyid);
}
outPack->lvol1=tCard.custid;
outPack->lsafe_level2=customer.custtype;
outPack->lvol5=tCard.feetype;
des2src(outPack->sall_name,customer.custname);
des2src(outPack->spager,customer.stuempno);
des2src(outPack->scert_no,customer.deptcode);
des2src(outPack->semail2,customer.idno);
des2src(outPack->smarket_code,customer.sex);
des2src(outPack->sdate0,tCard.expiredate);
sprintf(outPack->sholder_ac_no,"%d",10); //发行方标识
des2src(outPack->smarket_code2,customer.idtype);
outPack->lsafe_level=tCard.cardtype;
des2src(outPack->sname2,tCard.cardverno);
outPack->lvol0=tCard.cardno;
outPack->lvol8=(int)(cardinsteaddtl.oldcardbal*100);
outPack->lvol11=D4U5(tCardAccount.singlemaxamt*100,0);
outPack->lvol12=D4U5(tCardAccount.daycostmaxamt*100,0);
outPack->lvol6=cardinsteaddtl.oldcardcnt;
outPack->lvol4=cardinsteaddtl.oldsubsidyno;
des2src(outPack->sorder0,tCard.showcardno);
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->semp,trans.opercode);
des2src(outPack->stx_pwd,cardpwd);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
cardinsteaddtl.status[0]=STATUS_DELETE;
des2src(cardinsteaddtl.cardphyid,trans.cardphyid);
des2src(cardinsteaddtl.showcardno,trans.showcardno);
ret=DB_t_cardinsteaddtl_update_lock_by_c0(&cardinsteaddtl);
if(ret) {
return E_DB_CARDINSTEADDTL_U;
}
//检查新卡物理id
T_t_card cardtmp;
memset(&cardtmp,0,sizeof(cardtmp));
ret=DB_t_card_read_by_cardphyid_and_status(trans.cardphyid,"1",&cardtmp);
if(ret!=DB_NOTFOUND) {
if(DB_SUCCESS==ret)
return ERRINFO(E_EXIST_CARDPHYID,trans.cardphyid);
else
return E_DB_CARD_R;
}
if(pAccTrans->sysPara.bEnableCardMgr) {
ret=DB_t_card_read_by_showcardno_and_status(trans.showcardno,"1",&cardtmp);
if(ret!=DB_NOTFOUND) {
if(DB_SUCCESS==ret)
return ERRINFO(E_EXIST_SHOWCARDNO,trans.showcardno);
else
return E_DB_CARD_R;
}
//回收旧卡
ret=UseShowCardNoBack(trans.opercode,tCard.showcardno);
if(ret)
return ret;
T_t_carddtl carddtl;
memset(&carddtl,0,sizeof(carddtl));
des2src(carddtl.accdate,pAccTrans->trans.accdate);
des2src(carddtl.acctime,trans.acctime);
carddtl.termid=trans.termid;
carddtl.termseqno=trans.termseqno;
des2src(carddtl.opercode,trans.opercode);
carddtl.cardtype=tCard.cardtype;
carddtl.usetype=CARDUSETYPE_REUSE;
carddtl.inoutflag=INOUTFLAG_IN;
carddtl.transcnt=1;
strcpy(carddtl.summary,"换卡(回收旧卡)");
des2src(carddtl.cardphyid,cardinsteaddtl.oldcardphyid);
des2src(carddtl.showcardno,cardinsteaddtl.oldshowcardno);
ret=DB_t_carddtl_add(&carddtl);
if(ret) {
if(DB_REPEAT==ret)
return E_DB_CARDDTL_E;
else
return E_DB_CARDDTL_I;
}
}
////添加卡版本号记录
// T_t_cardver cardver;
//
// memset(&cardver,0,sizeof(cardver));
// cardver.cardno=trans.cardno;
// des2src(cardver.accdate,pAccTrans->sysPara.sSettleDate);
// cardver.termid=trans.termid;
// cardver.termseqno=trans.termseqno;
// cardver.status[0]=STATUS_NORMAL;
// des2src(cardver.cardphyid,cardinsteaddtl.oldcardphyid);
// des2src(cardver.stuempno,trans.stuempno);
// cardver.cardvertype=CARDVERTYPE_CARDINSTEADOLD;
//
// ret=getCardVerNo(cardver.cardverno);
// if(ret)
// return ret;
// ret=DB_t_cardver_add(&cardver);
// if(ret)
// {
// if(DB_REPEAT==ret)
// return E_DB_CARDVER_E;
// else
// return E_DB_CARDVER_I;
// }
if(pAccTrans->sysPara.bEnableCardMgr) {
int cardtype=0;
//使用新卡
ret=UseShowCardNo(trans.opercode,trans.showcardno,cardtype);
if(ret) {
return ret;
}
if(cardtype!=tCard.cardtype) {
if(CARDTYPE_TEMP==tCard.cardtype||CARDTYPE_TEMP==cardtype) {
ERRTIP("过渡临时卡与其他卡不能互换");
return E_COMMON_ERR;
}
}
tCard.cardtype=cardtype;
T_t_cardtyperight cardtyperight;
memset(&cardtyperight,0,sizeof(cardtyperight));
ret=DB_t_cardtyperight_read_by_cardtype_and_feetype(tCard.cardtype,tCard.feetype,&cardtyperight);
if (ret) {
writelog(LOG_ERR,"cardtype[%d]feetype[%d]",tCard.cardtype,tCard.feetype);
if (DB_NOTFOUND==ret)
return ERRINFO(E_NOCARDTYPERIGHT,tCard.feetype,tCard.cardtype);
else
return E_DB_CARDTYPERIGHT_R;
}
T_t_carddtl carddtl;
memset(&carddtl,0,sizeof(carddtl));
des2src(carddtl.accdate,pAccTrans->trans.accdate);
des2src(carddtl.acctime,trans.acctime);
carddtl.termid=trans.termid;
carddtl.termseqno=trans.termseqno;
des2src(carddtl.opercode,trans.opercode);
carddtl.cardtype=tCard.cardtype;
carddtl.usetype=CARDUSETYPE_USE;
carddtl.inoutflag=INOUTFLAG_OUT;
carddtl.transcnt=1;
strcpy(carddtl.summary,"换卡(发行新卡)");
des2src(carddtl.cardphyid,cardinsteaddtl.cardphyid);
des2src(carddtl.showcardno,cardinsteaddtl.showcardno);
ret=DB_t_carddtl_add(&carddtl);
if(ret) {
if(DB_REPEAT==ret)
return E_DB_CARDDTL_E;
else
return E_DB_CARDDTL_I;
}
}
ret = getNewUniqNo(KEYTYPE_CARDNO,&tCard.cardno); //获取最大卡号
if(ret) {
return ret;
}
T_t_cardver cardver;
memset(&cardver,0,sizeof(cardver));
cardver.cardno=tCard.cardno;
des2src(cardver.accdate,pAccTrans->trans.accdate);
cardver.termid=trans.termid;
cardver.termseqno=trans.termseqno;
cardver.status[0]=STATUS_NORMAL;
des2src(cardver.cardphyid,cardinsteaddtl.oldcardphyid);
des2src(cardver.stuempno,trans.stuempno);
cardver.cardvertype=CARDVERTYPE_CARDINSTEADNEW;
ret=getCardVerNo(cardver.cardverno);
if(ret)
return ret;
ret=DB_t_cardver_add(&cardver);
if(ret) {
if(DB_REPEAT==ret)
return E_DB_CARDVER_E;
else
return E_DB_CARDVER_I;
}
//使用卡片
des2src(tCard.cardphyid,trans.cardphyid);
des2src(tCard.showcardno,trans.showcardno);
des2src(tCard.lastsaved,trans.sysdatetime);
des2src(tCard.cardverno,cardver.cardverno);
tCard.status[0]=STATUS_NORMAL;
ret=DB_t_card_add(&tCard);
if(ret) {
if(DB_NOTFOUND==ret)
return E_NOTEXIST_CARDNO;
else
return E_DB_CARD_U;
}
tCardAccount.cardno=tCard.cardno;
tCardAccount.dpscnt=0;
tCardAccount.paycnt=0;
strcpy(tCardAccount.transtime,trans.sysdatetime);
ret=DB_t_account_update_by_accno(tCard.accno,&tCardAccount);
if(ret) {
if(DB_NOTFOUND==ret)
return E_DB_ACCOUNT_N;
else
return E_DB_ACCOUNT_R;
}
//插入卡位图表
T_t_cardbitmap tCardBitmap;
memset(&tCardBitmap,0,sizeof(tCardBitmap));
tCardBitmap.cardno=tCard.cardno;
tCardBitmap.baseno=0;
memset(tCardBitmap.bitmap0,'0',sizeof(tCardBitmap.bitmap0)-1);
memset(tCardBitmap.bitmap1,'0',sizeof(tCardBitmap.bitmap1)-1);
memset(tCardBitmap.bitmap2,'0',sizeof(tCardBitmap.bitmap2)-1);
memset(tCardBitmap.bitmap3,'0',sizeof(tCardBitmap.bitmap3)-1);
memset(tCardBitmap.bitmap4,'0',sizeof(tCardBitmap.bitmap4)-1);
memset(tCardBitmap.bitmap5,'0',sizeof(tCardBitmap.bitmap5)-1);
memset(tCardBitmap.bitmap6,'0',sizeof(tCardBitmap.bitmap6)-1);
memset(tCardBitmap.bitmap7,'0',sizeof(tCardBitmap.bitmap7)-1);
memset(tCardBitmap.bitmap8,'0',sizeof(tCardBitmap.bitmap8)-1);
memset(tCardBitmap.bitmap9,'0',sizeof(tCardBitmap.bitmap9)-1);
ret=DB_t_cardbitmap_add(&tCardBitmap);
if (ret) {
if (DB_REPEAT==ret)
return E_DB_CARDBITMAP_E;
else
return E_DB_CARDBITMAP_I;
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.paytype=trans.fundtype;
des2src(transdtl.voucherno,trans.voucherno);
transdtl.cardno=trans.cardno;
transdtl.exttype=EXTTYPE_NEWCARD;
sprintf(transdtl.extdata,"%d",tCard.cardno);
transdtl.purseno=trans.purseno;
transdtl.cardcnt=cardinsteaddtl.oldcardcnt;
transdtl.cardbefbal=cardinsteaddtl.oldcardbal;
transdtl.cardaftbal=cardinsteaddtl.oldcardbal;
transdtl.managefee=trans.totalfeeamt;
transdtl.amount=trans.totaltransamt;
transdtl.custid=tCard.custid;
des2src(transdtl.custname,customer.custname);
des2src(transdtl.stuempno,customer.stuempno);
des2src(transdtl.opercode,trans.opercode);
transdtl.status[0]=DTLSTATUS_SUCCESS;
des2src(transdtl.showcardno,tCard.showcardno);
ret=DB_t_transdtl_add(&transdtl);
if(ret) {
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
outPack->lvol1=tCard.custid;
outPack->lsafe_level2=customer.custtype;
outPack->lvol5=tCard.feetype;
des2src(outPack->sall_name,customer.custname);
des2src(outPack->spager,customer.stuempno);
des2src(outPack->scert_no,customer.deptcode);
des2src(outPack->semail2,customer.idno);
des2src(outPack->smarket_code,customer.sex);
des2src(outPack->sdate0,tCard.expiredate);
sprintf(outPack->sholder_ac_no,"%d",10); //发行方标识
des2src(outPack->smarket_code2,customer.idtype);
outPack->lsafe_level=tCard.cardtype;
outPack->lvol0=tCard.cardno;
outPack->lvol4=cardinsteaddtl.oldsubsidyno;
outPack->lvol8=(int)(cardinsteaddtl.oldcardbal*100);
outPack->lvol11=D4U5(tCardAccount.singlemaxamt*100,0);
outPack->lvol12=D4U5(tCardAccount.daycostmaxamt*100,0);
outPack->lvol6=cardinsteaddtl.oldcardcnt;
des2src(outPack->sorder0,tCard.showcardno);
des2src(outPack->stx_pwd,cardpwd);
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
des2src(outPack->sname2,cardver.cardverno);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
int F846322(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg) {
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
des2src(pAccTrans->trans.opercode,rPack->semp);
if(strlen(pAccTrans->trans.opercode)<1) {
pAccTrans->trans.termid=rPack->lwithdraw_flag;
}
pAccTrans->trans.transcode=TC_CARDBALMOD;
ret=pAccTrans->InitTrans();
if(ret)
return ret;
des2src(pAccTrans->trans.chkopercode,rPack->semp_no);
ret=chk_oper_pwd(pAccTrans->trans.chkopercode,rPack->scust_limit);
if(ret)
return ret;
trans.cardflag=1;
trans.usecardflag=1;
trans.cardno=rPack->lvol0;
pAccTrans->SetCardCntAndCardBal(rPack->lvol5,rPack->lvol6,rPack->lvol7);
des2src(trans.cardphyid,rPack->sstation1);
if(rPack->lbank_acc_type>0) {
trans.transamt=rPack->damt0;
trans.transflag=TF_DPS;
trans.aftdpscnt++;
} else {
trans.transamt=-rPack->damt0;
trans.transflag=TF_PAY;
trans.aftpaycnt++;
}
if(amtcmp(trans.transamt,0)==0) {
ERRTIP("调整金额不能为0");
return E_COMMON_ERR;
}
trans.cardaftbal= D4U5(trans.cardbefbal+trans.transamt);
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=doCard(trans,tCard);
if(ret) {
return ret;
}
trans.feetype=tCard.feetype;
trans.cardtype=tCard.cardtype;
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_lock_by_c0_and_accno(tCard.accno,&tCardAccount);
if(ret) {
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
if(tCardAccount.status[0]!=STATUS_NORMAL) {
DB_t_account_free_lock_by_c0();
return ERRINFO(E_CARDACC_LOGOUT,tCardAccount.accno);
}
if(amtcmp(trans.cardbefbal,tCardAccount.availbal)==0) {
DB_t_account_free_lock_by_c0();
ERRTIP("该卡余额与账户余额一致,不需要调整");
return E_COMMON_ERR;
}
if(amtcmp(trans.cardbefbal,tCardAccount.balance)==0) {
DB_t_account_free_lock_by_c0();
ERRTIP("该卡余额与账户余额一致,不需要调整");
return E_COMMON_ERR;
}
if(amtcmp(trans.cardaftbal,tCardAccount.balance)>0) {
DB_t_account_free_lock_by_c0();
ERRTIP("调整后卡余额不能大于账户余额");
return E_COMMON_ERR;
}
tCardAccount.dpscnt=trans.dpscnt;
tCardAccount.paycnt=trans.paycnt;
if(rPack->lbank_acc_type>0)
tCardAccount.dpscnt=trans.aftdpscnt;
if(rPack->lbank_acc_type<0)
tCardAccount.paycnt=trans.aftpaycnt;
tCardAccount.cardbal=trans.cardaftbal;
strcpy(tCardAccount.transtime,trans.sysdatetime);
ret=DB_t_account_update_lock_by_c0(&tCardAccount);
if(ret) {
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tCard.accno);
else
return E_DB_ACCOUNT_U;
}
trans.custid=tCard.custid;
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.paytype=trans.fundtype;
des2src(transdtl.voucherno,trans.voucherno);
transdtl.cardno=trans.cardno;
transdtl.purseno=trans.purseno;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.amount=trans.transamt;
transdtl.managefee=trans.totalfeeamt;
transdtl.cardaftbal=trans.cardaftbal;
transdtl.custid=trans.custid;
des2src(transdtl.opercode,trans.opercode);
des2src(transdtl.showcardno,tCard.showcardno);
GetCustBaseInfoByCustID(transdtl.custid,transdtl.custname,transdtl.stuempno,NULL);
transdtl.status[0]=DTLSTATUS_SUCCESS;
transdtl.transflag = trans.transflag;
if(TF_DPS==transdtl.transflag) {
transdtl.cardcnt=trans.aftdpscnt;
} else {
transdtl.cardcnt=trans.aftpaycnt;
ret=UpdateCardBitmap(trans.cardno,transdtl.cardcnt,CARDBITMAPTYPE_SYS_ONLINE);
if(ret)
return ret;
}
ret=SaveCardTransInfo();
if(ret) {
writelog(LOG_ERR,"SaveCardTransInfo ret=%d",ret);
}
ret=DB_t_transdtl_add(&transdtl);
if(ret) {
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,F_LVOL0,F_LVOL8,F_SDATE0,
F_SDATE3,F_STIME3,F_SEMP,F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,0);
outPack->lvol0=tCard.cardno;
outPack->lvol8=D4U5(pAccTrans->trans.cardaftbal*100,0);
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
sprintf(trans.remark,"%s卡余额%.2lf元",pAccTrans->remark.c_str(),pAccTrans->trans.cardaftbal);
des2src(outPack->vsmess,trans.remark);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
int F846326(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
des2src(pAccTrans->trans.opercode,rPack->semp);
if(strlen(pAccTrans->trans.opercode)<1)
{
pAccTrans->trans.termid=rPack->lwithdraw_flag;
}
pAccTrans->trans.transcode=TC_WATERCARDBALMOD;
ret=pAccTrans->InitTrans();
if(ret)
return ret;
des2src(pAccTrans->trans.chkopercode,rPack->semp_no);
ret=chk_oper_pwd(pAccTrans->trans.chkopercode,rPack->scust_limit);
if(ret)
return ret;
if(rPack->lbank_acc_type>0)
trans.transamt=rPack->damt0;
else
trans.transamt=-rPack->damt0;
trans.cardflag=1;
trans.usecardflag=1;
trans.cardno=rPack->lvol0;
trans.purseno=PURSE_NO_TWO;
trans.cardbefbal=rPack->lvol7/100.0;
trans.cardaftbal= D4U5(trans.cardbefbal+trans.transamt);
des2src(trans.cardphyid,rPack->sstation1);
if(amtcmp(trans.transamt,0)==0)
{
ERRTIP("调整金额不能为0");
return E_COMMON_ERR;
}
double CardMaxBal=0;
ret=GetPurseMaxBal(PURSE_NO_TWO,CardMaxBal);
if(ret)
return ret;
if(amtcmp(trans.cardaftbal,CardMaxBal)>0)
return ERRINFO(E_AMT_EXCEED_MAX,CardMaxBal);
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=doCard(trans,tCard);
if(ret)
{
return ret;
}
trans.feetype=tCard.feetype;
trans.cardtype=tCard.cardtype;
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_by_accno(tCard.accno,&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
if(tCardAccount.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_CARDACC_LOGOUT,tCardAccount.accno);
}
trans.custid=tCard.custid;
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.paytype=trans.fundtype;
des2src(transdtl.voucherno,trans.voucherno);
transdtl.cardno=trans.cardno;
transdtl.purseno=trans.purseno;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.amount=trans.transamt;
transdtl.managefee=trans.totalfeeamt;
transdtl.cardaftbal=trans.cardaftbal;
transdtl.custid=tCardAccount.custid;
des2src(transdtl.custname,tCardAccount.accname);
des2src(transdtl.opercode,trans.opercode);
transdtl.showcardno=atol(tCard.showcardno);
transdtl.status[0]=DTLSTATUS_SUCCESS;
GetStuempnoByCustid(transdtl.custid,transdtl.stuempno);
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,F_LVOL0,F_LVOL8,F_LVOL10,F_LVOL11,F_LVOL12,F_SDATE0,
F_SDATE3,F_STIME3,F_SEMP,F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,0);
int price1=0;
int price2=0;
int price3=0;
ret=GetWaterPrice(price1,price2,price3);
if(ret)
{
writelog(LOG_ERR,"读水价失败ret=%d",ret);
return ret;
}
outPack->lvol10=price1;
outPack->lvol11=price2;
outPack->lvol12=price3;
outPack->lvol0=tCard.cardno;
outPack->lvol8=D4U5(pAccTrans->trans.cardaftbal*100,0);
des2src(outPack->sdate0,pAccTrans->trans.accdate);
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
sprintf(trans.remark,"%s卡余额%.2lf元",pAccTrans->remark.c_str(),pAccTrans->trans.cardaftbal);
des2src(outPack->vsmess,trans.remark);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
static int TestTrans(TRUSERID *handle,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL0,F_LVOL1,F_LVOL8,F_LVOL10,F_LVOL11,F_LVOL12,F_SDATE0,F_SPHONE3,F_SADDR,F_LSAFE_LEVEL2,
F_SDATE3,F_STIME3,F_SEMP,F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,0);
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
trans.transcode=TC_CARDPAYMENT;
des2src(trans.opercode,rPack->semp);
trans.termid=rPack->lwithdraw_flag;
ret=pAccTrans->InitTrans();
if(ret)
return ret;
int paycode=rPack->lcert_code;
trans.cardno=rPack->lvol0;
if(trans.cardno<1)
{
return E_INPUTNULL_CARDNO;
}
trans.cardflag=1;
trans.usecardflag=1;
trans.purseno=PURSE_NO_ONE;
trans.paycnt=rPack->lvol6+1;
des2src(trans.cardphyid,rPack->sstation1);
trans.inputamt= D4U5(rPack->lvol1/100.0);
trans.unusedamt = trans.inputamt;
trans.cardbefbal=rPack->lvol7/100.0;
trans.cardaftbal=trans.cardbefbal - trans.inputamt;
if(amtcmp(trans.inputamt,0)<=0)
{
ERRTIP("交易金额不能为0");
return E_COMMON_ERR;
}
if(amtcmp(trans.inputamt,trans.cardbefbal)>0)
{
return ERRINFO(E_CARD_BALANCE_SHORTAGE,trans.cardbefbal);
}
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
T_t_account tAccount;
memset(&tAccount,0,sizeof(tAccount));
ret=pAccTrans->CheckAcc(&tCard,&tAccount);
if(ret)
{
writelog(LOG_INFO,"检查状态失败");
return ret;
}
if(amtcmp(trans.cardbefbal-tAccount.balance,MAXAMT_CARDGTACC)>0)
{
writelog(LOG_ERR,"卡余额[%.2lf]错误",trans.cardbefbal);
return ERRIF_CARDBAL_EXCEPT;
}
if(strlen(rPack->stx_pwd))
{
ret=check_card_pwd_by_card(trans.cardno,rPack->stx_pwd);
if(ret)
return ret;
}
if(tCard.custid>0)
{
ret=GetCustBaseInfoByCustID(trans.custid,trans.custname,trans.stuempno,NULL);
if(ret)
return ret;
}
CPaymentBase *payment;
payment = CPaymentBase::find_payment(paycode);
if(NULL == payment)
{
return E_TRANS_FUNC_NONSUPPORT;
}
ret = payment->init(handle,&aPack,rPack);
if(ret)
{
writelog(LOG_ERR,"trade[%d],ret[%d]",paycode,ret);
return ret;
}
int waterflag=0;
double waterbefbal=0;
double wateraftbal=0;
if(paycode/1000==1)//水控
{
waterflag=1;
}
if(waterflag)
{
switch(rPack->lvol1)
{
case 500:
case 1000:
case 1500:
case 2000:
break;
default:
ERRTIP("交易金额只能为5、10、15、20元");
return E_COMMON_ERR;
}
waterbefbal = rPack->lsafe_level/100.0;
wateraftbal = D4U5(waterbefbal+trans.inputamt);
double CardMaxBal=0;
ret=GetPurseMaxBal(PURSE_NO_TWO,CardMaxBal);
if(ret)
return ret;
if(amtcmp(wateraftbal,CardMaxBal)>0)
return ERRINFO(E_AMT_EXCEED_MAX,CardMaxBal);
if(1061==paycode)
{
int price1=0;
int price2=0;
int price3=0;
ret=GetWaterPrice(price1,price2,price3);
if(ret)
{
writelog(LOG_ERR,"读水价失败ret=%d",ret);
return ret;
}
outPack->lvol10=price1;
outPack->lvol11=price2;
outPack->lvol12=price3;
}
}
// 保持第三方账号
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
transdtl.exttype = paycode;
if(waterflag)
{
sprintf(transdtl.extdata,"%.2lf",wateraftbal);
}
else
{
des2src(transdtl.extdata,rPack->sbank_acc);
}
ret = pAccTrans->GenTransdtl(&transdtl,DTLSTATUS_INIT);
if(ret)
{
writelog(LOG_ERR,"GenTransdtl ret=%d",ret);
return ret;
}
ret=db_commit();
if(ret)
{
return ret;
}
trans.cardaftbal=trans.cardbefbal;
ret=pAccTrans->doTrans();
if(ret)
{
writelog(LOG_ERR,"doTrans err=%d",ret);
return ret;
}
ret=pAccTrans->doTransEnd();
if(ret)
{
writelog(LOG_ERR,"doTransEnd err=%d",ret);
return ret;
}
if(amtcmp(trans.cardaftbal,transdtl.cardaftbal)!=0)
{
ERRTIP("卡余额计算有误");
return E_COMMON_ERR;
}
ret=db_rollback();
if(ret)
{
writelog(LOG_ERR,"db_rollback err");
return ret;
}
// 输出参数
outPack->lvol0=tCard.cardno;
outPack->lvol1=D4U5(trans.inputamt*100,0);
outPack->lvol8=D4U5(transdtl.cardaftbal*100,0);
outPack->lsafe_level2=D4U5(wateraftbal*100,0);
des2src(outPack->sdate3,trans.accdate);
des2src(outPack->stime3,trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
des2src(outPack->sphone3,trans.refno);
des2src(outPack->saddr,trans.cardpwd); //mac
sprintf(trans.remark,"%s卡余额%.2lf元",pAccTrans->remark.c_str(),pAccTrans->trans.cardaftbal);
des2src(outPack->vsmess,trans.remark);
if(payment->payment_.onlinepay>0&&payment->payment_.paychkflag>0)
{
rPack->lwithdraw_flag=outPack->lwithdraw_flag;
rPack->lserial1=outPack->lserial1;
rPack->lvol0=outPack->lvol0;
rPack->lvol1=outPack->lvol1;
rPack->lvol8=outPack->lvol8;
rPack->lsafe_level2=outPack->lsafe_level2;
des2src(rPack->sdate3,outPack->sdate3);
des2src(rPack->stime3,outPack->stime3);
des2src(rPack->sphone3,outPack->sphone3);
des2src(rPack->saddr,outPack->saddr); //mac
des2src(rPack->semp,outPack->semp);
ret=payment->qry_acc(handle,rPack,outPack);
if(ret)
return ret;
if(payment->pushflag_ != 1)
PutRow(handle,outPack,pRetCode,szMsg);
}
else
{
PutRow(handle,outPack,pRetCode,szMsg);
}
return 0;
}
int UpdBadCard(TRUSERID *handle,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans& ats=CAccTrans::GetInst();
TRANS& trans=ats.trans;
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
if(trans.cardno<1)
{
ret=DB_t_card_read_by_cardphyid_and_status(trans.cardphyid,"1",&tCard);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDPHYID,trans.cardphyid);
else
return E_DB_CARD_R;
}
trans.cardno=tCard.cardno;
}
ret=DB_t_card_read_lock_by_c0_and_cardno(trans.cardno,&tCard);
if(ret)
{
writelog(LOG_ERR,"cardno[%d]",trans.cardno);
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,trans.cardno);
else
return E_DB_CARD_R;
}
trans.custid=tCard.custid;
trans.cardtype=tCard.cardtype;
trans.feetype=tCard.feetype;
if(tCard.status[0]!=STATUS_NORMAL)
{
DB_t_card_free_lock_by_c0();
return ERRINFO(E_CARD_LOGOUT,trans.cardno);
}
/*
if('1'==tCard.frozeflag[0])
{
DB_t_card_free_lock_by_c0();
return ERRINFO(E_CARD_FREEZE,trans.cardno);
}
*/
if('1'==tCard.lossflag[0])
{
DB_t_card_free_lock_by_c0();
return ERRINFO(E_CARD_LOST,trans.cardno);
}
//比较卡物理ID是否相同
if(strcmp(tCard.cardphyid,trans.cardphyid)!=0)
{
DB_t_card_free_lock_by_c0();
return ERRINFO(E_CARD_PHYNO_DIFFER,trans.cardphyid,tCard.cardphyid);
}
if('1'!=tCard.badflag[0])
{
return ERRINFO(E_CARD_NOBADRECORD,trans.cardno);
}
if((CARDBADFLAG_CARDBAL!=tCard.badtype[0])&&(CARDBADFLAG_ACCBAL!=tCard.badtype[0]))
{
DB_t_card_free_lock_by_c0();
ERRTIP("该卡已经登记为卡片损坏,请检查该卡是否完全损坏,如果没有损坏,请修改该卡损坏类型为余额错误类型再来修复");
return E_COMMON_ERR;
}
char badtype=tCard.badtype[0];
char enddate[9]={0};
ret=calcEndDate(tCard.baddate,ats.sysPara.iRenewCardDayCnt,enddate);
if(ret)
{
DB_t_card_free_lock_by_c0();
return ret;
}
if(strncmp(enddate,trans.transdate,8)>0)
{
DB_t_card_free_lock_by_c0();
return ERRINFO(E_BADCARD_RECORDDATE_NOTREACH,enddate);
}
tCard.badflag[0]='0';
tCard.badtype[0]=0;
tCard.baddate[0]=0;
des2src(tCard.lastsaved,trans.sysdatetime);
ret=DB_t_card_update_lock_by_cur(&tCard);
if(ret)
{
writelog(LOG_ERR,"cardno[%d]",tCard.cardno);
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,trans.cardno);
else
return E_DB_CARD_U;
}
T_t_customer customer;
memset(&customer,0,sizeof(customer));
if(tCard.custid)
{
ret=DB_t_customer_read_by_custid(tCard.custid,&customer);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CUSTOMER,tCard.custid);
else
return E_DB_CUSTOMER_R;
}
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_lock_by_c0_and_accno(tCard.accno,&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
if(tCardAccount.status[0]!=STATUS_NORMAL)
{
DB_t_account_free_lock_by_c0();
return ERRINFO(E_CARDACC_LOGOUT,tCardAccount.accno);
}
if(CARDBADFLAG_ACCBAL==badtype)
{
//以卡修库
if(amtcmp(tCardAccount.balance,trans.cardbefbal)<0)
{
//在卡比库大的时候不允许更新
DB_t_account_free_lock_by_c0();
ERRTIP("卡余额比账户余额大,不允许以卡修库");
return E_COMMON_ERR;
}
if(amtcmp(tCardAccount.availbal,trans.cardbefbal)==0)
{
DB_t_account_free_lock_by_c0();
ERRTIP("卡余额与账户余额已经相等,不需要以卡修库");
return E_COMMON_ERR;
}
//库余额错误，以卡余额为准，但必须卡余额小于库余额
//更新账户余额与卡余额一致
trans.cardaftbal=trans.cardbefbal;
tCardAccount.cardbal= trans.cardaftbal;
tCardAccount.availbal+=tCardAccount.subsidybal;
tCardAccount.subsidybal=0;
tCardAccount.dpscnt = trans.aftdpscnt;
tCardAccount.paycnt = trans.aftpaycnt;
strcpy(tCardAccount.transtime,trans.sysdatetime);
ret=DB_t_account_update_lock_by_c0(&tCardAccount);
if(ret)
{
return E_DB_ACCOUNT_U;
}
//考虑消费流水丢失的情况,走长款处理
trans.cardflag=0;//一定要设为无卡
trans.transamt=D4U5(tCardAccount.availbal-trans.cardbefbal);
trans.inputamt=trans.transamt;
trans.unusedamt = trans.inputamt;
trans.fundtype=0;
des2src(trans.cardaccno,tCardAccount.accno);
ats.trans.transtype=TRANSTYPE_MORE_CARDBALINCOME;
ret=ats.DoTransByTransType();
if(ret)
return ret;
if(ats.trans.unusedamt>0)
return E_INPUT_AMT;
if(ats.trans.unusedamt<0)
return E_AMT_LACK;
}
else
{
if(amtcmp(tCardAccount.balance,0)<0)
{
ERRTIP("卡余额不能小于0,该卡账户余额为%.2lf",tCardAccount.balance);
return E_COMMON_ERR;
}
//卡余额错误,把库余额写入卡余额
//更新卡余额与账户余额一致
tCardAccount.availbal+=tCardAccount.subsidybal;
tCardAccount.subsidybal=0;
tCardAccount.cardbal= tCardAccount.balance;
trans.cardaftbal=tCardAccount.cardbal;
if(amtcmp(trans.cardaftbal,trans.cardbefbal)>0)
{
tCardAccount.dpscnt=trans.dpscnt+1;
transdtl.cardcnt = tCardAccount.dpscnt;
transdtl.transflag = TF_DPS;
}
else if(amtcmp(trans.cardaftbal,trans.cardbefbal)<0)
{
tCardAccount.paycnt = trans.paycnt+1;
transdtl.cardcnt=tCardAccount.paycnt;
transdtl.transflag = TF_PAY;
ret=UpdateCardBitmap(trans.cardno,transdtl.cardcnt,CARDBITMAPTYPE_SYS_ONLINE);
if(ret)
return ret;
}
strcpy(tCardAccount.transtime,trans.sysdatetime);
ret=DB_t_account_update_lock_by_c0(&tCardAccount);
if(ret)
{
return E_DB_ACCOUNT_U;
}
}
ret=UpdAllUnGetSubsidy(trans.cardno);
if(ret)
return ret;
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
des2src(transdtl.accdate,trans.accdate);
des2src(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.paytype=trans.fundtype;
des2src(transdtl.voucherno,trans.voucherno);
transdtl.cardno=trans.cardno;
transdtl.purseno=trans.purseno;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.cardaftbal=trans.cardaftbal;
transdtl.managefee=trans.totalfeeamt;
transdtl.amount=trans.totaltransamt;
transdtl.custid=tCardAccount.custid;
des2src(transdtl.custname,tCardAccount.accname);
des2src(transdtl.opercode,trans.opercode);
transdtl.status[0]=DTLSTATUS_SUCCESS;
des2src(transdtl.showcardno,tCard.showcardno);
GetStuempnoByCustid(transdtl.custid,transdtl.stuempno);
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL1,F_LSAFE_LEVEL2,F_LVOL4,F_LVOL5,
F_SALL_NAME,F_SPAGER,F_SCERT_NO,
F_SEMAIL2,F_SMARKET_CODE,F_SMARKET_CODE2,F_SDATE0,
F_LVOL0,F_STX_PWD,F_LVOL8,F_LVOL6,
F_SORDER0,F_SEMP,F_LVOL11,F_LVOL12,
F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,F_STIME3,F_SDATE3,0);
outPack->lvol1=customer.custid;
outPack->lsafe_level2=customer.custtype;
outPack->lvol5=tCard.feetype;
strncpy(outPack->sall_name,customer.custname,8);
des2src(outPack->spager,customer.stuempno);
des2src(outPack->scert_no,customer.deptcode);
des2src(outPack->smarket_code2,customer.idtype);
des2src(outPack->semail2,customer.idno);
des2src(outPack->smarket_code,customer.sex);
des2src(outPack->sdate0,tCard.expiredate);
outPack->lvol0=tCard.cardno;
outPack->lvol8=D4U5(transdtl.cardaftbal*100,0);
outPack->lvol11=D4U5(tCardAccount.singlemaxamt*100,0);
outPack->lvol12=D4U5(tCardAccount.daycostmaxamt*100,0);
outPack->lvol6=tCardAccount.paycnt;
// outPack->lvol4=tCardAccount.subsidyno;
des2src(outPack->sorder0,tCard.showcardno);
des2src(outPack->sdate3,ats.trans.accdate);
des2src(outPack->stime3,ats.trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
des2src(outPack->vsmess,ats.remark.c_str());
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
static int NormalTrans(TRUSERID *handle,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL0,F_LVOL1,F_LVOL2,F_LVOL8,F_LVOL10,F_LVOL11,F_LVOL12,F_SDATE0,F_SPHONE3,F_SADDR,F_LSAFE_LEVEL2,
F_SDATE3,F_STIME3,F_SEMP,F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,0);
if(rPack->lvol0<1)
{
ERRTIP("请输入付款方卡号");
return E_COMMON_ERR;
}
if(rPack->lvol2<1)
{
ERRTIP("请输入收款方卡号");
return E_COMMON_ERR;
}
des2src(trans.refno,rPack->sphone3); //交易参考号
if(strlen(trans.refno)!=14)
{
ERRTIP("交易参考号错误");
return E_COMMON_ERR;
}
T_t_refno tRefno;
memset(&tRefno,0,sizeof(tRefno));
ret=DB_t_refno_read_by_refno(trans.refno,&tRefno);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_REFNO_N;
else
return E_DB_REFNO_R;
}
if(strncmp(tRefno.mac,rPack->saddr,8)!=0)
{
ERRTIP("交易参考号MAC校验错误");
return E_COMMON_ERR;
}
if(RS_FAIL==tRefno.status)
{
ERRTIP("交易已失败");
return E_COMMON_ERR;
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
ret=DB_t_transdtl_read_by_accdate_and_termid_and_termseqno(tRefno.accdate,tRefno.termid,tRefno.termseqno,&transdtl);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_NOTEXIST_TRANSDTL;
else
return E_DB_TRANSDTL_R;
}
if(RS_SUCC==tRefno.status)
{
outPack->lvol0=transdtl.cardno;
outPack->lvol1=D4U5(transdtl.amount*100,0);
outPack->lvol8=D4U5(transdtl.cardaftbal*100,0);
outPack->lsafe_level2=rPack->lsafe_level+D4U5(transdtl.amount*100,0);
des2src(outPack->sdate3,transdtl.transdate);
des2src(outPack->stime3,transdtl.transtime);
des2src(outPack->semp,transdtl.opercode);
outPack->lwithdraw_flag=transdtl.termid;
outPack->lserial1=transdtl.termseqno;
des2src(outPack->sphone3,transdtl.refno);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
int cardno=atoi(transdtl.voucherno);
if(rPack->lvol2!=cardno)
{
ERRTIP("收款方卡号错误");
return E_COMMON_ERR;
}
if(transdtl.status[0]!=DTLSTATUS_INIT)
{
ERRTIP("交易流水表状态错误");
return E_COMMON_ERR;
}
des2src(trans.opercode,transdtl.opercode);
trans.termid=transdtl.termid;
trans.termseqno=transdtl.termseqno;
trans.cardflag=0;
trans.usecardflag=0;
trans.transcode=transdtl.transcode;
trans.cardno=transdtl.cardno;
trans.purseno=transdtl.purseno;
trans.paycnt=transdtl.cardcnt;
trans.cardbefbal=transdtl.cardbefbal;
trans.cardaftbal=transdtl.cardaftbal;
trans.inputamt= transdtl.amount;
trans.unusedamt = trans.inputamt;
T_t_card tOutCard;
memset(&tOutCard,0,sizeof(tOutCard));
T_t_card tInCard;
memset(&tInCard,0,sizeof(tInCard));
ret=DB_t_card_read_by_cardno(trans.cardno,&tOutCard);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,trans.cardno);
else
return E_DB_CARD_R;
}
ret=DB_t_card_read_by_cardno(rPack->lvol2,&tInCard);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,rPack->lvol2);
else
return E_DB_CARD_R;
}
trans.feetype=tOutCard.feetype;
trans.custid=tOutCard.custid;
// trans.cardaftbal=trans.cardbefbal;
strcpy(pAccTrans->trans.draccno,tOutCard.accno);
strcpy(pAccTrans->trans.craccno,tInCard.accno);
ret=pAccTrans->doTrans();
if(ret)
return ret;
ret=pAccTrans->doTransEnd();
if(ret)
return ret;
transdtl.status[0]=DTLSTATUS_SUCCESS;
ret=DB_t_transdtl_update_by_accdate_and_termid_and_termseqno(tRefno.accdate,tRefno.termid,tRefno.termseqno,&transdtl);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_TRANSDTL_N;
else
return E_DB_TRANSDTL_U;
}
tRefno.status=RS_SUCC;
des2src(tRefno.lastsaved,trans.sysdatetime);
ret=DB_t_refno_update_by_refno(tRefno.refno,&tRefno);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_REFNO_N;
else
return E_DB_REFNO_U;
}
/////////////////////////////////////////////////////////////////////////////////////////////////
//记录转入卡的卡交易流水
pAccTrans->Reset();
trans.termid=transdtl.termid;
trans.dpscnt=rPack->lvol3+1;
trans.cardbefbal=rPack->lsafe_level/100.0;
trans.cardaftbal=(rPack->lvol1+rPack->lsafe_level)/100.0;
trans.cardno=atoi(transdtl.voucherno);
if(trans.cardno!=rPack->lvol2)
{
ERRTIP("收款卡号不符");
return E_COMMON_ERR;
}
ret=GetCustBaseInfoByCustID(tInCard.custid,trans.custname,trans.stuempno,trans.remark);
if(ret)
return ret;
ret=pAccTrans->GetTermSeqno();
if(ret)
{
return ret;
}
T_t_transdtl transdtl2;
memset(&transdtl2,0,sizeof(transdtl2));
des2src(transdtl2.refno,transdtl.refno);
des2src(transdtl2.transdate,transdtl.transdate);
des2src(transdtl2.transtime,transdtl.transtime);
strcpy(transdtl2.accdate,transdtl.accdate);
strcpy(transdtl2.acctime,transdtl.acctime);
transdtl2.termid=trans.termid;
transdtl2.termseqno=trans.termseqno;
transdtl2.transcode=transdtl.transcode;
sprintf(transdtl2.voucherno,"%d",transdtl.cardno);
transdtl2.cardno=trans.cardno;
transdtl2.purseno=trans.purseno;
transdtl2.transflag =TF_DPS;
transdtl2.cardcnt=trans.dpscnt;
transdtl2.cardbefbal=trans.cardbefbal;
transdtl2.cardaftbal=trans.cardaftbal;
transdtl2.amount= transdtl.amount;
transdtl2.managefee=0;
transdtl2.custid=tInCard.custid;
des2src(transdtl2.custname,trans.custname);
des2src(transdtl2.opercode,trans.opercode);
transdtl2.status[0]=DTLSTATUS_SUCCESS;
des2src(transdtl2.showcardno,tInCard.showcardno);
des2src(transdtl2.stuempno,trans.stuempno);
transdtl2.exttype=EXTTYPE_OPPSNO;
des2src(transdtl2.extdata,transdtl.stuempno);
sprintf(transdtl2.remark,"由(%s)转出",transdtl.custname);
ret=DB_t_transdtl_add(&transdtl2);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
T_t_account OutAccount;
memset(&OutAccount,0,sizeof(OutAccount));
ret=DB_t_account_read_lock_by_c0_and_accno(tOutCard.accno,&OutAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tOutCard.accno);
else
return E_DB_ACCOUNT_R;
}
OutAccount.paycnt=transdtl.cardcnt;
OutAccount.cardbal=transdtl.cardaftbal;
OutAccount.lastpaycnt=transdtl.cardcnt-1;
OutAccount.lastcardbal=transdtl.cardbefbal;
strcpy(OutAccount.lastaccdate,transdtl.transdate);
ret=DB_t_account_update_lock_by_c0(&OutAccount);
if(ret)
{
writelog(LOG_ERR,"更新付款方账户表错误ret=%d",ret);
return E_DB_ACCOUNT_U;
}
T_t_account InAccount;
memset(&InAccount,0,sizeof(InAccount));
ret=DB_t_account_read_lock_by_c0_and_accno(tInCard.accno,&InAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tInCard.accno);
else
return E_DB_ACCOUNT_R;
}
InAccount.dpscnt=transdtl2.cardcnt;
InAccount.cardbal=transdtl2.cardaftbal;
InAccount.lastdpscnt=transdtl2.cardcnt-1;
InAccount.lastcardbal=transdtl2.cardbefbal;
strcpy(InAccount.lastaccdate,transdtl2.transdate);
ret=DB_t_account_update_lock_by_c0(&InAccount);
if(ret)
{
writelog(LOG_ERR,"更新收款方账户表错误ret=%d",ret);
return E_DB_ACCOUNT_U;
}
outPack->lvol0=transdtl.cardno;
outPack->lvol2=transdtl2.cardno;
outPack->lvol1=D4U5(transdtl.amount*100,0);
outPack->lvol8=D4U5(transdtl.cardaftbal*100,0);
outPack->lsafe_level2=D4U5(transdtl2.cardaftbal*100,0);
des2src(outPack->sdate3,trans.accdate);
des2src(outPack->stime3,trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=transdtl.termid;
outPack->lserial1=transdtl.termseqno;
des2src(outPack->sphone3,transdtl.refno);
des2src(outPack->vsmess,trans.remark);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
int F240002(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
pAccTrans->trans.transcode=TC_BANKTRANS;
TRANS& trans=pAccTrans->trans;
trans.termid=atoi(rPack->sorder2);
ret=pAccTrans->InitTrans();
if(ret)
return ret;
trans.inputamt = rPack->lvol5/100.0;
trans.unusedamt=trans.inputamt;
trans.cardflag=1;
trans.usecardflag=1;
trans.cardbefbal=rPack->lvol6/100.00;
trans.dpscnt=rPack->lvol1+1;
trans.cardaftbal=trans.cardbefbal;
//转账不允许转小数金额
if((rPack->lvol5)%100>0)
{
writelog(LOG_ERR,"trans money is not a integer!,transmoney=[%f]",rPack->lvol5/100.0);
strcpy(szMsg,"转账金额必须是整数");
return E_TRANS_TRANSMONEY_OUTRANGE;
}
if(rPack->lvol5<1)
{
writelog(LOG_ERR,"trans money is not a integer!,transmoney=[%f]",rPack->lvol5/100.0);
strcpy(szMsg,"转账金额不能为0");
return E_TRANS_TRANSMONEY_OUTRANGE;
}
T_t_account tAccount; //帐户表
T_t_card card;
memset(&tAccount,0,sizeof(tAccount));
memset(&card,0,sizeof(card));
ST_CPACK aPack;
ST_PACK *out_pack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_DAMT0,F_DAMT1,F_DAMT2,F_LVOL1,F_LVOL2,F_LSERIAL0,F_SNAME2,0);
//判断设备是否登陆
if(0!=device_login_yes_or_no(trans.termid))
{
writelog(LOG_ERR,"Device don't login");
return E_TRANS_TERM_NOLOGIN;
}
trans.cardno=atoi(rPack->sserial0);
ret=pAccTrans->CheckAcc(&card,&tAccount);
if(ret)
return ret;
if(amtcmp(trans.cardbefbal-tAccount.balance,MAXAMT_CARDGTACC)>=0)
{
writelog(LOG_ERR,"cardbefbal[%.2lf]account balance[%.2lf]",trans.cardbefbal,tAccount.balance);
return ERRIF_CARDBAL_EXCEPT;
}
double CardMaxBal=0;
ret=GetPurseMaxBal(PURSE_NO_ONE,CardMaxBal);
if(ret)
return ret;
if(amtcmp(trans.inputamt+trans.cardbefbal,CardMaxBal)>0)
return ERRINFO(E_AMT_EXCEED_MAX,CardMaxBal);
trans.feetype=card.feetype;
trans.cardtype=card.cardtype;
trans.custid=card.custid;
des2src(trans.cardaccno,tAccount.accno); //贷方帐户,持卡人账户
des2src(trans.draccno,rPack->sstation0); //借方帐号，由前置机上传
ret=pAccTrans->doFeeTrans();
if(ret)
return ret;
ret=pAccTrans->doMainTrans();
if(ret)
return ret;
ret=pAccTrans->doTransEnd();
if(ret)
return ret;
//业务结束后，回滚事务
ret=db_rollback();
if(ret)
{
writelog(LOG_ERR,"db_rollback error,error code=[%d]",ret);
return E_DB_ROLLBACK;
}
//重新取流水号
ret=pAccTrans->GetTermSeqno();
if(ret)
{
writelog(LOG_ERR,"GetTermSeqno error,error code=[%d]",ret);
return ret;
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.paytype=trans.fundtype;
des2src(transdtl.voucherno,trans.voucherno);
transdtl.cardno=trans.cardno;
transdtl.purseno=trans.purseno;
transdtl.transflag=TF_DPS;
transdtl.cardcnt=trans.dpscnt;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.amount=trans.totaltransamt;
transdtl.managefee=trans.totalfeeamt;
transdtl.cardaftbal=trans.cardaftbal;
transdtl.custid=card.custid;
//transdtl.sysid= rPack->lvol2;
transdtl.exttype=EXTTYPE_BANKCARD;
des2src(transdtl.extdata,rPack->scust_auth);
des2src(transdtl.showcardno,card.showcardno);
transdtl.status[0]=DTLSTATUS_FAIL;
ret=GetNewRefno(transdtl.refno);
if(ret)
{
ERRTIP("取交易参考号失败");
return ret;
}
GetCustBaseInfoByCustID(card.custid,transdtl.custname,transdtl.stuempno,NULL);
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
char sMsg[255]="";
char sDebugMsg[255]="";
sprintf(sDebugMsg,"流水号:%d ",trans.termseqno);
sprintf(sMsg,"充值前卡余额:%.2lf 转帐后卡余额:%.2lf ",trans.cardbefbal,trans.cardaftbal);
strcat(sDebugMsg,sMsg);
writelog(LOG_DEBUG,sDebugMsg);
des2src(out_pack->sname2,transdtl.refno);
out_pack->lserial0=trans.termseqno;
out_pack->damt0=trans.cardaftbal;
out_pack->damt1=transdtl.amount;
out_pack->damt2=transdtl.managefee;
out_pack->lvol1=transdtl.termseqno;
out_pack->lvol2=D2I(trans.cardaftbal*100);
PutRow(handle,out_pack,pRetCode,szMsg);
return 0;
}
int F841609(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
int CustomerCount=0;
int start_no=0;
char temp[256] ="";
CAccTrans *pAccTrans=CAccTrans::getInstance();
ST_CPACK aPack;
ST_PACK *out_pack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_VSMESS,0);
CustomerCount=rPack->lvol0;// 数量
T_t_customer tCustomer;
memset(&tCustomer,0,sizeof tCustomer);
//先增加客户
ret = GetSysParaVal(GLOBE_FLAG_TEMPCARD_CUTTYPE,temp);
if(ret)
{
ERRTIP("系统参数表没有配置参数标识为14的临时卡的客户类别");
return ret;
}
tCustomer.custtype=atoi(temp);
T_t_custtype tCustType;
memset(&tCustType,0,sizeof(tCustType));
ret=DB_t_custtype_read_by_custtype(tCustomer.custtype,&tCustType);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CUSTTYPE,tCustomer.custtype);
else
return E_DB_CUSTTYPE_R;
}
if(tCustType.feetype < 1)
{
ERRTIP("客户类别[%d]类别名称[%s]没有设置收费类别",tCustType.custtype,tCustType.custtypename);
return E_COMMON_ERR;
}
tCustomer.feetype=tCustType.feetype;
T_t_feetype tFeetype;
memset(&tFeetype,0,sizeof tFeetype);
ret = DB_t_feetype_read_by_feetype(tCustomer.feetype,&tFeetype);
if(ret)
{
if(DB_NOTFOUND == ret)
{
return ERRINFO(E_NOTEXIST_FEETYPE,tCustomer.feetype);
}
else
return E_DB_FEETYPE_R;
}
tCustomer.status[0]=STATUS_NORMAL;
strcpy(tCustomer.custname,"临时人员"); //客户名称
tCustomer.custattr[0]='2'; //身份禁用标志1-禁用2-启用
tCustomer.useflag[0]='0';
strcpy(tCustomer.areacode,rPack->sbranch_code0); //校区
strcpy(tCustomer.batchno,pAccTrans->trans.sysdatetime);
strcpy(tCustomer.opendate,pAccTrans->trans.accdate);
for(int i=0;i<CustomerCount;i++)
{
ret=GetNewCustIDByShoolCode(rPack->sbranch_code0,tCustomer.custid);
if(ret)
{
writelog(LOG_ERR,"school_code[%s]",rPack->sbranch_code0);
return ret;
}
ret=DB_t_customer_add(&tCustomer);
if(ret)
{
writelog(LOG_ERR,"DB_t_customer_add ret[%d]",ret);
if(DB_REPEAT==ret)
return ERRINFO(E_DB_CUSTOMER_E,tCustomer.custid);
else
return E_DB_CUSTOMER_I;
}
if(0==i)
start_no=tCustomer.custid;
}
sprintf(out_pack->vsmess,"生成批次号%s,客户号从%d到%d共%d个客户自动生成完成",tCustomer.batchno,start_no,tCustomer.custid,CustomerCount);
PutRow(handle,out_pack,pRetCode,szMsg);
//writelog(LOG_DEBUG,out_pack->vsmess);
return 0;
}
int F846317(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg) {
int ret=0;
char oldaccdate[9]="";
des2src(oldaccdate,rPack->sdate3);
int oldtermid=rPack->lwithdraw_flag;
int oldtermseqno=rPack->lserial1;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
des2src(pAccTrans->trans.opercode,rPack->semp);
pAccTrans->trans.transcode=TC_POSDRAWREV;
des2src(trans.refno,rPack->sphone3);
if(14==strlen(trans.refno)) {
trans.termid=rPack->lwithdraw_flag;
T_t_refno tRefno;
memset(&tRefno,0,sizeof(tRefno));
ret=DB_t_refno_read_by_refno(trans.refno,&tRefno);
if(ret) {
if(DB_NOTFOUND==ret)
return 0;
else
return E_DB_REFNO_R;
}
if(strncmp(tRefno.mac,rPack->saddr,8)!=0) {
ERRTIP("交易参考号MAC校验错误");
return E_COMMON_ERR;
}
if(RS_SUCC!=tRefno.status) {
return E_TRANS_REVERSED;
}
des2src(oldaccdate,tRefno.accdate);
oldtermid=tRefno.termid;
oldtermseqno=tRefno.termseqno;
} else {
des2src(trans.chkopercode,rPack->semp_no);
ret=chk_oper_pwd(trans.chkopercode,rPack->scust_limit);
if(ret)
return ret;
}
if(strlen(oldaccdate)<1)
return E_INPUTNULL_ACCDATE;
if(oldtermid<1)
return E_INPUTNULL_TERMID;
if(oldtermseqno<1)
return E_INPUTNULL_TERMSEQNO;
ret=pAccTrans->InitTrans();
if(ret)
return ret;
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,F_LVOL0,F_LVOL8,F_SDATE3,F_SEMP,F_LSERIAL1,F_SSTATION0,F_VSMESS,F_STIME3,0);
trans.cardflag=1;
trans.usecardflag=1;
trans.cardno = rPack->lvol0;
pAccTrans->SetCardCntAndCardBal(rPack->lvol5,rPack->lvol6,rPack->lvol7);
trans.aftdpscnt++;
ret=doReverse(oldaccdate,oldtermid,oldtermseqno);
if(ret)
return ret;
ret=SaveCardTransInfo();
if(ret) {
writelog(LOG_ERR,"SaveCardTransInfo ret=%d",ret);
}
outPack->lvol0=pAccTrans->trans.cardno;
outPack->lvol8=D4U5(pAccTrans->trans.cardaftbal*100,0);
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
des2src(outPack->semp,pAccTrans->trans.opercode);
outPack->lserial1=pAccTrans->trans.termseqno;
sprintf(outPack->vsmess,"冲正金额%.2lf 卡余额%.2lf元",pAccTrans->trans.transamt,pAccTrans->trans.cardaftbal);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
int RewriteCardInfo(TRUSERID *handle,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans& ats=CAccTrans::GetInst();
TRANS& trans=ats.trans;
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=DB_t_card_read_by_cardphyid_and_status(trans.cardphyid,"1",&tCard);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDPHYID,trans.cardphyid);
else
return E_DB_CARD_R;
}
trans.cardno=tCard.cardno;
trans.custid=tCard.custid;
trans.cardtype=tCard.cardtype;
trans.feetype=tCard.feetype;
// if(tCard.status[0]!=STATUS_NORMAL)
// {
// return ERRINFO(E_CARD_LOGOUT,trans.cardno);
// }
if('1'==tCard.frozeflag[0])
{
return ERRINFO(E_CARD_FREEZE,trans.cardno);
}
if('1'==tCard.lossflag[0])
{
return ERRINFO(E_CARD_LOST,trans.cardno);
}
char cardpwd[33]="";
char key[17]="";
strcpy(key,STATIC_SEED_KEY);
EncodePwd(key,cardpwd,tCard.cardpwd, 1);
T_t_customer customer;
memset(&customer,0,sizeof(customer));
if(tCard.custid)
{
ret=DB_t_customer_read_by_custid(tCard.custid,&customer);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CUSTOMER,tCard.custid);
else
return E_DB_CUSTOMER_R;
}
}
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_by_accno(tCard.accno,&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_ACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
if(tCardAccount.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_CARDACC_LOGOUT,tCardAccount.accno);
}
T_t_newcardchange newcardchange;
memset(&newcardchange,0,sizeof(newcardchange));
ret=DB_t_newcardchange_read_by_showcardno(tCard.showcardno,&newcardchange);
if(ret)
{
if(DB_NOTFOUND==ret)
{
ERRTIP("该卡没有换卡成功,请用前台换卡操作中的撤销换卡功能,恢复该卡信息");
return E_COMMON_ERR;
}
else
return E_DB_NEWCARDCHANGE_R;
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.paytype=trans.fundtype;
des2src(transdtl.voucherno,trans.voucherno);
transdtl.cardno=trans.cardno;
transdtl.purseno=trans.purseno;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.cardcnt=tCardAccount.dpscnt;
transdtl.cardaftbal=tCardAccount.cardbal;
transdtl.managefee=trans.totalfeeamt;
transdtl.amount=trans.totaltransamt;
transdtl.custid=trans.custid;
des2src(transdtl.custname,customer.custname);
des2src(transdtl.opercode,trans.opercode);
transdtl.status[0]=DTLSTATUS_SUCCESS;
GetStuempnoByCustid(transdtl.custid,transdtl.stuempno);
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL1,F_LSAFE_LEVEL2,F_LVOL4,F_LVOL5,
F_SALL_NAME,F_SPAGER,F_SCERT_NO,
F_SEMAIL2,F_SMARKET_CODE,F_SMARKET_CODE2,F_SDATE0,
F_LVOL0,F_STX_PWD,F_LVOL8,F_LVOL6,
F_SORDER0,F_SEMP,F_LVOL11,F_LVOL12,
F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,F_STIME3,F_SDATE3,0);
outPack->lvol0=trans.cardno;
outPack->lvol1=trans.custid;
outPack->lsafe_level2=customer.custtype;
outPack->lvol5=tCard.feetype;
strncpy(outPack->sall_name,customer.custname,8);
des2src(outPack->spager,customer.stuempno);
des2src(outPack->scert_no,customer.deptcode);
des2src(outPack->smarket_code2,customer.idtype);
des2src(outPack->semail2,customer.idno);
des2src(outPack->smarket_code,customer.sex);
des2src(outPack->sdate0,tCard.expiredate);
outPack->lvol8=D4U5(transdtl.cardaftbal*100,0);
outPack->lvol6=tCardAccount.paycnt;
outPack->lvol11=D4U5(tCardAccount.singlemaxamt*100,0);
outPack->lvol12=D4U5(tCardAccount.daycostmaxamt*100,0);
// outPack->lvol4=tCardAccount.subsidyno;
des2src(outPack->sorder0,tCard.showcardno);
des2src(outPack->sdate3,ats.trans.accdate);
des2src(outPack->stime3,ats.trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
des2src(outPack->stx_pwd,cardpwd);
des2src(outPack->vsmess,"重写卡信息成功");
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
static int SaveOldCardInfo(TRUSERID *handle,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=DB_t_card_read_by_cardno(trans.cardno,&tCard);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,trans.cardno);
else
return E_DB_CARD_R;
}
if(tCard.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_CARD_LOGOUT,trans.cardno);
}
if('1'==tCard.frozeflag[0])
{
return ERRINFO(E_CARD_FREEZE,trans.cardno);
}
if('1'==tCard.lossflag[0])
{
return ERRINFO(E_CARD_LOST,trans.cardno);
}
if('1'==tCard.badflag[0])
{
return ERRINFO(E_CARD_BADRECORD,trans.cardno);
}
//比较卡物理ID是否相同
if(strcmp(tCard.cardphyid,trans.cardphyid)!=0)
{
writelog(LOG_ERR,"db cardphyid[%s],input cardphyid[%s]",tCard.cardphyid,trans.cardphyid);
return E_CARD_PHYNO_DIFFER;
}
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_lock_by_c0_and_accno(tCard.accno,&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
int existflag=0;
ret=IsExistUnGetSubsidy(tCard.cardno,&existflag);
if(ret)
{
return ret;
}
if(existflag)
{
ERRTIP("有未领补助，请领取补助后再换卡");
return E_COMMON_ERR;
}
ret=DB_t_cardinsteaddtl_del_by_cardno(trans.cardno);
if(ret)
{
if(DB_NOTFOUND!=ret)
return E_DB_CARDINSTEADDTL_R;
}
T_t_cardinsteaddtl cardinsteaddtl;
memset(&cardinsteaddtl,0,sizeof(cardinsteaddtl));
des2src(cardinsteaddtl.accdate,pAccTrans->trans.accdate);
cardinsteaddtl.termid = trans.termid;
cardinsteaddtl.termseqno = trans.termseqno;
cardinsteaddtl.cardno = trans.cardno;
cardinsteaddtl.oldcardtype=tCard.cardtype;
des2src(cardinsteaddtl.oldcardphyid,trans.cardphyid);
des2src(cardinsteaddtl.oldshowcardno,tCard.showcardno);
cardinsteaddtl.oldcardcnt = trans.paycnt;
cardinsteaddtl.oldcardbal = trans.cardbefbal;
cardinsteaddtl.oldsubsidyno=trans.cardsubsidyno;
cardinsteaddtl.revflag[0]='0';
cardinsteaddtl.status[0]=STATUS_NORMAL;
ret=DB_t_cardinsteaddtl_add(&cardinsteaddtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_CARDINSTEADDTL_E;
else
return E_DB_CARDINSTEADDTL_I;
}
T_t_cardver cardver;
memset(&cardver,0,sizeof(cardver));
cardver.cardno=tCard.cardno;
des2src(cardver.accdate,pAccTrans->trans.accdate);
cardver.termid=trans.termid;
cardver.termseqno=trans.termseqno;
cardver.status[0]=STATUS_NORMAL;
des2src(cardver.cardphyid,cardinsteaddtl.cardphyid);
des2src(cardver.stuempno,trans.stuempno);
cardver.cardvertype=CARDVERTYPE_CARDINSTEADOLD;
ret=getCardVerNo(cardver.cardverno);
if(ret)
return ret;
ret=DB_t_cardver_add(&cardver);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_CARDVER_E;
else
return E_DB_CARDVER_I;
}
T_t_newcardchange newcardchange;
memset(&newcardchange,0,sizeof(newcardchange));
ret=DB_t_newcardchange_read_lock_by_c1_and_showcardno(trans.showcardno,&newcardchange);
if(ret)
{
writelog(LOG_ERR,"showcardno[%s]",trans.showcardno);
if(DB_NOTFOUND==ret)
return E_DB_NEWCARDCHANGE_N;
else
return E_DB_NEWCARDCHANGE_R;
}
newcardchange.status= NEWCARDSTATUS_INIT;
des2src(newcardchange.oldcardphyid,cardinsteaddtl.oldcardphyid);
des2src(newcardchange.cardphyid,rPack->scust_no2);
des2src(newcardchange.lastsaved,trans.sysdatetime);
ret=DB_t_newcardchange_update_lock_by_c1(&newcardchange);
if(ret)
{
return E_DB_NEWCARDCHANGE_U;
}
//保存水控钱包卡余额
map<int,double> CardBalMap;
CardBalMap[rPack->lvol10]=D4U5(rPack->lvol1/100.0);
CardBalMap[rPack->lvol11]=D4U5(rPack->lvol2/100.0);
CardBalMap[rPack->lvol12]=D4U5(rPack->lvol3/100.0);
map<int,double>::iterator itMap;
for(itMap=CardBalMap.begin();itMap!=CardBalMap.end();itMap++)
{
int pursetype=itMap->first;
double balance=itMap->second;
if(pursetype<1)
continue;
T_t_cardbalance cardbalance;
memset(&cardbalance,0,sizeof(cardbalance));
ret=DB_t_cardbalance_read_lock_by_c0_and_accno_and_pursetype(tCard.accno,pursetype,&cardbalance);
if(ret)
{
if(DB_NOTFOUND!=ret)
return E_DB_CARDBALANCE_R;
else
{
memset(&cardbalance,0,sizeof(cardbalance));
des2src(cardbalance.accno,tCardAccount.accno);
cardbalance.pursetype=pursetype;
cardbalance.cardno=tCard.cardno;
cardbalance.balance=balance;
cardbalance.cardbal=balance;
cardbalance.accumdpsamt=balance;
ret=DB_t_cardbalance_add(&cardbalance);
if(ret)
{
return E_DB_CARDBALANCE_I;
}
}
}
else
{
cardbalance.cardno=tCard.cardno;
cardbalance.cardbal=balance;
ret=DB_t_cardbalance_update_lock_by_c0(&cardbalance);
if(ret)
{
return E_DB_CARDBALANCE_U;
}
}
writelog(LOG_INFO,"pursertype[%d]cardbalance[%.2lf]",pursetype,cardbalance.cardbal);
}
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,F_SDATE3,F_STIME3,0);
des2src(outPack->semp,trans.opercode);
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
// 退水控钱包到主钱包
static int waterbalareturn(CAccTrans *pAccTrans,ST_PACK *rPack,ST_PACK *outPack)
{
int ret=0;
double waterbefbal = 0;
double wateraftbal = 0;
TRANS& trans=pAccTrans->trans;
trans.cardno=rPack->lvol0;
trans.purseno=PURSE_NO_ONE;
trans.cardflag=1;
trans.usecardflag=1;
pAccTrans->SetCardCntAndCardBal(rPack->lvol5,rPack->lvol6,rPack->lvol7);
trans.aftdpscnt++;
des2src(trans.cardphyid,rPack->sstation1);
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
T_t_account tAccount;
memset(&tAccount,0,sizeof(tAccount));
/*
if(!rPack->lvol2) // 有卡
{
ERRTIP("无卡小钱包余额不退");
return E_COMMON_ERR;
}
ret=pAccTrans->CheckAcc(&tCard,&tAccount);
if(ret)
{
writelog(LOG_ERR,"检查状态失败");
return ret;
}
*/
ret = DB_t_card_read_by_cardno(trans.cardno,&tCard);
if(ret)
{
if(DB_NOTFOUND == ret)
return ERRINFO(E_NOTEXIST_CARDNO,trans.cardno);
return ret;
}
trans.custid=tCard.custid;
des2src(trans.showcardno,tCard.showcardno);
des2src(trans.cardaccno,tCard.accno);
ret=DB_t_account_read_by_accno(tCard.accno,&tAccount);
if(ret)
{
return E_DB_ACCOUNT_R;
}
strcpy(trans.custname,tAccount.accname);
// 小钱包类型
T_t_pursetype pursetype;
memset(&pursetype,0,sizeof(pursetype));
pursetype.pursetype=rPack->lvol1;
if(pursetype.pursetype<1)
{
ERRTIP("请输入小钱包类型");
return E_COMMON_ERR;
}
ret=DB_t_pursetype_read_by_pursetype(pursetype.pursetype,&pursetype);
if(ret)
{
if(DB_NOTFOUND==ret)
{
ERRTIP("钱包类型[%d]不存在",pursetype.pursetype);
return E_COMMON_ERR;
}
else
return E_DB_PURSETYPE_R;
}
if(!pursetype.enableflag)
{
ERRTIP("钱包类型[%d]未启用",pursetype.pursetype);
return E_COMMON_ERR;
}
if(!pursetype.refundflag)
{
//ERRTIP("钱包类型[%d]不允许退款",pursetype.pursetype);
outPack->lvol0=tCard.cardno;
outPack->lvol9=D2I(pAccTrans->trans.cardaftbal*100);
outPack->lvol8=0;
outPack->lsafe_level2=0;
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
//sprintf(trans.remark,"%s卡余额%.2lf元",pAccTrans->remark.c_str(),pAccTrans->trans.cardaftbal);
sprintf(trans.remark,"小钱包不允许退款");
des2src(outPack->vsmess,trans.remark);
return 0;
}
/*
T_t_cardbalance cardbalance;
memset(&cardbalance,0,sizeof(cardbalance));
ret=DB_t_cardbalance_read_lock_by_c0_and_accno_and_pursetype(tAccount.accno,pursetype.pursetype,&cardbalance);
if(ret)
{
if(DB_NOTFOUND==ret) // 早期的卡没开小钱包账户
{
return E_DB_CARDBALANCE_N;
}
else
return E_DB_CARDBALANCE_R;
}
if(rPack->lvol2) //有卡
{
trans.cardflag=1;
trans.usecardflag=1;
pAccTrans->SetCardCntAndCardBal(rPack->lvol5,rPack->lvol6,rPack->lvol7);
trans.aftdpscnt++;
des2src(trans.cardphyid,rPack->sstation1);
waterbefbal = D4U5(rPack->lsafe_level/100.0);
trans.inputamt= waterbefbal;
if(amtcmp(trans.inputamt,pursetype.pursemaxbal)>0)
trans.inputamt=pursetype.pursemaxbal;
if(amtcmp(trans.inputamt,cardbalance.balance)>0)
trans.inputamt=cardbalance.balance;
}
else
{
//无卡
if(amtcmp(cardbalance.cardbal,cardbalance.balance)>0)
trans.inputamt=cardbalance.balance;
else
trans.inputamt=cardbalance.cardbal;
waterbefbal = trans.inputamt;
trans.cardflag=1; // 涉及到计算卡余额，不然退大钱包有问题
trans.cardbefbal=tAccount.cardbal; // 大钱包卡余额
trans.cardaftbal=tAccount.cardbal;
des2src(trans.custname,tAccount.accname);
des2src(trans.showcardno,tCard.showcardno);
des2src(trans.cardaccno,tCard.accno);
}
*/
//waterbefbal = D4U5(rPack->lsafe_level/100.0);
if(rPack->lvol2)//有卡
{
waterbefbal = D4U5(rPack->lsafe_level/100.0);
}
else//无卡
{
if(pursetype.refundflag == 1)//无卡退小钱包
{
T_t_cardbalance cardbalance;
memset(&cardbalance,0,sizeof(cardbalance));
ret=DB_t_cardbalance_read_lock_by_c0_and_accno_and_pursetype(tAccount.accno,pursetype.pursetype,&cardbalance);
if(ret)
{
if(DB_NOTFOUND==ret) // 早期的卡没开小钱包账户
{
return E_DB_CARDBALANCE_N;
}
else
return E_DB_CARDBALANCE_R;
}
if(amtcmp(cardbalance.cardbal,cardbalance.balance)>0)
waterbefbal=cardbalance.balance;
else
waterbefbal=cardbalance.cardbal;
trans.cardflag=1;
trans.cardbefbal=tAccount.cardbal; // 大钱包卡余额
trans.cardaftbal=tAccount.cardbal;
// 更新水控卡余额
cardbalance.balance = 0;
cardbalance.cardbal = 0;
ret=DB_t_cardbalance_update_lock_by_c0(&cardbalance);
if(ret)
{
return E_DB_CARDBALANCE_U;
}
}
}
trans.inputamt= waterbefbal;
if(amtcmp(trans.inputamt,pursetype.pursemaxbal)>0)
{
//"小钱包余额大于最大钱包余额,只能按最大余额退卡";
trans.inputamt=pursetype.pursemaxbal;
}
double CardMaxBal=0;
ret=GetPurseMaxBal(PURSE_NO_ONE,CardMaxBal);
if(ret)
return ret;
if(amtcmp(trans.cardbefbal+trans.inputamt,CardMaxBal)>0)
return ERRINFO(E_AMT_EXCEED_MAX,CardMaxBal);
trans.feetype=tCard.feetype;
trans.custid=tCard.custid;
trans.transamt=trans.inputamt;
trans.unusedamt = trans.inputamt;
if(pursetype.onlineflag)
{
//联机水控退款
pAccTrans->trans.transtype=TRANSTYPE_WATERREFUND;
ret=pAccTrans->DoTransByTransType();
if(ret)
return ret;
ret=pAccTrans->doTransEnd();
if(ret)
return ret;
}
else
{
if(pursetype.shopid<1)
{
ERRTIP("钱包类型[%d]没有设置对应的水控商户",pursetype.pursetype);
return E_COMMON_ERR;
}
//否则脱机水控
int shoptype=0;
char shopstatus[2]={0};
ret=ShopAccReadbyShopid(pursetype.shopid,trans.shopaccno,&shoptype,shopstatus);
if(ret)
{
writelog(LOG_ERR,"shopid[%d]",pursetype.shopid);
return ret;
}
if(shopstatus[0]!=STATUS_NORMAL)
return ERRIF_SHOP_CLOSE;
if(shoptype!=SHOPTYPE_COSUMESHOP)
return ERRIF_SHOP_TYPE;
pAccTrans->trans.transtype=TRANSTYPE_SHOPREFUND;
ret=pAccTrans->DoTransByTransType();
if(ret)
return ret;
ret=pAccTrans->doTransEnd();
if(ret)
return ret;
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
des2src(transdtl.refno,trans.refno);
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.cardno=trans.cardno;
transdtl.purseno=trans.purseno;
transdtl.transflag= TF_DPS;
transdtl.cardcnt=trans.aftdpscnt;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.cardaftbal=trans.cardaftbal;
transdtl.amount=trans.totaltransamt;
transdtl.managefee=trans.totalfeeamt;
transdtl.custid=trans.custid;
des2src(transdtl.custname,trans.custname);
des2src(transdtl.opercode,trans.opercode);
transdtl.status[0]=DTLSTATUS_SUCCESS;
des2src(transdtl.showcardno,trans.showcardno);
GetStuempnoByCustid(transdtl.custid,transdtl.stuempno);
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
T_t_pursetransdtl pursetransdtl;
memset(&pursetransdtl,0,sizeof(pursetransdtl));
des2src(pursetransdtl.refno,transdtl.refno);
des2src(pursetransdtl.transdate,transdtl.transdate);
des2src(pursetransdtl.transtime,transdtl.transtime);
strcpy(pursetransdtl.accdate,transdtl.accdate);
strcpy(pursetransdtl.acctime,transdtl.acctime);
pursetransdtl.termid=transdtl.termid;
pursetransdtl.termseqno=transdtl.termseqno;
pursetransdtl.transcode=transdtl.transcode;
pursetransdtl.cardno=transdtl.cardno;
pursetransdtl.pursetype=pursetype.pursetype;
pursetransdtl.transflag= TF_PAY;
pursetransdtl.cardcnt=0;
pursetransdtl.cardbefbal=waterbefbal;
pursetransdtl.cardaftbal=wateraftbal;
pursetransdtl.amount=transdtl.amount;
pursetransdtl.custid=transdtl.custid;
des2src(pursetransdtl.custname,transdtl.custname);
des2src(pursetransdtl.opercode,transdtl.opercode);
pursetransdtl.status[0]=transdtl.status[0];
des2src(pursetransdtl.showcardno,trans.showcardno);
des2src(pursetransdtl.stuempno,transdtl.stuempno);
ret=DB_t_pursetransdtl_add(&pursetransdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_PURSETRANSDTL_E;
else
return E_DB_PURSETRANSDTL_I;
}
outPack->lvol0=tCard.cardno;
outPack->lvol9=D2I(pAccTrans->trans.cardaftbal*100);
outPack->lvol8=D2I(pAccTrans->trans.totaltransamt*100);
//outPack->lsafe_level=D2I(wateraftbal*100);
outPack->lsafe_level2=0;
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
sprintf(trans.remark,"%s卡余额%.2lf元",pAccTrans->remark.c_str(),pAccTrans->trans.cardaftbal);
des2src(outPack->vsmess,trans.remark);
return 0;
}
int F850020(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
pAccTrans->trans.transcode=TC_WATERBALRETURN;
des2src(pAccTrans->trans.opercode,rPack->semp);
pAccTrans->trans.termid=rPack->lwithdraw_flag;
ret=pAccTrans->InitTrans();
if(ret)
return ret;
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
memset(&aPack,0,sizeof(aPack));
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL0,F_LVOL1,F_LVOL2,F_LVOL3,F_LVOL8,F_SDATE0,F_SPHONE3,F_SADDR,F_LVOL5,F_LVOL9,F_LSAFE_LEVEL,F_LSAFE_LEVEL2,
F_SDATE3,F_STIME3,F_SEMP,F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,0);
trans.cardflag=1;
trans.usecardflag=1;
trans.cardno=rPack->lvol0;
trans.purseno=PURSE_NO_ONE;
trans.dpscnt=rPack->lvol5+1;
trans.cardbefbal=rPack->lvol7/100.0;
trans.cardaftbal=trans.cardbefbal;
des2src(trans.cardphyid,rPack->sstation1);
double waterbefbal = D4U5(rPack->lsafe_level/100.0);
double wateraftbal = 0;
trans.inputamt= waterbefbal;
T_t_pursetype pursetype;
memset(&pursetype,0,sizeof(pursetype));
pursetype.pursetype=rPack->lvol1;
if(pursetype.pursetype<1)
{
ERRTIP("请输入小钱包类型");
return E_COMMON_ERR;
}
ret=DB_t_pursetype_read_by_pursetype(pursetype.pursetype,&pursetype);
if(ret)
{
if(DB_NOTFOUND==ret)
{
ERRTIP("钱包类型[%d]不存在",pursetype.pursetype);
return E_COMMON_ERR;
}
else
return E_DB_PURSETYPE_R;
}
if(!pursetype.enableflag)
{
ERRTIP("钱包类型[%d]未启用",pursetype.pursetype);
return E_COMMON_ERR;
}
if(!pursetype.refundflag)
{
ERRTIP("钱包类型[%d]不允许退款",pursetype.pursetype);
return E_COMMON_ERR;
}
if(amtcmp(trans.inputamt,pursetype.pursemaxbal)>0)
trans.inputamt=pursetype.pursemaxbal;
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
T_t_account tAccount;
memset(&tAccount,0,sizeof(tAccount));
ret=pAccTrans->CheckAcc(&tCard,&tAccount);
if(ret)
{
writelog(LOG_ERR,"检查状态失败");
return ret;
}
T_t_cardbalance cardbalance;
memset(&cardbalance,0,sizeof(cardbalance));
ret=DB_t_cardbalance_read_lock_by_c0_and_accno_and_pursetype(tAccount.accno,pursetype.pursetype,&cardbalance);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_CARDBALANCE_N;
else
return E_DB_CARDBALANCE_R;
}
if(rPack->lvol2)
{
//有卡
if(amtcmp(trans.inputamt,cardbalance.balance)>0)
trans.inputamt=cardbalance.balance;
}
else
{
//无卡
if(amtcmp(cardbalance.cardbal,cardbalance.balance)>0)
trans.inputamt=cardbalance.balance;
else
trans.inputamt=cardbalance.cardbal;
}
cardbalance.balance =D4U5(cardbalance.balance - trans.inputamt);
cardbalance.cardbal=0;
// cardbalance.paycnt;
if(rPack->lvol4)
cardbalance.paycnt = rPack->lvol4-1;
des2src(cardbalance.transdate,trans.transdate);
des2src(cardbalance.transtime,trans.transtime);
ret=DB_t_cardbalance_update_lock_by_c0(&cardbalance);
if(ret)
{
return E_DB_CARDBITMAP_U;
}
double CardMaxBal=0;
ret=GetPurseMaxBal(PURSE_NO_ONE,CardMaxBal);
if(ret)
return ret;
if(amtcmp(trans.cardbefbal+rPack->lsafe_level,CardMaxBal)>0)
return ERRINFO(E_AMT_EXCEED_MAX,CardMaxBal);
trans.feetype=tCard.feetype;
trans.custid=tCard.custid;
trans.transamt=trans.inputamt;
trans.unusedamt = trans.inputamt;
if(pursetype.onlineflag)
{
//联机水控退款
pAccTrans->trans.transtype=TRANSTYPE_WATERREFUND;
ret=pAccTrans->DoTransByTransType();
if(ret)
return ret;
ret=pAccTrans->doTransEnd();
if(ret)
return ret;
}
else
{
if(pursetype.shopid<1)
{
ERRTIP("钱包类型[%d]没有设置对应的水控商户",pursetype.pursetype);
return E_COMMON_ERR;
}
//否则脱机水控
int shoptype=0;
char shopstatus[2]={0};
ret=ShopAccReadbyShopid(pursetype.shopid,trans.shopaccno,&shoptype,shopstatus);
if(ret)
{
writelog(LOG_ERR,"shopid[%d]",pursetype.shopid);
return ret;
}
if(shopstatus[0]!=STATUS_NORMAL)
return ERRIF_SHOP_CLOSE;
if(shoptype!=SHOPTYPE_COSUMESHOP)
return ERRIF_SHOP_TYPE;
pAccTrans->trans.transtype=TRANSTYPE_SHOPREFUND;
ret=pAccTrans->DoTransByTransType();
if(ret)
return ret;
ret=pAccTrans->doTransEnd();
if(ret)
return ret;
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
des2src(transdtl.refno,trans.refno);
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.cardno=trans.cardno;
transdtl.purseno=trans.purseno;
transdtl.transflag= TF_DPS;
transdtl.cardcnt=trans.dpscnt;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.cardaftbal=trans.cardaftbal;
transdtl.amount=trans.totaltransamt;
transdtl.managefee=trans.totalfeeamt;
transdtl.custid=trans.custid;
des2src(transdtl.custname,trans.custname);
des2src(transdtl.opercode,trans.opercode);
transdtl.status[0]=DTLSTATUS_SUCCESS;
des2src(transdtl.showcardno,trans.showcardno);
GetStuempnoByCustid(transdtl.custid,transdtl.stuempno);
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
T_t_pursetransdtl pursetransdtl;
memset(&pursetransdtl,0,sizeof(pursetransdtl));
des2src(pursetransdtl.refno,transdtl.refno);
des2src(pursetransdtl.transdate,transdtl.transdate);
des2src(pursetransdtl.transtime,transdtl.transtime);
strcpy(pursetransdtl.accdate,transdtl.accdate);
strcpy(pursetransdtl.acctime,transdtl.acctime);
pursetransdtl.termid=transdtl.termid;
pursetransdtl.termseqno=transdtl.termseqno;
pursetransdtl.transcode=transdtl.transcode;
pursetransdtl.cardno=transdtl.cardno;
pursetransdtl.pursetype=pursetype.pursetype;
pursetransdtl.transflag= TF_PAY;
pursetransdtl.cardcnt=cardbalance.paycnt;
pursetransdtl.cardbefbal=waterbefbal;
pursetransdtl.cardaftbal=wateraftbal;
pursetransdtl.amount=transdtl.amount;
pursetransdtl.custid=transdtl.custid;
des2src(pursetransdtl.custname,transdtl.custname);
des2src(pursetransdtl.opercode,transdtl.opercode);
pursetransdtl.status[0]=transdtl.status[0];
des2src(pursetransdtl.showcardno,trans.showcardno);
des2src(pursetransdtl.stuempno,transdtl.stuempno);
ret=DB_t_pursetransdtl_add(&pursetransdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_PURSETRANSDTL_E;
else
return E_DB_PURSETRANSDTL_I;
}
outPack->lvol0=tCard.cardno;
outPack->lvol9=D4U5(pAccTrans->trans.cardaftbal*100,0);
outPack->lvol8=D4U5(pAccTrans->trans.totaltransamt*100,0);
outPack->lsafe_level=D4U5(wateraftbal*100,0);
outPack->lsafe_level2=0;
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
sprintf(trans.remark,"%s卡余额%.2lf元",pAccTrans->remark.c_str(),pAccTrans->trans.cardaftbal);
des2src(outPack->vsmess,trans.remark);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
int F849005(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret;
int device_id=0;
char sDevPhyid[31]="";
char current_date[9] = "";
CAccTrans& ats=CAccTrans::GetInst();
TRANS& trans=ats.trans;
ret=ats.CheckCfgUpdate();
if(ret)
return ret;
T_t_authcard auth_card;
memset(&auth_card,0,sizeof auth_card);
writelog(LOG_INFO,"充值操作员签到,操作员卡号%d,设备%s",rPack->lvol5,rPack->sphone3);
ret = DB_t_authcard_read_by_cardno(rPack->lvol5,&auth_card);
if(ret)
{
if(DB_NOTFOUND == ret)
return E_DB_AUTHCARD_N;
else
return E_DB_AUTHCARD_R;
}
if(auth_card.status[0]!=STATUS_NORMAL)
return E_AUTHCARD_LOGOUT;
if(auth_card.lossflag[0] == '1')
{
return E_AUTHCARD_IS_LOSS;
}
// 判断授权卡权限
// if((auth_card.privilege & AUTHCARD_PRV_ADDPOS) == 0)
// {
// *pRetCode = E_AUTHCARD_IS_LOSS;
// goto L_RETU;
// }
// 判断有效期
if(strcmp(auth_card.expiredate,trans.accdate) < 0)
{
return E_CARD_EXPIRED;
}
T_t_operator oper;
memset(&oper,0,sizeof oper);
ret = DB_t_operator_read_by_opercode(auth_card.opercode,&oper);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_NOTEXIST_OPER;
else
return E_DB_OPERATOR_R;
}
T_t_dpsoper tDepositOper;
memset(&tDepositOper,0,sizeof tDepositOper);
ret=DB_t_dpsoper_read_by_opercode(auth_card.opercode,&tDepositOper);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_DEPOSITOPER_R;
else
return E_DB_DEPOSITOPER_N;
}
if(tDepositOper.status[0]!=STATUS_NORMAL)
{
return E_DEPOSITOPER_STOP;
}
ret=GetDevIdByDevPhyId(&device_id,rPack->sphone3);
if (ret)
{
writelog(LOG_ERR,"GetDevIdByDevPhyId err[%d] device_id[%d]devphyid[%s]",ret,device_id,rPack->sphone3);
return ret;
}
T_t_dpsshoppos tDepositShoppos;
if('1'==tDepositOper.shopoperflag[0])
{
memset(&tDepositShoppos,0,sizeof(tDepositShoppos));
ret=DB_t_dpsshoppos_read_by_deviceid(device_id, &tDepositShoppos);
if(ret)
{
if(DB_NOTFOUND==ret)
{
writelog(LOG_INFO,"PosDeposit device_id[%d] ",device_id);
return E_DB_DEPOSITSHOPPOS_N;
}
else
{
return E_DB_DEPOSITSHOPPOS_R;
}
}
T_t_shop tShop;
memset(&tShop,0,sizeof(tShop));
ret=DB_t_shop_read_by_shopid(tDepositShoppos.shopid, &tShop);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_SHOPID,tDepositShoppos.shopid);
else
return E_DB_SHOP_R;
}
if(tShop.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_SHOP_LOGOUT,tDepositShoppos.shopid);
}
}
else
{
memset(&tDepositShoppos,0,sizeof(tDepositShoppos));
ret=DB_t_dpsshoppos_read_by_deviceid(device_id, &tDepositShoppos);
if(ret)
{
if(DB_NOTFOUND!=ret)
{
writelog(LOG_ERR,"PosDeposit termid[%d] ",device_id);
return E_DB_DEPOSITSHOPPOS_R;
}
}
else
{
ERRTIP("设备号[%d]属于属于充值商户,非充值商户操作员不能使用该设备");
return E_COMMON_ERR;
}
}
if(tDepositOper.devlimitflag[0]=='1')
{
T_t_dpsoperpos tDepositOperpos;
memset(&tDepositOperpos,0,sizeof tDepositOperpos);
ret=DB_t_dpsoperpos_read_by_opercode_and_deviceid(tDepositOper.opercode, device_id,&tDepositOperpos);
if(ret)
{
writelog(LOG_ERR,"DB_t_dpsoperpos_read_by_opercode_and_deviceid ret[%d]oper_code[%s] device_id[%d]devphy999_id[%s]",ret,tDepositOper.opercode, device_id,sDevPhyid);
if(DB_NOTFOUND==ret)
return E_OPER_NO_RIGHT_FOR_DEVICE;
else
return E_DB_DEPOSITOPERPOS_R;
}
}
return 0;
static int DoCheck(ST_PACK *rPack,T_t_shopcard& tShopCard,T_t_shop& tShop)
{
//检查卡是否已经使用
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
des2src(tShopCard.cardphyid,rPack->sbank_acc);
des2src(tShopCard.showcardno,rPack->sorder0);
des2src(tShopCard.expiredate,rPack->sdate0);
des2src(tShopCard.opendate,trans.accdate);
des2src(tShopCard.lastsaved,trans.sysdatetime);
tShopCard.status[0]=STATUS_NORMAL;
tShopCard.lossflag[0]='0';
tShopCard.shopid =rPack->lvol0;
if(!strlen(tShopCard.cardphyid))
return E_INPUT_CARDPHYID;
if(!strlen(tShopCard.expiredate))
return E_INPUT_EXPIREDATE;
//判断到期日期
ret=IsInvalidDateTime(tShopCard.expiredate,"YYYYMMDD");
if (ret)
return ERRINFO(E_INPUT_EXPIREDATE,tShopCard.expiredate);
if (strncmp(tShopCard.expiredate,trans.accdate,8)<0)
return ERRINFO(E_INPUT_EXPIREDATE,tShopCard.expiredate);
//检查商户
ret=DB_t_shop_read_by_shopid(tShopCard.shopid,&tShop);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_SHOPID,tShopCard.shopid);
else
return E_DB_SHOPCARD_R;
}
if(tShop.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_SHOP_LOGOUT,tShop.shopid);
}
char cardpwd[33]={0};
char key[17]={0};
get_init_passwd_by_man_id(tShop.idno,cardpwd);
strcpy(key,STATIC_SEED_KEY);
EncodePwd(key,cardpwd,tShopCard.cardpwd, 0);
strcpy(trans.cardpwd,cardpwd);//临时保存密码
//检查是否存在商户卡
T_t_shopcard tShopCardCheck;
memset(&tShopCardCheck,0,sizeof(tShopCardCheck));
ret=DB_t_shopcard_read_by_shopid_and_status(tShopCard.shopid,tShopCard.status,&tShopCardCheck);
if(ret)
{
if(DB_NOTFOUND!=ret)
return E_DB_SHOPCARD_R;
}
else
{
ERRTIP("该商户商户卡已发行");
return E_COMMON_ERR;
}
ret=DB_t_shopcard_read_by_cardphyid_and_status(tShopCard.cardphyid,tShopCard.status,&tShopCardCheck);
if (ret!=DB_NOTFOUND)
{
if (DB_SUCCESS==ret)
return ERRINFO(E_EXIST_CARDPHYID,tShopCard.cardphyid);
else
return E_DB_CARD_R;
}
return 0;
}
int F846305(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
int freefeeflag=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
des2src(pAccTrans->trans.opercode,rPack->semp);
pAccTrans->trans.transcode=TC_CARDRENEW;
ret=pAccTrans->InitTrans();
if(ret)
return ret;
TRANS& trans=pAccTrans->trans;
trans.usecardflag=1;
trans.cardno=rPack->lvol0;
des2src(trans.showcardno,rPack->sorder0);
des2src(trans.cardphyid,rPack->sstation0);
if (!strlen(trans.cardphyid))
return E_INPUT_CARDPHYID;
// if (!strlen(trans.showcardno))
// return E_INPUT_SHOWCARDNO;
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
//检查卡
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=DB_t_card_read_lock_by_cur_and_cardno(trans.cardno,&tCard);
if(ret)
{
writelog(LOG_ERR,"cardno[%d]",trans.cardno);
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,trans.cardno);
else
return E_DB_CARD_R;
}
trans.cardtype=tCard.cardtype;
trans.feetype=tCard.feetype;
trans.custid=tCard.custid;
if(tCard.status[0]!=STATUS_NORMAL)
{
DB_t_card_free_lock_by_cur();
return ERRINFO(E_CARD_LOGOUT,trans.cardno);
}
if('1'==tCard.frozeflag[0])
{
DB_t_card_free_lock_by_cur();
return ERRINFO(E_CARD_FREEZE,trans.cardno);
}
if('1'==tCard.badflag[0])
{
if((CARDBADFLAG_CARDBAL==tCard.badtype[0])||(CARDBADFLAG_ACCBAL==tCard.badtype[0]))
{
DB_t_card_free_lock_by_cur();
ERRTIP("该卡余额错误,请使用坏卡修复功能来处理,不必补办");
return E_CARD_BAD_AND_NEED_UPDATE;
}
}
//无卡只有挂失或卡物理损坏的情况下才可以补办卡
if(tCard.lossflag[0]!='1'&&
tCard.badflag[0]!='1')
{
DB_t_card_free_lock_by_cur();
ERRTIP("该卡状态正常,不能补办");
return E_COMMON_ERR;
}
//检查该客户是否存在未注销的卡
// ret=IsExistOtherCardByCustid(tCard.custid,tCard.cardno);
ret=IsExistNormalTmpCardByCustid(tCard.custid);
if(ret)
{
DB_t_card_free_lock_by_cur();
if(DB_EXIST==ret)
{
ERRTIP("该客户存在正常的过渡临时卡,请先注销过渡临时卡再补办");
return E_EXIST_OTHERCARD;
}
else
return ret;
}
if('1'==tCard.badflag[0])
{
//检查卡是否到了销卡的时间
char enddate[9]="";
ret=calcEndDate(tCard.baddate,pAccTrans->sysPara.iPosdtlMaxDayCnt,enddate);
if(ret)
{
DB_t_card_free_lock_by_cur();
return ret;
}
if(strncmp(enddate,pAccTrans->trans.transdate,8)>0)
{
DB_t_card_free_lock_by_cur();
ERRTIP("请等到期后再补办");
return ERRINFO(E_BADCARD_RECORDDATE_NOTREACH,enddate);
}
if(CARDBADFLAG_QUALITY==tCard.badtype[0])
freefeeflag=1;
}
else if('1'==tCard.lossflag[0])
{
char enddate[9]="";
ret=calcEndDate(tCard.lossdate,pAccTrans->sysPara.iPosdtlMaxDayCnt,enddate);
if(ret)
{
DB_t_card_free_lock_by_cur();
return ret;
}
if(strncmp(enddate,pAccTrans->trans.transdate,8)>0)
{
DB_t_card_free_lock_by_cur();
ERRTIP("请等到期后再补办");
return ERRINFO(E_CARDLOSSDATE_NOREACH,enddate);
}
}
ret=getCardVerNo(tCard.cardverno);
if(ret)
{
DB_t_card_free_lock_by_cur();
return ret;
}
tCard.status[0]=STATUS_DELETE;
strcpy(tCard.closedate,trans.transdate);
getfmtsysdatetime(tCard.lastsaved);
ret=DB_t_card_update_lock_by_cur(&tCard);
if(ret)
{
writelog(LOG_ERR,"cardno[%d]",tCard.cardno);
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,tCard.cardno);
else
return E_DB_CARD_U;
}
//删除卡库不平表该卡的记录
ret=DelCardAccDiffByCardno(trans.cardno);
if(ret)
return ret;
T_t_customer tCustomer;
memset(&tCustomer,0,sizeof(tCustomer));
if(trans.custid>0)
{
ret=DB_t_customer_read_by_custid(trans.custid,&tCustomer);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CUSTOMER,trans.custid);
else
return E_DB_CUSTOMER_R;
}
trans.custid=tCustomer.custid;
des2src(trans.custname,tCustomer.custname);
des2src(trans.stuempno,tCustomer.stuempno);
}
T_t_cardtyperight cardtyperight;
memset(&cardtyperight,0,sizeof(cardtyperight));
ret=DB_t_cardtyperight_read_by_cardtype_and_feetype(tCard.cardtype,tCard.feetype,&cardtyperight);
if(ret)
{
writelog(LOG_ERR,"cardtype[%d]feetype[%d]",tCard.cardtype,tCard.feetype);
if(DB_NOTFOUND==ret)
return E_NOCARDTYPERIGHT;
else
return E_DB_CARDTYPERIGHT_R;
}
////添加旧卡版本号记录
T_t_cardver cardver;
memset(&cardver,0,sizeof(cardver));
cardver.cardno=tCard.cardno;
des2src(cardver.accdate,pAccTrans->trans.sysdate);
cardver.termid=trans.termid;
cardver.termseqno=trans.termseqno;
cardver.cardno=tCard.cardno;
cardver.status[0]=STATUS_NORMAL;
des2src(cardver.cardphyid,tCard.cardphyid);
des2src(cardver.stuempno,trans.stuempno);
cardver.cardvertype=CARDVERTYPE_CARDCLOSE;
des2src(cardver.cardverno,tCard.cardverno);
ret=DB_t_cardver_add(&cardver);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_CARDVER_E;
else
return E_DB_CARDVER_I;
}
T_t_card tCardTest;
ret=DB_t_card_read_by_cardphyid_and_status(trans.cardphyid,"1",&tCardTest);
if (ret!=DB_NOTFOUND)
{
if (DB_SUCCESS==ret)
return ERRINFO(E_EXIST_CARDPHYID,trans.cardphyid);
else
return E_DB_CARD_R;
}
if(pAccTrans->sysPara.bEnableCardMgr)
{
//使用新的显示卡号
ret=DB_t_card_read_by_showcardno_and_status(trans.showcardno,"1",&tCardTest);
if (ret!=DB_NOTFOUND)
{
if (DB_SUCCESS==ret)
return ERRINFO(E_EXIST_SHOWCARDNO,trans.showcardno);
else
return E_DB_CARD_R;
}
int cardtype=0;
ret=UseShowCardNo(trans.opercode,trans.showcardno,cardtype);
if(ret)
{
return ret;
}
if(cardtype!=tCard.cardtype)
{
return ERRINFO(E_DIFF_CARDTYPE,cardtype,tCard.cardtype);
}
T_t_carddtl carddtl;
memset(&carddtl,0,sizeof(carddtl));
des2src(carddtl.accdate,pAccTrans->trans.sysdate);
des2src(carddtl.acctime,trans.systime);
carddtl.termid=trans.termid;
carddtl.termseqno=trans.termseqno;
des2src(carddtl.opercode,trans.opercode);
carddtl.cardtype=tCard.cardtype;
carddtl.usetype=CARDUSETYPE_USE;
carddtl.inoutflag=INOUTFLAG_OUT;
carddtl.transcnt=1;
strcpy(carddtl.summary,"补办卡");
des2src(carddtl.cardphyid,trans.cardphyid);
des2src(carddtl.showcardno,trans.showcardno);
ret=DB_t_carddtl_add(&carddtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_CARDDTL_E;
else
return E_DB_CARDDTL_I;
}
}
//使用卡片
T_t_card tNewCard;
memset(&tNewCard,0,sizeof(tNewCard));
des2src(tNewCard.cardphyid,trans.cardphyid);
des2src(tNewCard.showcardno,trans.showcardno);
des2src(tNewCard.expiredate,tCard.expiredate);
des2src(tNewCard.accno,tCard.accno);
tNewCard.cardtype=tCard.cardtype;
tNewCard.feetype=tCard.feetype;
des2src(tNewCard.cardpwd,tCard.cardpwd);
tNewCard.custid=tCustomer.custid;
tNewCard.lossflag[0]='0';
tNewCard.frozeflag[0]='0';
tNewCard.badflag[0]='0';
tNewCard.status[0]=STATUS_NORMAL;
des2src(tNewCard.opendate,pAccTrans->trans.transdate);
getfmtsysdatetime(tNewCard.lastsaved);
ret = getNewUniqNo(KEYTYPE_CARDNO,&tNewCard.cardno); //获取最大卡号
if(ret)
{
return ret;
}
ret=getCardVerNo(tNewCard.cardverno);
if(ret)
{
return ret;
}
ret=DB_t_card_add(&tNewCard);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_CARD_E;
else
return E_DB_CARD_I;
}
////添加新卡版本号记录
// T_t_cardver cardver;
memset(&cardver,0,sizeof(cardver));
des2src(cardver.accdate,pAccTrans->trans.sysdate);
cardver.termid=trans.termid;
cardver.termseqno=trans.termseqno;
cardver.cardno=tNewCard.cardno;
cardver.status[0]=STATUS_NORMAL;
des2src(cardver.cardphyid,tNewCard.cardphyid);
des2src(cardver.stuempno,trans.stuempno);
cardver.cardvertype=CARDVERTYPE_CARDOPEN;
des2src(cardver.cardverno,tNewCard.cardverno);
ret=DB_t_cardver_add(&cardver);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_CARDVER_E;
else
return E_DB_CARDVER_I;
}
//添加换卡记录
T_t_cardnochange tCardnoChange;
memset(&tCardnoChange,0,sizeof(tCardnoChange));
des2src(tCardnoChange.changedate,pAccTrans->trans.sysdate);
tCardnoChange.oldcardno=tCard.cardno;
tCardnoChange.newcardno=tNewCard.cardno;
ret=DB_t_cardnochange_add(&tCardnoChange);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_CARDNOCHANGE_E;
else
return E_DB_CARDNOCHANGE_I;
}
//插入卡位图表
T_t_cardbitmap tCardBitmap;
memset(&tCardBitmap,0,sizeof(tCardBitmap));
tCardBitmap.cardno=tNewCard.cardno;
tCardBitmap.baseno=0;
memset(tCardBitmap.bitmap0,'0',sizeof(tCardBitmap.bitmap0));
memset(tCardBitmap.bitmap1,'0',sizeof(tCardBitmap.bitmap1));
memset(tCardBitmap.bitmap2,'0',sizeof(tCardBitmap.bitmap2));
memset(tCardBitmap.bitmap3,'0',sizeof(tCardBitmap.bitmap3));
memset(tCardBitmap.bitmap4,'0',sizeof(tCardBitmap.bitmap4));
memset(tCardBitmap.bitmap5,'0',sizeof(tCardBitmap.bitmap5));
memset(tCardBitmap.bitmap6,'0',sizeof(tCardBitmap.bitmap6));
memset(tCardBitmap.bitmap7,'0',sizeof(tCardBitmap.bitmap7));
memset(tCardBitmap.bitmap8,'0',sizeof(tCardBitmap.bitmap8));
memset(tCardBitmap.bitmap9,'0',sizeof(tCardBitmap.bitmap9));
tCardBitmap.bitmap0[0]=CARDBITMAPTYPE_INC;
ret=DB_t_cardbitmap_add(&tCardBitmap);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_CARDBITMAP_E;
else
return E_DB_CARDBITMAP_I;
}
//领取补助
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_by_cardno_and_purseno(trans.cardno,trans.purseno,&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_CARDNO_PURSENO_NOACCNO,trans.cardno,trans.purseno);
else
return E_DB_ACCOUNT_R;
}
if(tCardAccount.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_CARDACC_LOGOUT,tCardAccount.accno);
}
double subsidyamt=0;
int maxsubsidyno=0;
//检查补助信息
ret = GetSubsidy(tCard.cardno,tCardAccount.subsidyno,0,subsidyamt,maxsubsidyno);
if(ret)
{
writelog(LOG_ERR,"DoGetSubsidy ret=[%d]",ret);
return ret;
}
strcpy(trans.cardaccno,tCardAccount.accno);
//押金处理
// double returncashamt=0;
if(freefeeflag)
{
pAccTrans->SetFreeFlag();
}
else
{
//扣押金
if(amtcmp(tCardAccount.foregift,0)>0)
{
trans.transamt=tCardAccount.foregift;
trans.inputamt=tCardAccount.foregift;
trans.fundtype=0;
pAccTrans->trans.transtype=TRANSTYPE_FOREGIFT2COSTFEE;
ret=pAccTrans->DoTransByTransType();
if(ret)
return ret;
if(amtcmp(pAccTrans->trans.unusedamt,0)>0)
return E_INPUT_AMT;
if(amtcmp(pAccTrans->trans.unusedamt,0)<0)
return E_AMT_LACK;
}
}
if(amtcmp(tCardAccount.availbal,tCardAccount.lastcardbal)<=0)
trans.cardbefbal=D4U5(tCardAccount.availbal+tCardAccount.subsidybal);
else
trans.cardbefbal=D4U5(tCardAccount.lastcardbal+tCardAccount.subsidybal);
if(amtcmp(tCardAccount.subsidybal,0)!=0)
{
//领取补助
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_lock_by_c0_and_accno(trans.cardaccno,&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_ACCNO,trans.cardaccno);
else
return E_DB_ACCOUNT_R;
}
tCardAccount.availbal=D4U5(tCardAccount.availbal+tCardAccount.subsidybal);
tCardAccount.subsidybal=0;
ret=DB_t_account_update_lock_by_c0(&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_ACCOUNT_U;
else
return E_DB_ACCOUNT_R;
}
}
if(amtcmp(tCardAccount.balance-tCardAccount.frozebal,trans.cardbefbal)>0)
{
//走长款处理
trans.transamt=D4U5(tCardAccount.balance-tCardAccount.frozebal-trans.cardbefbal);
trans.inputamt=trans.transamt;
trans.fundtype=0;
pAccTrans->trans.transtype=TRANSTYPE_MORE_CARDBALINCOME;
ret=pAccTrans->DoTransByTransType();
if(ret)
return ret;
if(amtcmp(pAccTrans->trans.unusedamt,0)>0)
return E_INPUT_AMT;
if(amtcmp(pAccTrans->trans.unusedamt,0)<0)
return E_AMT_LACK;
}
trans.cardflag=1;
trans.usecardflag=1;
trans.feetype=tCard.feetype;
trans.fundtype=rPack->lvol9;
trans.cardcnt=1;
trans.inputamt=rPack->damt0;
if(trans.fundtype>4)
{
//如果从账户中扣卡成本费，则没有充值业务
trans.fundtype=0;
ret=pAccTrans->doFeeTrans();
if(ret)
return ret;
}
else
{
des2src(trans.voucherno,rPack->scust_auth2);
ret=pAccTrans->doTrans();
if(ret)
return ret;
}
ret=pAccTrans->doTransEnd();
if(ret)
return ret;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_lock_by_c0_and_accno(trans.cardaccno,&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,trans.cardaccno);
else
return E_DB_ACCOUNT_R;
}
if(tCardAccount.status[0]!=STATUS_NORMAL)
{
DB_t_account_free_lock_by_c0();
return ERRINFO(E_CARDACC_LOGOUT,tCardAccount.accno);
}
//取可用余额作为出卡值
trans.cardaftbal=tCardAccount.availbal;
if(amtcmp(trans.cardaftbal,0)<0)
{
DB_t_account_free_lock_by_c0();
return ERRINFO(E_CARD_BALANCE_SHORTAGE,trans.cardaftbal);
}
if(amtcmp(trans.cardaftbal,tCardAccount.cardmaxbal)>=0)
{
DB_t_account_free_lock_by_c0();
return ERRINFO(E_AMT_EXCEED_MAX,tCardAccount.cardmaxbal);
}
tCardAccount.cardno=tNewCard.cardno;
tCardAccount.lastcardcnt=1;
tCardAccount.lastsubsidyno=maxsubsidyno;
tCardAccount.lastcardbal=trans.cardaftbal;
des2src(tCardAccount.lasttransdate,trans.transdate);
ret=DB_t_account_update_lock_by_c0(&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_ACCOUNT_U;
else
return E_DB_ACCOUNT_R;
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
strcpy(transdtl.transdate,trans.transdate);
strcpy(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.sysdate);
strcpy(transdtl.acctime,trans.systime);
transdtl.amount=trans.totaltransamt;
transdtl.managefee=trans.totalfeeamt;
transdtl.cardno=tNewCard.cardno;
transdtl.cardcnt=trans.cardcnt;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.cardaftbal=trans.cardaftbal;
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.paytype=trans.fundtype;
des2src(transdtl.voucherno,trans.voucherno);
des2src(transdtl.opercode,trans.opercode);
transdtl.status[0]=DTLSTATUS_SUCCESS;
transdtl.errcode=0;
transdtl.custid=tCustomer.custid;
des2src(transdtl.custname,tCustomer.custname);
transdtl.showcardno=atol(tNewCard.showcardno);
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
char cardpwd[33]="";
char key[17]="";
//get_init_passwd_by_man_id(tCustomer.idno,cardpwd);
strcpy(key,STATIC_SEED_KEY);
EncodePwd(key,cardpwd,tNewCard.cardpwd, 1);
SetCol(handle,F_LVOL1,F_LSAFE_LEVEL2,F_LVOL4,F_LVOL5,
F_SALL_NAME,F_SPAGER,F_SCERT_NO,
F_SEMAIL2,F_SMARKET_CODE,F_SDATE0,
F_LVOL0,F_STX_PWD,F_LVOL8,F_LVOL11,F_LVOL12,
F_SORDER0,F_SDATE3,F_SEMP,
F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,0);
outPack->lvol1=tNewCard.custid;
outPack->lsafe_level2=tCustomer.custtype;
outPack->lvol5=tNewCard.feetype;
des2src(outPack->sall_name,tCustomer.custname);
des2src(outPack->spager,tCustomer.stuempno);
des2src(outPack->scert_no,tCustomer.deptcode);
des2src(outPack->semail2,tCustomer.idno);
des2src(outPack->smarket_code,tCustomer.sex);
des2src(outPack->sdate0,tNewCard.expiredate);
outPack->lvol0=tNewCard.cardno;
des2src(outPack->stx_pwd,cardpwd);
outPack->lvol4=maxsubsidyno;
outPack->lvol8=D4U5(pAccTrans->trans.cardaftbal*100,0);
outPack->lvol11=D4U5(tCardAccount.singlemaxamt*100,0);
outPack->lvol12=D4U5(tCardAccount.daycostmaxamt*100,0);
des2src(outPack->sorder0,tNewCard.showcardno);
des2src(outPack->sdate3,pAccTrans->trans.sysdate);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
sprintf(trans.remark,"%s卡余额%.2lf元",pAccTrans->remark.c_str(),pAccTrans->trans.cardaftbal);
des2src(outPack->vsmess,trans.remark);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
int F846341(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
des2src(trans.refno,rPack->sphone3);
if(strlen(trans.refno)!=14)
{
ERRTIP("交易参考号错误");
return E_COMMON_ERR;
}
T_t_refno tRefno;
memset(&tRefno,0,sizeof(tRefno));
ret=DB_t_refno_read_by_refno(trans.refno,&tRefno);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_REFNO_N;
else
return E_DB_REFNO_R;
}
if(strncmp(tRefno.mac,rPack->saddr,8)!=0)
{
return E_MAC_FAIL;
}
if(RS_SUCC!=tRefno.status)
{
return ERRIF_TRANS_REVERSED;
}
pAccTrans->trans.transcode=TC_TRANSREV;
pAccTrans->trans.termid=tRefno.termid;
ret=pAccTrans->InitTrans();
if(ret)
return ret;
ret=doTransRev(tRefno.accdate,tRefno.termid,tRefno.termseqno);
if(ret)
{
writelog(LOG_ERR,"acctransrev err ret=%d",ret);
return ret;
}
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,F_LVOL0,F_SPHONE3,F_SADDR,F_LWITHDRAW_FLAG,F_SDATE3,F_STIME3,F_SEMP,F_LSERIAL1,F_VSMESS,0);
outPack->lvol0=pAccTrans->trans.cardno;
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
des2src(outPack->semp,pAccTrans->trans.opercode);
outPack->lserial1=pAccTrans->trans.termseqno;
strcpy(outPack->sphone3,tRefno.refno);
strcpy(outPack->saddr,tRefno.mac);
strcpy(outPack->vsmess,pAccTrans->remark.c_str());
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
int F849003(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret =0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
ret=pAccTrans->CheckCfgUpdate();
if(ret)
return ret;
T_t_authcard tAuthCard;
T_t_transdtl transdtl;
T_t_dpsoper tDepositOper;
T_t_dpsoperpos tDepositOperpos;
T_t_dpsshoppos tDepositShoppos;
T_t_shop tDepositShop;
T_t_account tAccount; //帐户表
ST_CPACK aPack;
ST_PACK *out_pack = &(aPack.pack);
memset(&tAuthCard,0,sizeof(tAuthCard));
memset(&tDepositOper,0,sizeof(tDepositOper));
memset(&tDepositOperpos,0,sizeof(tDepositOperpos));
memset(&tDepositShoppos,0,sizeof(tDepositShoppos));
memset(&tDepositShop,0,sizeof(tDepositShop));
memset(&tAccount,0,sizeof(tAccount));
memset(&transdtl,0,sizeof(transdtl));
int opercardno=rPack->lvol3; //操作员号
if(!opercardno)
return E_INPUTNULL_CARDNO;
trans.cardflag=1;
trans.usecardflag=1;
trans.cardno=rPack->lvol5;
trans.purseno=PURSE_NO_ONE;
trans.cardbefbal=rPack->lvol9/100.0; //入卡金额
trans.cardaftbal=trans.cardbefbal;
trans.dpscnt= rPack->lvol7; //入卡金额
trans.inputamt= rPack->lvol8/100.0; //充值金额
trans.unusedamt = trans.inputamt;
trans.fundtype=1;
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=doCard(trans,tCard);
if(ret)
{
return ret;
}
trans.feetype=tCard.feetype;
trans.cardtype=tCard.cardtype;
// ret=UpdateCardBitmap(trans.cardno,trans.cardcnt,CARDBITMAPTYPE_INC,0);
// if(ret)
// return ret;
transdtl.sysid= rPack->lcert_code; //上传工作站标识(前置机注册号)
des2src(transdtl.devphyid, rPack->sphone3); //物理设备ID
transdtl.devseqno=rPack->lvol4; //上传端流水号
// 读取操作员号
ret = DB_t_authcard_read_by_cardno(opercardno,&tAuthCard);
if(ret)
{
writelog(LOG_ERR,"get operator code from auth card error, auth_card_id[%d]",opercardno);
if(DB_NOTFOUND == ret)
return E_DB_AUTHCARD_N;
else
return E_DB_OPERATOR_R;
}
if(tAuthCard.status[0]!=STATUS_NORMAL)
{
return E_OPERLOGON_UNREG;
}
des2src(trans.opercode,tAuthCard.opercode);
ret=GetDevIdByDevPhyId(&(trans.termid),transdtl.devphyid);
if (ret)
{
writelog(LOG_ERR,"GetDevIdByDevPhyId err[%d] devphy999_id[%s]",ret,transdtl.devphyid);
return ret;
}
ret=DB_t_dpsoper_read_lock_by_c0_and_opercode(trans.opercode,&tDepositOper);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_DEPOSITOPER_R;
else
return E_DB_DEPOSITOPER_N;
}
if(tDepositOper.status[0]!=STATUS_NORMAL)
{
DB_t_dpsoper_free_lock_by_c0();
return E_DEPOSITOPER_STOP;
}
//判断是否是重复交易
if(tDepositOper.lastdevseqno==transdtl.devseqno)
{
DB_t_dpsoper_free_lock_by_c0();
ret=DB_t_transdtl_read_by_accdate_and_termid_and_devseqno(trans.accdate,trans.termid,tDepositOper.lastdevseqno,&transdtl);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_DB_TRANSDTL_N;
else
return E_DB_TRANSDTL_R;
}
//if(transdtl.revflag[0]=='1')
// return E_TRANSDTL_REV;
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL5,F_LVOL10,F_LCERT_CODE,0);
out_pack->lvol5 = transdtl.cardno;
out_pack->lvol10 = (int)D4U5(transdtl.cardaftbal*100,0);
out_pack->lcert_code = transdtl.termseqno;
writelog(LOG_INFO,"该交易已成功,卡号[%d]充值金额[%.2lf]卡余额[%.2lf]",transdtl.cardno,transdtl.amount,transdtl.cardaftbal);
PutRow(handle,out_pack,pRetCode,szMsg);
return 0;
}
if(strncmp(tDepositOper.lasttransdate,trans.transdate,8)!=0)
{
des2src(tDepositOper.lasttransdate,trans.transdate);
tDepositOper.depositcnt=0;
tDepositOper.depositamt=0;
}
tDepositOper.depositcnt++;
tDepositOper.depositamt+=trans.inputamt;
tDepositOper.lastdevseqno=transdtl.devseqno;
des2src(tDepositOper.lastdevphyid,transdtl.devphyid);
des2src(tDepositOper.lastsaved,trans.sysdatetime);
if(amtcmp(tDepositOper.maxdepositamt,0)>0)
{
DB_t_dpsoper_free_lock_by_c0();
if(amtcmp(tDepositOper.depositamt,tDepositOper.maxdepositamt)>0)
{
return E_OPER_OVER_MAX_DEPOSIT_AMT;
}
}
ret=DB_t_dpsoper_update_lock_by_c0(&tDepositOper);
if(ret)
{
return E_DB_DEPOSITOPER_U;
}
if('1'==tDepositOper.shopoperflag[0])
{
ret=DB_t_dpsshoppos_read_by_deviceid(trans.termid, &tDepositShoppos);
if(ret)
{
if(DB_NOTFOUND==ret)
{
writelog(LOG_INFO,"PosDeposit termid[%d] ",trans.termid);
return E_DB_DEPOSITSHOPPOS_N;
}
else
{
return E_DB_DEPOSITSHOPPOS_R;
}
}
ret=DB_t_shop_read_by_shopid(tDepositShoppos.shopid, &tDepositShop);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_SHOPID,tDepositShoppos.shopid);
else
return E_DB_SHOP_R;
}
if(tDepositShop.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_SHOP_LOGOUT,tDepositShop.shopid);
}
trans.transcode = TC_SHOPPOSDEPOSIT;
des2src(trans.shopaccno,tDepositShop.accno);
writelog(LOG_INFO,"充值商户充值");
}
else
{
ret=DB_t_dpsshoppos_read_by_deviceid(trans.termid, &tDepositShoppos);
if(ret)
{
if(DB_NOTFOUND!=ret)
{
writelog(LOG_INFO,"PosDeposit termid[%d] ",trans.termid);
return E_DB_DEPOSITSHOPPOS_R;
}
}
else
{
ERRTIP("设备号[%d]属于属于充值商户,非充值商户操作员不能使用该设备",trans.termid);
return E_COMMON_ERR;
}
trans.transcode = TC_POSDEPOSIT;
}
ret=pAccTrans->InitTrans();
if(ret)
return ret;
//根据卡号和钱包号得到消费者账号(借方)
ret=DB_t_account_read_by_accno(tCard.accno,&tAccount);
if(ret)
{
writelog(LOG_ERR,"DB_t_account_read_by_accno ret[%d]cardno[%d]accno[%s]",ret,trans.cardno,tCard.accno);
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_ACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
// double CardMaxBal=0;
// ret=GetPurseMaxBal(PURSE_NO_ONE,CardMaxBal);
// if(ret)
// return ret;
// if(amtcmp(trans.inputamt+trans.cardbefbal,CardMaxBal)>0)
// return ERRINFO(E_AMT_EXCEED_MAX,CardMaxBal);
trans.custid=tCard.custid;
des2src(trans.cardaccno,tAccount.accno);
ret=pAccTrans->doTrans();
if(ret)
return ret;
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.paytype=trans.fundtype;
des2src(transdtl.voucherno,trans.voucherno);
transdtl.cardno=trans.cardno;
transdtl.purseno=trans.purseno;
transdtl.transflag=TF_DPS;
transdtl.cardcnt=trans.dpscnt;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.amount=trans.totaltransamt;
transdtl.managefee=trans.totalfeeamt;
transdtl.cardaftbal=trans.cardaftbal;
transdtl.custid=trans.custid;
des2src(transdtl.showcardno,tCard.showcardno);
des2src(transdtl.custname,tAccount.accname);
des2src(transdtl.opercode,trans.opercode);
GetStuempnoByCustid(transdtl.custid,transdtl.stuempno);
transdtl.status[0]=DTLSTATUS_SUCCESS;
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
sprintf(trans.remark,"卡号%d 充值前卡余额:%.2lf元 卡当前余额:%.2lf元",trans.cardno,trans.cardbefbal,trans.cardaftbal);
writelog(LOG_INFO,trans.remark);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LVOL5,F_LVOL10,F_LCERT_CODE,0);
out_pack->lvol5 = trans.cardno;
out_pack->lvol10 = (int)D4U5(trans.cardaftbal*100,0);
out_pack->lcert_code = trans.termseqno;
PutRow(handle,out_pack,pRetCode,szMsg);
return 0;
}
int F846310(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
// ret=pAccTrans->checkCfgUpdate();
// if(ret)
// return ret;
des2src(pAccTrans->trans.opercode,rPack->semp);
pAccTrans->trans.transcode=TC_CARDRETURN;
ret=pAccTrans->InitTrans();
if(ret)
return ret;
TRANS& trans=pAccTrans->trans;
char anonymflag[2]="";
int returnForgiftFlag=0;
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
//检查客户
trans.cardflag=1;
trans.usecardflag=1;
trans.cardno=rPack->lvol0;
trans.purseno=PURSE_NO_ONE;
trans.paycnt = rPack->lvol6+1;
trans.cardbefbal=rPack->lvol7/100.0;
trans.cardaftbal=trans.cardbefbal;
des2src(trans.cardphyid,rPack->sstation0);
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=doCard(trans,tCard);
if(ret)
{
return ret;
}
ret=UpdateCardBitmap(trans.cardno,trans.paycnt,CARDBITMAPTYPE_SYS_ONLINE);
if(ret)
return ret;
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_by_accno(tCard.accno,&tCardAccount);
if(ret)
{
writelog(LOG_ERR,"cardno[%d]",tCard.cardno);
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
if(tCardAccount.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_CARDACC_LOGOUT,tCardAccount.accno);
}
if(amtcmp(tCardAccount.balance,0)<0)
{
ERRTIP("账户余额小于0不能直接回收");
return E_COMMON_ERR;
}
else if(amtcmp(tCardAccount.balance,0)==0)
{
trans.cardaftbal=0;
}
else
{
strcpy(trans.cardaccno,tCardAccount.accno);
trans.feetype=tCard.feetype;
trans.inputamt=tCardAccount.balance;
trans.unusedamt = trans.inputamt;
ret=pAccTrans->doTrans();
if(ret)
return ret;
ret=pAccTrans->doTransEnd();
if(ret)
return ret;
//修改帐户
ret=doAccount(trans,tCardAccount.accno);
if(ret)
return ret;
}
T_t_customer tCustomer;
memset(&tCustomer,0,sizeof(tCustomer));
if(tCard.custid>0)
{
ret=DB_t_customer_read_by_custid(tCard.custid,&tCustomer);
if(ret)
{
if(DB_NOTFOUND==ret)
return E_NOTEXIST_CUSTOMER;
else
return E_DB_CUSTOMER_R;
}
}
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
strcpy(transdtl.transdate,trans.transdate);
strcpy(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
// des2src(transdtl.collectdate,rPack->sdate1);
// des2src(transdtl.collecttime,rPack->stime1);
transdtl.transcode=trans.transcode;
// transdtl.paytype=rPack->lvol9;
// des2src(transdtl.voucherno,rPack->scust_auth2);
transdtl.cardno=trans.cardno;
transdtl.purseno=PURSE_NO_ONE;
transdtl.transflag=TF_PAY;
transdtl.cardcnt=trans.paycnt;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.cardaftbal=trans.cardaftbal;
transdtl.amount=trans.totaltransamt;
transdtl.managefee=trans.totalfeeamt;
//// transdtl.frontno=0;
//des2src(transdtl.devphyid,rPack->sname);
//transdtl.devseqno=rPack->lserial0;
//des2src(transdtl.bankcode,rPack->sbank_code);
//des2src(transdtl.bankcardno,rPack->scard0);
//des2src(transdtl.mobile,rPack->sphone2);
des2src(transdtl.opercode,trans.opercode);
transdtl.status[0]=DTLSTATUS_SUCCESS;
transdtl.revflag[0]='0';
transdtl.errcode=0;
transdtl.custid=tCardAccount.custid;
des2src(transdtl.showcardno,tCard.showcardno);
GetCustBaseInfoByCustID(transdtl.custid,transdtl.custname,transdtl.stuempno,NULL);
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
SetCol(handle,F_LVOL1,F_LSAFE_LEVEL2,F_LVOL5,F_LVOL6,
F_SALL_NAME,F_SPAGER,F_SCERT_NO,F_SHOLDER_AC_NO,F_LSAFE_LEVEL,F_SMARKET_CODE2,
F_SEMAIL2,F_SMARKET_CODE,F_SDATE0,F_SNOTE,
F_SSTAT_TYPE,F_SSTAT_TYPE2,F_SNATION_CODE,F_SBRANCH_CODE0,
F_LVOL0,F_STX_PWD,F_LVOL8,F_LVOL11,F_LVOL12,
F_SORDER0,F_SORDER1,F_SORDER2,F_SDATE3,F_STIME3,F_SEMP,
F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,F_SNAME2,0);
outPack->lvol1=tCustomer.custid;
outPack->lsafe_level2=tCustomer.custtype;
outPack->lvol5=tCard.feetype;
des2src(outPack->sall_name,tCustomer.custname);
des2src(outPack->spager,tCustomer.stuempno);
des2src(outPack->scert_no,tCustomer.deptcode);
des2src(outPack->semail2,tCustomer.idno);
des2src(outPack->smarket_code,tCustomer.sex);
des2src(outPack->smarket_code2,tCustomer.idtype);
outPack->lsafe_level=tCard.cardtype;
des2src(outPack->sdate0,tCard.expiredate);
outPack->lvol0=tCard.cardno;
outPack->lvol6=trans.paycnt;
des2src(outPack->stx_pwd,tCard.cardpwd);
des2src(outPack->sorder0,tCard.showcardno);
des2src(outPack->sname2,tCard.cardverno);
// des2src(outPack->sorder0,tCard.showcardno);
strcpy(outPack->snote,CARD_STRUCT_VERSION); //制卡版本号
strcpy(outPack->sorder1,CARD_REGISTER_PUBLISH_CODE); //发卡注册标识号
strcpy(outPack->sorder2,CARD_REGISTER_SERVICE_CODE); //服务注册标识号
outPack->lvol8=D4U5(pAccTrans->trans.cardaftbal*100,0);
outPack->lvol11=D4U5(tCardAccount.singlemaxamt*100,0);
outPack->lvol12=D4U5(tCardAccount.daycostmaxamt*100,0);
sprintf(outPack->sholder_ac_no,"%d",tCustomer.custid); //客户号
des2src(outPack->sstat_type,tCustomer.idtype); //证件类型
des2src(outPack->snation_code,tCustomer.country); //国籍
des2src(outPack->sstat_type2,tCustomer.nation); //民族
des2src(outPack->sbranch_code0,tCustomer.areacode); //院校代码
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
sprintf(trans.remark,"%s卡余额%.2lf元",pAccTrans->remark.c_str(),pAccTrans->trans.cardaftbal);
des2src(outPack->vsmess,trans.remark);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
int F846312(TRUSERID *handle,int iRequest,ST_PACK *rPack,int *pRetCode,char *szMsg)
{
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
des2src(pAccTrans->trans.opercode,rPack->semp);
pAccTrans->trans.transcode=TC_CARDDEPOSIT;
ret=pAccTrans->InitTrans();
if(ret)
return ret;
TRANS& trans=pAccTrans->trans;
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
trans.cardflag=1;
trans.usecardflag=1;
trans.cardno=rPack->lvol0;
trans.purseno=PURSE_NO_ONE;
trans.cardbefbal=rPack->lvol7/100.0;
trans.cardaftbal=trans.cardbefbal;
trans.dpscnt=rPack->lvol5+1;
if(trans.dpscnt<=1)
{
if(amtcmp(trans.cardbefbal,0)>0)
trans.dpscnt=rPack->lvol6+1; //考虑兼容性
}
des2src(trans.cardphyid,rPack->sstation0);
trans.fundtype=rPack->lvol9;
if(!trans.fundtype)
return E_INPUTNULL_PAYTYPE;
des2src(trans.voucherno,rPack->scust_auth2);
trans.inputamt=rPack->damt0;
trans.unusedamt = trans.inputamt;
if(amtcmp(trans.inputamt,500)>0)
{
ERRTIP("单笔充值不能超过500元");
return E_COMMON_ERR;
}
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=doCard(trans,tCard);
if(ret)
{
return ret;
}
trans.feetype=tCard.feetype;
trans.cardtype=tCard.cardtype;
// ret=UpdateCardBitmap(trans.cardno,trans.cardcnt,CARDBITMAPTYPE_INC,0);
// if(ret)
// return ret;
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_by_accno(tCard.accno,&tCardAccount);
if(ret)
{
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
if(tCardAccount.status[0]!=STATUS_NORMAL)
{
return ERRINFO(E_CARDACC_LOGOUT,tCardAccount.accno);
}
double CardMaxBal=0;
ret=GetPurseMaxBal(PURSE_NO_ONE,CardMaxBal);
if(ret)
return ret;
if(amtcmp(trans.inputamt+trans.cardbefbal,CardMaxBal)>0)
return ERRINFO(E_AMT_EXCEED_MAX,CardMaxBal);
trans.custid=tCard.custid;
if(trans.custid)
{
ret=GetCustBaseInfoByCustID(trans.custid,trans.custname,trans.stuempno,NULL);
if(ret)
return ret;
}
des2src(trans.cardaccno,tCardAccount.accno);
ret=pAccTrans->doFeeTrans();
if(ret)
return ret;
des2src(trans.craccno,tCardAccount.accno);
ret=pAccTrans->doMainTrans();
if(ret)
return ret;
ret=pAccTrans->doTransEnd();
if(ret)
return ret;
T_t_transdtl transdtl;
memset(&transdtl,0,sizeof(transdtl));
des2src(transdtl.transdate,trans.transdate);
des2src(transdtl.transtime,trans.transtime);
strcpy(transdtl.accdate,trans.accdate);
strcpy(transdtl.acctime,trans.acctime);
transdtl.termid=trans.termid;
transdtl.termseqno=trans.termseqno;
transdtl.transcode=trans.transcode;
transdtl.paytype=trans.fundtype;
des2src(transdtl.voucherno,trans.voucherno);
transdtl.cardno=trans.cardno;
transdtl.purseno=trans.purseno;
transdtl.transflag=TF_DPS;
transdtl.cardcnt=trans.dpscnt;
transdtl.cardbefbal=trans.cardbefbal;
transdtl.amount=trans.totaltransamt;
transdtl.managefee=trans.totalfeeamt;
transdtl.cardaftbal=trans.cardaftbal;
transdtl.custid=trans.custid;
des2src(transdtl.custname,trans.custname);
des2src(transdtl.stuempno,trans.stuempno);
des2src(transdtl.opercode,trans.opercode);
des2src(transdtl.showcardno,tCard.showcardno);
transdtl.status[0]=DTLSTATUS_SUCCESS;
ret=DB_t_transdtl_add(&transdtl);
if(ret)
{
if(DB_REPEAT==ret)
return E_DB_TRANSDTL_E;
else
return E_DB_TRANSDTL_I;
}
SetCol(handle,F_LVOL0,F_LVOL8,F_SDATE0,F_STIME0,
F_SDATE3,F_SEMP,F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,F_STIME3,0);
outPack->lvol0=tCard.cardno;
outPack->lvol8=D4U5(pAccTrans->trans.cardaftbal*100,0);
des2src(outPack->sdate0,transdtl.transdate);
des2src(outPack->stime0,transdtl.transtime);
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
des2src(outPack->semp,trans.opercode);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
sprintf(trans.remark,"%s卡余额%.2lf元",pAccTrans->remark.c_str(),pAccTrans->trans.cardaftbal);
des2src(outPack->vsmess,trans.remark);
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
static int SaveOldCardInfo(TRUSERID *handle,ST_PACK *rPack,int *pRetCode,char *szMsg) {
int ret=0;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
T_t_card tCard;
memset(&tCard,0,sizeof(tCard));
ret=DB_t_card_read_by_cardno(trans.cardno,&tCard);
if(ret) {
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,trans.cardno);
else
return E_DB_CARD_R;
}
if(tCard.status[0]!=STATUS_NORMAL) {
return ERRINFO(E_CARD_LOGOUT,trans.cardno);
}
if('1'==tCard.frozeflag[0]) {
return ERRINFO(E_CARD_FREEZE,trans.cardno);
}
if('1'==tCard.lossflag[0]) {
return ERRINFO(E_CARD_LOST,trans.cardno);
}
if('1'==tCard.badflag[0]) {
return ERRINFO(E_CARD_BADRECORD,trans.cardno);
}
//比较卡物理ID是否相同
if(strcmp(tCard.cardphyid,trans.cardphyid)!=0) {
writelog(LOG_ERR,"db cardphyid[%s],input cardphyid[%s]",tCard.cardphyid,trans.cardphyid);
return E_CARD_PHYNO_DIFFER;
}
T_t_account tCardAccount;
memset(&tCardAccount,0,sizeof(tCardAccount));
ret=DB_t_account_read_by_accno(tCard.accno,&tCardAccount);
if(ret) {
if(DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDACCNO,tCard.accno);
else
return E_DB_ACCOUNT_R;
}
int existflag=0;
ret=IsExistUnGetSubsidy(tCard.cardno,&existflag);
if(ret) {
return ret;
}
if(existflag) {
ERRTIP("有未领补助，请领取补助后再换卡");
return E_COMMON_ERR;
}
ret=DB_t_cardinsteaddtl_del_by_cardno(trans.cardno);
if(ret) {
if(DB_NOTFOUND!=ret)
return E_DB_CARDINSTEADDTL_R;
}
T_t_cardinsteaddtl cardinsteaddtl;
memset(&cardinsteaddtl,0,sizeof(cardinsteaddtl));
des2src(cardinsteaddtl.accdate,pAccTrans->trans.accdate);
cardinsteaddtl.termid = trans.termid;
cardinsteaddtl.termseqno = trans.termseqno;
cardinsteaddtl.cardno = trans.cardno;
cardinsteaddtl.oldcardtype=tCard.cardtype;
des2src(cardinsteaddtl.oldcardphyid,trans.cardphyid);
des2src(cardinsteaddtl.oldshowcardno,tCard.showcardno);
cardinsteaddtl.oldcardcnt = trans.paycnt;
cardinsteaddtl.oldcardbal = trans.cardbefbal;
cardinsteaddtl.oldsubsidyno=trans.cardsubsidyno;
cardinsteaddtl.revflag[0]='0';
cardinsteaddtl.status[0]=STATUS_NORMAL;
ret=DB_t_cardinsteaddtl_add(&cardinsteaddtl);
if(ret) {
if(DB_REPEAT==ret)
return E_DB_CARDINSTEADDTL_E;
else
return E_DB_CARDINSTEADDTL_I;
}
T_t_cardver cardver;
memset(&cardver,0,sizeof(cardver));
cardver.cardno=tCard.cardno;
des2src(cardver.accdate,pAccTrans->trans.accdate);
cardver.termid=trans.termid;
cardver.termseqno=trans.termseqno;
cardver.status[0]=STATUS_NORMAL;
des2src(cardver.cardphyid,cardinsteaddtl.cardphyid);
des2src(cardver.stuempno,trans.stuempno);
cardver.cardvertype=CARDVERTYPE_CARDINSTEADOLD;
ret=getCardVerNo(cardver.cardverno);
if(ret)
return ret;
ret=DB_t_cardver_add(&cardver);
if(ret) {
if(DB_REPEAT==ret)
return E_DB_CARDVER_E;
else
return E_DB_CARDVER_I;
}
ST_CPACK aPack;
ST_PACK *outPack = &(aPack.pack);
ResetNormalCPack(&aPack,0,1);
SetCol(handle,0);
SetCol(handle,F_LWITHDRAW_FLAG,F_LSERIAL1,F_VSMESS,F_SDATE3,F_STIME3,0);
des2src(outPack->semp,trans.opercode);
des2src(outPack->sdate3,pAccTrans->trans.accdate);
des2src(outPack->stime3,pAccTrans->trans.acctime);
outPack->lwithdraw_flag=trans.termid;
outPack->lserial1=trans.termseqno;
PutRow(handle,outPack,pRetCode,szMsg);
return 0;
}
int DoUnlossCard(int cardno)
{
int ret=0;
T_t_card tCard;
CAccTrans *pAccTrans=CAccTrans::getInstance();
TRANS& trans=pAccTrans->trans;
trans.transcode=TC_CARDUNLOSS;
memset(&tCard,0,sizeof(tCard));
ret=DB_t_card_read_lock_by_cur_and_cardno(cardno,&tCard);
if (ret)
{
writelog(LOG_ERR,"cardno[%d]",cardno);
if (DB_NOTFOUND==ret)
return ERRINFO(E_NOTEXIST_CARDNO,cardno);
else
return E_DB_CARD_R;
}
des2src(trans.showcardno,tCard.showcardno);
if(tCard.status[0]!=STATUS_NORMAL)
{
DB_t_card_free_lock_by_cur();
return ERRINFO(E_CARD_LOGOUT,trans.cardno);
}
// if('1'!=tCard.lossflag[0])
// {
// DB_t_card_free_lock_by_cur();
// return ERRINFO(E_CARDNO_NOLOST,trans.cardno);
// }
if('1'==tCard.frozeflag[0])
{
DB_t_card_free_lock_by_cur();
ERRTIP("请先解冻后再解挂");
return ERRINFO(E_CARD_FREEZE,trans.cardno);
}
if('1'==tCard.badflag[0])
{
DB_t_card_free_lock_by_cur();
return ERRINFO(E_CARD_BADRECORD,trans.cardno);
}
//判断是否存在过渡临时卡
if(CARDTYPE_TEMP!=tCard.cardtype)
{
ret=IsExistNormalTmpCardByCustid(tCard.custid);
if(ret)
{
DB_t_card_free_lock_by_cur();
if(DB_EXIST==ret)
{
//锁定该卡,该卡只能销户
ERRTIP("该客户存在卡状态正常的过渡临时卡,请先退掉过卡状态正常的渡临时卡再解挂");
return E_EXIST_NORMALCARD;
}
else
return ret;
}
}
else
{
//检查是否存在其他正常的卡
ret=IsExistOtherNormalCardByCustid(tCard.custid,tCard.cardno);
if(ret)
{
if(DB_EXIST==ret)
{
//锁定该卡,该卡只能销户
TIPINFO("该客户存在卡状态正常的其他卡,该卡解挂后将不能再使用,请解挂后注销该卡!");
tCard.lockflag[0]='1';
des2src(tCard.lockdate,trans.accdate);
}
else
{
DB_t_card_free_lock_by_cur();
return ret;
}
}
}
tCard.lossflag[0]='0';
tCard.lossdate[0]=0;
ret=getCardVerNo(tCard.cardverno);
if (ret)
{
DB_t_card_free_lock_by_cur();
return ret;
}
des2src(tCard.lastsaved,trans.sysdatetime);
ret=DB_t_card_update_lock_by_cur(&tCard);
if (ret)
{
writelog(LOG_ERR,"cardno[%d]",tCard.cardno);
if (DB_NOTFOUND==ret)
return E_NOTEXIST_CARDNO;
else
return E_DB_CARD_U;
}
T_t_customer customer;
memset(&customer,0,sizeof(customer));
if (tCard.custid)
{
ret=DB_t_customer_read_by_custid(tCard.custid,&customer);
if (ret)
{
if (DB_NOTFOUND==ret)
return E_NOTEXIST_CUSTOMER;
else
return E_DB_CUSTOMER_R;
}
trans.custid=tCard.custid;
des2src(trans.custname,customer.custname);
des2src(trans.stuempno,customer.stuempno);
}
UpdCardVerStatus(cardno,CARDVERTYPE_CARDLOSS);
if('1'==tCard.lockflag[0])
{
//不下发名单
strcpy(trans.summary,"000101010101");
return 0;
}
//更新系统黑名单最大版本号
ret=SetSysParaVal(SYSPARA_MAXBLACKCARDVERNO,tCard.cardverno);
if(ret)
{
return ret;
}
T_t_cardver cardver;
memset(&cardver,0,sizeof(cardver));
cardver.cardno=tCard.cardno;
des2src(cardver.accdate,pAccTrans->trans.accdate);
cardver.termid=trans.termid;
cardver.termseqno=trans.termseqno;
cardver.cardno=tCard.cardno;
des2src(cardver.cardphyid,tCard.cardphyid);
des2src(cardver.stuempno,customer.stuempno);
cardver.cardvertype=CARDVERTYPE_CARDUNLOSS;
cardver.adddelflag=ADDDELFLAG_DEL;
cardver.status[0]=STATUS_NORMAL;
des2src(cardver.cardverno,tCard.cardverno);
ret=DB_t_cardver_add(&cardver);
if (ret)
{
if (DB_REPEAT==ret)
return E_DB_CARDVER_E;
else
return E_DB_CARDVER_I;
}
des2src(trans.summary,cardver.cardverno);
char broadcastblkflag[20]={0};
ret=GetSysParaVal(SYSPARA_BROADCASTBLKLIST,broadcastblkflag);
if(ret)
{
if(DB_NOTFOUND==ret)
return 0;
else
return E_DB_SYSKEY_R;
}
if(broadcastblkflag[0]!='1')
return 0;
T_t_msglist tMsgList;
memset(&tMsgList,0,sizeof(tMsgList));
AddXmlItemInt(tMsgList.reqdata, XML_KEY_CARDID,tCard.cardno);
AddXmlItemStr(tMsgList.reqdata, XML_KEY_VERNUM,tCard.cardverno);
AddXmlItemInt(tMsgList.reqdata, XML_KEY_ADDDELSIGN,1); //增删标志
tMsgList.funcno = 930005;
tMsgList.pfuncno = 846307;
tMsgList.msglevel = MESLIST_PRIORITY_REALTIME;
tMsgList.msgtype = MESLIST_TYPE_ORDER;
ret=AddMsgLst(&tMsgList);
if(ret)
{
writelog(LOG_ERR,"AddMsgLst err[%d]",ret);
return ret;
}
return 0;
}
