/// <summary> /// 根据条件意见建议信息列表 /// </summary> /// <param name="CompanyId">公司编号</param> /// <param name="model">查询参数类</param> /// <param name="PageSize">每页记录数</param> /// <param name="PageIndex">当前页数</param> /// <param name="RecordCount">总记记录数</param> /// <returns></returns> public IList <Model.GovStructure.MGovOpinion> GetGovOpinionList(string CompanyId, Model.GovStructure.MSearchOpinion MSearchOpinion, int PageSize, int PageIndex, ref int RecordCount) { IList <Model.GovStructure.MGovOpinion> list = null; if (!string.IsNullOrEmpty(CompanyId)) { list = new List <Model.GovStructure.MGovOpinion>(); return(dal.GetGovOpinionList(CompanyId, MSearchOpinion, 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.MGovOpinion> GetGovOpinionList(string CompanyId, Model.GovStructure.MSearchOpinion MSearchOpinion, int PageSize, int PageIndex, ref int RecordCount) { IList <EyouSoft.Model.GovStructure.MGovOpinion> ResultList = null; string tableName = "view_GovOpinion"; string identityColumnName = "OpinionId"; string fields = "OpinionId,CompanyId,Title,ProcessTime,IsOpen,Submit,SubmitTime,OperatorId,IssueTime,Name,OpinionUserXML "; string query = string.Format(" CompanyId='{0}'", CompanyId); if (MSearchOpinion != null) { if (!string.IsNullOrEmpty(MSearchOpinion.Title)) { query = query + string.Format(" AND Title LIKE '%{0}%'", MSearchOpinion.Title); } if (!string.IsNullOrEmpty(MSearchOpinion.Submit)) { query = query + string.Format(" AND Submit = '{0}'", MSearchOpinion.Submit); } if (MSearchOpinion.SubmitTime != null) { query = query + string.Format(" AND datediff(dd, '{0}', SubmitTime) = 0", MSearchOpinion.SubmitTime); } if (!string.IsNullOrEmpty(MSearchOpinion.OpinionUserId)) { //query = query + string.Format(" AND CAST(OpinionUserXML AS XML).exist('/ROOT/row[@ID=sql:variable(\"{0}\")]') = 1", MSearchOpinion.OpinionUserId); query = query + string.Format(" AND CAST(OpinionUserXML AS XML).exist('/ROOT/row/@ID[.=\"{0}\"]') = 1", MSearchOpinion.OpinionUserId); } if (MSearchOpinion.ProcessTime != null) { query = query + string.Format(" AND datediff(dd, '{0}', ProcessTime) = 0", MSearchOpinion.ProcessTime); } if (!string.IsNullOrEmpty(MSearchOpinion.Status))//状态1:未处理,2:已处理 { if (MSearchOpinion.Status.Equals("1")) { query = query + " AND ProcessTime is null "; } if (MSearchOpinion.Status.Equals("2")) { query = query + " AND ProcessTime is not null "; } } } 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.MGovOpinion>(); EyouSoft.Model.GovStructure.MGovOpinion model = null; while (dr.Read()) { model = new EyouSoft.Model.GovStructure.MGovOpinion(); model.OpinionId = dr.GetString(dr.GetOrdinal("OpinionId")); model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId")); model.Title = dr.IsDBNull(dr.GetOrdinal("Title")) ? "" : dr.GetString(dr.GetOrdinal("Title")); if (!dr.IsDBNull(dr.GetOrdinal("ProcessTime"))) { model.ProcessTime = dr.GetDateTime(dr.GetOrdinal("ProcessTime")); model.Status = "2"; } else { model.Status = "1"; } model.Operator = dr.IsDBNull(dr.GetOrdinal("Name")) ? "" : dr.GetString(dr.GetOrdinal("Name")); model.Submit = dr.IsDBNull(dr.GetOrdinal("Submit")) ? "" : dr.GetString(dr.GetOrdinal("Submit")); if (!dr.IsDBNull(dr.GetOrdinal("Submit"))) { model.SubmitTime = dr.GetDateTime(dr.GetOrdinal("SubmitTime")); } model.OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")); model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); model.MGovOpinionUserList = this.GetOpinionUserList(dr["OpinionUserXML"].ToString(), dr.GetString(dr.GetOrdinal("OpinionId"))); ResultList.Add(model); model = null; } }; return(ResultList); }