/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Settings GetModel(string name)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from [Settings] ");
strSql.Append(" where Name=@ID ");
MSSQLHelper h = new MSSQLHelper();
h.CreateCommand(strSql.ToString());
h.AddParameter("@ID", name);
Model.Settings model = null;
using (IDataReader dataReader = h.ExecuteReader())
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
h.CloseConn();
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Tools_entitys GetModel(int keyId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from [Tools_entitys] ");
strSql.Append(" where ID=@ID ");
MSSQLHelper h = new MSSQLHelper();
h.CreateCommand(strSql.ToString());
h.AddParameter("@ID", keyId);
Model.Tools_entitys model = null;
using (IDataReader dataReader = h.ExecuteReader())
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
h.CloseConn();
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.Tools_Defination GetModel(string code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from [Tools_Defination] ");
strSql.Append(" where Code=@ID ");
MSSQLHelper h = new MSSQLHelper();
h.CreateCommand(strSql.ToString());
h.AddParameter("@ID", code);
Model.Tools_Defination model = null;
using (IDataReader dataReader = h.ExecuteReader())
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
h.CloseConn();
}
return(model);
}
/// <summary>
/// 根据条件得到一个对象实体
/// </summary>
public Model.Settings GetModelByCond(string cond)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [Settings] ");
if (!string.IsNullOrEmpty(cond))
{
strSql.Append(" where " + cond);
}
MSSQLHelper h = new MSSQLHelper();
h.CreateCommand(strSql.ToString());
Model.Settings model = null;
using (IDataReader dataReader = h.ExecuteReader())
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
h.CloseConn();
}
return(model);
}
/// <summary>
/// 分页获取数据列表
/// </summary>
public List <Model.Settings> GetListArray(string fileds, string order, string ordertype, int PageSize, int PageIndex, string strWhere)
{
MSSQLHelper h = new MSSQLHelper();
h.CreateStoredCommand("[proc_SplitPage]");
h.AddParameter("@tblName", "[Settings]");
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 <Model.Settings> list = new List <Model.Settings>();
using (IDataReader dataReader = h.ExecuteReader())
{
while (dataReader.Read())
{
list.Add(ReaderBind(dataReader));
}
h.CloseConn();
}
return(list);
}
/// <summary>
/// 获得数据列表（比DataSet效率高，推荐使用）
/// </summary>
public List <Model.Settings> GetListArray(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM [Settings] ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
List <Model.Settings> list = new List <Model.Settings>();
MSSQLHelper h = new MSSQLHelper();
h.CreateCommand(strSql.ToString());
using (IDataReader dataReader = h.ExecuteReader())
{
while (dataReader.Read())
{
list.Add(ReaderBind(dataReader));
}
h.CloseConn();
}
return(list);
}