Пример #1
0
        private void 处理学生申请_Load(object sender, EventArgs e)
        {
            string grade = Grade.Text;
            string major = Major.Text;

            BLL.Group   b_group = new BLL.Group();
            Model.Group m_group = new Model.Group();
            dataGridView2.DataSource = b_group.getGroups(grade, major, uid);
            int width = 0;

            for (int i = 0; i < this.dataGridView2.Columns.Count; i++)
            {
                //将每一列都调整为自动适应模式
                this.dataGridView2.AutoResizeColumn(i, DataGridViewAutoSizeColumnMode.AllCellsExceptHeader);
                //记录整个DataGridView的宽度
                width += this.dataGridView2.Columns[i].Width;
            }
            //判断调整后的宽度与原来设定的宽度的关系,如果是调整后的宽度大于原来设定的宽度,
            //则将DataGridView的列自动调整模式设置为显示的列即可,
            //如果是小于原来设定的宽度,将模式改为填充。
            if (width > this.dataGridView2.Size.Width)
            {
                this.dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
            }
            else
            {
                this.dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
            }
            //冻结某列 从左开始 0,1,2
            dataGridView2.Columns[1].Frozen = true;
            dataGridView2.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
        }
Пример #2
0
        public IQueryable <EF.GroupMember> Checklist(EF.Member args, int id)
        {
            var bll_g = new BLL.Group(unitOfWork);
            var g     = bll_g.Get(new EF.Group {
                Id = id
            }).Result;

            var res = from m in unitOfWork.MemberRepository.Entities
                      .Where(x => x.IsActive == true &&
                             x.CommunityId == args.CommunityId &&
                             x.Id != g.GroupLeader)
                      join gm in unitOfWork.GroupMemberRepository.Entities
                      .Where(x => x.GroupId == id) on m.Id equals gm.MemberId into left
                      from rec in left.DefaultIfEmpty()
                      where m.Name.Contains(args.Name ?? "") &&
                      m.Id != rec.Group.GroupLeader
                      select new EF.GroupMember
            {
                Member   = m,
                Group    = rec.Group,
                GroupId  = rec == null ? 0 : rec.GroupId,
                MemberId = m.Id
            };

            return(res.OrderBy(x => x.Member.Name));
        }
Пример #3
0
        private void button7_Click(object sender, EventArgs e)
        {
            BLL.Group   b_group = new BLL.Group();
            Model.Group m_group = new Model.Group();
            string      msg     = "";
            int         groupid = 0;

            if (label1.Text.ToString().Equals(""))
            {
                groupid = 0;
            }
            else
            {
                groupid = int.Parse(label1.Text.ToString());
            }
            m_group.Gid       = groupid;
            m_group.Hid       = captainidbox.Text;
            m_group.Hid_name  = captainnamebox.Text;
            m_group.Mid1      = memberoneid.Text;
            m_group.Mid1_name = memberonename.Text;
            m_group.Mid2      = membertwoid.Text;
            m_group.Mid2_name = membertwoname.Text;
            m_group.Mid3      = memberthreeid.Text;
            m_group.Mid3_name = memberthreename.Text;
            m_group.Pro_name  = topicname.Text;
            m_group.Pro_intro = topicintroduce.Text;
            b_group.InsertOrModefiy(uid, groupid, m_group, out msg);
            MessageBox.Show(msg);
        }
Пример #4
0
        private void 学生_个人组队管理_Load(object sender, EventArgs e)
        {
            BLL.Group   b_group = new BLL.Group();
            Model.Group m_group = new Model.Group();
            string      str     = this.uid;

            //label5.Text = str;
            if (!str.Equals(""))
            {
                if (b_group.IsExistence(str, m_group))
                {
                    label1.Text          = m_group.Gid.ToString();
                    captainidbox.Text    = m_group.Hid;
                    captainnamebox.Text  = m_group.Hid_name;
                    memberoneid.Text     = m_group.Mid1;
                    memberonename.Text   = m_group.Mid1_name;
                    membertwoid.Text     = m_group.Mid2;
                    membertwoname.Text   = m_group.Mid2_name;
                    memberthreeid.Text   = m_group.Mid3;
                    memberthreename.Text = m_group.Mid3_name;
                    topicname.Text       = m_group.Pro_name;
                    topicintroduce.Text  = m_group.Pro_intro;
                }
            }
        }
