<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[wanglei_smartfish的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/wanglei_samrtfish</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; wanglei_samrtfish]]></copyright><item><title><![CDATA[vue+element上传图片]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/103901464</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/103901464</guid><author>wanglei_samrtfish</author><pubDate>Thu, 09 Jan 2020 09:05:32 +0800</pubDate><description><![CDATA[1前端



'usestrict';

importComponentfrom'vue-class-component';

import{PageVue,UI,Dict,DropDict}from"sj.sys.ui";

//引入ag-grid声明文件

import{GridOptions,RowEvent,RowNode,ColumnControll...]]></description><category></category></item><item><title><![CDATA[c#关于JWT跨域身份验证解决方案]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/102785888</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/102785888</guid><author>wanglei_samrtfish</author><pubDate>Mon, 28 Oct 2019 18:08:19 +0800</pubDate><description><![CDATA[学习程序，不是记代码，而是学习一种思想，以及对代码的理解和思考。

JSON Web Token（JWT）是目前最流行的跨域身份验证解决方案。为了网络应用环境间传递声明而执行的一种基于JSON的开发标准（RFC 7519），

该token被设计为紧凑且安全的，特别适用于分布式站点的单点登陆（SSO）场景。JWT的声明一般被用来在身份提供者和服务提供者间传递被认证的用户身份信息，

以便于从资源服...]]></description><category></category></item><item><title><![CDATA[angularJs增删改查]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/101450217</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/101450217</guid><author>wanglei_samrtfish</author><pubDate>Thu, 26 Sep 2019 16:10:07 +0800</pubDate><description><![CDATA[&lt;%@ Page Language="C#" AutoEventWireup="true" CodeFile="2.aspx.cs" Inherits="anglarJS_2" %&gt;



&lt;!DOCTYPE html&gt;
&lt;html&gt;
 &lt;head&gt;
  &lt;meta charset="UTF-8"&gt;
  &...]]></description><category></category></item><item><title><![CDATA[SQL Server 行转列，列转行。多行转成一列]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/90645510</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/90645510</guid><author>wanglei_samrtfish</author><pubDate>Tue, 28 May 2019 19:22:24 +0800</pubDate><description><![CDATA[一、多行转成一列（并以","隔开）

表名：A

表数据：



想要的查询结果：



查询语句：




SELECT  name ,
        value = ( STUFF(( SELECT    ',' + value
                          FROM      A
                          WHERE     name = T...]]></description><category></category></item><item><title><![CDATA[SQL查询结果行转列]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/90645495</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/90645495</guid><author>wanglei_samrtfish</author><pubDate>Tue, 28 May 2019 19:21:17 +0800</pubDate><description><![CDATA[练习脚本

 -- 学生表
 CREATE TABLE student (
 stuid VARCHAR(16) NOT NULL,
 stunm VARCHAR(20) NOT NULL,
 PRIMARY KEY (stuid)
 );
 
 -- 课程表
 CREATE TABLE courses (
 cours...]]></description><category></category></item><item><title><![CDATA[react的TodoList增删改]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/86236973</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/86236973</guid><author>wanglei_samrtfish</author><pubDate>Thu, 10 Jan 2019 15:54:50 +0800</pubDate><description><![CDATA[&amp;lt;%@ Page Language=&quot;C#&quot; AutoEventWireup=&quot;true&quot; CodeFile=&quot;react4.aspx.cs&quot; Inherits=&quot;react4&quot; %&amp;gt;


&amp;lt;!DOCTYPE html&amp;gt;
&amp;lt;html lang=&quot;en&quot;&amp;gt;
&amp;lt;head&amp;gt;
    &amp;lt;met]]></description><category></category></item><item><title><![CDATA[vue.js增删改查2]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/86165455</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/86165455</guid><author>wanglei_samrtfish</author><pubDate>Wed, 09 Jan 2019 17:30:30 +0800</pubDate><description><![CDATA[&amp;lt;%@ Page Language=&quot;C#&quot; AutoEventWireup=&quot;true&quot; CodeFile=&quot;vue3.aspx.cs&quot; Inherits=&quot;vue3&quot; %&amp;gt;

&amp;lt;!DOCTYPE html&amp;gt;

&amp;lt;html lang=&quot;en&quot;&amp;gt;
&amp;lt;head&amp;gt;
    &amp;lt;meta ch]]></description><category></category></item><item><title><![CDATA[c#bootstap数据操作]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/86086089</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/86086089</guid><author>wanglei_samrtfish</author><pubDate>Tue, 08 Jan 2019 17:25:51 +0800</pubDate><description><![CDATA[@{
    Layout = null;
    ViewBag.Title = &quot;Home Page&quot;;
}

&amp;lt;!DOCTYPE html&amp;gt;
&amp;lt;html&amp;gt;
&amp;lt;head&amp;gt;
    &amp;lt;meta charset=&quot;utf-8&quot; /&amp;gt;
    &amp;lt;meta name=&quot;viewport&quot; content=&quot;width=]]></description><category></category></item><item><title><![CDATA[vue.js模拟数据增删改查]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/86084577</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/86084577</guid><author>wanglei_samrtfish</author><pubDate>Tue, 08 Jan 2019 17:02:12 +0800</pubDate><description><![CDATA[1.页面代码

&amp;lt;%@ Page Language=&quot;C#&quot; AutoEventWireup=&quot;true&quot; CodeFile=&quot;vue2.aspx.cs&quot; Inherits=&quot;vue2&quot; %&amp;gt;

&amp;lt;!DOCTYPE html&amp;gt;
&amp;lt;html lang=&quot;en&quot;&amp;gt;
&amp;lt;head&amp;gt;
    &amp;lt;]]></description><category></category></item><item><title><![CDATA[winfrom下载文件进度条]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/85989356</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/85989356</guid><author>wanglei_samrtfish</author><pubDate>Mon, 07 Jan 2019 10:46:25 +0800</pubDate><description><![CDATA[1.后台代码

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using ...]]></description><category></category></item><item><title><![CDATA[echart报表]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/84989425</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/84989425</guid><author>wanglei_samrtfish</author><pubDate>Thu, 13 Dec 2018 15:30:13 +0800</pubDate><description><![CDATA[&amp;lt;%@ Page Language=&quot;C#&quot; AutoEventWireup=&quot;true&quot; CodeFile=&quot;hichar1.aspx.cs&quot; Inherits=&quot;Default3&quot; %&amp;gt;

&amp;lt;!DOCTYPE html&amp;gt;

&amp;lt;html xmlns=&quot;http://www.w3.org/1999/xhtml&quot;&amp;gt;
&amp;l]]></description><category></category></item><item><title><![CDATA[C# 绘制统计图(柱状图, 折线图, 扇形图)]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/83013164</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/83013164</guid><author>wanglei_samrtfish</author><pubDate>Thu, 11 Oct 2018 15:26:23 +0800</pubDate><description><![CDATA[统计图形种类繁多, 有柱状图, 折线图, 扇形图等等, 而统计图形的绘制方法也有很多, 有Flash制作的统计图形, 有水晶报表生成统计图形, 有专门制图软件制作, 也有编程语言自己制作的；这里我们用就C# 制作三款最经典的统计图: 柱状图, 折线图和扇形图；既然是统计, 当然需要数据, 这里演示的数据存于Sql Server2000中, 三款统计图形都是动态生成. 其中柱状图我会附上制作步骤, ...]]></description><category></category></item><item><title><![CDATA[C# 利用ReportViewer生成报表]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/83012992</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/83012992</guid><author>wanglei_samrtfish</author><pubDate>Thu, 11 Oct 2018 15:18:47 +0800</pubDate><description><![CDATA[本文主要是利用微软自带的控件ReportViewer进行报表设计的小例子，仅供学习分享使用，如有不足之处，还请指正。

涉及知识点：

ReportViewer :位于Microsoft.Reporting.WinForms命名空间， 主要用于报表的显示
	Report:报表，以rdlc结尾的文件，可视化设计报表模板。
	报表数据：内置字段，参数，图像，数据集（本报表主要使用参数，和数据集）
	R...]]></description><category></category></item><item><title><![CDATA[MVC中几种常用ActionResult]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/83012892</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/83012892</guid><author>wanglei_samrtfish</author><pubDate>Thu, 11 Oct 2018 15:14:56 +0800</pubDate><description><![CDATA[一、定义

MVC中ActionResult是Action的返回结果。ActionResult 有多个派生类，每个子类功能均不同，并不是所有的子类都需要返回视图View，有些直接返回流，有些返回字符串等。ActionResult是一个抽象类，它定义了唯一的ExecuteResult方法，参数为一个ControllerContext，下面为您介绍MVC中的ActionResult 的用法

 

二...]]></description><category></category></item><item><title><![CDATA[C#chart图表的应用]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/83012685</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/83012685</guid><author>wanglei_samrtfish</author><pubDate>Thu, 11 Oct 2018 15:04:37 +0800</pubDate><description><![CDATA[在图表中，x轴代表类别，y轴代表数值（好比类与他们的属性）



这是数据库中的数据，下面我们选前5辆车，在图表中显示他们的名字，油耗，功率，价格



创建查询数据的类

 




class CarDA
    {
        public List &amp;lt; CarData&amp;gt; select()
        {
            List &amp;lt; CarData &amp;gt...]]></description><category></category></item><item><title><![CDATA[（C#）一个WCF简单实例]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/83012628</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/83012628</guid><author>wanglei_samrtfish</author><pubDate>Thu, 11 Oct 2018 15:02:06 +0800</pubDate><description><![CDATA[以订票为例简单应用wcf
新建一个wcf服务应用程序

   



 
在IService1.cs定义服务契约 

 





 

namespace WcfDemo
{
// 注意: 如果更改此处的接口名称 &quot;IService1&quot;，也必须更新 Web.config 中对 &quot;IService1&quot; 的引用。
[ServiceContract] // 服务合同 即提供服务的接口或类
public...]]></description><category></category></item><item><title><![CDATA[几种常见SQL分页方式效率比较]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/79734405</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/79734405</guid><author>wanglei_samrtfish</author><pubDate>Wed, 28 Mar 2018 21:26:29 +0800</pubDate><description><![CDATA[ 分页很重要，面试会遇到。不妨再回顾总结一下： 一：创建测试环境，(插入100万条数据大概耗时5分钟)。1create database DBTest&amp;lt;br&amp;gt;use DBTest 二：--创建测试表1234567create table pagetest(id int identity(1,1) not null,col01 int null,col02 nvarchar(50) nu...]]></description><category></category></item><item><title><![CDATA[存储过程的具体应用]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/78587177</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/78587177</guid><author>wanglei_samrtfish</author><pubDate>Mon, 20 Nov 2017 21:58:46 +0800</pubDate><description><![CDATA[存储过程的具体应用
 一、基础查询
1、创建不带参数的存储过程
例子：查询学生总数


--查询存储过程
IF OBJECT_ID (N'PROC_SELECT_STUDENTS_COUNT', N'P') IS NOT NULL
    DROP procedure PROC_SELECT_STUDENTS_COUNT;
GO
CREATE procedure PROC_SELECT]]></description><category></category></item><item><title><![CDATA[EasyUi+mvc增删改查]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/77532673</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/77532673</guid><author>wanglei_samrtfish</author><pubDate>Thu, 24 Aug 2017 17:12:05 +0800</pubDate><description><![CDATA[1.首先得下载EasyUi包。

2.前端html代码如下：
@*
    For more information on enabling MVC for empty projects, visit http://go.microsoft.com/fwlink/?LinkID=397860
*@
@{
    ViewBag.Title = "拍卖会列表";
    Layout]]></description><category></category></item><item><title><![CDATA[jqueey练习]]></title><link>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/77197483</link><guid>https://blog.youkuaiyun.com/wanglei_samrtfish/article/details/77197483</guid><author>wanglei_samrtfish</author><pubDate>Tue, 15 Aug 2017 17:17:05 +0800</pubDate><description><![CDATA[@*
    For more information on enabling MVC for empty projects, visit http://go.microsoft.com/fwlink/?LinkID=397860
*@
@{
    ViewBag.Title = "拍卖会列表";
    Layout = null;
}

@using Microsoft.As]]></description><category></category></item></channel></rss>