public override void Start() { DoneFlag = false; Report.Init(this, 1, wsReportName); Report.PrintBlock(reportLvlStart); DataTable dt = new DataTable(); string FDT = ""; if (string.IsNullOrEmpty(wsFromDate)) { FDT = "01/01/1990"; } else { FDT = wsFromDate; } ClsProfitAndLoss PandL = new ClsProfitAndLoss(); dt = PandL.ProfitAndLoss(wsBRCD, FDT, wsUserName); if (dt != null) { if (dt.Rows.Count != 0) { for (i = 0; i < dt.Rows.Count; i++) { wsOpBal = 0; wsCrBal = 0; wsDrBal = 0; wsClBal = 0; wsGlCode = dt.Rows[i]["GlCode"].ToString(); wsSubGlCode = dt.Rows[i]["SubGlCode"].ToString(); wsGlName = dt.Rows[i]["GlName"].ToString(); wsOpBal = Math.Round(Convert.ToDouble(dt.Rows[i]["OpBal"].ToString()), 2); wsCrBal = Math.Round(Convert.ToDouble(dt.Rows[i]["CrBal"].ToString()), 2); wsDrBal = Math.Round(Convert.ToDouble(dt.Rows[i]["DrBal"].ToString()), 2); wsClBal = Math.Round(Convert.ToDouble(dt.Rows[i]["ClBal"].ToString()), 2); wsRptOpTotal = wsRptOpTotal + wsOpBal; wsRptCrTotal = wsRptCrTotal + wsCrBal; wsRptDrTotal = wsRptDrTotal + wsDrBal; wsRptClTotal = wsRptClTotal + wsClBal; Report.PrintBlock(details); } } } Report.PrintBlock(reportLvlEnd); Report.Finalize(); DoneFlag = true; }
public void BindGrid() { try { DataTable dt = new DataTable(); dt = PL.ProfitAndLoss(TxtBrID.Text, TxtFDT.Text, Session["UserName"].ToString()); if (dt.Rows.Count > 0) { GrdProfitLoss.DataSource = dt; GrdProfitLoss.DataBind(); } } catch (Exception Ex) { ExceptionLogging.SendErrorToText(Ex); //Response.Redirect("FrmLogin.aspx", true); } }