Ejemplo n.º 1
0
        private void btnadd_Click(object sender, EventArgs e)
        {
            string       Confirm = "增加教师需重新生成课表,确认继续修改?";
            DialogResult dr      = MessageBox.Show(Confirm, "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);

            if (dr == DialogResult.OK)
            {
                truncateTable();
                SubTeacher addform = new SubTeacher();
                addform.getState(1);
                addform.ShowDialog();
            }

            query();
        }
Ejemplo n.º 2
0
        private void grdview_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
        {
            string       Confirm = "修改教师需要重新生成课表,确认继续修改?";
            DialogResult dr      = MessageBox.Show(Confirm, "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);

            if (dr == DialogResult.OK)
            {
                truncateTable();
                string[] arr = new string[7];
                for (int i = 0; i < 7; i++)
                {
                    arr[i] = grdview[i, grdview.SelectedCells[i].RowIndex].Value.ToString();
                }
                SubTeacher alter = new SubTeacher();
                alter.getState(2);
                alter.getArry(arr);
                alter.ShowDialog();
            }
            query();
        }
Ejemplo n.º 3
0
        private void btnAlter_Click(object sender, EventArgs e)
        {
            string       Confirm = "修改教师需要重新生成课表,确认继续修改?";
            DialogResult dr      = MessageBox.Show(Confirm, "确认", MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);

            if (dr == DialogResult.OK)
            {
                truncateTable();
                string sql = "select * from Z_tmp_teacherinfo";
                object obj = dao.ExecuteScale(sql);
                if (obj == null)
                {
                    MessageBox.Show("当前数据库没有数据!");
                }
                else
                {
                    if (grdview.DataSource == null)
                    {
                        MessageBox.Show("请选中要修改的行!");
                        query();
                    }
                    else
                    {
                        string[] arr = new string[7];
                        for (int i = 0; i < 7; i++)
                        {
                            arr[i] = grdview[i, grdview.SelectedCells[i].RowIndex].Value.ToString();
                        }
                        SubTeacher alter = new SubTeacher();
                        alter.getState(2);
                        alter.getArry(arr);
                        alter.ShowDialog();
                    }
                }
                query();
            }
        }