step_end.aspx.cs

最好用的站点内容管理系统 全部源代码都有

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.IO;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text.RegularExpressions;
using System.Net;

namespace NetCMS.Web.Install
{
    public partial class step_End : NetCMS.Web.UI.BasePage
    {
        public string s_initialcatalog = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            Response.CacheControl = "no-cache";
            s_initialcatalog = Request.QueryString["Dbname"];
            if (s_initialcatalog == null || s_initialcatalog == "")
                PageError("参数传递错误!", "step4.aspx", true);
            else
                s_initialcatalog = NetCMS.Common.Input.URLDecode(s_initialcatalog);
            string GError = Request.QueryString["error"];
            if (GError != "false")
            {
                PageError("请安装管理员，再进行此操作！", "step4.aspx", true);
            }

            string gset = Request.QueryString["start"];
            if (gset != string.Empty && gset != null)
            {
                Response.Write(InsertValue(Request.QueryString["set"]));
                Response.End();
            }
            //deleteInstallFile();
        }

        protected string InsertValue(string par)
        {
            string sitedir = Server.MapPath("~").TrimEnd('\\');
            string ResultStr = string.Empty;
            string s_dbsqlpath1 = string.Empty;
            string RollBar = "0/8";
            try
            {
                switch (par)
                {
                    case "site_param":
                        s_dbsqlpath1 = sitedir + "\\Install\\SQL\\Value\\site_param.sql";
                        RollBar = "1/9，参数设置导入成功。";
                        break;
                    case "group":
                        s_dbsqlpath1 = sitedir + "\\Install\\SQL\\Value\\group.sql";
                        RollBar = "2/9，会员组，管理员组设置导入成功。";
                        break;
                    case "label":
                        s_dbsqlpath1 = sitedir + "\\Install\\SQL\\Value\\label.sql";
                        RollBar = "3/9，内置标签导入成功。";
                        break;
                    case "menu":
                        s_dbsqlpath1 = sitedir + "\\Install\\SQL\\Value\\menu.sql";
                        RollBar = "4/9，功能菜单导入成功。";
                        break;
                    case "navi":
                        s_dbsqlpath1 = sitedir + "\\Install\\SQL\\Value\\navi.sql";
                        RollBar = "5/9，默认快捷方式导入成功。";
                        break;
                    case "stat":
                        s_dbsqlpath1 = sitedir + "\\Install\\SQL\\Value\\stat.sql";
                        RollBar = "6/9，统计参数导入成功。";
                        break;
                    case "friend":
                        s_dbsqlpath1 = sitedir + "\\Install\\SQL\\Value\\friend.sql";
                        RollBar = "7/9，友情连接参数导入成功。";
                        break;
                    case "collect":
                        s_dbsqlpath1 = sitedir + "\\Install\\SQL\\Value\\collect.sql";
                        RollBar = "8/9，采集参数导入成功。";
                        break;
                    case "help":
                        s_dbsqlpath1 = sitedir + "\\Install\\SQL\\Value\\help.sql";
                        RollBar = "9/9，帮助导入成功。";
                        break;
                }
                if (s_dbsqlpath1 == string.Empty)
                {
                    ResultStr = "发生错误！参数传递错误。";
                }
                else
                {
                    StreamReader sr = File.OpenText(s_dbsqlpath1);
                    string s_sqldefault = sr.ReadToEnd();
                    string s_result = Regex.Replace(s_sqldefault, @"\[[Nn][Tt]_", "[" + NetCMS.Config.UIConfig.dataRe, RegexOptions.Compiled);
                    sr.Close();
                    NetCMS.Install.Comm.ExecuteSql(NetCMS.Config.DBConfig.CmsConString, s_initialcatalog, s_result);
                    if (par == "site_param")
                    {
                        NetCMS.Install.Comm.ExecuteSql(NetCMS.Config.DBConfig.CmsConString, s_initialcatalog, "insert into [" + NetCMS.Config.UIConfig.dataRe + "sys_newsIndex] ([TableName],[CreatTime]) values ('" + NetCMS.Config.UIConfig.dataRe + "News','" + DateTime.Now + "');");
                    }
                    ResultStr = RollBar;
                }
            }
            catch (Exception e)
            {
                ResultStr = "发生错误." + e.Message + "";
            }
            return ResultStr;
        }

        /// <summary>
        /// 删除安装文件
        /// </summary>
        protected void deleteInstallFile()
        {
            string[] arr_file ={ "Index.aspx", "step1.aspx", "step2.aspx", "step3.aspx" };
            for (int i = 0; i < arr_file.Length; i++)
            {
                string sitedir = Server.MapPath("~").TrimEnd('\\');
                string s_filepath = sitedir + "\\Install\\" + arr_file[i].ToString();
                if (File.Exists(s_filepath))
                    File.Delete(s_filepath);
            }
        }
    }
}