/// <summary>

        /// 获取查询条件语句

        /// </summary>

        /// <typeparam name="SearchT">查询实体类型</typeparam>

        /// <param name="searchEntity">查询实体</param>

        /// <param name="sqlParameters">参数列表</param>

        /// <param name="WhereSql">条件语句</param>

        /// <param name="item">属性对象</param>

        private static void GetQueryWhere<SearchT>(SearchT searchEntity, List<MySqlParameter> sqlParameters, StringBuilder WhereSql, PropertyInfo property)

        {

            //验证值是否有效

            if (WhereValueValidate<SearchT>(searchEntity, property))

            {

                var sqlLikeAttr = property.GetCustomAttribute(typeof(SqlLikeAttribute));

                if (sqlLikeAttr != null)

                {

                    var columnName = GetColumnName(property);

                    var proprtyValue = filterLikeRiskStr(property.GetValue(searchEntity));

                    if (!string.IsNullOrEmpty(proprtyValue))

                    {

                        //获取特性值

                        var sqlLikeVal = (sqlLikeAttr as SqlLikeAttribute).Value;

                        switch (sqlLikeVal)

                        {

                            case SqlLikeType.LikeAll:

                                WhereSql.AppendFormat(" AND {0} Like '%{1}%'", !string.IsNullOrEmpty(columnName) ? columnName : property.Name, proprtyValue);

                                break;

                            case SqlLikeType.LikeLeft:

                                WhereSql.AppendFormat(" AND {0} Like '%{1}'", !string.IsNullOrEmpty(columnName) ? columnName : property.Name, proprtyValue);

                                break;

                            case SqlLikeType.LikeRight:

                                WhereSql.AppendFormat(" AND {0} Like '{1}%'", !string.IsNullOrEmpty(columnName) ? columnName : property.Name, proprtyValue);

                                break;

                            default:

                                WhereSql.AppendFormat(" AND {0} Like '%{1}%'", !string.IsNullOrEmpty(columnName) ? columnName : property.Name, proprtyValue);

                                break;

                        }

                    }

                }

                else if (property.GetCustomAttribute(typeof(GreaterAndEqualAttribute)) != null)

                {

                    var columnName = GetColumnName(property);

                    if (!string.IsNullOrEmpty(columnName))

                    {

                        var parameterName = string.Format("@{0}", property.Name);

                        WhereSql.AppendFormat(" AND {0} >= {1}", columnName, parameterName);

                        sqlParameters.Add(new MySqlParameter(parameterName, property.GetValue(searchEntity)));

                    }

                }

                else if (property.GetCustomAttribute(typeof(LessAndEqualAttribute)) != null)

                {

                    var columnName = GetColumnName(property);

                    if (!string.IsNullOrEmpty(columnName))

                    {

                        var parameterName = string.Format("@{0}", property.Name);

                        var value = property.GetValue(searchEntity);

                        if (value.GetType().Name.Equals("DateTime"))

                        {

                            WhereSql.AppendFormat(" AND {0} < {1}", columnName, parameterName);

                            sqlParameters.Add(new MySqlParameter(parameterName, Convert.ToDateTime(value).AddDays()));

                        }

                        else

                        {

                            WhereSql.AppendFormat(" AND {0} <= {1}", columnName, parameterName);

                            sqlParameters.Add(new MySqlParameter(parameterName, value));

                        }

                    }

                }

                else

                {

                    //新方法灵活性高

                    var columnName = GetColumnName(property);

                    if (!string.IsNullOrEmpty(columnName))

                    {

                        var parameterName = string.Format("@{0}", property.Name);

                        WhereSql.AppendFormat(" AND {0} = {1}", columnName, parameterName);

                        sqlParameters.Add(new MySqlParameter(parameterName, property.GetValue(searchEntity)));

                    }

                }

            }

        }