/// <summary> /// 创建判断是否开头包含的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="value">数据</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition LikeStartWith(String columnName, String value) { return(SqlCondition.Like(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 LikeEndWith(String columnName, String paramName, String value) { return(SqlCondition.Like(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 LikeColumn(String columnName, String tableNameTwo, String columnNameTwo) { return(SqlCondition.Like(SqlParameter.CreateCustomAction(columnName, GetFieldName(tableNameTwo, columnNameTwo)))); }