62,046
社区成员
发帖
与我相关
我的任务
分享
public TcmOrdersCurrent LoadLastOneByOrdersSql(int orderSql)
{
const string sql = @"
SELECT ID
,System
,Channel
,Year
,Month
,Day
,Hour
,Minute
,Week
,Orders
,OrderSql
FROM TCMOrders_Current
WHERE OrderSql = @0
ORDER BY Year DESC,Month DESC,Day DESC,Hour DESC,Minute DESC LIMIT 1
";
return DB.PetaPoco(DB.TCMonitor).FirstOrDefault<TcmOrdersCurrent>(sql, orderSql);
}