Esempio n. 1
0
        /* ###################### 要求三 ###################### */
        private void AddBtn_Click(object sender, EventArgs e)
        {
            Intent.STATE = "ADD";

            StudentEdit se = new StudentEdit();

            if (se.ShowDialog() == DialogResult.OK)
            {
                Student s = se.s;

                sql = @"" +
                      " INSERT INTO [Student]" +
                      " VALUES" +
                      " (@SNo, @SName, @Date, @classNo)";

                SqlParameter[] sqlParams = new SqlParameter[]
                {
                    new SqlParameter("@SNo", s.SNo),
                    new SqlParameter("@SName", s.SName),
                    new SqlParameter("@Date", s.Date),
                    new SqlParameter("@classNo", s.classNo),
                };

                table = db.GetBySQL(sql, sqlParams);
            }

            LoadTabs();
        }
Esempio n. 2
0
        private void ChangeBtn_Click(object sender, EventArgs e)
        {
            Intent.STATE = "CHANGE";

            if (listView3.SelectedItems.Count == 0)
            {
                MessageBox.Show("请选择一行");
                return;
            }

            Student s = new Student();

            s.SetValue(
                listView3.SelectedItems[0].SubItems[0].Text,
                listView3.SelectedItems[0].SubItems[1].Text,
                listView3.SelectedItems[0].SubItems[2].Text,
                listView3.SelectedItems[0].SubItems[3].Text
                );

            StudentEdit se = new StudentEdit();

            se.s          = s;
            Intent.OLD_ID = s.SNo;
            if (se.ShowDialog() == DialogResult.OK)
            {
                sql = @"" +
                      " UPDATE [Student]" +
                      " SET" +
                      "   [Sno]=@SNo," +
                      "   [SName]=@SName," +
                      "   [Date]=@Date," +
                      "   [classNo]=@classNo" +
                      " WHERE [Sno]=@OLD_ID";
                SqlParameter[] sqlParams = new SqlParameter[]
                {
                    new SqlParameter("@SNo", s.SNo),
                    new SqlParameter("@SName", s.SName),
                    new SqlParameter("@Date", s.Date),
                    new SqlParameter("@classNo", s.classNo),
                    new SqlParameter("@OLD_ID", Intent.OLD_ID.ToString())
                };

                table = db.GetBySQL(sql, sqlParams);
            }
            LoadTabs();
        }