备份Notify.App.hfWeather

最新推荐文章于 2026-06-17 17:34:48 发布
原创 最新推荐文章于 2026-06-17 17:34:48 发布 · 28 阅读 · 0 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
GEO检测
标签
#数据库 #java #mysql 
//hfx 第一代接口
namespace Notify.App.hfWeather
{
    public class hfx_atstronomy
    {
        private string key = ""; //
        const string api_host = "https://api.qweather.com";
        const string free_api_host = "https://devapi.qweather.com";
        public string api_url { get; private set; }
        public string host_url { get; private set; }

        public hfx_atstronomy(string key)
        {
            this.key = key;
            this.host_url = free_api_host;
        }
        public hfx_atstronomy(string key, api_host_type type)
        {
            this.key = key;
            switch (type)
            {
                case api_host_type.free:
                    this.host_url = free_api_host;
                    break;
                case api_host_type.pay:
                    this.host_url = api_host;
                    break;
            }
        }
        public string astronomy_sun(string date, string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/sun?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + location;
            this.api_url = this.host_url + $"/v7/astronomy/sun?key={key}&lang=zh&date={date}&location={location}";
            return this.api_url;
        }
        /// <summary>
        /// 日出日落
        /// </summary>
        /// <param name="date"></param>
        /// <param name="locationid"></param>
        /// <returns></returns>
        public string astronomy_sun_byid(string date, string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/sun?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/sun?key={key}&lang=zh&date={date}&location={locationid}";
            return this.api_url;
        }
        public string astronomy_sun_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/sun?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/sun?key={key}&lang=zh&date={DateTime.Now.ToString("yyyyMMdd")}&location={locationid}";
            return this.api_url;
        }
        public string astronomy_sun_byid(int locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/sun?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/sun?key={key}&lang=zh&date={DateTime.Now.ToString("yyyyMMdd")}&location={locationid.ToString()}";
            return this.api_url;
        }
        public string astronomy_sun_byposition(string date, string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/sun?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + lng + "," + lat;
            this.api_url = this.host_url + $"/v7/astronomy/sun?key={key}&lang=zh&date={date}&location={lng},{lat}";
            return this.api_url;
        }
        public string astronomy_moon(string date, string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/moon?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + location;
            this.api_url = this.host_url + $"/v7/astronomy/moon?key={key}&lang=zh&date={date}&location={location}";
            return this.api_url;
        }
        public string astronomy_moon_byid(string date, string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/moon?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/moon?key={key}&lang=zh&date={date}&location={locationid}";
            return this.api_url;
        }
        public string astronomy_moon_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/moon?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/moon?key={key}&lang=zh&date={DateTime.Now.ToString("yyyMMdd")}&location={locationid}";
            return this.api_url;
        }
        public string astronomy_moon_byid(int locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/moon?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/moon?key={key}&lang=zh&date={DateTime.Now.ToString("yyyMMdd")}&location={locationid.ToString()}";
            return this.api_url;
        }
        public string astronomy_moon_byposition(string date, string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/moon?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + lng + "," + lat;
            this.api_url = this.host_url + $"/v7/astronomy/moon?key={key}&lang=zh&date={date}&location={lng},{lat}";
            return this.api_url;
        }
        /// <summary>
        /// 太阳高度角，收费应用，仅可使用付费主机。
        /// </summary>
        /// <param name="location"></param>
        /// <param name="date"></param>
        /// <param name="time"></param>
        /// <param name="tz"></param>
        /// <param name="alt"></param>
        /// <returns></returns>
        public string solarangle(string location, string date, string time, string tz, string alt)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/solar-elevation-angle?"
            //  + "key=" + key + "&lang=zh" + "&location=" + location + "&date=" + date + "&time=" + time + "&tz=" + tz + "&alt=" + alt;
            this.host_url = api_host;
            this.api_url = this.host_url + $"/v7/astronomy/solar-elevation-angle?key={key}&lang=zh&location={location}&date={date}&time={time}&tz={tz}&alt={alt}";
            return this.api_url;
        }
        /// <summary>
        /// 太阳高度角，收费应用，仅可使用付费主机。
        /// </summary>
        /// <param name="lng"></param>
        /// <param name="lat"></param>
        /// <param name="date"></param>
        /// <param name="time"></param>
        /// <param name="tz"></param>
        /// <param name="alt"></param>
        /// <returns></returns>
        public string solarangle_byposition(string lng, string lat, string date, string time, string tz, string alt)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/solar-elevation-angle?"
            //  + "key=" + key + "&lang=zh" + "&location=" + lng + "," + lat + "&date=" + date + "&time=" + time + "&tz=" + tz + "&alt=" + alt;
            //this.host_url = api_host;
            this.api_url = this.host_url + $"/v7/astronomy/solar-elevation-angle?key={key}&lang=zh&location={lng},{lat}&date={date}&time={time}&tz={tz}&alt={alt}";
            return this.api_url;
        }
    }
    public enum api_host_type
    {
        free,
        pay
    }
    public class hfx
    {
        private string key = ""; //32 bit chars
                                 //adcode \ 城市名，如北京 \beijing,拼音或英文，支持模糊查找
        const string api_host = "https://api.qweather.com";
        const string free_api_host = "https://devapi.qweather.com";
        public string api_url { get; private set; }
        public string host_url { get; private set; }
        public hfx(string key)
        {
            this.key = key;
            this.host_url = free_api_host;
        }
        
        public hfx(string key, api_host_type type)
        {
            this.key = key;

            switch (type)
            {
                case api_host_type.free:
                    this.host_url = free_api_host;
                    break;
                case api_host_type.pay:
                    this.host_url = api_host;
                    break;
            }
        }
        public string geocity_byadcode(string adcode)
        {
            //string api = "https://geoapi.qweather.com/v2/city/lookup?"
            //  + "key=" + key + "&lang=zh&num=20" + "&Range=cn" + "&location=" + adcode;
            this.api_url = $"https://geoapi.qweather.com/v2/city/lookup?key={key}&lang=zh&num=20&location={adcode}";
            this.host_url= "https://geoapi.qweather.com";
            return this.api_url;
        }
        /// <summary>
        /// 根据城市名获取城市信息
        /// </summary>
        /// <param name="adcode"></param>
        /// <param name="num">1-20</param>
        /// <returns></returns>
        public string geocity_byadcode(string adcode,int num)
        {
            //string api = "https://geoapi.qweather.com/v2/city/lookup?"
            //  + "key=" + key + "&lang=zh&num=20" + "&Range=cn" + "&location=" + adcode;
            this.api_url = $"https://geoapi.qweather.com/v2/city/lookup?key={key}&lang=zh&num={num}&location={adcode}";
            this.host_url = "https://geoapi.qweather.com";
            return this.api_url;
        }
        public string geocity_byname2(string name, string adm, string range = "cn")
        {
            //string api = "https://geoapi.qweather.com/v2/city/lookup?"
            //  + "key=" + key + "&lang=zh&num=20" + "&Range=" + range
            //  + "&location=" + name + "&adm=" + adm;
            this.api_url = $"https://geoapi.qweather.com//v2/city/lookup?key={key}&lang=zh&num=20&Range={range}&location={name}&adm={adm}";
            this.host_url = "https://geoapi.qweather.com";
            return this.api_url;
        }
        public string geocity_byposition(string longitude, string latitude)
        {
            //string api = "https://geoapi.qweather.com/v2/city/lookup?"
            //  + "key=" + key + "&lang=zh&num=20" + "&location=" + longitude + "," + latitude;
            this.api_url = $"https://geoapi.qweather.com/v2/city/lookup?key={key}&lang=zh&num=20&location={longitude},{latitude}";
            this.host_url = "https://geoapi.qweather.com";
            return this.api_url;
        }
        public string geocity_bylocation(string location, string range = "cn")
        {
            //string api = "https://geoapi.qweather.com/v2/city/lookup?"
            //  + "key=" + key + "&lang=zh&Range=cn&num=20" + "&location=" + location;
            this.api_url = $"https://geoapi.qweather.com/v2/city/lookup?key={key}&lang=zh&Range={range}&num=20&location={location}";
            this.host_url = "https://geoapi.qweather.com";
            return this.api_url;
        }
        public string geocity_bylocationid(string locationid)
        {
            //string api = "https://geoapi.qweather.com/v2/city/lookup?"
            //  + "key=" + key + "&lang=zh&num=20" + "&location=" + locationid;
            this.api_url = $"https://geoapi.qweather.com/v2/city/lookup?key={key}&lang=zh&num=20&location={locationid}";
            this.host_url = "https://geoapi.qweather.com";
            return this.api_url;
        }

        //number取值范围1-20，默认返回10个结果。
        public string topcity(int number = 20, string iso3166country = "cn")
        {
            if (iso3166country == string.Empty)
                iso3166country = "cn";
            if (number < 1 || number > 20)
                number = 10;
            //string api = "https://geoapi.qweather.com/v2/city/top?"
            //  + "key=" + key + "&lang=zh" + "&range=" + iso3166country + "&number=" + number;
            this.api_url = $"https://geoapi.qweather.com/v2/city/top?key={key}&lang=zh&range={iso3166country}&number={number}";
            this.host_url = "https://geoapi.qweather.com";
            return this.api_url;
        }
        public string lookupPOI(string type, string location, int number = 20)
        {
            if (number < 1 || number > 20)
                number = 10;
            //string api = "https://geoapi.qweather.com/v2/poi/lookup?"
            //+ "key=" + key + "&lang=zh" + "&type=" + type + "&location=" + location + "&number=" + number;
            this.api_url = $"https://geoapi.qweather.com/v2/poi/lookup?key={key}&lang=zh&type={type}&location={location}&number={number}";
            this.host_url = "https://geoapi.qweather.com";
            return this.api_url;
        }
        public string lookupPOI_byid(string type, string locationid, int number = 20)
        {
            if (number < 1 || number > 20)
                number = 10;
            //string api = "https://geoapi.qweather.com/v2/poi/lookup?"
            //    + "key=" + key + "&lang=zh" + "&type=" + type + "&location=" + locationid + "&number=" + number;
            this.api_url = $"https://geoapi.qweather.com/v2/poi/lookup?key={key}&lang=zh&type={type}&location={locationid}&number={number}";

            this.host_url = "https://geoapi.qweather.com";
            return this.api_url;
        }
        public string lookupPOI_byadcode(string type, string adcode, int number = 20)
        {
            if (number < 1 || number > 20)
                number = 10;
            //string api = "https://geoapi.qweather.com/v2/poi/lookup?" + "key=" + key + "&lang=zh" + "&type=" + type + "&location=" + adcode + "&number=" + number;
            this.api_url = $"https://geoapi.qweather.com/v2/poi/lookup?key={key}&lang=zh&type={type}&location={adcode}&number={number}";

            this.host_url = "https://geoapi.qweather.com";
            return this.api_url;
        }
        //location为经纬度
        public string rangePOI(string type, string location, int radius = 5, int number = 20)
        {
            if (number < 1 || number > 20)
                number = 10;
            if (radius < 1 || radius > 50)
                radius = 5;
            //string api = "https://geoapi.qweather.com/v2/poi/v2/poi/range?"
            //  + "key=" + key + "&lang=zh" + "&type=" + type + "&number=" + number + "&radius=" + radius + "&location=" + location;
            this.api_url = $"https://geoapi.qweather.com/v2/poi/v2/poi/range?key={key}&lang=zh&type={type}&number={number}&radius={radius}&location={location}";
            this.host_url = "https://geoapi.qweather.com";
            return this.api_url;
        }
        public string rangePOI_byposition(string type, string lng, string lat, int radius = 5, int number = 20)
        {
            if (number < 1 || number > 20)
                number = 10;
            if (radius < 1 || radius > 50)
                radius = 5;
            //string api = "https://geoapi.qweather.com/v2/poi/v2/poi/range?"
            //  + "key=" + key + "&lang=zh" + "&type=" + type + "&number=" + number + "&radius=" + radius + "&location=" + lng + "," + lat;
            this.api_url = $"https://geoapi.qweather.com/v2/poi/v2/poi/range?key={key}&lang=zh&type={type}&number={number}&radius={radius}&location={lng},{lat}";
            this.host_url = "https://geoapi.qweather.com";
            return this.api_url;
        }
        public string weather_now_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/now?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + locationid;

            this.api_url=this.host_url + $"/v7/weather/now?key={key}&lang=zh&unit=m&location={locationid}";
            return this.api_url;
        }
        //location为经纬度
        public string weather_now_bylocation(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/now?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + location;
            
            this.api_url =this.host_url+ $"/v7/weather/now?key={key}&lang=zh&unit=m&location={location}";
            return this.api_url;
        }
        public string weather_now_bylocation(int locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/now?key=key + "&lang=zh&unit=m" + "&location=" + location;

            this.api_url = this.host_url + $"/v7/weather/now?key={key}&lang=zh&unit=m&location={locationid.ToString()}";
            return this.api_url;
        }
        public string weather_now_bypostion(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/now?"
            //      + "key=" + key + "&lang=zh&unit=m" + "&location=" + lng + "," + lat;
            this.api_url =this.host_url+ $"/v7/weather/now?key={key}&lang=zh&unit=m&location={lng},{lat}";
            return this.api_url;
        }
        public string weather_3d_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/3d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + locationid;
            this.api_url =this.host_url+ $"/v7/weather/3d?key={key}&lang=zh&unit=m&location={locationid}";
            return this.api_url;
        }
        public string weather_3d_bylocation(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/3d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + location;
            this.api_url =this.host_url+ $"/v7/weather/3d?key={key}&lang=zh&unit=m&location={location}";
            return this.api_url;
        }
        public string weather_3d_bypostion(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/3d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + lng + "," + lat;
            this.api_url =this.host_url+ $"/v7/weather/3d?key={key}&lang=zh&unit=m&location={lng},{lat}";
            return this.api_url;
        }
        public string weather_7d_bylocation(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/3d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + location;
            this.api_url=this.host_url+ $"/v7/weather/7d?key={key}&lang=zh&unit=m&location={location}";
            return this.api_url;
        }
        public string weather_7d_bypostion(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/7d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + lng + "," + lat;
            this.api_url =this.host_url+ $"/v7/weather/7d?key={key}&lang=zh&unit=m&location={lng},{lat}";
            return this.api_url;
        }
        public string weather_7d_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/7d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + locationid;
            this.api_url=this.host_url+ $"/v7/weather/7d?key={key}&lang=zh&unit=m&location={locationid}";
            return this.api_url;
        }
        public string weather_10d_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/10d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/weather/10d?key={key}&lang=zh&unit=m&location={locationid}";
            return this.api_url;
        }
        public string weather_15d_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/15d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/weather/15d?key={key}&lang=zh&unit=m&location={locationid}";
            return this.api_url;
        }
        public string weather_30d_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/30d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/weather/30d?key={key}&lang=zh&unit=m&location={locationid}";
            return this.api_url;
        }
        public string weather_24h_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/24h?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + locationid;
            this.api_url=this.host_url+ $"/v7/weather/24h?key={key}&lang=zh&unit=m&location={locationid}";
            return this.api_url;
        }
        public string weather_24h_bypostion(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/24h?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + lng + "," + lat;
            this.api_url =this.host_url+ $"/v7/weather/24h?key={key}&lang=zh&unit=m&location={lng},{lat}";
            return this.api_url;
        }
        public string weather_24h_bylocation(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/24h?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + location;
            this.api_url = this.host_url + $"/v7/weather/24h?key={key}&lang=zh&unit=m&location={location}";
            return this.api_url;
        }
        public string weather_72h_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/72h?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/weather/72h?key={key}&lang=zh&unit=m&location={locationid}";
            return this.api_url;
        }
        public string weather_168h_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/weather/168h?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/weather/168h?key={key}&lang=zh&unit=m&location={locationid}";
            return this.api_url;
        }

        public string rain_5m(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/minutely/5m?"
            //  + "key=" + key + "&lang=zh" + "&location=" + location;
            this.api_url=this.host_url+$"/v7/minutely/5m?key={key}&lang=zh&location={location}";
            return this.api_url;
        }
        public string rain_5m_byposition(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/minutely/5m?"
            //  + "key=" + key + "&lang=zh" + "&location=" + lng + "," + lat;
            this.api_url=this.host_url+ $"/v7/minutely/5m?key={key}&lang=zh&location={lng},{lat}";
            return this.api_url;
        }
        public string gridweather_now(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/grid-weather/now?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + location;
            this.api_url=this.host_url+ $"/v7/grid-weather/now?key={key}&lang=zh&unit=m&location={location}";
            return this.api_url;
        }
        public string gridweather_now_byposition(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/grid-weather/now?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + lng + "," + lat;
            this.api_url=this.host_url+ $"/v7/grid-weather/now?key={key}&lang=zh&unit=m&location={lng},{lat}";
            return this.api_url;
        }
        public string gridweather_3d(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/grid-weather/3d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + location;
            this.api_url=this.host_url+ $"/v7/grid-weather/3d?key={key}&lang=zh&unit=m&location={location}";
            return this.api_url;
        }
        public string gridweather_3d_byposition(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/grid-weather/3d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + lng + "," + lat;
            this.api_url=this.host_url+ $"/v7/grid-weather/3d?key={key}&lang=zh&unit=m&location={lng},{lat}";
            return this.api_url;
        }
        public string gridweather_7d(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/grid-weather/7d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + location;
            this.api_url = this.host_url + $"/v7/grid-weather/7d?key={key}&lang=zh&unit=m&location={location}";
            return this.api_url;
        }
        public string gridweather_7d_byposition(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/grid-weather/7d?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + lng + "," + lat;
            this.api_url = this.host_url + $"/v7/grid-weather/7d?key={key}&lang=zh&unit=m&location={lng},{lat}";
            return this.api_url;
        }
        public string gridweather_24h(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/grid-weather/24h?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + location;
            this.api_url = this.host_url + $"/v7/grid-weather/24h?key={key}&lang=zh&unit=m&location={location}";
            return this.api_url;
        }
        public string gridweather_24h_byposition(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/grid-weather/24h?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + lng + "," + lat;
            this.api_url = this.host_url + $"/v7/grid-weather/24h?key={key}&lang=zh&unit=m&location={lng},{lat}";
            return this.api_url;
        }
        public string gridweather_72h(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/grid-weather/72h?"
            //  + "key=" + key + "&lang=zh&unit=m" + "&location=" + location;
            this.api_url = this.host_url + $"/v7/grid-weather/72h?key={key}&lang=zh&unit=m&location={location}";
            return this.api_url;
        }
        public string warning_list(string range_iso3166)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/warning/now?"
            //  + "key=" + key + "&lang=zh" + "&location=" + range_iso3166;
            this.api_url = this.host_url + $"/v7/warning/now?key={key}&lang=zh&location={range_iso3166}";
            return this.api_url;
        }
        public string warning_now(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/warning/now?"
            //  + "key=" + key + "&lang=zh" + "&location=" + location;
            this.api_url = this.host_url + $"/v7/warning/now?key={key}&lang=zh&location={location}";
            return this.api_url;
        }
        public string warning_now_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/warning/now?"
            //  + "key=" + key + "&lang=zh" + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/warning/now?key={key}&lang=zh&location={locationid}";
            return this.api_url;
        }
        public string warning_now_byposition(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/warning/now?"
            //  + "key=" + key + "&lang=zh" + "&location=" + lng + "," + lat;
            this.api_url = this.host_url + $"/v7/warning/now?key={key}&lang=zh&location={lng},{lat}";
            return this.api_url;
        }
        public string indices_today(string type, string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/indices/1d?"
            //  + "key=" + key + "&lang=zh" + "&type=" + type + "&location=" + location;
            this.api_url = this.host_url + $"/v7/indices/1d?key={key}&lang=zh&type={type}&location={location}";
            return this.api_url;
        }
        public string indices_today_byid(string type, string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            string api = "https://devapi.qweather.com/v7/indices/1d?"
              + "key=" + key + "&lang=zh" + "&type=" + type + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/indices/1d?key={key}&lang=zh&type={type}&location={locationid}";
            return this.api_url;
        }
        public string indices_today_byposition(string type, string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/indices/1d?"
            //  + "key=" + key + "&lang=zh" + "&type=" + type + "&location=" + lng + "," + lat;
            this.api_url = this.host_url + $"/v7/indices/1d?key={key}&lang=zh&type={type}&location={lng},{lat}";
            return this.api_url;
        }
        public string indices_3d(string type, string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/indices/3d?"
            //  + "key=" + key + "&lang=zh" + "&type=" + type + "&location=" + location;
            this.api_url = this.host_url + $"/v7/indices/3d?key={key}&lang=zh&type={type}&location={location}";
            return this.api_url;
        }
        public string indices_3d_byid(string type, string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/indices/3d?"
            //  + "key=" + key + "&lang=zh" + "&type=" + type + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/indices/3d?key={key}&lang=zh&type={type}&location={locationid}";
            return this.api_url;
        }
        public string indices_3d_byposition(string type, string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/indices/3d?"
            //  + "key=" + key + "&lang=zh" + "&type=" + type + "&location=" + lng + "," + lat;
            this.api_url = this.host_url + $"/v7/indices/3d?key={key}&lang=zh&type={type}&location={lng},{lat}";
            return this.api_url;
        }
        public string air_now(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/air/now?"
            //  + "key=" + key + "&lang=zh" + "&location=" + location;
            this.api_url = this.host_url + $"/v7/air/now?key={key}&lang=zh&location={location}";
            return this.api_url;
        }
        public string air_now_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/air/now?"
            //  + "key=" + key + "&lang=zh" + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/air/now?key={key}&lang=zh&location={locationid}";
            return this.api_url;
        }
        public string air_now_byid(int locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/air/now?"
            //  + "key=" + key + "&lang=zh" + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/air/now?key={key}&lang=zh&location={locationid.ToString()}";
            return this.api_url;
        }
        public string air_now_byposition(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/air/now?"
            //  + "key=" + key + "&lang=zh" + "&location=" + lng + "," + lat;
            this.api_url = this.host_url + $"/v7/air/now?key={key}&lang=zh&location={lng},{lat}";
            return this.api_url;
        }
        public string air_5d(string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/air/5d?"
            //  + "key=" + key + "&lang=zh" + "&location=" + location;
            this.api_url = this.host_url + $"/v7/air/5d?key={key}&lang=zh&location={location}";
            return this.api_url;
        }
        public string air_5d_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/air/5d?"
            //  + "key=" + key + "&lang=zh" + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/air/5d?key={key}&lang=zh&location={locationid}";
            return this.api_url;
        }
        public string air_5d_byposition(string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/air/5d?"
            //  + "key=" + key + "&lang=zh" + "&location=" + lng + "," + lat;
            this.api_url = this.host_url + $"/v7/air/5d?key={key}&lang=zh&location={lng},{lat}";
            return this.api_url;
        }
        public enum hfx_unit_type
        {
            m,  //公制单位
            i   //英制单位
        }
        public string historical_weather(string locationid,string date,string lang="zh",string unit="m")
        {
            this.host_url = api_host;
            this.api_url = this.host_url + $"/v7/historical/weather?key={this.key}&location={locationid}&date={date}&lang={lang}&unit={unit}";
            return this.api_url;
        }
        public string historical_air(string locationid, string date, string lang = "zh", string unit = "m")
        {
            this.host_url = api_host;
            this.api_url = this.host_url + $"/v7/historical/air?key={this.key}&location={locationid}&date={date}&lang={lang}&unit={unit}";
            return this.api_url;
        }
        public enum hfx_tropical_basin
        {
            AL,//North Atlantic 北大西洋
            EP,//Eastern Pacific 东太平洋
            NP,//NorthWest Pacific 西北太平洋
            SP,//SouthWestern Pacific 西南太平洋
            NI,//North Indian 北印度洋
            SI //South Indian 南印度洋
        }
        public string tropical_stormlist(hfx_tropical_basin basin, string year)
        {
            this.host_url = api_host;
            this.api_url = this.host_url + $"/v7/historical/tropical/storm-list?key={this.key}&basin={basin.ToString()}&year={year}";
            return this.api_url;
        }
        public string tropical_stormlist(string basin,string year)
        {
            this.host_url = api_host;
            this.api_url = this.host_url + $"/v7/historical/tropical/storm-list?key={this.key}&basin={basin}&year={year}";
            return this.api_url;
        }
        public string tropical_stormforecast(string stormid)
        {
            this.host_url= api_host;
            //'https://api.qweather.com/v7/tropical/storm-forecast?stormid=NP_2106'
            this.api_url = this.host_url + $"/v7/tropical/storm-forecast?key={this.key}&stormid={stormid}";
            return this.api_url;
        }
        public string tropical_stormtrack(string stormid)
        {
            this.host_url=api_host;
            this.api_url = this.host_url + $"/v7/tropical/storm-track?key={this.key}&stormid={stormid}";
            return this.api_url;
        }
        public string astronomy_sun(string date, string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/sun?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + location;
            this.api_url = this.host_url + $"/v7/astronomy/sun?key={key}&lang=zh&date={date}&location={location}";
            return this.api_url;
        }
        /// <summary>
        /// 收费接口，未来10天全球潮流数据，包括潮流流速和流向。
        /// </summary>
        /// <param name="location">潮流站点或潮汐站点，还有经纬度</param>
        /// <param name="date"></param>
        /// <returns></returns>
        public string ocean_tide(string location,string date)
        {
            this.host_url = api_host;
            this.api_url = this.host_url + $"/v7/ocean/tide?key={key}&lang=zh&date={date}&location={location}";
            return this.api_url;
        }
        public string ocean_currents(string location,string date)
        {
            this.host_url = api_host;
            //'https://api.qweather.com/v7/ocean/currents?location=P66981&date=20210310'
            this.api_url = this.host_url + $"/v7/ocean/currents?key={key}&lang=zh&date={date}&location={location}";
            return this.api_url;
        }
        public string solarradiation_24h(string location)
        {
            this.host_url = api_host;
            //'https://api.qweather.com/v7/solar-radiation/24h?location=116.41,39.92'
            this.api_url = this.host_url + $"/v7/solar-radiation/24h?key={key}&location={location}";
            return this.api_url;
        }
        public string solarradiation_24h(string lon,string lat)
        {
            this.host_url = api_host;
            //'https://api.qweather.com/v7/solar-radiation/24h?location=116.41,39.92'
            this.api_url = this.host_url + $"/v7/solar-radiation/24h?key={key}&location={lon},{lat}";
            return this.api_url;
        }
        public string solarradiation_24h(float lon, float lat)
        {
            this.host_url = api_host;
            //'https://api.qweather.com/v7/solar-radiation/24h?location=116.41,39.92'
            this.api_url = this.host_url + $"/v7/solar-radiation/24h?key={key}&location={lon},{lat}";
            return this.api_url;
        }
        public string solarradiation_72h(string location)
        {
            this.host_url = api_host;
            //'https://api.qweather.com/v7/solar-radiation/72h?location=116.41,39.92'
            this.api_url = this.host_url + $"/v7/solar-radiation/72h?key={key}&location={location}";
            return this.api_url;
        }
        public string solarradiation_72h(string lon,string lat)
        {
            this.host_url = api_host;
            //'https://api.qweather.com/v7/solar-radiation/72h?location=116.41,39.92'
            this.api_url = this.host_url + $"/v7/solar-radiation/72h?key={key}&location={lon},{lat}";
            return this.api_url;
        }
        public string solarradiation_72h(float lon, float lat)
        {
            this.host_url = api_host;
            //'https://api.qweather.com/v7/solar-radiation/72h?location=116.41,39.92'
            this.api_url = this.host_url + $"/v7/solar-radiation/72h?key={key}&location={lon},{lat}";
            return this.api_url;
        }
        /// <summary>
        /// 日出日落
        /// </summary>
        /// <param name="date"></param>
        /// <param name="locationid"></param>
        /// <returns></returns>
        public string astronomy_sun_byid(string date, string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/sun?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/sun?key={key}&lang=zh&date={date}&location={locationid}";
            return this.api_url;
        }
        public string astronomy_sun_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/sun?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/sun?key={key}&lang=zh&date={DateTime.Now.ToString("yyyyMMdd")}&location={locationid}";
            return this.api_url;
        }
        public string astronomy_sun_byid(int locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/sun?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/sun?key={key}&lang=zh&date={DateTime.Now.ToString("yyyyMMdd")}&location={locationid.ToString()}";
            return this.api_url;
        }
        public string astronomy_sun_byposition(string date, string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/sun?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + lng + "," + lat;
            this.api_url = this.host_url + $"/v7/astronomy/sun?key={key}&lang=zh&date={date}&location={lng},{lat}";
            return this.api_url;
        }
        public string astronomy_moon(string date, string location)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/moon?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + location;
            this.api_url = this.host_url + $"/v7/astronomy/moon?key={key}&lang=zh&date={date}&location={location}";
            return this.api_url;
        }
        public string astronomy_moon_byid(string date, string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/moon?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/moon?key={key}&lang=zh&date={date}&location={locationid}";
            return this.api_url;
        }
        public string astronomy_moon_byid(string locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/moon?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/moon?key={key}&lang=zh&date={DateTime.Now.ToString("yyyMMdd")}&location={locationid}";
            return this.api_url;
        }
        public string astronomy_moon_byid(int locationid)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/moon?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + locationid;
            this.api_url = this.host_url + $"/v7/astronomy/moon?key={key}&lang=zh&date={DateTime.Now.ToString("yyyMMdd")}&location={locationid.ToString()}";
            return this.api_url;
        }
        public string astronomy_moon_byposition(string date, string lng, string lat)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/moon?"
            //  + "key=" + key + "&lang=zh" + "&date=" + date + "&location=" + lng + "," + lat;
            this.api_url = this.host_url + $"/v7/astronomy/moon?key={key}&lang=zh&date={date}&location={lng},{lat}";
            return this.api_url;
        }
        /// <summary>
        /// 太阳高度角，收费应用，仅可使用付费主机。
        /// </summary>
        /// <param name="location"></param>
        /// <param name="date"></param>
        /// <param name="time"></param>
        /// <param name="tz"></param>
        /// <param name="alt"></param>
        /// <returns></returns>
        public string solarangle(string location, string date, string time, string tz, string alt)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/solar-elevation-angle?"
            //  + "key=" + key + "&lang=zh" + "&location=" + location + "&date=" + date + "&time=" + time + "&tz=" + tz + "&alt=" + alt;
            this.host_url=api_host;
            this.api_url = this.host_url + $"/v7/astronomy/solar-elevation-angle?key={key}&lang=zh&location={location}&date={date}&time={time}&tz={tz}&alt={alt}";
            return this.api_url;
        }
        /// <summary>
        /// 太阳高度角，收费应用，仅可使用付费主机。
        /// </summary>
        /// <param name="lng"></param>
        /// <param name="lat"></param>
        /// <param name="date"></param>
        /// <param name="time"></param>
        /// <param name="tz"></param>
        /// <param name="alt"></param>
        /// <returns></returns>
        public string solarangle_byposition(string lng, string lat, string date, string time, string tz, string alt)
        {
            //如果是免费订阅，将上述API Host更改为devapi.qweather.com。
            //string api = "https://devapi.qweather.com/v7/astronomy/solar-elevation-angle?"
            //  + "key=" + key + "&lang=zh" + "&location=" + lng + "," + lat + "&date=" + date + "&time=" + time + "&tz=" + tz + "&alt=" + alt;
            //this.host_url = api_host;
            this.api_url = this.host_url + $"/v7/astronomy/solar-elevation-angle?key={key}&lang=zh&location={lng},{lat}&date={date}&time={time}&tz={tz}&alt={alt}";
            return this.api_url;
        }
    }
}

