//导师查看团队信息
public Model.message_and_choose GetGroupModel(string xxid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Teamnumber,topicname,captainname,memberonename,membertwoname,memberthreename,topicintroduce from team ");
strSql.Append(" where Teamnumber=@xxid");
SqlParameter[] parameters =
{
new SqlParameter("@xxid", SqlDbType.Char, 11)
};
parameters[0].Value = xxid;
Model.message_and_choose model = new Model.message_and_choose();
DataTable dt = SQLDBhelper.ExecuteDataTable(strSql.ToString(), CommandType.Text, parameters);
if (dt.Rows.Count > 0)
{
model.Teamnumber = dt.Rows[0]["Teamnumber"].ToString();
model.topicname = dt.Rows[0]["topicname"].ToString();
model.captainname = dt.Rows[0]["captainname"].ToString();
model.memberonename = dt.Rows[0]["memberonename"].ToString();
model.membertwoname = dt.Rows[0]["membertwoname"].ToString();
model.memberthreename = dt.Rows[0]["memberthreename"].ToString();
model.topicintroduce = dt.Rows[0]["topicintroduce"].ToString();
return(model);
}
else
{
return(null);
}
}
//在个人信息界面显示导师信息
public Model.message_and_choose GetModel(string id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,name,sex,position,groupnumber,phone,email,academy,research,grade,major from teapasswordtable ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Char, 9)
};
parameters[0].Value = id;
Model.message_and_choose model = new Model.message_and_choose();
DataTable dt = SQLDBhelper.ExecuteDataTable(strSql.ToString(), CommandType.Text, parameters);
if (dt.Rows.Count > 0)
{
model.id = dt.Rows[0]["id"].ToString();
model.name = dt.Rows[0]["name"].ToString();
model.sex = dt.Rows[0]["sex"].ToString();
model.position = dt.Rows[0]["position"].ToString();
model.groupnumber = dt.Rows[0]["groupnumber"].ToString();
model.phone = dt.Rows[0]["phone"].ToString();
model.email = dt.Rows[0]["email"].ToString();
model.academy = dt.Rows[0]["academy"].ToString();
model.research = dt.Rows[0]["research"].ToString();
model.grade = dt.Rows[0]["grade"].ToString();
model.major = dt.Rows[0]["major"].ToString();
return(model);
}
else
{
return(null);
}
}
DateTime d5 = DateTime.Now; //当前系统时间
private void choose_group_Load(object sender, EventArgs e)
{
Model.message_and_choose model = bll.time();
d1 = model.d1;
d4 = model.d4;
label5.Text = "志愿预选开始时间为" + d1 + ",志愿预选截止时间为" + d4 + "";
}
//时间安排
public Model.message_and_choose time()
{
DataTable time = SQLDBhelper.ExecuteDataTable(string.Format("select * from time"));
Model.message_and_choose model = new Model.message_and_choose();
model.d1 = Convert.ToDateTime(time.Rows[0]["time1"].ToString());
model.d4 = Convert.ToDateTime(time.Rows[0]["time4"].ToString());
return(model);
}
//根据在choosegroup窗体中输入的团队编号，查找该账号的团队信息
private void groupmessage_Load(object sender, EventArgs e)
{
BLL.message_and_choose bll = new BLL.message_and_choose();
Model.message_and_choose model = bll.GetgroupModel(xxid);//绑定账号
if (model == null)
{
MessageBox.Show("数据查询出错");
return;
}
else
{
teamnumber.Text = model.Teamnumber;
topicname.Text = model.topicname;
captainname.Text = model.captainname;
memberonename.Text = model.memberonename;
membertwoname.Text = model.membertwoname;
memberthreename.Text = model.memberthreename;
topicintroduce.Text = model.topicintroduce;
}
}
private void tea_message_Load(object sender, EventArgs e)
{
BLL.message_and_choose bll = new BLL.message_and_choose();
Model.message_and_choose model = bll.GetModel(id);//绑定账号
if (model == null)
{
MessageBox.Show("数据查询出错");
return;
}
else
{
name_tea.Text = model.name;
sex_tea.Text = model.sex;
number_tea.Text = model.id;
title.Text = model.position;
people.Text = model.groupnumber;
college.Text = model.academy;
phone.Text = model.phone;
Email.Text = model.email;
research_tea.Text = model.research;
grade.Text = model.grade;
major.Text = model.major;
}
}
