/// <summary>
/// 转换SqlDataReader类型数据记录为实体
/// </summary>
private static Entity.UrlEntity ConvertToEntityFromDataReader(SqlDataReader reader)
{
Entity.UrlEntity entity = new Entity.UrlEntity();
entity.Id = Convert.ToInt32(reader["Id"]);
entity.WebUrl = reader["WebUrl"].ToString();
entity.Host = reader["Host"].ToString();
entity.Url = reader["Url"].ToString();
entity.IsUser = Convert.ToBoolean(reader["IsUser"]);
entity.Depth = Convert.ToInt32(reader["Depth"]);
entity.AddDate = Convert.ToDateTime(reader["AddDate"]);
return(entity);
}
/// <summary>
/// 更新数据库中一条记录(根据主键条件)
/// </summary>
/// <param name="entity">Entity.UrlEntity实体类</param>
public static void Update(Entity.UrlEntity entity)
{
List <SqlParameter> commandParms = new List <SqlParameter>();
commandParms.Add(SqlHelper.CreateParam("@Id", SqlDbType.Int, 0, ParameterDirection.Input, entity.Id));
commandParms.Add(SqlHelper.CreateParam("@WebUrl", SqlDbType.NVarChar, 200, ParameterDirection.Input, entity.WebUrl));
commandParms.Add(SqlHelper.CreateParam("@Host", SqlDbType.VarChar, 50, ParameterDirection.Input, entity.Host));
commandParms.Add(SqlHelper.CreateParam("@Url", SqlDbType.NVarChar, 200, ParameterDirection.Input, entity.Url));
commandParms.Add(SqlHelper.CreateParam("@IsUser", SqlDbType.Bit, 0, ParameterDirection.Input, entity.IsUser));
commandParms.Add(SqlHelper.CreateParam("@Depth", SqlDbType.Int, 0, ParameterDirection.Input, entity.Depth));
commandParms.Add(SqlHelper.CreateParam("@AddDate", SqlDbType.DateTime, 0, ParameterDirection.Input, entity.AddDate));
SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, C_SP_URL_UPDATE, commandParms);
}
/// <summary>
/// 向数据表中插入一条新记录
/// </summary>
/// <param name="entity">Entity.UrlEntity实体类</param>
/// <remarks>如果表存在自增长字段，插入记录成功后自增长字段值会更新至实体</remarks>
public static void Insert(Entity.UrlEntity 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("@WebUrl", SqlDbType.NVarChar, 200, ParameterDirection.Input, entity.WebUrl));
commandParms.Add(SqlHelper.CreateParam("@Host", SqlDbType.VarChar, 50, ParameterDirection.Input, entity.Host));
commandParms.Add(SqlHelper.CreateParam("@Url", SqlDbType.NVarChar, 200, ParameterDirection.Input, entity.Url));
commandParms.Add(SqlHelper.CreateParam("@IsUser", SqlDbType.Bit, 0, ParameterDirection.Input, entity.IsUser));
commandParms.Add(SqlHelper.CreateParam("@Depth", SqlDbType.Int, 0, ParameterDirection.Input, entity.Depth));
commandParms.Add(SqlHelper.CreateParam("@AddDate", SqlDbType.DateTime, 0, ParameterDirection.Input, entity.AddDate));
SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.Text, C_SP_URL_INSERT, commandParms);
entity.Id = Convert.ToInt32(id_Id.Value);
}
/// <summary>
/// 获取数据库一条记录实体(根据主键条件)
/// </summary>
/// <param name="id">主键字段id</param>
/// <returns>Entity.UrlEntity实体类</returns>
public static Entity.UrlEntity GetById(int id)
{
Entity.UrlEntity 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_URL_GET, commandParms))
{
if (reader.Read())
{
entity = ConvertToEntityFromDataReader(reader);
}
}
return(entity);
}
/// <summary>
/// 向数据表中插入一条新记录
/// </summary>
/// <param name="entity">Entity.UrlEntity实体类</param>
/// <remarks>如果表存在自增长字段，插入记录成功后自增长字段值会更新至实体</remarks>
public static void Insert(Entity.UrlEntity entity)
{
UrlDAL.Insert(entity);
}
