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