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