web123456

Mentorship Dual Selection System

 

Integrated application algorithm training

 

"one" radical in Chinese characters (Kangxi radical 1)mission statement

Designing a system forsoftware engineeringDepartmental undergraduate mentoring system for dual enrollment.

Design Requirements:

(1) Realize student information management and support information updating;

(2) Realization of teacher information management and support for information updating;

(3) Implement a process for students to fill out mentor volunteers and provide current mentor selections;

(4) Realization of a rule-based volunteer adjustment process;

(5) Realization of the student screening process for tutors;

(6) Realization of multiple types of queries for various types of information.

stupid (Beijing dialect)Experimental environment and experiment preparation

C# programming language

surname SanSystem analysis and design

This section includes the requirements analysis and software design portions of the software program, preferably illustrated.

(1) Needs analysis

Referring to the experimental requirements, it realizes calling the database for information display, mutual selection of tutors and students, updating the mutual selection results, administrator changing the information of teachers and students, querying the results of double selection, and adjusting the volunteers.

(2) Software design

Database: Teachers' table, students' table, administrators' table

Login: Tap Teacher/Student/Administrator Login and enter the correct username (Teacher ID, Student ID) and password to successfully log in.

Teachers:

The default capacity is 5 students.

Invite Students: list displays information about unassigned students, optional. If the students have not reached the limit, an invitation will be sent to the selected students and wait for the students to process. The student will receive the teacher's basic information and teaching experience, etc.

Processing of student applications: If an application is received from a student, the option of agreeing or rejecting it is available.

Refresh: update display information

Students:

There can only be one mentor.

Modify Personal Profile: Click to enter the content to be changed in the text box and save the modified personal profile.

Apply for a tutor: If you don't have a tutor, you can choose to apply for a tutor, send an application to the tutor, and wait for the teacher to process it. The tutor will receive the student's basic information and personal profile.

Processing Mentor Invitation: If you receive an invitation, enter the processing interface to view the invitation information and agree or decline the invitation.

Refresh: Refreshes the display information

Administrator:

Perform additions, deletions, and deletions to the teacher table, student table, and double opt-in table. And export the results to .xls file

Describe the definition of all data structures and data types used in this program, the flow of the main program, and a diagram of the calling relationships between the program modules.

4software source code

Form1 log in

using System;

using ;

using ;

using ;

using ;

using ;

using ;

using System.Windows.Forms;

using ;

 

namespace daoshizhi

{

    public partial class Form1 : Form

    {

        public static string welcome = "";

        public static string no = "";

        SqlConnection conn = new SqlConnection("server=.;database=tutorManagement;uid=sa;pwd=sa");

        public Form1()

        {

            InitializeComponent();

        }

        private void button1_Click(object sender, EventArgs e)

        {

            ();

            string username = ();

            string userpwd = ();

            if (username == "" || userpwd == "")

            {

= "User? Username? or password? cannot be empty! can be a null?!" ;)

            }

            else

            {

                string s1 = "select * from tutor where tno='" + username + "' and pwd='" + userpwd + "'";

                string s2 = "select * from student where sno='" + username + "' and pwd='" + userpwd + "'";

                string s3 = "select * from manager where mno='" + username + "' and pwd='" + userpwd + "'";

                if ()

                {

                    SqlCommand s01 = new SqlCommand(s1, conn);

                    SqlDataReader t = ();

                    if (())

                    {

                        ();

                        SqlDataAdapter s11 = new SqlDataAdapter(s1, conn);

                        DataSet ds = new DataSet();

                        ();

                        (ds, "tutor");

                        welcome=["tutor"].Rows[0]["tname"].ToString();

                        no= ["tutor"].Rows[0]["tno"].ToString();

                        Form Form2 = new Form2();

                        ();

                        ();

                    }

else = "User? User§name? or password? Wrong? error!".

                }

                else if ()

                {

                    SqlCommand s02 = new SqlCommand(s2, conn);

                    SqlDataReader t = ();

                    if (())

                    {

                        ();

                        SqlDataAdapter s22 = new SqlDataAdapter(s2, conn);

                        DataSet ds = new DataSet();

                        ();

                        (ds, "student");

                        welcome = ["student"].Rows[0]["name"].ToString();

                        no = ["student"].Rows[0]["sno"].ToString();

                        Form Form3 = new Form3();

                        ();

                        ();

                    }

else = "User? User§name? or password? Wrong? Mistake!".

                }

                else

                {

                    SqlCommand s03 = new SqlCommand(s3, conn);

                    SqlDataReader t = ();

                    if (())

                    {

                        Form Form4 = new Form4();

                        ();

                        ();

                    }

else = "User? User§name? or password? Wrong? error!".

                }

            }

