<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[killcwd的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/killcwd</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; killcwd]]></copyright><item><title><![CDATA[abp构建Web API服务]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/52044799</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/52044799</guid><author>killcwd</author><pubDate>Wed, 27 Jul 2016 13:49:29 +0800</pubDate><description><![CDATA[构建动态Web API控制器

ABP可以自动地为应用层生成Web API 层。比如说我们之前创建的应用层：


namespace Noah.ChargeStation.Application.CitiesApp
{
    public interface ICityAppService:IApplicationService
    {
        GetCitiesOutpu]]></description><category></category></item><item><title><![CDATA[EF Code First Migrations数据库迁移]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/52023226</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/52023226</guid><author>killcwd</author><pubDate>Mon, 25 Jul 2016 14:17:43 +0800</pubDate><description><![CDATA[1、EF Code First创建数据库

　　新建控制台应用程序Portal，通过程序包管理器控制台添加EntityFramework。

　　在程序包管理器控制台中执行以下语句，安装EntityFramework。

PM> Install-Package EntityFramework


　　安装成功后，界面提示如下图：



 　　在新建的Portal控制台应用]]></description><category></category></item><item><title><![CDATA[<Entity Framework> - 直接执行数据库命令]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/52022372</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/52022372</guid><author>killcwd</author><pubDate>Mon, 25 Jul 2016 11:48:33 +0800</pubDate><description><![CDATA[原文地址: http://msdn.microsoft.com/en-us/library/gg715124(v=vs.103)

 

使用 EF 4.1 或者更新版本, 你可以直接执行任何数据库命令. 在本节介绍的方法允许你对数据库执行原生的 SQL 命令.

 

通过 SQL 查询语句获取实体对象集

DbSet 类中的 SqlQuery 方法允许你执行一个返回实体对象]]></description><category></category></item><item><title><![CDATA[EntityFramework执行SQL语句]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/52021872</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/52021872</guid><author>killcwd</author><pubDate>Mon, 25 Jul 2016 11:16:09 +0800</pubDate><description><![CDATA[在EF中执行Sql语句。

Insert Code:
using (var context = new EFRecipesEntities())
{
   string sql = @"insert into Chapter3.Payment(Amount, Vendor)
                     values (@Amount, @Vendor)";
   var]]></description><category></category></item><item><title><![CDATA[手把手教你:让EF动态支持新增表、动态支持多数据库]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/52021125</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/52021125</guid><author>killcwd</author><pubDate>Mon, 25 Jul 2016 10:16:18 +0800</pubDate><description><![CDATA[名词解释：此动态非运行时动态，让EF动态支持新增表、动态切换数据库意在不改变项目核心框架，

通过新增或者替换组件的方式达到标题目地。

 

一、先来点简单的，动态支持多数据库

AppDbContext实现：

public class AppDbContext:DbContext
    {
        public AppDbContext(string con]]></description><category></category></item><item><title><![CDATA[为什么Entity Framework不能进行跨数据库查询]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/52020990</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/52020990</guid><author>killcwd</author><pubDate>Mon, 25 Jul 2016 10:01:04 +0800</pubDate><description><![CDATA[在上篇随笔中提到“对于跨数据库查询，我们没有找到通过LINQ to Entities实现的方法”。后来仔细想想，从理论来讲，实现跨数据库查询应该不难啊，与非跨数据库查询相比，只是多了个数据库名，比如下面的非跨数据库查询语句：

SELECT  [Text]  FROM dbo.blog_PostBody WHERE ID=3560


跨数据库查询语句：

SELECT  [Text]]></description><category></category></item><item><title><![CDATA[在ABP中通过EF直接执行原生Sql的解决方案]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51984425</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51984425</guid><author>killcwd</author><pubDate>Thu, 21 Jul 2016 16:49:03 +0800</pubDate><description><![CDATA[一般情况下，使用EF中的查询语法和方法语法可以帮助我们完成绝大部分业务，但是也有特殊的情况需要直接执行Sql语句。比如，我们的业务过于复杂繁琐，或是有些业务使用EF操作时比较复杂，但是使用Sql时会很简单等等。
今天做项目的时候，就由于使用EF来处理逻辑时格外棘手，最终选择了直接执行Sql语句，下面说说具体的业务。
一共关系到三张表，分别是Operators(运营商表)，Orders(订单表)]]></description><category></category></item><item><title><![CDATA[判断table同一列数据是否有重复]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51943536</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51943536</guid><author>killcwd</author><pubDate>Mon, 18 Jul 2016 17:05:59 +0800</pubDate><description><![CDATA[下面的方法，是将一列的内容放到一个数组中，通过$.unique()函数对数组进行去重，根据去重前后数组的长度来判断是否存在数据重复。


function hasRepeat(objId,columnIndex){

     var arr = [];

     $("#"+objId+" tbody tr").each(function(){

        arr.pu]]></description><category></category></item><item><title><![CDATA[table]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51922766</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51922766</guid><author>killcwd</author><pubDate>Sat, 16 Jul 2016 09:37:03 +0800</pubDate><description><![CDATA[$('#editabledatatable').on("click", 'a.delete', function(e) {
                e.preventDefault();


                if (confirm("确定要删除此行?") == false) {
                    return;
              ]]></description><category></category></item><item><title><![CDATA[Jquery DataTables 获取表格数据及选中行数据]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51922642</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51922642</guid><author>killcwd</author><pubDate>Sat, 16 Jul 2016 09:13:15 +0800</pubDate><description><![CDATA[1.获取表格所有数据









1

function getTableContent(){









2

       var nTrs
 = table.fnGetNodes();//fnGetNodes获取表格所有行，nTrs[i]表示第i行tr对象









3

       for(va]]></description><category></category></item><item><title><![CDATA[在Abp中执行sql语句]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51774917</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51774917</guid><author>killcwd</author><pubDate>Tue, 28 Jun 2016 11:58:20 +0800</pubDate><description><![CDATA[目录

前言

最近使用ABP(ASP.NET Boilerplate)做项目，有些查询(或存储过程)直接使用sql语句会更方便一点。

定义一个接口

在Core项目中定义一个接口，如：ISqlExecuter
    public interface ISqlExecuter    {        ///         /// 执行给定的命令        ///    ]]></description><category></category></item><item><title><![CDATA[C#生成验证码]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51768241</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51768241</guid><author>killcwd</author><pubDate>Mon, 27 Jun 2016 14:01:08 +0800</pubDate><description><![CDATA[使用C#生成验证码图片，然后在网页中直接使用，很方便的用法。
using System;
using System.Drawing;
using System.Drawing.Imaging;
using System.Web.UI;
using System.Drawing.Drawing2D;
using System.IO;

/// 
/// 生成验证码的类
/// 
public cl]]></description><category></category></item><item><title><![CDATA[bootstrap-table]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51757405</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51757405</guid><author>killcwd</author><pubDate>Sat, 25 Jun 2016 10:14:07 +0800</pubDate><description><![CDATA[public List xxxx(string stockOutSearch, string originalOrderSearch, int status,int isPick,int isTransfer, string sort, string order, int offset,
            int limit, ref int totalCount)
        {]]></description><category></category></item><item><title><![CDATA[选择语言]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51745284</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51745284</guid><author>killcwd</author><pubDate>Thu, 23 Jun 2016 17:21:53 +0800</pubDate><description><![CDATA[@model Bba.Web.Models



    
        
        @Model.CurrentLanguage.DisplayName
        
    




    @foreach (var language in Model.Languages)
    {
        if (language.Name != Mod]]></description><category></category></item><item><title><![CDATA[barcode生成]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51732624</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51732624</guid><author>killcwd</author><pubDate>Wed, 22 Jun 2016 10:51:21 +0800</pubDate><description><![CDATA[/// 
        /// 生成条码字节流
        /// 
        /// 
        /// 
        /// 
        /// 
        public static byte[] BarCode(string code, int width = 120, int height = 55, BarcodeFormat barco]]></description><category></category></item><item><title><![CDATA[EF Attach时已存在的处理方式]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51720148</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51720148</guid><author>killcwd</author><pubDate>Mon, 20 Jun 2016 13:41:05 +0800</pubDate><description><![CDATA[如果我们在先前的步骤中读取过数据，如
var list = db.Model.ToList();
之后再，附加
var o = new Model { Id = 1 };
db.Model.Attach(o);

就会报，类似这样的错误

Attaching an entity of type 'efAutoDetach.Model' failed because another ]]></description><category></category></item><item><title><![CDATA[HighCharts点击柱形或饼块加URL或Click事件]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51177049</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51177049</guid><author>killcwd</author><pubDate>Mon, 18 Apr 2016 08:54:58 +0800</pubDate><description><![CDATA[我们在做图表的时候，有时候需要在单个数据上加链接或点击事件，是在plotOptions里的events里设置的



plotOptions:
 {

    pie:
 {

        cursor:
'pointer',

        events:
 {

            click:
function(e)
 {

        ]]></description><category></category></item><item><title><![CDATA[sqlserver 计算百分比]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51167930</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51167930</guid><author>killcwd</author><pubDate>Sat, 16 Apr 2016 14:21:34 +0800</pubDate><description><![CDATA[declare @n int --n为显示多少位数
select left(convert(varchar,13.0/80*100),@n)+'%']]></description><category></category></item><item><title><![CDATA[解决jQuery元素绑定toggle事件后元素变成隐藏的问题]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51135034</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51135034</guid><author>killcwd</author><pubDate>Tue, 12 Apr 2016 16:59:07 +0800</pubDate><description><![CDATA[原因分析

很简单，toggle功能在1.9版本之后发生变化了。不再支持多个事件轮流切换。摘一段官网说明：

Note: This method signature was deprecated in jQuery 1.8 and removed in jQuery 1.9. jQuery also provides an animation method named .toggle() ]]></description><category></category></item><item><title><![CDATA[sqlserver 获取星期一到星期日的数据]]></title><link>https://blog.youkuaiyun.com/killcwd/article/details/51103401</link><guid>https://blog.youkuaiyun.com/killcwd/article/details/51103401</guid><author>killcwd</author><pubDate>Sat, 09 Apr 2016 09:45:30 +0800</pubDate><description><![CDATA[declare @dateValue datetime, @startDay datetime
set @dateValue = CONVERT(varchar(100), GETDATE(), 23) -- 赋需要查询的日期值，不包含时分秒
set @startDay = dateadd(d, CASE WHEN datepart(dw, @dateValue) + @@DATEFIRST ]]></description><category></category></item></channel></rss>