public bool Check(Model.Stumes model, out string mes)
{
bool check = true;
mes = "";
if (model.Name == "")
{
mes = "姓名不能为空";
check = false;
return(check);
}
if (model.Number.ToString() == "")
{
mes = "学号不能为空";
check = false;
return(check);
}
if (model.Major == "")
{
mes = "专业不能为空";
check = false;
return(check);
}
if (model.Stuclass == "")
{
mes = "班级不能为空";
check = false;
return(check);
}
//头像
return(check);
}
public bool update(Model.Stumes model, string UserName)
{
string str = "update tb_stumes set username=@UserName,number=@Number,major=@Major,stuclass=@Stuclass where username='******'";
MySqlParameter[] parameters =
{
new MySqlParameter("@UserName", MySqlDbType.VarChar, 50),
new MySqlParameter("@Number", MySqlDbType.VarChar, 50),
new MySqlParameter("@Major", MySqlDbType.VarChar, 50),
new MySqlParameter("@Stuclass", MySqlDbType.VarChar, 50),
//new SqlParameter("@Pic", SqlDbType.VarChar,50)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Number;
parameters[2].Value = model.Major;
parameters[3].Value = model.Stuclass;
//parameters[4].Value = model.Pic;
int rows = SqlDbHelper.ExecuteNonQuery(str, CommandType.Text, parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool update(Model.Stumes model, string UserName, out string mes)
{
if (!Check(model, out mes))
{
return(false);
}
else
{
return(stumes.update(model, UserName));
}
}
public bool update(Model.Stumes model, string UserName)
{
/*SqlServer语句存储过程，还是sqlserver好啊！！！
* string storeProcedure = "moreupdate";
* SqlParameter[] parameters = {
* new SqlParameter("@UserName", SqlDbType.VarChar,50),
* new SqlParameter("@Number", SqlDbType.VarChar,50),
* new SqlParameter("@Major", SqlDbType.VarChar,50),
* new SqlParameter("@Stuclass", SqlDbType.VarChar,50),};
* parameters[0].Value = model.Name;
* parameters[1].Value = model.Number;
* parameters[2].Value = model.Major;
* parameters[3].Value = model.Stuclass;
* int rows = SqlDbHelper.ExecuteNonQuery(storeProcedure, CommandType.StoredProcedure, parameters);*/
string insert1 = "insert into tb_stumes(username,number,major,stuclass) values(@UserName,@Number,@Major,@Stuclass)";
string insert2 = "insert into tb_wish(username) values(@Username)";
string insert3 = "insert into tb_score(username) values(@Username)";
MySqlParameter[] parameters =
{
new MySqlParameter("@UserName", MySqlDbType.VarChar, 50),
new MySqlParameter("@Number", MySqlDbType.VarChar, 50),
new MySqlParameter("@Major", MySqlDbType.VarChar, 50),
new MySqlParameter("@Stuclass", MySqlDbType.VarChar, 50),
};
parameters[0].Value = model.Name;
parameters[1].Value = model.Number;
parameters[2].Value = model.Major;
parameters[3].Value = model.Stuclass;
MySqlParameter[] pa = { new MySqlParameter("@UserName", MySqlDbType.VarChar, 50) };
pa[0].Value = model.Name;
MySqlParameter[] pas = { new MySqlParameter("@UserName", MySqlDbType.VarChar, 50) };
pas[0].Value = model.Name;
int a = SqlDbHelper.ExecuteNonQuery(insert1, CommandType.Text, parameters);
int b = SqlDbHelper.ExecuteNonQuery(insert2, CommandType.Text, pa);
int rows = SqlDbHelper.ExecuteNonQuery(insert3, CommandType.Text, pas);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
private void button7_Click(object sender, EventArgs e)
{
BLL.Stumes stumes = new BLL.Stumes();
Model.Stumes model = new Model.Stumes();
if (textBox6.Text == "" || textBox3.Text == "")
{
MessageBox.Show("请输入数据");
}
else
{
model.Name = textBox6.Text.Trim();
model.Number = textBox3.Text.Trim();
DataTable myDatatable = stumes.getmes(model);
dataGridView1.DataSource = myDatatable;
}
}
public Model.Stumes select(string UserName)
{
string str = "select username,number,major,stuclass from tb_stumes where username=@UserName";
MySqlParameter[] parameters =
{
new MySqlParameter("@UserName", MySqlDbType.VarChar, 50)
};
parameters[0].Value = UserName;
Model.Stumes model = new Model.Stumes();
model.Name = "";
model.Number = "";
model.Stuclass = "";
model.Major = "";
//model.Pic = "";
DataTable dt = SqlDbHelper.ExecuteDataTable(str, CommandType.Text, parameters);
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["username"] != null && dt.Rows[0]["username"].ToString() != "")
{
model.Name = dt.Rows[0]["username"].ToString();
}
if (dt.Rows[0]["number"] != null && dt.Rows[0]["number"].ToString() != "")
{
model.Number = dt.Rows[0]["number"].ToString();
}
if (dt.Rows[0]["major"] != null && dt.Rows[0]["major"].ToString() != "")
{
model.Major = dt.Rows[0]["major"].ToString();
}
if (dt.Rows[0]["stuclass"] != null && dt.Rows[0]["stuclass"].ToString() != "")
{
model.Stuclass = dt.Rows[0]["stuclass"].ToString();
}
/*if (dt.Rows[0]["pic"] != null && dt.Rows[0]["pic"].ToString() != "")
* {
* model.Pic = dt.Rows[0]["pic"].ToString();
* }*/
}
return(model);
}
public DataTable getmes(Model.Stumes model)
{
DataTable dt = new DataTable();
StringBuilder selectmes = new StringBuilder();
selectmes.Append("select tb_stumes.username as '学生名字',tb_stumes.number as '学生学号',tb_stumes.major as '专业',tb_stumes.stuclass as '班级',tb_score.endresult as '最终成绩',tb_wish.tb_result as '最终志愿' ");
selectmes.Append(" from tb_stumes ");
selectmes.Append(" join tb_score on tb_stumes.username = tb_score.username ");
selectmes.Append(" join tb_wish on tb_stumes.username = tb_wish.username ");
selectmes.Append(" where tb_stumes.username like '%" + model.Name + "%' and number =@Number ");
MySqlParameter[] parameters =
{
new MySqlParameter("@Number", MySqlDbType.VarChar, 50),
};
parameters[0].Value = model.Number;
dt = SqlDbHelper.ExecuteDataTable(selectmes.ToString(), CommandType.Text, parameters);
return(dt);
}
private void button5_Click(object sender, EventArgs e)
{
BLL.Stumes stumes = new BLL.Stumes();
Model.Stumes model = new Model.Stumes();
model.Name = textBox2.Text.Trim();
model.Number = textBox1.Text.Trim();
model.Major = textBox4.Text.Trim();
model.Stuclass = textBox5.Text.Trim();
string mes = "";
if (stumes.update(model, UserName, out mes) == true)
{
MessageBox.Show("更新成功!");
}
else
{
MessageBox.Show(mes);
}
}
//上方第四个按钮，结果查询
private void button4_Click(object sender, EventArgs e)
{
panel1.Visible = false;
panel2.Visible = false;
panel5.Visible = false;
panel6.Visible = true;
panel1.Size = panel6.Size;
BLL.Stumes stumes = new BLL.Stumes();
Model.Stumes model = stumes.select(UserName);
textBox12.Text = model.Name;
textBox11.Text = model.Number;
textBox10.Text = model.Major;
textBox9.Text = model.Stuclass;
BLL.wish Wish = new BLL.wish();
Model.wish wishModel = Wish.select(UserName);
textBox5.Text = wishModel.First;
textBox6.Text = wishModel.Second;
textBox7.Text = wishModel.Third;
textBox8.Text = wishModel.Result;
}
public DataTable getmes(Model.Stumes model)
{
return(stumes.getmes(model));
}
