static void ActRateInfoDetail(string sql) { DataTable dt = utils.ExecuteDataTable(sql); for (int i = 0; i < dt.Rows.Count; i++) { try { string result = dt.Rows[i][0].ToString(); Console.Write(result + "...\r\n"); ReceiveMessage msg = new ReceiveMessage(result.ToString()); string ret = msg.ActDataResult(); if (ret == "1") { sql = "UPDATE TCS_TaobaoMsgLog SET isok = 1 WHERE id = " + dt.Rows[i][1].ToString(); Console.Write(sql + "...\r\n"); utils.ExecuteNonQuery(sql); sql = "INSERT INTO TCS_TaobaoMsgLogBak SELECT * FROM [TCS_TaobaoMsgLog] WHERE id = " + dt.Rows[i][1].ToString(); Console.Write(sql + "...\r\n"); utils.ExecuteNonQuery(sql); sql = "DELETE FROM TCS_TaobaoMsgLog WHERE id = " + dt.Rows[i][1].ToString(); Console.Write(sql + "...\r\n"); utils.ExecuteNonQuery(sql); } } catch (Exception ex) { sql = "UPDATE TCS_TaobaoMsgLog SET isok = 2 WHERE id = " + dt.Rows[i][1].ToString(); utils.ExecuteNonQuery(sql); Console.Write(ex.Message.ToString() + "...\r\n"); Console.Write(ex.Source.ToString() + "...\r\n"); Console.Write(ex.StackTrace.ToString() + "...\r\n"); } } }