public DataSet GetSchemeTickets(long AgentID, DateTime TimeStamp, string Sign, string SchemeNumber) { new Log("Agent\\ElectronTicket").Write(String.Format("Method=GetSchemeTickets\tAgentID={0}\tTimeStamp={1}\tSign={2}\tSchemeNumber={3}", AgentID, TimeStamp, Sign, SchemeNumber)); DataSet ds = new DataSet(); string UseLotteryList = ""; double Balance = 0; short State = 0; if (Valid(ref ds, ref UseLotteryList, ref Balance, ref State, AgentID, TimeStamp, Sign, SchemeNumber) < 0) { return(ds); } DataTable dt = new DAL.Tables.T_ElectronTicketAgentSchemes().Open("[ID]", "AgentID = " + AgentID.ToString() + " and SchemeNumber = '" + Shove._Web.Utility.FilteSqlInfusion(SchemeNumber) + "'", ""); if ((dt == null) || (dt.Rows.Count < 1)) { BuildReturnDataSetForError(-16, "方案号不存在", ref ds); new Log("Agent\\ElectronTicket").Write("方案号不存在"); return(ds); } long SchemeID = Shove._Convert.StrToLong(dt.Rows[0]["ID"].ToString(), -1); if (SchemeID < 0) { BuildReturnDataSetForError(-16, "方案号不存在", ref ds); new Log("Agent\\ElectronTicket").Write("方案号不存在"); return(ds); } dt = new DAL.Tables.T_ElectronTicketAgentSchemesSendToCenter().Open("Identifiers, Multiple, Money, Ticket, Sends, HandleResult, HandleDescription, WinMoney as Bonus, BonusLevel", "SchemeID = " + SchemeID.ToString(), "[ID]"); if (dt == null) { BuildReturnDataSetForError(-9999, "未知错误", ref ds); new Log("Agent\\ElectronTicket").Write("未知错误"); return(ds); } BuildReturnDataSet(0, ref ds); ds.Tables.Add(dt); return(ds); }
private void BindData(long SchemeID) { DataTable dt = new DAL.Tables.T_ElectronTicketAgentSchemes().Open("SchemeNumber, DateTime, Amount, LotteryNumber, Multiple, state", " ID =" + SchemeID.ToString(), ""); if ((dt == null) || (dt.Rows.Count < 1)) { PF.GoError(ErrorNumber.Unknow, "参数错误", "Agent_ElectronTicket_Scheme"); return; } string t_str = dt.Rows[0]["LotteryNumber"].ToString(); lbSchemeNumber.Text = dt.Rows[0]["SchemeNumber"].ToString(); lbDateTime.Text = dt.Rows[0]["DateTime"].ToString(); lbAmount.Text = dt.Rows[0]["Amount"].ToString(); lbMultiple.Text = dt.Rows[0]["Multiple"].ToString(); string state = dt.Rows[0]["state"].ToString(); lbState.Text = "失败"; if (state == "1") { lbState.Text = "成功"; } DataTable dtLotteryNumber = new DAL.Tables.T_ElectronTicketAgentSchemesElectronTickets().Open("Ticket, identifiers", " SchemeID=" + SchemeID.ToString(), ""); if ((dtLotteryNumber == null) || dtLotteryNumber.Rows.Count < 1) { dtLotteryNumber = new DAL.Tables.T_ElectronTicketAgentSchemesElectronTickets().Open("Ticket, identifiers", " SchemeID=" + SchemeID.ToString(), ""); if ((dtLotteryNumber == null) || dtLotteryNumber.Rows.Count < 1) { return; } } dtLotteryNumber.Columns.Add("count", typeof(System.String)); for (int i = 0; i < dtLotteryNumber.Rows.Count; i++) { dtLotteryNumber.Rows[i]["count"] = (i + 1).ToString(); dtLotteryNumber.AcceptChanges(); } RpElectronTicket.DataSource = dtLotteryNumber; RpElectronTicket.DataBind(); }
protected void btnGO_Step2_Click(object sender, EventArgs e) { btnGO_Step1.AlertText = ""; if (ddlLottery.SelectedValue == SLS.Lottery.ZCDC.sID) { Shove._Web.JavaScript.Alert(this.Page, "足彩单场不支持分步开奖。"); return; } tbWinNumber.Text = Shove._Convert.ToDBC(tbWinNumber.Text.Trim().Replace(" ", " ")).Trim(); if (!new SLS.Lottery()[int.Parse(ddlLottery.SelectedValue)].AnalyseWinNumber(tbWinNumber.Text)) { Shove._Web.JavaScript.Alert(this.Page, "开奖号码不正确!"); return; } SystemOptions so = new SystemOptions(); bool isCompareWinMoneyNoWithFax = so["isCompareWinMoneyNoWithFax"].ToBoolean(true); double[] WinMoneyList = new double[g.Rows.Count * 2]; for (int i = 0; i < g.Rows.Count; i++) { WinMoneyList[i * 2] = Shove._Convert.StrToDouble(((TextBox)g.Rows[i].Cells[1].FindControl("tbMoney")).Text, 0); WinMoneyList[i * 2 + 1] = Shove._Convert.StrToDouble(((TextBox)g.Rows[i].Cells[2].FindControl("tbMoneyNoWithTax")).Text, 0); if (WinMoneyList[i * 2] < 0) { Shove._Web.JavaScript.Alert(this.Page, "第 " + (i + 1).ToString() + " 项奖金输入错误!"); return; } if (WinMoneyList[i * 2] < WinMoneyList[i * 2 + 1]) { if (isCompareWinMoneyNoWithFax) { Shove._Web.JavaScript.Alert(this.Page, "第 " + (i + 1).ToString() + " 项税后奖金输入错误(不能大于税前奖金)!"); return; } } } if (Shove._Convert.ToTextCode(tbOpenAffiche.Value.Trim()) == "") { Shove._Web.JavaScript.Alert(this.Page, "请输入开奖公告!"); return; } DataTable dt = new DAL.Tables.T_ElectronTicketAgentSchemes().Open("*", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(ddlIsuse.SelectedValue) + " and WinMoney is null and state = 1", "[ID]"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().BaseType.FullName); return; } DAL.Tables.T_ElectronTicketAgentSchemes t_ElectronTicketAgentSchemes = new DAL.Tables.T_ElectronTicketAgentSchemes(); for (int i = 0; i < dt.Rows.Count; i++) { string LotteryNumber = dt.Rows[i]["LotteryNumber"].ToString(); string Description = ""; double WinMoneyNoWithTax = 0; double WinMoney = new SLS.Lottery()[int.Parse(ddlLottery.SelectedValue)].ComputeWin(LotteryNumber, tbWinNumber.Text.Trim(), ref Description, ref WinMoneyNoWithTax, int.Parse(dt.Rows[i]["PlayTypeID"].ToString()), WinMoneyList); t_ElectronTicketAgentSchemes.WinMoney.Value = WinMoney * Shove._Convert.StrToInt(dt.Rows[i]["Multiple"].ToString(), 1); t_ElectronTicketAgentSchemes.WinMoneyWithoutTax.Value = WinMoneyNoWithTax * Shove._Convert.StrToInt(dt.Rows[i]["Multiple"].ToString(), 1); t_ElectronTicketAgentSchemes.WinDescription.Value = Description; t_ElectronTicketAgentSchemes.Update("[ID] =" + dt.Rows[i]["ID"].ToString()); } dt = new DAL.Tables.T_ElectronTicketAgentSchemes().Open("top 1 * ", "IsuseID = " + Shove._Web.Utility.FilteSqlInfusion(ddlIsuse.SelectedValue) + " and state = 1 and WinMoney is null", "[ID]"); if (dt == null) { PF.GoError(ErrorNumber.DataReadWrite, "数据库繁忙,请重试", this.GetType().BaseType.FullName); return; } Step2IsOpen = (dt.Rows.Count > 0); btnGO_Step2.Enabled = Step2IsOpen; btnGO_Step3.Enabled = (!Step2IsOpen); string Message = "请再次执行第二步"; if (!Step2IsOpen) { Message = "开奖步骤二已经完成,请执行第三步."; } Shove._Web.JavaScript.Alert(this.Page, Message); }
public DataSet QueryBetting(long AgentID, DateTime TimeStamp, string Sign, string SchemeNumber) { new Log("Agent\\ElectronTicket").Write(String.Format("Method=QueryBetting\tAgentID={0}\tTimeStamp={1}\tSign={2}\tSchemeNumber={3}", AgentID, TimeStamp, Sign, SchemeNumber)); DataSet ds = new DataSet(); string UseLotteryList = ""; double Balance = 0; short State = 0; if (Valid(ref ds, ref UseLotteryList, ref Balance, ref State, AgentID, TimeStamp, Sign, SchemeNumber) < 0) { return(ds); } DataTable dt = new DAL.Tables.T_ElectronTicketAgentSchemes().Open("[ID], State, BettingDescription", "AgentID = " + AgentID.ToString() + " and SchemeNumber = '" + Shove._Web.Utility.FilteSqlInfusion(SchemeNumber) + "'", ""); if (dt == null) { BuildReturnDataSetForError(-9999, "未知错误", ref ds); new Log("Agent\\ElectronTicket").Write("未知错误"); return(ds); } if (dt.Rows.Count < 1) { BuildReturnDataSetForError(-16, "方案号不存在", ref ds); new Log("Agent\\ElectronTicket").Write("方案号不存在"); return(ds); } long SchemeID = Shove._Convert.StrToLong(dt.Rows[0]["ID"].ToString(), -1); short SchemeState = Shove._Convert.StrToShort(dt.Rows[0]["State"].ToString(), -1); string BettingDescription = dt.Rows[0]["BettingDescription"].ToString(); if ((SchemeID < 0) || (SchemeState < 0)) { BuildReturnDataSetForError(-9999, "未知错误", ref ds); new Log("Agent\\ElectronTicket").Write("未知错误"); return(ds); } if (SchemeState == 0) { BuildReturnDataSetForError(-24, "等待出票", ref ds); new Log("Agent\\ElectronTicket").Write("等待出票"); return(ds); } if (SchemeState >= 2) { BuildReturnDataSetForError(-13, "出票失败(" + BettingDescription + ")", ref ds); new Log("Agent\\ElectronTicket").Write("出票失败(" + BettingDescription + ")"); return(ds); } BuildReturnDataSet(0, ref ds); DataTable dtTickets = new DAL.Tables.T_ElectronTicketAgentSchemesSendToCenter().Open("Identifiers as TicketID", "SchemeID = " + SchemeID.ToString(), "[ID]"); ds.Tables.Add(dtTickets); return(ds); }
public DataSet GetUnsuccessfulSchemes(long AgentID, DateTime TimeStamp, string Sign, int LotteryID, string IssueName) { new Log("Agent\\ElectronTicket").Write(String.Format("Method=GetUnsuccessfulSchemes\tAgentID={0}\tTimeStamp={1}\tSign={2}\tLotteryID={3}\tIssueName={4}", AgentID, TimeStamp, Sign, LotteryID, IssueName)); DataSet ds = new DataSet(); string UseLotteryList = ""; double Balance = 0; short State = 0; if (Valid(ref ds, ref UseLotteryList, ref Balance, ref State, AgentID, TimeStamp, Sign, LotteryID, IssueName) < 0) { return(ds); } if (ValidLotteryID(ref ds, UseLotteryList, LotteryID) < 0) { return(ds); } DataTable dt = new DAL.Tables.T_Isuses().Open("[ID], StartTime, EndTime, State, isOpened", "LotteryID = " + LotteryID.ToString() + "and [Name] = '" + Shove._Web.Utility.FilteSqlInfusion(IssueName) + "'", ""); if ((dt == null) || (dt.Rows.Count < 1)) { BuildReturnDataSetForError(-4, "奖期不存在", ref ds); new Log("Agent\\ElectronTicket").Write("奖期不存在"); return(ds); } long IsuseID = Shove._Convert.StrToLong(dt.Rows[0]["ID"].ToString(), -1); DateTime StartTime = Shove._Convert.StrToDateTime(dt.Rows[0]["StartTime"].ToString(), "1980-1-1 0:0:0"); short IsuseState = Shove._Convert.StrToShort(dt.Rows[0]["State"].ToString(), -1); if (IsuseID < 0) { BuildReturnDataSetForError(-4, "奖期不存在", ref ds); new Log("Agent\\ElectronTicket").Write("奖期不存在"); return(ds); } DateTime Now = DateTime.Now; if ((Now < StartTime) || (IsuseState < 1)) { BuildReturnDataSetForError(-5, "奖期未开启", ref ds); new Log("Agent\\ElectronTicket").Write("奖期未开启"); return(ds); } BuildReturnDataSet(0, ref ds); DataTable dtSchemes = new DAL.Tables.T_ElectronTicketAgentSchemes().Open("SchemeNumber, State", "AgentID = " + AgentID.ToString() + " and IsuseID = " + IsuseID.ToString() + " and State <> 1", "[ID]"); ds.Tables.Add(dtSchemes); return(ds); }