/// <summary>
/// 获取全部推广人数
/// </summary>
/// <param name="UserId">用Id</param>
/// <returns>返回推广人数</returns>
public Double GetAllSpreadCount(int UserId)
{
GameUserServers gus = new GameUserServers();
GameUser gu = gus.GetGameUser(UserId);
try
{
if (gu.IsSpreader == 1)
{
string sql = "select count(*) from game_users where source=@UserId";
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@UserId", UserId)
};
return(db.ExecuteScalar(sql, sp));
}
else if (gu.IsSpreader == 2)
{
Double SpreadCount = 0;
List <GameUser> list = new List <GameUser>();
list = gus.GetSpreadUser(UserId);
list.Add(gu);
foreach (GameUser gameuser in list)
{
string sql = "select count(*) from game_users where source=@UserId";
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@UserId", gameuser.Id)
};
SpreadCount += db.ExecuteScalar(sql, sp);
}
return(SpreadCount);
}
else
{
return(0);
}
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
/// <summary>
/// 获取推广员的推广总额
/// </summary>
/// <param name="UserId">用户Id</param>
/// <returns>返回总金额</returns>
public Double GetSumMoney(int UserId, string WhereStr)
{
GameUserServers gus = new GameUserServers();
GameUser gu = gus.GetGameUser(UserId);
try
{
if (gu.IsSpreader == 1)
{
string sql = "select ISNULL(sum(o.paymoney),0) from orders as o, game_users as gu where o.username in" +
"(select username from game_users where source=@UserId)and o.state=2 and o.orderno like 'G%' and o.username=gu.username and o.gameid = gu.reggame and gu.isspreader=0 " + WhereStr;
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@UserId", UserId)
};
return(db.ExecuteScalar(sql, sp));
}
else if (gu.IsSpreader == 2)
{
Double SpreadMoney = 0;
List <GameUser> list = new List <GameUser>();
list = gus.GetSpreadUser(UserId);
foreach (GameUser gameuser in list)
{
SpreadMoney += GetSumMoney(gameuser.Id, WhereStr);
}
return(SpreadMoney);
}
else
{
string sql = "select ISNULL(sum(o.paymoney),0) from orders as o, game_users as gu where o.username=@UserName and o.state=2 and o.orderno like 'G%' and o.username=gu.username and o.gameid = gu.reggame and gu.isspreader=0 " + WhereStr;
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@UserName", gu.UserName)
};
return(db.ExecuteScalar(sql, sp));
}
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
/// <summary>
/// 获取全部推广人数
/// </summary>
/// <param name="UserId">用Id</param>
/// <returns>返回推广人数</returns>
public Double GetAllSpreadCount(int UserId)
{
GameUserServers gus = new GameUserServers();
GameUser gu = gus.GetGameUser(UserId);
try
{
if (gu.IsSpreader == 1)
{
string sql = "select count(*) from game_users where source=@UserId";
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@UserId",UserId)
};
return db.ExecuteScalar(sql, sp);
}
else if (gu.IsSpreader == 2)
{
Double SpreadCount = 0;
List<GameUser> list = new List<GameUser>();
list = gus.GetSpreadUser(UserId);
list.Add(gu);
foreach (GameUser gameuser in list)
{
string sql = "select count(*) from game_users where source=@UserId";
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@UserId",gameuser.Id)
};
SpreadCount += db.ExecuteScalar(sql, sp);
}
return SpreadCount;
}
else
{
return 0;
}
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}
/// <summary>
/// 获取推广员的推广总额
/// </summary>
/// <param name="UserId">用户Id</param>
/// <returns>返回总金额</returns>
public Double GetSumMoney(int UserId, string WhereStr)
{
GameUserServers gus = new GameUserServers();
GameUser gu = gus.GetGameUser(UserId);
try
{
if (gu.IsSpreader == 1)
{
string sql = "select ISNULL(sum(o.paymoney),0) from orders as o, game_users as gu where o.username in" +
"(select username from game_users where source=@UserId)and o.state=2 and o.orderno like 'G%' and o.username=gu.username and o.gameid = gu.reggame and gu.isspreader=0 " + WhereStr;
SqlParameter[] sp = new SqlParameter[]{
new SqlParameter("@UserId",UserId)
};
return db.ExecuteScalar(sql, sp);
}
else if (gu.IsSpreader == 2)
{
Double SpreadMoney = 0;
List<GameUser> list = new List<GameUser>();
list = gus.GetSpreadUser(UserId);
foreach (GameUser gameuser in list)
{
SpreadMoney += GetSumMoney(gameuser.Id, WhereStr);
}
return SpreadMoney;
}
else
{
string sql = "select ISNULL(sum(o.paymoney),0) from orders as o, game_users as gu where o.username=@UserName and o.state=2 and o.orderno like 'G%' and o.username=gu.username and o.gameid = gu.reggame and gu.isspreader=0 " + WhereStr;
SqlParameter[] sp = new SqlParameter[]{
new SqlParameter("@UserName",gu.UserName)
};
return db.ExecuteScalar(sql, sp);
}
}
catch (SqlException ex)
{
throw new Exception("数据库异常！原因：" + ex.Message);
}
catch (Exception ex)
{
throw new Exception("未知异常！原因：" + ex.Message);
}
}