public WinnerViewModel(WinnerInfo winnerInfo)
{
UserId = winnerInfo.UserId;
Position = winnerInfo.Position;
Amount = winnerInfo.Amount;
HandScore = winnerInfo.HandScore;
Hand = ((PokerScores)HandScore).ToString();
}
private void btnStartOrStop_Click(object sender, EventArgs e)
{
if (btnStartOrStop.Text == "继续摇奖")
{
ClearLabel(everyNum);
btnStartOrStop.Text = "停止";
toolStripMenuItem1_Click(sender, e);
//b = true;
axMusicPlay.Ctlcontrols.stop();
}
else
{
//取值插入数据库
b = false;
for (int i = 0; i < everyNum; i++)
{
if (ths != null && ths[i] != null)
{
ths[i].Abort();
}
}
using (SQLiteConnection connection = new SQLiteConnection(SQLiteHelper.Conn))
{
connection.Open();
using (DbTransaction dbTrans = connection.BeginTransaction())
{
using (DbCommand cmd = connection.CreateCommand())
{
try
{
for (int j = 0; j < everyNum; j++)
{
Label label = FindControl(j.ToString()) as Label;
WinnerInfo winnerInfo = new WinnerInfo();
if (prizeCurrent == 0)
{
winnerInfo.PrizeID = Convert.ToInt32(dtPrize.Rows[prizeCurrent]["ID"]);
}
else
{
winnerInfo.PrizeID = Convert.ToInt32(dtPrize.Rows[prizeCurrent - 1]["ID"]);//prizeCurrent有++操作，所以此处要-1
}
winnerInfo.WinnerName = label.Text;
winnerInfo.WinnerPhone = string.Empty;
cmd.CommandText = "INSERT INTO Winners(PrizeID,Winner,WinnerPhone) VALUES (@PrizeID,@Winner,@WinnerPhone)";
cmd.Parameters.Add(new SQLiteParameter("@PrizeID", winnerInfo.PrizeID));
cmd.Parameters.Add(new SQLiteParameter("@Winner", winnerInfo.WinnerName));
cmd.Parameters.Add(new SQLiteParameter("@WinnerPhone", winnerInfo.WinnerPhone));
cmd.ExecuteNonQuery();
listStr.Remove(winnerInfo.WinnerName);
}
dbTrans.Commit();
btnStartOrStop.Text = "继续摇奖";
}
catch (Exception ex)
{
dbTrans.Rollback();
MessageBox.Show("该次名单保存失败！！" + ex.Message);
}
}
}
}
axMusicPlay.URL = ConfigHelper.GetValue("StopMusic");//ConfigurationManager.AppSettings["StopMusic"].ToString();
axMusicRoll.Ctlcontrols.pause();
}
}
