/// <summary> /// 获取单条 /// </summary> /// <param name="key"></param> /// <returns></returns> public static async Task <int> GetNextID <T>() where T : new() { string tableName = new ModelHelper <T> ().GetTableName(); var single = await dbHelper.SingleByKey(tableName); if (single == null) { single = new SysSequenceEntity(); single.seq_name = tableName; single.current_val = 1; single.increment_val = 1; await dbHelper.Save(new DtoSave <SysSequenceEntity> { data = single, ignoreFieldList = new List <string>() }); } else { single.current_val += single.increment_val; await dbHelper.Update(new DtoSave <SysSequenceEntity> { data = single, saveFieldListExp = x => new object[] { x.current_val }, }); } return(single.current_val); }
/// <summary> /// 获取单条 /// </summary> /// <param name="key"></param> /// <returns></returns> public async Task <SysRoleEntity> SingleByKey(int key) { var ent = await dbHelper.SingleByKey(key); DapperHelper <FaRoleModuleEntityView> roleModule = new DapperHelper <FaRoleModuleEntityView>(); ent.moduleIdStr = (await roleModule.FindAll(i => i.roleId == key)).Select(i => i.id).ToArray(); return(ent); }
/// <summary> /// 获取单条 /// </summary> /// <param name="key"></param> /// <returns></returns> public async Task <SysUserEntity> SingleByKey(int key) { var ent = await dbHelper.SingleByKey(key); ent.roleIdList = (await new DapperHelper <FaUserRoleEntityView>().FindAll(i => i.userId == key)).Select(x => x.roleId).ToList(); DapperHelper <FaUserRoleEntityView> dapperUserRole = new DapperHelper <FaUserRoleEntityView>(); var role = await dapperUserRole.FindAll(i => i.userId == ent.id); ent.isAdmin = role.Count(i => i.roleId == 1) > 0; ent.isLeader = role.Count(i => i.roleId == 2) > 0; return(ent); }
/// <summary> /// 获取单条 /// </summary> /// <param name="key"></param> /// <returns></returns> public Task <SysLoginHistoryEntity> SingleByKey(int key) { return(dbHelper.SingleByKey(key)); }
/// <summary> /// 获取单条 /// </summary> /// <param name="key"></param> /// <returns></returns> public Task <SysModuleEntity> SingleByKey(int key) { return(dbHelper.SingleByKey(key)); }
/// <summary> /// 获取单条 /// </summary> /// <param name="key"></param> /// <returns></returns> public Task <SysLoginEntity> SingleByKey(int key) { DapperHelper <SysLoginEntity> dbHelper = new DapperHelper <SysLoginEntity>(); return(dbHelper.SingleByKey(key)); }