--插入订单--

create proc InsertOrders

(

@OrderNumber varchar(300),

@OrderState varchar(30),

@OrderType varchar(30),

@OrderTime DateTime,

@OrderFirm varchar(300),

@OrderMoney decimal(8,2),

@SendWayMoney decimal(8,2),

@RegisterId int,

@CoalitionOrdersId int,

@ConsigneeId int,

@PayWayId int,

@SendWayId int,

@CouponId int,

@OrderId int output

)

AS

insert into Orders values(@OrderNumber,@OrderState,@OrderType,@OrderTime,@OrderFirm,@OrderMoney,@SendWayMoney,@RegisterId,@CoalitionOrdersId,@ConsigneeId,@PayWayId,@SendWayId,@CouponId)

set @OrderId = (select @@IDENTITY)

go