//private void button1_Click(object sender, RibbonControlEventArgs e) //{ // //PositionMasterView view = new PositionMasterView(); // ////view.ViewModel_. = InstPositionWapperVM_; // //Window w = new Window(); // //w.Content = view; // //w.Visibility = 0; // //DataBaseManager dbManager = new DataBaseManager(); // //List<string> fieldName = new List<string>(); // //List<string> fieldValue = new List<string>(); // //fieldName.Add("KRCODE"); // //fieldName.Add("NAME"); // //fieldValue.Add("KR000000001"); // //fieldValue.Add("ELS1011"); // //dbManager.addInstDB("MasterInfo", fieldName, fieldValue); //} private PositionBookingInfoVM readPositionInfoFromExcel() { Excel.Application xl_app = (Microsoft.Office.Interop.Excel.Application)System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application"); Excel.Workbook xl_workbook = null; xl_workbook = xl_app.ActiveWorkbook; Excel.Worksheet sheet = null; sheet = (Excel.Worksheet)xl_workbook.Worksheets.get_Item(1); //check book valid //Excel.Range newFirstRow = sheet.get_Range("TestName"); //newFirstRow.Value2 = "OK"; string itemcode = Convert.ToString(sheet.get_Range("itemcode").Value2); string krcode = Convert.ToString(sheet.get_Range("krcode").Value2); string teamcode = Convert.ToString(sheet.get_Range("teamcode").Value2); string fundcode = Convert.ToString(sheet.get_Range("fundcode").Value2); string bookID = Convert.ToString(sheet.get_Range("bookID").Value2); string excelType = Convert.ToString(sheet.get_Range("excelType").Value2); string productType = Convert.ToString(sheet.get_Range("productType").Value2); string groupID = Convert.ToString(sheet.get_Range("groupID").Value2); string groupState = Convert.ToString(sheet.get_Range("groupState").Value2); string itemname = Convert.ToString(sheet.get_Range("itemname").Value2); string shortName = Convert.ToString(sheet.get_Range("shortName").Value2); string issueDate = Convert.ToString(sheet.get_Range("issueDate").Value2); string maturityDate = Convert.ToString(sheet.get_Range("maturityDate").Value2); string underlying = Convert.ToString(sheet.get_Range("underlying").Value2); string counterParty = Convert.ToString(sheet.get_Range("counterParty").Value2); string contractType = Convert.ToString(sheet.get_Range("contractType").Value2); string notional = Convert.ToString(sheet.get_Range("notional").Value2); string currency = Convert.ToString(sheet.get_Range("currency").Value2); string bookedOrder = Convert.ToString(sheet.get_Range("bookedOrder").Value2); string bookingState = Convert.ToString(sheet.get_Range("bookingState").Value2); string bookingDate = Convert.ToString(sheet.get_Range("bookingDate").Value2); PositionBookingInfoVM vm = new PositionBookingInfoVM(itemcode, krcode, teamcode, fundcode, bookID, excelType, productType, groupID, groupState, itemname, shortName, issueDate, maturityDate, underlying, counterParty, contractType, notional, currency, bookedOrder, bookingState, bookingDate); return vm; //엑셀에서 로드해 갔고 InstPositionWapperVM_ 에 다가 박음 }
public ObservableCollection<PositionBookingInfoVM> loadPositionBookingInfoVM() { DataTable tb = new DataTable(); using (SqlCeConnection connection = new SqlCeConnection(@"Data Source=D:\Project File\OTCDerivativesCalculatorModule\ExcelOTCManagerAddIn\PositionMasterInformationDB.sdf")) using (SqlCeCommand command = connection.CreateCommand()) { command.CommandText = "SELECT " + "ITEMCODE,"+ "KRCODE,"+ "TEAMCODE,"+ "FUNDCODE,"+ "BOOKID,"+ "EXCELTYPE,"+ "PRODUCTTYPE,"+ "GROUPID,"+ "GROUPSTATE,"+ "ITEMNAME,"+ "SHORTNAME,"+ "ISSUEDATE,"+ "MATURITYDATE,"+ "UNDERLYING,"+ "COUNTERPARTY,"+ "CONTRACTTYPE,"+ "NOTIONAL,"+ "CURRENCY,"+ "BOOKEDORDER,"+ "BOOKINGSTATE,"+ "BOOKINGDATE "+ "FROM MASTERINFO"; connection.Open(); SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection); dataAdapter.Fill(tb); } ObservableCollection<PositionBookingInfoVM> vmList = new ObservableCollection<PositionBookingInfoVM>(); DataLoader loader = new DataLoader(); DataRow[] resultRows = tb.Select(); foreach (DataRow item in resultRows) { PositionBookingInfoVM positionData = new PositionBookingInfoVM(item["ITEMCODE"].ToString(), item["KRCODE"].ToString(), item["TEAMCODE"].ToString(), item["FUNDCODE"].ToString(), item["BOOKID"].ToString(), item["EXCELTYPE"].ToString(), item["PRODUCTTYPE"].ToString(), item["GROUPID"].ToString(), item["GROUPSTATE"].ToString(), item["ITEMNAME"].ToString(), item["SHORTNAME"].ToString(), item["ISSUEDATE"].ToString(), item["MATURITYDATE"].ToString(), item["UNDERLYING"].ToString(), item["COUNTERPARTY"].ToString(), item["CONTRACTTYPE"].ToString(), item["NOTIONAL"].ToString(), item["CURRENCY"].ToString(), item["BOOKEDORDER"].ToString(), item["BOOKINGSTATE"].ToString(), item["BOOKINGDATE"].ToString()); vmList.Add(positionData); } return vmList; }
public ObservableCollection <PositionBookingInfoVM> loadPositionBookingInfoVM() { DataTable tb = new DataTable(); using (SqlCeConnection connection = new SqlCeConnection(@"Data Source=D:\Project File\OTCDerivativesCalculatorModule\ExcelOTCManagerAddIn\PositionMasterInformationDB.sdf")) using (SqlCeCommand command = connection.CreateCommand()) { command.CommandText = "SELECT " + "ITEMCODE," + "KRCODE," + "TEAMCODE," + "FUNDCODE," + "BOOKID," + "EXCELTYPE," + "PRODUCTTYPE," + "GROUPID," + "GROUPSTATE," + "ITEMNAME," + "SHORTNAME," + "ISSUEDATE," + "MATURITYDATE," + "UNDERLYING," + "COUNTERPARTY," + "CONTRACTTYPE," + "NOTIONAL," + "CURRENCY," + "BOOKEDORDER," + "BOOKINGSTATE," + "BOOKINGDATE " + "FROM MASTERINFO"; connection.Open(); SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection); dataAdapter.Fill(tb); } ObservableCollection <PositionBookingInfoVM> vmList = new ObservableCollection <PositionBookingInfoVM>(); DataLoader loader = new DataLoader(); DataRow[] resultRows = tb.Select(); foreach (DataRow item in resultRows) { PositionBookingInfoVM positionData = new PositionBookingInfoVM(item["ITEMCODE"].ToString(), item["KRCODE"].ToString(), item["TEAMCODE"].ToString(), item["FUNDCODE"].ToString(), item["BOOKID"].ToString(), item["EXCELTYPE"].ToString(), item["PRODUCTTYPE"].ToString(), item["GROUPID"].ToString(), item["GROUPSTATE"].ToString(), item["ITEMNAME"].ToString(), item["SHORTNAME"].ToString(), item["ISSUEDATE"].ToString(), item["MATURITYDATE"].ToString(), item["UNDERLYING"].ToString(), item["COUNTERPARTY"].ToString(), item["CONTRACTTYPE"].ToString(), item["NOTIONAL"].ToString(), item["CURRENCY"].ToString(), item["BOOKEDORDER"].ToString(), item["BOOKINGSTATE"].ToString(), item["BOOKINGDATE"].ToString()); vmList.Add(positionData); } return(vmList); }