28,391
社区成员
发帖
与我相关
我的任务
分享
set mycmd=server.createobject("ADODB.Command")
mycmd.ActiveConnection = conn
mycmd.CommandType = 4
mycmd.CommandText = "savepurmf"
mycmd.Parameters.Append mycmd.CreateParameter("purmfflowsn", 200, 1,11, trim(tempstr1(0))) mycmd.Parameters.Append mycmd.CreateParameter("purmfdpno", 200, 1,13 , trim(tempstr1(1)))
mycmd.Parameters.Append mycmd.CreateParameter("purmfapplydate", 200, 1,10, trim(tempstr1(2)))
mycmd.Parameters.Append mycmd.CreateParameter("purmfusedate", 200, 1,10, trim(tempstr1(3)))
mycmd.Parameters.Append mycmd.CreateParameter("purmfnumber", 5, 1, , trim(tempstr1(4)))
mycmd.Parameters.Append mycmd.CreateParameter("purmfum", 200, 1,3, trim(tempstr1(5)))
mycmd.Parameters.Append mycmd.CreateParameter("purmfmodel", 200, 1,2, trim(model))
mycmd.Parameters.Append mycmd.CreateParameter("purmfvendor", 200, 1,3, trim(vendor))
mycmd.Parameters.Append mycmd.CreateParameter("purmfapplyunit", 200, 1,4, trim(tempstr1(7)))
mycmd.Parameters.Append mycmd.CreateParameter("purmfisxlflag", 200, 1,2, trim(isxlflag))
mycmd.Execute()
Set mycmd=nothing
CREATE OR REPLACE PROCEDURE EBUY.savepurmf (
purmfflowsn IN VARCHAR2,
purmfdpno IN VARCHAR2,
purmfmodel IN VARCHAR2,
purmfvendor IN VARCHAR2,
purmfnumber IN NUMBER,
purmfum IN VARCHAR2,
purmfusedate IN VARCHAR2,
purmfapplydate IN VARCHAR2,
purmfapplyunit IN VARCHAR2,
purmfisxlflag IN VARCHAR2
)
IS
i INTEGER := 0;
BEGIN
SELECT COUNT (*)
INTO i
FROM partpurmf_web
WHERE purmf_flowsn = purmfflowsn
AND purmf_dpno = purmfdpno
AND purmf_model = purmfmodel
AND purmf_vendor = purmfvendor;
IF i < 1
THEN
INSERT INTO partpurmf_web
(purmf_id, purmf_flowsn, purmf_model,
purmf_dpno, purmf_vendor, purmf_number, purmf_um,
purmf_usedate, purmf_applydate, purmf_applyunit,
purmf_isxlflag, purmf_inputtime
)
VALUES (seq_partpurmf_web.NEXTVAL, purmfflowsn, purmfmodel,
purmfdpno, purmfvendor, purmfnumber, purmfum,
purmfusedate, purmfapplydate, purmfapplyunit,
purmfisxlflag, SYSDATE
);
ELSE
UPDATE partpurmf_web
SET purmf_number = purmfnumber,
purmf_um = purmfum,
purmf_usedate = purmfusedate,
purmf_applydate = purmfapplydate,
purmf_applyunit = purmfapplyunit,
purmf_isxlflag = purmfisxlflag,
purmf_modtime = SYSDATE
WHERE purmf_flowsn = purmfflowsn
AND purmf_dpno = purmfdpno
AND purmf_model = purmfmodel
AND purmf_vendor = purmfvendor;
END IF;
COMMIT;
END;
/