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 BJEDTE,BSPSQN,BCURSQ,BESBNO,BEACSB,BETELR,BEAUUS,FEDT,RBSQ,TRDT,TLSQ,SBAC,ACNM,RBAC,OTNM,DASQ,MGID,PRCCO,STRINFO,BCSTAT,BDWFLG,PRTCNT,BJETIM,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_sstlog 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 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 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
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 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,TRCCO,SNDBNKCO,SNDBNKNM,RCVBNKCO,RCVBNKNM,SNDMBRCO,RCVMBRCO,TRCDAT,TRCNO,NPCBKID,NPCBKNM,NPCACNT,OCCAMT,REMARK,PRCCO,STRINFO,NOTE1,NOTE2,NOTE4,NOTE3 FROM rcc_mrqtbl 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 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 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 NCCWKDAT,TRCCO,BRSFLG,TRCNAM,TRCRSNM,TCNT,CTAMT,DTAMT,OFSTAMT,CLAMT,DLAMT,OFSLAMT,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_hpdzhz 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 STRDAT,ENDDAT,BESBNO,BESBNM,TRCCHRGCNT,TRCCHRGAMT,BILCHRGCNT,BILCHRGAMT,UCSWCHRGCNT,UCSWCHRGAMT,TCNT,TAMT,ISDEAL,FEDT,RBSQ,TRDT,TLSQ,MGID FROM rcc_qsqhqd 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 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 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 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 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,BETELR,BEAUUS,NCCWKDAT,TRCCO,TRCDAT,TRCNO,SNDMBRCO,RCVMBRCO,SNDBNKCO,SNDBNKNM,RCVBNKCO,RCVBNKNM,BOJEDT,BOSPSQ,ORTRCCO,BILDAT,BILNO,BILPNAM,BILENDDT,BILAMT,PYENAM,HONBNKNM,CONT,ISDEAL,PRCCO,STRINFO,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_pjcbka 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 insInfoBil(bil_dict):
AfaLoggerFunc.tradeInfo( ">>>开始登记汇票信息登记簿[" + bil_dict["BILVER"] + "][" + bil_dict["BILNO"] + "][" + bil_dict["BILRS"] + "]交易信息及相关状态" )
if not bil_dict.has_key("BILVER"):
return AfaFlowControl.ExitThisFlow("S999","登记汇票信息登记簿,BILVER不能为空")
if not bil_dict.has_key("BILNO"):
return AfaFlowControl.ExitThisFlow("S999","登记汇票信息登记簿,BILNO不能为空")
if not bil_dict.has_key("BILRS"):
return AfaFlowControl.ExitThisFlow("S999","登记汇票信息登记簿,BILRS不能为空")
#===========将输入字典赋值到汇票信息登记簿字典==============================
bilinf_dict = {}
if not rccpsMap0000Dbil_dict2Dbilinf.map(bil_dict,bilinf_dict):
return AfaFlowControl.ExitThisFlow( 'S999', '将输入字典赋值到汇票信息登记簿字典异常' )
bilinf_where_dict = {}
bilinf_where_dict['BILRS'] = bil_dict['BILRS']
bilinf_where_dict['BILVER'] = bil_dict['BILVER']
bilinf_where_dict['BILNO'] = bil_dict['BILNO']
tmp_bilinf_dict = rccpsDBTrcc_bilinf.selectu(bilinf_where_dict)
if tmp_bilinf_dict == None:
return AfaFlowControl.ExitThisFlow( 'S999', '校验汇票信息登记簿是否存在相同汇票异常' )
if len(tmp_bilinf_dict) <= 0:
AfaLoggerFunc.tradeError("汇票信息登记簿不存在此汇票,插入汇票信息")
#===========登记信息到汇票信息登记簿========================================
ret = rccpsDBTrcc_bilinf.insert(bilinf_dict)
if ret <= 0:
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow( 'S999', '登记汇票详细信息异常' )
return True
else:
AfaLoggerFunc.tradeError("汇票信息登记簿存在此汇票,更新汇票信息")
#===========登记信息到汇票信息登记簿========================================
ret = rccpsDBTrcc_bilinf.update(bilinf_dict,bilinf_where_dict)
if ret <= 0:
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow( 'S999', '登记汇票详细信息异常' )
return True
def StartWorkSql( ):
global sqlErrMsg
sqlErrMsg=''
curs=None
try:
conn=Db2Connection.getConnection( )
curs=conn.cursor( )
curs.execute( "START TRANSACTION" )
curs.close( )
return True
except Exception , e:
if( curs != None ):
curs.close( )
sqlErrMsg=str( e )
AfaLoggerFunc.tradeError( sqlErrMsg )
return False
def RollbackSql( ):
global sqlErrMsg
sqlErrMsg=''
curs=None
try:
conn=Db2Connection.getConnection( )
curs=conn.cursor( )
curs.execute( "ROLLBACK" )
curs.close( )
return True
except Exception , e:
if( curs != None ):
curs.close( )
sqlErrMsg=str( e )
AfaLoggerFunc.tradeError( sqlErrMsg )
return False
def ChkUnitInfo( ):
AfaLoggerFunc.tradeInfo( '＝＝＝＝＝判断应用状态开始＝＝＝＝＝' )
sqlStr = ''
sqlStr = sqlStr + "SELECT STATUS,STARTDATE,ENDDATE,STARTTIME,ENDTIME,ACCNO FROM ABDT_UNITINFO "
sqlStr = sqlStr + " AND WHERE APPNO = '" + TradeContext.sysId + "'"
#============单位编码============
sqlStr = sqlStr + " AND BUSINO = '" + TradeContext.busino + "'"
#============委托方式============
sqlStr = sqlStr + " AND AGENTTYPE IN ('1','2')"
AfaLoggerFunc.tradeFatal( '查询结果 ：'+sqlStr )
records = AfaDBFunc.SelectSql( sqlStr )
if( records == None ):
return AfaFlowControl.ExitThisFlow( 'A0002', '查询单位协议信息异常')
elif( len( records )!=0 ):
AfaUtilTools.ListFilterNone( records )
TradeContext.STATUS = str(records[0][0]) #签约状态
TradeContext.STARTDATE = str(records[0][1]) #生效日期
TradeContext.ENDDATE = str(records[0][2]) #失效日期
TradeContext.STARTTIME = str(records[0][3]) #服务开始时间
TradeContext.ENDTIME = str(records[0][4]) #服务终止时间
TradeContext.ACCNO = str(records[0][5]) #对公账户
if ( (TradeContext.STARTDATE > TradeContext.workDate) or (TradeContext.workDate > TradeContext.ENDDATE) ):
return AfaFlowControl.ExitThisFlow( '9000', '该单位委托协议还没有生效或已过有效期')
if ( (TradeContext.STARTTIME > TradeContext.workTime) or (TradeContext.workTime > TradeContext.ENDTIME) ):
return AfaFlowControl.ExitThisFlow( '9000', '已经超过该系统的服务时间,该业务必须在[' + s_StartDate + ']-[' + s_EndDate + ']时间段运行')
#=============代理业务帐号=============
#TradeContext.__agentAccno__ = records[0][5]
#AfaLoggerFunc.tradeInfo('收款人帐户__agentAccno__ BB：：'+ TradeContext.__agentAccno__)
AfaLoggerFunc.tradeInfo( '＝＝＝＝＝判断应用状态结束＝＝＝＝＝＝＝' )
return True
else:
AfaLoggerFunc.tradeError( sqlStr )
return AfaFlowControl.ExitThisFlow( 'A0003', '该地区没有开放此业务' )
def ChkAppStatus( ):
AfaLoggerFunc.tradeInfo( '判断应用状态[begin]' )
#============业务编号============
sqlStr = "SELECT STATUS,STARTDATE,ENDDATE,STARTTIME,ENDTIME,ACCNO FROM ABDT_UNITINFO WHERE APPNO = '" + TradeContext.appNo + "'"
#============单位编码============
sqlStr = sqlStr + " AND BUSINO = '" + TradeContext.busiNo + "'"
#============委托方式============
sqlStr = sqlStr + " AND AGENTTYPE IN ('1','2')"
records = AfaDBFunc.SelectSql( sqlStr )
if( records == None ):
# AfaLoggerFunc.tradeFatal( sqlStr )
return AfaFlowControl.ExitThisFlow( 'A0002', '代收代付_单位信息表:'+AfaDBFunc.sqlErrMsg )
elif( len( records )!=0 ):
AfaUtilTools.ListFilterNone( records )
#===============判断业务状态============================
if( records[0][0]=="0" ):
return AfaFlowControl.ExitThisFlow( 'A0004', '该业务处于未启用状态,不能做此交易' )
elif( records[0][0]=="2" ):
return AfaFlowControl.ExitThisFlow( 'A0005', '该业务处于关闭状态,不能做此交易' )
elif( records[0][0]=="3" ):
return AfaFlowControl.ExitThisFlow( 'A0006', '该业务处于停用状态,不能做此交易' )
#===============判断服务时间============================
if( long( TradeContext.workDate )<long( records[0][1] ) or long( TradeContext.workDate )>long( records[0][2] ) ):
return AfaFlowControl.ExitThisFlow ('A0008', "该业务已过期,有效期:["+records[0][1] + "-->" + records[0][2] + "]")
#================判断有效时间===========================
if( long(TradeContext.workTime) < long(records[0][3])) or (long(TradeContext.workTime) > long(records[0][4])):
return AfaFlowControl.ExitThisFlow( 'A0007', "超过业务开放时间,请在["+records[0][3]+"-->"+records[0][4]+"]做此业务" )
#=============代理业务帐号=============
TradeContext.__agentAccno__ = records[0][5]
TradeContext.Daccno = records[0][5]
AfaLoggerFunc.tradeInfo( '判断应用状态[end]' )
return True
else:
AfaLoggerFunc.tradeError( sqlStr )
return AfaFlowControl.ExitThisFlow( 'A0003', '该地区没有开放此业务' )
def executeUpdate( sql ):
global sqlErrMsg
sqlErrMsg=''
curs=None
try:
conn=Db2Connection.getConnection( )
curs=conn.cursor( )
curs.execute( sql )
rowcount=curs.rowcount
curs.close( )
return rowcount
except Exception , e:
if( curs != None ):
curs.close( )
sqlErrMsg=str( e )
AfaLoggerFunc.tradeError(sql)
AfaLoggerFunc.tradeError( sqlErrMsg )
return -1
def executeQueryMany( sql , arraysize=0 ):
global sqlErrMsg
sqlErrMsg=''
curs=None
try:
conn=Db2Connection.getConnection( )
curs=conn.cursor( )
curs.arraysize=arraysize
curs.execute( sql )
records=curs.fetchmany( )
curs.close( )
return records
except Exception, e:
if( curs != None ):
curs.close( )
sqlErrMsg=str( e )
AfaLoggerFunc.tradeError(sql)
AfaLoggerFunc.tradeError( sqlErrMsg )
return None
def ChkAbnormal( ):
AfaLoggerFunc.tradeInfo( '查询流水表中的主机异常交易' )
sql="SELECT COUNT(*) FROM FS_MAINTRANSDTL WHERE WORKDATE='"+ \
TradeContext.workDate+"' AND AGENTCODE='"+TradeContext.agentCode+ \
"' AND AGENTZONENO='"+TradeContext.zoneno+"' AND BRNO='"+TradeContext.brno+\
"' AND TELLERNO='"+TradeContext.teller+"' AND REVTRANF='0'AND \
(BANKSTATUS='2' OR (BANKSTATUS='0' AND CORPSTATUS IN ('1', '2','3')))"
result=AfaDBFunc.SelectSql( sql )
if( result == None ):
# AfaLoggerFunc.tradeFatal( sql )
return -1
if( result[0][0]!=0 ):
return 1
else:
AfaLoggerFunc.tradeError( sql )
return 0
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':
#20110819 曾照泰修改 汇票对账时当解付本行汇票时BILNO查询条件为模糊查询，不然查询不到原纪录
if where_item=='BILNO':
wheresql = wheresql + where_item + " LIKE '%" + where_dict[where_item] + "%' and "
else:
wheresql = wheresql + where_item + " LIKE '" + where_dict[where_item] + "' and "
#end
else:
wheresql = wheresql + where_item + " = " + str(where_dict[where_item]) + " and "
sql = "SELECT BILVER,BILNO,BILRS,BILTYP,BILDAT,PAYWAY,REMBNKCO,REMBNKNM,PAYBNKCO,PAYBNKNM,PYRACC,PYRNAM,PYRADDR,PYEACC,PYENAM,PYEADDR,PYHACC,PYHNAM,PYHADDR,PYITYP,PYIACC,PYINAM,BILAMT,OCCAMT,RMNAMT,CUR,SEAL,USE,REMARK,HPCUSQ,HPSTAT,NOTE1,NOTE2,NOTE3,NOTE4 FROM rcc_bilinf 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 chk(where_dict):
for item in where_dict.keys():
if item not in table_tuple:
AfaLoggerFunc.tradeError( '表[rcc_ztcbka]中无列[' + item + ']' )
return False
return True
def chk(where_dict):
for item in where_dict.keys():
if item not in table_tuple:
AfaLoggerFunc.tradeError( '表[rcc_atrchk]中无列[' + item + ']' )
return False
return True
while file_line:
file_line = AfaUtilTools.trim(pfile.readline())
file_line = rccpsUtilTools.replaceRet(file_line)
if file_line == "":
continue
line_list = file_line.split('|')
paybnk_where_dict = {}
paybnk_where_dict['BANKBIN'] = line_list[0]
tmp_paybnk_dict = rccpsDBTrcc_paybnk.selectu(paybnk_where_dict)
if tmp_paybnk_dict == None:
if not AfaDBFunc.RollbackSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
AfaLoggerFunc.tradeError(">>>Rollback异常")
AfaLoggerFunc.tradeInfo(">>>Rollback成功")
rccpsCronFunc.cronExit("S999","查询将登记行号是否存在异常")
paybnk_dict = {}
paybnk_dict['BANKBIN'] = line_list[0][:10]
paybnk_dict['BANKSTATUS'] = line_list[1][:1]
paybnk_dict['BANKATTR'] = line_list[2][:2]
paybnk_dict['STLBANKBIN'] = line_list[3][:10]
paybnk_dict['BANKNAM'] = line_list[4][:60]
paybnk_dict['BANKADDR'] = line_list[5][:60]
paybnk_dict['BANKPC'] = line_list[6][:6]
paybnk_dict['BANKTEL'] = line_list[7][:30]
paybnk_dict['EFCTDAT'] = line_list[8][:8]
paybnk_dict['INVDAT'] = line_list[9][:8]
paybnk_dict['ALTTYPE'] = line_list[10][:1]
def SubModuleMainFst( ):
AfaLoggerFunc.tradeInfo('财税库行_行内资金清算开始[T003001_0331112]' )
TradeContext.TransCode='0331112'
try:
#=============获取当前系统时间====================
TradeContext.workDate=UtilTools.GetSysDate( )
TradeContext.workTime=UtilTools.GetSysTime( )
#============系统标识============
sqlStr = "SELECT * FROM AFA_UNITADM WHERE APPNO = '" + TradeContext.appNo + "' AND "
#============商户代码============
sqlStr = sqlStr+"UNITNO = '" + TradeContext.unitno + "' "
AfaLoggerFunc.tradeInfo( sqlStr )
records = AfaDBFunc.SelectSql( sqlStr )
if( records == None ):
return AfaFlowControll.ExitThisFlow( 'A0002', '商户信息表操作异常:'+AfaDBFunc.sqlErrMsg )
elif( len( records )==0 ):
AfaLoggerFunc.tradeError( sqlStr )
return AfaFlowControll.ExitThisFlow( 'A0003', '无此商户信息' )
else:
records=UtilTools.ListFilterNone( records )
##=============商户名称=============
#TradeContext.unitName = records[0][2]
##=============商户简称=============
#TradeContext.unitSName = records[0][3]
#
##===============判断商户状态============================
#if( records[0][4]=="0" ):
# return AfaFlowControll.ExitThisFlow( 'A0004', '该商户处于关闭状态,不能做交易' )
#elif( records[0][4]=="2" ):
# return AfaFlowControll.ExitThisFlow( 'A0005', '该商户处于暂停状态,不能做交易' )
#elif( records[0][4]=="3" ):
# return AfaFlowControll.ExitThisFlow( 'A0005', '该商户处于未启用状态,不能做交易' )
##=============银行角色=============
#TradeContext.__bankMode__ = records[0][5]
#=============业务模式=============
TradeContext.__busiMode__ = records[0][6]
#=============账户模式=============
TradeContext.__accMode__ = records[0][7]
AfaLoggerFunc.tradeInfo( '业务模式:'+TradeContext.__busiMode__+' 账户模式:'+ TradeContext.__accMode__)
##===============业务模式============================
#if( TradeContext.__busiMode__!="2" ):
#======================账户模式============================
if( TradeContext.__accMode__ !="2" ): #无分支商户单位，不需行内清算
return True
##===============银行商户代码（商户号）============================
#TradeContext.bankUnitno = records[0][8]
##===============主办分行号============================
#if(len(records[0][9])>0):
# TradeContext.mainZoneno = records[0][9]
##===============主办网点号============================
#if(len(records[0][10])>0):
# TradeContext.mainBrno = records[0][10]
##===============银行编码============================
#TradeContext.bankno = records[0][16]
##=============单位账号=============
#TradeContext.__agentAccno__ = records[0][17]
##=============摘要代码（帐务核心系统需要）=============
#TradeContext.__zhaiYaoCode__ = records[0][32]
##=============摘要（帐务核心系统需要）=============
#TradeContext.__zhaiYao__ = records[0][33]
if( TradeContext.__accMode__ == '2' ):
#=============贷方账号（清算行帐号）=============
TradeContext.agentAccno = records[0][17]
#=========商户分支单位=============
#============系统标识============
sqlStr = "SELECT * FROM AFA_SUBUNITADM WHERE APPNO = '" + TradeContext.appNo + "' AND "
#============商户代码============
sqlStr = sqlStr+"UNITNO = '" + TradeContext.unitno + "' "
AfaLoggerFunc.tradeInfo( sqlStr )
subRecords = AfaDBFunc.SelectSql( sqlStr )
if(subRecords == None ):
# AfaLoggerFunc.tradeFatal( sqlStr )
return AfaFlowControll.ExitThisFlow( 'A0002', '商户分支单位信息表操作异常:'+AfaDBFunc.sqlErrMsg )
elif( len( subRecords )==0 ):
return AfaFlowControll.ExitThisFlow( 'A0002', '商户分支单位中无记录，参数设置有误' )
else:
subRecords=UtilTools.ListFilterNone( subRecords )
for i in range( 0, len( subRecords ) ):
subUnitno = subRecords[i][2]
AfaLoggerFunc.tradeInfo( 'subunitno:'+subUnitno )
#=============摘要代码=============
TradeContext.__zhaiYaoCode__ = subRecords[i][32]
#=============摘要=============
TradeContext.__zhaiYao__ = subRecords[i][33]
#=============清算：出现清算金额大于银行发生额，需要联社1391科目垫款====================
#统计县联社对账差异金额作为转账金额
if not DoSumAmountDiff(subUnitno):
return AfaFlowControll.ExitThisFlow( 'A0027', '汇总发生额失败' )
#TradeContext.amount='1'
TradeContext.amount =str(long(float(TradeContext.amountDiff)))
if long(TradeContext.amount)>0 :
#检查是否已经清算
sqlStr_qs = "SELECT COUNT(*) FROM AFA_MAINTRANSDTL WHERE APPNO = '" + TradeContext.appNo + "'"
sqlStr_qs = sqlStr_qs + "AND UNITNO = '" + TradeContext.unitno + "' "
sqlStr_qs = sqlStr_qs + "AND SUBUNITNO = '" + subUnitno + "' "
sqlStr_qs = sqlStr_qs + "AND USERNO = '-' "
sqlStr_qs = sqlStr_qs + "AND NOTE2 = '" + TradeContext.ChkDate + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE3 = '" + TradeContext.ChkAcctOrd + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE4 = '" + TradeContext.PayBkCode.strip() + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE5 = '" + TradeContext.PayeeBankNo.strip() + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE6 = '0'"
AfaLoggerFunc.tradeInfo( sqlStr_qs )
Records_qs = AfaDBFunc.SelectSql( sqlStr_qs )
if(Records_qs == None ):
# AfaLoggerFunc.tradeFatal( sqlStr )
return AfaFlowControll.ExitThisFlow( 'A0002', '流水表操作异常:'+AfaDBFunc.sqlErrMsg )
elif (len(Records_qs)=0):
TradeContext.__chkAccPwdCtl__='0'
TradeContext.channelCode='009'
TradeContext.accType ='001'
TradeContext.tellerno ='999986' #
TradeContext.cashTelno ='999986' #
TradeContext.termId ='tips'
TradeContext.brno =subUnitno #unitno作为记账网点号
TradeContext.zoneno =TradeContext.brno[0:3]
TradeContext.accno =subRecords[i][18] #联社1391账户作为借方账户
TradeContext.__agentAccno__=subRecords[i][17] #联社2013账户作为贷方账户
AfaLoggerFunc.tradeInfo( '借方:'+TradeContext.accno+'贷方:' +TradeContext.__agentAccno__)
TradeContext.userno ='-'
TradeContext.tradeType ='T' #转账类交易
TradeContext.userName =subRecords[i][3]+'.清算流水'
AfaFlowControl.GetBranchInfo(TradeContext.brno)
TradeContext.note1 =TradeContext.__mngZoneno__ #上级管理机构
TradeContext.note2 =TradeContext.ChkDate
TradeContext.note3 =TradeContext.ChkAcctOrd
TradeContext.note4 =TradeContext.PayBkCode.strip()
TradeContext.note5 =TradeContext.PayeeBankNo.strip()
TradeContext.note6 ='0' #垫款流水
TradeContext.revTranF ='0'
#TradeContext.tradeType ='T' #转账类交易
TradeContext.workTime =UtilTools.GetSysTime( )
#=============获取平台流水号====================
if AfaFlowControl.GetSerialno( ) == -1 :
AfaLoggerFunc.tradeInfo('>>>处理结果:获取平台流水号异常' )
return AfaFlowControll.ExitThisFlow( 'A0027', '获取流水号失败' )
#
TradeContext.subUnitno =subUnitno #流水中分支商户代码
#=============插入流水表====================
if not TransDtlFunc.InsertDtl( ) :
return AfaFlowControll.ExitThisFlow( 'A0027', '插入流水表失败' )
#=============与主机通讯====================
AfaHostFunc.AfaCommHost('705050')
#if TradeContext.errorCode!='0000':
# return False
#=============更新主机返回状态====================
TransDtlFunc.UpdateDtl( 'TRADE' )
#=============清算：从联社2013进清算行2621====================
##统计县联社总发生额作为转账金额
#if not DoSumAmount(subUnitno):
# return AfaFlowControll.ExitThisFlow( 'A0027', '汇总发生额失败' )
#TradeContext.amount='1'
TradeContext.amount =str(long(float(TradeContext.amountQS)))
if long(TradeContext.amount)>0 :
#检查是否已经清算
sqlStr_qs = "SELECT COUNT(*) FROM AFA_MAINTRANSDTL WHERE APPNO = '" + TradeContext.appNo + "'"
sqlStr_qs = sqlStr_qs + "AND UNITNO = '" + TradeContext.unitno + "' "
sqlStr_qs = sqlStr_qs + "AND SUBUNITNO = '" + subUnitno + "' "
sqlStr_qs = sqlStr_qs + "AND USERNO = '-' "
sqlStr_qs = sqlStr_qs + "AND NOTE2 = '" + TradeContext.ChkDate + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE3 = '" + TradeContext.ChkAcctOrd + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE4 = '" + TradeContext.PayBkCode.strip() + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE5 = '" + TradeContext.PayeeBankNo.strip() + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE6 = '1'"
AfaLoggerFunc.tradeInfo( sqlStr_qs )
Records_qs = AfaDBFunc.SelectSql( sqlStr_qs )
if(Records_qs == None ):
# AfaLoggerFunc.tradeFatal( sqlStr )
return AfaFlowControll.ExitThisFlow( 'A0002', '流水表操作异常:'+AfaDBFunc.sqlErrMsg )
elif (len(Records_qs)=0):
TradeContext.__chkAccPwdCtl__='0'
TradeContext.channelCode='009'
TradeContext.accType ='001'
TradeContext.tellerno ='999986' #
TradeContext.cashTelno ='999986' #
TradeContext.termId ='tips'
TradeContext.brno =TradeContext.unitno #unitno作为记账网点号
TradeContext.zoneno =TradeContext.brno[0:3]
TradeContext.accno =subRecords[i][17] #联社2013结算账户作为借方账户
TradeContext.__agentAccno__=TradeContext.agentAccno #清算行2621作为贷方
AfaLoggerFunc.tradeInfo( '借方:'+TradeContext.accno+'贷方:' +TradeContext.__agentAccno__)
if TradeContext.accno==TradeContext.__agentAccno__: #无需清算
continue
TradeContext.userno ='-'
TradeContext.tradeType ='T' #转账类交易
TradeContext.userName =subRecords[i][3]+'.清算流水'
AfaFlowControl.GetBranchInfo(TradeContext.brno)
TradeContext.note1 =TradeContext.__mngZoneno__ #上级管理机构
TradeContext.note2 =TradeContext.ChkDate
TradeContext.note3 =TradeContext.ChkAcctOrd
TradeContext.note4 =TradeContext.PayBkCode.strip()
TradeContext.note5 =TradeContext.PayeeBankNo.strip()
TradeContext.note6 ='1' #清算流水
TradeContext.revTranF ='0'
TradeContext.workTime =UtilTools.GetSysTime( )
#=============获取平台流水号====================
if AfaFlowControl.GetSerialno( ) == -1 :
AfaLoggerFunc.tradeInfo('>>>处理结果:获取平台流水号异常' )
return AfaFlowControll.ExitThisFlow( 'A0027', '获取流水号失败' )
#
TradeContext.subUnitno =TradeContext.unitno #流水中分支商户代码=商户代码
#=============插入流水表====================
if not TransDtlFunc.InsertDtl( ) :
return AfaFlowControll.ExitThisFlow( 'A0027', '插入流水表失败' )
#=============与主机通讯====================
AfaHostFunc.AfaCommHost('705050')
#if TradeContext.errorCode!='0000':
# return False
#=============更新主机返回状态====================
TransDtlFunc.UpdateDtl( 'TRADE' )
#TradeContext.errorCode='0000'
#TradeContext.errorMsg='交易成功'
AfaLoggerFunc.tradeInfo('财税库行_行内资金清算结束[T003001_0331112]' )
return True
except Exception, e:
AfaFlowControll.exitMainFlow(str(e))
def main( ):
AfaLoggerFunc.tradeInfo( '查询凭证结存交易['+TradeContext.TemplateCode+']进入' )
#=============前台上送数据====================
#TradeContext.sBESBNO 机构号
#TradeContext.sTellerNo 柜员号
#TradeContext.sVouhType 凭证种类
#TradeCoutext.sVouhStatus 凭证状态
#TradeCoutext.sStartDate 起始日期
#TradeCoutext.sEndDate 终止日期
#TradeContext.sStart 起始记录数
#TradeContext.arraySize 查询条数
try:
#=============初始化返回报文变量==================
TradeContext.tradeResponse = []
#=============获取当前系统时间====================
TradeContext.sLstTrxDay = AfaUtilTools.GetSysDate( )
TradeContext.sLstTrxTime = AfaUtilTools.GetSysTime( )
#begin凭证优化更改201109
#=============获取柜员尾箱号===============================
HostContext.I1SBNO = TradeContext.sBesbNo #机构号
HostContext.I1USID = TradeContext.sTellerNo #柜员号
HostContext.I1WSNO = TradeContext.sWSNO #终端号
HostContext.I1EDDT = TradeContext.sLstTrxDay #终止日期
HostContext.I1TELR = TradeContext.sTellerNo #柜员代号
if(not VouhHostFunc.CommHost('0104')):
VouhFunc.tradeExit( TradeContext.errorCode, TradeContext.errorMsg )
raise AfaFlowControl.flowException( )
if(TradeContext.errorCode == '0000'):
TradeContext.sTellerTailNobak = HostContext.O2CABO
TradeContext.sTellerTailNo = TradeContext.sTellerTailNobak[0]
AfaLoggerFunc.tradeInfo( '交易柜员尾箱号：' + TradeContext.sTellerTailNo )
#end
wheresql="substr(t1.BESBNO,1,6) = substr(t.BESBNO,1,6) AND t1.VOUHTYPE = t.VOUHTYPE AND t.VOUHSTATUS = '3'"
#==============设机构号=====================
if (TradeContext.existVariable("sSelBesbNo") and len(TradeContext.sSelBesbNo) <> 0 ):
wheresql = wheresql + " and t.BESBNO = '" + TradeContext.sSelBesbNo + "'"
#==============设凭证种类=====================
if (TradeContext.existVariable("sVouhType") and len(TradeContext.sVouhType) <> 0 ):
wheresql = wheresql + " and t.VOUHTYPE = '" + TradeContext.sVouhType+"'"
#begin凭证优化更改201109
#==============设尾箱号=====================
if (TradeContext.existVariable("sTellerTailNo") and len(TradeContext.sTellerTailNo) <> 0 ):
wheresql = wheresql + " and t.TELLERNO = '" + TradeContext.sTellerTailNo + "'"
#end
sqlStr = "\
SELECT TELLERNO,VOUHTYPE,STARTNO,ENDNO,VOUHNUM,VOUHNAME \
FROM ( \
SELECT row_number() over() as rowid,t.TELLERNO,t.VOUHTYPE,t.STARTNO,t.ENDNO,t.VOUHNUM,t1.VOUHNAME \
FROM VOUH_REGISTER t,VOUH_PARAMETER t1 \
WHERE " + wheresql + " \
) as tab1 \
where tab1.rowid >= " + str(TradeContext.sStart)
AfaLoggerFunc.tradeDebug(sqlStr);
#查询数据库并将返回的结果压至对应变量中
records = AfaDBFunc.SelectSql( sqlStr, int(TradeContext.arraySize))
if( records == None ):
AfaLoggerFunc.tradeError(AfaDBFunc.sqlErrMsg)
tradeExit('A005067', '查询[凭证登记表]操作异常!')
raise AfaFlowControl.flowException( )
elif( len( records ) == 0 ):
tradeExit('A005068', '凭证不存在!' )
raise AfaFlowControl.flowException( )
else :
record=AfaUtilTools.ListFilterNone( records )
total=len( records )
sTellerTailNo = ''
sVouhType = ''
sStartNo = ''
sEndNo = ''
sVouhNum = ''
sVouhName = ''
for i in range( 0, total ):
if( i <> 0):
strSplit = '|'
else:
strSplit = ''
sTellerTailNo = sTellerTailNo + strSplit + records[i][0]
sVouhType = sVouhType + strSplit + records[i][1]
sStartNo = sStartNo + strSplit + records[i][2]
sEndNo = sEndNo + strSplit + records[i][3]
sVouhNum = sVouhNum + strSplit + records[i][4]
sVouhName = sVouhName + strSplit + records[i][5]
TradeContext.tradeResponse.append( ['sTellerTailNo',sTellerTailNo] )
TradeContext.tradeResponse.append( ['sTellerNo',TradeContext.sTellerNo] ) #凭证优化更改201109
TradeContext.tradeResponse.append( ['sVouhType',sVouhType] )
TradeContext.tradeResponse.append( ['sVouhName',sVouhName] )
TradeContext.tradeResponse.append( ['sStartNo',sStartNo] )
TradeContext.tradeResponse.append( ['sEndNo',sEndNo] )
TradeContext.tradeResponse.append( ['sVouhNum',sVouhNum] )
TradeContext.tradeResponse.append( ['sLstTrxDay',TradeContext.sLstTrxDay] )
TradeContext.tradeResponse.append( ['sLstTrxTime',TradeContext.sLstTrxTime] )
TradeContext.tradeResponse.append( ['sNum',str(total)] )
TradeContext.tradeResponse.append( ['errorCode','0000'] )
TradeContext.tradeResponse.append( ['errorMsg','交易成功'] )
AfaFunc.autoPackData()
#=============程序退出====================
AfaLoggerFunc.tradeInfo( '查询凭证结存交易['+TradeContext.TemplateCode+']退出' )
except AfaFlowControl.flowException, e:
AfaFlowControl.exitMainFlow( )
def SubModuleMainFst( ):
AfaLoggerFunc.tradeInfo('财税库行_行内资金清算开始[TTPS001_0331112]' )
TradeContext.TransCode='0331112'
try:
#=============获取当前系统时间====================
#TradeContext.workDate=UtilTools.GetSysDate( )
TradeContext.workTime=UtilTools.GetSysTime( )
TradeContext.__agentAccno__ = TradeContext.payeeAcct #清算行国库待清算专户作为贷方账户
AfaLoggerFunc.tradeInfo( '待清算专户:'+TradeContext.__agentAccno__)
sqlStr = "SELECT BRNO,ACCNO FROM TIPS_BRANCH_ADM WHERE PAYBKCODE = '" + TradeContext.payBkCode.strip() + "' AND "
sqlStr = sqlStr+" PAYEEBANKNO = '" + TradeContext.payeeBankNo.strip() + "' "
AfaLoggerFunc.tradeInfo( sqlStr )
records = AfaDBFunc.SelectSql( sqlStr )
if( records == None ):
return TipsFunc.ExitThisFlow( 'A0002', '机构信息表操作异常:'+AfaDBFunc.sqlErrMsg )
elif( len( records )==0 ):
AfaLoggerFunc.tradeError( sqlStr )
return TipsFunc.ExitThisFlow( 'A0003', '无机构信息' )
else:
records=UtilTools.ListFilterNone( records )
for i in range( 0, len( records ) ):
AfaLoggerFunc.tradeInfo( 'brno:'+records[i][0] +' accno:'+records[i][1])
#=============清算：出现清算金额大于银行发生额，需要联社1391科目垫款====================
#统计县联社对账差异金额作为转账金额
if not DoSumAmount(records[i][0]):
return TipsFunc.ExitThisFlow( 'A0027', '汇总发生额失败' )
#TradeContext.amount='1'
if (TradeContext.amount)>0 :
#检查改机构是否已经清算
sqlStr_qs = "SELECT COUNT(*) FROM TIPS_MAINTRANSDTL WHERE TAXPAYCODE = '-' "
sqlStr_qs = sqlStr_qs + "AND DRACCNO = '"+records[i][1]+"' "
sqlStr_qs = sqlStr_qs + "AND NOTE1 = '" + TradeContext.chkDate + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE2 = '" + TradeContext.chkAcctOrd + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE3 = '" + TradeContext.payBkCode.strip() + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE4 = '" + TradeContext.payeeBankNo.strip() + "' "
sqlStr_qs = sqlStr_qs + "AND NOTE6 = '1'"
AfaLoggerFunc.tradeInfo( sqlStr_qs )
Records_qs = AfaDBFunc.SelectSql( sqlStr_qs )
if(Records_qs == None or Records_qs < 0):
return TipsFunc.ExitThisFlow( 'A0002', '流水表操作异常:'+AfaDBFunc.sqlErrMsg )
elif (Records_qs[0][0]==0):
TradeContext.channelCode = '009'
TradeContext.catrFlag = '1' #现金转账标志
TradeContext.tellerno = '999986' #
TradeContext.termId = 'tips'
TradeContext.brno = records[i][0] #
TradeContext.zoneno = TradeContext.brno[0:3]
TradeContext.accno = records[i][1] #机构4401账户作为借方账户
TradeContext.amount =str(TradeContext.amount)
AfaLoggerFunc.tradeInfo( '借方:'+TradeContext.accno+'贷方:' +TradeContext.__agentAccno__)
TradeContext.taxPayCode = '-'
TradeContext.tradeType = 'T' #转账类交易
TradeContext.taxPayName = '清算流水'
TradeContext.note1 = TradeContext.chkDate
TradeContext.note2 = TradeContext.chkAcctOrd
TradeContext.note3 = TradeContext.payBkCode.strip()
TradeContext.note4 = TradeContext.payeeBankNo.strip()
TradeContext.note6 = '1' #清算流水
TradeContext.revTranF = '0'
TradeContext.workTime =UtilTools.GetSysTime( )
TradeContext.taxTypeNum = '0'
#====获取摘要代码=======
if not AfaFlowControl.GetSummaryCode():
return False
#=============获取平台流水号====================
if TipsFunc.GetSerialno( ) == -1 :
AfaLoggerFunc.tradeInfo('>>>处理结果:获取平台流水号异常' )
return TipsFunc.ExitThisFlow( 'A0027', '获取流水号失败' )
#
#=============插入流水表====================
if not TipsFunc.InsertDtl( ) :
return TipsFunc.ExitThisFlow( 'A0027', '插入流水表失败' )
#=============与主机通讯====================
TipsFunc.CommHost()
#=============更新主机返回状态====================
TipsFunc.UpdateDtl( 'TRADE' )
if TradeContext.errorCode!='0000':
AfaLoggerFunc.tradeFatal( '清算记账失败：['+TradeContext.errorCode+']'+ TradeContext.errorMsg)
return False
else:
continue #已经清算，继续下一个机构
AfaLoggerFunc.tradeInfo('财税库行_行内资金清算结束[TTPS001_0331112]' )
return True
except Exception, e:
TipsFunc.exitMainFlow(str(e))
def SubModuleDoFst():
AfaLoggerFunc.tradeInfo( '***农信银系统：来账.中心类操作(1.本地操作).系统状态变更报文接收[RCC00R6_1121]进入***' )
#=================查询本地相关业务状态的系统状态============================
mbrifa_where_dict = {}
mbrifa_where_dict['OPRTYPNO'] = TradeContext.RELOPRTYPNO
mbrifa_dict = rccpsDBTrcc_mbrifa.selectu(mbrifa_where_dict)
if mbrifa_dict == None:
return AfaFlowControl.ExitThisFlow("S999","查询本地系统状态信息异常")
if len(mbrifa_dict) <= 0:
return AfaFlowControl.ExitThisFlow("S999","无相关业务类型本地系统状态信息")
#=================校验报文新工作日期============================================
if int(TradeContext.NWWKDAT) < int(mbrifa_dict['NWWKDAT']):
AfaLoggerFunc.tradeInfo("报文新工作日期[" + TradeContext.NWWKDAT + "]在本地新工作日期[" + mbrifa_dict['NWWKDAT'] + "]之前,丢弃此报文,进入下一流程,发送表示成功的通讯回执")
#======为通讯回执报文赋值===================================================
out_context_dict = {}
out_context_dict['sysType'] = 'rccpst'
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
#out_context_dict['SNDTRDAT'] = TradeContext.BJEDTE
#out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
#out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = TradeContext.TRCCO
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '过期报文'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
return True
elif int(TradeContext.NWWKDAT) == int(mbrifa_dict['NWWKDAT']):
#============报文新工作日期与本地新工作日期相同,校验报文新工作状态======
if int(TradeContext.NWSYSST) <= int(mbrifa_dict['NWSYSST']):
AfaLoggerFunc.tradeInfo("报文新工作状态[" + TradeContext.NWSYSST + "]不在本地新工作状态[" + mbrifa_dict['NWSYSST'] + "]之后,丢弃此报文,进入下一流程,发送表示成功的通讯回执")
#======为通讯回执报文赋值===================================================
out_context_dict = {}
out_context_dict['sysType'] = 'rccpst'
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
out_context_dict['SNDTRDAT'] = TradeContext.BJEDTE
out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = TradeContext.TRCCO
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '过期报文'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
return True
#增加日切报文后发先至情况的处理
#通存通兑顺序10-20-30-10
if TradeContext.RELOPRTYPNO == "30":
if mbrifa_dict['NWSYSST'] == '10' and TradeContext.NWSYSST != '20':
return AfaFlowControl.ExitThisFlow("S999","[" + TradeContext.RELOPRTYPNO + "]业务当前业务状态为日间开始[10],但日切报文中变更状态非业务截止准备[20],停止处理")
if mbrifa_dict['NWSYSST'] == '20' and TradeContext.NWSYSST != '30':
return AfaFlowControl.ExitThisFlow("S999","[" + TradeContext.RELOPRTYPNO + "]业务当前业务状态为业务截止准备[20],但日切报文中变更状态非业务截止[30],停止处理")
if mbrifa_dict['NWSYSST'] == '30' and TradeContext.NWSYSST != '10':
return AfaFlowControl.ExitThisFlow("S999","[" + TradeContext.RELOPRTYPNO + "]业务当前业务状态为业务截止[30],但日切报文中变更状态非日间开始[10],停止处理")
#汇兑汇票顺序10-30-10
else:
if mbrifa_dict['NWSYSST'] == '10' and TradeContext.NWSYSST != '30':
return AfaFlowControl.ExitThisFlow("S999","[" + TradeContext.RELOPRTYPNO + "]业务当前业务状态为日间开始[10],但日切报文中变更状态非业务截止[30],停止处理")
if mbrifa_dict['NWSYSST'] == '30' and TradeContext.NWSYSST != '10':
return AfaFlowControl.ExitThisFlow("S999","[" + TradeContext.RELOPRTYPNO + "]业务当前业务状态为业务截止[30],但日切报文中变更状态非日间开始[10],停止处理")
mbrifa_update_dict = {}
mbrifa_update_dict['ORWKDAT'] = mbrifa_dict['NWWKDAT']
mbrifa_update_dict['ORSYSST'] = mbrifa_dict['NWSYSST']
mbrifa_update_dict['NWWKDAT'] = TradeContext.NWWKDAT
mbrifa_update_dict['NWSYSST'] = TradeContext.NWSYSST
mbrifa_update_dict['HOLFLG'] = TradeContext.HOLFLG
mbrifa_update_dict['NOTE1'] = mbrifa_dict['NWWKDAT']
ret = rccpsDBTrcc_mbrifa.update(mbrifa_update_dict,mbrifa_where_dict)
if ret <= 0:
if not AfaDBFunc.RollbackSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
AfaLoggerFunc.tradeError(">>>Rollback异常")
AfaLoggerFunc.tradeInfo(">>>Rollback成功")
return AfaFlowControl.ExitThisFlow("S999","更新系统状态异常")
#======若新系统状态为业务截止,则打开对账系统调度============================
if TradeContext.NWSYSST == '30' and TradeContext.HOLFLG == '2':
if TradeContext.RELOPRTYPNO == '20':
#====打开汇兑对账系统调度=======================================
AfaLoggerFunc.tradeInfo(">>>开始打开汇兑对账系统调度")
if not rccpsCronFunc.openCron("00031"):
if not AfaDBFunc.RollbackSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
AfaLoggerFunc.tradeError(">>>Rollback异常")
AfaLoggerFunc.tradeInfo(">>>Rollback成功")
return AfaFlowControl.ExitThisFlow("S999","打开汇兑对账系统调度异常")
AfaLoggerFunc.tradeInfo(">>>结束打开汇兑对账系统调度")
#====打开汇票对账系统调度=======================================
AfaLoggerFunc.tradeInfo(">>>开始打开汇票对账系统调度")
if not rccpsCronFunc.openCron("00041"):
if not AfaDBFunc.RollbackSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
AfaLoggerFunc.tradeError(">>>Rollback异常")
AfaLoggerFunc.tradeInfo(">>>Rollback成功")
return AfaFlowControl.ExitThisFlow("S999","打开汇票对账系统调度异常")
AfaLoggerFunc.tradeInfo(">>>结束打开汇票对账系统调度")
elif TradeContext.RELOPRTYPNO == '30':
#====打开通存通兑对账系统调度===================================
AfaLoggerFunc.tradeInfo(">>>开始打开通存通兑对账系统调度")
if not rccpsCronFunc.openCron("00061"):
if not AfaDBFunc.RollbackSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
AfaLoggerFunc.tradeError(">>>Rollback异常")
AfaLoggerFunc.tradeInfo(">>>Rollback成功")
return AfaFlowControl.ExitThisFlow("S999","打开通存通兑对账系统调度异常")
AfaLoggerFunc.tradeInfo(">>>结束打开通存通兑对账系统调度")
#====打开信息类业务量统计系统调度======================
AfaLoggerFunc.tradeInfo(">>>开始打开信息类业务量统计系统调度")
# if not rccpsCronFunc.openCron("00067"):
# if not AfaDBFunc.RollbackSql( ):
# AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
# AfaLoggerFunc.tradeError(">>>Rollback异常")
# AfaLoggerFunc.tradeInfo(">>>Rollback成功")
# return AfaFlowControl.ExitThisFlow("S999","打开信息类业务量统计系统调度异常")
# AfaLoggerFunc.tradeInfo(">>>结束打开信息类业务量统计系统调度")
#======若通存通兑新系统状态为日间开始,则打开行名行号生效系统调度===================
if TradeContext.NWSYSST == '10' and TradeContext.RELOPRTYPNO == '30':
#====开始打开行名行号生效系统调度=======================================
AfaLoggerFunc.tradeInfo(">>>开始打开行名行号生效系统调度")
if not rccpsCronFunc.openCron("00050"):
if not AfaDBFunc.RollbackSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
AfaLoggerFunc.tradeError(">>>Rollback异常")
AfaLoggerFunc.tradeInfo(">>>Rollback成功")
return AfaFlowControl.ExitThisFlow("S999","打开行名行号生效系统调度异常")
AfaLoggerFunc.tradeInfo(">>>结束打开行名行号生效系统调度")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeFatal( AfaDBFunc.sqlErrMsg )
return AfaFlowControl.ExitThisFlow("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
#======为通讯回执报文赋值===================================================
out_context_dict = {}
out_context_dict['sysType'] = 'rccpst'
out_context_dict['TRCCO'] = '9900503'
out_context_dict['MSGTYPCO'] = 'SET008'
out_context_dict['RCVMBRCO'] = TradeContext.SNDMBRCO
out_context_dict['SNDMBRCO'] = TradeContext.RCVMBRCO
out_context_dict['SNDBRHCO'] = TradeContext.BESBNO
out_context_dict['SNDCLKNO'] = TradeContext.BETELR
out_context_dict['SNDTRDAT'] = TradeContext.BJEDTE
out_context_dict['SNDTRTIM'] = TradeContext.BJETIM
out_context_dict['MSGFLGNO'] = out_context_dict['SNDMBRCO'] + TradeContext.BJEDTE + TradeContext.SerialNo
out_context_dict['ORMFN'] = TradeContext.MSGFLGNO
out_context_dict['NCCWKDAT'] = TradeContext.NCCworkDate
out_context_dict['OPRTYPNO'] = '99'
out_context_dict['ROPRTPNO'] = TradeContext.OPRTYPNO
out_context_dict['TRANTYP'] = '0'
out_context_dict['ORTRCCO'] = TradeContext.TRCCO
out_context_dict['PRCCO'] = 'RCCI0000'
out_context_dict['STRINFO'] = '成功'
rccpsMap0000Dout_context2CTradeContext.map(out_context_dict)
AfaLoggerFunc.tradeInfo( '***农信银系统：来账.中心类操作(1.本地操作).系统状态变更报文接收[RCC00R6_1121]退出***' )
return True
