public void thisBookLoad() { this.DAO_ = new clsMAST_BOOKINFO_TB(); this.DAO_.BOOK_CD = this.bookCode_; this.DAO_.SelectOwn(); }
public static FinanceBook CreateBookFromUI(string bookName) { clsMAST_BOOKINFO_TB clstb = new clsMAST_BOOKINFO_TB(); clstb.BOOK_NM = bookName; clstb.SelectOwn(); FinanceBook fb = new FinanceBook(clstb.BOOK_CD); fb.thisBookLoad(); fb.childBookLoad(); return fb; }
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); } }
public clsMAST_BOOKINFO_TB Clone() { try { clsMAST_BOOKINFO_TB cloneTB = new clsMAST_BOOKINFO_TB(); cloneTB._BOOK_CD = this._BOOK_CD; cloneTB._BOOK_NM = this._BOOK_NM; cloneTB._PARENT_BOOK_CD = this._PARENT_BOOK_CD; cloneTB._OPEN_DT = this._OPEN_DT; cloneTB._CLOSE_DT = this._CLOSE_DT; cloneTB._DESCRIPTION = this._DESCRIPTION; return cloneTB; } catch(Exception ex) { throw new Exception(ex.Message); } }
public static clsMAST_BOOKINFO_TB Create(DataRow dr) { try { clsMAST_BOOKINFO_TB tb = new clsMAST_BOOKINFO_TB(); tb._BOOK_CD = Convert.ToString(dr[0]); tb._BOOK_NM = Convert.ToString(dr[1]); tb._PARENT_BOOK_CD = Convert.ToString(dr[2]); tb._OPEN_DT = Convert.ToString(dr[3]); tb._CLOSE_DT = Convert.ToString(dr[4]); tb._DESCRIPTION = Convert.ToString(dr[5]); return tb; } catch(Exception ex) { throw new Exception(ex.Message); } }
public IBook addChildBook(string book_cd,DateTime bookOpenDate,DateTime bookCloseDate) { IBook book = new IBook(book_cd); this.ChildBookList_.Add(book); clsMAST_BOOKINFO_TB tb = new clsMAST_BOOKINFO_TB(); tb.BOOK_CD = book_cd; tb.BOOK_NM = "NewBook"; tb.PARENT_BOOK_CD = this.bookCode_; tb.OPEN_DT = bookOpenDate.ToString("yyyyMMdd"); tb.CLOSE_DT = bookCloseDate.ToString("yyyyMMdd"); tb.DESCRIPTION = "NewBook"; tb.Insert(); book.DAO_ = tb; // Default KRW Cash 넣어놈. CurrencyCash.CurrencyCashBooking("KRW",book_cd, bookOpenDate); return book; }
public static void GetAllBookList(List<IBook> books) { clsMAST_BOOKINFO_TB clstb = new clsMAST_BOOKINFO_TB(); clstb.PARENT_BOOK_CD = "ANCESTOR"; clstb.SelectOwn(); string rootbookcd = clstb.BOOK_CD; if (rootbookcd != null) { IBook b = IBook.CreateBook(rootbookcd); b.getAllSubBook(books); } else { clstb.BOOK_CD = "ROOTBOOK"; clstb.BOOK_NM = "NewRootBook"; clstb.PARENT_BOOK_CD = "ANCESTOR"; clstb.OPEN_DT = DateTime.Now.ToString("yyyyMMdd"); clstb.CLOSE_DT = "20991231"; clstb.Insert(); books.Add(IBook.CreateBook("ROOTBOOK")); } }
// 북을 아예 날림. 가지고 있는 포지션은 그냥 놔둠. ( 나중에 살릴수도 있으니.. ) public void removeThisBook(IBook book) { clsMAST_BOOKINFO_TB tb = new clsMAST_BOOKINFO_TB(); tb.BOOK_CD = this.bookCode_; tb.DeleteBookCD(); }
// 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 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 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 static void install_db_initialize() { HITM_CALENDAR_TB calendar_tb = new HITM_CALENDAR_TB(); clsHITM_CALENDAR_TB.TableClear(); calendar_tb.buildTestData(); clsMAST_BOOKINFO_TB book_tb = new clsMAST_BOOKINFO_TB(); book_tb.BOOK_CD = "ROOTBOOK"; book_tb.BOOK_NM = "RootBook"; book_tb.PARENT_BOOK_CD = "ANCESTOR"; book_tb.OPEN_DT = DateTime.Now.ToString("yyyyMMdd"); book_tb.CLOSE_DT = "20991231"; book_tb.DESCRIPTION = ""; book_tb.Insert(); // ---------------------------------------------------- clsSET_SCENARIO_TB clstb_scenrio = new clsSET_SCENARIO_TB(); clstb_scenrio.FP_MASTER_TYP = 9999; clstb_scenrio.SCENARIO_CD = "DEFAULT_PARALLEL"; clstb_scenrio.CURVE_CD = "ALL"; clstb_scenrio.PARALLEL_SHIFT_UNIT = 1.0; clstb_scenrio.HUMP_SHIFT_UNIT = 0.0; clstb_scenrio.HUMP_CENTER_T = 0.0; clstb_scenrio.STEEPEN_SHIFT_UNIT = 0.0; clstb_scenrio.STEEPEN_CENTER_T = 0.0; clstb_scenrio.Insert(); clstb_scenrio.FP_MASTER_TYP = 2800; clstb_scenrio.SCENARIO_CD = "TEST_SC01"; clstb_scenrio.CURVE_CD = "IRSKRW"; clstb_scenrio.PARALLEL_SHIFT_UNIT = 1.0; clstb_scenrio.HUMP_SHIFT_UNIT = 0.0; clstb_scenrio.HUMP_CENTER_T = 0.0; clstb_scenrio.STEEPEN_SHIFT_UNIT = 0.1; clstb_scenrio.STEEPEN_CENTER_T = 3; clstb_scenrio.Insert(); clstb_scenrio.FP_MASTER_TYP = 2800; clstb_scenrio.SCENARIO_CD = "TEST_SC02"; clstb_scenrio.CURVE_CD = "IRSKRW"; clstb_scenrio.PARALLEL_SHIFT_UNIT = 0.5; clstb_scenrio.HUMP_SHIFT_UNIT = 0.0; clstb_scenrio.HUMP_CENTER_T = 0.0; clstb_scenrio.STEEPEN_SHIFT_UNIT = 0.3; clstb_scenrio.STEEPEN_CENTER_T = 3; clstb_scenrio.Insert(); }
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); } }