protected void Page_Load(object sender, EventArgs e)
{
gnStep = 0;
#region [=====读取数据库连接，如无法连接，则进入第一步=====]
string szFileConnection = Server.MapPath(WebConfig.SZ_FILE_CONNECTION);
string szConnJson = dyk.IO.File.DisplacementUTF8.ReadAllText(szFileConnection, true);
//Response.Write(szConnJson);
string szHost = "";
string szName = "";
string szPwd = "";
using (dyk.Format.XML json = new dyk.Format.XML(szConnJson)) {
szHost = json["sqlserver.source"].InnerText;
szName = json["sqlserver.user"].InnerText;
szPwd = json["sqlserver.password"].InnerText;
}
gstrConnString = "data source=" + szHost + ";user id=" + szName + ";Password="******";Initial Catalog=master";
if (szHost == "")
{
gnStep = 1;
return;
}
try {
using (dyk.Database.SQLClient Conn = new dyk.Database.SQLClient(gstrConnString)) {
Conn.ExecuteReader("select 1");
}
} catch {
gnStep = 1;
return;
}
#endregion
#region [=====读取Aos数据库设置，如无则进入第二步=====]
using (dyk.Database.SQLClient Conn = new dyk.Database.SQLClient(gstrConnString)) {
Conn.ExecuteReader("select * from sysdatabases where name='Aos'");
if (!Conn.DataReader.Read())
{
gnStep = 2;
return;
}
}
#endregion
#region [=====读取Aos_Manage数据库设置，如无则进入第二步=====]
using (dyk.Database.SQLClient Conn = new dyk.Database.SQLClient(gstrConnString)) {
Conn.ExecuteReader("select * from sysdatabases where name='Aos_Manage'");
if (!Conn.DataReader.Read())
{
gnStep = 3;
return;
}
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
this.Title = ClsSite.AppName;
gstrPath = "";
if (Request.Cookies["UserName"] != null)
{
gszCookieName = Request.Cookies["UserName"].Value;
}
//if (gszCookieName == "") gszCookieName = "在此输入账号";
gUserAgent = new Ly.Web.HttpUserAgent(HttpContext.Current.Request.UserAgent);
//Session["Manager"] = "Admin";
if (Request["Path"] != null)
{
gstrPath = Request["Path"].ToString().Trim().Replace("\\", "/");
}
if (gstrPath.StartsWith("/") || gstrPath.IndexOf("..") >= 0)
{
gstrPath = "";
}
if (gstrPath != "" && !gstrPath.EndsWith("/"))
{
gstrPath += "/";
}
gstrFullPath = "/" + gstrPath;
gJson = new Ly.IO.JsonFile(Server.MapPath("/Files/System/Apps.txt"), System.Text.Encoding.UTF8);
//String Connstr = Pub.IO.ReadAllText(Server.MapPath("/Files/System/Conn.txt"));
//检测是否安装了数据
string szConnJson = dyk.IO.File.DisplacementUTF8.ReadAllText(Server.MapPath(WebConfig.SZ_FILE_CONNECTION), true);
string szHost = "";
string szName = "";
string szPwd = "";
using (dyk.Format.XML json = new dyk.Format.XML(szConnJson)) {
szHost = json["sqlserver.source"].InnerText;
szName = json["sqlserver.user"].InnerText;
szPwd = json["sqlserver.password"].InnerText;
}
//gszConnectString = Pub.IO.ReadAllText(base.Server.MapPath(WebConfig.SZ_PATH_CONNECTSTRING));
gszConnectString = "data source=" + szHost + ";user id=" + szName + ";Password="******";Initial Catalog=Aos";
//if (!Pub.CheckInstall(gszConnectString)) Response.Redirect("/Files/Page/Install/Install.aspx");
//数据库未安装，跳转到数据库安装页面
if (szHost == "")
{
Response.Redirect("/Files/Page/Install/Install.aspx");
}
//gstrApps = "{Array:[";
//for (int i = 0; i < gJson.Objects.Count; i++) {
// if (gJson.Objects[i].Name == "App") {
// if (gJson.Objects[i].Items["Name"].Value == "#(TableList)") {
// using (Ly.DB.Dream.Tables gTab = new Ly.DB.Dream.Tables(gszConnectString)) {
// gTab.SystemTables.GetDatasOrderByIndex();
// for (int j = 0; j < gTab.SystemTables.StructureCollection.Count; j++) {
// if (gstrApps != "") {
// gstrApps += ",";
// }
// using (Ly.IO.Json js = new Ly.IO.Json()) {
// js.Items["text"].Value = gTab.SystemTables.StructureCollection[j].Text;
// js.Items["name"].Value = "System/Table";
// js.Items["logo"].Value = "/Files/App/System/Manager/Logo.png";
// js.Items["url"].Value = "/Files/App/System/Table/Default.aspx?Table=" + gTab.SystemTables.StructureCollection[j].ID;
// gstrApps += js.Object.ToString().Replace("\"", "\\\"");
// }
// }
// }
// } else {
// if (gstrApps != "") {
// gstrApps += ",";
// }
// using (Ly.IO.Json js = new Ly.IO.Json()) {
// js.Items["text"].Value = gJson.Objects[i].Items["Name"].Value;
// js.Items["name"].Value = gJson.Objects[i].Items["Dir"].Value;
// js.Items["logo"].Value = gJson.Objects[i].Items["Icon"].Value;
// js.Items["url"].Value = gJson.Objects[i].Items["App"].Value;
// gstrApps += js.Object.ToString().Replace("\"", "\\\"");
// }
// }
// }
//}
gstrApps = "{Array:[" + gstrApps + "]}";
}
protected override void OnInit(EventArgs e)
{
base.OnInit(e);
gstrSessionID = "";
//if (base.Request.Cookies["ASP.NET_SessionId"] != null) gstrSessionID = base.Request.Cookies["ASP.NET_SessionId"].Value;
//base.Response.AddHeader("<Debug>Cookie_Old", SessionID);
////base.Response.Cookies["ASP.NET_SessionId_Request"].Value = base.Request.Headers.Count.ToString();
//for (int i = 0; i < base.Request.Headers.Count; i++) {
// string szName = base.Request.Headers.GetKey(i);
// string szDebug = "<Debug>" + base.Request.Headers.GetKey(i);
// string szValue = "";
// if (szName == "Azalea_SessionID") {
// for (int j = 0; j < base.Request.Headers.GetValues(i).Length; j++) {
// string sVal = base.Request.Headers.GetValues(i)[j];
// szValue += sVal;
// }
// gstrSessionID = szValue;
// }
// //base.Response.Write(base.Request.Headers.GetKey(i) + ":");
// base.Response.AddHeader(szDebug, szValue);
//}
if (gstrSessionID == "")
{
gstrSessionID = Pub.Request(this, "Azalea_SessionID");
}
glngAuthorizeID = dyk.Type.String.New(Pub.Request(this, "Azalea_AuthID")).ToNumber;
// //base.Response.Write(base.Request.Headers.GetKey(i) + ":");
// for (int j = 0; j < base.Request.Headers.GetValues(i).Length; j++) {
// //base.Response.Write("[" + j + "]" + base.Request.Headers.GetValues(i)[j]);
// //base.Response.AddHeader("<Debug>Request_" + base.Request.Headers.GetKey(i) + "[" + j + "]", base.Request.Headers.GetValues(i)[j]);
// if (base.Request.Headers.GetKey(i).ToLower() == "cookie") {
// //base.Response.AddHeader("<Debug>Cookie", "Found");
// string sVal = base.Request.Headers.GetValues(i)[j];
// string[] sVals = sVal.Split(';');
// //base.Response.AddHeader("<Debug>Cookie", sVals.Length.ToString());
// for (int s = 0; s < sVals.Length; s++) {
// if (sVals[s].Trim() != "") {
// string[] sSubVals = sVals[s].Split('=');
// if (sSubVals.Length == 2) {
// string sName = sSubVals[0].Trim(',').Trim().ToLower();
// string sTemp = "";
// //base.Response.AddHeader("<Debug>Cookie", "Found\"=\"");
// for (int n = 0; n < sName.Length; n++) {
// sTemp += "[" + sName[n] + "," + (int)sName[n] + "]";
// }
// base.Response.AddHeader("<Debug>Cookie[" + s + "]", sTemp);
// if (sName == "asp.net_sessionid") {
// base.Response.AddHeader("<Debug>Cookie", sSubVals[1].Trim());
// gstrSessionID = sSubVals[1].Trim();
// }
// }
// }
// }
// }
// }
//base.Response.Write("\n");
//}
if (gstrSessionID == "")
{
gstrSessionID = Guid.NewGuid().ToString().Replace("-", "");
}
//base.Session.SessionID = SessionID;
//base.Response.Cookies["ASP.NET_SessionId"].Value = gstrSessionID;
//base.Response.AddHeader("<Debug>Cookie_New", gstrSessionID);
//gstrConnectString = Pub.IO.ReadAllText(base.Server.MapPath(WebConfig.SZ_PATH_CONNECTSTRING));
//读取数据库连接设定
string szConnJson = dyk.IO.File.DisplacementUTF8.ReadAllText(Server.MapPath(WebConfig.SZ_FILE_CONNECTION), true);
string szHost = "";
string szName = "";
string szPwd = "";
using (dyk.Format.XML json = new dyk.Format.XML(szConnJson)) {
szHost = json["sqlserver.source"].InnerText;
szName = json["sqlserver.user"].InnerText;
szPwd = json["sqlserver.password"].InnerText;
}
//gszConnectString = Pub.IO.ReadAllText(base.Server.MapPath(WebConfig.SZ_PATH_CONNECTSTRING));
gszAosConnectString = "data source=" + szHost + ";user id=" + szName + ";Password="******";Initial Catalog=Aos";
//生成数据表连接
using (dyk.DB.Aos.AosAuthorize.ExecutionExp aa = new dyk.DB.Aos.AosAuthorize.ExecutionExp(gszAosConnectString)) {
if (aa.GetDataByID(glngAuthorizeID))
{
if (aa.Structure.DBIP != "")
{
gszBaseConnectString = "data source=" + aa.Structure.DBIP + ";user id=" + aa.Structure.DBUser + ";Password="******";Initial Catalog=Aos_" + aa.Structure.DBSign;
gszDataConnectString = "data source=" + aa.Structure.DBIP + ";user id=" + aa.Structure.DBUser + ";Password="******";Initial Catalog=Aos_" + aa.Structure.DBSign + "_" + DateTime.Now.Year;
gszUpdateConnectString = "data source=" + aa.Structure.DBIP + ";user id=" + aa.Structure.DBUser + ";Password="******";Initial Catalog=master";
}
else
{
gszBaseConnectString = "data source=" + szHost + ";user id=" + szName + ";Password="******";Initial Catalog=Aos_" + aa.Structure.DBSign;
gszDataConnectString = "data source=" + szHost + ";user id=" + szName + ";Password="******";Initial Catalog=Aos_" + aa.Structure.DBSign + "_" + DateTime.Now.Year;
gszUpdateConnectString = "data source=" + szHost + ";user id=" + szName + ";Password="******";Initial Catalog=master";
}
}
}
//建立本年份的分支数据库
string dbPath = "";
//读取数据库保存地址
string szFileSetting = Server.MapPath(WebConfig.SZ_FILE_SETTING);
string szSetting = dyk.IO.File.UTF8.ReadAllText(szFileSetting, true);
using (dyk.Format.XML xml = new dyk.Format.XML(szSetting)) {
dbPath = xml["Database.SavePath"].InnerText;
}
//生成Aos库
using (dyk.Database.SQLClient Conn = new dyk.Database.SQLClient(gszUpdateConnectString)) {
string szSql = "if not exists(select * from sysdatabases where name='Aos_Manage_" + DateTime.Now.Year + "')";
szSql += "create database [Aos_Manage_" + DateTime.Now.Year + "]";
szSql += "on primary (";
szSql += "name='Aos_Manage_" + DateTime.Now.Year + "_data',";
szSql += "filename='" + dbPath + "\\Aos_Manage_" + DateTime.Now.Year + ".mdf',";
szSql += "size=5mb,";
szSql += "filegrowth=15%)";
szSql += "log on (";
szSql += "name='Aos_Manage_" + DateTime.Now.Year + "_log',";
szSql += "filename='" + dbPath + "\\Aos_Manage_" + DateTime.Now.Year + "_log.ldf',";
szSql += "size=2mb,";
szSql += "filegrowth=1mb)";
Conn.ExecuteNonQuery(szSql);
}
gszIP = System.Web.HttpContext.Current.Request.UserHostAddress;
gSession = new ClsSession(gszAosConnectString, gstrSessionID, glngAuthorizeID, gszIP);
//gUsers = new Ly.DB.Dream.SystemUsers.ExecutionExp(gstrConnectString);
gUser = new dyk.DB.Base.SystemUsers.ExecutionExp(gszBaseConnectString);
gUser.GetDataByName(gSession.Manager);
gConfig = new WebConfig(this);
}
