Esempio n. 1
0
        public InstResultMasterWrapperVM(InstrumentBaseViewModel instBaseVM, ResultMasterInfo resultMasterInfo)
        {
            this.InstBaseVM_         = instBaseVM;
            this.ParameterExistFlag_ = true;

            this.ResultMasterInfo_ = resultMasterInfo;

            this.KRCode_        = resultMasterInfo.KRCode_;
            this.InstName_      = resultMasterInfo.InstName_;
            this.InstCode_      = resultMasterInfo.InstCode_;
            this.CalValue_      = resultMasterInfo.CalValue_;
            this.CalUnitValue_  = resultMasterInfo.CalUnitValue_;
            this.ReferenceDate_ = resultMasterInfo.ReferenceDate_;
            this.FileName_      = resultMasterInfo.FileName_;
            this.InstType_      = resultMasterInfo.InstType_;
            this.ResultType_    = resultMasterInfo.ResultType_;
        }
        public InstResultMasterWrapperVM(InstrumentBaseViewModel instBaseVM,ResultMasterInfo resultMasterInfo)
        {
            this.InstBaseVM_ = instBaseVM;
            this.ParameterExistFlag_ = true;

            this.ResultMasterInfo_ = resultMasterInfo;

            this.KRCode_ = resultMasterInfo.KRCode_;
            this.InstName_ = resultMasterInfo.InstName_;
            this.InstCode_ = resultMasterInfo.InstCode_;
            this.CalValue_ = resultMasterInfo.CalValue_;
            this.CalUnitValue_ = resultMasterInfo.CalUnitValue_;
            this.ReferenceDate_ = resultMasterInfo.ReferenceDate_;
            this.FileName_ = resultMasterInfo.FileName_;
            this.InstType_ = resultMasterInfo.InstType_;
            this.ResultType_ = resultMasterInfo.ResultType_;

        }
        public List<ResultMasterInfo> loadResultData()
        {
            DataTable tb = new DataTable();

            using (SqlCeConnection connection = new SqlCeConnection("Data Source=D:\\Project File\\OTCDerivativesCalculatorModule\\Project_CSharp\\RiskMonitor\\Data\\Data_Interface\\MarketDataBase.sdf"))
            using (SqlCeCommand command = connection.CreateCommand())
            {

                command.CommandText = "SELECT KR_CODE , INST_NAME , INST_CODE , CAL_VALUE , " +
                                            " CAL_UNIT_VALUE , REFERENCE_DATE , CALCULATE_DATE , " +
                                            " FILE_NAME , INST_TYPE , RESULT_TYPE FROM RESULTMASTER";
                                        

                connection.Open();
                SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection);

                dataAdapter.Fill(tb);
            }

            List<ResultMasterInfo> resultList = new List<ResultMasterInfo>();

            DataLoader loader = new DataLoader();

            DataRow[] resultRows = tb.Select();

            foreach (DataRow item in resultRows)
	        {
                ResultMasterInfo resultData = new ResultMasterInfo(item["KR_CODE"].ToString(),
                                                 item["INST_NAME"].ToString(),
                                                 item["INST_CODE"].ToString(),
                                                 item["CAL_VALUE"].ToString(),
                                                 item["CAL_UNIT_VALUE"].ToString(),
                                                 item["REFERENCE_DATE"].ToString(),
                                                 item["CALCULATE_DATE"].ToString(),
                                                 item["FILE_NAME"].ToString(),
                                                 item["INST_TYPE"].ToString(),
                                                 item["RESULT_TYPE"].ToString()
                                                 );
                resultList.Add(resultData);

	        }

            return resultList;
        }
Esempio n. 4
0
        public List <ResultMasterInfo> loadResultData()
        {
            DataTable tb = new DataTable();

            using (SqlCeConnection connection = new SqlCeConnection("Data Source=D:\\Project File\\OTCDerivativesCalculatorModule\\Project_CSharp\\RiskMonitor\\Data\\Data_Interface\\MarketDataBase.sdf"))
                using (SqlCeCommand command = connection.CreateCommand())
                {
                    command.CommandText = "SELECT KR_CODE , INST_NAME , INST_CODE , CAL_VALUE , " +
                                          " CAL_UNIT_VALUE , REFERENCE_DATE , CALCULATE_DATE , " +
                                          " FILE_NAME , INST_TYPE , RESULT_TYPE FROM RESULTMASTER";


                    connection.Open();
                    SqlCeDataAdapter dataAdapter = new SqlCeDataAdapter(command.CommandText, connection);

                    dataAdapter.Fill(tb);
                }

            List <ResultMasterInfo> resultList = new List <ResultMasterInfo>();

            DataLoader loader = new DataLoader();

            DataRow[] resultRows = tb.Select();

            foreach (DataRow item in resultRows)
            {
                ResultMasterInfo resultData = new ResultMasterInfo(item["KR_CODE"].ToString(),
                                                                   item["INST_NAME"].ToString(),
                                                                   item["INST_CODE"].ToString(),
                                                                   item["CAL_VALUE"].ToString(),
                                                                   item["CAL_UNIT_VALUE"].ToString(),
                                                                   item["REFERENCE_DATE"].ToString(),
                                                                   item["CALCULATE_DATE"].ToString(),
                                                                   item["FILE_NAME"].ToString(),
                                                                   item["INST_TYPE"].ToString(),
                                                                   item["RESULT_TYPE"].ToString()
                                                                   );
                resultList.Add(resultData);
            }

            return(resultList);
        }