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