private void BindData()
{
string filterCondition = this.GetFilterCondition();
DataTable dt = new Views.V_UserDistills().Open("", filterCondition, "[DateTime] desc");
if (dt == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_FinanceDistill");
}
else
{
PF.DataGridBindData(this.g, dt, this.gPager);
for (int i = 0; i < this.g.Columns.Count; i++)
{
if ((((this.g.Columns[i].HeaderText == "提款银行卡帐号") || (this.g.Columns[i].HeaderText == "开户银行")) || ((this.g.Columns[i].HeaderText == "支行名称") || (this.g.Columns[i].HeaderText == "所在省"))) || ((this.g.Columns[i].HeaderText == "所在市") || (this.g.Columns[i].HeaderText == "持卡人姓名")))
{
this.g.Columns[i].Visible = (this.hfCurPayType.Value == "所有") || (this.hfCurPayType.Value == "银行卡");
}
else if (this.g.Columns[i].HeaderText == "支付宝账号")
{
this.g.Columns[i].Visible = true;
this.g.Columns[i].Visible = (this.hfCurPayType.Value == "所有") || (this.hfCurPayType.Value == "支付宝");
}
}
}
}
private void BindData(bool IsReload)
{
string key = "Admin_UserDistillWaitPay_" + this.tbBeginTime.Text + "_" + this.tbEndTime.Text;
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key);
if ((cacheAsDataTable == null) || IsReload)
{
cacheAsDataTable = new Views.V_UserDistills().Open("", "Result=10 and SiteID = " + base._Site.ID.ToString(), "[DateTime] desc");
Shove._Web.Cache.SetCache(key, cacheAsDataTable);
}
if (cacheAsDataTable == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_FinanceDistill");
}
else
{
string filterCondition = this.GetFilterCondition();
DataView dv = new DataView(cacheAsDataTable, filterCondition, "[DateTime] desc", DataViewRowState.OriginalRows);
PF.DataGridBindData(this.g, dv, this.gPager);
for (int i = 0; i < this.g.Columns.Count; i++)
{
if ((((this.g.Columns[i].HeaderText == "提款银行卡帐号") || (this.g.Columns[i].HeaderText == "开户银行")) || ((this.g.Columns[i].HeaderText == "支行名称") || (this.g.Columns[i].HeaderText == "所在省"))) || ((this.g.Columns[i].HeaderText == "所在市") || (this.g.Columns[i].HeaderText == "持卡人姓名")))
{
this.g.Columns[i].Visible = (this.hfCurPayType.Value == "所有") || (this.hfCurPayType.Value == "银行卡");
}
else if (this.g.Columns[i].HeaderText == "支付宝账号")
{
this.g.Columns[i].Visible = true;
this.g.Columns[i].Visible = (this.hfCurPayType.Value == "所有") || (this.hfCurPayType.Value == "支付宝");
}
}
}
}
private void BindData(bool IsReload)
{
this.lblTotalDistillMoney.Text = "0";
this.lblTotalFormalitiesFees.Text = "0";
this.lblTotalPayMoney.Text = "0";
DateTime now = DateTime.Now;
DateTime result = DateTime.Now;
if (!DateTime.TryParse(this.tbBeginTime.Text, out now) || !DateTime.TryParse(this.tbEndTime.Text, out result))
{
JavaScript.Alert(this.Page, "请输入正确的日期范围!");
}
else
{
string text1 = "Admin_UserDistillSuccess_Data_" + this.tbBeginTime.Text + "_" + this.tbEndTime.Text;
string filterCondition = this.GetFilterCondition();
DataTable dt = new Views.V_UserDistills().Open("", filterCondition, "[DateTime] desc");
if (dt == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_FinanceDistill");
}
else
{
double num = 0.0;
double num2 = 0.0;
for (int i = 0; i < dt.Rows.Count; i++)
{
num += _Convert.StrToDouble(dt.Rows[i]["Money"].ToString(), 0.0);
num2 += _Convert.StrToDouble(dt.Rows[i]["FormalitiesFees"].ToString(), 0.0);
}
this.lblTotalDistillMoney.Text = num.ToString();
this.lblTotalFormalitiesFees.Text = num2.ToString();
this.lblTotalPayMoney.Text = (num - num2).ToString();
PF.DataGridBindData(this.g, dt, this.gPager);
for (int j = 0; j < this.g.Columns.Count; j++)
{
if ((((this.g.Columns[j].HeaderText == "提款银行卡帐号") || (this.g.Columns[j].HeaderText == "开户银行")) || ((this.g.Columns[j].HeaderText == "支行名称") || (this.g.Columns[j].HeaderText == "所在省"))) || ((this.g.Columns[j].HeaderText == "所在市") || (this.g.Columns[j].HeaderText == "持卡人姓名")))
{
this.g.Columns[j].Visible = (this.hfCurPayType.Value == "所有") || (this.hfCurPayType.Value == "银行卡");
}
else if (this.g.Columns[j].HeaderText == "支付宝账号")
{
this.g.Columns[j].Visible = true;
this.g.Columns[j].Visible = (this.hfCurPayType.Value == "所有") || (this.hfCurPayType.Value == "支付宝");
}
}
}
}
}
private bool IsFirstDistill()
{
if (base._User == null)
{
return(false);
}
string text1 = "Room_UserDistills_" + base._User.ID.ToString();
DataTable table = new Views.V_UserDistills().Open("ID,[DateTime],[Money],FormalitiesFees,Result,Memo", "[UserID] = " + base._User.ID.ToString(), "[DateTime] desc, [ID]");
if ((table != null) && (table.Rows.Count > 0))
{
return(false);
}
return(true);
}
private void BindData()
{
short num = 0;
DataTable table = new Views.V_UserDistills().Open("", "Result = " + num.ToString(), "[DateTime]");
if (table == null)
{
PF.GoError(4, "数据库繁忙，请重试", base.GetType().BaseType.FullName);
}
else
{
this.g.DataSource = table;
this.g.DataBind();
this.labTip.Visible = table.Rows.Count == 0;
}
}
private void BindDistills()
{
if (base._User != null)
{
string key = "Room_UserDistills_" + base._User.ID.ToString();
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key);
if (cacheAsDataTable == null)
{
cacheAsDataTable = new Views.V_UserDistills().Open("ID,[DateTime],[Money],FormalitiesFees,Result,Memo", "[UserID] = " + base._User.ID.ToString(), "[DateTime] desc, [ID]");
if (cacheAsDataTable == null)
{
PF.GoError(4, "数据库繁忙，请重试(732)", base.GetType().FullName);
return;
}
Shove._Web.Cache.SetCache(key, cacheAsDataTable, 60);
}
this.gUserDistills.DataSource = cacheAsDataTable;
this.gUserDistills.DataBind();
this.lblDistillCount.Text = cacheAsDataTable.Rows.Count.ToString();
this.lblDistillMoney.Text = PF.GetSumByColumn(cacheAsDataTable, 2, false, this.gUserDistills.PageSize, 0).ToString("N");
}
}
private void BindData()
{
if (this.ddlYear.Items.Count != 0)
{
DataTable table;
long num = _Convert.StrToLong(this.tbID.Text, -1L);
if (this.tbID.Text == "-1")
{
table = new Views.V_UserDistills().Open("", "SiteID = " + base._Site.ID.ToString() + " and year([DateTime]) = " + Utility.FilteSqlInfusion(this.ddlYear.SelectedValue) + " and month([DateTime]) = " + Utility.FilteSqlInfusion(this.ddlMonth.SelectedValue), "[DateTime] desc");
}
else
{
table = new Views.V_UserDistills().Open("", "SiteID = " + base._Site.ID.ToString() + " and UserID = " + num.ToString() + " and year([DateTime]) = " + Utility.FilteSqlInfusion(this.ddlYear.SelectedValue) + " and month([DateTime]) = " + Utility.FilteSqlInfusion(this.ddlMonth.SelectedValue), "[DateTime] desc");
}
if (table == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_FinanceDistill");
}
else
{
PF.DataGridBindData(this.g, table, this.gPager);
}
}
}
