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;
}
}