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