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