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;
}
