public int Execute(IConnectinContext cc)
{
Command mCommand = Command.GetThreadCommand().AddSqlText("Delete from ").AddSqlText(mTable);
Where.Parse(mCommand);
return(cc.ExecuteNonQuery(mCommand));
}
private object ExecuseAsSQL(IConnectinContext cc, SQL value)
{
object result = null;
if (IsChangeDataSQL(value.Command.Text.ToString()))
{
result = cc.ExecuteNonQuery(value.Command);
}
result = cc.ExecuteScalar(value.Command);
return(result);
}
public int Execute(IConnectinContext cc)
{
Command mCommand = Command.GetThreadCommand().AddSqlText("Insert into ").AddSqlText(mTable);
System.Text.StringBuilder names, values;
names = new System.Text.StringBuilder();
values = new System.Text.StringBuilder();
Field field;
for (int i = 0; i < mInserFields.Count; i++)
{
if (i > 0)
{
names.Append(",");
values.Append(",");
}
field = (Field)mInserFields[i];
names.Append(field.Name);
if (field.IsParameter)
{
values.Append("@").Append(field.ParameterName);
if (field.Value != null)
{
mCommand.AddParameter(field.ParameterName, field.Value);
}
else
{
mCommand.AddParameter(field.ParameterName, DBNull.Value);
}
}
else
{
values.Append(field.Value);
}
}
mCommand.Text.Append("(").Append(names).Append(")").Append(" Values(").Append(values).Append(")");
return(cc.ExecuteNonQuery(mCommand));
}
public int Execute(IConnectinContext cc)
{
Command mCommand = Command.GetThreadCommand().AddSqlText("Update ").AddSqlText(mTable).AddSqlText(" set ");
for (int i = 0; i < mFields.Count; i++)
{
if (i > 0)
{
mCommand.Text.Append(",");
}
if (!mFields[i].IsParameter)
{
mCommand.Text.Append(mFields[i].Name).Append("=").Append(mFields[i].Value);
}
else
{
mCommand.Text.Append(mFields[i].Name).Append("=@").Append(mFields[i].ParameterName);
mCommand.AddParameter(mFields[i].ParameterName, mFields[i].Value);
}
}
Where.Parse(mCommand);
return(cc.ExecuteNonQuery(mCommand));
}
/// <summary>
/// 在指写数据库上执行SQL并返回受影响的数量
/// </summary>
/// <param name="cc">数据库访问上下文</param>
/// <returns>int</returns>
public int Execute(IConnectinContext cc)
{
return(cc.ExecuteNonQuery(mCommand));
}
public static int Execute(this string sql, IConnectinContext cc)
{
Command cmd = new Command(sql);
return(cc.ExecuteNonQuery(cmd));
}