<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Todd Li的博客]]></title><description><![CDATA[没啥养分的博客...]]></description><link>https://blog.youkuaiyun.com/qq_35309370</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_35309370]]></copyright><item><title><![CDATA[使用in影响效率问题]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/89740731</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/89740731</guid><author>qq_35309370</author><pubDate>Wed, 01 May 2019 21:26:47 +0800</pubDate><description><![CDATA[sql中使用in影响效率 可以这么用 （使用1方法解决的前提是 主查询语句中也得有top ）

1、 where account_id in(select top 10000 account_id from uf_customer_user where user_id = '10448')

加一个top 可能会更快

2、加order by

where account_id in(sele...]]></description><category></category></item><item><title><![CDATA[js 获取当前时间  格式是  2019-04-18 11:03:46]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/89370701</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/89370701</guid><author>qq_35309370</author><pubDate>Thu, 18 Apr 2019 08:45:28 +0800</pubDate><description><![CDATA[function CurentTime()
 {
 var now = new Date();
 
 var year = now.getFullYear(); //年
 var month = now.getMonth() + 1; //月
 var day = now.getDate();...]]></description><category></category></item><item><title><![CDATA[父子元素的点击关联]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/86517455</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/86517455</guid><author>qq_35309370</author><pubDate>Thu, 17 Jan 2019 08:14:22 +0800</pubDate><description><![CDATA[点击父节点不会触发子元素的点击事件

点击子节点会触发父元素的点击事件（冒泡）

 

 

&amp;lt;html&amp;gt;

&amp;lt;head&amp;gt;
&amp;lt;title&amp;gt;我的第一个 HTML 页面&amp;lt;/title&amp;gt;

&amp;lt;/head&amp;gt;

&amp;lt;body&amp;gt;
&amp;lt;div class=&quot;a&quot; onclick=&quot;alert('父亲')&quot;&]]></description><category></category></item><item><title><![CDATA[在 body 下只有一个 div时如何让其铺满屏幕]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/86487870</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/86487870</guid><author>qq_35309370</author><pubDate>Tue, 15 Jan 2019 10:07:18 +0800</pubDate><description><![CDATA[https://www.cnblogs.com/cnyaokai/p/6512519.html]]></description><category></category></item><item><title><![CDATA[推荐一个很好用的企业微信的SDK C#版本的]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/85234987</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/85234987</guid><author>qq_35309370</author><pubDate>Mon, 24 Dec 2018 16:13:31 +0800</pubDate><description><![CDATA[NUGET包直接搜 WeixinSDK.Work]]></description><category></category></item><item><title><![CDATA[sqlserver开启事务并打印错误信息]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/85197983</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/85197983</guid><author>qq_35309370</author><pubDate>Sat, 22 Dec 2018 10:39:44 +0800</pubDate><description><![CDATA[ BEGIN  
        SET NOCOUNT ON;
        BEGIN TRY
            BEGIN TRANSACTION train;
            
            COMMIT TRANSACTION train;
        END TRY
        BEGIN CATCH    ;
            PRINT ER...]]></description><category></category></item><item><title><![CDATA[js根据多字段进行排序]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/85158090</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/85158090</guid><author>qq_35309370</author><pubDate>Fri, 21 Dec 2018 10:36:07 +0800</pubDate><description><![CDATA[//测试数据
var items = [{
    name: &quot;linc&quot;,
    age: 28,
    num: 1234
}, {
    name: &quot;linc&quot;,
    age: 28,
    num: 12345
}, {
    name: &quot;kiki&quot;,
    age: 20,
    num: 12345
}, {
    name: &quot;高峰&quot;,
    age: 2...]]></description><category></category></item><item><title><![CDATA[JS根据一个列表填写的数据 汇总第二个列表的数据]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/85157725</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/85157725</guid><author>qq_35309370</author><pubDate>Fri, 21 Dec 2018 10:28:31 +0800</pubDate><description><![CDATA[     dest = [];
        var count = bodys0.getCount();
        for(var i=0;i&amp;lt;count;i++){
             var item = bodys0.getAt(i);
             dest.push({
                        vendercname: item....]]></description><category></category></item><item><title><![CDATA[js 数字比较 Number 与ParseInt]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/84787296</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/84787296</guid><author>qq_35309370</author><pubDate>Tue, 04 Dec 2018 13:52:32 +0800</pubDate><description><![CDATA[先，解释一下定义的区别：

parseInt将字符串(String)类型转为  整数类型。
Number() 函数把对象(Object)的值转换为 数字。

parseInt(&quot;10.2&quot;) 返回 10

Number(&quot;10.2&quot;) 返回10.2

 

Number(&quot; &quot;) 或者 Number(null) 都是返回0

parseInt(&quot; &quot;) 或者 parseInt(null) 则都返回...]]></description><category></category></item><item><title><![CDATA[ODBC安装 sqlserver连接服务器mysql]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/82892937</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/82892937</guid><author>qq_35309370</author><pubDate>Sat, 29 Sep 2018 09:39:06 +0800</pubDate><description><![CDATA[ mysql ODBC 5.2版本：https://dev.mysql.com/downloads/file/?id=452090

vc++2010环境安装：http://www.microsoft.com/en-us/download/confirmation.aspx?id=14632

注意：ODBC版本与vc++版本是需要对应的  之前因为8.0版本需要安装VC++2015 但是电脑很久...]]></description><category></category></item><item><title><![CDATA[office下载]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/82840760</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/82840760</guid><author>qq_35309370</author><pubDate>Tue, 25 Sep 2018 16:06:58 +0800</pubDate><description><![CDATA[https://www.lanzous.com/i1gm3li]]></description><category></category></item><item><title><![CDATA[VS2017新建项目没有windows服务选项]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/82838753</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/82838753</guid><author>qq_35309370</author><pubDate>Tue, 25 Sep 2018 14:15:53 +0800</pubDate><description><![CDATA[​​​]]></description><category></category></item><item><title><![CDATA[Dapper的基本使用]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/80927435</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/80927435</guid><author>qq_35309370</author><pubDate>Thu, 05 Jul 2018 15:12:13 +0800</pubDate><description><![CDATA[Dapper是.NET下一个micro的ORM，它和Entity Framework或Nhibnate不同，属于轻量级的，并且是半自动的。也就是说实体类都要自己写。它没有复杂的配置文件，一个单文件就可以了。给出官方地址。http://code.google.com/p/dapper-dot-net/个人觉得他非常好用，现在已经取代了原来的SqlHelper。优点：使用Dapper可以自动进行对象映...]]></description><category></category></item><item><title><![CDATA[sqlserver直接在sql里模糊查询]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/80831701</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/80831701</guid><author>qq_35309370</author><pubDate>Wed, 27 Jun 2018 16:50:09 +0800</pubDate><description><![CDATA[USE [toponline]GO/****** Object:  StoredProcedure [dbo].[procT_StudentStudyRecordGetPagedDataList]    Script Date: 2018/6/27 16:48:49 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGO-- ===========...]]></description><category></category></item><item><title><![CDATA[清除VS上登陆的git账号]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/80737091</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/80737091</guid><author>qq_35309370</author><pubDate>Tue, 19 Jun 2018 17:48:24 +0800</pubDate><description><![CDATA[可以删除或者修改对应网址下登陆的账号]]></description><category></category></item><item><title><![CDATA[代码加锁]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/80576307</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/80576307</guid><author>qq_35309370</author><pubDate>Tue, 05 Jun 2018 09:13:45 +0800</pubDate><description><![CDATA[ private static object locker = new object();lock (locker)   {xxxxxx}]]></description><category></category></item><item><title><![CDATA[C#调用腾讯云图片鉴黄]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/80422186</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/80422186</guid><author>qq_35309370</author><pubDate>Wed, 23 May 2018 17:00:46 +0800</pubDate><description><![CDATA[废话不多说 直接上代码这里使用的是人工智能里面的智能图像--万象优图 没有用天御的（太贵了） 首先要开通智能图像的功能注意：这里要绑定Bucket     使用主账号的appid，不是协作者的            var urlList = new List&amp;lt;string&amp;gt;();            urlList.Add(url);            //请求参数      ...]]></description><category></category></item><item><title><![CDATA[C# WebApi导出Excel 直接返回一个远程Excel地址 链接访问下载]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/80421878</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/80421878</guid><author>qq_35309370</author><pubDate>Wed, 23 May 2018 16:32:14 +0800</pubDate><description><![CDATA[        /// &amp;lt;summary&amp;gt;        /// 导出方案列表        /// &amp;lt;/summary&amp;gt;        [HttpGet, HttpPost]        public Object ExportProgramme(ExportProgrammeReq req)        {            var virtualPath = ...]]></description><category></category></item><item><title><![CDATA[C#使用微信内容安全接口之图片鉴黄]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/80421399</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/80421399</guid><author>qq_35309370</author><pubDate>Wed, 23 May 2018 16:20:44 +0800</pubDate><description><![CDATA[这他么绝对是个坑 草！！！！微信的文档实在是太简练（Fuck）了正言开始：他官方只给了PHP的DemoC#网上找了些方法 不知道在WEBAPI里面怎么将图片用form-data请求所以直接装了个Curl 通过cmd隐形命令调用的 此方法可行！下面是步骤：1、先下载安装包 然后安装 下载地址在这里：https://curl.haxx.se/download.html 64位的下载如下图安装包（直接拉...]]></description><category></category></item><item><title><![CDATA[数据库索引、查询优化、死锁]]></title><link>https://blog.youkuaiyun.com/qq_35309370/article/details/80307366</link><guid>https://blog.youkuaiyun.com/qq_35309370/article/details/80307366</guid><author>qq_35309370</author><pubDate>Mon, 14 May 2018 11:28:33 +0800</pubDate><description><![CDATA[数据库聚集索引与非聚集索引根本区别在于：表记录的排列顺序和索引的排列顺序是否一致  然后插入一条数据  给A字段创建聚集索引 删除聚集索引 创建非聚集索引 然后插入数据 效果对比：循环插入100条数据执行计划对比：非聚集索引聚集索引： 读取对比：非聚集索引：聚集索引：数据增加到一千条之后 非聚集索引：聚集索引： 查询优化：1、尽量避免在WHERE 后面使用OR连接 如果其中一个不是索引键 会进行全...]]></description><category></category></item></channel></rss>