62,243
社区成员




/// <summary>
/// 根据ID得用户表实体
/// </summary>
/// <param name="Id">主键ID</param>
/// <returns>实体</returns>
public static UserInfo GetUserInfoEntity(int Id)
{
string strSql = "select * from UserInfo where userId = " + Id;
SqlDataReader reader = SqlHelper.GetDataReader(strSql);
if (reader.Read())
{
UserInfo user = new UserInfo();
user.UserId = int.Parse(reader["userId"]);
user.UserName = reader["userName"].ToString();
user.UserTime = (DateTime?)reader["userTime"];
return user;
}
else
{
reader.Close();
return null;
}
}
UserInfo实体表
public class UserInfo
{
private int _userId;
/// <summary>
/// 主键ID
/// </summary>
public int UserId
{
get { return _userId; }
set { _userId = value; }
}
private string _userName;
/// <summary>
/// 用户名
/// </summary>
public string UserName
{
get { return _userName; }
set { _userName = value; }
}
private Nullable<DateTime> userTime;
/// <summary>
/// 用户注册时间
/// </summary>
public Nullable<DateTime>UserTime
{
get { return _userName; }
set { _userName = value; }
}
}
user.UserTime=Convert.ToDateTime(DBNull.Value==reader["userTime"]?"1900-01-01":reader["userTime"]);
user.UserTime = reader["userTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)reader["userTime"];