|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/8346f1f3/9c1cfaad/ |
?#pragma checksum "D:\wwwroot\bujuan\wwwroot\SystemSet\SelectMenu.aspx.cs" "{ff1816ec-aa5e-4d10-87f7-6f4963833460}" "9A434BB5EE154F07BA296E937274C042FF29A8C3"
#line 1 "D:\wwwroot\bujuan\wwwroot\SystemSet\SelectMenu.aspx.cs"
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
namespace EasyExam.SystemSet
{
/// <summary>
/// SelectMenu 的提要注明。
/// </summary>
public partial class SelectMenu : System.Web.UI.Page
{
string strSql="";
string myUserID="";
string myLoginID="";
PublicFunction ObjFun=new PublicFunction();
int intUserID=0;
bool bJoySoftware=false;
#region//*********初始信息*******
protected void Page_Load(object sender, System.EventArgs e)
{
try
{
myUserID=Session["UserID"].ToString();
myLoginID=Session["LoginID"].ToString();
}
catch
{
}
if (myLoginID=="")
{
Response.Redirect("../Login.aspx");
}
//断根缓存
Response.Expires=0;
Response.Buffer=true;
Response.Clear();
intUserID=Convert.ToInt32(Request["UserID"]);
bJoySoftware=ObjFun.JoySoftware();
if (!IsPostBack)
{
if (Convert.ToInt32(ObjFun.GetValues("select RoleMenu from UserInfo where UserID="+intUserID+"","RoleMenu"))==1)
{
rbAllMenu.Checked=true;
rbSelectMenu.Checked=false;
}
else
{
rbSelectMenu.Checked=true;
rbAllMenu.Checked=false;
}
ShowSelectedData();//显示选择数据
//this.RegisterStartupScript("newWindow","<script language='javascript'>var obj=window.dialogArguments;document.all('txtQuery').value=obj.name;</script>");
}
if (!IsPostBack)
{
// if (bJoySoftware==false)
// {
// ButInput.Attributes.Add("onclick", "javascript:alert('对不起，未注册用户不能设置角色菜单！');return false;");
// }
strSql="select ManagMenuID,MenuName from ManagMenu order by ManagMenuID asc";
ShowData(strSql);
}
}
#endregion
#region//******显示数据列表******
private void ShowData(string strSql)
{
string strConn="";
strConn=ConfigurationSettings.AppSettings["strConn"];
SqlConnection objConn=new SqlConnection(strConn);
SqlDataAdapter objCmd=new SqlDataAdapter(strSql,objConn);
DataSet objDS=new DataSet();
objCmd.Fill(objDS,"ManagMenu");
LBSelect.DataTextField="MenuName";
LBSelect.DataValueField="ManagMenuID";
LBSelect.DataSource=objDS.Tables["ManagMenu"].DefaultView;
LBSelect.DataBind();
objCmd.Dispose();
objDS.Dispose();
objConn.Dispose();
}
#endregion
#region//******显示已选择数据列表******
private void ShowSelectedData()
{
string strConn="";
strConn=ConfigurationSettings.AppSettings["strConn"];
SqlConnection objConn=new SqlConnection(strConn);
SqlDataAdapter objCmd=new SqlDataAdapter("select b.ManagMenuID,b.MenuName from UserPower a,ManagMenu b where a.OptionID=b.ManagMenuID and a.UserID="+intUserID+" and a.PowerID=3 order by a.OptionID asc",objConn);
DataSet objDS=new DataSet();
objCmd.Fill(objDS,"UserPower");
LBSelected.DataTextField="MenuName";
LBSelected.DataValueField="ManagMenuID";
LBSelected.DataSource=objDS.Tables["UserPower"].DefaultView;
LBSelected.DataBind();
objCmd.Dispose();
objDS.Dispose();
objConn.Dispose();
}
#endregion
#region Web 窗体设计器天生的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该挪用是 ASP.NET Web 窗体设计器所必须的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的步骤 - 不要使用代码编纂器批改
/// 此步骤的内容。
/// </summary>
private void InitializeComponent()
{
}
#endregion
#region//****选择题型按钮事务****
protected void butAllSelect_Click(object sender, System.EventArgs e)
{
ListItem LITmp=null;
for(int i=0;i<LBSelect.Items.Count;i++)
{
LITmp=new ListItem(LBSelect.Items[i].Text,LBSelect.Items[i].Value);
if(LBSelected.Items.IndexOf(LITmp)==-1)
{
LBSelected.Items.Add(LITmp);
}
}
LBSelect.Items.Clear();
}
protected void butOneSelect_Click(object sender, System.EventArgs e)
{
ArrayList arrList=new ArrayList();
foreach(ListItem item in LBSelect.Items)
{
if (item.Selected)
{
arrList.Add(item);
}
}
foreach(ListItem item in arrList)
{
if (LBSelected.Items.IndexOf(item)==-1)
{
LBSelected.Items.Add(item);
}
LBSelect.Items.Remove(item);
}
LBSelected.SelectedIndex=-1;
}
protected void butOneDel_Click(object sender, System.EventArgs e)
{
ArrayList arrList=new ArrayList();
foreach(ListItem item in LBSelected.Items)
{
if (item.Selected)
{
arrList.Add(item);
}
}
foreach(ListItem item in arrList)
{
if (LBSelect.Items.IndexOf(item)==-1)
{
LBSelect.Items.Add(item);
}
LBSelected.Items.Remove(item);
}
LBSelect.SelectedIndex=-1;
}
protected void butAllDel_Click(object sender, System.EventArgs e)
{
ListItem LITmp=null;
for(int i=0;i<LBSelected.Items.Count;i++)
{
LITmp=new ListItem(LBSelected.Items[i].Text,LBSelected.Items[i].Value);
if(LBSelect.Items.IndexOf(LITmp)==-1)
{
LBSelect.Items.Add(LITmp);
}
}
LBSelected.Items.Clear();
}
#endregion
#region//********选定帐号题型*******
protected void ButInput_Click(object sender, System.EventArgs e)
{
// if (ObjFun.JoySoftware()==false)
// {
// this.RegisterStartupScript("newWindow","<script language='javascript'>alert('对不起，未注册用户不能设置角色菜单！')</script>");
// return;
// }
//保留到数据库
int i=0;
string strConn=ConfigurationSettings.AppSettings["strConn"];
SqlConnection ObjConn =new SqlConnection(strConn);
ObjConn.Open();
SqlTransaction ObjTran=ObjConn.BeginTransaction();
SqlCommand ObjCmd=new SqlCommand();
ObjCmd.Transaction=ObjTran;
ObjCmd.Connection=ObjConn;
try
{
ObjCmd.CommandText="delete from UserPower where UserID="+intUserID+" and PowerID=3";
ObjCmd.ExecuteNonQuery();
if (rbAllMenu.Checked==true)
{
ObjCmd.CommandText="Update UserInfo set RoleMenu=1 where UserID="+intUserID+"";
ObjCmd.ExecuteNonQuery();
}
else
{
for(i=0;i<LBSelected.Items.Count;i++)
{
ObjCmd.CommandText="insert into UserPower(UserID,PowerID,OptionID) values("+intUserID+",3,"+LBSelected.Items[i].Value+")";
ObjCmd.ExecuteNonQuery();
}
ObjCmd.CommandText="Update UserInfo set RoleMenu=2 where UserID="+intUserID+"";
ObjCmd.ExecuteNonQuery();
}
ObjTran.Commit();
}
catch
{
ObjTran.Rollback();
}
finally
{
ObjConn.Close();
ObjConn.Dispose();
}
this.RegisterStartupScript("newWindow","<script language='javascript'>window.close();</script>");
}
#endregion
}
}
#line default
#line hidden