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); }
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(); }