private void rptQuerKalkulation_DataSourceDemanded(object sender, EventArgs e) { try { this.p_Rpt_QuerCalculationTableAdapter.Connection.ConnectionString = SQLCon.ConnectionString(); this.p_Rpt_QuerCalculationTableAdapter.ClearBeforeFill = true; this.p_Rpt_QuerCalculationTableAdapter.Fill(dsQuerKalculation1.P_Rpt_QuerCalculation, dtValue, _PID, _Type, _LVSection); this.p_Rpt_QuerCalculation_SurchargePositionTableAdapter.Connection.ConnectionString = SQLCon.ConnectionString(); this.p_Rpt_QuerCalculation_SurchargePositionTableAdapter.ClearBeforeFill = true; this.p_Rpt_QuerCalculation_SurchargePositionTableAdapter.Fill(dsSurchargeCalculation1.P_Rpt_QuerCalculation_SurchargePosition, dtValue, _PID, _Type, _LVSection); DataTable dt = new DataTable(); dt = dsSurchargeCalculation1.P_Rpt_QuerCalculation_SurchargePosition; if (dt != null) { decimal _result = 0; if (decimal.TryParse(Convert.ToString(dt.Rows[0][0]), out _result)) { if (_result == 0) { tblSurchargeresult.Text = string.Empty; } else { tblSurchargeresult.Text = _result.ToString("n2"); } } } dsDiscountCalculation ds = new dsDiscountCalculation(); this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter1.Connection.ConnectionString = SQLCon.ConnectionString(); this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter1.ClearBeforeFill = true; this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter1.Fill(ds.P_Rpt_QuerCalculation_DiscountPosition, dtValue, _PID, _Type, _LVSection); DataTable dtdiscount = new DataTable(); dtdiscount = ds.P_Rpt_QuerCalculation_DiscountPosition; if (dtdiscount != null) { decimal _result = 0; if (decimal.TryParse(Convert.ToString(dtdiscount.Rows[0][0]), out _result)) { if (_result > 0) { tbDiscountResult.Text = _result.ToString("n2"); _Discount = Convert.ToDouble(_result); } else { tbDiscountResult.Text = string.Empty; _Discount = 0; } } } } catch (Exception ex) { Utility.ShowError(ex); } }
private void rptProposalCommon_DataSourceDemanded(object sender, EventArgs e) { try { dsDiscountCalculation ds = new dsDiscountCalculation(); this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter.Connection.ConnectionString = SQLCon.ConnectionString(); this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter.ClearBeforeFill = true; this.p_Rpt_QuerCalculation_DiscountPositionTableAdapter.Fill(ds.P_Rpt_QuerCalculation_DiscountPosition, dtValue, _PID, _Type, _LVSection); dsProposalCommon _dsCommon = new dsProposalCommon(); this.p_Rpt_PositionForProposalPriceForCommonTableAdapter.Connection.ConnectionString = SQLCon.ConnectionString(); this.p_Rpt_PositionForProposalPriceForCommonTableAdapter.ClearBeforeFill = true; this.p_Rpt_PositionForProposalPriceForCommonTableAdapter.Fill(_dsCommon.P_Rpt_PositionForProposalPriceForCommon, dtValue, _PID, _Type, _LVSection); dsProposalCommonTotalSummery _dsTotalSum = new dsProposalCommonTotalSummery(); this.p_Rpt_GetTotalSummeryTableAdapter.Connection.ConnectionString = SQLCon.ConnectionString(); this.p_Rpt_GetTotalSummeryTableAdapter.ClearBeforeFill = true; this.p_Rpt_GetTotalSummeryTableAdapter.Fill(_dsTotalSum.P_Rpt_GetTotalSummery, dtValue, _PID, _Type, _LVSection); DataTable dtdiscount = new DataTable(); dtdiscount = ds.P_Rpt_QuerCalculation_DiscountPosition; if (dtdiscount != null) { decimal _result = 0; if (decimal.TryParse(Convert.ToString(dtdiscount.Rows[0][0]), out _result)) { if (_result != 0) //&& !ISWithGB) { tbDiscount.Text = '-' + _result.ToString("n2"); _Discount = Convert.ToDouble(_result); } else { tbDiscount.Text = string.Empty; _Discount = 0; lblDiscount.Visible = false; lblDiscountEuro.Visible = false; } } } } catch (Exception ex) { Utility.ShowError(ex); } }