upgrade.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

                    fieldListByModelId.Add(item);
                }
                string fieldList = new Serialize<FieldInfo>().SerializeFieldList(fieldListByModelId);
                ModelManager.UpdateField(info.ModelId, fieldList);
            }
            using (SqlConnection connection5 = new SqlConnection(connectionString))
            {
                SqlCommand command5 = new SqlCommand();
                connection5.Open();
                command5.Connection = connection5;
                command5.CommandText = "SELECT * FROM PE_CollectionFieldRules WHERE FieldType='ContentType'";
                command5.CommandType = CommandType.Text;
                using (SqlDataReader reader2 = command5.ExecuteReader())
                {
                    while (reader2.Read())
                    {
                        string str7 = reader2["FieldName"].ToString();
                        if (str7.IndexOf("$$$") > 0)
                        {
                            str7 = str7.Substring(0, str7.IndexOf("$$$"));
                            using (SqlConnection connection6 = new SqlConnection(connectionString))
                            {
                                connection6.Open();
                                SqlCommand command6 = connection6.CreateCommand();
                                command6.CommandType = CommandType.Text;
                                command6.CommandText = "UPDATE PE_CollectionFieldRules SET FieldName='" + str7 + "' WHERE FieldRuleID=" + reader2["FieldRuleID"].ToString();
                                command6.ExecuteNonQuery();
                                connection6.Close();
                                continue;
                            }
                        }
                    }
                }
                connection5.Close();
            }
            using (SqlConnection connection7 = new SqlConnection(connectionString))
            {
                SqlCommand command7 = new SqlCommand();
                connection7.Open();
                command7.Connection = connection7;
                command7.CommandText = "SELECT * FROM PE_CommonProduct";
                command7.CommandType = CommandType.Text;
                using (SqlDataReader reader3 = command7.ExecuteReader())
                {
                    while (reader3.Read())
                    {
                        using (SqlConnection connection8 = new SqlConnection(connectionString))
                        {
                            connection8.Open();
                            SqlCommand command8 = connection8.CreateCommand();
                            command8.CommandText = "UPDATE [PE_CommonProduct] SET [ProductExplain] = @Value WHERE ProductID=" + reader3["ProductID"].ToString();
                            command8.Parameters.Add(new SqlParameter("@Value", DataSecurity.HtmlDecode(reader3["ProductExplain"].ToString())));
                            command8.ExecuteNonQuery();
                            connection8.Close();
                            continue;
                        }
                    }
                }
                connection7.Close();
            }
            SiteConfigInfo info4 = SiteConfig.ConfigInfo();
            info4.SiteInfo.EshopWebPartSetting = "/wEUKwA9AgICBwUXd3A2MDk3MTY5MzQkd3AxNTc4MDgyODcCAx4FVGl0bGUFEuacquehruiupOeahOiuouWNlR4LT3BlcmF0ZUNvZGULKX1Qb3dlckVhc3kuRW51bWVyYXRpb25zLk9wZXJhdGVDb2RlLCBQb3dlckVhc3kuRW51bWVyYXRpb25zLCBWZXJzaW9uPTEuMC4wLjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49NjMxNDY4YmNlNDk0NThmMZ3j0TAeClNlYXJjaFR5cGUFATRmGSmHAVBvd2VyRWFzeS5Nb2RlbENvbnRyb2xzLkFkbWluV2ViUGFydE1hbmFnZXIsIFBvd2VyRWFzeS5Nb2RlbENvbnRyb2xzLCBWZXJzaW9uPTEuMC4wLjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49NjMxNDY4YmNlNDk0NThmMQUFX193cG1mAgIeEFdlYlBhcnRTdGF0ZVVzZXIUKwAgBRVnd3BTeXN0ZW1EaWFnbm9zdGljczEFB1dwekxlZnRmaAUKZ3dwQ29udGVudAUHV3B6TGVmdAIBZwURZ3dwU2lnbmluQ29udGVudDEFB1dwekxlZnQCA2cFC2d3cEFqYXhDYWwxBQhXcHpSaWdodGZoBQxnd3BBamF4Tm90ZTEFCFdwelJpZ2h0AgFoBQxnd3BNeU1lc3NhZ2UFCFdwelJpZ2h0AgJoBQx3cDIxMDE3NDUxMDkFB1dwekxlZnQCAWgFC3dwMTU3ODA4Mjg3BQdXcHpMZWZ0AgJoaGgeE0R5bmFtaWNXZWJQYXJ0c1VzZXIUKwAIBQt3cDIwMDU2OTU2MgVoU3lzdGVtLldlYi5VSS5Vc2VyQ29udHJvbCwgU3lzdGVtLldlYiwgVmVyc2lvbj0yLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWIwM2Y1ZjdmMTFkNTBhM2EFHn4vQ29udHJvbHMvV2ViUGFydC9PcmRlcnMuYXNjeAUMd3AyMTAxNzQ1MTA5BQt3cDYwOTcxNjkzNAVoU3lzdGVtLldlYi5VSS5Vc2VyQ29udHJvbCwgU3lzdGVtLldlYiwgVmVyc2lvbj0yLjAuMC4wLCBDdWx0dXJlPW5ldXRyYWwsIFB1YmxpY0tleVRva2VuPWIwM2Y1ZjdmMTFkNTBhM2EFHn4vQ29udHJvbHMvV2ViUGFydC9PcmRlcnMuYXNjeAULd3AxNTc4MDgyODdoaAULd3AxNTc4MDgyODcCAx4TQXV0aG9yaXphdGlvbkZpbHRlcgUJT3JkZXJWaWV3HwAFEuacquehruiupOeahOiuouWNlR4IVGl0bGVVcmwFLC8yMDA3L0FkbWluL1Nob3AvT3JkZXJMaXN0LmFzcHg/U2VhcmNoVHlwZT00ZgUYd3AyMDA1Njk1NjIkd3AyMTAxNzQ1MTA5AgIfAAUY5oiR6LSf6LSj6Lef6Liq55qE6K6i5Y2VHwELKwSd49EwZhkqGVN5c3RlbS5XZWIuVUkuVXNlckNvbnRyb2wFH34vQ29udHJvbHMvV2ViUGFydC9Db250ZW50LmFzY3gFEkNvbnRlbnQkZ3dwQ29udGVudAIBHwAFD+W+heWuoeaguOWGheWuuWYFDHdwMjEwMTc0NTEwOQIDHwUFCU9yZGVyVmlldx8ABRjmiJHotJ/otKPot5/ouKrnmoTorqLljZUfBgUtLzIwMDcvQWRtaW4vU2hvcC9PcmRlckxpc3QuYXNweD9TZWFyY2hUeXBlPTE4ZhkqMVN5c3RlbS5XZWIuVUkuV2ViQ29udHJvbHMuV2ViUGFydHMuR2VuZXJpY1dlYlBhcnQFCmd3cENvbnRlbnQCAR8ABQ/lvoXlrqHmoLjlhoXlrrlm";
            info4.UserConfig.UserGetPasswordType = 1;
            info4.UserConfig.MoneyExchangePointByMoney = 1.0;
            info4.UserConfig.MoneyExchangeValidDayByMoney = 1.0;
            info4.UserConfig.UserExpExchangePointByExp = 1.0;
            info4.UserConfig.UserExpExchangeValidDayByExp = 1.0;
            info4.UserConfig.MoneyExchangePointByPoint = 1.0;
            info4.UserConfig.MoneyExchangeValidDayByValidDay = 1.0;
            info4.UserConfig.UserExpExchangePointByPoint = 1.0;
            info4.UserConfig.UserExpExchangeValidDayByValidDay = 1.0;
            info4.ShopConfig.EnablePartPay = true;
            info4.ShopConfig.OrderProductNumber = 0;
            NameValueCollection values = new NameValueCollection();
            values.Add("DynamicPageDefault", "/其他模板/默认动态页模板.html");
            values.Add("ShowAuthorList", "/其他模板/作者列表页模板.html");
            values.Add("ShowAuthor", "/其他模板/显示作者详细信息页模板.html");
            values.Add("ShowCopyFromList", "/其他模板/来源列表页模板.html");
            values.Add("ShowCopyFrom", "/其他模板/显示来源详细信息页模板.html");
            values.Add("GuestWrite", "/其他模板/签写留言页模板.html");
            values.Add("ShowDownload", "/用户中心模板/默认会员中心通用模板.html");
            values.Add("ConfirmRemittance", "/用户中心模板/默认会员中心通用模板.html");
            values.Add("NavContent", "/用户中心模板/默认会员中心信息管理通用模板.html");
            values.Add("AnonymousContent", "/用户中心模板/匿名投稿页模板.html");
            values.Add("AnonymousContent2", "/用户中心模板/匿名投稿页模板.html");
            values.Add("ShowProducer", "/其他模板/显示厂商详细信息页模板.html");
            values.Add("ShowProducerList", "/其他模板/显示厂商列表页模板.html");
            values.Add("ShowTrademark", "/其他模板/显示品牌详细信息页模板.html");
            values.Add("ShowTrademarkList", "/其他模板/显示品牌列表页模板.html");
            foreach (string str8 in values.AllKeys)
            {
                FrontTemplate template = new FrontTemplate();
                template.Key = str8;
                template.Value = values[str8];
                info4.FrontTemplateList.Add(template);
            }
            SiteConfig config = new SiteConfig();
            try
            {
                config.Update(info4);
            }
            catch (FileNotFoundException)
            {
            }
            catch (UnauthorizedAccessException)
            {
            }
            catch (ConfigurationErrorsException)
            {
            }
            try
            {
                System.Configuration.Configuration configuration = WebConfigurationManager.OpenWebConfiguration("~");
                AppSettingsSection section = (AppSettingsSection) configuration.GetSection("appSettings");
                section.Settings.Add("PowerEasy:DefaultUploadSuffix", ".jpg.gif.jpeg.png.bmp.swf.fla.rm.rmvb.mp3.mpeg.avi.mpeg2.wmv.midi");
                configuration.Save();
            }
            catch (FileNotFoundException)
            {
            }
            catch (UnauthorizedAccessException)
            {
            }
            catch (ConfigurationErrorsException)
            {
            }
        }

        public static string ReadSiteConfigElement(string fileName, string element)
        {
            XmlTextReader reader = new XmlTextReader(fileName);
            string str = string.Empty;
            while (reader.Read())
            {
                if (string.Compare(reader.Name, element, true) == 0)
                {
                    str = reader.ReadString();
                    break;
                }
            }
            reader.Close();
            return str;
        }

        private static bool UpgradeDataBase(string fileName, string connectString)
        {
            SqlConnection connection = new SqlConnection(connectString);
            SqlCommand command = new SqlCommand();
            connection.Open();
            command.Connection = connection;
            using (StreamReader reader = new StreamReader(fileName, Encoding.UTF8))
            {
                try
                {
                    while (!reader.EndOfStream)
                    {
                        StringBuilder builder = new StringBuilder();
                        while (!reader.EndOfStream)
                        {
                            string str = reader.ReadLine();
                            if (!string.IsNullOrEmpty(str) && str.ToUpper().Trim().Equals("GO"))
                            {
                                break;
                            }
                            builder.AppendLine(str);
                        }
                        command.CommandType = CommandType.Text;
                        command.CommandText = builder.ToString();
                        command.CommandTimeout = 300;
                        command.ExecuteNonQuery();
                    }
                }
                catch (SqlException)
                {
                    return false;
                }
                finally
                {
                    command.Dispose();
                    connection.Close();
                    connection.Dispose();
                }
            }
            return true;
        }
    }
}