public Entity Add(Entity entity)
{
HoursePrice hoursePrice = entity as HoursePrice;
string sql = "insert into HoursePrice(AreaId,Price,Year,Month)values(@AreaId,@Price,@Year,@Month);select @HoursePriceId = @@IDENTITY";
SqlParameter prmHoursePriceId = new SqlParameter("@HoursePriceId", SqlDbType.Int)
{
Direction = ParameterDirection.Output
};
SqlParameter prmCityId = new SqlParameter("@AreaId", SqlDbType.Int)
{
Value = hoursePrice.AreaId
};
SqlParameter prmPrice = new SqlParameter("@Price", SqlDbType.Int)
{
Value = hoursePrice.Price
};
SqlParameter prmYear = new SqlParameter("@Year", SqlDbType.Int)
{
Value = hoursePrice.Year
};
SqlParameter prmMonth = new SqlParameter("@Month", SqlDbType.Int)
{
Value = hoursePrice.Month
};
ExecuteNoQuery(sql, prmHoursePriceId, prmCityId, prmPrice, prmYear, prmMonth);
hoursePrice.HoursePriceId = (int)prmHoursePriceId.Value;
return(hoursePrice);
}
public Entity Update(Entity entity)
{
HoursePrice hoursePrice = entity as HoursePrice;
string sql = "update hoursePrice set Price = @Price,Year = @Year,Month=@Month,AreaId = @AreaId where HoursePriceId = @HoursePriceId";
SqlParameter prmHoursePriceId = new SqlParameter("@HoursePriceId", SqlDbType.Int)
{
Value = hoursePrice.HoursePriceId
};
SqlParameter prmPrice = new SqlParameter("@Price", SqlDbType.Int)
{
Value = hoursePrice.Price
};
SqlParameter prmYear = new SqlParameter("@Year", SqlDbType.Int)
{
Value = hoursePrice.Year
};
SqlParameter prmMonth = new SqlParameter("@Month", SqlDbType.Int)
{
Value = hoursePrice.Month
};
SqlParameter prmAreaId = new SqlParameter("@AreaId", SqlDbType.Int)
{
Value = hoursePrice.AreaId
};
ExecuteNoQuery(sql, prmHoursePriceId, prmPrice, prmYear, prmMonth, prmAreaId);
return(entity);
}
private Entity GetOne(SqlDataReader reader)
{
if (!reader.HasRows)
{
SetError("房价记录不存在");
return(null);
}
reader.Read();
HoursePrice hoursePrice = new HoursePrice();
hoursePrice.HoursePriceId = reader.GetInt32(0);
hoursePrice.AreaId = reader.GetInt32(1);
hoursePrice.Year = reader.GetInt32(2);
hoursePrice.Month = reader.GetInt32(3);
hoursePrice.Price = reader.GetInt32(4);
return(hoursePrice);
}
private void GetOne()
{
int hoursePriceId = int.Parse(Helper.GetParameterFromRequest("hoursePriceId"));
HoursePrice hoursePrice = new HoursePrice();
hoursePrice.HoursePriceId = hoursePriceId;
HoursePriceRepo Repo = new HoursePriceRepo(hoursePrice);
if (Repo.Query())
{
Helper.Response(hoursePrice.Serialize());
}
else
{
Helper.ResponseError(Repo.ErrorMessage);
}
}
private Entities GetList(SqlDataReader reader)
{
Entities entities = new Entities();
HoursePrice hoursePrice;
while (reader.Read())
{
hoursePrice = new HoursePrice()
{
HoursePriceId = reader.GetInt32(1),
AreaId = reader.GetInt32(2),
Year = reader.GetInt32(3),
Month = reader.GetInt32(4),
Price = reader.GetInt32(5)
};
entities.Add(hoursePrice);
}
return(entities);
}