private void BindData()
{
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(base._Site.ID.ToString() + "MemberChase" + base._User.ID.ToString());
string condition = string.Concat(new object[] { "[UserID] = ", base._User.ID.ToString(), " and SiteID = ", base._Site.ID });
if (this.isDateValid())
{
string str2 = condition;
condition = str2 + " and Convert(datetime,[DateTime]) between '" + this.txtStartDate.Text + " 0:0:0' and '" + this.txtEndDate.Text + " 23:59:59'";
}
if (cacheAsDataTable == null)
{
cacheAsDataTable = new Views.V_ChaseTasksTotal().Open("", condition, "[DateTime] desc");
if (cacheAsDataTable == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Room_ViewChase");
return;
}
Shove._Web.Cache.SetCache(base._Site.ID.ToString() + "MemberChase" + base._User.ID.ToString(), cacheAsDataTable);
}
PF.DataGridBindData(this.g1, cacheAsDataTable, this.gPager1);
this.gPager1.Visible = true;
this.lblPageBuyMoney.Text = PF.GetSumByColumn(cacheAsDataTable, 12, true, this.gPager1.PageSize, this.gPager1.PageIndex).ToString("N");
this.lblTotalBuyMoney.Text = PF.GetSumByColumn(cacheAsDataTable, 12, false, this.gPager1.PageSize, this.gPager1.PageIndex).ToString("N");
}
private void BindData(int ChaseID)
{
DataTable dt = new Views.V_ChaseTasksTotal().Open("", "ID = " + ChaseID.ToString(), "");
if ((dt == null) || (dt.Rows.Count < 1))
{
PF.GoError(4, "没有追号！", "Admin_ChaseDetail");
}
else
{
DataRow row = dt.Rows[0];
this.labChase_id.Text = ChaseID.ToString();
this.labTitle.Text = row["Title"].ToString().Trim();
this.Label1.Text = row["LotteryName"].ToString();
this.tbInitiateUserID.Value = row["UserID"].ToString();
this.Label3.Text = row["Description"].ToString();
double num = _Convert.StrToDouble(row["SumMoney"].ToString(), 0.0);
int num2 = _Convert.StrToInt(row["SumIsuseNum"].ToString(), 0);
int num3 = _Convert.StrToInt(row["BuyedIsuseNum"].ToString(), 0);
int num4 = _Convert.StrToInt(row["QuashedIsuseNum"].ToString(), 0);
double num5 = _Convert.StrToDouble(row["BuyedMoney"].ToString(), 0.0);
double num6 = _Convert.StrToDouble(row["QuashedMoney"].ToString(), 0.0);
try
{
double num1 = num / ((double)num2);
}
catch
{
PF.GoError(4, "投注记录有错误", "Admin_ChaseDetail");
return;
}
this.Label4.Text = "</font>; 共<font color='red'>" + num2.ToString() + "</font>期<font color='red'>" + num.ToString("N") + "</font>元; 已完成<font color='red'>" + num3.ToString() + "</font>期<font color='red'>" + num5.ToString("N") + "</font>元; 已取消<font color='red'>" + num4.ToString() + "</font>期<font color='red'>" + num6.ToString("N") + "</font>元。";
this.btnQuash.Enabled = num2 > (num3 + num4);
dt = new Views.V_ChaseTaskDetails().Open("", "ChaseTaskID = " + ChaseID.ToString(), "[DateTime]");
if (dt != null)
{
this.LbPlayTypeName.Text = dt.Rows[0]["PlayTypeName"].ToString();
PF.DataGridBindData(this.g, dt);
}
else
{
PF.GoError(4, "没有追号记录", "Room_ChaseDetail");
}
}
}
private void BindData(int ChaseID)
{
DataTable dt = new Views.V_ChaseTasksTotal().Open("", "ID = " + ChaseID.ToString() + " and UserID=" + base._User.ID.ToString(), "");
if ((dt == null) || (dt.Rows.Count < 1))
{
PF.GoError(4, "您还没有追号！", base.GetType().FullName);
}
else
{
DataRow row = dt.Rows[0];
this.labChase_id.Text = ChaseID.ToString();
this.Label1.Text = row["LotteryName"].ToString();
this.Label3.Text = row["Description"].ToString();
double num2 = _Convert.StrToDouble(row["SumMoney"].ToString(), 0.0);
int num3 = _Convert.StrToInt(row["SumIsuseNum"].ToString(), 0);
int num4 = _Convert.StrToInt(row["BuyedIsuseNum"].ToString(), 0);
int num5 = _Convert.StrToInt(row["QuashedIsuseNum"].ToString(), 0);
double num6 = _Convert.StrToDouble(row["BuyedMoney"].ToString(), 0.0);
double num7 = _Convert.StrToDouble(row["QuashedMoney"].ToString(), 0.0);
try
{
double num1 = num2 / ((double)num3);
}
catch
{
PF.GoError(4, "投注记录有错误", base.GetType().FullName);
return;
}
this.Label4.Text = "</font>共<font color='red'>" + num3.ToString() + "</font>期<font color='red'>" + num2.ToString("N") + "</font>元; 已完成<font color='red'>" + num4.ToString() + "</font>期<font color='red'>" + num6.ToString("N") + "</font>元; 已取消<font color='red'>" + num5.ToString() + "</font>期<font color='red'>" + num7.ToString("N") + "</font>元。";
this.btnQuash.Enabled = num3 > (num4 + num5);
dt = new Views.V_ChaseTaskDetails().Open("", "ChaseTaskID = " + ChaseID.ToString(), "[DateTime]");
if ((dt != null) && (dt.Rows.Count >= 1))
{
this.LbPlayTypeName.Text = dt.Rows[0]["PlayTypeName"].ToString();
PF.DataGridBindData(this.g, dt);
}
else
{
PF.GoError(4, "没有追号记录", base.GetType().FullName);
}
}
}
