private string EditActivityMedia(NameValueCollection rParams)
{
string res = "{success:false,msg:'编辑失败'}";
//组装参数
ActivityMediaEntity entity = new ActivityMediaEntity();
if (!string.IsNullOrEmpty(rParams["id"]))
{
entity = new ActivityMediaBLL(CurrentUserInfo).GetByID(rParams["id"]);
}
entity = DataLoader.LoadFrom <ActivityMediaEntity>(rParams, entity);
entity.ClientID = CurrentUserInfo.ClientID;
if (!string.IsNullOrEmpty(rParams["id"]))
{
new ActivityMediaBLL(CurrentUserInfo).Update(entity);
}
else
{
new ActivityMediaBLL(CurrentUserInfo).Create(entity);
}
res = "{success:true,msg:'编辑成功',id:'" + entity.ActivityMediaID + "'}";
return(res);
}
public int getEventAlbumsCount(ActivityMediaEntity entity)
{
string sql = getEventAlbumsSql(entity);
sql += " select count(*) count From #tmp a ";
DataSet ds = new DataSet();
var obj = this.SQLHelper.ExecuteScalar(sql);
return(obj == null || obj == DBNull.Value ? 0 : Convert.ToInt32(obj));
}
public string getEventAlbumsSql(ActivityMediaEntity entity)
{
string sql = "select a.* ";
sql += " ,b.FileName,b.Path ";
sql += " ,displayIndex=row_number() over(order by a.CreateTime desc) ";
sql += " into #tmp from ActivityMedia a ";
sql += " left join Attachment b on b.AttachmentID=a.AttachmentID ";
sql += " where a.isDelete='0' ";
sql += " and a.ActivityID='" + entity.ActivityID.ToString() + "' ";
sql += " order by displayIndex ";
return(sql);
}
/// <summary>
/// 活动相册集合
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public DataSet getEventAlbums(ActivityMediaEntity entity, int page, int pageSize)
{
page = page <= 0 ? 1 : page;
pageSize = pageSize <= 0 ? 15 : pageSize;
int beginSize = (page - 1) * pageSize + 1;
int endSize = (page - 1) * pageSize + pageSize;
string sql = getEventAlbumsSql(entity);
sql += " select * From #tmp a where 1=1 and a.displayIndex between '" + beginSize + "' and '" + endSize + "' order by a.displayindex";
DataSet ds = new DataSet();
ds = this.SQLHelper.ExecuteDataset(sql);
return(ds);
}
private string GetActivityMediaList(NameValueCollection rParams)
{
ActivityMediaEntity entity = new ActivityMediaEntity();
string title = Request("MediaTitle").Trim('"');
if (!string.IsNullOrEmpty(title))
{
entity.MediaTitle = title;
}
int pageSize = rParams["limit"].ToInt();
int pageIndex = rParams["page"].ToInt();
int rowCount = 0;
return(string.Format("{{\"totalCount\":{1},\"topics\":{0}}}",
new ActivityMediaBLL(CurrentUserInfo).GetList(entity, pageIndex, pageSize, out rowCount).ToJSON(),
rowCount));
}
/// <summary>
/// 活动相册集合
/// </summary>
public ActivityMediaEntity getEventAlbums(ActivityMediaEntity entity, int page, int pageSize)
{
try
{
var result = new ActivityMediaEntity();
IList <ActivityMediaEntity> list = new List <ActivityMediaEntity>();
DataSet ds = _currentDAO.getEventAlbums(entity, page, pageSize);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
list = DataTableToObject.ConvertToList <ActivityMediaEntity>(ds.Tables[0]);
}
result.ICount = _currentDAO.getEventAlbumsCount(entity);
result.EntityList = list;
return(result);
}
catch (Exception ex)
{
throw (ex);
}
}
/// <summary>
/// 获取拜访任务列表
/// </summary>
/// <param name="entity"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public ActivityMediaEntity[] GetList(ActivityMediaEntity entity, int pageIndex, int pageSize, out int rowCount)
{
List <IWhereCondition> wheres = new List <IWhereCondition>();
if (entity != null && entity.MediaTitle != null)
{
wheres.Add(new LikeCondition()
{
FieldName = "MediaTitle", Value = entity.MediaTitle
});
}
List <OrderBy> orderbys = new List <OrderBy>();
orderbys.Add(new OrderBy()
{
FieldName = "CreateTime", Direction = OrderByDirections.Desc
});
PagedQueryResult <ActivityMediaEntity> pEntity = new ActivityMediaDAO(this.CurrentUserInfo).GetList(wheres.ToArray(), orderbys.ToArray(), pageIndex, pageSize);
rowCount = pEntity.RowCount;
return(pEntity.Entities);
}
public void Update(ActivityMediaEntity pEntity, bool pIsUpdateNullField, IDbTransaction pTran)
{
_currentDAO.Update(pEntity, pIsUpdateNullField, pTran);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Update(ActivityMediaEntity pEntity, IDbTransaction pTran)
{
Update(pEntity, true, pTran);
}
/// <summary>
/// 在事务内创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
/// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param>
public void Create(ActivityMediaEntity pEntity, IDbTransaction pTran)
{
_currentDAO.Create(pEntity, pTran);
}
/// <summary>
/// 创建一个新实例
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Create(ActivityMediaEntity pEntity)
{
_currentDAO.Create(pEntity);
}
/// <summary>
/// 分页根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public PagedQueryResult <ActivityMediaEntity> PagedQueryByEntity(ActivityMediaEntity pQueryEntity, OrderBy[] pOrderBys, int pPageSize, int pCurrentPageIndex)
{
return(_currentDAO.PagedQueryByEntity(pQueryEntity, pOrderBys, pPageSize, pCurrentPageIndex));
}
/// <summary>
/// 根据实体条件查询实体
/// </summary>
/// <param name="pQueryEntity">以实体形式传入的参数</param>
/// <param name="pOrderBys">排序组合</param>
/// <returns>符合条件的实体集</returns>
public ActivityMediaEntity[] QueryByEntity(ActivityMediaEntity pQueryEntity, OrderBy[] pOrderBys)
{
return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="pEntity"></param>
public void Delete(ActivityMediaEntity pEntity)
{
_currentDAO.Delete(pEntity);
}
public void Update(ActivityMediaEntity pEntity, bool pIsUpdateNullField)
{
_currentDAO.Update(pEntity, pIsUpdateNullField);
}
/// <summary>
/// 更新
/// </summary>
/// <param name="pEntity">实体实例</param>
public void Update(ActivityMediaEntity pEntity)
{
Update(pEntity, true);
}
