摘要:
1 public class UserBLL 2 { 3 public class UserInfo 4 { 5 public int ID { get; set; } 6 public string Email { get; set; } 7 public string UserName { get; set; } 8 } 9 10 public UserInfo GetModel(int id) 11 ... 阅读全文
摘要:
create table 表空间占用情况(name varchar(255), rows bigint, reserved varchar(20), data varchar(20), index_size varchar(20), unused varchar(20))exec sp_MSforeachtable 'insert into 表空间占用情况 exec sp_spaceused ''?''' select * from 表空间占用情况 order by rows desc 阅读全文
摘要:
1 public class LinkHelper 2 { 3 4 /// <summary> 5 /// 获取总页数 6 /// </summary> 7 /// <param name="totalCount"></param> 8 /// <param name="pageSize"></param> 9 /// <returns></returns> 10 public static int GetTotalPage(int totalC... 阅读全文
摘要:
View Code using System;namespace MyFunc{ public class MyMD5 { private const int BITS_TO_A_BYTE = 8; private const int BYTES_TO_A_WORD = 4; private const int BITS_TO_A_WORD = 32; private int[] m_lOnBits; private int[] m_l2Power; private int Get... 阅读全文
摘要:
1 public class XHttpRequest 2 { 3 //同步方式发起http get请求 4 public string HttpGet(string url, string queryString) 5 { 6 string responseData = null; 7 8 if (!string.IsNullOrEmpty(queryString)) 9 { 10 url += "?" ... 阅读全文
摘要:
1 var CHelper={ 2 ClrKey:function(selector,key){ 3 $(selector).focus(function(){ 4 if($.trim($(this).val())==key){$(this).val("");} 5 $(this).css("color","#000000"); 6 }); 7 8 $(selector).blur(function(){ 9 var v=$.trim($(this).val())... 阅读全文
摘要:
public static string ConcatAnchor(string url, string attr, string queryName, string pageNum, string innerText) { string[] rtun=new string[10]; rtun[0]=("<a "); rtun[1] = (attr); rtun[2] = (" href=\""); rtun[3] = (url); ... 阅读全文
摘要:
1 --分页查询,要求表必须包含标识列 2 SELECT [要查询字段] 3 FROM [查询表名称], 4 ( 5 SELECT * 6 FROM 7 ( 8 SELECT ROW_NUMBER() OVER(ORDER BY [排序字段]) as F_ID,[表标识列名称] AS F_ID_0 9 FROM [查询表名称] 10 WHERE [查询条件]11 ) AS [全部查询结果] 12 WHERE [全部查询结果].F_ID>=[分页记录开始号码] AND [全部查询结果].F_ID<[分... 阅读全文