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