/// <summary> /// getById /// </summary> public role getById(int id) { using (qdbEntities myDb = new qdbEntities()) { // TODO 生成代码后需要检查一下是否找到正确的主键,这里做一个错误代码,避免直接使用 return(myDb.Set <role>().Where <role>(p => p.ID == id).FirstOrDefault <role>()); } }
/// <summary> /// getById /// </summary> public general_workflow_func getById(int id) { using (qdbEntities myDb = new qdbEntities()) { // TODO 生成代码后需要检查一下是否找到正确的主键,这里做一个错误代码,避免直接使用 return(myDb.Set <general_workflow_func>().Where <general_workflow_func>(p => p.ORIGREC == id).FirstOrDefault <general_workflow_func>()); } }
/// <summary> /// getById /// </summary> public roles_menus getById(int id, int menuid) { using (qdbEntities myDb = new qdbEntities()) { // TODO 生成代码后需要检查一下是否找到正确的主键,这里做一个错误代码,避免直接使用 return(myDb.Set <roles_menus>().Where <roles_menus>(p => p.MENU_ID == id && p.ROLE_ID == menuid).FirstOrDefault <roles_menus>()); } }
/// <summary> /// getById /// </summary> public users_roles getById(int id, int roleid) { using (qdbEntities myDb = new qdbEntities()) { // TODO 生成代码后需要检查一下是否找到正确的主键,这里做一个错误代码,避免直接使用 return(myDb.Set <users_roles>().Where <users_roles>(p => p.USER_ID == id && p.ROLE_ID == roleid).FirstOrDefault <users_roles>()); // return myDb.Set<users_roles>().Where<users_roles>(p => p.ROLE_ID == id).FirstOrDefault<users_roles>(); } }
/// <summary> /// 分页查询 + 条件查询 + 排序 /// </summary> /// <typeparam name="Tkey">泛型</typeparam> /// <param name="pageSize">每页大小</param> /// <param name="pageIndex">当前页码</param> /// <param name="total">总数量</param> /// <param name="whereLambda">查询条件</param> /// <param name="orderbyLambda">排序条件</param> /// <param name="isAsc">是否升序</param> /// <returns>IQueryable 泛型集合</returns> public List <T> LoadPageItems <T, TKey>(int pageSize, int pageIndex, out int total, Expression <Func <T, bool> > whereLambda, Func <T, TKey> orderbyLambda, bool isAsc) where T : class { using (qdbEntities qdb = new qdbEntities()) { total = qdb.Set <T>().Where(whereLambda).Count(); if (isAsc) { var temp = qdb.Set <T>().Where(whereLambda) .OrderBy <T, TKey>(orderbyLambda) .Skip(pageSize * (pageIndex - 1)) .Take(pageSize); return(temp.ToList()); } else { var temp = qdb.Set <T>().Where(whereLambda) .OrderByDescending <T, TKey>(orderbyLambda) .Skip(pageSize * (pageIndex - 1)) .Take(pageSize); return(temp.ToList()); } } }