invoice配置文件修改

con="编号:#INVOICECODE#,数量:#INVOICENUM#,册号:#bookcode#,年度:#modChargemon#,领用人:#LEADMAN#,

备注:#modNOTES#,代码:#INVOICENUMBER#"

dataType="" dataKey="#INVOICECODE#">

{call ?:=pkg_invoiceManage.updateInvoice(

'#INVOICENUMBER#',

'#INVOICECODE#',

'#INVOICECOND#',

'#hyfl#',

'#PAYMAN#',

'#CHEQUECODE#',

'#NOWCASH#',

'#BILLMAN#',

'#BILLDATE#',

'#oldINVOICENUMBER#',

'#oldINVOICECODE#',

'#spmc1#',

'#spmc2#',

'#spmc3#',

'#spmc4#',

'#price1#',

'#price2#',

'#price3#',

'#price4#',

'#chargearea1#',

'#chargearea2#',

'#chargearea3#',

'#chargearea4#',

'#cash1#',

'#cash2#',

'#cash3#',

'#cash4#',

'#housecode1#',

'#housecode2#',

'#housecode3#',

'#housecode4#',

'#dw1#',

'#dw2#',

'#dw3#',

'#dw4#')}

数据包 PKG_INVOICEMANAGE

function updateInvoice() 包 包体字段改为

INVOICENUMBER in varchar2, --代码

INVOICECODE in varchar2, --编号

INVOICECOND in varchar2,

hyfl in varchar2,

PAYMAN in varchar2,

CHEQUECODE in varchar2,

NOWCASH in number,

BILLMAN in varchar2,

BILLDATE in varchar2,

oldINVOICENUMBER in varchar2,

oldINVOICECODE in varchar2,

spmc1 in varchar2,

spmc2 in varchar2,

spmc3 in varchar2,

spmc4 in varchar2,

price1 in number,

price2 in number,

price3 in number,

price4 in number,

chargearea1 in number,

chargearea2 in number,

chargearea3 in number,

chargearea4 in number,

cash1 in number,

cash2 in number,

cash3 in number,

cash4 in number,

housecode1 in varchar2,

housecode2 in varchar2,

housecode3 in varchar2,

housecode4 in varchar2,

dw1 in varchar2,

dw2 in varchar2,

dw3 in varchar2,

dw4 in varchar2

