public ActionResult VehicleList() { var gridModel = new VehicleListGridModel(); SetupVehicleListGrid(gridModel.VehicleListGrid); return(View(gridModel)); }
public ActionResult VehicleList_EditData(DXInfo.Models.Transport tp) { var gridModel = new VehicleListGridModel(); SetupVehicleListGrid(gridModel.VehicleListGrid); if (gridModel.VehicleListGrid.AjaxCallBackMode == AjaxCallBackMode.EditRow) { MembershipUser user = Membership.GetUser(); Guid userId = Guid.Parse(user.ProviderUserKey.ToString()); using (var context = db) { var oldtp = context.Transports.Where(w => w.Id == tp.Id).FirstOrDefault(); var dept = context.aspnet_CustomProfile.Where(w => w.UserId == userId).FirstOrDefault(); if (oldtp == null) { return(gridModel.VehicleListGrid.ShowEditValidationMessage("未找到车辆记录")); } oldtp.BalanceType = tp.BalanceType; oldtp.AgreeFreightRate = tp.AgreeFreightRate; oldtp.FreightRate = tp.FreightRate; oldtp.Shipper = tp.Shipper; oldtp.Shipper_Telephone = tp.Shipper_Telephone; oldtp.Carrier = tp.Carrier; oldtp.Carrier_Telephone = tp.Carrier_Telephone; oldtp.Lines = tp.Lines; oldtp.Load_Quantity = tp.Load_Quantity; oldtp.Shipment_Quantity = tp.Shipment_Quantity; oldtp.Shipment_CheckUser = tp.Shipment_CheckUser; oldtp.Comment = tp.Comment; oldtp.ModifyDate = DateTime.Now; oldtp.ModifyUserId = userId; oldtp.ModifyDeptId = dept.DeptId; DXInfo.Models.TransportsLog tl = new DXInfo.Models.TransportsLog(); tl.Id = Guid.NewGuid(); tl.tpId = oldtp.Id; tl.AgreeFreightRate = oldtp.AgreeFreightRate; tl.BalanceType = oldtp.BalanceType; tl.Card = oldtp.Card; tl.Carrier = oldtp.Carrier; tl.Carrier_Telephone = oldtp.Carrier_Telephone; tl.Comment = oldtp.Comment; tl.Driver = oldtp.Driver; tl.FreightRate = oldtp.FreightRate; tl.InFactory_Date = oldtp.InFactory_Date; tl.InFactory_DeptId = oldtp.InFactory_DeptId; tl.InFactory_UserId = oldtp.InFactory_UserId; tl.Lines = oldtp.Lines; tl.Load_Date = oldtp.Load_Date; tl.Load_DeptId = oldtp.Load_DeptId; tl.Load_Inventory = oldtp.Load_Inventory; tl.Load_Quantity = oldtp.Load_Quantity; tl.Load_UserId = oldtp.Load_UserId; tl.ModifyDate = oldtp.ModifyDate; tl.ModifyDeptId = oldtp.ModifyDeptId; tl.ModifyUserId = oldtp.ModifyUserId; tl.OutFactory_Date = oldtp.OutFactory_Date; tl.OutFactory_DeptId = oldtp.OutFactory_DeptId; tl.OutFactory_UserId = oldtp.OutFactory_UserId; tl.Shipment_CheckUser = oldtp.Shipment_CheckUser; tl.Shipment_Date = oldtp.Shipment_Date; tl.Shipment_DeptId = oldtp.Shipment_DeptId; tl.Shipment_Quantity = oldtp.Shipment_Quantity; tl.Shipment_UserId = oldtp.Shipment_UserId; tl.Shipper = oldtp.Shipper; tl.Shipper_Telephone = oldtp.Shipper_Telephone; tl.Status = oldtp.Status; context.TransportsLog.Add(tl); context.SaveChanges(); } } return(RedirectToAction("VehicleList")); }
public ActionResult ExportToExcel() { var gridModel = new VehicleListGridModel(); SetupVehicleListGrid(gridModel.VehicleListGrid); var tps = (from t in db.Transports join c in db.Cards on t.Card equals c.Id into tc from tcs in tc.DefaultIfEmpty() join v in db.Vehicles on tcs.Vehicle equals v.Id into cv from cvs in cv.DefaultIfEmpty() //join dr in db.Drivers on cvs.Driver equals dr.Id into vdr //from vdrs in vdr.DefaultIfEmpty() join dr1 in db.Drivers on t.Driver equals dr1.Id into tdr from tdrs in tdr.DefaultIfEmpty() join n in db.NameCode on t.BalanceType equals n.ID into tn from tns in tn.DefaultIfEmpty() join l in db.Lines on t.Lines equals l.Id into tl from tls in tl.DefaultIfEmpty() join d1 in db.Depts on t.InFactory_DeptId equals d1.DeptId into td1 from td1s in td1.DefaultIfEmpty() join u1 in db.aspnet_CustomProfile on t.InFactory_UserId equals u1.UserId into tu1 from tu1s in tu1.DefaultIfEmpty() join d2 in db.Depts on t.Load_DeptId equals d2.DeptId into td2 from td2s in td2.DefaultIfEmpty() join u2 in db.aspnet_CustomProfile on t.Load_UserId equals u2.UserId into tu2 from tu2s in tu2.DefaultIfEmpty() join i in db.Inventory on t.Load_Inventory equals i.Id into ti from tis in ti.DefaultIfEmpty() join um in db.UnitOfMeasures on tis.UnitOfMeasure equals um.Id into ium from iums in ium.DefaultIfEmpty() join d3 in db.Depts on t.Shipment_DeptId equals d3.DeptId into td3 from td3s in td3.DefaultIfEmpty() join u3 in db.aspnet_CustomProfile on t.Shipment_UserId equals u3.UserId into tu3 from tu3s in tu3.DefaultIfEmpty() join d4 in db.Depts on t.OutFactory_DeptId equals d4.DeptId into td4 from td4s in td4.DefaultIfEmpty() join u4 in db.aspnet_CustomProfile on t.OutFactory_UserId equals u4.UserId into tu4 from tu4s in tu4.DefaultIfEmpty() //join u5 in db.aspnet_CustomProfile on t.Shipment_CheckUserId equals u5.UserId into tu5 //from tu5s in tu5.DefaultIfEmpty() join d6 in db.Depts on t.ModifyDeptId equals d6.DeptId into td6 from td6s in td6.DefaultIfEmpty() join u6 in db.aspnet_CustomProfile on t.ModifyUserId equals u6.UserId into tu6 from tu6s in tu6.DefaultIfEmpty() select new { t.Id, tcs.CardNo, t.Status, cvs.PlateNo, cvs.BrandModel, cvs.MotorNo, OwnName = cvs.OwnerName, DriverName = tdrs.Name, t.BalanceType, BalanceTypeName = tns.Name, t.AgreeFreightRate, t.FreightRate, t.Shipper, t.Shipper_Telephone, t.Carrier, t.Carrier_Telephone, t.Lines, LinesName = tls.Name, tls.Mileage, InFactory_Dept = td1s.DeptName, t.InFactory_Date, InFactory_Oper = tu1s.FullName, Load_Dept = td2s.DeptName, t.Load_Date, Load_Oper = tu2s.FullName, Load_Inventory = tis.Name, UnitName = iums.Name, tis.Specs, t.Load_Quantity, Shipment_Dept = td3s.DeptName, t.Shipment_Date, Shipment_Oper = tu3s.FullName, t.Shipment_Quantity, //t.Shipment_CheckUserId, t.Shipment_CheckUser, OutFactory_Dept = td4s.DeptName, t.OutFactory_Date, OutFactory_Oper = tu4s.FullName, Modify_Dept = td6s.DeptName, t.ModifyDate, Modify_Oper = tu6s.FullName, t.Comment }).ToList(); //var tpls = tps.ToList(); var tpls = tps.Select(s => new { s.Id, s.CardNo, Status = s.Status == 0 ? "进厂" : s.Status == 1 ? "装车" : s.Status == 2 ? "卸货" : "出厂", s.PlateNo, s.BrandModel, s.MotorNo, s.OwnName, s.DriverName, s.BalanceType, s.BalanceTypeName, s.AgreeFreightRate, s.FreightRate, s.Shipper, s.Shipper_Telephone, s.Carrier, s.Carrier_Telephone, s.Lines, s.LinesName, s.Mileage, s.InFactory_Dept, s.InFactory_Date, s.InFactory_Oper, s.Load_Dept, s.Load_Date, s.Load_Oper, s.Load_Inventory, s.UnitName, s.Specs, s.Load_Quantity, s.Shipment_Dept, s.Shipment_Date, s.Shipment_Oper, s.Shipment_Quantity, //s.Shipment_CheckUserId, s.Shipment_CheckUser, s.OutFactory_Dept, s.OutFactory_Date, s.OutFactory_Oper, s.Modify_Dept, s.ModifyDate, s.Modify_Oper, s.Comment }); JQGridState gridState = Session["GridStateV"] as JQGridState; gridModel.VehicleListGrid.ExportToExcel(tpls.AsQueryable(), "车辆清单.xls", gridState); return(View()); }