            ();

        }

 

 

Form2 Teacher Interface

using System;

using ;

using ;

using ;

using ;

using ;

using ;

using ;

using ;

 

namespace daoshizhi

{

    public partial class Form2 : Form

    {

        public static string welcome =;

        public static string no = ;

        SqlConnection conn = new SqlConnection("server=.;database=tutorManagement;uid=sa;pwd=sa");

        public static int k;

        public Form2()

        {

            InitializeComponent();

= "Welcome? Welcome? ,?" + "Welcome" + "Master? Teacher!" ;)

/*Display? Show? My? Students

            ();

            string s = "select * from student where tno='"+no+"'";

            SqlCommand a = new SqlCommand(s,conn);

            SqlDataReader dr = ();

            while (())

            {

              (("{0}   {1}   {2}   {3}", dr[0], dr[1],dr[2],dr[3]));

            }

            ();

/*Display? Show? What's the name of the organization to be assigned to? MATCHED? Students?

            string s2 = "select sno,name,sex,message from student where tno is NULL";

            SqlCommand b = new SqlCommand(s2,conn);

            SqlDataReader dr2 = ();

            while (())

            {

                (("{0}    {1}    {2}   {3}", dr2[0], dr2[1], dr2[2], dr2[3]));

                (dr2[0]);

            }

            ();

            ();

/*Display? Show? Students are invited to attend the program. Invitation? */

            ();

            string s3 = "select count(sno) from student where selectno='" + no + "'";

            SqlCommand c = new SqlCommand(s3, conn);

            SqlDataReader dr3 = ();

            if (())

            {

                ();

                ();

                SqlDataAdapter da1 = new SqlDataAdapter(s3, conn);

                DataSet ds = new DataSet();

(ds, "Student Θ?Invitation? Invite? Invite? number of students").

string s4 = ["Student Θ?Invite? Invite? Number of people? Number of students"].Rows[0][0].ToString();

                k = (s4);

= "Received? Received?" + s4 + "a? student Θ?application Θ?please?" ;)

            }

            ();

            ();

        }

        private void panel1_Paint(object sender, PaintEventArgs e)

        {

 

        }

 

        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

        {

            ();

            Form1 f1 = new Form1();

            ();

        }

 

        private void Form2_Load(object sender, EventArgs e)

        {

 

        }

 

        private void label1_Click(object sender, EventArgs e)

        {

 

        }

 

        private void button1_Click(object sender, EventArgs e)

