/// <summary> /// 修改用户 /// </summary> /// <param name="user"></param> public void updateUser(Bs_User user) { CSA.DAL.SQLBuilder builder = new CSA.DAL.SQLBuilder(); builder.TblName = "bs_user"; builder.AddData("realname", user.RealName); builder.AddData("Sex", user.Sex); builder.AddData("QQ", user.QQ); builder.AddData("MSN", user.MSN); builder.AddData("WanWan", user.WanWan); builder.AddData("Pic", user.Pic); builder.AddData("Mobile", user.Mobile); builder.AddData("Phone", user.Phone); builder.AddData("Fax", user.Fax); builder.AddData("EMail", user.EMail); builder.AddData("Company", user.Company); builder.AddData("Address", user.Address); builder.AddData("PostCode", user.PostCode); builder.AddData("County", user.County); builder.AddData("Country", user.Country); builder.AddData("City", user.City); builder.AddData("Province", user.Province); builder.AddData("csgAddress", user.csgAddress); builder.AddData("csgCity", user.csgCity); builder.AddData("csgCountry", user.csgCountry); builder.AddData("csgCounty", user.csgCounty); builder.AddData("csgEmail", user.csgEmail); builder.AddData("csgMobile", user.csgMobile); builder.AddData("csgName", user.csgName); builder.AddData("csgPhone", user.csgPhone); builder.AddData("csgPostCode", user.csgPostCode); builder.AddData("csgProvince", user.csgProvince); builder.Where = " and id= " + user.ID; builder.AutoUpdate(); }
protected void Page_Load(object sender, EventArgs e) { string action = Com.Util.getStringByObject(Request["action"]); if (CurInfo.CurUser == null) { Response.Redirect("login.aspx?from=address.aspx"); } if (action == "del") { string id = Request.Form["id"]; string sql = "delete bs_useraddress where id=" + id + ""; if (CSA.DAL.DBAccess.ExecuteNonQuery(sql) > 0) { Response.Write("{\"status\":\"success\",\"content\":\"删除成功!\"}"); } else { Response.Write("{\"status\":\"error\",\"content\":\"提交失败!\"}"); } } if (action == "edit") { CSA.DAL.SQLBuilder builder = new CSA.DAL.SQLBuilder("Bs_userAddress"); string hid = Request.Form["hid"]; string city = Request.Form["city"]; string[] s = city.Split('/'); builder.AddData("CsgProv", s[0]); builder.AddData("CsgCity", s[1]); builder.AddData("CsgCounty", s[2]); builder.AddData("CsgAddress", Request.Form["KK_CsgAddress"]); builder.AddData("CsgPostcode", Request.Form["KK_CsgPostcode"]); builder.AddData("CsgTel", Request.Form["KK_CsgTel"]); builder.AddData("CsgMobile", Request.Form["KK_CsgMobile"]); builder.AddData("CsgName", Request.Form["KK_CsgName"]); builder.AddData("IsCheck", Request.Form["KK_IsCheck"]); builder.AddData("uid", CurInfo.CurUser.ID); if (!string.IsNullOrEmpty(hid)) { builder.Where = " and id=" + hid; if (builder.AutoUpdate()) { Response.Write("{\"status\":\"success\",\"content\":\"地址保存成功!\"}"); } else { Response.Write("{\"status\":\"error\",\"content\":\"提交失败!\"}"); } } else { if (builder.AutoInsert()) { Response.Write("{\"status\":\"success\",\"content\":\"地址保存成功!\"}"); } else { Response.Write("{\"status\":\"error\",\"content\":\"提交失败!\"}"); } } } if (action == "modify") { string id = Request.Form["id"]; System.Data.DataTable dt; dt = CSA.DAL.DBAccess.getRS("select * from bs_useraddress where id=" + id); if (dt.Rows.Count > 0) { Response.Write("{\"status\":\"success\",\"CsgProv\":\"" + dt.Rows[0]["CsgProv"] + "\",\"CsgCity\":\"" + dt.Rows[0]["CsgCity"] + "\",\"CsgCounty\":\"" + dt.Rows[0]["CsgCounty"] + "\",\"CsgAddress\":\"" + dt.Rows[0]["CsgAddress"] + "\",\"CsgPostcode\":\"" + dt.Rows[0]["CsgPostcode"] + "\",\"CsgTel\":\"" + dt.Rows[0]["CsgTel"] + "\",\"CsgMobile\":\"" + dt.Rows[0]["CsgMobile"] + "\",\"IsCheck\":\"" + dt.Rows[0]["IsCheck"] + "\",\"CsgName\":\"" + dt.Rows[0]["CsgName"] + "\"}"); } else { Response.Write("{\"status\":\"error\",\"content\":\"读取失败!\"}"); } } }