/// <summary> /// /// </summary> /// <param name="sqlexpression"></param> private void fillDsWithoutPage(Expression sqlexpression) { #region Expresser expresser = new Expresser(); string tablename = expresser.GetViewTablename(sqlexpression); this.Selector.SelectCommand.CommandText = expresser.CreateSelectSQLWithoutPage(sqlexpression); this.Selector.Fill(sqlexpression.ReturnDS, tablename); #endregion }
/// <summary> /// /// </summary> /// <param name="sqlexpression"></param> private void fillDsByStoredProcedure(Expression sqlexpression) { #region Expresser expresser = new Expresser(); string tablename = expresser.GetViewTablename(sqlexpression); SqlCommand cmd = (SqlCommand)this.Selector.SelectCommand; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "SupesoftPage"; cmd.Parameters.Add("@TableName", SqlDbType.NVarChar, 2000).Value = expresser.CreateSelectSQL(sqlexpression); cmd.Parameters.Add("@ReturnFields", SqlDbType.NVarChar, 500).Value = sqlexpression.SqlConditions.ReturnFields; cmd.Parameters.Add("@PageSize", SqlDbType.NVarChar, 500).Value = sqlexpression.SqlConditions.PageSize; cmd.Parameters.Add("@PageIndex", SqlDbType.NVarChar, 500).Value = sqlexpression.SqlConditions.PageIndex; cmd.Parameters.Add("@Where", SqlDbType.NVarChar, 500).Value = ""; cmd.Parameters.Add("@Orderfld", SqlDbType.NVarChar, 500).Value = "uploadtime"; cmd.Parameters.Add("@OrderType", SqlDbType.NVarChar, 500).Value = 1; this.Selector.Fill(sqlexpression.ReturnDS, tablename); #endregion }