public static string CheckLocationAndAddSQL(string LocationColName) { string locationClauseStr = ""; if (!LocationKeyHelper.GetInstance().IsOCC) { locationClauseStr = " " + LocationColName + "= " + LocationKeyHelper.GetInstance().LocationKey; } return(locationClauseStr); }