private void button1_Click(object sender, EventArgs e)
{
string riqi = dateTimePicker1.Value.ToString("yyyy-MM-dd");
//获取数据
DataTable dtYuce = new KaijiangDAL().GetKaijiangDateYuce1(riqi);
//绑定datagrid
dataGridView1.DataSource = dtYuce;
//设置颜色
//row.Cells[2].Style.BackColor = Color.Red;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
string spfresult = "-1";
if (row.Cells["spfresult"].Value != null)
{
spfresult = row.Cells["spfresult"].Value.ToString();
}
switch (spfresult)
{
case "3":
row.Cells[5].Style.BackColor = Color.Red;
break;
case "1":
row.Cells[6].Style.BackColor = Color.Yellow;
break;
case "0":
row.Cells[7].Style.BackColor = Color.Blue;
break;
}
string rqspfresult = "-1";
if (row.Cells["rqspfresult"].Value != null)
{
rqspfresult = row.Cells["rqspfresult"].Value.ToString();
}
switch (rqspfresult)
{
case "3":
row.Cells[8].Style.BackColor = Color.Red;
break;
case "1":
row.Cells[9].Style.BackColor = Color.Yellow;
break;
case "0":
row.Cells[10].Style.BackColor = Color.Green;
break;
}
}
}
private void btnCalcShouyiDaily_Click(object sender, EventArgs e)
{
double minShouyi = double.MaxValue;
double maxShouyi = double.MinValue;
string mindate = "";
string maxdate = "";
DataSet yuce = new AppYuceDAL().GetAllYuce();
DataSet kaijiang = new KaijiangDAL().GetAllKaijiang();
double totalshouyi = 0.0;
double defaultTouru = 200;
string currentRiqi = "";
List <DailyShouyi> dailyShouyis = new List <DailyShouyi>();
DailyShouyi dailyshouyi = null;
foreach (DataRow yuceRow in yuce.Tables[0].Rows)
{
string yuceriqi = yuceRow["riqi"].ToString();
if (currentRiqi != yuceriqi)
{
if (dailyshouyi != null)
{
dailyshouyi.shouyi = dailyshouyi.totalprize - dailyshouyi.totaltouru;
}
dailyshouyi = new DailyShouyi();
dailyshouyi.riqi = yuceriqi;
dailyShouyis.Add(dailyshouyi);
currentRiqi = yuceriqi;
}
string yucebianhao = yuceRow["bianhao"].ToString();
string yucerangqiushu = yuceRow["rangqiushu"].ToString();
string yucespfresult = yuceRow["spfresult"].ToString();
DataRow matchedRow = null;
foreach (DataRow kaijiangrow in kaijiang.Tables[0].Rows)
{
if (kaijiangrow["riqi"].ToString() == yuceriqi && kaijiangrow["bianhao"].ToString() == yucebianhao)
{
matchedRow = kaijiangrow;
break;
}
}
if (matchedRow != null)
{
dailyshouyi.totaltouru += defaultTouru;
totalshouyi = totalshouyi - defaultTouru;
double shengsp = 0.0;
double pingsp = 0.0;
double fusp = 0.0;
int spfresult = 0;
double spfresultsp = 0.0;
if (yucerangqiushu == "0")
{
shengsp = Convert.ToDouble(matchedRow["shengsp"]);
pingsp = Convert.ToDouble(matchedRow["pingsp"]);
fusp = Convert.ToDouble(matchedRow["fusp"]);
spfresult = Convert.ToInt32(matchedRow["spfresult"]);
spfresultsp = Convert.ToDouble(matchedRow["spfsp"]);
}
else
{
shengsp = Convert.ToDouble(matchedRow["rqshengsp"]);
pingsp = Convert.ToDouble(matchedRow["rqpingsp"]);
fusp = Convert.ToDouble(matchedRow["rqfusp"]);
spfresult = Convert.ToInt32(matchedRow["rqspfresult"]);
spfresultsp = Convert.ToDouble(matchedRow["rqspfsp"]);
}
//首先要判断是否中奖
if (yucespfresult.Trim().IndexOf(spfresult.ToString()) != -1)
{
if (yucespfresult.Trim().Length == 1)
{
if (yucespfresult == spfresult.ToString())
{
totalshouyi = totalshouyi + defaultTouru * spfresultsp;
dailyshouyi.totalprize += defaultTouru * spfresultsp;
}
}
else
{
//第一个预测结果中奖的情况
string firstString = yucespfresult.Substring(0, 1);
double firstsp = GetMatchedSp(firstString, shengsp, pingsp, fusp);
string secondString = yucespfresult.Substring(1, 1);
double secondsp = GetMatchedSp(secondString, shengsp, pingsp, fusp);
if (secondsp == 0)
{
MessageBox.Show("数据不完整");
}
if (firstString == spfresult.ToString())
{
totalshouyi = totalshouyi + firstsp * (defaultTouru - defaultTouru / secondsp);
dailyshouyi.totalprize += firstsp * (defaultTouru - defaultTouru / secondsp);
}
else
{
totalshouyi = totalshouyi + defaultTouru;
dailyshouyi.totalprize += defaultTouru;
}
}
}
if (totalshouyi > maxShouyi)
{
maxShouyi = totalshouyi;
maxdate = yuceriqi;
}
if (totalshouyi < minShouyi)
{
minShouyi = totalshouyi;
mindate = yuceriqi;
}
}
}
dataGridView1.DataSource = dailyShouyis;
}
