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 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}", new object[] { AgentID, TimeStamp, Sign, SchemeNumber })); DataSet returnDS = new DataSet(); string useLotteryList = ""; double balance = 0.0; short state = 0; if (this.Valid(ref returnDS, ref useLotteryList, ref balance, ref state, AgentID, TimeStamp, Sign, new object[] { SchemeNumber }) >= 0) { DataTable table = new Tables.T_ElectronTicketAgentSchemes().Open("[ID], State, BettingDescription", "AgentID = " + AgentID.ToString() + " and SchemeNumber = '" + Utility.FilteSqlInfusion(SchemeNumber) + "'", ""); if (table == null) { this.BuildReturnDataSetForError(-9999, "未知错误", ref returnDS); new Log(@"Agent\ElectronTicket").Write("未知错误"); return returnDS; } if (table.Rows.Count < 1) { this.BuildReturnDataSetForError(-16, "方案号不存在", ref returnDS); new Log(@"Agent\ElectronTicket").Write("方案号不存在"); return returnDS; } long num3 = _Convert.StrToLong(table.Rows[0]["ID"].ToString(), -1L); short num4 = _Convert.StrToShort(table.Rows[0]["State"].ToString(), -1); string str2 = table.Rows[0]["BettingDescription"].ToString(); if ((num3 < 0L) || (num4 < 0)) { this.BuildReturnDataSetForError(-9999, "未知错误", ref returnDS); new Log(@"Agent\ElectronTicket").Write("未知错误"); return returnDS; } if (num4 == 0) { this.BuildReturnDataSetForError(-24, "等待出票", ref returnDS); new Log(@"Agent\ElectronTicket").Write("等待出票"); return returnDS; } if (num4 >= 2) { this.BuildReturnDataSetForError(-13, "出票失败(" + str2 + ")", ref returnDS); new Log(@"Agent\ElectronTicket").Write("出票失败(" + str2 + ")"); return returnDS; } this.BuildReturnDataSet(0L, ref returnDS); DataTable table2 = new Tables.T_ElectronTicketAgentSchemesSendToCenter().Open("Identifiers as TicketID", "SchemeID = " + num3.ToString(), "[ID]"); returnDS.Tables.Add(table2); } return returnDS; }
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; }
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}", new object[] { AgentID, TimeStamp, Sign, SchemeNumber })); DataSet returnDS = new DataSet(); string useLotteryList = ""; double balance = 0.0; short state = 0; if (this.Valid(ref returnDS, ref useLotteryList, ref balance, ref state, AgentID, TimeStamp, Sign, new object[] { SchemeNumber }) >= 0) { DataTable table = new Tables.T_ElectronTicketAgentSchemes().Open("[ID]", "AgentID = " + AgentID.ToString() + " and SchemeNumber = '" + Utility.FilteSqlInfusion(SchemeNumber) + "'", ""); if ((table == null) || (table.Rows.Count < 1)) { this.BuildReturnDataSetForError(-16, "方案号不存在", ref returnDS); new Log(@"Agent\ElectronTicket").Write("方案号不存在"); return returnDS; } long num3 = _Convert.StrToLong(table.Rows[0]["ID"].ToString(), -1L); if (num3 < 0L) { this.BuildReturnDataSetForError(-16, "方案号不存在", ref returnDS); new Log(@"Agent\ElectronTicket").Write("方案号不存在"); return returnDS; } table = new Tables.T_ElectronTicketAgentSchemesSendToCenter().Open("Identifiers, Multiple, Money, Ticket, Sends, HandleResult, HandleDescription, WinMoney as Bonus, BonusLevel", "SchemeID = " + num3.ToString(), "[ID]"); if (table == null) { this.BuildReturnDataSetForError(-9999, "未知错误", ref returnDS); new Log(@"Agent\ElectronTicket").Write("未知错误"); return returnDS; } this.BuildReturnDataSet(0L, ref returnDS); returnDS.Tables.Add(table); } return returnDS; }