        {

//Invite? Invite? Students Θ?

if ( == -1) { ("Not ′selected? D What? !??") return; }

/*Calculating? Calculated? Already? What's the choice? And I'm in the process of inviting them. What are the implications of this? The total number of students who have been selected and who are being invited to attend the program. The total number of students who have been selected and who are being invited to attend the conference. The total number of students is very high. The number of students is very small. No. It can't be more than that. More than 5*/

            string m,n;

            int x=0,y=0;

            string s1 = "select count(*) from student where tno='" + no + "' group by tno";

            string s2 = "select count(*) from student where tnoselect='" + no + "' group by tnoselect";

            ();

            SqlCommand a = new SqlCommand(s1, conn);

            SqlDataReader dr1 = ();

            DataSet ds = new DataSet();

            if (())

            {

                ();

                ();

                SqlDataAdapter da = new SqlDataAdapter(s1, conn);

                (ds, "selected");

                m = ["selected"].Rows[0][0].ToString();

                x = (m);

            }

            ();

            ();

            SqlCommand b = new SqlCommand(s2, conn);

            SqlDataReader dr2 = ();

            if (())

            {

                ();

                ();

                SqlDataAdapter da1 = new SqlDataAdapter(s1, conn);

                (ds, "selecting");

                n = ["selecting"].Rows[0][0].ToString();

                y = (n);

            }

            ();

            if (x + y > 4)

{ ("People? The number of people will increase? More than? More than the largest. What's the limit? What's the limit? 5!") return; }

            else

            {

//Select? Select? Choose? What are the results? Add ? Add to? The table below summarizes the results.

                y++;

                string s3 = "update student set tnoselect='" + no + "' where sno='" + () + "'";

                SqlCommand cmd = new SqlCommand(s3, conn);

                ();

                ();

                ();

("to ò" + + "send aa? What's going on? Invite? Invite? \What are you doing? There is a "oval-shaped" + () + "a student" + (). The school is in the process of organizing a program for the students. are in the process of inviting them to the program. Invitation?" + () + "A? (the "student").

            }

        }

 

        private void button2_Click(object sender, EventArgs e)

        {

          

        }

 

        private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

        {

            Form5 f5 = new Form5();

            ();

            ();

        }

 

        private void linkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

        {

//Refresh? Message? Message

            ();

            ();

//Display? Show? My? Student Θ? Information

            ();

            string s = "select * from student where tno='" + no + "'";

            SqlCommand a = new SqlCommand(s, conn);

            SqlDataReader dr = ();

            while (())

            {

 

                (("{0}   {1}   {2}   {3}", dr[0], dr[1], dr[2], dr[3]));

            }

            ();

//Display? Show? What's the name of the organization to be distributed? What's the name of the student? Students?

            string s2 = "select sno,name,sex,message from student where tno is NULL";

            SqlCommand b = new SqlCommand(s2, conn);

            SqlDataReader dr2 = ();

            while (())

            {

                (("{0}    {1}    {2}   {3}", dr2[0], dr2[1], dr2[2], dr2[3]));

                (dr2[0]);

            }

            ();

            ();

//Display? Show? Students Θ// are invited? Invite?

            string s3 = "select count(sno) from student where selectno='" + no + "'";

            ();

            SqlCommand c = new SqlCommand(s3, conn);

            SqlDataReader dr3 = ();

            if (())

            {

                ();

                ();

                SqlDataAdapter da1 = new SqlDataAdapter(s3, conn);

                DataSet ds = new DataSet();

(ds, "Student Θ?invitation? Invite? Invite? number of applications").

string s4 = ["Student Θ?Invite? Invite? Number of people? Number of students"].Rows[0][0].ToString();

                k = (s4);

= "Received? Received?" + s4 + "a? student Θ?application Θ?please?" ;)

            }

            ();

            ();

        }

    }

}

 

 

Form3 Student Interface

using System;

using ;

using ;

using ;

using ;

using ;

using ;

using ;

using ;

 

namespace daoshizhi

{

    public partial class Form3 : Form

    {

        public static int k=0;

        public static string welcome =;

        public static string no = ;

        string sql1 = "select message from student where sno='" + no + "'";

        string sql2 = "select * from tutor where tno in (select tno from student where sno='" + no + "')";

        SqlConnection conn = new SqlConnection("server=.;database=tutorManagement;uid=sa;pwd=sa");

        public Form3()

        {

            InitializeComponent();

= "Welcome? Welcome? ,?" + welcome + "!?" ;

//Display? Show? Who? Who is it? Brief description

            ();

            SqlDataAdapter da = new SqlDataAdapter(sql1, conn);

            DataSet ds = new DataSet();

            (ds, "student");

            = ["student"].Rows[0]["message"].ToString();

            ();

//Display? Show? What's the name of the instructor? Teacher's information? Information

            ();

            SqlCommand c1 = new SqlCommand(sql2, conn);

            SqlDataReader dr = ();

            if (())

            {

k = 1;//The parentheses? What does this mean? Already? There is a guide? The following is a summary of the results of the program.

                ();

                SqlDataAdapter dp = new SqlDataAdapter(sql2, conn);

                ();

                (ds, "tutor");

                = ["tutor"].Rows[0]["tname"].ToString();

                = ["tutor"].Rows[0]["tno"].ToString();

                = ["tutor"].Rows[0]["sex"].ToString();

                = ["tutor"].Rows[0]["message"].ToString();

                ();

            }

            ();

//Display? Show? Guide? Teacher's invitation? Invite? Number of people? Number of people

            string s3 = "select count(tnoselect) from student where sno='" + no + "'";

            ();

            SqlCommand c = new SqlCommand(s3, conn);

            SqlDataReader dr3 = ();

            if (())

            {

                ();

                ();

                SqlDataAdapter da1 = new SqlDataAdapter(s3, conn);

(ds, "Guide? The teacher is invited? Invite? People? Counting applications").

string s4 = ["Guide? Teacher's invitation? Invite? Invite? Counting System"].Rows[0][0].ToString();

= "Received? Received?" + s4 + "a? Guidance? Teacher's invitation? Invited?" (SIGHING)

            }

            ();

            ();

        }

 

