/// <summary> /// 修改手机联系人 /// </summary> /// <param name="phoneAddressInfo">手机联系人实体</param> public int UpdatePhoneAddress(PhoneAddressInfo phoneAddressInfo) { using (DataContextDB DB = new DataContextDB()) { try { DB.GetTable<PhoneAddressInfo>().Attach(phoneAddressInfo, true); DB.SubmitChanges(); return 1; } catch (Exception e) { string error = e.Message; return -1; } } }
/// <summary> /// 添加手机联系人 /// </summary> /// <param name="phoneAddressInfo">手机联系人实体</param> public int InsertPhoneAddress(PhoneAddressInfo phoneAddressInfo) { using (DataContextDB DB = new DataContextDB()) { try { DB.GetTable<PhoneAddressInfo>().InsertOnSubmit(phoneAddressInfo); DB.SubmitChanges(); return 1; } catch (Exception e) { string error = e.Message; return -1; } } }
/// <summary> /// 获取手机联系人 /// </summary> /// <param name="phoneAddressInfo">手机联系人实体</param> /// <param name="pageInfo">分页实体</param> /// <returns></returns> public IList<PhoneAddressInfo> GetPhoneAddress(PhoneAddressInfo phoneAddressInfo, PageInfo pageInfo) { using (DataContextDB DB = new DataContextDB()) { IQueryable<PhoneAddressInfo> phoneAddressInfos = ( from item in DB.GetTable<PhoneAddressInfo>() orderby item.ID descending select item ); if (phoneAddressInfo != null && phoneAddressInfo.ID != 0) phoneAddressInfos = phoneAddressInfos.Where<PhoneAddressInfo>(m => m.ID == phoneAddressInfo.ID); if (phoneAddressInfo != null && phoneAddressInfo.UserID != 0) phoneAddressInfos = phoneAddressInfos.Where<PhoneAddressInfo>(m => m.UserID == phoneAddressInfo.UserID); if (pageInfo != null) { pageInfo.TotalRecord = phoneAddressInfos.Count(); return phoneAddressInfos.Skip(pageInfo.PageSize * (pageInfo.PageIndex - 1)).Take(pageInfo.PageSize).ToList<PhoneAddressInfo>(); } else return phoneAddressInfos.ToList<PhoneAddressInfo>(); } }
public ActionResult PhoneAddress(PhoneAddressInfo phoneAddressInfo) { if (phoneAddressInfo == null) return Json(new FeedbackInfo { Success = -1, Message = "获取实体出错" }); if (phoneAddressInfo.UserID == 0) return Json(new FeedbackInfo { Success = -1, Message = "请输入用户编号" }); if (string.IsNullOrWhiteSpace(phoneAddressInfo.Name)) return Json(new FeedbackInfo { Success = -1, Message = "请输入联系人名" }); if (string.IsNullOrWhiteSpace(phoneAddressInfo.Phone)) return Json(new FeedbackInfo { Success = -1, Message = "请输入联系人手机" }); //新建 int result = 0; if (phoneAddressInfo.ID == 0) { result = Start.DatabaseProvider.Instance().InsertPhoneAddress(phoneAddressInfo); if (result == 1) return Json(new FeedbackInfo { Success = 1, Message = "添加成功" }); else return Json(new FeedbackInfo { Success = -1, Message = "添加失败" }); } else //编辑 { result = Start.DatabaseProvider.Instance().UpdatePhoneAddress(phoneAddressInfo); if (result == 1) return Json(new FeedbackInfo { Success = 1, Message = "修改成功" }); else return Json(new FeedbackInfo { Success = -1, Message = "修改失败" }); } }
public ActionResult PhoneAddress(int? id) { PhoneAddressInfo phoneAddressInfo = null; if (id != null && id.Value != 0) phoneAddressInfo = Start.DatabaseProvider.Instance().GetPhoneAddressByID(id.Value); if (phoneAddressInfo == null) phoneAddressInfo = new PhoneAddressInfo(); return View(phoneAddressInfo); }
public ActionResult PhoneAddressList(int userID = 0, int pageIndex = 1) { PageInfo pageInfo = new PageInfo { PageIndex = pageIndex }; PhoneAddressInfo phoneAddressInfo = new PhoneAddressInfo { UserID = userID }; IList<PhoneAddressInfo> phoneAddressInfos = Start.DatabaseProvider.Instance().GetPhoneAddress(phoneAddressInfo, pageInfo); PagedList<PhoneAddressInfo> pagedList = new PagedList<PhoneAddressInfo>(phoneAddressInfos, pageInfo.PageIndex, pageInfo.PageSize, pageInfo.TotalRecord); ViewBag.PhoneAddressInfo = phoneAddressInfo; return View(pagedList); }