public static void FillObject(Business.DataObjectPinboardOffer item, SqlDataReader sqlReader)
{
if (sqlReader["Price"] != DBNull.Value)
{
item.Price = sqlReader["Price"].ToString();
}
item.Amount = (int)sqlReader["Amount"];
}
private static void SetParameters(Business.DataObjectPinboardOffer item, SqlParameterCollection parameters)
{
if (!string.IsNullOrEmpty(item.Price))
{
parameters.AddWithValue("@Price", item.Price);
}
else
{
parameters.AddWithValue("@Price", DBNull.Value);
}
parameters.AddWithValue("@Amount", item.Amount);
}
public static string GetUpdateSQL(Business.DataObjectPinboardOffer item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("UPDATE hiobj_PinboardOffer SET [Price] = @Price, [Amount] = @Amount");
}
public static string GetInsertSQL(Business.DataObjectPinboardOffer item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("INSERT INTO hiobj_PinboardOffer ([OBJ_ID],[Price],[Amount]) VALUES (@OBJ_ID,@Price,@Amount)");
}
