Аналитический обзор методов и систем имитационного моделирования

rightHandles[i].Paint(mainBufWorks);

}

else

if (treeGridViewWorks.Columns[10].DataGridView["RightHandle", i].Value.ToString() == "checked")

{

rightHandles.Add(new HandleBlock(new SolidBrush(Color.Black), new Pen(Color.Black),

leftIndent * 22 + duration * 22 - 3, currentHeight + 4, 6, 6));

rightHandles[i].Paint(mainBufWorks);

}

}

else

{

rightHandles.Add(new HandleBlock(new SolidBrush(Color.White), new Pen(Color.White), 0, 0, 0, 0));

leftHandles.Add(new HandleBlock(new SolidBrush(Color.White), new Pen(Color.White), 0, 0, 0, 0));

}

#endregion

}

}

#endregion

}

public void EditParentNodeInfo(TreeGridNode node)

{

DateTime minDateChild = DateTime.Today.AddYears(200);

DateTime maxDateChild = DateTime.Today.AddYears(-100);

DateTime currentDateBegin, currentDateEnd;

//TimeSpan n;

#region Изменяем данные о родителе

node.Cells[1].ReadOnly = true;

node.Cells[2].ReadOnly = true;

for (int i = 0; i < node.Nodes.Count; i++)

{

if (node.Nodes[i].HasChildren == true)

{

EditParentNodeInfo(node.Nodes[i]);

}

currentDateBegin = Convert.ToDateTime(node.Nodes[i].Cells[1].Value);

currentDateEnd = Convert.ToDateTime(node.Nodes[i].Cells[2].Value);

//currentDate2 = currentDate2.AddDays(Convert.ToInt16(node.Nodes[i].Cells[2].Value));

if (currentDateBegin < minDateChild)

{

minDateChild = currentDateBegin;

}

if (currentDateEnd > maxDateChild)

{

maxDateChild = currentDateEnd;

}

}

//n = maxDateChild - minDateChild;

node.Cells["Begin"].Value = minDateChild.ToShortDateString() + ' ' + minDateChild.ToShortTimeString();

node.Cells["End"].Value = maxDateChild.ToShortDateString() + ' ' + maxDateChild.ToShortTimeString();

#endregion

}

public int Duration(ToolStripMenuItem Days, ToolStripMenuItem Hours, ToolStripMenuItem Minutes,

DateTime begin, DateTime end)

{

int duration = 0;

if (Days.Checked == true)

{

begin = begin.AddMinutes(-begin.Minute);

begin = begin.AddHours(-begin.Hour);

TimeSpan lengthWork = end - begin;

duration = lengthWork.Days;

if ((lengthWork.Hours != 0) || (lengthWork.Minutes != 0))

duration++;

}

if (Hours.Checked == true)

{

begin = begin.AddMinutes(-begin.Minute);

TimeSpan lengthWork = end - begin;

duration = Convert.ToInt32(Math.Ceiling(lengthWork.TotalMinutes / 60));

}

if (Minutes.Checked == true)

{

TimeSpan lengthWork = end - begin;

duration = Convert.ToInt32(lengthWork.TotalMinutes);

}

return (duration);

}

public int LeftIndent(ToolStripMenuItem Days, ToolStripMenuItem Hours, ToolStripMenuItem Minutes,

DateTime begin, DateTime startDate)

{

int leftIndent = 0;

if (Days.Checked == true)

{

begin = Convert.ToDateTime(begin.ToShortDateString());

startDate = Convert.ToDateTime(startDate.ToShortDateString());

TimeSpan lengthSpan = begin - startDate;

leftIndent = lengthSpan.Days;

/*if ((lengthSpan.Hours != 0) || (lengthSpan.Minutes != 0))

leftIndent++;*/

}

if (Hours.Checked == true)

{

begin = begin.AddMinutes(-begin.Minute);

startDate = startDate.AddMinutes(-startDate.Minute);

TimeSpan lengthSpan = begin - startDate;

leftIndent = Convert.ToInt32(lengthSpan.TotalHours);

/* if (lengthSpan.Minutes != 0)

leftIndent++;*/

}

if (Minutes.Checked == true)

{

TimeSpan lengthSpan = begin - startDate;

leftIndent = Convert.ToInt32(lengthSpan.TotalMinutes);

}

return (leftIndent);

}

}

}using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using Excel = Microsoft.Office.Interop.Excel;