        private void button1_Click(object sender, EventArgs e)

        {

 

        }

 

        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

        {

            ();

            Form1 f1 = new Form1();

            ();

        }

 

        private void button2_Click(object sender, EventArgs e)

        {

//Display? Show? Who? Who is it? Brief description

            ();

            = false;

        }

 

        private void buttonSave_Click(object sender, EventArgs e)

        {

//Modify? The database is a repository of data. Who is it? Brief description

                string s1 = "update student set message='" + + "' where sno='" + no + "'";

                ();

                SqlCommand cmd = new SqlCommand(s1, conn);

                ();

                ();

("Fixing the T-change? ").

            = "";

            = false;

//New? Show? Show? Who is it? Who are you? Brief introductory information? Information

            ();

            SqlDataAdapter da = new SqlDataAdapter(sql1, conn);

            DataSet ds = new DataSet();

            (ds, "student");

            = ["student"].Rows[0]["message"].ToString();

            ();

        }

        private void button6_Click(object sender, EventArgs e)

        {

//Fetch? What is it? The name of the program is "Θ".

            = false;

            = "";

        }

        private void button3_Click(object sender, EventArgs e)

        {

            ();

            ();

            if (k == 0)

            {

                = false;

                = true;

//Display? Show? Guide? Teacher's choice? Selection? Boxes.

                string s2 = "select tno,tname,sex,message from tutor where tno in(select from student join tutor on = group by having count(sno)<5) or tno not in(select from student join tutor on =) ";

                ();

                SqlCommand a = new SqlCommand(s2, conn);

                SqlDataReader dr = ();

                while (())

                {

                    (("{0}    {1}    {2}    {3}", dr[0], dr[1], dr[2], dr[3]));

                    (dr[0]);

                }

                ();

                ();

            }

            else

("You have? You already have a tutor? You have a teacher now!") The

        }

 

        private void button4_Click(object sender, EventArgs e)

        {

//Select? Selection? Tutor? Teachers

string selectno = ();//get? Get? Select? selectno = ();//get? The Teacher's number?

/*The teacher is responsible for the student's behavior. Yes? No. of students Full of students±*/

            string s0 = "select count(*) from student where tno='" + selectno + "' group by tno";

            ();

            SqlCommand a= new SqlCommand(s0,conn);

            SqlDataReader dr=();

            DataSet ds = new DataSet();

            int x=0;

            if (() )

            {

                ();

                ();

                SqlDataAdapter da = new SqlDataAdapter(s0, conn);

                (ds, "selected");

                string m = ["selected"].Rows[0][0].ToString();

                x = (m);

                ();

            }

            ();

            ();

            if (x > 5)

("The? The teacher has taken the students to the school. The number of students in the program has already reached a full enrollment. The number of students has reached full capacity. Please contact us. Please repeat. New Select a new program. Choose a new teacher. Teachers!") The

            else

            {

/*Options? Choice? What are the results? Add ? Add to? Table of Contents /

                string s1 = "update student set selectno='"+selectno+"' where sno='"+ no + "'";

                ();

                SqlCommand cmd = new SqlCommand(s1, conn);

                ();

                ();

/*Get? What is it? Teacher's last name? First name? */First name?

                string s2 = "select tname from tutor where tno='" + selectno + "'";

                ();

                SqlDataAdapter da1 = new SqlDataAdapter(s2, conn);

(ds, "Choose? Choose? Teachers").

string selectname = ["Select? selectname = ["selectname"].Rows[0]["ttm"]. Teachers"].Rows[0]["tname"].ToString();

                ();

("To ò " + selectname + " old (of people)? Master What's going on? I've got it. Please.") The

                = false;

                ();

                ();

            }

        }

