private static List <AppUserAccountInfo> GetAppUserAccountInSql() { List <AppUserAccountInfo> appUserAccountInfos = new List <AppUserAccountInfo>(); Database database = Database.GetDatabase("BeisenUserSecurity"); SafeProcedure.ExecuteAndGetInstanceList(database, "[dbo].[AppUserAccount_GetAll]", delegate(IRecord record, int entity) { AppUserAccountInfo appUserAccountInfo = new AppUserAccountInfo(); appUserAccountInfo.Id = record.GetOrDefault <int>("Id", 0); appUserAccountInfo.AppId = record.GetOrDefault <string>("AppId", ""); appUserAccountInfo.OpenId = record.GetOrDefault <string>("OpenId", ""); appUserAccountInfo.TenantId = record.GetOrDefault <int>("TenantId", 0); appUserAccountInfo.UserId = record.GetOrDefault <int>("UserId", 0); appUserAccountInfo.BeisenAccount = record.GetOrDefault <string>("BeisenAccount", ""); appUserAccountInfo.TypeNotEnum = record.GetOrDefault <Int16>("Type", 0); appUserAccountInfo.StateNotEnum = record.GetOrDefault <Int16>("State", 0); appUserAccountInfo.ActivateTime = record.GetOrDefault <DateTime>("ActivateTime", DateTime.Now); appUserAccountInfo.CreateTime = record.GetOrDefault <DateTime>("CreateTime", DateTime.Now); appUserAccountInfo.UnbindTime = record.GetOrDefault <DateTime>("UnbindTime", DateTime.Now); appUserAccountInfo.MasterAccountId = record.GetOrDefault <int>("MasterAccountId", 0); appUserAccountInfos.Add(appUserAccountInfo); }); return(appUserAccountInfos); }
public static List <AppIdModel> GetAppIdByType() { var db = Database.GetDatabase("BeisenAppConnect"); var result = SafeProcedure.ExecuteAndGetInstanceList <AppIdModel>(db, "dbo.AppAccount_GetAppIdByType", parameterMapper => { }, AppIdInfo); return(result); }
internal static List <AppAccountInfo> GetListByTenantId(int tenantId) { var db = Database.GetDatabase(DatabaseName.AppConnect); var list = SafeProcedure.ExecuteAndGetInstanceList <AppAccountInfo>(db, "dbo.AppAccount_GetListByTenantId", parameterMapper => { parameterMapper.AddWithValue("@TenantId", tenantId); }, BuildInfo); return(list); }
public static List <UserInfoModel> GetInfoByAppId(string appIds) { var db = Database.GetDatabase("BeisenUserSecurity"); var list = SafeProcedure.ExecuteAndGetInstanceList <UserInfoModel>(db, "dbo.AppUserAccount_GetInfoByAppId", parameterMapper => { parameterMapper.AddWithValue("@AppId", appIds); }, BuildInfo); return(list); }
internal static List <AppUserAccountInfo> GetListByUserId(int tenantId, string userIds) { var db = Database.GetDatabase(DatabaseName.UserSecurity); var list = SafeProcedure.ExecuteAndGetInstanceList <AppUserAccountInfo>(db, "dbo.AppUserAccount_GetListByUserId", parameterMapper => { parameterMapper.AddWithValue("@TenantId", tenantId); parameterMapper.AddWithValue("@UserIds", userIds); }, BuildInfo); return(list); }
/// <summary> /// 根据TenantId和状态获取用户 /// </summary> /// <param name="tenantId"></param> /// <param name="appId"></param> /// <param name="states"></param> /// <returns></returns> internal static List <AppUserAccountInfo> GetByTenantId(int tenantId, string appId, string states) { var db = Database.GetDatabase(DatabaseName.UserSecurity); return(SafeProcedure.ExecuteAndGetInstanceList <AppUserAccountInfo>(db, "dbo.AppUserAccount_GetByTenantId", parameterMapper => { parameterMapper.AddWithValue("@TenantId", tenantId); parameterMapper.AddWithValue("@States", states); parameterMapper.AddWithValue("@AppId", appId); }, BuildInfo)); }
public static List <int> GetAllTenantIds() { Database database = Database.GetDatabase("BeisenTenantSecurity"); var tenantIds = new HashSet <int>(); SafeProcedure.ExecuteAndGetInstanceList(database, "dbo.Auth_GetTenantAll", delegate(IRecord record, int entity) { int dbTenantId = record.GetOrDefault <int>("ID", 0); if (dbTenantId > 0) { tenantIds.Add(dbTenantId); } }); return(tenantIds.Distinct().ToList()); }
internal static List <AppUserAccountInfo> ConvertToUserId(int tenantId, string appId, string openIds) { var db = Database.GetDatabase(DatabaseName.UserSecurity); var list = SafeProcedure.ExecuteAndGetInstanceList <AppUserAccountInfo>(db, "dbo.AppUserAccount_ConvertToUserId", parameterMapper => { parameterMapper.AddWithValue("@AppId", appId); parameterMapper.AddWithValue("@OpenIds", openIds); parameterMapper.AddWithValue("@TenantId", tenantId); }, delegate(IRecord record, AppUserAccountInfo entity) { entity.OpenId = record.Get <string>("OpenId"); entity.TenantId = record.Get <int>("TenantId"); entity.UserId = record.Get <int>("UserId"); }); return(list); }
public static List <int> GetAllCompensationTenantIds() { Database database = Database.GetDatabase("BeisenTenantSecurity"); var tenantIds = new HashSet <int>(); SafeProcedure.ExecuteAndGetInstanceList(database, "dbo.Auth_GetTenantIdsByProductID", delegate(IParameterSet parameters) { parameters.AddWithValue("@productID", "DC4EED15-D7D3-42B1-AC3D-CEA68A0A95B2"); }, delegate(IRecord record, int entity) { int dbTenantId = record.GetOrDefault <int>("TenantID", 0); if (dbTenantId > 0) { tenantIds.Add(dbTenantId); } }); return(tenantIds.Distinct().ToList()); }
internal static List <AppUserAccountInfo> List(int tenantId, string appId, int pageSize, int pageNum, out int total) { var db = Database.GetDatabase(DatabaseName.UserSecurity); var totalParameter = new SqlParameter("@Total", SqlDbType.Int) { Direction = ParameterDirection.Output }; var result = SafeProcedure.ExecuteAndGetInstanceList <AppUserAccountInfo>(db, "dbo.AppUserAccount_List", BuildInfo, new SqlParameter[] { totalParameter, new SqlParameter("@TenantId", tenantId), new SqlParameter("@AppId", appId), new SqlParameter("@PageSize", pageSize), new SqlParameter("@PageNum", pageNum) }); total = (int)totalParameter.Value; return(result); }
private static Dictionary <int, List <AppUserAccountInfo> > GetAppUserAccountInSql() { Dictionary <int, List <AppUserAccountInfo> > appUserAccountInfoDic = new Dictionary <int, List <AppUserAccountInfo> >(); Database database = Database.GetDatabase("BeisenUserSecurity"); SafeProcedure.ExecuteAndGetInstanceList(database, "[dbo].[AppUserAccount_GetAll]", delegate(IRecord record, int entity) { AppUserAccountInfo appUserAccountInfo = new AppUserAccountInfo(); appUserAccountInfo.Id = record.GetOrDefault <int>("Id", 0); appUserAccountInfo.AppId = record.GetOrDefault <string>("AppId", ""); appUserAccountInfo.OpenId = record.GetOrDefault <string>("OpenId", ""); appUserAccountInfo.TenantId = record.GetOrDefault <int>("TenantId", 0); appUserAccountInfo.UserId = record.GetOrDefault <int>("UserId", 0); appUserAccountInfo.BeisenAccount = record.GetOrDefault <string>("BeisenAccount", ""); appUserAccountInfo.TypeNotEnum = record.GetOrDefault <Int16>("Type", 0); appUserAccountInfo.StateNotEnum = record.GetOrDefault <Int16>("State", 0); appUserAccountInfo.CreateTime = record.GetOrDefault <DateTime>("CreateTime", DateTime.Now); appUserAccountInfo.ActivateTime = record.GetOrDefault <DateTime>("ActivateTime", appUserAccountInfo.CreateTime); appUserAccountInfo.UnbindTime = record.GetOrDefault <DateTime>("UnbindTime", DateTime.Now); appUserAccountInfo.MasterAccountId = record.GetOrDefault <int>("MasterAccountId", 0); if (appUserAccountInfoDic.ContainsKey(appUserAccountInfo.TenantId)) { var existList = appUserAccountInfoDic[appUserAccountInfo.TenantId]; existList.Add(appUserAccountInfo); appUserAccountInfoDic[appUserAccountInfo.TenantId] = existList; } else { appUserAccountInfoDic.Add(appUserAccountInfo.TenantId, new List <AppUserAccountInfo> { appUserAccountInfo }); } }); return(appUserAccountInfoDic); }