/// <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\":\"读取失败！\"}");
}
}
}