        private void button5_Click(object sender, EventArgs e)

        {

//Fetch? Cancel? Select? Selection? Instructor? Teachers

            = false;

            ();

            ();

        }

 

        private void linkLabel3_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

        {

//Refresh?

            ();

            SqlCommand c1 = new SqlCommand(sql2, conn);

            SqlDataReader dr = ();

            if (())

            {

                k = 1;

                ();

                SqlDataAdapter dp = new SqlDataAdapter(sql2, conn);

                DataSet ds = new DataSet();

                ();

                (ds, "tutor");

                = ["tutor"].Rows[0]["tname"].ToString();

                = ["tutor"].Rows[0]["tno"].ToString();

                = ["tutor"].Rows[0]["sex"].ToString();

                = ["tutor"].Rows[0]["message"].ToString();

                ();

            }

            ();

//Display? Show? Guidance? Teacher's invitation? Invite? Number of people? Number of people

            string s3 = "select count(tnoselect) from student where sno='" + no + "'";

            ();

            SqlCommand c = new SqlCommand(s3, conn);

            SqlDataReader dr3 = ();

            if (())

            {

                ();

                ();

                SqlDataAdapter da1 = new SqlDataAdapter(s3, conn);

                DataSet ds = new DataSet();

(ds, "Guide? The teacher is invited? Invite? Who? Counting applications").

string s4 = ["Guide? Teacher's invitation? Invite? Number of People Counting System"].Rows[0][0].ToString();

= "Received? Received?" + s4 + "a? Guidance? Teacher's invitation? Invited?" (SIGHING)

            }

            ();

            ();

        }

 

        private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)

        {

            Form6 f6 = new Form6();

            ();

        }

    }

}

 

 

Form4 Administrator Interface

using System;

using ;

using ;

using ;

using ;

using ;

using ;

using ;

using ;

using Excel = ;

 

namespace daoshizhi

{

    public partial class Form4 : Form

    {

        SqlConnection conn = new SqlConnection("server=.;database=tutorManagement;uid=sa;pwd=sa");

string s1 = "select as surname JiaoìDivision No.?,tname as lead?Surname of Division?place (e.g. among winners)?,sno as science§horn (wind instrument)?,name as science§be bornΘ?be surnamed?place (e.g. among winners)? from student join tutor on = order by ,sno";

string s2 = "select tno as surname JiaoìDivision No.?,tname as be surnamed?place (e.g. among winners)?,sex as suffix forming noun from adjective, corresponding -ness or -ity?don't worry about it.,message as bamboo strips used for writing (old)òlie betweené from tutor";

string s3 = "select sno as science§horn (wind instrument)?,name as be surnamed?place (e.g. among winners)?,sex as suffix forming noun from adjective, corresponding -ness or -ity?don't worry about it.,message as since?meòbamboo strips used for writing (old)òlie betweené from student";

        string s4 = "select count(sno) from student";

        string s5 = "select count(sno) from student where tno is not null";

        public SqlDataAdapter adap = new SqlDataAdapter();

        public DataSet ds = new DataSet();

        public Form4()

        {

            InitializeComponent();

        }

        private void Form4_Load(object sender, EventArgs e)

        {

 

        }

 

        private void button1_Click(object sender, EventArgs e)

