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