/// <summary>
/// 新增和修改教师信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ButtonOK_Click(object sender, EventArgs e)
{
TbTeacher teacher = new TbTeacher();
TbUser user = new TbUser();
user.Zt = int.Parse(userrole.SelectedValue);
user.Xh = "";
teacher.LsName = teachername.Text.Trim();
user.YhName = teacheruser.Text.Trim(); //用户名(账号)
user.YhPwd = System.Web.Security.FormsAuthentication.HashPasswordForStoringInConfigFile(teacherpwd.Text, "MD5"); //密码
teacher.ZyID = int.Parse(this.teacherzy.SelectedValue); //专业
teacher.Remark = textRemark.Text.Trim();
if (this.hidTeacherID.Value != "") /*用户编号不为空，即为修改时*/
{
teacher.YhID = int.Parse(this.hidTeacherID.Value);
user.YhID = teacher.YhID;
TbUserManager.UpdateUserRoleByYhID(user);
TbTeacherManager.UpdateTeacherInfoByYhID(teacher);
this.hidTeacherID.Value = "";
}
else
{
int yhid = TbUserManager.InsertTeacherUser(user.YhName, user.Xh, user.YhPwd, user.Zt);/*新增教师用户信息，返回其用户编号*/
if (yhid > 0)
{
int Result = TbTeacherManager.InsertTeacherInfo(yhid, teacher.LsName, teacher.ZyID, teacher.Remark);
}
}
teacherzy.Items.Clear();
GetSpeciality();
GetPageInfo();
teachername.Text = "";
teacherpwd.Text = "";
teacheruser.Text = "";
}
static int FirstSxNum = 0;/*声明变量，初始化为0，用于判断筛选条件是否改变*/
/// <summary>
/// 获取页面信息
/// </summary>
public void GetPageInfo()
{
string lsname = this.txtTeacherName.Value.Trim() == "按教师名、用户名、专业名模糊查找" ? "" : this.txtTeacherName.Value.Trim();
if (lsname != "按教师名、用户名、专业名模糊查找" && lsname != "" && FirstSxNum == 0)
{
nowPage = 1;
FirstSxNum = 1;
}
Record = TbTeacherManager.GetAllTeachersInfo(lsname).Rows.Count;;/*记录总数*/
TeacherList = TbTeacherManager.GetAllTeacherInfoPage(len, nowPage, lsname);
if (Record == 0)
{
Pages = 1;
}
else
{
if (Record % len == 0)
{
Pages = (Record / len);
}
else
{
Pages = (Record / len) + 1;
}
}
}
public static int maxPage = 0; //定义显示页面的最大页数，初始化为0
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie usercookie = Request.Cookies["nowloginuser"];
string url = PublicClass.CheckLogin(usercookie, "main");
if (url != "")
{
Response.Write(url);
return;
}
if (!IsPostBack)
{
string zyid = Request["ZyID"];
if (zyid != null)
{
//判断是否存在科目信息,存在则提示不能删除专业信息，不存在则执行删除操作
if (TbSubjectManager.QuerySubjectInfo(int.Parse(zyid)) <= 0)
{
//根据专业ID删除班级、老师信息表以及专业信息表对应的信息
TbClassManager.DeleteClassByZyID(int.Parse(zyid));
TbTeacherManager.DeleteTeaByZyID(int.Parse(zyid));
TbSpecialityManager.DeleteSpecByZyID(int.Parse(zyid));
}
else
{
Page.RegisterStartupScript("", "<script>alert('存在专业对应的科目信息，如需继续执行删除操作，请先删除科目信息！')</script>");
}
}
GetAllSpenIntoCount();
}
}
/// <summary>
/// 根据教师编号LsID查询对应的详细信息
/// </summary>
/// <param name="LsID"></param>
private void GetTeacher(int YhID)
{
TbTeacher teacher = TbTeacherManager.GetTeacherInfoByLsID(YhID);
TbUser user = TbUserManager.GetUserInfoByYhID(YhID);
string role = "";
if (user.Zt == 1)
{
role = "管理员";
}
else
{
role = "教师";
}
TbSpeciality speciality = TbSpecialityManager.GetSpecialByID(teacher.ZyID);
string message = teacher.YhID + "|" + teacher.LsName + "|" + user.YhName + "|" + user.YhPwd + "|" + role + "|" + speciality.ZyName + "|" + teacher.Remark;
Response.Write(message);
}
public static int Record = 0; //定义当前符号查询的记录总数，初始化为0
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie usercookie = Request.Cookies["nowloginuser"];
string url = PublicClass.CheckLogin(usercookie, "main");
if (url != "")
{
Response.Write(url);
return;
}
if (!IsPostBack)
{
string lsid = Request["LsID"];
if (lsid != null)
{
int yhid = TbUserManager.GetTeacherUserYhID(int.Parse(lsid)); //根据教师编号LsID得到对应的用户编号
TbTeacherManager.DeleteTeacherInfo(int.Parse(lsid)); //根据教师编号LsID删除对应教师信息
TbUserManager.DeleteUserByYhID(yhid); //根据用户编号删除教师对应的用户信息
}
GetPageInfo();
GetSpeciality();
}
}
