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