<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[code旅行者的专栏]]></title><description><![CDATA[在代码世界旅行～]]></description><link>https://blog.youkuaiyun.com/dotNET25</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; dotNET25]]></copyright><item><title><![CDATA[mysql数据库group_concat函数内包含case when 语法时的使用]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/52610436</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/52610436</guid><author>dotNET25</author><pubDate>Wed, 21 Sep 2016 17:27:33 +0800</pubDate><description><![CDATA[select `a`.`tdorderid`,group_concat('类型：',(case `a`.`td_type` when 'no_goods' then '无货退款' when 'low_quantity' then '质量退款' when 'no_reason' then '非质量退款' else '无' end),'/退货员：',
(case when`a`.`td_user`]]></description><category></category></item><item><title><![CDATA[mysql性能优化验分享]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/52222532</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/52222532</guid><author>dotNET25</author><pubDate>Tue, 16 Aug 2016 16:36:42 +0800</pubDate><description><![CDATA[我的一个月结统计报表已经优化，性能提升了10~15倍，原先计算1天需要10~15秒，现在只需1秒。计算一个月的数据原先超过180秒，服务器超时，现在也在15~20秒以内完成。


优化思想是多表join的时候，先对数据进行筛选，用尽可能少的数据 join。


例如：
表join之前先用where过滤数据（性能高）：
(select * from gr_sp_order o whe]]></description><category></category></item><item><title><![CDATA[Mysql条件判断语法]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/50214355</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/50214355</guid><author>dotNET25</author><pubDate>Tue, 08 Dec 2015 09:06:38 +0800</pubDate><description><![CDATA[select orderid AS 订单编号, case type when 11 then '退货' when 12 then '换货' else '非退换货' end as 类型,finalAmount AS 金额 from table


注意：else   end 不能少，否则语法错误，与sqlserver不同。]]></description><category></category></item><item><title><![CDATA[从外网站点获取的html去除换行回车制表位\n\r\t]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/46890163</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/46890163</guid><author>dotNET25</author><pubDate>Wed, 15 Jul 2015 11:01:35 +0800</pubDate><description><![CDATA[StringStr.Replace("\\r", "").Replace("\\n", "").Replace("\\t", "")//--错误，去除不掉


StringStr.Replace('\n', ' ').Replace('\t', ' ').Replace('\r', ' ');//正确]]></description><category></category></item><item><title><![CDATA[sql server2008R2自动备份和自动删除过期bak文件]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/42741411</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/42741411</guid><author>dotNET25</author><pubDate>Thu, 15 Jan 2015 15:26:30 +0800</pubDate><description><![CDATA[点击下一步：


自定义名称和说明，点击更改：

点击确定，下一步




1、备份：
选择备份，下一步，再下一步，选择需要备份的数据库：

选择备份文件存放的路径：

点击下一步，选择系统产生的报告存放的位置：

最后点击下一步，点击完成。
看到这个表示任务已经指定完毕：



2、删除备份文件：

下一步，完成。]]></description><category></category></item><item><title><![CDATA[html5学习笔记1]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/42492379</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/42492379</guid><author>dotNET25</author><pubDate>Wed, 07 Jan 2015 14:53:30 +0800</pubDate><description><![CDATA[Your browser does not support the canvas element.




var c=document.getElementById("myCanvas");
var cxt=c.getContext("2d");
cxt.moveTo(10,10);
cxt.lineTo(150,50);
cxt.lineTo(0,50);
cxt.lineTo(70,80);]]></description><category></category></item><item><title><![CDATA[Entity Framework 上下文在C#事务中间使用时，通过递归方法引入新构造的上下文访问入口导致错误]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/41649795</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/41649795</guid><author>dotNET25</author><pubDate>Mon, 01 Dec 2014 17:16:36 +0800</pubDate><description><![CDATA[dbEntery.Connection.Open();
                    using (var trains = dbEntery.Connection.BeginTransaction())
                    {
                        try
                        {
                ]]></description><category></category></item><item><title><![CDATA[sql存储过程参数不填写时的正确写法]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/38901681</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/38901681</guid><author>dotNET25</author><pubDate>Thu, 28 Aug 2014 18:15:16 +0800</pubDate><description><![CDATA[AND ((1=1 and @scoreType  = NULL  )or(@scoreType != NULL and ss.scoreType=@scoreType)) 错误！]]></description><category></category></item><item><title><![CDATA[Entity Framework 无法加载指定的元数据资源。]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/35986585</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/35986585</guid><author>dotNET25</author><pubDate>Mon, 30 Jun 2014 10:28:15 +0800</pubDate><description><![CDATA[看下config文件中的连接串的
.csdl|res://*/Entity.AllData.ssdl|res://*/Entity.AllData.msl;]]></description><category></category></item><item><title><![CDATA[table-layout :fixed   white-space: nowrap  word-break:break-all和word-wrap:break-word]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/26677289</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/26677289</guid><author>dotNET25</author><pubDate>Fri, 23 May 2014 10:20:42 +0800</pubDate><description><![CDATA[设置表格布局算法：
table
  {
  table-layout:fixed;
  }

亲自试一试

浏览器支持



IE
Firefox
Chrome
Safari
Opera


 
 
 
 
 



所有浏览器都支持 table-layout 属性。
注释：任何的版本的 Internet Explorer （包括 IE8）都不支持属]]></description><category></category></item><item><title><![CDATA[本地windows7系统导入word（或excel）正常，在部署到服务器window2003系统上不能导入的处理]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/26495189</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/26495189</guid><author>dotNET25</author><pubDate>Wed, 21 May 2014 17:37:51 +0800</pubDate><description><![CDATA[本地windows7系统导入正常，在部署到服务器window2003系统上不能导入并有如下报错：
 
检索 COM 类工厂中CLSID 为 {000209FF-0000-0000-C000-000000000046} 的组件时失败，原因是出现以下错误:80070005。
 
具体解决方法如下:
1:在服务器上安装office的word软件.
2:在"开始"->"运行"中输入dcomcn]]></description><category></category></item><item><title><![CDATA[在页面上显示数据库查询条件的替换功能（具体字符串只作举例）]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/24780971</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/24780971</guid><author>dotNET25</author><pubDate>Wed, 30 Apr 2014 14:01:35 +0800</pubDate><description><![CDATA[var getCondition = function () {
    $.ajax({
        type: "POST",
        dataType: "text",
        url: 'ashx/Handler.ashx', //目标地址
        data: "op=getCondition",
        async: false, //置为同步
   ]]></description><category></category></item><item><title><![CDATA[特殊字符在数据库查询前的处理]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/24780531</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/24780531</guid><author>dotNET25</author><pubDate>Wed, 30 Apr 2014 11:54:55 +0800</pubDate><description><![CDATA[Server.UrlDecode(context.Request.Form["condition"] == null ? "" : context.Request.Form["condition"].ToString());]]></description><category></category></item><item><title><![CDATA[js备忘]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/24767089</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/24767089</guid><author>dotNET25</author><pubDate>Wed, 30 Apr 2014 09:08:37 +0800</pubDate><description><![CDATA[var str = res.match(/文献类型 类似 "\d+"/g);//

            var num = str[0].substring(9, 13);]]></description><category></category></item><item><title><![CDATA[特殊字符导致json字符串转换成json对象出错]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/24475437</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/24475437</guid><author>dotNET25</author><pubDate>Fri, 25 Apr 2014 15:42:58 +0800</pubDate><description><![CDATA[在对数据库取出来的数据（特别是描述信息）里面含有特殊字符的话，使用JSON.parse将json字符串转换成json对象的时候会出错，主要是双引号，回车换行等影响明显，左尖括号和右尖括号也会导致显示问题，所以要在输出到页面之前将一些特殊符合进行编码或转义，下面展示的是C#代码编码和转义几个常用特殊字符。经过笔者测试，将这些符号编码和转义之后，大部分json字符串都可以转换成json对象了。如果遇到]]></description><category></category></item><item><title><![CDATA[解决子级用css float浮动 而父级div没高度不能自适应高度]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/24265363</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/24265363</guid><author>dotNET25</author><pubDate>Mon, 21 Apr 2014 17:27:46 +0800</pubDate><description><![CDATA[http://www.divcss5.com/jiqiao/j612.shtml]]></description><category></category></item><item><title><![CDATA[IE6/IE7下float:right的导致元素换行显示]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/24239867</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/24239867</guid><author>dotNET25</author><pubDate>Mon, 21 Apr 2014 11:25:43 +0800</pubDate><description><![CDATA[http://blog.youkuaiyun.com/freshlover/article/details/7531931]]></description><category></category></item><item><title><![CDATA[待验证问题和注意点]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/23372635</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/23372635</guid><author>dotNET25</author><pubDate>Thu, 10 Apr 2014 17:58:32 +0800</pubDate><description><![CDATA[IE6，7，8当页面出现滚动条的时候会出发window.resize()方法，待验证]]></description><category></category></item><item><title><![CDATA[type="text/javascript" type="application/javascript"]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/23359601</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/23359601</guid><author>dotNET25</author><pubDate>Thu, 10 Apr 2014 15:47:55 +0800</pubDate><description><![CDATA[`type="text/javascript"` 是比较老的写法
IETF 推荐的是 `type="application/javascript"`
实际上这两种没什么大区别，只是不同浏览器的支持不一样。]]></description><category></category></item><item><title><![CDATA[让页面出现滚动条的时候，滚动条不影响页面宽度]]></title><link>https://blog.youkuaiyun.com/dotNET25/article/details/23344187</link><guid>https://blog.youkuaiyun.com/dotNET25/article/details/23344187</guid><author>dotNET25</author><pubDate>Thu, 10 Apr 2014 12:01:07 +0800</pubDate><description><![CDATA[设置body的宽度
$("body").css("width", $(window).width());]]></description><category></category></item></channel></rss>