前往Shuct.Net首页

Shudepb PB反编译专家长时间以来,为业内同类软件事实上的唯一选择.细节,彰显专业.态度,决定品质.

关于PB反编译的搜索

长益商友查询库重汇数据_侠客天空——pb开发长益商友技术交流_百度空间 相册 广场游戏 登录注册 关注此空间 侠客天空——pb开发长益商友技术交流欢迎访问我们的官方站点:http://www.xkerp.com QQ群:31329369 2010-10-23 10:50 长益商友查询库重汇数据 本人提供sybase技术支持以及Sqlserver数据库技术支持、错误处理、灾难恢复!提供长益商友pb9.0二次开发、pb版连锁超市(前台pos、后台mis)、PB反编译,满意后付款!如需要,请QQ联系:356179407。关键字:连锁超市管理软件 商友二次开发 商友BI销售分析查询库重汇数据====2010.9.30至2010.10.4查询库报表不正确调整=1、生成该时间段的临时报表SELECT DEPTID, DEPTID_JH ,HSFS,SUM(JCJE_SQ) JCJE_SQ,SUM(JHJE) JHJE,SUM(BRJE) BRJE,SUM(TJZZJE) TJZZJE,SUM(CYJE) CYJE,SUM(XSJE) XSJE,SUM(XSJE_BHS) XSJE_BHS,SUM(XSJE_PF) XSJE_PF,SUM(XSJE_PF_BHS) XSJE_PF_BHS,SUM(ZKJE) ZKJE,SUM(XSCB) XSCB,SUM(XSCB_PF) XSCB_PF,SUM(WRZXSJE) WRZXSJE,SUM(BCJE) BCJE,SUM(JJJZJE) JJJZJE,SUM(THJE) THJE,SUM(DQJE) DQJE,SUM(JCJE) JCJE,SUM(XSTHJE) XSTHJE,SUM(WRZZKJE) WRZZKJE,SUM(WRZYHJE) WRZYHJE,SUM(YHJE) YHJE,SUM(ZKFTJE) ZKFTJE,SUM(XSYYJE) XSYYJE,SUM(QT_ZKFT) QT_ZKFT,SUM(PYJE) PYJE,SUM(PKJE) PKJE,SUM(JCJE_SS) JCJE_SS,SUM(XSJE_CX) XSJE_CX,SUM(XSCB_CX) XSCB_CX INTO PS_GZJXCFROM GZJXCR WHERE RQ >= '2010.9.30' AND RQ<='2010.10.4' GROUP BY DEPTID, DEPTID_JH ,HSFS AT ISOLATION 0SELECT DEPTID ,HSFS ,DEPTID_JH , JXCXM , SUM(JE17) JE17,SUM(SJ17) SJ17,SUM(JE13) JE13,SUM(SJ13) SJ13,SUM(JEQT) JEQT,SUM(SJQT) SJQT INTO PS_GZJXCSJ FROM GZJXCSJR WHERE RQ >= '2010.9.30' AND RQ<='2010.10.4' GROUP BY DEPTID ,HSFS ,DEPTID_JH , JXCXMAT ISOLATION 0SELECT DEPTID, SPFL,SB,GHDW,CGY,HSFS,SUM(JHSL) JHSL,SUM(JHJE) JHJE,SUM(JHJE_HS) JHJE_HS,SUM(BSSL) BSSL,SUM(BSJE) BSJE,SUM(XSSL) XSSL,SUM(XSCB) XSCB,SUM(XSJE) XSJE,SUM(XSJE_BHS) XSJE_BHS,SUM(ZKJE) ZKJE,SUM(BRSL) BRSL,SUM(BRJE) BRJE,SUM(THSL) THSL,SUM(THJE) THJE,SUM(JSSL) JSSL,SUM(JSJE) JSJE,SUM(BJCE) BJCE,SUM(JCSL) JCSL,SUM(JCJE) JCJE,SUM(XSSL_PF) XSSL_PF,SUM(XSJE_PF) XSJE_PF,SUM(XSCB_PF) XSCB_PF,SUM(WRZXSSL) WRZXSSL,SUM(WRZXSJE) WRZXSJE,SUM(XSCB_HS) XSCB_HS,SUM(XSCB_PFHS) XSCB_PFHS into PS_SPZHSJFROM SPZHSJR201010 WHERE RQ >= '2010.9.30' AND RQ<='2010.10.4' GROUP BY DEPTID, SPFL,SB,GHDW,CGY,HSFSAT ISOLATION 0SELECT * FROM PS_GHDWJXCSELECT COUNT(*) FROM PS_GZJXCSJ --143522、从月报表里减去临时报表的数据BEGIN TRAN UPDATE GHDWJXCY SET B.JHJE_JJ=B.JHJE_JJ-A.JHJE_JJ, B.THJE_JJ=B.THJE_JJ-A.THJE_JJ, B.BRJE_JJ=B.BRJE_JJ-A.BRJE_JJ, B.BJZRJE_JJ=B.BJZRJE_JJ-A.BJZRJE_JJ,B.BSJE_JJ=B.BSJE_JJ-A.BSJE_JJ, B.XSCB=B.XSCB-A.XSCB, B.XSJE =B.XSJE-A.XSJE, B.XSJE_BHS=B.XSJE_BHS-A.XSJE_BHS, B.JSJE =B.JSJE-A.JSJE, B.CJFTJE=B.CJFTJE-A.CJFTJE,B.YHJE =B.YHJE-A.YHJE, B.JCJE_JJ=B.JCJE_JJ-A.JCJE_JJ, B.ZKJE=B.ZKJE-A.ZKJE, B.XSCB_HS=B.XSCB_HS-A.XSCB_HS, B.SJ_17=B.SJ_17-A.SJ_17, B.SJ_13=B.SJ_13-A.SJ_13,B.JCJE_HS =B.JCJE_HS-A.JCJE_HS, B.QT_ZKFT=B.QT_ZKFT-A.QT_ZKFTFROM PS_GHDWJXC A,GHDWJXCY B WHERE A.DEPTID=B.DEPTID AND A.DEPTID_JH=B.DEPTID_JH AND A.HTH=B.HTH AND A.CODE=B.CODE AND A.HSFS=B.HSFS AND B.YEARMONTH=201010UPDATE GZJXCY SET B.JHJE =B.JHJE -A.JHJE ,B.BRJE =B.BRJE-A.BRJE, B.TJZZJE=B.TJZZJE-A.TJZZJE, B.CYJE=B.CYJE-A.CYJE,B.XSJE= B.XSJE-A.XSJE,B.XSJE_BHS=B.XSJE_BHS-A.XSJE_BHS, B.XSJE_PF=B.XSJE_PF-A.XSJE_PF,B.XSJE_PF_BHS =B.XSJE_PF_BHS-A.XSJE_PF_BHS, B.ZKJE=B.ZKJE-A.ZKJE, B.XSCB=B.XSCB-A.XSCB, B.XSCB_PF=B.XSCB_PF-A.XSCB_PF,B.WRZXSJE=B.WRZXSJE-A.WRZXSJE, B.BCJE =B.BCJE-A.BCJE, B.JJJZJE =B.JJJZJE-A.JJJZJE, B.THJE =B.THJE-A.THJE, B.DQJE =B.DQJE-A.DQJE,B.XSTHJE =B.XSTHJE-A.XSTHJE, B.WRZZKJE =B.WRZZKJE-A.WRZZKJE, B.WRZYHJE=B.WRZYHJE-A.WRZYHJE, B.YHJE =B.YHJE-A.YHJE, B.ZKFTJE =B.ZKFTJE-A.ZKFTJE,B.XSYYJE =B.XSYYJE-A.XSYYJE, B.QT_ZKFT =B.QT_ZKFT-A.QT_ZKFT, B.PYJE =B.PYJE-A.PYJE, B.PKJE =B.PKJE-A.PKJE, B.XSJE_CX =B.XSJE_CX-A.XSJE_CX, B.XSCB_CX=B.XSCB_CX-A.XSCB_CXFROM PS_GZJXC A,GZJXCY B WHERE A.DEPTID=B.DEPTID AND A.DEPTID_JH=B.DEPTID_JH AND A.HSFS=B.HSFS AND B.YEARMONTH=201010UPDATE GZJXCSJY SET B.JE17=B.JE17-A.JE17,B.SJ17 =B.SJ17-A.SJ17,B.JE13=B.JE13-A.JE13,B.SJ13=B.SJ13-A.SJ13,B.JEQT=B.JEQT-A.JEQT,B.SJQT=B.SJQT-A.SJQTFROM PS_GZJXCSJ A,GZJXCSJY B WHERE A.DEPTID=B.DEPTID AND A.DEPTID_JH=B.DEPTID_JH AND A.HSFS=B.HSFS AND A.JXCXM=B.JXCXM AND B.YEARMONTH=201010UPDATE SPZHSJY SET B.JHSL=B.JHSL-A.JHSL,B.JHJE=B.JHJE-A.JHJE,B.BSSL =B.BSSL-A.BSSL,B.BSJE=B.BSJE-A.BSJE,B.XSSL =B.XSSL-A.XSSL,B.XSCB=B.XSCB-A.XSCB,B.XSJE =B.XSJE-A.XSJE,B.XSJE_BHS =B.XSJE_BHS-A.XSJE_BHS,B.ZKJE =B.ZKJE-A.ZKJE,B.BRSL =B.BRSL-A.BRSL,B.BRJE =B.BRJE-A.BRJE,B.THSL=B.THSL-A.THSL,B.THJE =B.THJE-A.THJE,B.JSSL =B.JSSL-A.JSSL,B.JSJE =B.JSJE-A.JSJE,B.BJCE =B.BJCE-A.BJCE,B.XSSL_PF=B.XSSL_PF-A.XSSL_PF,B.XSJE_PF =B.XSJE_PF-A.XSJE_PF,B.XSCB_PF =B.XSCB_PF-A.XSCB_PF,B.JHJE_HS=B.JHJE_HS-A.JHJE_HS,B.WRZXSSL=B.WRZXSSL-A.WRZXSSL,B.WRZXSJE =B.WRZXSJE-A.WRZXSJE,B.XSCB_HS =B.XSCB_HS-A.XSCB_HS,B.XSCB_PFHS=B.XSCB_PFHS-A.XSCB_PFHSFROM PS_SPZHSJ A,SPZHSJY B WHERE A.DEPTID=B.DEPTID AND A.SPFL=B.SPFL AND A.SB=B.SB AND A.GHDW=B.GHDW AND A.CGY=B.CGY AND A.HSFS=B.HSFS AND B.NIANYUE=201010COMMIT3、查询库CREATE TABLE RCL_HIS AND RCLSJ_HIS create table dbo.RCL_HIS (RQ datetime not null,LIBID smallint not null,OPERATOR_ID int null,PROC_KSSJ datetime null,PROC_JSSJ datetime null,STATION_ID varchar(3) null,STATUS smallint not null,constraint PK_RCL_HIS PRIMARY KEY CLUSTERED ( RQ, LIBID ))gocreate table dbo.RCLSJ_HIS (RQ datetime not null,LIBID smallint not null,ID smallint not null,KSSJ datetime null,JSSJ datetime null,constraint PK_RCLSJ_HIS PRIMARY KEY CLUSTERED ( RQ, LIBID, ID ))go3、更换数据处理,业务库和查询库两者分开4、select * from RCL_HIS WHERE RQ >= '2010.9.30' AND RQ<='2010.10.4' select * from RCLSJ_HIS WHERE RQ >= '2010.9.30' AND RQ<='2010.10.4' AND ID>21UPDATE RCL_HIS SET STATUS=21 WHERE RQ >= '2010.9.30' AND RQ<='2010.10.4' DELETE RCLSJ_HIS WHERE RQ >= '2010.9.30' AND RQ<='2010.10.4' AND ID>215、删除错误数据begin trandelete from GZJXCR where RQ >= '2010.9.30' AND RQ<='2010.10.4'delete from GZJXCSJR where RQ >= '2010.9.30' AND RQ<='2010.10.4'delete from SPZHSJR201010 where RQ >= '2010.9.30' AND RQ<='2010.10.4'delete from SPFLJXCR where RQ >= '2010.9.30' AND RQ<='2010.10.4'delete from GHDWJXCR where RQ >= '2010.9.30' AND RQ<='2010.10.4'DELETE from SPJYJDBB where RQ >= '2010.9.30' AND RQ<='2010.10.4'commitINSERT INTO SPJXCRSELECT * FROM SPJXCR201010 where RQ >= '2010.9.30' AND RQ<='2010.10.4'DELETE FROM SPJXCR201010 where RQ >= '2010.9.30' AND RQ<='2010.10.4'SELECT * FROM SPJXCR where RQ >= '2010.10.5' AND RQ<='2010.10.4' AND DEPTID LIKE '0403%'(1190101 row(s) affected)--6、重新汇总数据查询数据处理窗口选择日期手工点击日处理7、删除门店报表,发送到队列delete from GHDWJXCR WHERE RQ>='2010.9.30' AND RQ<='2010.10.4'delete from GZJXCR WHERE RQ>='2010.9.30' AND RQ<='2010.10.4'delete from SPFLJXCR WHERE RQ>='2010.9.30' AND RQ<='2010.10.4'delete from SPJYJDBB WHERE RQ>='2010.9.30' AND RQ<='2010.10.4'delete from SPZHSJR WHERE RQ>='2010.9.30' AND RQ<='2010.10.4'总结:1、将数据不对天数生成临时表,从月报表里减去,重新生成报表,月报表也就对了,但结存和期初库存不能这么做,目前还没有想到好办法,抛砖引玉,望有高人能解决这个问题。2、虽然没有什么技术高招,但必须要绝对的细心,无论眼睛有多小,必须挣得大大的,字段太多且过于枯燥写SQL慎用粘贴复制。 #长益商友erp v6 分享到: 举报 浏览(173) 评论 转载 你可能也喜欢 心蓝手制私房菜【阳春雪白豆浆】——曲高为何和寡 【碗里_吃货】第一百一十四波——豆腐鸡肉饼 开学开心 养颜补气血的家传汤谱——鸡汤煲 南京的怪菜之一——活珠子 《空间周刊》2014年第2期(总第22期) 广电关于如何干扰卫星电视的内部教材 评论 帮助中心 | 空间客服 | 投诉中心 | 空间协议&copy;2014 Baidu