/// <summary>
/// 更新 Apq_Tables, Apq_Columns 表内容
/// </summary>
/// <param name="DBName">目标数据库名</param>
/// <returns>影响行数</returns>
public int Refresh(string DBName)
{
#region 参数检测
if (string.IsNullOrEmpty(DBName))
{
throw new ArgumentNullException("DBName");
}
#endregion
System.Data.Common.DbCommand Command = Connection.CreateCommand();
Apq.Data.Common.DbCommandHelper CommandHelper = new Common.DbCommandHelper(Command);
CommandHelper.AddParameter("@Apq_Tables", Apq_Tables);
Command.CommandText = "SELECT OBJECT_ID( @Apq_Tables )";
Common.DbConnectionHelper.Open(Connection);
#region Apq_Tables
if (System.Convert.IsDBNull(Command.ExecuteScalar()))
{
Command.CommandText = string.Format(Sqls.Apq_TablesCreate,
Apq.Data.SqlClient.Common.EncodeString(Apq_Tables),
Apq.Data.SqlClient.Common.EncodeString(Apq_Columns),
Apq.Data.SqlClient.Common.EncodeString(DBName)
);
Command.ExecuteNonQuery();
}
Command.CommandText = string.Format(Sqls.Apq_TablesUpdate,
Apq.Data.SqlClient.Common.EncodeString(Apq_Tables),
Apq.Data.SqlClient.Common.EncodeString(Apq_Columns),
Apq.Data.SqlClient.Common.EncodeString(DBName)
);
Command.ExecuteNonQuery();
#endregion
#region Apq_Columns
CommandHelper.AddParameter("@Columns", Apq_Columns);
Command.CommandText = "SELECT OBJECT_ID( @Columns )";
if (System.Convert.IsDBNull(Command.ExecuteScalar()))
{
Command.CommandText = string.Format(Sqls.Apq_ColumnsCreate,
Apq.Data.SqlClient.Common.EncodeString(Apq_Tables),
Apq.Data.SqlClient.Common.EncodeString(Apq_Columns),
Apq.Data.SqlClient.Common.EncodeString(DBName)
);
Command.ExecuteNonQuery();
}
Command.CommandText = string.Format(Sqls.Apq_ColumnsUpdate,
Apq.Data.SqlClient.Common.EncodeString(Apq_Tables),
Apq.Data.SqlClient.Common.EncodeString(Apq_Columns),
Apq.Data.SqlClient.Common.EncodeString(DBName)
);
return(Command.ExecuteNonQuery());
#endregion
}
/// <summary>
/// 更新 Apq_Tables, Apq_Columns 表内容
/// </summary>
/// <param name="DBName">目标数据库名</param>
/// <returns>影响行数</returns>
public int Refresh(string DBName)
{
#region 参数检测
if (string.IsNullOrEmpty(DBName))
{
throw new ArgumentNullException("DBName");
}
#endregion
System.Data.Common.DbCommand Command = Connection.CreateCommand();
Apq.Data.Common.DbCommandHelper CommandHelper = new Common.DbCommandHelper(Command);
CommandHelper.AddParameter("@Apq_Tables", Apq_Tables);
Command.CommandText = "SELECT OBJECT_ID( @Apq_Tables )";
Common.DbConnectionHelper.Open(Connection);
#region Apq_Tables
if (System.Convert.IsDBNull(Command.ExecuteScalar()))
{
Command.CommandText = string.Format(Sqls.Apq_TablesCreate,
Apq.Data.SqlClient.Common.EncodeString(Apq_Tables),
Apq.Data.SqlClient.Common.EncodeString(Apq_Columns),
Apq.Data.SqlClient.Common.EncodeString(DBName)
);
Command.ExecuteNonQuery();
}
Command.CommandText = string.Format(Sqls.Apq_TablesUpdate,
Apq.Data.SqlClient.Common.EncodeString(Apq_Tables),
Apq.Data.SqlClient.Common.EncodeString(Apq_Columns),
Apq.Data.SqlClient.Common.EncodeString(DBName)
);
Command.ExecuteNonQuery();
#endregion
#region Apq_Columns
CommandHelper.AddParameter("@Columns", Apq_Columns);
Command.CommandText = "SELECT OBJECT_ID( @Columns )";
if (System.Convert.IsDBNull(Command.ExecuteScalar()))
{
Command.CommandText = string.Format(Sqls.Apq_ColumnsCreate,
Apq.Data.SqlClient.Common.EncodeString(Apq_Tables),
Apq.Data.SqlClient.Common.EncodeString(Apq_Columns),
Apq.Data.SqlClient.Common.EncodeString(DBName)
);
Command.ExecuteNonQuery();
}
Command.CommandText = string.Format(Sqls.Apq_ColumnsUpdate,
Apq.Data.SqlClient.Common.EncodeString(Apq_Tables),
Apq.Data.SqlClient.Common.EncodeString(Apq_Columns),
Apq.Data.SqlClient.Common.EncodeString(DBName)
);
return Command.ExecuteNonQuery();
#endregion
}
