Mikel
1
using System;
2using System.Data;
3using System.Configuration;
4using System.Collections;
5using System.Web;
6using System.Web.Security;
7using System.Web.UI;
8using System.Web.UI.WebControls;
9using System.Web.UI.WebControls.WebParts;
10using System.Web.UI.HtmlControls;
11
12using IBatisNet.DataMapper;
13using System.Reflection;
14
15
/// <summary>
16
/// ODRM为结合ORM与DataSet,并自动根据O和DataSet生成对象，以便业务层处理
17
/// </summary>
18public partial class ODRM_test : PageBase
19{
20 protected void Page_Load(object sender, EventArgs e)
21
{
22 if (!IsPostBack)
23 {
24 DataSet set11 = Mapper.Instance().QueryForDataSet("SelectXTM_UserByKey_Test",UIhashtable);
25 DataTable table1 = ConvertDataTable(set11, "");
26 //这里为自己定义的序列化类
27 cXTM_User[] objModel = new cXTM_User[table1.Rows.Count];
28 //DataTable转化为序列化类数组
29 for (int y = 0; y < table1.Rows.Count; y++)
30 {
31 objModel[y] = new cXTM_User();
32 DataTableConvertObject(table1.Rows[y], objModel[y]);
33
}
34 //以DataSet模式绑定
35 ExDataGrid1.DataSource = table1;
36 //以序列化对象模式绑定
37 //ExDataGrid1.DataSource = objModel;
38 ExDataGrid1.DataBind();
39 }
40 }
41
42 protected void ExDataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
43 {
44 /*
45 * 该部分应用范围
46 * 查询一条数据的修改，可以用objModel.UserName
47 * 而不必再使用DataTable[0].Rows[0]["UserName"]的模式
48 * 提高面向对象的程度，并减少业务流程部分编码
49 */
50
51 if (e.Item.ItemIndex != –1)
52 {
53 cXTM_User objModel = new cXTM_User();
54
55 //如果为DataSet填充的DataGrid
56 if (e.Item.DataItem.GetType().FullName == "System.Data.DataRowView")
57 {
58 DataTableConvertObject((DataRow)((DataRowView)e.Item.DataItem).Row, objModel);
59 }
60 //否则认为为序列化对象填充
61 else
62 {
63 objModel = (cXTM_User)e.Item.DataItem;
64
65 }
66 }
67 }
68
69 #region 指定对象函数
70 /// <summary>
71 /// 数据集中一行DataRow转换为指定对象，并填充数据
72 /// </summary>
73 /// <param name="row">数据集中一行</param>
74 /// <param name="objModel">指定对象</param>
75 private void DataTableConvertObject(DataRow row, cXTM_User objModel)
76 {
77 Hashtable hTable = new Hashtable();
78 hTable = DataRowConvertHashtable(row);
79 Type entitytype = Type.GetType(objModel.GetType().AssemblyQualifiedName);
80
81 for (int j = 0; j < objModel.Propertylist.Length; j++)
82 {
83 PropertyInfo propertyinfo = entitytype.GetProperty(objModel.Propertylist[j]);
84 propertyinfo.SetValue(objModel, hTable[objModel.Propertylist[j]], null);
85 }
86 }
87
88 /// <summary>
89 /// 对象转换为哈希表
90 /// </summary>
91 /// <param name="objModel">有数据的对象</param>
92 /// <returns>填充数据后的哈希表</returns>
93 public Hashtable ObjectConvertHashtable(cXTM_User objModel)
94 {
95 Hashtable hTable = new Hashtable();
96 Type entitytype = Type.GetType(objModel.GetType().AssemblyQualifiedName);
97 for (int j = 0; j < objModel.Propertylist.Length; j++)
98 {
99 PropertyInfo propertyinfo = entitytype.GetProperty(objModel.Propertylist[j]);
100 hTable.Add(objModel.Propertylist[j], propertyinfo.GetValue(objModel, null));
101 }
102 return hTable;
103 }
104
105 /// <summary>
106 /// 对象转换为DataTable，并有单行DataRow
107 /// </summary>
108 /// <param name="objModel">有数据的对象</param>
109 /// <returns></returns>
110 public DataTable ObjectConvertDataTableWidthRow(cXTM_User objModel)
111 {
112 return ObjectConvertDataTableWidthRow(objModel, "");
113 }
114
115 /// <summary>
116 /// 对象转换为DataTable，并有单行DataRow
117 /// </summary>
118 /// <param name="objModel">有数据的对象</param>
119 /// <returns></returns>
120 public DataTable ObjectConvertDataTableWidthRow(cXTM_User objModel, string DataMapper)
121 {
122 Type entitytype = Type.GetType(objModel.GetType().AssemblyQualifiedName);
123 DataTable dt = new DataTable();
124 if (DataMapper != "")
125 {
126 dt = new DataTable(DataMapper);
127 }
128 dt.Columns.Clear();
129 for (int j = 0; j < objModel.Propertylist.Length; j++)
130 {
131 PropertyInfo propertyinfo = entitytype.GetProperty(objModel.Propertylist[j]);
132 dt.Columns.Add(new DataColumn(objModel.Propertylist[j], propertyinfo.GetType()));
133 }
134 DataRow row = dt.NewRow();
135 for (int j = 0; j < objModel.Propertylist.Length; j++)
136 {
137 PropertyInfo propertyinfo = entitytype.GetProperty(objModel.Propertylist[j]);
138 row[objModel.Propertylist[j]] = propertyinfo.GetValue(objModel, null);
139 }
140 dt.Rows.Add(row);
141
142 return dt;
143 }
144
145 /// <summary>
146 /// 对象转换为DataTable，并有多行DataRow
147 /// </summary>
148 /// <param name="objModel">有数据的对象</param>
149 /// <returns></returns>
150 public DataTable ObjectConvertDataTableWidthRows(cXTM_User[] objModel)
151 {
152 return ObjectConvertDataTableWidthRows(objModel, "");
153 }
154
155 /// <summary>
156 /// 对象转换为DataTable，并有多行DataRow
157 /// </summary>
158 /// <param name="objModel">有数据的对象</param>
159 /// <returns></returns>
160 public DataTable ObjectConvertDataTableWidthRows(cXTM_User[] objModel, string DataMapper)
161 {
162 Type entitytype = Type.GetType(objModel.GetType().AssemblyQualifiedName);
163 DataTable dt = new DataTable();
164 if (DataMapper != "")
165 {
166 dt = new DataTable(DataMapper);
167 }
168 if (objModel.Length == 0)
169 {
170 return dt;
171 }
172 dt.Columns.Clear();
173 for (int j = 0; j < objModel[0].Propertylist.Length; j++)
174 {
175 PropertyInfo propertyinfo = entitytype.GetProperty(objModel[0].Propertylist[j]);
176 dt.Columns.Add(new DataColumn(objModel[0].Propertylist[j], propertyinfo.GetType()));
177 }
178
179 for (int i = 0; i < objModel.Length; i++)
180 {
181 DataRow row = dt.NewRow();
182 for (int j = 0; j < objModel[i].Propertylist.Length; j++)
183 {
184 PropertyInfo propertyinfo = entitytype.GetProperty(objModel[i].Propertylist[j]);
185 row[objModel[i].Propertylist[j]] = propertyinfo.GetValue(objModel[i], null);
186 }
187 dt.Rows.Add(row);
188 }
189 return dt;
190 }
191 #endregion
192
193 #region 通用函数
194
195 /// <summary>
196 /// 转换为DataTable
197 /// </summary>
198 /// <param name="Source">数据源</param>
199 /// <param name="DataMember">数据表名称</param>
200 public static DataTable ConvertDataTable(object Source, string DataMember)
201 {
202 DataTable baseTable = new DataTable();
203 if (Source is DataTable)
204 {
205 baseTable = (DataTable)Source;
206 return baseTable;
207 }
208 if (Source is DataSet)
209 {
210
211 DataSet set1 = (DataSet)Source;
212 if ((set1.Tables.Count > 1) && ((DataMember == null) || (DataMember == "")))
213 {
214 throw new Exception("If there is more than one table in your dataset, you must define the DataMember property to specify which table to use.");
215 }
216 if (set1.Tables.Count < 1)
217 {
218 throw new Exception("There are no tables in the datasource.");
219 }
220 if ((DataMember != null) && (DataMember != ""))
221 {
222 baseTable = set1.Tables[DataMember];
223 return baseTable;
224 }
225 else
226 {
227 baseTable = set1.Tables[0];
228 return baseTable;
229 }
230
231 }
232 return baseTable;
233 }
234
235 /// <summary>
236 /// 返回DataTable为哈希表键值对
237 /// </summary>
238 /// <param name="SourceTable">数据行对象</param>
239 /// <returns>填充后哈希表</returns>
240 public static Hashtable DataRowConvertHashtable(DataRow SourceRow)
241 {
242 Hashtable hTable = new Hashtable();
243 IList list = SourceRow.ItemArray;
244 object[] tObj = new object[SourceRow.Table.Columns.Count];
245
246 for (int i = 0; i < SourceRow.Table.Columns.Count; i++)
247 {
248 tObj[SourceRow.Table.Columns.IndexOf(SourceRow.Table.Columns[i].ColumnName)] = SourceRow.Table.Columns[i].ColumnName;
249 }
250
251 for (int x = 0; x < list.Count; x++)
252 {
253 hTable.Add(tObj[x].ToString(), list[x]);
254 }
255 return hTable;
256 }
257
258 #endregion
259
260
261
262
263}
264
using System;2
using System.Data;3
using System.Configuration;4
using System.Collections;5
using System.Web;6
using System.Web.Security;7
using System.Web.UI;8
using System.Web.UI.WebControls;9
using System.Web.UI.WebControls.WebParts;10
using System.Web.UI.HtmlControls;11
12
using IBatisNet.DataMapper;13
using System.Reflection;14
15
/// <summary>
16
/// ODRM为结合ORM与DataSet,并自动根据O和DataSet生成对象，以便业务层处理17
/// </summary>18
public partial class ODRM_test : PageBase19
{
20
protected void Page_Load(object sender, EventArgs e)21
{
22
if (!IsPostBack)23
{24
DataSet set11 = Mapper.Instance().QueryForDataSet("SelectXTM_UserByKey_Test",UIhashtable);25
DataTable table1 = ConvertDataTable(set11, "");26
//这里为自己定义的序列化类27
cXTM_User[] objModel = new cXTM_User[table1.Rows.Count];28
//DataTable转化为序列化类数组29
for (int y = 0; y < table1.Rows.Count; y++)30
{31
objModel[y] = new cXTM_User();32
DataTableConvertObject(table1.Rows[y], objModel[y]); 33
}34
//以DataSet模式绑定35
ExDataGrid1.DataSource = table1;36
//以序列化对象模式绑定37
//ExDataGrid1.DataSource = objModel;38
ExDataGrid1.DataBind();39
}40
}41
42
protected void ExDataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)43
{44
/*45
* 该部分应用范围46
* 查询一条数据的修改，可以用objModel.UserName47
* 而不必再使用DataTable[0].Rows[0]["UserName"]的模式48
* 提高面向对象的程度，并减少业务流程部分编码49
*/50
51
if (e.Item.ItemIndex != –1)52
{53
cXTM_User objModel = new cXTM_User();54
55
//如果为DataSet填充的DataGrid56
if (e.Item.DataItem.GetType().FullName == "System.Data.DataRowView")57
{58
DataTableConvertObject((DataRow)((DataRowView)e.Item.DataItem).Row, objModel); 59
}60
//否则认为为序列化对象填充61
else 62
{63
objModel = (cXTM_User)e.Item.DataItem; 64
65
}66
}67
}68
69
#region 指定对象函数70
/// <summary>71
/// 数据集中一行DataRow转换为指定对象，并填充数据72
/// </summary>73
/// <param name="row">数据集中一行</param>74
/// <param name="objModel">指定对象</param>75
private void DataTableConvertObject(DataRow row, cXTM_User objModel)76
{77
Hashtable hTable = new Hashtable();78
hTable = DataRowConvertHashtable(row);79
Type entitytype = Type.GetType(objModel.GetType().AssemblyQualifiedName);80
81
for (int j = 0; j < objModel.Propertylist.Length; j++)82
{83
PropertyInfo propertyinfo = entitytype.GetProperty(objModel.Propertylist[j]);84
propertyinfo.SetValue(objModel, hTable[objModel.Propertylist[j]], null);85
}86
}87
88
/// <summary>89
/// 对象转换为哈希表90
/// </summary>91
/// <param name="objModel">有数据的对象</param>92
/// <returns>填充数据后的哈希表</returns>93
public Hashtable ObjectConvertHashtable(cXTM_User objModel)94
{95
Hashtable hTable = new Hashtable();96
Type entitytype = Type.GetType(objModel.GetType().AssemblyQualifiedName);97
for (int j = 0; j < objModel.Propertylist.Length; j++)98
{99
PropertyInfo propertyinfo = entitytype.GetProperty(objModel.Propertylist[j]);100
hTable.Add(objModel.Propertylist[j], propertyinfo.GetValue(objModel, null));101
}102
return hTable;103
}104
105
/// <summary>106
/// 对象转换为DataTable，并有单行DataRow107
/// </summary>108
/// <param name="objModel">有数据的对象</param>109
/// <returns></returns>110
public DataTable ObjectConvertDataTableWidthRow(cXTM_User objModel)111
{112
return ObjectConvertDataTableWidthRow(objModel, "");113
}114
115
/// <summary>116
/// 对象转换为DataTable，并有单行DataRow117
/// </summary>118
/// <param name="objModel">有数据的对象</param>119
/// <returns></returns>120
public DataTable ObjectConvertDataTableWidthRow(cXTM_User objModel, string DataMapper)121
{122
Type entitytype = Type.GetType(objModel.GetType().AssemblyQualifiedName);123
DataTable dt = new DataTable();124
if (DataMapper != "")125
{126
dt = new DataTable(DataMapper);127
}128
dt.Columns.Clear();129
for (int j = 0; j < objModel.Propertylist.Length; j++)130
{131
PropertyInfo propertyinfo = entitytype.GetProperty(objModel.Propertylist[j]);132
dt.Columns.Add(new DataColumn(objModel.Propertylist[j], propertyinfo.GetType()));133
}134
DataRow row = dt.NewRow();135
for (int j = 0; j < objModel.Propertylist.Length; j++)136
{137
PropertyInfo propertyinfo = entitytype.GetProperty(objModel.Propertylist[j]);138
row[objModel.Propertylist[j]] = propertyinfo.GetValue(objModel, null);139
}140
dt.Rows.Add(row);141
142
return dt;143
}144
145
/// <summary>146
/// 对象转换为DataTable，并有多行DataRow147
/// </summary>148
/// <param name="objModel">有数据的对象</param>149
/// <returns></returns>150
public DataTable ObjectConvertDataTableWidthRows(cXTM_User[] objModel)151
{152
return ObjectConvertDataTableWidthRows(objModel, "");153
}154
155
/// <summary>156
/// 对象转换为DataTable，并有多行DataRow157
/// </summary>158
/// <param name="objModel">有数据的对象</param>159
/// <returns></returns>160
public DataTable ObjectConvertDataTableWidthRows(cXTM_User[] objModel, string DataMapper)161
{162
Type entitytype = Type.GetType(objModel.GetType().AssemblyQualifiedName);163
DataTable dt = new DataTable();164
if (DataMapper != "")165
{166
dt = new DataTable(DataMapper);167
}168
if (objModel.Length == 0)169
{170
return dt;171
}172
dt.Columns.Clear();173
for (int j = 0; j < objModel[0].Propertylist.Length; j++)174
{175
PropertyInfo propertyinfo = entitytype.GetProperty(objModel[0].Propertylist[j]);176
dt.Columns.Add(new DataColumn(objModel[0].Propertylist[j], propertyinfo.GetType()));177
}178
179
for (int i = 0; i < objModel.Length; i++)180
{181
DataRow row = dt.NewRow();182
for (int j = 0; j < objModel[i].Propertylist.Length; j++)183
{184
PropertyInfo propertyinfo = entitytype.GetProperty(objModel[i].Propertylist[j]);185
row[objModel[i].Propertylist[j]] = propertyinfo.GetValue(objModel[i], null);186
}187
dt.Rows.Add(row);188
}189
return dt;190
}191
#endregion192
193
#region 通用函数194
195
/// <summary>196
/// 转换为DataTable197
/// </summary>198
/// <param name="Source">数据源</param>199
/// <param name="DataMember">数据表名称</param>200
public static DataTable ConvertDataTable(object Source, string DataMember)201
{202
DataTable baseTable = new DataTable();203
if (Source is DataTable)204
{205
baseTable = (DataTable)Source;206
return baseTable;207
}208
if (Source is DataSet)209
{210
211
DataSet set1 = (DataSet)Source;212
if ((set1.Tables.Count > 1) && ((DataMember == null) || (DataMember == "")))213
{214
throw new Exception("If there is more than one table in your dataset, you must define the DataMember property to specify which table to use.");215
}216
if (set1.Tables.Count < 1)217
{218
throw new Exception("There are no tables in the datasource.");219
}220
if ((DataMember != null) && (DataMember != ""))221
{222
baseTable = set1.Tables[DataMember];223
return baseTable;224
}225
else226
{227
baseTable = set1.Tables[0];228
return baseTable;229
}230
231
}232
return baseTable;233
}234
235
/// <summary>236
/// 返回DataTable为哈希表键值对237
/// </summary>238
/// <param name="SourceTable">数据行对象</param>239
/// <returns>填充后哈希表</returns>240
public static Hashtable DataRowConvertHashtable(DataRow SourceRow)241
{242
Hashtable hTable = new Hashtable();243
IList list = SourceRow.ItemArray;244
object[] tObj = new object[SourceRow.Table.Columns.Count];245
246
for (int i = 0; i < SourceRow.Table.Columns.Count; i++)247
{248
tObj[SourceRow.Table.Columns.IndexOf(SourceRow.Table.Columns[i].ColumnName)] = SourceRow.Table.Columns[i].ColumnName;249
}250
251
for (int x = 0; x < list.Count; x++)252
{253
hTable.Add(tObj[x].ToString(), list[x]);254
}255
return hTable;256
}257
258
#endregion259
260
261
262
263
}264
