/// <summary> /// 获得会议管理信息列表 /// </summary> /// <param name="CompanyId">公司编号</param> /// <param name="SearchInfo">会议查询实体</param> /// <param name="PageSize">每页记录数</param> /// <param name="PageIndex">当前页数</param> /// <param name="RecordCount">总记记录数</param> /// <returns></returns> public IList <Model.GovStructure.MGovMeeting> GetGovMeetingList(string CompanyId, EyouSoft.Model.GovStructure.MSearchMeeting MSearchMeeting, int PageSize, int PageIndex, ref int RecordCount) { IList <Model.GovStructure.MGovMeeting> list = null; if (!string.IsNullOrEmpty(CompanyId)) { list = new List <Model.GovStructure.MGovMeeting>(); return(dal.GetGovMeetingList(CompanyId, MSearchMeeting, PageSize, PageIndex, ref RecordCount)); } return(list); }
/// <summary> /// 获得会议管理信息列表 /// </summary> /// <param name="CompanyId">公司编号</param> /// <param name="MSearchMeeting">会议查询实体</param> /// <param name="PageSize">页面数据总记录数</param> /// <param name="PageIndex">当前页数</param> /// <param name="RecordCount">每页显示的记录数</param> /// <returns></returns> public IList <Model.GovStructure.MGovMeeting> GetGovMeetingList(string CompanyId, EyouSoft.Model.GovStructure.MSearchMeeting MSearchMeeting, int PageSize, int PageIndex, ref int RecordCount) { IList <EyouSoft.Model.GovStructure.MGovMeeting> ResultList = null; //string tableName = "view_GovMeeting"; //string identityColumnName = "MeetingId"; //string fields = "MeetingId,CompanyID,Number,Category,Theme,StartTime,EndTime,Venue,Minutes,OperatorId,IssueTime,GovMeetingStaff "; string tableName = "tbl_GovMeeting"; string identityColumnName = "MeetingId"; string fields = "MeetingId,CompanyID,Number,Category,Theme,MeetingStaff,StartTime,EndTime,Venue,Minutes,OperatorId,IssueTime "; string query = string.Format(" CompanyId='{0}'", CompanyId); if (MSearchMeeting != null) { if (!string.IsNullOrEmpty(MSearchMeeting.Number)) { query = query + string.Format(" AND [Number] LIKE '%{0}%'", MSearchMeeting.Number); } if (!string.IsNullOrEmpty(MSearchMeeting.Theme)) { query = query + string.Format(" AND [Theme] LIKE '%{0}%'", MSearchMeeting.Theme); } if (MSearchMeeting.StartTime != null) { query = query + string.Format(" AND StartTime >='{0}' ", MSearchMeeting.StartTime); } if (MSearchMeeting.EndTime != null) { query = query + string.Format(" AND EndTime <='{0}' ", MSearchMeeting.EndTime); } } string orderByString = " IssueTime DESC"; using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(_db, PageSize, PageIndex, ref RecordCount, tableName, identityColumnName, fields, query, orderByString)) { ResultList = new List <EyouSoft.Model.GovStructure.MGovMeeting>(); while (dr.Read()) { EyouSoft.Model.GovStructure.MGovMeeting model = new EyouSoft.Model.GovStructure.MGovMeeting() { MeetingId = dr.GetString(dr.GetOrdinal("MeetingId")), CompanyID = dr.GetString(dr.GetOrdinal("CompanyId")), Number = dr.IsDBNull(dr.GetOrdinal("Number")) ? "" : dr.GetString(dr.GetOrdinal("Number")), //Category = (EyouSoft.Model.EnumType.GovStructure.Category)Enum.Parse(typeof(EyouSoft.Model.EnumType.GovStructure.Category), dr.GetByte(dr.GetOrdinal("Category"))), Category = (EyouSoft.Model.EnumType.GovStructure.Category)dr.GetByte(dr.GetOrdinal("Category")), Theme = dr.IsDBNull(dr.GetOrdinal("Theme")) ? "" : dr.GetString(dr.GetOrdinal("Theme")), StartTime = dr.GetDateTime(dr.GetOrdinal("StartTime")), EndTime = dr.GetDateTime(dr.GetOrdinal("EndTime")), Venue = dr.IsDBNull(dr.GetOrdinal("Venue")) ? "" : dr.GetString(dr.GetOrdinal("Venue")), Minutes = dr.IsDBNull(dr.GetOrdinal("Minutes")) ? "" : dr.GetString(dr.GetOrdinal("Minutes")), OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")), IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")), //MGovMeetingStaff = this.GetMeetingStaffListXML(dr["GovMeetingStaff"].ToString(), dr.GetString(dr.GetOrdinal("MeetingId"))) MeetingStaff = dr.IsDBNull(dr.GetOrdinal("MeetingStaff")) ? "" : dr.GetString(dr.GetOrdinal("MeetingStaff")) }; ResultList.Add(model); model = null; } }; return(ResultList); }