/// <summary>
/// 根据组织机构ID获取所对应的用户集合
/// </summary>
/// <param name="folder_id"></param>
/// <returns></returns>
public List <HCQ2_Model.T_User> GetOrgUsers(OrgTableParamModel model, out int total)
{
total = 0;
if (null == model || model.folder_id <= 0)
{
return(null);
}
if (string.IsNullOrEmpty(model.keyword))
{
total = (from o in db.Set <HCQ2_Model.T_OrgUserRelation>()
join s in db.Set <HCQ2_Model.T_User>()
on o.user_id equals s.user_id
where o.folder_id == model.folder_id
select s).ToList().Count;
return((from o in db.Set <HCQ2_Model.T_OrgUserRelation>()
join s in db.Set <HCQ2_Model.T_User>()
on o.user_id equals s.user_id
where o.folder_id == model.folder_id
select s).OrderBy(s => s.user_id).ToList().Skip((model.page - 1) * model.rows).Take(model.rows).ToList());
}
else
{
total = (from o in db.Set <HCQ2_Model.T_OrgUserRelation>()
join s in db.Set <HCQ2_Model.T_User>()
on o.user_id equals s.user_id
where o.folder_id == model.folder_id && s.user_name.Contains(model.keyword)
select s).ToList().Count;
return((from o in db.Set <HCQ2_Model.T_OrgUserRelation>()
join s in db.Set <HCQ2_Model.T_User>()
on o.user_id equals s.user_id
where o.folder_id == model.folder_id && s.user_name.Contains(model.keyword)
select s).OrderBy(s => s.user_id).ToList().Skip((model.page - 1) * model.rows).Take(model.rows).ToList());
}
}
/// <summary>
/// 获取Table数据
/// </summary>
/// <param name="model">参数</param>
/// <param name="total">根据条件返回记录条数</param>
/// <returns></returns>
public List <T_User> GetTableData(OrgTableParamModel model, out int total)
{
total = 0;
if (null == model || model.folder_id <= 0)
{
return(null);
}
return(DBSession.IT_OrgFolderDAL.GetOrgUsers(model, out total));
}
public ActionResult InitTable(OrgTableParamModel model)
{
if (model.folder_id == 0)
{
return(null);
}
int total = 0;
List <T_User> list = operateContext.bllSession.T_OrgFolder.GetTableData(model, out total);
TableModel tModel = new TableModel()
{
total = total,
rows = list
};
return(Json(tModel, JsonRequestBehavior.AllowGet));
}
