<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[bdbql的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/bdbql</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; bdbql]]></copyright><item><title><![CDATA[EF相关语句]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/78212617</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/78212617</guid><author>bdbql</author><pubDate>Thu, 12 Oct 2017 11:11:51 +0800</pubDate><description><![CDATA[添加数据库视图：Add-Migration updateview（视图名称）


更新数据库结构：Update-Database -Verbose]]></description><category></category></item><item><title><![CDATA[JS中的PadLeft、PadRight，位数不足，自动补位，String扩展方法]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/78125855</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/78125855</guid><author>bdbql</author><pubDate>Thu, 28 Sep 2017 17:08:42 +0800</pubDate><description><![CDATA[类似C#中的 PadLeft、PadRight 方法 //方法一
    function FillZero(p) {
        return new Array(3 - (p + '').length + 1).join('0') + p;
    }
    FillZero(6);    //输出006

    //方法一扩展（C#中PadLeft、PadRight）
    Str]]></description><category></category></item><item><title><![CDATA[SQL 利用游标循环添加数据]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/78095153</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/78095153</guid><author>bdbql</author><pubDate>Tue, 26 Sep 2017 14:44:36 +0800</pubDate><description><![CDATA[--查询数据
  select 
  Invest.UserId,
  BorrowReturn.RealReturnTime,
  Borrow.InvestType,
  case Borrow.InvestType 
  when 0 then '理财收益成功000,请注意查收'
  when 1 then '理财收益成功111,请注意查收'
  when 2 then '理财收益成功222]]></description><category></category></item><item><title><![CDATA[NopiHelper  Excel导出 导入]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/78082847</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/78082847</guid><author>bdbql</author><pubDate>Mon, 25 Sep 2017 10:48:08 +0800</pubDate><description><![CDATA[先上一个Helper类：
public class NopiHelper
    {
        public string DataTableToExcel(DataTable tempDataTable, string path, bool is2007 = true)
        {
            try
            {
                //创]]></description><category></category></item><item><title><![CDATA[对象转化成键值对]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/78053160</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/78053160</guid><author>bdbql</author><pubDate>Thu, 21 Sep 2017 16:05:09 +0800</pubDate><description><![CDATA[控制台程序：
class Program
    {
        static void Main(string[] args)
        {
            User u = new User();
            u.name = "ahbool";
            u.gender = "男";
            u.age = "1";

    ]]></description><category></category></item><item><title><![CDATA[MVC路由Route]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/77962513</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/77962513</guid><author>bdbql</author><pubDate>Wed, 13 Sep 2017 10:39:08 +0800</pubDate><description><![CDATA[控制器方法：
        public ActionResult Index(string controller, string action, int id)
        {
            ViewBag.Name1 = controller;
            ViewBag.Name2 = action;
            ViewBag.Name3 = id]]></description><category></category></item><item><title><![CDATA[Sql 语句之获取年月、年月日]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/60580499</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/60580499</guid><author>bdbql</author><pubDate>Mon, 06 Mar 2017 16:04:06 +0800</pubDate><description><![CDATA[1.获取年月日
select CONVERT(varchar(100), GETDATE(), 23)

输出 2017-03-06
2.获取年月
select CONVERT(varchar(7), GETDATE(), 120)

输出 2017-03]]></description><category></category></item><item><title><![CDATA[jQuery 选择器大全总结]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/56011958</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/56011958</guid><author>bdbql</author><pubDate>Mon, 20 Feb 2017 13:26:38 +0800</pubDate><description><![CDATA[本文转载于http://www.html5wd.com/archives/2232.html，谢谢]]></description><category></category></item><item><title><![CDATA[WebApi生成接口文档]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/54376141</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/54376141</guid><author>bdbql</author><pubDate>Thu, 12 Jan 2017 11:09:43 +0800</pubDate><description><![CDATA[1.修改文件：
Areas>HelpPage>App_Start>HelpPageConfig.cs



            config.SetDocumentationProvider(new XmlDocumentationProvider(HttpContext.Current.Server.MapPath("~/App_Data/XmlDocument.xml")));]]></description><category></category></item><item><title><![CDATA[获取客户端Mac地址]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/52440113</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/52440113</guid><author>bdbql</author><pubDate>Mon, 05 Sep 2016 14:44:09 +0800</pubDate><description><![CDATA[/// 
        /// 返回IP地址的MAC地址
        /// 
        /// 
        /// 
        /// 
        /// 
        /// 
        [DllImport("Iphlpapi.dll")]
        private static extern int SendARP(Int32 dest, In]]></description><category></category></item><item><title><![CDATA[多查询条件的MVC分页]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/51952859</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/51952859</guid><author>bdbql</author><pubDate>Tue, 19 Jul 2016 09:41:30 +0800</pubDate><description><![CDATA[1、查询
    
        @using (Ajax.BeginForm("方法", "控制器",
                new RouteValueDictionary { { "id", "" } }, new AjaxOptions()
                {
                    HttpMethod = "Get",
          ]]></description><category></category></item><item><title><![CDATA[MVC复选框选中方法]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/51952769</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/51952769</guid><author>bdbql</author><pubDate>Tue, 19 Jul 2016 09:36:05 +0800</pubDate><description><![CDATA[1、Model类
    public class News
    {
        public int ID { get; set; }
        public string Name { get; set; }

    }
2、Controller返回数据
        private List GetALL()
        {
            List li]]></description><category></category></item><item><title><![CDATA[模拟Http登录]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/51488088</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/51488088</guid><author>bdbql</author><pubDate>Tue, 24 May 2016 10:28:49 +0800</pubDate><description><![CDATA[class Program
    {	//Cookie
        private static CookieContainer m_Cookie = new CookieContainer();
        static void Main(string[] args)
        {
            try
            {]]></description><category></category></item><item><title><![CDATA[WebApi 跨域调用]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/51184592</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/51184592</guid><author>bdbql</author><pubDate>Mon, 18 Apr 2016 23:19:00 +0800</pubDate><description><![CDATA[1.WebAPI添加类库引用


2.WebApiConfig添加
config.EnableCors(new EnableCorsAttribute("*", "*", "*"));
3.控制器示例 
namespace WebApiTest.Controllers
{
    [EnableCors("*", "*", "*")]
    public class UserMode]]></description><category></category></item><item><title><![CDATA[Mapper映射]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/48317367</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/48317367</guid><author>bdbql</author><pubDate>Wed, 09 Sep 2015 16:07:41 +0800</pubDate><description><![CDATA[Mapper.CreateMap();
var borrowListReturn = Mapper.Map, List>(borrowList);]]></description><category></category></item><item><title><![CDATA[利用list的Contains判断是否包含]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/46603759</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/46603759</guid><author>bdbql</author><pubDate>Tue, 23 Jun 2015 11:15:51 +0800</pubDate><description><![CDATA[1.如果为实体类型
//实体类型
            var stu = new Student() {StudentId = 1, StudentName = "aaaaa"};
            if (list.Contains(stu))
            {
                Console.WriteLine("实体类型包含");
           ]]></description><category></category></item><item><title><![CDATA[ADO.NET 备份还原数据库]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/46519827</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/46519827</guid><author>bdbql</author><pubDate>Tue, 16 Jun 2015 16:29:25 +0800</pubDate><description><![CDATA[献给需要的人和我自己]]></description><category></category></item><item><title><![CDATA[Chart 图表 柱图]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/44304265</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/44304265</guid><author>bdbql</author><pubDate>Mon, 16 Mar 2015 13:37:19 +0800</pubDate><description><![CDATA[以下是一些关于柱图的显示代码：
                    MyChart.Series.Clear(); //Chart var series = new Series(); series.Label = "#VAL"; series.LegendText = "金额（单位：元）"; series.Color = Color.Green; series.YValueMembers]]></description><category></category></item><item><title><![CDATA[Chart 图表 饼图]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/44304143</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/44304143</guid><author>bdbql</author><pubDate>Mon, 16 Mar 2015 13:28:33 +0800</pubDate><description><![CDATA[以下是一些关于饼图的显示代码]]></description><category></category></item><item><title><![CDATA[不常用的数据库操作整理]]></title><link>https://blog.youkuaiyun.com/bdbql/article/details/44154623</link><guid>https://blog.youkuaiyun.com/bdbql/article/details/44154623</guid><author>bdbql</author><pubDate>Mon, 09 Mar 2015 14:40:40 +0800</pubDate><description><![CDATA[1.通配符的使用：
“_” 仅替代一个字符

示例：
SELECT * FROM Persons WHERE FirstName LIKE '_eorge'


SELECT * FROM Persons WHERE LastName LIKE 'C_r_er'


“[charlist]” 字符列中的任何单一字符
示例：

SELECT * FROM Persons W]]></description><category></category></item></channel></rss>