CREATE PROCEDURE ups_groupInfoadd
@ParentGroupID int,
@GroupName varchar(20),
@Orderby int,
@Re varchar(20)
AS
declare @groupid varchar(20)
declare @GroupPower varchar(200)
begin
if(not exists(select * from GroupInfo where GroupName=@GroupName))
begin
set select @Grouppower=GroupPower from GroupInfo where GroupID=@ParentGroupIDinsert into GroupInfo
(
ParentGroupID,
GroupName,
orderby,
Re
)
values
(
@ParentGroupID,
@GroupName,
@Orderby,
@Re
)
set select @GroupID=GroupID from GroupInfo where GroupName=@GroupNameupdate GroupInfo
set GroupPower=@GroupPower+@GroupID+';'
where GroupName=@GroupName
return 1 --插入成功返回1
end
else
begin
return 0 --插入失败返回0
end
end
GO
---------------------------------
存储过程,插入成功返回1
失败就返回0,请问C#里,使用该存储过程,怎么才能得到返回的值,或者说怎么判断插入成功/失败?高手过一下招,谢谢了,C#里,
----------------------------------
public bool GroupAdd()
{
SqlParameter[] Params = new SqlParameter[4];
Database db = new Database();
Params[0] = db.MakeInParam("@ParentGroupID", SqlDbType.Int,4,ParentGroupID);
Params[1] = db.MakeInParam("@GroupName", SqlDbType.VarChar,20,GroupName);
Params[2] = db.MakeInParam("@Orderby", SqlDbType.Int,4,Orderby);
Params[3] = db.MakeInParam("@Re", SqlDbType.VarChar, 20, Re); int Count = -1;
Count = SqlHelper.ExecuteNonQuery(db.ConnectionString, CommandType.StoredProcedure, "ups_groupInfoadd", Params);
if (Count > 0)
return true;
else return false; }
@ParentGroupID int,
@GroupName varchar(20),
@Orderby int,
@Re varchar(20)
AS
declare @groupid varchar(20)
declare @GroupPower varchar(200)
begin
if(not exists(select * from GroupInfo where GroupName=@GroupName))
begin
set select @Grouppower=GroupPower from GroupInfo where GroupID=@ParentGroupIDinsert into GroupInfo
(
ParentGroupID,
GroupName,
orderby,
Re
)
values
(
@ParentGroupID,
@GroupName,
@Orderby,
@Re
)
set select @GroupID=GroupID from GroupInfo where GroupName=@GroupNameupdate GroupInfo
set GroupPower=@GroupPower+@GroupID+';'
where GroupName=@GroupName
return 1 --插入成功返回1
end
else
begin
return 0 --插入失败返回0
end
end
GO
---------------------------------
存储过程,插入成功返回1
失败就返回0,请问C#里,使用该存储过程,怎么才能得到返回的值,或者说怎么判断插入成功/失败?高手过一下招,谢谢了,C#里,
----------------------------------
public bool GroupAdd()
{
SqlParameter[] Params = new SqlParameter[4];
Database db = new Database();
Params[0] = db.MakeInParam("@ParentGroupID", SqlDbType.Int,4,ParentGroupID);
Params[1] = db.MakeInParam("@GroupName", SqlDbType.VarChar,20,GroupName);
Params[2] = db.MakeInParam("@Orderby", SqlDbType.Int,4,Orderby);
Params[3] = db.MakeInParam("@Re", SqlDbType.VarChar, 20, Re); int Count = -1;
Count = SqlHelper.ExecuteNonQuery(db.ConnectionString, CommandType.StoredProcedure, "ups_groupInfoadd", Params);
if (Count > 0)
return true;
else return false; }
public int seqId(string LogType)
{
//得到数据库连接 SqlConnection conn = DBMgr.GetConnection(); //打开连接
conn.Open(); //建立Command语句命令
SqlCommand cmd = new SqlCommand(); //连接字符串的赋值
cmd.Connection = conn; cmd.CommandText = @"sp_GetSequence";
//设置对象命令类型为存储过程
cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.Add(new SqlParameter("@SEQ_TYPE",SqlDbType.NVarChar));
cmd.Parameters["@SEQ_TYPE"].Value = "OCS"; cmd.Parameters.Add(new SqlParameter("@SEQ_NAME",SqlDbType.NVarChar));
cmd.Parameters["@SEQ_NAME"].Value = LogType; // "ImportExport_Seq"; cmd.Parameters.Add(new SqlParameter("@SEQ_ID", SqlDbType.Int));
cmd.Parameters["@SEQ_ID"].Direction = ParameterDirection.ReturnValue; cmd.ExecuteScalar(); return int.Parse(cmd.Parameters["@SEQ_ID"].Value.ToString());
}