internal bool IsIssued()
{
DBBook dbb = new DBBook();
IEnumerable <BJRecord> iddata = from BJRecord x in BookRecord
where x.SORT == this.BAR && x.MNFIELD == 899 && x.MSFIELD == "$w"
select x;
return(dbb.IsIssued(iddata.ToList()[0].IDDATA, this.FUND));
}
internal bool IsIssued()
{
DBBook dbb = new DBBook();
IEnumerable<BJACCRecord> iddata = from BJACCRecord x in BookRecord
where x.SORT == this.BAR && x.MNFIELD == 899 && x.MSFIELD == "$w"
select x;
return dbb.IsIssued(iddata.ToList()[0].IDDATA);
}
public BookVO(string BAR)
{
DBBook dbb = new DBBook();
this.BookRecord = dbb.GetBookByBAR(BAR);
this.BAR = BAR;
this.IDMAIN = BookRecord[0].IDMAIN;
IEnumerable<BJACCRecord> iddata = from BJACCRecord x in BookRecord
where x.SORT == this.BAR && x.MNFIELD == 899 && x.MSFIELD == "$w"
select x;
this.IDDATA = iddata.ToList()[0].IDDATA;
var title = from BJACCRecord x in BookRecord
where x.MNFIELD == 200 && x.MSFIELD == "$a"
select x;
this.TITLE = title.ToList()[0].PLAIN;
if (title.Count() == 0)
{
this.TITLE = "";
}
else
{
this.TITLE = title.ToList()[0].PLAIN;
}
var author = from BJACCRecord x in BookRecord
where x.MNFIELD == 700 && x.MSFIELD == "$a"
select x;
if (author.Count() == 0)
{
this.AUTHOR = "";
}
else
{
this.AUTHOR = author.ToList()[0].PLAIN;
}
this.IDISSUED = dbb.GetIDISSUED(this.IDDATA);
}
//public BookVO(int IDMAIN, Bases fund)
//{
// DBBook dbb = new DBBook();
// this.BookRecord = dbb.GetBookByIDMAIN(IDMAIN, fund);
// this.IDMAIN = BookRecord[0].IDMAIN;
//}
public BookVO(string BAR)
{
DBBook dbb = new DBBook();
this.BookRecord = dbb.GetBookByBAR(BAR);
if (BookRecord[0].Fund == Bases.BJSCC)
{
this.FUND = Bases.BJSCC;
}
else
{
this.FUND = Bases.BJVVV;
}
this.BAR = BAR;
this.IDMAIN = BookRecord[0].IDMAIN;
IEnumerable <BJRecord> iddata = from BJRecord x in BookRecord
where x.SORT == this.BAR && x.MNFIELD == 899 && x.MSFIELD == "$w"
select x;
this.IDDATA = iddata.ToList()[0].IDDATA;
var title = from BJRecord x in BookRecord
where x.MNFIELD == 200 && x.MSFIELD == "$a"
select x;
this.TITLE = title.ToList()[0].PLAIN;
if (title.Count() == 0)
{
this.TITLE = "";
}
else
{
this.TITLE = title.ToList()[0].PLAIN;
}
var author = from BJRecord x in BookRecord
where x.MNFIELD == 700 && x.MSFIELD == "$a"
select x;
if (author.Count() == 0)
{
this.AUTHOR = "";
}
else
{
this.AUTHOR = author.ToList()[0].PLAIN;
}
this.IDISSUED = dbb.GetIDISSUED(this.IDDATA, this.FUND);
iddata = from BJRecord x in BookRecord
where x.IDDATA == this.IDDATA && x.MNFIELD == 899 && x.MSFIELD == "$b"
select x;
if (iddata.Count() == 0)//поле 899b не заполнено.
{
this.F899b = "<нет>";
}
else
{
this.F899b = iddata.ToList()[0].PLAIN;
this.F899b_Id = iddata.ToList()[0].IDINLIST;
}
//метонахождение
iddata = from BJRecord x in BookRecord
where x.IDDATA == this.IDDATA && x.MNFIELD == 899 && x.MSFIELD == "$a"
select x;
if (iddata.Count() == 0)//поле 899a не заполнено.
{
this.F899a = "<нет>";
}
else
{
this.F899a = iddata.ToList()[0].PLAIN;
this.F899a_Id = iddata.ToList()[0].IDINLIST;
}
}
public BookVO(int IDMAIN)
{
DBBook dbb = new DBBook();
this.BookRecord = dbb.GetBookByIDMAIN(IDMAIN);
this.IDMAIN = BookRecord[0].IDMAIN;
}