namespace Logist

{

public class FromGant

{

public class Res

{

public string name;

public int count;

public int index;

}

public List<Res> NResources;

public List<Res> VResources;

public string f;

public List<Job> jobs;

public string fname;

public int[] resuse;

public int[,] vresuse;

public FromGant()

{

fname = var.Fname;

NResources = new List<Res>();

VResources = new List<Res>();

}

public void LoadJobs()

{

Excel.Application loadProject = null;

object misValue = System.Reflection.Missing.Value;

loadProject = new Excel.Application();

Excel.Workbook loadProjectBook;

loadProjectBook = loadProject.Workbooks.Open(fname,

Type.Missing, Type.Missing, Type.Missing, Type.Missing,

Type.Missing, Type.Missing, Type.Missing, Type.Missing,

Type.Missing, Type.Missing, Type.Missing, Type.Missing,

Type.Missing, Type.Missing);

Excel.Worksheet loadProjectWorksheet;

Excel.Range excelcell;

//таблица

loadProjectWorksheet = (Excel.Worksheet)loadProjectBook.Sheets[1];

//копирование листа 1 в массив valueArray

Excel.Range excelRange = loadProjectWorksheet.UsedRange;

object[,] valueArray = (object[,])excelRange.get_Value(

Excel.XlRangeValueDataType.xlRangeValueDefault);

jobs = new List<Job>();

#region Загрузка работ

string name, edIzm, index, lefthandle, righthandle, after, before, parent;

DateTime begin, end;

for (int i = 2; i <= valueArray.Length / 11; i++)

{

Job job = new Job();

name = valueArray[i, 1].ToString();

job.name = name;

begin = Convert.ToDateTime(valueArray[i, 2]);

job.startDate = begin;

end = Convert.ToDateTime(valueArray[i, 3]);

job.endDate = end;

job.duration = (end-begin).TotalMinutes;

edIzm = valueArray[i, 4].ToString();

//excelcell = loadProjectWorksheet.get_Range("E" + i.ToString(), Type.Missing);

index = valueArray[i, 6].ToString();

lefthandle = valueArray[i, 7].ToString();

righthandle = valueArray[i, 8].ToString();

//if (valueArray[i, 9] == null)

// after = "";

//else

// after = valueArray[i, 9].ToString();

// if (valueArray[i, 10] == null)

// before = "";

// else

// before = valueArray[i, 10].ToString();

// parent = valueArray[i, 11].ToString();

jobs.Add(job);

}

#endregion;

#region Загрузка списка невозобновляемых ресурсов

//f = "";

loadProjectWorksheet = (Excel.Worksheet)loadProjectBook.Sheets[2];

//копирование листа 2 в массив valueArray

excelRange = loadProjectWorksheet.UsedRange;

valueArray = (object[,])excelRange.get_Value(

Excel.XlRangeValueDataType.xlRangeValueDefault);

for (int i = 2; i <= valueArray.Length / 5; i++)

{

Res resource = new Res();

name = valueArray[i, 1].ToString();

resource.name = name;

// if (valueArray[i, 2] == null)

// edIzm = "";

// else

// edIzm = valueArray[i, 2].ToString();

index = valueArray[i, 3].ToString();

resource.index = Convert.ToInt32(index);

// excelcell = loadProjectWorksheet.get_Range("D" + i.ToString(), Type.Missing);

//parent = valueArray[i, 5].ToString();

//f += name + ' ' + index + '\n';

NResources.Add(resource);

}

#endregion;

#region Загрузка невозобновляемых ресурсов работ

resuse = new int[jobs.Count];

loadProjectWorksheet = (Excel.Worksheet)loadProjectBook.Sheets[4];

//копирование листа 4 в массив valueArray

excelRange = loadProjectWorksheet.UsedRange;

valueArray = (object[,])excelRange.get_Value(

Excel.XlRangeValueDataType.xlRangeValueDefault);

if (valueArray != null)

{

for (int i = 1; i <= valueArray.GetLength(1); i++)

{

if (valueArray[1, i] != null)

{

NResources[i - 1].count = Convert.ToInt32(valueArray[1, i]);

}

}

for (int i = 2; i <= valueArray.GetLength(0); i++)

for (int j = 1; j <= valueArray.GetLength(1); j++)

{

if (valueArray[i, j] != null)

resuse[i - 2] = j;

}

//for (int j = 1; j <= valueArray.GetLength(1); j++)

//{

// if (valueArray[i, j] == null)

// resourcesWorks[i - 1, j, 0] = 0;

// else

// resourcesWorks[i - 1, j, 0] = Convert.ToInt32(valueArray[i, j]);

//}

}

#endregion

#region Загрузка списка возобновляемых ресурсов

loadProjectWorksheet = (Excel.Worksheet)loadProjectBook.Sheets[3];

//копирование листа 3 в массив valueArray

excelRange = loadProjectWorksheet.UsedRange;

valueArray = (object[,])excelRange.get_Value(

Excel.XlRangeValueDataType.xlRangeValueDefault);

if (valueArray != null)

{

for (int i = 2; i <= valueArray.Length / 5; i++)

{

Res resource = new Res();

name = valueArray[i, 1].ToString();

//if (valueArray[i, 2] == null)

// edIzm = "";

//else

// edIzm = valueArray[i, 2].ToString();

index = valueArray[i, 3].ToString();

resource.name = name;

resource.index = Convert.ToInt32(index);

VResources.Add(resource);

}

}

#endregion

#region Загрузка возобновляемых ресурсов работ

vresuse = new int[jobs.Count, VResources.Count];

loadProjectWorksheet = (Excel.Worksheet)loadProjectBook.Sheets[5];

//копирование листа 5 в массив valueArray

excelRange = loadProjectWorksheet.UsedRange;

valueArray = (object[,])excelRange.get_Value(

Excel.XlRangeValueDataType.xlRangeValueDefault);

if (valueArray != null)

{

for (int i = 1; i <= valueArray.GetLength(1); i++)

{

if (valueArray[1, i] != null)

{

VResources[i - 1].count = Convert.ToInt32(valueArray[1, i]);

}

//for (int j = 1; j <= valueArray.GetLength(1); j++)

//{

//if (valueArray[i, j] == null)

// resourcesWorks[i - 1, j, 1] = 0;

//else

// resourcesWorks[i - 1, j, 1] = Convert.ToInt32(valueArray[i, j]);

//}

}

for (int i = 2; i <= valueArray.GetLength(0); i++)

for (int j = 1; j <= valueArray.GetLength(1); j++)

{

if (valueArray[i, j] != null)

vresuse[i - 2, j - 1] = Convert.ToInt32(valueArray[i, j]);

}

}

#endregion

}

public string GetCode()

{

string code="\tSIMULATE\n";

LoadJobs();

for (int i = 0; i < VResources.Count; i++)

{

code += "\tINTEGER &RES" + VResources[i].index + ' ' + VResources[i].name + '\n';

code += "\tLET &RES"+ VResources[i].index +" = " + VResources[i].count + '\n';

}

int num = 0;

foreach (Job job in jobs)

{

if (resuse[num] != 0)

code += "J" + (num + 1) + '\t' + "STORAGE" + ' ' +

NResources[resuse[num] - 1].count + ' ' +

NResources[resuse[num] - 1].name + "\n\tENTER J" + (num + 1)+'\n';

else

code += "J" + (num + 1) + '\t' + "SEIZE JOB" + (num + 1) + '\n';

code+="\tADVANCE " + job.duration + ' ' + job.name + '\n';

for (int i = 0; i < VResources.Count; i++)

{

if (vresuse[num,i]!=0)

code += "\tLET &RES"+ VResources[i].index+" = "+"&RES"+ VResources[i].index+ " - " + vresuse[num,i]+'\n';

}

if (resuse[num] != 0)

code += "\tLEAVE " + "J" + (num + 1)+'\n';

else

code += "\tRELEASE " + "JOB" + (num + 1)+'\n';

num++;

}

code += "\tTERMINATE 1\n\tSTART 1\n\tEND";

//foreach (Res res in NResources)

//{

// code += res.name + ' ' + res.count+'\n';

//}

//foreach (Res res in VResources)

//{

// code += res.name + ' ' + res.count + '\n';

//}

return code;

}

}

}

Размещено на Allbest.ru