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