// 接收奖期通知
private void IsuseNotice(string TransMessage)
{
System.Xml.XmlDocument XmlDoc = new XmlDocument();
try
{
XmlDoc.Load(new StringReader(TransMessage));
}
catch { }
DAL.Tables.T_Isuses t_Isuses = new DAL.Tables.T_Isuses();
string Body = TransMessage.Substring(TransMessage.IndexOf("<elements"), TransMessage.LastIndexOf("</elements>") - TransMessage.IndexOf("<elements")) + "</elements>";
DataSet ds = new DataSet();
ds.ReadXml(new StringReader(Body));
if (ds == null)
{
return;
}
if (ds.Tables.Count == 0)
{
return;
}
DataTable dt = ds.Tables[0];
if (dt.Rows.Count < 1)
{
return;
}
string MessageID = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
string LotteryName = dr["lotteryid"].ToString();
int LotteryID = GetLotteryID(LotteryName);
string IsuseName = GetIsusesNameToCaiyou(LotteryID.ToString(), dr["issue"].ToString());
string Status = dr["status"].ToString();
string StartTime = dr["starttime"].ToString();
string EndTime = dr["endtime"].ToString();
string WinNumber = "";
if (Shove._Convert.StrToInt(Status, 0) > 1)
{
try
{
WinNumber = GetWinNumber(LotteryID, dr["bonuscode"].ToString());
}
catch { }
}
if ((LotteryID < 0) || (String.IsNullOrEmpty(IsuseName)))
{
continue;
}
if (t_Isuses.GetCount("LotteryID = " + LotteryID.ToString() + " and [Name] = '" + Shove._Web.Utility.FilteSqlInfusion(IsuseName) + "' and year(StartTime) = YEAR(GETDATE())") < 1)
{
DateTime _StartTime = DateTime.Now;
DateTime _EndTime = DateTime.Now;
try
{
_StartTime = DateTime.Parse(StartTime);
_EndTime = DateTime.Parse(EndTime);
}
catch
{
continue;
}
long IsuseID = -1;
string ReturnDescription = "";
if (DAL.Procedures.P_IsuseAdd(LotteryID, IsuseName, _StartTime, _EndTime, "", ref IsuseID, ref ReturnDescription) < 0)
{
continue;
}
if (IsuseID < 0)
{
continue;
}
}
DataTable dtIsuse = t_Isuses.Open("ID, State, WinLotteryNumber", "LotteryID = " + LotteryID.ToString() + " and [Name] = '" + Shove._Web.Utility.FilteSqlInfusion(IsuseName) + "' and year(StartTime) = YEAR(GETDATE())", "");
if ((dtIsuse == null) || (dtIsuse.Rows.Count < 1))
{
continue;
}
if (Status == "1")
{
int ReturnValue = 0;
string ReturnDescprtion = "";
if (DAL.Procedures.P_ElectronTicketAgentSchemeQuash(Shove._Convert.StrToLong(dtIsuse.Rows[0]["ID"].ToString(), 0), ref ReturnValue, ref ReturnDescprtion) < 0)
{
new Log("ElectronTicket\\ZCW").Write("电子票方案撤单错误_P_ElectronTicketAgentSchemeQuash");
continue;
}
}
bool isHasUpdate = false;
if (dtIsuse.Rows[0]["State"].ToString() != Status)
{
isHasUpdate = true;
}
if (isHasUpdate)
{
int ReturnValue = 0;
string ReturnDescprtion = "";
if (DAL.Procedures.P_IsuseUpdate(LotteryID, Shove._Web.Utility.FilteSqlInfusion(IsuseName), Shove._Convert.StrToShort(Status, 0), Shove._Convert.StrToDateTime(StartTime, DateTime.Now.ToString()), Shove._Convert.StrToDateTime(EndTime, DateTime.Now.ToString()), DateTime.Now, WinNumber, ref ReturnValue, ref ReturnDescprtion) < 0)
{
new Log("ElectronTicket\\ZCW").Write("电子票撤销追号错误P_IsuseEdit。");
}
if (ReturnValue < 0)
{
new Log("ElectronTicket\\ZCW").Write(ReturnDescprtion);
}
}
if (!String.IsNullOrEmpty(WinNumber) && (dtIsuse.Rows[0]["WinLotteryNumber"].ToString() != WinNumber))
{
DataTable dtWinTypes = new DAL.Tables.T_WinTypes().Open("", "LotteryID =" + LotteryID.ToString(), "");
double[] WinMoneyList = new double[dtWinTypes.Rows.Count * 2];
for (int k = 0; k < dtWinTypes.Rows.Count; k++)
{
if (Shove._Convert.StrToDouble(dtWinTypes.Rows[k]["DefaultMoney"].ToString(), 1) < 1)
{
MessageID = GetFromXPath(TransMessage, "message/header/messengerid");
ReNotice(MessageID, "13008");
return;
}
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);
}
#region 开奖第一步
DataTable dtWin = null;
dtWin = new DAL.Tables.T_Schemes().Open("LotteryNumber,PlayTypeID,Multiple,ID", "isOpened = 0 and IsuseID = " + dtIsuse.Rows[0]["ID"].ToString(), "[ID]");
if (dtWin == null)
{
return;
}
for (int y = 0; y < dtWin.Rows.Count; y++)
{
string LotteryNumber = "";
try
{
LotteryNumber = dtWin.Rows[y]["LotteryNumber"].ToString();
}
catch
{ }
string Description = "";
double WinMoneyNoWithTax = 0;
try
{
double WinMoney = new SLS.Lottery()[LotteryID].ComputeWin(LotteryNumber, WinNumber, ref Description, ref WinMoneyNoWithTax, int.Parse(dtWin.Rows[y]["PlayTypeID"].ToString()), WinMoneyList);
Shove.Database.MSSQL.ExecuteNonQuery("update T_Schemes set PreWinMoney = @p1, PreWinMoneyNoWithTax = @p2, EditWinMoney = @p3, EditWinMoneyNoWithTax = @p4, WinDescription = @p5 where [ID] = " + dtWin.Rows[y]["ID"].ToString(),
new Shove.Database.MSSQL.Parameter("p1", SqlDbType.Money, 0, ParameterDirection.Input, WinMoney * Shove._Convert.StrToInt(dtWin.Rows[y]["Multiple"].ToString(), 1)),
new Shove.Database.MSSQL.Parameter("p2", SqlDbType.Money, 0, ParameterDirection.Input, WinMoneyNoWithTax * Shove._Convert.StrToInt(dtWin.Rows[y]["Multiple"].ToString(), 1)),
new Shove.Database.MSSQL.Parameter("p3", SqlDbType.Money, 0, ParameterDirection.Input, WinMoney * Shove._Convert.StrToInt(dtWin.Rows[y]["Multiple"].ToString(), 1)),
new Shove.Database.MSSQL.Parameter("p4", SqlDbType.Money, 0, ParameterDirection.Input, WinMoneyNoWithTax * Shove._Convert.StrToInt(dtWin.Rows[y]["Multiple"].ToString(), 1)),
new Shove.Database.MSSQL.Parameter("p5", SqlDbType.VarChar, 0, ParameterDirection.Input, Description));
}
catch
{
continue;
}
}
#endregion
#region 开奖第二步
string OpenAffiche = new OpenAfficheTemplates()[LotteryID];
int SchemeCount, QuashCount, WinCount, WinNoBuyCount;
bool isEndOpen = false;
int ReturnValue = 0;
string ReturnDescription = "";
while (!isEndOpen)
{
SchemeCount = 0;
QuashCount = 0;
WinCount = 0;
WinNoBuyCount = 0;
// 总方案数，处理时撤单数，中奖数，中奖但未成功数
ReturnValue = 0;
ReturnDescription = "";
DataSet dsWin = null;
DAL.Procedures.P_Win(ref dsWin,
Shove._Convert.StrToLong(dtIsuse.Rows[0]["ID"].ToString(), 0),
WinNumber,
OpenAffiche,
1,
true,
ref SchemeCount, ref QuashCount, ref WinCount, ref WinNoBuyCount,
ref isEndOpen,
ref ReturnValue, ref ReturnDescription);
}
#endregion
}
}
MessageID = GetFromXPath(TransMessage, "message/header/messengerid");
ReNotice(MessageID, "13008");
}
// 接收奖期通知
private void IsuseNotice(string TransMessage)
{
System.Xml.XmlDocument XmlDoc = new XmlDocument();
try
{
XmlDoc.Load(new StringReader(TransMessage));
}
catch { }
DAL.Tables.T_Isuses t_Isuses = new DAL.Tables.T_Isuses();
string Body = TransMessage.Substring(TransMessage.IndexOf("<elements"), TransMessage.LastIndexOf("</elements>") - TransMessage.IndexOf("<elements")) + "</elements>";
DataSet ds = new DataSet();
ds.ReadXml(new StringReader(Body));
if (ds == null)
{
return;
}
if (ds.Tables.Count == 0)
{
return;
}
DataTable dt = ds.Tables[0];
if (dt.Rows.Count < 1)
{
return;
}
string MessageID = "";
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
string LotteryName = dr["lotteryid"].ToString();
int LotteryID = GetLotteryID(LotteryName);
string IsuseName = GetIsusesNameToCaiyou(LotteryID.ToString(), dr["issue"].ToString());
string Status = dr["status"].ToString();
string StartTime = dr["starttime"].ToString();
string EndTime = dr["endtime"].ToString();
string WinNumber = "";
if (Shove._Convert.StrToInt(Status, 0) > 1)
{
try
{
WinNumber = GetWinNumber(LotteryID, dr["bonuscode"].ToString());
}
catch { }
}
if ((LotteryID < 0) || (String.IsNullOrEmpty(IsuseName)))
{
continue;
}
if (t_Isuses.GetCount("LotteryID = " + LotteryID.ToString() + " and [Name] = '" + Shove._Web.Utility.FilteSqlInfusion(IsuseName) + "' and year(StartTime) = YEAR(GETDATE())") < 1)
{
DateTime _StartTime = DateTime.Now;
DateTime _EndTime = DateTime.Now;
try
{
_StartTime = DateTime.Parse(StartTime);
_EndTime = DateTime.Parse(EndTime);
}
catch
{
continue;
}
long IsuseID = -1;
string ReturnDescription = "";
if (DAL.Procedures.P_IsuseAdd(LotteryID, IsuseName, _StartTime, _EndTime, "", ref IsuseID, ref ReturnDescription) < 0)
{
continue;
}
if (IsuseID < 0)
{
continue;
}
}
DataTable dtIsuse = t_Isuses.Open("ID, State, WinLotteryNumber", "LotteryID = " + LotteryID.ToString() + " and [Name] = '" + Shove._Web.Utility.FilteSqlInfusion(IsuseName) + "' and year(StartTime) = YEAR(GETDATE())", "");
if ((dtIsuse == null) || (dtIsuse.Rows.Count < 1))
{
continue;
}
if (Status == "1")
{
int ReturnValue = 0;
string ReturnDescprtion = "";
if (DAL.Procedures.P_ElectronTicketAgentSchemeQuash(Shove._Convert.StrToLong(dtIsuse.Rows[0]["ID"].ToString(), 0), ref ReturnValue, ref ReturnDescprtion) < 0)
{
new Log("ElectronTicket\\ZCW").Write("电子票方案撤单错误_P_ElectronTicketAgentSchemeQuash");
continue;
}
}
bool isHasUpdate = false;
if (dtIsuse.Rows[0]["State"].ToString() != Status)
{
isHasUpdate = true;
}
if (isHasUpdate)
{
int ReturnValue = 0;
string ReturnDescprtion = "";
if (DAL.Procedures.P_IsuseUpdate(LotteryID, Shove._Web.Utility.FilteSqlInfusion(IsuseName), Shove._Convert.StrToShort(Status, 0), Shove._Convert.StrToDateTime(StartTime, DateTime.Now.ToString()), Shove._Convert.StrToDateTime(EndTime, DateTime.Now.ToString()), DateTime.Now, WinNumber, ref ReturnValue, ref ReturnDescprtion) < 0)
{
new Log("ElectronTicket\\ZCW").Write("电子票撤销追号错误P_IsuseEdit。");
}
if (ReturnValue < 0)
{
new Log("ElectronTicket\\ZCW").Write(ReturnDescprtion);
}
}
if (!String.IsNullOrEmpty(WinNumber) && (dtIsuse.Rows[0]["WinLotteryNumber"].ToString() != WinNumber))
{
DataTable dtWinTypes = new DAL.Tables.T_WinTypes().Open("", "LotteryID =" + LotteryID.ToString(), "");
double[] WinMoneyList = new double[dtWinTypes.Rows.Count * 2];
for (int k = 0; k < dtWinTypes.Rows.Count; k++)
{
if (Shove._Convert.StrToDouble(dtWinTypes.Rows[k]["DefaultMoney"].ToString(), 1) < 1)
{
MessageID = GetFromXPath(TransMessage, "message/header/messengerid");
ReNotice(MessageID, "13008");
return;
}
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);
}
#region 开奖第一步
DataTable dtWin = null;
dtWin = new DAL.Tables.T_Schemes().Open("LotteryNumber,PlayTypeID,Multiple,ID", "isOpened = 0 and IsuseID = " + dtIsuse.Rows[0]["ID"].ToString(), "[ID]");
if (dtWin == null)
{
return;
}
for (int y = 0; y < dtWin.Rows.Count; y++)
{
string LotteryNumber = "";
try
{
LotteryNumber = dtWin.Rows[y]["LotteryNumber"].ToString();
}
catch
{ }
string Description = "";
double WinMoneyNoWithTax = 0;
try
{
double WinMoney = new SLS.Lottery()[LotteryID].ComputeWin(LotteryNumber, WinNumber, ref Description, ref WinMoneyNoWithTax, int.Parse(dtWin.Rows[y]["PlayTypeID"].ToString()), WinMoneyList);
Shove.Database.MSSQL.ExecuteNonQuery("update T_Schemes set PreWinMoney = @p1, PreWinMoneyNoWithTax = @p2, EditWinMoney = @p3, EditWinMoneyNoWithTax = @p4, WinDescription = @p5 where [ID] = " + dtWin.Rows[y]["ID"].ToString(),
new Shove.Database.MSSQL.Parameter("p1", SqlDbType.Money, 0, ParameterDirection.Input, WinMoney * Shove._Convert.StrToInt(dtWin.Rows[y]["Multiple"].ToString(), 1)),
new Shove.Database.MSSQL.Parameter("p2", SqlDbType.Money, 0, ParameterDirection.Input, WinMoneyNoWithTax * Shove._Convert.StrToInt(dtWin.Rows[y]["Multiple"].ToString(), 1)),
new Shove.Database.MSSQL.Parameter("p3", SqlDbType.Money, 0, ParameterDirection.Input, WinMoney * Shove._Convert.StrToInt(dtWin.Rows[y]["Multiple"].ToString(), 1)),
new Shove.Database.MSSQL.Parameter("p4", SqlDbType.Money, 0, ParameterDirection.Input, WinMoneyNoWithTax * Shove._Convert.StrToInt(dtWin.Rows[y]["Multiple"].ToString(), 1)),
new Shove.Database.MSSQL.Parameter("p5", SqlDbType.VarChar, 0, ParameterDirection.Input, Description));
}
catch
{
continue;
}
}
#endregion
#region 开奖第二步
string OpenAffiche = new OpenAfficheTemplates()[LotteryID];
int SchemeCount, QuashCount, WinCount, WinNoBuyCount;
bool isEndOpen = false;
int ReturnValue = 0;
string ReturnDescription = "";
while (!isEndOpen)
{
SchemeCount = 0;
QuashCount = 0;
WinCount = 0;
WinNoBuyCount = 0;
// 总方案数，处理时撤单数，中奖数，中奖但未成功数
ReturnValue = 0;
ReturnDescription = "";
DataSet dsWin = null;
DAL.Procedures.P_Win(ref dsWin,
Shove._Convert.StrToLong(dtIsuse.Rows[0]["ID"].ToString(), 0),
WinNumber,
OpenAffiche,
1,
true,
ref SchemeCount, ref QuashCount, ref WinCount, ref WinNoBuyCount,
ref isEndOpen,
ref ReturnValue, ref ReturnDescription);
}
#endregion
}
}
MessageID = GetFromXPath(TransMessage, "message/header/messengerid");
ReNotice(MessageID, "13008");
}
