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]退出***")