public ActionResult Issue_EditData(DXInfo.Models.Vehicle vehicle, string CardNo) { var gridModel = new VehicleGridModel(); if (gridModel.VehicleGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow) { MembershipUser user = Membership.GetUser(); Guid userId = Guid.Parse(user.ProviderUserKey.ToString()); if (CardNo.Length != 5) { return(gridModel.VehicleGrid.ShowEditValidationMessage("请输入5位卡号")); } var c = db.Cards.Where(w => w.CardNo == CardNo).FirstOrDefault(); if (c != null) { return(gridModel.VehicleGrid.ShowEditValidationMessage("卡号已存在")); } using (var Content = db) { var dept = db.aspnet_CustomProfile.Where(w => w.UserId == userId).FirstOrDefault(); Guid deptId = dept.DeptId.HasValue ? dept.DeptId.Value : Guid.Empty; DXInfo.Models.Card card = new DXInfo.Models.Card(); card.CardNo = CardNo; card.Vehicle = vehicle.Id; card.CreateDate = DateTime.Now; card.UserId = userId; card.DeptId = deptId; db.Cards.Add(card); db.SaveChanges(); } } return(RedirectToAction("Issue")); }
public ActionResult Vehicle() { var gridModel = new VehicleGridModel(); SetupVehicleGridModel(gridModel.VehicleGrid); return(View(gridModel)); }
public ActionResult Vehicle_EditData(DXInfo.Models.Vehicle vehicle) { var gridModel = new VehicleGridModel(); if (gridModel.VehicleGrid.AjaxCallBackMode == AjaxCallBackMode.AddRow) { var v = db.Vehicles.Where(w => w.PlateNo == vehicle.PlateNo).FirstOrDefault(); if (v != null) { return(gridModel.VehicleGrid.ShowEditValidationMessage("车牌号已存在")); } using (var context = db) { vehicle.Id = Guid.NewGuid(); context.Vehicles.Add(vehicle); context.SaveChanges(); } } if (gridModel.VehicleGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow) { using (var context = db) { var oldvehicle = context.Vehicles.Where(w => w.Id == vehicle.Id).FirstOrDefault(); if (oldvehicle.PlateNo != vehicle.PlateNo) { var v = db.Vehicles.Where(w => w.PlateNo == vehicle.PlateNo).FirstOrDefault(); if (v != null) { return(gridModel.VehicleGrid.ShowEditValidationMessage("车牌号已存在")); } } oldvehicle.PlateNo = vehicle.PlateNo; oldvehicle.BrandModel = vehicle.BrandModel; oldvehicle.MotorNo = vehicle.MotorNo; oldvehicle.Comment = vehicle.Comment; //oldvehicle.OwnerName = vehicle.OwnerName; //oldvehicle.OwnerIdCardNo = vehicle.OwnerIdCardNo; //oldvehicle.OwnerDriverNo = vehicle.OwnerDriverNo; oldvehicle.OwnerName = vehicle.OwnerName; context.SaveChanges(); } } return(RedirectToAction("Vehicle")); }
public ActionResult Vehicle_RequestData() { var gridModel = new VehicleGridModel(); SetupVehicleGridModel(gridModel.VehicleGrid); var vehicles = (from v in db.Vehicles //join d in db.Drivers on v.Driver equals d.Id into vd //from veh in vd.DefaultIfEmpty() select new { v.Id, v.PlateNo, v.MotorNo, v.BrandModel, v.Comment, v.OwnerName }).ToList(); var veh2 = vehicles.Select(s => new { s.Id, s.PlateNo, s.BrandModel, s.MotorNo, s.OwnerName, s.Comment }); return(gridModel.VehicleGrid.DataBind(veh2.ToList().AsQueryable())); }