《标准版本更新记录_1_》由会员分享,可在线阅读,更多相关《标准版本更新记录_1_(7页珍藏版)》请在金锄头文库上搜索。
1、标准版本更新记录目录首营审批增加营业执照年检日期 .1KSOA 错误修复 .2KSOA 日清错误修复 .3KSOA 日清错误修复 .4KSOA 商品滞销查询更新 .6KSOA 调价计划(总部) .6首营审批增加营业执照年检日期更新日期:2013-09-24 更新人:张建申请日期:2013-09-18 申请人:唐建平客户:泰州华为、无锡锡新申请原因:首营审批增加营业执照年检日期适用版本:CCERP、KSOA确认日期: 确认人:1. 增加字段if not exists(select b.*,a.* from sysobjects a,syscolumns b where a.name=mchk a
2、nd a.id=b.id and b.name=ngsp_yyzznjrq)alter table mchk add ngsp_yyzznjrq char(10) null default ;delete from tbstru where tbname=mchk and fdname=ngsp_yyzznjrq;insert into tbstru (tbname,xlh,fdname) values (mchk,141,ngsp_yyzznjrq);if not exists(select * from fldlist where fdname=ngsp_yyzznjrq)insert i
3、nto fldlist (fdname,chnname,fdtype,fdsize,fddec) values (ngsp_yyzznjrq,营业执照年检日期,字符,10,0);if not exists(select b.*,a.* from sysobjects a,syscolumns b where a.name=NGSP_SYQYXG and a.id=b.id and b.name=ngsp_yyzznjrq)alter table NGSP_SYQYXG add ngsp_yyzznjrq char(10) null default ;delete from tbstru whe
4、re tbname=NGSP_SYQYXG and fdname=ngsp_yyzznjrq;insert into tbstru (tbname,xlh,fdname) values (NGSP_SYQYXG,119,ngsp_yyzznjrq);if not exists(select b.*,a.* from sysobjects a,syscolumns b where a.name=NGSP_SYQY and a.id=b.id and b.name=ngsp_yyzznjrq)alter table NGSP_SYQY add ngsp_yyzznjrq char(10) null
5、 default ;delete from tbstru where tbname=NGSP_SYQY and fdname=ngsp_yyzznjrq;insert into tbstru (tbname,xlh,fdname) values (NGSP_SYQY,116,ngsp_yyzznjrq);2. 更新表单涉及表单NGSP_SYQY_GSAJ01NGSP_SYQY_GSBJ021NGSP_SYQY_GSCJ031NGSP_SYQY_GSDJ041NGSP_SYQY_XGNGSP_SYQY_XGZXNGSP_SYQY_BLNGSP_SYQY_CXNGSP_SYQY_YYCXNGSP_
6、SYKH_GSAJ01NGSP_SYKH_GSBJ021NGSP_SYKH_GSCJ031NGSP_SYKH_GSDJ041NGSP_SYKH_XGNGSP_SYKH_XGZXNGSP_SYKH_BLNGSP_SYKH_CXNGSP_SYKH_YYCX3. 更新存储过程涉及存储过程NGSP_gspxy_ycKSOA 错误修复更新日期:2013-09-24 更新人:张建申请日期:2013-09-24 申请人:卜练练客户:无锡烨辉申请原因:ksoa标准版本错误适用版本:KSOA确认日期: 确认人:一、 拒收审核和拒收记录查询报错列名 ysshl 和 ssshl 无效1. 增加字段if not ex
7、ists(select b.*,a.* from sysobjects a,syscolumns b where a.name=spjsdmx and a.id=b.id and b.name=ysshl)alter table spjsdmx add ysshl decimal (14,2) null default 0;delete from tbstru where tbname=spjsdmx and fdname=ysshl;insert into tbstru (tbname,xlh,fdname) values (spjsdmx,34,ysshl);if not exists(s
8、elect * from fldlist where fdname=ysshl)insert into fldlist (fdname,chnname,fdtype,fdsize,fddec) values (ysshl,验收数量 ,实数, 14,2);if not exists(select b.*,a.* from sysobjects a,syscolumns b where a.name=spjsdmx and a.id=b.id and b.name=ssshl)alter table spjsdmx add ssshl decimal (14,2) null default 0;d
9、elete from tbstru where tbname=spjsdmx and fdname=ssshl;insert into tbstru (tbname,xlh,fdname) values (spjsdmx,35,ssshl);if not exists(select * from fldlist where fdname=ssshl)insert into fldlist (fdname,chnname,fdtype,fdsize,fddec) values (ssshl,实收数量 ,实数, 14,2);二、 高于库存上限和货位上限预警没有过滤掉库存上限为零的情况1. 更新存储
10、过程SOF_xt_jy,该存储过程改动较多,可考虑完全覆盖三、 零售价调整存盘当抬头勾选“是否更新状态”时,报错“ 字段 zhuangt 无效”1. 更新字段if not exists(select b.*,a.* from sysobjects a,syscolumns b where a.name=fdspgx and a.id=b.id and b.name=zhuangt)alter table fdspgx add zhuangt char(10) null default ;delete from tbstru where tbname=fdspgx and fdname=zhua
11、ngt;insert into tbstru (tbname,xlh,fdname) values (fdspgx,26,zhuangt);四、 410 请货报计量规格校验错误1. 更新存储过程AutogetmxAutogetmx 存储过程, 410 单据所有品种语句时增加 jlgg 的取值。五、 “会员发卡管理” 功能打不开功能注册被删除,注册功能“会员发卡管理”1. 执行脚本if exists(select * from gnlist where mkbh = A1 and gnbh = pos_card_faka) insert into gnlist(gnbh,mkbh,gnmch,r
12、unexe,para,tubidx,jsjg) values(pos_card_fakagl,A1,会员发卡管理,OpenBillMenu,pos_card_fakagl,-1,)KSOA 日清错误修复更新日期:2013-09 -25 更新人:张建申请日期:2013-09 -25 申请人:赵辉客户:徐州恩奇申请原因:ksoa标准版本日清发现daysphz, dayskyhz,retjels,retmast不一致适用版本:KSOA确认日期: 确认人:1. 更新存储过程SBP_ls_rq-Lan Q T 2013-09-25 增加三张表条目数不一致拦截 ,较之前的数据相比,更正了mx_count,
13、je_count为的错误if exists (select top 1 1 from #t_mast aleft join pos_mast b on a.lshh=b.lshh and a.sktid=b.sktid and a.fdbs=b.fdbsleft join (select lshh,sktid,fdbs,count(1) mx_count from pos_mxls group by lshh,sktid,fdbs) c on a.lshh=c.lshh and a.sktid=c.sktid and a.fdbs=c.fdbsleft join (select lshh,sk
14、tid,fdbs,count(1) je_count from pos_jels group by lshh,sktid,fdbs) d on a.lshh=d.lshh and a.sktid=d.sktid and a.fdbs=d.fdbswhere isnull(a.mx_count,0)isnull(b.je_count,0)or isnull(a.mx_count,0)isnull(d.je_count,0)or isnull(a.mx_count,0)=0 or (isnull(a.sshje,0)0 and isnull(a.je_count,0)=0)beginraiserror(数据异常!存在明细条目数不匹配