1
using System;
2using System.Data;
3using System.Configuration;
4using System.Web;
5using System.Web.Security;
6using System.Web.UI;
7using System.Web.UI.WebControls;
8using System.Web.UI.WebControls.WebParts;
9using System.Web.UI.HtmlControls;
10using System.Data.SqlClient;
11
12
/**//// <summary>
13
/// UserInfoClass 的摘要说明
14
/// </summary>
15public class UserInfoClass
16...{
17 DBClass dbObj = new DBClass();
18 public UserInfoClass()
19
...{
20 //
21 // TODO: 在此处添加构造函数逻辑
22 //
23
}
24 //***************************************登录界面************************************************************
25 /**//// <summary>
26 /// 判断用户是否存在
27 /// </summary>
28 /// <param name="P_Str_Name">会员登录名</param>
29 /// <param name="P_Str_Password">会员登录密码</param>
30 /// <returns></returns>
31 public int UserExists(string P_Str_Name,string P_Str_Password)
32 ...{
33 SqlConnection myConn = dbObj.GetConnection();
34 SqlCommand myCmd = new SqlCommand("Proc_UserExists", myConn);
35 myCmd.CommandType = CommandType.StoredProcedure;
36 //添加参数
37 SqlParameter Name = new SqlParameter("@Name", SqlDbType.VarChar, 50);
38 Name.Value = P_Str_Name;
39 myCmd.Parameters.Add(Name);
40 //添加参数
41 SqlParameter Password = new SqlParameter("@Password", SqlDbType.VarChar, 50);
42 Password.Value = P_Str_Password;
43 myCmd.Parameters.Add(Password);
44 //添加参数
45 SqlParameter returnValue = myCmd.Parameters.Add("returnValue", SqlDbType.Int, 4);
46 returnValue.Direction = ParameterDirection.ReturnValue;
47 //执行过程
48 myConn.Open();
49 try
50 ...{
51 myCmd.ExecuteNonQuery();
52 }
53 catch (Exception ex)
54 ...{
55 throw (ex);
56 }
57 finally
58 ...{
59 myCmd.Dispose();
60 myConn.Close();
61
62 }
63 int P_Int_returnValue = Convert.ToInt32(returnValue.Value.ToString());
64 return P_Int_returnValue;
65 }
66 /**//// <summary>
67 /// 获取会员信息
68 /// </summary>
69 /// <param name="P_Str_Name">会员登录名</param>
70 /// <param name="P_Str_Password">会员登录密码</param>
71 /// <param name="P_Str_srcTable">查询表信息</param>
72 /// <returns></returns>
73 public DataSet ReturnUIDs(string P_Str_Name, string P_Str_Password,string P_Str_srcTable)
74 ...{
75 SqlConnection myConn = dbObj.GetConnection();
76 SqlCommand myCmd = new SqlCommand("Proc_GetUserInfo", myConn);
77 myCmd.CommandType = CommandType.StoredProcedure;
78 //添加参数
79 SqlParameter Name = new SqlParameter("@Name", SqlDbType.VarChar, 50);
80 Name.Value = P_Str_Name;
81 myCmd.Parameters.Add(Name);
82 //添加参数
83 SqlParameter Password = new SqlParameter("@Password", SqlDbType.VarChar, 50);
84 Password.Value = P_Str_Password;
85 myCmd.Parameters.Add(Password);
86 //执行过程
87 myConn.Open();
88 try
89 ...{
90 myCmd.ExecuteNonQuery();
91
92 }
93 catch (Exception ex)
94 ...{
95 throw (ex);
96 }
97 finally
98 ...{
99 myCmd.Dispose();
100 myConn.Close();
101
102 }
103 SqlDataAdapter da = new SqlDataAdapter(myCmd);
104 DataSet ds= new DataSet();
105 da.Fill(ds, P_Str_srcTable);
106 return ds;
107
108 }
109 //***************************************注册界面************************************************************
110 /**//// <summary>
111 /// 向用户表中插入信息
112 /// </summary>
113 /// <param name="P_Str_Name">会员名</param>
114 /// <param name="P_Bl_Sex">性别</param>
115 /// <param name="P_Str_Password">密码</param>
116 /// <param name="P_Str_TrueName">真实姓名</param>
117 /// <param name="P_Str_Questions">找回密码问题</param>
118 /// <param name="P_Str_Answers">找回密码答案</param>
119 /// <param name="P_Str_Phonecode">电话号码</param>
120 /// <param name="P_Str_Emails">E_Mail</param>
121 /// <param name="P_Str_City">会员所在城市</param>
122 /// <param name="P_Str_Address">会员详细地址</param>
123 /// <param name="P_Str_PostCode">邮编</param>
124 /// <param name="P_Flt_AdvancePayment">预付金额</param>
125 /// <param name="P_Date_LoadDate">登录日期</param>
126 public int AddUInfo(string P_Str_Name, bool P_Bl_Sex, string P_Str_Password, string P_Str_TrueName, string P_Str_Questions, string P_Str_Answers, string P_Str_Phonecode, string P_Str_Emails, string P_Str_City, string P_Str_Address, string P_Str_PostCode)
127 ...{
128 SqlConnection myConn = dbObj.GetConnection();
129 SqlCommand myCmd = new SqlCommand("Proc_InsertUInfo", myConn);
130 myCmd.CommandType = CommandType.StoredProcedure;
131 //添加参数
132 SqlParameter Name = new SqlParameter("@Name", SqlDbType.VarChar, 50);
133 Name.Value = P_Str_Name;
134 myCmd.Parameters.Add(Name);
135 //添加参数
136 SqlParameter sex = new SqlParameter("@sex", SqlDbType.Bit,1);
137 sex.Value = P_Bl_Sex;
138 myCmd.Parameters.Add(sex);
139 //添加参数
140 SqlParameter Password = new SqlParameter("@Password", SqlDbType.VarChar, 50);
141 Password.Value = P_Str_Password;
142 myCmd.Parameters.Add(Password);
143 //添加参数
144 SqlParameter TrueName = new SqlParameter("@TrueName", SqlDbType.VarChar, 50);
145 TrueName.Value = P_Str_TrueName;
146 myCmd.Parameters.Add(TrueName);
147 //添加参数
148 SqlParameter Questions = new SqlParameter("@Questions", SqlDbType.VarChar, 50);
149 Questions.Value = P_Str_Questions;
150 myCmd.Parameters.Add(Questions);
151 //添加参数
152 SqlParameter Answers = new SqlParameter("@Answers", SqlDbType.VarChar, 50);
153 Answers.Value = P_Str_Answers;
154 myCmd.Parameters.Add(Answers);
155 //添加参数
156 SqlParameter Phonecode = new SqlParameter("@Phonecode", SqlDbType.VarChar, 20);
157 Phonecode.Value = P_Str_Phonecode;
158 myCmd.Parameters.Add(Phonecode);
159 //添加参数
160 SqlParameter Emails = new SqlParameter("@Emails", SqlDbType.VarChar, 50);
161 Emails.Value = P_Str_Emails;
162 myCmd.Parameters.Add(Emails);
163 //添加参数
164 SqlParameter City = new SqlParameter("@City", SqlDbType.VarChar, 50);
165 City.Value = P_Str_City;
166 myCmd.Parameters.Add(City);
167 //添加参数
168 SqlParameter Address = new SqlParameter("@Address", SqlDbType.VarChar, 200);
169 Address.Value = P_Str_Address;
170 myCmd.Parameters.Add(Address);
171 //添加参数
172 SqlParameter PostCode = new SqlParameter("@PostCode", SqlDbType.Char, 10);
173 PostCode.Value = P_Str_PostCode;
174 myCmd.Parameters.Add(PostCode);
175 //添加参数
176 SqlParameter MemberId = myCmd.Parameters.Add("@MemberId",SqlDbType.BigInt,8);
177 MemberId.Direction = ParameterDirection.Output;
178 //执行过程
179 myConn.Open();
180 try
181 ...{
182 myCmd.ExecuteNonQuery();
183 }
184 catch (Exception ex)
185 ...{
186 throw(ex);
187
188 }
189 finally
190 ...{
191 myCmd.Dispose();
192 myConn.Close();
193 }
194 return Convert.ToInt32(MemberId.Value.ToString());
195
196 }
197 /**//// <summary>
198 /// 修改会员充值
199 /// </summary>
200 /// <param name="P_Int_MemberID">会员ID</param>
201 /// <param name="P_Flt_AdvancePayment">充值金额</param>
202 public void UpdateAP(int P_Int_MemberID, float P_Flt_AdvancePayment)
203 ...{
204 SqlConnection myConn = dbObj.GetConnection();
205 SqlCommand myCmd = new SqlCommand("Proc_UpdateAP", myConn);
206 myCmd.CommandType = CommandType.StoredProcedure;
207 //添加参数
208 SqlParameter MemberID = new SqlParameter("@MemberID", SqlDbType.BigInt, 8);
209 MemberID.Value = P_Int_MemberID;
210 myCmd.Parameters.Add(MemberID);
211 //添加参数
212 SqlParameter AdvancePayment = new SqlParameter("@AdvancePayment", SqlDbType.Float, 8);
213 AdvancePayment.Value = P_Flt_AdvancePayment;
214 myCmd.Parameters.Add(AdvancePayment);
215 //执行过程
216 myConn.Open();
217 try
218 ...{
219 myCmd.ExecuteNonQuery();
220 }
221 catch (Exception ex)
222 ...{
223 throw (ex);
224
225 }
226 finally
227 ...{
228 myCmd.Dispose();
229 myConn.Close();
230 }
231
232
233 }
234 //********************************更新用户信息*************************************************
235 /**//// <summary>
236 /// 获取会员信息
237 /// </summary>
238 /// <param name="P_Int_MemberID">会员编号</param>
239 /// <param name="P_Str_srcTable">表的信息</param>
240 /// <returns></returns>
241 public DataSet ReturnUIDsByID(int P_Int_MemberID, string P_Str_srcTable)
242 ...{
243 SqlConnection myConn = dbObj.GetConnection();
244 SqlCommand myCmd = new SqlCommand("Proc_GetUIByID", myConn);
245 myCmd.CommandType = CommandType.StoredProcedure;
246 //添加参数
247 SqlParameter MemberID = new SqlParameter("@MemberID", SqlDbType.BigInt, 8);
248 MemberID.Value = P_Int_MemberID;
249 myCmd.Parameters.Add(MemberID);
250 //执行过程
251 myConn.Open();
252 try
253 ...{
254 myCmd.ExecuteNonQuery();
255
256 }
257 catch (Exception ex)
258 ...{
259 throw (ex);
260 }
261 finally
262 ...{
263 myCmd.Dispose();
264 myConn.Close();
265
266 }
267 SqlDataAdapter da = new SqlDataAdapter(myCmd);
268 DataSet ds = new DataSet();
269 da.Fill(ds, P_Str_srcTable);
270 return ds;
271
272 }
273 /**//// <summary>
274 /// 修改会员表中的信息
275 /// </summary>
276 /// <param name="P_Str_Name">会员名</param>
277 /// <param name="P_Bl_Sex">性别</param>
278 /// <param name="P_Str_Password">密码</param>
279 /// <param name="P_Str_TrueName">真实姓名</param>
280 /// <param name="P_Str_Questions">找回密码问题</param>
281 /// <param name="P_Str_Answers">找回密码答案</param>
282 /// <param name="P_Str_Phonecode">电话号码</param>
283 /// <param name="P_Str_Emails">E_Mail</param>
284 /// <param name="P_Str_City">会员所在城市</param>
285 /// <param name="P_Str_Address">会员详细地址</param>
286 /// <param name="P_Str_PostCode">邮编</param>
287 /// <param name="P_Flt_AdvancePayment">预付金额</param>
288 /// <param name="P_Date_LoadDate">登录日期</param>
289 public void UpdateUInfo(string P_Str_Name, bool P_Bl_Sex, string P_Str_Password, string P_Str_TrueName, string P_Str_Questions, string P_Str_Answers, string P_Str_Phonecode, string P_Str_Emails, string P_Str_City, string P_Str_Address, string P_Str_PostCode,int P_Int_MemberID)
290 ...{
291 SqlConnection myConn = dbObj.GetConnection();
292 SqlCommand myCmd = new SqlCommand("Proc_UpdateUIbyID", myConn);
293 myCmd.CommandType = CommandType.StoredProcedure;
294 //添加参数
295 SqlParameter Name = new SqlParameter("@Name", SqlDbType.VarChar, 50);
296 Name.Value = P_Str_Name;
297 myCmd.Parameters.Add(Name);
298 //添加参数
299 SqlParameter sex = new SqlParameter("@sex", SqlDbType.Bit, 1);
300 sex.Value = P_Bl_Sex;
301 myCmd.Parameters.Add(sex);
302 //添加参数
303 SqlParameter Password = new SqlParameter("@Password", SqlDbType.VarChar, 50);
304 Password.Value = P_Str_Password;
305 myCmd.Parameters.Add(Password);
306 //添加参数
307 SqlParameter TrueName = new SqlParameter("@TrueName", SqlDbType.VarChar, 50);
308 TrueName.Value = P_Str_TrueName;
309 myCmd.Parameters.Add(TrueName);
310 //添加参数
311 SqlParameter Questions = new SqlParameter("@Questions", SqlDbType.VarChar, 50);
312 Questions.Value = P_Str_Questions;
313 myCmd.Parameters.Add(Questions);
314 //添加参数
315 SqlParameter Answers = new SqlParameter("@Answers", SqlDbType.VarChar, 50);
316 Answers.Value = P_Str_Answers;
317 myCmd.Parameters.Add(Answers);
318
MingriNetShop/App_Code/UserInfoClass.cs，打开代码结构图