/// <summary>
///
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void BTN_SAVE_Click(object sender, EventArgs e)
{
RoleMoudleInfo _RoleMoudleInfo = null;
List<RoleMoudleInfo> list = new List<RoleMoudleInfo>();
double RightValue = 0;
foreach (GridViewRow row in this.GridView1.Rows)
{
_RoleMoudleInfo = new RoleMoudleInfo();
_RoleMoudleInfo.MoudleId = int.Parse(this.GridView1.DataKeys[row.RowIndex].Value.ToString());
_RoleMoudleInfo.RoleId = int.Parse(ViewState["ROLEID"].ToString());
CheckBoxList CheckList = (CheckBoxList)row.Cells[1].Controls[1];
if (CheckList.Items.Count > 0)
{
foreach (ListItem item in CheckList.Items)
{
if (item.Selected)
{
RightValue = RightValue + Math.Pow(2, double.Parse(item.Value));
}
}
}
_RoleMoudleInfo.PowerValue = (int)RightValue;
list.Add(_RoleMoudleInfo);
RightValue = 0;
}
if (_RoleMoudle.GrantRolePower(list))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('角色权限授予成功！');</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "alert", "<script>alert('角色权限授予失败！');</script>");
}
}
/// <summary>
///
/// </summary>
/// <param name="RoleId"></param>
/// <param name="MoudleId"></param>
/// <returns></returns>
public int GetPowerValue(string RoleId, string MoudleId)
{
RoleMoudleInfo info = new RoleMoudleInfo();
string sql = "Select sum(powervalue) powervalue From rolemoudleinfo where roleid in(" + RoleId + ") and moudleid='" + MoudleId + "'";
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
if (reader.Read())
{
info.PowerValue = (reader.IsDBNull(reader.GetOrdinal("powervalue"))) ? int.Parse("0") : int.Parse(reader["powervalue"].ToString());
}
}
return int.Parse(info.PowerValue.ToString());
}
/// <summary>
///
/// </summary>
/// <param name="RoleId"></param>
/// <param name="MoudleId"></param>
/// <returns></returns>
public int GetPowerValue(string RoleId, string MoudleId)
{
RoleMoudleInfo info = new RoleMoudleInfo();
string sql = "Select sum(powervalue) powervalue From rolemoudleinfo where roleid in(" + RoleId + ") and moudleid='" + MoudleId + "'";
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
if (reader.Read())
{
info.PowerValue = (reader.IsDBNull(reader.GetOrdinal("powervalue"))) ? int.Parse("0") : int.Parse(reader["powervalue"].ToString());
}
}
return(int.Parse(info.PowerValue.ToString()));
}
/// <summary>
///
/// </summary>
/// <param name="RoleId"></param>
/// <returns></returns>
public List<RoleMoudleInfo> GetRoleMoudle(string RoleId)
{
List<RoleMoudleInfo> ListInfo = new List<RoleMoudleInfo>();
RoleMoudleInfo info = null;
string sql = "Select roleid, moudleid,powervalue From rolemoudleinfo where roleid='" + RoleId.ToString() + "'";
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
while (reader.Read())
{
info = new RoleMoudleInfo();
info.MoudleId = (reader.IsDBNull(reader.GetOrdinal("moudleid"))) ? int.Parse("0") : int.Parse(reader["moudleid"].ToString());
info.RoleId = (reader.IsDBNull(reader.GetOrdinal("roleid"))) ? int.Parse("0") : int.Parse(reader["roleid"].ToString());
info.PowerValue = (reader.IsDBNull(reader.GetOrdinal("powervalue"))) ? int.Parse("0") : int.Parse(reader["powervalue"].ToString());
ListInfo.Add(info);
}
}
return ListInfo;
}
/// <summary>
///
/// </summary>
/// <param name="RoleId"></param>
/// <returns></returns>
public List <RoleMoudleInfo> GetRoleMoudle(string RoleId)
{
List <RoleMoudleInfo> ListInfo = new List <RoleMoudleInfo>();
RoleMoudleInfo info = null;
string sql = "Select roleid, moudleid,powervalue From rolemoudleinfo where roleid='" + RoleId.ToString() + "'";
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
while (reader.Read())
{
info = new RoleMoudleInfo();
info.MoudleId = (reader.IsDBNull(reader.GetOrdinal("moudleid"))) ? int.Parse("0") : int.Parse(reader["moudleid"].ToString());
info.RoleId = (reader.IsDBNull(reader.GetOrdinal("roleid"))) ? int.Parse("0") : int.Parse(reader["roleid"].ToString());
info.PowerValue = (reader.IsDBNull(reader.GetOrdinal("powervalue"))) ? int.Parse("0") : int.Parse(reader["powervalue"].ToString());
ListInfo.Add(info);
}
}
return(ListInfo);
}
