def GET(self): flag = True runData = {'runFlag':True,'showMsg':'OK'} req = web.input() # 检查必填项是否都有值 mustName = ['type','id'] runData = lazy.checkInput( req, mustName, runData) if not runData['runFlag']: msg = "输入参数不正确,请按照正常操作流程使用系统。" runData['showMsg'] = msg + runData['showMsg'] return render.err(runData) host = web.ctx.get('host', '192.168.1.101') tempIndex = host.find(':') if tempIndex < 1 : runData['runFlag'] = False print host[:tempIndex] ip = host[:tempIndex] runData['iframeUrl'] = 'http://'+ ip +':8000/zdgs/report?type=' + req['type'] +'&id=' + req['id'] pageCookie = web.cookies(automode='n') if cmp(pageCookie.automode, 'y') == 0: runData['automodeFlag'] = 'y' runData['automodeText'] = '自动模式,5秒后跳转到 下一张单据。' else: runData['automodeFlag'] = 'n' runData['automodeText'] = '' return render.showreport(runData)
def GET(self): flag = True runData = {'runFlag': True, 'showMsg': 'OK'} req = web.input() # 检查必填项是否都有值 mustName = ['type', 'id'] runData = lazy.checkInput(req, mustName, runData) if not runData['runFlag']: msg = "输入参数不正确,请按照正常操作流程使用系统。" runData['showMsg'] = msg + runData['showMsg'] return render.err(runData) host = web.ctx.get('host', '192.168.1.101') tempIndex = host.find(':') if tempIndex < 1: runData['runFlag'] = False print host[:tempIndex] ip = host[:tempIndex] runData[ 'iframeUrl'] = 'http://' + ip + ':8000/zdgs/report?type=' + req[ 'type'] + '&id=' + req['id'] pageCookie = web.cookies(automode='n') if cmp(pageCookie.automode, 'y') == 0: runData['automodeFlag'] = 'y' runData['automodeText'] = '自动模式,5秒后跳转到 下一张单据。' else: runData['automodeFlag'] = 'n' runData['automodeText'] = '' return render.showreport(runData)
def POST(self): flag = True runData = {'runFlag':True,'showMsg':'OK'} req = web.input() # 检查必填项是否都有值 mustName = ['c0_1',] runData = lazy.checkInput( req, mustName, runData) cx = lazy.getConn() cu = cx.cursor() strUpdate = "UPDATE temp_data SET use_flag='2' where data_no='" + req['c0_1'] + "'" print strUpdate cu.execute(strUpdate) cx.commit() cu.close() cx.close raise web.redirect('/')
def POST(self): flag = True runData = {'runFlag': True, 'showMsg': 'OK'} req = web.input() # 检查必填项是否都有值 mustName = [ 'c0_1', ] runData = lazy.checkInput(req, mustName, runData) cx = lazy.getConn() cu = cx.cursor() strUpdate = "UPDATE temp_data SET use_flag='2' where data_no='" + req[ 'c0_1'] + "'" print strUpdate cu.execute(strUpdate) cx.commit() cu.close() cx.close raise web.redirect('/')
def POST(self): flag = True msg = "lost : " renderData = {'runFlag':True,'showMsg':'OK'} req = web.input() # 检查必填项是否都有值 mustName = ['fld_no','c0_1','c1_1','c2_1','c3_1','c4_1','c5_1','c6_1' \ ,'c7_1','c8_1','c9_1','c9_1','c10_1','c11_1' \ ] renderData = lazy.checkInput( req, mustName, renderData) req['fld_no'] = lazy.getFldNo() if not renderData['runFlag']: msg = "输入参数不正确,请按照正常操作流程使用系统。" renderData['showMsg'] = msg + renderData['showMsg'] return render.err(renderData) cx = lazy.getConn() cu = cx.cursor() strInsert = "INSERT INTO fld (fld_no, khmc, khdz, lxdh, ssds, xqdh, lsh, " \ + "zdrq, ckrq, flck, jedx, jehj ) VALUES ('" \ + req['fld_no'] + "','" + req['c1_1'] + "','" + req['c2_1'] + "','" + req['c3_1'] \ + "','" + req['c4_1'] + "','" + req['c5_1'] + "','" + req['fld_no'] + "','" + req['c6_1'] \ + "','" + req['c7_1'] + "','" + req['c8_1'] + "','" + req['c1_1'] + "','" + req['c1_1'] + "')" print strInsert try: cu.execute(strInsert) except: renderData['runFlag'] = False msg = "被禁止的数据库操作,请按照正常操作流程使用系统。" renderData['showMsg'] = msg + renderData['showMsg'] return render.err(renderData) strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','1','" + req['c9_1'] + "','" + req['c10_1'] + "','" + req['c11_1'] \ + "','" + req['c12_1'] + "','" + req['c13_1'] + "','"+ req['c14_1'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req['c0_1'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_2'], '')!=0 : strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','2','" + req['c9_2'] + "','" + req['c10_2'] + "','" + req['c11_2'] \ + "','" + req['c12_2'] + "','" + req['c13_2'] + "','"+ req['c14_2'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req['c0_2'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_3'], '')!=0 : strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','3','" + req['c9_3'] + "','" + req['c10_3'] + "','" + req['c11_3'] \ + "','" + req['c12_3'] + "','" + req['c13_3'] + "','"+ req['c14_3'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req['c0_3'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_4'], '')!=0 : strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','4','" + req['c9_4'] + "','" + req['c10_4'] + "','" + req['c11_4'] \ + "','" + req['c12_4'] + "','" + req['c13_4'] + "','"+ req['c14_4'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req['c0_4'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_5'], '')!=0 : strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','5','" + req['c9_5'] + "','" + req['c10_5'] + "','" + req['c11_5'] \ + "','" + req['c12_5'] + "','" + req['c13_5'] + "','"+ req['c14_5'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req['c0_5'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_6'], '')!=0 : strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','6','" + req['c9_6'] + "','" + req['c10_6'] + "','" + req['c11_6'] \ + "','" + req['c12_6'] + "','" + req['c13_6'] + "','"+ req['c14_6'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req['c0_6'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_7'], '')!=0 : strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','7','" + req['c9_7'] + "','" + req['c10_7'] + "','" + req['c11_7'] \ + "','" + req['c12_7'] + "','" + req['c13_7'] + "','"+ req['c14_7'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req['c0_7'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_8'], '')!=0 : strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','8','" + req['c9_8'] + "','" + req['c10_8'] + "','" + req['c11_8'] \ + "','" + req['c12_8'] + "','" + req['c13_8'] + "','"+ req['c14_8'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req['c0_8'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_9'], '')!=0 : strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','9','" + req['c9_9'] + "','" + req['c10_9'] + "','" + req['c11_9'] \ + "','" + req['c12_9'] + "','" + req['c13_9'] + "','"+ req['c14_9'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req['c0_9'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_10'], '')!=0 : strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','10','" + req['c9_10'] + "','" + req['c10_10'] + "','" + req['c11_10'] \ + "','" + req['c12_10'] + "','" + req['c13_10'] + "','"+ req['c14_10'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req['c0_10'] + "'" print strUpdate cu.execute(strUpdate) cx.commit() cu.close() cx.close() #return "success" host = web.ctx.get('host', '192.168.1.101') tempIndex = host.find(':') if tempIndex < 1 : renderData['runFlag'] = False print host[:tempIndex] ip = host[:tempIndex] if req.has_key('automode') : web.setcookie('automode', 'y', 3600000) #raise web.redirect('/makeFld') else: web.setcookie('automode', 'n', 3600000) raise web.redirect('/showReport?type=fld&id=' + req['fld_no'] )
def POST(self): flag = True msg = "lost : " renderData = {'runFlag': True, 'showMsg': 'OK'} req = web.input() # 检查必填项是否都有值 mustName = ['fld_no','c0_1','c1_1','c2_1','c3_1','c4_1','c5_1','c6_1' \ ,'c7_1','c8_1','c9_1','c9_1','c10_1','c11_1' \ ] renderData = lazy.checkInput(req, mustName, renderData) req['fld_no'] = lazy.getFldNo() if not renderData['runFlag']: msg = "输入参数不正确,请按照正常操作流程使用系统。" renderData['showMsg'] = msg + renderData['showMsg'] return render.err(renderData) cx = lazy.getConn() cu = cx.cursor() strInsert = "INSERT INTO fld (fld_no, khmc, khdz, lxdh, ssds, xqdh, lsh, " \ + "zdrq, ckrq, flck, jedx, jehj ) VALUES ('" \ + req['fld_no'] + "','" + req['c1_1'] + "','" + req['c2_1'] + "','" + req['c3_1'] \ + "','" + req['c4_1'] + "','" + req['c5_1'] + "','" + req['fld_no'] + "','" + req['c6_1'] \ + "','" + req['c7_1'] + "','" + req['c8_1'] + "','" + req['c1_1'] + "','" + req['c1_1'] + "')" print strInsert try: cu.execute(strInsert) except: renderData['runFlag'] = False msg = "被禁止的数据库操作,请按照正常操作流程使用系统。" renderData['showMsg'] = msg + renderData['showMsg'] return render.err(renderData) strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','1','" + req['c9_1'] + "','" + req['c10_1'] + "','" + req['c11_1'] \ + "','" + req['c12_1'] + "','" + req['c13_1'] + "','"+ req['c14_1'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req[ 'c0_1'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_2'], '') != 0: strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','2','" + req['c9_2'] + "','" + req['c10_2'] + "','" + req['c11_2'] \ + "','" + req['c12_2'] + "','" + req['c13_2'] + "','"+ req['c14_2'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req[ 'c0_2'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_3'], '') != 0: strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','3','" + req['c9_3'] + "','" + req['c10_3'] + "','" + req['c11_3'] \ + "','" + req['c12_3'] + "','" + req['c13_3'] + "','"+ req['c14_3'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req[ 'c0_3'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_4'], '') != 0: strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','4','" + req['c9_4'] + "','" + req['c10_4'] + "','" + req['c11_4'] \ + "','" + req['c12_4'] + "','" + req['c13_4'] + "','"+ req['c14_4'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req[ 'c0_4'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_5'], '') != 0: strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','5','" + req['c9_5'] + "','" + req['c10_5'] + "','" + req['c11_5'] \ + "','" + req['c12_5'] + "','" + req['c13_5'] + "','"+ req['c14_5'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req[ 'c0_5'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_6'], '') != 0: strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','6','" + req['c9_6'] + "','" + req['c10_6'] + "','" + req['c11_6'] \ + "','" + req['c12_6'] + "','" + req['c13_6'] + "','"+ req['c14_6'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req[ 'c0_6'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_7'], '') != 0: strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','7','" + req['c9_7'] + "','" + req['c10_7'] + "','" + req['c11_7'] \ + "','" + req['c12_7'] + "','" + req['c13_7'] + "','"+ req['c14_7'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req[ 'c0_7'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_8'], '') != 0: strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','8','" + req['c9_8'] + "','" + req['c10_8'] + "','" + req['c11_8'] \ + "','" + req['c12_8'] + "','" + req['c13_8'] + "','"+ req['c14_8'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req[ 'c0_8'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_9'], '') != 0: strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','9','" + req['c9_9'] + "','" + req['c10_9'] + "','" + req['c11_9'] \ + "','" + req['c12_9'] + "','" + req['c13_9'] + "','"+ req['c14_9'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req[ 'c0_9'] + "'" print strUpdate cu.execute(strUpdate) if cmp(req['c0_10'], '') != 0: strInsert = "INSERT INTO fld_list (fld_no, bh, mcjgg, jxdm, jldw, yfsl, sfsl, bz ) VALUES ('" \ + req['fld_no'] + "','10','" + req['c9_10'] + "','" + req['c10_10'] + "','" + req['c11_10'] \ + "','" + req['c12_10'] + "','" + req['c13_10'] + "','"+ req['c14_10'] +"')" print strInsert cu.execute(strInsert) strUpdate = "UPDATE temp_data SET use_flag='1' where data_no='" + req[ 'c0_10'] + "'" print strUpdate cu.execute(strUpdate) cx.commit() cu.close() cx.close() #return "success" host = web.ctx.get('host', '192.168.1.101') tempIndex = host.find(':') if tempIndex < 1: renderData['runFlag'] = False print host[:tempIndex] ip = host[:tempIndex] if req.has_key('automode'): web.setcookie('automode', 'y', 3600000) #raise web.redirect('/makeFld') else: web.setcookie('automode', 'n', 3600000) raise web.redirect('/showReport?type=fld&id=' + req['fld_no'])