Example #1
0
def insert_data_hrb():
    cursor = globalvars.cnx3.cursor()
    sql = "SELECT * FROM tbs001_developprojectbasicinfo"
    cursor.execute(sql)
    data = cursor.fetchall()

    cursor = globalvars.cnx1.cursor()
    for row in data:
        sql = "SELECT * FROM phase_a1 " "WHERE XiangMuMingCheng=%s"
        param = (row[0],)
        cursor.execute(sql, param)
        data1 = cursor.fetchall()
        if cursor.rowcount == 0:
            continue
        elif cursor.rowcount == 1:
            pid = data1[0][0]
        else:
            print globalvars.get_time(), "数据出错！", row[0]
            pid = data1[0][0]
        log_yushouli(row, pid)
        log_shouli(row, pid)
        log_bumen(row, pid)
        log_fuzeren(row, pid)
        log_tacha(row, pid)
        log_huiyi(row, pid)
        log_pinggu(row, pid)
        log_kaoping(row, pid)
        log_shangbao(row, pid)

    globalvars.cnx1.commit()
Example #2
0
def run():
  print globalvars.get_time(), '清空staff表'
  globalvars.trunc_staff()

  print globalvars.get_time(), '添加staff表数据（黑龙江）'
  insert_data_hlj()
  print globalvars.get_time(), '添加staff表数据（哈尔滨）'
  insert_data_hrb()

  print globalvars.get_time(), '添加authority表数据'
  insert_authority()

  print globalvars.get_time(), '更新authority表数据'
  update_authortity()
Example #3
0
def run():
  print globalvars.get_time(), '清空pinggu_danwei表'
  globalvars.trunc_pgdw()

  print globalvars.get_time(), '添加pinggu_danwei表数据（黑龙江）'
  insert_data_hlj()
  print globalvars.get_time(), '添加pinggu_danwei表数据（哈尔滨）'
  insert_data_hrb()

  print globalvars.get_time(), '添加评估单位登录信息'
  update_data_acc()
Example #4
0
def run():
  print globalvars.get_time(), '清空jianshe_danwei表'
  globalvars.trunc_jshdw()

  print globalvars.get_time(), '添加jianshe_danwei数据（黑龙江）'
  insert_data_hlj()
  print globalvars.get_time(), '添加jianshe_danwei数据（哈尔滨）'
  insert_data_hrb()
Example #5
0
def run():
    print globalvars.get_time(), "清空phase_log表"
    globalvars.trunc_log()

    print globalvars.get_time(), "添加phase_log数据（黑龙江）"
    insert_data_hlj()

    print globalvars.get_time(), "添加phase_log数据（哈尔滨）"
    insert_data_hrb()

    print globalvars.get_time(), "删除phase_log表无效数据"
    cursor = globalvars.cnx1.cursor()
    sql = "DELETE FROM phase_b_log WHERE account is NULL"
    cursor.execute(sql)
    globalvars.cnx1.commit()
Example #6
0
def run():
  print globalvars.get_time(), '清空phase表'
  globalvars.trunc_phase()

  print globalvars.get_time(), '添加phase数据（黑龙江）'
  insert_data_hlj()

  print globalvars.get_time(), '添加phase数据（哈尔滨）'
  insert_data_hrb()
Example #7
0
def run():
  print globalvars.get_time(), '清空zhuanjia表'
  globalvars.trunc_zhuanjia()

  print globalvars.get_time(), '添加zhuanjia表数据（黑龙江）'
  insert_data_hlj()

  print globalvars.get_time(), '添加zhuanjia表数据（哈尔滨）'
  insert_data_hrb()
Example #8
0
# -*- coding:utf-8 -*-

import globalvars

if __name__ == '__main__':
  print globalvars.get_time(), '1123'
Example #9
0
def run():
  print globalvars.get_time(), '清空pinggu_xiangmufuzeren表'
  globalvars.trunc_xmfzr()

  print globalvars.get_time(), '添加pinggu_xiangmufuzeren数据（黑龙江）'
  insert_data_hlj()

  print globalvars.get_time(), '添加pinggu_xiangmufuzeren数据（哈尔滨）'
  insert_data_hrb()

  print globalvars.get_time(), '修正评估类别'
  update_leibie()

  print globalvars.get_time(), '修正资格证编号'
  update_zigezheng()

  print globalvars.get_time(), '修正上岗证编号'
  update_shanggangzheng()
Example #10
0
def run():
  print globalvars.get_time(), '修正A1表环评类别'
  update_a1_hplb()
  print globalvars.get_time(), '修正A1表环统类别'
  update_a1_htlb()
Example #11
0
import jshdw
import staff
import pgdw
import xmfzr
import zhuanjia
import phase
import phase_log
import phase_a4
import phase_a5
import phase_a6

reload(sys)
sys.setdefaultencoding("utf-8")

if __name__ == '__main__':
  print globalvars.get_time(), '开始运行'

  #jshdw.run()

  #staff.run()

  #pgdw.run()

  #xmfzr.run()

  #zhuanjia.run()

  phase.run()

  #phase_log.run()