private void textBoxLotNo_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Return & textBoxLotNo.Text.Trim() != "")
{
if (!int.TryParse(textBoxLotNo.Text, out int b))
{
textBoxLotNo.Text = "";
MessageBox.Show("Nieprawidłowy numer zlecenia");
return;
}
bool debug = false;
#if DEBUG
debug = true;
#endif
if (!SqlOperations.IsLotAlreadyInDb(textBoxLotNo.Text) || debug)
{
currentLotData = SqlOperations.GetLotData(textBoxLotNo.Text);
if (currentLotData.Model.Length > 0)
{
labelModel.Text = "Model: " + currentLotData.Model;
labelOrderedQty.Text = "Ilość " + currentLotData.OrderedQty.ToString();
labelRankA.Text = "Rank A" + Environment.NewLine + currentLotData.RankA;
labelRankB.Text = "Rank B" + Environment.NewLine + currentLotData.RankB;
string expectedMiraeProgram = currentLotData.Model.Remove(6, 1).Insert(6, "X");
if (checkMirae)
{
labelMiraeProgram.Text = "Mirae program: " + currentMiraeProgram;
}
else
{
labelMiraeProgram.Text = "";
}
if (currentMiraeProgram == expectedMiraeProgram || !checkMirae)
{
labelMiraeProgram.Text = labelMiraeProgram.Text + " OK";
textBoxRankAQr.Visible = true;
textBoxRankBQr.Visible = true;
textBoxRankAQr.Focus();
}
else
{
labelMiraeProgram.Text = labelMiraeProgram.Text + Environment.NewLine + " ZŁY PROGRAM!";
labelMiraeProgram.ForeColor = Color.Red;
labelMiraeProgram.Font = new Font(labelMiraeProgram.Font, FontStyle.Bold);
}
ledRanksQty = SqlOperations.MaxRankQty(currentLotData.Model);
labelLedQty.Text = "RankA=" + ledRanksQty.Item1 + " RankB=" + ledRanksQty.Item2;
labelLotData.Text = "Dane zlecenia nr. " + textBoxLotNo.Text;
textBoxRankAQr.Focus();
}
else
{
labelModel.Text = "Brak zlecenia w bazie danych";
labelOrderedQty.Text = "";
labelRankA.Text = "";
labelRankB.Text = "";
textBoxRankAQr.Visible = false;
textBoxRankBQr.Visible = false;
}
string prevModel = "";
if (grid.Rows.Count > 0)
{
prevModel = Tools.getCellValue(grid.Rows[0].Cells["ColumnModel"]);
if (prevModel != "")
{
if (prevModel == currentLotData.Model)
{
string stencil = Tools.getCellValue(grid.Rows[0].Cells["Stencil"]);
if (stencil.Trim() != "")
{
radioButtonCurrentStencil.Enabled = true;
radioButtonCurrentStencil.Checked = true;
radioButtonCurrentStencil.Text = "Aktualny:" + Environment.NewLine + stencil;
radioButtonCurrentStencil.Tag = stencil;
}
}
}
}
}
else
{
MessageBox.Show("Ten LOT jest już w bazie danych");
}
}
}
