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