public string getQuery(Guid formGridViewID, Guid productID, Guid userID/*, OrderExpression order , List<SearchExpression> searchExpression*/)
{
//
List<SearchExpression> searchExpression = new List<SearchExpression>();
OrderExpression order = new OrderExpression();
//
Query.Query query = new Query.Query(this);
//query.ClassificationTreeID = treeNodeID;
query.Columns = this.GetUserProperties(userID, formGridViewID, FieldPlaceHolder.Grid);
query.UserFields = this.GetUserFields(userID, formGridViewID, FieldPlaceHolder.Grid);
query.OrderExpression = order;
query.SearchExpression = this.ValidateSearchExpression(query.Columns, query.UserFields, searchExpression);
string sql = query.BuildListQuery(productID);
return sql;
}
public virtual System.Data.DataSet GetList(Guid formGridViewID, Guid productID, Guid userID, /*OrderExpression order ,*/ List<SearchExpression> searchExpression)
{
//
//List<SearchExpression> searchExpression = new List<SearchExpression>();
OrderExpression order = new OrderExpression();
//
Query.Query query = new Query.Query(this);
//query.ClassificationTreeID = treeNodeID;
query.Columns = this.GetUserProperties(userID, formGridViewID, FieldPlaceHolder.Grid);
query.UserFields = this.GetUserFields(userID, formGridViewID, FieldPlaceHolder.Grid);
query.OrderExpression = order;
query.SearchExpression = this.ValidateSearchExpression(query.Columns, query.UserFields, searchExpression);
string sql = query.BuildListQuery(productID);
using (CommonDataProvider provider = new CommonDataProvider())
{
return provider.ExecuteCommand(sql);
}
}