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