62,046
社区成员
发帖
与我相关
我的任务
分享
public static Dictionary<int, string> UserList(string userids)
{
Dictionary<int, string> userlist = new Dictionary<int, string>();
using (SqlConnection cn = new SqlConnection(sqlConnStr))
{
//try
//{
SqlCommand cmd = new SqlCommand(string.Format("select ID,RealName from Depart_Users where id in ({0})", userids), cn);
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
userlist.Add(int.Parse(dr["id"].ToString()), dr["RealName"].ToString());
}
return userlist;
//}
//catch (Exception ex)
//{
// Class_LogFile.LogWrite(ex.Message);
// throw new ApplicationException("获取部门用户出错!");
//}
//finally
//{
// cn.Close();
//}
}
}
方法中只有sqlConnStr是静态变量,不同用户同时取的话结果不存在相互干扰吧。都是重新NEW了一块