贴个存储过程 问几个棘手的小问题

[llovecf]

create procedure proc_Category_Delete(
@CODE varchar(50),
@CATEGORYCODE varchar(50)
)
as
set nocount on
begin transaction
  if not exists(select ID from CategoryParentList where CODE = @CODE) and not exists ( select ID from CategoryList where P_CODE = @CODE )
    begin
        if(@CATEGORYCODE = 'ArticleInfo')
          begin
            delete from ArticleList where P_CODE = @CODE;
              if(@@error<>0)
                begin
                  rollback transaction;
                  select Result = -1;
                  return -1;
                end
            delete from CategoryList where CODE = @CODE and CATEGORYCODE = @CATEGORYCODE;
              if(@@error<>0)
                begin
                  rollback transaction;
                  select Result = -1;
                  return -1;
                end
          end
        else if(@CATEGORYCODE = 'ProductInfo')
          begin
            delete from Product_AdditionalList where P_ID in (select ID from PorductList where CODE = @CODE);
              if(@@error<>0)
                begin
                  rollback transaction;
                  select Result = -1;
                  return -1;
                end
            delete from ProductList where P_CODE = @CODE;
              if(@@error<>0)
                begin
                rollback transaction;
                select Result = -1;
                return -1;
              end
            delete from CategoryList where CODE = @CODE and CATEGORYCODE = @CATEGORYCODE;
              if(@@error<>0)
                begin
                  rollback transaction;
                  select Result = -1;
                  return -1;
                end
          end
        else
          begin
            rollback transaction;
            select Result = -1;
            return -1;
          end
      select Result = 1;
      commit transaction;
    end
  else
    begin
      select Result = -1;
      rollback transaction

      return -1;
    end
return; 
go

首选 想请各位不吝赐教 帮小弟看看 这样的存储过程写得如何
其实 这里有一句是select Result = * 这个是我用来判断存储过程的执行情况的 不过好像又感觉有点麻烦 本来一开始是用output的 想想其实也一样 好像还有一种是直接去掉这个select Result=* 就用Return * 这样来判断的 但小小不知道在C#里怎么实现 请大家帮忙看看 如果有说得不明白的地方 楼下留言 在线等待

[消失的尘芥]

太长了，把问题的关键地方贴出来就行

[llovecf]

.......

[yanfang19850405]

不太懂 要output就行了

[llovecf]

就是不想用output 呵呵 就想直接传入参数 取得返回状态

[vrhero]

DbParameter.Direction属性设为ReturnValue...自己看MSDN去...

http://msdn.microsoft.com/zh-cn/library/system.data.common.dbparameter.direction(VS.80).aspx