private void btnYuceSuccess_Click(object sender, EventArgs e)
{
DataTable dt = StrategyDAL.GetAnalysis1Data();
Dictionary <String, List <DataRow> > riqiDict = new Dictionary <string, List <DataRow> >();
//按照日期分类
foreach (DataRow row in dt.Rows)
{
String riqi = row["riqi"].ToString();
List <DataRow> rows;
if (riqiDict.TryGetValue(riqi, out rows))
{
rows.Add(row);
}
else
{
rows = new List <DataRow>();
rows.Add(row);
riqiDict[riqi] = rows;
}
}
List <AnalysisResult> matchshouyi = new List <AnalysisResult>();
AnalysisResult shouyi = new AnalysisResult();
double totalCount = 0.0;
double totalLucky = 0.0;
//遍历字典
foreach (KeyValuePair <string, List <DataRow> > keyvalue in riqiDict)
{
shouyi = new AnalysisResult();
shouyi.riqi = keyvalue.Key;
List <DataRow> rows = keyvalue.Value;
double sum = 0;
int luckysum = 0;
foreach (DataRow row in rows)
{
string lucky = row["lucky"].ToString();
string luckycount = row["luckycount"].ToString();
if (lucky == "1")
{
luckysum = Convert.ToInt32(luckycount);
}
sum += Convert.ToInt32(luckycount);
}
shouyi.ratio = luckysum / sum;
shouyi.yucecount = sum;
totalCount += sum;
totalLucky += luckysum;
shouyi.sumratio = totalLucky / totalCount;
matchshouyi.Add(shouyi);
}
dataGridView1.DataSource = matchshouyi;
PrintPicture(matchshouyi);
}
