public user_address getDefaultAddress() { string userid = TokenService.UserID; using (var db = base.getDatabase()) { user_address list = db.FirstOrDefault <user_address>("select * from user_address where user_id =@0 and isDefault=1 ", userid); if (list == null) { list = db.FirstOrDefault <user_address>("select top 1 * from user_address where user_id =@0 order by id desc ", userid); } return(list); } }
public ActionResult AddUserAddress(string address, string name) { var ua = new user_address(); ua.address = address; ua.user_id = UserInfo.id; ua.name = name ?? UserInfo.nickname; ua.add_time = DateTime.Now; ua.del_flag = (int)Del_flag.正常; ua.state = (int)State.可用; var res = User_addressService.AddEntity(ua); if (res.id > 0) { return(Json(SysEnum.成功, "添加地址成功")); } return(Json(SysEnum.失败, "添加地址失败")); }
public bool SetAddress(user_address address) { using (var db = base.getDatabase()) { user_address oldadd = db.FirstOrDefault <user_address>("SELECT * FROM `user_address` where city =@0 and country = @1 and detail = @2 and user_id=@3", address.city, address.country, address.detail, TokenService.UserID); if (oldadd != null) { oldadd.name = address.name; oldadd.mobile = address.mobile; oldadd.user_id = address.user_id; return(db.Update(oldadd) > 0 ? true : false); } else { address.user_id = int.Parse(TokenService.UserID); return(db.Insert(address) != null ? true : false); } } }
private int SaveAddress(string address, wx_user userInfo) { int id; var item = User_addressService.LoadEntities(n => n.address.Equals(address)).FirstOrDefault(); if (item != null) { id = item.id; } else { var ad = new user_address(); ad.del_flag = (int)Del_flag.正常; ad.state = (int)State.可用; ad.address = address; ad.user_id = userInfo.id; ad.name = userInfo.nickname; ad.add_time = DateTime.Now; var res = User_addressService.AddEntity(ad); id = res.id; } return(id); }
public user_address AddNewAddress(user_address address) { _userAddressDal.Add(address); return(address); }
public user_address UpdateUserAddress(user_address address) { _userAddressDal.Update(address); return(address); }
public void RemoveUserAddress(user_address address) { _userAddressDal.Delete(address); }
public IActionResult SetAddress(user_address address) { var flag = _addressService.SetAddress(address); return(Ok(flag)); }