public static string CheckLocationAndAddSQL(string LocationColName)
        {
            string locationClauseStr = "";

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