file_path = "settlefile/HDHZCNY1340000008" + NCCWKDAT
if not rccpsFtpFunc.getRccps(file_path):
rccpsCronFunc.cronExit("S999","下载汇兑对账汇总文件[" + file_path + "]异常")
file_path = "settlefile/HDMXCNY1340000008" + NCCWKDAT
if not rccpsFtpFunc.getRccps(file_path):
rccpsCronFunc.cronExit("S999","下载汇兑对账明细文件[" + file_path + "]异常")
AfaLoggerFunc.tradeInfo(">>>结束下载汇兑对账文件")
#================关闭汇兑对账文件下载系统调度,打开导入汇兑对账文件系统调度==
AfaLoggerFunc.tradeInfo(">>>开始关闭汇兑对账文件下载系统调度,打开导入汇兑对账文件系统调度")
if not rccpsCronFunc.closeCron("00031"):
rccpsCronFunc.cronExit("S999","关闭汇兑对账文件下载系统调度异常")
if not rccpsCronFunc.openCron("00034"):
rccpsCronFunc.cronExit("S999","打开汇兑对账明细文件导入系统调度异常")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
AfaLoggerFunc.tradeInfo(">>>结束关闭汇兑对账文件下载系统调度,打开导入汇兑对账文件系统调度")
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.汇兑对账文件下载[rccpsHDDZGetFile]退出***")
temp_sql = temp_sql + "where a.bjedte = b.bjedte and a.bspsqn = b.bspsqn and not (b.bcstat in ('70','71') and b.bdwflg = '1') and a.brsflg = '1' and a.nccwkdat in " + LNCCWKDAT + " and exists "
temp_sql = temp_sql + "(select * from rcc_hpdzmx as c where a.sndbnkco = c.sndbnkco and a.trcdat = c.trcdat and a.trcno = c.trcno))"
AfaLoggerFunc.tradeInfo(temp_sql)
ret = AfaDBFunc.InsertSql(temp_sql)
if ret < 0:
AfaLoggerFunc.tradeInfo(AfaDBFunc.sqlErrMsg)
rccpsCronFunc.cronExit("S999","对账来账行内未清算,中心清算类型异常")
AfaLoggerFunc.tradeInfo(">>>结束对账来账行内未清算,中心清算类型")
#================关闭汇票对账明细账勾兑系统调度,打开汇票对账错账处理系统调度==
AfaLoggerFunc.tradeInfo(">>>开始关闭汇票对账明细账勾兑系统调度,打开汇票对账错账处理系统调度")
if not rccpsCronFunc.closeCron("00043"):
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","关闭汇票对账明细账勾兑系统调度异常")
if not rccpsCronFunc.openCron("00040"):
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","打开汇票对账错账处理系统调度异常")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
AfaLoggerFunc.tradeInfo(">>>结束关闭汇票对账明细账勾兑系统调度,打开汇票对账错账处理系统调度")
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.汇票对账明细账勾兑[rccpsHPDZMXCompare]退出***")
tmp_sql = tmp_sql + " and b.bcstat in ('70','72') and b.bdwflg = '1' and a.brsflg = '" + PL_BRSFLG_RCV + "' and a.nccwkdat in " + LNCCWKDAT
tmp_sql = tmp_sql + " group by a.nccwkdat,a.besbno,a.trcco,a.brsflg)"
AfaLoggerFunc.tradeInfo(tmp_sql)
ret = AfaDBFunc.InsertSql(tmp_sql)
if ret < 0:
AfaLoggerFunc.tradeInfo(AfaDBFunc.sqlErrMsg)
rccpsCronFunc.cronExit("S999","通存通兑来账业务量统计异常")
AfaLoggerFunc.tradeInfo(">>>结束通存通兑来账业务量统计")
#================关闭通存通兑业务量统计系统调度===========
AfaLoggerFunc.tradeInfo(">>>开始关闭通存通兑业务量统计系统调度")
if not rccpsCronFunc.closeCron("00066"):
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","关闭通存通兑业务量统计调度异常")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
AfaLoggerFunc.tradeInfo(">>>结束关闭通存通兑业务量统计系统调度")
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.通存通兑业务量统计[rccpsTDProStat]退出***")
except Exception, e:
#所有异常
# #temp_sql = temp_sql + " and ((a.scflag = '7' and a.sctram != c.occamt) or (a.scflag = '8' and a.sctram != c.cuschrg)))"
# temp_sql = temp_sql + " and ((a.scflag = '7' and abs(a.sctram - c.occamt) > 0.001) or (a.scflag = '8' and abs(a.sctram - c.cuschrg) > 0.001)))"
#
# AfaLoggerFunc.tradeInfo(temp_sql)
#
# ret = AfaDBFunc.InsertSql(temp_sql)
#
# if ret < 0:
# rccpsCronFunc.cronExit("S999","对账金额不符异常")
#
# AfaLoggerFunc.tradeInfo(">>>结束对账金额不符")
#================关闭通存通兑主机明细账勾兑系统调度,打开通存通兑主机错账处理系统调度==
AfaLoggerFunc.tradeInfo(">>>开始关闭通存通兑主机明细账勾兑系统调度,打开通存通兑主机错账处理系统调度")
if not rccpsCronFunc.closeCron("00070"):
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","关闭通存通兑主机明细账勾兑系统调度异常")
if not rccpsCronFunc.openCron("00071"):
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","打开通存通兑主机错账处理系统调度异常")
if not AfaDBFunc.CommitSql( ):
AfaLoggerFunc.tradeInfo( AfaDBFunc.sqlErrMsg )
rccpsCronFunc.cronExit("S999","Commit异常")
AfaLoggerFunc.tradeInfo(">>>Commit成功")
AfaLoggerFunc.tradeInfo(">>>结束关闭通存通兑主机明细账勾兑系统调度,打开通存通兑主机错账处理系统调度")
AfaLoggerFunc.tradeInfo("***农信银系统: 系统调度类.通存通兑主机明细账勾兑[rccpsTDZJDZCompare]退出***")
