protected void ddlLotteries_SelectedIndexChanged(object sender, EventArgs e)
 {
     if (this.ddlLotteries.SelectedValue == "0")
     {
         this.ddlPlayTypes.Items.Clear();
         this.ddlPlayTypes.Items.Add(new ListItem("选择玩法", "0"));
     }
     else
     {
         string    key = "dtPlayTypes_" + this.ddlLotteries.SelectedValue;
         DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key);
         if (cacheAsDataTable == null)
         {
             cacheAsDataTable = new Tables.T_PlayTypes().Open("", "LotteryID in (" + ((base._Site.UseLotteryList == "") ? "-1" : base._Site.UseLotteryList) + ") and LotteryID = " + _Convert.StrToInt(this.ddlLotteries.SelectedValue, -1).ToString(), "[ID]");
             if ((cacheAsDataTable == null) || (cacheAsDataTable.Rows.Count < 1))
             {
                 PF.GoError(7, "数据库繁忙,请重试", base.GetType().FullName + "(-85)");
                 return;
             }
             Shove._Web.Cache.SetCache(key, cacheAsDataTable, 0x1770);
         }
         if (cacheAsDataTable == null)
         {
             PF.GoError(4, "数据库繁忙,请重试", base.GetType().BaseType.FullName + "(-95)");
         }
         else
         {
             this.ddlPlayTypes.Items.Clear();
             foreach (DataRow row in cacheAsDataTable.Rows)
             {
                 this.ddlPlayTypes.Items.Add(new ListItem(row["Name"].ToString(), row["ID"].ToString()));
             }
         }
     }
 }
    private void BindDataForPlayTypes(int LotteryID)
    {
        string    key = "dtPlayTypes_" + LotteryID.ToString();
        DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key);

        if (cacheAsDataTable == null)
        {
            cacheAsDataTable = new Tables.T_PlayTypes().Open("", "LotteryID in (" + ((base._Site.UseLotteryList == "") ? "-1" : base._Site.UseLotteryList) + ") and LotteryID = " + LotteryID.ToString(), "[ID]");
            if ((cacheAsDataTable == null) || (cacheAsDataTable.Rows.Count < 1))
            {
                PF.GoError(7, "数据库繁忙,请重试", base.GetType().FullName);
                return;
            }
            Shove._Web.Cache.SetCache(key, cacheAsDataTable, 0x1770);
        }
        this.ddlPlayTypes.Items.Clear();
        this.ddlPlayTypes.Items.Add(new ListItem("全部玩法", "0"));
        foreach (DataRow row in cacheAsDataTable.Rows)
        {
            ListItem item = new ListItem(row["Name"].ToString(), row["ID"].ToString());
            this.ddlPlayTypes.Items.Add(item);
        }
        int num = _Convert.StrToInt(Utility.GetRequest("PlayTypeID"), 0);

        if (this.ddlPlayTypes.Items.Count > 0)
        {
            if (this.ddlPlayTypes.Items.FindByValue(num.ToString()) != null)
            {
                this.ddlPlayTypes.SelectedValue = num.ToString();
            }
            this.ddlPlayTypes_SelectedIndexChanged(this.ddlPlayTypes, new EventArgs());
        }
    }
 protected void g_ItemDataBound(object sender, DataGridItemEventArgs e)
 {
     if (((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem)) || (e.Item.ItemType == ListItemType.EditItem))
     {
         DataRowView dataItem = (DataRowView)e.Item.DataItem;
         DataRow     row      = dataItem.Row;
         e.Item.Cells[0].Text = _Convert.StrToDateTime(row["DateTime"].ToString(), DateTime.Now.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
         string    key = "dtLotteriesUseLotteryList";
         DataTable cacheAsDataTable = Shove._Web.Cache.GetCacheAsDataTable(key);
         if (cacheAsDataTable == null)
         {
             cacheAsDataTable = new Tables.T_Lotteries().Open("[ID], [Name], [Code]", "[ID] in(" + ((base._Site.UseLotteryList == "") ? "-1" : base._Site.UseLotteryList) + ")", "[ID]");
             if (cacheAsDataTable == null)
             {
                 PF.GoError(4, "数据库繁忙,请重试", base.GetType().BaseType.FullName + "(-39)");
                 return;
             }
             Shove._Web.Cache.SetCache(key, cacheAsDataTable, 0x1770);
         }
         if (cacheAsDataTable == null)
         {
             PF.GoError(4, "数据库繁忙,请重试", base.GetType().BaseType.FullName + "(-49)");
         }
         else
         {
             if (row["LotteryID"].ToString() == "-1")
             {
                 e.Item.Cells[2].Text = "全部彩种";
             }
             else
             {
                 e.Item.Cells[2].Text = cacheAsDataTable.Select("ID = " + row["LotteryID"].ToString())[0]["Name"].ToString();
             }
             key = "dtPlayTypes";
             DataTable table2 = Shove._Web.Cache.GetCacheAsDataTable(key);
             if (table2 == null)
             {
                 table2 = new Tables.T_PlayTypes().Open("", "LotteryID in (" + ((base._Site.UseLotteryList == "") ? "-1" : base._Site.UseLotteryList) + ")", "[ID]");
                 if ((table2 == null) || (table2.Rows.Count < 1))
                 {
                     PF.GoError(7, "数据库繁忙,请重试", base.GetType().FullName + "(-85)");
                     return;
                 }
                 Shove._Web.Cache.SetCache(key, table2, 0x1770);
             }
             if (table2 == null)
             {
                 PF.GoError(4, "数据库繁忙,请重试", base.GetType().BaseType.FullName + "(-95)");
             }
             else
             {
                 if (row["PlayTypeID"].ToString() == "-1")
                 {
                     e.Item.Cells[3].Text = "全部玩法";
                 }
                 else
                 {
                     e.Item.Cells[3].Text = table2.Select("ID = " + row["PlayTypeID"].ToString())[0]["Name"].ToString();
                 }
                 e.Item.Cells[4].Text = _Convert.StrToDouble(row["MoneyStart"].ToString(), 0.0).ToString("N") + "&nbsp;至&nbsp;" + _Convert.StrToDouble(row["MoneyEnd"].ToString(), 0.0).ToString("N") + " 元";
                 e.Item.Cells[5].Text = (row["Type"].ToString() == "1") ? "用户定制" : "发起人指定";
             }
         }
     }
 }
Esempio n. 4
0
    private void BindData()
    {
        DataTable table = new Views.V_SchemeSchedulesWithQuashed().Open("", "SiteID = " + base._Site.ID.ToString() + " and [id] = " + Shove._Web.Utility.FilteSqlInfusion(this.tbSchemeID.Text), "");

        if ((table == null) || (table.Rows.Count < 1))
        {
            PF.GoError(4, "数据库繁忙,请重试(-141)", base.GetType().BaseType.FullName);
        }
        else
        {
            DataTable table4;
            DataRow   row = table.Rows[0];
            long      num = _Convert.StrToLong(row["InitiateUserID"].ToString(), 0L);
            this.hfID.Value  = num.ToString();
            this.LotteryName = row["LotteryName"].ToString();
            if (this.LotteryName == "江西时时彩")
            {
                this.LotteryName = this.LotteryName.Replace("江西", "");
            }
            this.Label3.Text       = this.LotteryName + "<font class='red14'>" + row["IsuseName"].ToString() + "</font>期" + row["PlayTypeName"].ToString() + "认购方案";
            this.labTitle.Text     = row["IsuseName"].ToString();
            this.labStartTime.Text = row["StartTime"].ToString();
            this.tbIsuseID.Text    = row["IsuseID"].ToString();
            this.tbLotteryID.Text  = row["LotteryID"].ToString();
            this.LotteryID         = this.tbLotteryID.Text;
            this.PlayTypeID        = _Convert.StrToInt(row["PlayTypeID"].ToString(), 0);
            this.labEndTime.Text   = row["SystemEndTime"].ToString();
            if (_Convert.StrToInt(row["LotteryID"].ToString(), 0) == 0x2d)
            {
                string  scheme     = row["LotteryNumber"].ToString();
                string  buyContent = "";
                string  cnLocateWaysAndMultiples = "";
                Lottery lottery = new Lottery();
                if (lottery["45"].GetSchemeSplit(scheme, ref buyContent, ref cnLocateWaysAndMultiples))
                {
                    string    str4   = buyContent.Split(new char[] { '|' })[0].ToString();
                    DataTable table2 = new Views.V_IsuseForZCDC().Open("DateTime", "[IsuseID]=" + this.tbIsuseID.Text + " and [No]=" + str4.Split(new char[] { '(' })[0], "");
                    if ((table2 == null) || (table2.Rows.Count == 0))
                    {
                        PF.GoError(4, "数据库繁忙,请重试(-184)", base.GetType().FullName);
                        return;
                    }
                    DataTable table3 = new Tables.T_PlayTypes().Open("SystemEndAheadMinute", "[ID] = " + row["PlayTypeID"], "");
                    this.labEndTime.Text = _Convert.StrToDateTime(table2.Rows[0][0].ToString(), DateTime.Now.ToString()).AddMinutes(_Convert.StrToDouble(table3.Rows[0][0].ToString(), 0.0)).ToString();
                }
            }
            this.labInitiateUser.Text = row["InitiateName"].ToString() + "&nbsp;&nbsp;【<A class=li3 href='../Web/Score.aspx?id=" + row["InitiateUserID"].ToString() + "&LotteryID=" + this.tbLotteryID.Text + "' target='_blank'>发起人历史战绩</A>】";
            short num2 = _Convert.StrToShort(row["QuashStatus"].ToString(), 0);
            Shove._Web.Cache.SetCache("All_QuashStatus" + this.SchemeID, num2, 0xe10);
            bool   flag  = _Convert.StrToBool(row["Buyed"].ToString(), false);
            int    num3  = _Convert.StrToInt(row["Share"].ToString(), 0);
            int    num4  = _Convert.StrToInt(row["BuyedShare"].ToString(), 0);
            double num5  = _Convert.StrToDouble(row["Money"].ToString(), 0.0);
            double num6  = _Convert.StrToDouble(row["AssureMoney"].ToString(), 0.0);
            double num7  = _Convert.StrToDouble(row["WinMoney"].ToString(), 0.0);
            short  num8  = _Convert.StrToShort(row["SecrecyLevel"].ToString(), 0);
            bool   flag2 = false;
            _Convert.StrToBool(row["isCanChat"].ToString(), false);
            if (num3 > 1)
            {
                this.trBonusScale.Visible = true;
                this.lbSchemeBonus.Text   = ((_Convert.StrToDouble(row["SchemeBonusScale"].ToString(), 0.04) * 100.0)).ToString() + "%";
            }
            this.HidSchedule.Value = row["Schedule"].ToString();
            table4 = table4 = new Views.V_Isuses().Open("IsOpened, WinLotteryNumber,Code", "[id] = " + row["IsuseID"].ToString(), "");
            if (table4 == null)
            {
                PF.GoError(4, "数据库繁忙,请重试(-213)", base.GetType().FullName);
            }
            else if (table4.Rows.Count < 1)
            {
                PF.GoError(1, "系统错误(-220)", base.GetType().FullName);
            }
            else
            {
                flag2 = _Convert.StrToBool(table4.Rows[0]["IsOpened"].ToString(), true);
                this.lbWinNumber.Text   = table4.Rows[0]["WinLotteryNumber"].ToString();
                this.ImageLogo.ImageUrl = "images/lottery/" + table4.Rows[0]["Code"].ToString().ToLower() + ".jpg";
                if (!base._Site.SiteOptions["Opt_FullSchemeCanQuash"].ToBoolean(false))
                {
                    this.btnQuashScheme.Visible = (((num2 == 0) && !flag) && ((num3 > num4) && (base._User != null))) && (num == base._User.ID);
                }
                else
                {
                    this.btnQuashScheme.Visible = (((num2 == 0) && !flag) && (base._User != null)) && (num == base._User.ID);
                }
                short num10 = _Convert.StrToShort(row["AtTopStatus"].ToString(), 0);
                bool  flag4 = num10 != 0;
                if (num10 == 0)
                {
                    this.cbAtTopApplication.Visible = (((num2 == 0) && !flag) && ((num3 > num4) && (base._User != null))) && (num == base._User.ID);
                    this.cbAtTopApplication.Checked = flag4;
                }
                else
                {
                    this.labAtTop.Visible = true;
                }
                bool     flag5 = false;
                bool     flag6 = false;
                DateTime time5 = _Convert.StrToDateTime(this.labEndTime.Text, DateTime.Now.ToString());
                if (DateTime.Now >= time5)
                {
                    flag6            = true;
                    this.tbStop.Text = flag6.ToString();
                }
                if (num2 > 0)
                {
                    if (num2 == 2)
                    {
                        this.labState.Text = "已撤单(系统撤单)";
                    }
                    else
                    {
                        this.labState.Text = "已撤单";
                    }
                }
                else if (flag6)
                {
                    this.labState.Text = "已截止";
                }
                else if (flag)
                {
                    this.labState.Text = "<FONT color='red'>已成功</font>";
                }
                else if (num3 <= num4)
                {
                    this.labState.Text = "<FONT color='red'>已满员</font>";
                }
                else
                {
                    this.labState.Text = "<font color='red'>抢购中...</font>";
                    flag5 = true;
                }
                this.labMultiple.Text = row["Multiple"].ToString();
                if (((num8 == 1) && !flag6) && ((base._User == null) || (((base._User != null) && (num != base._User.ID)) && !base._User.isOwnedViewSchemeCompetence())))
                {
                    this.labLotteryNumber.Text = "投注内容已经被保密,将在本期投注截止后公开。";
                }
                else if (((num8 == 2) && !flag2) && ((base._User == null) || (((base._User != null) && (num != base._User.ID)) && !base._User.isOwnedViewSchemeCompetence())))
                {
                    this.labLotteryNumber.Text = "投注内容已经被保密,将在本期开奖后公开。";
                }
                else if ((num8 == 3) && ((base._User == null) || (((base._User != null) && (num != base._User.ID)) && !base._User.isOwnedViewSchemeCompetence())))
                {
                    this.labLotteryNumber.Text = "投注内容已经被保密。";
                }
                else
                {
                    int    num11 = base._Site.SiteOptions["Opt_MaxShowLotteryNumberRows"].ToShort(0);
                    string str   = "";
                    try
                    {
                        str = row["LotteryNumber"].ToString();
                    }
                    catch
                    {
                    }
                    if (_String.StringAt(str, '\n') < num11)
                    {
                        if (new Lottery.ZCDC().CheckPlayType(_Convert.StrToInt(row["PlayTypeID"].ToString(), -1)))
                        {
                            string    vote   = "";
                            DataTable table5 = PF.GetZCDCBuyContent(str, this.SchemeID, ref vote);
                            if (table5 == null)
                            {
                                PF.GoError(4, "数据访问错误(-358)", base.GetType().FullName);
                                return;
                            }
                            this.labMultiple.Text     = vote;
                            this.rptScheme.DataSource = table5;
                            this.rptScheme.DataBind();
                            this.rptScheme.Visible = true;
                        }
                        else
                        {
                            this.labLotteryNumber.Text = _Convert.ToHtmlCode(str) + "&nbsp;";
                            if (flag2)
                            {
                                this.NumberDuiBi(this.labLotteryNumber.Text, this.lbWinNumber.Text, this.PlayTypeID);
                            }
                        }
                    }
                    else
                    {
                        this.linkDownloadScheme.Visible                 = true;
                        this.linkDownloadLotteryIdentifiers.Visible     = (base._User == null) || ((base._User != null) && ((base._User.ID.ToString() == row["InitiateUserID"].ToString()) || base._User.Competences["Administrator"]));
                        this.linkDownloadLotteryIdentifiers.NavigateUrl = "../Web/DownLotteryIdentifiers.aspx?id=" + this.tbSchemeID.Text;
                        this.linkDownloadScheme.NavigateUrl             = "../Web/DownloadSchemeFile.aspx?id=" + this.tbSchemeID.Text;
                    }
                }
                this.labSchemeNumber.Text      = row["SchemeNumber"].ToString();
                this.labSchemeDateTime.Text    = row["DateTime"].ToString();
                this.labSchemeMoney.Text       = _Convert.StrToDouble(row["Money"].ToString(), 0.0).ToString("N");
                this.labSchemeTitle.Text       = row["Title"].ToString() + "&nbsp;";
                this.labSchemeDescription.Text = row["Description"].ToString() + "&nbsp;";
                this.labSchemeADUrl.Text       = Shove._Web.Utility.GetUrl() + "/Home/Room/Scheme.aspx?id=" + this.tbSchemeID.Text;
                object[] args = new object[] { this.labSchemeMoney.Text, num3, (num5 / ((double)num3)).ToString("N"), num4, ((num5 / ((double)num3)) * num4).ToString("N") };
                this.labSchemeDetail.Text = string.Format("此方案总金额 <FONT color='red'>{0}</font> 元,共 <FONT color='red'>{1}</font> 份,每份 <FONT color='red'>{2}</font> 元。<br />已认购 <FONT color='red'>{3}</font> 份(金额 <FONT color='red'>{4}</font> 元)", args) + (flag5 ? string.Format(",还有 <FONT color='red'>{0}</font> 份(金额 <FONT color='red'>{1}</font> 元)可以认购!", num3 - num4, ((num5 / ((double)num3)) * (num3 - num4)).ToString("N")) : "");
                if ((string.IsNullOrEmpty(row["LotteryNumber"].ToString()) && (((this.LotteryID == "1") || (this.LotteryID == "2")) || (this.LotteryID == "15"))) && (((num2 == 0) && !flag6) && !flag))
                {
                    this.labLotteryNumber.Text = "未上传";
                    if ((base._User != null) && (row["InitiateUserID"].ToString() == base._User.ID.ToString()))
                    {
                        this.lbUploadScheme.Visible = true;
                    }
                }
                if (flag)
                {
                    this.labLotteryCode.Text = "已出票,彩票标识:";
                    this.linkDownloadLotteryIdentifiers.Visible     = true;
                    this.linkDownloadLotteryIdentifiers.NavigateUrl = "../Web/DownLotteryIdentifiers.aspx?id=" + this.tbSchemeID.Text;
                }
                else
                {
                    this.labLotteryCode.Text = "暂未出票";
                    this.linkDownloadLotteryIdentifiers.Visible = false;
                }
                this.labAssureMoney.Text = (num6 > 0.0) ? string.Format("发起人保底 <FONT color='red'>{0}</font> 份,<FONT color='red'>{1}</font> 元", Math.Round((double)(num6 / (num5 / ((double)num3))), 0).ToString(), num6.ToString("N")) : "未保底";
                if (num2 > 0)
                {
                    if (num2 == 2)
                    {
                        this.labWin.Text = "已撤单(系统撤单)";
                    }
                    else
                    {
                        this.labWin.Text = "已撤单";
                    }
                }
                else if (flag6)
                {
                    this.labWin.Text = string.Format("<FONT color='red'>{0}</font> 元", num7.ToString("N"));
                    string str7 = row["WinDescription"].ToString();
                    if (str7 != "")
                    {
                        this.labWin.Text = this.labWin.Text + "<br />" + str7;
                    }
                    else if (flag2)
                    {
                        this.labWin.Text = this.labWin.Text + "  未中奖";
                    }
                    else
                    {
                        this.labWin.Text = this.labWin.Text + "  <font color='red'>【注】</font>中奖结果在开奖后需要一段时间才能显示。";
                    }
                }
                else
                {
                    this.labWin.Text = "尚未截止";
                }
                if (flag2 && (((this.LotteryID == "1") || (this.LotteryID == "2")) || (this.LotteryID == "15")))
                {
                    this.labWin.Text = this.labWin.Text + "(命中<font color='red'>" + this.CompareLotteryNumberToWinNumber(row["LotteryNumber"].ToString(), row["WinLotteryNumber"].ToString()).ToString() + "</font>场)";
                }
                if (flag6)
                {
                    this.labCannotBuyTip.Text    = "方案已截止,不能认购";
                    this.labCannotBuyTip.Visible = true;
                    this.pBuy.Visible            = false;
                    this.btnOK.Enabled           = false;
                }
                else if (num2 > 0)
                {
                    this.labCannotBuyTip.Text    = "方案已撤单,不能认购";
                    this.labCannotBuyTip.Visible = true;
                    this.pBuy.Visible            = false;
                    this.btnOK.Enabled           = false;
                }
                else if (num4 >= num3)
                {
                    this.labCannotBuyTip.Text    = "方案已满员,不能认购";
                    this.labCannotBuyTip.Visible = true;
                    this.pBuy.Visible            = false;
                    this.btnOK.Enabled           = false;
                }
                else
                {
                    this.labCannotBuyTip.Visible = false;
                    this.pBuy.Visible            = true;
                    this.btnOK.Enabled           = true;
                }
                this.labShare.Text      = (num3 - num4).ToString();
                this.labShareMoney.Text = (num5 / ((double)num3)).ToString("N");
                this.BindDataForUserList();
                if (base._User != null)
                {
                    DataTable dt = new Views.V_BuyDetailsWithQuashedAll().Open("[id],[DateTime],[Money],Share,SchemeShare,BuyedShare,QuashStatus,Buyed,IsuseID,Code,Schedule,DetailMoney,isWhenInitiate, WinMoneyNoWIthTax", "SiteID = " + base._Site.ID.ToString() + " and SchemeID = " + Shove._Web.Utility.FilteSqlInfusion(this.tbSchemeID.Text) + " and [UserID] = " + base._User.ID.ToString(), "[id]");
                    if (dt == null)
                    {
                        PF.GoError(4, "数据库繁忙,请重试(-518)", base.GetType().FullName);
                    }
                    else
                    {
                        if (dt.Rows.Count == 0)
                        {
                            this.labMyBuy.Text    = "此方案还没有我的认购记录。";
                            this.labMyBuy.Visible = true;
                            this.g.Visible        = false;
                        }
                        else
                        {
                            this.labMyBuy.Visible = false;
                            this.g.Visible        = true;
                            PF.DataGridBindData(this.g, dt);
                            if (flag2)
                            {
                                double num23 = 0.0;
                                for (int i = 0; i < dt.Rows.Count; i++)
                                {
                                    num23 += double.Parse(dt.Rows[i]["WinMoneyNoWIthTax"].ToString());
                                }
                                this.lbReward.Text = num23.ToString("N");
                            }
                        }
                        if (base._User.UserType < 2)
                        {
                            this.btnOK.Enabled          = false;
                            this.btnQuashScheme.Enabled = false;
                        }
                    }
                }
            }
        }
    }