private void InsertBom()
{
SqlTransaction trans = AppRes.DB.BeginTrans();
try
{
bomSet.RegTime = bomRec.RegTime;
bomSet.AreaNo = bomRec.AreaNo;
bomSet.FName = bomRec.FName;
bomSet.FPath = bomRec.FPath;
bomSet.Insert(trans);
foreach (ProductColumns productRec in bomRec.Products)
{
productSet.BomNo = bomSet.RecNo;
productSet.Code = productRec.Code;
productSet.Name = productRec.Name;
productSet.Image = productRec.Image;
productSet.Insert(trans);
foreach (PartColumns partRec in productRec.Parts)
{
partSet.ProductNo = productSet.RecNo;
partSet.Name = partRec.Name;
partSet.MaterialNo = partRec.MaterialNo;
partSet.MaterialName = partRec.MaterialName;
partSet.Insert(trans);
}
}
AppRes.DB.CommitTrans();
}
catch (Exception e)
{
AppRes.DbLog[ELogTag.Exception] = e.ToString();
AppRes.DB.RollbackTrans();
}
}
private void InsertProduct(ProductColumns col, SqlTransaction trans)
{
phyQuery.ProfJobSet.Type = EReportType.Physical;
phyQuery.ProfJobSet.JobNo = "";
phyQuery.ProfJobSet.AreaNo = bomSet.AreaNo;
phyQuery.ProfJobSet.ItemNo = col.Code;
phyQuery.ProfJobSet.ExtendASTM = false;
phyQuery.ProfJobSet.Select(trans);
phyQuery.ProfJobSet.Fetch();
string jobNo = phyQuery.ProfJobSet.JobNo;
if (string.IsNullOrWhiteSpace(jobNo) == false)
{
phyMainSet.RecNo = jobNo;
phyMainSet.ReportApproval = EReportApproval.None;
phyMainSet.AreaNo = EReportArea.None;
phyMainSet.ProductNo = "";
phyMainSet.From = "";
phyMainSet.To = "";
phyMainSet.Select(trans);
if (phyMainSet.Empty == true)
{
phyQuery.Insert(trans);
}
}
productSet.BomNo = bomSet.RecNo;
productSet.Valid = false;
productSet.AreaNo = bomSet.AreaNo;
productSet.Code = col.Code;
productSet.JobNo = jobNo;
productSet.Name = col.Name;
productSet.Image = col.Image;
productSet.Insert(trans);
}