/// <summary>
/// 数据映射
/// </summary>
/// <param name="record">记录</param>
/// <param name="info">实体</param>
private static void BuildInfo(IRecord record, BindBatchInfo info)
{
info.Id = record.Get <int>("Id");
info.TenantId = record.Get <int>("TenantId");
info.AppUserAccountId = record.Get <int>("AppUserAccountId");
info.BeisenAccount = record.Get <string>("BeisenAccount");
info.Batch = record.Get <string>("Batch");
info.Type = (AppUserAccountType)record.Get <short>("Type");
info.State = (BindBatchState)record.Get <short>("State");
}
/// <summary>
/// 增加绑定批次
/// </summary>
/// <param name="tenantId"></param>
/// <param name="info"></param>
/// <returns></returns>
public int Add(int tenantId, BindBatchInfo info)
{
ArgumentHelper.AssertIsTrue(tenantId > 0, "tenantId is 0");
ArgumentHelper.AssertNotNull(info, "info is null");
ArgumentHelper.AssertIsTrue(info.TenantId > 0, "info.TenantId is 0");
ArgumentHelper.AssertIsTrue(info.AppUserAccountId > 0, "info.AppUserAccountId is 0");
ArgumentHelper.AssertNotNullOrEmpty(info.BeisenAccount, "info.BeisenAccount is null");
return(BindBatchDao.Insert(tenantId, info));
}
/// <summary>
/// 增加绑定批次
/// </summary>
/// <param name="tenantId"></param>
/// <param name="info"></param>
/// <returns></returns>
internal static int Insert(int tenantId, BindBatchInfo info)
{
var db = Database.GetDatabase(DatabaseName.AppConnect);
int id = 0;
SafeProcedure.ExecuteNonQuery(db, "dbo.BindBatch_Insert", parameterMapper =>
{
parameterMapper.AddWithValue("@TenantId", info.TenantId);
parameterMapper.AddWithValue("@AppUserAccountId", info.AppUserAccountId);
parameterMapper.AddWithValue("@BeisenAccount", info.BeisenAccount);
parameterMapper.AddWithValue("@Batch", info.Batch);
parameterMapper.AddWithValue("@Type", (short)info.Type);
parameterMapper.AddTypedDbNull("@Id", ParameterDirectionWrap.Output, DbType.Int32);
}, o =>
{
id = (int)o.GetValue("@Id");
});
return(id);
}
public BindResult Bind(Dictionary <string, string> openIds, string batch, string userName, string password, string captcha)
{
var result = new BindResult
{
NeedCaptcha = false
};
var callback = ProviderGateway.CallbackContentProvider.GetByBatchId(batch);
var appAccountPublic = ProviderGateway.AppAccountProvider.Get(callback.AppAccountPublic);
if (!openIds.ContainsKey(appAccountPublic.AppId))
{
result.Result = 2;
result.Message = "用户公有OpenId无效";
return(result);
}
AppAccountInfo appAccountPrivate = null;
if (callback.TenantId != 0)
{
appAccountPrivate = ProviderGateway.AppAccountProvider.Get(callback.AppAccountPrivate);
if (!openIds.ContainsKey(appAccountPrivate.AppId))
{
result.Result = 2;
result.Message = "用户私有OpenId无效";
return(result);
}
}
var openIdPublic = openIds[appAccountPublic.AppId];
var currentAppUserAccount = ProviderGateway.AppUserAccountProvider.GetByOpenId(appAccountPublic.AppId, openIdPublic);
if (currentAppUserAccount != null && currentAppUserAccount.State == AppUserAccountState.Activated)
{
result.Result = 8;
result.Message = "您已经绑定过了，无需重复绑定";
return(result);
}
//验证发送时间
if (RedisHelper.IsExist(RedisConstName.SendCheck + userName))
{
result.Result = 6;
result.Message = "绑定过于频繁";
return(result);
}
// 校验邮箱是否存在
var userId = Proxy.BeisenUserProxy.GetSecurityByUserName(userName);
if (userId <= 0)
{
result.Result = 5;
result.Message = "未找到对应账户";
return(result);
}
var tenantId = Proxy.BeisenUserProxy.GetTenantId(userId);
var oldAppUserAccount = ProviderGateway.AppUserAccountProvider.GetByUserId(tenantId, userId, appAccountPublic.AppId);
if (oldAppUserAccount != null && oldAppUserAccount.State == AppUserAccountState.Activated)
{
result.Result = 7;
result.Message = "帐号已绑定";
return(result);
}
var newAppUserAccountMaster = new AppUserAccountInfo
{
AppId = appAccountPublic.AppId,
OpenId = openIdPublic,
TenantId = tenantId,
UserId = userId,
BeisenAccount = userName,
Type = _type,
State = AppUserAccountState.Inactive,
MasterAccountId = 0
};
var masterAccountId = ProviderGateway.AppUserAccountProvider.AddOrUpdate(tenantId, newAppUserAccountMaster);
//增加私有关联关系
if ((appAccountPublic.Type == 11 || appAccountPublic.Type == 12) && callback.TenantId != 0 && masterAccountId != 0)
{
var newAppAccountUser = new AppUserAccountInfo
{
AppId = appAccountPrivate.AppId,
OpenId = openIds[appAccountPrivate.AppId],
TenantId = tenantId,
UserId = userId,
BeisenAccount = userName,
Type = _type,
State = AppUserAccountState.Inactive,
MasterAccountId = masterAccountId
};
ProviderGateway.AppUserAccountProvider.AddOrUpdate(tenantId, newAppAccountUser);
}
// 记录发邮件记录
var bindBatch = new BindBatchInfo
{
TenantId = tenantId,
AppUserAccountId = masterAccountId,
BeisenAccount = userName,
Type = _type,
State = BindBatchState.UnUse
};
var bindBatchId = ProviderGateway.BindBatchProvider.Add(tenantId, bindBatch);
// 发送激活邮件
string activateCode = CryptographyHelper.AESEncrypt(tenantId + "_" + bindBatchId);
string emailBody = GetEmailBody(userName, AppConnectHostConfig.Cache[0] + HostConst.UserActivate + "?code=" + activateCode);
var emailBatch = EmailProxy.SendEmail(0, "iTalent登录邮件验证", "", userName, emailBody);
RedisHelper.SetRedis(RedisConstName.SendCheck + userName, DateTime.Now.Ticks.ToString(), 180);
ProviderGateway.BindBatchProvider.UpdateBatchId(tenantId, bindBatchId, emailBatch);
return(result);
}
