If you give someone a program , you will frustrate them for a day; if you teach them how to program, you will frustrate them for a lifetime.IT 這段話的意思是，如果你交給某人一隻程式，你將折磨他一整天;如果你教會某人如何寫程式，你將折磨他一輩子。

部落格全站分類：數位生活

BloggerAds

Jan 01 Mon 2018 00:59
根據ListSqlParameter返回sql條件(where后) - gaocong

文章出處

  /// <summary>
        /// 根據參數列表返回sql條件(where后)
        /// </summary>
        /// <param name="list"></param>
        /// <returns>//返回如 a=@a and b=@b</returns>
        public string getSqlFilterCondition(List<SqlParameter> list)
        {
            List<string> uniqueFilter = new List<string>();
            //生成條件字符串
            foreach (SqlParameter item in list)
            {
                uniqueFilter.Add(item.ParameterName.Replace("@", "") + "=" + item.ParameterName);
            }
            return string.Join(" and ", uniqueFilter);
        }