private void toolAdd_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (AddParent())
{
// 字典的实体类
DataDictDto dto = new DataDictDto();
dto.FieldTypeName = slueditField.EditValue.ToString();
dto.FieldTypeSerialNo = gvDataDict.RowCount;
// 字典编辑对话框
FrmDataDictInfo frmInfo = new FrmDataDictInfo();
frmInfo.Tag = "ADD";
frmInfo.dataDictDto = dto;
if (frmInfo.ShowDialog() == DialogResult.OK)
{
// 更新数据库
UpdateInfo();
if (slueditField.Enabled)
{
slueditField.Enabled = false;
}
}
}
// 设置当前状态为“新增”
ctrlPanel.Tag = "ADD";
}
/// <summary>
/// 获取单个实体
/// </summary>
/// <param name="DataType">父级值</param>
/// <param name="ItemId">主键值</param>
/// <returns></returns>
public DataDictDto GetEntityByDataTypeAndItemId(string DataType, string ItemId)
{
var DataResult = new DataDictDto();
using (var db = _dbContext.GetIntance())
{
DataResult = db.Queryable <DataDictEntity>().Where(de => de.DeleteMark == 1 && de.DataType == DataType && de.ItemCode == ItemId).OrderBy(de => de.SortCode)
.Select(de => new DataDictDto
{
CRowId = de.CRowId,
DataType = de.DataType,
ItemCode = de.ItemCode,
ItemName = de.ItemName,
Remark = de.Remark,
SortCode = de.SortCode,
CreateDate = de.CreateDate,
CreateUserId = de.CreateUserId,
CreateUserName = de.CreateUserName,
DeleteMark = de.DeleteMark,
ModifyDate = de.ModifyDate,
ModifyUserId = de.ModifyUserId,
ModifyUserName = de.ModifyUserName
}).ToList().SingleOrDefault();
}
return(DataResult);
}
/// <summary>
/// 添加纪录
/// </summary>
/// <param name="dto"></param>
private bool Add(DataDictDto dto)
{
//int recordCnt = PropertyHelper.DataDictItems.Count<DataDictDto>(item => item.FieldTypeName == dto.FieldTypeName
// && item.FieldTypeValue == dto.FieldTypeValue);
//if (recordCnt > 0)
//{
// MessageUtil.ShowWarning("重复的条目值，请重新输入!");
// return false;
//}
//try
//{
// CallerFactory.Instance.GetService<ISystemConfigService>().Add(dto);
// MessageUtil.ShowTips("添加新条目成功!");
//}
//catch (Exception ex)
//{
// MessageUtil.ShowWarning(ex.Message);
// return false;
//}
return(true);
}
/// <summary>
/// 加入树形结构的根节点
/// </summary>
/// <returns></returns>
private bool AddParent()
{
if (dataDictList.Exists(q => q.FieldTypeValue == slueditField.EditValue.ToString()))
{
return(true);
}
DataDictDto dto = new DataDictDto();
dto.FieldTypeName = "分类管理";
dto.FieldTypeValue = slueditField.EditValue.ToString();
dto.FieldTypeSerialNo = tvType.TopNode.GetNodeCount(false) - 1;
try
{
// 记录写入数据库
CallerFactory.Instance.GetService <ISystemConfigService>().Add(dto);
return(true);
}
catch (Exception ex)
{
MessageUtil.ShowWarning(ex.Message);
return(false);
}
}
/// <summary>
/// 更新纪录
/// </summary>
/// <param name="fieldInfo"></param>
private bool Update(DataDictDto fieldInfo)
{
try
{
CallerFactory.Instance.GetService <ISystemConfigService>().UpdateDataDict(fieldInfo);
MessageUtil.ShowTips("更新条目成功!");
return(true);
}
catch (Exception ex)
{
MessageUtil.ShowWarning(ex.Message);
return(false);
}
}
/// <summary>
/// 更新纪录
/// </summary>
/// <param name="fieldInfo">实体对象</param>
private void Update(DataDictDto fieldInfo)
{
try
{
// 更新作为子节点的记录
CallerFactory.Instance.GetService <ISystemConfigService>().UpdateDataDict(fieldInfo);
// 禁止编辑标签文本
tvType.LabelEdit = false;
MessageUtil.ShowTips("更新条目成功!");
}
catch (Exception ex)
{
MessageUtil.ShowWarning(ex.Message);
}
}
/// <summary>
/// 添加纪录
/// </summary>
/// <param name="dto">实体对象</param>
private void Add(DataDictDto dto)
{
if (PropertyHelper.DataDictItems.Count <DataDictDto>(q => q.FieldTypeName == dto.FieldTypeName &&
q.FieldTypeValue == dto.FieldTypeValue) > 0)
{
MessageUtil.ShowWarning("重复的条目值，请重新输入!");
return;
}
try
{
// 记录写入数据库
CallerFactory.Instance.GetService <ISystemConfigService>().Add(dto);
MessageUtil.ShowTips("添加新条目成功!");
}
catch (Exception ex)
{
MessageUtil.ShowWarning(ex.Message);
}
}
private void toolDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
// 是否选中条目
int[] selected = gvDataDict.GetSelectedRows();
if (selected.Length == 0)
{
MessageUtil.ShowWarning("请选择要删除的信息！");
return;
}
// 表格选中的记录
DataDictDto item = (DataDictDto)gvDataDict.GetFocusedRow();
string str = string.Format("确实要删除该用户信息吗？");
if (DialogResult.Yes == MessageUtil.ShowYesNoAndTips(str))
{
int[] idx = selected.Reverse().ToArray();
try
{
foreach (int rowIndex in idx)
{
// 表格中删除选中的列
DataDictDto dataDict = (DataDictDto)gvDataDict.GetRow(rowIndex);
gvDataDict.DeleteRow(rowIndex);
// 在数据库中删除信息
CallerFactory.Instance.GetService <ISystemConfigService>().Delete(dataDict);
}
MessageUtil.ShowTips("删除成功！");
}
catch (Exception ex)
{
MessageUtil.ShowWarning(ex.Message);
}
}
}
/// <summary>
/// 删除节点
/// </summary>
/// <param name="subNodes">树的子节点集合</param>
/// <param name="tn">待删除节点</param>
public void Delete(List <TreeNode> subNodes, TreeNode tn)
{
// 节点实体对象
DataDictDto fieldInfo = new DataDictDto();
try
{
foreach (TreeNode node in subNodes)
{
// 确定子节点的父节点
if (node.Parent.Tag != null)
{
fieldInfo.FieldTypeName = node.Parent.Tag.ToString();
}
else
{
fieldInfo.FieldTypeName = node.Parent.Text;
}
fieldInfo.FieldTypeValue = node.Text; // 节点值
fieldInfo.FieldTypeSerialNo = node.Index; // 节点序号
// 从数据库中删除节点
CallerFactory.Instance.GetService <ISystemConfigService>().Delete(fieldInfo);
}
// 删除视图上指定节点
tvType.Nodes.Remove(tn);
MessageUtil.ShowTips("条目已删除!");
}
catch (Exception ex)
{
MessageUtil.ShowError(ex.Message);
}
}
/// <summary>
/// 删除或移动节点后更新字段
/// </summary>
/// <param name="node">节点</param>
void UpdateNode(TreeNode node)
{
DataDictDto fieldInfo = new DataDictDto();
foreach (TreeNode tn in node.Nodes)
{
// 更新移动树形节点的数据库记录
if (tn.Parent.Tag != null)
{
fieldInfo.FieldTypeName = tn.Parent.Tag.ToString();
}
else
{
fieldInfo.FieldTypeName = tn.Parent.Text;
}
fieldInfo.FieldTypeValue = tn.Text;
fieldInfo.FieldTypeSerialNo = tn.Index;
CallerFactory.Instance.GetService <ISystemConfigService>().UpdateDataDict(fieldInfo);
}
PropertyHelper.DataDictItems = CallerFactory.Instance.GetService <ISystemConfigService>().GetAllDataDicts();
}
public ActionResult Edit(DataDictDto model)
{
var resultModel = new RespResultCountViewModel();
try
{
#region 验证
if (string.IsNullOrEmpty(model.DataType) && string.IsNullOrEmpty(model.ItemCode))
{
resultModel.code = -1;
resultModel.msg = "修改失败！原因：字典分类ID或字典ID是空";
return(Ok(resultModel));
}
if (string.IsNullOrEmpty(model.ItemName))
{
resultModel.code = -1;
resultModel.msg = "名称不允许为空";
return(Ok(resultModel));
}
if (string.IsNullOrEmpty(model.ItemCode))
{
resultModel.code = -1;
resultModel.msg = "编码不允许为空";
return(Ok(resultModel));
}
if (string.IsNullOrEmpty(model.CRowId))
{
resultModel.code = -1;
resultModel.msg = "主键不允许为空";
return(Ok(resultModel));
}
if (_dataDictService.ExistFullName(model.DataType, model.ItemName, model.CRowId, User.GetCurrentUserOrganizeId()))
{
resultModel.code = -1;
resultModel.msg = "已存在相同名称！";
return(Ok(resultModel));
}
if (_dataDictService.ExistEnCode(model.DataType, model.ItemCode, model.CRowId, User.GetCurrentUserOrganizeId()))
{
resultModel.code = -1;
resultModel.msg = "已存在相同编号！";
return(Ok(resultModel));
}
#endregion
DataDictEntity dataDictEntity = _mapper.Map <DataDictEntity>(model);
dataDictEntity.ItemName = model.ItemName;
dataDictEntity.ModifyDate = DateTime.Now;
dataDictEntity.ModifyUserId = User.GetCurrentUserId();
dataDictEntity.ModifyUserName = User.GetCurrentUserName();
bool result = _dataDictService.Update(dataDictEntity);
if (result)
{
resultModel.code = 0;
resultModel.msg = "修改成功";
}
else
{
resultModel.code = -1;
resultModel.msg = "修改失败！原因：根据主键没有找到要处理的数据";
}
return(Ok(resultModel));
}
catch (Exception ex)
{
resultModel.code = -1;
resultModel.msg = "操作失败！原因：" + ex.Message;
return(Ok(resultModel));
}
}
public ActionResult Create(DataDictDto model)
{
RespResultViewModel resultModel = new RespResultCountViewModel();
try
{
#region 验证
if (string.IsNullOrEmpty(model.ItemName))
{
resultModel.code = -1;
resultModel.msg = "名称不允许为空";
return(Ok(resultModel));
}
if (string.IsNullOrEmpty(model.ItemCode))
{
resultModel.code = -1;
resultModel.msg = "编码不允许为空";
return(Ok(resultModel));
}
if (_dataDictService.ExistFullName(model.DataType, model.ItemName, model.CRowId, User.GetCurrentUserOrganizeId()))
{
resultModel.code = -1;
resultModel.msg = "已存在相同名称！";
return(Ok(resultModel));
}
if (_dataDictService.ExistEnCode(model.DataType, model.ItemCode, model.CRowId, User.GetCurrentUserOrganizeId()))
{
resultModel.code = -1;
resultModel.msg = "已存在相同编号！";
return(Ok(resultModel));
}
#endregion
DataDictEntity dataDictEntity = _mapper.Map <DataDictEntity>(model);
dataDictEntity.ItemName = model.ItemName;
dataDictEntity.CRowId = ConstDefine.CreateGuid();
dataDictEntity.CreateUserId = User.GetCurrentUserId();
dataDictEntity.CreateUserName = User.GetCurrentUserName();
dataDictEntity.CreateDate = DateTime.Now;
dataDictEntity.DeleteMark = 1;
dataDictEntity.ModifyDate = System.DateTime.Now;
dataDictEntity.ModifyUserId = "";
dataDictEntity.ModifyUserName = "";
dataDictEntity.OrgId = User.GetCurrentUserOrganizeId();
bool result = _dataDictService.Insert(dataDictEntity);
if (result)
{
resultModel.code = 0;
resultModel.msg = "新增成功";
}
else
{
resultModel.code = -1;
resultModel.msg = "新增失败";
}
return(Ok(resultModel));
}
catch (Exception ex)
{
resultModel.code = -1;
resultModel.msg = "操作失败" + ex.ToString();
return(Ok(resultModel));
}
}
/// <summary>
/// 更新字典条目
/// </summary>
/// <param name="item">实体</param>
/// <returns></returns>
public int UpdateDataDict(DataDictDto item)
{
return(baseSytemConfigService.UpdateDataDict(item.MapTo <DataDict>()));
}
/// <summary>
/// 删除字典条目
/// </summary>
/// <param name="item">实体</param>
/// <returns></returns>
public int Delete(DataDictDto item)
{
return(baseSytemConfigService.Delete(item.MapTo <DataDict>()));
}
/// <summary>
/// 加入字典条目
/// </summary>
/// <param name="item">实体</param>
/// <returns></returns>
public int Add(DataDictDto item)
{
return(baseSytemConfigService.Add(item.MapTo <DataDict>()));
}