Esempio n. 1
0
        public override List <MyParagraph> getTitleParagraphs(DataTable dt)
        {
            var paragraphLst = new List <MyParagraph>();

            foreach (DataRow row in dt.Rows)
            {
                if (row.RowState == DataRowState.Deleted)
                {
                    continue;
                }

                var par = new MyParagraph
                {
                    titleId    = Convert.ToUInt64(row["titleId"]),
                    order      = Convert.ToInt32(row["ord"]),
                    alignment  = Convert.ToInt32(row["alignment"]),
                    leftIndent = Convert.ToInt32(row["leftIndent"]),
                    fontSize   = Convert.ToInt32(row["fontSize"]),
                    fontBold   = Convert.ToInt32(row["fontBold"]),
                    fontItalic = Convert.ToInt32(row["fontItalic"]),
                    content    = Convert.ToString(row["content"])
                };
                paragraphLst.Add(par);
            }
            return(paragraphLst);
        }
Esempio n. 2
0
        public override List <MyParagraph> getTitleParagraphs(UInt64 titleId)
        {
            var paragraphLst = new List <MyParagraph>();
            //get title
            var qry = "select * from paragraphs where titleId = @id ";
            var cmd = new OleDbCommand(qry, m_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["ord"]);
                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);
        }