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; }
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)); }
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); }
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; } } }
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); } } } } }
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; }