public int AddVote(int titleId, int blockId, int typeId)
{
List<SqlParameter> paramArray = new List<SqlParameter>();
paramArray.Add(new SqlParameter("@titleId", titleId));
paramArray.Add(new SqlParameter("@blockId", blockId));
paramArray.Add(new SqlParameter("@typeId", typeId));
SqlParameter param = new SqlParameter("@num", SqlDbType.Int);
param.Direction = ParameterDirection.Output;
paramArray.Add(param);
using (RPDBContext db = new RPDBContext())
{
try
{
db.Database.ExecuteSqlCommand("EXEC [AddVote] @blockId,@titleId,@typeId,@num out", paramArray.ToArray());
}
catch (Exception ex)
{
throw;
}
int result = (int)paramArray[3].Value;
return result;
}
}
存储过程测试实例:
USE [HY_ReplyComment]
GO
/****** 对象: StoredProcedure [dbo].[AddVote] 脚本日期: 06/10/2014 22:27:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
CREATE PROCEDURE [dbo].[AddVote]
@blockId int,
@titleId int,
@typeId int,
@num int output
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT @num = Count(1) FROM [Vote] WHERE TitleId = @titleId AND BlockId = @blockId
END