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