예제 #1
0
        private void ListBox_Item()
        {
            SQLite_Funciton_Query sfq = new SQLite_Funciton_Query();

            sfq.SQLite_Query_ListBox(listBox1, Left_Item_ListBox_SQL, Main_GridView.Rows[this.Row_Index].Cells[1].Value.ToString());
            sfq.SQLite_Query_ListBox_Inverse(listBox2, Righ_Item_ListBox_SQL, Main_GridView.Rows[this.Row_Index].Cells[1].Value.ToString());
        }
예제 #2
0
        internal void status_stoped()
        {
            SQLite_Funciton_Query sfq = new SQLite_Funciton_Query();

            sfq.SQLite_Query_Status(this.stop, Main_GridView.Rows[this.Row_Index].Cells[1].Value.ToString());
            Log_DataBase("Status Stop", "Stop " + Main_GridView.Rows[this.Row_Index].Cells[3].Value.ToString());
        }
예제 #3
0
        internal void status_actived()
        {
            SQLite_Funciton_Query sfq = new SQLite_Funciton_Query();

            sfq.SQLite_Query_Status(this.active, Main_GridView.Rows[this.Row_Index].Cells[1].Value.ToString());
            Log_DataBase("Status Active", "Active " + Main_GridView.Rows[this.Row_Index].Cells[3].Value.ToString());

            //  m.Items[2].Text = "Stop";
        }
예제 #4
0
        private void delete_item()
        {
            Function_Settings     fnc = new Function_Settings();
            SQLite_Funciton_Query sfq = new SQLite_Funciton_Query();

            sfq.SQLite_Query_Delete(this.delete, Main_GridView.Rows[this.Row_Index].Cells[1].Value.ToString());
            Log_DataBase("Delete data", "Delete" + Main_GridView.Rows[this.Row_Index].Cells[3].Value.ToString());
            Main_GridView.Rows.RemoveAt(this.Row_Index);
            fnc.reload(Main_GridView, select, View_Column_Type);
        }
예제 #5
0
        private void btnStart_Click(object sender, EventArgs e)
        {
            tabControl1.SelectTab("tabPage4");
            Default_Template_Gridview();
            this.select = "select * from  Log";
            Function_Settings     dta = new Function_Settings();
            SQLite_Funciton_Query sfq = new SQLite_Funciton_Query();

            dta.gridview(Log_GridView, this.select, this.View_Column_Type);
            sfq.SQLite_Query_Combox(cb1, "SELECT DISTINCT Action FROM Log;");
            sfq.SQLite_Query_Combox(cb2, "SELECT DISTINCT Name FROM Log;");
            this.Log_GridView.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.DisplayedCells;
        }
예제 #6
0
        private void ListBox_Item_Inverse(int i)
        {
            SQLite_Funciton_Query sfq = new SQLite_Funciton_Query();

            listBox1.Items.Clear();
            listBox2.Items.Clear();
            if (i == 1)
            {
                sfq.SQLite_Query_ListBox_Inverse(listBox2, Righ_Item_ListBox_SQL, Main_GridView.Rows[this.Row_Index].Cells[1].Value.ToString());
                sfq.SQLite_Query_ListBox(listBox2, Left_Item_ListBox_SQL, Main_GridView.Rows[this.Row_Index].Cells[1].Value.ToString());
            }
            if (i == 2)
            {
                sfq.SQLite_Query_ListBox(listBox1, Left_Item_ListBox_SQL, Main_GridView.Rows[this.Row_Index].Cells[1].Value.ToString());
                sfq.SQLite_Query_ListBox_Inverse(listBox1, Righ_Item_ListBox_SQL, Main_GridView.Rows[this.Row_Index].Cells[1].Value.ToString());
            }
        }
예제 #7
0
        //Function datagridview and insert checkbox(use create datasource)
        #region Gridview
        internal void gridview(DataGridView bunifuCustomDataGrid1, string select, int species)
        {
            SQLite_Funciton_Query sfq = new SQLite_Funciton_Query();

            species_use                     = species;
            bunifuCustomDataGrid            = bunifuCustomDataGrid1;
            selected                        = select;
            bunifuCustomDataGrid.DataSource = null;
            bunifuCustomDataGrid.ReadOnly   = true;
            if (species_use == 0)
            {
                sfq.SQLite_Query(bunifuCustomDataGrid1, select);
                add_checkbox(bunifuCustomDataGrid);
            }
            if (species_use == 1)
            {
                sfq.SQLite_Query(bunifuCustomDataGrid1, select);
                add_checkbox(bunifuCustomDataGrid);
            }
        }
예제 #8
0
        private void Log_DataBase(string fucntion, string Note = null)
        {
            if (GridView_Index == 1)
            {
                this.Log_Text_Concatenate = " in User";
            }
            if (GridView_Index == 2)
            {
                this.Log_Text_Concatenate = " in Link";
            }
            if (GridView_Index == 3)
            {
                this.Log_Text_Concatenate = " in Comment";
            }
            if (GridView_Index == 4)
            {
                this.Log_Text_Concatenate = " in Group";
            }
            string select             = "INSERT INTO Log (Name, Time, Action, Note) VALUES('" + User_ACL.ToString() + "', '" + DateTime.Now.ToString() + "', '" + fucntion.ToString() + "','" + Note.ToString() + Log_Text_Concatenate + "');";
            SQLite_Funciton_Query sfq = new SQLite_Funciton_Query();

            sfq.SQLite_Query_Log_Database(Main_GridView, select);
        }
예제 #9
0
        //Function datagridview no insert checkbox (use reload data or Create datasource)
        #region reload
        internal void reload(DataGridView bunifuCustomDataGrid1, string select, int species)
        {
            SQLite_Funciton_Query sfq = new SQLite_Funciton_Query();

            this.species_use          = species;
            this.bunifuCustomDataGrid = bunifuCustomDataGrid1;
            this.selected             = select;
            bunifuCustomDataGrid.ClearSelection();
            bunifuCustomDataGrid.DataSource = null;
            bunifuCustomDataGrid.Rows.Clear();
            bunifuCustomDataGrid.Columns.Clear();
            bunifuCustomDataGrid.Refresh();
            bunifuCustomDataGrid.ReadOnly = true;
            if (species_use == 0)
            {
                sfq.SQLite_Query(bunifuCustomDataGrid1, select);
                add_checkbox(bunifuCustomDataGrid);
            }
            if (species_use == 1)
            {
                sfq.SQLite_Query(bunifuCustomDataGrid1, select);
                add_checkbox(bunifuCustomDataGrid);
            }
        }