for (int i = 0; i < photoIds.Count; i++) {

string PID = (string)photoIds[i]; PHOTOID = PHOTOID + PID + ",";

}

PHOTOID = PHOTOID.Remove(PHOTOID.Length - 1);

string SQL_DEL_PHOTOS = "delete from PHOTO_PHOTOS where PHOTOID in (" + PHOTOID + ")";

bool result = DataAccess.ExecuteNonQuery(SQL_DEL_PHOTOS); return result;

}

public static bool updatePhotosAlbumId(string AlbumName, ArrayList photoIds) {

string TrasALm = "update PHOTO_PHOTOS set ALBUMID=(select ALBUMID from PHOTO_ALBUMS where ALBUMNAME='" + AlbumName + "') where PHOTOID in ("; for (int i = 0; i < photoIds.Count; i++) {

string PID = (string)photoIds[i]; TrasALm = TrasALm + PID + ","; }

TrasALm = TrasALm.Remove(TrasALm.Length - 1); TrasALm = TrasALm + ")";

bool result = DataAccess.ExecuteNonQuery(TrasALm); return result; }

public static string GetPhototype(string photoid) {

String SQL_GET_PHOTOTYPE = @"select PHOTOTYPE from PHOTO_PHOTOS where PHOTOID=" + photoid;

string phototype = (string)DataAccess.ExecuteScalar(SQL_GET_PHOTOTYPE); return phototype; } }

}

3.用户管理类 using System.Data; using Edu.Sovo.OACF;

using System.Data.SqlClient;

namespace erBLL