re: 不把text或image字段放最后的后果

温景良(Jason) — Sat, 06 Jun 2009 16:55:31 GMT

呵呵

温景良(Jason) 2009-06-07 00:55 发表评论

re: 实现获取客户端的MAC地址(3)

红泼 — Thu, 04 Jun 2009 12:48:35 GMT

有个问题需要请教，请留个联系方式好吗？
或者和我联系 QQ19863409 谢谢

红泼 2009-06-04 20:48 发表评论

re: onKeypress对中文无效

kaixin110 — Thu, 26 Feb 2009 08:56:12 GMT

firefox去哪里了?

http://www.handandaily.com

kaixin110 2009-02-26 16:56 发表评论

re: ftp://ftp.microsoft.com

sunmi — Fri, 20 Feb 2009 15:41:18 GMT

我是一只狼

sunmi 2009-02-20 23:41 发表评论

re: 今天新接触到一个名词——GSV

ASP.NET学习日记！！！ — Sat, 14 Feb 2009 16:09:11 GMT

越是懂的多越发现自己知道的太少。。。

ASP.NET学习日记！！！ 2009-02-15 00:09 发表评论

re: ftp://ftp.microsoft.com

relax — Thu, 12 Feb 2009 05:01:58 GMT

哈。的确能进去。
里面东西还真的很陈旧~

relax 2009-02-12 13:01 发表评论

re: 实现获取客户端的MAC地址(3)

kilene — Thu, 12 Feb 2009 01:18:53 GMT

呵呵，楼主很幽默,不错，顶一个

kilene 2009-02-12 09:18 发表评论

re: 将主关键字加强为适应多个

yzx99 — Sun, 08 Feb 2009 12:05:20 GMT

SQL语句

--创建测试的环境1（删除现有的表，重建各种情况的表，设置好索引）

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A01]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[A01]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A02]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[A02]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A03]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[A03]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A04]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[A04]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A05]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[A05]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A06]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[A06]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A07]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[A07]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[A08]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[A08]
GO

CREATE TABLE [A01] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[DH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A01_DH] DEFAULT (''),
[GH] [int] NOT NULL CONSTRAINT [DF_A01_GH] DEFAULT (0),
[JB] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A01_JB] DEFAULT (''),
[RQ1] [char] (16) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A01_RQ1] DEFAULT (''),
CONSTRAINT [PK_A01] PRIMARY KEY CLUSTERED
(
[DH]
) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [A02] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[DH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A02_DH] DEFAULT (''),
[GH] [int] NOT NULL CONSTRAINT [DF_A02_GH] DEFAULT (0),
[JB] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A02_JB] DEFAULT (''),
[RQ1] [char] (16) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A02_RQ1] DEFAULT (''),
CONSTRAINT [PK_A02] PRIMARY KEY CLUSTERED
(
[DH]
) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE INDEX [IX_A02] ON [dbo].[A02]([GH], [JB], [RQ1]) ON [PRIMARY]
GO

CREATE TABLE [A03] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[DH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A03_DH] DEFAULT (''),
[GH] [int] NOT NULL CONSTRAINT [DF_A03_GH] DEFAULT (0),
[JB] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A03_JB] DEFAULT (''),
[RQ1] [char] (16) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A03_RQ1] DEFAULT (''),
CONSTRAINT [PK_A03] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [A04] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[DH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A04_DH] DEFAULT (''),
[GH] [int] NOT NULL CONSTRAINT [DF_A04_GH] DEFAULT (0),
[JB] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A04_JB] DEFAULT (''),
[RQ1] [char] (16) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A04_RQ1] DEFAULT (''),
CONSTRAINT [PK_A04] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE INDEX [IX_A04] ON [dbo].[A04]([DH]) ON [PRIMARY]
GO

CREATE TABLE [A05] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[DH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A05_DH] DEFAULT (''),
[GH] [int] NOT NULL CONSTRAINT [DF_A05_GH] DEFAULT (0),
[JB] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A05_JB] DEFAULT (''),
[RQ1] [char] (16) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A05_RQ1] DEFAULT (''),
CONSTRAINT [PK_A05] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE INDEX [IX_A05] ON [dbo].[A05]([GH], [JB], [RQ1]) ON [PRIMARY]
GO

