/// <summary>
/// 获得数据列表
/// </summary>
public List <Tunnel.Model.Tunnel_dyingshe> DataTableToList(DataTable dt)
{
List <Tunnel.Model.Tunnel_dyingshe> modelList = new List <Tunnel.Model.Tunnel_dyingshe>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
Tunnel.Model.Tunnel_dyingshe model;
for (int n = 0; n < rowsCount; n++)
{
model = new Tunnel.Model.Tunnel_dyingshe();
if (dt.Rows[n]["dy_id"].ToString() != "")
{
model.dy_id = int.Parse(dt.Rows[n]["dy_id"].ToString());
}
model.dy_did = dt.Rows[n]["dy_did"].ToString();
model.dy_list = dt.Rows[n]["dy_list"].ToString();
modelList.Add(model);
}
}
return(modelList);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Tunnel.Model.Tunnel_dyingshe model)
{
dal.Update(model);
}
/// <summary>
/// 更新权限
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Button1_Click(object sender, EventArgs e)
{
switch (typeId)
{
#region 添加/更新用户权限
case 1:
Tunnel.BLL.Tunnel_uyingshe tyu = new Tunnel.BLL.Tunnel_uyingshe();
Tunnel.Model.Tunnel_uyingshe tyuu = new Tunnel.Model.Tunnel_uyingshe();
List <Tunnel.Model.Tunnel_uyingshe> uslist = new List <Tunnel.Model.Tunnel_uyingshe>();
uslist = tyu.GetModelList("uy_uid='" + tmpId + "'");
if (uslist.Count > 0)
{
tyuu.uy_id = uslist[0].uy_id;
tyuu.uy_uid = tmpId.ToString();
tyuu.uy_list = getString();
tyu.Update(tyuu);
Tunnel.Common.Message.Show("更新用户权限成功"); //更新用户权限
}
else
{
tyuu.uy_uid = tmpId.ToString();
tyuu.uy_list = getString();
tyu.Add(tyuu);
Tunnel.Common.Message.Show("添加用户权限成功"); //更新用户权限
}
ListBox2.Items.Clear();
break;
#endregion
#region 添加/更新角色权限
case 2:
Tunnel.BLL.Tunnel_yingshe tyj = new Tunnel.BLL.Tunnel_yingshe();
Tunnel.Model.Tunnel_yingshe tyjj = new Tunnel.Model.Tunnel_yingshe();
List <Tunnel.Model.Tunnel_yingshe> jslist = new List <Tunnel.Model.Tunnel_yingshe>();
jslist = tyj.GetModelList("y_jsid=" + tmpId + "");
if (jslist.Count > 0)
{
tyjj.y_id = jslist[0].y_id;
tyjj.y_jsid = tmpId;
tyjj.y_qxlist = getString();
tyj.Update(tyjj);
Tunnel.Common.Message.Show("更新角色权限成功"); //更新角色权限
}
else
{
tyjj.y_jsid = tmpId;
tyjj.y_qxlist = getString();
tyj.Add(tyjj);
Tunnel.Common.Message.Show("添加角色权限成功"); //添加角色权限
}
ListBox2.Items.Clear();
break;
#endregion
#region 添加/更新职位权限
case 3:
Tunnel.BLL.Tunnel_dyingshe tyd = new Tunnel.BLL.Tunnel_dyingshe();
Tunnel.Model.Tunnel_dyingshe tydd = new Tunnel.Model.Tunnel_dyingshe();
List <Tunnel.Model.Tunnel_dyingshe> dulist = new List <Tunnel.Model.Tunnel_dyingshe>();
dulist = tyd.GetModelList("dy_did='" + tmpId + "'");
if (dulist.Count > 0)
{
tydd.dy_id = dulist[0].dy_id;
tydd.dy_did = tmpId.ToString();
tydd.dy_list = getString();
tyd.Update(tydd);
Tunnel.Common.Message.Show("更新职位权限成功"); //更新职务权限
}
else
{
tydd.dy_did = tmpId.ToString();
tydd.dy_list = getString();
tyd.Add(tydd);
Tunnel.Common.Message.Show("添加职位权限成功"); //添加职务权限
}
ListBox2.Items.Clear();
break;
#endregion
#region 添加/更新部门权限
case 4:
Tunnel.BLL.Tunnel_byingshe tyb = new Tunnel.BLL.Tunnel_byingshe();
Tunnel.Model.Tunnel_byingshe tybb = new Tunnel.Model.Tunnel_byingshe();
List <Tunnel.Model.Tunnel_byingshe> bulist = new List <Tunnel.Model.Tunnel_byingshe>();
bulist = tyb.GetModelList("by_bid='" + tmpId + "'");
//判断是修改还是添加权限
if (bulist.Count > 0)
{
tybb.by_id = bulist[0].by_id;
tybb.by_bid = tmpId.ToString();
tybb.by_list = getString();
tyb.Update(tybb);
Tunnel.Common.Message.Show("更新部门权限成功"); //更新部门权限
}
else
{
tybb.by_bid = tmpId.ToString();
tybb.by_list = getString();
tyb.Add(tybb);
Tunnel.Common.Message.Show("添加部门权限成功"); //添加部门权限
}
ListBox2.Items.Clear();
break;
#endregion
default:
break;
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Tunnel.Model.Tunnel_dyingshe model)
{
return(dal.Add(model));
}
public static int typeId = 0; //管理类型编号
/// <summary>
/// 根据 用户编号获取用户拥有的所有权限
/// </summary>
/// <param name="userId"></param>
public void GetUserAllPermission(int userId)
{
ListBox3.Items.Clear();
int bumId = 0;
int dutyId = 0;
int jueSeId = 0;
string qxList = string.Empty;
Tunnel.BLL.Tunnel_menber tm = new Tunnel.BLL.Tunnel_menber();
Tunnel.Model.Tunnel_menber tmm = new Tunnel.Model.Tunnel_menber();
Tunnel.BLL.Tunnel_uyingshe uy = new Tunnel.BLL.Tunnel_uyingshe();
Tunnel.Model.Tunnel_uyingshe uyy = new Tunnel.Model.Tunnel_uyingshe();
Tunnel.BLL.Tunnel_dyingshe dy = new Tunnel.BLL.Tunnel_dyingshe();
Tunnel.Model.Tunnel_dyingshe dyy = new Tunnel.Model.Tunnel_dyingshe();
Tunnel.BLL.Tunnel_yingshe jy = new Tunnel.BLL.Tunnel_yingshe();
Tunnel.Model.Tunnel_yingshe jyy = new Tunnel.Model.Tunnel_yingshe();
Tunnel.BLL.Tunnel_byingshe by = new Tunnel.BLL.Tunnel_byingshe();
Tunnel.Model.Tunnel_byingshe byy = new Tunnel.Model.Tunnel_byingshe();
tmm = tm.GetModel(userId);
#region 判断
if (tmm != null)
{
bumId = tmm.m_bum;
dutyId = tmm.m_duty;
jueSeId = tmm.m_jiao;
if (uy.GetModelList("uy_uid=" + userId).Count > 0)
{
uyy = uy.GetModelList("uy_uid=" + userId)[0];
if (uyy != null)
{
if (uyy.uy_list.Length > 0)
{
qxList += uyy.uy_list + "|";
}
}
}
if (by.GetModelList("by_bid=" + bumId).Count > 0)
{
byy = by.GetModelList("by_bid=" + bumId)[0];
if (byy != null)
{
if (byy.by_list.Length > 0)
{
qxList += byy.by_list + "|";
}
}
}
if (dy.GetModelList("dy_did=" + dutyId).Count > 0)
{
dyy = dy.GetModelList("dy_did=" + dutyId)[0];
if (dyy != null)
{
if (dyy.dy_list.Length > 0)
{
qxList += dyy.dy_list + "|";
}
}
}
if (jy.GetModelList("y_jsid=" + jueSeId).Count > 0)
{
jyy = jy.GetModelList("y_jsid=" + jueSeId)[0];
if (jyy != null)
{
if (jyy.y_qxlist.Length > 0)
{
qxList += jyy.y_qxlist + "|";
}
}
}
if (qxList.Length > 1)
{
qxList = qxList.Substring(0, qxList.Length - 1);
}
}
#endregion
Tunnel.BLL.Tunnel_quanxian tq = new Tunnel.BLL.Tunnel_quanxian();
if (qxList.Length > 0)
{
foreach (string item in qxList.Split('|'))
{
Tunnel.Model.Tunnel_quanxian tqq = new Tunnel.Model.Tunnel_quanxian();
tqq = tq.GetModel(int.Parse(item));
if (tqq != null)
{
ListItem li = new ListItem(tqq.q_mark + "-->>" + tqq.q_name, tqq.q_id.ToString());
if (!ListBox3.Items.Contains(li))
{
ListBox3.Items.Add(li);
}
}
}
}
}