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