public void Delete()
{
if (local == true)
{
throw new Exception("Can't call PhysicalQuery.Delete() method in Local transaction mode!");
}
string mainNo = MainSet.RecNo;
SqlTransaction trans = AppRes.DB.BeginTrans();
try
{
P2Set.MainNo = mainNo;
P2Set.Delete(trans);
P3Set.MainNo = mainNo;
P3Set.Delete(trans);
P40Set.MainNo = mainNo;
P40Set.Delete(trans);
P41Set.MainNo = mainNo;
P41Set.Delete(trans);
P5Set.MainNo = mainNo;
P5Set.Delete(trans);
ImageSet.RecNo = mainNo;
ImageSet.Delete(trans);
MainSet.Delete(trans);
productSet.JobNo = mainNo;
productSet.UpdateJobNoReset(trans);
AppRes.DB.CommitTrans();
}
catch
{
AppRes.DB.RollbackTrans();
}
}
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 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);
}
}
