/// <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 }