public bool DeleteByIds(string propIds, TagsTypeEntity TagsTypeEn) { string sql = "update Tags set "; sql += " isdelete=1 "; sql += " ,LastUpdateBy='" + TagsTypeEn.LastUpdateBy + "' "; sql += " ,LastUpdateTime='" + TagsTypeEn.LastUpdateTime + "' "; sql += " where TypeId='" + TagsTypeEn.TypeId + "'"; sql += " and TagsId not in (" + propIds + ") "; this.SQLHelper.ExecuteNonQuery(sql); return(true); }
/// <summary> /// GetList /// </summary> /// <param name="entity">entity</param> /// <param name="Page">分页页码。从0开始</param> /// <param name="PageSize">每页的数量。未指定时默认为15</param> /// <returns></returns> public IList <TagsTypeEntity> GetList(TagsTypeEntity entity, int Page, int PageSize) { if (PageSize <= 0) { PageSize = 15; } IList <TagsTypeEntity> list = new List <TagsTypeEntity>(); DataSet ds = new DataSet(); ds = _currentDAO.GetList(entity, Page, PageSize); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { list = DataTableToObject.ConvertToList <TagsTypeEntity>(ds.Tables[0]); } return(list); }
/// <summary> /// 删除 /// </summary> public string DeleteTagsType(string pRequest) { var rp = pRequest.DeserializeJSONTo <APIRequest <DeleteTagsTypeRP> >(); var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; var rd = new DeleteTagsTypeRD();//返回值 var TypeId = rp.Parameters.TypeId; if (string.IsNullOrEmpty(TypeId)) { throw new APIException("缺少参数【TypeId】或参数值为空") { ErrorCode = 135 }; } TagsTypeBLL TagsTypeBLL = new TagsTypeBLL(loggingSessionInfo); TagsTypeEntity TagsTypeEn = TagsTypeBLL.GetByID(TypeId); if (TagsTypeEn == null) { throw new APIException("没有找到对应的标签类型") { ErrorCode = 135 }; } var rsp = new SuccessResponse <IAPIResponseData>(rd); //查看标签是否已经被使用 DataSet ds = TagsTypeBLL.HasUse(TypeId); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { rsp.ResultCode = 310; rsp.Message = "该标签类型下面的标签已经被使用"; return(rsp.ToJSON()); } //虚拟删除标签类型和下面的标签 TagsTypeBLL.DeleteTagsType(TypeId); return(rsp.ToJSON()); }
/// <summary> /// /// </summary> public string GetTagsTypeData() { var billService = new TagsTypeBLL(new SessionManager().CurrentUserLoginInfo); var queryEntity = new TagsTypeEntity(); queryEntity.CustomerId = CurrentUserInfo.CurrentUser.customer_id; var list = billService.GetList(queryEntity, 0, 100); string content = string.Empty; var jsonData = new JsonData(); jsonData.totalCount = list.Count.ToString(); jsonData.data = list; content = jsonData.ToJSON(); return(content); }
public void Update(TagsTypeEntity 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(TagsTypeEntity pEntity, IDbTransaction pTran) { Update(pEntity, true, pTran); }
/// <summary> /// 在事务内创建一个新实例 /// </summary> /// <param name="pEntity">实体实例</param> /// <param name="pTran">事务实例,可为null,如果为null,则不使用事务来更新</param> public void Create(TagsTypeEntity pEntity, IDbTransaction pTran) { _currentDAO.Create(pEntity, pTran); }
/// <summary> /// 创建一个新实例 /// </summary> /// <param name="pEntity">实体实例</param> public void Create(TagsTypeEntity pEntity) { _currentDAO.Create(pEntity); }
/// <summary> /// 分页根据实体条件查询实体 /// </summary> /// <param name="pQueryEntity">以实体形式传入的参数</param> /// <param name="pOrderBys">排序组合</param> /// <returns>符合条件的实体集</returns> public PagedQueryResult <TagsTypeEntity> PagedQueryByEntity(TagsTypeEntity 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 TagsTypeEntity[] QueryByEntity(TagsTypeEntity pQueryEntity, OrderBy[] pOrderBys) { return(_currentDAO.QueryByEntity(pQueryEntity, pOrderBys)); }
/// <summary> /// 删除 /// </summary> /// <param name="pEntity"></param> public void Delete(TagsTypeEntity pEntity) { _currentDAO.Delete(pEntity); }
public void Update(TagsTypeEntity pEntity, bool pIsUpdateNullField) { _currentDAO.Update(pEntity, pIsUpdateNullField); }
/// <summary> /// 更新 /// </summary> /// <param name="pEntity">实体实例</param> public void Update(TagsTypeEntity pEntity) { Update(pEntity, true); }
/// <summary> /// 根据id删除信息 /// </summary> /// <param name="propIds"></param> /// <param name="propInfo"></param> /// <returns></returns> public bool DeleteByIds(string propIds, TagsTypeEntity TagsTypeEn) { return(this._currentDAO.DeleteByIds(propIds, TagsTypeEn)); }
/// <summary> /// GetListCount /// </summary> /// <param name="entity">entity</param> public int GetListCount(TagsTypeEntity entity) { return(_currentDAO.GetListCount(entity)); }
public string SaveTagsType(string pRequest) { var rp = pRequest.DeserializeJSONTo <APIRequest <SaveTagsTypeRP> >(); var loggingSessionInfo = new SessionManager().CurrentUserLoginInfo; var rd = new SaveTagsTypeRD();//返回值 var _TagsTypeInfo = rp.Parameters.TagsTypeInfo; if (string.IsNullOrEmpty(_TagsTypeInfo.TypeName)) { throw new APIException("缺少参数【TypeName】或参数值为空") { ErrorCode = 135 }; } TagsTypeEntity TagsTypeEn = new TagsTypeEntity(); bool isNew = false; if (string.IsNullOrEmpty(_TagsTypeInfo.TypeId)) { _TagsTypeInfo.TypeId = Guid.NewGuid().ToString(); isNew = true; } TagsTypeEn.TypeId = _TagsTypeInfo.TypeId; TagsTypeEn.TypeName = _TagsTypeInfo.TypeName; TagsTypeEn.LastUpdateBy = loggingSessionInfo.UserID; TagsTypeEn.LastUpdateTime = DateTime.Now; TagsTypeEn.IsDelete = 0; string error = ""; //service.SaveProp(propInfo, ref error); TagsTypeBLL TagsTypeBLL = new TagsTypeBLL(loggingSessionInfo); if (isNew) { TagsTypeEn.CreateBy = loggingSessionInfo.UserID; TagsTypeEn.CreateTime = DateTime.Now; TagsTypeBLL.Create(TagsTypeEn); } else { TagsTypeBLL.Update(TagsTypeEn, false); } TagsBLL TagsBLL = new TagsBLL(loggingSessionInfo); if (!isNew)//不是新的 { string propIds = ""; foreach (var itemInfo in _TagsTypeInfo.TagsList)//数组,更新数据 { if (!string.IsNullOrEmpty(itemInfo.TagsId)) { if (propIds != "") { propIds += ","; } propIds += "'" + itemInfo.TagsId + "'"; } } //删除不在这个里面的 if (!string.IsNullOrEmpty(propIds)) { TagsBLL.DeleteByIds(propIds, TagsTypeEn); } } foreach (var itemInfo in _TagsTypeInfo.TagsList)//数组,更新数据 { TagsEntity TagsEn = new TagsEntity(); TagsEn.TagsName = itemInfo.TagsName; TagsEn.TagsDesc = itemInfo.TagsName; TagsEn.LastUpdateBy = rp.UserID; TagsEn.LastUpdateTime = DateTime.Now; TagsEn.IsDelete = 0; TagsEn.CustomerId = loggingSessionInfo.ClientID; TagsEn.TypeId = TagsTypeEn.TypeId; if (string.IsNullOrEmpty(itemInfo.TagsId)) { TagsEn.TagsId = Guid.NewGuid().ToString(); TagsEn.CreateBy = rp.UserID; TagsEn.CreateTime = DateTime.Now; TagsBLL.Create(TagsEn); } else { TagsEn.TagsId = itemInfo.TagsId; TagsBLL.Update(TagsEn, false); } } var rsp = new SuccessResponse <IAPIResponseData>(rd); return(rsp.ToJSON()); }