public void Update(ThirdLoginInfo thirdLoginInfo)
{
var parms = new IDataParameter[]
{
GetParameter(ParmName, EDataType.NVarChar, 50, thirdLoginInfo.ThirdLoginName),
GetParameter(ParmIsEnabled, EDataType.VarChar, 18, thirdLoginInfo.IsEnabled.ToString()),
GetParameter(ParmDescription, EDataType.NText, thirdLoginInfo.Description),
GetParameter(ParmSettingsXml, EDataType.NText, thirdLoginInfo.SettingsXml),
GetParameter(ParmId, EDataType.Integer, thirdLoginInfo.Id)
};
ExecuteNonQuery(SqlUpdateThirdlogin, parms);
}
public override void Submit_OnClick(object sender, EventArgs e)
{
try
{
var thirdLoginInfo = new ThirdLoginInfo();
if (_thirdLoginId > 0)
{
thirdLoginInfo = BaiRongDataProvider.ThirdLoginDao.GetThirdLoginInfo(_thirdLoginId);
}
thirdLoginInfo.ThirdLoginName = tbThirdLoginName.Text;
var authInfo = new ThirdLoginAuthInfo(thirdLoginInfo.SettingsXml)
{
AppKey = tbLoginAuthAppKey.Text,
AppSercet = tbLoginAuthAppSercet.Text
};
;
authInfo.CallBackUrl = tbLoginAuthCallBackUrl.Text;;
thirdLoginInfo.SettingsXml = authInfo.ToString();
thirdLoginInfo.Description = breDescription.Text;
thirdLoginInfo.IsEnabled = true;//设置成功之后，启用
if (_thirdLoginId > 0)
{
BaiRongDataProvider.ThirdLoginDao.Update(thirdLoginInfo);
}
else
{
BaiRongDataProvider.ThirdLoginDao.Insert(thirdLoginInfo);
}
SuccessMessage("配置登录方式成功！");
AddWaitAndRedirectScript(PageThirdLogin.GetRedirectUrl());
}
catch (Exception ex)
{
FailMessage(ex, ex.Message);
}
}
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 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);
}
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();
}
}
