/// <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); }