Beispiel #1
0
        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));
        }
Beispiel #2
0
        //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;
            }
        }