private void btnSave_Click(object sender, EventArgs e) { if (txtEmail.Text == "") { er++; ep.SetError(txtEmail, "Name Requered"); } if (txtTeacherId.Text == "") { er++; ep.SetError(txtTeacherId, "Teacher Id Required"); } if (txtContact.Text == "") { er++; ep.SetError(txtContact, "Contact Number Required"); } if (txtEamil.Text == "") { er++; ep.SetError(txtEamil, "Email Required"); } if (er == 0) { Hypertag.Advising.DAL.teacher teachers = new DAL.teacher(); teachers.Name = txtEmail.Text; teachers.contact = txtContact.Text; teachers.email = txtEamil.Text; if (teachers.Insert()) { MessageBox.Show("Data Saved"); txtEmail.Text = ""; txtTeacherId.Text = ""; txtContact.Text = ""; txtEamil.Text = ""; txtEmail.Focus(); } else { MessageBox.Show(teachers.Error); } } }
/// <summary> /// 核对用户信息 /// </summary> /// <param name="name"></param> /// <param name="pwd"></param> /// <param name="type"></param> /// <returns></returns> public LogState check_user_info(string stuNumber, string pwd, bool Type) { if (Type)//教师登录 { DAL.teacher dal = new DAL.teacher(); DataTable dt = dal.get_user_info(stuNumber.Trim()); if (dt.Rows.Count == 0) { return(LogState.None); } DataRow dr = dt.Rows[0]; if (dr[2].ToString().Trim() == pwd.Trim()) { return(LogState.teacherSuccess); } else { return(LogState.PwdErr); } } else { DAL.Admin dal = new DAL.Admin(); DataTable dt = dal.get_user_info(stuNumber.Trim()); if (dt.Rows.Count == 0) { return(LogState.None); } DataRow dr = dt.Rows[0]; if (dr[1].ToString().Trim() == pwd.Trim()) { return(LogState.adminSuccess); } else { return(LogState.PwdErr); } } }
private void frmTeacher_Load(object sender, EventArgs e) { DAL.teacher t = new DAL.teacher(); dgbTeacher.DataSource = t.Select().Tables[0]; }
public teacher() { dal = new DAL.teacher(siteConfig.sysdatabaseprefix); }