/// <summary>
/// 根据ID查找数据给模型
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public User GetById(long id)
{
string sql = "select * from t_users where userid=@id";
DataTable dt = SqlHelper.ExecuteQuery(sql, new SqlParameter("@id", id));
if (dt.Rows.Count <= 0)
{
return null;
}
else
{
DataRow row = dt.Rows[0];
User user = new User();
user.UserId = (long)row["userid"];
user.UserName = (string)row["username"];
user.PassWord = (string)row["password"];
user.Age = row.IsNull("age") ? null : (int?)row["Age"];//将数据库中可能为空的的数据加载到模型中
user.IsDeleted = (bool)row["IsDeleted"];
return user;
}
}
/// 根据ID查找数据给模型
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public User GetById(long id)
{
string sql = "select * from t_users where userid=@id";
DataTable dt = SqlHelper.ExecuteQuery(sql, new SqlParameter("@id", id));
if (dt.Rows.Count <= 0)
{
return null;
}
else
{
DataRow row = dt.Rows[0];
User user = new User();
user.UserId = (long)row["userid"];
user.UserName = (string)row["username"];
user.PassWord = (string)row["password"];
user.Age = row.IsNull("age") ? null : (int?)row["Age"];//将数据库中可能为空的的数据加载到模型中
user.IsDeleted = (bool)row["IsDeleted"];
return user;
}
}