public ReportViewSpareSalesByPeriod(DateTime df, DateTime dt, int SpareID, int WID) { InitializeComponent(); dateTo = dt; dateFrom = df; WarehouseID = WID; DataAccess db = new DataAccess(); Spare = db.GetSpareView(SpareID); if (Spare == null) return; }
public SpareView SpareCreateSilent(string Name, string CodeShatem, string GroupName, string ParentGroupName, string BrandName, string UnitName, string Description) { DataAccess da = new DataAccess(); spare s = da.SpareCreateSilent(Name, CodeShatem, GroupName, ParentGroupName, BrandName, UnitName, Description); SpareView SpareViewItem = da.GetSpareView(s.id); SpareContainer.Instance.Update(s.id); int BrandID = SpareViewItem.BrandID; int GroupID = SpareViewItem.GroupID; if (SpareContainer.Instance.Spares.Where(i => i.BrandID == BrandID && i.GroupID == GroupID).Count() == 1) { if (s.brand == null) s.brandReference.Load(); da.SpareGroupCreate(GroupID, s.brand.name); } return SpareViewItem; }
// ЗАПЧАСТЬ - ДОБАВИТЬ public SpareView SpareCreate() { if (!ready()) return null;// null; SpareView result = null; SpareEditView v = new SpareEditView(); v._id = -1; v.ParentWorkspace = mainWindowObj; v.ShowDialog(); if (v._spare != null) { DataAccess db = new DataAccess(); result = db.GetSpareView(v._spare.id); mainWindowObj.LoadSpares(); mainWindowObj.LoadGroups(false); } return result; }
private void OfferingAdd(int SpareID, decimal Q, decimal Pusd, string GroupName, string ParentGroupName) { SpareInSpareIncomeView sisi = new SpareInSpareIncomeView(); if (Income.currency == null) Income.currencyReference.Load(); sisi.num = offerings.Count + 1; sisi.CurrencyID = Income.currency.id; sisi.description = ""; sisi.Markup = 0; sisi.PIn = Pusd; sisi.PInBasic = Pusd; sisi.POut = Pusd; sisi.POutBasic = Pusd; sisi.QIn = Q; sisi.QRest = Q; sisi.S = Q * Pusd; sisi.SBasic = sisi.S; sisi.GroupName = GroupName; sisi.ParentGroupName = ParentGroupName; DataAccess db = new DataAccess(); sisi.SpareID = SpareID; SpareView sv = db.GetSpareView(SpareID); sisi.SpareName = sv.name; sisi.SpareCode = sv.code; sisi.SpareCodeShatem = sv.codeShatem; sisi.BrandName = sv.BrandName; sisi.SpareIncomeID = Income.id; sisi.VatRateName = "0%"; offerings.Add(sisi); }
private void OfferingAdd(int SpareID) { SpareInSpareIncomeView sisi = new SpareInSpareIncomeView(); if (Income.currency == null) Income.currencyReference.Load(); sisi.num = offerings.Count + 1; sisi.CurrencyID = Income.currency.id; sisi.description = ""; sisi.Markup = 0; sisi.PIn = 1; sisi.PInBasic = 1; sisi.POut = 1; sisi.POutBasic = 1; sisi.QIn = 1; sisi.QRest = 1; sisi.S = 1; sisi.SBasic = 1; DataAccess db = new DataAccess(); sisi.SpareID = SpareID; SpareView sv = db.GetSpareView(SpareID); sisi.SpareName = sv.name; sisi.SpareCode = sv.code; sisi.SpareCodeShatem = sv.codeShatem; sisi.BrandName = sv.BrandName; sisi.SpareIncomeID = Income.id; sisi.VatRateName = "0%"; sisi.GroupName = db.GetSpareGroup(sv.GroupID).name; sisi.ParentGroupName = db.GetSpareGroup(sv.spare_group1_id.Value).name; offerings.Add(sisi); }
private void Window_Closing(object sender, System.ComponentModel.CancelEventArgs e) { if (IsNew && TemporarySaved) { DataAccess db = new DataAccess(); SpareViewItem = db.GetSpareView(this._id); Marvin.Instance.SpareDelete(SpareViewItem); } }
/* * OLD public void Update(SpareView spare) { if (Spares.Where(x => x!= null).Where(x => x.id != null).Where(x => x.id == spare.id).Count() > 0) { SpareView sv = spares.Where(x => x != null).Where(x => x.id != null).FirstOrDefault(x => x.id == spare.id); if(sv != null) Spares.Remove(sv); } Spares.Add(spare); }*/ /* dec2012 public void Update(SpareView NewSpareInstance, bool UpdateFromDB = true) // обновление без удаления { if (UpdateFromDB) { DataAccess da = new DataAccess(); SpareView OldSpareInstance = Spares.Where(x => x != null).FirstOrDefault(x => x.id == NewSpareInstance.id); // если в кэше такая есть, запоминает индекс и перезаписываем if (OldSpareInstance != null) { int i = Spares.IndexOf(OldSpareInstance); spares[i] = NewSpareInstance; } else { spares.Add(NewSpareInstance); } } else { List<SpareView> items = this.Spares; SpareView ind = items.Where(x => x != null).FirstOrDefault(x => x.id == NewSpareInstance.id); if (ind != null) { int i = spares.IndexOf(ind); spares[i] = NewSpareInstance; } else { spares.Add(NewSpareInstance); } } } */ public void Update(int SpareID, bool UpdateFromDB = true, bool SkipQRestsCalculation = false) { if (UpdateFromDB) { DataAccess da = new DataAccess(); SpareView OldSpareInstance = Spares.Where(x => x != null).FirstOrDefault(x => x.id == SpareID); SpareView NewSpareInstance = da.GetSpareView(SpareID); // если в кэше такая есть, запоминает индекс и перезаписываем if (OldSpareInstance != null) { int i = Spares.IndexOf(OldSpareInstance); spares[i] = NewSpareInstance; } else { spares.Add(NewSpareInstance); } } else { List<SpareView> items = this.Spares.ToList(); SpareView ind = items.Where(x => x != null).FirstOrDefault(x => x.id == SpareID); if (ind != null) { int i = spares.IndexOf(ind); spares[i] = ind; } else { DataAccess db = new DataAccess(); SpareView sv = db.GetSpareView(SpareID); spares.Add(sv); } } if (!SkipQRestsCalculation) { Helper.CalculateQRests(SpareID); Update(SpareID, true, true); } }