private void Insert(EReportArea areaNo, string itemNo)
{
string jobNo = "";
string extendJobNo = "";
profJobSet.Type = EReportType.Chemical;
profJobSet.JobNo = "";
profJobSet.AreaNo = areaNo;
profJobSet.ItemNo = itemNo;
profJobSet.ExtendASTM = true;
profJobSet.Select();
int rowCount = profJobSet.RowCount;
if (rowCount > 0)
{
profJobSet.Fetch(0);
jobNo = profJobSet.JobNo;
if (string.IsNullOrWhiteSpace(jobNo) == false)
{
cheCheckSet.Select(jobNo);
if (cheCheckSet.Empty == false)
{
MessageBox.Show("Can't import chemical report because this report already exist in DB!",
"SGS", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
if (rowCount > 1)
{
// Find jobno for additional test results
for (int i = 1; i < profJobSet.RowCount; i++)
{
profJobSet.Fetch(i);
if (profJobSet.Image == null)
{
extendJobNo = profJobSet.JobNo;
break;
}
}
profJobSet.Fetch(0);
}
cheQuery.Insert(extendJobNo);
}
}
}
findButton.PerformClick();
}
private void okButton_Click(object sender, EventArgs e)
{
if (reportGridView.FocusedRowHandle < 0)
{
return;
}
DataRow row = reportGridView.GetDataRow(reportGridView.FocusedRowHandle);
profJobSet.Fetch(row);
AreaNo = profJobSet.AreaNo;
JobNo = profJobSet.JobNo;
ItemNo = profJobSet.ItemNo;
Close();
}
public void Import()
{
DialogProfJobListView dialog = new DialogProfJobListView();
try
{
dialog.Type = EReportType.Physical;
dialog.ShowDialog();
}
finally
{
if (dialog.DialogResult == DialogResult.OK)
{
profJobSet.Type = EReportType.Physical;
profJobSet.JobNo = dialog.JobNo;
profJobSet.ExtendASTM = false;
profJobSet.Select();
profJobSet.Fetch();
Insert();
}
}
}