private static void AddCLoud(int tenantId, int sqlId, AppUserAccountInfo appUserAccountInfo)
{
ApplicationContext.Current.ApplicationName = "AppConnect";
ApplicationContext.Current.TenantId = tenantId;
ApplicationContext.Current.UserId = appUserAccountInfo.UserId;
var metaObject = CloudDataHelper.GetMetaObject(tenantId, "AppConnect.AppUser");
List <ObjectData> objectDatas = new List <ObjectData>();
ObjectData objectData = new ObjectData(metaObject);
objectData.ID = Guid.NewGuid();
objectData.CreatedBy = appUserAccountInfo.UserId;
objectData.CreatedTime = DateTime.Now;
objectData.ModifiedBy = appUserAccountInfo.UserId;
objectData.ModifiedTime = DateTime.Now;
objectData["StdIsDeleted"] = false;
objectData["TenantId"] = tenantId;
objectData["UserId"] = appUserAccountInfo.UserId;
objectData["UserEmail"] = appUserAccountInfo.BeisenAccount;
objectData["State"] = (int)appUserAccountInfo.State;
objectData["ActivateTime"] = DateTime.Now;
objectData["OpenId"] = appUserAccountInfo.OpenId;
objectData["AppId"] = appUserAccountInfo.AppId;
objectData["SqlId"] = sqlId;
objectData["LoginType"] = ((int)appUserAccountInfo.Type).ToString();
objectData["MasterAccountId"] = appUserAccountInfo.MasterAccountId;
objectDatas.Add(objectData);
CloudDataHelper.Add(metaObject, objectDatas);
}
private static void AddCloudData(int tenantId, List <AppUserAccountInfo> appUserAccountInfos, ref string message)
{
try
{
message += string.Format("租户：{0} 开始处理数据\r\n", tenantId);
BeisenUserDao.SetContext(tenantId);
//先删除该租户数据
List <string> delObjectIds = new List <string>();
var multiDataDic = GetMultiTenantData(tenantId);
foreach (var item in multiDataDic)
{
if (!delObjectIds.Contains(Convert.ToString(item.ID)))
{
delObjectIds.Add(Convert.ToString(item.ID));
}
}
CloudDataHelper.Delete("AppConnect.AppUser", tenantId, delObjectIds.ToArray());
message += string.Format("租户：{0} 开始删除{1}条数据\r\n", tenantId, delObjectIds.Count);
var metaObject = CloudDataHelper.GetMetaObject(tenantId, "AppConnect.AppUser");
List <ObjectData> objectDatas = new List <ObjectData>();
foreach (var appUserAccountInfo in appUserAccountInfos)
{
ObjectData objectData = new ObjectData(metaObject);
objectData.ID = Guid.NewGuid();
objectData.CreatedBy = appUserAccountInfo.UserId;
objectData.CreatedTime = appUserAccountInfo.CreateTime;
objectData.ModifiedBy = appUserAccountInfo.UserId;
objectData.ModifiedTime = appUserAccountInfo.ModifyTime;
objectData["StdIsDeleted"] = false;
objectData["TenantId"] = appUserAccountInfo.TenantId;
objectData["UserId"] = appUserAccountInfo.UserId;
objectData["UserEmail"] = appUserAccountInfo.BeisenAccount;
objectData["State"] = appUserAccountInfo.StateNotEnum;
objectData["ActivateTime"] = appUserAccountInfo.CreateTime;
objectData["OpenId"] = appUserAccountInfo.OpenId;
objectData["AppId"] = appUserAccountInfo.AppId;
objectData["SqlId"] = appUserAccountInfo.Id;
objectData["LoginType"] = appUserAccountInfo.TypeNotEnum;
objectData["SqlId"] = appUserAccountInfo.Id;
objectData["MasterAccountId"] = appUserAccountInfo.MasterAccountId;
objectDatas.Add(objectData);
}
CloudDataHelper.Add(metaObject, objectDatas);
message += string.Format("租户：{0} 处理完毕，共处理{1}条数据 \r\n", tenantId, objectDatas.Count);
}
catch (Exception ex)
{
message += string.Format("租户：{0} 修复数据失败！\r\n", tenantId);
AppConnectLogHelper.ErrorFormat(message, ex);
Froms.MessageBox.Show(ex.Message);
}
}
private static void AddCLoud(int tenantId, List <AppUserAccountInfo> appUserAccountInfos, ref string message)
{
try
{
BeisenUserDao.SetContext(tenantId);
message += string.Format("租户：{0} 开始处理\r\n", tenantId);
var metaObject = CloudDataHelper.GetMetaObject(tenantId, "AppConnect.AppUser");
List <ObjectData> objectDatas = new List <ObjectData>();
var appUserAccountInfos_tenantId = appUserAccountInfos.Where(w => w.TenantId == tenantId).ToList();
if (appUserAccountInfos_tenantId != null && appUserAccountInfos_tenantId.Count > 0)
{
appUserAccountInfos_tenantId.ForEach(appUserAccountInfo =>
{
ObjectData objectData = new ObjectData(metaObject);
objectData.ID = Guid.NewGuid();
objectData.CreatedBy = appUserAccountInfo.UserId;
objectData.CreatedTime = DateTime.Now;
objectData.ModifiedBy = appUserAccountInfo.UserId;
objectData.ModifiedTime = DateTime.Now;
objectData["StdIsDeleted"] = false;
objectData["TenantId"] = appUserAccountInfo.TenantId;
objectData["UserId"] = appUserAccountInfo.UserId;
objectData["UserEmail"] = appUserAccountInfo.BeisenAccount;
objectData["State"] = appUserAccountInfo.StateNotEnum;
objectData["ActivateTime"] = DateTime.Now;
objectData["OpenId"] = appUserAccountInfo.OpenId;
objectData["AppId"] = appUserAccountInfo.AppId;
objectData["SqlId"] = appUserAccountInfo.Id;
objectData["LoginType"] = appUserAccountInfo.TypeNotEnum;
objectData["SqlId"] = appUserAccountInfo.Id;
objectData["MasterAccountId"] = appUserAccountInfo.MasterAccountId;
objectDatas.Add(objectData);
});
}
CloudDataHelper.Add(metaObject, objectDatas);
message += string.Format("租户：{0} 处理完毕，共处理{objectDatas.Count}条数据 \r\n", tenantId);
}
catch (Exception ex)
{
message += string.Format("租户：{0} 修复数据失败！\r\n", tenantId);
AppConnectLogHelper.ErrorFormat(message, ex);
Froms.MessageBox.Show(ex.Message);
}
}
internal static void AddOrUpdateCLoud(int tenantId, int userId, AppAccountInfo info)
{
var metaObject = CloudDataHelper.GetMetaObject(tenantId, "AppConnect.AppUser");
List <ObjectData> objectDatas = new List <ObjectData>();
ObjectData objectdata = new ObjectData(metaObject);
objectdata.ID = Guid.NewGuid();
objectdata.CreatedBy = userId;
objectdata.CreatedTime = DateTime.Now;
objectdata.ModifiedBy = userId;
objectdata.ModifiedTime = DateTime.Now;
objectdata["StdIsDeleted"] = false;
objectdata["TenantId"] = tenantId;
objectdata["StaffID"] = info.CreateBy;
objectdata["UserEmail"] = info.CreateBy;
objectDatas.Add(objectdata);
CloudDataHelper.Add(metaObject, objectDatas);
}
public static void MigrationUserInfoMapping(string metaObjectName, ref string message)
{
try
{
var appId = SqlHelper.GetAppIdByType();
var appIdList = appId.Select(n => Convert.ToString(n.AppId)).ToList();
var appIdStr = string.Join(",", appIdList.ToArray());
var userInfoList = SqlHelper.GetInfoByAppId(appIdStr);
var userInfoGroupByTenantId = userInfoList.GroupBy(n => n.TenantId);
foreach (var item in userInfoGroupByTenantId)
{
//存储到各个租户
var metaObj = CloudDataHelper.GetMetaObject(item.Key, metaObjectName);
List <ObjectData> objectDataList = new List <ObjectData>();
foreach (var info in item)
{
var data = saveCloud(metaObj, info);
objectDataList.Add(data);
}
CloudDataHelper.Add(metaObj, objectDataList);
//存储到公共租户
var sysMetaObj = CloudDataHelper.GetMetaObject(SystemInfo.ISVSystemTenantId, metaObjectName);
List <ObjectData> sysObjectDataList = new List <ObjectData>();
foreach (var info in item)
{
var data = saveCloud(sysMetaObj, info);
objectDataList.Add(data);
}
CloudDataHelper.Add(sysMetaObj, sysObjectDataList);
}
}
catch (Exception ex)
{
message += string.Format("租户：{tenantId} 修复数据失败！\r\n");
logger.ErrorFormat(message, ex);
MessageBox.Show(message);
return;
}
}
private void AddCLoud(int tenantId, List <AppUserAccountInfo> appUserAccountInfos)
{
ApplicationContext.Current.ApplicationName = "AppConnect";
ApplicationContext.Current.TenantId = tenantId;
ApplicationContext.Current.UserId = 100000;
var metaObject = CloudDataHelper.GetMetaObject(tenantId, "AppConnect.AppUser");
List <ObjectData> objectDatas = new List <ObjectData>();
var appUserAccountInfos_tenantId = appUserAccountInfos.Where(w => w.TenantId == tenantId).ToList();
if (appUserAccountInfos_tenantId != null && appUserAccountInfos_tenantId.Count > 0)
{
appUserAccountInfos_tenantId.ForEach(appUserAccountInfo =>
{
ObjectData objectData = new ObjectData(metaObject);
objectData.ID = Guid.NewGuid();
objectData.CreatedBy = appUserAccountInfo.UserId;
objectData.CreatedTime = DateTime.Now;
objectData.ModifiedBy = appUserAccountInfo.UserId;
objectData.ModifiedTime = DateTime.Now;
objectData["StdIsDeleted"] = false;
objectData["TenantId"] = appUserAccountInfo.TenantId;
objectData["UserId"] = appUserAccountInfo.UserId;
objectData["UserEmail"] = appUserAccountInfo.BeisenAccount;
objectData["State"] = appUserAccountInfo.StateNotEnum;
objectData["ActivateTime"] = DateTime.Now;
objectData["OpenId"] = appUserAccountInfo.OpenId;
objectData["AppId"] = appUserAccountInfo.AppId;
objectData["SqlId"] = appUserAccountInfo.Id;
objectData["LoginType"] = appUserAccountInfo.TypeNotEnum;
objectData["SqlId"] = appUserAccountInfo.Id;
objectData["MasterAccountId"] = appUserAccountInfo.MasterAccountId;
objectDatas.Add(objectData);
});
}
CloudDataHelper.Add(metaObject, objectDatas);
}