public static bool SetUserWealthBuffer()
{
try
{
if (mapUserWealth == null)
mapUserWealth = new Dictionary<int, UserWealth>();
else
mapUserWealth.Clear();
if (sqlConn.State == ConnectionState.Closed)
sqlConn.Open();
sqlCmd = new SqlCommand("GetUserWealth" + playId, sqlConn);
sqlReader = sqlCmd.ExecuteReader();
while (sqlReader.Read())
{
UserWealth userWealth = new UserWealth();
userWealth.Initialize();
userWealth.UserID = Convert.ToInt32(sqlReader["UserID"]);
userWealth.RMB = Convert.ToDecimal(sqlReader["WealthRMB"]);
userWealth.USD = Convert.ToDecimal(sqlReader["WealthUSD"]);
userWealth.HKD = Convert.ToDecimal(sqlReader["WealthHKD"]);
if (!mapUserWealth.ContainsKey(userWealth.UserID))
{
mapUserWealth.Add(userWealth.UserID, userWealth);
}
}
sqlReader.Close();
Common.Log("mapUserWealth 加载成功.数目[" + mapUserWealth.Count.ToString() + "]");
if (!GetDataSetUserWealth())
{
Log("mapUserWealth DataSet转换失败");
return false;
}
else
{
Log("mapUserWealth DataSet转换成功");
}
return true;
}
catch (Exception err)
{
Common.Log(err.ToString());
return false;
}
finally
{
if (sqlConn.State != ConnectionState.Closed)
sqlConn.Close();
}
}
public static bool SetUserWealthBuffer()
{
try
{
if (mapUserWealth == null)
{
mapUserWealth = new Dictionary <int, UserWealth>();
}
else
{
mapUserWealth.Clear();
}
if (sqlConn.State == ConnectionState.Closed)
{
sqlConn.Open();
}
sqlCmd = new SqlCommand("GetUserWealth" + playId, sqlConn);
sqlReader = sqlCmd.ExecuteReader();
while (sqlReader.Read())
{
UserWealth userWealth = new UserWealth();
userWealth.Initialize();
userWealth.UserID = Convert.ToInt32(sqlReader["UserID"]);
userWealth.RMB = Convert.ToDecimal(sqlReader["WealthRMB"]);
userWealth.USD = Convert.ToDecimal(sqlReader["WealthUSD"]);
userWealth.HKD = Convert.ToDecimal(sqlReader["WealthHKD"]);
if (!mapUserWealth.ContainsKey(userWealth.UserID))
{
mapUserWealth.Add(userWealth.UserID, userWealth);
}
}
sqlReader.Close();
Common.Log("mapUserWealth 加载成功.数目[" + mapUserWealth.Count.ToString() + "]");
if (!GetDataSetUserWealth())
{
Log("mapUserWealth DataSet转换失败");
return(false);
}
else
{
Log("mapUserWealth DataSet转换成功");
}
return(true);
}
catch (Exception err)
{
Common.Log(err.ToString());
return(false);
}
finally
{
if (sqlConn.State != ConnectionState.Closed)
{
sqlConn.Close();
}
}
}