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