DRP修改說明及SQL更新 2010-06-21.docx

1、1, 把現(xiàn)有打印頁面顯示的列記錄好備用。2, 使用下面的SQL在查詢分析器中對數(shù)據(jù)庫更新：-入庫單打印數(shù)據(jù)窗口歷史模板清空updateIstTblNamessetsavcdtitlcdw=null,savedgriddw=nullwheretblName='dwjhinfo_ordtojh_billlist'-入庫單打印數(shù)據(jù)窗口歷史模板備份savetitledw:release9;datawindow(units=0timcr_intcrval=Ocolor=167772I5proccssing=0print.printername=""print.docu

2、mentname=""print.orientation=0print.margin.left=l10print.margin.right=l10print.margin.top=96print.margin.bottom=96print.papcr.sizc=Oprint.savegirddw:-release9;datawindow(units=0timer_interval=Ocolor=1073741824processing=lprint.printernaine=""prini.documentname=""prinl.o

3、rientation=0print.margin.left=l10piint.maigin.right=l10print.margin.top=96print.margin.bottom=96print.paper.size=Oprin-出庫單打印數(shù)據(jù)窗口歷史模板清空updateIstTblNamessetsavcdtitlcdw=null,savedgriddw=nullwheretblName='dw_slinfo_shipmcnt_b山list_detail'3, 恢復(fù)原報(bào)表顯示的列（1中記錄的），把不該顯示的列勾去。由于把兩個(gè)報(bào)表的歷史模板清空了，列的顯示可能需要重新設(shè)

4、置其中，入庫報(bào)表：條碼，商品規(guī)格，零頭，單價(jià)必須顯示，否則在頁腳的凡個(gè)簽名也不會顯示出庫報(bào)表：商品編號，條碼，規(guī)格，大單位數(shù)量必須顯示，否則在頁腳的幾個(gè)簽名也不會顯示deleteIstColNamesfromIstTblNamesa,IstColNamesbwherea.id=b.lstTbllDanda.tblName='dwjhinfo_ordtojh_billlist'g。deleteIstTblNameswheretblName='dw_jhinfo_ordtojh_billlist'g。deleteIstColNamesfromIstTblNamesa,IstColNamesbwherea.id=b.lstTbllDanda.tblName='dw_slinfo_shipment_biinist_detairgodeleteIstTblNameswheretblName='dw_slinfo_shipment_bi111ist_detaiI'goselect*fromIstTblNameswheretblNamewheretblName'dw_jhinfo_ordtojh_billlist'select*fromIstTblNamesa,Isl