/// <summary>
/// 分页工作交流集合
/// </summary>
/// <param name="pageSize">每页显示条数</param>
/// <param name="pageIndex">当前页码</param>
/// <param name="RecordCount">总记录数</param>
/// <param name="CompanyId">公司编号 =0返回所有</param>
/// <param name="OperatorId">操作人编号 =0返回所有</param>
/// <param name="QueryInfo">工作计划查询实体</param>
/// <returns></returns>
public IList <EyouSoft.Model.PersonalCenterStructure.WorkPlan> GetList(int pageSize, int pageIndex, ref int RecordCount, int CompanyId, int OperatorId, EyouSoft.Model.PersonalCenterStructure.QueryWorkPlan QueryInfo)
{
return(idal.GetList(pageSize, pageIndex, ref RecordCount, CompanyId, OperatorId, QueryInfo));
}
/// <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.WorkPlan> GetList(int pageSize, int pageIndex, ref int RecordCount, int CompanyId, int OperatorId, EyouSoft.Model.PersonalCenterStructure.QueryWorkPlan QueryInfo)
{
IList <EyouSoft.Model.PersonalCenterStructure.WorkPlan> list = new List <EyouSoft.Model.PersonalCenterStructure.WorkPlan>();
string tableName = "tbl_WorkPlan";
string fields = "PlanId,PlanNO,Title,Remark,OperatorId,(select ContactName from tbl_CompanyUser where Id=tbl_WorkPlan.OperatorId) as OperatorName,Status,ExpectedDate,ActualDate,CreateTime";
string primaryKey = "PlanId";
string orderbyStr = " CreateTime DESC ";
StringBuilder strWhere = new StringBuilder(" IsDelete='0' ");
if (CompanyId > 0)
{
strWhere.AppendFormat(" and CompanyId={0} ", CompanyId);
}
if (OperatorId > 0)
{
strWhere.AppendFormat(" and ((PlanId in(select PlanId from tbl_WorkPlanAccept where AccetpId={0})) OR (OperatorId={0}) OR (dbo.fn_ValidUserLevDepartManagers({0},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.LastSTime.HasValue)
{
strWhere.AppendFormat(" and datediff(dd,LastTime,'{0}')<=0 ", QueryInfo.LastSTime.Value.ToString());
}
if (QueryInfo.LastETime.HasValue)
{
strWhere.AppendFormat(" and datediff(dd,LastTime,'{0}')>=0 ", QueryInfo.LastETime.Value.ToString());
}
if (QueryInfo.Status.HasValue)
{
strWhere.AppendFormat(" and Status={0} ", (int)QueryInfo.Status.Value);
}
}
using (IDataReader dr = DbHelper.ExecuteReader(this._db, pageSize, pageIndex, ref RecordCount, tableName, primaryKey, fields, strWhere.ToString(), orderbyStr))
{
while (dr.Read())
{
EyouSoft.Model.PersonalCenterStructure.WorkPlan model = new EyouSoft.Model.PersonalCenterStructure.WorkPlan();
model.PlanId = dr.GetInt32(dr.GetOrdinal("PlanId"));
model.PlanNO = dr[dr.GetOrdinal("PlanNO")].ToString();
model.Title = dr[dr.GetOrdinal("Title")].ToString();
model.OperatorName = dr[dr.GetOrdinal("OperatorName")].ToString();
model.Remark = dr[dr.GetOrdinal("Remark")].ToString();
model.Status = (EyouSoft.Model.EnumType.PersonalCenterStructure.PlanCheckState) int.Parse(dr[dr.GetOrdinal("Status")].ToString());
if (!dr.IsDBNull(dr.GetOrdinal("ExpectedDate")))
{
model.ExpectedDate = dr.GetDateTime(dr.GetOrdinal("ExpectedDate"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ActualDate")))
{
model.ActualDate = dr.GetDateTime(dr.GetOrdinal("ActualDate"));
}
model.CreateTime = dr.GetDateTime(dr.GetOrdinal("CreateTime"));
if (!dr.IsDBNull(dr.GetOrdinal("OperatorId")))
{
model.OperatorId = dr.GetInt32(dr.GetOrdinal("OperatorId"));
}
list.Add(model);
model = null;
}
}
return(list);
}
