/// <summary>
/// 获取字典集合
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public GetDictionaryResponse GetDictionary(GetDictionaryRequest request)
{
GetDictionaryResponse response = new GetDictionaryResponse();
List <DictionaryItem> list = dictionaryRepository.GetDictionary(request);
response.dataList = list;
return(response);
}
/// <summary>
/// 获取POC自定义参数明细参宿
/// </summary>
/// <param name="parentGuid">父节点guid</param>
/// <returns></returns>
public GetVMDictionaryResponse getPOCBasiceChildParamsList(Guid parentGuid)
{
GetDictionaryRequest request = new GetDictionaryRequest();
request.ParentGuid.Add(parentGuid);
GetVMDictionaryResponse response = new GetVMDictionaryResponse();
List <VM_SYS_Dictionary> list = dictionaryRepository.GetChildDictionaryList(request);
response.ReusltList = list;
return(response);
}
public BaseResponse GetDictionary(GetDictionaryRequest request)
{
try
{
GetDictionaryResponse response = dictionaryDomainService.GetDictionary(request);
return(ApiSuccessResult(response));
}
catch (Exception ex)
{
_Log4Net.Error("GetDictionary--异常信息", ex);
return(ApiErrorResult(ex.Message));
}
}
public BaseResponse GetPOCBasicParamsParentList()
{
try
{
GetDictionaryRequest request = new GetDictionaryRequest();//参数为空，获取5个基本参数
GetVMDictionaryResponse response = dictionaryDomainService.GetPOCBasicParamsParentList(request);
return(ApiSuccessResult(response));
}
catch (Exception ex)
{
_Log4Net.Error("GetPOCDictParams--异常信息", ex);
return(ApiErrorResult(ex.Message));
}
}
public List <string> GetDictionary(GetDictionaryRequest request)
{
List <WordResult> result;
if (request == null)
{
result = this.ServiceImpl.GetDictionary(null);
}
else
{
result = this.ServiceImpl.GetDictionary(request.Cc);
}
return(result.Select(t => t.Term).ToList());
}
/// <summary>
/// 获取POC自定义参数大类
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public GetVMDictionaryResponse GetPOCBasicParamsParentList(GetDictionaryRequest request)
{
//获取根节点
request.DictGuid.Add(new Guid("2E9AED60-7EF3-477D-ABE3-0541F7DA3501"));
request.DictGuid.Add(new Guid("D7459004-5E26-43C7-B066-7F93F29D9A34"));
request.DictGuid.Add(new Guid("1A930526-9F51-41BC-AC35-C890D0B60918"));
request.DictGuid.Add(new Guid("0E0E674D-BBDF-4C3E-85AE-362E8FA5F3D5"));
request.DictGuid.Add(new Guid("AA98545B-495F-46FE-AA90-25C418E96C8C"));
GetVMDictionaryResponse response = new GetVMDictionaryResponse();
List <VM_SYS_Dictionary> list = dictionaryRepository.GetParentDictionary(request);
response.ReusltList = list;
return(response);
}
public async Task <ActionResult> GetDictionary(string name, string sort, string columns, string paging, string filter)
{
try
{
if (!await DWKitRuntime.Security.CheckFormPermissionAsync(name, "View"))
{
throw new Exception("Access denied!");
}
var filterItems = new List <ClientFilterItem>();
if (NotNullOrEmpty(filter))
{
filterItems.AddRange(JsonConvert.DeserializeObject <List <ClientFilterItem> >(filter));
}
var getRequest = new GetDictionaryRequest(name)
{
Filter = filterItems
};
if (NotNullOrEmpty(sort))
{
getRequest.Sort = JsonConvert.DeserializeObject <List <ClienSortItem> >(sort);
}
if (NotNullOrEmpty(columns))
{
getRequest.Columns = JsonConvert.DeserializeObject <List <string> >(columns);
}
if (NotNullOrEmpty(paging))
{
getRequest.Paging = JsonConvert.DeserializeObject <ClientPaging>(paging);
}
var data = await DataSource.GetDictionaryAsync(getRequest).ConfigureAwait(false);
var res = new ItemSuccessResponse <List <KeyValuePair <object, string> > >(data.Item1.ToList());
res.Count = data.Item2;
return(Json(res));
}
catch (Exception e)
{
return(Json(new FailResponse(e)));
}
}
/// <summary>
/// 递归加载获取子节点
/// </summary>
/// <param name="list"></param>
/// <param name="parentGuid"></param>
/// <returns></returns>
private void AddChildData(DictTreeResponse parentNode, Guid parentGuid)
{
//获取子节点
GetDictionaryRequest requestRoot = new GetDictionaryRequest();
requestRoot.ParentGuid.Add(parentGuid);
List <DictionaryItem> listDictChild = dictionaryRepository.GetDictionary(requestRoot);
foreach (var item in listDictChild)
{
DictTreeResponse dtNode = new DictTreeResponse();
if (item.ParentGuid == parentGuid)
{
dtNode.value = item.DictGuid.ToString(); //字典表key
dtNode.label = item.SysDictValue; //字典显示名称
parentNode.children.Add(dtNode);
AddChildData(dtNode, item.DictGuid);
}
}
}
/// <summary>
/// 添加根节点
/// </summary>
/// <param name="parentData"></param>
/// <param name="parentGuid"></param>
/// <returns></returns>
private void AddRootData()
{
//获取根节点
GetDictionaryRequest requestRoot = new GetDictionaryRequest();
requestRoot.DictGuid.Add(new Guid("2E9AED60-7EF3-477D-ABE3-0541F7DA3501"));
requestRoot.DictGuid.Add(new Guid("D7459004-5E26-43C7-B066-7F93F29D9A34"));
requestRoot.DictGuid.Add(new Guid("1A930526-9F51-41BC-AC35-C890D0B60918"));
requestRoot.DictGuid.Add(new Guid("0E0E674D-BBDF-4C3E-85AE-362E8FA5F3D5"));
requestRoot.DictGuid.Add(new Guid("AA98545B-495F-46FE-AA90-25C418E96C8C"));
List <DictionaryItem> listDictRoot = dictionaryRepository.GetDictionary(requestRoot);//获取根节点
foreach (var item in listDictRoot)
{
DictTreeResponse dtNode = new DictTreeResponse();
dtNode.value = item.DictGuid.ToString(); //字典表key
dtNode.label = item.SysDictValue; //字典显示名称
responseTreeNodeList.Add(dtNode);
AddChildData(dtNode, item.DictGuid);
}
}
/// <summary>
/// 获取字典集合包含子节点内容的父节点集合
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public List <VM_SYS_Dictionary> GetParentDictionary(GetDictionaryRequest request)
{
try
{
//sql
string strSql = @"SELECT
(SELECT y.ChinldSysDictValueLable FROM
(SELECT ChinldSysDictValueLable =(
SELECT STUFF((SELECT '、' + SysDictValue FROM (SELECT * FROM [T_SYS_Dictionary] WHERE ParentGuid=p.DictGuid) x
ORDER BY Id FOR XML PATH('')),1,1,''))
) y) ChinldSysDictValueLable,
p.* FROM [dbo].[T_SYS_Dictionary] p WHERE 1=1";
StringBuilder _sql = new StringBuilder(strSql);
//查询条件
StringBuilder _condition = new StringBuilder("");
var _parameters = new DynamicParameters();
//guid
if (request.DictGuid != null && request.DictGuid.Count > 0)
{
_condition.AppendFormat(" AND p.DictGuid in @DictGuid ");
_parameters.Add("@DictGuid", request.DictGuid.ToArray());
}
//父级Id
if (request.ParentGuid != null && request.ParentGuid.Count > 0)
{
_condition.AppendFormat(" AND p.ParentGuid in @ParentGuid ");
_parameters.Add("@ParentGuid", request.ParentGuid.ToArray());
}
_condition.Append(" ORDER BY SysDictSort");
return(GetInfos <VM_SYS_Dictionary>(EumDBName.POC, _sql.ToString() + _condition, _parameters).ToList());
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 新增修改明细字典内容
/// </summary>
/// <param name="viewModel"></param>
public UnitOfWorkResult SaveOrUpdateChild(SaveVMDictionaryRequest viewModel)
{
//var result = UnitOfWorkResult.GetCurrentUow();
//父类 参数名称：必输，最大字符20
//参数描述：非必输，最大字符50
//参数选项：选项名称必输，最大字段20，选项描述非必输，最大字符50
//排序：必输，正整数
//校验长度
//校验是否已经存在映射关系
StringBuilder errormsg = new StringBuilder();
if (viewModel != null)
{
foreach (var item in viewModel.selectOptions)
{
//校验长度
if (string.IsNullOrEmpty(item.SysDictValue))
{
errormsg.AppendFormat("参数名称必填");
}
else
{
if (item.SysDictValue.Length > 20)
{
errormsg.AppendFormat("参数名称最大字符20");
}
}
if ((!string.IsNullOrEmpty(item.SysDictDesc)) && (item.SysDictDesc.Length > 50))
{
errormsg.AppendFormat("参数描述最大字符50");
}
}
List <VM_SYS_Dictionary> updateDictList = new List <VM_SYS_Dictionary>();//记录修改的节点
//获取当前字典类型的所有子节点，循环判断新增或修改
//var childDbDictList = this.getPOCBasiceChildParamsList(new Guid(viewModel.parentGuid));
GetDictionaryRequest request = new GetDictionaryRequest();
request.ParentGuid.Add(new Guid(viewModel.parentGuid));
List <T_SYS_Dictionary> childDbDictList = dictionaryRepository.GetDictEntityList(request);
int iOrderNo = 1;//排序号
foreach (var itemDb in childDbDictList)
{
iOrderNo++;
var findItem = viewModel.selectOptions.Find(t => t.DictGuid == itemDb.DictGuid);
if (findItem != null)//修改
{
//判断新增或修改或删除
T_SYS_Dictionary dictnew = new T_SYS_Dictionary();
dictnew.Id = findItem.Id;
dictnew.DictGuid = findItem.DictGuid;
dictnew.ParentGuid = new Guid(viewModel.parentGuid);//父节点Guid
dictnew.SysDictKey = dictnew.DictGuid.ToString();
dictnew.SysDictValue = findItem.SysDictValue;
dictnew.SysDictDesc = findItem.SysDictDesc;
dictnew.SysDictSort = iOrderNo;
dictnew.SysCatalogCode = viewModel.vmParentDict.SysCatalogCode;
dictnew.SysCatalogName = viewModel.vmParentDict.SysCatalogName;
dictnew.SysIsCatalog = false;
dictnew.SysIsEnabled = true;
dictnew.SysIsEdit = true;
dictnew.UpdaterUserId = findItem.UpdaterUserId;
dictnew.UpdaterUserName = findItem.UpdaterUserName;
dictnew.CreatedDate = findItem.CreatedDate;
dictnew.UpdateDate = DateTime.Now;
dictnew.SaveType = SaveType.Modify;
var uowSave = Save(dictnew);
updateDictList.Add(findItem);
}
else
{
//校验是否已经存在映射关系
if (this.CheckHasMappedBasciData(itemDb.DictGuid))
{
errormsg.AppendFormat($"{itemDb.SysDictValue}已存在映射关系的数据，不能删除！");
}
//校验是否已经存在映射关系
if (this.CheckIsExtractorBasciData(itemDb.DictGuid))
{
errormsg.AppendFormat($"{itemDb.SysDictValue}提取正在使用，不能删除！");
}
//删除没在界面上存在
var uowDel = Remove(itemDb);
}
}
if (!string.IsNullOrWhiteSpace(errormsg.ToString()))
{
throw new Exception(errormsg.ToString());
}
foreach (var item in viewModel.selectOptions)
{
var findItem = updateDictList.Find(t => t.DictGuid == item.DictGuid);
if (findItem == null)//没找到的是要新增的节点
{
iOrderNo++;
T_SYS_Dictionary dictnew = new T_SYS_Dictionary();
dictnew.DictGuid = Guid.NewGuid();
dictnew.ParentGuid = new Guid(viewModel.parentGuid);//父节点Guid
dictnew.SysDictKey = dictnew.DictGuid.ToString();
dictnew.SysDictValue = item.SysDictValue;
dictnew.SysDictDesc = item.SysDictDesc;
dictnew.SysDictSort = iOrderNo;
dictnew.SysCatalogCode = viewModel.vmParentDict.SysCatalogCode;
dictnew.SysCatalogName = viewModel.vmParentDict.SysCatalogName;
dictnew.SysIsCatalog = false;
dictnew.SysIsEnabled = true;
dictnew.SysIsEdit = true;
dictnew.UpdaterUserId = "";
dictnew.UpdaterUserName = "";
dictnew.CreatedDate = DateTime.Now;
dictnew.UpdateDate = DateTime.Now;
dictnew.SaveType = SaveType.Add;
var uowAdd = Add(dictnew);
}
}
}
//父节点赋值
viewModel.vmParentDict.SysDictValue = viewModel.SysDictValue;
viewModel.vmParentDict.SysDictDesc = viewModel.SysDictDesc;
viewModel.vmParentDict.SysDictSort = viewModel.SysDictSort;
var uowParent = dictionaryRepository.UpdateParentDict(viewModel.vmParentDict);
var result = UnitOfWorkResult.GetCurrentUow();
//throw new NotImplementedException();
return(result);
}
