Пример #1
0
        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);
            }
        }
Пример #2
0
        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();
            }
        }
Пример #3
0
        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);
            }
        }