static void Main(string[] args)
{
SpeciesIndividual sp = new SpeciesIndividual();
sp.CreateByRandomGenes();
for (int i = 0; i < 5; i++)
{
sp.Select();
sp.Crossover();
sp.Mutate();
sp.CalFitness();
for (int j = 0; j < TSPDATA.SPECIES_Num; j++)
{
Console.WriteLine("存在{0}节课,适应度为{0}", sp.genes.Length, sp.fitness[j]);
}
}
sp.Deletect();
for (int j = 0; j < TSPDATA.LessonNum; j++)
{
Lesson le = Lesson.GetLesson(sp.genes[sp.GetBest(), j]);
if (le.Course != 9)
{
Mycourse mc = new Mycourse();
mc.Time = TSPDATA.Time[le.Time];
mc.Course = TSPDATA.Course[le.Course];
mc.Classm = TSPDATA.Classm[le.Classm];
mc.Room = TSPDATA.Room[le.Room];
mc.Teacher = TSPDATA.Teacher[le.Teacher];
Console.WriteLine("时间：{0}，教师：{1}，教室：{2},课程：{3}，班级：{4}", mc.Time, mc.Teacher, mc.Room, mc.Course, mc.Classm);
if (Method.insertlesson(mc))
{
Console.WriteLine("插入第{0}节课成功", j);
}
}
}
Console.ReadKey();
}
public static bool insertlesson(Mycourse le)
{
using (SqlConnection scon = new SqlConnection(str))
{
using (SqlCommand scom = scon.CreateCommand())
{
scon.Open();
scom.CommandText = "insert into CSTable(Time,CourseName,Techaer,ClassRoom,Classm) values(@time,@course,@teacher,@classroom,@class)";
SqlParameter[] p = new SqlParameter[]
{
new SqlParameter("@time", le.Time),
new SqlParameter("course", le.Course),
new SqlParameter("@teacher", le.Teacher),
new SqlParameter("@classroom", le.Room),
new SqlParameter("@class", le.Classm)
};
scom.Parameters.AddRange(p);
return(scom.ExecuteNonQuery() > 0);
}
}
}
