コード例 #1
0
        public static List <string> GetActions(int buttonID)
        {
            DBButton dummyButton = new DBButton();

            dummyButton.btn_ID = buttonID;

            return(GetActions(dummyButton));
        }
コード例 #2
0
        // Insert the new button in the Buttons table.
        public static void InsertButton(DBButton button)
        {
            CheckDatabase();

            using (SQLiteConnection conn = new SQLiteConnection(new SQLitePlatformGeneric(), DB_PATH))
            {
                conn.RunInTransaction(() =>
                {
                    conn.Insert(button);
                });
            }
        }
コード例 #3
0
        //Update existing button
        public static void UpdateDetails(DBButton button)
        {
            CheckDatabase();

            using (SQLiteConnection conn = new SQLiteConnection(new SQLitePlatformGeneric(), DB_PATH))
            {
                var existingconact = conn.Query <DBButton>("select * from DBButton where btn_ID =" + button.btn_ID).FirstOrDefault();
                if (existingconact != null)
                {
                    conn.RunInTransaction(() =>
                    {
                        conn.Update(button);
                    });
                }
            }
        }
コード例 #4
0
        /*Добавление кнопки с указанным текстом, позицией и результатом диалога*/
        private Button NewButton(string text, Point location, DialogResult res)
        {
            DBButton bt = new DBButton();

            bt.Text      = text;
            bt.Location  = location;
            bt.FlatStyle = FlatStyle.Flat;
            /*Обрабатываем нажатие на левую кнопку мыши*/
            bt.MouseClick += new MouseEventHandler((o, mEv) =>
            {
                if (mEv.Button == MouseButtons.Left)
                {
                    result = res;
                    this.Close();
                }
            });
            return(bt);
        }
コード例 #5
0
        // TODO multiple actions w/ same button, ordinality
        public static List <string> GetActions(DBButton buttonPressed)
        {
            CheckDatabase();

            using (SQLiteConnection conn = new SQLiteConnection(new SQLitePlatformGeneric(), DB_PATH))
            {
                string keycodeQuery = "SELECT kc_Value FROM DBKeyCode " +
                                      "LEFT JOIN DBMacro ON DBKeyCode.kc_ID = DBMacro.mc_kc_ID " +
                                      "LEFT JOIN DBButton ON DBButton.btn_mc_ID = DBMacro.mc_ID " +
                                      "WHERE DBButton.btn_ID = " + buttonPressed.btn_ID;

                List <DBKeyCode> dbKeycodes = conn.Query <DBKeyCode>(keycodeQuery);

                List <string> actions = new List <string>();

                foreach (var keycode in dbKeycodes)
                {
                    actions.Add(keycode.kc_Value);
                }

                return(actions);
            }
        }