private void BindData() { tbMoney.Text = ""; tbSchedule.Text = ""; tbMinMoney.Text = ""; DataTable dt = new DAL.Tables.T_SchemesFormulae().Open("", "LotteryID=" + ddlLottery.SelectedValue, ""); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", "Admin_SchemesFormulaeSet"); return; } if (dt.Rows.Count < 1) { return; } tbMoney.Text = dt.Rows[0]["Money"].ToString(); tbSchedule.Text = dt.Rows[0]["Schedule"].ToString(); tbMinMoney.Text = dt.Rows[0]["MinMoney"].ToString(); IsSet.Value = "1"; }
private void BindDataForType() { long IsuseID = Shove._Convert.StrToLong(Shove._Web.Utility.FilteSqlInfusion(HidIsuseID.Value), 0); //合买方案缓存 60 秒 string CacheKey = "Home_Room_CoBuy_BindDataForType" + HidIsuseID.Value; DataTable dt = null; if (TxtName.Text.Trim() == "" || TxtName.Text.Trim() == "输入用户名") //2010-7-9添加的判断 { dt = Shove._Web.Cache.GetCacheAsDataTable(CacheKey); } if (dt == null) { StringBuilder sb = new StringBuilder(); sb.AppendLine("select SchemeNumber, InitiateName, Level, Money, d.Name as PlayTypeName, Share, Schedule, AssureMoney, a.ID, InitiateUserID, QuashStatus, PlayTypeID, Buyed, SecrecyLevel, EndTime, b.IsOpened, LotteryNumber,b.LotteryID ") .AppendLine("from ") .AppendLine(" (") .AppendLine(" select T_Schemes.ID,IsuseID,AtTopStatus,T_Users.Name as InitiateName, T_Users.Level, SchemeNumber,ReSchedule,Money,Share, Schedule, AssureMoney, InitiateUserID, QuashStatus, PlayTypeID, Buyed, SecrecyLevel, LotteryNumber ") .AppendLine(" from T_Schemes left join T_Users on T_Schemes.InitiateUserID = T_Users.id") .AppendLine(" where IsuseID = @IsuseID and QuashStatus = 0 and Share > BuyedShare ") .AppendLine("" + ((TxtName.Text.Trim() == "" || TxtName.Text.Trim() == "输入用户名") ? " and not exists (select 1 from T_SchemesTop where T_Schemes.ID = T_SchemesTop.SchemeID) " : (" and T_Users.Name like '%" + Shove._Web.Utility.FilteSqlInfusion(TxtName.Text.Trim()) + "%' "))) .AppendLine(" and T_Schemes.SiteID = @SiteID") .AppendLine(" )as a") .AppendLine("inner join T_Isuses b on a.IsuseID = b.ID") .AppendLine("inner join T_PlayTypes d on d.ID = a.PlayTypeID") .AppendLine("order by AtTopStatus desc, ReSchedule desc, [Money] desc"); dt = MSSQL.Select(sb.ToString(), new MSSQL.Parameter("IsuseID", SqlDbType.BigInt, 0, ParameterDirection.Input, IsuseID), new MSSQL.Parameter("SiteID", SqlDbType.Int, 0, ParameterDirection.Input, _Site.ID)); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().FullName); return; } } DataTable dtSchemesFormulae = new DAL.Tables.T_SchemesFormulae().Open("", "LotteryID=" + HidLotteryID.Value, ""); if (dtSchemesFormulae == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().FullName); return; } dt.Columns.Add("IsTop", typeof(System.Int32)); if ((TxtName.Text.Trim() == "" || TxtName.Text.Trim() == "输入用户名") && dtSchemesFormulae.Rows.Count > 0) { BindSchemesFormulae(); DataTable dtSchemesTop = new DAL.Tables.T_SchemesTop().Open("", "IsuseID=" + IsuseID.ToString(), "Sort"); if (dtSchemesTop == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().FullName); return; } DataTable dtSchemes = null; if (dtSchemesTop.Rows.Count > 0) { StringBuilder sb = new StringBuilder(); sb.AppendLine("select SchemeNumber, InitiateName, Level, Money, d.Name as PlayTypeName, Share, Schedule, AssureMoney, a.ID, InitiateUserID, QuashStatus, PlayTypeID, Buyed, SecrecyLevel, EndTime, b.IsOpened, LotteryNumber,b.LotteryID, 1 as IsTop ") .AppendLine("from ") .AppendLine(" (") .AppendLine(" select T_Schemes.ID,IsuseID,AtTopStatus,T_Users.Name as InitiateName, T_Users.Level, SchemeNumber,ReSchedule,Money,Share, Schedule, AssureMoney, InitiateUserID, QuashStatus, PlayTypeID, Buyed, SecrecyLevel, LotteryNumber ") .AppendLine(" from T_Schemes left join T_Users on T_Schemes.InitiateUserID = T_Users.id") .AppendLine(" where IsuseID = @IsuseID and QuashStatus = 0 and Share > BuyedShare ") .AppendLine(" and exists (select 1 from T_SchemesTop where T_Schemes.ID = T_SchemesTop.SchemeID) ") .AppendLine(" and T_Schemes.SiteID = @SiteID") .AppendLine(" )as a") .AppendLine("inner join T_Isuses b on a.IsuseID = b.ID") .AppendLine("inner join T_PlayTypes d on d.ID = a.PlayTypeID") .AppendLine("order by AtTopStatus desc, ReSchedule desc, [Money] desc"); dtSchemes = MSSQL.Select(sb.ToString(), new MSSQL.Parameter("IsuseID", SqlDbType.BigInt, 0, ParameterDirection.Input, IsuseID), new MSSQL.Parameter("SiteID", SqlDbType.Int, 0, ParameterDirection.Input, _Site.ID)); } int TopCount = 10 - dtSchemesTop.Rows.Count; for (int i = 0; i < dt.Rows.Count; i++) { if (Shove._Convert.StrToDouble(dt.Rows[i]["Money"].ToString(), 0) > Shove._Convert.StrToDouble(dtSchemesFormulae.Rows[0]["Money"].ToString(), 0) && Shove._Convert.StrToFloat(dt.Rows[i]["Schedule"].ToString(), 0) > Shove._Convert.StrToFloat(dtSchemesFormulae.Rows[0]["MinMoney"].ToString(), 0) && ((Shove._Convert.StrToDouble(dt.Rows[i]["AssureMoney"].ToString(), 0) / Shove._Convert.StrToDouble(dt.Rows[i]["Money"].ToString(), 0)) * 100 + Shove._Convert.StrToDouble(dt.Rows[i]["Schedule"].ToString(), 0) > Shove._Convert.StrToDouble(dtSchemesFormulae.Rows[0]["MinMoney"].ToString(), 0)) && TopCount < 10) { dt.Rows[i]["IsTop"] = 1; } else { dt.Rows[i]["IsTop"] = 0; } dt.AcceptChanges(); } DataRow dr = null; DataRow drSchemes = null; if (dtSchemes != null && dtSchemes.Rows.Count > 0) { for (int i = 0; i < dtSchemesTop.Rows.Count; i++) { dr = dt.NewRow(); try { drSchemes = dtSchemes.Select("ID=" + dtSchemesTop.Rows[i]["SchemeID"].ToString())[0]; } catch { } dr["SchemeNumber"] = drSchemes["SchemeNumber"]; dr["InitiateName"] = drSchemes["InitiateName"]; dr["Level"] = drSchemes["Level"]; dr["Money"] = drSchemes["Money"]; dr["PlayTypeName"] = drSchemes["PlayTypeName"]; dr["Share"] = drSchemes["Share"]; dr["Schedule"] = drSchemes["Schedule"]; dr["AssureMoney"] = drSchemes["AssureMoney"]; dr["ID"] = drSchemes["ID"]; dr["InitiateUserID"] = drSchemes["InitiateUserID"]; dr["QuashStatus"] = drSchemes["QuashStatus"]; dr["PlayTypeID"] = drSchemes["PlayTypeID"]; dr["Buyed"] = drSchemes["Buyed"]; dr["SecrecyLevel"] = drSchemes["SecrecyLevel"]; dr["EndTime"] = drSchemes["EndTime"]; dr["IsOpened"] = drSchemes["IsOpened"]; dr["LotteryNumber"] = drSchemes["LotteryNumber"]; dr["LotteryID"] = drSchemes["LotteryID"]; dr["IsTop"] = drSchemes["IsTop"]; dt.Rows.InsertAt(dr, Shove._Convert.StrToInt(dtSchemesTop.Rows[i]["Sort"].ToString(), 0)); dt.AcceptChanges(); } } } dt.Columns.Add("Assure", typeof(System.String)); for (int i = 0; i < dt.Rows.Count; i++) { double AssureMoney = Shove._Convert.StrToDouble(dt.Rows[i]["AssureMoney"].ToString(), 0); if (AssureMoney > 0) { dt.Rows[i]["Assure"] = "<Font color=\'red\'>" + dt.Rows[i]["Schedule"].ToString() + "%<br />+" + ((AssureMoney / Shove._Convert.StrToDouble(dt.Rows[i]["Money"].ToString(), 0)) * 100).ToString("N") + "%(保)</ Font>"; } else { dt.Rows[i]["Assure"] = "<Font color=\'red\'>" + dt.Rows[i]["Schedule"].ToString() + "%</ Font><br />"; } dt.AcceptChanges(); } PF.DataGridBindData(g, dt, gPager); if (g.Items.Count == 0) { string userName = Shove._Web.Utility.FilteSqlInfusion(TxtName.Text.Trim()); if (userName != "" && userName != "输入用户名" && Personages.InnerHtml.Contains(userName)) { StringBuilder sb = new StringBuilder(); sb.AppendLine("select SchemeNumber,InitiateName, Level, Money, d.Name as PlayTypeName, Share, Schedule, AssureMoney, a.ID, InitiateUserID, QuashStatus, PlayTypeID, Buyed, SecrecyLevel, EndTime, IsOpened, LotteryNumber,a.LotteryID") .AppendLine("from ") .AppendLine("(") .AppendLine(" select top 5 SchemeNumber, Money, Share, Schedule, AssureMoney, s.ID,u.Name as InitiateName,Level, InitiateUserID, QuashStatus, PlayTypeID, Buyed, SecrecyLevel, EndTime, s.isOpened, LotteryNumber,LotteryID ") .AppendLine(" from T_Schemes s left join T_Isuses t on s.IsuseID = t.ID ") .AppendLine(" left join T_Users u on s.InitiateUserID = u.ID") .AppendLine(" where s.Share > 1 and t.LotteryID = @LotteryID ") .AppendLine(" and u.Name like @InitiateName and s.SiteID = @SiteID") .AppendLine(" order by QuashStatus asc,[Datetime] desc,[Money] desc") .AppendLine(") as a") .AppendLine("inner join T_PlayTypes d on d.ID = a.PlayTypeID"); //合买方案缓存 60 秒 CacheKey = userName + "CoBuySchemes_" + HidLotteryID.Value + "_Top5" + sb; dt = Shove._Web.Cache.GetCacheAsDataTable(CacheKey); if (dt == null) { dt = MSSQL.Select(sb.ToString(), new MSSQL.Parameter("LotteryID", SqlDbType.Int, 0, ParameterDirection.Input, Shove._Convert.StrToLong(Shove._Web.Utility.FilteSqlInfusion(HidLotteryID.Value), 0)), new MSSQL.Parameter("InitiateName", SqlDbType.VarChar, 0, ParameterDirection.Input, "'%" + userName + "%'"), new MSSQL.Parameter("SiteID", SqlDbType.Int, 0, ParameterDirection.Input, _Site.ID)); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().FullName); return; } if (dt.Rows.Count > 0) { Shove._Web.Cache.SetCache(CacheKey, dt, 60); } } dt.Columns.Add("Assure", typeof(System.String)); for (int i = 0; i < dt.Rows.Count; i++) { double AssureMoney = Shove._Convert.StrToDouble(dt.Rows[i]["AssureMoney"].ToString(), 0); if (AssureMoney > 0) { dt.Rows[i]["Assure"] = "<Font color=\'red\'>" + dt.Rows[i]["Schedule"].ToString() + "%<br />+" + ((AssureMoney / Shove._Convert.StrToDouble(dt.Rows[i]["Money"].ToString(), 0)) * 100).ToString("N") + "%(保)</ Font>"; } else { dt.Rows[i]["Assure"] = "<Font color=\'red\'>" + dt.Rows[i]["Schedule"].ToString() + "%</ Font><br />"; } dt.AcceptChanges(); } PF.DataGridBindData(g, dt, gPager); } } divData.Visible = true; divLoding.Visible = false; }
private void BindSchemesFormulae() { DataTable dt = new DAL.Tables.T_SchemesFormulae().Open("", "LotteryID=" + HidLotteryID.Value, ""); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", "Admin_SchemesFormulaeSet"); return; } if (dt.Rows.Count < 1) { return; } lbContent.Text = " 1、 方案金额大于等于" + Shove._Convert.StrToDouble(dt.Rows[0]["Money"].ToString(), 0).ToString("N") + "元<br />2、 进度或者进度+保底大于等于" + dt.Rows[0]["Schedule"].ToString() + "%<br />3、 进度不少于方案总金额的" + dt.Rows[0]["MinMoney"].ToString() + "%"; }
protected void btnAdd_Click(object sender, System.EventArgs e) { if (string.IsNullOrEmpty(tbMoney.Text.Trim())) { Shove._Web.JavaScript.Alert(this.Page, "请输入方案最低金额!"); return; } if (Shove._Convert.StrToFloat(tbMoney.Text.Trim(), 0) == 0) { Shove._Web.JavaScript.Alert(this.Page, "请输入最低方案金额输入有误,请重新输入!"); return; } if (string.IsNullOrEmpty(tbSchedule.Text.Trim())) { Shove._Web.JavaScript.Alert(this.Page, "请输入方案进度加保底的最少金额!"); return; } if (Shove._Convert.StrToFloat(tbSchedule.Text.Trim(), 0) == 0) { Shove._Web.JavaScript.Alert(this.Page, "请输入方案的最少进度加保底金额输入有误,请重新输入!"); return; } if (string.IsNullOrEmpty(tbMinMoney.Text.Trim())) { Shove._Web.JavaScript.Alert(this.Page, "请输入方案最小进度!"); return; } if (Shove._Convert.StrToFloat(tbMinMoney.Text.Trim(), 0) == 0) { Shove._Web.JavaScript.Alert(this.Page, "请输入方案的最少进度输入有误,请重新输入!"); return; } DAL.Tables.T_SchemesFormulae t_SchemesFormulae = new DAL.Tables.T_SchemesFormulae(); t_SchemesFormulae.Money.Value = Shove._Convert.StrToFloat(tbMoney.Text.Trim(), 0); t_SchemesFormulae.Schedule.Value = Shove._Convert.StrToFloat(tbSchedule.Text.Trim(), 0); t_SchemesFormulae.MinMoney.Value = Shove._Convert.StrToFloat(tbMinMoney.Text.Trim(), 0); if (IsSet.Value != "1") { t_SchemesFormulae.LotteryID.Value = Shove._Convert.StrToShort(ddlLottery.SelectedValue, 0); t_SchemesFormulae.Insert(); Shove._Web.JavaScript.Alert(this.Page, "彩种已经设置成功!"); return; } t_SchemesFormulae.Update("LotteryID=" + ddlLottery.SelectedValue); Shove._Web.JavaScript.Alert(this.Page, "彩种已经设置成功!"); return; }