asp.net web page razor 定時(shí)器怎么做,比如說訂單15天自動(dòng)簽收。我做了一個(gè)簽收頁(yè)面AutoReceipt.chtml,代碼如下
@{ //發(fā)貨后15天自動(dòng)簽收 var db = Database.Open("rcdb"); var sql = "SELECT * FROM Orders WHERE Status = 2 and datediff(day,UpdateTime,"+ DateTime.Now +") > 15"; var data = db.Query(sql); if(data != null){ foreach (var item in data) { var updateCommand = "UPDATE Orders SET UpdateTime=@0, Status=@1 WHERE Id=@2"; db.Execute(updateCommand, DateTime.Now, 3, item.Id); } }}
可不可以利用每次打開網(wǎng)站都啟動(dòng)_AppStar.cshtmlt這個(gè)來執(zhí)行AutoReceipt.chtml這個(gè)頁(yè)面
- 3 回答
- 0 關(guān)注
- 495 瀏覽
添加回答
舉報(bào)
0/150
提交
取消