private void InsertPage2(SqlTransaction trans) { ProfJobSchemeSet.JobNo = MainSet.RecNo; ProfJobSchemeSet.Select(trans); ProfJobSchemeSet.Fetch(); P2Set.MainNo = MainSet.RecNo; for (int i = 0; i < ProfJobSchemeSet.RowCount; i++) { ProfJobSchemeSet.Fetch(i); P2Set.Name = ProfJobSchemeSet.Name; P2Set.LoValue = ProfJobSchemeSet.LoValue; P2Set.HiValue = ProfJobSchemeSet.HiValue; P2Set.ReportValue = ProfJobSchemeSet.ReportValue; P2Set.FormatValue = ProfJobSchemeSet.FormatValue; P2Set.Insert(trans); } }
private void InsertPage2Extend(string jobNo, SqlTransaction trans) { if (string.IsNullOrWhiteSpace(jobNo) == true) { return; } ProfJobSchemeSet.JobNo = jobNo; ProfJobSchemeSet.Select(trans); if (ProfJobSchemeSet.Empty == false) { ProfJobSchemeSet.Fetch(); P2ExtendSet.RecNo = MainSet.RecNo; P2ExtendSet.Name = ProfJobSchemeSet.Name; P2ExtendSet.LoValue = ProfJobSchemeSet.LoValue; P2ExtendSet.HiValue = ProfJobSchemeSet.HiValue; P2ExtendSet.ReportValue = ProfJobSchemeSet.ReportValue; P2ExtendSet.FormatValue = ProfJobSchemeSet.FormatValue; P2ExtendSet.Insert(trans); } }