/// <summary> /// 插入指定参数并返回当前语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="function">函数</param> /// <exception cref="ArgumentNullException">函数不能为空</exception> /// <returns>当前语句</returns> public InsertCommand Add(String columnName, ISqlFunction function) { if (function == null) { throw new ArgumentNullException("function"); } this._parameters.Add(SqlParameter.CreateCustomAction(columnName, function.ToString(this.DatabaseType))); if (function.HasParameters) { this._parameters.AddRange(function.GetAllParameters()); } return(this); }
/// <summary> /// 插入指定参数并返回当前语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="command">选择语句</param> /// <exception cref="ArgumentNullException">选择语句不能为空</exception> /// <returns>当前语句</returns> public InsertCommand Add(String columnName, SelectCommand command) { if (command == null) { throw new ArgumentNullException("command"); } this._parameters.Add(SqlParameter.CreateCustomAction(columnName, command.ToString())); List <SqlParameter> parameters = command.GetAllParameters(); if (parameters != null) { this._parameters.AddRange(command.GetAllParameters()); } return(this); }
/// <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)))); }
/// <summary> /// 创建判断是否小于等于的Sql条件语句 /// </summary> /// <param name="columnName">字段名</param> /// <param name="tableNameTwo">数据表名二</param> /// <param name="columnNameTwo">字段名二</param> /// <returns>Sql条件语句</returns> public static SqlBasicParameterCondition LessThanOrEqualColumn(String columnName, String tableNameTwo, String columnNameTwo) { return(SqlCondition.LessThanOrEqual(SqlParameter.CreateCustomAction(columnName, GetFieldName(tableNameTwo, columnNameTwo)))); }
/// <summary> /// 指定字段名自减并返回当前语句 /// </summary> /// <param name="columnName">字段名</param> /// <returns>当前语句</returns> public UpdateCommand Decrease(String columnName) { this._parameters.Add(SqlParameter.CreateCustomAction(columnName, columnName + "-1")); return(this); }