TA的每日心情 | 难过 2012-3-10 22:48 |
---|
签到天数: 61 天 [LV.6]常住居民II
|
楼主 |
发表于 2011-9-21 15:44:44
|
显示全部楼层
超赢软件一些小玩意整合:
异入超赢软件基本信息,对条形码进行触发语句:
delete jxc_bm_sp_barcode where is_master_code=1;
insert into jxc_bm_sp_barcode (bm_sp, barcode, dw, zhl, is_master_code, n_last)
select bm, barcode, dw, 1, 1, 1
from jxc_bm_sp where isnull(barcode, '') <> '';
delete jxc_bm_sp_barcode where is_master_code=1;
insert into jxc_bm_sp_barcode (bm_sp, barcode, dw, zhl, is_master_code, n_last)
select bm, barcode, dw, 1, 1, 1
from jxc_bm_sp where isnull(barcode, '') <> '';
delete jxc_bm_sp_barcode where is_master_code=1;
insert into jxc_bm_sp_barcode (bm_sp, barcode, dw, zhl, is_master_code, n_last)
select bm, barcode, dw, 1, 1, 1
from jxc_bm_sp where isnull(barcode, '') <> '';
超赢对不属于当前进销存日期的数据进行日结语法更新语句:
update jxc_dj_ls_1 set jxc_yyyymm = '200704' where jxc_yyyymm = '200612';
update jxc_dj_ls_2 set jxc_yyyymm = '200704' where jxc_yyyymm = '200612';
超赢软件不能月结,提示当月没有发生业务不能进行月结时,请更改:超赢软件配置文件Licence.ini中check_jzxy=0项中更改为等于1,保存即可.
|
|