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