/// <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>
/// 更新指定参数并返回当前语句
/// </summary>
/// <param name="columnName">字段名</param>
/// <param name="tableName">查询的表名</param>
/// <param name="action">设置选择语句的方法</param>
/// <exception cref="ArgumentNullException">设置语句的方法不能为空</exception>
/// <returns>当前语句</returns>
/// <example>
/// <code lang="C#">
/// <![CDATA[
/// IDatabase db = DatabaseFactory.CreateDatabase();
///
/// UpdateCommand cmd = db.CreateUpdateCommand("tbl_Users")
/// .Set("UserName", "admin")
/// .Set("UploadCount",
/// "tbl_Uploads", s =>
/// {
/// s.Query(SqlAggregateFunction.Count)
/// .Where(c => c.Equal("UserID", 1));
/// }
/// )
/// .Where(c => c.Equal("UserID", 1));
///
/// //UPDATE tbl_Users SET UserName = @UserName, UploadCount = (SELECT COUNT(*) FROM tbl_Uploads WHERE UserID = @UserID_Select) WHERE UserID = @UserID_Update
/// //@UserName = "******"
/// //@UserID_Select = 1
/// //@UserID_Update = 1
///
/// Boolean success = cmd.Result() > 0;
/// ]]>
/// </code>
/// </example>
public UpdateCommand Set(String columnName, String tableName, Action <SelectCommand> action)
{
if (action == null)
{
throw new ArgumentNullException("action");
}
SelectCommand command = this._database.InternalCreateSelectCommand((this.RootSource == null ? this : this.RootSource), tableName);
action(command);
this._updateFields.Add(this.CreateDataParameterCustomAction(columnName, command.GetCommandText()));
DataParameter[] parameters = command.GetAllParameters();
if (parameters != null)
{
this._parameters.AddRange(command.GetAllParameters());
}
return(this);
}
/// <summary>
/// 获取分页后的选择语句
/// </summary>
/// <param name="sourceCommand">源选择语句</param>
/// <param name="orderReverse">是否反转</param>
/// <returns>分页后的选择语句</returns>
internal override String InternalGetPagerSelectCommand(SelectCommand sourceCommand, Boolean orderReverse)
{
if (sourceCommand.PageSize <= 0 || sourceCommand.RecordStart <= 0)//正常模式或分页模式中的子语句
{
return AccessSelectPager.InternalGetPagerCommand(sourceCommand, 0, orderReverse);
}
String cntCommand = AccessSelectPager.InternalGetCountCommand(sourceCommand);
SqlParameter[] parameters = sourceCommand.GetAllParameters();
DbCommand dbCommand = this.CreateDbCommand(cntCommand, parameters);
Int32 recordCount = this.ExecuteScalar<Int32>(dbCommand);
return this.InternalGetPagerSelectCommand(sourceCommand, recordCount, orderReverse);
}
/// <summary>
/// 查询指定选择语句并返回当前语句
/// </summary>
/// <param name="command">选择语句</param>
/// <param name="aliasesName">别名</param>
/// <exception cref="ArgumentNullException">选择语句不能为空</exception>
/// <returns>当前语句</returns>
public SelectCommand Query(SelectCommand command, String aliasesName)
{
if (command == null)
{
throw new ArgumentNullException("function");
}
this._queryFields.Add(SqlQueryField.InternalCreateFromFunction(command.ToString(true), aliasesName));
List <SqlParameter> parameters = command.GetAllParameters();
if (parameters != null)
{
this._parameters.AddRange(parameters);
}
return(this);
}
/// <summary>
/// 更新指定参数并返回当前语句
/// </summary>
/// <param name="columnName">字段名</param>
/// <param name="command">选择语句</param>
/// <exception cref="ArgumentNullException">选择语句不能为空</exception>
/// <returns>当前语句</returns>
/// <example>
/// <code lang="C#">
/// <![CDATA[
/// IDatabase db = DatabaseFactory.CreateDatabase();
/// SelectCommand countCmd = db.CreateSelectCommand("tbl_Uploads")
/// .Query(SqlAggregateFunction.Count)
/// .Where(c => c.Equal("UserID", 1));
///
/// UpdateCommand cmd = db.CreateUpdateCommand("tbl_Users")
/// .Set("UserName", "admin")
/// .Set("UploadCount", countCmd)
/// .Where(c => c.Equal("UserID", 1));
///
/// //UPDATE tbl_Users SET UserName = @UserName, UploadCount = (SELECT COUNT(*) FROM tbl_Uploads WHERE UserID = @UserID_Select) WHERE UserID = @UserID_Update
/// //@UserName = "******"
/// //@UserID_Select = 1
/// //@UserID_Update = 1
///
/// Boolean success = cmd.Result() > 0;
/// ]]>
/// </code>
/// </example>
public UpdateCommand Set(String columnName, SelectCommand command)
{
if (command == null)
{
throw new ArgumentNullException("command");
}
this._parameters.Add(this.CreateSqlParameterCustomAction(columnName, command.GetCommandText()));
SqlParameter[] parameters = command.GetAllParameters();
if (parameters != null)
{
this._parameters.AddRange(command.GetAllParameters());
}
return this;
}
/// <summary>
/// 查询指定选择语句并返回当前语句
/// </summary>
/// <param name="command">选择语句</param>
/// <param name="aliasesName">别名</param>
/// <exception cref="ArgumentNullException">选择语句不能为空</exception>
/// <returns>当前语句</returns>
public SelectCommand Query(SelectCommand command, String aliasesName)
{
if (command == null)
{
throw new ArgumentNullException("function");
}
this._queryFields.Add(SqlQueryField.InternalCreateFromFunction(command.ToString(true), aliasesName));
List<SqlParameter> parameters = command.GetAllParameters();
if (parameters != null)
{
this._parameters.AddRange(parameters);
}
return this;
}