/// <summary>
/// 取指定岗位下的所有角色
/// </summary>
/// <param name="_postid"></param>
/// <returns></returns>
public static List <SinoRole> Get_RolesOfGW(string _postid)
{
string _sql = string.Format(" select a.jsid,a.jsmc,a.jssm,a.ssdwid from qx2_gwjsgxb t,qx_jsdyb a ");
_sql += string.Format("where a.jsid = t.jsid and t.gwid = :GWID");
SqlParameter[] _param =
{
new SqlParameter(":GWID", SqlDbType.Decimal),
};
_param[0].Value = decimal.Parse(_postid);
List <SinoRole> roles = new List <SinoRole>();
SqlDataReader dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringProfile, CommandType.Text, _sql, _param);
while (dr.Read())
{
SinoRole _sr = RightFunctions.CreateRoleItem(dr.GetDecimal(0).ToString(),
dr.IsDBNull(1) ? "" : dr.GetString(1),
dr.IsDBNull(2) ? "" : dr.GetString(2),
dr.IsDBNull(3) ? "" : dr.GetDecimal(3).ToString()
);
roles.Add(_sr);
}
dr.Close();
return(roles);
}
private void ShowRoleData(SinoRole _sr, TreeListNode _node)
{
if (CurrentRoleInfo != null)
{
if (CurrentRoleInfo.HaveChanged)
{
string _msg = String.Format("角色{0}的信息有修改,是否保存?", CurrentRoleInfo.Role.RoleName);
DialogResult _rs = XtraMessageBox.Show(_msg, "系统提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (_rs == DialogResult.Yes)
{
CurrentRoleInfo.SaveData();
}
}
}
CurrentRoleInfo = null;
if (_sr != null)
{
SinoSZUC_RoleInfo _uc = new SinoSZUC_RoleInfo(_sr, _node, CanUseQueryModelNames);
_uc.Dock = DockStyle.Fill;
_uc.DataChanged += new EventHandler <EventArgs>(_uc_DataChanged);
this.splitContainerControl1.Panel2.Controls.Clear();
this.splitContainerControl1.Panel2.Controls.Add(_uc);
_uc.BringToFront();
CurrentRoleInfo = _uc;
}
this.RaiseMenuChanged();
}
/// <summary>
/// 取角色列表
/// </summary>
private void InitRoleList()
{
this.treeList1.BeginUpdate();
this.treeList1.Nodes.Clear();
using (SinoSZClientBase.UserManagerService.UserManagerServiceClient _umsc = new SinoSZClientBase.UserManagerService.UserManagerServiceClient())
{
RoleList = _umsc.GetRoleList().ToList <SinoRole>();
}
foreach (SinoRole _sr in RoleList)
{
TreeListNode _tn = this.treeList1.AppendNode(null, null);
_tn.ImageIndex = 0;
_tn.SelectImageIndex = 0;
_tn.SetValue(this.treeListColumn1, _sr.RoleName);
_tn.Tag = _sr;
}
this.treeList1.EndUpdate();
TreeListNode _node = this.treeList1.FocusedNode;
if (_node != null)
{
SinoRole _role = _node.Tag as SinoRole;
ShowRoleData(_role, _node);
}
}
public SinoSZUC_RoleInfo(SinoRole _role, TreeListNode _treeNode, List <string> canUseQueryModelNames)
{
InitializeComponent();
RoleDefine = _role;
RoleNode = _treeNode;
CanUseQueryModelNames = canUseQueryModelNames;
InitForm();
}
private void treeList1_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
{
TreeListNode _node = e.Node;
if (_node != null)
{
SinoRole _sr = _node.Tag as SinoRole;
ShowRoleData(_sr, _node);
}
}
/// <summary>
/// 取用户的角色
/// </summary>
/// <param name="yhid"></param>
/// <returns></returns>
public static ArrayList Get_RoleByYHID(string yhid)
{
string _sql = string.Format(" select a.jsid,a.jsmc,a.jssm,a.ssdwid from qx_yhjsgxb t,qx_jsdyb a ");
_sql += string.Format("where a.jsid = t.jsid and yhid = {0}", yhid);
DataTable _dt = SqlHelper.Get_Data(_sql, "ROLES");
ArrayList roles = new ArrayList();
foreach (DataRow _dr in _dt.Rows)
{
SinoRole _sr = RightFunctions.CreateRoleItem(_dr);
roles.Add(_sr);
}
return(roles);
}
private List <SinoRole> GetSelectedRoles()
{
List <SinoRole> _ret = new List <SinoRole>();
foreach (TreeListNode _tn in this.treeList1.Nodes)
{
if (_tn.GetValue(this.treeListColumn2) != null)
{
bool _isChecked = (bool)_tn.GetValue(this.treeListColumn2);
if (_isChecked)
{
SinoRole _sr = _tn.Tag as SinoRole;
_ret.Add(_sr);
}
}
}
return(_ret);
}
private void InitQueryViewRightTree(SinoRole _sr)
{
using (SinoSZClientBase.UserManagerService.UserManagerServiceClient _umsc = new SinoSZClientBase.UserManagerService.UserManagerServiceClient())
{
List <UserQueryModelInfo> _qvRightList = _umsc.GetModelRightListByRoleID(_sr.RoleID).ToList <UserQueryModelInfo>();
TObj_ModelRightList _qvRights = new TObj_ModelRightList();
foreach (UserQueryModelInfo _qmRight in _qvRightList)
{
string _qvname = string.Format("{0}.{1}", _qmRight.QueryModelNamespace, _qmRight.QueryModelName);
if (this.CanUseQueryModelNames.Contains(_qvname))
{
TObj_ModelRightItem _ritem = new TObj_ModelRightItem(_qmRight);
_qvRights.Add(_ritem);
}
}
this.treeList3.BeginUpdate();
this.treeList3.DataSource = _qvRights;
this.treeList3.EndUpdate();
}
}
/// <summary>
/// 添加新角色
/// </summary>
/// <returns></returns>
private bool AddNewRole()
{
Dialog_AddRole _ar = new Dialog_AddRole();
if (_ar.ShowDialog() == DialogResult.OK)
{
SinoRole _newRole = new SinoRole();
_newRole.RoleID = "";
_newRole.RoleName = _ar.RoleName;
_newRole.Descript = _ar.RoleDes;
using (SinoSZClientBase.UserManagerService.UserManagerServiceClient _umsc = new SinoSZClientBase.UserManagerService.UserManagerServiceClient())
{
if (_umsc.AddNewRole(_newRole))
{
InitRoleList();
return(true);
}
}
}
return(false);
}
private void InitRigtTree(SinoRole _sr)
{
if (_sr != null)
{
using (SinoSZClientBase.UserManagerService.UserManagerServiceClient _umsc = new SinoSZClientBase.UserManagerService.UserManagerServiceClient())
{
List <UserRightInfo> _rightList = _umsc.GetRightListByRoleID(_sr.RoleID).ToList <UserRightInfo>();
UserRightFinder _finder = new UserRightFinder("-1");
List <UserRightInfo> _TopRightList = _rightList.FindAll(new Predicate <UserRightInfo>(_finder.FindByFatherID));
_TopRightList.Sort(new UserRightInfoComparer());
RightList = new TObj_RightItemList();
foreach (UserRightInfo _ri in _TopRightList)
{
TObj_RightItem _ritem = new TObj_RightItem(_ri);
RightList.Add(_ritem);
AddChildrenRightItem(_ritem, _rightList);
}
this.treeList2.BeginUpdate();
this.treeList2.DataSource = RightList;
this.treeList2.ExpandAll();
this.treeList2.EndUpdate();
}
}
}
public bool DeleteRole(SinoRole _role)
{
return(UserManagerFactroy.DeleteRole(_role));
}
public bool SaveRightsOfRole(SinoRole _role, List <UserRightInfo> _functionRights, List <UserQueryModelInfo> _modelRights)
{
return(UserManagerFactroy.SaveRightsOfRole(_role, _functionRights, _modelRights));
}
public bool AddNewRole(SinoRole _newRole)
{
return(UserManagerFactroy.AddNewRole(_newRole));
}
