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