protected void btn_upteacher_Click(object sender, EventArgs e)//将教师身份修改为系部管理员身份
{
lbl_fankui.Text = "";
string xibuid = DDLView3xibu.SelectedValue;
string username = DDL_v3_teacher.SelectedValue;
if (TeacherInfo.IsSuperManager(username))
{
lbl_fankui.Text = "该教师是系统管理员，不能修改为系部管理员，操作失败！";
}
else
{
string txingming = DDL_v3_teacher.SelectedItem.Text;
string xibuname = DDLView3xibu.SelectedItem.Text;
string sqltxt = "update tb_teacher set manager='manager',guanlixibuid=@xibuid where username=@username";
SqlParameter[] pa = new SqlParameter[2];
pa[0] = new SqlParameter("@username", username);
pa[1] = new SqlParameter("@xibuid", xibuid);
try
{
SqlHelper.ExecuteNonQuery(SqlDal.conn, CommandType.Text, sqltxt, pa);
lbl_fankui.Text = "将教师：" + txingming + "修改为系部：" + xibuname + "的管理员，成功！";
}
catch (Exception ex)
{
lbl_fankui.Text = "将教师：" + txingming + "修改为系部：" + xibuname + "的管理员，失败，详情：" + ex.Message;
}
}
}
protected void btn_delgly_Click(object sender, EventArgs e)
{
lbl_fankui.Text = "";
string username = ddl_v4gly.SelectedValue;
if (TeacherInfo.IsSuperManager(username))//判断是否系统管理员
{
lbl_fankui.Text = "该教师是系统管理员，不能删除其系统管理员身份！";
}
else
{
string xingming = ddl_v4gly.SelectedItem.Text;
string xibuid = ddl_v4xibu.SelectedValue;
string xibuname = ddl_v4xibu.SelectedItem.Text;
string sqltxt = "update tb_teacher set manager='',guanlixibuid=-1 where username=@username";
SqlParameter[] pa = new SqlParameter[1];
pa[0] = new SqlParameter("@username", username);
try
{
SqlHelper.ExecuteNonQuery(SqlDal.conn, CommandType.Text, sqltxt, pa);
lbl_fankui.Text = "已将" + xibuname + "的管理员" + xingming + "的管理员身份删除，保留其教师身份。";
}
catch (Exception ex)
{
lbl_fankui.Text = "管理员删除失败，详情：" + ex.Message;
}
}
}
protected void grv_v2renke_DataBound(object sender, EventArgs e)
{
string username = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
if (!TeacherInfo.IsSuperManager(username))
{
string guanlixibuid = TeacherInfo.managerXibu(username);
if (guanlixibuid != ddl_v2xibu.SelectedValue)
{
grv_v2renke.Columns[3].Visible = false;
}
}
}
protected void DropDownList1_DataBound(object sender, EventArgs e)
{
string username = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
if (!TeacherInfo.IsSuperManager(username))
{
string guanlixibuid = TeacherInfo.managerXibu(username);
if (guanlixibuid != "0")
{
DropDownList1.SelectedValue = guanlixibuid;
DropDownList1.Enabled = false;
}
}
}
protected void LinkButton4_Click(object sender, EventArgs e)
{
lbl_fankui.Text = "";
string username = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
if (TeacherInfo.IsSuperManager(username))
{
MultiView1.ActiveViewIndex = 2;
}
else
{
ScriptManager.RegisterClientScriptBlock(this, typeof(string), "", "<script>alert('您无权进行此操作！');</script>", false);
}
}
protected void GridView1_DataBound(object sender, EventArgs e)
{
string username = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
if (TeacherInfo.IsSuperManager(username))
{
GridView1.Columns[1].Visible = true;
}
else
{
string guanlixibuid = TeacherInfo.managerXibu(username);
if (guanlixibuid == DropDownList3.SelectedValue)
{
GridView1.Columns[1].Visible = true;
}
else
{
GridView1.Columns[1].Visible = false;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string username = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
Button1.Enabled = GridView1.Columns[1].Visible = TeacherInfo.IsSuperManager(username);
}
protected void GridView1_DataBound(object sender, EventArgs e)
{
string username = ((FormsIdentity)HttpContext.Current.User.Identity).Ticket.Name;
GridView1.Columns[6].Visible = TeacherInfo.IsSuperManager(username);
}
