Exemplo n.º 1
0
    protected void bind_sub_reports(int ordernumber)
    {
        //courier details
        Repeater _r = this.fmvorder.FindControl("rptcouriers") as Repeater;

        if (_r != null)
        {
            linq.linq_courier_detailsDataContext _courier = new linq.linq_courier_detailsDataContext();
            IList <linq.courier_detailsResult>   _c       = _courier.courier_details(ordernumber).ToList <linq.courier_detailsResult>();
            _r.DataSource = _c;
            _r.DataBind();
        }

        //delivery details
        _r = this.fmvorder.FindControl("rptdeliveries") as Repeater;
        if (_r != null)
        {
            linq.linq_delivery_detailsDataContext _delivery = new linq.linq_delivery_detailsDataContext();
            IList <linq.delivery_detailsResult>   _d        = _delivery.delivery_details(ordernumber).ToList <linq.delivery_detailsResult>();
            _r.DataSource = _d;
            _r.DataBind();
        }

        //titles
        _r = this.fmvorder.FindControl("rptordertitles") as Repeater;
        if (_r != null)
        {
            //string[] _cols = { "ItemTable.Title", "ItemTable.Copies", "ItemTable.ISBN", "ItemTable.PONumber" };
            IDataReader _t = DAL.Logistics.ItemTable.FetchByParameter("OrderNumber", Comparison.Equals, ordernumber);
            _r.DataSource = _t;
            _r.DataBind();
        }
    }
Exemplo n.º 2
0
    protected void bind_sub_reports(int ordernumber)
    {
        //courier details
        Repeater _r = this.fmvorder.FindControl("rptcouriers") as Repeater;
        if (_r != null)
        {
            linq.linq_courier_detailsDataContext _courier = new linq.linq_courier_detailsDataContext();
            IList<linq.courier_detailsResult> _c = _courier.courier_details(ordernumber).ToList<linq.courier_detailsResult>();
            _r.DataSource = _c;
            _r.DataBind();
        }

        //delivery details
        _r = this.fmvorder.FindControl("rptdeliveries") as Repeater;
        if (_r != null)
        {
            linq.linq_delivery_detailsDataContext _delivery = new linq.linq_delivery_detailsDataContext();
            IList<linq.delivery_detailsResult> _d = _delivery.delivery_details(ordernumber).ToList<linq.delivery_detailsResult>();
            _r.DataSource = _d;
            _r.DataBind();
        }

        //titles
        _r = this.fmvorder.FindControl("rptordertitles") as Repeater;
        if (_r != null)
        {
            //string[] _cols = { "ItemTable.Title", "ItemTable.Copies", "ItemTable.ISBN", "ItemTable.PONumber" };
            IDataReader _t = DAL.Logistics.ItemTable.FetchByParameter("OrderNumber", Comparison.Equals, ordernumber);
            _r.DataSource = _t;         
            _r.DataBind();
        }
    }