UserData.cs
1
/////////////////////////////
2
//File:UserData.cs
3
//Data Created:2006年10月2日
4
//Created by:Slash
5
/////////////////////////////
6
namespace FreeZone.Common.Data
7
{
8
using System;
9
using System.Data;
10
using System.Runtime.Serialization;
11
12
/// <summary>
13
/// A custom serializable dataset containing order information.
14
/// <remarks>
15
/// This class is used to define the shape of OrderData.
16
/// </remarks>
17
/// <remarks>
18
/// The serializale constructor allows objects of type OrderData to be remoted.
19
/// </remarks>
20
/// </summary>
21
[System.ComponentModel.DesignerCategoryAttribute("Code")]
22
[SerializableAttribute]
23
public class UserData : DataSet
24
{
25
26
27
//
28
//User items table constants
29
//
30
///<value>The constant used for User table.</value>
31
public const String USER_TABLE = "User";
32
///<value>The constant used for PKID field in the User table.</value>
33
public const String PKID_FIELD = "PKID";
34
///<value>The constant used for UserName field in the User table.</value>
35
public const String USERNAME_FIELD = "UserName";
36
///<value>The constant used for Password field in the User table.</value>
37
public const String PASSWORD_FIELD = "Password";
38
///<value>The constant used for NickName field in the User table.</value>
39
public const String NICKNAME_FIELD = "NickName";
40
///<value>The constant used for Sex field in the User table.</value>
41
public const String SEX_FIELD = "Sex";
42
///<value>The constant used for Email field in the User table.</value>
43
public const String EMAIL_FIELD = "Email";
44
///<value>The constant used for Face field in the User table.</value>
45
public const String FACE_FIELD = "Face";
46
///<value>The constant used for EMoney field in the User table.</value>
47
public const String EMONEY_FIELD = "EMoney";
48
///<value>The constant used for Score field in the User table.</value>
49
public const String SCORE_FIELD = "Score";
50
///<value>The constant used for Credit field in the User table.</value>
51
public const String CREDIT_FIELD = "Credit";
52
///<value>The constant used for LevelUp field in the User table.</value>
53
public const String LEVELUP_FIELD = "LevelUp";
54
///<value>The constant used for UpdateTime field in the User table.</value>
55
public const String UPDATETIME_FIELD = "UpdateTime";
56
///<value>The constant used for IsAvailable field in the User table.</value>
57
public const String ISAVAILABLE_FIELD = "IsAvailable";
58
///<value>The constant used for RoleID field in the User table.</value>
59
public const String ROLEID_FIELD = "RoleID";
60
61
//
62
//UserInfo items table constants
63
//
64
///<value>The constant used for UserInfo table.</value>
65
public const String USERINFO_TABLE = "UserInfo";
66
///<value>The constant used for PKID field in the UserInfo table.</value>
67
public const String PKID_FIELD = "PKID";
68
///<value>The constant used for UserID field in the UserInfo table.</value>
69
public const String USERID_FIELD = "UserID";
70
///<value>The constant used for Name field in the UserInfo table.</value>
71
public const String NAME_FIELD = "Name";
72
///<value>The constant used for Oicq field in the UserInfo table.</value>
73
public const String OICQ_FIELD = "Oicq";
74
///<value>The constant used for MSN field in the UserInfo table.</value>
75
public const String MSN_FIELD = "MSN";
76
///<value>The constant used for InTime field in the UserInfo table.</value>
77
public const String INTIME_FIELD = "InTime";
78
///<value>The constant used for TotalLogins field in the UserInfo table.</value>
79
public const String TOTALLOGINS_FIELD = "TotalLogins";
80
///<value>The constant used for TotalTopics field in the UserInfo table.</value>
81
public const String TOTALTOPICS_FIELD = "TotalTopics";
82
///<value>The constant used for TotalReplys field in the UserInfo table.</value>
83
public const String TOTALREPLYS_FIELD = "TotalReplys";
84
85
//
86
//UserOnLine items table constants
87
//
88
///<value>The constant used for UserOnLine table.</value>
89
public const String USERONLINE_TABLE = "UserOnLine";
90
///<value>The constant used for UserID field in the UserOnLine table.</value>
91
public const String USERID_FIELD = "UserID";
92
///<value>The constant used for LastActivity field in the UserOnLine table.</value>
93
public const String LASTACTIVITY_FIELD = "LastActivity";
94
///<value>The constant used for IPAddress field in the UserOnLine table.</value>
95
public const String IPADDRESS_FIELD = "IPAddress";
96
97
/// <summary>
98
/// Constructor to support serialization.
99
/// <remarks>Constructor that supports serialization.</remarks>
100
/// <param name="info">The SerializationInfo object to read from.</param>
101
/// <param name="context">Information on who is calling this method.</param>
102
/// </summary>
103
private UserData(SerializationInfo info,StreamingContext context):base(info,context)
104
{
105
}
106
107
/// <summary>
108
/// Constructor for UserData.
109
/// <remarks>Initialize a UserDatainstance by building the table schema.</remarks>
110
/// </summary>
111
public UserData
112
{
113
//
114
//Create the tables in the dataset
115
//
116
BuildDataTables();
117
}
118
119
///----------------------------------------------------------------
120
/// Sub BuildDataTables:
121
/// Creates the following datatables: OrderItems, OrderSummary,
122
/// Customer, ShippingAddress, Payment, Order
123
///----------------------------------------------------------------
124
private void BuildDataTables()
125
{
126
///
127
///create the User items table.
128
///
129
DataTable table=new DataTable(User);
130
DataColumnCollection columns=table.Columns;
131
132
columns.Add(PKID,typeof(System.Int32));
133
columns.Add(UserName,typeof(System.String));
134
columns.Add(Password,typeof(System.String));
135
columns.Add(NickName,typeof(System.String));
136
columns.Add(Sex,typeof(System.Boolean));
137
columns.Add(Email,typeof(System.String));
138
columns.Add(Face,typeof(System.String));
139
columns.Add(EMoney,typeof(System.Int32));
140
columns.Add(Score,typeof(System.Int32));
141
columns.Add(Credit,typeof(System.Int32));
142
columns.Add(LevelUp,typeof(System.Int32));
143
columns.Add(UpdateTime,typeof(System.DataTime));
144
columns.Add(IsAvailable,typeof(System.Boolean));
145
columns.Add(RoleID,typeof(System.Int32));
146
columns.Add(PKID,typeof(System.Int32));
147
columns.Add(UserID,typeof(System.Int32));
148
columns.Add(Name,typeof(System.String));
149
columns.Add(Oicq,typeof(System.String));
150
columns.Add(MSN,typeof(System.String));
151
columns.Add(InTime,typeof(System.DataTime));
152
columns.Add(TotalLogins,typeof(System.Int32));
153
columns.Add(TotalTopics,typeof(System.Int32));
154
columns.Add(TotalReplys,typeof(System.Int32));
155
columns.Add(UserID,typeof(System.Int32));
156
columns.Add(LastActivity,typeof(System.DataTime));
157
columns.Add(IPAddress,typeof(System.String));
158
this.Tables.Add(table);
159
}
160
161
}
162
}
163![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
2
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
3
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
4
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
5
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
6
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
7
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
8
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
9
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
10
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
11
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
12
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
13
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
14
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
15
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
16
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
17
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
18
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
19
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
20
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
21
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
22
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
23
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
24
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
25
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
26
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
27
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
28
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
29
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
30
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
31
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
32
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
33
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
34
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
35
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
36
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
37
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
38
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
39
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
40
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
41
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
42
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
43
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
44
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
45
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
46
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
47
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
48
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
49
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
50
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
51
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
52
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
53
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
54
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
55
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
56
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
57
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
58
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
59
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
60
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
61
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
62
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
63
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
64
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
65
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
66
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
67
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
68
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
69
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
70
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
71
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
72
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
73
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
74
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
75
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
76
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
77
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
78
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
79
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
80
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
81
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
82
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
83
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
84
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
85
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
86
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
87
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
88
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
89
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
90
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
91
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
92
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
93
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
94
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
95
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
96
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
97
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
98
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
99
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
100
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
101
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
102
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
103
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
104
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
105
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
106
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
107
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
108
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
109
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
110
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
111
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
112
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
113
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
114
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
115
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
116
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
117
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
118
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
119
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
120
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
121
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
122
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
123
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
124
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
125
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
126
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
127
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
128
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
129
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
130
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
131
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
132
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
133
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
134
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
135
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
136
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
137
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
138
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
139
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
140
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
141
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
142
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
143
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
144
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
145
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
146
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
147
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
148
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
149
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
150
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
151
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
152
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
153
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
154
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
155
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
156
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
157
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
158
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
159
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
160
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
161
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
162
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
163
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)