public int parseHLDayFiles(string dirpath)
{
int nResult = 0;
HdDBHelper db = new HdDBHelper();
string[] filenames = Directory.GetFiles(dirpath);
foreach (string fn in filenames)
{
FileStream fs = new FileStream(fn, FileMode.Open);
if (fs != null)
{
TextReader tr = new StreamReader(fs);
string strHtml = tr.ReadToEnd();
ZHtmlParser htmlParser = new ZHtmlParser(strHtml);
LaoHLDayEx lhlday = new LaoHLDayEx(htmlParser);
db.saveToDb(lhlday);
tr.Close();
}
fs.Close();
}
return nResult;
}
public int saveToDb(LaoHLDayEx lhlday)
{
int nSaved = 0;
for (int i = 0; i < lhlday.Length; i++)
{
string cmdText = string.Format("INSERT INTO wy_laohuangli " +
"(ancient_hour, ancient_hour_fullname, solar_time_start, solar_time_end, " +
"star_god, straight_confict, good_ill_luck, zodiac_timed, good_god, ill_god, " +
"well_timed, bad_timed, fiveElem_timed, conflict_orientation, happy_god, fortune_god) " +
"VALUES ('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', " +
"'{10}', '{11}', '{12}', '{13}', '{14}', '{15}')",
lhlday.m_ancient_hour[i].Value,
lhlday.m_ancient_hour_fullname[i].Value,
lhlday.m_solar_time_start[i].Value,
lhlday.m_solar_time_end[i].Value,
lhlday.m_star_god[i].Value,
lhlday.m_straight_confict[i].Value,
lhlday.m_good_ill_luck[i].Value,
lhlday.m_zodiac_timed[i].Value,
lhlday.m_good_god[i].Value,
lhlday.m_ill_god[i].Value,
lhlday.m_well_timed[i].Value,
lhlday.m_bad_timed[i].Value,
lhlday.m_fiveElem_timed[i].Value,
lhlday.m_conflict_orientation[i].Value,
lhlday.m_happy_god[i].Value,
lhlday.m_fortune_god[i].Value);
MySqlCommand cmdSql = new MySqlCommand(cmdText, m_connSql);
cmdSql.CommandType = CommandType.Text;
if (cmdSql.ExecuteNonQuery() == 1)
{
nSaved++;
}
}
return nSaved;
}
