17,377
社区成员
发帖
与我相关
我的任务
分享
CREATE OR REPLACE PROCEDURE insert_update(p_upcode in varchar2, --属装图号
p_upname in varchar2, --属装图名
p_ditem in number, --键号
p_dcode in varchar2, --图号
p_dname in varchar2, --图名
p_dmaterial in varchar2, --材料
p_dweight in number, --单重
p_dtweight in number, --总重
p_dquantity in number, --总数
p_dremark in varchar2, --备注
p_dother1 in varchar2, --工艺分工
p_productdwgcode in varchar2, --所属产品
p_g1 in varchar2,
p_g2 in varchar2, --领料单位
p_g3 in varchar2,
p_g4 in varchar2,
p_g5 in varchar2,
p_g6 in varchar2,
p_g7 in varchar2,
p_g8 in varchar2,
p_g9 in varchar2,
p_xialiao in varchar2, --下料尺寸
p_dinge in varchar2, --定额
p_lldw in varchar2, --领料单位
p_dmark in varchar2, --外购标记
p_invcost in number, --计划价
p_dinvcost in number, --计划总价
p_cinvcode in varchar2, --物料码
p_invunit in varchar2, --计量单位
p_yongyou in varchar2, --用友码
p_changerate in number, --转化率
p_creator in varchar2, --创建人
p_createtime in date, --创建日期
p_modified in varchar2, --修改人
p_modifytime in date --修改日期
) as
num number;
begin
select count(*)
into num
from XTDETAMSALL_DETAIL_2
WHERE UPCODE = p_upcode
and DITEM = p_ditem;
if num <> 0 then
update XTDETAMSALL_DETAIL_2
set XIALIAO = p_xialiao,
DINGE = p_dinge,
LLDW = p_lldw,
DMARK = p_dmark,
INVCOST = p_invcost,
DINVCOST = p_dinvcost,
CINVCODE = p_cinvcode,
INVUNIT = p_invunit,
YONGYOU = p_yongyou,
CHANGERATE = p_changerate,
MODIFIED = p_modified,
MODIFYTIME = sysdate
where UPCODE = p_upcode
and DITEM = p_ditem;
--UPCODE=p_upcode,UPNAME=p_upname,DITEM=p_ditem,DCODE=p_dcode,DNAME=p_dname,DMATERIAL=p_dmaterial,DWEIGHT=p_dweight,DTWEIGHT=p_dtweight,DQUANTITY=p_dquantity,DREMARK=p_dremark,DOTHER1=p_dother1,PRODUCTDWGCODE=p_productdwgcode,G1=p_g1,G2=p_g2,G3=p_g3,G4=p_g4,G5=p_g5,G6=p_g6,G7=p_g7,G8=p_g8,G9=p_g9,XIALIAO=p_xialiao,DINGE=p_dinge,LLDW=p_lldw,DMARK=p_dmark,INVCOST=p_invcost,DINVCOST=p_dinvcost,CINVCODE=p_cinvcode,INVUNIT=p_invunit,YONGYOU=p_yongyou,MODIFIED=p_modified,MODIFYTIME=sysdate;
else
insert into XTDETAMSALL_DETAIL_2
(UPCODE,
UPNAME,
DITEM,
DCODE,
DNAME,
DMATERIAL,
DWEIGHT,
DTWEIGHT,
DQUANTITY,
DREMARK,
DOTHER1,
PRODUCTDWGCODE,
G1,
G2,
G3,
G4,
G5,
G6,
G7,
G8,
G9,
XIALIAO,
DINGE,
LLDW,
DMARK,
INVCOST,
DINVCOST,
CINVCODE,
INVUNIT,
YONGYOU,
CHANGERATE,
CREATOR,
CREATETIME)
values
(p_upcode,
p_upname,
p_ditem,
p_dcode,
p_dname,
p_dmaterial,
p_dweight,
p_dtweight,
p_dquantity,
p_dremark,
p_dother1,
p_productdwgcode,
p_g1,
p_g2,
p_g3,
p_g4,
p_g5,
p_g6,
p_g7,
p_g8,
p_g9,
p_xialiao,
p_dinge,
p_lldw,
p_dmark,
p_invcost,
p_dinvcost,
p_cinvcode,
p_invunit,
p_yongyou,
p_changerate,
p_creator,
sysdate);
end if;
commit;
end insert_update;