private object QryTabContent(List <string> lst)
{
var tc = new TabContent();
var bgtb = appConfig.s_config.GetTable(TableIdx.Lecture);
var bgsb = new SearchBuilder(bgtb, m_cp);
bgsb.Clear();
bgsb.Add(LectureTblInfo.ColIdx.lect.ToField(), lst);
bgsb.Search();
tc.recs = new List <LectRec>();
for (int i = 0; i < bgsb.dc.m_dataTable.Rows.Count; i++)
{
var rec = new LectRec();
var row = bgsb.dc.m_dataTable.Rows[i];
rec.lect = row[LectureTblInfo.ColIdx.lect.ToField()].ToString();
rec.title = row[LectureTblInfo.ColIdx.title.ToField()].ToString();
var auth = (LectureTblInfo.Author) int.Parse(row[LectureTblInfo.ColIdx.auth.ToField()].ToString());
rec.auth = auth.ToDesc();
var target = (LectureTblInfo.Target) int.Parse(row[LectureTblInfo.ColIdx.target.ToField()].ToString());
rec.target = target.ToDesc();
rec.topic = row[LectureTblInfo.ColIdx.topic.ToField()].ToString();
var date = (DateTime)row[LectureTblInfo.ColIdx.crt.ToField()];
rec.crt = date.ToString(lConfigMng.GetDisplayDateFormat());
rec.content = row[LectureTblInfo.ColIdx.content.ToField()].ToString();
rec.link = row[LectureTblInfo.ColIdx.link.ToField()].ToString();
tc.recs.Add(rec);
}
tc.cols = new List <string> {
LectureTblInfo.ColIdx.title.ToAlias(),
LectureTblInfo.ColIdx.auth.ToAlias(),
LectureTblInfo.ColIdx.target.ToAlias(),
LectureTblInfo.ColIdx.topic.ToAlias(),
LectureTblInfo.ColIdx.crt.ToAlias(),
LectureTblInfo.ColIdx.content.ToAlias(),
LectureTblInfo.ColIdx.link.ToAlias(),
};
return(tc);
}
public List <LectRec> QryLectures()
{
var dc = m_cp.CreateDataContent(TableIdx.Lecture);
dc.Search(new List <string>(), new List <SearchParam>());
var lst = new List <LectRec>();
foreach (DataRow row in dc.m_dataTable.Rows)
{
var rec = new LectRec
{
lect = row[LectureTblInfo.ColIdx.lect.ToField()].ToString(),
title = row[LectureTblInfo.ColIdx.title.ToField()].ToString(),
auth = ((LectureTblInfo.Author) int.Parse(row[LectureTblInfo.ColIdx.auth.ToField()].ToString())).ToDesc(),
target = ((LectureTblInfo.Target) int.Parse(row[LectureTblInfo.ColIdx.target.ToField()].ToString())).ToDesc(),
topic = row[LectureTblInfo.ColIdx.topic.ToField()].ToString(),
crt = row[LectureTblInfo.ColIdx.crt.ToField()].ToString(),
content = row[LectureTblInfo.ColIdx.content.ToField()].ToString(),
link = row[LectureTblInfo.ColIdx.link.ToField()].ToString(),
};
lst.Add(rec);
}
return(lst);
}
