2019年08月_霍夫曼

12月 11月 10月 09月 08月 07月 06月 05月 04月

原创 varchar、nvarchar

Unicode字符集就是为了解决字符集这种不兼容的问题而产生的，它所有的字符都用两个字节表示，即英文字符也是用两个字节表示。NCHAR、NVARCHAR、NTEXT。这三种从名字上看比前面三种多了个“N”。它表示存储的是Unicode数据类型的字符。我们知道字符中，英文字符只需要一个字节存储就足够了，但汉字众多，需要两个字节存储，英文与汉字同时存在时容易造成混乱，Unicode字符集...

2019-08-16 15:03:00 69

原创 .Net C# EF database first connectionstring

<connectionStrings> <add name="CupCreditCheckDB" connectionString="metadata=res://*/CupModel.csdl|res://*/CupModel.ssdl|res://*/CupModel.msl;provider=System.Data.SqlClient;provi...

2019-08-16 13:44:00 224

原创 Entity Framework Database First、Model First、Code Only三种开发模式实现数据持久化

待续

2019-08-14 15:55:00 123

原创虚拟桌面基础架构

　　虚拟桌面基础架构（英文全称：Virtual Desktop Infrastructure），即虚拟桌面基础架构，正迅速成为一个热门词语，属于云桌面技术之一。　　

2019-08-14 13:39:00 724

原创 .Net C# Dictionary 和参数字符串互转

#region Parse #region Dictionary Parse To String /// <summary> /// Dictionary Parse To String /// </summary> /// <param nam...

2019-08-13 17:02:00 2307 1

原创 .Net C# 读取xml

[TestMethod] public void Test3() { StringBuilder temp = new StringBuilder(); temp.AppendFormat("<?xml version=\"1.0\"?><Entities xmlns:xsi=\...

2019-08-13 17:00:00 347

原创参数字符串转字典数组

#region Assign parameters to specified objects /// <summary> /// Assign parameters to specified objects /// </summary> /// <typeparam name="...

2019-08-13 14:32:00 121

原创绝对路径和相对路径

　　总是忘记他们的区别　　绝对路径：指的是绝对位置，完整地描述目标所在位置，目录层级关系一目了然　　　　<link href="/Content/bootstrap.min.css" rel="stylesheet" type="text/css" />　　相对路径：　　指的是相对于当前文件的路径，相对路径通常用几个特殊符号来表示...

2019-08-12 17:10:00 77

原创 CPA ,CFA,ACCA

　　CPA是“注册会计师”（Certified Public Accountant，CPA）的简称，是指取得注册会计师证书并在会计师事务所执业的人员，是从事社会审计/中介审计/独立审计的专业人士，CPA为中国唯一官方认可的注册会计师资质，唯一拥有签字权的执业资质。　　CFA是“特许金融分析师”（Chartered Financial Analyst）的简称，它是证券投资与管理界的一种...

2019-08-09 10:26:00 231

原创 Get HttpWebResponse and HttpClient Return String by proxy

#region Get HttpClient Return String /// <summary> /// Get HttpClient Return String /// </summary> /// <param name="apiUrl">api U...

2019-08-06 11:33:00 62

原创 C# Base64 操作类

using System;using System.Text;namespace VWFC.IT.CUP.BLL.Util{ /// <summary> /// Base64 tools /// </summary> public class Base64Util { /// ...

2019-08-02 18:00:00 389

原创 .Net C# 签名字符串排序

#region Get Sign Content /// <summary> /// Get Sign Content /// </summary> /// <param name="parameters"></param> /// <ret...

2019-08-02 11:14:00 287

原创 .Net C# RSA签名和验签重写

namespace com._80community.unittest.CUP{ /// <summary> /// CUP Client /// </summary> public interface IClient { /// <summary> //...

2019-08-01 18:08:00 233

原创 Path.Combine(

// 获取程序的基目录。 var dir1 = System.AppDomain.CurrentDomain.BaseDirectory; // 获取模块的完整路径。 var dir2 = System.Diagnostics.Process.GetCurrentProc...

2019-08-01 17:56:00 593

原创 HttpContext is null

HttpContext context1 = System.Web.HttpContext.Current;HttpContext context2 = System.Runtime.Remoting.Messaging.CallContext.HostContext as HttpContext; //当前(请求)线程上下文bool isEqual = object.Refe...

2019-08-01 17:42:00 239

转载经典AndersLiu,经典登录

转载经典AndersLiu,经典登录转载经典AndersLiu,经典登录转载经典AndersLiu,经典登录转载经典AndersLiu,经典登录

2009-05-08

CREATE PROCEDURE [dbo].[pro_Pager] @TableName varchar(50), @Condition nvarchar(500), @Fields varchar(500), @CurrentPage int, @PageSize int, @OrderField varchar(100), @OrderType varchar(4) AS set nocount on declare @SQL nvarchar(2000) if @OrderType = 'Desc' begin if @Condition = 'None' begin if @CurrentPage = 1 begin set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' order by ' + @OrderField + ' desc' end if @CurrentPage > 1 begin set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' where ' + @OrderField + '<(select min(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' order by ' + @OrderField + ' desc) temp) order by ' + @OrderField + ' desc' end end else begin if @CurrentPage = 1 begin set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' desc' end if @CurrentPage > 1 begin set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' and ' + @OrderField + '<(select min(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' desc) temp) order by ' + @OrderField + ' desc' end end end else begin if @Condition = 'None' begin if @CurrentPage = 1 begin set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' order by ' + @OrderField + ' asc' end if @CurrentPage > 1 begin set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' where ' + @OrderField + ' > (select max(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' order by ' + @OrderField + ' asc) temp) order by ' + @OrderField + ' asc' end end else begin if @CurrentPage = 1 begin set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' asc' end if @CurrentPage > 1 begin set @SQL = 'select top ' + Cast(@PageSize as varchar) + ' ' + @Fields + ' from ' + @TableName + ' ' + @Condition + ' and ' + @OrderField + ' > (select max(' + @OrderField + ') from (select top ' + Cast(@PageSize*(@CurrentPage-1) as varchar) + ' ' + @OrderField + ' from ' + @TableName + ' ' + @Condition + ' order by ' + @OrderField + ' asc] temp) order by ' + @OrderField + ' asc' end end end exec sp_executesql @SQL

2008-12-04

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人

转载经典AndersLiu,经典登录

sql 2000自定义分页存储过程

空空如也