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()));
}