CREATE TABLE [A06] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[DH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A06_DH] DEFAULT (''),
[GH] [int] NOT NULL CONSTRAINT [DF_A06_GH] DEFAULT (0),
[JB] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A06_JB] DEFAULT (''),
[RQ1] [char] (16) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A06_RQ1] DEFAULT (''),
CONSTRAINT [PK_A06] PRIMARY KEY CLUSTERED
(
[ID]
) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE INDEX [IX_A06] ON [dbo].[A06]([DH]) ON [PRIMARY]
GO

CREATE INDEX [IX_A06_1] ON [dbo].[A06]([GH], [JB], [RQ1]) ON [PRIMARY]
GO

CREATE TABLE [A07] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[DH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A07_DH] DEFAULT (''),
[GH] [int] NOT NULL CONSTRAINT [DF_A07_GH] DEFAULT (0),
[JB] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A07_JB] DEFAULT (''),
[RQ1] [char] (16) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A07_RQ1] DEFAULT (''),
CONSTRAINT [PK_A07] PRIMARY KEY CLUSTERED
(
[GH],
[JB],
[RQ1]
) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE TABLE [A08] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[DH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A08_DH] DEFAULT (''),
[GH] [int] NOT NULL CONSTRAINT [DF_A08_GH] DEFAULT (0),
[JB] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A08_JB] DEFAULT (''),
[RQ1] [char] (16) COLLATE Chinese_PRC_CI_AS NOT NULL CONSTRAINT [DF_A08_RQ1] DEFAULT (''),
CONSTRAINT [PK_A08] PRIMARY KEY CLUSTERED
(
[GH],
[JB],
[RQ1]
) ON [PRIMARY]
) ON [PRIMARY]
GO

CREATE INDEX [IX_A08] ON [dbo].[A08]([DH]) ON [PRIMARY]
GO

--创建测试的环境2（清空表，插入相应数据，重整索引（注：truncate后，索引也会清空，insert后，索引也是最新的，我测试时也没有频繁插入、删除数据，因此这里重整索引不是必须的））

truncate table A01
insert into A01(DH, GH, JB, RQ1) select DH, GH, JB, RQ1 + ' ' + SJ1 from A12QJD where DH like 'RS%'
dbcc dbreindex ('A01')
GO

truncate table A02
insert into A02(DH, GH, JB, RQ1) select DH, GH, JB, RQ1 + ' ' + SJ1 from A12QJD where DH like 'RS%'
dbcc dbreindex ('A02')
GO

truncate table A03
insert into A03(DH, GH, JB, RQ1) select DH, GH, JB, RQ1 + ' ' + SJ1 from A12QJD where DH like 'RS%'
dbcc dbreindex ('A03')
GO

truncate table A04
insert into A04(DH, GH, JB, RQ1) select DH, GH, JB, RQ1 + ' ' + SJ1 from A12QJD where DH like 'RS%'
dbcc dbreindex ('A04')
GO

truncate table A05
insert into A05(DH, GH, JB, RQ1) select DH, GH, JB, RQ1 + ' ' + SJ1 from A12QJD where DH like 'RS%'
dbcc dbreindex ('A05')
GO

truncate table A06
insert into A06(DH, GH, JB, RQ1) select DH, GH, JB, RQ1 + ' ' + SJ1 from A12QJD where DH like 'RS%'
dbcc dbreindex ('A06')
GO

truncate table A07
insert into A07(DH, GH, JB, RQ1) select DH, GH, JB, RQ1 + ' ' + SJ1 from A12QJD where DH like 'RS%'
dbcc dbreindex ('A07')
GO

truncate table A08
insert into A08(DH, GH, JB, RQ1) select DH, GH, JB, RQ1 + ' ' + SJ1 from A12QJD where DH like 'RS%'
dbcc dbreindex ('A08')
GO

--让查询分析器去分析的SQL语句

insert into A01(DH, GH, JB, RQ1) values('RS10320297', 10335, '0', '2009-01-01')
update A01 set GH=15141, JB='A', RQ1='2009-02-01' where DH='RS00320297'
delete from A01 where DH='RS10320297'
select * from A01 where DH='RS00320297'