C# SmtpClient好像不支持STARTTLS，outlook邮箱不能发了
huxyc的博客
04-14 2192
最近发现我之前的程序不能用了。于是我想代替程序，于是找到MailKit了，我先试一下水。 using System; using System.Text; using System.Net.Mail; using System.Net; namespace sendmail { internal class Program { static void Main(string[] args) { try .
C# 使用SQLite
huxyc的博客
10-21 8951
SQLite是一个进程内的轻量级嵌入式数据库，它的数据库就是一个文件，实现了自给自足、无服务器、零配置的、事务性的SQL数据库引擎。它是一个零配置的数据库，这就体现出来SQLite与其他数据库的最大的区别：SQLite不需要在系统中配置，直接可以使用。且SQLite不是一个独立的进程，可以按应用程序需求进行静态或动态连接。SQLite可直接访问其存储文件。首先需要在数据创建一张表，才能添加数据，有数据了才能演示查询，修改和删除。实现了基本的数据操作，增删改查。创建一张Person表。
JsonSerializer 类
huxyc的博客
01-26 5921
定义 命名空间: System.Text.Json 程序集： System.Text.Json.dll 提供将对象或值类型序列化为 JSON 以及将 JSON 反序列化为对象或值类型的功能。 public static class JsonSerializer 继承 Object ---》 JsonSerializer 我踩过的坑 public class User { public int Id { get; set; } } static void Main(stri..
C#中将string转换为float
huxyc的博客
04-18 5754
string s = "123.2"; //方法1 float f1 = Convert.ToSingle(s); //方法2 float f2; if (!float.TryParse(s, out f2)) { ...
在C#中如何判断线程当前所处的状态
huxyc的博客
10-16 4637
在公共语言运行时中创建的线程最初处于Unstarted状态中，而进入运行时的外部线程则已经处于Running状态中。并非所有的ThreadState值的组合都是有效的；例如，线程不能同时处于Aborted和Unstarted状态中。在C#中，线程对象Thread使用ThreadState属性指示线程状态，它 是带Flags特性的枚举类型对象。因此判断线程当前的状态必须用bitmask按位运算来达到判断目的，不能直接使用相等来判断。2.判断线程是否处于运行状态。1.判断线程是否处于取消状态。
mysql insert 存在即不插入语法
huxyc的博客
07-18 4187
如果发现表中已经有此行数据（根据主键或者唯一索引判断）则先删除此行数据，然后插入新的数据。否则，直接插入新数据。
C#计算程序执行的时间间隔
huxyc的博客
03-02 3340
我在这提供3种方法。 一、用SpanTime TimeSpants1=newTimeSpan(DateTime.Now.Ticks);//获取当前时间的刻度数//执行某操作TimeSpants2=newTimeSpan(DateTime.Now.Ticks);TimeSpants=ts2.Subtr...
C# 编写规范
huxyc的博客
04-29 3237
C# 编写规范 一、两种命名风格： 1.Pascal风格 大驼峰命名法     包含一个到多个单词，每个单词首字母大写，其余字母均小写。例如：HelloWorld、SetName等等。 2.Camel风格   小驼峰命名法     包含一个到多个单词，第一个单词首字母小写，其余单词首字母大写。例如：name、productId等等。 二、标识符的大小写规则 1.参数和变量的命
C#读取MySQL数据
huxyc的博客
01-26 3129
public static void Main() { MySqlConnection conn = new MySqlConnection("Database=yourDataBase;Data Source=localhost;User Id=yourmysqlaccount;Password=yourpassword"); try { conn.Open(); } catch(Exception ex) .
System.Data.SQLite 与 Microsoft.Data.Sqlite
huxyc的博客
10-24 2808
但是，Microsoft.Data.Sqlite 的最初目标是仍保持轻量级的新式特性。System.Data.SQLite 历史悠久，并且已发展成为具有 Visual Studio 工具的稳定且功能齐全的 ADO.NET 提供程序。在 2005 年，Robert Simpson 创建了System.Data.SQLite，这是 ADO.NET 2.0 的一个 SQLite 提供程序。Microsoft.Data.Sqlite 和 System.Data.SQLite 之间的最大区别是处理数据类型的方式。
MySqlDataAdapter
huxyc的博客
01-28 1851
using System; using System.Data; using MySql.Data.MySqlClient; public static void debug_mysqladapter() { MySqlConnection conn = new MySqlConnection(GetConnectString()); try { conn.Open(); } catch (Exception ex) .
Mysql如何实现不存在则插入,存在则更新
huxyc的博客
07-16 1726
执行如上sql，该id不存在(此处id不存在，指的是id为X的记录不存在，包括主键、unique索引列等情况)，相当于执行了insert部分，普通插入，受影响的行1。执行如上sql，该id已存在，相当于执行了update部分，受影响的行2。执行结果如下，注意只是更新username，是保留了email的。...
C#DateTimeOffset
huxyc的博客
02-20 1291
最近解析和风接口的数据，因为时间国际化的问题犯愁，今天查一下资料，终于找到最简单可靠的办法。 var dateTime = DateTimeOffset.Parse("2022-02-20T13:04+08:00"); Console.WriteLine(dateTime.ToString("yyyy-MM-ddTHH:mmzzz")); 参考文档： c#：时区、DateTime和DateTimeOffset - .Neter1 - 博客园 (cnblogs.com) ...
C#控制台退出前操作
huxyc的博客
08-02 1258
最近我的项目需要在退出前保存数据到数据库，所以研究了一下。
C#GBK编码转ANSI编码
huxyc的博客
05-21 1155
static string gbk_ansi(string str) { Encoding gbk = Encoding.GetEncoding(936); Encoding ansi = Encoding.GetEncoding("ANSI"); byte[] buf = gbk.GetByt...
基于java Web 训练管理系统设计与实现 源码 论文
qq_251836457的博客
06-17 566
用户信息实体，主要包括 用户编号,用户名,密码,姓名,性别,出生日期,证件号,民族,政治面貌,单位,入伍时间,照片,班级,排 等信息实体。1 用户( 用户编号,用户名,密码,姓名,性别,出生日期,证件号,民族,政治面貌,单位,入伍时间,照片,班级,排 )讨论信息实体，主要包括 讨论编号,疑问,说明,发布人,发布时间,状态,回答 等信息实体。系统主要用户实体,班级实体,排实体,科目实体,成绩实体,教学视频实体,教学理论实体,讨论实体，如图所示。班级信息实体，主要包括 班级编号,班级 等信息实体。
Java使用tomcat+servlet+filter实现简单的登录功能，需先登录再进行页面数据管理操作
简介
06-12 1296
实现简单的登录页面，那就设计一个简单的用户信息表，字段简约，这是mysql建表和一条admin用户的数据。同样简约的前端页面（没有添加任何样式）
24-Django请求全链路-WSGI到数据库响应的完整旅程
weixin_44081096的博客
06-15 729
你点了浏览器的"刷新"按钮，0.5 秒后页面渲染完毕。这 0.5 秒里发生了什么？本文把 Django 处理一个 HTTP 请求的完整链路拆为六个步骤：WSGI Server 接收 TCP 连接 → 中间件栈的洋葱模型逐层处理 → URL 路由匹配 → View 执行业务逻辑 → ORM 生成 SQL 并发送到数据库 → Template 渲染或 JSON 序列化返回响应。每一步都配有对应的源码位置和关键代码片段，读完你能对一个请求的全生命周期建立起清晰的空间模型。穿插真实调试经历——一个中间件错误导致所有
数据库写轮眼：看透 MVCC 版本链、快照、隔离级别。
初入后端的大二在校生
06-15 836
在数据库高并发场景下，海量事务同时读写同一份数据，单纯依赖锁机制相互制衡，只会造成无休止的阻塞等待；脏读、不可重复读与幻读，更如同忍界无解的幻术，牢牢桎梏着系统性能。 正如这幅图中，宇智波鼬借 Undo Log 铺展绵延不绝的数据历史分身版本链，佐助则凭借 ReadView 写轮眼，筛选出仅对当前事务可见的数据快照。 MVCC 正是数据库世界里独一份的宇智波瞳术，它摒弃锁竞争的对抗思路，依托多版本数据与视图可见性规则，为每一笔事务划分独立读写时空，从根源化解并发读写矛盾。
【基础】PostgreSQL 数据导出
最新发布
shen12138的博客
06-17 309
PostgreSQL 的导出其实可以很精细：先用查询摸清各表大小，再用pg_dump配合精准排除不需要的数据。这套「先查后导」的流程既能节省导出时间，又能控制备份文件的大小，值得在实际工作中推广使用。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

Risehuxyc

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值