コード例 #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            int date = new int();

            date = 0;
            keeys        ky  = new keeys();
            attendValues val = new attendValues();

            foreach (var s in attend)
            {
                if (use.student_id == s.Key.s_id && use.course_id == s.Key.c_id)
                {
                    if (date < s.Key.week)
                    {
                        date = s.Key.week;
                    }
                }
            }
            date++;
            ky.c_id = use.course_id;
            ky.s_id = use.student_id;
            ky.week = date;

            if (comboBox1.selectedIndex == 0)
            {
                val.attendance = "Yes";
            }
            else
            {
                val.attendance = "No";
            }

            val.e_id = use.user_id;
            attend.Add(ky, val);
            insertdata(ky.s_id, ky.c_id, val.e_id, ky.week, val.attendance);
        }
コード例 #2
0
        //-------------------------------------------------------------------------------------------------------------------------------------------------
        public Dictionary <keeys, attendValues> dataattendance()
        {
            SqlConnection con = new SqlConnection("Data Source=.;Initial Catalog=DSProject;Integrated Security=True");

            con.Open();
            SqlDataAdapter reader3 = new SqlDataAdapter("select * from Attendance ", con);
            DataTable      dt      = new DataTable();

            reader3.Fill(dt);
            foreach (DataRow dr in dt.Rows)
            {
                keeys        key1   = new keeys();
                attendValues value1 = new attendValues();
                key1.c_id         = (int)dr["C_ID"];
                key1.s_id         = (int)dr["S_ID"];
                key1.week         = (int)dr["week"];
                value1.attendance = (string)dr["_status"];
                value1.e_id       = (int)dr["Emp_Id"];
                attend.Add(key1, value1);
            }
            con.Close();

            return(attend);
        }