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()
{
string sql = @"select ID,Title,Content,TypeName from V_News where TypeId in (" + Newsid + ")";
DataTable dt = Shove.Database.MSSQL.Select(sql);
PF.DataGridBindData(RepTitle, dt, gPager);
}
private void BindChaseComboData()
{
string key = "Home_Room_ViewChase_BindChaseComboData" + base._User.ID.ToString() + this.tbTitle.Text;
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key);
if (cacheAsDataTable == null)
{
StringBuilder builder = new StringBuilder();
builder.Append("select a.ID,Name, DateTime,IsuseCount,IsuseCount*Multiple*Nums*Price as SumMoney,Money,QuashStatus,ExecutedCount,").Append("IsuseCount-ExecutedCount as NoExecutedCount,Title from T_Chases a inner join T_Lotteries b ").Append("on a.LotteryID = b.ID and a.UserID = " + base._User.ID.ToString() + " ");
if (this.tbTitle.Text != "")
{
builder.Append("and Title like '%" + Utility.FilteSqlInfusion(this.tbTitle.Text) + "%'");
}
builder.Append(" left join (select ChaseID,count(SchemeID) as ExecutedCount from T_ExecutedChases group by ChaseID)c on a.ID = c.ChaseID");
cacheAsDataTable = MSSQL.Select(builder.ToString(), new MSSQL.Parameter[0]);
if (cacheAsDataTable == null)
{
PF.GoError(4, "数据库繁忙，请重试", base.GetType().BaseType.FullName);
return;
}
Shove._Web.Cache.SetCache(key, cacheAsDataTable);
}
PF.DataGridBindData(this.g2, cacheAsDataTable, this.gPager2);
this.gPager2.Visible = true;
double num3 = 0.0;
foreach (DataRow row in cacheAsDataTable.Rows)
{
num3 += _Convert.StrToDouble(row["SumMoney"].ToString(), 0.0);
}
this.lblTotalMoney.Text = num3.ToString("N");
}
private void BindData()
{
string commandText = "select a.ID,Name,RealityName,IDCardNumber,Email,QQ,Telephone,Mobile,RegisterTime,BankName,BankCardNumber from T_Users a \r\n where RegisterTime between '2009-10-01 00:00:00' and '2009-10-08 23:59:59' and ID in(select UserID from T_UserPayDetails where Money >= 60 and DateTime between '2009-10-01 00:00:00' and '2009-10-08 23:59:59' and Result = 1)";
DataTable dt = MSSQL.Select(commandText, new MSSQL.Parameter[0]);
PF.DataGridBindData(this.g, dt, this.gPager);
}
private void BindData()
{
string Key = "Admin_ChaseList_BindData_" + ddlType.SelectedValue == "1" ? tbID.Text : ddlIsuses.SelectedValue;
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key);
if (dt == null)
{
StringBuilder sb = new StringBuilder();
sb.Append("select '我的追号' as Type,ID,Name,DateTime,LotteryName,Title,SumMoney,SumIsuseNum,BuyedIsuseNum,QuashedIsuseNum,QuashStatus,2 as StopType,StopWhenWinMoney from V_ChaseTasksTotal ");
if (ddlType.SelectedValue == "1")
{
sb.Append("where UserID=" + Shove._Web.Utility.FilteSqlInfusion(tbID.Text.Trim()) + " ");
}
else
{
sb.Append("where ID in(select ChaseTaskID from T_ChaseTaskDetails where IsuseID = " + ddlIsuses.SelectedValue + ") ");
}
sb.Append(" union select '追号套餐' as Type,a.ID,d.Name,DateTime,b.Name,Title,IsuseCount*Multiple*Nums*Price as SumMoney,IsuseCount,ExecutedCount,")
.Append(" IsuseCount-ExecutedCount as NoExecutedCount,QuashStatus,StopTypeWhenWin,StopTypeWhenWinMoney from T_Chases a inner join T_Lotteries b ")
.Append(" on a.LotteryID = b.ID ");
if (ddlType.SelectedValue == "1")
{
sb.Append("and UserID=" + Shove._Web.Utility.FilteSqlInfusion(tbID.Text.Trim()) + " ");
}
else
{
sb.Append("and (a.ID in (select ChaseID from T_ExecutedChases where SchemeID in(select ID from T_Schemes where IsuseID = " + ddlIsuses.SelectedValue + ")) ");
if (new DAL.Tables.T_Isuses().GetCount("ID=" + ddlIsuses.SelectedValue + " and getdate() between StartTime and EndTime") > 0)
{
sb.Append("or a.ID in (select ChaseID from T_ExecutedChases where QuashStatus = 0 and Money > 0 and LotteryID=" + ddlLottery.SelectedValue + "))");
}
else
{
sb.Append(")");
}
}
sb.Append("left join T_Users d on a.UserID = d.ID ");
sb.Append(" left join (select ChaseID,count(SchemeID) as ExecutedCount from T_ExecutedChases group by ChaseID)c on a.ID = c.ChaseID");
dt = Shove.Database.MSSQL.Select(sb.ToString());
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_ChaseList");
return;
}
Shove._Web.Cache.SetCache(Key, dt);
}
PF.DataGridBindData(g, dt, gPager);
}
private void BindData()
{
string Key = "Admin_RecallingRecord_BindData";
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key);
if (dt == null)
{
string sql = @"select b.ID,a.State,LotteryID,Level,InitiateUserID, LotteryName,InitiateName,Money,WinMoney,
WinMoney/Money as Win from T_RecallingAllBuyStar a inner join V_Schemes b
on a.SchemesID = b.ID and WinMoney>0 and Buyed = 1 and IsOpened = 1 and a.State = 0
order by WinMoney desc ";
dt = Shove.Database.MSSQL.Select(sql);
if (dt == null)
{
return;
}
Shove._Web.Cache.SetCache(Key, dt, 6000);
}
PF.DataGridBindData(g, dt, gPager);
}
private void BindData()
{
if (ddlYear.Items.Count == 0)
{
return;
}
long UserID = Shove._Convert.StrToLong(tbID.Text, -1);
DataTable dt;
if (tbID.Text == "-1")
{
dt = new DAL.Views.V_UserDetails().Open("", "SiteID = " + _Site.ID.ToString() + " and OperatorType = dbo.F_GetDetailsOperatorType('中奖') and year([DateTime]) = " + Shove._Web.Utility.FilteSqlInfusion(ddlYear.SelectedValue) + " and month([DateTime]) = " + Shove._Web.Utility.FilteSqlInfusion(ddlMonth.SelectedValue), "[DateTime] desc");
}
else
{
dt = new DAL.Views.V_UserDetails().Open("", "SiteID = " + _Site.ID.ToString() + " and UserID = " + UserID.ToString() + " and OperatorType = dbo.F_GetDetailsOperatorType('中奖') and year([DateTime]) = " + Shove._Web.Utility.FilteSqlInfusion(ddlYear.SelectedValue) + " and month([DateTime]) = " + Shove._Web.Utility.FilteSqlInfusion(ddlMonth.SelectedValue), "[DateTime] desc");
}
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_FinanceWin");
return;
}
PF.DataGridBindData(g, dt, gPager);
}
private void BindHistoryData()
{
string key = "Home_Room_Invest_BindHistoryData" + base._User.ID.ToString();
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key);
if (cacheAsDataTable == null)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * from (select LotteryID,LotteryName,PlayTypeID,InitiateName,PlayTypeName, ").Append("SchemeShare,a.Money,b.Share,b.DetailMoney,SchemeWinMoney, b.WinMoneyNoWithTax,a.DateTime, ").Append("b.SchemeID,QuashStatus,Buyed,AssureMoney,BuyedShare,IsOpened,c.Memo from ").Append("(select UserID,SchemeID,SUM(Share) as Share,SUM(DetailMoney) as DetailMoney, ").Append("sum(WinMoneyNoWithTax) as WinMoneyNoWithTax from V_BuyDetailsWithQuashedAll ").Append("where UserID = " + base._User.ID.ToString() + " and InitiateUserID = UserID group by SchemeID,UserID)b ").Append("left join (select * from V_BuyDetailsWithQuashedAll where UserID = " + base._User.ID.ToString() + " and ").Append("UserID = InitiateUserID and isWhenInitiate = 1)a ").Append("on a.UserID = b.UserID and ").Append("a.SchemeID = b.SchemeID left join (select SchemeID,Memo from T_UserDetails where ").Append("OperatorType = 9 and UserID = " + base._User.ID.ToString() + ") c ").Append("on b.SchemeID = c.SchemeID union select LotteryID,LotteryName,PlayTypeID,InitiateName, ").Append("PlayTypeName,SchemeShare,a.Money,Share,DetailMoney,SchemeWinMoney, WinMoneyNoWithTax, ").Append("a.DateTime,a.SchemeID,QuashStatus,Buyed,AssureMoney,BuyedShare,IsOpened,b.Memo from ").Append("(select * from V_BuyDetailsWithQuashedAll where UserID = " + base._User.ID.ToString() + " and UserID<>InitiateUserID) a left join (select SchemeID,Memo from T_UserDetails where ").Append("OperatorType = 9 and UserID = " + base._User.ID.ToString() + ")b on a.SchemeID = b.SchemeID)a order by DateTime desc");
cacheAsDataTable = MSSQL.Select(builder.ToString(), new MSSQL.Parameter[0]);
if (cacheAsDataTable == null)
{
PF.GoError(4, "数据库繁忙，请重试", base.GetType().BaseType.FullName);
return;
}
Shove._Web.Cache.SetCache(key, cacheAsDataTable, 60);
}
PF.DataGridBindData(this.gHistory, cacheAsDataTable, this.gPagerHistory);
int num7 = 0;
double num8 = 0.0;
foreach (DataRow row in cacheAsDataTable.Rows)
{
if (row["QuashStatus"].ToString() == "0")
{
num7++;
num8 += _Convert.StrToDouble(row["DetailMoney"].ToString(), 0.0);
}
}
this.lblBuyOutCount.Text = num7.ToString();
this.lblBuyOutMoney.Text = num8.ToString("N");
this.gPagerHistory.Visible = true;
}
private void BindData(bool IsReload)
{
DataTable dt = dt = new DAL.Views.V_UserDistills().Open("", "IsCps=1 and Result=10 and SiteID = " + _Site.ID.ToString(), "[DateTime] desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_FinanceDistill");
return;
}
string filterCondition = GetFilterCondition();
DataView dv = new DataView(dt, filterCondition, "[DateTime] desc", DataViewRowState.OriginalRows);
PF.DataGridBindData(g, dv, gPager);
//根据条件显示或隐藏列
for (int i = 0; i < g.Columns.Count; i++)
{
if (g.Columns[i].HeaderText == "提款银行卡帐号" || g.Columns[i].HeaderText == "开户银行" || g.Columns[i].HeaderText == "支行名称" ||
g.Columns[i].HeaderText == "所在省" || g.Columns[i].HeaderText == "所在市" || g.Columns[i].HeaderText == "持卡人姓名")
{
g.Columns[i].Visible = (hfCurPayType.Value == "所有" || hfCurPayType.Value == "银行卡") ? true : false;
}
else if (g.Columns[i].HeaderText == "支付宝账号")
{
g.Columns[i].Visible = true;
g.Columns[i].Visible = (hfCurPayType.Value == "所有" || hfCurPayType.Value == "支付宝") ? true : false;
}
}
}
private void BindData()
{
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 commandText = "SELECT a.ID,a.SiteID,a.UserID,a.[DateTime], a.PayType,a.[Money],a.FormalitiesFees,a.Result, \r\n\t\t\t b.Name, b.RealityName, b.Sex, b.IDCardNumber, b.[Address], b.Email, b.QQ, b.Telephone, b.Mobile\r\n FROM dbo.T_UserPayDetails a INNER JOIN dbo.T_Users b ON a.UserID = b.ID \r\n where a.[DateTime]>=@fromDate and a.[DateTime]<=@toDate ";
MSSQL.Parameter[] paras = new MSSQL.Parameter[3];
paras[0] = new MSSQL.Parameter("@fromDate", SqlDbType.DateTime, 8, ParameterDirection.Input, now);
paras[1] = new MSSQL.Parameter("@toDate", SqlDbType.DateTime, 8, ParameterDirection.Input, result);
DataTable dt = null;
if (!string.IsNullOrEmpty(this.tbName.Text.Trim()))
{
dt = MSSQL.Select(commandText + " and Name like '%" + Shove._Web.Utility.FilteSqlInfusion(this.tbName.Text.Trim()) + "%'", paras);
}
else
{
dt = MSSQL.Select(commandText, paras);
}
if (dt == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_UserForInitiateFollowSchemeTrys");
}
else
{
PF.DataGridBindData(this.g, dt, this.gPager);
}
}
}
private void BindData()
{
DataTable dt;
string condition = GetFilterCondition();
dt = new DAL.Views.V_UserDistills().Open("", condition, "[DateTime] desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_FinanceDistill");
return;
}
PF.DataGridBindData(g, dt, gPager);
//根据条件显示或隐藏列
for (int i = 0; i < g.Columns.Count; i++)
{
if (g.Columns[i].HeaderText == "提款银行卡帐号" || g.Columns[i].HeaderText == "开户银行" || g.Columns[i].HeaderText == "支行名称" ||
g.Columns[i].HeaderText == "所在省" || g.Columns[i].HeaderText == "所在市" || g.Columns[i].HeaderText == "持卡人姓名")
{
g.Columns[i].Visible = (hfCurPayType.Value == "所有" || hfCurPayType.Value == "银行卡") ? true : false;
}
else if (g.Columns[i].HeaderText == "支付宝账号")
{
g.Columns[i].Visible = true;
g.Columns[i].Visible = (hfCurPayType.Value == "所有" || hfCurPayType.Value == "支付宝") ? true : false;
}
}
}
private void BindData()
{
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Shove._Web.WebConfig.GetAppSettingsString("SystemPreFix") + _Site.ID.ToString() + "ScoringDetail_" + _User.ID.ToString() + "_DateTime" + ddlYear.SelectedValue.ToString() + ddlMonth.SelectedValue.ToString());
if (dt == null)
{
if (ddlYear.Items.Count < 1)
{
return;
}
int ReturnValue = 0;
string ReturnDescription = "";
DataSet ds = null;
DAL.Procedures.P_GetUserScoringDetail(ref ds, _Site.ID, _User.ID, int.Parse(ddlYear.SelectedValue), int.Parse(ddlMonth.SelectedValue), ref ReturnValue, ref ReturnDescription);
if ((ds == null) || (ds.Tables.Count < 1))
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Home_Room_ScoringDetail");
return;
}
dt = ds.Tables[0];
Shove._Web.Cache.SetCache(Shove._Web.WebConfig.GetAppSettingsString("SystemPreFix") + _Site.ID.ToString() + "ScoringDetail_" + _User.ID.ToString() + "_DateTime" + ddlYear.SelectedValue.ToString() + ddlMonth.SelectedValue.ToString(), dt);
}
PF.DataGridBindData(g, dt, gPager);
}
private void BindData()
{
DataTable dt = new DAL.Tables.T_Users().Open("ID,SiteID ,Name ,RealityName, IDCardNumber ,Email ,QQ,Telephone , Mobile ,isCanLogin ,Reason", "SiteID = " + _Site.ID.ToString() + "and isCanLogin= 0", "");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_Admin_UserLogOut");
return;
}
DataTable dtData = dt.Clone();
DataRow[] drs;
if (rbUser.Checked)
{
drs = dt.Select("Reason is not null");
}
else
{
drs = dt.Select("Reason is null");
}
foreach (DataRow dr in drs)
{
dtData.Rows.Add(dr.ItemArray);
}
PF.DataGridBindData(g, dtData, gPager);
}
private void BindData()
{
if (ddlYear.Items.Count == 0)
{
return;
}
int ReturnValue = -1;
string ReturnDescription = "";
DataSet ds = null;
int Results = -1;
Results = DAL.Procedures.P_GetAccount(ref ds, _Site.ID, int.Parse(ddlYear.SelectedValue), int.Parse(ddlMonth.SelectedValue), ref ReturnValue, ref ReturnDescription);
if (Results < 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_FinanceAddMoney");
return;
}
if (ReturnValue < 0)
{
PF.GoError(ErrorNumber.Unknow, ReturnDescription, "Admin_FinanceAddMoney");
return;
}
PF.DataGridBindData(g, ds.Tables[0], gPager);
}
private void BindData()
{
DataTable table = new Tables.T_Users().Open("ID,SiteID ,Name ,RealityName, IDCardNumber ,Email ,QQ,Telephone , Mobile ,isCanLogin ,Reason", "SiteID = " + base._Site.ID.ToString() + "and isCanLogin= 0", "");
if (table == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_Admin_UserLogOut");
}
else
{
DataRow[] rowArray;
DataTable dt = table.Clone();
if (this.rbUser.Checked)
{
rowArray = table.Select("Reason is not null");
}
else
{
rowArray = table.Select("Reason is null");
}
foreach (DataRow row in rowArray)
{
dt.Rows.Add(row.ItemArray);
}
PF.DataGridBindData(this.g, dt, this.gPager);
}
}
private void BindData()
{
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(_Site.ID.ToString() + "MemberChase" + _User.ID.ToString());
string Condition = "[UserID] = " + _User.ID.ToString() + " and SiteID = " + _Site.ID;
if (isDateValid())
{
Condition += " and Convert(datetime,[DateTime]) between '" + txtStartDate.Text + " 0:0:0' and '" + txtEndDate.Text + " 23:59:59'";
}
if (dt == null)
{
dt = new DAL.Views.V_ChaseTasksTotal().Open("", Condition, "[DateTime] desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Room_ViewChase");
return;
}
Shove._Web.Cache.SetCache(_Site.ID.ToString() + "MemberChase" + _User.ID.ToString(), dt);
}
PF.DataGridBindData(g1, dt, gPager1);
gPager1.Visible = true;
this.lblPageBuyMoney.Text = PF.GetSumByColumn(dt, 12, true, gPager1.PageSize, gPager1.PageIndex).ToString("N");
this.lblTotalBuyMoney.Text = PF.GetSumByColumn(dt, 12, false, gPager1.PageSize, gPager1.PageIndex).ToString("N");
}
private void BindDuiZhangDanData(bool IsReload)
{
DateTime now = DateTime.Now;
DateTime result = DateTime.Now;
if (((this.tbBeginTime.Text.Trim() != "") && (this.tbEndTime.Text.Trim() != "")) && (!DateTime.TryParse(this.tbBeginTime.Text.Trim(), out now) || !DateTime.TryParse(this.tbEndTime.Text.Trim() + " 23:59:59", out result)))
{
JavaScript.Alert(this.Page, "请输入正确的日期格式:2009-08-08");
}
else
{
string key = "Admin_UserDistillGeneralLedger_" + now.ToString("yyyyMMdd") + result.ToString("yyyyMMdd");
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key);
if ((cacheAsDataTable == null) || IsReload)
{
DataSet ds = null;
int returnValue = 0;
string returnDescription = "";
if (Procedures.P_GetDistillStatisticByDistillType(ref ds, base._Site.ID, now, result, ref returnValue, ref returnDescription) < 0)
{
PF.GoError(4, "数据读写错误", base.GetType().BaseType.FullName);
return;
}
if ((returnValue < 0) || (returnDescription != ""))
{
JavaScript.Alert(this.Page, returnDescription);
return;
}
cacheAsDataTable = ds.Tables[0];
Shove._Web.Cache.SetCache(key, cacheAsDataTable);
}
PF.DataGridBindData(this.dgDuiZhangDan, cacheAsDataTable);
string str3 = "Admin_UserDistillGeneralLedger_cacheKeyGetDistillMoneyAndAddMoney_" + now.ToString("yyyyMMdd") + result.ToString("yyyyMMdd");
DataTable table2 = Shove._Web.Cache.GetCacheAsDataTable(str3);
if ((table2 == null) || IsReload)
{
DataSet set2 = null;
int num2 = 0;
string str4 = "";
if (Procedures.P_GetDistillMoneyAndAddMoney(ref set2, base._Site.ID, now, result, 0, ref num2, ref str4) < 0)
{
PF.GoError(4, "数据读写错误", base.GetType().BaseType.FullName);
return;
}
if ((num2 < 0) || (str4 != ""))
{
JavaScript.Alert(this.Page, str4);
return;
}
table2 = set2.Tables[0];
Shove._Web.Cache.SetCache(str3, table2);
}
this.lblSumAddMoneyByDate1.Text = _Convert.StrToDouble(table2.Rows[0]["SumAddMoneyByDate"].ToString(), 0.0).ToString("N2");
this.lblSumAddMoney1.Text = _Convert.StrToDouble(table2.Rows[0]["SumAddMoney"].ToString(), 0.0).ToString("N2");
this.lblSumDistillMoneyByDate1.Text = _Convert.StrToDouble(table2.Rows[0]["SumDistillMoneyByDate"].ToString(), 0.0).ToString("N2");
this.lblSumDistillMoney1.Text = _Convert.StrToDouble(table2.Rows[0]["SumDistillMoney"].ToString(), 0.0).ToString("N2");
this.lblSumFormalitiesFeesByDate1.Text = _Convert.StrToDouble(table2.Rows[0]["SumFormalitiesFeesByDate"].ToString(), 0.0).ToString("N2");
this.lblSumFormalitiesFees1.Text = _Convert.StrToDouble(table2.Rows[0]["SumFormalitiesFees"].ToString(), 0.0).ToString("N2");
}
}
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()
{
string cacheKeyScaleList = "Cps_Admin_BonusScaleView_ScaleList_" + _User.ID.ToString();
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(cacheKeyScaleList);
if (dt == null)
{
int returnValue = -1;
string returnDescription = "";
DataSet ds = null;
int Result = DAL.Procedures.P_CpsGetUserBonusScaleList(ref ds, _User.ID, ref returnValue, ref returnDescription);
if (Result < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "系统出错!");
return;
}
if (ds == null || ds.Tables.Count < 1)
{
Shove._Web.JavaScript.Alert(this.Page, "获取数据出错!");
return;
}
dt = ds.Tables[0];
Shove._Web.Cache.SetCache(cacheKeyScaleList, dt, 100000);
}
PF.DataGridBindData(g, dt, gPager);
}
private void BindData()
{
DataTable dt = new DAL.Tables.T_UnionLinkScale().Open("ID,UnionID,SiteLinkPID,BonusScale", "UnionID=" + _User.ID, "SiteLinkPID");
DataTable dtLink = new DAL.Tables.T_Users().Open("distinct [Memo]", "Memo<>'' and CpsID=" + _User.cps.ID, "[Memo]");
double scale = _Site.SiteOptions["BonusScale"].ToDouble(0.02);
for (int i = 0; i < dtLink.Rows.Count; i++)
{
string pid = dtLink.Rows[i][0].ToString();
DataRow[] drList = dt.Select("SiteLinkPID='" + pid + "'");
if (drList.Length == 0)
{
DataRow dr = dt.NewRow();
dr["ID"] = 0;
dr["UnionID"] = _User.cps.ID;
dr["SiteLinkPID"] = pid;
dr["BonusScale"] = scale;
dt.Rows.Add(dr);
}
}
DataTable dtTemp = GetNewDataTable(dt, "SiteLinkPID like '%" + tbPID.Text.Trim() + "%'");
PF.DataGridBindData(g, dtTemp, gPager);
}
private void BindData()
{
if (ddlIsuse.Items.Count < 1)
{
return;
}
string Cmd;
if (cbUserApplication.Checked)
{
Cmd = "select * from V_SchemeSchedules where SiteID = " + _Site.ID.ToString() + " and IsuseID = " + ddlIsuse.SelectedValue + " and QuashStatus = 0 and Buyed = 0 and AtTopStatus = 1 order by [Money] desc";
}
else
{
Cmd = "select * from V_SchemeSchedules where SiteID = " + _Site.ID.ToString() + " and IsuseID = " + ddlIsuse.SelectedValue + " and QuashStatus = 0 and Buyed = 0 order by [Money] desc";
}
DataTable dt = MSSQL.Select(Cmd);
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_SchemeAtTop");
return;
}
PF.DataGridBindData(g, dt, gPager);
}
private void BindData()
{
DataTable dt = new DAL.Tables.T_ExpertsCommends().Open("", "SiteID = " + _Site.ID.ToString() + " and ExpertsID = " + Shove._Web.Utility.FilteSqlInfusion(ddlExperts.SelectedValue), "[DateTime] desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Room_ExpertsCommendsList");
return;
}
if (dt.Rows.Count > 0)
{
dt.Columns.Add("Number1", System.Type.GetType("System.String"));
foreach (DataRow dr in dt.Rows)
{
try
{
dr["Number1"] = dr["Number"];
}
catch
{
dr["Number1"] = "";
}
dt.AcceptChanges();
}
}
PF.DataGridBindData(g, dt, gPager);
}
private void BindData(int Type)
{
DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable("MemberQuestionList_" + Type.ToString() + "_" + base._User.ID.ToString());
if (cacheAsDataTable == null)
{
switch (Type)
{
case 1:
cacheAsDataTable = new Views.V_Questions().Open("", "SiteID = " + base._Site.ID.ToString() + " and UserID = " + base._User.ID.ToString() + " and UseType = 1", "[DateTime] desc");
break;
case 2:
cacheAsDataTable = new Views.V_Questions().Open("", "SiteID = " + base._Site.ID.ToString() + " and UserID = " + base._User.ID.ToString() + " and UseType = 1 and AnswerStatus = 0", "[DateTime] desc");
break;
case 3:
cacheAsDataTable = new Views.V_Questions().Open("", "SiteID = " + base._Site.ID.ToString() + " and UserID = " + base._User.ID.ToString() + " and UseType = 1 and AnswerStatus = 1", "[DateTime] desc");
break;
}
if (cacheAsDataTable == null)
{
PF.GoError(4, "数据库繁忙，请重试", base.GetType().FullName);
return;
}
Shove._Web.Cache.SetCache("MemberQuestionList_" + Type.ToString() + "_" + base._User.ID.ToString(), cacheAsDataTable);
}
PF.DataGridBindData(this.g, cacheAsDataTable, this.gPager);
}
private void BindData()
{
if (this.ddlYear.Items.Count != 0)
{
long userID = _Convert.StrToLong(this.tbID.Text, -1L);
int returnValue = -1;
string returnDescription = "";
DataSet ds = null;
if (Procedures.P_GetFinanceAddMoney(ref ds, base._Site.ID, userID, int.Parse(this.ddlYear.SelectedValue), int.Parse(this.ddlMonth.SelectedValue), ref returnValue, ref returnDescription) < 0)
{
PF.GoError(4, "数据库繁忙，请重试", base.GetType().BaseType.FullName);
}
else if ((ds == null) || (ds.Tables.Count < 1))
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_FinanceAddMoney");
}
else if (returnValue < 0)
{
PF.GoError(1, returnDescription, "Admin_FinanceAddMoney");
}
else
{
PF.DataGridBindData(this.g, ds.Tables[0], this.gPager);
}
}
}
private void BindData()
{
long ownerUserID = Shove._Convert.StrToLong(hfOwnerUserID.Value, -1);
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(cacheKeyScaleList + ownerUserID);
if (dt == null)
{
int returnValue = -1;
string returnDescription = "";
DataSet ds = null;
int Result = DAL.Procedures.P_CpsGetUserBonusScaleList(ref ds, ownerUserID, ref returnValue, ref returnDescription);
if (Result < 0)
{
Shove._Web.JavaScript.Alert(this.Page, "系统出错!");
return;
}
if (ds == null || ds.Tables.Count < 1)
{
Shove._Web.JavaScript.Alert(this.Page, "获取数据出错!");
return;
}
dt = ds.Tables[0];
Shove._Web.Cache.SetCache(cacheKeyScaleList + ownerUserID, dt, 100000);
}
PF.DataGridBindData(g, dt, gPager);
}
private void BindData()
{
DataSet ds = null;
int Results = -1;
Results = DAL.Procedures.P_GetLoginCount(ref ds, Shove._Convert.StrToInt(ddlYear.SelectedValue, 0), Shove._Convert.StrToInt(ddlMonth.SelectedValue, 0));
if (Results < 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.Page.GetType().BaseType.FullName);
return;
}
if ((ds == null) || (ds.Tables.Count < 1))
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_LoginCount");
return;
}
PF.DataGridBindData(g, ds.Tables[0], gPager);
}
private void BindData()
{
int days = int.Parse(ddlDateTime.SelectedValue);
string CmdStr;
if (days == -1)
{
CmdStr = "select * from T_SMS where SiteID = " + _Site.ID.ToString() + " and SMSID = -1 order by [DateTime] desc";
}
else
{
CmdStr = "select * from T_SMS where SiteID = " + _Site.ID.ToString() + " and Datediff(day, [DateTime], GetDate()) <= " + days.ToString() + " and SMSID = -1 order by [DateTime] desc";
}
DataTable dt = MSSQL.Select(CmdStr);
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", "Admin_SendSMSList");
return;
}
PF.DataGridBindData(g, dt, gPager);
}
private void BindData()
{
if (tv.Nodes.Count < 1)
{
return;
}
string TypeID = tv.SelectedValue;
if (TypeID == "")
{
TypeID = tv.Nodes[0].Value;
}
DataTable dt = new DAL.Tables.T_News().Open("", "SiteID = " + _Site.ID.ToString() + " and TypeID = " + Shove._Web.Utility.FilteSqlInfusion(TypeID), "[DateTime] desc");
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙，请重试", this.GetType().BaseType.FullName);
return;
}
PF.DataGridBindData(g, dt, gPager);
}
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()
{
string str = "select * from V_SystemLog where SiteID = " + base._Site.ID.ToString();
int num = _Convert.StrToInt(this.ddlTime.SelectedValue, -1);
if (num > 0)
{
str = str + " and Datediff(day, [DateTime], GetDate()) <= " + num.ToString();
}
if (this.tbUserName.Text.Trim() != "")
{
str = str + " and [Name] = '" + Utility.FilteSqlInfusion(this.tbUserName.Text.Trim()) + "'";
}
DataTable dt = MSSQL.Select(str + " order by [DateTime]", new MSSQL.Parameter[0]);
if (dt == null)
{
PF.GoError(4, "数据库繁忙，请重试", "Admin_LoginLog");
}
else
{
PF.DataGridBindData(this.g, dt, this.gPager);
this.btnClear.Enabled = dt.Rows.Count > 0;
}
}