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