Esempio n. 1
0
    public void BindBOLData(string BOLNumber)
    {
        DataSet dsGER = new DataSet();

        UpdateButton.Visible      = false;
        PreUpdateGridView.Visible = false;
        ResultsGridView.Visible   = false;
        string SqlStatement = " select BOLNo, ProcessRecInd from (  ";

        SqlStatement += " Select BOLNo, case GERProcess.ProcessRecInd when 1 then 'Now' else 'Nightly' end as ProcessRecInd  ";
        SqlStatement += " FROM GERProcess,  ";
        SqlStatement += "   (SELECT * ";
        SqlStatement += " 	FROM GERDetail ";
        SqlStatement += "   WHERE (BOLNo = '" + BOLNumber + "')) GERDtl";
        SqlStatement += " WHERE GERDtl.pGERDtlID = GERProcess.GERDetailID  ";
        SqlStatement += " and GERProcess.ProcessDt IS NULL) GetMstr ";
        SqlStatement += " group by BOLNo, ProcessRecInd";
        dsGER         = SqlHelper.ExecuteDataset(connectionString, CommandType.Text, SqlStatement);
        if (dsGER.Tables[0] != null)
        {
            dtBOLData = dsGER.Tables[0];
            PreUpdateGridView.DataSource = dtBOLData;
            PreUpdateGridView.DataBind();
            if (dtBOLData.Rows.Count == 0)
            {
                lblErrorMessage.Text = "No records waiting to process for this BOL.";
            }
            else
            {
                UpdateButton.Visible      = true;
                PreUpdateGridView.Visible = true;
            }
        }
        else
        {
            lblErrorMessage.Text = "No records waiting to process for this BOL..";
        }
    }
Esempio n. 2
0
    public void BindBOLData(string BOLNumber)
    {
        lblSuccessMessage.Text = "";
        lblErrorMessage.Text   = "";
        DataSet   dsGER         = new DataSet();
        DataTable dtBOLLineData = new DataTable();
        DataTable dtRcptData    = new DataTable();
        String    PONumber      = "";
        String    POLineNumber  = "";
        Boolean   UpdateOK      = true;

        UpdateButton.Visible      = false;
        PreUpdateGridView.Visible = false;
        NVStatusGrid.Visible      = false;
        string SqlStatement = " select pGERHdrHstID, BOLNo, BOLDate, VendNo, VendName, ProcDt ";

        SqlStatement += " FROM GERHeaderHist";
        SqlStatement += "   WHERE (BOLNo = '" + BOLNumber + "') ";
        dsGER         = SqlHelper.ExecuteDataset(connectionString, CommandType.Text, SqlStatement);
        if (dsGER.Tables[0] != null)
        {
            dtBOLData = dsGER.Tables[0];
            PreUpdateGridView.DataSource = dtBOLData;
            PreUpdateGridView.DataBind();
            if (dtBOLData.Rows.Count == 0)
            {
                lblErrorMessage.Text = "BOL not in History.";
                UpdateOK             = false;
            }
            else
            {
                DataTable dtStatusData = new DataTable();
                dtStatusData.Columns.Add("DataType", typeof(String));
                dtStatusData.Columns.Add("DataStatus", typeof(String));
                dtStatusData.Columns.Add("RcptNo", typeof(String));
                dtStatusData.Columns.Add("RcptLine", typeof(String));
                dtStatusData.Columns.Add("Item", typeof(String));
                dtStatusData.Columns.Add("PONo", typeof(String));
                dtStatusData.Columns.Add("POLine", typeof(String));
                // now check the lines
                SqlStatement  = " select  PFCPONo, PFCPOLineNo, PFCItemNo, RcptQty ";
                SqlStatement += " FROM GERDetailHist";
                SqlStatement += "   WHERE (BOLNo = '" + BOLNumber + "') ";
                dsGER         = SqlHelper.ExecuteDataset(connectionString, CommandType.Text, SqlStatement);
                if (dsGER.Tables[0] != null)
                {
                    dtBOLLineData = dsGER.Tables[0];
                    if (dtBOLData.Rows.Count == 0)
                    {
                        lblErrorMessage.Text = "Problem: No BOL Lines in History.";
                        UpdateOK             = false;
                    }
                    else
                    {
                        foreach (DataRow row in dtBOLLineData.Rows)
                        {
                            PONumber      = row["PFCPONo"].ToString();
                            POLineNumber  = row["PFCPOLineNo"].ToString();
                            SqlStatement  = " select   [Document No_], [Line No_], No_, [Location Code], [Order No_], [Order Line No_], [Bill of Lading No_], [Bill of Lading Date] ";
                            SqlStatement += " FROM   [Porteous$Purch_ Rcpt_ Line] WITH (NOLOCK) ";
                            SqlStatement += "   WHERE ([Order No_] = '" + PONumber + "') ";
                            SqlStatement += "   and ([Order Line No_] = " + POLineNumber + ") ";
                            SqlStatement += "   and ([Bill of Lading No_] = '" + BOLNumber + "') ";
                            dsGER         = SqlHelper.ExecuteDataset(NVconnectionString, CommandType.Text, SqlStatement);
                            if (dsGER.Tables[0] != null)
                            {
                                dtRcptData = dsGER.Tables[0];
                                if (dtRcptData.Rows.Count == 0)
                                {
                                    dtStatusData.Rows.Add(new Object[] { "P.O. Receipts",
                                                                         "OK", "None", "", row["PFCItemNo"].ToString(), PONumber, POLineNumber });
                                }
                                else
                                {
                                    dtStatusData.Rows.Add(new Object[] { "P.O. Receipts",
                                                                         "Records found", dtRcptData.Rows[0]["Document No_"].ToString(),
                                                                         dtRcptData.Rows[0]["Line No_"].ToString(), row["PFCItemNo"].ToString(),
                                                                         PONumber, POLineNumber });
                                    UpdateOK             = false;
                                    lblErrorMessage.Text = "Receipts already exist for this BOL so it cannot be reprocessed.";
                                }
                            }
                        }
                    }
                }
                if (UpdateOK)
                {
                    UpdateButton.Visible   = true;
                    lblSuccessMessage.Text = "Press the Update button to move this BOL from history and make it ready for reprocessing";
                }
                PreUpdateGridView.Visible = true;
                NVStatusGrid.DataSource   = dtStatusData;
                NVStatusGrid.DataBind();
                NVStatusGrid.Visible = true;
            }
        }
        else
        {
            lblErrorMessage.Text = "BOL not in History..";
        }
    }