public int InsertStuInfo(StuInfo stu) { string sql = @"INSERT INTO scoremanagement.`stu_info`(`id`, `name`, `major_id`, `gender`, `remark`, `birth`, `totalscore`) VALUES (@para1, @para2, ( SELECT id FROM scoremanagement.`major` ma WHERE ma.`name` = @para3 ), @para4, @para5, STR_TO_DATE(@para6,'%Y/%m/%d'), @para7);"; return(this.ExecNonQuery(sql, stu.id, stu.name, stu.major, stu.gender, stu.remark, stu.birth, stu.totalScore.ToString())); }
public bool GetOneStuInfoStruct(string id, ref StuInfo stu) { DataSet dataSet = this.GetAllStuInfo(id, "%", "%"); try { stu.id = dataSet.Tables[0].Rows[0][0].ToString(); stu.name = dataSet.Tables[0].Rows[0][1].ToString(); stu.major = dataSet.Tables[0].Rows[0][2].ToString(); stu.gender = dataSet.Tables[0].Rows[0][3].ToString(); stu.birth = dataSet.Tables[0].Rows[0][4].ToString(); stu.totalScore = Convert.ToSingle(dataSet.Tables[0].Rows[0][5]); stu.remark = dataSet.Tables[0].Rows[0][6].ToString(); return(true); } catch { return(false); } }
public int UpdateStuInfo(StuInfo stu) { string sql = @"UPDATE scoremanagement.`stu_info` st SET st.`name` = @para1, st.`gender` = @para2, st.`birth` = STR_TO_DATE(@para3,'%Y/%m/%d'), st.`major_id` = ( SELECT id FROM scoremanagement.`major` ma WHERE ma.`NAME` = @para4 ), st.`totalscore` = @para5, st.`remark` = @para6 WHERE st.`id` = @para7;" ; return(this.ExecNonQuery(sql, stu.name, stu.gender, stu.birth, stu.major, stu.totalScore.ToString(), stu.remark, stu.id)); }
private void buttonCancel_Click(object sender, EventArgs e) { StuInfo stu = new StuInfo(); this.setStuInfo(stu); }