public bool Save(ContractDetail contractDetail, out string strResult) { strResult = string.Empty; bool result = false; var con = ContractDetailRepository.GetQueryable().FirstOrDefault(c => c.ContractCode == contractDetail.Contract.ContractCode); if (con != null) { try { con.BrandCode = contractDetail.BrandCode; con.Quantity = contractDetail.Quantity; con.Price = contractDetail.Price; con.Amount = contractDetail.Amount; con.TaxAmount = contractDetail.TaxAmount; ContractDetailRepository.SaveChanges(); result = true; } catch (Exception ex) { strResult = "原因:" + ex.Message; } } return(result); }
public bool Add(ContractDetail contractDetail, out string strResult) { strResult = string.Empty; bool result = false; var c = new ContractDetail(); if (c != null) { try { c.ID = Guid.NewGuid(); c.ContractCode = contractDetail.ContractCode; c.BrandCode = contractDetail.BrandCode; c.Quantity = contractDetail.Quantity; c.Price = contractDetail.Price; c.Amount = contractDetail.Amount; c.TaxAmount = contractDetail.TaxAmount; ContractDetailRepository.Add(c); ContractDetailRepository.SaveChanges(); result = true; } catch (Exception ex) { strResult = "原因:" + ex.InnerException; } } else { strResult = "原因:找不到当前登陆用户!请重新登陆!"; } return(result); }
// // GET: /Site/Edit/5 public ActionResult Edit(int id) { SiteMonitoring e = repo.Get(id); ContractDetailRepository cdrepo = new ContractDetailRepository(); ContractDetail cd = cdrepo.Get(e.ContractDetailID.ToInt()); e.Site = cd.Site; return View(e); }
// // GET: /Site/Edit/5 public ActionResult Edit(int id) { SiteMonitoring e = repo.Get(id); ContractDetailRepository cdrepo = new ContractDetailRepository(); ContractDetail cd = cdrepo.Get(e.ContractDetailID.ToInt()); e.Site = cd.Site; return(View(e)); }
public ActionResult Create(int? contractDetailID, IEnumerable<HttpPostedFileBase> files, string[] noteList) { repo.Create(UpdateModel, files, contractDetailID, noteList); ContractDetailRepository contractDetailRepository = new ContractDetailRepository(); ContractDetail e = contractDetailRepository.Get(contractDetailID.Value); return RedirectToAction("Edit", "Contract", new { id = e.ContractID }); }
public ActionResult Create(int?contractDetailID, IEnumerable <HttpPostedFileBase> files, string[] noteList) { repo.Create(UpdateModel, files, contractDetailID, noteList); ContractDetailRepository contractDetailRepository = new ContractDetailRepository(); ContractDetail e = contractDetailRepository.Get(contractDetailID.Value); return(RedirectToAction("Edit", "Contract", new { id = e.ContractID })); }
public ContractDetail DeleteTheLastTimeline(int contractDetailID) { ContractDetailRepository contractDetailRepo = new ContractDetailRepository() { DB = DB }; var r = contractDetailRepo.Get(contractDetailID); var lastTimeline = r.ContractDetailTimelines.OrderByDescending(r1 => r1.Order).FirstOrDefault(); if (lastTimeline != null) { if (r.SiteMonitorings.Where(r1 => r1.Order == lastTimeline.Order).Count() == 0) { DB.DeleteObject(lastTimeline); Save(); } } return r; }
public IEnumerable<SelectListItem> FilterOrderForCreate(int contractDetailID) { ContractDetailRepository contractDetailRepository = new ContractDetailRepository(); SiteMonitoringRepository siteMonitoringRepository = new SiteMonitoringRepository(); var contractDetail = contractDetailRepository.Get(contractDetailID); var orderList = contractDetail.SiteMonitorings.Select(r => r.Order).Distinct(); var timelineList = contractDetail.ContractDetailTimelines .ToList() .Where(r => !orderList.Contains(r.Order)) .OrderBy(r => r.Order) .Select(r => new SelectListItem() { Value = r.Order.ToString(), Text = string.Format("{0}: {1} - {2}", r.Order, String.Format("{0:d}", r.FromDate), String.Format("{0:d}", r.ToDate)) }); ; return timelineList; }
public void AddSite(int contractID, int siteDetailID) { var siteDetailRepo = new SiteDetailRepository() { DB = DB }; var siteDetail = siteDetailRepo.Get(siteDetailID); ContractDetail e = new ContractDetail(); e.ContractID = contractID; e.SiteID = siteDetail.SiteID; e.Format = siteDetail.Format; e.SiteDetailName = siteDetail.Name; DB.ContractDetails.AddObject(e); Save(); ContractDetailRepository contractDetailRepository = new ContractDetailRepository(); contractDetailRepository.CopyTimeline(e.ID); }
public ContractDetailTimeline Add(int contractDetailID, int timeCount, string timeUnit) { timeCount = timeCount < 1 ? 1 : timeCount; ContractDetailRepository contractDetailRepo = new ContractDetailRepository() { DB = DB }; var contractDetail = contractDetailRepo.Get(contractDetailID); var lastTimeline = contractDetail.ContractDetailTimelines.OrderByDescending(r => r.Order).FirstOrDefault(); var newTimeline = new ContractDetailTimeline(); if (lastTimeline == null) { newTimeline.Order = 1; newTimeline.FromDate = contractDetail.EffectiveDate.HasValue ? contractDetail.EffectiveDate : DateTime.Now.Date; } else { newTimeline.Order = lastTimeline.Order + 1; newTimeline.FromDate = lastTimeline.ToDate.Value.AddDays(1); } if (timeUnit.ToLower() == "day") { newTimeline.ToDate = newTimeline.FromDate.Value.AddDays(timeCount).AddDays(-1); } else if (timeUnit.ToLower() == "month") { newTimeline.ToDate = newTimeline.FromDate.Value.AddMonths(timeCount).AddDays(-1); } newTimeline.ContractDetailID = contractDetailID; DB.AddToContractDetailTimelines(newTimeline); Save(); return newTimeline; }
public SiteMonitoring Create(Action<SiteMonitoring> updateMethod, IEnumerable<HttpPostedFileBase> files, int? contractDetailID, string[] noteList) { var contractDetailRepository = new ContractDetailRepository() { DB = DB }; var contractDetail = contractDetailRepository.Get(contractDetailID.Value); SiteMonitoring e = new SiteMonitoring(); updateMethod(e); e.ContractDetail = contractDetail; Save(); PicasaRepository picasaRepository = new PicasaRepository(); picasaRepository.DB = DB; picasaRepository.UploadPhoto(e, files, noteList, false); Save(); return e; }
public SiteMonitoring InitWithDefaultValue(int? ContractDetailID) { SiteMonitoring e = new SiteMonitoring(); e.ContractDetailID = ContractDetailID; e.Working = true; e.Clean = true; e.CreativeGoodConditon = true; e.ExternalInterference = false; e.Vandalism = false; ContractDetailRepository cdrepo = new ContractDetailRepository(); ContractDetail cd = cdrepo.Get(ContractDetailID.ToInt()); e.ContractDetail = cd; e.NoOfBullbs = cd.Site.FrontlitNumerOfLamps; e.Site = cd.Site; e.ProductID = cd.ProductID; e.Product = cd.Product; return e; }