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