Index: ssts-web/src/main/webapp/dataUpdater/4.0升级4.1脚本/服务器启动之后执行的脚本.txt =================================================================== diff -u -r13432 -r13754 --- ssts-web/src/main/webapp/dataUpdater/4.0升级4.1脚本/服务器启动之后执行的脚本.txt (.../服务器启动之后执行的脚本.txt) (revision 13432) +++ ssts-web/src/main/webapp/dataUpdater/4.0升级4.1脚本/服务器启动之后执行的脚本.txt (.../服务器启动之后执行的脚本.txt) (revision 13754) @@ -58,8 +58,8 @@ /* �����̵��¼��ϸ��һ������Ʒ��Ϣ */ -update StockTakeItem set disposableGoodsId=diposableGoodsID,disposableGoodsStockId=diposableGoodsID,disposableGoodsBatchId=batchID,disposableGoodsBatchStockId=batchID; + /* ���÷�����һ������Ʒ��ϸ��һ������Ʒ��Ϣ */ update DiposableGoodsItem set disposableGoodsId=diposableGoodsID,disposableGoodsStockId=diposableGoodsID,disposableGoodsBatchId=batchID,disposableGoodsBatchStockId=batchID; @@ -83,8 +83,8 @@ update ReturnGoodsRecord set warehouseName='��Ժ��Ӧ�Ҳֿ�',warehouseID=(select id from WareHouse where name='��Ժ��Ӧ�Ҳֿ�'); update ReturnGoodsItem set warehouseName='��Ժ��Ӧ�Ҳֿ�',warehouseID=(select id from WareHouse where name='��Ժ��Ӧ�Ҳֿ�'); --5.������һ������Ʒ�̵㼰��ϸ�ֿ��ֶ� -update StockTakeInfo set warehouseName='��Ժ��Ӧ�Ҳֿ�',warehouseID=(select id from WareHouse where name='��Ժ��Ӧ�Ҳֿ�'); -update StockTakeItem set warehouseName='��Ժ��Ӧ�Ҳֿ�',warehouseID=(select id from WareHouse where name='��Ժ��Ӧ�Ҳֿ�'); + + --6.����������ϸ�ֿ��ֶθ��� update invoice set sourceWareHouseName='��Ժ��Ӧ�Ҳֿ�',sourceWarehouseID=(select id from WareHouse where name='��Ժ��Ӧ�Ҳֿ�'); --wareHouseName=(select w.name from WareHouse w join OrgUnit o on w.orgUnitCode=o.orgUnitCoding where o.name=invoice.depart), wareHouseId = (select w.id from WareHouse w join OrgUnit o on w.orgUnitCode=o.orgUnitCoding where o.name=invoice.depart);