protected DataSet getRoleID(string tem, string SParentCode)
{
if (tem != "")
{
string[] tems = tem.Split(',');
string strWhere = " RoleID in ("; //拼接查询条件
for (int i = 0; i < tems.Length; i++)
{
if (i < tems.Length - 1)
{
strWhere = strWhere + tems[i] + ",";
}
else
{
strWhere = strWhere + tems[i];
}
}
strWhere += ")";
Tz888.BLL.Sys.SysPermissionTab sysPerm = new Tz888.BLL.Sys.SysPermissionTab();
DataSet ds = sysPerm.GetList(strWhere);
string spCode = ""; //获取所有的菜单码
if (ds.Tables[0] != null)
{
for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
{
spCode = spCode + ds.Tables[0].Rows[j]["SPCode"].ToString();
}
}
//拼接菜单码查询条件
string strspCode = " scode in (";
string[] strspCodes = spCode.Split(',');
for (int f = 0; f < strspCodes.Length; f++)
{
if (strspCode.IndexOf(strspCodes[f].Trim()) < 0)
{
strspCode = strspCode + "'" + strspCodes[f] + "',";
}
}
strspCode = strspCode.Substring(0, strspCode.Length - 1) + ") and sparentcode = '" + SParentCode + "'";
Tz888.BLL.Sys.SysMenuTab sysMenu = new Tz888.BLL.Sys.SysMenuTab();
return(sysMenu.GetList(strspCode));
}
else
{
return(null);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Request.UrlReferrer != null)
{
ViewState["url"] = Request.UrlReferrer.ToString();
}
else
{
ViewState["url"] = "MenuList1.aspx";
}
//删除一三级菜单
if (Request.QueryString["sid"] != null && Request.QueryString["sid"] != "")
{
int sid = int.Parse(Request.QueryString["sid"].ToString());
Tz888.BLL.Sys.SysMenuTab bll = new Tz888.BLL.Sys.SysMenuTab();
if (bll.Delete(sid))
{
Response.Redirect(ViewState["url"].ToString());
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Msg", "<script>alert('删除失败!');location.href='" + ViewState["url"].ToString() + "';</script>", false);
//Response.Write("<script>alert('删除失败');location.href='" + ViewState["url"].ToString() + "';</script>");
}
}
//删除二级菜单
if (Request.QueryString["sid2"] != null && Request.QueryString["sid2"] != "")
{
int sid = int.Parse(Request.QueryString["sid2"].ToString());
Tz888.BLL.Sys.SysMenuTab bll = new Tz888.BLL.Sys.SysMenuTab();
if (bll.Delete1(sid))
{
Response.Redirect(ViewState["url"].ToString());
}
else
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Msg", "<script>alert('删除失败!');location.href='" + ViewState["url"].ToString() + "';</script>", false);
}
}
}
}