C# 日期字串統一格式

//// 定義日期字串

string dateString = "2018/03/10";

//// 字串 -> DateTime

DateTime datetime = Convert.ToDateTime(dateString);

//// DateTime -> 字串(yyyy-MM-dd HH:mm:ss)

String datetimeString = datetime.ToString("yyyy-MM-dd HH:mm:ss");

//// 轉回來的字串才能統一格式

Console.WriteLine(datetimeString);

參考程式 -> C# Online

C# 取得 Url 參數

HttpContext.Current.Request.Url 

參考網址：
https://blog.miniasp.com/post/2008/02/10/How-Do-I-Get-Paths-and-URL-fragments-from-the-HttpRequest-object.aspx

SQL Case When In Where Condition

SELECT
   column1, 
   column2
FROM
   viewWhatever
WHERE
CASE 
    WHEN @locationType = 'location' AND account_location = @locationID THEN 1
    WHEN @locationType = 'area' AND xxx_location_area = @locationID THEN 1
    WHEN @locationType = 'division' AND xxx_location_division = @locationID THEN 1
    ELSE 0
END = 1

SELECT column1, column2
FROM viewWhatever
WHERE
    (@locationType = 'location' AND account_location = @locationID)
    OR
    (@locationType = 'area' AND xxx_location_area = @locationID)
    OR
    (@locationType = 'division' AND xxx_location_division = @locationID)
By: https://stackoverflow.com/questions/206484/sql-switch-case-in-where-clause