private object QryTabContent(string grpId) { var tc = new TabContent(); var bgtb = appConfig.s_config.GetTable(TableIdx.Budgrp); var bgsb = new SearchBuilder(bgtb, m_cp); bgsb.Clear(); bgsb.Add(BudgrpTblInfo.ColIdx.grp.ToField(), grpId); bgsb.Search(); var bgrec = new BudgrpRec(); for (int i = 0; i < bgsb.dc.m_dataTable.Rows.Count; i++) { var row = bgsb.dc.m_dataTable.Rows[i]; bgrec.name = row[BudgrpTblInfo.ColIdx.name.ToField()].ToString(); bgrec.about = row[BudgrpTblInfo.ColIdx.about.ToField()].ToString(); break; } tc.budgrpRec = bgrec; var trntb = appConfig.s_config.GetTable(TableIdx.Training); var trnsb = new SearchBuilder(trntb, m_cp); trnsb.Clear(); trnsb.Add(TrainingTblInfo.ColIdx.bgrp.ToField(), grpId); trnsb.Search(); tc.trngCols = new List <string> { TrainingTblInfo.ColIdx.date.ToAlias(), TrainingTblInfo.ColIdx.topic.ToAlias(), TrainingTblInfo.ColIdx.trnr.ToAlias(), TrainingTblInfo.ColIdx.cmnt.ToAlias(), TrainingTblInfo.ColIdx.star.ToAlias(), }; tc.recs = new List <TrngRec>(); foreach (DataRow row in trnsb.dc.m_dataTable.Rows) { var trnrec = new TrngRec(); DateTime dateTime = (DateTime)row[TrainingTblInfo.ColIdx.date.ToField()]; trnrec.date = dateTime.ToString(lConfigMng.GetDisplayDateFormat()); trnrec.topic = row[TrainingTblInfo.ColIdx.topic.ToField()].ToString(); TrainingTblInfo.Trainer trainer = (TrainingTblInfo.Trainer) int.Parse(row[TrainingTblInfo.ColIdx.trnr.ToField()].ToString()); trnrec.trainer = trainer.ToDesc(); trnrec.cmnt = row[TrainingTblInfo.ColIdx.cmnt.ToField()].ToString(); TrainingTblInfo.Star star = (TrainingTblInfo.Star) int.Parse(row[TrainingTblInfo.ColIdx.star.ToField()].ToString()); trnrec.star = star.ToDesc(); tc.recs.Add(trnrec); } return(tc); }
public List <BudgrpRec> QryBudgrps() { var dc = MngForm.s_contentProvider.CreateDataContent(TableIdx.Budgrp); dc.Search(new List <string>(), new List <SearchParam>()); var lst = new List <BudgrpRec>(); foreach (DataRow row in dc.m_dataTable.Rows) { var rec = new BudgrpRec { numb = row[(int)BudgrpTblInfo.ColIdx.grp].ToString(), name = row[(int)BudgrpTblInfo.ColIdx.name].ToString() }; lst.Add(rec); } return(lst); }