Visual Studio 2017 – Windows应用程序打包成exe文件（2）- Advanced Installer 关于Newtonsoft.Json，LINQ to JSON的一个小d…

        public static void Test1()
        {
            /* 文本格式如下 代码实现目的： 1、VR 对象中是否包含ProjectId 2、取ProjectId下的值 { "VR": { "ProjectId": { "txt_s": "工程项目的名称编号Id", "value": "01" }, "ProjectObject": { "ProjectTypeName": { "name": "12企业类别1", "txt_s": "企业类别名称" }, "txt_s": "企业类别对象" }, "ProjectTitle": { "txt_s": "工程项目的名称(Title信息)", "value": "01" }, "UserId": { "txt_s": "用户的Id", "value": "01" } } } */ var str = @"%7b+%22VR%22%3a+%7b%22ProjectId%22%3a+%7b%22txt_s%22%3a+%22%e5%b7%a5%e7%a8%8b%e9%a1%b9%e7%9b%ae%e7%9a%84%e5%90%8d%e7%a7%b0%e7%bc%96%e5%8f%b7Id%22%2c+%22value%22%3a+%2201%22+%7d%2c+%22ProjectObject%22%3a+%7b%22ProjectTypeName%22%3a+%7b%22name%22%3a+%2212%e4%bc%81%e4%b8%9a%e7%b1%bb%e5%88%ab1%22%2c+%22txt_s%22%3a+%22%e4%bc%81%e4%b8%9a%e7%b1%bb%e5%88%ab%e5%90%8d%e7%a7%b0%22+%7d%2c+%22txt_s%22%3a+%22%e4%bc%81%e4%b8%9a%e7%b1%bb%e5%88%ab%e5%af%b9%e8%b1%a1%22+%7d%2c+%22ProjectTitle%22%3a+%7b%22txt_s%22%3a+%22%e5%b7%a5%e7%a8%8b%e9%a1%b9%e7%9b%ae%e7%9a%84%e5%90%8d%e7%a7%b0(Title%e4%bf%a1%e6%81%af)%22%2c+%22value%22%3a+%2201%22+%7d%2c+%22UserId%22%3a+%7b%22txt_s%22%3a+%22%e7%94%a8%e6%88%b7%e7%9a%84Id%22%2c+%22value%22%3a+%2201%22+%7d+%7d%7d"; //上述文本是编码之后的，方便调试 str = HttpUtility.UrlDecode(str, Encoding.UTF8); var jobject = JObject.Parse(str); var projectId = jobject.SelectToken("VR.ProjectId"); //VR 对象中是否包含ProjectId if (!projectId.HasValues) { //不包含 } else { foreach (var temp in projectId.Children()) { if (temp.Path.EndsWith("txt_s")) { var a = temp.ToObject<string>(); //a 的值是 工程项目的名称编号Id } if (temp.Path.EndsWith("value")) { var a = temp.ToObject<string>(); //a 的值是 01 } } } } 

DELIMITER ;
CREATE PROCEDURE test_insert() BEGIN DECLARE y TINYINT DEFAULT 1; WHILE y<13 DO INSERT INTO app_sign(`user_id`, `score`, `createdate`) VALUES ('1', FLOOR( 1 + RAND() * 5), CONCAT('2018-',CAST(y AS CHAR),'-07') ); SET y=y+1; END WHILE ; COMMIT; END; CALL test_insert(); DROP PROCEDURE IF EXISTS test_insert;

DELIMITER ;
CREATE PROCEDURE test_insert() BEGIN DECLARE y TINYINT DEFAULT 1; REPEAT INSERT INTO app_sign(`user_id`, `score`, `createdate`) VALUES ('1', FLOOR( 1 + RAND() * 5), CONCAT('2018-',CAST(y AS CHAR),'-07') ); SET y=y+1; UNTIL y >= 12 END REPEAT; COMMIT; END; CALL test_insert(); DROP PROCEDURE IF EXISTS test_insert;

DELIMITER ;
CREATE PROCEDURE test_insert() BEGIN DECLARE y TINYINT DEFAULT 1; lp:LOOP INSERT INTO app_sign(`user_id`, `score`, `createdate`) VALUES ('1', FLOOR( 1 + RAND() * 5), CONCAT('2018-',CAST(y AS CHAR),'-07') ); SET y=y+1; IF y > 12 THEN LEAVE lp; END IF; END LOOP; COMMIT; END; CALL test_insert(); DROP PROCEDURE IF EXISTS test_insert;

在工作时，需要获取服务器公网IP（外网IP），并且判断该IP地址是属于网通还是电信。花时间整理一下，自己实现的代码，以及后续遇到的问题。

        /// <summary>
        /// 获取外网IP
        /// </summary>
        /// <returns>IP</returns>
        public static string GetOuterIP()
        {
            string IP = string.Empty; Uri uri = new Uri("http://www.ip138.com/ips138.asp"); System.Net.HttpWebRequest req = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(uri); req.Method = "get"; using (System.IO.Stream s = req.GetResponse().GetResponseStream()) { using (System.IO.StreamReader reader = new System.IO.StreamReader(s)) { char[] ch = { '[', ']' }; string str = reader.ReadToEnd(); System.Text.RegularExpressions.Match m = System.Text.RegularExpressions.Regex.Match(str, @"\[(?<IP>[0-9\.]*)\]"); IP= m.Value.Trim(ch); } } return IP; }

        /// <summary> /// 判断ip是电信还是网通，网通为0，电信为1 /// </summary> /// <returns></returns> public static string GetLocation() { string location = "0"; try { Uri uri = new Uri("http://www.ip138.com/ips138.asp"); System.Net.HttpWebRequest req = System.Net.WebRequest.Create(uri) as System.Net.HttpWebRequest; if (req != null) { req.Method = "get"; using (System.IO.Stream s = req.GetResponse().GetResponseStream()) { using (System.IO.StreamReader reader = new System.IO.StreamReader(s, Encoding.GetEncoding("gb2312"))) { string str = reader.ReadToEnd(); if (str.Contains("电信")) { location = "1"; } } } } } catch { location = "0"; } return location; }