综合实训报告测试版(9)

if (StrAlbumeID_Old == AlbumID) {

return true; } else {

return false; } } else {

return false; }

}

public static DataSet getAlbums() {

string getalbumlist = "select distinct al.ALBUMNAME,al.ALBUMID,

al.BUILDDATE,count(ph.PHOTOID)AS PHOTONUM from PHOTO_ALBUMS al LEFT outer join PHOTO_PHOTOS ph on al.ALBUMID=ph.ALBUMID group by al.ALBUMID,al.ALBUMNAME, al.BUILDDATE order by al.BUILDDATE desc";

DataSet ds = DataAccess.ExecuteToDataSet(getalbumlist); return ds; }

private static String SQL_DEL_BY_ALBUMID = @"delete from PHOTO_ALBUMS where ALBUMID=@ALBUMID";

public static void deleteAlbum(long albumId) {

bool boresult = DataAccess.ExecuteNonQuery(SQL_DEL_BY_ALBUMID, "ALBUMID", Convert.ToString(albumId)); }

private static String SQL_INSERT_ALBUM = @"insert into

PHOTO_ALBUMS(ALBUMNAME,DESCRIPTION,BUILDDATE) values (@ALBUMNAME,@DESCRIPTION,@BUILDDATE)"; public static bool insertAlbum(Dictionary<string, string> AlbumInfo) {

bool result = DataAccess.ExecuteNonQuery(SQL_INSERT_ALBUM, AlbumInfo, CommandType.Text); return result; }

private static String SQL_UPDA_BY_ALBUMID = @"update PHOTO_ALBUMS set