![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
/**//// <summary>
/// 通过User Name获取user id的table
/// 如果有非法的user则提示用户修改并返回null
/// </summary>
/// <param name="userNameList">user names 比如:Sammy Song;Lili Zhang;</param>
/// <returns>user table</returns>
public DataTable GetUserIDsForAdmin(string userNameList)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/dot.gif)
{
//对参数字符串处理,比如';;;;;;Sammy Song;;;;;;Lili Zhang;;;;;;' 这样的字符串,先Trim掉两边所有的分号,再把中间多个分号用正则替换成一个
userNameList = userNameList.Trim(';');
userNameList = Regex.Replace(userNameList, ";+", ";");
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string[] userCheckString = userNameList.Split(';');
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
List<string> userCheckList = new List<string>();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
userCheckList.Add(userCheckString[0].ToLower());
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
//去除重复的名字
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
for (int i = 0; i < userCheckString.Length; i++)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/dot.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
if (!userCheckList.Contains(userCheckString[i].ToLower()) && userCheckString[i].Trim() != "")
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/dot.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
userCheckList.Add(userCheckString[i].ToLower());
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
//获取user table
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
BenQ.Public.Web.WSC.Entity.Wscuser entityCheckUser = new BenQ.Public.Web.WSC.Entity.Wscuser();
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
entityCheckUser.QueryMode = true;
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
entityCheckUser.Account.In(userCheckString);
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
entityCheckUser.Active += true;
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ContractedSubBlock.gif)
DataTable userTable = entityCheckUser.Query(new QString[]
![](https://www.cnblogs.com/Images/dot.gif)
{ entityCheckUser.Userid, entityCheckUser.Account },
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
false, -1).Tables[0];
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
//返回的行数小于非重复user name的个数,则有非法的user name,提示用户出错
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
if (userTable.Rows.Count != userCheckList.Count)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/dot.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
for (int j = 0; j < userTable.Rows.Count; j++)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/dot.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
if (userCheckList.Contains(userTable.Rows[j]["account"].ToString().ToLower()))
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/dot.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
userCheckList.Remove(userTable.Rows[j]["account"].ToString().ToLower());
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
string invalidUser = "";
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
for (int k = 0; k < userCheckList.Count; k++)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/dot.gif)
{
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
invalidUser += "," + userCheckList[k];
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
invalidUser = invalidUser.TrimStart(',');
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
this.showMessageInfo(this.getMessage("WM10005").Replace("%User%", invalidUser));
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return null;
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
}
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
//没有非法用户,
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
return userTable;
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
}