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