bool saveToFile(TXHuangDaoDay hdd, FileFormat iFormat) { bool result = true; try { string tmp_filename = hdd.FID + ".txt"; FileStream fs = new FileStream(tmp_filename, FileMode.CreateNew); StreamWriter sw = new StreamWriter(fs, Encoding.GetEncoding("UTF-8")); switch (iFormat) { case FileFormat.FM_JSON: sw.Write(hdd.SerialToJSON()); break; case FileFormat.FM_XML: sw.Write(hdd.SerialToXML()); break; } sw.Close(); fs.Close(); } catch (IOException ex) { result = false; } return result; }
private void readWebData() { int page_count = m_endPage - m_startPage + 1; for (int i = 0; i < page_count; i++) { m_strHtml = m_wclient.DownloadString(getBookUrl(i)); TXHuangDaoDay hdd = new TXHuangDaoDay(m_strHtml); saveToDb(hdd); } }
bool saveToDb(TXHuangDaoDay hdd) { bool result = false; if (!initDb()) { return false; } string cmdText = string.Format("INSERT INTO wy_huangli(fid, showtime, lunerdate, goodtodo, badtodo) VALUES(\'{0}\', \'{1}\', \'{2}\', \'{3}\', \'{4}\')", hdd.FID, hdd.ShowTime, hdd.LunerDate, hdd.GoodToDo, hdd.BadToDo); MySqlCommand cmdSql = new MySqlCommand(cmdText, m_connSql); cmdSql.CommandType = CommandType.Text; if (cmdSql.ExecuteNonQuery() == 1) { result = true; } return result; }
public TXHuangDaoDay selectHlData(string where_clause) { if (!initDb()) { return null; } TXHuangDaoDay hdd = null; try { // Get record count string cmdText = "SELECT count(*) FROM wy_huangli " + where_clause; MySqlCommand cmdSql = new MySqlCommand(cmdText, m_connSql); cmdSql.CommandType = CommandType.Text; int row_count = (int)cmdSql.ExecuteScalar(); if (row_count > 0) { TXHuangDaoDay[] hdds = new TXHuangDaoDay[row_count]; cmdText = "SELECT * FROM wy_huangli " + where_clause; cmdSql.CommandText = cmdText; MySqlDataReader sqlReader = cmdSql.ExecuteReader(); for (int i = 0; (i < row_count) && sqlReader.Read(); i++) { hdds[i].FID = sqlReader.GetString("fid"); hdds[i].ShowTime = sqlReader.GetDateTime("showtime"); hdds[i].LunerDate = sqlReader.GetString("lunerdate"); hdds[i].GoodToDo = sqlReader.GetString("goodtodo"); hdds[i].BadToDo = sqlReader.GetString("badtodo"); } sqlReader.Close(); } } catch (MySqlException ex) { hdd = null; } return hdd; }