def deleteData_quantou(request): '删除数据' result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"],itemlenth=0) if len(rs1)>0: for rs in rs1: if rs[2]<>'': #出错信息的保留 res={} res['proid']=rs[0] res['proname']=rs[1] res['info']=rs[2] result.append(res) else: try: res={} sqlstr=u"delete from quantou where proid='"+rs[0]+"'" confsql.runSql(sqlstr) res={} res['proid']=rs[0] res['proname']=rs[1] res['info']=u'删除成功!' result.append(res) except: res={} res['proid']=rs[0] res['proname']=rs[1] res['info']=u'删除失败!' result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def save_quantou(request): '保存拳头产品' rs1=[] result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"]) for rs in rs1: if rs[2]==u'数据库已存在!': try: confsql.runSql("delete from quantou where proid='"+rs[0]+"'") except: rs[2]=u'删除失败!' try: confsql.runSql("insert into quantou values('"+rs[0]+"','"+datetime.date.today().strftime("%Y-%m-%d")+"')") rs[2]=u'插入成功!' except: rs[2]=u'插入失败!' res={} res['proid']=rs[0] res['proname']=rs[1] res['info']=rs[2] result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def save_tianshu(request): '保存拳头产品' rs1 = [] result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"]) for rs in rs1: if rs[4] == u'数据库已存在!': try: confsql.runSql("delete from tianshu where braid='" + rs[0] + "'") except: rs[4] = u'删除失败!' try: confsql.runSql("insert into tianshu values('" + rs[0] + "','" + rs[2] + "','" + rs[3] + "','" + datetime.date.today().strftime("%Y-%m-%d") + "')") rs[4] = u'插入成功!' except: rs[4] = u'插入失败!' res = {} res['braid'] = rs[0] res['braname'] = rs[1] res['anquankucun'] = rs[2] res['peisongzhouqi'] = rs[3] res['info'] = rs[4] result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def save_maxmin(request): ' 上下限导入检查 写入数据库 ' try: rs1 = [] result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"]) banben = myjson["banben"] startdate = myjson["startdate"] enddate = myjson["enddate"] #插入数据库 sqlstr = "" for rs in rs1: if rs[6] == '': sqlstr += "delete from maxmin where braid ='" + rs[ 0] + "' and proid='" + rs[ 2] + "' and banben='" + banben + "';" if sqlstr <> "": confsql.runSql(sqlstr) #数据库 sqlstr = "" for rs in rs1: if rs[6] == '': adddate = datetime.datetime.now().strftime( '%Y-%m-%d') #最后追加插入日期 sqlstr += "insert into maxmin(braid,proid,maxval,minval,banben,startdate,enddate,adddate) values('" + rs[ 0] + "','" + rs[2] + "','" + rs[4] + "','" + rs[ 5] + "','" + banben + "','" + startdate + "','" + enddate + "','" + adddate + "');" rs[6] = '插入成功!' res = {} res['braid'] = rs[0] res['braname'] = rs[1] res['proid'] = rs[2] res['proname'] = rs[3] res['maxval'] = rs[4] res['minval'] = rs[5] res['info'] = rs[6] result.append(res) else: res = {} res['braid'] = rs[0] res['braname'] = rs[1] res['proid'] = rs[2] res['proname'] = rs[3] res['maxval'] = rs[4] res['minval'] = rs[5] res['info'] = rs[6] result.append(res) if sqlstr <> "": confsql.runSql(sqlstr) #数据库 jsonres = simplejson.dumps(result) log(jsonres) return HttpResponse(jsonres) except: return HttpResponse(0)
def save_basedisplay(request): '保存订货量修改规则' rs1 = [] result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"]) for rs in rs1: if rs[5] <> '': if rs[5] == u'数据库已存在!': try: confsql.runSql("update basedisplay set basedisplay='" + rs[4] + "' where braid='" + rs[0] + "' and proid='" + rs[2] + "'") rs[5] = '插入成功!' except: rs[5] = '插入失败!' res = {} res['braid'] = rs[0] res['braname'] = rs[1] res['proid'] = rs[2] res['proname'] = rs[3] res['basedisplay'] = rs[4] res['info'] = rs[5] result.append(res) else: res = {} res['braid'] = rs[0] res['braname'] = rs[1] res['proid'] = rs[2] res['proname'] = rs[3] res['basedisplay'] = rs[4] res['info'] = rs[5] result.append(res) else: #无误的 try: confsql.runSql( "insert into basedisplay(braid,proid,basedisplay) values('" + rs[0] + "','" + rs[2] + "','" + rs[4] + "')") rs[5] = '插入成功!' except: rs[5] = '插入失败!' res = {} res['braid'] = rs[0] res['braname'] = rs[1] res['proid'] = rs[2] res['proname'] = rs[3] res['basedisplay'] = rs[4] res['info'] = rs[5] result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def deleteData_product_gl_packetqty_rules(request): '删除数据' result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"]) #log(rs1) if len(rs1) > 0: for rs in rs1: if rs[4] <> '': #出错信息的保留 res = {} res['xcode'] = rs[0] res['name'] = rs[1] res['excode'] = rs[2] res['packetqty1'] = rs[3] res['info'] = rs[4] result.append(res) else: try: #sp, xl, zl, dl, null excode = rs[2] if rs[2] == u'商品代码': excode = 'sp' if rs[2] == u'小类代码': excode = 'xl' if rs[2] == u'中类代码': excode = u'zl' if rs[2] == '大类代码': excode = u'dl' #log("delete from product_gl_packetqty_rules where xcode='"+rs[0]+"' and excode='"+excode+"'") confsql.runSql( "delete from product_gl_packetqty_rules where xcode='" + rs[0] + "' and excode='" + excode + "'") res = {} res['xcode'] = rs[0] res['name'] = rs[1] res['excode'] = rs[2] res['packetqty1'] = rs[3] res['info'] = u'删除成功!' result.append(res) except: res = {} res['xcode'] = rs[0] res['name'] = rs[1] res['excode'] = rs[2] res['packetqty1'] = rs[3] res['info'] = u'删除失败!' result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def save_basedisplay(request): '保存订货量修改规则' rs1=[] result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"]) for rs in rs1: if rs[5]<>'': if rs[5]==u'数据库已存在!': try: confsql.runSql("update basedisplay set basedisplay='"+rs[4]+"' where braid='"+rs[0]+"' and proid='"+rs[2]+"'") rs[5]='插入成功!' except: rs[5]='插入失败!' res={} res['braid']=rs[0] res['braname']=rs[1] res['proid']=rs[2] res['proname']=rs[3] res['basedisplay']=rs[4] res['info']=rs[5] result.append(res) else: res={} res['braid']=rs[0] res['braname']=rs[1] res['proid']=rs[2] res['proname']=rs[3] res['basedisplay']=rs[4] res['info']=rs[5] result.append(res) else: #无误的 try: confsql.runSql("insert into basedisplay(braid,proid,basedisplay) values('"+rs[0]+"','"+rs[2]+"','"+rs[4]+"')") rs[5]='插入成功!' except: rs[5]='插入失败!' res={} res['braid']=rs[0] res['braname']=rs[1] res['proid']=rs[2] res['proname']=rs[3] res['basedisplay']=rs[4] res['info']=rs[5] result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def save_maxmin(request): ' 上下限导入检查 写入数据库 ' try: rs1=[] result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"]) banben=myjson["banben"] startdate=myjson["startdate"] enddate=myjson["enddate"] #插入数据库 sqlstr="" for rs in rs1: if rs[6]=='': sqlstr+="delete from maxmin where braid ='" + rs[0] + "' and proid='" + rs[2] + "' and banben='" + banben + "';" if sqlstr<>"": confsql.runSql(sqlstr) #数据库 sqlstr="" for rs in rs1: if rs[6]=='': adddate=datetime.datetime.now().strftime('%Y-%m-%d') #最后追加插入日期 sqlstr+="insert into maxmin(braid,proid,maxval,minval,banben,startdate,enddate,adddate) values('"+rs[0]+"','"+rs[2]+"','"+rs[4]+"','"+rs[5]+"','"+banben+"','"+startdate+"','"+enddate+"','"+adddate+"');" rs[6]='插入成功!' res={} res['braid']=rs[0] res['braname']=rs[1] res['proid']=rs[2] res['proname']=rs[3] res['maxval']=rs[4] res['minval']=rs[5] res['info']=rs[6] result.append(res) else: res={} res['braid']=rs[0] res['braname']=rs[1] res['proid']=rs[2] res['proname']=rs[3] res['maxval']=rs[4] res['minval']=rs[5] res['info']=rs[6] result.append(res) if sqlstr<>"": confsql.runSql(sqlstr) #数据库 jsonres=simplejson.dumps(result) log(jsonres) return HttpResponse(jsonres) except: return HttpResponse(0)
def deleteData_product_gl_packetqty_rules(request): '删除数据' result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"]) #log(rs1) if len(rs1)>0: for rs in rs1: if rs[4]<>'': #出错信息的保留 res={} res['xcode']=rs[0] res['name']=rs[1] res['excode']=rs[2] res['packetqty1']=rs[3] res['info']=rs[4] result.append(res) else: try: #sp, xl, zl, dl, null excode=rs[2] if rs[2]==u'商品代码': excode='sp' if rs[2]==u'小类代码': excode='xl' if rs[2]==u'中类代码': excode=u'zl' if rs[2]=='大类代码': excode=u'dl' #log("delete from product_gl_packetqty_rules where xcode='"+rs[0]+"' and excode='"+excode+"'") confsql.runSql("delete from product_gl_packetqty_rules where xcode='"+rs[0]+"' and excode='"+excode+"'") res={} res['xcode']=rs[0] res['name']=rs[1] res['excode']=rs[2] res['packetqty1']=rs[3] res['info']=u'删除成功!' result.append(res) except: res={} res['xcode']=rs[0] res['name']=rs[1] res['excode']=rs[2] res['packetqty1']=rs[3] res['info']=u'删除失败!' result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def save_delivery(request): '''配送规则导入检查并插入数据库''' rs1=[] result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"]) adddate=datetime.datetime.now().strftime('%Y-%m-%d') for rs in rs1: #log(rs) if rs[3]<>'': if rs[3]==u'数据库已存在': try: #confsql.runSql("update delivery set adddate='"+adddate+"' where braid='"+rs[0]+"' and weekdelivery='"+rs[2]+"'") sqlstr ="delete from delivery where braid='"+rs[0]+"' and weekdelivery='"+rs[2]+"'; " sqlstr +=" insert into delivery(braid,weekdelivery,adddate) values('"+rs[0]+"','"+rs[2]+"','"+adddate+"') " confsql.runSql(sqlstr) rs[3]=u'插入成功!' except: rs[3]=u'插入失败!' else: res={} res['braid']=rs[0] res['braname']=rs[1] res['weekdelivery']=rs[2] res['adddate']=adddate res['info']=rs[3] result.append(res) else: try: sqlstr="insert into delivery(braid,weekdelivery,adddate) values('"+rs[0]+"','"+rs[2]+"','"+adddate+"')" confsql.runSql(sqlstr) rs[3]=u'插入成功!' except: rs[3]=u'插入失败!' res={} res['braid']=rs[0] res['braname']=rs[1] res['weekdelivery']=rs[2] res['adddate']=adddate res['info']=rs[3] result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def deleteData_basedisplay(request): '删除数据' result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"], itemlenth=0) if len(rs1) > 0: for rs in rs1: if rs[5] <> '': #出错信息的保留 res = {} res['braid'] = rs[0] res['braname'] = rs[1] res['proid'] = rs[2] res['proname'] = rs[3] res['basedisplay'] = rs[4] res['info'] = rs[5] result.append(res) else: try: sqlstr = u"delete from basedisplay where braid='" + rs[ 0] + "' and proid='" + rs[2] + "'" confsql.runSql(sqlstr) res = {} res['braid'] = rs[0] res['braname'] = rs[1] res['proid'] = rs[2] res['proname'] = rs[3] res['basedisplay'] = rs[4] res['info'] = u'删除成功!' result.append(res) except: res = {} res['braid'] = rs[0] res['braname'] = rs[1] res['proid'] = rs[2] res['proname'] = rs[3] res['basedisplay'] = rs[4] res['info'] = u'删除失败!' result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def deleteData_delivery(request): '删除数据' result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"],itemlenth=0) adddate=datetime.datetime.now().strftime('%Y-%m-%d') if len(rs1)>0: for rs in rs1: if rs[3]<>'': #出错信息的保留 res={} res['braid']=rs[0] res['braname']=rs[1] res['weekdelivery']=rs[2] res['adddate']=adddate res['info']=rs[3] result.append(res) else: try: sqlstr="delete from delivery where braid='"+rs[0]+"' and weekdelivery='"+rs[2]+"'" confsql.runSql(sqlstr) res={} res['braid']=rs[0] res['braname']=rs[1] res['weekdelivery']=rs[2] res['adddate']=adddate res['info']=u'删除成功!' result.append(res) except: res={} res['braid']=rs[0] res['braname']=rs[1] res['weekdelivery']=rs[2] res['adddate']=adddate res['info']=u'删除失败!' result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def deleteData_dhrules(request): '删除数据' result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"], itemlenth=0) if len(rs1) > 0: for rs in rs1: if rs[8] <> '': #出错信息的保留 res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['yqkey'] = rs[5] res['yqrule'] = rs[6] res['yqvalue'] = rs[7] res['info'] = rs[8] result.append(res) else: try: #sp, xl, zl, dl, null res = {} excode = rs[4] if rs[4] == u'商品代码': excode = 'sp' if rs[4] == u'小类代码': excode = 'xl' if rs[4] == u'中类代码': excode = 'zl' if rs[4] == u'大类代码': excode = 'dl' yqkey = rs[5] if rs[5] == u'上阈值': yqkey = 'maxlimit' if rs[5] == u'下阈值': yqkey = 'minlimit' sqlstr = u"delete from dhrules where mdcode='" + rs[ 0] + "' and xcode ='" + rs[ 2] + "' and excode='" + excode + "' and yqkey='" + yqkey + "'" #log(sqlstr) confsql.runSql(sqlstr) res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['yqkey'] = rs[5] res['yqrule'] = rs[6] res['yqvalue'] = rs[7] res['info'] = u'删除成功!' result.append(res) except: res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['yqkey'] = rs[5] res['yqrule'] = rs[6] res['yqvalue'] = rs[7] res['info'] = u'删除失败!' result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def deleteData_dhrulesYuzhi(request): '删除数据' result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"]) if len(rs1)>0: for rs in rs1: if rs[12]<>'': #出错信息的保留 res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['yqkey']=rs[5] res['yqrule']=rs[6] res['yqvalue']=rs[7] res['startdate']=rs[8] res['enddate']=rs[9] res['remark']=rs[10] res['adddate']=rs[11] res['info']=rs[12] result.append(res) else: #无出错信息的执行删除 try: excode=rs[4] if rs[4]==u'商品代码': excode='sp' if rs[4]==u'品牌小类代码': excode='braxl' if rs[4]==u'大类代码': excode='prodl' if rs[4]==u'中类代码': excode='prozl' if rs[4]==u'小类代码': excode='proxl' confsql.runSql("delete from dhrulesYuzhi where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[8]+"' and enddate = '" + rs[9] + "'") res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['yqkey']=rs[5] res['yqrule']=rs[6] res['yqvalue']=rs[7] res['startdate']=rs[8] res['enddate']=rs[9] res['remark']=rs[10] res['adddate']=rs[11] res['info']=u'删除成功!' result.append(res) except: res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['yqkey']=rs[5] res['yqrule']=rs[6] res['yqvalue']=rs[7] res['startdate']=rs[8] res['enddate']=rs[9] res['remark']=rs[10] res['adddate']=rs[11] res['info']=u'删除失败!' result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def save_dhrulesYuzhi(request): rs1=[] result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"]) for rs in rs1: excode=rs[4] if rs[4]==u'商品代码': excode='sp' if rs[4]==u'品牌小类代码': excode='braxl' if rs[4]==u'大类代码': excode='prodl' if rs[4]==u'中类代码': excode='prozl' if rs[4]==u'小类代码': excode='proxl' adddate = time.strftime("%Y-%m-%d", time.localtime()) if rs[10]<>'': if rs[10]==u'数据库已存在!': try: confsql.runSql(u"delete from dhrulesYuzhi where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[7]+"' and enddate = '" + rs[8] + "'") confsql.runSql(u"insert into dhrulesYuzhi (mdcode,xcode,excode,yqkey,yqrule,yqvalue,startdate,enddate,remark,adddate) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+rs[5]+"','相对值','"+rs[6]+"','"+rs[7]+"','"+rs[8]+"','"+adddate+"')") rs[10]=u'插入成功!' except: rs[10]=u'插入失败!' res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['yqkey']=rs[5] res['yqrule']=u"相对值" res['yqvalue']=rs[6] res['startdate']=rs[7] res['enddate']=rs[8] res['remark']=rs[9] res['info']=rs[10] result.append(res) else: #无误的 try: sqlstr=u"insert into dhrulesYuzhi (mdcode,xcode,excode,yqkey,yqrule,yqvalue,startdate,enddate,remark,adddate) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+rs[5]+"','"+u"相对值"+"','"+rs[6]+"','"+rs[7]+"','"+rs[8]+"','"+rs[9]+"','"+adddate+"')" confsql.runSql(sqlstr) rs[10]=u'插入成功!' except: rs[10]=u'插入失败!' res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['yqkey']=rs[5] res['yqrule']=u"相对值" res['yqvalue']=rs[6] res['startdate']=rs[7] res['enddate']=rs[8] res['remark']=rs[9] res['info']=rs[10] result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def save_dhPauserules(request): rs1=[] result=[] myjson=simplejson.loads(request.POST["myjson"].encode('utf8')) rs1=trim_csv(myjson["table"]) for rs in rs1: excode=rs[4] if rs[4]==u'商品代码': excode='sp' if rs[4]==u'小类代码': excode='xl' if rs[4]==u'中类代码': excode='zl' if rs[4]==u'大类代码': excode='dl' adddate = time.strftime("%Y-%m-%d", time.localtime()) if rs[7]<>'': if rs[7]==u'数据库已存在!': try: #confsql.runSql("update dhrules set yqrule='"+yqrule+"',yqvalue='"+rs[7]+"' where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and yqkey='"+yqkey+"'") #log("delete from dhpauserules where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[5]+"' and enddate = '" + rs[6] + "'") confsql.runSql("delete from dhpauserules where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[5]+"' and enddate = '" + rs[6] + "'") confsql.runSql("insert into dhpauserules (mdcode,xcode,excode,startdate, enddate, adddate) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+rs[5]+"','"+rs[6]+"','"+adddate+"')") rs[7]='插入成功!' except: rs[7]='插入失败!' res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['startdate']=rs[5] res['enddate']=rs[6] res['info']=rs[7] result.append(res) else: res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['startdate']=rs[5] res['enddate']=rs[6] res['info']=rs[7] result.append(res) else: #无误的 try: confsql.runSql("insert into dhpauserules (mdcode,xcode,excode,startdate, enddate, adddate) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+rs[5]+"','"+rs[6]+"','"+adddate+"')") rs[7]='插入成功!' except: rs[7]='插入失败!' res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['startdate']=rs[5] res['enddate']=rs[6] res['info']=rs[7] result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def deleteData_maxminCuxiaori(request): '删除数据' result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"]) if len(rs1) > 0: for rs in rs1: if rs[10] <> '': #出错信息的保留 res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['max_multiple'] = rs[5] res['min_multiple'] = rs[6] res['startdate'] = rs[7] res['enddate'] = rs[8] res['remark'] = rs[9] res['info'] = rs[10] result.append(res) else: try: #sp, xl, zl, dl, null excode = rs[4] if rs[4] == u'商品代码': excode = 'sp' if rs[4] == u'品牌小类代码': excode = 'braxl' if rs[4] == u'大类代码': excode = 'prodl' if rs[4] == u'中类代码': excode = 'prozl' if rs[4] == u'小类代码': excode = 'proxl' confsql.runSql( "delete from maxminCuxiaori where mdcode='" + rs[0] + "' and xcode='" + rs[2] + "' and excode='" + excode + "' and startdate='" + rs[7] + "' and enddate = '" + rs[8] + "'") res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['max_multiple'] = rs[5] res['min_multiple'] = rs[6] res['startdate'] = rs[7] res['enddate'] = rs[8] res['remark'] = rs[9] res['info'] = u'删除成功!' result.append(res) except: res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['max_multiple'] = rs[5] res['min_multiple'] = rs[6] res['startdate'] = rs[7] res['enddate'] = rs[8] res['remark'] = rs[9] res['info'] = u'删除失败!' result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def backup_maxmin(request): '备份上下限' if request.method=='POST': try: jlist=simplejson.loads(request.POST["jsonlist"]) if jlist['proid']<>'' or jlist['proname']<>'' or jlist['braid']<>'' or jlist['braname']<>'' or jlist['prodl']<>'' or jlist['prozl']<>'' or jlist['proxl']<>'': #不全为空 sqlstr=""" insert into maxmin_bak select braid,proid,maxval,minval,banben,startdate,enddate,adddate,'""" + datetime.date.today().strftime('%Y-%m-%d') + """' from( select * from ( select t1.braid,t2.braname,t1.proid,t3.proname,t3.prodl_id||'_'||t3.prodl as prodl,t3.prozl_id||'_'||t3.prozl as prozl,t3.proxl_id||'_'||t3.proxl as proxl,t1.maxval,t1.minval,t1.banben,t1.startdate,t1.enddate,t1.adddate from maxmin t1,branch t2,product_all t3 where t1.braid=t2.braid and t1.proid=t3.proid ) t1 where """ for j in jlist: if jlist[j]<>'': li=jlist[j].split(",") if len(li)==1: #一个条件 sqlstr+=j+" like '%%"+jlist[j].strip()+"%%' and " else: #逗号分隔的多条件 sqlstr+="(" for l in li: sqlstr+=j+" like '%%"+l.strip() +"%%' or " sqlstr=sqlstr[0:-4]+") and " sqlstr=sqlstr[0:-4] sqlstr+=") tt1" confsql.runSql(sqlstr) sqlstr=""" select count(*) from ( select t1.braid,t2.braname,t1.proid,t3.proname,t3.prodl_id||'_'||t3.prodl as prodl,t3.prozl_id||'_'||t3.prozl as prozl,t3.proxl_id||'_'||t3.proxl as proxl,t1.maxval,t1.minval,t1.banben,t1.startdate,t1.enddate,t1.adddate from maxmin t1,branch t2,product_all t3 where t1.braid=t2.braid and t1.proid=t3.proid ) t1 where """ for j in jlist: if jlist[j]<>'': li=jlist[j].split(",") if len(li)==1: #一个条件 sqlstr+=j+" like '%%"+jlist[j].strip()+"%%' and " else: #逗号分隔的多条件 sqlstr+="(" for l in li: sqlstr+=j+" like '%%"+l.strip() +"%%' or " sqlstr=sqlstr[0:-4]+") and " sqlstr=sqlstr[0:-4] result=confsql.runquery(sqlstr) for rs in result: num=rs[0] return HttpResponse(num) else: #全为空,查询所有 sqlstr=""" insert into maxmin_bak select braid,proid,maxval,minval,banben,startdate,enddate,adddate,'""" + datetime.date.today().strftime('%Y-%m-%d') + """' from maxmin """ confsql.runSql(sqlstr) sqlstr="select count(*) from maxmin" result=confsql.runquery(sqlstr) for rs in result: num=rs[0] return HttpResponse(num) except: return HttpResponse(0) else: t=get_template('mana1/backup_maxmin.html') html=t.render(Context()) return HttpResponse(html)
def deleteData_dhrules(request): '删除数据' result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"],itemlenth=0) if len(rs1)>0: for rs in rs1: if rs[8]<>'': #出错信息的保留 res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['yqkey']=rs[5] res['yqrule']=rs[6] res['yqvalue']=rs[7] res['info']=rs[8] result.append(res) else: try: #sp, xl, zl, dl, null res={} excode=rs[4] if rs[4]==u'商品代码': excode='sp' if rs[4]==u'小类代码': excode='xl' if rs[4]==u'中类代码': excode='zl' if rs[4]==u'大类代码': excode='dl' yqkey = rs[5] if rs[5]==u'上阈值': yqkey='maxlimit' if rs[5]==u'下阈值': yqkey='minlimit' sqlstr=u"delete from dhrules where mdcode='"+rs[0]+"' and xcode ='"+rs[2] +"' and excode='"+excode+"' and yqkey='"+yqkey+"'" #log(sqlstr) confsql.runSql(sqlstr) res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['yqkey']=rs[5] res['yqrule']=rs[6] res['yqvalue']=rs[7] res['info']=u'删除成功!' result.append(res) except: res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['yqkey']=rs[5] res['yqrule']=rs[6] res['yqvalue']=rs[7] res['info']=u'删除失败!' result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def deleteData_dhrulesYuzhi(request): '删除数据' result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"]) if len(rs1) > 0: for rs in rs1: if rs[12] <> '': #出错信息的保留 res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['yqkey'] = rs[5] res['yqrule'] = rs[6] res['yqvalue'] = rs[7] res['startdate'] = rs[8] res['enddate'] = rs[9] res['remark'] = rs[10] res['adddate'] = rs[11] res['info'] = rs[12] result.append(res) else: #无出错信息的执行删除 try: excode = rs[4] if rs[4] == u'商品代码': excode = 'sp' if rs[4] == u'品牌小类代码': excode = 'braxl' if rs[4] == u'大类代码': excode = 'prodl' if rs[4] == u'中类代码': excode = 'prozl' if rs[4] == u'小类代码': excode = 'proxl' confsql.runSql("delete from dhrulesYuzhi where mdcode='" + rs[0] + "' and xcode='" + rs[2] + "' and excode='" + excode + "' and startdate='" + rs[8] + "' and enddate = '" + rs[9] + "'") res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['yqkey'] = rs[5] res['yqrule'] = rs[6] res['yqvalue'] = rs[7] res['startdate'] = rs[8] res['enddate'] = rs[9] res['remark'] = rs[10] res['adddate'] = rs[11] res['info'] = u'删除成功!' result.append(res) except: res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['yqkey'] = rs[5] res['yqrule'] = rs[6] res['yqvalue'] = rs[7] res['startdate'] = rs[8] res['enddate'] = rs[9] res['remark'] = rs[10] res['adddate'] = rs[11] res['info'] = u'删除失败!' result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def save_dhrulesYuzhi(request): rs1 = [] result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"]) for rs in rs1: excode = rs[4] if rs[4] == u'商品代码': excode = 'sp' if rs[4] == u'品牌小类代码': excode = 'braxl' if rs[4] == u'大类代码': excode = 'prodl' if rs[4] == u'中类代码': excode = 'prozl' if rs[4] == u'小类代码': excode = 'proxl' adddate = time.strftime("%Y-%m-%d", time.localtime()) if rs[10] <> '': if rs[10] == u'数据库已存在!': try: confsql.runSql(u"delete from dhrulesYuzhi where mdcode='" + rs[0] + "' and xcode='" + rs[2] + "' and excode='" + excode + "' and startdate='" + rs[7] + "' and enddate = '" + rs[8] + "'") confsql.runSql( u"insert into dhrulesYuzhi (mdcode,xcode,excode,yqkey,yqrule,yqvalue,startdate,enddate,remark,adddate) values('" + rs[0] + "','" + rs[2] + "','" + excode + "','" + rs[5] + "','相对值','" + rs[6] + "','" + rs[7] + "','" + rs[8] + "','" + adddate + "')") rs[10] = u'插入成功!' except: rs[10] = u'插入失败!' res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['yqkey'] = rs[5] res['yqrule'] = u"相对值" res['yqvalue'] = rs[6] res['startdate'] = rs[7] res['enddate'] = rs[8] res['remark'] = rs[9] res['info'] = rs[10] result.append(res) else: #无误的 try: sqlstr = u"insert into dhrulesYuzhi (mdcode,xcode,excode,yqkey,yqrule,yqvalue,startdate,enddate,remark,adddate) values('" + rs[ 0] + "','" + rs[2] + "','" + excode + "','" + rs[ 5] + "','" + u"相对值" + "','" + rs[6] + "','" + rs[ 7] + "','" + rs[8] + "','" + rs[ 9] + "','" + adddate + "')" confsql.runSql(sqlstr) rs[10] = u'插入成功!' except: rs[10] = u'插入失败!' res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['yqkey'] = rs[5] res['yqrule'] = u"相对值" res['yqvalue'] = rs[6] res['startdate'] = rs[7] res['enddate'] = rs[8] res['remark'] = rs[9] res['info'] = rs[10] result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def save_product_gl_packetqty_rules(request): '保存商品配货单位规则' rs1=[] result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"]) #sp, xl, zl, dl, null for rs in rs1: excode=rs[2] if rs[2]==u'商品代码': excode='sp' if rs[2]==u'小类代码': excode='xl' if rs[2]==u'中类代码': excode='zl' if rs[2]==u'大类代码': excode='dl' if rs[4]<>'': if rs[4]==u'数据库已存在!': try: sqlstr="delete from product_gl_packetqty_rules where xcode='"+rs[0]+"' and excode='" + excode + "'" confsql.runSql(sqlstr) sqlstr="insert into product_gl_packetqty_rules (xcode,excode,packetqty1) values('"+rs[0]+"','"+excode+"','"+rs[3]+"')" confsql.runSql(sqlstr) rs[4]='插入成功!' except: rs[4]='插入失败!' res={} res['xcode']=rs[0] res['name']=rs[1] res['excode']=rs[2] res['packetqty1']=rs[3] res['info']=rs[4] result.append(res) else: res={} res['xcode']=rs[0] res['name']=rs[1] res['excode']=rs[2] res['packetqty1']=rs[3] res['info']=rs[4] result.append(res) else: try: sqlstr="insert into product_gl_packetqty_rules (xcode,excode,packetqty1) values('"+rs[0]+"','"+excode+"','"+rs[3]+"')" confsql.runSql(sqlstr) rs[4]='插入成功!' except: rs[4]='插入失败!' res={} res['xcode']=rs[0] res['name']=rs[1] res['excode']=rs[2] res['packetqty1']=rs[3] res['info']=rs[4] result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def save_product_gl_packetqty_rules(request): '保存商品配货单位规则' rs1 = [] result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"]) #sp, xl, zl, dl, null for rs in rs1: excode = rs[2] if rs[2] == u'商品代码': excode = 'sp' if rs[2] == u'小类代码': excode = 'xl' if rs[2] == u'中类代码': excode = 'zl' if rs[2] == u'大类代码': excode = 'dl' if rs[4] <> '': if rs[4] == u'数据库已存在!': try: sqlstr = "delete from product_gl_packetqty_rules where xcode='" + rs[ 0] + "' and excode='" + excode + "'" confsql.runSql(sqlstr) sqlstr = "insert into product_gl_packetqty_rules (xcode,excode,packetqty1) values('" + rs[ 0] + "','" + excode + "','" + rs[3] + "')" confsql.runSql(sqlstr) rs[4] = '插入成功!' except: rs[4] = '插入失败!' res = {} res['xcode'] = rs[0] res['name'] = rs[1] res['excode'] = rs[2] res['packetqty1'] = rs[3] res['info'] = rs[4] result.append(res) else: res = {} res['xcode'] = rs[0] res['name'] = rs[1] res['excode'] = rs[2] res['packetqty1'] = rs[3] res['info'] = rs[4] result.append(res) else: try: sqlstr = "insert into product_gl_packetqty_rules (xcode,excode,packetqty1) values('" + rs[ 0] + "','" + excode + "','" + rs[3] + "')" confsql.runSql(sqlstr) rs[4] = '插入成功!' except: rs[4] = '插入失败!' res = {} res['xcode'] = rs[0] res['name'] = rs[1] res['excode'] = rs[2] res['packetqty1'] = rs[3] res['info'] = rs[4] result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def save_dhPauserules(request): rs1 = [] result = [] myjson = simplejson.loads(request.POST["myjson"].encode('utf8')) rs1 = trim_csv(myjson["table"]) for rs in rs1: excode = rs[4] if rs[4] == u'商品代码': excode = 'sp' if rs[4] == u'小类代码': excode = 'xl' if rs[4] == u'中类代码': excode = 'zl' if rs[4] == u'大类代码': excode = 'dl' adddate = time.strftime("%Y-%m-%d", time.localtime()) if rs[7] <> '': if rs[7] == u'数据库已存在!': try: #confsql.runSql("update dhrules set yqrule='"+yqrule+"',yqvalue='"+rs[7]+"' where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and yqkey='"+yqkey+"'") #log("delete from dhpauserules where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[5]+"' and enddate = '" + rs[6] + "'") confsql.runSql("delete from dhpauserules where mdcode='" + rs[0] + "' and xcode='" + rs[2] + "' and excode='" + excode + "' and startdate='" + rs[5] + "' and enddate = '" + rs[6] + "'") confsql.runSql( "insert into dhpauserules (mdcode,xcode,excode,startdate, enddate, adddate) values('" + rs[0] + "','" + rs[2] + "','" + excode + "','" + rs[5] + "','" + rs[6] + "','" + adddate + "')") rs[7] = '插入成功!' except: rs[7] = '插入失败!' res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['startdate'] = rs[5] res['enddate'] = rs[6] res['info'] = rs[7] result.append(res) else: res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['startdate'] = rs[5] res['enddate'] = rs[6] res['info'] = rs[7] result.append(res) else: #无误的 try: confsql.runSql( "insert into dhpauserules (mdcode,xcode,excode,startdate, enddate, adddate) values('" + rs[0] + "','" + rs[2] + "','" + excode + "','" + rs[5] + "','" + rs[6] + "','" + adddate + "')") rs[7] = '插入成功!' except: rs[7] = '插入失败!' res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['startdate'] = rs[5] res['enddate'] = rs[6] res['info'] = rs[7] result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def save_dhrules(request): '保存订货量修改规则' rs1 = [] result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"]) for rs in rs1: excode = rs[4] if rs[4] == u'商品代码': excode = 'sp' if rs[4] == u'小类代码': excode = 'xl' if rs[4] == u'中类代码': excode = 'zl' if rs[4] == u'大类代码': excode = 'dl' yqkey = rs[5] if rs[5] == u'上阈值': yqkey = 'maxlimit' if rs[5] == u'下阈值': yqkey = 'minlimit' yqrule = rs[6] if rs[6] == u'绝对值': yqrule = 'jd' if rs[6] == u'相对值': yqrule = 'xd' if rs[8] <> '': if rs[8] == u'数据库已存在!': try: #confsql.runSql("update dhrules set yqrule='"+yqrule+"',yqvalue='"+rs[7]+"' where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and yqkey='"+yqkey+"'") confsql.runSql("delete from dhrules where mdcode='" + rs[0] + "' and xcode='" + rs[2] + "' and excode='" + excode + "' and yqkey='" + yqkey + "'") confsql.runSql( "insert into dhrules (mdcode,xcode,excode,yqkey,yqrule,yqvalue) values('" + rs[0] + "','" + rs[2] + "','" + excode + "','" + yqkey + "','" + yqrule + "','" + rs[7] + "')") rs[8] = '插入成功!' except: rs[8] = '插入失败!' res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['yqkey'] = rs[5] res['yqrule'] = rs[6] res['yqvalue'] = rs[7] res['info'] = rs[8] result.append(res) else: res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['yqkey'] = rs[5] res['yqrule'] = rs[6] res['yqvalue'] = rs[7] res['info'] = rs[8] result.append(res) else: #无误的 try: confsql.runSql( "insert into dhrules (mdcode,xcode,excode,yqkey,yqrule,yqvalue) values('" + rs[0] + "','" + rs[2] + "','" + excode + "','" + yqkey + "','" + yqrule + "','" + rs[7] + "')") rs[8] = '插入成功!' except: rs[8] = '插入失败!' res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['yqkey'] = rs[5] res['yqrule'] = rs[6] res['yqvalue'] = rs[7] res['info'] = rs[8] result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def deleteData_dhPauserules(request): '删除数据' result = [] myjson = simplejson.loads(request.POST["myjson"]) rs1 = trim_csv(myjson["table"], itemlenth=0) if len(rs1) > 0: for rs in rs1: if rs[7] <> '': #出错信息的保留 res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['startdate'] = rs[5] res['enddate'] = rs[6] res['info'] = rs[7] result.append(res) else: try: #sp, xl, zl, dl, null res = {} excode = rs[4] if rs[4] == u'商品代码': excode = 'sp' if rs[4] == u'小类代码': excode = 'xl' if rs[4] == u'中类代码': excode = 'zl' if rs[4] == u'大类代码': excode = 'dl' confsql.runSql("delete from dhpauserules where mdcode='" + rs[0] + "' and xcode='" + rs[2] + "' and excode='" + excode + "' and startdate='" + rs[5] + "' and enddate = '" + rs[6] + "'") res = {} res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['startdate'] = rs[5] res['enddate'] = rs[6] res['info'] = u'删除成功!' result.append(res) except: res['mdcode'] = rs[0] res['mdname'] = rs[1] res['xcode'] = rs[2] res['name'] = rs[3] res['excode'] = rs[4] res['startdate'] = rs[5] res['enddate'] = rs[6] res['info'] = u'删除失败!' result.append(res) jsonres = simplejson.dumps(result) return HttpResponse(jsonres)
def deleteData_dhPauserules(request): '删除数据' result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"],itemlenth=0) if len(rs1)>0: for rs in rs1: if rs[7]<>'': #出错信息的保留 res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['startdate']=rs[5] res['enddate']=rs[6] res['info']=rs[7] result.append(res) else: try: #sp, xl, zl, dl, null res={} excode=rs[4] if rs[4]==u'商品代码': excode='sp' if rs[4]==u'小类代码': excode='xl' if rs[4]==u'中类代码': excode='zl' if rs[4]==u'大类代码': excode='dl' confsql.runSql("delete from dhpauserules where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[5]+"' and enddate = '" + rs[6] + "'") res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['startdate']=rs[5] res['enddate']=rs[6] res['info']=u'删除成功!' result.append(res) except: res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['startdate']=rs[5] res['enddate']=rs[6] res['info']=u'删除失败!' result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def backup_maxmin(request): '备份上下限' if request.method == 'POST': try: jlist = simplejson.loads(request.POST["jsonlist"]) if jlist['proid'] <> '' or jlist['proname'] <> '' or jlist[ 'braid'] <> '' or jlist['braname'] <> '' or jlist[ 'prodl'] <> '' or jlist['prozl'] <> '' or jlist[ 'proxl'] <> '': #不全为空 sqlstr = """ insert into maxmin_bak select braid,proid,maxval,minval,banben,startdate,enddate,adddate,'""" + datetime.date.today( ).strftime('%Y-%m-%d') + """' from( select * from ( select t1.braid,t2.braname,t1.proid,t3.proname,t3.prodl_id||'_'||t3.prodl as prodl,t3.prozl_id||'_'||t3.prozl as prozl,t3.proxl_id||'_'||t3.proxl as proxl,t1.maxval,t1.minval,t1.banben,t1.startdate,t1.enddate,t1.adddate from maxmin t1,branch t2,product_all t3 where t1.braid=t2.braid and t1.proid=t3.proid ) t1 where """ for j in jlist: if jlist[j] <> '': li = jlist[j].split(",") if len(li) == 1: #一个条件 sqlstr += j + " like '%%" + jlist[j].strip( ) + "%%' and " else: #逗号分隔的多条件 sqlstr += "(" for l in li: sqlstr += j + " like '%%" + l.strip( ) + "%%' or " sqlstr = sqlstr[0:-4] + ") and " sqlstr = sqlstr[0:-4] sqlstr += ") tt1" confsql.runSql(sqlstr) sqlstr = """ select count(*) from ( select t1.braid,t2.braname,t1.proid,t3.proname,t3.prodl_id||'_'||t3.prodl as prodl,t3.prozl_id||'_'||t3.prozl as prozl,t3.proxl_id||'_'||t3.proxl as proxl,t1.maxval,t1.minval,t1.banben,t1.startdate,t1.enddate,t1.adddate from maxmin t1,branch t2,product_all t3 where t1.braid=t2.braid and t1.proid=t3.proid ) t1 where """ for j in jlist: if jlist[j] <> '': li = jlist[j].split(",") if len(li) == 1: #一个条件 sqlstr += j + " like '%%" + jlist[j].strip( ) + "%%' and " else: #逗号分隔的多条件 sqlstr += "(" for l in li: sqlstr += j + " like '%%" + l.strip( ) + "%%' or " sqlstr = sqlstr[0:-4] + ") and " sqlstr = sqlstr[0:-4] result = confsql.runquery(sqlstr) for rs in result: num = rs[0] return HttpResponse(num) else: #全为空,查询所有 sqlstr = """ insert into maxmin_bak select braid,proid,maxval,minval,banben,startdate,enddate,adddate,'""" + datetime.date.today( ).strftime('%Y-%m-%d') + """' from maxmin """ confsql.runSql(sqlstr) sqlstr = "select count(*) from maxmin" result = confsql.runquery(sqlstr) for rs in result: num = rs[0] return HttpResponse(num) except: return HttpResponse(0) else: t = get_template('mana1/backup_maxmin.html') html = t.render(Context()) return HttpResponse(html)
def save_dhrules(request): '保存订货量修改规则' rs1=[] result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"]) for rs in rs1: excode=rs[4] if rs[4]==u'商品代码': excode='sp' if rs[4]==u'小类代码': excode='xl' if rs[4]==u'中类代码': excode='zl' if rs[4]==u'大类代码': excode='dl' yqkey = rs[5] if rs[5]==u'上阈值': yqkey='maxlimit' if rs[5]==u'下阈值': yqkey='minlimit' yqrule = rs[6] if rs[6]==u'绝对值': yqrule='jd' if rs[6]==u'相对值': yqrule='xd' if rs[8]<>'': if rs[8]==u'数据库已存在!': try: #confsql.runSql("update dhrules set yqrule='"+yqrule+"',yqvalue='"+rs[7]+"' where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and yqkey='"+yqkey+"'") confsql.runSql("delete from dhrules where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and yqkey='"+yqkey+"'") confsql.runSql("insert into dhrules (mdcode,xcode,excode,yqkey,yqrule,yqvalue) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+yqkey+"','"+yqrule+"','"+rs[7]+"')") rs[8]='插入成功!' except: rs[8]='插入失败!' res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['yqkey']=rs[5] res['yqrule']=rs[6] res['yqvalue']=rs[7] res['info']=rs[8] result.append(res) else: res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['yqkey']=rs[5] res['yqrule']=rs[6] res['yqvalue']=rs[7] res['info']=rs[8] result.append(res) else: #无误的 try: confsql.runSql("insert into dhrules (mdcode,xcode,excode,yqkey,yqrule,yqvalue) values('"+rs[0]+"','"+rs[2]+"','"+excode+"','"+yqkey+"','"+yqrule+"','"+rs[7]+"')") rs[8]='插入成功!' except: rs[8]='插入失败!' res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['yqkey']=rs[5] res['yqrule']=rs[6] res['yqvalue']=rs[7] res['info']=rs[8] result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)
def deleteData_maxminCuxiaori(request): '删除数据' result=[] myjson=simplejson.loads(request.POST["myjson"]) rs1=trim_csv(myjson["table"]) if len(rs1)>0: for rs in rs1: if rs[10]<>'': #出错信息的保留 res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['max_multiple']=rs[5] res['min_multiple']=rs[6] res['startdate']=rs[7] res['enddate']=rs[8] res['remark']=rs[9] res['info']=rs[10] result.append(res) else: try: #sp, xl, zl, dl, null excode=rs[4] if rs[4]==u'商品代码': excode='sp' if rs[4]==u'品牌小类代码': excode='braxl' if rs[4]==u'大类代码': excode='prodl' if rs[4]==u'中类代码': excode='prozl' if rs[4]==u'小类代码': excode='proxl' confsql.runSql("delete from maxminCuxiaori where mdcode='"+rs[0]+"' and xcode='" +rs[2]+ "' and excode='"+excode+"' and startdate='"+rs[7]+"' and enddate = '" + rs[8] + "'") res={} res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['max_multiple']=rs[5] res['min_multiple']=rs[6] res['startdate']=rs[7] res['enddate']=rs[8] res['remark']=rs[9] res['info']=u'删除成功!' result.append(res) except: res['mdcode']=rs[0] res['mdname']=rs[1] res['xcode']=rs[2] res['name']=rs[3] res['excode']=rs[4] res['max_multiple']=rs[5] res['min_multiple']=rs[6] res['startdate']=rs[7] res['enddate']=rs[8] res['remark']=rs[9] res['info']=u'删除失败!' result.append(res) jsonres=simplejson.dumps(result) return HttpResponse(jsonres)