DotNetExample
diff --git a/‎source/BaiRong.Core/WebConfigUtils.cs‎
Lines changed: 41 additions & 2 deletions b/‎source/BaiRong.Core/WebConfigUtils.cs‎
Lines changed: 41 additions & 2 deletions
diff --git a/‎source/SiteServer.BackgroundPages/Cms/ModalInputContentTaxis.cs‎
Lines changed: 14 additions & 22 deletions b/‎source/SiteServer.BackgroundPages/Cms/ModalInputContentTaxis.cs‎
Lines changed: 14 additions & 22 deletions
@@ -1,5 +1,4 @@
 using System;
-using System.Reflection;
 using System.Web;
 using System.Xml;
 using BaiRong.Core.Data;
@@ -39,7 +38,7 @@ public static AdoHelper Helper
 
         static WebConfigUtils()
         {
-            var physicalApplicationPath = string.Empty;
+            string physicalApplicationPath;
             var applicationPath = string.Empty;
             if (HttpContext.Current != null)
             {
@@ -196,5 +195,45 @@ public static void UpdateWebConfig(bool isProtectData, bool isMySql, string conn
             ConnectionString = connectionString;
             _helper = null;
         }
+
+        public static string GetConnectionStringByName(string name)
+        {
+            var connectionString = string.Empty;
+            try
+            {
+                var doc = new XmlDocument();
+
+                var configFile = PathUtils.Combine(PhysicalApplicationPath, "web.config");
+
+                doc.Load(configFile);
+
+                var appSettings = doc.SelectSingleNode("configuration/appSettings");
+                if (appSettings != null)
+                {
+                    foreach (XmlNode setting in appSettings)
+                    {
+                        if (setting.Name != "add") continue;
+
+                        var attrKey = setting.Attributes?["key"];
+                        if (attrKey == null) continue;
+
+                        if (!StringUtils.EqualsIgnoreCase(attrKey.Value, name)) continue;
+
+                        var attrValue = setting.Attributes["value"];
+                        if (attrValue != null)
+                        {
+                            connectionString = attrValue.Value;
+                        }
+                        break;
+                    }
+                }
+            }
+            catch
+            {
+                // ignored
+            }
+
+            return connectionString;
+        }
     }
 }
