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