当前位置: 首页 > news >正文

20170118修改商品流水

备份表 fr_spls_rkbak20170118  fr_wlzhkkbak20170118   fr_spls_ckbak20170118


update spls_rk set jcshl=300,jcje=1210.26 where plh='Z0001270771'

update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00007796' and djbh in ('JHAYMA00022870','JHCYMA00003021')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00007796' and djbh in ('JHAYMA00022870','JHCYMA00003021')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00007796' and djbh in ('JHAYMA00022870','JHCYMA00003021')

update wlzhk set jfje=jfje+1416,ye=ye+1416 where djbh='JHCYMA00003021' 

update wlzhk set ye=ye+1416 where djbh in ('JHCYMA00003025','JHCYMA00003024','JHCYMA00003023','JHCYMA00003022')

update wlzhk set dwbh='EWI00000129' where djbh='JHAYMA00022870'




update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00007445' and djbh in ('JHAYMA00022871','JHCYMA00003032')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00007445' and djbh in ('JHAYMA00022871','JHCYMA00003032')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00007445' and djbh in ('JHAYMA00022871','JHCYMA00003032')


update wlzhk set jfje=jfje+1368,ye=ye+1368 where djbh='JHCYMA00003032' 

update wlzhk set dwbh='EWI00000134' where djbh='JHAYMA00022871'




update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00007474' and djbh in ('JHCYMA00003019','JHAYMA00022872')


update spls_rk set jcshl=300,jcje=756.41 where plh='Z0001270775'

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00007474' and djbh in ('JHCYMA00003019','JHAYMA00022872')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00007474' and djbh in ('JHCYMA00003019','JHAYMA00022872')

update wlzhk set ye=ye+885 where djbh in ('JHCYMA00003025','JHCYMA00003024','JHCYMA00003023','JHCYMA00003022','JHCYMA00003021','JHCYMA00003020')

update wlzhk set dwbh='EWI00000129' where djbh in ('JHCYMA00003019','JHAYMA00022872')




update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00007827' and djbh in ('JHCYMA00002981','JHAYMA00022861')


update spls_rk set jcshl=180,jcje=153.86 where plh='Z0001270697'

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00007827' and djbh in ('JHCYMA00002981','JHAYMA00022861')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00007827' and djbh in ('JHCYMA00002981','JHAYMA00022861')

update wlzhk set ye=ye+180 where djbh in ('JHAYMA00022860','JHAYMA00022859','JHAYMA00022677','JHAYMA00022461','JHAYMA00022334','JHAYMA00022333','JHAYMA00022332','JHAYMA00022331','JHAYMA00022330','JHDYMA00005335','JHDYMA00005332','JHDYMA00005238','JHDYMA00005237','JHAYMA00021923','JHCYMA00002992','JHCYMA00002991','JHCYMA00002990','JHCYMA00002989','JHCYMA00002988','JHCYMA00002987','JHCYMA00002986','JHCYMA00002985','JHCYMA00002984','JHCYMA00002983','JHCYMA00002982')

update wlzhk set dwbh='EWI00000127' where djbh in ('JHCYMA00002981','JHAYMA00022861')



update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00004840' and djbh in ('JHCYMA00002879','JHAYMA00022873')


update spls_rk set jcshl=jcshl+360,jcje=jcje+1261.54 where plh in ('Z0001270683','Z0001270420')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00004840' and djbh in ('JHCYMA00002879','JHAYMA00022873')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00004840' and djbh in ('JHCYMA00002879','JHAYMA00022873')

update wlzhk set ye=ye+1476 where djbh in ('JHAYMA00022442','JHAYMA00022441','JHAYMA00022440','JHAYMA00022439','JHDYMA00005308','JHAYMA00021904','JHCYMA00002887','JHCYMA00002885','JHCYMA00002880')

update wlzhk set dwbh='EWI00000123' where djbh in ('JHCYMA00002879','JHAYMA00022873')




update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00006244' and djbh in ('JHCYMA00003286','JHAYMA00022874')


update spls_rk set jcshl=jcshl+480,jcje=jcje+11076.92 where plh in ('Z0001271339')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00006244' and djbh in ('JHCYMA00003286','JHAYMA00022874')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00006244' and djbh in ('JHCYMA00003286','JHAYMA00022874')

update wlzhk set ye=ye+12960.00 where djbh in ('JHCYMA00003287','JHCYMA00003666')

update wlzhk set dwbh='EWI00000151' where djbh in ('JHCYMA00003286','JHAYMA00022874')



update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00007572' and djbh in ('JHCYMA00002913','JHAYMA00022875')


update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00007572' and djbh in ('JHCYMA00002913','JHAYMA00022875')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00007572' and djbh in ('JHCYMA00002913','JHAYMA00022875')

update wlzhk set dwbh='EWI00004202' where djbh in ('JHCYMA00002913','JHAYMA00022875')



update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00005430' and djbh in ('JHCYMA00002915','JHAYMA00022876')

update spls_rk set jcshl=jcshl+900,jcje=jcje+769.23 where plh in ('Z0001272546')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00005430' and djbh in ('JHCYMA00002915','JHAYMA00022876')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00005430' and djbh in ('JHCYMA00002915','JHAYMA00022876')