{call ?:=pkg_list_business.get_page_by_number(

'INVOICENUMBER,

INVOICECODE,

case when invoicecond=''1'' then ''正票''

when invoicecond=''2'' then ''负票''

when invoicecond=''3'' then ''废票''

when invoicecond=''4'' then ''缴销票''

when invoicecond=''0'' then ''缴销票''

else ''缴销票'' end as invoicecondname,

hyfl,

PAYMAN,

CHEQUECODE,

NOWCASH,

BILLMAN,

BILLDATE,

oldINVOICENUMBER,

oldINVOICECODE,

case when printType = ''1'' then ''直连打印''

else ''税控机导

入''

end as printType,

OPERATEDATE,

spmc1,

price1,

chargearea1,

cash1,

housecode1,

dw1,

spmc2,

price2,

chargearea2,

cash2,

housecode2,

dw2,

spmc3,

price3,

chargearea3,

cash3,

housecode3,

dw3,

spmc4,

price4,

chargearea4,

cash4,

housecode4,

dw4,invoicecond',

'SF_INVOICE',

'1=1 #condition#',

'#sort#',15,#page_number#)}

{call ?:=pkg_list_business.get_total_sum_info('NOWCASH',

'sf_invoice',

'1=1 #condition#',15)}

charge.xml

---- PKG_CHARGE_HN body saveChargeInvoice 照着包体改

PKG_INVOICEMANAGE body修改（对应的包头也要修改）

--修改

function updateInvoice(

INVOICENUMBER in varchar2, --代码

INVOICECODE in varchar2, --编号

INVOICECOND in varchar2, --状态

hyfl in varchar2, --行业分类

PAYMAN in varchar2, --客户名称

CHEQUECODE in varchar2, --支票号

NOWCASH in number, --开票金额

BILLMAN in varchar2, --开票人

BILLDATE in varchar2, --开票日期

oldINVOICENUMBER in varchar2, --原代码

oldINVOICECODE in varchar2, --原号码

spmc1 in varchar2, --商品名称1

spmc2 in varchar2,

spmc3 in varchar2,

spmc4 in varchar2,

price1 in number, --单价1

price2 in number,

price3 in number,

price4 in number,

chargearea1 in number, --数量1

chargearea2 in number,

chargearea3 in number,

chargearea4 in number,

cash1 in number, --总价1

cash2 in number,

cash3 in number,

cash4 in number,

housecode1 in varchar2, --合同编号1

housecode2 in varchar2,

housecode3 in varchar2,

housecode4 in varchar2,

dw1 in varchar2, --单位1

dw2 in varchar2,

dw3 in varchar2,

dw4 in varchar2

) return pkg_custom_type.cursor_type

IS

sql_statement varchar2(2000);

t_LEN integer; --长度

vInvCodeEnd varchar2(20); --截止编号

result_cursor pkg_custom_type.cursor_type;

BEGIN

--更新sf_invoice表

sql_statement :='update sf_invoice set INVOICECOND='''||INVOICECOND||''',

hyfl='''||hyfl||''',PAYMAN='''||PAYMAN||''',CHEQUECODE='''||CHEQUECODE||''',

NOWCASH='''||NOWCASH||''',BILLMAN='''||BILLMAN||''',BILLDATE='''||BILLDATE||''',

oldINVOICENUMBER='''||oldINVOICENUMBER||''',oldINVOICECODE='''||oldINVOICECODE||''',

spmc1='''||spmc1||''',price1='''||price1||''',chargearea1='''||chargearea1||''',

cash1='''||cash1||''',housecode1=''

'||housecode1||''',dw1='''||dw1||''',

spmc2='''||spmc2||''',price2='''||price2||''',chargearea2='''||chargearea2||''',

cash2='''||cash2||''',housecode2='''||housecode2||''',dw2='''||dw2||''',

spmc3='''||spmc3||''',price3='''||price3||''',chargearea3='''||chargearea3||''',

cash3='''||cash3||''',housecode3='''||housecode3||''',dw3='''||dw3||''',

spmc4='''||spmc4||''',price4='''||price4||''',chargearea4='''||chargearea4||''',

cash4='''||cash4||''',housecode4='''||housecode4||''',dw4='''||dw4||'''

where INVOICENUMBER='''||INVOICENUMBER||''' and INVOICECODE='''||INVOICECODE||'''';

dbms_output.put_line(sql_statement);

execute immediate sql_statement;

con="代码:#INVOICENUMBER#,编号:#INVOICECODE#,本金金额:#NOWCASH#,滞纳金金额:#LATEFEENOW#"

dataType="" dataKey="#INVOICECODE#">

update sf_invoice set

INVOICECOND='#INVOICECOND#',

hyfl='#hyfl#',

PAYMAN='#PAYMAN#',

CHEQUECODE='#CHEQUECODE#',

NOWCASH=#NOWCASH#,

BILLMAN='#BILLMAN#',

BILLDATE='#BILLDATE#',

oldINVOICENUMBER='#oldINVOICENUMBER#',

oldINVOICECODE='#oldINVOICECODE#',

spmc1='#spmc1#',

price1='#price1#',

cash1='#cash1#',

chargearea1='#chargearea1#',

housecode1='#housecode1#',

dw1='#dw1#',

spmc2='#spmc2#',

price2='#price2#',

cash2='#cash2#',

chargearea2='#chargearea2#',

housecode2='#housecode2#',

dw2='#dw2#',

spmc3='#spmc3#',

price3='#price3#',

cash3='#cash3#',

chargearea3='#chargearea3#',

housecode3='#housecode3#',

dw3='#dw3#',

spmc4='#spmc4#',

price4='#price4#',

cash4='#cash4#',

chargearea4='#chargearea4#',

housecode4='#housecode4#',

dw4='#dw4#'

where INVOICENUMBER='#INVOICENUMBER#' and INVOICECODE='#INVOICECODE#'