public void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
if (SystemManager.IsInstalled)
{
Page.Response.Write("系统已安装成功，向导被禁用。<a href=\"" + PageUtils.GetAdminUrl("/") + "\">返回后台管理首页</a>");
Page.Response.End();
return;
}
LtlVersionInfo.Text = SystemManager.ProductVersion;
SetSetp(1);
DatabaseTypeUtils.AddListItems(DdlSqlDatabaseType);
EBooleanUtils.AddListItems(DdlIsDefaultPort, "默认数据库端口", "自定义数据库端口");
ControlUtils.SelectSingleItemIgnoreCase(DdlIsDefaultPort, true.ToString());
PhSqlPort.Visible = false;
EBooleanUtils.AddListItems(DdlIsProtectData, "加密", "不加密");
ControlUtils.SelectSingleItemIgnoreCase(DdlIsProtectData, false.ToString());
LtlGo.Text = $@"<a class=""btn btn-success m-l-5"" href=""{PageUtils.GetAdminUrl(string.Empty)}"">进入后台</a>";
}
private bool UpdateWebConfig(out string errorMessage)
{
errorMessage = string.Empty;
var returnValue = false;
try
{
var isProtectData = TranslateUtils.ToBool(DdlIsProtectData.SelectedValue);
var databaseType = DatabaseTypeUtils.GetEnumType(DdlSqlDatabaseType.SelectedValue);
var connectionString = GetConnectionString(true);
WebConfigUtils.UpdateWebConfig(isProtectData, databaseType, connectionString, "api", "SiteServer", "Home", StringUtils.GetShortGuid(), false);
DataProvider.Reset();
returnValue = true;
}
catch (Exception e)
{
errorMessage = e.Message;
}
return(returnValue);
}
public void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
if (!SystemManager.IsNeedInstall())
{
Page.Response.Write("系统已安装成功，向导被禁用");
Page.Response.End();
return;
}
LtlVersionInfo.Text = SystemManager.ProductVersion;
SetSetp(1);
DatabaseTypeUtils.AddListItems(DdlSqlDatabaseType);
DdlOraclePrivilege.Items.Add(new ListItem(EOraclePrivilegeUtils.GetValue(EOraclePrivilege.Normal), EOraclePrivilegeUtils.GetValue(EOraclePrivilege.Normal)));
DdlOraclePrivilege.Items.Add(new ListItem(EOraclePrivilegeUtils.GetValue(EOraclePrivilege.SYSDBA), EOraclePrivilegeUtils.GetValue(EOraclePrivilege.SYSDBA)));
DdlOraclePrivilege.Items.Add(new ListItem(EOraclePrivilegeUtils.GetValue(EOraclePrivilege.SYSOPER), EOraclePrivilegeUtils.GetValue(EOraclePrivilege.SYSOPER)));
EBooleanUtils.AddListItems(DdlIsOracleSid, "SID", "Service name");
ControlUtils.SelectSingleItemIgnoreCase(DdlIsOracleSid, true.ToString());
EBooleanUtils.AddListItems(DdlIsDefaultPort, "默认数据库端口", "自定义数据库端口");
ControlUtils.SelectSingleItemIgnoreCase(DdlIsDefaultPort, true.ToString());
PhSqlPort.Visible = false;
EBooleanUtils.AddListItems(DdlIsProtectData, "加密", "不加密");
ControlUtils.SelectSingleItemIgnoreCase(DdlIsProtectData, false.ToString());
LtlGo.Text = $@"<a class=""btn btn-success m-l-5"" href=""{PageUtils.GetAdminUrl(string.Empty)}"">进入后台</a>";
}
private string GetConnectionString(bool isDatabaseName)
{
var databaseType = DatabaseTypeUtils.GetEnumType(DdlSqlDatabaseType.SelectedValue);
var databaseName = string.Empty;
if (isDatabaseName)
{
databaseName = databaseType == DatabaseType.Oracle ? TbSqlOracleDatabase.Text : DdlSqlDatabaseName.SelectedValue;
}
return(WebConfigUtils.GetConnectionString(databaseType, TbSqlServer.Text, TranslateUtils.ToBool(DdlIsDefaultPort.SelectedValue), TranslateUtils.ToInt(TbSqlPort.Text), TbSqlUserName.Text, HihSqlHiddenPassword.Value, databaseName));
}
private bool UpdateWebConfig(out string errorMessage)
{
errorMessage = string.Empty;
var returnValue = false;
try
{
var isProtectData = TranslateUtils.ToBool(DdlIsProtectData.SelectedValue);
var databaseType = DatabaseTypeUtils.GetEnumType(DdlSqlDatabaseType.SelectedValue);
var connectionString = GetConnectionString(true);
WebConfigUtils.UpdateWebConfig(isProtectData, databaseType, connectionString, "siteserver", "vEnfkn16t8aeaZKG3a4Gl9UUlzf4vgqU9xwh8ZV5", false);
returnValue = true;
}
catch (Exception e)
{
errorMessage = e.Message;
}
return(returnValue);
}
public void DdlSqlDatabaseType_SelectedIndexChanged(object sender, EventArgs e)
{
var databaseType = DatabaseTypeUtils.GetEnumType(DdlSqlDatabaseType.SelectedValue);
PhSqlOracleDatabase.Visible = databaseType == DatabaseType.Oracle;
}
public void BtnStep3_Click(object sender, EventArgs e)
{
if (PhSql1.Visible)
{
HihSqlHiddenPassword.Value = TbSqlPassword.Text;
bool isConnectValid;
string errorMessage;
var databaseNameList = new List <string>();
var databaseType = DatabaseTypeUtils.GetEnumType(DdlSqlDatabaseType.SelectedValue);
if (string.IsNullOrEmpty(TbSqlServer.Text))
{
isConnectValid = false;
errorMessage = "数据库主机必须填写。";
}
else if (PhSqlPort.Visible && string.IsNullOrEmpty(TbSqlPort.Text))
{
isConnectValid = false;
errorMessage = "数据库端口必须填写。";
}
else if (string.IsNullOrEmpty(TbSqlUserName.Text))
{
isConnectValid = false;
errorMessage = "数据库用户必须填写。";
}
else if (databaseType == DatabaseType.Oracle && string.IsNullOrEmpty(TbSqlOracleDatabase.Text))
{
isConnectValid = false;
errorMessage = "数据库名称必须填写。";
}
else
{
var connectionStringWithoutDatabaseName = GetConnectionString(databaseType == DatabaseType.Oracle);
isConnectValid = DataProvider.DatabaseDao.ConnectToServer(databaseType, connectionStringWithoutDatabaseName, out databaseNameList, out errorMessage);
}
if (isConnectValid)
{
if (databaseType != DatabaseType.Oracle)
{
DdlSqlDatabaseName.Items.Clear();
foreach (var databaseName in databaseNameList)
{
DdlSqlDatabaseName.Items.Add(databaseName);
}
DdlSqlDatabaseType.Enabled = false;
PhSql1.Visible = false;
PhSql2.Visible = true;
}
else
{
SetSetp(4);
}
}
else
{
FailMessage(errorMessage);
}
}
else
{
SetSetp(4);
}
}
