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