/// <summary>
/// 获得公告通知实体
/// </summary>
/// <param name="NoticeId">公告通知ID</param>
/// <param name="ItemType">附件类型</param>
/// <returns></returns>
public EyouSoft.Model.GovStructure.MGovNotice GetGovNoticeModel(string NoticeId, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType)
{
EyouSoft.Model.GovStructure.MGovNotice model = null;
StringBuilder StrSql = new StringBuilder();
StrSql.Append("SELECT NoticeId,CompanyId,Title,[Content],IsRemind,IsMsg,MsgContent,DepartId,[Views],Operator,OperatorId,IssueTime, ");
StrSql.AppendFormat(" (SELECT Name,FilePath,Size,Downloads FROM tbl_ComAttach WHERE ItemType={0} AND ItemId=a.NoticeId FOR XML RAW,ROOT('ROOT'))AS ComAttachXML,", (int)ItemType);
StrSql.Append(" (SELECT ItemType,ItemId FROM tbl_GovNoticeReceiver WHERE NoticeId=a.NoticeId FOR XML RAW,ROOT('ROOT'))AS NoticeReceiverXML ");
StrSql.AppendFormat(" FROM tbl_GovNotice a WHERE NoticeId='{0}' ", NoticeId);
DbCommand dc = this._db.GetSqlStringCommand(StrSql.ToString());
using (IDataReader dr = EyouSoft.Toolkit.DAL.DbHelper.ExecuteReader(dc, this._db))
{
if (dr.Read())
{
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,
IsMsg = dr.GetString(dr.GetOrdinal("IsMsg")) == "1" ? true : false,
MsgContent = dr.IsDBNull(dr.GetOrdinal("MsgContent")) ? "" : dr.GetString(dr.GetOrdinal("MsgContent")),
Views = dr.GetInt32(dr.GetOrdinal("Views")),
OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")),
IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")),
Operator = dr.GetString(dr.GetOrdinal("Operator")),
ComAttachList = this.GetAttachList(dr["ComAttachXML"].ToString(), NoticeId, ItemType),
MGovNoticeReceiverList = this.GetNoticeReceiveList(dr["NoticeReceiverXML"].ToString(), NoticeId)
};
}
};
return(model);
}
/// <summary>
/// 获得公告通知实体
/// </summary>
/// <param name="NoticeId">公告通知ID</param>
/// <returns></returns>
public EyouSoft.Model.GovStructure.MGovNotice GetGovNoticeModel(string NoticeId)
{
EyouSoft.Model.GovStructure.MGovNotice model = null;
if (!string.IsNullOrEmpty(NoticeId))
{
model = new EyouSoft.Model.GovStructure.MGovNotice();
return(dal.GetGovNoticeModel(NoticeId, ItemType));
}
return(model);
}
/// <summary>
/// 获得公告通知信息列表
/// </summary>
/// <param name="NoticeType">消息类型</param>
/// <param name="CompanyId">公司编号</param>
/// <param name="Title">标题</param>
/// <param name="OperatorId">发布人ID</param>
/// <param name="Operator">发布人</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, string Title, string OperatorId, string Operator, 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,ComAttachXML,IsRemind,[Views],DepartId,Operator,OperatorId,IssueTime ";
string query = string.Format(" (NoticeType='{0}') AND CompanyId='{1}'", NoticeType, CompanyId);
if (!string.IsNullOrEmpty(Title))
{
query = query + string.Format(" and Title like '%{0}%'", Title);
}
if (!string.IsNullOrEmpty(OperatorId))
{
query = query + string.Format(" and OperatorId = '{0}'", OperatorId);
}
if (!string.IsNullOrEmpty(Operator))
{
query = query + string.Format(" and Operator like '%{0}%'", Operator);
}
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")),
IsRemind = dr.GetString(dr.GetOrdinal("IsRemind")) == "1" ? true : false,
Views = dr.IsDBNull(dr.GetOrdinal("Views")) ? 0 : dr.GetInt32(dr.GetOrdinal("Views")),
OperatorId = dr.IsDBNull(dr.GetOrdinal("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);
}
