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)"); }