/// <summary>
/// 获取条件的公共方法
/// </summary>
/// <param name="param">条件实体</param>
/// <returns></returns>
WhereClip GetWhereClip(CRM_ZoneParam param)
{
this.CheckSession();
WhereClip where = CRM_Zone._.IsDeleted == 0;
if (param.ZID != null)
{
where = where && CRM_Zone._.ZID == param.ZID;
}
if (param.PZID != null)
{
where = where && CRM_Zone._.PZID == param.PZID;
}
if (param.ZGuID != null)
{
where = where && CRM_Zone._.ZGuID == param.ZGuID;
}
if (param.ZType != 0)
{
where = where && CRM_Zone._.ZType == param.ZType;
}
if (param.Name_CN != null)
{
where = where && CRM_Zone._.Name_CN.Like("%" + param.Name_CN + "%");
}
return(where);
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="param">删除条件实体</param>
/// <returns></returns>
public WCFAddUpdateResult DelInfo(CRM_ZoneParam param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
int affect = 0;
try
{
#region 判断
if (param.ZID == null)
{
throw new WarnException("请指定要删除的记录！");
}
#endregion
WhereClip where = GetWhereClip(param);
CRM_ZoneResult info = new CRM_ZoneResult();
info.IsDeleted = true;
affect = this.Update <CRM_ZoneResult>(info, where);
#region 设置返回值
ret.Key = affect;
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
public WCFAddUpdateResult DelInfo(CRM_ZoneParam param)
{
WCFAddUpdateResult ret = new WCFAddUpdateResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.CRM.CRM_ZoneBLL", "DelInfo", param);
ret = (rst == null ? new WCFAddUpdateResult() : rst.Result as WCFAddUpdateResult);
return(ret);
}
public CRM_ZoneResult GetInfo(CRM_ZoneParam param)
{
CRM_ZoneResult ret = new CRM_ZoneResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.CRM.CRM_ZoneBLL", "GetInfo", param);
ret = rst == null ? new CRM_ZoneResult() : rst.Result as CRM_ZoneResult;
return(ret);
}
/// <summary>
/// 获取一条信息记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public CRM_ZoneResult GetInfo(CRM_ZoneParam param)
{
this.CheckSession();
CRM_ZoneResult rst = new CRM_ZoneResult();
#region 获取实体
rst = this.Select <CRM_ZoneResult>(GetWhereClip(param));
#endregion
return(rst);
}
public List <CRM_ZoneResult> GetList(CRM_ZoneParam param)
{
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.CRM.CRM_ZoneBLL", "GetList", param);
List <CRM_ZoneResult> list = new List <CRM_ZoneResult>();
list = (rst == null ? new List <CRM_ZoneResult>() : rst.Result as List <CRM_ZoneResult>);
return(list);
}
public void BindComboBox(Controls.UcComboBox c, CRM_ZoneParam param)
{
if (c != null && param != null)
{
List <CRM_ZoneResult> zoneList = this.GetList(param);
zoneList.Insert(0, new CRM_ZoneResult {
Name_CN = ""
});
c.ValueMember = "Name_CN";
c.DisplayMember = "Name_CN";
c.DataSource = zoneList;
}
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <CRM_ZoneResult> GetList(CRM_ZoneParam param)
{
this.CheckSession();
List <CRM_ZoneResult> ret = new List <CRM_ZoneResult>();
try
{
WhereClip whereClip = GetWhereClip(param);
ret = this.SelectList <CRM_ZoneResult>(whereClip, CRM_ZoneResult._.Name_CN.Asc);
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
