在最常见的用法中，从Reader到Entity或Collection或List时总会用到对象转化。
这里提供一份简陋的性能测试报告(仅代表downmoon或邀月)的观点。
一、在测试之前，首先准备一个表(SQL2005）
Database Name :TestBigData
Table:Product
这里，提供一些傻瓜语句
create database Testbigdata
go
use Testbigdata
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Product]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Product](
[P_ID] [bigint] IDENTITY(1,1) NOT NULL,
[P_Name] [nvarchar](255) NULL,
[P_E_ID] [int] NULL,
[CategoryID1] [int] NULL CONSTRAINT [DF__Product__Categor__04AFB25B] DEFAULT ((0)),
[CategoryID2] [int] NULL CONSTRAINT [DF__Product__Categor__05A3D694] DEFAULT ((0)),
[CategoryID3] [int] NULL CONSTRAINT [DF__Product__Categor__0697FACD] DEFAULT ((0)),
[CategoryID4] [int] NULL CONSTRAINT [DF__Product__Categor__078C1F06] DEFAULT ((0)),
[CategoryID5] [int] NULL CONSTRAINT [DF__Product__Categor__0880433F] DEFAULT ((0)),
[CategoryID6] [int] NULL CONSTRAINT [DF__Product__Categor__09746778] DEFAULT ((0)),
[P_SysCate] [nvarchar](20) NULL,
[P_Key] [nvarchar](100) NULL,
[P_SellArea] [nvarchar](500) NULL,
[P_SingleIntro] [nvarchar](1000) NULL,
[P_Intro] [ntext] NULL,
[P_Order] [float] NULL,
[P_Cate] [nvarchar](20) NULL,
[P_Cate1] [int] NULL,
[P_Cate2] [int] NULL,
[P_Cate3] [int] NULL,
[P_C_Order] [int] NULL,
[P_TopTime] [smalldatetime] NULL,
[AddTime] [datetime] NULL,
[AddUser] [nvarchar](50) NULL,
[ModTime] [datetime] NULL,
[ModUser] [nvarchar](50) NULL,
[P_BigImage] [nvarchar](150) NULL,
[P_SmallImage] [nvarchar](150) NULL,
[P_BigImage2] [nvarchar](150) NULL,
[P_SmallImage2] [nvarchar](150) NULL,
[P_BigImage3] [nvarchar](150) NULL,
[P_SmallImage3] [nvarchar](150) NULL,
[LoginID] [nvarchar](50) NULL,
[CurState] [smallint] NOT NULL CONSTRAINT [DF__Product__CurStat__0A688BB1] DEFAULT ((0)),
[RecState] [smallint] NOT NULL CONSTRAINT [DF_Product_RecCtate] DEFAULT ((0)),
[P_CheckInfo] [nvarchar](80) NULL,
[P_Max] [nvarchar](30) NULL,
[P_Min] [nvarchar](30) NULL,
[P_Unit] [nvarchar](50) NULL,
[P_L_ID] [int] NULL,
[C_ID] [int] NULL,
[C_I_ID] [int] NULL CONSTRAINT [DF__Product__C_I_ID__0B5CAFEA] DEFAULT ((0)),
[P_NewInfo] [nvarchar](1000) NULL,
[P_Price] [nvarchar](50) NULL,
[P_OtherState] [int] NULL,
[P_NewKey1] [nvarchar](300) NULL,
[P_NewKey2] [nvarchar](300) NULL,
[P_NewKey3] [nvarchar](300) NULL,
[F1] [int] NOT NULL CONSTRAINT [DF__Product__F1__0C50D423] DEFAULT ((0)),
[F2] [int] NOT NULL CONSTRAINT [DF__Product__F2__0D44F85C] DEFAULT ((0)),
[F3] [nvarchar](50) NULL,
[F4] [nvarchar](200) NULL,
[WebSite] [nvarchar](50) NULL,
[Languages] [nvarchar](20) NULL,
CONSTRAINT [PK_PRODUCT] PRIMARY KEY CLUSTERED
(
[P_ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
SET Identity_Insert dbo.Product ON
INSERT INTO dbo.Product(
P_ID,P_Name,P_E_ID,CategoryID1,
CategoryID2,CategoryID3,CategoryID4,CategoryID5,
CategoryID6,P_SysCate,P_Key,P_SellArea,
P_SingleIntro,P_Intro,P_Order,P_Cate,
P_Cate1,P_Cate2,P_Cate3,P_C_Order,
P_TopTime,AddTime,AddUser,ModTime,
ModUser,P_BigImage,P_SmallImage,P_BigImage2,
P_SmallImage2,P_BigImage3,P_SmallImage3,LoginID,
CurState,RecState,P_CheckInfo,P_Max,
P_Min,P_Unit,P_L_ID,C_ID,
C_I_ID,P_NewInfo,P_Price,P_OtherState,
P_NewKey1,P_NewKey2,P_NewKey3,F1,
F2,F3,F4,WebSite,
Languages)
VALUES (
262144,'成功1号',0,
4,9,332,0,
0,0,'花椰菜','花菜种子，花椰菜种子，白花菜种子',
'1','花椰菜种子,特征特性：一般株高65厘米，开展度65-70厘米，叶深绿色，长椭圆形，蜡粉中等，叶柄短，','<P>特征特性：一般株高65厘米，开展度65-70厘米，叶深绿色，长椭圆形，蜡粉中等，叶柄短，脚特短，节间特别紧密，芯叶多层扭卷护球。部份叶柄嵌入花球下方，使花球成圆球形，花球三叠，特别洁白坚实紧密，质地柔嫩，鲜美可口，比重特大。一般单花球重2-3千克左右，适应性广，耐运输，还是冷冻出口创汇的好原料。元旦前上市。结球期适应温度 7-10℃。</P>
<P> 栽培要点：该品种适宜北纬 31℃以内种植。浙江省一般7月下旬播种为宜，其它地区敬请参照当地气候与栽培习惯，慎选最佳播期。一般南稍迟、北稍早；沿海平原稍迟、内陆山区稍早。苗期适当遮荫，搭架避雨，苗龄25-30天（包括假植时间）。合理密植，每亩1400-1500株。施足基肥，成活后淡肥勤施，花球形成后（时）重施追肥 2-3次。及时摘叶盖花，生长期间要防治病虫害和结球期鼠害。 <BR> 播种期间不适，苗期过长，肥水管理跟不上，遇到天气长期高温晴旱或暴雨淋伤根系都会提早形成花球，球小品质差。严重时容易出现毛花、异花（畸形花）。要照样施肥水，有利于增加产量，提高质量。</P>',0,
'Seed',20,0,0,
0,'2008-02-28 00:00:00.000','2004-10-09 17:37:00.000',NULL,
'2008-03-13 19:35:59.140','qbd','20064201105007754.jpg','20064201105004166.jpg',
'','','','',
'qingyiseeds',1,0,'',
'','','千克/公斤',0,
10633,0,'','',
0,'花菜种子，花椰菜种子，白花菜种子','','',
0,0,'','',
'agronet','cn')
GO
Set Identity_Insert dbo.Product OFF
<!-- <br />
<br />
Code highlighting produced by Actipro CodeHighlighter (freeware)<br />
http://www.CodeHighlighter.com/<br />
<br />
-->
create
database
Testbigdata
go
use
Testbigdata
GO
SET
ANSI_NULLS
ON
GO
SET
QUOTED_IDENTIFIER
ON
GO
IF
NOT
EXISTS
(
SELECT
*
FROM
sys.objects
WHERE
object_id
=
OBJECT_ID
(N
'
[dbo].[Product]
'
)
AND
type
in
(N
'
U
'
))
BEGIN
CREATE
TABLE
[
dbo
]
.
[
Product
]
(
[
P_ID
]
[
bigint
]
IDENTITY
(
1
,
1
)
NOT
NULL
,
[
P_Name
]
[
nvarchar
]
(
255
)
NULL
,
[
P_E_ID
]
[
int
]
NULL
,
[
CategoryID1
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__04AFB25B
]
DEFAULT
((
0
)),
[
CategoryID2
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__05A3D694
]
DEFAULT
((
0
)),
[
CategoryID3
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__0697FACD
]
DEFAULT
((
0
)),
[
CategoryID4
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__078C1F06
]
DEFAULT
((
0
)),
[
CategoryID5
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__0880433F
]
DEFAULT
((
0
)),
[
CategoryID6
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__Categor__09746778
]
DEFAULT
((
0
)),
[
P_SysCate
]
[
nvarchar
]
(
20
)
NULL
,
[
P_Key
]
[
nvarchar
]
(
100
)
NULL
,
[
P_SellArea
]
[
nvarchar
]
(
500
)
NULL
,
[
P_SingleIntro
]
[
nvarchar
]
(
1000
)
NULL
,
[
P_Intro
]
[
ntext
]
NULL
,
[
P_Order
]
[
float
]
NULL
,
[
P_Cate
]
[
nvarchar
]
(
20
)
NULL
,
[
P_Cate1
]
[
int
]
NULL
,
[
P_Cate2
]
[
int
]
NULL
,
[
P_Cate3
]
[
int
]
NULL
,
[
P_C_Order
]
[
int
]
NULL
,
[
P_TopTime
]
[
smalldatetime
]
NULL
,
[
AddTime
]
[
datetime
]
NULL
,
[
AddUser
]
[
nvarchar
]
(
50
)
NULL
,
[
ModTime
]
[
datetime
]
NULL
,
[
ModUser
]
[
nvarchar
]
(
50
)
NULL
,
[
P_BigImage
]
[
nvarchar
]
(
150
)
NULL
,
[
P_SmallImage
]
[
nvarchar
]
(
150
)
NULL
,
[
P_BigImage2
]
[
nvarchar
]
(
150
)
NULL
,
[
P_SmallImage2
]
[
nvarchar
]
(
150
)
NULL
,
[
P_BigImage3
]
[
nvarchar
]
(
150
)
NULL
,
[
P_SmallImage3
]
[
nvarchar
]
(
150
)
NULL
,
[
LoginID
]
[
nvarchar
]
(
50
)
NULL
,
[
CurState
]
[
smallint
]
NOT
NULL
CONSTRAINT
[
DF__Product__CurStat__0A688BB1
]
DEFAULT
((
0
)),
[
RecState
]
[
smallint
]
NOT
NULL
CONSTRAINT
[
DF_Product_RecCtate
]
DEFAULT
((
0
)),
[
P_CheckInfo
]
[
nvarchar
]
(
80
)
NULL
,
[
P_Max
]
[
nvarchar
]
(
30
)
NULL
,
[
P_Min
]
[
nvarchar
]
(
30
)
NULL
,
[
P_Unit
]
[
nvarchar
]
(
50
)
NULL
,
[
P_L_ID
]
[
int
]
NULL
,
[
C_ID
]
[
int
]
NULL
,
[
C_I_ID
]
[
int
]
NULL
CONSTRAINT
[
DF__Product__C_I_ID__0B5CAFEA
]
DEFAULT
((
0
)),
[
P_NewInfo
]
[
nvarchar
]
(
1000
)
NULL
,
[
P_Price
]
[
nvarchar
]
(
50
)
NULL
,
[
P_OtherState
]
[
int
]
NULL
,
[
P_NewKey1
]
[
nvarchar
]
(
300
)
NULL
,
[
P_NewKey2
]
[
nvarchar
]
(
300
)
NULL
,
[
P_NewKey3
]
[
nvarchar
]
(
300
)
NULL
,
[
F1
]
[
int
]
NOT
NULL
CONSTRAINT
[
DF__Product__F1__0C50D423
]
DEFAULT
((
0
)),
[
F2
]
[
int
]
NOT
NULL
CONSTRAINT
[
DF__Product__F2__0D44F85C
]
DEFAULT
((
0
)),
[
F3
]
[
nvarchar
]
(
50
)
NULL
,
[
F4
]
[
nvarchar
]
(
200
)
NULL
,
[
WebSite
]
[
nvarchar
]
(
50
)
NULL
,
[
Languages
]
[
nvarchar
]
(
20
)
NULL
,
CONSTRAINT
[
PK_PRODUCT
]
PRIMARY
KEY
CLUSTERED
(
[
P_ID
]
ASC
)
WITH
(PAD_INDEX
=
OFF
,STATISTICS_NORECOMPUTE
=
OFF
,IGNORE_DUP_KEY
=
OFF
,ALLOW_ROW_LOCKS
=
ON
,ALLOW_PAGE_LOCKS
=
ON
)
ON
[
PRIMARY
]
)
ON
[
PRIMARY
]
TEXTIMAGE_ON
[
PRIMARY
]
END
SET
Identity_Insert
dbo.Product
ON
INSERT
INTO
dbo.Product(
P_ID,P_Name,P_E_ID,CategoryID1,
CategoryID2,CategoryID3,CategoryID4,CategoryID5,
CategoryID6,P_SysCate,P_Key,P_SellArea,
P_SingleIntro,P_Intro,P_Order,P_Cate,
P_Cate1,P_Cate2,P_Cate3,P_C_Order,
P_TopTime,AddTime,AddUser,ModTime,
ModUser,P_BigImage,P_SmallImage,P_BigImage2,
P_SmallImage2,P_BigImage3,P_SmallImage3,LoginID,
CurState,RecState,P_CheckInfo,P_Max,
P_Min,P_Unit,P_L_ID,C_ID,
C_I_ID,P_NewInfo,P_Price,P_OtherState,
P_NewKey1,P_NewKey2,P_NewKey3,F1,
F2,F3,F4,WebSite,
Languages)
VALUES
(
262144
,
'
成功1号
'
,
0
,
4
,
9
,
332
,
0
,
0
,
0
,
'
花椰菜
'
,
'
花菜种子，花椰菜种子，白花菜种子
'
,
'
1
'
,
'
花椰菜种子,特征特性：一般株高65厘米，开展度65-70厘米，叶深绿色，长椭圆形，蜡粉中等，叶柄短，
'
,
'
<P>
特征特性：一般株高65厘米，开展度65-70厘米，叶深绿色，长椭圆形，蜡粉中等，叶柄短，脚特短，节间特别紧密，芯叶多层扭卷护球。部份叶柄嵌入花球
下方，使花球成圆球形，花球三叠，特别洁白坚实紧密，质地柔嫩，鲜美可口，比重特大。一般单花球重2-3千克左右，适应性广，耐运输，还是冷冻出口创汇的
好原料。元旦前上市。结球期适应温度7-10℃。</P>
<P> 栽
培要点：该品种适宜北纬31℃以内种植。浙江省一般7月下旬播种为宜，其它地区敬请参照当地气候与栽培习惯，慎选最佳播期。一般南稍迟、北稍早；沿海平原
稍迟、内陆山区稍早。苗期适当遮荫，搭架避雨，苗龄25-30天（包括假植时间）。合理密植，每亩1400-1500株。施足基肥，成活后淡肥勤施，花球
形成后（时）重施追肥2-3次。及时摘叶盖花，生长期间要防治病虫害和结球期鼠害。
<BR> 播种期间不适，苗期过长，肥水管理跟不上，遇到天气长期高温晴旱或
暴雨淋伤根系都会提早形成花球，球小品质差。严重时容易出现毛花、异花（畸形花）。要照样施肥水，有利于增加产量，提高质量。</P>
'
,
0
,
'
Seed
'
,
20
,
0
,
0
,
0
,
'
2008-02-2800:00:00.000
'
,
'
2004-10-0917:37:00.000
'
,
NULL
,
'
2008-03-1319:35:59.140
'
,
'
qbd
'
,
'
20064201105007754.jpg
'
,
'
20064201105004166.jpg
'
,
''
,
''
,
''
,
''
,
'
qingyiseeds
'
,
1
,
0
,
''
,
''
,
''
,
'
千克/公斤
'
,
0
,
10633
,
0
,
''
,
''
,
0
,
'
花菜种子，花椰菜种子，白花菜种子
'
,
''
,
''
,
0
,
0
,
''
,
''
,
'
agronet
'
,
'
cn
'
)
GO
Set
Identity_Insert
dbo.Product
OFF
假定己插入2048条记录
二、创建ConSole Application
主要三个类如下：
最常见的用法：
第二种用法(Reflect)：
<!-- <br />
<br />
Code highlighting produced by Actipro CodeHighlighter (freeware)<br />
http://www.CodeHighlighter.com/<br />
<br />
-->using
System;
using
System.Data.SqlClient;
using
System.Reflection;
namespace
DynamicMappingSpike
{
public
class
ReflectionBuilder
<
T
>
{
private
PropertyInfo[]properties;
private
ReflectionBuilder()
{}
public
TBuild(SqlDataReaderreader)
{
Tresult
=
(T)Activator.CreateInstance(
typeof
(T));
for
(
int
i
=
0
;i
<
reader.FieldCount;i
++
)
{
if
(properties[i]
!=
null
&&
!
reader.IsDBNull(i))
{
properties[i].SetValue(result,reader[i],
null
);
}
}
return
result;
}
public
static
ReflectionBuilder
<
T
>
CreateBuilder(SqlDataReaderreader)
{
ReflectionBuilder
<
T
>
result
=
new
ReflectionBuilder
<
T
>
();
result.properties
=
new
PropertyInfo[reader.FieldCount];
for
(
int
i
=
0
;i
<
reader.FieldCount;i
++
)
{
result.properties[i]
=
typeof
(T).GetProperty(reader.GetName(i));
}
return
result;
}
}
}
using System;
using System.Data.SqlClient;
using System.Reflection;
namespace DynamicMappingSpike
{
public class ReflectionBuilder<T>
{
private PropertyInfo[] properties;
private ReflectionBuilder() { }
public T Build(SqlDataReader reader)
{
T result = (T)Activator.CreateInstance(typeof(T));
for (int i = 0; i < reader.FieldCount; i++)
{
if (properties[i] != null && !reader.IsDBNull(i))
{
properties[i].SetValue(result, reader[i], null);
}
}
return result;
}
public static ReflectionBuilder<T> CreateBuilder(SqlDataReader reader)
{
ReflectionBuilder<T> result = new ReflectionBuilder<T>();
result.properties = new PropertyInfo[reader.FieldCount];
for (int i = 0; i < reader.FieldCount; i++)
{
result.properties[i] = typeof(T).GetProperty(reader.GetName(i));
}
return result;
}
}
}
第三种用法(DynaMicmethod ,基于IL）
<!-- <br />
<br />
Code highlighting produced by Actipro CodeHighlighter (freeware)<br />
http://www.CodeHighlighter.com/<br />
<br />
-->using
System;
using
System.Data.SqlClient;
using
System.Reflection;
using
System.Reflection.Emit;
using
System.Data;
namespace
DownmoonTestConsole
{
public
class
DynamicBuilder
<
T
>
{
private
static
readonly
MethodInfogetValueMethod
=
typeof
(IDataRecord).GetMethod(
"
get_Item
"
,
new
Type[]
{
typeof
(
int
)}
);
private
static
readonly
MethodInfoisDBNullMethod
=
typeof
(IDataRecord).GetMethod(
"
IsDBNull
"
,
new
Type[]
{
typeof
(
int
)}
);
private
delegate
TLoad(IDataRecorddataRecord);
private
Loadhandler;
private
DynamicBuilder()
{}
public
TBuild(IDataRecorddataRecord)
{
return
handler(dataRecord);
}
public
static
DynamicBuilder
<
T
>
CreateBuilder(IDataRecorddataRecord)
{
DynamicBuilder
<
T
>
dynamicBuilder
=
new
DynamicBuilder
<
T
>
();
DynamicMethodmethod
=
new
DynamicMethod(
"
DynamicCreate
"
,
typeof
(T),
new
Type[]
{
typeof
(IDataRecord)}
,
typeof
(T),
true
);
ILGeneratorgenerator
=
method.GetILGenerator();
LocalBuilderresult
=
generator.DeclareLocal(
typeof
(T));
generator.Emit(OpCodes.Newobj,
typeof
(T).GetConstructor(Type.EmptyTypes));
generator.Emit(OpCodes.Stloc,result);
for
(
int
i
=
0
;i
<
dataRecord.FieldCount;i
++
)
{
PropertyInfopropertyInfo
=
typeof
(T).GetProperty(dataRecord.GetName(i));
LabelendIfLabel
=
generator.DefineLabel();
if
(propertyInfo
!=
null
&&
propertyInfo.GetSetMethod()
!=
null
)
{
generator.Emit(OpCodes.Ldarg_0);
generator.Emit(OpCodes.Ldc_I4,i);
generator.Emit(OpCodes.Callvirt,isDBNullMethod);
generator.Emit(OpCodes.Brtrue,endIfLabel);
generator.Emit(OpCodes.Ldloc,result);
generator.Emit(OpCodes.Ldarg_0);
generator.Emit(OpCodes.Ldc_I4,i);
generator.Emit(OpCodes.Callvirt,getValueMethod);
generator.Emit(OpCodes.Unbox_Any,dataRecord.GetFieldType(i));
generator.Emit(OpCodes.Callvirt,propertyInfo.GetSetMethod());
generator.MarkLabel(endIfLabel);
}
}
generator.Emit(OpCodes.Ldloc,result);
generator.Emit(OpCodes.Ret);
dynamicBuilder.handler
=
(Load)method.CreateDelegate(
typeof
(Load));
return
dynamicBuilder;
}
}
}
using System;
using System.Data.SqlClient;
using System.Reflection;
using System.Reflection.Emit;
using System.Data;
namespace DownmoonTestConsole
{
public class DynamicBuilder<T>
{
private static readonly MethodInfo getValueMethod = typeof(IDataRecord).GetMethod("get_Item", new Type[] { typeof(int) });
private static readonly MethodInfo isDBNullMethod = typeof(IDataRecord).GetMethod("IsDBNull", new Type[] { typeof(int) });
private delegate T Load(IDataRecord dataRecord);
private Load handler;
private DynamicBuilder() { }
public T Build(IDataRecord dataRecord)
{
return handler(dataRecord);
}
public static DynamicBuilder<T> CreateBuilder(IDataRecord dataRecord)
{
DynamicBuilder<T> dynamicBuilder = new DynamicBuilder<T>();
DynamicMethod method = new DynamicMethod("DynamicCreate", typeof(T), new Type[] { typeof(IDataRecord) }, typeof(T), true);
ILGenerator generator = method.GetILGenerator();
LocalBuilder result = generator.DeclareLocal(typeof(T));
generator.Emit(OpCodes.Newobj, typeof(T).GetConstructor(Type.EmptyTypes));
generator.Emit(OpCodes.Stloc, result);
for (int i = 0; i < dataRecord.FieldCount; i++)
{
PropertyInfo propertyInfo = typeof(T).GetProperty(dataRecord.GetName(i));
Label endIfLabel = generator.DefineLabel();
if (propertyInfo != null && propertyInfo.GetSetMethod() != null)
{
generator.Emit(OpCodes.Ldarg_0);
generator.Emit(OpCodes.Ldc_I4, i);
generator.Emit(OpCodes.Callvirt, isDBNullMethod);
generator.Emit(OpCodes.Brtrue, endIfLabel);
generator.Emit(OpCodes.Ldloc, result);
generator.Emit(OpCodes.Ldarg_0);
generator.Emit(OpCodes.Ldc_I4, i);
generator.Emit(OpCodes.Callvirt, getValueMethod);
generator.Emit(OpCodes.Unbox_Any, dataRecord.GetFieldType(i));
generator.Emit(OpCodes.Callvirt, propertyInfo.GetSetMethod());
generator.MarkLabel(endIfLabel);
}
}
generator.Emit(OpCodes.Ldloc, result);
generator.Emit(OpCodes.Ret);
dynamicBuilder.handler = (Load)method.CreateDelegate(typeof(Load));
return dynamicBuilder;
}
}
}
基于的实体类
using System;
namespace Agronet.Product.Framework.Components
{
Product#region Product
public class Product
{
private long m_P_ID;
/**//// <summary>
/// 产品ID
/// </summary>
public long P_ID
{
get { return m_P_ID; }
set { m_P_ID = value; }
}
private string m_P_Name;
/**//// <summary>
/// 产品名称
/// </summary>
public string P_Name
{
get { return m_P_Name; }
set { m_P_Name = value; }
}
private int m_P_E_ID;
/**//// <summary>
/// 分类扩展属性ID
/// </summary>
public int P_E_ID
{
get { return m_P_E_ID; }
set { m_P_E_ID = value; }
}
private int m_CategoryID1;
/**//// <summary>
/// 产品产业分类
/// </summary>
public int CategoryID1
{
get { return m_CategoryID1; }
set { m_CategoryID1 = value; }
}
private int m_CategoryID2;
/**//// <summary>
/// 产品行业分类
/// </summary>
public int CategoryID2
{
get { return m_CategoryID2; }
set { m_CategoryID2 = value; }
}
private int m_CategoryID3;
/**//// <summary>
/// 第三分类ID
/// </summary>
public int CategoryID3
{
get { return m_CategoryID3; }
set { m_CategoryID3 = value; }
}
private int m_CategoryID4;
/**//// <summary>
/// 第四分类ID
/// </summary>
public int CategoryID4
{
get { return m_CategoryID4; }
set { m_CategoryID4 = value; }
}
private int m_CategoryID5;
/**//// <summary>
/// 第五分类ID
/// </summary>
public int CategoryID5
{
get { return m_CategoryID5; }
set { m_CategoryID5 = value; }
}
private int m_CategoryID6;
/**//// <summary>
/// 第六分类ID
/// </summary>
public int CategoryID6
{
get { return m_CategoryID6; }
set { m_CategoryID6 = value; }
}
private string m_P_SysCate;
/**//// <summary>
/// 系统分类(旧）
/// </summary>
public string P_SysCate
{
get { return m_P_SysCate; }
set { m_P_SysCate = value; }
}
private string m_P_Key;
/**//// <summary>
/// 关键字
/// </summary>
public string P_Key
{
get { return m_P_Key; }
set { m_P_Key = value; }
}
private string m_P_SellArea;
/**//// <summary>
/// 产品销售地区
/// </summary>
public string P_SellArea
{
get { return m_P_SellArea; }
set { m_P_SellArea = value; }
}
private string m_P_SingleIntro;
/**//// <summary>
/// 简介
/// </summary>
public string P_SingleIntro
{
get { return m_P_SingleIntro; }
set { m_P_SingleIntro = value; }
}
private string m_P_Intro;
/**//// <summary>
/// 介绍
/// </summary>
public string P_Intro
{
get { return m_P_Intro; }
set { m_P_Intro = value; }
}
private double m_P_Order;
/**//// <summary>
/// 排序
/// </summary>
public double P_Order
{
get { return m_P_Order; }
set { m_P_Order = value; }
}
private string m_P_Cate;
/**//// <summary>
/// 分类(旧)
/// </summary>
public string P_Cate
{
get { return m_P_Cate; }
set { m_P_Cate = value; }
}
private int m_P_Cate1;
/**//// <summary>
/// 产品原分类1
/// </summary>
public int P_Cate1
{
get { return m_P_Cate1; }
set { m_P_Cate1 = value; }
}
private int m_P_Cate2;
/**//// <summary>
/// 产品原分类2
/// </summary>
public int P_Cate2
{
get { return m_P_Cate2; }
set { m_P_Cate2 = value; }
}
private int m_P_Cate3;
/**//// <summary>
/// 产品原分类3
/// </summary>
public int P_Cate3
{
get { return m_P_Cate3; }
set { m_P_Cate3 = value; }
}
private int m_P_C_Order;
/**//// <summary>
/// 企业顺序
/// </summary>
public int P_C_Order
{
get { return m_P_C_Order; }
set { m_P_C_Order = value; }
}
private DateTime m_P_TopTime;
/**//// <summary>
/// 置顶时间
/// </summary>
public DateTime P_TopTime
{
get { return m_P_TopTime; }
set { m_P_TopTime = value; }
}
private DateTime m_AddTime;
/**//// <summary>
/// 新增时间
/// </summary>
public DateTime AddTime
{
get { return m_AddTime; }
set { m_AddTime = value; }
}
private string m_AddUser;
/**//// <summary>
/// 新增用户
/// </summary>
public string AddUser
{
get { return m_AddUser; }
set { m_AddUser = value; }
}
private DateTime m_ModTime;
/**//// <summary>
/// 修改时间
/// </summary>
public DateTime ModTime
{
get { return m_ModTime; }
set { m_ModTime = value; }
}
private string m_ModUser;
/**//// <summary>
/// 修改人
/// </summary>
public string ModUser
{
get { return m_ModUser; }
set { m_ModUser = value; }
}
private string m_P_BigImage;
/**//// <summary>
/// 大图地址
/// </summary>
public string P_BigImage
{
get { return m_P_BigImage; }
set { m_P_BigImage = value; }
}
private string m_P_SmallImage;
/**//// <summary>
/// 小图地址
/// </summary>
public string P_SmallImage
{
get { return m_P_SmallImage; }
set { m_P_SmallImage = value; }
}
private string m_P_BigImage2;
/**//// <summary>
/// 大图地址2
/// </summary>
public string P_BigImage2
{
get { return m_P_BigImage2; }
set { m_P_BigImage2 = value; }
}
private string m_P_SmallImage2;
/**//// <summary>
/// 小图地址2
/// </summary>
public string P_SmallImage2
{
get { return m_P_SmallImage2; }
set { m_P_SmallImage2 = value; }
}
private string m_P_BigImage3;
/**//// <summary>
/// 大图地址3
/// </summary>
public string P_BigImage3
{
get { return m_P_BigImage3; }
set { m_P_BigImage3 = value; }
}
private string m_P_SmallImage3;
/**//// <summary>
/// 小图地址3
/// </summary>
public string P_SmallImage3
{
get { return m_P_SmallImage3; }
set { m_P_SmallImage3 = value; }
}
private string m_LoginID;
/**//// <summary>
/// 登录帐号
/// </summary>
public string LoginID
{
get { return m_LoginID; }
set { m_LoginID = value; }
}
private short m_CurState;
/**//// <summary>
/// 审核状态
/// </summary>
public short CurState
{
get { return m_CurState; }
set { m_CurState = value; }
}
private short m_RecState;
/**//// <summary>
/// 推荐状态
/// </summary>
public short RecState
{
get { return m_RecState; }
set { m_RecState = value; }
}
private string m_P_CheckInfo;
/**//// <summary>
/// 审核信息
/// </summary>
public string P_CheckInfo
{
get { return m_P_CheckInfo; }
set { m_P_CheckInfo = value; }
}
private string m_P_Max;
/**//// <summary>
/// 单价上限
/// </summary>
public string P_Max
{
get { return m_P_Max; }
set { m_P_Max = value; }
}
private string m_P_Min;
/**//// <summary>
/// 单价下限
/// </summary>
public string P_Min
{
get { return m_P_Min; }
set { m_P_Min = value; }
}
private string m_P_Unit;
/**//// <summary>
/// 单价单位
/// </summary>
public string P_Unit
{
get { return m_P_Unit; }
set { m_P_Unit = value; }
}
private int m_P_L_ID;
/**//// <summary>
/// 商标ID
/// </summary>
public int P_L_ID
{
get { return m_P_L_ID; }
set { m_P_L_ID = value; }
}
private int m_C_ID;
/**//// <summary>
/// 企业ID
/// </summary>
public int C_ID
{
get { return m_C_ID; }
set { m_C_ID = value; }
}
private int m_C_I_ID;
/**//// <summary>
/// 联系方式ID
/// </summary>
public int C_I_ID
{
get { return m_C_I_ID; }
set { m_C_I_ID = value; }
}
private string m_P_NewInfo;
/**//// <summary>
/// 扩展联系方式
/// </summary>
public string P_NewInfo
{
get { return m_P_NewInfo; }
set { m_P_NewInfo = value; }
}
private string m_P_Price;
/**//// <summary>
/// 价格(旧)
/// </summary>
public string P_Price
{
get { return m_P_Price; }
set { m_P_Price = value; }
}
private int m_P_OtherState;
/**//// <summary>
/// 其他状态
/// </summary>
public int P_OtherState
{
get { return m_P_OtherState; }
set { m_P_OtherState = value; }
}
private string m_P_NewKey1;
/**//// <summary>
/// 新关键字一
/// </summary>
public string P_NewKey1
{
get { return m_P_NewKey1; }
set { m_P_NewKey1 = value; }
}
private string m_P_NewKey2;
/**//// <summary>
/// 新关键字二
/// </summary>
public string P_NewKey2
{
get { return m_P_NewKey2; }
set { m_P_NewKey2 = value; }
}
private string m_P_NewKey3;
/**//// <summary>
/// 新关键字三
/// </summary>
public string P_NewKey3
{
get { return m_P_NewKey3; }
set { m_P_NewKey3 = value; }
}
private int m_F1;
/**//// <summary>
/// 扩展1
/// </summary>
public int F1
{
get { return m_F1; }
set { m_F1 = value; }
}
private int m_F2;
/**//// <summary>
/// 扩展2
/// </summary>
public int F2
{
get { return m_F2; }
set { m_F2 = value; }
}
private string m_F3;
/**//// <summary>
/// 扩展3
/// </summary>
public string F3
{
get { return m_F3; }
set { m_F3 = value; }
}
private string m_F4;
/**//// <summary>
/// 扩展4
/// </summary>
public string F4
{
get { return m_F4; }
set { m_F4 = value; }
}
private string m_WebSite;
/**//// <summary>
/// 网站
/// </summary>
public string WebSite
{
get { return m_WebSite; }
set { m_WebSite = value; }
}
private string m_Languages;
/**//// <summary>
/// 语言
/// </summary>
public string Languages
{
get { return m_Languages; }
set { m_Languages = value; }
}
}
#endregion
}
<!-- <br />
<br />
Code highlighting produced by Actipro CodeHighlighter (freeware)<br />
http://www.CodeHighlighter.com/<br />
<br />
-->
using
System;
namespace
Agronet.Product.Framework.Components
{
Product
#region
Product
public
class
Product
{
private
long
m_P_ID;
/**/
///
<summary>
///
产品ID
///
</summary>
public
long
P_ID
{
get
{
return
m_P_ID;}
set
{m_P_ID
=
value;}
}
private
string
m_P_Name;
/**/
///
<summary>
///
产品名称
///
</summary>
public
string
P_Name
{
get
{
return
m_P_Name;}
set
{m_P_Name
=
value;}
}
private
int
m_P_E_ID;
/**/
///
<summary>
///
分类扩展属性ID
///
</summary>
public
int
P_E_ID
{
get
{
return
m_P_E_ID;}
set
{m_P_E_ID
=
value;}
}
private
int
m_CategoryID1;
/**/
///
<summary>
///
产品产业分类
///
</summary>
public
int
CategoryID1
{
get
{
return
m_CategoryID1;}
set
{m_CategoryID1
=
value;}
}
private
int
m_CategoryID2;
/**/
///
<summary>
///
产品行业分类
///
</summary>
public
int
CategoryID2
{
get
{
return
m_CategoryID2;}
set
{m_CategoryID2
=
value;}
}
private
int
m_CategoryID3;
/**/
///
<summary>
///
第三分类ID
///
</summary>
public
int
CategoryID3
{
get
{
return
m_CategoryID3;}
set
{m_CategoryID3
=
value;}
}
private
int
m_CategoryID4;
/**/
///
<summary>
///
第四分类ID
///
</summary>
public
int
CategoryID4
{
get
{
return
m_CategoryID4;}
set
{m_CategoryID4
=
value;}
}
private
int
m_CategoryID5;
/**/
///
<summary>
///
第五分类ID
///
</summary>
public
int
CategoryID5
{
get
{
return
m_CategoryID5;}
set
{m_CategoryID5
=
value;}
}
private
int
m_CategoryID6;
/**/
///
<summary>
///
第六分类ID
///
</summary>
public
int
CategoryID6
{
get
{
return
m_CategoryID6;}
set
{m_CategoryID6
=
value;}
}
private
string
m_P_SysCate;
/**/
///
<summary>
///
系统分类(旧）
///
</summary>
public
string
P_SysCate
{
get
{
return
m_P_SysCate;}
set
{m_P_SysCate
=
value;}
}
private
string
m_P_Key;
/**/
///
<summary>
///
关键字
///
</summary>
public
string
P_Key
{
get
{
return
m_P_Key;}
set
{m_P_Key
=
value;}
}
private
string
m_P_SellArea;
/**/
///
<summary>
///
产品销售地区
///
</summary>
public
string
P_SellArea
{
get
{
return
m_P_SellArea;}
set
{m_P_SellArea
=
value;}
}
private
string
m_P_SingleIntro;
/**/
///
<summary>
///
简介
///
</summary>
public
string
P_SingleIntro
{
get
{
return
m_P_SingleIntro;}
set
{m_P_SingleIntro
=
value;}
}
private
string
m_P_Intro;
/**/
///
<summary>
///
介绍
///
</summary>
public
string
P_Intro
{
get
{
return
m_P_Intro;}
set
{m_P_Intro
=
value;}
}
private
double
m_P_Order;
/**/
///
<summary>
///
排序
///
</summary>
public
double
P_Order
{
get
{
return
m_P_Order;}
set
{m_P_Order
=
value;}
}
private
string
m_P_Cate;
/**/
///
<summary>
///
分类(旧)
///
</summary>
public
string
P_Cate
{
get
{
return
m_P_Cate;}
set
{m_P_Cate
=
value;}
}
private
int
m_P_Cate1;
/**/
///
<summary>
///
产品原分类1
///
</summary>
public
int
P_Cate1
{
get
{
return
m_P_Cate1;}
set
{m_P_Cate1
=
value;}
}
private
int
m_P_Cate2;
/**/
///
<summary>
///
产品原分类2
///
</summary>
public
int
P_Cate2
{
get
{
return
m_P_Cate2;}
set
{m_P_Cate2
=
value;}
}
private
int
m_P_Cate3;
/**/
///
<summary>
///
产品原分类3
///
</summary>
public
int
P_Cate3
{
get
{
return
m_P_Cate3;}
set
{m_P_Cate3
=
value;}
}
private
int
m_P_C_Order;
/**/
///
<summary>
///
企业顺序
///
</summary>
public
int
P_C_Order
{
get
{
return
m_P_C_Order;}
set
{m_P_C_Order
=
value;}
}
private
DateTimem_P_TopTime;
/**/
///
<summary>
///
置顶时间
///
</summary>
public
DateTimeP_TopTime
{
get
{
return
m_P_TopTime;}
set
{m_P_TopTime
=
value;}
}
private
DateTimem_AddTime;
/**/
///
<summary>
///
新增时间
///
</summary>
public
DateTimeAddTime
{
get
{
return
m_AddTime;}
set
{m_AddTime
=
value;}
}
private
string
m_AddUser;
/**/
///
<summary>
///
新增用户
///
</summary>
public
string
AddUser
{
get
{
return
m_AddUser;}
set
{m_AddUser
=
value;}
}
private
DateTimem_ModTime;
/**/
///
<summary>
///
修改时间
///
</summary>
public
DateTimeModTime
{
get
{
return
m_ModTime;}
set
{m_ModTime
=
value;}
}
private
string
m_ModUser;
/**/
///
<summary>
///
修改人
///
</summary>
public
string
ModUser
{
get
{
return
m_ModUser;}
set
{m_ModUser
=
value;}
}
private
string
m_P_BigImage;
/**/
///
<summary>
///
大图地址
///
</summary>
public
string
P_BigImage
{
get
{
return
m_P_BigImage;}
set
{m_P_BigImage
=
value;}
}
private
string
m_P_SmallImage;
/**/
///
<summary>
///
小图地址
///
</summary>
public
string
P_SmallImage
{
get
{
return
m_P_SmallImage;}
set
{m_P_SmallImage
=
value;}
}
private
string
m_P_BigImage2;
/**/
///
<summary>
///
大图地址2
///
</summary>
public
string
P_BigImage2
{
get
{
return
m_P_BigImage2;}
set
{m_P_BigImage2
=
value;}
}
private
string
m_P_SmallImage2;
/**/
///
<summary>
///
小图地址2
///
</summary>
public
string
P_SmallImage2
{
get
{
return
m_P_SmallImage2;}
set
{m_P_SmallImage2
=
value;}
}
private
string
m_P_BigImage3;
/**/
///
<summary>
///
大图地址3
///
</summary>
public
string
P_BigImage3
{
get
{
return
m_P_BigImage3;}
set
{m_P_BigImage3
=
value;}
}
private
string
m_P_SmallImage3;
/**/
///
<summary>
///
小图地址3
///
</summary>
public
string
P_SmallImage3
{
get
{
return
m_P_SmallImage3;}
set
{m_P_SmallImage3
=
value;}
}
private
string
m_LoginID;
/**/
///
<summary>
///
登录帐号
///
</summary>
public
string
LoginID
{
get
{
return
m_LoginID;}
set
{m_LoginID
=
value;}
}
private
short
m_CurState;
/**/
///
<summary>
///
审核状态
///
</summary>
public
short
CurState
{
get
{
return
m_CurState;}
set
{m_CurState
=
value;}
}
private
short
m_RecState;
/**/
///
<summary>
///
推荐状态
///
</summary>
public
short
RecState
{
get
{
return
m_RecState;}
set
{m_RecState
=
value;}
}
private
string
m_P_CheckInfo;
/**/
///
<summary>
///
审核信息
///
</summary>
public
string
P_CheckInfo
{
get
{
return
m_P_CheckInfo;}
set
{m_P_CheckInfo
=
value;}
}
private
string
m_P_Max;
/**/
///
<summary>
///
单价上限
///
</summary>
public
string
P_Max
{
get
{
return
m_P_Max;}
set
{m_P_Max
=
value;}
}
private
string
m_P_Min;
/**/
///
<summary>
///
单价下限
///
</summary>
public
string
P_Min
{
get
{
return
m_P_Min;}
set
{m_P_Min
=
value;}
}
private
string
m_P_Unit;
/**/
///
<summary>
///
单价单位
///
</summary>
public
string
P_Unit
{
get
{
return
m_P_Unit;}
set
{m_P_Unit
=
value;}
}
private
int
m_P_L_ID;
/**/
///
<summary>
///
商标ID
///
</summary>
public
int
P_L_ID
{
get
{
return
m_P_L_ID;}
set
{m_P_L_ID
=
value;}
}
private
int
m_C_ID;
/**/
///
<summary>
///
企业ID
///
</summary>
public
int
C_ID
{
get
{
return
m_C_ID;}
set
{m_C_ID
=
value;}
}
private
int
m_C_I_ID;
/**/
///
<summary>
///
联系方式ID
///
</summary>
public
int
C_I_ID
{
get
{
return
m_C_I_ID;}
set
{m_C_I_ID
=
value;}
}
private
string
m_P_NewInfo;
/**/
///
<summary>
///
扩展联系方式
///
</summary>
public
string
P_NewInfo
{
get
{
return
m_P_NewInfo;}
set
{m_P_NewInfo
=
value;}
}
private
string
m_P_Price;
/**/
///
<summary>
///
价格(旧)
///
</summary>
public
string
P_Price
{
get
{
return
m_P_Price;}
set
{m_P_Price
=
value;}
}
private
int
m_P_OtherState;
/**/
///
<summary>
///
其他状态
///
</summary>
public
int
P_OtherState
{
get
{
return
m_P_OtherState;}
set
{m_P_OtherState
=
value;}
}
private
string
m_P_NewKey1;
/**/
///
<summary>
///
新关键字一
///
</summary>
public
string
P_NewKey1
{
get
{
return
m_P_NewKey1;}
set
{m_P_NewKey1
=
value;}
}
private
string
m_P_NewKey2;
/**/
///
<summary>
///
新关键字二
///
</summary>
public
string
P_NewKey2
{
get
{
return
m_P_NewKey2;}
set
{m_P_NewKey2
=
value;}
}
private
string
m_P_NewKey3;
/**/
///
<summary>
///
新关键字三
///
</summary>
public
string
P_NewKey3
{
get
{
return
m_P_NewKey3;}
set
{m_P_NewKey3
=
value;}
}
private
int
m_F1;
/**/
///
<summary>
///
扩展1
///
</summary>
public
int
F1
{
get
{
return
m_F1;}
set
{m_F1
=
value;}
}
private
int
m_F2;
/**/
///
<summary>
///
扩展2
///
</summary>
public
int
F2
{
get
{
return
m_F2;}
set
{m_F2
=
value;}
}
private
string
m_F3;
/**/
///
<summary>
///
扩展3
///
</summary>
public
string
F3
{
get
{
return
m_F3;}
set
{m_F3
=
value;}
}
private
string
m_F4;
/**/
///
<summary>
///
扩展4
///
</summary>
public
string
F4
{
get
{
return
m_F4;}
set
{m_F4
=
value;}
}
private
string
m_WebSite;
/**/
///
<summary>
///
网站
///
</summary>
public
string
WebSite
{
get
{
return
m_WebSite;}
set
{m_WebSite
=
value;}
}
private
string
m_Languages;
/**/
///
<summary>
///
语言
///
</summary>
public
string
Languages
{
get
{
return
m_Languages;}
set
{m_Languages
=
value;}
}
}
#endregion
}
测试主要方法
static SqlConnection connection = new SqlConnection(@"server=localhost;database=Testbigdata;uid=sa;pwd=sa");
static SqlCommand command = new SqlCommand("Select top 100 * From product order by P_ID asc ", connection);
public static void LoadManually()
{
using (SqlConnection connection = new SqlConnection(ConnStr))
{
SqlCommand command = new SqlCommand(CmdStr, connection);
connection.Open();
LoadManually(command);
connection.Close();
}
}
public static void LoadUsingReflection()
{
using (SqlConnection connection = new SqlConnection(ConnStr))
{
SqlCommand command = new SqlCommand(CmdStr, connection);
connection.Open();
LoadUsingReflection(command);
connection.Close();
}
}
public static void LoadUsingDynamicCode()
{
using (SqlConnection connection = new SqlConnection(ConnStr))
{
SqlCommand command = new SqlCommand(CmdStr, connection);
connection.Open();
LoadUsingDynamicCode(command);
connection.Close();
}
}
private static void LoadManually(SqlCommand command)
{
DateTime start = DateTime.Now;
Console.WriteLine("Start Manual Load: {0}", start);
using (SqlDataReader reader = command.ExecuteReader())
{
ManualBuilder builder = new ManualBuilder();
while (reader.Read())
{
Agronet.Product.Framework.Components.Product m_Product = builder.Build(reader);
}
}
DateTime stop = DateTime.Now;
Console.WriteLine("Stop Manual Load: {0}", stop);
Console.WriteLine("Elapsed Time: {0}", stop - start);
Console.WriteLine();
}
private static void LoadUsingReflection(SqlCommand command)
{
DateTime start = DateTime.Now;
Console.WriteLine("Start Reflection Load: {0}", start);
using (SqlDataReader reader = command.ExecuteReader())
{
ReflectionBuilder<Agronet.Product.Framework.Components.Product> builder = ReflectionBuilder<Agronet.Product.Framework.Components.Product>.CreateBuilder(reader);
while (reader.Read())
{
Agronet.Product.Framework.Components.Product m_Product = builder.Build(reader);
}
}
DateTime stop = DateTime.Now;
Console.WriteLine("Stop Reflection Load: {0}", stop);
Console.WriteLine("Elapsed Time: {0}", stop - start);
Console.WriteLine();
}
private static void LoadUsingDynamicCode(SqlCommand command)
{
DateTime start = DateTime.Now;
Console.WriteLine("Start Dynamic Load: {0}", start);
using (SqlDataReader reader = command.ExecuteReader())
{
DynamicBuilder<Agronet.Product.Framework.Components.Product> builder = DynamicBuilder<Agronet.Product.Framework.Components.Product>.CreateBuilder(reader);
while (reader.Read())
{
Agronet.Product.Framework.Components.Product m_Product = builder.Build(reader);
//Console.WriteLine("ID:"+m_Product.P_ID);
//Console.WriteLine("Name:"+m_Product.P_Name);
//Console.WriteLine("LoginID:"+m_Product.LoginID);
}
}
DateTime stop = DateTime.Now;
Console.WriteLine("Stop Dynamic Load: {0}", stop);
Console.WriteLine("Elapsed Time: {0}", stop - start);
Console.WriteLine();
}
在网络流量200的负载测试下
结果如图
结论 在vs2005环境下，从Reader流转化为List<T>或IList<T>时，Reflect方法效率最低，DynamicMethod次之，但性能与Manual方法相当接近，综合而言， DynamicMethod
代码量小，移植性好，性能相对也不错，值得推荐!
最主要的是：当Entity的属性值个数大于Reader的Column个数时，Reflect和DynamicMethod性能更佳，且不会报错！换言之，当你需取表中的某几个字段时，DynamicMwthod的优势是显而易见的！
