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