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