public void BindDeliveryOrderSummary() { TechnicalBAL objtechBAL = new TechnicalBAL(); DataSet dsReqSumm = new DataSet(); dsReqSumm = objtechBAL.GetDeliveryOrderSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString(), Request.QueryString["DELIVERY_CODE"].ToString()); lblCatalog.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["Catalog"]); lblReqNo.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["RequistionCode"]); lblTotalItem.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["TotalItems"]); lblToDate.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["ToDate"]); lblVessel.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["VesselName"]); txtComments.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["ReqComents"]); lblDelDate.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["DELIVERY_DATE"]); lblDelPort.Text = Convert.ToString(dsReqSumm.Tables[0].Rows[0]["PORT_NAME"]); rgdItems.DataSource = dsReqSumm.Tables[2]; rgdItems.DataBind(); rpAttachment.DataSource = dsReqSumm.Tables[1]; rpAttachment.DataBind(); gvItemsSupp.DataSource = dsReqSumm.Tables[3]; gvItemsSupp.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { string strRptPath = Server.MapPath("."); string Selection = Request.QueryString["RptType"].ToString(); DataSet dsReqSumm; TechnicalBAL objtechBAL; ConnectionInfo cInfo = new ConnectionInfo(); TableLogOnInfo logOnInfo = new TableLogOnInfo(); string connstring = System.Configuration.ConfigurationManager.ConnectionStrings["smsconn"].ToString(); string[] conn = connstring.ToString().Split(';'); string[] serverInfo = conn[0].ToString().Split('='); string[] DbInfo = conn[1].ToString().Split('='); string[] userInfo = conn[2].ToString().Split('='); string[] passwordInfo = conn[3].ToString().Split('='); cInfo.ServerName = serverInfo[1].ToString(); cInfo.DatabaseName = DbInfo[1].ToString(); cInfo.UserID = userInfo[1].ToString(); cInfo.Password = passwordInfo[1].ToString(); switch (Selection) { //For Requistion Summary case "ReqSumry": objtechBAL = new TechnicalBAL(); dsReqSumm = new DataSet(); dsReqSumm = objtechBAL.GetRequisitionSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString()); ReportDocument rptSumryDoc = new ReportDocument(); rptSumryDoc.Load(strRptPath + "\\RptRequisitionSummary.rpt"); rptSumryDoc.OpenSubreport("Items").SetDataSource(dsReqSumm.Tables[1]); rptSumryDoc.SetDataSource(dsReqSumm.Tables[0]); SummaryReportViewer.ReportSource = rptSumryDoc; SummaryReportViewer.DisplayGroupTree = false; SummaryReportViewer.DisplayToolbar = true; break; //For Quotation Summary case "QtnSumry": objtechBAL = new TechnicalBAL(); dsReqSumm = new DataSet(); dsReqSumm = objtechBAL.GetRequQuotationSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString(), Request.QueryString["QUOTATION_CODE"].ToString()); ReportDocument rptSumryDocQtn = new ReportDocument(); rptSumryDocQtn.Load(strRptPath + "\\RptQuotationSummary.rpt"); rptSumryDocQtn.OpenSubreport("RptSubRFQSent").SetDataSource(dsReqSumm.Tables[3]); rptSumryDocQtn.OpenSubreport("RptSubQuotationReceived").SetDataSource(dsReqSumm.Tables[2]); rptSumryDocQtn.SetDataSource(dsReqSumm.Tables[0]); SummaryReportViewer.ReportSource = rptSumryDocQtn; SummaryReportViewer.DisplayGroupTree = false; SummaryReportViewer.DisplayToolbar = true; break; //For Delivery Order Summary case "DelvSumry": objtechBAL = new TechnicalBAL(); dsReqSumm = new DataSet(); dsReqSumm = objtechBAL.GetDeliveryOrderSummary(Request.QueryString["REQUISITION_CODE"].ToString(), Request.QueryString["document_code"].ToString(), Request.QueryString["Vessel_Code"].ToString(), Request.QueryString["DELIVERY_CODE"].ToString()); ReportDocument rptSumryDelv = new ReportDocument(); rptSumryDelv.Load(strRptPath + "\\RptDeliverOrderSummary.rpt"); rptSumryDelv.OpenSubreport("RptSubDeliverOrderSummaryItem").SetDataSource(dsReqSumm.Tables[2]); rptSumryDelv.OpenSubreport("RptSubDeliverOrderSummaryAttachment").SetDataSource(dsReqSumm.Tables[1]); rptSumryDelv.SetDataSource(dsReqSumm.Tables[0]); SummaryReportViewer.ReportSource = rptSumryDelv; SummaryReportViewer.DisplayGroupTree = false; SummaryReportViewer.DisplayToolbar = true; break; } }