select * from A01 where GH=10335
select * from A01 where GH=10335 and JB='A'

insert into A02(DH, GH, JB, RQ1) values('RS10320297', 10335, '0', '2009-01-01')
update A02 set GH=15141, JB='A', RQ1='2009-02-01' where DH='RS00320297'
delete from A02 where DH='RS10320297'
select * from A02 where DH='RS00320297'

select * from A02 where GH=10335
select * from A02 where GH=10335 and JB='A'

insert into A03(DH, GH, JB, RQ1) values('RS10320297', 10335, '0', '2009-01-01')
update A03 set GH=15141, JB='A', RQ1='2009-02-01' where DH='RS00320297'
delete from A03 where DH='RS10320297'
select * from A03 where DH='RS00320297'

select * from A03 where GH=10335
select * from A03 where GH=10335 and JB='A'

insert into A04(DH, GH, JB, RQ1) values('RS10320297', 10335, '0', '2009-01-01')
update A04 set GH=15141, JB='A', RQ1='2009-02-01' where DH='RS00320297'
delete from A04 where DH='RS10320297'
select * from A04 where DH='RS00320297'

select * from A04 where GH=10335
select * from A04 where GH=10335 and JB='A'

insert into A05(DH, GH, JB, RQ1) values('RS10320297', 10335, '0', '2009-01-01')
update A05 set GH=15141, JB='A', RQ1='2009-02-01' where DH='RS00320297'
delete from A05 where DH='RS10320297'
select * from A05 where DH='RS00320297'

select * from A05 where GH=10335
select * from A05 where GH=10335 and JB='A'

insert into A06(DH, GH, JB, RQ1) values('RS10320297', 10335, '0', '2009-01-01')
update A06 set GH=15141, JB='A', RQ1='2009-02-01' where DH='RS00320297'
delete from A06 where DH='RS10320297'
select * from A06 where DH='RS00320297'

select * from A06 where GH=10335
select * from A06 where GH=10335 and JB='A'

insert into A07(DH, GH, JB, RQ1) values('RS10320297', 10335, '0', '2009-01-01')
update A07 set GH=15141, JB='A', RQ1='2009-02-01' where DH='RS00320297'
delete from A07 where DH='RS10320297'
select * from A07 where DH='RS00320297'

select * from A07 where GH=10335
select * from A07 where GH=10335 and JB='A'

insert into A08(DH, GH, JB, RQ1) values('RS10320297', 10335, '0', '2009-01-01')
update A08 set GH=15141, JB='A', RQ1='2009-02-01' where DH='RS00320297'
delete from A08 where DH='RS10320297'
select * from A08 where DH='RS00320297'

select * from A08 where GH=10335
select * from A08 where GH=10335 and JB='A'

yzx99 2009-02-08 20:05 发表评论

re: 尝试消除switch

yzx99 — Fri, 06 Feb 2009 16:42:52 GMT

谢谢！第一次听说Dictionary

试出如下代码：
using System;
using System.Collections.Generic;

public delegate void show();

public class m
{
public static void Main()
{
Dictionary s = new Dictionary();
s.Add("C1", new show(m.C1));
s.Add("M1", new show(m.M1));
s["C1"].DynamicInvoke();
s["M1"].DynamicInvoke();
}

public static void C1()
{
Console.WriteLine("C1");
}

public static void M1()
{
Console.WriteLine("M1");
}
}
它对消除switch的效果确实不错。不过，按我理解的代码，如果要增加一种处理方法，Main中还要加了s.Add("K1", new show(m.K1));，这有点不理想。

yzx99 2009-02-07 00:42 发表评论

re: 尝试消除switch

南柯之石 — Wed, 04 Feb 2009 14:30:52 GMT

用Dictionary可以吗?

南柯之石 2009-02-04 22:30 发表评论

博客园-yzx99-最新评论

re: 不把text或image字段放最后的后果

re: 实现获取客户端的MAC地址(3)

re: onKeypress对中文无效

re: ftp://ftp.microsoft.com

re: 今天新接触到一个名词——GSV

re: ftp://ftp.microsoft.com

re: 实现获取客户端的MAC地址(3)

re: 将主关键字加强为适应多个

re: 尝试消除switch

re: 尝试消除switch