/// <summary>取distinct的datatable /// /// </summary> /// <param name="fileds">字段</param> /// <param name="cond">条件</param> /// <returns></returns> public DataTable GetDistinctTable(string fileds, string cond) { string sql = "select distinct " + fileds + " from [user] "; if (!string.IsNullOrEmpty(cond)) { sql += " where " + cond; } MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(sql); return(h.ExecuteQuery()); }
/// <summary>分页获取数据列表 /// /// </summary> public DataSet GetList(string fileds, string order, string ordertype, int PageSize, int PageIndex, string strWhere) { MSSQLHelper h = new MSSQLHelper(); 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); DataTable dt = h.ExecuteQuery(); DataSet ds = new DataSet(); ds.Tables.Add(dt); return(ds); }
/// <summary>获得数据列表 /// /// </summary> public DataSet GetList(string strWhere) { StringBuilder strSql = new StringBuilder(); strSql.Append("select * "); strSql.Append(" FROM [user] "); if (strWhere.Trim() != "") { strSql.Append(" where " + strWhere); } MSSQLHelper h = new MSSQLHelper(); h.CreateCommand(strSql.ToString()); DataTable dt = h.ExecuteQuery(); DataSet ds = new DataSet(); ds.Tables.Add(dt); return(ds); }