/// <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);
}
