/// <summary> /// 更新运行参数 /// </summary> /// <param name="_entity"></param> internal void UpdateRunParams(RunParameters _entity) { string sql = string.Format("UPDATE run_parameters SET CurUserAgentIndex=@user_agent, CurScrRslIndex=@scr_rsl, CurLoopNo=@loop_no;"); SQLiteCommand cmd = new SQLiteCommand(sql, m_dbConnection); cmd.Parameters.Add(new SQLiteParameter("@user_agent", _entity.CurUserAgentIndex)); cmd.Parameters.Add(new SQLiteParameter("@scr_rsl", _entity.CurScrRslIndex)); cmd.Parameters.Add(new SQLiteParameter("@loop_no", _entity.CurLoopNo)); cmd.ExecuteNonQuery(); }
/// <summary> /// 查询运行参数 /// </summary> /// <returns></returns> internal RunParameters QryRunParams() { string sql = "SELECT CurUserAgentIndex, CurScrRslIndex, CurLoopNo FROM run_parameters limit 0,1"; SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection); SQLiteDataReader reader = command.ExecuteReader(); RunParameters _ret = null; while (reader.Read()) { _ret = new RunParameters() { CurLoopNo = Convert.ToInt32(reader["CurLoopNo"]), CurScrRslIndex = Convert.ToInt32(reader["CurScrRslIndex"]), CurUserAgentIndex = Convert.ToInt32(reader["CurUserAgentIndex"]) }; } return(_ret); }