public bool CheckIsLast(int noteid)
{
bool bRet = false;
using (var repo = DMRepository.Get())
{
DeliveryNote note = repo.Get <DeliveryNote>(p => p.noteid == noteid);
if (note != null)
{
Spec <CustomerEntity> where = new Spec <CustomerEntity>();
where.And(p => p.customer == note.customer);
where.And(p => p.cyear == note.sdate.Year);
CustomerEntity customer = repo.Get <CustomerEntity>(where.Exp);
if (customer != null)
{
if (customer.sequence == note.deliverid)
{
bRet = true;
}
}
}
}
return(bRet);
}
public String Delete(int noteid, bool isdecrease)
{
String bErr = "";
CustomerEntity customer = null;
if (isdecrease)
{
using (var repo = DMRepository.Get())
{
DeliveryNote note = repo.Get <DeliveryNote>(p => p.noteid == noteid);
if (note == null)
{
return("当前送货单不存在");
}
Spec <CustomerEntity> where = new Spec <CustomerEntity>();
where.And(p => p.customer == note.customer);
if (note.sdate.Year <= 1)
{
where.And(p => p.cyear == DateTime.Now.Year);
}
else
{
where.And(p => p.cyear == note.sdate.Year);
}
customer = repo.Get <CustomerEntity>(where.Exp);
if (customer == null)
{
return("系统中没有此客户信息");
}
if (customer.sequence != note.deliverid)
{
return("当前送货单已归档，不能删除");
}
customer.sequence = customer.sequence - 1;
}
}
using (var dmt = DMContext.GetTransaction())
{
var trans = dmt.BeginTransaction();
if (customer != null & isdecrease)
{
DMContext.Update <CustomerEntity>(customer, p => p.cid == customer.cid, null, trans);
}
DMContext.Delete <DeliveryItem>(p => p.noteid == noteid, trans);
DMContext.Delete <DeliveryNote>(p => p.noteid == noteid, trans);
trans.Commit();
}
return(bErr);
}
public DeliveryNote Select(int noteId)
{
DeliveryNote note;
using (var repo = DMRepository.Get())
{
note = repo.Get <DeliveryNote>(p => p.noteid == noteId);
note.items = repo.GetList <DeliveryItem>(50, p => p.noteid == noteId, p => p.itemid.Asc());
}
return(note);
}
public Collection GetCollectionForProcessing(XmlNode siteData)
{
string siteName = siteData["Folder"].InnerText;
CameraSite site = SiteRepository.Find(s => s.Name == siteName).FirstOrDefault();
Collection collection = null;
if (site == null)
{
site = new CameraSite();
site.Name = siteData["Folder"].InnerText;
site.DirectoryName = siteData["Folder"].InnerText;
site.ContainerID = Guid.NewGuid().ToString();
if (siteData["Location"].Attributes["latitude"].Value != String.Empty)
{
site.Latitude = Convert.ToDouble(siteData["Location"].Attributes["latitude"].Value);
site.Longitude = Convert.ToDouble(siteData["Location"].Attributes["longitude"].Value);
}
var county = siteData["County"].InnerText;
var state = siteData["State"].InnerText;
site.CountyFips = DMRepository.GetFipsForCountyAndState(county, state);
collection = new Collection()
{
ContainerID = site.ContainerID,
Name = site.Name,
Site = site,
Status = CollectionStatus.PROCESSING,
Type = CollectionType.SITE
};
CollectionRepository.Insert(collection);
SiteRepository.Insert(site);
}
else
{
collection = CollectionRepository.Find(c => c.Site.ID == site.ID).FirstOrDefault();
collection.Status = CollectionStatus.PROCESSING;
CollectionRepository.Update(collection);
}
return(collection);
}
public ICollection <TimeLapseFrame> CreateTimeLapseFramesFromIDs(long[] photoIDs)
{
List <TimeLapseFrame> frames = new List <TimeLapseFrame>();
long firstID = photoIDs[0]; // stupid LINQ
USCounty county = DMRepository.GetCountyForFips(PhotoRepository.Find(p => p.ID == firstID, p => p.Site)
.FirstOrDefault().Site.CountyFips);
var properties = PhotoRepo.GetPhotoProperties(photoIDs, new string[] { "ID", "Captured" });
foreach (var property in properties)
{
var frame = new TimeLapseFrame()
{
FrameTime = (DateTime)property["Captured"], PhotoID = (long)property["ID"]
};
frames.Add(frame);
}
return(frames);
}
