Beispiel #1
0
        public void childBookLoad()
        {
            this.ChildBookList_.Clear();

            clsMAST_BOOKINFO_TB clstb = new clsMAST_BOOKINFO_TB();

            clstb.PARENT_BOOK_CD = this.bookCode_;

            DataTable dt = clstb.Select();

            foreach (DataRow dr in dt.Select())
            {
                clsMAST_BOOKINFO_TB tb = clsMAST_BOOKINFO_TB.Create(dr);

                IBook book = IBook.CreateBook(tb.BOOK_CD);

                this.ChildBookList_.Add(book);


            }
        }
Beispiel #2
0
        // 12 자리 -- B1234567890A // B (1) // 150528 (6) MakeDate // 0001 (4) Order // 9 (1) Etc
        public static string getNewBookCD()
        {
            string bookID = "B";
            string dateStr = DateTime.Now.ToString("yyyyMMdd").Substring(2, 6);

            bookID += dateStr;

            clsMAST_BOOKINFO_TB clstb = new clsMAST_BOOKINFO_TB();

            DataTable dt = clstb.Select();

            List<string> list = new List<string>();

            foreach (DataRow dr in dt.Select())
            {
                string bookcd = clsMAST_BOOKINFO_TB.Create(dr).BOOK_CD;
                
                if (bookcd.Length == 12)
                { 
                    list.Add(bookcd.Substring(1, 10)); 
                }

            }

            List<int> result = 
                (from str in list where str.Substring(0,6) == dateStr
                 orderby Convert.ToInt32(str) 
                     select Convert.ToInt32(str) ).ToList<int>();

            int max = (result.Count == 0) ? -1 : result.Count;

            bookID += getLetter((max + 1), 4);

            bookID += "9";

            return bookID;
        }
Beispiel #3
0
        private void build_cashMaster()
        { 
            #region Build Base Cash Master
            
            // cash를 만듬 -----------------------------------------------------------
            clsMAST_BOOKINFO_TB clstb_bookinfo = new clsMAST_BOOKINFO_TB();
            // krw 없는 booklist를 에다가 krw를 넣음

            DataTable noKRWCash_dt = clstb_bookinfo.SelectBookNoKRWCash();

            foreach (DataRow dr in noKRWCash_dt.Select() )
            {
                CurrencyCash cash_fi = 
                    CurrencyCash.CurrencyCashBooking("KRW",clsMAST_BOOKINFO_TB.Create(dr).BOOK_CD,this.ReferenceDate_);

                //cash_fi.build_cashPosition(this.ReferenceDate_);
            }

            DataTable totalBook_dt = clstb_bookinfo.Select();

            // 각각의 북마다 krw를 제외한 Currency 를 뜸
            clsHITM_CASH_INSTOCK_TB clstb_cash = new clsHITM_CASH_INSTOCK_TB();
            clsMAST_FP_INSTRUMENT_TB clstb_master = new clsMAST_FP_INSTRUMENT_TB();

            foreach (DataRow dr in totalBook_dt.Select())
            {
                string book_cd = clsMAST_BOOKINFO_TB.Create(dr).BOOK_CD;

                // book별 cash list
                foreach ( DataRow dr2 in clstb_cash.SelectCashesInEachBook(book_cd).Select() )
                {
                    string currency = clsHITM_CASH_INSTOCK_TB.Create(dr2).CURR;

                    if (clstb_master.SelectHasCurrency(currency, book_cd).Rows.Count == 0)
                    {
                        if (currency != "KRW")
                        { 
                            CurrencyCash cash_fi = 
                                CurrencyCash.CurrencyCashBooking(currency, clsMAST_BOOKINFO_TB.Create(dr).BOOK_CD, this.ReferenceDate_);
                        } 

                        //cash_fi.build_cashPosition(this.ReferenceDate_);

                    }

                }
                
            }

            #endregion

            // if 오늘 부킹댄거면 position , emptyGreekResult 만듬.
            clstb_master.FP_MASTER_TYP = (int)clsMAST_FP_INSTRUMENT_TB.FP_MASTER_TYP_Type.Money_Cash;
            clstb_master.BOOKED_DT = this.ReferenceDate_.ToString("yyyyMMdd");

            DataTable cash_dt = clstb_master.Select();

            foreach (DataRow dr in cash_dt.Select())
            {
                clsMAST_FP_INSTRUMENT_TB tb = clsMAST_FP_INSTRUMENT_TB.Create(dr);
                CurrencyCash cash_fi = (CurrencyCash)Financial_instrument.CreateInstrument(tb);
                cash_fi.build_cashPosition(this.ReferenceDate_);
                //cash_fi.build_emptyResult(this.ReferenceDate_);
            }

        }
        private void AddBook_Click(object sender, RoutedEventArgs e)
        {
            IBook selectedBook = this.bookTreeView_.SelectedItem as IBook;

            if (selectedBook != null)
            {
                clsMAST_BOOKINFO_TB clstb = new clsMAST_BOOKINFO_TB();

                clstb.Select();

                // 기존의 북 코드와 곂치치 않아야함.

                string bookCD = IDGenerator.getNewBookCD();

                IBook addedBook = selectedBook.addChildBook(bookCD, this.ReferenceDate_, new DateTime(2099, 12, 31));

                //this.bookTreeView_.Items.Refresh();

            }
        }
Beispiel #5
0
        private void _BookListDropDown_Initialize()
        {
            this.BookListDropDown.Items.Clear();
                        
            clsMAST_BOOKINFO_TB clstb = new clsMAST_BOOKINFO_TB();

            // 현재는 다 가지고 옴 나중에는 날짜 해서 가져오면댐.
            DataTable tb = clstb.Select();

            foreach (DataRow dr in tb.Select())
            {
                clsMAST_BOOKINFO_TB selectedrowtb = clsMAST_BOOKINFO_TB.Create(dr);

                RibbonDropDownItem item = Factory.CreateRibbonDropDownItem();
                item.Label = selectedrowtb.BOOK_NM;

                this.BookListDropDown.Items.Add(item);
            }

        }