public override Dictionary <string, DataSet> Execute(string filter, Status status) { Dictionary <string, DataSet> results; this._status = status; try { base.StartPrivateSession(); //BuildJournalList(filter, this.CompId, base.TransMan); Dictionary <string, object> parameters = new Dictionary <string, object>(); //Date gg = Convert.Date(Convert.ToString(frmArContribTrialBalControl._from).Substring(0,9).Trim()); // parameters.Add("@PmtDateFrom", "3/1/14"); //parameters.Add("@PmtDateThru", Convert.ToString(frmArContribTrialBalControl._thru).Substring(0,9).Trim()); parameters.Add("@PmtDateThru", frmArContribTrialBalControl._thru); //parameters.Add("@PrintOption", this.PrintOption); //parameters.Add("@SortOption", this.SortOption); //parameters.Add("@SortOrder", this.SortOrder); //parameters.Add("@ReportCurrency", this.ReportCurrency); //if (Convert.ToInt32(frmArGroupStatisticRptControl.selection.EditValue) == 1) if (frmArContribTrialBalControl._selection == 1) { set = EntityProvider.ExecuteCommand("trav_ARContribTrialBalanceArea_proc_CSI", this.CompId, true, parameters, base.TransMan); } else if (frmArContribTrialBalControl._selection == 2) { set = EntityProvider.ExecuteCommand("trav_ARContribTrialBalanceCitySt_proc_CSI", this.CompId, true, parameters, base.TransMan); } else { set = null; } for (int i = 0; i < set.Tables.Count; i++) { DataSet set2 = new DataSet("MainDataset"); DataTable table = set.Tables[i].Copy(); set2.Tables.Add(table); this.Results.Add(i.ToString(), set2); } results = this.Results; } catch (Exception exception) { base.StopPrivateSession(true); throw exception; } finally { base.StopPrivateSession(false); } return(results); }
public override Dictionary <string, DataSet> Execute(string filter, Status status) { Dictionary <string, DataSet> results; this._status = status; //Missing Definition try { base.StartPrivateSession(); BuildBlanketOrderList(filter, this.CompId, base.TransMan); Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@SortBy", this._sortBy); //Missing Definition parameters.Add("@PrintAllInBaseCurrency", this.PrintAllInBase); parameters.Add("@ReportCurrency", this.ReportCurrency); parameters.Add("@ExchRate", TRAVERSE.Business.Sys.Currency.GetExchangeRate(this.ReportCurrency, ApplicationContext.SessionDate));//TRAVERSE.Business.Sys. parameters.Add("@WksDate", ApplicationContext.SessionDate); DataSet set = EntityProvider.ExecuteCommand("dbo.trav_SoBlanketOrderReport_proc_CSI", this.CompId, true, parameters, base.TransMan); for (int i = 0; i < set.Tables.Count; i++) { DataSet set2 = new DataSet("MainDataset"); DataTable table = set.Tables[i].Copy(); set2.Tables.Add(table); this.Results.Add(i.ToString(), set2); } results = this.Results; } catch (Exception exception) { base.StopPrivateSession(true); throw exception; } finally { base.StopPrivateSession(false); } return(results); }