DAO读取

public Accuse Load(int Id)
  {
   try
   {
    using (SqlConnection conn = new SqlConnection(SqlAccess.GetConnectionString()))
    {
     conn.Open();
     String cmdString="select * from Accuse where ID=@ID";
     SqlCommand cmd=new SqlCommand(cmdString,conn);
     cmd.Parameters.Add(new SqlParameter("@ID",SqlDbType.Int)).Value=Id;
     SqlDataReader result=cmd.ExecuteReader();
     Accuse b=new Accuse();
     if(result.Read())
     {
      b.Name =Convert.ToString(result["Name"]);
      b.Email =Convert.ToString(result["Email"]);
      b.Title =Convert.ToString(result["Title"]);
      b.AccuseCompany =Convert.ToString(result["AccuseCompany"]);
      b.Content =Convert.ToString(result["Content"]);
      b.AddTime =Convert.ToDateTime(result["AddTime"]);
      b.ReName =Convert.ToString(result["ReName"]);
      b.Revert =Convert.ToString(result["Revert"]);
      b.ReTime=Convert.ToDateTime(result["ReTime"]);
      b.IsDispose =Convert.ToBoolean(result["IsDispose"]);
      b.Phone =Convert.ToString(result["Phone"]);
     }
     return b;
    }
   }
   catch(Exception ex)
   {
    log.Debug("人才信息读取失败!!!");
    log.Debug(ex.StackTrace);
    throw ex;
   }
  }

 

 

  public string LoadMemberOK(string typeName)
  {
   try
   {
    string MemberOK="";
    String cmdString="select MemberOK from Type where typeName='"+typeName+"'";
    SqlCommand cmd=new SqlCommand(cmdString,data.conn());
    cmd.Connection.Open();
    SqlDataReader result=cmd.ExecuteReader();
    if(result.Read())
    {
     MemberOK=Convert.ToString(result["MemberOK"]);
    }
    return MemberOK;
   }
   catch(Exception ex)
   {
    throw ex;
   }
  }

 

  public string LoginCheck(string MemberName,string MemberPwd)         //验证登录口的用户名和密码
  {
   try
   {
    using (SqlConnection conn=new SqlConnection(SqlAccess.GetConnectionString()))
    {
     string  md5Pwd=System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(MemberPwd,"md5");
     conn.Open();
     String cmdString="select Id from Member where UserName=@UserName and PassWord=@PassWord";
     SqlCommand cmd=new SqlCommand(cmdString,conn);
     cmd.Parameters.Add(new SqlParameter("@UserName",SqlDbType.VarChar)).Value=MemberName;
     cmd.Parameters.Add(new SqlParameter("@PassWord",SqlDbType.VarChar)).Value=md5Pwd;
     return Convert.ToString(cmd.ExecuteScalar());
    }
    
   }
   catch(Exception ex)
   {
    throw ex;
   }
  }