/// <summary>
/// 转换SqlDataReader类型数据记录为实体
/// </summary>
private static Entity.AdminUserEntity ConvertToEntityFromDataReader(SqlDataReader reader)
{
Entity.AdminUserEntity entity = new Entity.AdminUserEntity();
entity.Id = Convert.ToInt32(reader["Id"]);
entity.UserName = reader["UserName"].ToString();
entity.PassWord = reader["PassWord"].ToString();
entity.AddTime = Convert.ToDateTime(reader["AddTime"]);
return(entity);
}
/// <summary>
/// 更新数据库中一条记录(根据主键条件)
/// </summary>
/// <param name="entity">Entity.AdminUserEntity实体类</param>
public static void Update(Entity.AdminUserEntity entity)
{
List <SqlParameter> commandParms = new List <SqlParameter>();
commandParms.Add(SqlHelper.CreateParam("@Id", SqlDbType.Int, 0, ParameterDirection.Input, entity.Id));
commandParms.Add(SqlHelper.CreateParam("@UserName", SqlDbType.NVarChar, 50, ParameterDirection.Input, entity.UserName));
commandParms.Add(SqlHelper.CreateParam("@PassWord", SqlDbType.VarChar, 50, ParameterDirection.Input, entity.PassWord));
commandParms.Add(SqlHelper.CreateParam("@AddTime", SqlDbType.DateTime, 0, ParameterDirection.Input, entity.AddTime));
SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, C_SP_ADMINUSER_UPDATE, commandParms);
}
/// <summary>
/// 向数据表中插入一条新记录
/// </summary>
/// <param name="entity">Entity.AdminUserEntity实体类</param>
/// <remarks>如果表存在自增长字段，插入记录成功后自增长字段值会更新至实体</remarks>
public static void Insert(Entity.AdminUserEntity entity)
{
List <SqlParameter> commandParms = new List <SqlParameter>();
SqlParameter id_Id = SqlHelper.CreateParam("@Id", SqlDbType.Int, 0, ParameterDirection.Output, null);
commandParms.Add(id_Id);
commandParms.Add(SqlHelper.CreateParam("@UserName", SqlDbType.NVarChar, 50, ParameterDirection.Input, entity.UserName));
commandParms.Add(SqlHelper.CreateParam("@PassWord", SqlDbType.VarChar, 50, ParameterDirection.Input, entity.PassWord));
commandParms.Add(SqlHelper.CreateParam("@AddTime", SqlDbType.DateTime, 0, ParameterDirection.Input, entity.AddTime));
SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, C_SP_ADMINUSER_INSERT, commandParms);
entity.Id = Convert.ToInt32(id_Id.Value);
}
/// <summary>
/// 获取数据库一条记录实体(根据主键条件)
/// </summary>
/// <param name="id">主键字段id</param>
/// <returns>Entity.AdminUserEntity实体类</returns>
public static Entity.AdminUserEntity GetById(int id)
{
Entity.AdminUserEntity entity = null;
List <SqlParameter> commandParms = new List <SqlParameter>();
commandParms.Add(SqlHelper.CreateParam("@Id", SqlDbType.Int, 0, ParameterDirection.Input, id));
using (SqlDataReader reader = SqlHelper.ExecuteReader(ConnectionString, CommandType.Text, C_SP_ADMINUSER_GET, commandParms))
{
if (reader.Read())
{
entity = ConvertToEntityFromDataReader(reader);
}
}
return(entity);
}
