private List<string> GetRevUser(string revString)
{
string sql = "";
revString = revString.Replace("/r", "").Replace("/n", "").Replace("——", "-").Replace("--", "-");
string[] membergroup = revString.Split(',');
string strs="";
string groupuser = "";
foreach (string member in membergroup)
{
if (member.StartsWith("["))//如果是组的话 就以"["开头 以这个']"结束
{
revString =member.Replace("[", "'").Replace("]", "'");
sql = "select * from tbGroupMember where group_name =" + revString + "";
DataTable tb = SqlHelper.SqlHelper.ExecuteDataset(ConfigurationManager.ConnectionStrings["ASUSCrmAppConnectionString"].ToString(), CommandType.Text, sql).Tables[0];
groupuser= tb.Rows[0][1].ToString();//取到组员名
strs += groupuser == "" ? groupuser : groupuser + ",";//如果不是空 加","
}
else
{
strs += member == "" ? member : member + ",";
}
}
strs = strs.Substring(0, strs.Length - 1);
List<string> list = new List<string>();
string[] strArr = strs.Split(',');
foreach (string str in strArr)
{
int _pos=str.IndexOf("-");
if (_pos > 0)
{
string lefts = str.Substring(0, _pos);
string rights = str.Substring(_pos + 1);
try
{
int lefti = Convert.ToInt32(lefts.Substring(4));
int righti = Convert.ToInt32(rights.Substring(4));
for (int i = lefti; i <= righti; i++)
{
string uid="ASUS"+i.ToString("D3");
if (tbUserManager.UserExists(uid) )
{
if (list.IndexOf(uid) < 0)
{
list.Add(uid);
}
}
}
}
catch
{ }
}
else
{
if (tbUserManager.UserExists(str))
{
if (list.IndexOf(str)<0)
{
list.Add(str);
}
}
}
}
return list;
}