/// <summary>
/// 调动模块
/// 根据一级机构、二级结构、三级结构、登记时间和复核时间根据条件做分页查询
/// </summary>
/// <param name="sql">根据sql筛选</param>
/// <param name="rows">总行数</param>
/// <param name="IndexPage">当前页</param>
/// <param name="PageSize">总页数</param>
/// <returns></returns>
public List <major_change> SelectFenYeBySelect(string sql, out int rows, int IndexPage, int PageSize)
{
HR_DBEntities entity = new HR_DBEntities();
var select = entity.major_change.SqlQuery(sql).ToList(); //根据条件查询
rows = select.Count(); //获取总记录数
return(select.Skip((IndexPage - 1) * PageSize).Take(PageSize).ToList());
}
/// <summary>
/// 薪酬模块
/// 薪酬发放查询的分页
/// </summary>
/// <param name="sql"></param>
/// <param name="rows"></param>
/// <param name="IndexPage"></param>
/// <param name="PageSize"></param>
/// <returns></returns>
public List <salary_grant> SelectFenYeBySelect(string sql, out int rows, int IndexPage, int PageSize)
{
HR_DBEntities entity = new HR_DBEntities();
var select = entity.salary_grant.SqlQuery(sql).ToList();
rows = select.Count();
return(select.Skip((IndexPage - 1) * PageSize).Take(PageSize).ToList());
}
/// <summary>
/// 获取模型数据对象
/// </summary>
/// <returns>数据对象</returns>
public static HR_DBEntities CreateDBContent()
{
HR_DBEntities modelSet = CallContext.GetData("modelClass") as HR_DBEntities;
if (modelSet == null)
{
modelSet = new HR_DBEntities();
CallContext.SetData("modelClass", modelSet);
}
return(modelSet);
}
public static HR_DBEntities CreateDBContent()
{
HR_DBEntities at = CallContext.GetData("s") as HR_DBEntities;
if (at == null)
{
at = new HR_DBEntities();
CallContext.SetData("s", at);
}
return(at);
}
