/// <summary>
/// 根据接收类型获得公告通知信息列表
/// </summary>
/// <param name="NoticeType">消息类型</param>
/// <param name="CompanyId">公司编号</param>
/// <param name="Type">接收类型</param>
/// <param name="PageSize">页面数据总记录数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">每页显示的记录数</param>
/// <returns></returns>
public IList <Model.GovStructure.MGovNotice> GetGovNoticeList(string NoticeType, string CompanyId, EyouSoft.Model.EnumType.GovStructure.ItemType Type, int PageSize, int PageIndex, ref int RecordCount)
{
IList <Model.GovStructure.MGovNotice> list = null;
if (!string.IsNullOrEmpty(CompanyId))
{
list = new List <Model.GovStructure.MGovNotice>();
return(dal.GetGovNoticeList(NoticeType, CompanyId, Type, ItemType, PageSize, PageIndex, ref RecordCount));
}
return(list);
}
/// <summary>
/// 根据接收类型获得公告通知信息列表
/// </summary>
/// <param name="NoticeType">消息类型</param>
/// <param name="CompanyId">公司编号</param>
/// <param name="Type">接收类型</param>
/// <param name="ItemType">附件类型</param>
/// <param name="PageSize">页面数据总记录数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">每页显示的记录数</param>
/// <returns></returns>
public IList <Model.GovStructure.MGovNotice> GetGovNoticeList(string NoticeType, string CompanyId, EyouSoft.Model.EnumType.GovStructure.ItemType Type, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType, int PageSize, int PageIndex, ref int RecordCount)
{
IList <EyouSoft.Model.GovStructure.MGovNotice> ResultList = null;
string tableName = "view_GovNotice";
string identityColumnName = "NoticeId";
string fields = "NoticeId,CompanyId,Title,IsRemind,[Views],DepartId,Operator,OperatorId,IssueTime ";
string query = string.Format(" (NoticeType='{0}') AND CompanyId='{1}'", NoticeType, CompanyId);
query = query + string.Format(" AND CAST(NoticeReceiverXML AS XML).exist('/ROOT/row/@ItemType[.=\"{0}\"]') = 1", (int)Type);
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.MGovNotice>();
while (dr.Read())
{
EyouSoft.Model.GovStructure.MGovNotice model = new EyouSoft.Model.GovStructure.MGovNotice()
{
NoticeId = dr.GetString(dr.GetOrdinal("NoticeId")),
CompanyId = dr.GetString(dr.GetOrdinal("CompanyId")),
Title = dr.IsDBNull(dr.GetOrdinal("Title")) ? "" : dr.GetString(dr.GetOrdinal("Title")),
//Content = dr.IsDBNull(dr.GetOrdinal("Content")) ? "" : dr.GetString(dr.GetOrdinal("Content")),
IsRemind = dr.GetString(dr.GetOrdinal("IsRemind")) == "1" ? true : false,
Views = dr.IsDBNull(dr.GetOrdinal("Views")) ? 0 : dr.GetInt32(dr.GetOrdinal("Views")),
OperatorId = dr.GetString(dr.GetOrdinal("OperatorId")),
IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")),
Operator = dr.IsDBNull(dr.GetOrdinal("Operator")) ? "" : dr.GetString(dr.GetOrdinal("Operator")),
//MGovNoticeReceiverList = this.GetNoticeReceiveList(dr["NoticeReceiverXML"].ToString()),
//ComAttachList = this.GetAttachList(dr["ComAttachXML"].ToString(), dr.GetString(dr.GetOrdinal("NoticeId")), ItemType)
};
ResultList.Add(model);
model = null;
}
};
return(ResultList);
}
