// POST api/UserBank_WebAPI public HttpResponseMessage PostUserBank(UserBank userbank) { if (ModelState.IsValid) { db.UserBanks.Add(userbank); db.SaveChanges(); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, userbank); response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = userbank.ID })); return response; } else { return Request.CreateResponse(HttpStatusCode.BadRequest); } }
public string Create(UserBank userbank) { try { User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User; userbank.BankID = Convert.ToInt32(Request.Form["search_bank.BankID"]); userbank.BankName = Request.Form["search_bank.BankName"]; userbank.UserID = loginUser.ID; userbank.UserName = loginUser.cUserName; userbank.CreateDate = DateTime.Now; db.UserBanks.Add(userbank); db.SaveChanges(); return WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "添加成功", "userBankList", "", CallBackType.none, ""); } catch (Exception ex) { return WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "添加失败!" + ex.Message, "", "", CallBackType.none, ""); } }
/// <summary> /// 获取用户开户行列表 /// </summary> /// <param name="currentPage">当前页码</param> /// <param name="uBank">查询实体</param> /// <returns></returns> private List<UserBank> GetUserBankList(int currentPage, UserBank uBank) { var ubList = db.UserBanks.AsQueryable(); User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User; //区分用户加载数据,如果不是超级管理员,只能查看自己的数据 if (!UserPower.adminUserCode.Contains(loginUser.cUserCode)) { ubList = ubList.Where(ub => ub.UserID == loginUser.ID); } //筛选卡号 if (uBank != null && !string.IsNullOrEmpty(uBank.BankNo)) { ubList = ubList.Where(ub => ub.BankNo.Contains(uBank.BankNo)); } //筛选银行名称 if (uBank != null && !string.IsNullOrEmpty(uBank.BankName)) { ubList = ubList.Where(ub => ub.BankName.Contains(uBank.BankName)); } //筛选银行卡类型 if (uBank != null && !string.IsNullOrEmpty(uBank.BankCardType) && uBank.BankCardType != "-1") { ubList = ubList.Where(ub => ub.BankCardType == uBank.BankCardType); } //筛选用户 if (uBank != null && !string.IsNullOrEmpty(uBank.UserID.ToString()) && uBank.UserID > 0) { ubList = ubList.Where(ub => ub.UserID == uBank.UserID); } SetPagerOptions(ubList.Count(), currentPage); List<UserBank> list = ubList.OrderBy(b => b.BankID).Skip((currentPage - 1) * pageSize).Take(pageSize).ToList(); return list; }
public ActionResult List(UserBank uBank) { int pageNO = 1; if (Request.Form["pageNum"] != null) { int.TryParse(Request.Form["pageNum"], out pageNO); } BindBankCardType(); BindComboxUser(); List<UserBank> list = GetUserBankList(pageNO, uBank); return View(viewFolder + "List.cshtml", list); }
public string Edit(UserBank userbank) { try { User loginUser = Session[SessionList.FamilyManageUser.ToString()] as User; userbank.BankID = Convert.ToInt32(Request.Form["search_bank.BankID"]); userbank.BankName = Request.Form["search_bank.BankName"]; userbank.UserID = loginUser.ID; userbank.UserName = loginUser.cUserName; db.Entry(userbank).State = EntityState.Modified; db.SaveChanges(); return WebComm.ReturnAlertMessage(ActionReturnStatus.成功, "修改成功", "userBankList", "", CallBackType.none, ""); } catch (Exception ex) { return WebComm.ReturnAlertMessage(ActionReturnStatus.失败, "修改失败" + ex.Message, "", "", CallBackType.none, ""); } }
// PUT api/UserBank_WebAPI/5 public HttpResponseMessage PutUserBank(int id, UserBank userbank) { if (ModelState.IsValid && id == userbank.ID) { db.Entry(userbank).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { return Request.CreateResponse(HttpStatusCode.NotFound); } return Request.CreateResponse(HttpStatusCode.OK); } else { return Request.CreateResponse(HttpStatusCode.BadRequest); } }