/////////////////////////////////////////////////////////////////////////////////////
// 查询开奖信息并开奖。
private void QueryIsuseOpen()
{
DataTable dt = new DAL.Views.V_Isuses().Open(ConnectionString, "[ID], LotteryID, [Name]", "IsOpened = 0 and State >= 5 and PrintOutType = 102", "EndTime");
if (dt == null)
{
msg.Send("电子票查询开奖出错(QueryIsuseOpen)。");
log.Write("电子票查询开奖出错(QueryIsuseOpen)。");
return;
}
if (dt.Rows.Count < 1)
{
return;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i % 100 == 0)
{
System.Threading.Thread.Sleep(1000);
}
string IsuseID = dt.Rows[i]["ID"].ToString();
string LotteryName = GetLotteryName(Shove._Convert.StrToInt(dt.Rows[i]["LotteryID"].ToString(), 0));
string IsuseName = dt.Rows[i]["Name"].ToString();
DateTime Now = DateTime.Now;
string MessageID = ElectronTicket_HPSH_UserName + Now.ToString("yyyyMMdd") + Now.ToString("HHmmss") + (i % 100).ToString().PadLeft(2, '0');
string Body = "<body><bonusQuery><issue gameName=\"" + LotteryName + "\" number=\"" + IsuseName + "\"/></bonusQuery></body>";
string TimeStamp = Now.ToString("yyyyMMdd") + Now.ToString("HHmmss");
string Message = "<?xml version=\"1.0\" encoding=\"GBK\"?>";
Message += "<message version=\"1.0\" id=\"" + MessageID + "\">";
Message += "<header>";
Message += "<messengerID>" + ElectronTicket_HPSH_UserName + "</messengerID>";
Message += "<timestamp>" + TimeStamp + "</timestamp>";
Message += "<transactionType>106</transactionType>";
Message += "<digest>" + Shove._Security.Encrypt.MD5(MessageID + TimeStamp + ElectronTicket_HPSH_UserPassword + Body, "gb2312") + "</digest>";
Message += "</header>";
Message += Body;
Message += "</message>";
WriteElectronTicketLog(true, "106", "transType=106&transMessage=" + Message);
string ReceiveString = "";
try
{
ReceiveString = PublicFunction.Post(ElectronTicket_HPSH_Getway, "transType=106&transMessage=" + Message, TimeoutSeconds);
}
catch
{
continue;
}
if (ReceiveString.Length <= 10)
{
continue;
}
string[] t_strs = ReceiveString.Split('&');
if ((t_strs == null) || (t_strs.Length < 2))
{
continue;
}
string TransType = t_strs[0];
string TransMessage = t_strs[1];
TransType = TransType.Substring(10);
TransMessage = TransMessage.Substring(13);
WriteElectronTicketLog(false, TransType, ReceiveString);
GetSprize(IsuseID, TransMessage);
}
}
// 查询奖期状态
private void QueryIsuseState()
{
// 查询的几组条件说明：
// 1 有效期内未开奖、未开启的
// 2 已截止未开奖的
DataTable dt = new DAL.Views.V_Isuses().Open(ConnectionString, "[ID], LotteryID, [Name]", "((isOpened = 0 and (Getdate() between StartTime and EndTime) and State = 0) or (isOpened = 0 and Getdate() > EndTime and State < 5)) and PrintOutType = 102", "EndTime");
if (dt == null)
{
msg.Send("期号状态查询错误(QueryIsuseState)。");
log.Write("期号状态查询错误(QueryIsuseState)。");
return;
}
if (dt.Rows.Count < 1)
{
return;
}
for (int i = 0; i < dt.Rows.Count; i++)
{
if (i % 100 == 0)
{
System.Threading.Thread.Sleep(1000);
}
#region 查询奖期
string LotteryName = GetLotteryName(Shove._Convert.StrToInt(dt.Rows[i]["LotteryID"].ToString(), 0));
string IsuseName = dt.Rows[i]["Name"].ToString();
DateTime Now = DateTime.Now;
string MessageID = ElectronTicket_HPSH_UserName + Now.ToString("yyyyMMdd") + Now.ToString("HHmmss") + (i % 100).ToString().PadLeft(2, '0');
string Body = "<body><issueQuery><issue gameName=\"" + LotteryName + "\" number=\"" + IsuseName + "\"/></issueQuery></body>";
string TimeStamp = Now.ToString("yyyyMMdd") + Now.ToString("HHmmss");
string Message = "<?xml version=\"1.0\" encoding=\"GBK\"?>";
Message += "<message version=\"1.0\" id=\"" + MessageID + "\">";
Message += "<header>";
Message += "<messengerID>" + ElectronTicket_HPSH_UserName + "</messengerID>";
Message += "<timestamp>" + TimeStamp + "</timestamp>";
Message += "<transactionType>102</transactionType>";
Message += "<digest>" + Shove._Security.Encrypt.MD5(MessageID + TimeStamp + ElectronTicket_HPSH_UserPassword + Body, "gb2312") + "</digest>";
Message += "</header>";
Message += Body;
Message += "</message>";
WriteElectronTicketLog(true, "102", "transType=102&transMessage=" + Message);
string ReceiveString = "";
try
{
ReceiveString = PublicFunction.Post(ElectronTicket_HPSH_Getway, "transType=102&transMessage=" + Message, TimeoutSeconds);
}
catch
{
continue;
}
if (ReceiveString.Length <= 10)
{
continue;
}
string[] t_strs = ReceiveString.Split('&');
if ((t_strs == null) || (t_strs.Length < 2))
{
continue;
}
string TransType = t_strs[0];
string TransMessage = t_strs[1];
TransType = TransType.Substring(10);
TransMessage = TransMessage.Substring(13);
WriteElectronTicketLog(false, TransType, ReceiveString);
#endregion
#region 处理结果
System.Xml.XmlDocument XmlDoc = new XmlDocument();
System.Xml.XmlNodeList nodes = null;
System.Xml.XmlNodeList nodesIssue = null;
try
{
XmlDoc.Load(new StringReader(TransMessage));
nodes = XmlDoc.GetElementsByTagName("response");
nodesIssue = XmlDoc.GetElementsByTagName("issue");
}
catch
{
continue;
}
if (nodes == null)
{
continue;
}
if (nodes[0].Attributes["code"].Value != "0000")
{
continue;
}
if (nodesIssue == null)
{
continue;
}
DAL.Tables.T_Isuses t_Isuses = new DAL.Tables.T_Isuses();
for (int j = 0; j < nodesIssue.Count; j++)
{
LotteryName = nodesIssue[j].Attributes["gameName"].Value;
IsuseName = nodesIssue[j].Attributes["number"].Value;
string Status = nodesIssue[j].Attributes["status"].Value;
int LotteryID = GetLotteryID(LotteryName);
string WinNumber = "";
try
{
WinNumber = GetWinNumber(LotteryID, nodesIssue[j].Attributes["bonusCode"].Value);
}
catch
{
}
if ((LotteryID < 0) || (String.IsNullOrEmpty(IsuseName)))
{
continue;
}
DataTable dtIsuse = t_Isuses.Open(ConnectionString, "ID, State, WinLotteryNumber", "LotteryID = " + LotteryID.ToString() + " and [Name] = '" + IsuseName + "'", "");
if ((dtIsuse == null) || (dtIsuse.Rows.Count < 1))
{
continue;
}
bool isHasUpdate = false;
if (dtIsuse.Rows[0]["State"].ToString() != Status)
{
t_Isuses.State.Value = Status;
t_Isuses.StateUpdateTime.Value = DateTime.Now;
isHasUpdate = true;
}
if (!String.IsNullOrEmpty(WinNumber) && (dtIsuse.Rows[0]["WinLotteryNumber"].ToString() != WinNumber))
{
t_Isuses.WinLotteryNumber.Value = WinNumber;
isHasUpdate = true;
if (LotteryID == SLS.Lottery.SHSSL.ID)
{
DataTable dtWinTypes = new DAL.Tables.T_WinTypes().Open(ConnectionString, "", "LotteryID =" + LotteryID.ToString(), "");
double[] WinMoneyList = new double[dtWinTypes.Rows.Count * 2];
for (int k = 0; k < dtWinTypes.Rows.Count; k++)
{
WinMoneyList[k * 2] = Shove._Convert.StrToDouble(dtWinTypes.Rows[k]["DefaultMoney"].ToString(), 1);
WinMoneyList[k * 2 + 1] = Shove._Convert.StrToDouble(dtWinTypes.Rows[k]["DefaultMoneyNoWithTax"].ToString(), 1);
}
DataTable dtChaseTaskDetails = new DAL.Tables.T_ChaseTaskDetails().Open(ConnectionString, "", "IsuseID=" + dtIsuse.Rows[0]["ID"].ToString() + " and SchemeID IS NOT NULL", "");
for (int k = 0; k < dtChaseTaskDetails.Rows.Count; k++)
{
string LotteryNumber = dtChaseTaskDetails.Rows[k]["LotteryNumber"].ToString();
string Description = "";
double WinMoneyNoWithTax = 0;
double WinMoney = new SLS.Lottery()[LotteryID].ComputeWin(LotteryNumber, WinNumber, ref Description, ref WinMoneyNoWithTax, int.Parse(dtChaseTaskDetails.Rows[k]["PlayTypeID"].ToString()), WinMoneyList);
if (WinMoney < 1)
{
continue;
}
int ReturnValue = 0;
string ReturnDescprtion = "";
if (DAL.Procedures.P_ChaseTaskStopWhenWin(ConnectionString, Shove._Convert.StrToLong(dtChaseTaskDetails.Rows[k]["SiteID"].ToString(), 1), Shove._Convert.StrToLong(dtChaseTaskDetails.Rows[k]["SchemeID"].ToString(), 0), WinMoney, ref ReturnValue, ref ReturnDescprtion) < 0)
{
msg.Send("电子票撤销追号错误_P_ChaseTaskStopWhenWin。");
log.Write("电子票撤销追号错误_P_ChaseTaskStopWhenWin。");
}
}
}
}
if (isHasUpdate)
{
t_Isuses.Update(ConnectionString, "LotteryID = " + LotteryID.ToString() + " and [Name] = '" + IsuseName + "'");
}
}
#endregion
}
}
