public ExecResult DelDict(DictQuery query) { ExecResult execResult = new ExecResult(); IDictService service = ServiceContainer.Instance.Container.Resolve <IDictService>(); IList <Int64> dictIDs = query.DictIDs.ToList(); if (dictIDs == null) { execResult.result = EnumJsonResult.failure.ToString(); execResult.msg = "没有删除任何数据!"; return(execResult); } string msg = string.Empty; IList <Int64> list = service.BatchDeleteDict(dictIDs); if (list == null || list.Count < dictIDs.Count) { execResult.result = EnumJsonResult.success.ToString(); execResult.msg = "删除数据字典成功!"; if (list != null && list.Count > 0) { execResult.msg += string.Format("部分编号[{0}]由于存在数据字典值,请先删除", string.Join(",", list)); } } else { execResult.result = EnumJsonResult.failure.ToString(); execResult.msg = "删除数据字典失败!"; } return(execResult); }
public DictEntity GetDictModelByKey(DictQuery query) { IDictService service = ServiceContainer.Instance.Container.Resolve <IDictService>(); DictEntity model = service.GetDictByKey(query.DictKey, query.JournalID); return(model); }
/// <summary> /// 命令执行 /// </summary> /// <param name="context"></param> public override void Execute(DataContext context) { byte[] cmdData = context.CmdData; if (cmdData.Length == 0) { context.Flush(RespondCode.CmdDataLack); return; } DictQuery query = cmdData.ProtoBufDeserialize <DictQuery>(); if (Compiled.Debug) { query.Debug("=== Material.Translation 请求数据 ==="); } string word = (query.Text ?? string.Empty).Trim(); DictQuery.ResultPart resultPart = query.QueryPart; bool extendQuery = query.ExtendResult; if (string.IsNullOrEmpty(word)) { context.Flush(RespondCode.DataInvalid); return; } //检测待查询的内容是中文还是英文 Regex regex = new Regex("[\u4e00-\u9fa5]"); bool isChinese = regex.IsMatch(word); Query(context, word, isChinese, resultPart, extendQuery); }
public Pager <DictEntity> GetDictPageList(DictQuery query) { IDictService service = ServiceContainer.Instance.Container.Resolve <IDictService>(); Pager <DictEntity> pager = service.GetDictPageList(query); return(pager); }
public DictEntity GetDictModel(DictQuery query) { IDictService service = ServiceContainer.Instance.Container.Resolve <IDictService>(); DictEntity model = service.GetDict(query.DictID); return(model); }
public List <DictEntity> GetDictList(DictQuery query) { List <DictEntity> list = new List <DictEntity>(); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT DictID,JournalID,DictKey,Note,InUserID,EditUserID,EditDate,AddDate FROM dbo.Dict WITH(NOLOCK)"); string whereSQL = DictQueryToSQLWhere(query); string orderBy = DictQueryToSQLOrder(query); if (!string.IsNullOrEmpty(whereSQL)) { sqlCommandText.Append(" WHERE " + whereSQL); } if (!string.IsNullOrEmpty(orderBy)) { sqlCommandText.Append(" ORDER BY " + orderBy); } DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); using (IDataReader dr = db.ExecuteReader(cmd)) { list = MakeDictList(dr); } return(list); }
/// <summary> /// 将查询实体转换为Where语句 /// <param name="query">查询实体</param> /// <returns>获取Where语句,不包含Where</returns> /// </summary> public string DictQueryToSQLWhere(DictQuery query) { if (query.JournalID > 0) { return(" JournalID=" + query.JournalID); } return(string.Empty); }
/// <summary> /// 分页获取符合查询条件的数据 /// </summary> /// <param name="dictQuery">DictQuery查询实体对象</param> /// <returns>Pager<DictEntity></returns> public Pager <DictEntity> GetDictPageList(DictQuery dictQuery) { Pager <DictEntity> pager = DictBusProvider.GetDictPageList(dictQuery); if (pager != null) { pager.ItemList = GetDictList(pager.ItemList.ToList(), dictQuery); } return(pager); }
public ActionResult Delete(Int64[] dictIDs) { ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); DictQuery query = new DictQuery(); query.JournalID = CurAuthor.JournalID; query.DictIDs = dictIDs; ExecResult result = service.DelDict(query); return(Json(new { result = result.result, msg = result.msg })); }
public ActionResult GetDictPageList(DictQuery query) { ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); query.JournalID = CurAuthor.JournalID; query.CurrentPage = Convert.ToInt32(Request.Params["page"]); query.PageSize = Convert.ToInt32(Request.Params["pagesize"]); Pager <DictEntity> pager = service.GetDictPageList(query); return(Json(new { Rows = pager.ItemList, Total = pager.TotalRecords })); }
/// <summary> /// 根据字典编码查询数据项 /// </summary> /// <param name="dictCode"></param> /// <returns></returns> public async Task <List <DictDataItemOutput> > GetDictDataItem(string dictCode) { var query = new DictQuery { DictCode = dictCode, DictType = DictType.Sub }; query.OrderBy(a => a.Sort).OrderBy(a => a.CreateTime); var dictItems = await _dictRep.GetListAsync(query); return(dictItems.Adapt <List <DictDataItemOutput> >()); }
public ActionResult Create(Int64 dictId = 0) { DictEntity model = null; if (dictId > 0) { DictQuery query = new DictQuery(); query.JournalID = CurAuthor.JournalID; query.DictID = dictId; ISiteConfigFacadeService service = ServiceContainer.Instance.Container.Resolve <ISiteConfigFacadeService>(); model = service.GetDictModel(query); } if (model == null) { model = new DictEntity(); } return(View(model)); }
/// <summary> /// 组装数据 /// </summary> /// <param name="list"></param> /// <returns></returns> private List <DictEntity> GetDictList(List <DictEntity> list, DictQuery dictQuery) { if (list == null || list.Count == 0) { return(list); } AuthorInfoService service = new AuthorInfoService(); AuthorInfoQuery query = new AuthorInfoQuery(); query.JournalID = dictQuery.JournalID; var dict = service.AuthorInfoBusProvider.GetAuthorDict(query); foreach (var mode in list) { mode.InUserName = dict.GetValue(mode.InUserID, mode.InUserID.ToString()); } return(list); }
public Pager <DictEntity> GetDictPageList(DictQuery query) { string strSql = "SELECT DictID,JournalID,DictKey,Note,InUserID,EditUserID,EditDate,AddDate,ROW_NUMBER() OVER(ORDER BY DictID DESC) AS ROW_ID FROM dbo.Dict with(nolock)", sumStr = "SELECT RecordCount=COUNT(1) FROM dbo.Dict with(nolock)"; string whereSQL = DictQueryToSQLWhere(query); if (!string.IsNullOrWhiteSpace(whereSQL)) { strSql += " WHERE " + whereSQL; sumStr += " WHERE " + whereSQL; } return(db.GetPageList <DictEntity>(string.Format(SQL_Page_Select, strSql, query.StartIndex, query.EndIndex) , sumStr , query.CurrentPage, query.PageSize , (dr, pager) => { pager.TotalRecords = TypeParse.ToLong(dr["RecordCount"]); } , MakeDictList)); }
public async Task <Paged <DictDto> > GetDictPagedResult(DictQuery query) { var items = await DbContext.Select <SysDict>() .WhereIf(query.DictType.HasValue, a => a.DictType == query.DictType) .WhereIf(query.LikeDictName.HasValue(), a => a.DictName.Contains(query.LikeDictName)) .WhereIf(query.LikeDictCode.HasValue(), a => a.DictCode.Contains(query.LikeDictCode)) .OrderByDescending(a => a.CreateTime) .Count(out var totalCount) .Page(query.PageIndex, query.PageSize) .ToListAsync(a => new DictDto { Id = a.Id, ParentId = a.ParentId, DictCode = a.DictCode, DictName = a.DictName, Remark = a.Remark, CreateTime = a.CreateTime, ItemNames = string.Join(',', DbContext.Select <SysDict>().Where(b => b.ParentId == a.Id).ToList(b => b.ItemName)) }); return(items.ToPaged(query, totalCount)); }
/// <summary> /// 将查询实体转换为Order语句 /// <param name="query">查询实体</param> /// <returns>获取Order语句,不包含Order</returns> /// </summary> public string DictQueryToSQLOrder(DictQuery query) { return(" DictID DESC"); }
/// <summary> /// 分页获取符合查询条件的数据 /// </summary> /// <param name="dictQuery">DictQuery查询实体对象</param> /// <returns>Pager<DictEntity></returns> public Pager <DictEntity> GetDictPageList(DictQuery dictQuery) { return(DictDataAccess.Instance.GetDictPageList(dictQuery)); }
/// <summary> /// 获取所有符合查询条件的数据 /// </summary> /// <param name="dictQuery">DictQuery查询实体对象</param> /// <returns>List<DictEntity></returns> public List <DictEntity> GetDictList(DictQuery dictQuery) { return(GetDictList(DictBusProvider.GetDictList(dictQuery), dictQuery)); }