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); }