/// <summary>分页获取数据列表
///
/// </summary>
public List <mhqNetAPP.Model.User> GetListArray(string fileds, string order, string ordertype, int PageSize, int PageIndex, string strWhere, IDbDataParameter[] paras = null)
{
string cond = string.IsNullOrEmpty(strWhere) ? "" : $" where {strWhere}";
string sql = $"SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY {order} {ordertype}) AS pos, {fileds} FROM [user] {cond} ) AS sp WHERE pos BETWEEN {(((PageIndex - 1) * PageSize) + 1)} AND {PageSize * PageIndex}";
MSSQLHelper h = new MSSQLHelper();
h.CreateCommand(sql);
if (paras != null)
{
h.AddParameter(paras);
}
/* h.CreateStoredCommand("[proc_SplitPage]");
* h.AddParameter("@tblName", "[user]");
* 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 <mhqNetAPP.Model.User> list = new List <mhqNetAPP.Model.User>();
using (IDataReader dataReader = h.ExecuteReader())
{
while (dataReader.Read())
{
list.Add(ReaderBind(dataReader));
}
h.CloseConn();
}
return(list);
}
/// <summary>根据条件得到一个对象实体
///
/// </summary>
public mhqNetAPP.Model.User GetModelByCond(string cond, IDbDataParameter[] paras = null)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from [user] ");
if (!string.IsNullOrEmpty(cond))
{
strSql.Append(" where " + cond);
}
MSSQLHelper h = new MSSQLHelper();
h.CreateCommand(strSql.ToString());
if (paras != null)
{
h.AddParameter(paras);
}
mhqNetAPP.Model.User model = null;
using (IDataReader dataReader = h.ExecuteReader())
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
h.CloseConn();
}
return(model);
}
/// <summary>获得数据列表（比DataSet效率高，推荐使用）
///
/// </summary>
public List <mhqNetAPP.Model.User> GetListArray(string strWhere, IDbDataParameter[] paras = null)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * ");
strSql.Append(" FROM [user] ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
List <mhqNetAPP.Model.User> list = new List <mhqNetAPP.Model.User>();
MSSQLHelper h = new MSSQLHelper();
h.CreateCommand(strSql.ToString());
if (paras != null)
{
h.AddParameter(paras);
}
using (IDataReader dataReader = h.ExecuteReader())
{
while (dataReader.Read())
{
list.Add(ReaderBind(dataReader));
}
h.CloseConn();
}
return(list);
}
/// <summary>得到一个对象实体
///
/// </summary>
public mhqNetAPP.Model.User GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from [user] ");
strSql.Append(" where id=@id ");
MSSQLHelper h = new MSSQLHelper();
h.CreateCommand(strSql.ToString());
h.AddParameter("@id", id);
mhqNetAPP.Model.User model = null;
using (IDataReader dataReader = h.ExecuteReader())
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
h.CloseConn();
}
return(model);
}
