public object Address([FromBody] MailingAddressEntity mailingAddressEntity) { //MailingAddressEntity mailingAddressEntity = new MailingAddressEntity(); //mailingAddressEntity.UserId = userId; //mailingAddressEntity.Province = province; //mailingAddressEntity.City = city; //mailingAddressEntity.County = county; //mailingAddressEntity.Address = address; //mailingAddressEntity.ZipCode = zipCode; //mailingAddressEntity.Name = name; //mailingAddressEntity.Phone = phone; mailingAddressEntity.AddTime = DateTime.Now; mailingAddressEntity.Status = 1; if (MailingAddressBll.Instance.Add(mailingAddressEntity) > 0) { return(new Dictionary <string, string>() { { "status", "200" } }); } else { return(new Dictionary <string, string>() { { "status", "500" } }); } }
public void ProcessRequest(HttpContext context) { string addId = context.Request.Form["ctb[post-addId]"]; //地址id string status = context.Request.Form["ctb[post-status]"]; //修改状态(add、update) string userId = context.Request.Form["ctb[post-userId]"]; //会员id string province = context.Request.Form["ctb[post-province]"]; //省 string city = context.Request.Form["ctb[post-city]"]; //市 string county = context.Request.Form["ctb[post-county]"]; //区/县 string address = context.Request.Form["ctb[post-address]"]; //详细地址 string zipCode = context.Request.Form["ctb[post-zipCode]"]; //邮政编码 string name = context.Request.Form["ctb[post-name]"]; //姓名 string phone = context.Request.Form["ctb[post-phone]"]; //手机号码 string s = "{\"status\":\"error\"}"; bool b = false; if (status == "add") //增加 { MailingAddressEntity mailingAddressEntity = new MailingAddressEntity(); mailingAddressEntity.UserId = userId; mailingAddressEntity.Province = province; mailingAddressEntity.City = city; mailingAddressEntity.County = county; mailingAddressEntity.Address = address; mailingAddressEntity.Name = name; mailingAddressEntity.ZipCode = zipCode; mailingAddressEntity.Phone = phone; mailingAddressEntity.AddTime = DateTime.Now; mailingAddressEntity.Status = 1; b = MailingAddressBll.Instance.Add(mailingAddressEntity) > 0; } else //修改 { MailingAddressEntity mailingAddressEntity = MailingAddressBll.Instance.GetModel(int.Parse(addId)); mailingAddressEntity.UserId = userId; mailingAddressEntity.Province = province; mailingAddressEntity.City = city; mailingAddressEntity.County = county; mailingAddressEntity.Address = address; mailingAddressEntity.Name = name; mailingAddressEntity.ZipCode = zipCode; mailingAddressEntity.Phone = phone; mailingAddressEntity.AddTime = DateTime.Now; mailingAddressEntity.Status = 1; b = MailingAddressBll.Instance.Update(mailingAddressEntity); } if (b) { s = "{\"status\":\"success\"}"; } context.Response.ContentType = "text/plain"; context.Response.Charset = "utf-8"; context.Response.Write(s); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MailingAddressEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update sns_mailingAddress set "); strSql.Append("UserId=@UserId,"); strSql.Append("Province=@Province,"); strSql.Append("City=@City,"); strSql.Append("County=@County,"); strSql.Append("Address=@Address,"); strSql.Append("ZipCode=@ZipCode,"); strSql.Append("Name=@Name,"); strSql.Append("Phone=@Phone,"); strSql.Append("AddTime=@AddTime,"); strSql.Append("Status=@Status"); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.VarChar, 50), new SqlParameter("@Province", SqlDbType.VarChar, 50), new SqlParameter("@City", SqlDbType.VarChar, 50), new SqlParameter("@County", SqlDbType.VarChar, 50), new SqlParameter("@Address", SqlDbType.VarChar, 50), new SqlParameter("@ZipCode", SqlDbType.VarChar, 50), new SqlParameter("@Name", SqlDbType.VarChar, 50), new SqlParameter("@Phone", SqlDbType.VarChar, 50), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int, 4), new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = model.UserId; parameters[1].Value = model.Province; parameters[2].Value = model.City; parameters[3].Value = model.County; parameters[4].Value = model.Address; parameters[5].Value = model.ZipCode; parameters[6].Value = model.Name; parameters[7].Value = model.Phone; parameters[8].Value = model.AddTime; parameters[9].Value = model.Status; parameters[10].Value = model.Id; int rows = SqlHelper.Instance.ExecSqlNonQuery(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MailingAddressEntity DataRowToModel(DataRow row) { MailingAddressEntity model = new MailingAddressEntity(); if (row != null) { if (row["Id"] != null && row["Id"].ToString() != "") { model.Id = int.Parse(row["Id"].ToString()); } if (row["UserId"] != null) { model.UserId = row["UserId"].ToString(); } if (row["Province"] != null) { model.Province = row["Province"].ToString(); } if (row["City"] != null) { model.City = row["City"].ToString(); } if (row["County"] != null) { model.County = row["County"].ToString(); } if (row["Address"] != null) { model.Address = row["Address"].ToString(); } if (row["ZipCode"] != null) { model.ZipCode = row["ZipCode"].ToString(); } if (row["Name"] != null) { model.Name = row["Name"].ToString(); } if (row["Phone"] != null) { model.Phone = row["Phone"].ToString(); } if (row["AddTime"] != null && row["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(row["AddTime"].ToString()); } if (row["Status"] != null && row["Status"].ToString() != "") { model.Status = int.Parse(row["Status"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(MailingAddressEntity model) { try { return(MailingAddressDb.Instance.Update(model)); } catch (Exception ex) { WriteLog.WriteError(ex); throw ex; } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(MailingAddressEntity model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into sns_mailingAddress("); strSql.Append("UserId,Province,City,County,Address,ZipCode,Name,Phone,AddTime,Status)"); strSql.Append(" values ("); strSql.Append("@UserId,@Province,@City,@County,@Address,@ZipCode,@Name,@Phone,@AddTime,@Status)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.VarChar, 50), new SqlParameter("@Province", SqlDbType.VarChar, 50), new SqlParameter("@City", SqlDbType.VarChar, 50), new SqlParameter("@County", SqlDbType.VarChar, 50), new SqlParameter("@Address", SqlDbType.VarChar, 50), new SqlParameter("@ZipCode", SqlDbType.VarChar, 50), new SqlParameter("@Name", SqlDbType.VarChar, 50), new SqlParameter("@Phone", SqlDbType.VarChar, 50), new SqlParameter("@AddTime", SqlDbType.DateTime), new SqlParameter("@Status", SqlDbType.Int, 4) }; parameters[0].Value = model.UserId; parameters[1].Value = model.Province; parameters[2].Value = model.City; parameters[3].Value = model.County; parameters[4].Value = model.Address; parameters[5].Value = model.ZipCode; parameters[6].Value = model.Name; parameters[7].Value = model.Phone; parameters[8].Value = model.AddTime; parameters[9].Value = model.Status; object obj = SqlHelper.Instance.ExecSqlScalar(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
public object UpdateAddress([FromBody] MailingAddressEntity mailingAddressEntity) { //string[] s = values.Split('/'); //string id = s[0]; //string userId = s[1]; //会员id会员id //string province = s[2]; //省 //string city = s[3]; //市 //string county = s[4]; //区 / 县 //string address = s[5]; //详细地址 //string zipCode = s[6]; //邮政编码 //string name = s[7]; //姓名 //string phone = s[8]; //手机号码 //MailingAddressEntity mailingAddressEntity = MailingAddressBll.Instance.GetModel(int.Parse(id)); //mailingAddressEntity.UserId = userId; //mailingAddressEntity.Province = province; //mailingAddressEntity.City = city; //mailingAddressEntity.County = county; //mailingAddressEntity.Address = address; //mailingAddressEntity.ZipCode = zipCode; //mailingAddressEntity.Name = name; //mailingAddressEntity.Phone = phone; mailingAddressEntity.AddTime = DateTime.Now; mailingAddressEntity.Status = 1; if (MailingAddressBll.Instance.Update(mailingAddressEntity)) { return(new Dictionary <string, string>() { { "status", "200" } }); } else { return(new Dictionary <string, string>() { { "status", "500" } }); } }
/// <summary> /// 得到一个对象实体 /// </summary> public MailingAddressEntity GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,UserId,Province,City,County,Address,ZipCode,Name,Phone,AddTime,Status from sns_mailingAddress "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int, 4) }; parameters[0].Value = Id; MailingAddressEntity model = new MailingAddressEntity(); DataSet ds = SqlHelper.Instance.ExecSqlDataSet(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
public void ProcessRequest(HttpContext context) { string userId = context.Request.Form["UserId"]; //报名人id string exId = context.Request.Form["ExId"]; //分享的帖子id string address = context.Request.Form["AddressId"]; //收货地址id string classid = context.Request.Form["classId"]; //1表示直接兑换,2表示会员兑换 string s = "{\"status\":\"error\"}"; bool b = false; DataTable epdt = ExchangePersonBll.Instance.GetList($"UserId={userId} and status=1").Tables[0]; if (epdt.Rows.Count > 0) { s = "{\"status\":\"exist\"}"; //已有兑换,不能继续兑换 context.Response.Write(s); return; } //获得帖子信息 ExchangeEntity exchangeEntity = ExchangeBll.Instance.GetModel(int.Parse(exId)); string official = exchangeEntity.Official; if (exchangeEntity.Examine == "4") //兑换中状态 { if (classid == "2") //会员兑换 { if (!VipExchange(int.Parse(userId))) { s = "{\"status\":\"lacking\"}"; //会员不足 context.Response.Write(s); return; } } else //普通兑换 { if (!OrdinaryExchange(int.Parse(userId), official)) { s = "{\"status\":\"lacking\"}"; //身家不足 context.Response.Write(s); return; } } //添加兑换表 ExchangePersonEntity exchangePersonEntity = new ExchangePersonEntity(); exchangePersonEntity.UserId = userId; exchangePersonEntity.ExId = exId; exchangePersonEntity.AddTime = DateTime.Now; exchangePersonEntity.Address = address; exchangePersonEntity.Examine = "1"; exchangePersonEntity.Status = 1; b = ExchangePersonBll.Instance.Add(exchangePersonEntity) > 0; if (b) { //更新分享表 exchangeEntity.ExchangePerson = userId; exchangeEntity.EnterTime = DateTime.Now; exchangeEntity.Examine = "5"; b = ExchangeBll.Instance.Update(exchangeEntity); if (b) { MailingAddressEntity mailingAddressEntity = MailingAddressBll.Instance.GetModel(int.Parse(exchangePersonEntity.Address)); string body = $@"id为:{exchangeEntity.Id},标题为:{exchangeEntity.Title},收货地址为:{mailingAddressEntity.Province}省{mailingAddressEntity.City}市{mailingAddressEntity.County}区/县{mailingAddressEntity.Address}, 邮政编码为:{mailingAddressEntity.ZipCode},兑换人:{mailingAddressEntity.Name},兑换人手机号为:{mailingAddressEntity.Phone}"; MailHelper.sendMail("分享被兑换", body, EmailConfig.Instance._EmailName, new List <string>() { EmailConfig.Instance._EmailUserName }, EmailConfig.Instance._EmailAgreement, EmailConfig.Instance._EmailUserName, EmailConfig.Instance._EmailPassword); s = "{\"status\":\"success\"}"; } } } else { s = "{\"status\":\"other\"}"; } context.Response.ContentType = "text/plain"; context.Response.Charset = "utf-8"; context.Response.Write(s); }