<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[diantingpi1639的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/diantingpi1639</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; diantingpi1639]]></copyright><item><title><![CDATA[sql时间操作]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431621</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431621</guid><author>diantingpi1639</author><pubDate>Fri, 26 Jul 2019 09:10:00 +0800</pubDate><description><![CDATA[select CONVERT(varchar, GETDATE(), 120)//当前时间：2019-07-26 08:58:09
select CONVERT(varchar(100), GETDATE(), 23)//当前时间：2019-07-26
select * from Smoke where datediff(day, dateadd(dd,0,addTime),ge...]]></description><category></category></item><item><title><![CDATA[IIS报500.19错误]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431620</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431620</guid><author>diantingpi1639</author><pubDate>Wed, 20 Feb 2019 20:19:00 +0800</pubDate><description><![CDATA[cmd执行以下代码

%windir%/system32/inetsrv/appcmd.exe set config -section:system.webServer/httpCompression /-[name='xpress']



转载于:https://www.cnblogs.com/hyyweb/p/10408986.html...]]></description><category></category></item><item><title><![CDATA[sql数据库常用分页存储过程]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431617</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431617</guid><author>diantingpi1639</author><pubDate>Wed, 13 Feb 2019 10:49:00 +0800</pubDate><description><![CDATA[go
create proc usp_dt_managerByPage
@pagesize int=10,
@pageindex int=1,
@recordcount int output,
@pagecount int output
as
begin
    select * 
    from (select *,rn=ROW_NUMBER() over(or...]]></description><category></category></item><item><title><![CDATA[如何让电脑内外网同时使用]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431618</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431618</guid><author>diantingpi1639</author><pubDate>Fri, 12 Jan 2018 09:39:00 +0800</pubDate><description><![CDATA[打开cmd；  route delete 0.0.0.0  初始化外网地址；
route add -p 0.0.0.0 mask 0.0.0.0 192.168.20.1  执行成功
这里需要变动的就是192.168.20.1，该地址是cmd中输入ipconfig ，自己电脑的外网的“默认网关”；
route add -p 192.168.2.0 mask 255.255....]]></description><category></category></item><item><title><![CDATA[Asp.net提供地址供下载文件]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431616</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431616</guid><author>diantingpi1639</author><pubDate>Wed, 11 Oct 2017 09:21:00 +0800</pubDate><description><![CDATA[关键代码

protected void Page_Load(object sender, EventArgs e)
    {
        string action=Request.QueryString["action"];
        if (!String.IsNullOrEmpty(action))
        {
            switc...]]></description><category></category></item><item><title><![CDATA[基于Asp.net下Excel批量导入SQLserver数据库]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431615</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431615</guid><author>diantingpi1639</author><pubDate>Tue, 10 Oct 2017 16:49:00 +0800</pubDate><description><![CDATA[关键代码

protected void Button1_Click(object sender, EventArgs e)
    {
        if (FileUpload1.HasFile == false)//HasFile用来检查FileUpload是否有指定文件
        {
            Response.Write("&lt;script...]]></description><category></category></item><item><title><![CDATA[js根据身份证获取性别，年龄，生日信息]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431435</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431435</guid><author>diantingpi1639</author><pubDate>Tue, 10 Oct 2017 16:27:00 +0800</pubDate><description><![CDATA[js关键代码

    &lt;script src="../scripts/jquery/jquery-1.10.2.min.js" type="text/javascript"&gt;&lt;/script&gt;
    &lt;script type="text/javascript"&gt;
        function IdCard(UUserCard, num)...]]></description><category></category></item><item><title><![CDATA[和中国移动对接短信平台]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431436</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431436</guid><author>diantingpi1639</author><pubDate>Tue, 02 May 2017 11:15:00 +0800</pubDate><description><![CDATA[项目需求
2017年4月12日，正式收到领导通知打算和中国移动对接短信平台，要做的项目当然就是给人发短信，这个短信平台和第三方提供的短信接口不同，这个平台可以二次开发，别人收到短信进行回复的话，我这边可以在数据库中收到相关数据。
开始对接
从4月12日开始，领导给我中国移动客户经理的电话，我就直接和经理联系，收到的反馈就是，目前工信部对单位发送群发短信必须加入白名单，白名单的意思就...]]></description><category></category></item><item><title><![CDATA[Android获取网络图片]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431432</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431432</guid><author>diantingpi1639</author><pubDate>Wed, 30 Nov 2016 15:57:00 +0800</pubDate><description><![CDATA[/**
 * 
 * 访问网络的操作，必须放在工作线程中完成
 *
 */
public class MainActivity extends Activity {
    static List&lt;HashMap&lt;String, String&gt;&gt; list;
    static List&lt;String&gt; userList2 = ne...]]></description><category></category></item><item><title><![CDATA[asp.net开发中遇到的奇葩bug及解决办法（会持续更新。。。）]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431433</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431433</guid><author>diantingpi1639</author><pubDate>Mon, 12 Sep 2016 18:00:00 +0800</pubDate><description><![CDATA[1，不知道你们遇没遇到过，在vs2010或更高版本上运行程序的时候，完全没问题，放在IIS中出现了问题，就比如左侧是菜单项，点击菜单右边显示，如果菜单链接是这样：content.aspx，而另一个链接是这样：manager/manager_list.aspx，在IIS中就会出现Session过期的问题，content.aspx页面根本无法接收到传过来的session值，因此会报sessi...]]></description><category></category></item><item><title><![CDATA[sql常用语句]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431614</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431614</guid><author>diantingpi1639</author><pubDate>Sat, 30 Jul 2016 08:36:00 +0800</pubDate><description><![CDATA[选择：select * from table1 where 范围
插入：insert into table1(field1,field2) values(value1,value2)
删除：delete from table1 where 范围
更新：update table1 set field1=value1 where 范围
查找：select * from table...]]></description><category></category></item><item><title><![CDATA[asp.net 一句话搞定分页]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431613</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431613</guid><author>diantingpi1639</author><pubDate>Sat, 30 Jul 2016 08:14:00 +0800</pubDate><description><![CDATA[rows 是客户端传过来的行数，page是页码，传参就需要就两个参数就行，sql语句中_row 和_page 自己声明的局部变量，值还是相应的row 和page ，为了运算而已。
用数据库类获得它的DataTable,转换为json格式通过一般处理程序传到客户端，客户端显示就ok了。这里我使用的是easyui datagrid进行接收和传参。这是大体的思路。
string sql =...]]></description><category></category></item><item><title><![CDATA[js实现对移动设备的检测]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431612</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431612</guid><author>diantingpi1639</author><pubDate>Thu, 21 Jul 2016 10:58:00 +0800</pubDate><description><![CDATA[&lt;script type="text/javascript"&gt;
    if (browserRedirect()) {        location.href = 'http:/phone.aspx';    }    /*工具类方法    ------------------------------------------------*/    //检测是否移动设备来...]]></description><category></category></item><item><title><![CDATA[asp.net 获取汉字字符串的拼音首字母，含多音字]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431610</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431610</guid><author>diantingpi1639</author><pubDate>Mon, 11 Apr 2016 14:39:00 +0800</pubDate><description><![CDATA[需求：在很多时候数据查询的时候，我们希望输入某个人姓名的拼音首字母进行查询，例如“潘长江”，输入“pcj”，就能搜索潘长江相关信息。
实现：

#region 获取汉字转换拼音 首字母
    public string MkPinyinString(string HanZiStr)
    //获取汉字字符串的拼音首字母，含多音字
    {
        int i,...]]></description><category></category></item><item><title><![CDATA[asp.net 时间操作]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431611</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431611</guid><author>diantingpi1639</author><pubDate>Mon, 11 Apr 2016 09:57:00 +0800</pubDate><description><![CDATA[　　　　/*在dt上加天数*/
        DateTime dt = DateTime.Now.AddDays(30);
        /*将指定的天数加到此实例的值上；
        即以当前日期为基础的情况下上加上30天。*/
        DateTime dt2 = DateTime.Now.AddDays(-30);/*以当前日期为基础的情况下上减去30...]]></description><category></category></item><item><title><![CDATA[Android TabHost使用]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431606</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431606</guid><author>diantingpi1639</author><pubDate>Wed, 06 Apr 2016 15:41:00 +0800</pubDate><description><![CDATA[TabHost是Android中自带的选项卡控件，效果图如下：

主布局文件

&lt;RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_w...]]></description><category></category></item><item><title><![CDATA[Android PreferenceFragment]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431609</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431609</guid><author>diantingpi1639</author><pubDate>Mon, 07 Mar 2016 10:18:00 +0800</pubDate><description><![CDATA[PreferenceFragment用来显示首选项的设置，效果图如下：


主布局文件：

&lt;RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:...]]></description><category></category></item><item><title><![CDATA[Android BadgeView使用]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431605</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431605</guid><author>diantingpi1639</author><pubDate>Mon, 07 Mar 2016 09:15:00 +0800</pubDate><description><![CDATA[BadgeView是第三方的插件，用来显示组件上面的标记，起到提醒的作用，下载地址如下：http://files.cnblogs.com/files/hyyweb/android-viewbadger.zip如示意图：

首先导入BadgeView的jar包到libs文件夹下，然后就可以使用它提供的类库了。核心代码如下：

package com.example.badgevi...]]></description><category></category></item><item><title><![CDATA[Android pulltorefresh使用]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431604</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431604</guid><author>diantingpi1639</author><pubDate>Fri, 26 Feb 2016 16:25:00 +0800</pubDate><description><![CDATA[pulltorefresh插件可以轻松实现上拉下拉刷新，github.com上直接搜索进行下载。
布局文件:

&lt;RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:ptr="http://schemas.android.com/apk/res-auto"
...]]></description><category></category></item><item><title><![CDATA[Android 利用xUtils框架实现对sqllite的增删改查]]></title><link>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431603</link><guid>https://blog.youkuaiyun.com/diantingpi1639/article/details/101431603</guid><author>diantingpi1639</author><pubDate>Fri, 26 Feb 2016 16:05:00 +0800</pubDate><description><![CDATA[首先下载xUtils，下载地址：https://github.com/wyouflf/xUtils 把下载好的文件压缩，把里面的jar包拷进项目中如图所示：

这里新建一个User类进行测试增删改查

package com.example.xutilsdemo;

public class User {
    private int id;
    private ...]]></description><category></category></item></channel></rss>