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); } }
// 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; }
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(); } }
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); } }