asked on
public class ctrlAsBuiltTallyReport : System.Web.UI.UserControl
{
string QSPrjId;
string QSSectionId;
protected CrystalDecisions.Web.CrystalReportViewer CrystalReportViewer1;
PipeTracking_GI.Crystal.CRSAsBuilt oRpt = new PipeTracking_GI.Crystal.CRSAsBuilt();
protected System.Web.UI.WebControls.ImageButton Imagebutton3;
protected System.Web.UI.WebControls.ImageButton ImageButton1;
protected System.Web.UI.WebControls.ImageButton ImageButton2;
SessionDetails Session_Properties=new SessionDetails();
private void Page_Load(object sender, System.EventArgs e)
{
DataSet ds = new DataSet();
QSPrjId = Request.QueryString["PrjId"];
QSSectionId = Request.QueryString["SectionId"];
Projects proj;
proj=Projects.getProjectByProjId_BLL(Convert.ToInt32(QSPrjId));
CargoBarge _Cargo;
_Cargo=CargoBarge.getCargoBargeByProjId_BLL(Convert.ToInt32(QSPrjId));
Section _Section=null;
_Section=Section.getSectionBySectionId_BLL(Convert.ToInt32(QSSectionId));
ds = InstalledPipes.Get_DSAsBuilt_BLL(Convert.ToInt32(QSPrjId),Convert.ToInt32(QSSectionId));
oRpt.SetParameterValue("Report Header", "As Built Tally Report");
oRpt.SetParameterValue("Client", proj.ProjClient);
oRpt.SetParameterValue("Project Name", proj.ProjName);
oRpt.SetParameterValue("Project description", proj.ProjDesc);
oRpt.SetParameterValue("Project number", proj.ProjNumber);
oRpt.SetParameterValue("Section", _Section.SectionNo);
oRpt.SetParameterValue("Location", proj.ProjLocation);
oRpt.SetParameterValue("Contractor", "Global Industries");
oRpt.SetParameterValue("Barge ID", _Cargo.LayBarge);
DataColumn dc = new DataColumn("Name");
ds.Tables[0].Columns.Add(dc);
oRpt.SetDataSource(ds.Tables[0]);
CrystalReportViewer1.ReportSource=oRpt;
CrystalReportViewer1.Visible = true;
}
}