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