public bool ReConstructPackageListFromSql(string newOrderBy) { try { //string tmpOrderby = (string.IsNullOrEmpty(OrderByClause)) ? "" : OrderByClause.ToString(); Parser.Parse(Sql); EmptyReportedFields(); for (int i = 0; i < Parser.SelectList.Count; i++) { ReportedFields.Add(new ReportPair(Parser.SelectList[i], Parser.AsList[i])); } ////////////////////////// Parser.SelectList = new List <string>(); Parser.AsList = new List <string>(); foreach (ReportPair reported in ReportedFields) { Parser.SelectList.Add(reported.ReportedFieldName); Parser.AsList.Add(reported.DisplayedAs); } if (!string.IsNullOrEmpty(newOrderBy)) { Parser.OrderByClause = newOrderBy; } if (ReportedFields.Count > 0) { Sql = Parser.ReBuild(true); } ////////////////////////// } catch (Exception ex) { return(false); } return(true); }
public bool ReConstructSQLFromGridView() { if (Parser == null || Parser.SelectList == null) { return(false); } Parser.SelectList = new List <string>(); Parser.AsList = new List <string>(); foreach (ReportPair reported in ReportedFields) { Parser.SelectList.Add(reported.ReportedFieldName); Parser.AsList.Add(reported.DisplayedAs); } try { if (ReportedFields.Count > 0) { Sql = Parser.ReBuild(true); } ////////////////////// Parser.Parse(Sql); EmptyReportedFields(); for (int i = 0; i < Parser.SelectList.Count; i++) { ReportedFields.Add(new ReportPair(Parser.SelectList[i], Parser.AsList[i])); } ///////////////////// } catch (Exception ex) { return(false); } return(true); }