//向excel文件写入数据
private void write_To_Excel()
{
int lines = data_Set_Block.get_Item_Count();
string line = "";
selected = data_Set_Block.get_Selected_Array();
XSSFWorkbook sheets = new XSSFWorkbook();
ISheet sheet0 = sheets.CreateSheet("Result");
sheet0.CreateRow(0).CreateCell(0).SetCellValue(data_Set_Block.get_Recall_Result().ToString());
sheet0.GetRow(0).CreateCell(1).SetCellValue(data_Set_Block.get_Process_Time().ToString());
sheet0.CreateRow(1).CreateCell(0).SetCellValue("Selected Index");
sheet0.GetRow(1).CreateCell(1).SetCellValue("Selected Data");
for (int i = 0; i < lines; i++)
{
if (selected[i] == -1)
{
sheet0.CreateRow(i + 2).CreateCell(0).SetCellValue("-1");
sheet0.GetRow(i + 2).CreateCell(1).SetCellValue("Null");
}
else
{
sheet0.CreateRow(i + 2).CreateCell(0).SetCellValue(selected[i].ToString());
string temp = "(" + data_Set_Block.get_Item(i).get_Profit(selected[i] - 1).ToString() + "," + data_Set_Block.get_Item(i).get_Weight(selected[i] - 1).ToString() + ")";
sheet0.GetRow(i + 2).CreateCell(1).SetCellValue(temp);
}
}
using (FileStream stream = new FileStream(file_Path, FileMode.Create, FileAccess.Write))
{
sheets.Write(stream);
}
}
//直接在显示时绘图
private void Form2_Shown(object sender, EventArgs e)
{
//获取当前图形
Graphics g = this.CreateGraphics();
//创建新原点
PointF origin = new PointF(40, this.Height - 80);
//绘制坐标系的初始线
g.DrawLine(new Pen(Brushes.Black, 2), origin, new PointF(this.Width, this.Height - 80));
g.DrawLine(new Pen(Brushes.Black, 2), origin, new PointF(40, 0));
PointF p1;
PointF p2;
//绘制刻度
for (int i = 1; i * 20 + 40 < this.Width; i++)
{
p1 = new PointF(40 + i * 20, this.Height - 80);
p2 = new PointF(40 + i * 20, this.Height - 85);
g.DrawLine(new Pen(Brushes.Black, 1), p1, p2);
if (i % 5 == 0)
{
p2 = new PointF(30 + i * 20, this.Height - 75);
g.DrawString((i * 20).ToString(), new Font("黑体", 8, FontStyle.Bold), new SolidBrush(Color.Black), p2);
}
}
//绘制刻度下方的字符串
for (int i = 1; i * 20 + 40 < this.Height; i++)
{
g.DrawLine(new Pen(Brushes.Black, 1), new PointF(40, this.Height - 80 - 20 * i), new PointF(45, this.Height - 80 - i * 20));
if (i % 5 == 0)
{
p2 = new PointF(15, this.Height - 85 - 20 * i);
g.DrawString((i * 20).ToString(), new Font("黑体", 8, FontStyle.Bold), new SolidBrush(Color.Black), p2);
}
}
//绘制字符串x和y和原点0
p2 = new PointF(30, this.Height - 75);
g.DrawString("0", new Font("黑体", 8, FontStyle.Bold), new SolidBrush(Color.Black), p2);
p2 = new PointF(this.Width - 30, this.Height - 77);
g.DrawString("x", new Font("黑体", 8, FontStyle.Bold), new SolidBrush(Color.Black), p2);
p2 = new PointF(30, 5);
g.DrawString("y", new Font("黑体", 8, FontStyle.Bold), new SolidBrush(Color.Black), p2);
//获取数据集
data_Set_Block data_Block = form1.get_Data_Block(index0);
//获取数据组个数
int item_Count = data_Block.get_Item_Count();
for (int i = 0; i < item_Count; i++)
{
item_Set item = data_Block.get_Item(i);
//绘制当前数据组
for (int j = 0; j < 3; j++)
{
draw_Point(item.get_Profit(j), item.get_Weight(j));
}
}
}