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