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 bool InsertPart(PartColumns col, SqlTransaction trans)
{
string jobNo = "";
string extendJobNo = "";
cheQuery.ProfJobSet.Type = EReportType.Chemical;
cheQuery.ProfJobSet.JobNo = "";
cheQuery.ProfJobSet.AreaNo = bomSet.AreaNo;
cheQuery.ProfJobSet.ItemNo = col.MaterialNo;
cheQuery.ProfJobSet.ExtendASTM = true;
cheQuery.ProfJobSet.Select(trans);
int rowCount = cheQuery.ProfJobSet.RowCount;
if (rowCount > 0)
{
cheQuery.ProfJobSet.Fetch(0);
jobNo = cheQuery.ProfJobSet.JobNo;
if (string.IsNullOrWhiteSpace(jobNo) == false)
{
cheMainSet.RecNo = jobNo;
cheMainSet.ReportApproval = EReportApproval.None;
cheMainSet.AreaNo = EReportArea.None;
cheMainSet.From = "";
cheMainSet.To = "";
cheMainSet.MaterialNo = "";
cheMainSet.Select(trans);
if (cheMainSet.Empty == true)
{
if (rowCount > 1)
{
// Find jobno for additional test results
for (int i = 1; i < cheQuery.ProfJobSet.RowCount; i++)
{
cheQuery.ProfJobSet.Fetch(i);
if (cheQuery.ProfJobSet.Image == null)
{
extendJobNo = cheQuery.ProfJobSet.JobNo;
break;
}
}
cheQuery.ProfJobSet.Fetch(0);
}
cheQuery.Insert(extendJobNo, trans);
}
}
}
partSet.ProductNo = productSet.RecNo;
partSet.JobNo = jobNo;
partSet.MaterialNo = col.MaterialNo;
partSet.Name = col.Name;
partSet.MaterialName = col.MaterialName;
partSet.Insert(trans);
return((string.IsNullOrWhiteSpace(jobNo) == false) ? true : false);
}
