def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '退付开始' )
#=====刘雨龙 20080811 新增查找fa15表中财政区划内码,条件为单位内码====
#sql = "select AAA010 from fs_fa15 where AFA050='" + TradeContext.busiNo + "'"
sql = "select AAA010 from fs_fa22 where busino='" + TradeContext.busiNo + "'"
#begin 20100629 蔡永贵增加查询条件
sql = sql + " and AFA101 = '" + TradeContext.bankbm + "'"
AfaLoggerFunc.tradeInfo( sql )
#end
ret = AfaDBFunc.SelectSql( sql )
if ret == None:
return AfaFlowControl.ExitThisFlow('0001','通过单位内码查找财政区划内码失败')
elif len(ret) <= 0:
return AfaFlowControl.ExitThisFlow('0001','通过单位内码查找财政区划内码无满足条件记录')
else:
TradeContext.AAA010 = ret[0][0]
TradeContext.__agentEigen__ = '0' #从表标志
#将字段转化为退付交易所使用的字段
TradeContext.AFC060 = TradeContext.userNo
TradeContext.AFA050 = TradeContext.note1
TradeContext.AFC064 = TradeContext.amount
TradeContext.AFC063 = TradeContext.accno
#=====刘雨龙 20080811 新增条件财政区划内码====
#sqlstr = "select flag from fs_fc75 where afc060='" + TradeContext.AFC060 + "'"
sqlstr = "select flag from fs_fc75 where afc060='" + TradeContext.AFC060 + "'"
sqlstr = sqlstr + " and AAA010 = '" + TradeContext.AAA010 + "'"
#===条件增加银行编码字段,张恒修改===
sqlstr = sqlstr + " and afa101 = '" + TradeContext.bankbm + "'"
records = AfaDBFunc.SelectSql( sqlstr )
AfaLoggerFunc.tradeInfo( '退付查询' + sqlstr )
if ( len(records) > 0 ):
if records[0][0] == '0':
TradeContext.errorCode,TradeContext.errorMsg = '0001','已经查找到了退付编号，不能再次退付'
AfaLoggerFunc.tradeInfo( TradeContext.errorMsg )
return False
elif records[0][0] != '1':
TradeContext.errorCode,TradeContext.errorMsg = '0002',"缴款书状态位异常"
AfaLoggerFunc.tradeInfo( TradeContext.errorMsg )
return False
return True
def SubModuleMainFst( ):
AfaLoggerFunc.tradeInfo( '********************查找数据表结束*******************' )
TradeContext.__agentEigen__ = '0' #从表标志
sqlstr = "select busino,hostip,upuser,uppasswd,upldir,downuser,downpasswd,downldir from fs_businoconf where busino='" + TradeContext.busiNo + "'"
AfaLoggerFunc.tradeInfo(sqlstr)
records = AfaDBFunc.SelectSql( sqlstr )
if records == None:
TradeContext.errorCode = "0001"
TradeContext.errorMsg = "操作数据库异常"
AfaLoggerFunc.tradeInfo(sqlstr+AfaDBFunc.sqlErrMsg)
return False
if( len( records)==0 ):
TradeContext.errorCode = "0001"
TradeContext.errorMsg = "未找到相应记录"
AfaLoggerFunc.tradeInfo(sqlstr+AfaDBFunc.sqlErrMsg)
return False
else:
TradeContext.APPNO = 'AG2008'
TradeContext.BUSINO = records[0][0]
TradeContext.HOSTIP = records[0][1]
TradeContext.RDOWNPATH = records[0][7]
TradeContext.RUPPATH = records[0][4]
TradeContext.DOWNUSER = records[0][5]
TradeContext.DOWNPWD = records[0][6]
TradeContext.UPUSER = records[0][2]
TradeContext.UPPD = records[0][3]
sqlstr = "select date,this from fs_remain where busino='" + TradeContext.busiNo + "'"
AfaLoggerFunc.tradeInfo(sqlstr)
records = AfaDBFunc.SelectSql( sqlstr )
if records == None:
TradeContext.errorCode = "0001"
TradeContext.errorMsg = "操作数据库异常"
AfaLoggerFunc.tradeInfo(sqlstr+AfaDBFunc.sqlErrMsg)
return False
if( len( records)==0 ):
TradeContext.errorCode = "0001"
TradeContext.errorMsg = "未找到相应记录"
AfaLoggerFunc.tradeInfo(sqlstr+AfaDBFunc.sqlErrMsg)
return False
else:
AfaLoggerFunc.tradeInfo(records[0][1])
TradeContext.THIS = records[0][1]
AfaLoggerFunc.tradeInfo(records[0][0])
TradeContext.ACCDATE = records[0][0]
AfaLoggerFunc.tradeInfo( '********************查找数据表结束*******************' )
TradeContext.errorCode,TradeContext.errorMsg = "0000","查找非税数据成功"
return True
def AdbSelectQueDtl( ):
AfaLoggerFunc.tradeInfo( '>>>>>>>开始查询原交易<<<<<<<')
sql = "select * from YBT_INFO "
sql = sql + " where WORKDATE = '" + TradeContext.workDate.strip() + "'" #交易日期
sql = sql + " and SUBMINO = '" + TradeContext.applno.strip() + "'" #投保单号
sql = sql + " and cpicno = '" + TradeContext.unitno + "'" #保险公司单位编码
sql = sql + " and tellerno = '" + TradeContext.tellerno + "'" #交易柜员号
AfaLoggerFunc.tradeInfo( '>>>>>>>开始查询原交易：'+ str(sql))
records = AfaDBFunc.SelectSql( sql )
AfaLoggerFunc.tradeInfo('查询到记录条数为：'+str(len(records)))
#没有记录则插入数据
if(len(records)==0):
if not AdbInsertQueDtl( ):
raise AfaFlowControl.flowException()
else:
return True
#有记录则更新原纪录
else:
if not AdbUpdateQueDtl( ):
raise AfaFlowControl.flowException()
else:
return True
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT BJEDTE,BSPSQN,BRSFLG,BESBNO,BEACSB,BETELR,BEAUUS,NCCWKDAT,TRCCO,TRCDAT,TRCNO,SNDMBRCO,RCVMBRCO,SNDBNKCO,SNDBNKNM,RCVBNKCO,RCVBNKNM,BOJEDT,BOSPSQ,ORTRCCO,CUR,OCCAMT,CONT,NCCTRCST,MBRTRCST,ISDEAL,PRCCO,STRINFO,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_ztcbka WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT SNDBNKCO,TRCDAT,TRCNO,ROPRTPNO,TRCCO,RCVBNKCO,CUR,RDTCNT,RDTAMT,RCTCNT,RCTAMT,SDTCNT,SDTAMT,SCTCNT,SCTAMT,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_atrchk WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def ADBGetInfoByUnitno():
AfaLoggerFunc.tradeInfo( '>>>>获取保险公司相关信息<<<<' )
AfaLoggerFunc.tradeInfo("保险公司代码[" + TradeContext.unitno + "]")
#初始化险种代码和险种名称
TradeContext.ProCodeStr = ''
TradeContext.PlanName = ''
sql = ""
sql = "select NOTE2 from afa_unitadm where sysid = '" + TradeContext.sysId + "' and unitno = '" + TradeContext.unitno + "'"
record = AfaDBFunc.SelectSql( sql )
if ( record == None ):
AfaLoggerFunc.tradeInfo( '>>>>获取保险公司相关信息异常<<<<' )
TradeContext.errorCode,TradeContext.errorMsg='A0100','获取保险公司相关信息异常'
return False
if ( len(record) <= 0):
AfaLoggerFunc.tradeInfo( '>>>>未查到相关保险公司信息<<<<' )
TradeContext.errorCode,TradeContext.errorMsg='A0100','未查到相关保险公司信息'
return False
else:
tmplist = record[0][0].split("|")
if len(tmplist) < 2:
AfaLoggerFunc.tradeInfo(">>>>保险公司配置信息非法<<<<")
TradeContext.errorCode,TradeContext.errorMsg='A0100','保险公司配置信息非法'
return False
TradeContext.ProCodeStr = tmplist[0]
TradeContext.PlanName = tmplist[1]
AfaLoggerFunc.tradeInfo( '>>>>数据库配置险种代码[' + TradeContext.ProCodeStr + ']' )
AfaLoggerFunc.tradeInfo( '>>>>数据库配置险种名称[' + TradeContext.PlanName + ']' )
return True
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT NCCWKDAT,SCNBBH,SCFEDT,SCRBSQ,SCEYDT,SCTLSQ,SCRVSB,SCCATR,SCWLBZ,SCTRAM,SCFLAG,SCSTCD,SCBYZ1,SCBYZ2,SCBYZ3,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_tdzjmx WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT BJEDTE,BSPSQN,BRSFLG,BESBNO,BEACSB,BETELR,BEAUUS,BEAUPS,TERMID,BBSSRC,DASQ,DCFLG,OPRNO,OPRATTNO,NCCWKDAT,TRCCO,TRCDAT,TRCNO,MSGFLGNO,COTRCDAT,COTRCNO,COMSGFLGNO,SNDMBRCO,RCVMBRCO,SNDBNKCO,SNDBNKNM,RCVBNKCO,RCVBNKNM,CUR,OCCAMT,CHRGTYP,LOCCUSCHRG,CUSCHRG,PYRTYP,PYRACC,PYRNAM,PYRADDR,PYETYP,PYEACC,PYENAM,PYEADDR,STRINFO,CERTTYPE,CERTNO,BNKBKNO,BNKBKBAL,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_wtrbka WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def closeCron(taskid):
#======================查询系统调度信息================================
sql = "SELECT * FROM AFA_CRONADM WHERE TASKID = '" + taskid + "'"
records = AfaDBFunc.SelectSql(sql)
if records == None:
rccpsCronFunc.WrtLog( AfaDBFunc.sqlErrMsg )
WrtLog("获取系统调度[" + taskid + "]信息异常")
return False
if len(records) <= 0:
WrtLog("系统调度表中无此调度信息[" + taskid + "]")
return False
#======================修改系统调度状态为0=============================
sql = "UPDATE AFA_CRONADM SET STATUS = '0' WHERE TASKID = '" + taskid + "'"
if not AfaDBFunc.UpdateSql(sql):
rccpsCronFunc.WrtLog( AfaDBFunc.sqlErrMsg )
WrtLog("关闭系统调度[" + taskid + "]异常")
return False
WrtLog("关闭系统调度[" + taskid + "]成功")
return True
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT BESBNO,BESBNM,BESBTP,BTOPSB,BEACSB,BANKBIN,STRINFO,SUBFLG,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_subbra WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def Query():
try:
if( TradeContext.existVariable( "BRNO" ) and len(TradeContext.BRNO)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[分行行号]:不能为空')
sql="SELECT BRNO,PAYBKCODE,BANKNO,BANKACCT,BANKNAME,PAYEEBANKNO,STATUS,ACCNO,NOTE1,NOTE2,NOTE3,NOTE4,NOTE5 "
sql=sql+" FROM TIPS_BRANCH_ADM WHERE 1=1 "
sql=sql+"AND BRNO='"+ TradeContext.BRNO+"'"
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql(sql)
if( records == None ):
AfaLoggerFunc.tradeFatal(sql)
return AfaFlowControl.ExitThisFlow( 'A0002', '数据库操作异常:'+AfaDBFunc.sqlErrMsg )
elif( len( records )==0 ):
return AfaFlowControl.ExitThisFlow( 'A0027', '未定义信息' )
elif( len( records )>1 ):
return AfaFlowControl.ExitThisFlow( 'A0027', 'TIPS_BRANCH_ADM表配置错误' )
else:
#if records[0][5]=='0':
# return AfaFlowControl.ExitThisFlow( 'A0027', '业务已停止' )
# if records[0][5]=='2':
# return AfaFlowControl.ExitThisFlow( 'A0027', '业务已暂停' )
TradeContext.BRNO = records[0][0]
TradeContext.PAYBKCODE = records[0][1]
TradeContext.BANKNO = records[0][2]
TradeContext.BANKACCT = records[0][3]
TradeContext.BANKNAME = records[0][4]
TradeContext.PAYEEBANKNO = records[0][5]
TradeContext.STATUS = records[0][6]
TradeContext.ACCNO = records[0][7]
TradeContext.ACCNAME = records[0][10]
return True
except Exception, e:
AfaLoggerFunc.tradeInfo(e)
return AfaFlowControl.ExitThisFlow('9999', '程序处理异常'+str(e))
def Delete():
try:
if( TradeContext.existVariable( "BRNO" ) and len(TradeContext.BRNO)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[分行行号]:不能为空')
sql="SELECT BRNO,PAYBKCODE,BANKNO,BANKACCT,BANKNAME,PAYEEBANKNO,STATUS,ACCNO,NOTE1,NOTE2,NOTE3,NOTE4,NOTE5 "
sql=sql+" FROM TIPS_BRANCH_ADM WHERE 1=1 "
sql=sql+"AND BRNO='"+ TradeContext.BRNO+"'"
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql(sql)
if( records == None ):
AfaLoggerFunc.tradeFatal(sql)
return AfaFlowControl.ExitThisFlow( 'A0002', '数据库操作异常:'+AfaDBFunc.sqlErrMsg )
elif( len( records ) == 0 ):
return AfaFlowControl.ExitThisFlow( 'A0027', '不存在此上线行信息' )
sql="DELETE "
sql=sql+" FROM TIPS_BRANCH_ADM WHERE 1=1 "
if( TradeContext.existVariable( "BRNO" ) and len(TradeContext.BRNO)>0):
sql=sql+"AND BRNO='"+ TradeContext.BRNO+"'"
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.DeleteSqlCmt(sql)
if( records == None or records <=0 ):
AfaLoggerFunc.tradeFatal(sql)
return AfaFlowControl.ExitThisFlow( 'A0002', '数据库操作异常:'+AfaDBFunc.sqlErrMsg )
return True
except Exception, e:
AfaLoggerFunc.tradeInfo(e)
return AfaFlowControl.ExitThisFlow('9999', '程序处理异常'+str(e))
def SubModuleMainFst( ):
TradeContext.__agentEigen__ = '0' #从表标志
AfaLoggerFunc.tradeInfo( "单位编码信息查询开始" )
#在中台数据库中查询
sqlstr = "select ACCNO,NAME,AAA010 ,AAA012,BANKNO,BANKNAME from fs_businoinfo where busino='" + TradeContext.busiNo + "' and bankno = '" + TradeContext.bankbm + "'"
AfaLoggerFunc.tradeInfo( sqlstr )
records = AfaDBFunc.SelectSql( sqlstr )
if( records == None ):
TradeContext.errorCode = "9999"
TradeContext.errorMsg = "查找单位编码信息异常"
return False
elif ( len( records)==0 ):
TradeContext.errorCode = "0001"
TradeContext.errorMsg = "没有查找到单位编码信息"
return False
else:
TradeContext.O1ACCN = records[0][0] #收款人帐号
TradeContext.O1NAME = records[0][1] #收款人名字
TradeContext.O1AAA010 = records[0][2] #财政区划内码
TradeContext.O1AAA012 = records[0][3] #区划名称
TradeContext.O1BANKNO = records[0][4] #收款人开户行编码
TradeContext.O1BANKNAME = records[0][5] #收款人开户行名称
TradeContext.errorCode = "0000"
TradeContext.errorMsg = "查找单位编码信息成功"
AfaLoggerFunc.tradeInfo( "********************中台单位编码信息查询结束***************" )
return True
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT NCCWKDAT,SNDBNKCO,TRCDAT,TRCNO,RCVBNKCO,SNDMBRCO,RCVMBRCO,TRCCO,DCFLG,PYRACC,PYEACC,CUR,OCCAMT,LOCOCCAMT,CUSCHRG,LOCCUSCHRG,ORTRCNO,BJEDTE,BSPSQN,EACTYP,EACINF,LOCEACTYP,LOCEACINF,ISDEAL,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_tddzcz WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT BJEDTE,BSPSQN,BRSFLG,TRCCO,NCCWKDAT,TRCDAT,TRCNO,SNDMBRCO,RCVMBRCO,SNDBNKCO,SNDBNKNM,RCVBNKCO,RCVBNKNM,CUR,LBDCFLG,LSTDTBAL,NTTDCFLG,NTTBAL,BALDCFLG,TODAYBAL,AVLBAL,NTODAYBAL,CHKRST,BOJEDT,BOSPSQ,PRCCO,STRINFO,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_rekbal WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def TrxMain( ):
AfaLoggerFunc.tradeInfo('**********批量处理多笔查询(8490)开始**********')
TradeContext.O1AFAPDATE = TradeContext.TranDate #工作日期
TradeContext.O1AFAPTIME = TradeContext.TranTime #工作日期
#查询单位信息，获得单位编号
try:
sql = ""
sql = "SELECT BUSINO FROM ABDT_UNITINFO WHERE "
sql = sql + "APPNO=" + "'" + TradeContext.I1APPNO + "'" + " AND " #业务编号
sql = sql + "ACCNO=" + "'" + TradeContext.I1ACCNO + "'" #对公账户
AfaLoggerFunc.tradeInfo( sql )
results = AfaDBFunc.SelectSql( sql )
if ( results == None ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return ExitSubTrade( '9000', '查询单位信息异常' )
if ( len(results) <= 0 ):
return ExitSubTrade( '9000', '没有单位信息,不能进行此类操作')
except Exception, e:
AfaLoggerFunc.tradeFatal( str(e) )
return ExitSubTrade( '9999', '查询单位信息失败')
def Insert():
try:
if( TradeContext.existVariable( "PAYEEBANKNO" ) and len(TradeContext.PAYEEBANKNO)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[清算国库支付系统行号]:不能为空')
if( TradeContext.existVariable( "TRECODE" ) and len(TradeContext.TRECODE)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[清算国库代码]:不能为空')
if( TradeContext.existVariable( "TRENAME" ) and len(TradeContext.TRENAME)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[清算国库名称]:不能为空')
if( TradeContext.existVariable( "PAYEEACCT" ) and len(TradeContext.PAYEEACCT)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[清算国库收款账号]:不能为空')
if( TradeContext.existVariable( "PAYEEACCTNAME" ) and len(TradeContext.PAYEEACCTNAME)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[清算国库收款账户名称]:不能为空')
if( TradeContext.existVariable( "PAYBKCODE" ) and len(TradeContext.PAYBKCODE)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[国库关联行行号]:不能为空')
if( TradeContext.existVariable( "PAYBKNAME" ) and len(TradeContext.PAYBKNAME)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[国库关联行名称]:不能为空')
if( TradeContext.existVariable( "LIQUIDATEMODE" ) and len(TradeContext.LIQUIDATEMODE)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[清算模式]:不能为空')
if( TradeContext.existVariable( "BRNO" ) and len(TradeContext.BRNO)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[机构代码]:不能为空')
if( TradeContext.existVariable( "TELLERNO" ) and len(TradeContext.TELLERNO)<=0):
return AfaFlowControl.ExitThisFlow( 'A0027', '[交易柜员]:不能为空')
sql="SELECT PAYEEBANKNO,TRECODE,TRENAME,PAYEEACCT,PAYEEACCTNAME,PAYBKCODE,PAYBKNAME,LIQUIDATEMODE,STATUS,BRNO,TELLERNO,NOTE1,NOTE2,NOTE3,NOTE4,NOTE5 "
sql=sql+" FROM TIPS_LIQUIDATE_ADM WHERE 1=1 "
sql=sql+"AND PAYEEBANKNO='"+ TradeContext.PAYEEBANKNO+"'"
sql=sql+"AND PAYBKCODE='"+ TradeContext.PAYBKCODE+"'"
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql(sql)
if( records == None ):
AfaLoggerFunc.tradeFatal(sql)
return AfaFlowControl.ExitThisFlow( 'A0002', '数据库操作异常:'+AfaDBFunc.sqlErrMsg )
elif( len(records) > 0 ):
return AfaFlowControl.ExitThisFlow( 'A0027', '已存在此清算信息' )
sql="INSERT INTO TIPS_LIQUIDATE_ADM(PAYEEBANKNO,TRECODE,TRENAME,PAYEEACCT,PAYEEACCTNAME,PAYBKCODE,PAYBKNAME,LIQUIDATEMODE,STATUS,BRNO,TELLERNO) "
sql=sql+" VALUES "
sql=sql+"('"+ TradeContext.PAYEEBANKNO +"'"
sql=sql+",'"+ TradeContext.TRECODE +"'"
sql=sql+",'"+ TradeContext.TRENAME +"'"
sql=sql+",'"+ TradeContext.PAYEEACCT +"'"
sql=sql+",'"+ TradeContext.PAYEEACCTNAME+"'"
sql=sql+",'"+ TradeContext.PAYBKCODE +"'"
sql=sql+",'"+ TradeContext.PAYBKNAME +"'"
sql=sql+",'"+ TradeContext.LIQUIDATEMODE+"'"
sql=sql+",'"+ '1' +"'"
sql=sql+",'"+ TradeContext.BRNO +"'"
sql=sql+",'"+ TradeContext.TELLERNO +"'"
sql=sql+" ) "
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.InsertSqlCmt(sql)
if( records == None or records <=0 ):
AfaLoggerFunc.tradeFatal(sql)
return AfaFlowControl.ExitThisFlow( 'A0002', '数据库操作异常:'+AfaDBFunc.sqlErrMsg )
return True
except Exception, e:
AfaLoggerFunc.tradeInfo(e)
return AfaFlowControl.ExitThisFlow('9999', '程序处理异常'+str(e))
def GetFtpConfig( ):
#---------------从数据库中提取信息--------------
sqlstr = "select hostip,downuser,downpasswd,downldir,downrdir from fs_businoconf where busino='" + TradeContext.busiNo + "'"
AfaLoggerFunc.tradeInfo( sqlstr )
records = AfaDBFunc.SelectSql( sqlstr )
if( records == None ):
AfaLoggerFunc.tradeInfo( "查找数据库异常：单位编码ftp配置信息表，联系科技人员" )
return False
if( len( records)==0 ):
AfaLoggerFunc.tradeInfo( "没有查找到单位配置信息，联系科技人员" )
return False
else:
TradeContext.CROP_HOSTIP = records[0][0].strip()
TradeContext.CROP_USERNO = records[0][1].strip()
TradeContext.CROP_PASSWD = records[0][2].strip()
TradeContext.CROP_LDIR = records[0][3].strip()
TradeContext.CROP_RDIR = records[0][4].strip()
AfaLoggerFunc.tradeInfo( "当前单位编码：%s" %TradeContext.busiNo )
AfaLoggerFunc.tradeInfo( "当前主机地址：%s" %TradeContext.CROP_HOSTIP )
AfaLoggerFunc.tradeInfo( "账户：%s" %TradeContext.CROP_USERNO )
AfaLoggerFunc.tradeInfo( "密码：%s" %TradeContext.CROP_PASSWD )
AfaLoggerFunc.tradeInfo( "本地路径：%s" %TradeContext.CROP_LDIR )
return True
def UpdateUserPass():
sql = "SELECT PASSWORD FROM ABDT_USERINFO WHERE STATUS='1' AND USERNO = '" + TradeContext.USERNO + "'"
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None or len(records)==0) :
return ExitSubTrade( '9000', '不存在用户信息' )
if (records[0][0] != TradeContext.OLDPASSWD):
return ExitSubTrade( '9000', '旧密码不符' )
sql = "UPDATE ABDT_USERINFO SET PASSWORD='******'"
sql = sql + " WHERE "
sql = sql + "USERNO=" + "'" + TradeContext.USERNO + "'" #用户号
AfaLoggerFunc.tradeInfo(sql)
ret = AfaDBFunc.UpdateSqlCmt( sql )
if (ret < 0):
return ExitSubTrade('9000', '修改用户密码失败')
return True
def GetConfig( CfgFileName = None ):
#---------------从数据库中提取信息--------------
#begin 20100528 蔡永贵修改
#sqlstr = "select hostip,upuser,uppasswd,upldir,uprdir from fs_businoconf where busino='" + TradeContext.busiNo + "'"
sqlstr = "select hostip,upuser,uppasswd,upldir,uprdir from fs_businoconf where busino='" + TradeContext.busiNo + "'"
sqlstr = sqlstr + " and bankno='" + TradeContext.bankCode + "'"
#end
AfaLoggerFunc.tradeInfo( sqlstr )
records = AfaDBFunc.SelectSql( sqlstr )
if( records == None ):
AfaLoggerFunc.tradeInfo( "查找数据库异常：单位编码ftp配置信息表，联系科技人员" )
return False
if( len( records)==0 ):
AfaLoggerFunc.tradeInfo( "没有查找到单位配置信息，联系科技人员" )
return False
else:
TradeContext.CROP_HOSTIP = records[0][0].strip()
TradeContext.CROP_USERNO = records[0][1].strip()
TradeContext.CROP_PASSWD = records[0][2].strip()
TradeContext.CROP_LDIR = records[0][3].strip()
TradeContext.CROP_RDIR = records[0][4].strip()
AfaLoggerFunc.tradeInfo( "当前单位编码：%s" %TradeContext.busiNo )
AfaLoggerFunc.tradeInfo( "当前主机地址：%s" %TradeContext.CROP_HOSTIP )
AfaLoggerFunc.tradeInfo( "账户：%s" %TradeContext.CROP_USERNO )
AfaLoggerFunc.tradeInfo( "密码：%s" %TradeContext.CROP_PASSWD )
AfaLoggerFunc.tradeInfo( "本地路径：%s" %TradeContext.CROP_LDIR )
return True
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT BJEDTE,BSPSQN,BCURSQ,BCSTAT,BDWFLG,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_spbsta WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeDebug(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT SNDBNKCO,TRCDAT,TRCNO,NCCWKDAT,TRCCO,MSGTYPCO,RCVMBRCO,SNDMBRCO,SNDBRHCO,SNDCLKNO,SNDTRDAT,SNDTRTIM,MSGFLGNO,ORMFN,OPRTYPNO,ROPRTPNO,SNDBNKNM,RCVBNKCO,RCVBNKNM,CUR,OCCAMT,CUSCHRG,PYRMBRCO,PYRACC,PYEMBRCO,PYEACC,ORTRCCO,ORTRCNO,DCFLG,CBFLG,CONFFLG,CANCFLG,STRINFO,BJEDTE,BSPSQN,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_tddzmx WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT TRCDAT,BSPSQN,MSGFLGNO,ORMFN,TRCCO,BRSFLG,BESBNO,BEACSB,BETELR,BEAUUS,BEAUPS,TERMID,OPTYPE,NCCWKDAT,TRCNO,SNDMBRCO,RCVMBRCO,SNDBNKCO,SNDBNKNM,RCVBNKCO,RCVBNKNM,ORTRCDAT,ORTRCCO,ORTRCNO,ORSNDSUBBNK,ORSNDBNK,ORRCVSUBBNK,ORRCVBNK,ORPYRACC,ORPYRNAM,ORPYEACC,ORPYENAM,CUR,OCCAMT,CHRG,ERRCONBAL,BALANCE,UNCONRST,CONSTS,PRCCO,STRINFO,NOTE1,NOTE2,NOTE3,NOTE4,NOTE5 FROM rcc_acckj WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT BESBNO,BPSBNO,CHGTYP,TRCCO,CHGNAM,CHGDATA,EFCTDAT,INVDATE,UPDTIME FROM rcc_chgtbl WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT BANKBIN,BANKSTATUS,BANKATTR,STLBANKBIN,BANKNAM,BANKADDR,BANKPC,BANKTEL,EFCTDAT,INVDAT,ALTTYPE,PRIVILEGE,NEWOFLG,STRINFO,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_paybnk WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
def ChkCustInfo( ):
#AfaLoggerFunc.tradeInfo('>>>判断个人协议是否存在')
try:
sql = ""
sql = "SELECT PROTOCOLNO,BUSIUSERNO,ACCNO FROM ABDT_CUSTINFO WHERE "
sql = sql + "APPNO='AG1014' AND " #业务编号
sql = sql + "BUSINO=" + "'" + TradeContext.I1BUSINO + "'" + " AND (" #单位编号
sql = sql + "BUSIUSERNO=" + "'" + TradeContext.SBNO + "'" + " OR " #商户客户编号
sql = sql + "ACCNO=" + "'" + TradeContext.ACCNO + "'" + " )AND " #银行账号
sql = sql + "STATUS=" + "'" + "1" + "'" #状态
#AfaLoggerFunc.tradeInfo( sql )
records = AfaDBFunc.SelectSql( sql )
if ( records == None ):
#AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return ExitSubTrade( '9000', '查询个人协议信息异常' )
if ( len(records) > 0 ):
#201208 中间业务优化 llj 判断是社保编号重复，还是账号重复
if records[0][1]== TradeContext.SBNO:
return ExitSubTrade( '9000', '该个人协议的社保编号已经被注册,不能再次进行注册')
if records[0][2]== TradeContext.ACCNO:
return ExitSubTrade( '9000', '该个人协议的账号已经被注册,不能再次进行注册')
else:
return ExitSubTrade( '9000', '该个人协议已经被注册,不能再次进行注册')
return True
except Exception, e:
AfaLoggerFunc.tradeFatal( str(e) )
return ExitSubTrade( '9999', '判断个人协议信息是否存在异常')
def SubModuleMainFst( ):
TradeContext.__agentEigen__ = '0' #从表标志
AfaLoggerFunc.tradeInfo( "中台查找流水金额数据库开始" )
#在中台数据库中查询
sqlstr = "select afc011 from fs_fc74 where afc401='" + TradeContext.serNo + "' and busino='" + TradeContext.busiNo + "' and afc016='" + TradeContext.brno + "' and afc015='" + TradeContext.AFC015 + "'"
#===条件增加银行编码字段,张恒修改===
sqlstr = sqlstr + " and afa101 = '" + TradeContext.bankbm + "'"
records = AfaDBFunc.SelectSql( sqlstr )
if( records == None ):
AfaLoggerFunc.tradeInfo( sqlstr )
TradeContext.errorCode = "9999"
TradeContext.errorMsg = "查找流水金额失败"
return False
elif ( len(records)==0 ):
AfaLoggerFunc.tradeInfo( sqlstr )
TradeContext.errorCode = "0001"
TradeContext.errorMsg = "没有查找到流水金额"
return False
else:
TradeContext.totalAmt = records[0][0]
TradeContext.errorCode = "0000"
TradeContext.errorMsg = "查找流水金额成功"
AfaLoggerFunc.tradeInfo( "********************中台查找流水金额数据库开始***************" )
return True
def TrxMain():
AfaLoggerFunc.tradeInfo('**********用户登陆(8800)开始**********')
sqlStr = "SELECT ZONENO,BRNO,USERNAME,TEL,ADDRESS,PASSWORD FROM ABDT_USERINFO WHERE STATUS='1'"
sqlStr = sqlStr + " AND USERNO = '" + TradeContext.USERNO + "'"
AfaLoggerFunc.tradeInfo(sqlStr)
records = AfaDBFunc.SelectSql( sqlStr )
if (records == None):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return ExitSubTrade( '9999', '查询用户信息异常' )
if (len(records)==0) :
return ExitSubTrade( '9000', '该用户号不存在' )
else:
if ( records[0][5] == TradeContext.PASSWD ):
TradeContext.tradeResponse.append(['ZONENO', records[0][0]])
TradeContext.tradeResponse.append(['BRNO', records[0][1]])
TradeContext.tradeResponse.append(['USERNAME', records[0][2]])
else:
return ExitSubTrade( '9999', '密码错误,请重试!')
AfaLoggerFunc.tradeInfo('**********用户登陆(8800)结束**********')
#返回
TradeContext.tradeResponse.append(['errorCode', '0000'])
TradeContext.tradeResponse.append(['errorMsg', '交易成功'])
return True
def ChkLiquidStatus():
AfaLoggerFunc.tradeInfo( '>>>获取清算信息' )
sql ="SELECT PAYBKCODE,PAYEEBANKNO,TRECODE,TRENAME,PAYEEACCT,PAYBKNAME,STATUS FROM TIPS_LIQUIDATE_ADM WHERE "
sql =sql + "BRNO = '" + TradeContext.brno + "'"
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql(sql)
if( records == None ):
AfaLoggerFunc.tradeFatal(sql)
return TipsFunc.ExitThisFlow( 'A0002', '数据库操作异常:'+AfaDBFunc.sqlErrMsg )
elif( len( records )==0 ):
return TipsFunc.ExitThisFlow( 'A0027', '本机构不是清算行，不可以进行对账差错查询' )
else:
if records[0][6]=='0':
return TipsFunc.ExitThisFlow( 'A0027', '业务已停止，不可进行查询' )
if records[0][6]=='2':
return TipsFunc.ExitThisFlow( 'A0027', '业务已暂停，不可进行查询' )
AfaLoggerFunc.tradeInfo('本机构的清算行号为'+ records[0][0])
AfaLoggerFunc.tradeInfo('柜面送的清算行号为'+ TradeContext.payBkCode)
if(records[0][0]!=TradeContext.payBkCode):
return TipsFunc.ExitThisFlow( 'A0002', '清算行行号不正确，不允许做此交易')
AfaLoggerFunc.tradeInfo( '>>>获取清算信息完成' )
return True
def selectu( where_dict ):
if not chk(where_dict):
return None
wheresql = ""
for where_item in where_dict.keys():
if table_dict[where_item] == 'S':
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT SNDBNKCO,TRCDAT,TRCNO,NCCWKDAT,MSGTYPCO,RCVMBRCO,SNDMBRCO,TRCCO,SNDBRHCO,SNDCLKNO,SNDTRDAT,SNDTRTIM,MSGFLGNO,ORMFN,OPRTYPNO,ROPRTPNO,SNDBNKNM,RCVBNKCO,RCVBNKNM,CUR,OCCAMT,PYRACC,PYRNAM,PYRADDR,PYEACC,PYENAM,PYEADDR,OPRATTNO,SEAL,BILDAT,BILNO,BILVER,PAYWAY,BILAMT,RMNAMT,USE,REMARK,BJEDTE,BSPSQN,BCSTAT,BDWFLG,EACTYP,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_hpdzmx WHERE " + wheresql[0:-5]
AfaLoggerFunc.tradeInfo(sql)
records = AfaDBFunc.SelectSql( sql )
if (records == None):
return None
elif (len(records) > 1):
AfaLoggerFunc.tradeError("查询结果非唯一,请检查查询条件[" + wheresql[0:-5] + "]")
return None
elif (len(records) == 0):
AfaLoggerFunc.tradeError("查询结果为空,查询条件[" + wheresql[0:-5] + "]")
tmp_dict = {}
return tmp_dict
else:
tmp_dict = {}
for i in xrange(0,len(table_tuple)):
if len(str(records[0][i])) == 0:
tmp_dict[table_tuple[i]] = ""
else:
tmp_dict[table_tuple[i]] = records[0][i]
#AfaLoggerFunc.tradeInfo("return return_dict:" + str(tmp_dict))
return tmp_dict
