private void rptUnInstalled_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
var thirdLoginType = (EThirdLoginType)e.Item.DataItem;
foreach (var thirdLoginInfo in _thirdLoginInfoList)
{
if (thirdLoginInfo.ThirdLoginType == thirdLoginType)
{
e.Item.Visible = false;
return;
}
}
var ltlThirdLoginName = e.Item.FindControl("ltlThirdLoginName") as Literal;
var ltlDescription = e.Item.FindControl("ltlDescription") as Literal;
var ltlInstallUrl = e.Item.FindControl("ltlInstallUrl") as Literal;
if (ltlThirdLoginName != null)
{
ltlThirdLoginName.Text = EThirdLoginTypeUtils.GetText(thirdLoginType);
}
if (ltlDescription != null)
{
ltlDescription.Text = EThirdLoginTypeUtils.GetDescription(thirdLoginType);
}
var urlInstall = GetRedirectUrl() + $"?isInstall=True&thirdLoginType={EThirdLoginTypeUtils.GetValue(thirdLoginType)}";
if (ltlInstallUrl != null)
{
ltlInstallUrl.Text = $@"<a href=""{urlInstall}"">安装</a>";
}
}
}
public bool IsExists(EThirdLoginType thirdLoginType)
{
var exists = false;
var parms = new IDataParameter[]
{
GetParameter(ParmType, EDataType.VarChar, 50, EThirdLoginTypeUtils.GetValue(thirdLoginType))
};
using (var rdr = ExecuteReader(SqlSelectByType, parms))
{
if (rdr.Read())
{
exists = true;
}
rdr.Close();
}
return(exists);
}
public ThirdLoginInfo GetThirdLoginInfo(int thirdLoginId)
{
ThirdLoginInfo thirdLoginInfo = null;
var parms = new IDataParameter[]
{
GetParameter(ParmId, EDataType.Integer, thirdLoginId)
};
using (var rdr = ExecuteReader(SqlSelectThirdlogin, parms))
{
if (rdr.Read())
{
var i = 0;
thirdLoginInfo = new ThirdLoginInfo(GetInt(rdr, i++), EThirdLoginTypeUtils.GetEnumType(GetString(rdr, i++)), GetString(rdr, i++), GetBool(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i));
}
rdr.Close();
}
return(thirdLoginInfo);
}
public List <ThirdLoginInfo> GetThirdLoginInfoList()
{
var list = new List <ThirdLoginInfo>();
var parms = new IDataParameter[]
{
};
using (var rdr = ExecuteReader(SqlSelectAllThirdlogin, parms))
{
while (rdr.Read())
{
var i = 0;
var thirdLoginInfo = new ThirdLoginInfo(GetInt(rdr, i++), EThirdLoginTypeUtils.GetEnumType(GetString(rdr, i++)), GetString(rdr, i++), GetBool(rdr, i++), GetInt(rdr, i++), GetString(rdr, i++), GetString(rdr, i));
list.Add(thirdLoginInfo);
}
rdr.Close();
}
return(list);
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
_thirdLoginId = Body.GetQueryInt("thirdLoginID");
if (!IsPostBack)
{
BreadCrumbUser(AppManager.User.LeftMenu.UserConfiguration, "授权登录管理", AppManager.User.Permission.UserConfiguration);
//var publishmentSystemUrl = AssetsUtils.GetUrl(PageUtils.GetApiUrl(), "iframe/authLogin.html");
var publishmentSystemUrl = string.Empty;
ltlLoginAuthCallBackUrl.Text = "<span style='color:red;'>" + publishmentSystemUrl + "</span>";
tbLoginAuthCallBackUrl.Text = publishmentSystemUrl;
if (_thirdLoginId > 0)
{
var thirdLoginInfo = BaiRongDataProvider.ThirdLoginDao.GetThirdLoginInfo(_thirdLoginId);
if (thirdLoginInfo != null)
{
tbThirdLoginName.Text = thirdLoginInfo.ThirdLoginName;
ltlThirdLoginType.Text = EThirdLoginTypeUtils.GetText(thirdLoginInfo.ThirdLoginType);
var authInfo = new ThirdLoginAuthInfo(thirdLoginInfo.SettingsXml);
phLoginAuth.Visible = true;
tbLoginAuthAppKey.Text = authInfo.AppKey;
tbLoginAuthAppSercet.Text = authInfo.AppSercet;
tbLoginAuthCallBackUrl.Text = authInfo.CallBackUrl;
breDescription.Text = thirdLoginInfo.Description;
}
}
}
}
public void Page_Load(object sender, EventArgs e)
{
if (IsForbidden)
{
return;
}
if (Body.IsQueryExists("isInstall") && Body.IsQueryExists("thirdLoginType"))
{
var thirdLoginType = EThirdLoginTypeUtils.GetEnumType(Body.GetQueryString("thirdLoginType"));
if (!BaiRongDataProvider.ThirdLoginDao.IsExists(thirdLoginType))
{
//安装之后，默认不可用
var thirdLoginInfo = new ThirdLoginInfo(0, thirdLoginType, EThirdLoginTypeUtils.GetText(thirdLoginType), false, 0, EThirdLoginTypeUtils.GetDescription(thirdLoginType), string.Empty);
BaiRongDataProvider.ThirdLoginDao.Insert(thirdLoginInfo);
//安装之后，直接跳转到设置页面
Response.Redirect(PageThirdLoginConfiguration.GetRedirectUrl((int)thirdLoginType));
//base.SuccessMessage("登录方式安装成功");
}
}
else if (Body.IsQueryExists("isDelete") && Body.IsQueryExists("thirdLoginID"))
{
var thirdLoginId = Body.GetQueryInt("thirdLoginID");
if (thirdLoginId > 0)
{
BaiRongDataProvider.ThirdLoginDao.Delete(thirdLoginId);
SuccessMessage("登录方式删除成功");
}
}
else if (Body.IsQueryExists("isEnable") && Body.IsQueryExists("thirdLoginID"))
{
var thirdLoginId = Body.GetQueryInt("thirdLoginID");
if (thirdLoginId > 0)
{
var thirdLoginInfo = BaiRongDataProvider.ThirdLoginDao.GetThirdLoginInfo(thirdLoginId);
if (thirdLoginInfo != null)
{
var authInfo = new ThirdLoginAuthInfo(thirdLoginInfo.SettingsXml);
if (string.IsNullOrEmpty(authInfo.AppKey) || string.IsNullOrEmpty(authInfo.AppSercet) || string.IsNullOrEmpty(authInfo.CallBackUrl))
{
FailMessage("请先对第三方登录方式进行设置，设置之后才能启用！");
}
else
{
var action = thirdLoginInfo.IsEnabled ? "禁用" : "启用";
thirdLoginInfo.IsEnabled = !thirdLoginInfo.IsEnabled;
BaiRongDataProvider.ThirdLoginDao.Update(thirdLoginInfo);
SuccessMessage($"成功{action}登录方式");
}
}
}
}
else if (Body.IsQueryExists("setTaxis"))
{
var thirdLoginId = Body.GetQueryInt("thirdLoginID");
var direction = Body.GetQueryString("direction");
if (thirdLoginId > 0)
{
switch (direction.ToUpper())
{
case "UP":
BaiRongDataProvider.ThirdLoginDao.UpdateTaxisToUp(thirdLoginId);
break;
case "DOWN":
BaiRongDataProvider.ThirdLoginDao.UpdateTaxisToDown(thirdLoginId);
break;
}
SuccessMessage("排序成功！");
AddWaitAndRedirectScript(GetRedirectUrl());
}
}
if (!IsPostBack)
{
BreadCrumbUser(AppManager.User.LeftMenu.UserConfiguration, "授权登录管理", AppManager.User.Permission.UserConfiguration);
_thirdLoginInfoList = BaiRongDataProvider.ThirdLoginDao.GetThirdLoginInfoList();
rptInstalled.DataSource = _thirdLoginInfoList;
rptInstalled.ItemDataBound += rptInstalled_ItemDataBound;
rptInstalled.DataBind();
rptUnInstalled.DataSource = EThirdLoginTypeUtils.GetEThirdLoginTypeList();
rptUnInstalled.ItemDataBound += rptUnInstalled_ItemDataBound;
rptUnInstalled.DataBind();
}
}
public void SetDefaultThirdLogin()
{
ExecuteNonQuery("DELETE FROM bairong_ThirdLogin;");
var sbSql = new StringBuilder();
sbSql.AppendFormat("INSERT INTO bairong_ThirdLogin (ThirdLoginType, ThirdLoginName, IsEnabled, Taxis, Description, SettingsXML) VALUES ( '{0}', '{1}', 'False', 1, '{2}', '');", EThirdLoginTypeUtils.GetValue(EThirdLoginType.QQ), EThirdLoginTypeUtils.GetText(EThirdLoginType.QQ), EThirdLoginTypeUtils.GetDescription(EThirdLoginType.QQ));
sbSql.AppendFormat("INSERT INTO bairong_ThirdLogin (ThirdLoginType, ThirdLoginName, IsEnabled, Taxis, Description, SettingsXML) VALUES ( '{0}', '{1}', 'False', 2, '{2}', '');", EThirdLoginTypeUtils.GetValue(EThirdLoginType.Weibo), EThirdLoginTypeUtils.GetText(EThirdLoginType.Weibo), EThirdLoginTypeUtils.GetDescription(EThirdLoginType.Weibo));
sbSql.AppendFormat("INSERT INTO bairong_ThirdLogin (ThirdLoginType, ThirdLoginName, IsEnabled, Taxis, Description, SettingsXML) VALUES ( '{0}', '{1}', 'False', 3, '{2}', '');", EThirdLoginTypeUtils.GetValue(EThirdLoginType.WeixinPC), EThirdLoginTypeUtils.GetText(EThirdLoginType.WeixinPC), EThirdLoginTypeUtils.GetDescription(EThirdLoginType.WeixinPC));
ExecuteNonQuery(sbSql.ToString());
}
public int Insert(ThirdLoginInfo thirdLoginInfo)
{
int thirdLoginId;
var sqlString = "INSERT INTO bairong_ThirdLogin (ThirdLoginType, ThirdLoginName, IsEnabled, Taxis, Description, SettingsXML) VALUES ( @ThirdLoginType, @ThirdLoginName, @IsEnabled,@Taxis, @Description, @SettingsXML)";
var taxis = GetMaxTaxis() + 1;
IDataParameter[] parms =
{
GetParameter(ParmType, EDataType.VarChar, 50, EThirdLoginTypeUtils.GetValue(thirdLoginInfo.ThirdLoginType)),
GetParameter(ParmName, EDataType.NVarChar, 50, thirdLoginInfo.ThirdLoginName),
GetParameter(ParmIsEnabled, EDataType.VarChar, 18, thirdLoginInfo.IsEnabled.ToString()),
GetParameter(ParmTaxis, EDataType.Integer, taxis),
GetParameter(ParmDescription, EDataType.NText, thirdLoginInfo.Description),
GetParameter(ParmSettingsXml, EDataType.NText, thirdLoginInfo.SettingsXml)
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
thirdLoginId = ExecuteNonQueryAndReturnId(trans, sqlString, parms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(thirdLoginId);
}
