private void BindUserAccount() { string request = Utility.GetRequest("dt"); StringBuilder builder = new StringBuilder(); builder.AppendFormat("SiteID={0} and Buyed=1 and replace(CONVERT(char(10),[DateTime],111),'/','-')='{1}' ", base._Site.ID, request); builder.AppendFormat("and UserID in (Select ID from T_Users where CpsID in (Select ID from T_Cps where CommendID={0})) ", base._User.ID); DataTable dt = new Views.V_BuyDetails().Open("IsuseName, SchemeNumber, LotteryName, PlayTypeName,Money,DetailMoney, DateTime", builder.ToString(), "DateTime desc"); if (dt == null) { PF.GoError(4, "数据库繁忙,请重试", base.GetType().BaseType.FullName); } else { PF.DataGridBindData(this.g, dt, this.gPager); this.gPager.Visible = this.g.PageCount > 1; } }
private void PopNews() { if (_User == null) { return; } string CacheKeyName = "Get_Win_Info_" + _User.ID.ToString(); DataTable dt = Shove._Web.Cache.GetCacheAsDataTable("Get_Win_Info_" + _User.ID.ToString()); if (dt == null) { dt = new DAL.Views.V_BuyDetails().Open("top 1 LotteryName,IsuseName,WinLotteryNumber,LotteryNumber,WinMoneyNoWithTax", "IsOpened = 1 and UserID = " + _User.ID, "ID DESC"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试(537)", this.GetType().FullName); return; } Shove._Web.Cache.SetCache(CacheKeyName, dt, 300); } StringBuilder sb = new StringBuilder(); sb.Append(_User.Name).Append(","); if (dt.Rows.Count != 0) { string SiteUrl = Shove._Web.Utility.GetUrl(); for (int i = 0; i < dt.Rows.Count; i++) { sb.Append(dt.Rows[i]["LotteryName"].ToString()).Append("第") .Append(dt.Rows[i]["IsuseName"].ToString()).Append("期中奖号码是 ") .Append(dt.Rows[i]["WinLotteryNumber"].ToString()) .Append(" 您投注的号码是") .Append(Shove._String.Cut(dt.Rows[i]["LotteryNumber"].ToString(), 15)).Append(" ,") .Append(Shove._Convert.StrToDouble(dt.Rows[i]["WinMoneyNoWithTax"].ToString(), 0) > 0 ? "<font style='color:red;'>中奖了</font>,希望您再接再厉,夺得更多奖金。" : "没有中奖,希望您继续努力,祝您早日中大奖。"); } string FloatNotify = HmtlManage.GetHtml(AppDomain.CurrentDomain.BaseDirectory + "Home/Room/Template/FloatNotify.html"); label1.Text = FloatNotify.Replace("$FloatNotifyContent$", sb.ToString()); } }
private void BindUserAccount() { string strDateTime = Shove._Web.Utility.GetRequest("dt"); StringBuilder sb = new StringBuilder(); sb.AppendFormat("SiteID={0} and Buyed=1 and replace(CONVERT(char(10),[DateTime],111),'/','-')='{1}' ", _Site.ID, strDateTime); sb.AppendFormat("and UserID in (Select ID from T_Users where CpsID in (Select ID from T_Cps where CommendID={0})) ", _User.ID); DataTable dt = new DAL.Views.V_BuyDetails().Open("IsuseName, SchemeNumber, LotteryName, PlayTypeName,Money,DetailMoney, DateTime", sb.ToString(), "DateTime desc"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().BaseType.FullName); return; } PF.DataGridBindData(g, dt, gPager); gPager.Visible = g.PageCount > 1; }
private void PopNews() { if (base._User != null) { string key = "Get_Win_Info_" + base._User.ID.ToString(); DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable("Get_Win_Info_" + base._User.ID.ToString()); if (cacheAsDataTable == null) { cacheAsDataTable = new Views.V_BuyDetails().Open("top 1 LotteryName,IsuseName,WinLotteryNumber,LotteryNumber,WinMoneyNoWithTax", "IsOpened = 1 and UserID = " + base._User.ID, "ID DESC"); if (cacheAsDataTable == null) { PF.GoError(4, "数据库繁忙,请重试(537)", base.GetType().FullName); return; } Shove._Web.Cache.SetCache(key, cacheAsDataTable, 300); } StringBuilder builder = new StringBuilder(); builder.Append(base._User.Name).Append(","); if (cacheAsDataTable.Rows.Count != 0) { Shove._Web.Utility.GetUrl(); for (int i = 0; i < cacheAsDataTable.Rows.Count; i++) { builder.Append(cacheAsDataTable.Rows[i]["LotteryName"].ToString()).Append("第").Append(cacheAsDataTable.Rows[i]["IsuseName"].ToString()).Append("期中奖号码是 ").Append(cacheAsDataTable.Rows[i]["WinLotteryNumber"].ToString()).Append(" 您投注的号码是").Append(_String.Cut(cacheAsDataTable.Rows[i]["LotteryNumber"].ToString(), 15)).Append(" ,").Append((_Convert.StrToDouble(cacheAsDataTable.Rows[i]["WinMoneyNoWithTax"].ToString(), 0.0) > 0.0) ? "<font style='color:red;'>中奖了</font>,希望您再接再厉,夺得更多奖金。" : "没有中奖,希望您继续努力,祝您早日中大奖。"); } this.label1.Text = HmtlManage.GetHtml(AppDomain.CurrentDomain.BaseDirectory + "Home/Room/Template/FloatNotify.html").Replace("$FloatNotifyContent$", builder.ToString()); } } }