Ejemplo n.º 1
0
 /// <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)));
 }
Ejemplo n.º 2
0
 /// <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 + "%")));
 }
Ejemplo n.º 3
0
 /// <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))));
 }