예제 #1
0
        /// <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);
        }
예제 #2
0
        /// <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);
        }