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); }