/// <summary>
/// 加载历史工程列表
/// </summary>
public void LoadProjectList()
{
try
{
// 历史文件模型
HistoryModels models = HistoryModels.Open();
models.Sort((model1, model2) =>
{
return(model1.LastModified > model2.LastModified ? -1
: model1.LastModified == model2.LastModified ? 0 : 1);
});
BindingSource bindingSource = new BindingSource();
foreach (var item in models)
{
if (false == File.Exists(item.FilePath))
{
continue;
}
bindingSource.Add(item);
}
gridRecent.DataSource = bindingSource;
}
catch (Exception ex)
{
throw ex;
}
}
private void FinishSearch()
{
if (String.IsNullOrEmpty(ClientNumber) == false)
{
HistoryModels = new BindableCollection <HistoryModel>(HistoryModels.ToList().Where(x => x.Client.PhoneNumber.Contains(ClientNumber)));
}
if (String.IsNullOrEmpty(ClientName) == false)
{
HistoryModels = new BindableCollection <HistoryModel>(HistoryModels.ToList().Where(x => x.Client.Name.Contains(ClientName)));
}
if (String.IsNullOrEmpty(ClientSurname) == false)
{
HistoryModels = new BindableCollection <HistoryModel>(HistoryModels.ToList().Where(x => x.Client.Surname.Contains(ClientSurname)));
}
if (String.IsNullOrEmpty(ProductFactoryNumber) == false)
{
HistoryModels = new BindableCollection <HistoryModel>(HistoryModels.ToList().Where(x => x.FactoryNumber.Contains(ProductFactoryNumber)));
}
if (String.IsNullOrEmpty(ProductName) == false)
{
HistoryModels = new BindableCollection <HistoryModel>(HistoryModels.ToList().Where(x => x.Name.Contains(ProductName)));
}
if (String.IsNullOrEmpty(ProductSet) == false)
{
HistoryModels = new BindableCollection <HistoryModel>(HistoryModels.ToList().Where(x => x.Set.Contains(ProductSet)));
}
isOpenPopup = false;
EmptySearchParameters();
if (HistoryModels.Count == 0)
{
RefreshView();
MessageBox.Show("Жодного результату за вашим пошуком");
}
}
public ActionResult DeleteConfirmed(int id)
{
HistoryModels roomModels = db.HistoryModels.Find(id);
db.HistoryModels.Remove(roomModels);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void CountSums()
{
SumOfEarnings = 0;
SumOfNetPrices = 0;
SumOfSellPrices = 0;
HistoryModels.ToList().ForEach(x => SumOfSellPrices += x.ProductSellPrice * x.ProductQuantity);
HistoryModels.ToList().ForEach(x => SumOfNetPrices += x.ProductNetPrice * x.ProductQuantity);
SumOfEarnings = SumOfSellPrices - SumOfNetPrices;
}
public ActionResult Edit([Bind(Include = "ID,Name,Peopel,Coustomer,StartTime,EndTime,Tips,Person")] HistoryModels roomModels)
{
if (ModelState.IsValid)
{
db.Entry(roomModels).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(roomModels));
}
public ActionResult Create([Bind(Include = "ID,Name,Peopel,Coustomer,StartTime,EndTime,Tips,Person")] HistoryModels roomModels)
{
if (ModelState.IsValid)
{
//db.HistoryModels.Add(roomModels);
//db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(roomModels));
}
// GET: RoomPage/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HistoryModels roomModels = db.HistoryModels.Find(id);
if (roomModels == null)
{
return(HttpNotFound());
}
return(View(roomModels));
}
public bool WriteHis([Bind(Include = "Id,RoomId,RoomName,Peopel,Coustomer,StartTime,EndTime,Tips")] RoomModels rm)
{
HistoryModels room = new HistoryModels();
room.RoomId = rm.ID;
room.RoomName = rm.Name;
room.Peopel = rm.Peopel;
room.Coustomer = rm.Coustomer;
room.StartTime = rm.StartTime;
room.EndTime = rm.EndTime;
room.Tips = rm.Tips;
if (ModelState.IsValid)
{
db.HistoryModels.Add(room);
db.SaveChanges();
return(true);
}
return(false);
}
