/// <summary>
/// 获得规章制度信息列表
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="SearchModel">查询实体</param>
/// <param name="ItemType">附件类型</param>
/// <param name="PageSize">页面数据总记录数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">每页显示的记录数</param>
/// <returns></returns>
public IList <Model.GovStructure.MGovRegulation> GetGovRegulationList(string CompanyId, EyouSoft.Model.GovStructure.MGovRegSearch SearchModel, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType, int PageSize, int PageIndex, ref int RecordCount)
{
if (CompanyId.Trim() == "")
{
return(null);
}
IList <Model.GovStructure.MGovRegulation> ResultList = null;
string tableName = "view_GovRegulation";
string identityColumnName = "RegId";
string fields = " RegId,CompanyId,Code,Title,OperatorId,IssueTime,IssuedId,IssuedName,IssuedDeptId,IssuedDepartName,DepartmentXML,ComAttachXML ";
string query = string.Format(" CompanyId='{0}'", CompanyId);
if (SearchModel != null)
{
if (!string.IsNullOrEmpty(SearchModel.Code))
{
query = query + string.Format(" AND [Code] LIKE '%{0}%' ", SearchModel.Code);
}
if (!string.IsNullOrEmpty(SearchModel.Title))
{
query = query + string.Format(" AND [Title] LIKE '%{0}%' ", SearchModel.Title);
}
if (SearchModel.DepIds != null && SearchModel.DepIds.Length > 0)
{
StringBuilder sId = new StringBuilder();
for (int i = 0; i < SearchModel.DepIds.Length; i++)
{
sId.AppendFormat("{0},", SearchModel.DepIds[i]);
}
sId.Remove(sId.Length - 1, 1);
if (!string.IsNullOrEmpty(sId.ToString()))
{
query = query + string.Format(" AND EXISTS(SELECT RegId FROM tbl_GovRegApplyDept WHERE RegId=view_GovRegulation.RegId AND DepartId IN ({0})) ", sId);
}
}
if (!string.IsNullOrEmpty(SearchModel.DepName) && (SearchModel.DepIds == null || SearchModel.DepIds.Length < 1))
{
query = query + string.Format(" and DepartmentXML like '%{0}%'", SearchModel.DepName);
}
}
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 <Model.GovStructure.MGovRegulation>();
while (dr.Read())
{
EyouSoft.Model.GovStructure.MGovRegulation model = new EyouSoft.Model.GovStructure.MGovRegulation()
{
RegId = dr.GetString(dr.GetOrdinal("RegId")),
CompanyId = dr.GetString(dr.GetOrdinal("CompanyId")),
Code = dr.GetString(dr.GetOrdinal("Code")),
Title = dr.GetString(dr.GetOrdinal("Title")),
OperatorId = dr.IsDBNull(dr.GetOrdinal("OperatorId")) ? "" : dr.GetString(dr.GetOrdinal("OperatorId")),
IssuedId = dr.IsDBNull(dr.GetOrdinal("IssuedId")) ? "" : dr.GetString(dr.GetOrdinal("IssuedId")),
IssuedName = dr.IsDBNull(dr.GetOrdinal("IssuedName")) ? "" : dr.GetString(dr.GetOrdinal("IssuedName")),
IssuedDeptId = dr.IsDBNull(dr.GetOrdinal("IssuedDeptId")) ? 0 : dr.GetInt32(dr.GetOrdinal("IssuedDeptId")),
IssuedDepartName = dr.IsDBNull(dr.GetOrdinal("IssuedDepartName")) ? "" : dr.GetString(dr.GetOrdinal("IssuedDepartName")),
IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")),
ComAttachList = this.GetAttachList(dr["ComAttachXML"].ToString(), dr.GetString(dr.GetOrdinal("RegId")), ItemType),
ApplyDeptList = this.GetDepartmentList(dr["DepartmentXML"].ToString()),
};
ResultList.Add(model);
model = null;
}
};
return(ResultList);
}
/// <summary>
/// 获得规章制度信息列表
/// </summary>
/// <param name="CompanyId">公司编号</param>
/// <param name="SearchModel">查询实体</param>
/// <param name="PageSize">每页记录数</param>
/// <param name="PageIndex">当前页数</param>
/// <param name="RecordCount">总记记录数</param>
/// <returns></returns>
public IList <Model.GovStructure.MGovRegulation> GetGovRegulationList(string CompanyId, EyouSoft.Model.GovStructure.MGovRegSearch SearchModel, EyouSoft.Model.EnumType.ComStructure.AttachItemType ItemType, int PageSize, int PageIndex, ref int RecordCount)
{
IList <Model.GovStructure.MGovRegulation> list = null;
if (!string.IsNullOrEmpty(CompanyId))
{
list = new List <Model.GovStructure.MGovRegulation>();
list = dal.GetGovRegulationList(CompanyId, SearchModel, ItemType, PageSize, PageIndex, ref RecordCount);
}
return(list);
}
