static void Main(string[] args) // тесты генераторов { Console.WriteLine(GenParadigmCollection.ParadigmGenerator.GetInCorrectRegister("КОмПАНИЯ, ФонД", "компаНиями, фОндом")); GenParadigmCollection.ParadigmGenerator pg = new ParadigmGenerator(); List<GenParadigmCollection.ParadigmGenerator.Paradigm> ListParadigm = pg.GetAllDeclinationWithNumber_WithParam("синий", 2); List<string> List; while (1 == 1) { string r = Console.ReadLine(); Console.WriteLine(); //ListParadigm = pg.GetAllDeclinationWithNumber(r, 2); List = pg.GetDeclinationAdjectivesAndNoun("8-ой апелляционный арбитражный суд"); ListParadigm = pg.GetDeclinationAdjectivesAndNounWithDash_WithParam(r); List = pg.GetDeclinationAdjectivesAndNounWithDash("минюстиции"); //ListParadigm = pg.GetAllDeclinationCompanyName_WithParam(r); ListParadigm = pg.GetAllDeclinationCompanyName_WithParam("ТНГ-Групп"); ListParadigm = pg.GetAllDeclinationCompanyName_WithParam("ТНГ -Групп"); ListParadigm = pg.GetAllDeclinationCompanyName_WithParam("ТНГ- Групп"); ListParadigm = pg.GetAllDeclinationCompanyName_WithParam("ТНГ - Групп"); //ListParadigm = pg.GetDeclinationAdjectivesAndNoun_Plural(r, null); //ListParadigm = pg.GetAllDeclinationWithNumber(r, 2); //ListParadigm = pg.GetDeclinationAdjectivesAndNoun(r); foreach (GenParadigmCollection.ParadigmGenerator.Paradigm p in ListParadigm.OrderBy(b => b.number).ThenBy(b => b.case_w)) { Console.WriteLine(p.word + " " + p.case_w + " " + p.number); } Console.WriteLine("----------------"); } }
// тесты генераторов static void Main(string[] args) { /* List<ParadigmGenerator.Paradigm> lPars = GenParadigmCollection.ParadigmGenerator.GetDeclinationAdjective_WithParam("1ая"); lPars = GenParadigmCollection.ParadigmGenerator.GetDeclinationAdjective_WithParam("1-ая"); lPars = GenParadigmCollection.ParadigmGenerator.GetDeclinationAdjective_WithParam("1-я"); lPars = GenParadigmCollection.ParadigmGenerator.GetDeclinationAdjective_WithParam("1-й"); lPars = GenParadigmCollection.ParadigmGenerator.GetDeclinationAdjective_WithParam("1й"); lPars = GenParadigmCollection.ParadigmGenerator.GetDeclinationAdjective_WithParam("1-е"); lPars = GenParadigmCollection.ParadigmGenerator.GetDeclinationAdjective_WithParam("1е"); */ //Console.WriteLine(GenParadigmCollection.ParadigmGenerator.GetInCorrectRegister("КОмПАНИЯ, ФонД", "компаНиями, фОндом")); GenParadigmCollection.ParadigmGenerator pg = new ParadigmGenerator(ParadigmGenerator.EParadigmGeneratorMode.EModeGeoRussia); pg.GenMode = ParadigmGenerator.EParadigmGeneratorMode.EModeSecondName; List<GenParadigmCollection.ParadigmGenerator.Paradigm> ListParadigm; while (1 == 1) { string r = Console.ReadLine(); Console.WriteLine(); //ListParadigm = pg.GetAllDeclinationWithNumber(r, 2); ListParadigm = pg.GetDeclinationAdjectivesAndNounWithDash_WithParam(r); //ListParadigm = pg.GetAllDeclinationCompanyName_WithParam(r); //ListParadigm = pg.GetAllDeclinationCompanyName_WithParam("ТНГ-Групп"); //ListParadigm = pg.GetDeclinationAdjectivesAndNoun_Plural(r, null); //ListParadigm = pg.GetAllDeclinationWithNumber(r, 2); //ListParadigm = pg.GetDeclinationAdjectivesAndNoun(r); foreach (GenParadigmCollection.ParadigmGenerator.Paradigm p in ListParadigm.OrderBy(b => b.number).ThenBy(b => b.case_w)) { Console.WriteLine(p.word + " " + p.case_w + " " + p.number); } Console.WriteLine("----------------"); } }
static void Main(string[] args) { String connectionString = "Persist Security Info=False;Integrated Security=true;Initial Catalog=;server=server28"; SortedDictionary<int, String> dict = new SortedDictionary<int, string>(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); string queryString = "SELECT ID, Text1 from ItemList where Ind = \'сельское поселение\' and UP=55 and Text1 IS NOT NULL;"; SqlCommand command = new SqlCommand(queryString, conn); SqlDataReader reader = command.ExecuteReader(); Console.WriteLine("Read names from DB = ###"); int num = 0; while (reader.Read()) { dict.Add((int)reader[0], (String)reader[1]); num++; Console.Write("\r{0}", num); } reader.Close(); /////// queryString = "select ID from YugoReport_ImportReport515;"; command = new SqlCommand(queryString, conn); reader = command.ExecuteReader(); Console.WriteLine("\nRemove names from YugoReport_ImportReport515 = ###"); num = 0; while (reader.Read()) { if (dict.Remove((int)reader[0])) { num++; Console.Write("\r{0}", num); } } reader.Close(); /////// queryString = "select ID from YugoReport_ImportReport516;"; command = new SqlCommand(queryString, conn); reader = command.ExecuteReader(); Console.WriteLine("\nRemove names from YugoReport_ImportReport516 = ###"); num = 0; while (reader.Read()) { if (dict.Remove((int)reader[0])) { num++; Console.Write("\r{0}", num); } } reader.Close(); } /////////// String positivePattern = @"(во$)"; Regex reg = new Regex(positivePattern); SortedDictionary<int, String> result = new SortedDictionary<int, string>(); ParadigmGenerator gen = new ParadigmGenerator(); List<ParadigmGenerator.Paradigm> lpar; int id = 0; Console.WriteLine("\nProcessing..."); foreach (var item in dict) { id++; if (reg.IsMatch(item.Value)) { String res = reg.Replace(item.Value, "ва"); result.Add(item.Key, res); } else { lpar = gen.GetDeclinationAdjectivesAndNoun_WithParam(item.Value); result.Add(item.Key, lpar[0].word); } Console.Write("\r{0}", id); } using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); Console.WriteLine("\nWrite to DB"); id = 0; foreach (var dic in dict) { int id220 = 0; string comLine220 = "INSERT INTO Attrib220 (AttribValue, IdItem, Ru, IsCleanName) VALUES (" + /*id220.ToString() + */ "\'" + dic.Value + "\', " + dic.Key.ToString() + ", " + "1, 1);"; SqlCommand cmd220 = new SqlCommand(comLine220); cmd220.Connection = conn; cmd220.ExecuteNonQuery(); String getNewId = "select ID from Attrib220 where AttribValue = \'" + dic.Value + "\' AND IdItem = " + dic.Key.ToString() + ";"; SqlCommand findId = new SqlCommand(getNewId, conn); SqlDataReader readNewId = findId.ExecuteReader(); if (readNewId.Read()) { id220 = (int)readNewId[0]; } else { Console.WriteLine("Baaad :("); } readNewId.Close(); String attrVal222; result.TryGetValue(dic.Key, out attrVal222); string comLine222 = "INSERT INTO Attrib222 (AttribValue, Attr220, CaseR) VALUES (" + /*id222.ToString() + */ "\'" + attrVal222 + "\', " + id220.ToString() + ", " + "1);"; SqlCommand cmd222 = new SqlCommand(comLine222); cmd222.Connection = conn; cmd222.ExecuteNonQuery(); id++; Console.Write("\r{0}", id); } /* string comLine = "INSERT INTO YugoReport_Omonim_Stem (id, idItem, descriptor, omonim, omonIdItem, language) VALUES (" + id.ToString() + ", " + curRec.idItem + ", " + quote + desc.ToString() + quote + ", " + quote + omon.ToString() + quote + ", " + curRec.idItemOmon + ", " + (int)curRec.omonLanguage + ");"; try { cmd.CommandText = comLine; cmd.ExecuteNonQuery(); Console.Write("\r{0}", id); } catch (Exception ex) { Console.WriteLine("\nERROR: Can't write to DB. Exception = {0}", ex.ToString()); } */ } Console.ReadLine(); }