/// <summary>
///
/// </summary>
/// <returns></returns>
public bool ModifyMoudleSort(Dictionary <string, string> Dic)
{
List <string> list = new List <string>();
StringBuilder sql = new StringBuilder();
foreach (KeyValuePair <string, string> kvp in Dic)
{
list.Add(" Update moudleinfo Set Sort='" + kvp.Value + "' Where moudleid = '" + kvp.Key + "'");
}
return(DataBaseManage.ExecuteSqlTran(list) > 0);
}
/// <summary>
/// 授予用户角色
/// </summary>
/// <param name="UserId"></param>
/// <param name="RoleId"></param>
/// <returns></returns>
public bool GrantUserRole(int UserId, List <string> RoleId)
{
List <string> list = new List <string>();
string sql = "";
foreach (string _RoleId in RoleId)
{
sql = string.Format("Insert Into userroleinfo (userid, roleid)Values ('{0}', '{1}')", UserId, _RoleId);
list.Add(sql);
}
return(DataBaseManage.ExecuteSqlTran(list) > 0);
}
/// <summary>
///
/// </summary>
/// <param name="ListInfo"></param>
/// <returns></returns>
public bool GrantRolePower(List <RoleMoudleInfo> ListInfo)
{
List <string> list = new List <string>();
string sql = "";
foreach (RoleMoudleInfo info in ListInfo)
{
sql = string.Format("Update rolemoudleinfo Set powervalue = '{0}' Where roleid = '{1}' And moudleid = '{2}'", info.PowerValue, info.RoleId, info.MoudleId);
list.Add(sql);
}
return(DataBaseManage.ExecuteSqlTran(list) > 0);
}
public bool GrantRoleMoudle(int RoleId, List <string> MoudleId)
{
List <string> list = new List <string>();
string sql = string.Format("Delete FROM rolemoudleinfo Where roleid = '{0}'", RoleId);
list.Add(sql);
foreach (string _MoudleId in MoudleId)
{
sql = string.Format("Insert Into rolemoudleinfo (roleid, moudleid, powervalue)Values ('{0}', '{1}','0')", RoleId, _MoudleId);
list.Add(sql);
}
return(DataBaseManage.ExecuteSqlTran(list) > 0);
}
