def update_xw_nr(**kwargs):
rs = None
try:
sql = "update xw_nr set zt='%s' where biaoti ='%s' "% (kwargs["zt"], kwargs["biaoti"])
sql = sql.replace('\\', '-').replace('\n', '').replace('\r', '').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
def update_xw_nrxy(**kwargs):
rs = None
try:
sql = "update xw_nr set xy='%s' where prid ='%s' "% (kwargs["xy"], kwargs["prid"])
sql = sql.replace('\\', '-').replace('\n', '').replace('\r', '').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
def token(**kwargs):
rs = None
try:
sql = "update token_ceshi set yxq='1' where token='%s';" % (
kwargs['token'])
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def updateryzt(**kwargs):
rs = None
try:
sql = "update tbl_fupa_temp set ryzt ='%s'where eid='%s';" % (
kwargs["ryzt"], kwargs["eid"])
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def select_xw(**kwargs):
rs = None
try:
sql = f"SELECT * FROM `bh_gl`.`xw_nr` WHERE `zt` = '1' ORDER BY `biaoti` DESC;"
rs = dbmysql.query(sql)
return rs
except Exception as e:
util.logger.error(e)
return rs
def update_xmxq2(**kwargs):
rs = None
try:
sql = "update xmxq set yyqx='%s'where zbdwmc ='%s' "% (kwargs["yyqx"], kwargs["zbdwmc"])
sql = sql.replace('\\', '-').replace('\n', '').replace('\r', '').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def update_qyzz(**kwargs):
rs = None
try:
sql = "update zzfw set zsh='%s' where tbl_qy_zz ='%s' "% (kwargs["zzfw"], kwargs["zsh"])
sql = sql.replace('\\', '-').replace('\n', '').replace('\r', '').replace('\t', '')
rs = dbmysql.query(sql)
print(sql)
except Exception as e:
util.logger.error(e)
def gxqy_fupa_te(**kwargs):
rs = None
try:
sql = "UPDATE q_psname SET zt ='%s' WHERE qyname='%s';" % \
(kwargs['zt'],kwargs['gsname'])
# cx_state标记
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def deletetbl_user_zcxx1_user(**kwargs):
rs = None
try:
sql = "DELETE FROM tbl_user_zcxx WHERE userid='%s';" % (
kwargs["userid"])
rs = dbmysql.query(sql)
print(sql)
except Exception as e:
util.logger.error(e)
return rs
def gxqy(**kwargs):
rs = None
try:
sql = "UPDATE tbl_query_temp SET cx_state ='%s' WHERE cx_val='%s';" % (
kwargs['cx_state'], kwargs['gsname'])
# cx_state标记
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def delete_qycookie(**kwargs):
rs = None
try:
sql = "delete from ipo_title where uid='%s'" % (kwargs["uid"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
def insertZhilian(**kwargs):
rs = None
try:
id = util.getUUID()
sql = "insert into newtable(id,date,title,url,insertTime,opertionTime) VALUES ('%s','%s','%s','%s',now(),now());" % (
id, kwargs["date"], kwargs["title"], kwargs["url"])
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def insertgonggao(**kwargs):
rs = None
try:
ggId = util.getUUID()
sql = "insert into gonggaobody(ggId,insertTime,opertionTime,title,times,body,url) VALUES ('%s',now(),now(),'%s','%s','%s','%s');" % (
ggId, kwargs["title"], kwargs["times"], kwargs["body"], kwargs["url"])
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def updatexmxq_doc(**kwargs):
rs = None
try:
sql = "update xmxq set doc_link='%s'where xmmc ='%s'and gclx ='%s';" % (
kwargs["doc_link"], kwargs["xmmc"], kwargs["gclx"])
sql = sql.replace('\\', '-').replace('\n', '').replace('\r', '').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def insertZhilian(**kwargs):
rs = None
try:
posId = util.getUUID()
sql = "insert into zhaoping(posId,posName,salary,workExp,edu,company,detail,insertTime,opertionTime,url) VALUES ('%s','%s','%s','%s','%s','%s','%s',now(),now(),'%s');" % (
posId, kwargs["posName"], kwargs["salary"], kwargs["workExp"],
kwargs["edu"], kwargs["company"], kwargs["detail"], kwargs["url"])
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def dele_token(**kwargs):
rs = None
try:
sql = "DELETE from token_ceshi where token='%s';" % (kwargs['token'])
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
#======================================================================================================
def gxqy_fupa(**kwargs):
rs = None
try:
inserttime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
sql = "UPDATE tbl_fupa_temp SET inserttime ='%s',cx_state ='%s' WHERE eid='%s';" % (
inserttime, kwargs['cx_state'], kwargs['eid'])
# cx_state标记
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def delete_tbl_user_user(**kwargs):
rs = None
try:
sql = "delete from tbl_user where userid ='%s';" % (kwargs["userid"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def updatet_qyzzzt(**kwargs):
rs = None
try:
sql = "update tbl_fupa_temp set qyzzzt='%s' where eid='%s';" % (
kwargs["qyzzzt"], kwargs["eid"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def update_qyid(**kwargs):
rs = None
try:
# inserttime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
sql = "update tbl_fupa_temp set qiyeurl='%s'where eid='%s';" % (
kwargs["qyurl"], kwargs["eid"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def update_fj(**kwargs):
rs = None
try:
sql = "update tbl_fj set zt='%s'where qyname ='%s'and qyurl ='%s';" % (
kwargs["zt"], kwargs["qyname"], kwargs["qyurl"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def inserttbl_user(**kwargs):
rs = None
try:
sql = "insert into tbl_user(qyid,userid,username,sex,zjlx,zjhm) VALUES ('%s','%s','%s','%s','%s','%s');" % (
kwargs["qyid"], kwargs["userid"], kwargs["username"],
kwargs["sex"], kwargs["zjlx"], kwargs["zjhm"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def updatetbl_user(**kwargs):
rs = None
try:
sql = "update tbl_user set username='******',sex='%s',zjlx='%s',zjhm='%s' where qyid='%s' and userid='%s';" % (
kwargs["username"], kwargs["sex"], kwargs["zjlx"], kwargs["zjhm"],
kwargs["qyid"], kwargs["userid"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def inserttbl_qy(**kwargs):
rs = None
try:
sql = "insert into tbl_qy (qyid,qyname,xydm,frdb,zclx,zcsd,jydz) value ('%s','%s','%s','%s','%s','%s','%s');" % (
kwargs["qyid"], kwargs["qyname"], kwargs["xydm"], kwargs["frdb"],
kwargs["zclx"], kwargs["zcsd"], kwargs["jydz"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
print(sql)
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def updatetbl_qy(**kwargs):
rs = None
try:
sql = "update tbl_qy set xydm='%s',frdb='%s',zclx='%s',zcsd='%s',jydz='%s' where qyid='%s';" % (
kwargs["xydm"], kwargs["frdb"], kwargs["zclx"], kwargs["zcsd"],
kwargs["jydz"], kwargs["qyid"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
print(sql)
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def insert_token(**kwargs):
rs = None
try:
inserttime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
sql = "insert into token_ceshi (token,yxq,inserttime,ip) value ('%s','%s','%s','%s');" % (
kwargs['token'], '0', inserttime, kwargs['ip'])
print(sql)
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def insert_qy_list(**kwargs):
rs = None
try:
inserttime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
sql = "insert into q_name_list (eid,qyname,bh,qy_zt,inserttime) value ('%s','%s','%s','%s','%s');" % (
kwargs['eid'], kwargs['qyname'], kwargs['bh'], kwargs['qy_zt'],
inserttime)
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def update_qname_list(**kwargs):
rs = None
try:
# inserttime = time.strftime('%Y-%m-%d %H:%M:%S', time.localtime())
sql = "update q_name_list set qy_zt='%s'where eid='%s';" % (
kwargs["qy_zt"], kwargs["eid"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
# print(sql)
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def inserttbl_qy_zz(**kwargs):
rs = None
try:
sql = "insert into tbl_qy_zz(qyid,zzlx,zsh,zzmc,fzrq,zsyxq,fzjg,zzfw) VALUES ('%s','%s','%s','%s','%s','%s','%s','%s');" % (
kwargs["qyid"], kwargs["zzlx"], kwargs["zsh"], kwargs["zzmc"],
kwargs["fzrq"], kwargs["zsyxq"], kwargs["fzjg"], kwargs["zzfw"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
def updatetbl_qy_zz(**kwargs):
rs = None
try:
sql = "update tbl_qy_zz set zzlx='%s',fzrq='%s',zsyxq='%s',fzjg='%s' where qyid='%s' and(zsh='%s' or zzmc='%s');" % (
kwargs["zzlx"], kwargs["fzrq"], kwargs["zsyxq"], kwargs["fzjg"],
kwargs["qyid"], kwargs["zsh"], kwargs["zzmc"])
sql = sql.replace('\\', '-').replace('\n',
'').replace('\r',
'').replace('\t', '')
# print('更新资质信息的sql语句',sql)
rs = dbmysql.query(sql)
except Exception as e:
util.logger.error(e)
return rs
