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