Post Result Set to LINE Notify

指令碼工作

• ReadOnlyVariables 屬性：User::SqlResultSet

• Script（寫法參考 Wei 大大的文章）

// ......

public void Main()
{
    // TODO: Add your code here

    DataTable dataTable = new DataTable();
    OleDbDataAdapter adapter = new OleDbDataAdapter();
    adapter.Fill(dataTable, Dts.Variables["User::SqlResultSet"].Value);

    string result = "";

    foreach (DataRow row in dataTable.Rows)
    {
        result +=   "\n"
               + "\t股票代號：" + row["StockNo"].ToString() + "\n"
               + "\t即時高點：" + row["MinAvgHighPrice"].ToString() + "\n"
               + "\t即時低點：" + row["MinAvgLowPrice"].ToString() + "\n"
               + "\t當日高點：" + row["DayHighPrice"].ToString() + "\n"
               + "\t當日高點時間：" + String.Format("{0:H:mm:ss}", Convert.ToDateTime(row["DayHighTime"])) + "\n"
               + "\t當日低點：" + row["DayLowPrice"].ToString() + "\n"
               + "\t當日低點時間：" + String.Format("{0:HH:mm:ss}", Convert.ToDateTime(row["DayLowTime"]))
               + "\n";
    }

    using (var wc = new WebClient())
    {
        var bearer = $"[Your LINE Notify Token]";

        wc.Encoding = Encoding.UTF8;
        wc.Headers.Add("Content-Type", "application/x-www-form-urlencoded");
        wc.Headers.Add("Authorization", $"Bearer {bearer}");

        var nv = new NameValueCollection();
        nv["message"] = result;

        var bResult = wc.UploadValues($"https://notify-api.line.me/api/notify", nv);

        var res = Encoding.UTF8.GetString(bResult);
    }

    Dts.TaskResult = (int)ScriptResults.Success;
}

// ......