@@ -9,12 +9,12 @@ namespace SiteServer.BackgroundPages.Cms
 {
     public class ModalInputContentTaxis : BasePageCms
     {
-        protected RadioButtonList TaxisType;
-        protected TextBox TaxisNum;
+        protected RadioButtonList RblTaxisType;
+        protected TextBox TbTaxisNum;
 
         private int _inputId;
         private string _returnUrl;
-        private List<int> _contentIdArrayList;
+        private List<int> _contentIdList;
 
         public static string GetOpenWindowString(int publishmentSystemId,   int inputId, string returnUrl)
         {
@@ -33,45 +33,37 @@ public void Page_Load(object sender, EventArgs e)
             PageUtils.CheckRequestParameter("PublishmentSystemID",  "ReturnUrl");
             _inputId = Body.GetQueryInt("InputID");
             _returnUrl = StringUtils.ValueFromUrl(Body.GetQueryString("ReturnUrl"));
-            _contentIdArrayList = TranslateUtils.StringCollectionToIntList(Body.GetQueryString("ContentIDCollection"));
+            _contentIdList = TranslateUtils.StringCollectionToIntList(Body.GetQueryString("ContentIDCollection"));
 
             if (!IsPostBack)
             {
-                TaxisType.Items.Add(new ListItem("上升", "Up"));
-                TaxisType.Items.Add(new ListItem("下降", "Down"));
-                ControlUtils.SelectListItems(TaxisType, "Up");
-
-
+                RblTaxisType.Items.Add(new ListItem("上升", "Up"));
+                RblTaxisType.Items.Add(new ListItem("下降", "Down"));
+                ControlUtils.SelectListItems(RblTaxisType, "Up");
             }
         }
 
         public override void Submit_OnClick(object sender, EventArgs e)
         {
-            var isUp = (TaxisType.SelectedValue == "Up");
-            var taxisNum = int.Parse(TaxisNum.Text);
+            var isUp = RblTaxisType.SelectedValue == "Up";
+            var taxisNum = TranslateUtils.ToInt(TbTaxisNum.Text);
 
             if (isUp == false)
             {
-                _contentIdArrayList.Reverse();
+                _contentIdList.Reverse();
             }
 
-            foreach (int contentID in _contentIdArrayList)
+            foreach (var contentId in _contentIdList)
             {
-                for (var i = 1; i <= taxisNum; i++)
+                for (var i = 0; i < taxisNum; i++)
                 {
                     if (isUp)
                     {
-                        if (DataProvider.InputContentDao.UpdateTaxisToUp(_inputId, contentID))
-                        {
-                            break;
-                        }
+                        DataProvider.InputContentDao.UpdateTaxisToUp(_inputId, contentId);
                     }
                     else
                     {
-                        if (DataProvider.InputContentDao.UpdateTaxisToDown(_inputId, contentID))
-                        {
-                            break;
-                        }
+                        DataProvider.InputContentDao.UpdateTaxisToDown(_inputId, contentId);
                     }
                 }
             }
Original file line number	Diff line number	Diff line change
`@@ -9,12 +9,12 @@ namespace SiteServer.BackgroundPages.Cms`
`9`	`9`	`{`
`10`	`10`	`public class ModalInputContentTaxis : BasePageCms`
`11`	`11`	`{`
`12`		`- protected RadioButtonList TaxisType;`
`13`		`- protected TextBox TaxisNum;`
	`12`	`+ protected RadioButtonList RblTaxisType;`
	`13`	`+ protected TextBox TbTaxisNum;`
`14`	`14`
`15`	`15`	`private int _inputId;`
`16`	`16`	`private string _returnUrl;`
`17`		`- private List<int> _contentIdArrayList;`
	`17`	`+ private List<int> _contentIdList;`
`18`	`18`
`19`	`19`	`public static string GetOpenWindowString(int publishmentSystemId, int inputId, string returnUrl)`
`20`	`20`	`{`
`@@ -33,45 +33,37 @@ public void Page_Load(object sender, EventArgs e)`
`33`	`33`	`PageUtils.CheckRequestParameter("PublishmentSystemID", "ReturnUrl");`
`34`	`34`	`_inputId = Body.GetQueryInt("InputID");`
`35`	`35`	`_returnUrl = StringUtils.ValueFromUrl(Body.GetQueryString("ReturnUrl"));`
`36`		`- _contentIdArrayList = TranslateUtils.StringCollectionToIntList(Body.GetQueryString("ContentIDCollection"));`
	`36`	`+ _contentIdList = TranslateUtils.StringCollectionToIntList(Body.GetQueryString("ContentIDCollection"));`
`37`	`37`
`38`	`38`	`if (!IsPostBack)`
`39`	`39`	`{`
`40`		`- TaxisType.Items.Add(new ListItem("上升", "Up"));`
`41`		`- TaxisType.Items.Add(new ListItem("下降", "Down"));`
`42`		`- ControlUtils.SelectListItems(TaxisType, "Up");`
`43`		`-`
`44`		`-`
	`40`	`+ RblTaxisType.Items.Add(new ListItem("上升", "Up"));`
	`41`	`+ RblTaxisType.Items.Add(new ListItem("下降", "Down"));`
	`42`	`+ ControlUtils.SelectListItems(RblTaxisType, "Up");`
`45`	`43`	`}`
`46`	`44`	`}`
`47`	`45`
`48`	`46`	`public override void Submit_OnClick(object sender, EventArgs e)`
`49`	`47`	`{`
`50`		`- var isUp = (TaxisType.SelectedValue == "Up");`
`51`		`- var taxisNum = int.Parse(TaxisNum.Text);`
	`48`	`+ var isUp = RblTaxisType.SelectedValue == "Up";`
	`49`	`+ var taxisNum = TranslateUtils.ToInt(TbTaxisNum.Text);`
`52`	`50`
`53`	`51`	`if (isUp == false)`
`54`	`52`	`{`
`55`		`- _contentIdArrayList.Reverse();`
	`53`	`+ _contentIdList.Reverse();`
`56`	`54`	`}`
`57`	`55`
`58`		`- foreach (int contentID in _contentIdArrayList)`
	`56`	`+ foreach (var contentId in _contentIdList)`
`59`	`57`	`{`
`60`		`- for (var i = 1; i <= taxisNum; i++)`
	`58`	`+ for (var i = 0; i < taxisNum; i++)`
`61`	`59`	`{`
`62`	`60`	`if (isUp)`
`63`	`61`	`{`
`64`		`- if (DataProvider.InputContentDao.UpdateTaxisToUp(_inputId, contentID))`
`65`		`- {`
`66`		`- break;`
`67`		`- }`
	`62`	`+ DataProvider.InputContentDao.UpdateTaxisToUp(_inputId, contentId);`
`68`	`63`	`}`
`69`	`64`	`else`
`70`	`65`	`{`
`71`		`- if (DataProvider.InputContentDao.UpdateTaxisToDown(_inputId, contentID))`
`72`		`- {`
`73`		`- break;`
`74`		`- }`
	`66`	`+ DataProvider.InputContentDao.UpdateTaxisToDown(_inputId, contentId);`
`75`	`67`	`}`
`76`	`68`	`}`
`77`	`69`	`}`