public User GetUserByUserName(string userName)
{
User user = new User();
string sql = "select * from Tb_User where UserName=@UserName";
SqlParameter[] parms = SqlHelperParameterCache.GetCachedParameterSet(sql);
if (parms == null)
{
parms = new SqlParameter[] {
new SqlParameter("@UserName",SqlDbType.NVarChar,15)
};
SqlHelperParameterCache.CacheParameterSet(sql, parms);
}
parms[0].Value = userName;
using (SqlDataReader dr = SqlHelper.ExecuteReader(connString, CommandType.Text, sql, parms))
{
RowHelper row = new RowHelper(dr);
if (row.Read())
{
user.UserID = row.GetInt32("UserID");
user.LastLoginIP = row.GetString("LastLoginIP");
user.LastLoginTime = row.GetDateTime("LastLoginTime");
user.RegTime = row.GetDateTime("RegTime");
user.Server = row.GetString("Server");
user.Status = row.GetUInt32("Status");
user.UserName = row.GetString("UserName");
user.UserPwd = row.GetString("UserPwd");
}
dr.Close();
}
return user;
}
public User GetUserByUserID(int userID)
{
User user = new User();
string sql = "select * from Tb_User where UserID=@UserID";
SqlParameter[] parms = SqlHelperParameterCache.GetCachedParameterSet(sql);
if (parms == null)
{
parms = new SqlParameter[] {
new SqlParameter("@UserID", SqlDbType.BigInt)
};
SqlHelperParameterCache.CacheParameterSet(sql, parms);
}
parms[0].Value = userID;
using (SqlDataReader dr = SqlHelper.ExecuteReader(connString, CommandType.Text, sql, parms))
{
RowHelper row = new RowHelper(dr);
if (row.Read())
{
user.UserID = row.GetInt32("UserID");
user.LastLoginIP = row.GetString("LastLoginIP");
user.LastLoginTime = row.GetDateTime("LastLoginTime");
user.RegTime = row.GetDateTime("RegTime");
user.Server = row.GetString("Server");
user.Status = row.GetUInt32("Status");
user.UserName = row.GetString("UserName");
user.UserPwd = row.GetString("UserPwd");
}
dr.Close();
}
return(user);
}
private UserInfo FillUserInfo(RowHelper row)
{
UserInfo userInfo = null;
if (row.Read())
{
userInfo = new UserInfo()
{
Age = row.GetInt32("Age"),
BirthDay = row.GetDateTime("BirthDay"),
Email = row.GetString("Email"),
NickName = row.GetString("NickName"),
Sex = row.GetInt16("Sex"),
UserID = row.GetInt32("UserID")
};
}
return(userInfo);
}
private UserInfo FillUserInfo(RowHelper row)
{
UserInfo userInfo = null;
if (row.Read())
{
userInfo = new UserInfo()
{
Age = row.GetInt32("Age"),
BirthDay = row.GetDateTime("BirthDay"),
Email = row.GetString("Email"),
NickName = row.GetString("NickName"),
Sex = row.GetInt16("Sex"),
UserID = row.GetInt32("UserID")
};
}
return userInfo;
}