/// <summary>得到一个对象实体 /// /// </summary> public Nikita.Base.CacheStore.Model.CacheSetting GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from CacheSetting "); strSql.Append(" where Id=@Id "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@Id", Id); Nikita.Base.CacheStore.Model.CacheSetting model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>得到一个对象实体 /// /// </summary> public Nikita.Platform.BugClose.Model.BseDictionary GetModel(int Id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from BseDictionary "); strSql.Append(" where Id=@Id "); IDbHelper h = GlobalHelp.GetDataAccessHelper();; h.CreateCommand(strSql.ToString()); h.AddParameter("@Id", Id); Nikita.Platform.BugClose.Model.BseDictionary model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>得到一个对象实体 /// /// </summary> public Nikita.Assist.Logger.Model.SqlserverLog GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from SqlserverLog "); strSql.Append(" where id=@id "); IDbHelper h = DbHelper.GetDbHelper(SqlType.SqlServer, GlobalHelp.Connection); h.CreateCommand(strSql.ToString()); h.AddParameter("@id", id); Nikita.Assist.Logger.Model.SqlserverLog model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>得到一个对象实体 /// /// </summary> public Nikita.Platform.BugClose.Model.BseProjectVersion GetModel(int VersionID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * from BseProjectVersion "); strSql.Append(" where VersionID=@VersionID "); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); h.AddParameter("@VersionID", VersionID); Nikita.Platform.BugClose.Model.BseProjectVersion model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public Nikita.Base.CacheStore.Model.CacheSetting GetModelByCond(string strCond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from CacheSetting "); if (!string.IsNullOrEmpty(strCond)) { strSql.Append(" where " + strCond); } IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); Nikita.Base.CacheStore.Model.CacheSetting model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public Nikita.Platform.BugClose.Model.BseDictionary GetModelByCond(string strCond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from BseDictionary "); if (!string.IsNullOrEmpty(strCond)) { strSql.Append(" where " + strCond); } IDbHelper h = GlobalHelp.GetDataAccessHelper();; h.CreateCommand(strSql.ToString()); Nikita.Platform.BugClose.Model.BseDictionary model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>根据条件得到一个对象实体 /// /// </summary> public Nikita.Assist.Logger.Model.SqlserverLog GetModelByCond(string cond) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from SqlserverLog "); if (!string.IsNullOrEmpty(cond)) { strSql.Append(" where " + cond); } IDbHelper h = DbHelper.GetDbHelper(SqlType.SqlServer, GlobalHelp.Connection); h.CreateCommand(strSql.ToString()); Nikita.Assist.Logger.Model.SqlserverLog model = null; using (IDataReader dataReader = h.ExecuteReader()) { if (dataReader.Read()) { model = ReaderBind(dataReader); } h.CloseConn(); } return(model); }
/// <summary>分页获取数据列表 /// /// </summary> public List <Nikita.Base.CacheStore.Model.CacheSetting> GetListArray(string strFileds, string strOrder, string strOrderType, int intPageSize, int intPageIndex, string strWhere) { IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateStoredCommand("[proc_SplitPage]"); h.AddParameter("@tblName", "CacheSetting"); h.AddParameter("@strFields", strFileds); h.AddParameter("@strOrder", strOrder); h.AddParameter("@strOrderType", strOrderType); h.AddParameter("@PageSize", intPageSize); h.AddParameter("@PageIndex", intPageIndex); h.AddParameter("@strWhere", strWhere); List <Nikita.Base.CacheStore.Model.CacheSetting> list = new List <Nikita.Base.CacheStore.Model.CacheSetting>(); using (IDataReader dataReader = h.ExecuteReader()) { while (dataReader.Read()) { list.Add(ReaderBind(dataReader)); } h.CloseConn(); } return(list); }
/// <summary>获得数据列表(比DataSet效率高,推荐使用) /// /// </summary> public List <Nikita.Base.CacheStore.Model.CacheSetting> GetListArray(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM CacheSetting "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } List <Nikita.Base.CacheStore.Model.CacheSetting> list = new List <Nikita.Base.CacheStore.Model.CacheSetting>(); IDbHelper h = GlobalHelp.GetDataAccessHelper(); h.CreateCommand(strSql.ToString()); using (IDataReader dataReader = h.ExecuteReader()) { while (dataReader.Read()) { list.Add(ReaderBind(dataReader)); } h.CloseConn(); } return(list); }
/// <summary>分页获取数据列表 /// /// </summary> public List <Nikita.Assist.Logger.Model.SqlserverLog> GetListArray(string fileds, string order, string ordertype, int PageSize, int PageIndex, string strWhere) { IDbHelper h = DbHelper.GetDbHelper(SqlType.SqlServer, GlobalHelp.Connection); h.CreateStoredCommand("[proc_SplitPage]"); h.AddParameter("@tblName", "SqlserverLog"); h.AddParameter("@strFields", fileds); h.AddParameter("@strOrder", order); h.AddParameter("@strOrderType", ordertype); h.AddParameter("@PageSize", PageSize); h.AddParameter("@PageIndex", PageIndex); h.AddParameter("@strWhere", strWhere); List <Nikita.Assist.Logger.Model.SqlserverLog> list = new List <Nikita.Assist.Logger.Model.SqlserverLog>(); using (IDataReader dataReader = h.ExecuteReader()) { while (dataReader.Read()) { list.Add(ReaderBind(dataReader)); } h.CloseConn(); } return(list); }
/// <summary>获得数据列表(比DataSet效率高,推荐使用) /// /// </summary> public List <Nikita.Assist.Logger.Model.SqlserverLog> GetListArray(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM SqlserverLog "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } List <Nikita.Assist.Logger.Model.SqlserverLog> list = new List <Nikita.Assist.Logger.Model.SqlserverLog>(); IDbHelper h = DbHelper.GetDbHelper(SqlType.SqlServer, GlobalHelp.Connection); h.CreateCommand(strSql.ToString()); using (IDataReader dataReader = h.ExecuteReader()) { while (dataReader.Read()) { list.Add(ReaderBind(dataReader)); } h.CloseConn(); } return(list); }