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

ALBUMNAME=@ALBUMNAME, DESCRIPTION=@DESCRIPTION where ALBUMID=@ALBUMID"; public static bool updateAlbum(Dictionary<string, string> NewAlbumInfo) {

return DataAccess.ExecuteNonQuery(SQL_UPDA_BY_ALBUMID, NewAlbumInfo); }

private static String SQL_ALBUM_BY_ALBUMID = @"select distinct ALBUMNAME, DESCRIPTION from PHOTO_ALBUMS where ALBUMID=@ALBUMID order by ALBUMNAME";

public static Dictionary<String, String> getAlbum(string albumId) {

return DataAccess.ExecuteToSet(SQL_ALBUM_BY_ALBUMID, "ALBUMID", albumId); } } }

2.照片管理类

using System.Data; using Edu.Sovo.OACF; namespace Services.PhotoBll {

public class PhotoService {

public static DataSet searchPhoto(string PHOTONAME, string ALBUMNAME, string DESCRIPTION, string ALBUMID, string StartTime, string EndTime) {

string SQL_SearchPhoto = "select distinct ph.PHOTOID,ph.PHOTONAME,ph.DESCRIPTION, ph.SCREENDATE from PHOTO_PHOTOS ph inner join PHOTO_ALBUMS al on al.ALBUMID=ph.ALBUMID"; QueryHelper qh = new QueryHelper(SQL_SearchPhoto, "order by ph.SCREENDATE desc"); qh.setParam(QueryHelper.IsNotBlank(PHOTONAME), " PHOTONAME like '%'+@PHOTONAME+'%'", "PHOTONAME", PHOTONAME);

qh.setParam(QueryHelper.IsNotBlank(ALBUMNAME), "al.ALBUMNAME=@ALBUMNAME", "ALBUMNAME", ALBUMNAME);

qh.setParam(QueryHelper.IsNotBlank(DESCRIPTION), "ph.DESCRIPTION=@DESCRIPTION", "DESCRIPTION", DESCRIPTION);

qh.setParam(QueryHelper.IsNotBlank(ALBUMID), "al.ALBUMID=@ALBUMID", "ALBUMID", ALBUMID);

qh.setParam(QueryHelper.IsNotBlank(StartTime),

"datediff(day,Convert(DateTime,@StartTime),ph.SCREENDATE)>=0", "StartTime", StartTime); qh.setParam(QueryHelper.IsNotBlank(EndTime),

"datediff(day,Convert(DateTime,@EndTime),ph.SCREENDATE)<=0", "EndTime", EndTime); return DataAccess.ExecuteToDataSet(qh.getQuerySql(), qh.getParams()); }=

public static DataSet getStatByMonth() {

string PhotoStaticStr = "select

convert(varchar(4),datepart(yy,SCREENDATE))+'-'+convert(varchar(4),datepart(mm,SCREENDATE))a