当多人尝试保存一个事务时，用户id在数据库中的值将变为null

Question

当多人试图保存一个事务时，用户id在数据库中的值将变为null。我每次都从数据库中根据会话id获取用户信息。我也试过查询字符串和会话。

下面提到的代码是根据会话id和系统名从数据库检索记录的用户信息。

我曾经调用这些构造函数是web方法

public clsLoggedUser()
{
try
{
string strUserId = "";
if (HttpContext.Current.Request.QueryString["x"] == null)
{

string strSessionID = HttpContext.Current.Session.SessionID;
string strUrl = HttpContext.Current.Request.UrlReferrer.Authority;
string strSystemName = Convert.ToString(System.Net.Dns.Resolve(HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"]).HostName);
OracleParameter[] objParam = new OracleParameter[3];
objParam[0] = new OracleParameter("SESSIONID", OracleType.VarChar);
objParam[1] = new OracleParameter("SYSNAME", OracleType.VarChar);
objParam[2] = new OracleParameter("URL", OracleType.VarChar);
objParam[0].Value = strSessionID.Trim();
objParam[1].Value = strSystemName.Trim();
objParam[2].Value = strUrl.Trim();
DataTable dtUserDetails = clsOracleAccess.StaticExecuteDataset(CommandType.StoredProcedure, "PACKCOMMON.GETLOGGEDUSERID", objParam, true).Tables[0];
if (dtUserDetails.Rows.Count > 0)
{
strUserId = dtUserDetails.Rows[0]["APPLOCKID_NR"].ToString();
}
else
{
Exception ex = new NullReferenceException();
clsErrorLogEntity.fn_AddNewErrorLog(DateTime.Now, "clsLoggedUser.cs (clsLoggedUser(-1)) [" + ex.Source + "]:" + ((String[])ex.StackTrace.Split(':'))[((String[])ex.StackTrace.Split(':')).Length - 1] + "", ex.Message, ex);
}
}
else
{
strUserId = HttpContext.Current.Request.QueryString["x"].ToString().Trim();
}

if (!String.IsNullOrEmpty(strUserId))
{
OracleParameter[] objParam = new OracleParameter[1];
objParam[0] = new OracleParameter("USERID", OracleType.Number);
objParam[0].Value = Int32.Parse(strUserId);
DataTable dtUserDetails = clsOracleAccess.StaticExecuteDataset(CommandType.StoredProcedure, "HMPACK.GETUSERINFOBYID", objParam, true).Tables[0];
if (dtUserDetails.Rows.Count > 0)
{
UserID = Convert.ToInt32(dtUserDetails.Rows[0]["APPID_NR"].ToString());
UserName = dtUserDetails.Rows[0]["APPUNAME_CD"].ToString();
Password = dtUserDetails.Rows[0]["APPUACCESS_CD"].ToString();
UserCode = dtUserDetails.Rows[0]["APPCODE_CD"].ToString();
IsAdmin = Convert.ToChar(dtUserDetails.Rows[0]["ADMINUSER_YN"].ToString());
UserConID = Convert.ToInt32(dtUserDetails.Rows[0]["CONID_NR"].ToString());
IsLoggedIn = true;
blIsAdmin = IsAdmin == 'Y' ? true : false;
}
}
}
catch (Exception ex)
{

}
}
}
clsLoggedUser objclsLoggedUser = new clsLoggedUser();
objclsLoggedUser.UserName;
objclsLoggedUser.UserID; 

Answer 1

(抱歉现在不能评论)我注意到运行该代码并最终得到" objclloggeduser的可能性相当大。UserName == null"。如果发生异常，您可以使用'clsErrorLogEntity '进行日志记录。fn_AddNewErrorLog'但是'if (!String.IsNullOrEmpty(strUserId))'没有其他错误记录。你的"catch (Exception ex)"也不记录任何东西。如果在这些位置设置断点并运行代码，就很可能找到罪魁祸首。或者在'catch (Exception ex)'集合之后:

catch (Exception ex)
if(UserName == null)
throw new IllegalStateException($"User is NULL, HELP!! Some info: {HttpContext.Current.Session.SessionID}");

为抛出设置一个断点，或者观察错误，以获得出错的线索。