检查用户名和Email是否存在

create proc Proc_Fellow_Get_Fellow_Name_By_Co_id
@UserName nvarchar(50)
as
declare @CompanyCode nvarchar(50)
select @CompanyCode=CompanyCode from FellowTab where UserName=@UserName
return @CompanyCode 

public int CheckFellowRegisterName(string name)
  {
   //20050522
   //修改参数和存储过程
   dataConn = new SqlConnection(strConn);
   dataConn.Open();
   SqlCommand cm=new SqlCommand("Proc_Fellow_Get_Fellow_Name_By_Co_id",dataConn);
   cm.CommandType=CommandType.StoredProcedure;

   cm.Parameters.Add("@UserName",SqlDbType.NVarChar,50);
   cm.Parameters.Add("@CompanyCode",SqlDbType.NVarChar,50);
   //添加
   cm.Parameters["@UserName"].Value=name;
   cm.Parameters["@CompanyCode"].Direction=ParameterDirection.ReturnValue;//接收存储过程的返回值
   cm.ExecuteNonQuery();
   dataConn.Close();
   int nid=(int)cm.Parameters["@CompanyCode"].Value;
   return nid;
  }

#region 用户名和电子邮件唯一性检查
  private bool Check_name(string uname)
  {
   int nid = ( new FellowRegisterFacade() ).Check_Name(uname);
   if (nid>0)
    return false;
   else
    return true;
  }

  private bool Check_email(string email)
  {
   int nid = ( new FellowRegisterFacade() ).Check_Email(email);
   if (nid>0)
    return false;
   else
    return true;
  }