Beispiel #1
0
        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);
        }
Beispiel #2
0
        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);
        }