public Model.tea updatetoselect(string xxid)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from teapasswordtable where id='" + xxid + "' ");
Model.tea model = new Model.tea();
DataTable dt = SQLDBhelper.ExecuteDataTable(strSql.ToString());
if (dt.Rows.Count > 0)
{
model.name = dt.Rows[0]["Name"].ToString();
model.sex = dt.Rows[0]["Sex"].ToString();
model.id = dt.Rows[0]["ID"].ToString();
model.password = dt.Rows[0]["password"].ToString();
model.position = dt.Rows[0]["position"].ToString();
model.number = dt.Rows[0]["number"].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);
}
}
private void edit_tea_message_Load(object sender, EventArgs e)
{
try
{
Model.tea model = bll.updatetoselect(UserHelper.xxid);
textBox1.Text = model.name;
comboBox1.Text = model.sex;
textBox2.Text = model.id;
textBox3.Text = model.password;
comboBox2.Text = model.grade;
comboBox5.Text = model.major;
comboBox4.Text = model.academy;
comboBox3.Text = model.position;
textBox9.Text = model.research;
textBox4.Text = model.phone;
textBox5.Text = model.email;
textBox6.Text = model.groupnumber;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
