Welcome, guest! Login / Register - Why register?
Psst.. new poll here.
Psst.. new forums here.
Microsoft is blocking us again (TY IP Reputation!) so just use oauth login instead. :)

Paste

Pasted as C# by Volgruk ( 15 years ago )
List<string[]> rec1 = DataBaseManager.GetRecords(DataBaseManager.GetLibCatDBConnect(), "select f001 from marc_rec where IDR='" + edition.ID + "'");
      if(rec1.Count < 1) return;
      List<object[]> jyears = DataBaseManager.ExecuteQueryToLibCat("linkm=\"" + rec1[0][0] + "\""); // год журнала
      foreach(object[] jy in jyears)
      {
       List<string[]> rec2 = DataBaseManager.GetRecords(DataBaseManager.GetLibCatDBConnect(), "select f001 from marc_rec where IDR='" + edition.ID + "'");
       if(rec2.Count < 1) return;
       List<object[]> junits = DataBaseManager.ExecuteQueryToLibCat("linkm=\"" + rec2[0][0] + "\""); // номер журнала 
       foreach(object[] ju in junits)
       {
        List<string[]> juinvnumbers = DataBaseManager.GetRecords(DataBaseManager.GetLibCatDBConnect(true), "select TOKEN from VI_INVN where IDR='" + ju[0].ToString() + "'");
        foreach(string[] juin in juinvnumbers)
        {
         edition.Shifr.Add(juin[0].ToString());
        }
       }
      }

 

Revise this Paste

Your Name: Code Language: