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 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 (_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 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());
}
}
}
