Exemple #1
0
        /// <summary>
        /// _s the fill static from table reader.
        /// </summary>
        /// <param name="oDT">The o DT.</param>
        /// <returns></returns>
        private Static _FillStaticFromTableReader(IDataReader oDT)
        {
            Static stc = new Static();

            stc.Tag = ( oDT.IsDBNull(oDT.GetOrdinal("tag")) ? "" : oDT["tag"].ToString() );
            stc.Type = ( oDT.IsDBNull(oDT.GetOrdinal("type")) ? "" : oDT["type"].ToString() );
            stc.Content = ( oDT.IsDBNull(oDT.GetOrdinal("content")) ? "" : oDT["content"].ToString() );
            stc.Value = ( oDT.IsDBNull(oDT.GetOrdinal("value")) ? "" : oDT["value"].ToString() );
            stc.Length = oDT.IsDBNull(oDT.GetOrdinal("length")) ? 0 : oDT.GetInt32(oDT.GetOrdinal("length"));

            return stc;
        }
Exemple #2
0
        /// <summary>
        /// Get a single static item
        /// </summary>
        /// <param name="Tag"></param>
        /// <param name="Value"></param>
        /// <returns></returns>
        public Static GetStaticItem(string Tag, string Value)
        {
            DataSet dsData = this._GetStatic(Tag, Value);
            Static stc = new Static();

            if(dsData.Tables[0].Rows.Count > 0) {
                DataTableReader oDT = dsData.CreateDataReader();
                oDT.Read();

                stc = this._FillStaticFromTableReader(oDT);
            }

            return stc;
        }