Пример #5
0
        private void button7_Click(object sender, EventArgs e)
        {
            string id = uid;

            BLL.Group   b_group = new BLL.Group();
            Model.Group m_group = new Model.Group();
            string      msg     = "";

            if (dataGridView2.Rows.Count > 0)
            {
                for (int i = 0; i < dataGridView2.Rows.Count; i++)
                {
                    string _selectValue = dataGridView2.Rows[i].Cells["dataGridViewTextBoxColumn5"].EditedFormattedValue.ToString();
                    if (_selectValue == "True")
                    {
                        /*
                         * m_group.Gid = int.Parse(dataGridView2.Rows[i].Cells["小组编号"].ToString());
                         * m_group.Pro_name = dataGridView2.Rows[i].Cells["项目名称"].ToString();
                         * m_group.Hid_name = dataGridView2.Rows[i].Cells["队长"].ToString();
                         * m_group.Mid1_name = dataGridView2.Rows[i].Cells["队员"].ToString();
                         * m_group.Mid2_name = dataGridView2.Rows[i].Cells["队员1"].ToString();
                         * m_group.Mid3_name = dataGridView2.Rows[i].Cells["队员2"].ToString();
                         * m_group.First = dataGridView2.Rows[i].Cells["第一志愿"].ToString();
                         * m_group.First = dataGridView2.Rows[i].Cells["第二志愿"].ToString();
                         * m_group.First = dataGridView2.Rows[i].Cells["第三志愿"].ToString();
                         * b_group.UpdateTea(m_group.Gid,m_group,out msg);
                         * */
                        string str = dataGridView2.Rows[i].Cells["小组编号"].EditedFormattedValue.ToString();
                        int    gid = int.Parse(str);
                        try
                        {
                            b_group.UpdateTea(gid, id, out msg);
                            MessageBox.Show(msg);
                        }
                        catch (SqlException ex)
                        {
                            MessageBox.Show("更改失败" + ex.ErrorCode);
                        }
                        catch (Exception ex) {
                            MessageBox.Show("更改失败" + ex.Message);
                        }
                    }
                }
            }
        }
Пример #6
0
        private void button1_Click(object sender, EventArgs e)
        {
            string sql = "select * from g";

            //string sql = "select * from g,student,groupp where g.gid = groupp.groupid and student.id = groupp.headman and student.grade = @grade and student.major = @major;";
            SqlParameter[] paras = new SqlParameter[]
            {
                new SqlParameter("@grade", int.Parse(comboBox2.Text)),
                new SqlParameter("@major", comboBox1.Text.ToString())
            };
            dt_g = SqlDbHelper.ExecuteDataTable(sql, CommandType.Text, paras);

            //dataGridView1.DataSource = dt_g;


            sql  = "select * from t";
            dt_t = SqlDbHelper.ExecuteDataTable(sql);
            //dataGridView2.DataSource = dt_t;
            make_table();
            //dataGridView3.DataSource = score;
            count_score();
            DataView dataView = score.DefaultView;

            dataView.RowFilter = "得分>0";
            dataView.Sort      = "得分 DESC";
            score = dataView.ToTable();
            t_res = dt_t.Copy();
            g_res = dt_g.Copy();
            DataRow dr;       //遍历的每一行记录

            DataRow[] gids;   //每行记录的队伍ID
            DataRow[] tids;   //每行记录的老师ID
            DataRow[] g_tids; //老师选择的5个队伍的ID

            for (int i = 0; i < score.Rows.Count; i++)
            {
                dr = score.Rows[i];

                int tid, gid, mark, del, t_rescount;

                gid        = Convert.ToInt32(dr["组ID"]);
                tid        = Convert.ToInt32(dr["老师ID"]);
                mark       = Convert.ToInt32(dr["得分"]);
                del        = Convert.ToInt32(dr["del"]);
                t_rescount = Convert.ToInt32(t_res.Rows[tid - 1000]["res_count"]);
                //t_rescount = t_res.Select("tid=" + tid)[0].;
                if (del == 1)
                {
                    continue;
                }

                gids = score.Select("组ID=" + gid);

                tids = t_res.Select("tid=" + tid);

                for (int n = 0; n < 5; n++)
                {
                    if (t_rescount == res_count)
                    {
                        break;
                    }

                    int g_id = Convert.ToInt32(tids[0]["g" + (n + 1)]);
                    if (g_id == -1)
                    {
                        for (int j = 0; j < gids.Length; j++)
                        {
                            gids[j]["del"] = 1;
                        }
                        tids[0]["g" + (n + 1)] = gid;
                        tids[0]["res_count"]   = t_rescount + 1;
                        g_tids         = g_res.Select("gid=" + gid);
                        g_tids[0]["t"] = tid;
                        break;
                    }
                    else
                    {
                        continue;
                    }
                }
            }
            //dataGridView2.DataSource = g_res;
            DataTable data = new DataTable();

            foreach (DataRow row in g_res.Rows)
            {
                BLL.Group g = new BLL.Group();
                data.Merge(g.getInfo((int)row["gid"], (string)row["t"]));
            }
            dataGridView2.DataSource = data;
            int width = 0;

            for (int i = 0; i < this.dataGridView2.Columns.Count; i++)
            {
                //将每一列都调整为自动适应模式
                this.dataGridView2.AutoResizeColumn(i, DataGridViewAutoSizeColumnMode.AllCellsExceptHeader);
                //记录整个DataGridView的宽度
                width += this.dataGridView2.Columns[i].Width;
            }
            //判断调整后的宽度与原来设定的宽度的关系,如果是调整后的宽度大于原来设定的宽度,
            //则将DataGridView的列自动调整模式设置为显示的列即可,
            //如果是小于原来设定的宽度,将模式改为填充。
            if (width > this.dataGridView1.Size.Width)
            {
                this.dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
            }
            else
            {
                this.dataGridView2.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
            }
            //冻结某列 从左开始 0,1,2
            dataGridView2.Columns[1].Frozen = true;
            //内容居中
            dataGridView2.RowsDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
        }