protected void DropDownList_class_SelectedIndexChanged(object sender, EventArgs e)
{
CourseTableBLL ctBLL = new CourseTableBLL();
CourseBLL courBLL = new CourseBLL();
TeacherBLL teachBLL = new TeacherBLL();
DropDownList_course.Items.Clear();
DropDownList_course.DataSource = courBLL.getByClassId(DropDownList_class.SelectedValue);
DropDownList_course.DataTextField = "name";
DropDownList_course.DataValueField = "ID";
DropDownList_course.DataBind();
DropDownList_teacher.Items.Clear();
string filterTeacher = "classID='" + DropDownList_class.SelectedValue + "' and courId='" + DropDownList_course.SelectedValue + "'";
DataTable tempDt = PageUtil.getProcessedDataTable(ctBLL.getAll().Tables[0], filterTeacher, null, false);
DataView dv = tempDt.DefaultView;
tempDt = dv.ToTable(true, "teachID");
foreach (DataRow dr in tempDt.Rows)
{
Teacher teacher = teachBLL.get(dr["teachID"].ToString());
DropDownList_teacher.Items.Add(new ListItem(teacher.Name, teacher.Id));
}
bind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ClassBLL classBLL = new ClassBLL();
CourseBLL courBLL = new CourseBLL();
TeacherBLL teachBLL = new TeacherBLL();
//绑定页面查询条件的数据
DropDownList_class.DataSource = classBLL.getAll();
DropDownList_class.DataTextField = "name";
DropDownList_class.DataBind();
DropDownList_class.Items.Insert(0, "全部班级");
DropDownList_course.DataSource = courBLL.getAll();
DropDownList_course.DataTextField = "name";
DropDownList_course.DataBind();
DropDownList_course.Items.Insert(0, "全部课程");
DropDownList_teacher.DataSource = teachBLL.getTeachers();
DropDownList_teacher.DataTextField = "name";
DropDownList_teacher.DataBind();
DropDownList_teacher.Items.Insert(0, "全部教师");
bind();
}
}
protected void ImageButton_submit_Click(object sender, ImageClickEventArgs e)
{
if (check())
{
TeacherBLL teachBLL = new TeacherBLL();
string name = TextBox_name.Text.Trim();
string gender = RadioButton_male.Checked ? "男" : "女";
string birth = DropDownList_yearPart1.SelectedValue + DropDownList_yearPart2.SelectedValue + DropDownList_yearPart3.SelectedValue + DropDownList_yearPart4.SelectedValue;
birth += DropDownList_month.SelectedValue;
string title = DropDownList_title.SelectedValue;
string phone = TextBox_phone.Text.Trim();
string email = TextBox_email.Text.Trim();
if (!teacher.Title.Equals(title))
{
UserBLL userBLL = new UserBLL();
User user = userBLL.get(teacher.UserID);
user.Type = title.Equals("辅导员") ? "2" : "1";
userBLL.update(user);
}
teacher.Name = name;
teacher.Gender = gender;
teacher.Birth = birth;
teacher.Title = title;
teacher.Phone = phone;
teacher.Email = email;
teachBLL.update(teacher);
Response.Write("<script>alert('修改成功！');location.href='showTeachers.aspx';</script>");
}
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
string id = Request.QueryString["id"].ToString();
AttendanceBLL attendBLL = new AttendanceBLL();
attend = attendBLL.get(id);
CourseTableBLL ctBLL = new CourseTableBLL();
CourseTable ct = ctBLL.get(attend.CourTableID);
ClassBLL classBLL = new ClassBLL();
TeacherBLL teacherBLL = new TeacherBLL();
CourseBLL courseBLL = new CourseBLL();
StudentBLL stuBLL = new StudentBLL();
#region 绑定页面数据
Label_class.Text = classBLL.get(ct.ClassID).Name;
Label_course.Text = courseBLL.get(ct.CourId).Name;
Label_teacher.Text = teacherBLL.get(ct.TeachID).Name;
Label_student.Text = stuBLL.get(attend.StudID).Name;
Label_oldStatus.Text = attend.Status;
Label_week.Text = ct.Week;
Label_weekDay.Text = ct.WeekDay;
Label_courseTime.Text = ct.CourseTime;
Label_place.Text = ct.Place;
#endregion
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
string courTableID = Request.QueryString["courTableID"];
CourseTableBLL ctBLL = new CourseTableBLL();
TeacherBLL teacherBLL = new TeacherBLL();
CourseBLL courBLL = new CourseBLL();
ClassBLL classBLL = new ClassBLL();
CourseTable ct = ctBLL.get(courTableID);
Class clazz = classBLL.get(ct.ClassID);
#region 页面数据绑定
className.Text = clazz.Name;
courseName.Text = courBLL.get(ct.CourId).Name;
teacherName.Text = teacherBLL.get(ct.TeachID).Name;
week.Text = "第" + ct.Week + "周";
weekDay.Text = ct.WeekDay;
classtTime.Text = ct.CourseTime;
classAddress.Text = ct.Place;
CommonBLL commBLL = new CommonBLL();
DataTable dt = commBLL.getAbsentStudent(courTableID,false);
AspNetPager1.RecordCount = dt.Rows.Count;
int from = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1;
int to = from + AspNetPager1.PageSize - 1 > AspNetPager1.RecordCount ? AspNetPager1.RecordCount : from + AspNetPager1.PageSize - 1;
GridView1.DataSource = PageUtil.getPaged(dt, from, to);
GridView1.DataBind();
#endregion
}
public static TeacherBLL getInstance()
{
if (instace == null)
{
instace = new TeacherBLL();
}
return(instace);
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
TeacherBLL teachBLL = new TeacherBLL();
DropDownList_teacher.DataSource = teachBLL.getClassTeachers();
DropDownList_teacher.DataTextField = "name";
DropDownList_teacher.DataValueField = "ID";
DropDownList_teacher.DataBind();
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
User user = Session["User"] as User;
TeacherBLL teacherBLL = new TeacherBLL();
Teacher teacher = teacherBLL.getByUserId(user.Id);
CommonBLL commBLL = new CommonBLL();
GridView1.DataSource = commBLL.getClassesByTeacherId(teacher.Id);
GridView1.DataBind();
}
protected void ImageButton_submit_Click(object sender, ImageClickEventArgs e)
{
if (check())
{
TeacherBLL teachBLL = new TeacherBLL();
UserBLL userBLL = new UserBLL();
string teachId = TextBox_teachId.Text.Trim();
string name = TextBox_name.Text.Trim();
string gender = RadioButton_male.Checked ? "男" : "女";
string birth = DropDownList_yearPart1.SelectedValue + DropDownList_yearPart2.SelectedValue + DropDownList_yearPart3.SelectedValue + DropDownList_yearPart4.SelectedValue;
birth += DropDownList_month.SelectedValue;
string title = DropDownList_title.SelectedValue;
string phone = TextBox_phone.Text.Trim();
string email = TextBox_email.Text.Trim();
if (teachBLL.getByTeacherId(teachId) == null)
{
if (userBLL.getByUsername(teachId) == null)
{
#region 在用户表中创建新用户
User user = new User();
user.UserName = teachId;
user.Password = EncryptUtil.MD5Encrypt("12345678");
user.Type = title.Equals("辅导员") ? "2" : "1";
userBLL.save(user);
#endregion
Teacher teacher = new Teacher();
teacher.TeacherId = teachId;
teacher.Name = name;
teacher.Gender = gender;
teacher.Birth = birth;
teacher.Title = title;
teacher.Phone = phone;
teacher.Email = email;
teacher.UserID = userBLL.getByUsername(teachId).Id;
teachBLL.save(teacher);
Response.Write("<script>alert('添加成功！');location.href='addTeacher.aspx';</script>");
}
else
Response.Write("<script>alert('添加失败，用户名已存在！');location.href='addTeacher.aspx';</script>");
}
else
{
checkTeachId.ErrorMessage = "教师号已存在！";
checkTeachId.IsValid = false;
}
}
}
public void bind()
{
courTableID = Request.QueryString["courTableID"];
User user = Session["User"] as User;
TeacherBLL teachBLL = new TeacherBLL();
StudentBLL studBLL = new StudentBLL();
CourseTableBLL ctBLL = new CourseTableBLL();
CourseTable ct = ctBLL.get(courTableID);
ClassBLL classBll = new ClassBLL();
Class cla = classBll.get(ct.ClassID);
className.Text = cla.Name;
dt = studBLL.getByClassId(ct.ClassID).Tables[0];
if (Session["attenList"] != null)
{
attenList = Session["attenList"] as List<Attendance>;
}
else
{
attenList = new List<Attendance>();
foreach (DataRow dr in dt.Rows)
{
Attendance attend = new Attendance();
attend.Status = "正常";
attend.Remark = "";
attend.Recorder = "教师";
attend.RecorderID = teachBLL.getByUserId(user.Id).Id;
attend.StudID = dr["ID"].ToString();
attend.CourTableID = courTableID;
attenList.Add(attend);
}
}
AspNetPager1.RecordCount = dt.Rows.Count;
int from = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1;
int to = from + AspNetPager1.PageSize - 1 > AspNetPager1.RecordCount ? AspNetPager1.RecordCount : from + AspNetPager1.PageSize - 1;
GridView1.DataSource = PageUtil.resort(PageUtil.getPaged(dt, from, to));
GridView1.DataBind();
initStatusAndRemark();
}
public void bind()
{
User user = (User)Session["user"];
TeacherBLL teacherBll = new TeacherBLL();
Teacher teacher = teacherBll.getByUserId(user.Id);
CommonBLL commonBll = new CommonBLL();
DataTable dt = commonBll.getAllRecordByRecordId(teacher.Id);
AspNetPager1.RecordCount = dt.Rows.Count;
int from = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1;
int to = from + AspNetPager1.PageSize - 1 > AspNetPager1.RecordCount ? AspNetPager1.RecordCount : from + AspNetPager1.PageSize - 1;
GridView1.DataSource = PageUtil.getPaged(dt, from, to);
GridView1.DataBind();
}
protected void ImageButton_delete_Click(object sender, ImageClickEventArgs e)
{
ImageButton imageButton = sender as ImageButton;
string id = imageButton.CommandArgument;
TeacherBLL teachBLL = new TeacherBLL();
UserBLL userBLL = new UserBLL();
Teacher teacher = teachBLL.get(id);
User user = userBLL.get(teacher.UserID);
teachBLL.delete(teacher);
userBLL.delete(user);
Response.Write("<script>alert('删除成功！');location.href='showTeachers.aspx';</script>");
}
private void bind()
{
string id = Request.QueryString["id"].ToString();
TeacherBLL teachBLL = new TeacherBLL();
teacher = teachBLL.get(id);
Label_teachId.Text = teacher.TeacherId;
TextBox_name.Text = teacher.Name;
if (teacher.Gender.Equals("女")) RadioButton_female.Checked = true;
PageUtil.bindDropDownList(DropDownList_yearPart1, teacher.Birth[0].ToString());
PageUtil.bindDropDownList(DropDownList_yearPart2, teacher.Birth[1].ToString());
PageUtil.bindDropDownList(DropDownList_yearPart3, teacher.Birth[2].ToString());
PageUtil.bindDropDownList(DropDownList_yearPart4, teacher.Birth[3].ToString());
PageUtil.bindDropDownList(DropDownList_month, teacher.Birth.Substring(4, 2));
PageUtil.bindDropDownList(DropDownList_title, teacher.Title);
TextBox_phone.Text = teacher.Phone;
TextBox_email.Text = teacher.Email;
}
private void bind()
{
User user = (User)Session["user"];
TeacherBLL teachBll = new TeacherBLL();
Teacher teacher = teachBll.getByUserId(user.Id);
CommonBLL commonBll = new CommonBLL();
// 根据教师ID得到课程信息
string filter = "1=1";
filter += weekId.SelectedIndex == 0 ? "" : " and week='" + weekId.SelectedValue + "'";
DataTable dt = PageUtil.getProcessedDataTable(commonBll.getWorkAttendanceByTeachID(teacher.Id), filter);
AspNetPager1.RecordCount = dt.Rows.Count;
int from = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1;
int to = from + AspNetPager1.PageSize - 1 > AspNetPager1.RecordCount ? AspNetPager1.RecordCount : from + AspNetPager1.PageSize - 1;
GridView1.DataSource = PageUtil.getPaged(dt, from, to);
GridView1.DataBind();
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
string studID = Request.QueryString["studID"].ToString();
CommonBLL commBLL = new CommonBLL();
User user = (User)Session["user"];
TeacherBLL teacherBll = new TeacherBLL();
Teacher teacher = teacherBll.getByUserId(user.Id);
string filter = "teacherID='" + teacher.Id + "'";
DataTable dt = PageUtil.getProcessedDataTable(commBLL.getDetailStudentAttendStatistics(studID, true), filter);
AspNetPager1.RecordCount = dt.Rows.Count;
int from = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1;
int to = from + AspNetPager1.PageSize - 1 > AspNetPager1.RecordCount ? AspNetPager1.RecordCount : from + AspNetPager1.PageSize - 1;
GridView1.DataSource = PageUtil.getPaged(dt, from, to);
GridView1.DataBind();
}
public void bind()
{
List<Attendance> attenList = Session["attenList"] as List<Attendance>;
CourseTableBLL ctBLL = new CourseTableBLL();
TeacherBLL teachBll = new TeacherBLL();
CourseBLL courBLL = new CourseBLL();
ClassBLL classBLL = new ClassBLL();
CourseTable ct = ctBLL.get(attenList[0].CourTableID);
Class clazz = classBLL.get(ct.ClassID);
#region 页面数据绑定
className.Text = clazz.Name;
courseName.Text = courBLL.get(ct.CourId).Name;
teacherName.Text = teachBll.get(ct.TeachID).Name;
week.Text = "第" + ct.Week + "周";
weekDay.Text = ct.WeekDay;
classtTime.Text = ct.CourseTime;
classAddress.Text = ct.Place;
lateNumber.Text = attenList.Where(x => x.Status.Equals("迟到")).ToList().Count.ToString();
absences.Text = attenList.Where(x => !x.Status.Equals("正常")).ToList().Count.ToString();
allNumber.Text = clazz.StudCount;
attRate.Text = FormatUtil.doubleToPercent(attenList.Where(x => x.Status.Equals("正常")).ToList().Count / Convert.ToDouble(clazz.StudCount));
DataTable dt = transferListToDataTable(attenList);
AspNetPager1.RecordCount = dt.Rows.Count;
int from = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1;
int to = from + AspNetPager1.PageSize - 1 > AspNetPager1.RecordCount ? AspNetPager1.RecordCount : from + AspNetPager1.PageSize - 1;
GridView1.DataSource = PageUtil.resort(PageUtil.getPaged(dt, from, to));
GridView1.DataBind();
#endregion
}
public void bind()
{
string classID = Request.QueryString["classID"].ToString();
string courID = Request.QueryString["courId"].ToString();
//courseName.Text = new CourseBLL().get(courID).Name;//courseName改成className
className.Text = new ClassBLL().get(classID).Name;
User user = (User)Session["user"];
TeacherBLL teacherBll = new TeacherBLL();
Teacher teacher = teacherBll.getByUserId(user.Id);
CommonBLL commBLL = new CommonBLL();
DataTable dt = commBLL.getClassStudentAttendStatistics(classID,teacher.Id, true);
AspNetPager1.RecordCount = dt.Rows.Count;
int from = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1;
int to = from + AspNetPager1.PageSize - 1 > AspNetPager1.RecordCount ? AspNetPager1.RecordCount : from + AspNetPager1.PageSize - 1;
GridView1.DataSource = PageUtil.getPaged(dt, from, to);
GridView1.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["User"] != null)
{
string username = "";
User user = Session["User"] as User;
int type = Convert.ToInt32(user.Type);
switch (type)
{
case 1:
username = new TeacherBLL().getByUserId(user.Id).Name;
break;
case 2:
username = new TeacherBLL().getByUserId(user.Id).Name;
break;
case 3:
username = new StudentBLL().getByUserId(user.Id).Name;
break;
case 4:
username = new StudentBLL().getByUserId(user.Id).Name;
break;
case 5:
username = new StaffBLL().getByUserId(user.Id).Name;
break;
case 6:
username = new StaffBLL().getByUserId(user.Id).Name;
break;
}
Label_username.Text = username;
}
}
}
//Update:
private void btnModify_Click(object sender, EventArgs e)
{
if (txtTeaNum.Text == "" || txtTeaName.Text == "")
{
MessageBox.Show("工号和姓名都不能为空！\n 请重新输入！");
}
else
{
TeacherBLL objTeacherBLL = new TeacherBLL();
TeacherModel objTeacherModel = new TeacherModel();
objTeacherModel.TeaAdress = txtTeaAddress.Text;
objTeacherModel.TeaName = txtTeaName.Text;
objTeacherModel.TeaNum = txtTeaNum.Text;
objTeacherModel.TeaPhone = txtTeaPhone.Text;
objTeacherModel.TeaTitle = txtTeaTitle.Text;
objTeacherModel.TeaSex = cbxTeaSex.Text;
objTeacherModel.TeaTitle = txtTeaTitle.Text;
if (objTeacherBLL.UpdateTea(objTeacherModel)==true)
{
MessageBox.Show("增加成功！");
}
else
MessageBox.Show("增加失败！");
}
ShowTable();
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
CourseBLL courBLL = new CourseBLL();
TeacherBLL teacherBLL = new TeacherBLL();
ClassBLL classBLL = new ClassBLL();
//绑定 "课程名称" 数据源
DropDownList_course.DataSource = courBLL.getAll();
DropDownList_course.DataTextField = "name";
DropDownList_course.DataValueField = "ID";
DropDownList_course.DataBind();
//绑定 "任课老师" 数据源
DropDownList_teacher.DataSource = teacherBLL.getTeachers();
DropDownList_teacher.DataTextField = "name";
DropDownList_teacher.DataValueField = "ID";
DropDownList_teacher.DataBind();
//绑定 "班级名称" 数据源
DropDownList_class.DataSource = classBLL.getAll();
DropDownList_class.DataTextField = "name";
DropDownList_class.DataValueField = "ID";
DropDownList_class.DataBind();
}
//Del:
private void btnDel_Click(object sender, EventArgs e)
{
TeacherBLL objTeacherBLL = new TeacherBLL();
TeacherModel objTeacherModel = new TeacherModel();
objTeacherModel.TeaNum = txtTeaNum.Text;
if (objTeacherBLL.DeleteTeacher(objTeacherModel)==true)
{ MessageBox.Show("数据删除成功"); }
else
{ MessageBox.Show("数据删除失败"); }
ShowTable();
}
/// <summary>
/// 绑定数据源
/// </summary>
private void bind()
{
string id = Request.QueryString["ID"].ToString();
string week = Request.QueryString["week"].ToString();
CourseBLL courBLL = new CourseBLL();
TeacherBLL teacherBLL = new TeacherBLL();
ClassBLL classBLL = new ClassBLL();
CourseTableBLL ctBLL = new CourseTableBLL();
ct = ctBLL.get(id);
#region 页面数据绑定
Label_course.Text = courBLL.get(ct.CourId).Name;
Label_teacher.Text = teacherBLL.get(ct.TeachID).Name;
Label_class.Text = classBLL.get(ct.ClassID).Name;
PageUtil.bindDropDownList(DropDownList_semester_from, ct.Semester.Substring(0, 4));
PageUtil.bindDropDownList(DropDownList_semester_to, ct.Semester.Substring(5, 4));
PageUtil.bindDropDownList(DropDownList_semester_end, ct.Semester.Substring(9, 3));
PageUtil.bindDropDownList(DropDownList_week_from, week.Split('-')[0]);
PageUtil.bindDropDownList(DropDownList_week_to, week.Split('-')[1]);
PageUtil.bindDropDownList(DropDownList_weekDay, ct.WeekDay);
TextBox_place.Text = ct.Place;
PageUtil.bindDropDownList(DropDownList_courseTime, ct.CourseTime.Split('节')[0]);
#endregion
}
//Search:
private void btnSearch_Click(object sender, EventArgs e)
{
dgvTeacherInfo.DataSource=0;
if (txtTeaNum.Text == "")
{
MessageBox.Show("请先输入工号\n！");
}
else
{
TeacherModel objTeacherModel = new TeacherModel();
objTeacherModel.TeaNum = txtTeaNum.Text;
TeacherBLL objTeacherBLL = new TeacherBLL();
dgvTeacherInfo.DataSource = objTeacherBLL.SearchTea(objTeacherModel);
}
}
//Add:
private void btnAdd_Click(object sender, EventArgs e)
{
#region sql语句进行添加，已注释
//TeacherBLL objTeacherBLL = new TeacherBLL();
//TeacherModel Teacher = new TeacherModel();
//Teacher.TeaNum = txtNum.Text ;
//Teacher.TeaName = txtName.Text;
//Teacher.TeaSex = cmbSex.Text;
//Teacher.TeaAdress = txtAdress.Text;
//Teacher.TeaPhone = txtPhone.Text;
//Teacher.TeaTitle = txtTitle.Text;
//if(objTeacherBLL.AddTeacher(Teacher)==true)
// MessageBox.Show("数据添加成功");
//else
// MessageBox.Show("数据添加失败");
//dgvTeacherInfo.DataSource = objTeacherBLL.ShowTeacher();
#endregion
#region //存储过程 已注释
////SqlConnection objConn = new SqlConnection("Data Source=.\\SQLExpress;Initial Catalog=StuManageSystem_2008;Integrated Security=True");
////objConn.Open();
////SqlCommand objSqlCommand = new SqlCommand();
//objSqlCommand.Connection = objConn;
//objSqlCommand.CommandType = CommandType.StoredProcedure;
//objSqlCommand.CommandText = "Teachers";
//objSqlCommand.Parameters.Add("@TeaName", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaName"].Value = txtName.Text;
//objSqlCommand.Parameters.Add("@Sex", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaSex"].Value = txtSex.Text;
//objSqlCommand.Parameters.Add("@TeaAdress", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaAdress"].Value = txtAdress.Text;
//objSqlCommand.Parameters.Add("@TeaPhone", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaPhone"].Value = txtPhone.Text;
//objSqlCommand.Parameters.Add("@TeaTitle", SqlDbType.NChar, 10);
//objSqlCommand.Parameters["@TeaTitle"].Value = txtTitle.Text;
//if (objSqlCommand.EndExecuteNonQuery() > 0)
// MessageBox.Show("添加成功");
//else MessageBox.Show("添加失败");
//objConn.Close();
//调用类的后半段
//string SqlString = "select*from dbo.Teacher";
// dgvTeacherInfo.DataSource = objDataBase.GetDataSet(SqlString).Tables[0];
//SqlCommand objSqlCommand = new SqlCommand();
//objSqlCommand.CommandType = CommandType.StoredProcedure;
//objSqlCommand.CommandText = "studentInsert";
//objSqlCommand.Parameters.AddWithValue("@TeaNum", txtNum.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaName", txtName.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaSex", cmbSex.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaAdress ", txtAdress.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaPhone", txtPhone.Text);
//objSqlCommand.Parameters.AddWithValue("@TeaTitle", txtTitle.Text);
//SQLClass1 objdatabase = new SQLClass1();
//if (objdatabase.GetExecute1(objSqlCommand))
// MessageBox.Show("添加成功");
//else
// MessageBox.Show("添加失败");
//showDGV();
#endregion
if (txtTeaNum.Text=="" || txtTeaName.Text == "")
{
MessageBox.Show("工号和姓名都不能为空！\n 请重新输入！");
}
else
{
TeacherBLL objTeacherBLL = new TeacherBLL();
TeacherModel objTeacherModel = new TeacherModel();
objTeacherModel.TeaAdress = txtTeaAddress.Text;
objTeacherModel.TeaName = txtTeaName.Text;
objTeacherModel.TeaNum = txtTeaNum.Text;
objTeacherModel.TeaPhone = txtTeaPhone.Text;
objTeacherModel.TeaTitle = txtTeaTitle.Text;
objTeacherModel.TeaSex = cbxTeaSex.Text;
objTeacherModel.TeaTitle = txtTeaTitle.Text;
if (objTeacherBLL.AddTeacher(objTeacherModel) == true)
{
MessageBox.Show("增加成功！");
}
else
MessageBox.Show("增加失败！");
ShowTable();
}
}
private void ShowTable()
{
TeacherBLL objTeacherBLL = new TeacherBLL();
dgvTeacherInfo.DataSource = objTeacherBLL.ShowTeacher();
}
