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