static List <MyParagraph> getTitleParagraphs(ADODB.Connection cnn, UInt64 titleId)
{
var paragraphLst = new List <MyParagraph>();
//get title
var qry = "select * from paragraphs where titleId = ? ";
var rst = new ADODB.Recordset();
rst.Open(qry.Replace("?", titleId.ToString()),
cnn, ADODB.CursorTypeEnum.adOpenKeyset,
ADODB.LockTypeEnum.adLockOptimistic,
(int)ADODB.CommandTypeEnum.adCmdText);
rst.MoveFirst();
while (!rst.EOF)
{
var par = new MyParagraph();
par.order = Convert.ToInt32(rst.Fields["order"].Value);
par.alignment = Convert.ToInt32(rst.Fields["alignment"].Value);
par.leftIndent = Convert.ToInt32(rst.Fields["leftIndent"].Value);
par.fontSize = Convert.ToInt32(rst.Fields["fontSize"].Value);
par.fontBold = Convert.ToInt32(rst.Fields["fontBold"].Value);
par.fontItalic = Convert.ToInt32(rst.Fields["fontItalic"].Value);
par.content = Convert.ToString(rst.Fields["content"].Value);
paragraphLst.Add(par);
rst.MoveNext();
}
rst.Close();
return(paragraphLst);
}
static List <MyParagraph> getTitleParagraphs(OleDbConnection cnn, UInt64 titleId)
{
var paragraphLst = new List <MyParagraph>();
//get title
var qry = "select * from paragraphs where titleId = @id ";
var cmd = new OleDbCommand(qry, cnn);
cmd.Parameters.AddWithValue("@id", titleId);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var par = new MyParagraph();
par.titleId = Convert.ToUInt64(reader["titleId"]);
par.order = Convert.ToInt32(reader["order"]);
par.alignment = Convert.ToInt32(reader["alignment"]);
par.leftIndent = Convert.ToInt32(reader["leftIndent"]);
par.fontSize = Convert.ToInt32(reader["fontSize"]);
par.fontBold = Convert.ToInt32(reader["fontBold"]);
par.fontItalic = Convert.ToInt32(reader["fontItalic"]);
par.content = Convert.ToString(reader["content"]);
paragraphLst.Add(par);
}
paragraphLst.Sort((x, y) => { return(x.order - y.order); });
int order = 0;
foreach (var par in paragraphLst)
{
Debug.Assert(par.order > order);
order = par.order;
}
reader.Close();
return(paragraphLst);
}