private void BindData(int ChaseID)
{
DataTable dt = new DAL.Views.V_ChaseTasksTotal().Open("", "ID = " + ChaseID.ToString() + " and UserID=" + _User.ID.ToString(), "");
if ((dt == null) || (dt.Rows.Count < 1))
{
PF.GoError(ErrorNumber.DataReadWrite, "您还没有追号！", this.GetType().FullName);
return;
}
DataRow dr = dt.Rows[0];
labChase_id.Text = ChaseID.ToString();
Label1.Text = dr["LotteryName"].ToString();
Label3.Text = dr["Description"].ToString();
double IsuseMoney, SumMoney, BuyedMoney, QuashedMoney;;
int SumIsuseNum, BuyedIsuseNum, QuashedIsuseNum;
SumMoney = Shove._Convert.StrToDouble(dr["SumMoney"].ToString(), 0);
SumIsuseNum = Shove._Convert.StrToInt(dr["SumIsuseNum"].ToString(), 0);
BuyedIsuseNum = Shove._Convert.StrToInt(dr["BuyedIsuseNum"].ToString(), 0);
QuashedIsuseNum = Shove._Convert.StrToInt(dr["QuashedIsuseNum"].ToString(), 0);
BuyedMoney = Shove._Convert.StrToDouble(dr["BuyedMoney"].ToString(), 0);
QuashedMoney = Shove._Convert.StrToDouble(dr["QuashedMoney"].ToString(), 0);
try
{
IsuseMoney = SumMoney / SumIsuseNum;
}
catch
{
PF.GoError(ErrorNumber.DataReadWrite, "投注记录有错误", this.GetType().FullName);
return;
}
Label4.Text = "</font>共<font color=\'red\'>" + SumIsuseNum.ToString() + "</font>期<font color=\'red\'>" +
SumMoney.ToString("N") + "</font>元; 已完成<font color=\'red\'>" + BuyedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (BuyedMoney).ToString("N") + "</font>元; 已取消<font color=\'red\'>" +
QuashedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (QuashedMoney).ToString("N") + "</font>元。";
btnQuash.Enabled = (SumIsuseNum > (BuyedIsuseNum + QuashedIsuseNum));
//填充每期列表
dt = new DAL.Views.V_ChaseTaskDetails().Open("", "ChaseTaskID = " + ChaseID.ToString(), "[DateTime]");
if ((dt == null) || dt.Rows.Count < 1)
{
PF.GoError(ErrorNumber.DataReadWrite, "没有追号记录", this.GetType().FullName);
return;
}
LbPlayTypeName.Text = dt.Rows[0]["PlayTypeName"].ToString(); //买法类型
PF.DataGridBindData(g, dt);
}
private void BindData(int ChaseID)
{
string Key = "Home_Room_ChaseExecutedSchemes_BindData_" + ChaseID.ToString();
DataTable dtChase = Shove._Web.Cache.GetCacheAsDataTable(Key);
StringBuilder sb = new StringBuilder();
if (dtChase == null || dtChase.Rows.Count == 0)
{
sb.Append("select Title,Name,IsuseCount,IsuseCount*Multiple*Nums*Price as SumMoney,Money,QuashStatus,ExecutedCount,ExecutedCount*Multiple*Nums*Price as ExcutedMoney,")
.Append("IsuseCount-ExecutedCount as NoExecutedCount,Title,StopTypeWhenWin,StopTypeWhenWinMoney from T_Chases a inner join T_Lotteries b ")
.Append("on a.LotteryID = b.ID and a.ID=" + ChaseID.ToString() + " ")
.Append("left join (select ChaseID,count(SchemeID) as ExecutedCount from T_ExecutedChases group by ChaseID)c on a.ID = c.ChaseID");
dtChase = Shove.Database.MSSQL.Select(sb.ToString());
if (dtChase == null || dtChase.Rows.Count == 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "此记录不存在或已被删除！", this.GetType().FullName);
return;
}
Shove._Web.Cache.SetCache(Key, dtChase);
}
DataRow dr = dtChase.Rows[0];
lbLotteryName.Text = dr["Name"].ToString();
lbTitle.Text = dr["Title"].ToString();
if (dr["StopTypeWhenWin"].ToString() == "1")
{
lbStopCondition.Text = "完成方案";
}
else
{
lbStopCondition.Text = "单期中奖金额达到" + dr["StopTypeWhenWinMoney"].ToString();
}
double SumMoney, BuyedMoney, QuashedMoney;;
int SumIsuseNum, BuyedIsuseNum, QuashedIsuseNum;
SumMoney = Shove._Convert.StrToDouble(dr["SumMoney"].ToString(), 0);
SumIsuseNum = Shove._Convert.StrToInt(dr["IsuseCount"].ToString(), 0);
BuyedIsuseNum = Shove._Convert.StrToInt(dr["ExecutedCount"].ToString(), 0);
QuashedIsuseNum = Shove._Convert.StrToInt(dr["NoExecutedCount"].ToString(), 0);
BuyedMoney = Shove._Convert.StrToDouble(dr["ExcutedMoney"].ToString(), 0);
QuashedMoney = Shove._Convert.StrToDouble(dr["Money"].ToString(), 0);
lbDescription.Text = "</font>共<font color=\'red\'>" + SumIsuseNum.ToString() + "</font>期<font color=\'red\'>" +
SumMoney.ToString("N") + "</font>元; 已完成<font color=\'red\'>" + BuyedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (BuyedMoney).ToString("N") + "</font>元; 未执行<font color=\'red\'>" +
QuashedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (QuashedMoney).ToString("N") + "</font>元。";
//填充每期列表
Key = "Home_Room_ChaseExecutedSchemes_BindDataDetails_" + ChaseID.ToString();
DataTable dt = Shove._Web.Cache.GetCacheAsDataTable(Key);
sb = new StringBuilder();
if (dt == null)
{
sb.Append("select PlayTypeName,ID,IsuseName,LotteryNumber,Multiple,Money,QuashStatus,Buyed from T_ExecutedChases a inner join V_Schemes b ")
.Append("on a.SchemeID = b.ID and a.ChaseID =" + ChaseID.ToString() + " order by ID");
dt = Shove.Database.MSSQL.Select(sb.ToString());
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "您还没有追号！", this.GetType().FullName);
return;
}
Shove._Web.Cache.SetCache(Key, dt);
}
if (dt.Rows.Count > 0)
{
lbPlayTypeName.Text = dt.Rows[0]["PlayTypeName"].ToString(); //买法类型
}
PF.DataGridBindData(g, dt);
}
private void BindData(int ChaseID)
{
StringBuilder sb = new StringBuilder();
sb.Append("select Title,Name,IsuseCount,IsuseCount*Multiple*Nums*Price as SumMoney,Money,QuashStatus,ExecutedCount,ExecutedCount*Multiple*Nums*Price as ExcutedMoney,")
.Append("IsuseCount-ExecutedCount as NoExecutedCount,Title,StopTypeWhenWin,StopTypeWhenWinMoney from T_Chases a inner join T_Lotteries b ")
.Append("on a.LotteryID = b.ID and a.ID=" + ChaseID.ToString() + " ")
.Append("left join (select ChaseID,count(SchemeID) as ExecutedCount from T_ExecutedChases group by ChaseID)c on a.ID = c.ChaseID");
DataTable dtChase = Shove.Database.MSSQL.Select(sb.ToString());
if (dtChase == null || dtChase.Rows.Count == 0)
{
PF.GoError(ErrorNumber.DataReadWrite, "您还没有追号！", this.GetType().FullName);
return;
}
DataRow dr = dtChase.Rows[0];
lbLotteryName.Text = dr["Name"].ToString();
labTitle.Text = dr["Title"].ToString();
if (dr["StopTypeWhenWin"].ToString() == "1")
{
lbStopCondition.Text = "完成方案";
}
else
{
lbStopCondition.Text = "单期中奖金额达到" + dr["StopTypeWhenWinMoney"].ToString();
}
double SumMoney, BuyedMoney, QuashedMoney;;
int SumIsuseNum, BuyedIsuseNum, QuashedIsuseNum;
SumMoney = Shove._Convert.StrToDouble(dr["SumMoney"].ToString(), 0);
SumIsuseNum = Shove._Convert.StrToInt(dr["IsuseCount"].ToString(), 0);
BuyedIsuseNum = Shove._Convert.StrToInt(dr["ExecutedCount"].ToString(), 0);
QuashedIsuseNum = Shove._Convert.StrToInt(dr["NoExecutedCount"].ToString(), 0);
BuyedMoney = Shove._Convert.StrToDouble(dr["ExcutedMoney"].ToString(), 0);
QuashedMoney = Shove._Convert.StrToDouble(dr["Money"].ToString(), 0);
lbDescription.Text = "</font>共<font color=\'red\'>" + SumIsuseNum.ToString() + "</font>期<font color=\'red\'>" +
SumMoney.ToString("N") + "</font>元; 已完成<font color=\'red\'>" + BuyedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (BuyedMoney).ToString("N") + "</font>元; 未执行<font color=\'red\'>" +
QuashedIsuseNum.ToString() + "</font>期<font color=\'red\'>" + (QuashedMoney).ToString("N") + "</font>元。";
string sql = "select c.Name as PlayTypeName,b.ID,d.Name as IsuseName,LotteryNumber,Multiple,Money,QuashStatus,Buyed " +
"from T_ExecutedChases a inner join T_Schemes b on a.SchemeID = b.ID and a.ChaseID =@ChaseID " +
"inner join T_PlayTypes c on b.PlayTypeID = c.ID " +
"inner join T_Isuses d on b.IsuseID = d.ID";
//sb = new StringBuilder();
//sb.Append("select PlayTypeName,ID,IsuseName,LotteryNumber,Multiple,Money,QuashStatus,Buyed from T_ExecutedChases a inner join V_Schemes b ")
// .Append("on a.SchemeID = b.ID and a.ChaseID =" + ChaseID.ToString() + "");
DataTable dt = Shove.Database.MSSQL.Select(sql, new Shove.Database.MSSQL.Parameter("ChaseID", SqlDbType.BigInt, 0, ParameterDirection.Input, ChaseID.ToString()));
if (dt == null)
{
PF.GoError(ErrorNumber.DataReadWrite, "您还没有追号！", this.GetType().FullName);
return;
}
if (dt.Rows.Count > 0)
{
lbPlayTypeName.Text = dt.Rows[0]["PlayTypeName"].ToString(); //买法类型
}
PF.DataGridBindData(g, dt);
}
