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