個人記錄

-orm

https://www.cnblogs.com/s0611163/p/15829449.html

--任務

btnExecuteTaskAsync.Click += (sender, args) => ExecuteTaskAsync();

 

private async void ExecuteTaskAsync()

{

    try

    {

        btnExecuteTaskAsync.IsEnabled = false;

        TextBoxMessage.Text = "Calculate Async Start" + Environment.NewLine;

        TextBoxMessage.Text += await DoSomethingAsync(); //异步调用

        btnExecuteTaskAsync.IsEnabled = true;

    }

    catch (Exception e)

    {

        TextBoxMessage.Text += $"Error: {e.Message}" + Environment.NewLine;

    }

    finally

    {

        btnExecuteTaskAsync.IsEnabled = true;

    }

}

 

private async Task<string> DoSomethingAsync()

{

    await Task.Delay(3000); //模拟计算密集耗时

    return "Calculate Async Done";

}

 

 

-----

分頁查詢

SELECT t.*

FROM (select uuid, pay_order_id

from t

where t.pay_order_id is not null --【 * 注】如果没有非空约束必须显示标明，否则索引失效

and t.pay_order_id >= '101809020001428452'

order by t.pay_order_id) t

WHERE ROWNUM <= 100;