コード例 #1
0
 private void BindData()
 {
     DataTable dt = new Views.V_CustomFollowSchemes().Open("[UserName],MoneyStart,[MoneyEnd],BuyShareStart,BuyShareEnd,[TypeName],Convert(varchar,[DateTime],120)[DateTime]", "UsersForInitiateFollowSchemeUserID = " + Utility.FilteSqlInfusion(this.tbUserID.Value) + " and PlayTypeID = " + Utility.FilteSqlInfusion(this.tbPlayTypeID.Value), "[DateTime] desc");
     if (dt == null)
     {
         PF.GoError(4, "数据库繁忙,请重试", base.GetType().FullName);
     }
     else
     {
         this.lbCountUser.Text = dt.Rows.Count.ToString();
         PF.DataGridBindData(this.g, dt, this.gPager);
         this.gPager.Visible = true;
     }
 }
コード例 #2
0
    private void BindData()
    {
        DataTable dt = new DAL.Views.V_CustomFollowSchemes().Open("[UserName],MoneyStart,[MoneyEnd],BuyShareStart,BuyShareEnd,[TypeName],Convert(varchar,[DateTime],120)[DateTime]", "UsersForInitiateFollowSchemeUserID = " + Shove._Web.Utility.FilteSqlInfusion(tbUserID.Value) + " and PlayTypeID = " + Shove._Web.Utility.FilteSqlInfusion(tbPlayTypeID.Value), "[DateTime] desc");

        if (dt == null)
        {
            PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().FullName);

            return;
        }

        lbCountUser.Text = dt.Rows.Count.ToString();

        PF.DataGridBindData(g, dt, gPager);

        gPager.Visible = true;
    }
コード例 #3
0
    private void BindData()
    {
        DataTable dt = new DAL.Views.V_CustomFollowSchemes().Open("[UserName],MoneyStart,[MoneyEnd],BuyShareStart,BuyShareEnd,[TypeName],Convert(varchar,[DateTime],120)[DateTime]", "UsersForInitiateFollowSchemeUserID = " + Shove._Web.Utility.FilteSqlInfusion(tbUserID.Value) + " and PlayTypeID = " + Shove._Web.Utility.FilteSqlInfusion(tbPlayTypeID.Value), "[DateTime] desc");

        if (dt == null)
        {
            PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().FullName);

            return;
        }

        lbCountUser.Text = dt.Rows.Count.ToString();

        PF.DataGridBindData(g, dt, gPager);

        gPager.Visible = true;
    }