public void ProcessRequest(HttpContext context) { //context.Response.ContentType = "text/plain"; //context.Response.Write("Hello World"); UserInfoVO strUserInfo = new UserInfoVO(); strUserInfo.LoginName = context.Application.Equals("loginName").ToString(); strUserInfo.UserName = System.Web.HttpUtility.UrlDecode(context.Request["username"]); strUserInfo.Birthday = Convert.ToDateTime(System.Web.HttpUtility.UrlDecode(context.Request["birthday"])); strUserInfo.Sex = System.Web.HttpUtility.UrlDecode(context.Request["sex"]); strUserInfo.School = System.Web.HttpUtility.UrlDecode(context.Request["school"]); strUserInfo.Job = System.Web.HttpUtility.UrlDecode(context.Request["job"]); strUserInfo.Mobilphone = System.Web.HttpUtility.UrlDecode(context.Request["mobilphone"]); strUserInfo.QQ = System.Web.HttpUtility.UrlDecode(context.Request["qq"]); strUserInfo.Msn = System.Web.HttpUtility.UrlDecode(context.Request["msn"]); strUserInfo.Weibo = System.Web.HttpUtility.UrlDecode(context.Request["weibo"]); try { UserBLL insUserBLL = new UserBLL(); if (insUserBLL.UpdateUserInfo(strUserInfo) == true) { context.Response.Write("success"); } else { context.Response.Write("fail"); } } catch (Exception ex) { } }
/// <summary> /// 更新用户信息 /// </summary> /// <param name="strUserInfo">用户信息</param> /// <returns></returns> public bool UpdateUserInfo(UserInfoVO strUserInfo) { if (newUserDAL.UpdateUserInfo(strUserInfo) > 0) { return true; } else { return false; } }
public int UpdateUserInfo(UserInfoVO strUserInfo) { try { #region 赋值给存储过程变量 SqlParameter[] sqlPara = new SqlParameter[12]; sqlPara[0] = new SqlParameter("@loginName", SqlDbType.VarChar, 50); sqlPara[0].Value = strUserInfo.LoginName; sqlPara[1] = new SqlParameter("@userName", SqlDbType.VarChar, 10); sqlPara[1].Value = strUserInfo.UserName; sqlPara[2] = new SqlParameter("@EnglishName", SqlDbType.VarChar, 25); sqlPara[2].Value = strUserInfo.EnglishName; sqlPara[3] = new SqlParameter("@birthday", SqlDbType.Date); sqlPara[3].Value = strUserInfo.Birthday; sqlPara[4] = new SqlParameter("@sex", SqlDbType.VarChar, 2); sqlPara[4].Value = strUserInfo.Sex; sqlPara[5] = new SqlParameter("@school", SqlDbType.VarChar, 50); sqlPara[5].Value = strUserInfo.School; sqlPara[6] = new SqlParameter("@job", SqlDbType.VarChar, 10); sqlPara[6].Value = strUserInfo.Job; sqlPara[7] = new SqlParameter("@qq", SqlDbType.VarChar, 15); sqlPara[7].Value = strUserInfo.QQ; sqlPara[8] = new SqlParameter("@weibo", SqlDbType.VarChar, 50); sqlPara[8].Value = strUserInfo.Weibo; sqlPara[9] = new SqlParameter("@msn", SqlDbType.VarChar, 50); sqlPara[9].Value = strUserInfo.Msn; sqlPara[10] = new SqlParameter("@mobilPhone", SqlDbType.VarChar, 20); sqlPara[10].Value = strUserInfo.Mobilphone; sqlPara[11] = new SqlParameter("@phone", SqlDbType.VarChar, 20); sqlPara[11].Value = strUserInfo.Phone; #endregion int rowCount = 0; this.RunProcedure("UserDAL_UpdateUserInfo", sqlPara, out rowCount); return rowCount; } catch (Exception ex) { throw ex; } }