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