update wlzhk set ye=ye+900 where djbh in ('JHBYMA00000149','JHCYMA00003697','JHDYMA00005170','JHCYMA00003514','JHCYMA00003513','JHCYMA00003512','JHCYMA00003511','JHCYMA00003510','JHCYMA00003509','JHCYMA00003508','JHCYMA00003507','JHCYMA00003506','JHCYMA00003505','JHCYMA00003503','JHCYMA00003499','JHCYMA00003497','JHCYMA00003496','JHCYMA00003494','JHCYMA00003493','JHCYMA00003492','JHCYMA00003491','JHCYMA00003490','JHCYMA00003489','JHCYMA00003488','JHCYMA00003487','JHCYMA00003486','JHCYMA00003485','JHCYMA00003484','JHCYMA00003481','JHCYMA00003479','JHCYMA00003478','JHCYMA00003477','JHCYMA00003476','JHCYMA00003475','JHCYMA00003474','JHCYMA00003473','JHCYMA00003472','JHCYMA00003471','JHCYMA00003470','JHCYMA00003462')

update wlzhk set dwbh='EWI00000162' where djbh in ('JHCYMA00002915','JHAYMA00022876')



update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00005896' and djbh in ('JHCYMA00002863','JHAYMA00022877')

update spls_rk set jcshl=jcshl+1000,jcje=jcje+10427.35 where plh in ('Z0001270635','Z0001270387')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00005896' and djbh in ('JHCYMA00002863','JHAYMA00022877')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00005896' and djbh in ('JHCYMA00002863','JHAYMA00022877')

update wlzhk set ye=ye+12200 where djbh in ('JHCYMA00002864')

update wlzhk set dwbh='EWI00001856' where djbh in ('JHCYMA00002863','JHAYMA00022877')


update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00002828' and djbh in ('JHCYMA00002844','JHCYMA00002848','JHAYMA00022878')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00002828' and djbh in ('JHCYMA00002844','JHCYMA00002848','JHAYMA00022878')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00002828' and djbh in ('JHCYMA00002844','JHCYMA00002848','JHAYMA00022878')

update wlzhk set dwbh='EWI00001654' where djbh in ('JHCYMA00002844','JHCYMA00002848','JHAYMA00022878')


update spls_rk set spid=replace(spid,'SPH','APH') where spid='SPH00000404' and djbh in ('JHCYMA00002907','JHAYMA00022879')

update spls_rk set jcshl=jcshl+4680,jcje=jcje+40000 where plh in ('Z0001270483','Z0001270481','Z0001270479','Z0001270477')

update mxysyf set spid=replace(spid,'SPH','APH') where spid='SPH00000404' and djbh in ('JHCYMA00002907','JHAYMA00022879')

update jh_rkmx set spid=replace(spid,'SPH','APH') where spid='SPH00000404' and djbh in ('JHCYMA00002907','JHAYMA00022879')

update wlzhk set ye=ye+46800 where djbh in ('JHCYMA00002911','JHCYMA00002910','JHCYMA00002909','JHCYMA00002908')

update wlzhk set dwbh='EWI00000109' where djbh in ('JHCYMA00002907','JHAYMA00022879')



本文转自 qvodnet 51CTO博客,原文链接:http://blog.51cto.com/bks2015/1892979

相关文章:

  • 如何轻松运维,你是救火队员还是工程师?
  • CentOS6.7 mysql 主从配置
  • Zookeeper的zoo.cfg的配置
  • 编写一个简单通用的makefile
  • ORA-00119: invalid specification for system parameter REMOTE_LISTENER
  • bootstrap-水平表单
  • MYSQL数据库字符编码设置
  • 网站测试自动化系统—数据驱动测试
  • LeetCode169. Majority Element C语言
  • CCNP综合实验2
  • *1 计算机基础和操作系统基础及几大协议
  • 没有ARM开发板一样移植uboot并用SKYEYE仿真
  • 如何通过httpclient获取访问域名的真实ip
  • NET客户端js调用服务器端控件的方法
  • 4周第5次课 zip压缩工具 tar打包 打包并压缩
  • 《用数据讲故事》作者Cole N. Knaflic:消除一切无效的图表
  • android图片蒙层
  • chrome扩展demo1-小时钟
  • css系列之关于字体的事
  • ES6系列(二)变量的解构赋值
  • fetch 从初识到应用
  • JAVA_NIO系列——Channel和Buffer详解
  • mysql 5.6 原生Online DDL解析
  • Rancher如何对接Ceph-RBD块存储
  • React 快速上手 - 07 前端路由 react-router
  • spring boot 整合mybatis 无法输出sql的问题
  • SpringBoot几种定时任务的实现方式
  • vue--为什么data属性必须是一个函数
  • 初识 webpack
  • 构建工具 - 收藏集 - 掘金
  • 基于Android乐音识别(2)
  • 开发基于以太坊智能合约的DApp
  • 罗辑思维在全链路压测方面的实践和工作笔记
  • 前端技术周刊 2019-01-14:客户端存储
  • 使用权重正则化较少模型过拟合
  • 事件委托的小应用
  • 微信小程序开发问题汇总
  • 详解移动APP与web APP的区别
  • 消息队列系列二(IOT中消息队列的应用)
  • 智能情侣枕Pillow Talk,倾听彼此的心跳
  • ​ArcGIS Pro 如何批量删除字段
  • ​iOS实时查看App运行日志
  • ​卜东波研究员:高观点下的少儿计算思维
  • ​云纳万物 · 数皆有言|2021 七牛云战略发布会启幕,邀您赴约
  • (day6) 319. 灯泡开关
  • (libusb) usb口自动刷新
  • (ros//EnvironmentVariables)ros环境变量
  • (八)c52学习之旅-中断实验
  • (考研湖科大教书匠计算机网络)第一章概述-第五节1:计算机网络体系结构之分层思想和举例
  • (原创) cocos2dx使用Curl连接网络(客户端)
  • (转)3D模板阴影原理
  • (转载)深入super,看Python如何解决钻石继承难题
  • .[backups@airmail.cc].faust勒索病毒的最新威胁:如何恢复您的数据?
  • .libPaths()设置包加载目录
  • .NET 使用 JustAssembly 比较两个不同版本程序集的 API 变化