/// <summary> /// 分页工作交流集合 /// </summary> /// <param name="pageSize">每页显示条数</param> /// <param name="pageIndex">当前页码</param> /// <param name="RecordCount">总记录数</param> /// <param name="CompanyId">公司编号 =0返回所有</param> /// <param name="OperatorId">操作人编号 =0返回所有</param> /// <param name="QueryInfo">工作计划查询实体</param> /// <returns></returns> public IList <EyouSoft.Model.PersonalCenterStructure.WorkPlan> GetList(int pageSize, int pageIndex, ref int RecordCount, int CompanyId, int OperatorId, EyouSoft.Model.PersonalCenterStructure.QueryWorkPlan QueryInfo) { return(idal.GetList(pageSize, pageIndex, ref RecordCount, CompanyId, OperatorId, QueryInfo)); }
/// <summary> /// 分页工作交流集合 /// </summary> /// <param name="pageSize">每页显示条数</param> /// <param name="pageIndex">当前页码</param> /// <param name="RecordCount">总记录数</param> /// <param name="CompanyId">公司编号 =0返回所有</param> /// <param name="OperatorId">操作人编号</param> /// <param name="QueryInfo">工作计划查询实体</param> /// <returns></returns> public IList <EyouSoft.Model.PersonalCenterStructure.WorkPlan> GetList(int pageSize, int pageIndex, ref int RecordCount, int CompanyId, int OperatorId, EyouSoft.Model.PersonalCenterStructure.QueryWorkPlan QueryInfo) { IList <EyouSoft.Model.PersonalCenterStructure.WorkPlan> list = new List <EyouSoft.Model.PersonalCenterStructure.WorkPlan>(); string tableName = "tbl_WorkPlan"; string fields = "PlanId,PlanNO,Title,Remark,OperatorId,(select ContactName from tbl_CompanyUser where Id=tbl_WorkPlan.OperatorId) as OperatorName,Status,ExpectedDate,ActualDate,CreateTime"; string primaryKey = "PlanId"; string orderbyStr = " CreateTime DESC "; StringBuilder strWhere = new StringBuilder(" IsDelete='0' "); if (CompanyId > 0) { strWhere.AppendFormat(" and CompanyId={0} ", CompanyId); } if (OperatorId > 0) { strWhere.AppendFormat(" and ((PlanId in(select PlanId from tbl_WorkPlanAccept where AccetpId={0})) OR (OperatorId={0}) OR (dbo.fn_ValidUserLevDepartManagers({0},OperatorId)>0))", OperatorId); } if (QueryInfo != null) { if (!string.IsNullOrEmpty(QueryInfo.Title)) { strWhere.AppendFormat(" and Title like '%{0}%' ", QueryInfo.Title); } if (!string.IsNullOrEmpty(QueryInfo.OperatorName)) { strWhere.AppendFormat(" and OperatorName like '%{0}%' ", QueryInfo.OperatorName); } if (QueryInfo.LastSTime.HasValue) { strWhere.AppendFormat(" and datediff(dd,LastTime,'{0}')<=0 ", QueryInfo.LastSTime.Value.ToString()); } if (QueryInfo.LastETime.HasValue) { strWhere.AppendFormat(" and datediff(dd,LastTime,'{0}')>=0 ", QueryInfo.LastETime.Value.ToString()); } if (QueryInfo.Status.HasValue) { strWhere.AppendFormat(" and Status={0} ", (int)QueryInfo.Status.Value); } } using (IDataReader dr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref RecordCount, tableName, primaryKey, fields, strWhere.ToString(), orderbyStr)) { while (dr.Read()) { EyouSoft.Model.PersonalCenterStructure.WorkPlan model = new EyouSoft.Model.PersonalCenterStructure.WorkPlan(); model.PlanId = dr.GetInt32(dr.GetOrdinal("PlanId")); model.PlanNO = dr[dr.GetOrdinal("PlanNO")].ToString(); model.Title = dr[dr.GetOrdinal("Title")].ToString(); model.OperatorName = dr[dr.GetOrdinal("OperatorName")].ToString(); model.Remark = dr[dr.GetOrdinal("Remark")].ToString(); model.Status = (EyouSoft.Model.EnumType.PersonalCenterStructure.PlanCheckState) int.Parse(dr[dr.GetOrdinal("Status")].ToString()); if (!dr.IsDBNull(dr.GetOrdinal("ExpectedDate"))) { model.ExpectedDate = dr.GetDateTime(dr.GetOrdinal("ExpectedDate")); } if (!dr.IsDBNull(dr.GetOrdinal("ActualDate"))) { model.ActualDate = dr.GetDateTime(dr.GetOrdinal("ActualDate")); } model.CreateTime = dr.GetDateTime(dr.GetOrdinal("CreateTime")); if (!dr.IsDBNull(dr.GetOrdinal("OperatorId"))) { model.OperatorId = dr.GetInt32(dr.GetOrdinal("OperatorId")); } list.Add(model); model = null; } } return(list); }