protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
UserInfo userInfo = accountsFacade.GetUserBaseInfoByUserID(Fetch.GetUserCookie().UserID);
this.lblAccounts.Text = userInfo.Accounts;
this.lblGameID.Text = userInfo.GameID.ToString();
Message umsg = treasureFacade.GetUserSpreadInfo(Fetch.GetUserCookie().UserID);
if (umsg.Success)
{
RecordSpreadInfo spreader = umsg.EntityList[0] as RecordSpreadInfo;
this.lblInsure.Text = spreader.InsureScore.ToString();
this.lblRecord.Text = spreader.RecordID.ToString();
this.lblScore.Text = spreader.Score.ToString();
this.txtScore.Text = spreader.RecordID.ToString();
}
GameScoreInfo scoreInfo = treasureFacade.GetTreasureInfo2(Fetch.GetUserCookie().UserID);
if (scoreInfo != null)
{
this.lblInsureScore.Text = scoreInfo.InsureScore.ToString( );
}
}
Themes.Standard.Common_Header sHeader = (Themes.Standard.Common_Header) this.FindControl("sHeader");
sHeader.title = "会员中心";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
UserInfo userInfo = FacadeManage.aideAccountsFacade.GetUserBaseInfoByUserID(Fetch.GetUserCookie().UserID);
this.lblAccounts.Text = userInfo.Accounts;
this.lblGameID.Text = userInfo.GameID.ToString();
Message umsg = FacadeManage.aideTreasureFacade.GetUserSpreadInfo(Fetch.GetUserCookie().UserID);
if (umsg.Success)
{
RecordSpreadInfo spreader = umsg.EntityList[0] as RecordSpreadInfo;
this.lblInsure.Text = spreader.InsureScore.ToString();
this.lblRecord.Text = spreader.RecordID.ToString();
this.lblScore.Text = spreader.Score.ToString();
this.txtScore.Text = spreader.RecordID.ToString();
}
GameScoreInfo scoreInfo = FacadeManage.aideTreasureFacade.GetTreasureInfo2(Fetch.GetUserCookie().UserID);
if (scoreInfo != null)
{
this.lblInsureScore.Text = scoreInfo.InsureScore.ToString();
}
}
}
/// <summary>
/// 获取单个结算总额
/// </summary>
/// <param name="userID"></param>
/// <returns></returns>
public long GetUserSpreaderTotal(string sWhere)
{
string sql = "SELECT SUM(Score) AS Score FROM RecordSpreadInfo ";
if (sWhere != "" && sWhere != null)
{
sql += sWhere;
}
RecordSpreadInfo spreader = Database.ExecuteObject <RecordSpreadInfo>(sql);
return(spreader == null ? 0 : spreader.Score);
}
public long GetUserSpreaderTotal(string sWhere)
{
string text = "SELECT SUM(Score) AS Score FROM RecordSpreadInfo ";
if (sWhere != "" && sWhere != null)
{
text += sWhere;
}
RecordSpreadInfo recordSpreadInfo = base.Database.ExecuteObject <RecordSpreadInfo>(text);
long result;
if (recordSpreadInfo != null)
{
result = recordSpreadInfo.Score;
}
else
{
result = 0L;
}
return(result);
}
