<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ditong5719的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ditong5719</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ditong5719]]></copyright><item><title><![CDATA[C# 深拷贝]]></title><link>https://blog.youkuaiyun.com/ditong5719/article/details/102379489</link><guid>https://blog.youkuaiyun.com/ditong5719/article/details/102379489</guid><author>ditong5719</author><pubDate>Fri, 06 Sep 2019 16:45:00 +0800</pubDate><description><![CDATA[public static T DeepClone&lt;T&gt;(T obj)
{
 using (var ms = new MemoryStream())
 {
   var formatter = new BinaryFormatter();
   formatter.Serialize(ms, obj);
   ms.Position = 0;

   re...]]></description><category></category></item><item><title><![CDATA[.net 修改app.config自定义配置节点]]></title><link>https://blog.youkuaiyun.com/ditong5719/article/details/102379487</link><guid>https://blog.youkuaiyun.com/ditong5719/article/details/102379487</guid><author>ditong5719</author><pubDate>Thu, 10 May 2018 14:00:00 +0800</pubDate><description><![CDATA[&lt;?xml version="1.0" encoding="utf-8" ?&gt;&lt;!-- 样本 --&gt;
&lt;configuration&gt;
    &lt;configSections&gt;
        &lt;sectionGroup name="geoSettings"&gt;
            &lt;section name=...]]></description><category></category></item><item><title><![CDATA[oracle查询中over(partition by ...order by ...)用法]]></title><link>https://blog.youkuaiyun.com/ditong5719/article/details/102379490</link><guid>https://blog.youkuaiyun.com/ditong5719/article/details/102379490</guid><author>ditong5719</author><pubDate>Mon, 05 Mar 2018 15:56:00 +0800</pubDate><description><![CDATA[例：
rank()over(partitionby deptnoorderby saldesc)rank
解释：
deptno -- 部门， sal -- 工资
over:在什么条件之上。partition by e.deptno:按部门编号划分（分区）。order by e.sal desc:按工资从高到低排序（使用rank()/dense_rank(...]]></description><category></category></item><item><title><![CDATA[ORACLE按每月、每周关联数据表]]></title><link>https://blog.youkuaiyun.com/ditong5719/article/details/102379484</link><guid>https://blog.youkuaiyun.com/ditong5719/article/details/102379484</guid><author>ditong5719</author><pubDate>Thu, 07 Dec 2017 11:35:00 +0800</pubDate><description><![CDATA[-- 时间段内的每个月份，{0}：开始日期，{1}：结束日期
SELECT TO_CHAR(ADD_MONTHS(TO_DATE('{0}', 'YYYY-MM'), ROWNUM - 1),
                           'YYYYMM') AS MONTHLIST
              FROM DUAL
            CONNEC...]]></description><category></category></item><item><title><![CDATA[打印html5中Canvas的方法]]></title><link>https://blog.youkuaiyun.com/ditong5719/article/details/102379488</link><guid>https://blog.youkuaiyun.com/ditong5719/article/details/102379488</guid><author>ditong5719</author><pubDate>Sun, 23 Apr 2017 10:58:00 +0800</pubDate><description><![CDATA[function print_voucher(){ // 打印的主要方法
    var win=window.open();
    win.document.write("&lt;br&gt;&lt;img src='"+canvas.toDataURL()+"'/&gt;");
    win.print();
    win.location.reload();
}...]]></description><category></category></item><item><title><![CDATA[记录一个表，COUNT多列的写法]]></title><link>https://blog.youkuaiyun.com/ditong5719/article/details/102379485</link><guid>https://blog.youkuaiyun.com/ditong5719/article/details/102379485</guid><author>ditong5719</author><pubDate>Wed, 12 Apr 2017 14:15:00 +0800</pubDate><description><![CDATA[笔记
DHS_CARDIOVASCULAR_SCREENING 为病人数据表，需要查出糖尿病、高血压、脑卒中家族史的病人各有多少个。
SELECT        COUNT(D.ID) AS TOTAL,         COUNT(CASE                 WHEN D.DIABETES = '1' THEN                  'DIABETES'...]]></description><category></category></item></channel></rss>