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