processmattlist.sql

出租车管理企业

CREATE PROCEDURE ProcessMattList(
       @sID varchar(50),
       @sLinkID varchar(50),
       @sItemID varchar(50),
       @sName varchar(100),
       @sModel varchar(50),
       @sUnit varchar(50),
       @sProperty1 varchar(254),
       @sProperty2 varchar(254),
       @sProperty3 varchar(254),
       @sProperty4 varchar(254),
       @sProperty5 varchar(254),
       @nPrice numeric(20, 4),
       @nEndPrice numeric(20, 4),
       @nRate numeric(6, 4),
       @nCount numeric(20, 2),
       @nMoney numeric(20, 4),
       @nCost numeric(20, 4),
       @dMass datetime,
       @lMass bit,
       @sComment varchar(200),
       @nLeft numeric(20, 2)
       )
AS
BEGIN
     declare @err integer
     /*
     if exists(select * from mattlist where sId = @sId and sProperty1 = @sProperty1
         and sProperty2 = @sProperty2 and sProperty3 = @sProperty3
         and sProperty4 = @sProperty4 and sProperty5 = @sProperty5)
     begin
     end
     else
     begin
     end
     */
     select @err err
END