private void reloadAccountList(IList <EasAccountEntity> accountsList, ListView lv)
{
//if (this.accountsUnSelectedList.Count != 0)
//{
EasAccountEntity account = null;
// 添加数据项
lv.BeginUpdate();
for (int i = 0; i < accountsList.Count; i++)
{
account = accountsList[i];
ListViewItem lvi = new ListViewItem(account.Name, i);
if (account.ObjectType == DataType.AuthObjectType.UserRole)
{
//lvi.SubItems.Add(account.RoleName + "【群组】");
//FontStyle style=new FontStyle();
//Font font = new System.Drawing.Font("宋体", 9,style);
// font.Underline = true;
// lvi.SubItems.Add("【群组】", Color.Black, Color.Red, font);
lvi.SubItems.Add("【群组】");
lvi.ForeColor = Color.Red;
}
else
{
//lvi.SubItems.Add(account.RoleName + "【单用户】");
lvi.SubItems.Add("【用户】");
}
lvi.SubItems.Add(account.LoginID);
lvi.Tag = account.ObjectType; //存放类型
lv.Items.Add(lvi);
}
lv.EndUpdate();
//}
}
private void InitAccountsList()
{
this.accountsUnSelectedList.Clear();
this.accountsOldSelectedList.Clear();
// this.accountsList = _accountsService.GetAllAccountsList();
// DataTable dtUserRole= CommonFuns.getDataTableBySql("NAME,DESCRIPTION", " WHERE NAME NOT IN ('Administrators','Guests','平台演示')", "EAS_ROLES");
if (this.OldSelectedUserList == null || this.OldSelectedUserList.Count == 0)
{
}
else
{
stbOldSelected = new StringBuilder("(");
foreach (DataType.UserOrGroupSelected it in this.OldSelectedUserList)
{
stbOldSelected.Append("'" + it.Value + "'").Append(",");
}
stbOldSelected.Remove(stbOldSelected.Length - 1, 1).Append(")");
}
DataTable dtUnSelectedUsers;
DataTable dtOldSelectedUsers;
if (stbOldSelected == null || stbOldSelected.ToString() == "")
{
dtUnSelectedUsers = CommonFuns.getDataTableBySql("A.LOGINID,A.ROLENAME,B.Name,B.DESCRIPTION,B.ORGANNAME", "WHERE B.ORGANID NOT IN ('7ECC3D03-B80E-4EBC-9DEC-CAE93143321F','7987FC8D-BF40-4A3D-B7CD-588CD6CDD175') ", "EAS_ACCOUNTGROUPING A LEFT JOIN EAS_ACCOUNTS B ON A.LOGINID=B.LOGINID");
//未选择的用户
foreach (DataRow dr in dtUnSelectedUsers.Rows)
{
EasAccountEntity userAndRole = new EasAccountEntity();
userAndRole.LoginID = dr["LOGINID"].ToString();
userAndRole.RoleName = dr["ROLENAME"].ToString();
userAndRole.Name = dr["Name"].ToString();
userAndRole.ObjectType = DataType.AuthObjectType.SingleUser; //单用户
accountsUnSelectedList.Add(userAndRole);
}
reloadAccountList(this.accountsUnSelectedList, lvNotSelect);
// dtOldSelectedUsers = new DataTable();
}
else
{
dtUnSelectedUsers = CommonFuns.getDataTableBySql("A.LOGINID,A.ROLENAME,B.Name,B.DESCRIPTION,B.ORGANNAME", "WHERE B.ORGANID NOT IN ('7ECC3D03-B80E-4EBC-9DEC-CAE93143321F','7987FC8D-BF40-4A3D-B7CD-588CD6CDD175') AND A.LOGINID NOT IN " + stbOldSelected.ToString(), "EAS_ACCOUNTGROUPING A LEFT JOIN EAS_ACCOUNTS B ON A.LOGINID=B.LOGINID");
dtOldSelectedUsers = CommonFuns.getDataTableBySql("A.LOGINID,A.ROLENAME,B.Name,B.DESCRIPTION,B.ORGANNAME", "WHERE B.ORGANID NOT IN ('7ECC3D03-B80E-4EBC-9DEC-CAE93143321F','7987FC8D-BF40-4A3D-B7CD-588CD6CDD175') AND A.LOGINID IN " + stbOldSelected.ToString(), "EAS_ACCOUNTGROUPING A LEFT JOIN EAS_ACCOUNTS B ON A.LOGINID=B.LOGINID");
//未选择的用户
foreach (DataRow dr in dtUnSelectedUsers.Rows)
{
EasAccountEntity userAndRole = new EasAccountEntity();
userAndRole.LoginID = dr["LOGINID"].ToString();
userAndRole.RoleName = dr["ROLENAME"].ToString();
userAndRole.Name = dr["Name"].ToString();
userAndRole.ObjectType = DataType.AuthObjectType.SingleUser; //单用户
accountsUnSelectedList.Add(userAndRole);
}
///已经选择了的用户
foreach (DataRow dr in dtOldSelectedUsers.Rows)
{
EasAccountEntity userAndRole = new EasAccountEntity();
userAndRole.LoginID = dr["LOGINID"].ToString();
userAndRole.RoleName = dr["ROLENAME"].ToString();
userAndRole.Name = dr["Name"].ToString();
userAndRole.ObjectType = DataType.AuthObjectType.SingleUser; //单用户
accountsOldSelectedList.Add(userAndRole);
}
reloadAccountList(this.accountsUnSelectedList, lvNotSelect);
reloadAccountList(this.accountsOldSelectedList, lvSelected);
}
newSelectItemList();
///用户群组信息，暂时去掉
// DataTable dtUserGroup = CommonFuns.getDataTableBySql("NAME,DESCRIPTION", " WHERE NAME NOT IN ('Administrators','Guests','平台演示')", "EAS_ROLES");
///用户群组信息，暂时去掉
//foreach (DataRow dr in dtUserGroup.Rows)
//{
// EasAccountEntity userAndRole = new EasAccountEntity();
// userAndRole.LoginID = dr["NAME"].ToString();
// userAndRole.RoleName = dr["NAME"].ToString();
// userAndRole.Name = dr["NAME"].ToString();
// userAndRole.ObjectType = DataType.AuthObjectType.UserRole; //用户群组
// accountsList.Add(userAndRole);
//}
}
private void InitAccountsList()
{
this.accountsUnSelectedList.Clear();
this.accountsOldSelectedList.Clear();
// this.accountsList = _accountsService.GetAllAccountsList();
// DataTable dtUserRole= CommonFuns.getDataTableBySql("NAME,DESCRIPTION", " WHERE NAME NOT IN ('Administrators','Guests','平台演示')", "EAS_ROLES");
if (this.OldSelectedUserList == null || this.OldSelectedUserList.Count == 0)
{
}
else
{
stbOldSelected = new StringBuilder("(");
foreach (DataType.UserOrGroupSelected it in this.OldSelectedUserList)
{
stbOldSelected.Append("'" + it.Value + "'").Append(",");
}
stbOldSelected.Remove(stbOldSelected.Length - 1, 1).Append(")");
}
DataTable dtUnSelectedUsers;
DataTable dtOldSelectedUsers;
if (stbOldSelected == null || stbOldSelected.ToString() == "")
{
dtUnSelectedUsers = CommonFuns.getDataTableBySql("A.LOGINID,A.ROLENAME,B.Name,B.DESCRIPTION,B.ORGANNAME", "WHERE B.ORGANID NOT IN ('7ECC3D03-B80E-4EBC-9DEC-CAE93143321F','7987FC8D-BF40-4A3D-B7CD-588CD6CDD175') ", "EAS_ACCOUNTGROUPING A LEFT JOIN EAS_ACCOUNTS B ON A.LOGINID=B.LOGINID");
//未选择的用户
foreach (DataRow dr in dtUnSelectedUsers.Rows)
{
EasAccountEntity userAndRole = new EasAccountEntity();
userAndRole.LoginID = dr["LOGINID"].ToString();
userAndRole.RoleName = dr["ROLENAME"].ToString();
userAndRole.Name = dr["Name"].ToString();
userAndRole.ObjectType = DataType.AuthObjectType.SingleUser; //单用户
accountsUnSelectedList.Add(userAndRole);
}
reloadAccountList(this.accountsUnSelectedList, lvNotSelect);
// dtOldSelectedUsers = new DataTable();
}
else
{
dtUnSelectedUsers = CommonFuns.getDataTableBySql("A.LOGINID,A.ROLENAME,B.Name,B.DESCRIPTION,B.ORGANNAME", "WHERE B.ORGANID NOT IN ('7ECC3D03-B80E-4EBC-9DEC-CAE93143321F','7987FC8D-BF40-4A3D-B7CD-588CD6CDD175') AND A.LOGINID NOT IN " + stbOldSelected.ToString(), "EAS_ACCOUNTGROUPING A LEFT JOIN EAS_ACCOUNTS B ON A.LOGINID=B.LOGINID");
dtOldSelectedUsers = CommonFuns.getDataTableBySql("A.LOGINID,A.ROLENAME,B.Name,B.DESCRIPTION,B.ORGANNAME", "WHERE B.ORGANID NOT IN ('7ECC3D03-B80E-4EBC-9DEC-CAE93143321F','7987FC8D-BF40-4A3D-B7CD-588CD6CDD175') AND A.LOGINID IN " + stbOldSelected.ToString(), "EAS_ACCOUNTGROUPING A LEFT JOIN EAS_ACCOUNTS B ON A.LOGINID=B.LOGINID");
//未选择的用户
foreach (DataRow dr in dtUnSelectedUsers.Rows)
{
EasAccountEntity userAndRole = new EasAccountEntity();
userAndRole.LoginID = dr["LOGINID"].ToString();
userAndRole.RoleName = dr["ROLENAME"].ToString();
userAndRole.Name = dr["Name"].ToString();
userAndRole.ObjectType = DataType.AuthObjectType.SingleUser; //单用户
accountsUnSelectedList.Add(userAndRole);
}
///已经选择了的用户
foreach (DataRow dr in dtOldSelectedUsers.Rows)
{
EasAccountEntity userAndRole = new EasAccountEntity();
userAndRole.LoginID = dr["LOGINID"].ToString();
userAndRole.RoleName = dr["ROLENAME"].ToString();
userAndRole.Name = dr["Name"].ToString();
userAndRole.ObjectType = DataType.AuthObjectType.SingleUser; //单用户
accountsOldSelectedList.Add(userAndRole);
}
reloadAccountList(this.accountsUnSelectedList, lvNotSelect);
reloadAccountList(this.accountsOldSelectedList, lvSelected);
}
newSelectItemList();
///用户群组信息，暂时去掉
// DataTable dtUserGroup = CommonFuns.getDataTableBySql("NAME,DESCRIPTION", " WHERE NAME NOT IN ('Administrators','Guests','平台演示')", "EAS_ROLES");
///用户群组信息，暂时去掉
//foreach (DataRow dr in dtUserGroup.Rows)
//{
// EasAccountEntity userAndRole = new EasAccountEntity();
// userAndRole.LoginID = dr["NAME"].ToString();
// userAndRole.RoleName = dr["NAME"].ToString();
// userAndRole.Name = dr["NAME"].ToString();
// userAndRole.ObjectType = DataType.AuthObjectType.UserRole; //用户群组
// accountsList.Add(userAndRole);
//}
}