        {

//Display? Show? Dual? Selection The table is bracketed.

            = null;

             = new SqlCommand(s1, conn);

(ds, "double? Selection? table brackets?) (ds, "double choice")

= ["Double? Selected? Table of Contents] ["Dual"]; ["Double"]; ["Parentheses"].

            ();

            SqlDataAdapter da = new SqlDataAdapter(s4,conn);

            DataSet ds2 = new DataSet();

(ds2, "Student§Θ? person? number of students").

string x0 = ["Student§Θ? Number of students"].Rows[0][0].ToString();

            ();

            ();

            SqlDataAdapter da1 = new SqlDataAdapter(s5, conn);

            DataSet ds3 = new DataSet();

(ds3, "Has? Finished ? The double? What are the options? The number of students who have been selected for the program has been increasing. Number of students").

string y0 = ["Has? Finished ? What is the name of the program? Selected? The number of students who have been selected for the program has been increasing. Number of students"].Rows[0][0].ToString();

            ();

= "has" + y0 + "/" + x0+ "been? Have oval-shaped" + y0 + "/" +x0+ "Learning§ students Θ?finished ? The student has completed the program. Selected?" ;)

            ();

            ();

            ();

        }

 

        private void button2_Click(object sender, EventArgs e)

        {

//Display? Show? Teachers' tables.

            = null;

             = new SqlCommand(s2, conn);

(ds, "Teach ì teacher mosquito table bracket?") ;

= ["Teach the teacher"] ["Teachers"].

            ();

           /* ();

            ();

            ();

            ();

            ();

            ();*/

        }

 

        private void button3_Click(object sender, EventArgs e)

        {

//Display? Show? The student Θ? table is enclosed?

            = null;

            = new SqlCommand(s3, conn);

(ds, "Student §Θ? table brackets?) ;

= ["Student Θ? table brackets?] ["Student Θ?table brackets?

            ();

           /* ();

            ();

            ();

            ();

            ();

            ();*/

        }

 

        private void button4_Click(object sender, EventArgs e)

        {

               

        }

 

        private void button7_Click(object sender, EventArgs e)

        {

            ExportDataGridview(dataGridView1,true);

        }

        public bool ExportDataGridview(DataGridView gridView, bool isShowExcle)

        {

            if ( == 0)

            {

                return false;

            }

//Creating a new name. Excel Objects

            excel = new ();

            (true);

 

//Sheng Θẽẽẽẽ? What is the name? Name? Name?

            for (int i = 0; i < ; i++)

            {

                [1, i + 1] = [i].HeaderText;

            }

//Fill? Fill in the blanks? Digital capitalization of Y

for (int i = 0; i < - 1; i++) //circle-loop-row D

            {

for (int j = 0; j < ; j++) //circular-column 

                {

                    if (gridView[j, i].ValueType == typeof(string))

                    {

                        [i + 2, j + 1] = "'" + [i].Cells[j].();

                    }

                    else

                    {

                        [i + 2, j + 1] = [i].Cells[j].();

                    }

                }

            }

//Set Θ?Set? Disable? Stop1bouncer? What's going on? Keep? Storage? And what about the cover? Inquire at ? What do you think? Frames of inquiry

            = false;

            = false;

            = false;

 

//Protection? What's the best way to get the most out of your life? Viii? What's the problem? What's the best way to get the most out of your life? What's the best way to do this?

            //(true).Save();

//Protection? Storage? Documentation? Documentation for the

 

            ("D:" + "\\");

            ();

            return true;

        }

    }

}

 

 

Form5 Processing of student applications

using System;

using ;

using ;

using ;

using ;

using ;

using ;

using ;

using ;

 

namespace daoshizhi

{

    public partial class Form5 : Form

    {

        SqlConnection conn = new SqlConnection("server=.;database=tutorManagement;uid=sa;pwd=sa");

        public static string no = ;

        public Form5()

        {

           

            InitializeComponent();

            ();

            string s = "select sno,name,sex,message from student where selectno='" + no + "'";

            SqlCommand a = new SqlCommand(s, conn);

            SqlDataReader dr = ();

            while (())

            {

                (("{0}   {1}   {2}   {3}", dr[0], dr[1], dr[2], dr[3]));

                (dr[0]);

            }

            ();

        }

 

        private void button1_Click(object sender, EventArgs e)

{/// Receive a sound? Invitation? Please? - Yes, please.

if ( == -1) { ("Not ′selected? Any of D? What? !??") return; }

            string s1 = ();

            string s2 = "update student set tno='" + no + "' where sno='" + s1 + "'";

            string s3 = "update student set tno=null where sno='" + s1 + "'";

            ();

            SqlCommand cmd = new SqlCommand(s2, conn);

            ();

            ();

            = 0;

            ();

            SqlCommand cmd2 = new SqlCommand(s3, conn);

            ();

            ();

("Add ? AddóstudentsΘ?+s1).

            ();

        }

 

        private void button2_Click(object sender, EventArgs e)

{// Reject? Invite? Invite?

if ( == -1) { ("Not ′selected? D What? !??") return; }

            string s1 = ();

            ();

            string s2 = "update student set selectno=null where sno='" + s1 + "'";

            ();

            SqlCommand cmd = new SqlCommand(s2, conn);

            ();

            ();

("Rejected? What? Come aa? From?" +s1+ "of? request?") The

        }

    }

}

 

 

Form6 Handling mentor invitations

using System;

using ;

using ;

using ;

using ;

using ;

using ;

using ;

using ;

 

namespace daoshizhi

{

    public partial class Form6 : Form

    {

        SqlConnection conn = new SqlConnection("server=.;database=tutorManagement;uid=sa;pwd=sa");

        public static string no = ;

        public Form6()

        {

            InitializeComponent();

            ();

            string s = "select tno,tname,sex,message from tutor where tno=(select tnoselect from student where sno='" + no + "')";

            SqlCommand a = new SqlCommand(s, conn);

            SqlDataReader dr = ();

            while (())

            {

                (("{0}   {1}   {2}   {3}", dr[0], dr[1], dr[2], dr[3]));

                (dr[0]);

            }

            ();

        }

 

        private void button1_Click(object sender, EventArgs e)

{/// Receive a sound? Invitation? Please? - Yes, please.

if ( == -1) { ("Not ′selected? D What? !??") return; }

            string s1 = ();

            string s2 = "update student set tno='" + s1 + "' where sno='" + no + "'";

            string s3 = "update student set tnoselect=null where sno='" + no + "'";

            ();

            SqlCommand cmd = new SqlCommand(s2, conn);

            ();

            ();

            ();

            ();

            SqlCommand cmd2 = new SqlCommand(s3, conn);

            ();

            ();

("Add ? Adding a guide? " + s1).

            = 1;

        }

 

        private void button2_Click(object sender, EventArgs e)

        {

//Reject? Invite? Invite?

if ( == -1) { ("Not ′selected? Any of D? What? !??") return; }

            string s1 = ();

            ();

            string s2 = "update student set tnoselect=null where sno='" + no + "'";

            ();

            SqlCommand cmd = new SqlCommand(s2, conn);

            ();

            ();

("Rejected? What? Come aa? Since? " + s1 + " Invitation? Invitation?") The

        }

    }

}

5Software testing instructions

login screen

 

When there is no mentor

 

Modify Profile

 

 

Apply for Mentor

 

 

Teacher Login

 

Inviting students

 

Processing of student applications

 

janitors

 

This section includes test data for the software with test screenshots and descriptions, preferably using the test cases from III.

6Instructions for using the software

Login: Tap Teacher/Student/Administrator Login and enter the correct username (Teacher ID, Student ID) and password to successfully login.

Teachers:

The default number of students is 5. The interface displays "My Students" and all "Students to be Assigned" who do not have a tutor at the moment.

Invite students: Tap the student number in the drop-down box, click "Invite", if the students have not reached the maximum number of students, the invitation will be sent to the selected students, waiting for students to process. The student will receive basic information about the teacher and his/her teaching experience.

Processing Student Requests: If you receive a request from a student, click on it to go to the processing screen, where you can agree or reject it.

Refresh: click Refresh to update the display information

Students:

There can be only one tutor. The screen displays "Profile" and tutor information.

Modify personal profile: Click to enter the content to be changed in the text box and save to modify the personal profile.

Apply for a tutor: If there is no tutor information, click the "Apply for a tutor" button to select a tutor from the drop-down list, click "Apply" to send an application to the tutor, and wait for the teacher to process it. The tutor will receive the student's basic information and personal profile.

Processing Tutor Invitation: If you receive an invitation, tap to enter the processing interface to view the invitation information, tap the drop-down box, and tap the button to agree or decline the invitation.

Refresh: Refreshes the display information

Administrator:

Follow the button prompts to add, delete, and check the Teacher, Student, and Double Selection tables.