/// <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.WorkReport> GetList(int pageSize, int pageIndex, ref int RecordCount, int CompanyId, int OperatorId, EyouSoft.Model.PersonalCenterStructure.QueryWorkReport QueryInfo) { IList <EyouSoft.Model.PersonalCenterStructure.WorkReport> list = new List <EyouSoft.Model.PersonalCenterStructure.WorkReport>(); string tableName = "tbl_WorkReport"; string fields = "ReportId,Title,ReportingTime,OperatorName,Status,(select DepartName from tbl_CompanyDepartment where Id=tbl_WorkReport.DepartmentId) as DepartName "; string primaryKey = "ReportId"; string orderbyStr = " ReportingTime DESC "; StringBuilder strWhere = new StringBuilder(" IsDelete='0' "); if (CompanyId > 0) { strWhere.AppendFormat(" and CompanyId={0} ", CompanyId); } if (OperatorId > 0) { strWhere.AppendFormat(" and ((dbo.fn_ValidUserLevDepartManagers({0},OperatorId)>0) OR (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.DepartmentId > 0) { strWhere.AppendFormat(" and DepartmentId={0} ", QueryInfo.DepartmentId); } if (QueryInfo.CreateSDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,ReportingTime,'{0}')<=0 ", QueryInfo.CreateSDate.Value.ToString()); } if (QueryInfo.CreateEDate.HasValue) { strWhere.AppendFormat(" and datediff(dd,ReportingTime,'{0}')>=0 ", QueryInfo.CreateEDate.Value.ToString()); } } using (IDataReader dr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref RecordCount, tableName, primaryKey, fields, strWhere.ToString(), orderbyStr)) { while (dr.Read()) { EyouSoft.Model.PersonalCenterStructure.WorkReport model = new EyouSoft.Model.PersonalCenterStructure.WorkReport(); if (!dr.IsDBNull(dr.GetOrdinal("ReportId"))) { model.ReportId = dr.GetInt32(dr.GetOrdinal("ReportId")); } if (!dr.IsDBNull(dr.GetOrdinal("Title"))) { model.Title = dr[dr.GetOrdinal("Title")].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("OperatorName"))) { model.OperatorName = dr[dr.GetOrdinal("OperatorName")].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("DepartName"))) { model.DepartmentName = dr[dr.GetOrdinal("DepartName")].ToString(); } if (!dr.IsDBNull(dr.GetOrdinal("Status"))) { model.Status = (EyouSoft.Model.EnumType.PersonalCenterStructure.CheckState) int.Parse(dr[dr.GetOrdinal("Status")].ToString()); } if (!dr.IsDBNull(dr.GetOrdinal("ReportingTime"))) { model.ReportingTime = dr.GetDateTime(dr.GetOrdinal("ReportingTime")); } list.Add(model); model = null; } } return(list); }
/// <summary> /// 分页工作交流集合 /// </summary> /// <param name="pageSize">每页显示条数</param> /// <param name="pageIndex">当前页码</param> /// <param name="RecordCount">总记录数</param> /// <param name="QueryInfo">工作汇报查询实体</param> /// <returns></returns> public IList <EyouSoft.Model.PersonalCenterStructure.WorkReport> GetList(int pageSize, int pageIndex, ref int RecordCount, EyouSoft.Model.PersonalCenterStructure.QueryWorkReport QueryInfo) { return(idal.GetList(pageSize, pageIndex, ref RecordCount, CompanyId, userId, QueryInfo)); }