private void btnSearch_Click(object sender, EventArgs e)
{
try
{
SoccerSingleDAL dal = new SoccerSingleDAL();
DataSet ds = dal.SearchDanchang();
List<SoccerSingleAnalysis> danChangAnalyses = new List<SoccerSingleAnalysis>();
foreach (DataRow row in ds.Tables[0].Rows)
{
SoccerSingleAnalysis analysis = new SoccerSingleAnalysis();
analysis.riqi = row["riqi"].ToString();
analysis.bianhao = row["bianhao"].ToString();
analysis.liansai = row["liansai"].ToString();
analysis.shengsp = row["shengsp"].ToString();
analysis.pingsp = row["pingsp"].ToString();
analysis.fusp = row["fusp"].ToString();
analysis.rqshengsp = row["rqshengsp"].ToString();
analysis.rqpingsp = row["rqpingsp"].ToString();
analysis.rqfusp = row["rqfusp"].ToString();
analysis.spfresult = row["spfresult"].ToString();
analysis.rqspfresult = row["rqspfresult"].ToString();
analysis.spfrank = GetSpfRank(analysis);
analysis.rqspfrank = GetRqSpfRank(analysis);
danChangAnalyses.Add(analysis);
}
dataGridView1.DataSource = danChangAnalyses;
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private string GetSpfRank(SoccerSingleAnalysis analysis)
{
int rank = 0;
String tempSp = "0";
switch (analysis.spfresult)
{
case "3":
tempSp = analysis.shengsp;
break;
case "1":
tempSp = analysis.pingsp;
break;
case "0":
tempSp = analysis.fusp;
break;
}
if (analysis.shengsp.Equals("0"))
{
return "0";
}
if (Convert.ToDouble(tempSp) >= Convert.ToDouble(analysis.shengsp))
{
rank ++;
}
if (Convert.ToDouble(tempSp) >= Convert.ToDouble(analysis.pingsp))
{
rank++;
}
if (Convert.ToDouble(tempSp) >= Convert.ToDouble(analysis.fusp))
{
rank++;
}
return rank.ToString();
}
