public bool BackupAA()
{int temp = 0;
int tempdel = 0;
string sql = "INSERT INTO [WMSBAK].[dbo].[AACopy] SELECT * FROM [TestDB].[dbo].[AA] WHERE AddDate <= DATEADD( d ,-45,GETDATE())";
try
{temp = dbhelper.ExcuteNonequery(sql);
}
catch (Exception)
{}
if (temp > 0)
{string delsql = "DELETE [TestDB].[dbo].[AA] WHERE AddDate < DATEADD( d ,-45,GETDATE())";
try
{新聞熱點
疑難解答