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