/// <summary> /// 创建判断是否开头不包含的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="value">数据</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition NotLikeStartWith(String columnName, String value) { return(SqlCondition.NotLike(SqlParameter.Create(columnName, "%" + value))); }
/// <summary> /// 创建判断是否结尾不包含的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="paramName">参数名</param> /// <param name="value">数据</param> /// <returns>Sql查询语句类</returns> public static SqlBasicParameterCondition NotLikeEndWith(String columnName, String paramName, String value) { return(SqlCondition.NotLike(SqlParameter.Create(columnName, paramName, value + "%"))); }
/// <summary> /// 创建判断是否结尾不包含的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="tableNameTwo">数据表名二</param> /// <param name="columnNameTwo">字段名二</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition NotLikeColumn(String columnName, String tableNameTwo, String columnNameTwo) { return(SqlCondition.NotLike(SqlParameter.CreateCustomAction(columnName, GetFieldName(tableNameTwo, columnNameTwo)))); }