private void btnNext_Click(object sender, RoutedEventArgs e) { Stage++; if (Stage == 1) { dgSpares.IsEnabled = true; btnNext.Content = "Сохранить"; } else if (Stage == 2) { foreach (SpareInSpareIncomeView sisi in offerings) { //sisi.SpareName //sisi.BrandName //sisi.SpareCode //sisi.SpareCodeShatem DataAccess db = new DataAccess(); int SpareID = sisi.SpareID.Value; db.InOfferingCreate(sisi.SpareID.Value, sisi.QIn, sisi.PIn.Value, sisi.Markup, sisi.POut.Value, sisi.S.Value, sisi.SpareIncomeID.Value); SpareContainer.Instance.Update(SpareID); } Close(); } }
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; }