public void RetrieveProductPrice(String ID)
{
SqlConnection RetrieveProductPrice = new SqlConnection("Data Source=SELAKA\\SELA;Initial Catalog=SATHOSA;Integrated Security=True");
SqlCommand Select = new SqlCommand("Select Product_Selling_Price FROM Product Where Product_ID=@ID;", RetrieveProductPrice);
//MessageBox.Show(""+ID);
Select.Parameters.AddWithValue("@ID", ID);
try
{
SqlDataReader DataReader2;
RetrieveProductPrice.Open();
DataReader2 = Select.ExecuteReader();
while (DataReader2.Read())
{
metroTextBox7.Text = DataReader2["Product_Selling_Price"].ToString();
}
DataReader2.Close();
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
finally
{
RetrieveProductPrice.Close();
}
}
public override void BuildTrainingEnvironment()
{
string inputDir = Path.GetFullPath(Path.Combine(Directory.GetCurrentDirectory(), @"..\..\..\", "Parameters", Program.ParametersDirectory));
string outputDir = @"C:\CSSLWaferFab\Output\RLToyFab\";
Simulation = new RLSimulation("RLToyFab", outputDir);
// Fab settings
//IDataReader reader = new DataReader1(inputDir);
IDataReader reader = new DataReader2(inputDir);
ToyFabSettings toyFabSettings = reader.ReadToyFabSettings();
// Build the model
toyFab = new ToyFab(Simulation.MyModel, "ToyFab", this)
{
LotSteps = toyFabSettings.LotSteps,
};
LotOutObserver LotOutObserver = new LotOutObserver(Simulation, "LotOutObserver");
// Work stations
foreach (string wc in toyFabSettings.WorkStations)
{
WorkStation workStation = new WorkStation(toyFab, $"WorkCenter_{wc}", toyFabSettings.LotStepsPerWorkStation[wc]);
workStation.DispatcherWarmUp = new FIFODispatcher(workStation, workStation.Name + "_FIFODispatcher");
if (wc == Program.WSWithRLDispatcher || Program.WSWithRLDispatcher == "")
{
workStation.Dispatcher = new RLDispatcherDeductedActionSpace(workStation, workStation.Name + "_RLDispatcher", this, Program.TimePerDispatchTrigger);
}
else
{
workStation.Dispatcher = new FIFODispatcher(workStation, workStation.Name + "_FIFODispatcher");
}
// Machines
foreach (MachineData m in toyFabSettings.Machines.Where(x => x.WorkStation == wc))
{
Machine machine = new Machine(toyFab, $"{workStation.Name}_Machine{m.Number}", new GammaDistribution(m.MeanServiceTime, Math.Pow(m.COVServiceTime * m.MeanServiceTime, 2)), workStation, m.Number);
machine.Eligibilities = m.Eligibilities;
workStation.Machines.Add(machine);
machine.Subscribe(LotOutObserver);
}
toyFab.AddWorkCenter(workStation.Name, workStation);
}
foreach (var sequence in toyFabSettings.Sequences)
{
toyFab.AddSequence(sequence.Key, sequence.Value);
}
toyFab.SetLotGenerator(new LotGenerator(toyFab, "LotGenerator", Program.NumberOfLots));
}
public MasterRelease GetMasterRelease(int id)
{
string response = this.DownloadString(this.baseUrl + "master/" + id);
this.UpdateRateLimit();
using (StringReader stringReader = new StringReader(response))
{
using (XmlReader xmlReader = XmlReader.Create(stringReader))
{
DataReader2 dataReader = new DataReader2(xmlReader);
dataReader.ReadResponseHeader();
return(dataReader.ReadMasterRelease());
}
}
}
public Artist GetArtist(string artistName)
{
string escapedArtistName = Uri.EscapeDataString(artistName);
string response = this.DownloadString(this.baseUrl + "artist/" + escapedArtistName);
this.UpdateRateLimit();
using (StringReader stringReader = new StringReader(response))
{
using (XmlReader xmlReader = XmlReader.Create(stringReader))
{
DataReader2 dataReader = new DataReader2(xmlReader);
dataReader.ReadResponseHeader();
return(dataReader.ReadArtist());
}
}
}
public void Dispose()
{
SearchKey = null;
if (IsBufferMode)
{
CachedResult.Dispose();
}
else
{
DBConnection.Dispose();
DataReader.Dispose();
if (DataReader2 != null)
{
DataReader2.Dispose();
}
}
}
public static void RunNormalSimulation()
{
string inputDir = Path.GetFullPath(Path.Combine(Directory.GetCurrentDirectory(), @"..\..\..\", "Parameters", ParametersDirectory));
string outputDir = @"C:\CSSLWaferFab\Output\RLToyFab\";
CSSL.Modeling.Settings.WriteOutput = true;
// Fab settings
//IDataReader reader = new DataReader1(inputDir);
IDataReader reader = new DataReader2(inputDir);
ToyFabSettings toyFabSettings = reader.ReadToyFabSettings();
// Build Fab
Simulation sim = new Simulation("RLToyFab", outputDir);
// Experiment settings
sim.MyExperiment.NumberOfReplications = 10;
sim.MyExperiment.LengthOfWarmUp = LengthOfWarmUp;
sim.MyExperiment.LengthOfReplication = LengthOfReplication;
// Build the model
ToyFab toyFab = new ToyFab(sim.MyModel, "WaferFab")
{
LotSteps = toyFabSettings.LotSteps,
LengthOfWarmUp = LengthOfWarmUp
};
AddWorkStations(toyFab, toyFabSettings, sim);
foreach (var sequence in toyFabSettings.Sequences)
{
toyFab.AddSequence(sequence.Key, sequence.Value);
}
toyFab.SetLotGenerator(new LotGenerator(toyFab, "LotGenerator", NumberOfLots));
sim.Run();
// Report summary
SimulationReporter reporter = sim.MakeSimulationReporter();
reporter.PrintSummaryToFile();
reporter.PrintSummaryToConsole();
}
public void BufferData(int highestRow)
{
if (!IsBufferMode)
{
var isStop = false;
while (CachedResult.Rows.Count < highestRow && !isStop)
{
isStop = true;
DataRow row = null;
if (DataReader != null && DataReader.Read())
{
row = CachedResult.NewRow();
CachedResult.Rows.Add(row);
var count = DataReader.FieldCount;
for (var i = 0; i < count; i++)
{
row[DataReader.GetName(i)] = DataReader.GetValue(i);
}
isStop = false;
}
if (DataReader2 != null && DataReader2.Read())
{
if (row == null)
{
row = CachedResult.NewRow();
CachedResult.Rows.Add(row);
}
var count = DataReader2.FieldCount;
for (var i = 0; i < count; i++)
{
row[DataReader2.GetName(i)] = DataReader2.GetValue(i);
}
isStop = false;
}
}
}
}
public void BufferData(int highestRow)
{
if (!IsBufferMode)
{
var isStop = false;
if (DataReader2 == null)
{
while (CachedResult.Rows.Count < highestRow && !isStop)
{
isStop = true;
DataRow row = null;
if (DataReader != null && DataReader.Read())
{
row = CachedResult.NewRow();
CachedResult.Rows.Add(row);
var count = DataReader.FieldCount;
for (var i = 0; i < count; i++)
{
row[DataReader.GetName(i)] = DataReader.GetValue(i);
}
isStop = false;
}
if (DataReader2 != null && DataReader2.Read())
{
if (row == null)
{
row = CachedResult.NewRow();
CachedResult.Rows.Add(row);
}
var count = DataReader2.FieldCount;
for (var i = 0; i < count; i++)
{
row[DataReader2.GetName(i)] = DataReader2.GetValue(i);
}
isStop = false;
}
}
}
else
{
string primaryKey = null;
for (var i = 0; i < DataReader.FieldCount; i++)
{
for (var j = 0; j < DataReader2.FieldCount; j++)
{
if (DataReader.GetName(i) == DataReader2.GetName(j))
{
primaryKey = DataReader.GetName(i);
}
}
}
while (CachedResult.Rows.Count < highestRow && !isStop)
{
isStop = true;
DataRow row = null;
if (DataReader != null && DataReader.Read())
{
row = CachedResult.NewRow();
CachedResult.Rows.Add(row);
var count = DataReader.FieldCount;
for (var i = 0; i < count; i++)
{
row[DataReader.GetName(i)] = DataReader.GetValue(i);
}
isStop = false;
}
}
DataTable dt1 = CachedResult.Copy();
CachedResult.Clear();
isStop = false;
while (CachedResult.Rows.Count < highestRow && !isStop)
{
isStop = true;
DataRow row = null;
if (DataReader2 != null && DataReader2.Read())
{
if (row == null)
{
row = CachedResult.NewRow();
CachedResult.Rows.Add(row);
}
var count = DataReader2.FieldCount;
for (var i = 0; i < count; i++)
{
row[DataReader2.GetName(i)] = DataReader2.GetValue(i);
}
isStop = false;
}
}
DataTable dt2 = CachedResult.Copy();
CachedResult.Clear();
var tables = new DataTable[] { dt1, dt2 };
CachedResult = MergeAll(tables.ToList(), primaryKey);
}
}
}
public LabelReader2(string filename)
{
this.streamReader = new StreamReader(filename, Encoding.UTF8);
this.xmlReader = XmlReader.Create(this.streamReader, this.GetXmlReaderSettings());
this.dataReader = new DataReader2(this.xmlReader);
}
public LabelReader2(TextReader textReader)
{
this.xmlReader = XmlReader.Create(textReader, this.GetXmlReaderSettings());
this.dataReader = new DataReader2(this.xmlReader);
}
public LabelReader2(XmlReader xmlReader)
{
this.xmlReader = xmlReader;
this.dataReader = new DataReader2(this.xmlReader);
}
public MasterReleaseReader2(TextReader textReader)
{
this.xmlReader = XmlReader.Create(textReader, this.GetXmlReaderSettings());
this.dataReader = new DataReader2(this.xmlReader);
}
public MasterReleaseReader2(XmlReader xmlReader)
{
this.xmlReader = xmlReader;
this.dataReader = new DataReader2(this.xmlReader);
}
public ArtistReader2(XmlReader xmlReader)
{
this.xmlReader = xmlReader;
this.dataReader = new DataReader2(this.xmlReader);
}
