public void BindUserMoney() { if (UiCommon.StringConfig.BankVersion == "1") { lteBank.Text = UiCommon.StringConfig.AddZeros(member.GetBankMoney(UiCommon.UserLoginInfo.UserID)); lteWallet.Text = UiCommon.StringConfig.AddZeros(member.GetWalletMoney(UiCommon.UserLoginInfo.UserID)); } else { lteBank.Text = UiCommon.StringConfig.AddZeros(member.GetBankMoney(UiCommon.UserLoginInfo.UserID)); //绑定游戏列表 DataTable ds1 = DbSession.Default.FromSql("SELECT * FROM dbo.TGameNameInfo").ToDataTable(); if (ds1.Rows.Count > 0) { ddlGame.DataSource = ds1; ddlGame.DataTextField = "ComName"; ddlGame.DataValueField = "NameID"; ddlGame.DataBind(); } DataSet ds = DbSession.Default.FromProc("Web_pGetDataPager") .AddInputParameter("@PageSize", DbType.Int32, anpPageIndex.PageSize) .AddInputParameter("@CurrentPage", DbType.Int32, PageIndex) .AddInputParameter("@Columns", DbType.String, "*") .AddInputParameter("@TableName", DbType.String, "Web_VUserGameMoney") .AddInputParameter("@Wheres", DbType.String, " and userid=" + UiCommon.UserLoginInfo.UserID) .AddInputParameter("@KeyName", DbType.String, "GameID") .AddInputParameter("@OrderBy", DbType.String, "GameID") .ToDataSet(); if (ds.Tables.Count > 0 && ds.Tables[1].Rows.Count > 0) { anpPageIndex.RecordCount = (int)ds.Tables[0].Rows[0][0]; anpPageIndex.CurrentPageIndex = PageIndex; rpList.DataSource = ds.Tables[1]; rpList.DataBind(); rpList.Visible = true; } else { rpList.Visible = false; } } }
protected void Page_Load(object sender, EventArgs e) { BLL.Member member = new BLL.Member(); DataRow dr = member.GetInfo(UserLoginInfo.UserID); if (dr == null) { return; } NickName = dr["NickName"].ToString(); Sex = Convert.ToInt32(dr["Sex"]); LogoID = Convert.ToInt32(dr["LogoID"]); LogoID = member.GetLogoID(Sex, LogoID); BankMoney = dr["BankMoney"].ToString(); Email = dr["Email"].ToString(); //��ȡ���Ǯ����ұ����ж�Ǯ���汾 if (UiCommon.StringConfig.BankVersion == "2") { WalletMoney = member.GetWalletMoney(UiCommon.UserLoginInfo.UserID).ToString(); } else { WalletMoney = dr["WalletMoney"].ToString(); } AllMoney = (Convert.ToInt64(BankMoney) + Convert.ToInt64(WalletMoney)).ToString(); OnLineTimeCount = member.ConverTimeToDHMS(member.GetOnLineTimeSum(UserLoginInfo.UserID)); //PlayTimeCount = member.ConverTimeToDHMS(member.GetPlayTimeSum(UserLoginInfo.UserID)); PlayTimeCount = member.ConverTimeToDHMS(member.GetAllPlayTimeByUserID(UserLoginInfo.UserID)); AllLoginCount = dr["AllLoginTime"].ToString(); // string str = dr["RegisterTM"].ToString(); RegisterTM = Convert.ToDateTime(dr["RegisterTM"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); LastLoginTM = Convert.ToDateTime(dr["LastLoginTM"]).ToString("yyyy-MM-dd HH:mm:ss"); UserFasci = dr["Fascination"].ToString(); Phone = dr["Phone"].ToString(); RealName = dr["RealName"].ToString(); Lotteries = dr["Lotteries"].ToString(); //ZhiYe = dr["OccuPation"].ToString(); //Address = dr["AdrProvince"].ToString() + dr["AdrCity"].ToString() + dr["AdrZone"].ToString(); //Paiming //VipTime-------------- VipTime = dr["VipTime2"].ToString(); DateTime dtNow = DateTime.Now; if (Convert.ToDateTime(VipTime) > dtNow) { VipTime = Convert.ToDateTime(VipTime).ToString("yyyy-MM-dd"); } else { DateTime dtInit = new DateTime(1970, 01, 01, 08, 00, 00); if (Convert.ToDateTime(VipTime) > dtInit) { VipTime = "<a href=\"/Manage/VipApply.aspx\" class=\"red\">����VIP�Ѿ����ڣ���������</a>"; } else { VipTime = "<a href=\"/Manage/VipApply.aspx\" class=\"red\">��������VIP����������</a>"; } } //UserHeadImg------------- //if (LogoID >= 1 && LogoID <= 255)//ϵͳĬ��ͷ�� 1<=LogoID<=255 if (LogoID >= BLL.Member.LogoId_Const1 && LogoID <= BLL.Member.LogoId_Const2) { if (Sex == 1) { UserHeadImg = "/Image/Users/b_" + LogoID + ".png"; } else { UserHeadImg = "/Image/Users/g_" + LogoID + ".png"; } } else if (LogoID >= BLL.Member.LogoId_Const3 && LogoID <= BLL.Member.LogoId_Const4) //�ϴ����Զ���ͷ�� 256<=LogoID<=512 { int childDirName = Convert.ToInt32(UiCommon.UserLoginInfo.UserID) / 1000; UserHeadImg = "/Upload/" + UiCommon.StringConfig.UserCustHeadFolderName + "/" + childDirName + "/" + UiCommon.UserLoginInfo.UserID + ".png"; } else if (LogoID > BLL.Member.LogoId_Const4) //�ϴ����Զ���ͷ�� LogoID>512 ����˻��й���ʱ����Զ���ͷ�� { int childDirName = Convert.ToInt32(UiCommon.UserLoginInfo.UserID) / 1000; UserHeadImg = "/Upload/" + UiCommon.StringConfig.UserCustHeadFolderName + "/" + childDirName + "/" + UiCommon.UserLoginInfo.UserID + ".png"; } GameTimeCount = member.ConverTimeToDHMS(GetPlayTimeCount(UserLoginInfo.UserID)); }
protected void Page_Load(object sender, EventArgs e) { BLL.Member member = new BLL.Member(); DataRow dr = member.GetInfo(UserLoginInfo.UserID); if (dr == null) { return; } NickName = dr["NickName"].ToString(); Sex = Convert.ToInt32(dr["Sex"]); LogoID = Convert.ToInt32(dr["LogoID"]); LogoID = member.GetLogoID(Sex, LogoID); BankMoney = dr["BankMoney"].ToString(); Email = dr["Email"].ToString(); //获取玩家钱包金币必须判断钱包版本 if (UiCommon.StringConfig.BankVersion == "2") { WalletMoney = member.GetWalletMoney(UiCommon.UserLoginInfo.UserID).ToString(); } else { WalletMoney = dr["WalletMoney"].ToString(); } AllMoney = (Convert.ToInt64(BankMoney) + Convert.ToInt64(WalletMoney)).ToString(); OnLineTimeCount = member.ConverTimeToDHMS(member.GetOnLineTimeSum(UserLoginInfo.UserID)); //PlayTimeCount = member.ConverTimeToDHMS(member.GetPlayTimeSum(UserLoginInfo.UserID)); PlayTimeCount = member.ConverTimeToDHMS(member.GetAllPlayTimeByUserID(UserLoginInfo.UserID)); AllLoginCount = dr["AllLoginTime"].ToString(); // string str = dr["RegisterTM"].ToString(); RegisterTM = Convert.ToDateTime(dr["RegisterTM"].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); LastLoginTM = Convert.ToDateTime(dr["LastLoginTM"]).ToString("yyyy-MM-dd HH:mm:ss"); UserFasci = dr["Fascination"].ToString(); Phone = dr["Phone"].ToString(); RealName = dr["RealName"].ToString(); Lotteries = dr["Lotteries"].ToString(); //ZhiYe = dr["OccuPation"].ToString(); //Address = dr["AdrProvince"].ToString() + dr["AdrCity"].ToString() + dr["AdrZone"].ToString(); //Paiming //VipTime-------------- VipTime = dr["VipTime2"].ToString(); DateTime dtNow = DateTime.Now; if (Convert.ToDateTime(VipTime) > dtNow) { VipTime = Convert.ToDateTime(VipTime).ToString("yyyy-MM-dd"); } else { DateTime dtInit = new DateTime(1970, 01, 01, 08, 00, 00); if (Convert.ToDateTime(VipTime) > dtInit) { VipTime = "<a href=\"/Manage/VipApply.aspx\" class=\"red\">您的VIP已经过期,立即申请</a>"; } else { VipTime = "<a href=\"/Manage/VipApply.aspx\" class=\"red\">您还不是VIP,立即申请</a>"; } } //UserHeadImg------------- //if (LogoID >= 1 && LogoID <= 255)//系统默认头像 1<=LogoID<=255 if (LogoID >= BLL.Member.LogoId_Const1 && LogoID <= BLL.Member.LogoId_Const2) { if (Sex == 1) { UserHeadImg = "/Image/Users/b_" + LogoID + ".png"; } else { UserHeadImg = "/Image/Users/g_" + LogoID + ".png"; } } else if (LogoID >= BLL.Member.LogoId_Const3 && LogoID <= BLL.Member.LogoId_Const4) //上传的自定义头像 256<=LogoID<=512 { int childDirName = Convert.ToInt32(UiCommon.UserLoginInfo.UserID) / 1000; UserHeadImg = "/Upload/" + UiCommon.StringConfig.UserCustHeadFolderName + "/" + childDirName + "/" + UiCommon.UserLoginInfo.UserID + ".png"; } else if (LogoID > BLL.Member.LogoId_Const4) //上传的自定义头像 LogoID>512 需审核或有过期时间的自定义头像 { int childDirName = Convert.ToInt32(UiCommon.UserLoginInfo.UserID) / 1000; UserHeadImg = "/Upload/" + UiCommon.StringConfig.UserCustHeadFolderName + "/" + childDirName + "/" + UiCommon.UserLoginInfo.UserID + ".png"; } GameTimeCount = member.ConverTimeToDHMS(GetPlayTimeCount(UserLoginInfo.UserID)); }