// ЗАПЧАСТЬ - ДОБАВИТЬ - СОХРАНИТЬ public spare SpareCreate(string Name, string Code, string CodeShatem, int QDemand, int GroupID, int BrandID, int UnitID, string Description) { DataAccess da = new DataAccess(); spare sp = new spare(); sp.name = Name; sp.code = Code; sp.codeShatem = CodeShatem; sp.q_demand = QDemand; sp.q_demand_clear = QDemand; sp.q_rest = 0; sp.description = Description; spare s = da.SpareCreate(sp, BrandID, GroupID, UnitID); SpareContainer.Instance.Update(s.id); 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(s); }
public spare SpareEditInBackground(int SpareID, string Name, string Code, string CodeShatem, int QDemand, int GroupID, int BrandID, int UnitID, string Description) { DataAccess da = new DataAccess(); spare sp = da.GetSpare(SpareID); sp.name = Name; sp.code = Code; sp.codeShatem = CodeShatem; sp.q_demand = QDemand; sp.q_demand_clear = QDemand; sp.q_rest = 0; sp.description = Description; if (sp.brand == null) { sp.brandReference.Load(); } if (sp.spare_group == null) { sp.spare_groupReference.Load(); } string OldBrandName = sp.BrandName; int OldBrandID = sp.brand.id; int OldGroupID = sp.spare_group.id; spare s = da.SpareEdit(sp, BrandID, GroupID, UnitID); return(s); }
private void BackgroundCreate_DoWork(object sender, DoWorkEventArgs e) { DataAccess da = new DataAccess(); spare sp = new spare(); sp.name = SpareUpdateName; sp.code = SpareUpdateCode; sp.codeShatem = SpareUpdateCodeShatem; sp.q_demand = SpareUpdateQDemand; sp.q_demand_clear = SpareUpdateQDemand; sp.q_rest = 0; sp.description = SpareUpdateDescription; spare s = da.SpareCreate(sp, SpareUpdateBrandID, SpareUpdateGroupID, SpareUpdateUnitID); SpareContainer.Instance.Update(s.id); if (SpareContainer.Instance.Spares.Where(i => i.BrandID == SpareUpdateBrandID && i.GroupID == SpareUpdateGroupID).Count() == 1) { if (s.brand == null) { s.brandReference.Load(); } da.SpareGroupCreate(SpareUpdateGroupID, s.brand.name); ReloadGroups = true; } }
//private delegate void UpdateProgressBarDelegate(System.Windows.DependencyProperty dp, Object value); public static int getSpares(string FilePath) { List <spare> items = new List <spare>(); // Объявляем и забиваем файл в документ XmlDocument xd = new XmlDocument(); FileStream fs = new FileStream(FilePath, FileMode.Open); xd.Load(fs); DataAccess da = new DataAccess(); XmlNodeList list = xd.GetElementsByTagName("Row"); // Создаем и заполняем лист по тегу "user" LoadingWindowView v = new LoadingWindowView(); v._ProgressBar.Minimum = 0; v._ProgressBar.Maximum = list.Count; v._ProgressBar.Value = list.Count / 2; //object value = 0; //Сохраняем значение ProgressBar //Создаем новый экземпляр делегата для ProgressBar // который показывает на метод ProgressBar.SetValue //UpdateProgressBarDelegate updatePbDelegate = new UpdateProgressBarDelegate(v._ProgressBar.SetValue); v.Show(); string Errors = ""; for (int i = 1; i < list.Count; i++) { try { spare b = new spare(); b.code1C = list[i].ChildNodes[0].InnerText; if (!da.ExistCode1C(b.code1C)) { b.codeShatem = list[i].ChildNodes[1].InnerText; b.name = list[i].ChildNodes[2].InnerText; string BrandCode1C = list[i].ChildNodes[3].InnerText; string GroupCode1C = list[i].ChildNodes[4].InnerText; da.SpareCreate(b, BrandCode1C, GroupCode1C); } } catch (Exception qwe) { Errors += qwe.Message; } } // Закрываем поток fs.Close(); v.Close(); return(items.Count); }
public void LoadItem(int id) { DataAccess da = new DataAccess(); _spare = da.GetSpare(id); if (_spare != null) { IsNew = false; if (_spare.brand == null) { _spare.brandReference.Load(); } if (_spare.spare_group == null) { _spare.spare_groupReference.Load(); } if (_spare.unit == null) { _spare.unitReference.Load(); } _id = _spare.id; string Name = _spare.name; string Code = _spare.code; string CodeShatem = _spare.codeShatem; string QDemand = _spare.q_demand.ToString(); int GroupID = _spare.spare_group.id; int BrandID = _spare.brand.id; int UnitID = _spare.unit.id; string BrandName = _spare.brand.name; string GroupName = _spare.spare_group.name; string UnitName = _spare.unit.name; string Description = _spare.description; OldBrandName = BrandName; OldGroupID = GroupID; edtName.Text = Name; edtCode.Text = Code; edtCodeShatem.Text = CodeShatem; edtQ_Demand.Text = QDemand; edtGroup.SelectedValue = GroupID; edtBrand.SelectedValue = BrandID; edtUnit.SelectedValue = UnitID; edtDescr.Text = Description; } }
// ЗАПЧАСТЬ - РЕДАКТИРОВАТЬ - СОХРАНИТЬ public spare SpareEdit(int SpareID, string Name, string Code, string CodeShatem, int QDemand, int GroupID, int BrandID, int UnitID, string Description) { DataAccess da = new DataAccess(); spare sp = da.GetSpare(SpareID); sp.name = Name; sp.code = Code; sp.codeShatem = CodeShatem; sp.q_demand = QDemand; sp.q_demand_clear = QDemand; sp.q_rest = 0; sp.description = Description; if (sp.brand == null) { sp.brandReference.Load(); } if (sp.spare_group == null) { sp.spare_groupReference.Load(); } string OldBrandName = sp.BrandName; int OldBrandID = sp.brand.id; int OldGroupID = sp.spare_group.id; spare s = da.SpareEdit(sp, BrandID, GroupID, UnitID); SpareContainer.Instance.Update(s.id); if (OldBrandID != BrandID || OldGroupID != GroupID) { if (SpareContainer.Instance.Spares.Where(i => i.BrandID == OldBrandID && i.GroupID == OldGroupID).Count() == 0) { da.SpareGroupDelete(OldBrandID, OldGroupID); mainWindowObj.LoadGroups(false); } if (SpareContainer.Instance.Spares.Where(i => i.BrandID == BrandID && i.GroupID == GroupID).Count() == 1) { da.SpareGroupCreate(GroupID, BrandID); mainWindowObj.LoadGroups(false); } } return(s); }
private void BackgroundEdit_DoWork(object sender, DoWorkEventArgs e) { int SpareID = _spare.id; DataAccess da = new DataAccess(); spare sp = da.GetSpare(SpareID); sp.name = SpareUpdateName; sp.code = SpareUpdateCode; sp.codeShatem = SpareUpdateCodeShatem; sp.q_demand = SpareUpdateQDemand; sp.q_demand_clear = SpareUpdateQDemand; sp.q_rest = 0; sp.description = SpareUpdateDescription; if (sp.brand == null) { sp.brandReference.Load(); } if (sp.spare_group == null) { sp.spare_groupReference.Load(); } string OldBrandName = sp.BrandName; int OldBrandID = sp.brand.id; int OldGroupID = sp.spare_group.id; spare s = da.SpareEdit(sp, SpareUpdateBrandID, SpareUpdateGroupID, SpareUpdateUnitID); SpareContainer.Instance.Update(s.id); if (OldBrandID != SpareUpdateBrandID || OldGroupID != SpareUpdateGroupID) { if (SpareContainer.Instance.Spares.Where(i => i.BrandID == OldBrandID && i.GroupID == OldGroupID).Count() == 0) { da.SpareGroupDelete(OldBrandID, OldGroupID); ReloadGroups = true; } if (SpareContainer.Instance.Spares.Where(i => i.BrandID == SpareUpdateBrandID && i.GroupID == SpareUpdateGroupID).Count() == 1) { da.SpareGroupCreate(SpareUpdateGroupID, SpareUpdateBrandID); ReloadGroups = true; } } }
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 void SpareDelete(SpareView item) { if (!ready()) { return; } //try { DataAccess da = new DataAccess(); int cnt = SpareContainer.Instance.Spares.Where(s => s.BrandID == item.BrandID && s.GroupID == item.GroupID).Count(); spare sp = da.GetSpare(item.id); if (sp.spare_group == null) { sp.spare_groupReference.Load(); } if (sp.brand == null) { sp.brandReference.Load(); } int BrandID = item.BrandID; int GroupID = item.GroupID; da.SpareDelete(item.id); SpareContainer.Instance.Remove(item.id); // проверить, не последняя ли это деталь в брэнде в данной группе if (cnt < 2) { da.SpareGroupDelete(BrandID, GroupID); } } //catch (Exception ex) { // this.Log(ex.Message); } }
private void BackgroundShowDetails_DoWork(object sender, DoWorkEventArgs e) { // DETAILED INFO IList selectedItems = e.Argument as IList; if (selectedItems.Count == 0) { DetailSpareInfo_Brand = ""; DetailSpareInfo_Group = ""; DetailSpareInfo_Name = ""; Detail_Incomes = null; Detail_Analogues = null; } else { SpareView selected = selectedItems[0] as SpareView; DetailSpareInfo_Brand = selected.BrandName; DetailSpareInfo_Name = selected.name; // построим путь по группам к запчасти // текущая группа DataAccess db = new DataAccess(); spare s = db.GetSpare(selected.id); string gp = s.spare_group.name; // родительская if (s.spare_group1 != null) { gp = s.spare_group1.name + "/" + gp; } // дедушка if (s.spare_group2 != null) { gp = s.spare_group2.name + "/" + gp; } // прадедушка if (s.spare_group3 != null) { gp = s.spare_group3.name + "/" + gp; } DetailSpareInfo_Group = gp; // INCOMES & ANALOGS WINDOWS // anlogues Detail_Analogues = db.GetAnalogues(selected.id); // incomes Detail_Incomes = db.GetIncomes(selected.id); foreach (SpareInSpareIncomeView i in Detail_Incomes) { decimal POutBasic = 0; decimal PInBasic = 0; if (!i.POutBasic.HasValue) { string IncomeCurrencyCode = i.CurrencyCode; decimal PIn = i.PIn.Value; POutBasic = CurrencyHelper.GetBasicPrice(IncomeCurrencyCode, PIn); } else { POutBasic = i.POutBasic.Value; } if (i.PInBasic.HasValue) { PInBasic = i.PInBasic.Value; } else { string IncomeCurrencyCode = i.CurrencyCode; decimal PIn = i.PIn.Value; PInBasic = CurrencyHelper.GetBasicPrice(IncomeCurrencyCode, PIn); } i.DF_PriceInCurrency = CurrencyHelper.GetPrice(currentCurrencyName, POutBasic); i.DF_PriceInCurrencyIn = CurrencyHelper.GetPrice(currentCurrencyName, PInBasic); string strDate = ""; if (i.SpareIncomeDate.Value.Day < 10) { strDate += "0"; } strDate += i.SpareIncomeDate.Value.Day + "."; if (i.SpareIncomeDate.Value.Month < 10) { strDate += "0"; } strDate += i.SpareIncomeDate.Value.Month + "."; strDate += i.SpareIncomeDate.Value.Year; i.DF_Date = strDate; } } }
public static string getRemains(string FilePath) { List <spare_analogue> items = new List <spare_analogue>(); string Message = ""; // Объявляем и забиваем файл в документ XmlDocument xd = new XmlDocument(); FileStream fs = new FileStream(FilePath, FileMode.Open); xd.Load(fs); DataAccess da = new DataAccess(); XmlNodeList list = xd.GetElementsByTagName("Row"); //int RemainsInputID = da.getRemainsInputID(); MessageBox.Show("Будет импортировано " + list.Count + " записей."); string m1 = ""; System.Globalization.CultureInfo ci = System.Globalization.CultureInfo.InstalledUICulture; System.Globalization.NumberFormatInfo ni = (System.Globalization.NumberFormatInfo) ci.NumberFormat.Clone(); ni.NumberDecimalSeparator = "."; for (int i = 0; i < list.Count; i++) { if (list[i].HasChildNodes) { decimal P = 0; if (decimal.TryParse(list[i].ChildNodes[4].InnerText, out P)) { P = decimal.Parse(list[i].ChildNodes[4].InnerText, ni); da = new DataAccess(); spare_in_spare_income offering = new spare_in_spare_income(); //[id] - генериурется автоматически //[num] offering.num = 0; //[description] offering.description = ""; //[QIn] decimal Q = 0; Q = decimal.Parse(list[i].ChildNodes[3].InnerText, ni); offering.QIn = Q; //[PIn] offering.PIn = P; //[PInBasic] offering.PInBasic = P; //[VatRateID] offering.vat_rate = da.getZeroVatRate(); //[Markup] offering.Markup = 0; //[SpareIncomeID] - в зависимости от поля #5 string WarehouseMarker = list[i].ChildNodes[5].InnerText; int SpareIncomeID = 61; if (WarehouseMarker.Contains("истина")) { SpareIncomeID = 61; } else { SpareIncomeID = 62; } offering.spare_income = da.SpareIncomeGet(SpareIncomeID); //[CurrencyID] offering.CurrencyID = 1; //[S] offering.S = Q * P; //[SBasic] offering.SBasic = Q * P; //[POut] offering.POut = P; //[POutBasic] offering.POutBasic = P; //[QRest] offering.QRest = Q; string mess = ""; //===================================================== [SpareID] string SpareCode1C = list[i].ChildNodes[0].InnerText; mess += "1C:[" + SpareCode1C + "] - "; // search by code1C spare sp = null; sp = da.GetSpare(SpareCode1C); string code = "X"; if (sp == null) { mess += "not found! "; // search by spare code code = list[i].ChildNodes[1].InnerText; mess += "CODE:[" + code + "] - "; sp = da.GetSpareByCode(code); } string name = "X"; if (sp == null) { mess += "not found! "; // search by spare name name = list[i].ChildNodes[2].InnerText; mess += "NAME:[" + name + "] - "; sp = da.GetSpare(name); } if (sp == null) { m1 += SpareCode1C + ", " + code + ", " + name + "\n"; } else { da.InOfferingCreate(offering, sp.id); } } } } MessageBox.Show(m1); // Закрываем поток fs.Close(); return(Message); }