public void Insert(string extendJobNo, SqlTransaction trans = null) { EReportArea area = ProfJobSet.AreaNo; if (local == false) { trans = AppRes.DB.BeginTrans(); } try { InsertMain(area, trans); InsertJoin(trans); InsertImage(trans); InsertPage2(trans); InsertPage2Extend(extendJobNo, trans); if (local == false) { SetReportValidation(trans); AppRes.DB.CommitTrans(); } } catch (Exception e) { if (local == false) { AppRes.DB.RollbackTrans(); } else { throw e; } } }
private void SavePage4(EReportArea area, SqlTransaction trans) { List <PhysicalPage3Row> p40Rows = (area == EReportArea.US) ? null : CtrlEu.P40Rows; List <PhysicalPage4Row> p41Rows = (area == EReportArea.US) ? CtrlUs.P4Rows : CtrlEu.P41Rows; if (p40Rows != null) { P40Set.MainNo = MainSet.RecNo; P40Set.Delete(trans); foreach (PhysicalPage3Row row in p40Rows) { P40Set.No = row.No; P40Set.Line = row.Line; P40Set.Clause = row.Clause; P40Set.Description = row.Description; P40Set.Result = row.Result; P40Set.Insert(trans); } } P41Set.MainNo = MainSet.RecNo; P41Set.Delete(trans); foreach (PhysicalPage4Row row in p41Rows) { P41Set.No = row.No; P41Set.Line = row.Line; P41Set.Sample = row.Sample; P41Set.BurningRate = row.BurningRate; P41Set.Insert(trans); } }
public void Update() { if (local == true) { throw new Exception("Can't call PhysicalQuery.Update() method in Local transaction mode!"); } EReportArea area = ProfJobSet.AreaNo; SqlTransaction trans = AppRes.DB.BeginTrans(); try { SaveMain(area, trans); SavePage2(area, trans); SavePage3(area, trans); SavePage4(area, trans); SavePage5(area, trans); AppRes.DB.CommitTrans(); } catch { AppRes.DB.RollbackTrans(); } }
private string OpenBomFile(EReportArea area) { string fName = ""; OpenFileDialog dialog = new OpenFileDialog(); switch (area) { case EReportArea.US: dialog.InitialDirectory = Path.Combine(AppRes.Settings.BomPath, "AURORA ASTM"); break; case EReportArea.EU: dialog.InitialDirectory = Path.Combine(AppRes.Settings.BomPath, "AURORA EN"); break; } dialog.DefaultExt = "xls"; dialog.Filter = "Excel files (*.xls)|*.xls"; dialog.Multiselect = false; dialog.ShowReadOnly = true; if (dialog.ShowDialog() == DialogResult.OK) { fName = dialog.FileName; } return(fName); }
private void Insert() { EReportArea area = profJobSet.AreaNo; if (profJobSet.Empty == true) { return; } if (area == EReportArea.None) { return; } if (string.IsNullOrWhiteSpace(profJobSet.ItemNo) == true) { return; } phyCheckSet.From = ""; phyCheckSet.To = ""; phyCheckSet.AreaNo = area; phyCheckSet.ReportApproval = EReportApproval.None; phyCheckSet.ProductNo = profJobSet.ItemNo; phyCheckSet.Select(); if (phyCheckSet.Empty == false) { MessageBox.Show("Can't import physical report because this report already exist in DB!", "SGS", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } phyQuery.Insert(); findButton.PerformClick(); }
private void InsertPage2(EReportArea area, SqlTransaction trans) { if (area == EReportArea.US) { P2Set.MainNo = MainSet.RecNo; P2Set.No = 0; P2Set.Line = false; P2Set.Requested = "US Public Law 110-314(Comsumer Plroduct Safety Improvement Act of 2008, CPSIA):"; P2Set.Conclusion = "-"; P2Set.Insert(trans); P2Set.No = 1; P2Set.Line = false; P2Set.Requested = "- ASTM F963-17: Standard Consumer Safety Specification on Toy Safety\r\n (Excluding clause 4.3.5 Heavy Element)"; P2Set.Conclusion = "PASS"; P2Set.Insert(trans); P2Set.No = 2; P2Set.Line = false; P2Set.Requested = "Flammability of toys(16 C.F.R. 1500.44)"; P2Set.Conclusion = "PASS"; P2Set.Insert(trans); P2Set.No = 3; P2Set.Line = false; P2Set.Requested = "Small part(16 C.F.R. 1501)"; P2Set.Conclusion = "PASS"; P2Set.Insert(trans); P2Set.No = 4; P2Set.Line = false; P2Set.Requested = "Sharp points and edges(16 C.F.R. 1500.48 and 49)"; P2Set.Conclusion = "PASS"; P2Set.Insert(trans); } else { P2Set.MainNo = MainSet.RecNo; P2Set.No = 0; P2Set.Line = false; P2Set.Requested = "EN 71 Part 1:2014+A1:2018 - Mechanical and Physical Properties"; P2Set.Conclusion = "PASS"; P2Set.Insert(trans); P2Set.No = 1; P2Set.Line = false; P2Set.Requested = "EN 71 Part 2:2011+A1:2014 - Flammability of Toys"; P2Set.Conclusion = "PASS"; P2Set.Insert(trans); P2Set.No = 2; P2Set.Line = false; P2Set.Requested = "Labeling requirement (Washing/Cleaning Label, CE mark, importer / manufacturer mark (name, address), product identification) according to the Directive 2009/48/EC-Safety of toys"; P2Set.Conclusion = "See note 1*"; P2Set.Insert(trans); } }
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 addBomButton_Click(object sender, EventArgs e) { EReportArea area = ((sender as SimpleButton).Tag.ToString() == "0") ? EReportArea.US : EReportArea.EU; string fName = OpenBomFile(area); if (string.IsNullOrWhiteSpace(fName) == false) { ctrlReport.LoadBom(area, fName); } }
private void SaveMain(EReportArea area, SqlTransaction trans) { if (area == EReportArea.US) { CtrlUs.SetControlToDataSet(); } else { CtrlEu.SetControlToDataSet(); } MainSet.Update(trans); }
private void SavePage2(EReportArea area, SqlTransaction trans) { List <PhysicalPage2Row> rows = (area == EReportArea.US) ? CtrlUs.P2Rows : CtrlEu.P2Rows; P2Set.MainNo = MainSet.RecNo; P2Set.Delete(trans); foreach (PhysicalPage2Row row in rows) { P2Set.No = row.No; P2Set.Line = row.Line; P2Set.Requested = row.Requested; P2Set.Conclusion = row.Conclusion; P2Set.Insert(trans); } }
private void SavePage3(EReportArea area, SqlTransaction trans) { List <PhysicalPage3Row> rows = (area == EReportArea.US) ? CtrlUs.P3Rows : CtrlEu.P3Rows; P3Set.MainNo = MainSet.RecNo; P3Set.Delete(trans); foreach (PhysicalPage3Row row in rows) { P3Set.No = row.No; P3Set.Line = row.Line; P3Set.Clause = row.Clause; P3Set.Description = row.Description; P3Set.Result = row.Result; P3Set.Insert(trans); } }
private void SetReportView(EReportArea area) { switch (area) { case EReportArea.None: ClearReport(); break; case EReportArea.US: SetReportUs(); break; case EReportArea.EU: SetReportEu(); break; } }
private void SavePage5(EReportArea area, SqlTransaction trans) { List <PhysicalPage5Row> rows = (area == EReportArea.US) ? CtrlUs.P5Rows : CtrlEu.P5Rows; P5Set.MainNo = MainSet.RecNo; P5Set.Delete(trans); foreach (PhysicalPage5Row row in rows) { P5Set.No = row.No; P5Set.Line = row.Line; P5Set.TestItem = row.TestItem; P5Set.Result = row.Result; P5Set.Requirement = row.Requirement; P5Set.Insert(trans); } }
public void LoadBom(EReportArea area, string fName) { bomSet.AreaNo = area; bomSet.FName = Path.GetFileName(fName); bomSet.Select(); // if BOM already exist in DB? if (bomSet.Empty == false) { MessageBox.Show("Can't add BOM because that already exist in DB!", "SGS", MessageBoxButtons.OK, MessageBoxIcon.Error); bomFindButton.PerformClick(); return; } if (bomExcelSheet.LoadDocument(fName) == true) { bomRec.Clear(); bomRec.RegTime = DateTime.Now; bomRec.AreaNo = area; bomRec.FName = Path.GetFileName(fName); bomRec.FPath = Path.GetDirectoryName(fName); if (ExtractProduct(bomExcelSheet.Document.Worksheets[0]) == true) { try { InsertBom(); } finally { bomFindButton.PerformClick(); } } else { MessageBox.Show("Can't load BOM file because of its invalid format!", "SGS", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
private void SavePage2(EReportArea area, SqlTransaction trans) { if (area == EReportArea.US) { List <ChemicalPage2ExtendRow> extendRows = CtrlUs.P2ExtendRows; foreach (ChemicalPage2ExtendRow row in extendRows) { P2ExtendSet.RecNo = row.RecNo; P2ExtendSet.FormatValue = row.FormatValue; P2ExtendSet.Update(trans); } } List <ChemicalPage2Row> rows = (area == EReportArea.US) ? CtrlUs.P2Rows : CtrlEu.P2Rows; foreach (ChemicalPage2Row row in rows) { P2Set.RecNo = row.RecNo; P2Set.FormatValue = row.FormatValue; P2Set.Update(trans); } }
private void bomImportButton_Click(object sender, EventArgs e) { string fName = OpenBomFile(); if (string.IsNullOrWhiteSpace(fName) == false) { EReportArea area = EReportArea.None; string dirName = Path.GetDirectoryName(fName); if (dirName.EndsWith("AURORA ASTM") == true) { area = EReportArea.US; } else if (dirName.EndsWith("AURORA EN") == true) { area = EReportArea.EU; } if (area != EReportArea.None) { (DefMenu.Controls(0) as CtrlEditBom).Import(area, fName); } } }
private void InsertPage4(EReportArea area, SqlTransaction trans) { if (area == EReportArea.US) { P41Set.MainNo = MainSet.RecNo; P41Set.No = 0; P41Set.Line = false; P41Set.Sample = "Panda toy"; P41Set.BurningRate = "0.1*"; P41Set.Insert(trans); } else { P40Set.MainNo = MainSet.RecNo; P40Set.No = 0; P40Set.Line = true; P40Set.Clause = "4.1"; P40Set.Description = "General requirements"; P40Set.Result = "Pass (See note *)"; P40Set.Insert(trans); P40Set.No = 1; P40Set.Line = true; P40Set.Clause = "4.5"; P40Set.Description = "Soft - filled toys(animals and doll, etc.) with a piled or textile surface"; P40Set.Result = "NA"; P40Set.Insert(trans); P41Set.MainNo = MainSet.RecNo; P41Set.No = 0; P41Set.Line = false; P41Set.Sample = "Santa mini toy"; P41Set.BurningRate = "NSFO"; P41Set.Insert(trans); } }
public void Insert(SqlTransaction trans = null) { EReportArea area = ProfJobSet.AreaNo; if (local == false) { trans = AppRes.DB.BeginTrans(); } try { InsertMain(area, trans); InsertImage(trans); InsertPage2(area, trans); InsertPage3(area, trans); InsertPage4(area, trans); InsertPage5(area, trans); UpdateProductSet(trans); if (local == false) { AppRes.DB.CommitTrans(); } } catch (Exception e) { if (local == false) { AppRes.DB.RollbackTrans(); } else { throw e; } } }
private void InsertMain(EReportArea area, SqlTransaction trans) { MainSet.RecNo = ProfJobSet.JobNo; MainSet.RegTime = ProfJobSet.RegTime; MainSet.ReceivedTime = ProfJobSet.ReceivedTime; MainSet.RequiredTime = ProfJobSet.RequiredTime; MainSet.ReportedTime = ProfJobSet.ReportedTime; MainSet.Approval = false; MainSet.AreaNo = ProfJobSet.AreaNo; MainSet.StaffNo = ProfJobSet.StaffNo; MainSet.ProductNo = ProfJobSet.ItemNo; MainSet.P1ClientNo = ProfJobSet.ClientNo; MainSet.P1ClientName = ProfJobSet.ClientName; MainSet.P1ClientAddress = ProfJobSet.ClientAddress; MainSet.P1FileNo = ProfJobSet.FileNo; MainSet.P1SampleDescription = ProfJobSet.SampleRemark; MainSet.P1DetailOfSample = ProfJobSet.DetailOfSample; MainSet.P1ItemNo = ProfJobSet.ItemNo; MainSet.P1OrderNo = "-"; MainSet.P1Packaging = "Yes, provided"; MainSet.P1Instruction = "Not provided"; MainSet.P1Buyer = "-"; MainSet.P1Manufacturer = ProfJobSet.Manufacturer; MainSet.P1CountryOfOrigin = ProfJobSet.CountryOfOrigin; MainSet.P1CountryOfDestination = "-"; MainSet.P1LabeledAge = "None"; MainSet.P1TestAge = "None"; MainSet.P1AssessedAge = "All ages"; MainSet.P1ReceivedDate = ProfJobSet.ReceivedTime.ToString("yyyy. MM. dd"); MainSet.P1TestPeriod = $"{ProfJobSet.ReceivedTime.ToString("yyyy. MM. dd")} to {ProfJobSet.RequiredTime.ToString("yyyy. MM. dd")}"; MainSet.P1TestMethod = "For further details, please refer to following page(s)"; MainSet.P1TestResults = "For further details, please refer to following page(s)"; MainSet.P1Comments = ProfJobSet.ReportComments; MainSet.Approval = false; MainSet.P2Name = ""; if (string.IsNullOrWhiteSpace(MainSet.StaffNo) == true) { MainSet.Approval = false; } else { MainSet.Approval = true; } if (area == EReportArea.US) { MainSet.P3Description1 = "As specified in ASTM F963-17 standard consumer safety specification on toys safety."; MainSet.P3Description2 = "N/A = Not Applicable **Visual Examination\r\n" + "NT = Not tested as per client's request.\r\n\r\n" + "N.B. : - Only applicable clauses were shown"; MainSet.P4Description1 = "Flammability Test(Clause 4.2)"; MainSet.P4Description2 = "*Burning rate has been rounded to the nearest one tenth of an inch per second.\r\n\r\n" + "Requirement: A toy / component is considered a \"flammable solid\" if it ignites and burns with a self-sustaining\r\n" + " flame at a rate greater than 0.1 in./s along its major axis."; MainSet.P4Description3 = ""; MainSet.P5Description1 = "Suffing Materials(Clause 4.3.7)\r\n\r\n" + "Method: With reference to ASTM F963-17 Clause 8.29. Visual inspection is performed using a stereo widerfield\r\n" + "microscope, or equivalent, at 10 x magnification and adequate illumination."; MainSet.P5Description2 = "Polyester fiber"; } else { MainSet.P3Description1 = "European Standard on Safety of Toys\r\n" + "- Mechanical & Physical Properties\r\n" + "As specified in European standard on safety of toys EN 71 Part 1:2014+A1:2018"; MainSet.P3Description2 = ""; MainSet.P4Description1 = "- Flammability of Toys\r\n" + "As specified in European standard on safety of toys EN71 PART 2: 2011+A1:2014"; MainSet.P4Description2 = "* Surface Flash of Pile Fabrics (Clause 4.1)"; MainSet.P4Description3 = "NSFO = No surface flash occurred\r\n" + "DNI = Did not ignite\r\n" + "IBE = Ignite But Self-Extinguished\r\n" + "N / A = Not applicable since the requirements of this sub - clause do not apply to toys with a greatest dimension of 150mm or less\r\n" + "SE = Self - Extinguishing\r\n\r\n\r\n" + "N.B. : Only applicable clauses were shown."; MainSet.P5Description1 = "Labeling requirement (Washing/Cleaning Label, CE mark, importer / manufacturer mark (name, address), product identification) according to the Directive 2009/48/EC - Safety of toys"; MainSet.P5Description2 = "1. According to Directive 2009/48/EC, a toy intended for use by children under 36 months must be designed and\r\n" + " manufactured in such a way that it can be cleaned. A textile toy must, to this end, be washable, except if it\r\n" + " contains a mechanism that may be damaged if soak washed. The manufacturer should, if applicable, provide\r\n" + " instructions on how the toy has to be cleaned.\r\n\r\n" + "2. CE marking should be visible from outside the packaging and its height must be at least 5 mm.\r\n\r\n" + "3. Manufacturer's and Importer's name, registered trade name or registered trade mark and the address at which\r\n" + " the manufacturer can be contacted must be indicated on the toy or, where that is not possible, on its packaging\r\n" + " or in a document accompanying the toy.\r\n\r\n" + "4. Manufacturers must ensure that their toys bear a type, batch, serial or model number or other element allowing\r\n" + " their identification, or where the size or nature of the toy does not allow it, that the required information is\r\n" + " provided on the packaging or in a document accompanying the toy."; } MainSet.Insert(trans); }
private void InsertPage3(EReportArea area, SqlTransaction trans) { if (area == EReportArea.US) { P3Set.MainNo = MainSet.RecNo; P3Set.No = 0; P3Set.Line = false; P3Set.Clause = "4"; P3Set.Description = "Safety Requirements"; P3Set.Result = "-"; P3Set.Insert(trans); P3Set.No = 1; P3Set.Line = false; P3Set.Clause = " 4.1"; P3Set.Description = "Material Quality**"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 2; P3Set.Line = false; P3Set.Clause = " 4.2"; P3Set.Description = "Flammability Test(16 C.F.R. 1500.44)"; P3Set.Result = "Pass(See Note 1)"; P3Set.Insert(trans); P3Set.No = 3; P3Set.Line = false; P3Set.Clause = " 4.3"; P3Set.Description = "Toxicology"; P3Set.Result = "-"; P3Set.Insert(trans); P3Set.No = 4; P3Set.Line = false; P3Set.Clause = " 4.3.5"; P3Set.Description = "Heavy Elements"; P3Set.Result = ""; P3Set.Insert(trans); P3Set.No = 5; P3Set.Line = false; P3Set.Clause = ""; P3Set.Description = "4.3.5.1 Hravy Elements in Paint/Similar Coating Materials"; P3Set.Result = ""; P3Set.Insert(trans); P3Set.No = 6; P3Set.Line = false; P3Set.Clause = ""; P3Set.Description = "4.3.5.2 Heavy Metal in Substrate Materials"; P3Set.Result = ""; P3Set.Insert(trans); P3Set.No = 7; P3Set.Line = false; P3Set.Clause = " 4.3.7"; P3Set.Description = "Styffing Materials"; P3Set.Result = "Pass(See Note 2)"; P3Set.Insert(trans); P3Set.No = 8; P3Set.Line = false; P3Set.Clause = " 4.6"; P3Set.Description = "Small Objects"; P3Set.Result = "-"; P3Set.Insert(trans); P3Set.No = 9; P3Set.Line = false; P3Set.Clause = " 4.6.1"; P3Set.Description = "Small Objects"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 10; P3Set.Line = false; P3Set.Clause = " 4.7"; P3Set.Description = "Accessible Edges(16 C.F.R. 1500.49)"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 11; P3Set.Line = false; P3Set.Clause = " 4.9"; P3Set.Description = "Accessible Points(16 C.F.R. 1500.48)"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 12; P3Set.Line = false; P3Set.Clause = " 4.14"; P3Set.Description = "Cords, Straps and Elastic"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 13; P3Set.Line = true; P3Set.Clause = " 4.27"; P3Set.Description = "Stuffed and Beanbag-Type Toys"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 14; P3Set.Line = false; P3Set.Clause = "5"; P3Set.Description = "Safety Labeling Requirements"; P3Set.Result = "-"; P3Set.Insert(trans); P3Set.No = 15; P3Set.Line = true; P3Set.Clause = " 4.2"; P3Set.Description = "Age Grading Labeling"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 16; P3Set.Line = false; P3Set.Clause = "7"; P3Set.Description = "Producer's Markings"; P3Set.Result = "-"; P3Set.Insert(trans); P3Set.No = 17; P3Set.Line = true; P3Set.Clause = " 7.1"; P3Set.Description = "Producer's Markings"; P3Set.Result = "Present"; P3Set.Insert(trans); P3Set.No = 18; P3Set.Line = false; P3Set.Clause = "8"; P3Set.Description = "Test Methods"; P3Set.Result = "-"; P3Set.Insert(trans); P3Set.No = 19; P3Set.Line = false; P3Set.Clause = " 8.5"; P3Set.Description = "Normal Use Testing"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 20; P3Set.Line = false; P3Set.Clause = " 8.7"; P3Set.Description = "Impact Test"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 21; P3Set.Line = false; P3Set.Clause = " 8.8"; P3Set.Description = "Torque Test"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 22; P3Set.Line = false; P3Set.Clause = " 8.9"; P3Set.Description = "Tension Test"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 23; P3Set.Line = false; P3Set.Clause = " 8.23"; P3Set.Description = "Test for Loops and Cords"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 24; P3Set.Line = true; P3Set.Clause = " 8.29"; P3Set.Description = "Stuffing Materials Evaluation"; P3Set.Result = "Pass"; P3Set.Insert(trans); } else { P3Set.MainNo = MainSet.RecNo; P3Set.No = 0; P3Set.Line = false; P3Set.Clause = "4"; P3Set.Description = "General requirements"; P3Set.Result = "-"; P3Set.Insert(trans); P3Set.No = 1; P3Set.Line = false; P3Set.Clause = " 4.1"; P3Set.Description = "Material cleanliness"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 2; P3Set.Line = false; P3Set.Clause = " 4.7"; P3Set.Description = "Edges"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 3; P3Set.Line = true; P3Set.Clause = " 4.8"; P3Set.Description = "Points and metallic wires"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 4; P3Set.Line = false; P3Set.Clause = "5"; P3Set.Description = "Toys intended for children under 36 months"; P3Set.Result = "-"; P3Set.Insert(trans); P3Set.No = 5; P3Set.Line = false; P3Set.Clause = " 5.1"; P3Set.Description = "General requirements"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 6; P3Set.Line = false; P3Set.Clause = ""; P3Set.Description = "5.1a Small part requirements on toys & removable components"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 7; P3Set.Line = false; P3Set.Clause = ""; P3Set.Description = " (Test method 8.2)"; P3Set.Result = "-"; P3Set.Insert(trans); P3Set.No = 8; P3Set.Line = false; P3Set.Clause = ""; P3Set.Description = "5.1b Torque test(Test method 8.3)"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 9; P3Set.Line = false; P3Set.Clause = ""; P3Set.Description = " Tension test(Test method 8.4)"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 10; P3Set.Line = false; P3Set.Clause = ""; P3Set.Description = " Drop test(Test method 8.5)"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 11; P3Set.Line = false; P3Set.Clause = ""; P3Set.Description = " Impact test(Test method 8.7)"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 12; P3Set.Line = false; P3Set.Clause = ""; P3Set.Description = " Sharp edge(Test method 8.11)"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 13; P3Set.Line = false; P3Set.Clause = ""; P3Set.Description = " Sharp point(Test method 8.12)"; P3Set.Result = "Pass"; P3Set.Insert(trans); P3Set.No = 14; P3Set.Line = false; P3Set.Clause = " 5.2"; P3Set.Description = "Soft-filled toys and soft-filled parts of a toy"; P3Set.Result = "Pass"; P3Set.Insert(trans); } }
private void InsertMain(EReportArea area, SqlTransaction trans) { MainSet.RecNo = ProfJobSet.JobNo; MainSet.RegTime = ProfJobSet.RegTime; MainSet.ReceivedTime = ProfJobSet.ReceivedTime; MainSet.RequiredTime = ProfJobSet.RequiredTime; MainSet.ReportedTime = ProfJobSet.ReportedTime; MainSet.Approval = false; MainSet.AreaNo = ProfJobSet.AreaNo; MainSet.StaffNo = ProfJobSet.StaffNo; MainSet.MaterialNo = ""; MainSet.P1ClientNo = ProfJobSet.ClientNo; MainSet.P1ClientName = ProfJobSet.ClientName; MainSet.P1ClientAddress = ProfJobSet.ClientAddress; MainSet.P1FileNo = ProfJobSet.FileNo; MainSet.P1SampleDescription = ProfJobSet.SampleRemark; MainSet.P1ItemNo = ProfJobSet.ItemNo; MainSet.P1OrderNo = "-"; MainSet.P1Manufacturer = ProfJobSet.Manufacturer; MainSet.P1CountryOfOrigin = ProfJobSet.CountryOfOrigin; MainSet.P1CountryOfDestination = "-"; MainSet.P1ReceivedDate = $"{ProfJobSet.ReceivedTime:yyyy. MM. dd}"; MainSet.P1TestPeriod = $"{ProfJobSet.ReceivedTime:yyyy. MM. dd} to {ProfJobSet.RequiredTime:yyyy. MM. dd}"; MainSet.P1TestMethod = "For further details, please refer to following page(s)"; MainSet.P1TestResults = "For further details, please refer to following page(s)"; MainSet.P1Comments = ProfJobSet.ReportComments; MainSet.P1Name = ""; if (string.IsNullOrWhiteSpace(MainSet.StaffNo) == true) { MainSet.Approval = false; } else { MainSet.Approval = true; } if (area == EReportArea.US) { MainSet.P1TestRequested = "Selected test(s) as requested by applicant for compliance with Public Law 110-314(Consumer Product Safety Improvement Act of 2008, CPSIA):-\r\n" + "- To determine Heavy Elements in the submitted samples with reference to ASTM F963-16\r\n" + " 4.3.5.2-Heavy Metal in Substrate Materials"; MainSet.P1Conclusion = "\r\n\r\n-\r\nPASS"; MainSet.P2Description1 = "ASTM F963-16, Clause 4.3.5.2 - Heavy Elements in Toys Substrate Materials"; MainSet.P2Description2 = "Method: With reference to ASTM F963-16 Clause 8.3. Analysis was performed by ICP-OES."; MainSet.P2Description3 = "1. Black textile\r\n\r\n" + "Note: - Soluble results shown are of the adjusted analytical result.\r\n" + " - ND = Not Detected(<MDL)"; MainSet.P2Description4 = "Method(non-metallic materials): CPSC-CH-E1002-08.3 - Standard Operation Procedure for Determining Total Lead(Pb) in Non-Metal Children Product. Analysis was performed by ICP-OES."; MainSet.P3Description1 = ""; } else { MainSet.P1TestRequested = "EN71-3:2013+A3:2018-Migration of certain elements\r\n" + "(By first action method testing only)"; MainSet.P1Conclusion = "PASS"; MainSet.P2Description1 = "EN71-3:2013+A3:2018 - Migration of certain elements"; MainSet.P2Description2 = "Method : With reference to EN71-3:2013+A3:2018. Analysis of general elements was performed by ICP-OES."; MainSet.P2Description3 = ProfJobSet.SampleDescription; MainSet.P2Description4 = ""; MainSet.P3Description1 = "Note. 1. mg/kg = milligram per kilogram\r\n" + " 2. ND = Not Detected(< MDL)\r\n" + " 3. 1% = 10000 mg/kg = 10000 ppm\r\n" + " 4. Soluble Chromium(III) = Soluble Total Chromium – Soluble Chromium(VI)\r\n" + " 5. ^ = Confirmation test of soluble organic tin is not required in case of soluble tin, after conversion, does not exceed the soluble organic tin requirement as specified in EN71-3:2019."; } MainSet.Insert(trans); }
private void InsertPage5(EReportArea area, SqlTransaction trans) { if (area == EReportArea.US) { P5Set.MainNo = MainSet.RecNo; P5Set.No = 0; P5Set.Line = true; P5Set.TestItem = " 1. Objectionable matter originating from\r\n" + " Insect, bird and rodent or other animal\r\n" + " infestation"; P5Set.Result = "Absent"; P5Set.Requirement = "Absent"; P5Set.Insert(trans); P5Set.No = 1; P5Set.Line = false; P5Set.TestItem = "Comment"; P5Set.Result = "PASS"; P5Set.Requirement = "-"; P5Set.Insert(trans); } else { P5Set.MainNo = MainSet.RecNo; P5Set.No = 0; P5Set.Line = true; P5Set.TestItem = "Washing/Cleaning instruction"; P5Set.Result = "Present"; P5Set.Requirement = "Affixed label and Hangtag"; P5Set.Insert(trans); P5Set.No = 1; P5Set.Line = true; P5Set.TestItem = "CE mark"; P5Set.Result = "Present"; P5Set.Requirement = "Affixed label and Hangtag"; P5Set.Insert(trans); P5Set.No = 2; P5Set.Line = true; P5Set.TestItem = "Importer's Name & Address"; P5Set.Result = "Present"; P5Set.Requirement = "Affixed label and Hangtag"; P5Set.Insert(trans); P5Set.No = 3; P5Set.Line = true; P5Set.TestItem = "Manufacturer's Name & Address"; P5Set.Result = "Present"; P5Set.Requirement = "Affixed label and Hangtag"; P5Set.Insert(trans); P5Set.No = 4; P5Set.Line = true; P5Set.TestItem = "Product ID"; P5Set.Result = "Present"; P5Set.Requirement = "Affixed label and Hangtag"; P5Set.Insert(trans); } }