/// <summary> /// 获取条件的公共方法 /// </summary> /// <param name="param">条件实体</param> /// <returns></returns> WhereClip GetWhereClip(CRM_JobMastParam param) { this.CheckSession(); WhereClip where = CRM_JobMast._.IsDeleted == 0; if (param.EmpJobGuid != null) { where = where && CRM_JobMast._.EmpJobGuid == param.EmpJobGuid; } if (!string.IsNullOrEmpty(param.JobName)) { where = where && CRM_JobMast._.JobName.Like("%" + param.JobName + "%"); } if (!string.IsNullOrEmpty(param.JobType)) { where = where && CRM_JobMast._.JobType == param.JobType; } if (param.JobDateS != null) { where = where && CRM_JobMast._.JobDate >= param.JobDateS; } if (param.JobDateE != null) { where = where && CRM_JobMast._.JobDate < param.JobDateE.Value.AddDays(1); } where = Sys_EmpDataRightBLL.GetEmpIDInWhere(where, CRM_JobMast._.JobDate, CRM_JobMast._.BeLongEmpID, CRM_JobMast._.OrgID, CRM_JobMast._.DeptID, this.SessionInfo); return(where); }
/// <summary> /// 获取上一条或下一条记录 /// </summary> /// <param name="param">条件实体</param> /// <returns></returns> public CRM_JobMastResult GetNextOrPreInfo(CRM_JobMastParam param) { this.CheckSession(); CRM_JobMastResult rst = new CRM_JobMastResult(); #region 判断 if (param.EmpJobGuid == null) { throw new WarnException("请指定关键字GUID!"); } #endregion #region 保存实体 WhereClip where = CRM_JobMast._.EmpJobGuid == param.EmpJobGuid; where = Sys_EmpDataRightBLL.GetEmpIDInWhere(where, CRM_JobMast._.JobDate, CRM_JobMast._.BeLongEmpID, CRM_JobMast._.OrgID, CRM_JobMast._.DeptID, this.SessionInfo); rst = this.Select <CRM_JobMastResult>(where); #endregion return(rst); }
/// <summary> /// 获取条件的公共方法 /// </summary> /// <param name="param">条件实体</param> /// <returns></returns> WhereClip GetWhereClip(CRM_VisitPlanParam param) { this.CheckSession(); WhereClip where = CRM_VisitPlan._.IsDeleted == 0; if (param.CustVstPlnID != null) { where = where && CRM_VisitPlan._.CustVstPlnID == param.CustVstPlnID; } if (param.CustVstPlnGuID != null) { where = where && CRM_VisitPlan._.CustVstPlnGuID == param.CustVstPlnGuID; } if (param.PlanName != null) { where = where && CRM_VisitPlan._.PlanName.Like("%" + param.PlanName + "%"); } where = Sys_EmpDataRightBLL.GetEmpIDInWhere(where, CRM_VisitPlan._.CreatedTime, CRM_VisitPlan._.OpEmpID, CRM_VisitPlan._.OrgID, CRM_VisitPlan._.DeptID, this.SessionInfo); return(where); }