BS3000J批量反记账反审核的方法

最新推荐文章于 2021-01-13 15:57:29 发布

原创最新推荐文章于 2021-01-13 15:57:29 发布 · 1.3k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#excel #数据库

本文介绍了一种批量处理订单的方法，包括检索特定状态的订单、更新订单状态、生成执行语句并导出到TXT文件等步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1，检索数据库中审核，记账，未执行，未终止的订单（说明此单据仅仅是做到第三步，并没有发货！）

2，删除发货单中发货单.通知单号=通知单.通知单单号的发货单。

3，把1步检索出的，要反记账，反审核的单据列表，拷贝到 excel

4，

SD2000073

SD2000075

SD2000078

SD2000079

SD2000083

SD2000086

SD2000087

SD2000090

SD2000091

SD2000092

5，然后再在两边加入执行语句

UPDATE PSEND SET YS = '0' WHERE DJBH='	SD2000073	';
UPDATE PSEND SET YS = '0' WHERE DJBH='	SD2000075	';
UPDATE PSEND SET YS = '0' WHERE DJBH='	SD2000078	';
UPDATE PSEND SET YS = '0' WHERE DJBH='	SD2000079	';
UPDATE PSEND SET YS = '0' WHERE DJBH='	SD2000083	';
UPDATE PSEND SET YS = '0' WHERE DJBH='	SD2000086	';
UPDATE PSEND SET YS = '0' WHERE DJBH='	SD2000087	';
UPDATE PSEND SET YS = '0' WHERE DJBH='	SD2000090	';
UPDATE PSEND SET YS = '0' WHERE DJBH='	SD2000091	';
UPDATE PSEND SET YS = '0' WHERE DJBH='	SD2000092	';

6，然后再拷贝到TXT文件中把 TAB的“空格” 替换掉就成了

UPDATE PSEND SET YS = '0' WHERE DJBH='SD2000073';
UPDATE PSEND SET YS = '0' WHERE DJBH='SD2000075';
UPDATE PSEND SET YS = '0' WHERE DJBH='SD2000078';
UPDATE PSEND SET YS = '0' WHERE DJBH='SD2000079';
UPDATE PSEND SET YS = '0' WHERE DJBH='SD2000083';
UPDATE PSEND SET YS = '0' WHERE DJBH='SD2000086';
UPDATE PSEND SET YS = '0' WHERE DJBH='SD2000087';
UPDATE PSEND SET YS = '0' WHERE DJBH='SD2000090';
UPDATE PSEND SET YS = '0' WHERE DJBH='SD2000091';
UPDATE PSEND SET YS = '0' WHERE DJBH='SD2000092';

UPDATE PSEND SET JZ = '0' WHERE DJBH='SD2000073';
UPDATE PSEND SET JZ = '0' WHERE DJBH='SD2000075';
UPDATE PSEND SET JZ = '0' WHERE DJBH='SD2000078';
UPDATE PSEND SET JZ = '0' WHERE DJBH='SD2000079';
UPDATE PSEND SET JZ = '0' WHERE DJBH='SD2000083';
UPDATE PSEND SET JZ = '0' WHERE DJBH='SD2000086';
UPDATE PSEND SET JZ = '0' WHERE DJBH='SD2000087';
UPDATE PSEND SET JZ = '0' WHERE DJBH='SD2000090';
UPDATE PSEND SET JZ = '0' WHERE DJBH='SD2000091';
UPDATE PSEND SET JZ = '0' WHERE DJBH='SD2000092';

7.看！！！！批量的语句！超简单！