CREATE PROCEDURE sp_jiaoyanruku
@cphh varchar (20)='',
@bm int,
-- @kuid int,
@num int,
@checkvalue int output AS
declare @nm numeric
select @nm=0
SELECT @nm=proNum FROM kucun WHERE dhmxName=rtrim(ltrim(@cphh)) and prosizeid=@bm and kucunid=666
if @nm>@num
select @checkvalue=1
else
select @checkvalue=0
GOC#
cmd.CommandText="sp_jiaoyanruku666";
cmd.CommandType =CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@cphh",SqlDbType.VarChar,20)); //kucunidid
cmd.Parameters.Add(new SqlParameter("@bm",SqlDbType.Int,10)); //kucunidid
//cmd.Parameters.Add(new SqlParameter("@kuid",SqlDbType.Int,10)); //kucunidid
cmd.Parameters.Add(new SqlParameter("@num",SqlDbType.Int,10)); //kucunidid SqlParameter sampParm = null;
sampParm=cmd.Parameters.Add ("@checkvalue",SqlDbType.Int ,10);
sampParm.Direction = ParameterDirection.Output;
cmd.Parameters["@cphh"].Value=int.Parse(Result1[c]);
cmd.Parameters["@bm"].Value = int.Parse (Result3[c]);
//cmd.Parameters["@kuid"].Value =kuku;
cmd.Parameters["@num"].Value =int.Parse ( Result4[c]);
cmd.ExecuteNonQuery();
ReturnValue = cmd.Parameters["@checkvalue"].Value.ToString ();。
ReturnValue 一直是0 我在查询分析器中测试存储过程没问题
翻了以前的贴子,也没能解决
@cphh varchar (20)='',
@bm int,
-- @kuid int,
@num int,
@checkvalue int output AS
declare @nm numeric
select @nm=0
SELECT @nm=proNum FROM kucun WHERE dhmxName=rtrim(ltrim(@cphh)) and prosizeid=@bm and kucunid=666
if @nm>@num
select @checkvalue=1
else
select @checkvalue=0
GOC#
cmd.CommandText="sp_jiaoyanruku666";
cmd.CommandType =CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@cphh",SqlDbType.VarChar,20)); //kucunidid
cmd.Parameters.Add(new SqlParameter("@bm",SqlDbType.Int,10)); //kucunidid
//cmd.Parameters.Add(new SqlParameter("@kuid",SqlDbType.Int,10)); //kucunidid
cmd.Parameters.Add(new SqlParameter("@num",SqlDbType.Int,10)); //kucunidid SqlParameter sampParm = null;
sampParm=cmd.Parameters.Add ("@checkvalue",SqlDbType.Int ,10);
sampParm.Direction = ParameterDirection.Output;
cmd.Parameters["@cphh"].Value=int.Parse(Result1[c]);
cmd.Parameters["@bm"].Value = int.Parse (Result3[c]);
//cmd.Parameters["@kuid"].Value =kuku;
cmd.Parameters["@num"].Value =int.Parse ( Result4[c]);
cmd.ExecuteNonQuery();
ReturnValue = cmd.Parameters["@checkvalue"].Value.ToString ();。
ReturnValue 一直是0 我在查询分析器中测试存储过程没问题
翻了以前的贴子,也没能解决
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货