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

else {

return albumid.ToString(); }

}

private static String SQL_ALBUM_BY_ALBUMID = @"select

PHOTONAME,SCREENDATE,DESCRIPTION,PHOTOID from PHOTO_PHOTOS where ALBUMID=@albumId order by SCREENDATE desc";

public static DataSet getPhotosByAlbumId(string albumId) {

DataSet ds = DataAccess.ExecuteToDataSet(SQL_ALBUM_BY_ALBUMID, "ALBUMID", albumId);

return ds; }

private static String SQL_GetOther_BY_ALBUMID = @"select ALBUMNAME from PHOTO_ALBUMS where ALBUMID!=@ALBUMID";

public static DataSet getAlbumList(string Albumid) {

DataSet ds = DataAccess.ExecuteToDataSet(SQL_GetOther_BY_ALBUMID, "ALBUMID", Albumid);

return ds; }

private static String SQL_GetALBUMNAME_BY_ALBUMID = @"select ALBUMNAME from PHOTO_ALBUMS where ALBUMID=@ALBUMID";

public static string getAlbumNameByAlbumId(string albumId) {

return (string)DataAccess.ExecuteScalar(SQL_GetALBUMNAME_BY_ALBUMID, "ALBUMID", albumId); }

private static String SQL_ADD_PHOTO = @"insert into

PHOTO_PHOTOS(PHOTONAME,ALBUMID,SCREENDATE,DESCRIPTION,PHOTOTYPE)values(@PHOTONAME,@ALBUMID,@SCREENDATE,@DESCRIPTION,@PHOTOTYPE)select scope_identity()";

public static string addPhoto(Dictionary<string, string> PhotoInfo) {

return DataAccess.ExecuteScalar(SQL_ADD_PHOTO, PhotoInfo).ToString();

}

public static bool deletePhotos(ArrayList photoIds) {

string PHOTOID = "";