//--- static void CreateInn() { XElement save = SaveClass.LoadSave(); XElement AddInn = save.Element("Inns"); string name; Console.WriteLine("Créer une auberge"); Console.WriteLine("Quel est le nom de votre auberge?"); name = Console.ReadLine(); int testing = 0; foreach (Inn i in ListInn) { if (name == i.Name) { Console.WriteLine("Erreur, une autre auberge porte ce nom"); Console.ReadKey(); testing = 1; } } if (testing == 0) { Inn inn1 = new Inn(name); ListInn.Add(inn1); XElement NewInn = new XElement("Inn", new XAttribute("ID", name), new XElement("Name", name), new XElement("Heroes", new XAttribute("ID", name))); AddInn.Add(NewInn); SaveClass.SaveFile(save); } }
///<summary> /// Метод конвертации xlsx по xml sheme FullInnCount.xsd /// <![CDATA[ /// <?xml version="1.0" encoding="UTF-8"?> ///<INNList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="FullInnCount.xsd"> /// <ListInn NumColection = "1" CountInn="4"> /// <MyInnn>d500306578530/503009784020/504601612560/772904428090</MyInnn> /// </ListInn> /// <ListInn NumColection = "2" CountInn="2"> /// <MyInnn>500303703461/775101147891/</MyInnn> /// </ListInn> /// <ListInn NumColection = "3" CountInn="3"> /// <MyInnn >500303703461/775101147891/772809074772</MyInnn> /// </ListInn> ///</INNList>]]> /// </summary> /// <param name="pathFilexlsx">Выбранный файл</param> /// <param name="listfile">Выбранный лист</param> /// <param name="letter">Буква в xlsx</param> /// <param name="numrow">Номер строки</param> /// <param name="countinn">Количество по сколько формируем списки</param> /// <param name="path">Путь сохранения</param> public void ConvertInnMassList(string pathFilexlsx, string listfile, string letter, int numrow, int countinn, string path) { var j = 1; //Количество в массиве var m = 0; //Номер коллекции var ws = ListXlsx(pathFilexlsx, listfile); var countcell = CountUseRow(ws, letter); var maxmassiv = Convert.ToInt32(Math.Ceiling(Convert.ToDecimal(countcell) / Convert.ToDecimal(countinn))); //расчет максимального массива округлить в большую сторону List <string> listinn = new List <string>(); var fullinn = new INNList() { ListInn = new ListInn[maxmassiv] }; for (int i = numrow; i <= countcell; i++) { listinn.Add(ws.Cell(letter + i).Value.ToString()); if ((j == countinn) || (i == countcell)) { ListInn list = new ListInn() { CountInn = j, NumColection = m, MyInnn = string.Join("/", listinn.ToArray()), CountInnSpecified = true, NumColectionSpecified = true }; fullinn.ListInn[m] = list; listinn.Clear(); m++; j = 0; } j++; } SerializerClassToXml(path, fullinn, typeof(INNList)); }
//--- static void DelInn(int i) { int compteur = 0; foreach (Inn I in ListInn) { compteur++; if (i == compteur) { SaveClass.DelInnSave(ListInn[compteur - 1].Name, ListInn); ListInn.RemoveAt(compteur - 1); break; } } }