/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="strUserInfo">用户信息</param>
/// <returns></returns>
public bool UpdateUserInfo(UserInfo strUserInfo)
{
try
{
#region 赋值给存储过程变量
SqlParameter[] sqlPara = new SqlParameter[12];
sqlPara[0] = new SqlParameter("@loginName", SqlDbType.VarChar, 50);
sqlPara[0].Value = strUserInfo.LoginName;
sqlPara[1] = new SqlParameter("@userName", SqlDbType.VarChar, 10);
sqlPara[1].Value = strUserInfo.UserName;
sqlPara[2] = new SqlParameter("@EnglishName", SqlDbType.VarChar, 25);
sqlPara[2].Value = strUserInfo.EnglishName;
sqlPara[3] = new SqlParameter("@birthday", SqlDbType.Date);
sqlPara[3].Value = strUserInfo.Birthday;
sqlPara[4] = new SqlParameter("@sex", SqlDbType.VarChar, 2);
sqlPara[4].Value = strUserInfo.Sexy;
sqlPara[5] = new SqlParameter("@school", SqlDbType.VarChar, 50);
sqlPara[5].Value = strUserInfo.GraduteSchool;
sqlPara[6] = new SqlParameter("@job", SqlDbType.VarChar, 10);
sqlPara[6].Value = strUserInfo.Job;
sqlPara[7] = new SqlParameter("@qq", SqlDbType.VarChar, 15);
sqlPara[7].Value = strUserInfo.QQ;
sqlPara[8] = new SqlParameter("@weibo", SqlDbType.VarChar, 50);
sqlPara[8].Value = strUserInfo.Weibo;
sqlPara[9] = new SqlParameter("@msn", SqlDbType.VarChar, 50);
sqlPara[9].Value = strUserInfo.Msn;
sqlPara[10] = new SqlParameter("@mobilPhone", SqlDbType.VarChar, 20);
sqlPara[10].Value = strUserInfo.MobilPhone;
sqlPara[11] = new SqlParameter("@phone", SqlDbType.VarChar, 20);
sqlPara[11].Value = strUserInfo.Phone;
#endregion
int rowCount = 0;
dbCon.RunProcedure("UserDAL_UpdateUserInfo", sqlPara, out rowCount);
if (rowCount > 0)
{
return true;
}
else
{
return false;
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取用户的详细信息
/// </summary>
/// <param name="loginName">登陆名</param>
/// <returns></returns>
public UserInfo GetUserInfo(string loginName)
{
UserInfo myUserInfo = null;
SqlDataReader userData;
SqlParameter[] sqlPara = new SqlParameter[1];
sqlPara[0] = new SqlParameter("@loginName", SqlDbType.VarChar, 50);
sqlPara[0].Value = loginName;
userData = dbCon.RunProcedure("UserDAL_GetUserInfo", sqlPara);
try
{
while (userData.Read())
{
myUserInfo = new UserInfo();
myUserInfo.LoginName = Convert.ToString(userData["LoginName"]);
myUserInfo.UserName = Convert.ToString(userData["Name"]);
myUserInfo.EnglishName = Convert.ToString(userData["EnglishName"]);
myUserInfo.Sexy = Convert.ToString(userData["Sexy"]);
myUserInfo.Birthday = Convert.ToDateTime(userData["Birthday"]);
myUserInfo.GraduteSchool = Convert.ToString(userData["GraduteSchool"]);
myUserInfo.Company = Convert.ToString(userData["Company"]);
myUserInfo.Job = Convert.ToString(userData["Job"]);
myUserInfo.QQ = Convert.ToString(userData["QQ"]);
myUserInfo.Mail = Convert.ToString(userData["Mail"]);
myUserInfo.Msn = Convert.ToString(userData["MSN"]);
myUserInfo.MobilPhone = Convert.ToString(userData["MobilPhone"]);
}
return myUserInfo;
}
catch (Exception ex)
{
throw ex;
}
finally
{
userData.Close();
}
}
/// <summary>
/// 用户账号注册
/// </summary>
/// <param name="user">用户注册信息</param>
/// <returns></returns>
public string UserRegist(UserInfo user)
{
string ret = "fail";
try
{
SqlParameter[] sqlPara = new SqlParameter[6];
sqlPara[0] = new SqlParameter("@userName", SqlDbType.VarChar, 50);
sqlPara[0].Value = user.LoginName;
sqlPara[1] = new SqlParameter("@password", SqlDbType.VarChar, 50);
sqlPara[1].Value = user.Password;
sqlPara[2] = new SqlParameter("@email", SqlDbType.VarChar, 50);
sqlPara[2].Value = user.Mail;
sqlPara[3] = new SqlParameter("@questionID", SqlDbType.Int);
sqlPara[3].Value = user.QuestionID;
sqlPara[4] = new SqlParameter("@answer", SqlDbType.VarChar, 20);
sqlPara[4].Value = user.QuestionAnswer;
sqlPara[5] = new SqlParameter("@strReturn", SqlDbType.VarChar, 50);
sqlPara[5].Direction = System.Data.ParameterDirection.Output;
int rowCount = 0;
dbCon.RunProcedure("UserDAL_Regist", sqlPara, out rowCount);
ret = Convert.ToString(sqlPara[5].Value);
}
catch (Exception ex)
{
throw ex;
}
return ret;
}
/// <summary>
/// 用户登陆
/// </summary>
/// <param name="user">用户信息，用户名与密码</param>
/// <returns></returns>
public string UserLogin(UserInfo user)
{
string ret; //函数返回值，记录数据库返回的密码
try
{
#region 调用执行存储过程
//将用户名与密码传回数据库执行判断
SqlDataReader sqlData = null; //存储数据库返回值的变量
SqlParameter[] sqlPara = new SqlParameter[2];
sqlPara[0] = new SqlParameter("@userName", SqlDbType.VarChar, 50);
sqlPara[0].Value = user.LoginName;
sqlPara[1] = new SqlParameter("@password", SqlDbType.VarChar, 50);
sqlPara[1].Value = user.Password;
sqlData = dbCon.RunProcedure("UserDAL_Login", sqlPara);
#endregion
if (sqlData.Read())
{
//读取存储过程中返回的值
ret = sqlData["Password"].ToString();
}
else
{
ret = "";
}
}
catch (Exception ex)
{
//捕捉异常，写入日志
throw ex;
}
return ret;
}
