/// <summary>
/// 分页工作交流集合
/// </summary>
/// <param name="pageSize">每页显示条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="CompanyId">公司编号 =0返回所有</param>
/// <param name="OperatorId">操作人编号</param>
/// <param name="QueryInfo">工作汇报查询实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.PersonalCenterStructure.WorkReport> GetList(int pageSize, int pageIndex, ref int RecordCount, int CompanyId, int OperatorId, EyouSoft.Model.PersonalCenterStructure.QueryWorkReport QueryInfo)
{
IList <EyouSoft.Model.PersonalCenterStructure.WorkReport> list = new List <EyouSoft.Model.PersonalCenterStructure.WorkReport>();
string tableName = "tbl_WorkReport";
string fields = "ReportId,Title,ReportingTime,OperatorName,Status,(select DepartName from tbl_CompanyDepartment where Id=tbl_WorkReport.DepartmentId) as DepartName ";
string primaryKey = "ReportId";
string orderbyStr = " ReportingTime DESC ";
StringBuilder strWhere = new StringBuilder(" IsDelete='0' ");
if (CompanyId > 0)
{
strWhere.AppendFormat(" and CompanyId={0} ", CompanyId);
}
if (OperatorId > 0)
{
strWhere.AppendFormat(" and ((dbo.fn_ValidUserLevDepartManagers({0},OperatorId)>0) OR (OperatorId={0})) ", OperatorId);
}
if (QueryInfo != null)
{
if (!string.IsNullOrEmpty(QueryInfo.Title))
{
strWhere.AppendFormat(" and Title like '%{0}%' ", QueryInfo.Title);
}
if (!string.IsNullOrEmpty(QueryInfo.OperatorName))
{
strWhere.AppendFormat(" and OperatorName like '%{0}%' ", QueryInfo.OperatorName);
}
if (QueryInfo.DepartmentId > 0)
{
strWhere.AppendFormat(" and DepartmentId={0} ", QueryInfo.DepartmentId);
}
if (QueryInfo.CreateSDate.HasValue)
{
strWhere.AppendFormat(" and datediff(dd,ReportingTime,'{0}')<=0 ", QueryInfo.CreateSDate.Value.ToString());
}
if (QueryInfo.CreateEDate.HasValue)
{
strWhere.AppendFormat(" and datediff(dd,ReportingTime,'{0}')>=0 ", QueryInfo.CreateEDate.Value.ToString());
}
}
using (IDataReader dr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref RecordCount, tableName, primaryKey, fields, strWhere.ToString(), orderbyStr))
{
while (dr.Read())
{
EyouSoft.Model.PersonalCenterStructure.WorkReport model = new EyouSoft.Model.PersonalCenterStructure.WorkReport();
if (!dr.IsDBNull(dr.GetOrdinal("ReportId")))
{
model.ReportId = dr.GetInt32(dr.GetOrdinal("ReportId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Title")))
{
model.Title = dr[dr.GetOrdinal("Title")].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("OperatorName")))
{
model.OperatorName = dr[dr.GetOrdinal("OperatorName")].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("DepartName")))
{
model.DepartmentName = dr[dr.GetOrdinal("DepartName")].ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("Status")))
{
model.Status = (EyouSoft.Model.EnumType.PersonalCenterStructure.CheckState) int.Parse(dr[dr.GetOrdinal("Status")].ToString());
}
if (!dr.IsDBNull(dr.GetOrdinal("ReportingTime")))
{
model.ReportingTime = dr.GetDateTime(dr.GetOrdinal("ReportingTime"));
}
list.Add(model);
model = null;
}
}
return(list);
}
/// <summary>
/// 分页工作交流集合
/// </summary>
/// <param name="pageSize">每页显示条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="QueryInfo">工作汇报查询实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.PersonalCenterStructure.WorkReport> GetList(int pageSize, int pageIndex, ref int RecordCount, EyouSoft.Model.PersonalCenterStructure.QueryWorkReport QueryInfo)
{
return(idal.GetList(pageSize, pageIndex, ref RecordCount, CompanyId, userId, QueryInfo));
}
