コード例 #1
0
ファイル: FundPriceETL.cs プロジェクト: minikie/test
        public void FundData(DateTime refDate)
        {
            string refDateStr = refDate.ToString("yyyyMMdd");
            //string fileName = @"D:\data_etl\FP_" + refDateStr + ".TXT";
            string fileName = @"C:\batch\FP_" + refDateStr + ".TXT";

            /* Download a File */
            this.FtpConnector_.download("/FP_" + refDateStr + ".TXT", fileName);

            DataSet ds = TextToDataSet.Convert(fileName, "testTB", "|");
            
            // db 에 올림.
            clsHDAT_INSR_FUNDPRICE_INFO_TB clstb = new clsHDAT_INSR_FUNDPRICE_INFO_TB();

            clstb.REF_DT = refDateStr;
            clstb.DeleteDate();

            foreach (DataRow dr in ds.Tables[0].Select())
            {
                clstb.REF_DT = dr[0].ToString().Trim();
                clstb.FUND_CD =  dr[1].ToString().Trim();
                clstb.FUND_NM = dr[2].ToString().Trim();
                clstb.FUND_PRICE = Convert.ToDouble(dr[3].ToString().Trim());
                clstb.ACC_UNIT = Convert.ToInt64(dr[4].ToString().Trim());
                clstb.INFLOW_UNIT = Convert.ToInt64(dr[5].ToString().Trim());
                clstb.OUTFLOW_UNIT = Convert.ToInt64(dr[6].ToString().Trim());
                clstb.TOTAL_AMT = Convert.ToInt64(dr[7].ToString().Trim());
                clstb.STOCK_AMT = Convert.ToInt64(dr[8].ToString().Trim());
                clstb.BOND_AMT = Convert.ToInt64(dr[8].ToString().Trim());

                clstb.Insert();
            }

            clstb.Insert();

        }
コード例 #2
0
		public clsHDAT_INSR_FUNDPRICE_INFO_TB Clone()
		{
			try
			{
				clsHDAT_INSR_FUNDPRICE_INFO_TB cloneTB = new clsHDAT_INSR_FUNDPRICE_INFO_TB();
				
				
				cloneTB._REF_DT = this._REF_DT;
				cloneTB._FUND_CD = this._FUND_CD;
				cloneTB._FUND_NM = this._FUND_NM;
				cloneTB._FUND_PRICE = this._FUND_PRICE;
				cloneTB._ACC_UNIT = this._ACC_UNIT;
				cloneTB._INFLOW_UNIT = this._INFLOW_UNIT;
				cloneTB._OUTFLOW_UNIT = this._OUTFLOW_UNIT;
				cloneTB._TOTAL_AMT = this._TOTAL_AMT;
				cloneTB._STOCK_AMT = this._STOCK_AMT;
				cloneTB._BOND_AMT = this._BOND_AMT; 
				
				return cloneTB;
			}
			catch(Exception ex)
			{
				throw new Exception(ex.Message);
			}
		}
コード例 #3
0
		public static clsHDAT_INSR_FUNDPRICE_INFO_TB Create(DataRow dr)
		{
			try
			{
				clsHDAT_INSR_FUNDPRICE_INFO_TB tb = new clsHDAT_INSR_FUNDPRICE_INFO_TB();
				
				
				tb._REF_DT = Convert.ToString(dr[0]);
				tb._FUND_CD = Convert.ToString(dr[1]);
				tb._FUND_NM = Convert.ToString(dr[2]);
				tb._FUND_PRICE = Convert.ToDouble(dr[3]);
				tb._ACC_UNIT = Convert.ToInt32(dr[4]);
				tb._INFLOW_UNIT = Convert.ToInt32(dr[5]);
				tb._OUTFLOW_UNIT = Convert.ToInt32(dr[6]);
				tb._TOTAL_AMT = Convert.ToInt32(dr[7]);
				tb._STOCK_AMT = Convert.ToInt32(dr[8]);
				tb._BOND_AMT = Convert.ToInt32(dr[9]); 
				
				return tb;
			}
			catch(Exception ex)
			{
				throw new Exception(ex.Message);
			}
		}