コード例 #1
0
        private void CreateUpdateTrackingTables(Table t, string eventName)
        {
            var commandStr = "If exists (select name from sysobjects where name = '{0}') drop table {0} CREATE TABLE {0}{1}";

            commandStr = string.Format(commandStr, eventName + "_" + t.TableName, CreateTableColumns(t.OrderedColumnSchema));

            SDQ.ExecuteNonQuery(commandStr);
        }
コード例 #2
0
        private void UpdateEntitySyncLog(string entityId, string showCode, int sysEventId)
        {
            var commandStr = "exec InsertUpdateEntityState '{0}', '{1}', {2}";

            commandStr = string.Format(commandStr, entityId, showCode, sysEventId);

            SDQ.ExecuteNonQuery(commandStr);
        }