def Schedule_ImportCalendar():
strSql = "select param_value from YwzcWebSys.commset_sysparam where param_en_name='CALENDAR_SOURCE'"
CParam = mySqlConn.query(strSql)
CParam = eval(CParam[0]["param_value"].replace("\r\n",
"").replace(" ", ""))
# 创建到账户库的链接
TNS_NAME = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=%s)(PORT=%s)))(CONNECT_DATA=(SERVICE_NAME=%s)))' % (
CParam["ORACLE_HOST"], CParam["ORACLE_PORT"],
CParam["ORACLE_SERVICE_NAME"])
try:
oraConn = cxOracle(CParam["ORACLE_USER_NAME"],
CParam["ORACLE_USER_PASSWD"], TNS_NAME)
except Exception as e:
print(e)
YYYY = time.strftime("%Y", time.localtime())
lastYYYY = int(YYYY) + 1
oraStrSql = "SELECT * FROM {0} A WHERE A.PHYSICAL_DATE BETWEEN '{1}0101' AND '{1}1231'".format(
CParam["TABLE_NAME"], lastYYYY)
rtnDatas = oraConn.QueryDict(oraStrSql)
for x in rtnDatas:
myStrSql = "select count(*) as cnt from `YwzcWebSys`.`commset_calendar` where `bookset` = '{0}' and `physical_date` = {1}".format(
x["BOOKSET"], x["PHYSICAL_DATE"])
dx = mySqlConn.query(myStrSql)[0]
if str(dx["cnt"]) == "0":
myStrSql = "INSERT INTO `YwzcWebSys`.`commset_calendar` (`bookset`, `physical_date`, `date_flag`, `date_status`) VALUES ('{0}', '{1}', '{2}', '{3}');".format(
x["BOOKSET"],
x["PHYSICAL_DATE"],
x["DATE_FLAG"],
x["DATE_STATUS"],
)
mySqlConn.execute(myStrSql)
# 引入全局参数文件
currPath = os.path.dirname(os.path.realpath(__file__))
globParaList = Get_Param_Info("%s/Config.ini" % (currPath))
# 创建到账户库的链接
TY_TNS_NAME = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=%s)(PORT=%s)))(CONNECT_DATA=(SERVICE_NAME=%s)))' % (
globParaList["TY_ORACLE_HOST"],
globParaList["TY_ORACLE_PORT"],
globParaList["TY_ORACLE_SERVICE_NAME"]
)
oraConnTyzh = cxOracle(
globParaList["TY_ORACLE_USER_NAME"],
globParaList["TY_ORACLE_USER_PASSWD"],
TY_TNS_NAME
)
# 创建到数据中心的链接
DC_TNS_NAME = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=%s)(PORT=%s)))(CONNECT_DATA=(SID=%s)))' % (
globParaList["DC_ORACLE_HOST"],
globParaList["DC_ORACLE_PORT"],
globParaList["DC_ORACLE_SERVICE_NAME"]
)
oraConnDc = cxOracle(
globParaList["DC_ORACLE_USER_NAME"],
globParaList["DC_ORACLE_USER_PASSWD"],
DC_TNS_NAME
) # 通过参数文件获取需要增加的一些信息
cxOracle, Print_Dict_KandV, Gen_Now_Date, Dict2List
from apps.runscripts.Ext_Functions.ADD_NewORG_2_BusiSys.Current_Process import WZH_Add_Org, Back_Tables, \
Table_Row_Is_Exist, Rtn_Table_Desc, Assembling_Insert_Sql, Assembling_Update_Sql
# 引入全局参数文件
currPath = os.path.dirname(os.path.realpath(__file__))
globParaList = Get_Param_Info("%s/Config.ini" % (currPath))
# 创建Oracle库的链接
XYIMG_TNS_NAME = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=%s)(PORT=%s)))(CONNECT_DATA=(SERVICE_NAME=%s)))' % (
globParaList["XYIMG_ORACLE_HOST"],
globParaList["XYIMG_ORACLE_PORT"],
globParaList["XYIMG_ORACLE_SERVICE_NAME"],
)
oraConn = cxOracle(globParaList["XYIMG_ORACLE_USER_NAME"],
globParaList["XYIMG_ORACLE_USER_PASSWD"], XYIMG_TNS_NAME)
if __name__ == "__main__":
""" 为新意无纸化系统新增营业部运营参数脚本 """
try:
MSG_INFO = {}
MSG_INFO["MSG_NO"] = 0
MSG_INFO["MSG_STR"] = "初始消息空间"
''' 获取 任务运行参数 '''
sqlStr = "select * from insbusi_inserneworginfo where insert_org_flag = '0';"
xList = mySqlConn.query(sqlStr)
if len(xList) == 0:
MSG_INFO["MSG_NO"] = 100001
os.environ['DJANGO_SETTINGS_MODULE'] = 'YwzcWebSys.settings'
from apps.commset.GetSysInfo import mySqlConn
strSql = "select param_value from YwzcWebSys.commset_sysparam where param_en_name='CALENDAR_SOURCE'"
CParam = mySqlConn.query(strSql)
CParam = eval(CParam[0]["param_value"].replace("\r\n", "").replace(" ", ""))
print(CParam)
# 创建到账户库的链接
TNS_NAME = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=%s)(PORT=%s)))(CONNECT_DATA=(SERVICE_NAME=%s)))' % (
CParam["ORACLE_HOST"], CParam["ORACLE_PORT"],
CParam["ORACLE_SERVICE_NAME"])
oraConn = cxOracle(CParam["ORACLE_USER_NAME"], CParam["ORACLE_USER_PASSWD"],
TNS_NAME)
oraStrSql = "SELECT * FROM {0} A".format(CParam["TABLE_NAME"])
rtnDatas = oraConn.QueryDict(oraStrSql)
for x in rtnDatas:
myStrSql = "select count(*) as cnt from `YwzcWebSys`.`commset_calendar` where `bookset` = '{0}' and `physical_date` = {1}".format(
x["BOOKSET"], x["PHYSICAL_DATE"])
dx = mySqlConn.query(myStrSql)[0]
if str(dx["cnt"]) == "0":
myStrSql = "INSERT INTO `YwzcWebSys`.`commset_calendar` (`bookset`, `physical_date`, `date_flag`, `date_status`) VALUES ('{0}', '{1}', '{2}', '{3}');".format(
x["BOOKSET"],