public IList<CY.UME.Core.Business.Album> GetAlbumByPagesAndAccountId(CY.UME.Core.Business.Account account, PagingInfo pageInfo, int viewPermission)
{
IList<Core.Business.Album> albumlist = new List<Core.Business.Album>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
StringBuilder sbFilter = new StringBuilder();
sbFilter.Append(" [AccountId] = ");
sbFilter.Append(account.Id);
string permission = String.Empty;
if (viewPermission == 0)//�Լ�����
{
;
}
else if (viewPermission == 1)//���ѷ���
{
permission = "(0,1,2)";
}
else if (viewPermission == 2)//İ���˷���
{
permission = "(0,2)";
}
else
{
return albumlist;
}
if (permission.Length != 0)
{
sbFilter.Append(" And ViewPermission in " + permission);
}
sql.AddParameter("@Tables", SqlDbType.VarChar, "Album");
sql.AddParameter("@PK", SqlDbType.VarChar, "Id");
sql.AddParameter("@Filter", SqlDbType.VarChar, sbFilter.ToString());
sql.AddParameter("@Fields", SqlDbType.VarChar, "[Id],[AccountId],[ViewPermission],[DateCreated],[LastModifiedTime],[IsAvatar],[Name],[CoverPath],[ViewPassword]");
sql.AddParameter("@PageNumber", SqlDbType.Int, pageInfo.CurrentPage);
sql.AddParameter("@PageSize", SqlDbType.Int, pageInfo.PageSize);
sql.AddParameter("@sort", SqlDbType.NVarChar, "Id DESC");
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
if (reader != null)
{
while (reader.Read())
{
Core.Business.Album album = new Core.Business.Album();
long id = reader.GetInt64(0);
album = Core.Business.Album.Load(id);
album.MarkOld();
albumlist.Add(album);
}
reader.Close();
}
return albumlist;
}
public Core.Business.Album Select(long id)
{
SqlServerUtility sql = new SqlServerUtility(connectionString);
sql.AddParameter("@Id", SqlDbType.BigInt, id);
SqlDataReader reader = sql.ExecuteSPReader("USP_Album_Select_By_Id");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.Album album = new Core.Business.Album();
if (!reader.IsDBNull(0)) album.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) album.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) album.ViewPermission = reader.GetInt32(2);
if (!reader.IsDBNull(3)) album.DateCreated = reader.GetDateTime(3);
if (!reader.IsDBNull(4)) album.LastModifiedTime = reader.GetDateTime(4);
if (!reader.IsDBNull(5)) album.IsAvatar = reader.GetBoolean(5);
if (!reader.IsDBNull(6)) album.Name = reader.GetString(6);
if (!reader.IsDBNull(7)) album.CoverPath = reader.GetString(7);
if (!reader.IsDBNull(8)) album.ViewPassword = reader.GetString(8);
reader.Close();
return album;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IList<Core.Business.Album> GetAllAlbum()
{
IList<Core.Business.Album> albumlist = new List<Core.Business.Album>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
SqlDataReader reader = sql.ExecuteSPReader("USP_Album_SelectAll");
if (reader != null)
{
while (reader.Read())
{
Core.Business.Album album = new Core.Business.Album();
long id = reader.GetInt64(0);
album = Core.Business.Album.Load(id);
/*
if (!reader.IsDBNull(0)) album.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) album.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) album.ViewPermission = reader.GetInt32(2);
if (!reader.IsDBNull(3)) album.DateCreated = reader.GetDateTime(3);
if (!reader.IsDBNull(4)) album.LastModifiedTime = reader.GetDateTime(4);
if (!reader.IsDBNull(5)) album.IsAvatar = reader.GetBoolean(5);
if (!reader.IsDBNull(6)) album.Name = reader.GetString(6);
if (!reader.IsDBNull(7)) album.CoverPath = reader.GetString(7);
if (!reader.IsDBNull(8)) album.ViewPassword = reader.GetString(8);
*/
album.MarkOld();
albumlist.Add(album);
}
reader.Close();
}
return albumlist;
}
public List<Core.Business.Album> GetAll(Core.Business.Account account, bool? isAvatar)
{
List<Core.Business.Album> albumlist = new List<Core.Business.Album>();
SqlServerUtility sql = new SqlServerUtility(connectionString);
StringBuilder sbFilter = new StringBuilder();
sbFilter.Append(" [AccountId] = ");
sbFilter.Append(account.Id);
if (isAvatar.HasValue)
{
sbFilter.Append(" And [IsAvatar] = ");
sbFilter.Append(isAvatar.Value ? "1" : "0");
}
sql.AddParameter("@Tables", SqlDbType.VarChar, "Album");
sql.AddParameter("@PK", SqlDbType.VarChar, "Id");
sql.AddParameter("@Filter", SqlDbType.VarChar, sbFilter.ToString());
sql.AddParameter("@Fields", SqlDbType.VarChar, "[Id],[AccountId],[ViewPermission],[DateCreated],[LastModifiedTime],[IsAvatar],[Name],[CoverPath],[ViewPassword]");
sql.AddParameter("@PageNumber", SqlDbType.Int, 1);
sql.AddParameter("@PageSize", SqlDbType.Int, int.MaxValue);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
if (reader != null)
{
while (reader.Read())
{
Core.Business.Album album = new Core.Business.Album();
long id = reader.GetInt64(0);
album = Core.Business.Album.Load(id);
/*
if (!reader.IsDBNull(0)) album.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) album.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) album.ViewPermission = reader.GetInt32(2);
if (!reader.IsDBNull(3)) album.DateCreated = reader.GetDateTime(3);
if (!reader.IsDBNull(4)) album.LastModifiedTime = reader.GetDateTime(4);
if (!reader.IsDBNull(5)) album.IsAvatar = reader.GetBoolean(5);
if (!reader.IsDBNull(6)) album.Name = reader.GetString(6);
if (!reader.IsDBNull(7)) album.CoverPath = reader.GetString(7);
if (!reader.IsDBNull(8)) album.ViewPassword = reader.GetString(8);
*/
album.MarkOld();
albumlist.Add(album);
}
reader.Close();
}
return albumlist;
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
string AccountIdTemp = context.Request.Params["accountId"];
string albumIdTemp = context.Request.Params["albumId"];
string albumName = context.Request.Params["albumName"];
string selViewPermission = context.Request.Params["selViewPermission"];
string viewPassword = context.Request.Params["ViewPassword"];
int viewPermission = 0;
long accountId = 0;
long albumId = 0;
CY.UME.Core.Business.Album album = null;
int.TryParse(selViewPermission, out viewPermission);
if (albumName.Length == 0)
{
context.Response.Write("{success:false,msg:'相册名称不能为空!'}");
return;
}
if (!long.TryParse(AccountIdTemp, out accountId))
{
return;
}
if (albumIdTemp != "0" && long.TryParse(albumIdTemp, out albumId))
{//编辑相册
album = Core.Business.Album.Load(albumId);
}
else
{//添加相册
album = new Core.Business.Album();
album.DateCreated = DateTime.Now;
}
album.AccountId = accountId;
album.LastModifiedTime = DateTime.Now;
album.Name = albumName;
album.ViewPermission = viewPermission;
CY.Security.SecurityHelper sh = new CY.Security.SecurityHelper();
if (viewPermission == 2)
{
if (viewPassword != "" && viewPassword.Length > 0)
{
album.ViewPassword = sh.ComputeMD5Hash(viewPassword);
}
}
album.Save();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("{success:true,msg:'操作成功!',Album:[");
if (album.ViewPermission == 2)
{
album.CoverPath = CY.UME.Core.Global.AlbumCoverNoPublishAddress;
}
else if (album.PhotoCount == 0)
album.CoverPath = CY.UME.Core.Global.AlbumCoverAddress;
sb.Append("{Id:");
sb.Append(album.Id);
sb.Append(",Name:'");
sb.Append(album.Name);
sb.Append("',CoverPath:'");
sb.Append(album.CoverPath);
sb.Append("',ViewPermission:'");
sb.Append(album.ViewPermission);
sb.Append("',ViewPassword:'******',DateCreated:'");
sb.Append(album.DateCreated.ToString("yyyy年MM月dd日"));
sb.Append("',LastModifiedTime:'");
sb.Append(album.LastModifiedTime.ToString("yyyy年MM月dd日"));
sb.Append("',PicCount:'");
sb.Append(album.PhotoCount.ToString());
sb.Append("',IsAvatar:");
if (album.IsAvatar)
sb.Append("true");
else
sb.Append("false");
sb.Append("}]}");
context.Response.Write(sb.ToString());
}
public IList<CY.UME.Core.Business.Album> GetGroupAlbum(CY.UME.Core.Business.Group group, int viewpermission, CY.UME.Core.PagingInfo pagingInfo)
{
List<Core.Business.Album> albumlist = new List<Core.Business.Album>();
if (group == null)
{
return albumlist;
}
SqlServerUtility sql = new SqlServerUtility(SqlConnection);
string filter = "id in (select id from albumExtend where [type]='group' and instanceid =" + group.Id + ")";
if (viewpermission == 1)
{
filter += " and viewpermission=" + viewpermission;
}
sql.AddParameter("@Tables", SqlDbType.VarChar, "Album");
sql.AddParameter("@PK", SqlDbType.VarChar, "Id DESC");
sql.AddParameter("@Filter", SqlDbType.VarChar, filter);
sql.AddParameter("@Fields", SqlDbType.VarChar, "[Id],[AccountId],[ViewPermission],[DateCreated],[LastModifiedTime],[IsAvatar],[Name],[CoverPath],[ViewPassword]");
sql.AddParameter("@PageNumber", SqlDbType.Int, pagingInfo.CurrentPage);
sql.AddParameter("@PageSize", SqlDbType.Int, pagingInfo.PageSize);
SqlDataReader reader = sql.ExecuteSPReader("Paging_RowCount");
if (reader != null)
{
while (reader.Read())
{
Core.Business.Album album = new Core.Business.Album();
long id = reader.GetInt64(0);
if (!reader.IsDBNull(0)) album.Id = reader.GetInt64(0);
if (!reader.IsDBNull(1)) album.AccountId = reader.GetInt64(1);
if (!reader.IsDBNull(2)) album.ViewPermission = reader.GetInt32(2);
if (!reader.IsDBNull(3)) album.DateCreated = reader.GetDateTime(3);
if (!reader.IsDBNull(4)) album.LastModifiedTime = reader.GetDateTime(4);
if (!reader.IsDBNull(5)) album.IsAvatar = reader.GetBoolean(5);
if (!reader.IsDBNull(6)) album.Name = reader.GetString(6);
if (!reader.IsDBNull(7)) album.CoverPath = reader.GetString(7);
if (!reader.IsDBNull(8)) album.ViewPassword = reader.GetString(8);
album.MarkOld();
albumlist.Add(album);
}
reader.Close();
}
return albumlist;
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
string groupIdStr = context.Request.Params["groupId"]; //群组ID
string albumName = context.Request.Params["albumName"]; //相册名称
string viewPermissionStr = context.Request.Params["viewPermission"]; //浏览权限
string albumIdStr = context.Request.Params["aid"]; //相册ID
string accountIdStr = context.Request.Params["accountId"]; //用户ID
int viewPermission = 1;//默认为所有人可以访问
int groupId;
long albumId = 0;
long accountId = 0;
int.TryParse(viewPermissionStr, out viewPermission);
long.TryParse(accountIdStr, out accountId);
if (albumIdStr.Trim().Length==0)
{
CY.UME.Core.Business.Group group;
CY.UME.Core.Business.Album album = new Core.Business.Album();
if (albumName.Trim().Length == 0)
{
context.Response.Write("{success:false,msg:'相册名不能为空'}");
return;
}
if (int.TryParse(groupIdStr, out groupId))
{
group = CY.UME.Core.Business.Group.Load(groupId);
if (group == null)
{
context.Response.Write("{success:false,msg:'该群组不存在或已被删除'}");
return;
}
}
else
{
context.Response.Write("{success:false,msg:'该群组不存在或已被删除'}");
return;
}
album = group.CreateGroupAlbum(albumName, viewPermission);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("{success:true,msg:'操作成功!',Album:[");
//if (album.ViewPermission == 2)
//{
// album.CoverPath = CY.UME.Core.Global.AlbumCoverNoPublishAddress;
//}
//else if (album.PhotoCount == 0)
//album.CoverPath = CY.UME.Core.Global.AlbumCoverAddress;
sb.Append("{Id:");
sb.Append(album.Id);
sb.Append(",AccountId:");
sb.Append(accountId);
sb.Append(",Name:'");
sb.Append(album.Name);
sb.Append("',CoverPath:'");
sb.Append(album.CoverPath);
sb.Append("',ViewPermission:'");
sb.Append(album.ViewPermission);
sb.Append("',ViewPassword:'******',DateCreated:'");
sb.Append(album.DateCreated.ToString("yyyy年MM月dd日"));
sb.Append("',LastModifiedTime:'");
sb.Append(album.LastModifiedTime.ToString("yyyy年MM月dd日"));
sb.Append("',PicCount:'");
sb.Append(album.PhotoCount.ToString());
sb.Append("',IsAvatar:");
if (album.IsAvatar)
sb.Append("true");
else
sb.Append("false");
sb.Append("}]}");
context.Response.Write(sb.ToString());
}
else
{
if (long.TryParse(albumIdStr, out albumId))
{
CY.UME.Core.Business.Album album = CY.UME.Core.Business.Album.Load(albumId);
if (album != null)
{
album.Name = albumName;
album.ViewPermission = viewPermission;
album.Save();
}
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("{success:true,msg:'操作成功!',Album:[");
sb.Append("{Id:");
sb.Append(album.Id);
sb.Append(",Name:'");
sb.Append(album.Name);
sb.Append("',CoverPath:'");
sb.Append(album.CoverPath);
sb.Append("',ViewPermission:'");
sb.Append(album.ViewPermission);
sb.Append("',ViewPassword:'******',DateCreated:'");
sb.Append(album.DateCreated.ToString("yyyy年MM月dd日"));
sb.Append("',LastModifiedTime:'");
sb.Append(album.LastModifiedTime.ToString("yyyy年MM月dd日"));
sb.Append("',PicCount:'");
sb.Append(album.PhotoCount.ToString());
sb.Append("',IsAvatar:");
if (album.IsAvatar)
{
sb.Append("true");
}
else
{
sb.Append("false");
}
sb.Append("}]}");
context.Response.Write(sb.ToString());
}
}
}
