Пример #1
0
        public DataTable ViewWaresReceipt()
        {
            ParametersCollection varParameters = new ParametersCollection();

            varParameters.Add("parIdWorkplace", GlobalVar.varIdWorkPlace, DbType.Int32);
            varParameters.Add("parCodePeriod", varReceipt.varCodePeriod, DbType.Int32);
            varParameters.Add("parCodeReceipt", varReceipt.varCodeReceipt, DbType.Int32);
            DataTable varDtViewWaresReceipt = varWDB.ViewWaresReceipt(varParameters);
            object    sumObject;

            sumObject = varDtViewWaresReceipt.Compute("Sum(sum)", "");
            this.varReceipt.varSumReceipt = (sumObject.ToString() != "" ?   Math.Round(Convert.ToDecimal(sumObject), 2):0.0m);
            //this.varReceipt.varStSumReceipt = this.varReceipt.varSumReceipt.ToString();

            return(varDtViewWaresReceipt);
        }
Пример #2
0
        void ViewWaresReceipt()
        {
            ParametersCollection varParameters = new ParametersCollection();

            varParameters.Add("parIdWorkplace", GlobalVar.varIdWorkPlace, DbType.Int32);
            varParameters.Add("parCodePeriod", varReceipt.varCodePeriod, DbType.Int32);
            varParameters.Add("parCodeReceipt", varReceipt.varCodeReceipt, DbType.Int32);
            varDtViewWaresReceipt = varWDB.ViewWaresReceipt(varParameters);
            object sumObject;

            sumObject = varDtViewWaresReceipt.Compute("Sum(sum)", "");

            this.varReceipt.varSumReceipt = (sumObject.ToString() != "" ?   Math.Round(Convert.ToDecimal(sumObject), 2):0.0m);
            Sum.Text         = this.varReceipt.varSumReceipt.ToString();
            Wares.DataSource = varDtViewWaresReceipt;
            Wares.Refresh();
        }