/// <summary>
/// 查询条件
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
WhereClip GetWhereClip(Sys_RootDirMappingParam param)
{
this.CheckSession();
WhereClip where = Sys_RootDirMapping._.IsDeleted == 0;
if (param.MID > 0)
{
where = where && Sys_RootDirMapping._.MID == param.MID;
}
if (param.MGuid != null)
{
where = where && Sys_RootDirMapping._.MGuid == param.MGuid;
}
if (!string.IsNullOrEmpty(param.MappingIdentifier))
{
where = where && Sys_RootDirMapping._.MappingIdentifier.Like("%" + param.MappingIdentifier + "%");
}
if (!string.IsNullOrEmpty(param.AttachType))
{
where = where && Sys_RootDirMapping._.AttachType == param.AttachType;
}
if (param.IsEffect != null)
{
where = where && Sys_RootDirMapping._.IsEffect == param.IsEffect;
}
return(where);
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="param">删除条件实体</param>
/// <returns></returns>
public WCFAddUpdateResult DelInfo(Sys_RootDirMappingParam param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
int affect = 0;
try
{
#region 判断
if (param.MGuid == null)
{
throw new WarnException("请指定要删除的映射表guid！");
}
#endregion
WhereClip whereClip = GetWhereClip(param);
Sys_RootDirMappingResult info = new Sys_RootDirMappingResult();
info.IsDeleted = true;
affect = this.Update <Sys_RootDirMappingResult>(info, whereClip);
#region 设置返回值
ret.Key = affect;
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
}
return(ret);
}
public WCFAddUpdateResult DelInfo(Sys_RootDirMappingParam param)
{
WCFAddUpdateResult ret = new WCFAddUpdateResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.Sys.Sys_RootDirMappingBLL", "DelInfo", param);
ret = (rst == null ? new WCFAddUpdateResult() : rst.Result as WCFAddUpdateResult);
return(ret);
}
public Sys_RootDirMappingResult GetInfo(Sys_RootDirMappingParam param)
{
Sys_RootDirMappingResult ret = new Sys_RootDirMappingResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.Sys.Sys_RootDirMappingBLL", "GetInfo", param);
ret = rst == null ? new Sys_RootDirMappingResult() : rst.Result as Sys_RootDirMappingResult;
return(ret);
}
public PageList <Sys_RootDirMappingResult> GetPageList(Sys_RootDirMappingParam param)
{
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.Sys.Sys_RootDirMappingBLL", "GetPageList", param);
PageList <Sys_RootDirMappingResult> pageList = new PageList <Sys_RootDirMappingResult>();
pageList = (rst == null ? new PageList <Sys_RootDirMappingResult>() : rst.Result as PageList <Sys_RootDirMappingResult>);
return(pageList);
}
/// <summary>
/// 获取一条信息记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public Sys_RootDirMappingResult GetInfo(Sys_RootDirMappingParam param)
{
this.CheckSession();
Sys_RootDirMappingResult rst = new Sys_RootDirMappingResult();
//#region 判断
//if (param.MGuid == null) throw new WarnException("请指定映射表GUID！");
//#endregion
#region 获取实体
rst = this.Select <Sys_RootDirMappingResult>(GetWhereClip(param));
#endregion
return(rst);
}
private void BindDataGridView(int pageIndex)
{
Sys_RootDirMappingParam param = new Sys_RootDirMappingParam();
if (!string.IsNullOrEmpty(txtSMappingIdentifier.Text.Trim()))
{
param.MappingIdentifier = txtMappingIdentifier.Text.Trim();
}
param.PageIndex = pageIndex;
param.PageSize = 100;
PageList <Sys_RootDirMappingResult> pageList = this.AsyncExecute <PageList <Sys_RootDirMappingResult>, Sys_RootDirMappingParam>(param, logic.GetPageList, a =>
{
dgvMapping.DataSource = a.ResultList;
pgMapping.RecordCount = a.TotalCount;
});
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <Sys_RootDirMappingResult> GetList(Sys_RootDirMappingParam param)
{
this.CheckSession();
List <Sys_RootDirMappingResult> ret = new List <Sys_RootDirMappingResult>();
try
{
WhereClip whereClip = GetWhereClip(param);
ret = this.SelectList <Sys_RootDirMappingResult>(whereClip, Sys_RootDirMapping._.CreatedTime.Desc);
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
/// <summary>
/// 分页集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public PageList <Sys_RootDirMappingResult> GetPageList(Sys_RootDirMappingParam param)
{
this.CheckSession();
PageList <Sys_RootDirMappingResult> ret = new PageList <Sys_RootDirMappingResult>();
try
{
List <Field> field = new List <Field>()
{
Field.All
};
ret = this.SelectList <Sys_RootDirMappingResult>(param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(50), field, GetWhereClip(param), Sys_RootDirMapping._.CreatedTime.Desc);
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
