<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[某某xl]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/SunshineBlog</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; SunshineBlog]]></copyright><item><title><![CDATA[Oracel 创建分页存储过程]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/122573785</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/122573785</guid><author>SunshineBlog</author><pubDate>Wed, 19 Jan 2022 09:37:23 +0800</pubDate><description><![CDATA[CREATE OR REPLACE PROCEDURE proc_getInfoPage(
	pageIndex int,
	pageSize int, 
	total OUT int,--输出总数量
	v_cursor OUT SYS_REFCURSOR --游标输出表信息 
)
AS 
BEGIN  		
	SELECT  COUNT(1) INTO total  from table1;

	OPEN v_cursor FOR
	  SELECT t.*  FROM (
		SELECT pb.*,.]]></description><category></category></item><item><title><![CDATA[nginx 学习随笔]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/121096701</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/121096701</guid><author>SunshineBlog</author><pubDate>Tue, 02 Nov 2021 11:22:55 +0800</pubDate><description><![CDATA[windows命令操作nginx：

 启动nginx：start nginx.exe 或 start nginx
 
 停止：nginx.exe -s stop 或 nginx.exe -s quit --stop是快速停止nginx，可能并不保存相关信息；quit是完整有序的停止nginx，并保存相关信息
 
 检查修改配置后的nginx.conf是否正确: nginx -t
 
 重启（刷新配置文件）：nginx -s reload


做反向代理之前需要...]]></description><category></category></item><item><title><![CDATA[通用分页方法]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/120541722</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/120541722</guid><author>SunshineBlog</author><pubDate>Wed, 29 Sep 2021 09:15:03 +0800</pubDate><description><![CDATA[public static DataSet QueryByPage(string connectionString, string SQLString, SqlParameter[] cmdParms, string sortPara, out int total, int pageIndex = 1, int PageSize = 10, string sortRule = "asc")
        {
            total = 0;
            var sq...]]></description><category></category></item><item><title><![CDATA[exchange协议发送邮件]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/119953099</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/119953099</guid><author>SunshineBlog</author><pubDate>Fri, 27 Aug 2021 15:04:08 +0800</pubDate><description><![CDATA[平时基本都是是用ssl协议发送邮件，但是公司有个客户对发送邮件要求比较特殊，所以就结合客户需求写了一个通用的exchange协议发送邮件的方法，菜鸟上手，请大家多多指教



    public class ExchangeEmailInfo
    {
       
        /// &lt;summary&gt;
        /// 接收人
        /// &lt;/summary&gt;
        public List&lt;string&gt; ToRecipient.]]></description><category></category></item><item><title><![CDATA[WebClient发布到IIS后访问共享文件提示用户名或密码错误（已设置凭证）]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/119888416</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/119888416</guid><author>SunshineBlog</author><pubDate>Tue, 24 Aug 2021 14:14:00 +0800</pubDate><description><![CDATA[WebClient wc = new WebClient();
     //有连接凭证（没有连接凭证的可以不加）
     wc.Credentials = new NetworkCredential("admin", "123456");
     wc.Headers.Add(HttpRequestHeader.ContentType, "application/json; charset=utf-8");

            byte[] bt =             
   ...]]></description><category></category></item><item><title><![CDATA[js获取上个月的年月和下个月的年月（yyyyMM）]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/119216349</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/119216349</guid><author>SunshineBlog</author><pubDate>Thu, 29 Jul 2021 17:47:23 +0800</pubDate><description><![CDATA['上月年月': function () {
                       var date = new Date();
var months = (date.getMonth() + 1);
var m = '0' + months;
var y = date.getFullYear();
if (months == 1 ) {
    y--;
        m = '01';
} else {
    m = '0' + (months-1)
}
return y + m.subs..]]></description><category></category></item><item><title><![CDATA[git的操作命令]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/118519047</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/118519047</guid><author>SunshineBlog</author><pubDate>Tue, 06 Jul 2021 14:01:18 +0800</pubDate><description><![CDATA[右键 git bash here

--获取代码
git config --system --unset credential.helper	清除用户名和密码
git config --global user.name 	用户名 		    配置用户名
git config --global user.email 	邮箱  		    配置邮箱
git config --global --list  			        获取本地所有配置
git config --system --list			  ...]]></description><category></category></item><item><title><![CDATA[给redis新增密码以及命令启动redis服务]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/118515620</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/118515620</guid><author>SunshineBlog</author><pubDate>Tue, 06 Jul 2021 10:49:55 +0800</pubDate><description><![CDATA[首先找到redis以conf结尾的配置文件，redis版本不同配置文件名字也不同，一般为redis.conf或redis.wondows.conf，然后找到该文件的requirepass（没有设置密码前面一般都会带#号，如图一所示），去掉该单词前面的#号，然后在requirepass后面写上自己的密码就行了，如图二所示


图一



  ...]]></description><category></category></item><item><title><![CDATA[如何处理echats双y轴刻度不一致（不对齐）问题]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/117415727</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/117415727</guid><author>SunshineBlog</author><pubDate>Mon, 31 May 2021 14:35:45 +0800</pubDate><description><![CDATA[双y轴刻度不一致处理之前，如下图所示







为了解决上图问题，最先想到使用最大公约数来解决刻度不一致问题，话不多说，上代码



  //yMax1 第一条y轴的最大值   yMax2 第二条y轴的最大值
  var divisor = 5;
  var lcmVal = chartlcm(yMax1, yMax2)//获取两条y轴的最大公约数
  var Ymaxval_interval = YmaxvalAndinterval(yMax1, yMax2, lcmVal, divisor);//.]]></description><category></category></item><item><title><![CDATA[echarts实现颜色渐变]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/116704404</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/116704404</guid><author>SunshineBlog</author><pubDate>Wed, 12 May 2021 13:23:20 +0800</pubDate><description><![CDATA[itemStyle: {
                            normal: {
                                areaStyle: { type: 'linear', opacity: 0.3 },
                                color: new echarts.graphic.LinearGradient(
                                    0, 0, 0, 1,
  ...]]></description><category></category></item><item><title><![CDATA[.net上传文件报413 Request Entity Too Large]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/106140892</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/106140892</guid><author>SunshineBlog</author><pubDate>Fri, 15 May 2020 14:13:00 +0800</pubDate><description><![CDATA[之前做项目遇到一个坑,上传大文件一直报413,最后在同事的帮助下终于解决了这个问题,详情如下：

在配置文件里面增加一下节点，友情提示：length的单位都为kb



&lt;system.webServer&gt;
    &lt;security&gt;
      &lt;requestFiltering&gt;
        &lt;requestLimits maxAllowedContentLength="2147483648"&gt;&lt;/requestLimits&gt;
    .]]></description><category></category></item><item><title><![CDATA[ZipOutputStream文件夹或文件中文乱码或出现下划线问题]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/106124570</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/106124570</guid><author>SunshineBlog</author><pubDate>Thu, 14 May 2020 17:25:31 +0800</pubDate><description><![CDATA[/*
      * 解决中文乱码问题
      *
      * ICSharpCode.SharpZipLib 0.86版本使用ZipConstants.DefaultCodePage
      * ZipConstants.DefaultCodePage = Encoding.GetEncoding("gbk").CodePage;
      * 
      * ICSharpCode.Shar...]]></description><category></category></item><item><title><![CDATA[.net 基础连接已经关闭: 发送时发生错误.]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/106124486</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/106124486</guid><author>SunshineBlog</author><pubDate>Thu, 14 May 2020 17:23:24 +0800</pubDate><description><![CDATA[WebClient 请求的时候出现 “基础连接已经关闭: 发送时发生错误” 问题




ServicePointManager.SecurityProtocol = (SecurityProtocolType)3072 | SecurityProtocolType.Ssl3 | SecurityProtocolType.Tls|SecurityProtocolType.Tls11;




]]></description><category></category></item><item><title><![CDATA[layui下拉框数据被遮住显示不出来的问题]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/105487315</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/105487315</guid><author>SunshineBlog</author><pubDate>Mon, 13 Apr 2020 13:55:48 +0800</pubDate><description><![CDATA[.layui-form-select dl {
      max-height: 200px;
    }


]]></description><category></category></item><item><title><![CDATA[pdf预览]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/105487096</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/105487096</guid><author>SunshineBlog</author><pubDate>Mon, 13 Apr 2020 13:45:01 +0800</pubDate><description><![CDATA[首先下载pdf.js插件，放到项目里面

官网下载地址：http://mozilla.github.io/pdf.js/getting_started/#download





在页面引入pdf.js，然后进行下图操作



&lt;button onclick="prepdf()"&gt;预览&lt;/button&gt;
&lt;script src="~/Scripts/jquer...]]></description><category></category></item><item><title><![CDATA[如何简单实现视频预览和图片预览]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/105482870</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/105482870</guid><author>SunshineBlog</author><pubDate>Mon, 13 Apr 2020 10:25:08 +0800</pubDate><description><![CDATA[工作需要做一个视频预览和图片预览，于是就发现了一个简单省事的预览方法，供大家参考一下，请多指教啊



    $("#preview").click(function () {
        var file = $("#ResUrl").val();//获取我那件路径
        if (file == null || file == "") {
            layer.m...]]></description><category></category></item><item><title><![CDATA[如何截取视频第一帧（含跨域问题）]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/105482257</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/105482257</guid><author>SunshineBlog</author><pubDate>Mon, 13 Apr 2020 10:11:27 +0800</pubDate><description><![CDATA[首选创建一个视频标签



&lt;video src="" name='VideoWay' id="video" controls="controls" &gt;&lt;/video&gt;


创建一个截取视频图片的方法




    function initialize() {
        var scale = 0.8;
        var video = documen...]]></description><category></category></item><item><title><![CDATA[excel帮助类（泛型和datatable）]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/105406919</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/105406919</guid><author>SunshineBlog</author><pubDate>Thu, 09 Apr 2020 11:44:21 +0800</pubDate><description><![CDATA[在做项目的过程中经常会遇到关于excel的导入和导出操作，所以就封装了一个excel帮助类来提升开发的速度。。。




using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using NPOI.HSSF.UserMo...]]></description><category></category></item><item><title><![CDATA[访问数据库的泛型封装类]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/105182400</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/105182400</guid><author>SunshineBlog</author><pubDate>Sun, 29 Mar 2020 17:33:40 +0800</pubDate><description><![CDATA[/// &lt;summary&gt;
        /// 新增
        /// &lt;/summary&gt;
        /// &lt;typeparam name="T"&gt;实体类&lt;/typeparam&gt;
        /// &lt;param name="t"&gt;对象&lt;/param&gt;
        /// &lt;param ...]]></description><category></category></item><item><title><![CDATA[redis帮助类]]></title><link>https://blog.youkuaiyun.com/SunshineBlog/article/details/103146250</link><guid>https://blog.youkuaiyun.com/SunshineBlog/article/details/103146250</guid><author>SunshineBlog</author><pubDate>Tue, 19 Nov 2019 16:55:58 +0800</pubDate><description><![CDATA[话不多说，上代码

第一种：多线程安全，线程不是每次都加锁，按需加载（懒汉模式）



using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

using System.Net.Http;
using static C...]]></description><category></category></item></channel></rss>