/// <summary>
/// 删除实体
/// </summary>
/// <param name="param">删除条件实体</param>
/// <returns></returns>
public WCFAddUpdateResult DelInfo(SYS_DictItemParam param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
int affect = 0;
try
{
#region 判断
if (param.DictItemID.ToInt32() <= 0)
{
throw new WarnException("请指定要删除的数据字典ID！");
}
#endregion
WhereClip whereClip = GetWhereClip(param);
SYS_DictItemResult info = new SYS_DictItemResult();
info.IsDeleted = true;
affect = this.Update <SYS_DictItemResult>(info, whereClip);
#region 设置返回值
ret.Key = affect;
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
}
return(ret);
}
public SYS_DictItemResult GetInfo(SYS_DictItemParam param)
{
SYS_DictItemResult ret = new SYS_DictItemResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.Sys.SYS_DictItemBLL", "GetInfo", param);
ret = rst == null ? new SYS_DictItemResult() : rst.Result as SYS_DictItemResult;
return(ret);
}
public WCFAddUpdateResult AddOrUpdate(SYS_DictItemResult param)
{
WCFAddUpdateResult ret = new WCFAddUpdateResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.Sys.SYS_DictItemBLL", "AddOrUpdate", param);
ret = (rst == null ? new WCFAddUpdateResult() : rst.Result as WCFAddUpdateResult);
return(ret);
}
private void btnSaveDict_Click(object sender, EventArgs e)
{
SYS_DictItemResult info = new SYS_DictItemResult();
info.DictItemID = txtDictItemID.Text.ToInt32();
info = this.ConvertControlToEntity <SYS_DictItemResult>(this.grpDict.Controls, info, null);
WCFAddUpdateResult result = this.AsyncExecute <WCFAddUpdateResult, SYS_DictItemResult>(info, dictLogic.AddOrUpdate, (a) =>
{
if (a.Key > 0)
{
this.HidEditWindow();
BindDictTree();
}
});
}
/// <summary>
/// 获取一条信息记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public SYS_DictItemResult GetInfo(SYS_DictItemParam param)
{
this.CheckSession();
SYS_DictItemResult rst = new SYS_DictItemResult();
#region 判断
if (param.DictItemID.ToInt32() <= 0)
{
throw new WarnException("请指定数据字典ID！");
}
#endregion
#region 获取实体
WhereClip whereClip = SYS_DictItem._.DictItemID == param.DictItemID;
rst = this.Select <SYS_DictItemResult>(whereClip);
#endregion
return(rst);
}
private void btnEditDict_Click(object sender, EventArgs e)
{
ClearDictConent();
txtDictItemID.Text = dictItemID.ToStringHasNull();
if (txtDictItemID.Text.ToInt32() > 0)
{
ShowEditWindow("编辑数据字典", grpDict);
SYS_DictItemResult info = new SYS_DictItemResult();
info = dictLogic.GetInfo(new SYS_DictItemParam()
{
DictItemID = txtDictItemID.Text.ToInt32()
});
this.ConvertEntityToControl <SYS_DictItemResult>(this.grpDict.Controls, info, null);
}
else
{
ShowMessage("请选择需要修改的数据字典！");
}
}
private void btnDelDict_Click(object sender, EventArgs e)
{
SYS_DictItemParam param = new SYS_DictItemParam();
param.DictItemID = dictItemID;
SYS_DictItemResult rst = dictLogic.GetInfo(param);
if (rst != null)
{
if (MessageBox.Show("请确认是否要删除数据字典：【" + rst.ItemName + "】", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
WCFAddUpdateResult result = this.AsyncExecute <WCFAddUpdateResult, SYS_DictItemParam>(param, dictLogic.DelInfo, (a) => { if (a.Key > 0)
{
BindDictTree();
}
});
}
}
else
{
this.ShowMessage("请选择需要删除的数据字典！");
}
}
/// <summary>
/// 添加和新增修改
/// </summary>
/// <param name="param">新增或修改的实体</param>
/// <returns></returns>
public WCFAddUpdateResult AddOrUpdate(SYS_DictItemResult param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
try
{
int affect = 0;
#region 判断
if (param.ItemCode.Trim() == "")
{
throw new WarnException("请指定数据字典编码！");
}
if (param.ItemName.Trim() == "")
{
throw new WarnException("请指定数据字典名称！");
}
if (param.DictGroupName.Trim() == "")
{
throw new WarnException("请指定数据字典所属组名！");
}
#endregion
#region 判断重复
WhereClip whereChk = SYS_DictItem._.IsDeleted == false && SYS_DictItem._.ItemCode == param.ItemCode;
if (param.DictItemID > 0)
{
whereChk = whereChk & SYS_DictItem._.DictItemID != param.DictItemID;
}
int chkNum = this.Count <SYS_DictItemResult>(whereChk);
if (chkNum > 0)
{
throw new WarnException("存在重复的数据字典编码!");
}
#endregion
#region 系统默认值
if (param.DictItemID > 0)
{
WhereClip where = SYS_DictItem._.DictItemID == param.DictItemID;
affect = this.Update <SYS_DictItemResult>(param, where);
}
else
{
param.GCompanyID = this.SessionInfo.CompanyID;
param.IsDeleted = false;
affect = this.Insert <SYS_DictItemResult>(param);
param = this.Select <SYS_DictItemResult>(new List <Field>()
{
SYS_DictItemResult._.DictItemID
}, SYS_DictItem._.ItemCode == param.ItemCode);
}
#region 设置返回值
ret.Key = param.DictItemID;
#endregion
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
}
return(ret);
}
/// <summary>
/// 绑定下拉框使用
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <SYS_DictItemLineResult> GetListByCode(SYS_DictItemLineParam param)
{
this.CheckSession();
List <SYS_DictItemLineResult> ret = new List <SYS_DictItemLineResult>();
try
{
List <Field> fields = new List <Field> ()
{
SYS_DictItem._.DictItemID,
SYS_DictItem._.ItemCode,
SYS_DictItem._.ItemName,
SYS_DictItem._.ValueType
};
WhereClip clip = SYS_DictItem._.ItemCode.In(param.ItemCodes) && SYS_DictItem._.IsDeleted == 0;
List <SYS_DictItemResult> dictItemResultList = this.SelectList <SYS_DictItemResult>(fields, clip, SYS_DictItem._.ItemCode.Desc);
int[] dictItemIDArr = dictItemResultList.Select(a => a.DictItemID).ToArray();
if (dictItemIDArr != null && dictItemIDArr.Length > 0)
{
WhereClip clip2 = SYS_DictItemLine._.DictItemID.In(dictItemIDArr);
List <Field> fields2 = new List <Field>()
{
SYS_DictItemLine._.DictItemID,
SYS_DictItemLine._.DictItemLineID,
SYS_DictItemLine._.ItemValue,
SYS_DictItemLine._.ItemValue2
};
ret = this.SelectList <SYS_DictItemLineResult>(fields2, clip2, SYS_DictItemLine._.DictItemLineID.Asc);
foreach (SYS_DictItemLineResult itemLineResult in ret)
{
SYS_DictItemResult itemResult = dictItemResultList.FirstOrDefault(a => a.DictItemID == itemLineResult.DictItemID);
itemLineResult.ItemCode = itemResult.ItemCode;
switch (itemResult.ValueType)
{
case "Boolean":
itemLineResult.ValueType = DataValueType.Boolean;
break;
case "Decimal":
itemLineResult.ValueType = DataValueType.Decimal;
break;
case "Int32":
itemLineResult.ValueType = DataValueType.Int32;
break;
case "JSON":
itemLineResult.ValueType = DataValueType.JSON;
break;
case "String":
itemLineResult.ValueType = DataValueType.String;
break;
case "XML":
itemLineResult.ValueType = DataValueType.XML;
break;
}
}
}
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
}
return(ret);
}
