public ActionResult Add() { var gridModel = new AddCardsGridModel(); SetupAddGridModel(gridModel.CardsGrid); return(View(gridModel)); }
public ActionResult Add_RequestData() { var gridModel = new AddCardsGridModel(); SetupAddGridModel(gridModel.CardsGrid); var cards = (from c in db.Cards.Where(w => w.Status == 1) join v in db.Vehicles on c.Vehicle equals v.Id join u in db.aspnet_CustomProfile on c.UserId equals u.UserId into cu from cus in cu.DefaultIfEmpty() join d in db.Depts on c.DeptId equals d.DeptId into cd from cds in cd.DefaultIfEmpty() select new { c.Id, IsInUser = true, c.CardNo, c.SecondCardNo, c.AddReason, c.LossDate, v.PlateNo, v.MotorNo, v.BrandModel, cus.FullName, cds.DeptName }).ToList(); return(gridModel.CardsGrid.DataBind(cards.AsQueryable())); }
public ActionResult Add_EditData(DXInfo.Models.Card card) { var gridModel = new AddCardsGridModel(); SetupAddGridModel(gridModel.CardsGrid); if (gridModel.CardsGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow) { if (string.IsNullOrEmpty(card.SecondCardNo) || card.SecondCardNo.Length != 5) { return(gridModel.CardsGrid.ShowEditValidationMessage("请输入5位卡号")); } var c = db.Cards.Where(w => w.CardNo == card.SecondCardNo).FirstOrDefault(); if (c != null) { return(gridModel.CardsGrid.ShowEditValidationMessage("卡号已存在")); } MembershipUser user = Membership.GetUser(); Guid userId = Guid.Parse(user.ProviderUserKey.ToString()); using (var context = db) { var dept = context.aspnet_CustomProfile.Where(w => w.UserId == userId).FirstOrDefault(); var oldcard = context.Cards.Where(w => w.Id == card.Id).FirstOrDefault(); oldcard.Status = 2; oldcard.SecondCardNo = card.SecondCardNo; oldcard.AddDate = DateTime.Now; oldcard.AddUserId = userId; oldcard.AddReason = card.AddReason; DXInfo.Models.Card newcard = new DXInfo.Models.Card(); newcard.Id = Guid.NewGuid(); newcard.CardNo = card.SecondCardNo; newcard.Vehicle = oldcard.Vehicle; newcard.CreateDate = DateTime.Now; newcard.UserId = userId; newcard.DeptId = dept.DeptId.HasValue ? dept.DeptId.Value : Guid.Empty; context.Cards.Add(newcard); context.SaveChanges(); } } return(RedirectToAction("Add")); }