public void UpdatePwd(string pwd) { string sql = string.Format("update t_user set user_psd='{0}' where " + "user_id='{1}'", pwd, this.ID); SQLHelp.ExcuteUpdate(sql); }
//缺勤 public void Attentent() { string sql = string.Format("update t_sc set attendence_no='{0}' where stu_no='{1}'", AbsentNo + 1, StuID); this.AbsentNo++; SQLHelp.ExcuteUpdate(sql); }
//添加课程 public int AddCourse(string courseName, string courseNO) { string sql = string.Format("insert into t_course values('{0}','{1}','{2}')", courseNO, this.ID, courseName); return(SQLHelp.ExcuteUpdate(sql)); }
public void Update(string sql) { SQLHelp.ExcuteUpdate(sql); }