public static void FillObject(Business.DataObjectPage item, SqlDataReader sqlReader)
{
if (sqlReader["MetaTag"] != DBNull.Value)
{
item.MetaTag = sqlReader["MetaTag"].ToString();
}
if (sqlReader["VirtualURL"] != DBNull.Value)
{
item.VirtualURL = sqlReader["VirtualURL"].ToString();
}
item.PageType = (PageType)Enum.Parse(typeof(PageType), sqlReader["PageType"].ToString());
}
private static void SetParameters(Business.DataObjectPage item, SqlParameterCollection parameters)
{
if (!string.IsNullOrEmpty(item.MetaTag))
{
parameters.AddWithValue("@MetaTag", item.MetaTag);
}
else
{
parameters.AddWithValue("@MetaTag", DBNull.Value);
}
if (!string.IsNullOrEmpty(item.VirtualURL))
{
parameters.AddWithValue("@VirtualURL", item.VirtualURL);
}
else
{
parameters.AddWithValue("@VirtualURL", DBNull.Value);
}
parameters.AddWithValue("@PageType", item.PageType);
}
public static string GetUpdateSQL(Business.DataObjectPage item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("UPDATE hiobj_Page SET [MetaTag] = @MetaTag, [VirtualURL] = @VirtualURL, [PageType] = @PageType");
}
public static string GetInsertSQL(Business.DataObjectPage item, SqlParameterCollection parameters)
{
SetParameters(item, parameters);
return("INSERT INTO hiobj_Page ([OBJ_ID],[MetaTag],[VirtualURL],[PageType]) VALUES (@OBJ_ID,@MetaTag,@VirtualURL,@PageType)");
}
