示例#1
0
        //[Obsolete("Use GetStockLot")]
        static public DataTable GetLotDetails(string LotID)
        {
            Query q = new StoredProc("usp_GetLotDetails");

            q.Parameters.AddWithValue("@LOTID", LotID);

            return(q.ExecuteDataTable());
        }
示例#2
0
        private void LoadData()
        {
            Query q = new StoredProc("usp_GetSalesShipmentProcessResults");

            q.Parameters.AddWithValue("@sordernbr", soNbr);

            DataSet ds = q.ExecuteDataSet();

            expectedTable           = ds.Tables[0];
            expectedTable.TableName = "Expected";

            processedTable           = ds.Tables[1];
            processedTable.TableName = "Processed";

            FillTableList();
        }
示例#3
0
        private void LoadData()
        {
            Query q = new StoredProc("usp_GetReceiptProcessResults");

            q.Parameters.AddWithValue("@pordernbr", poNbr);

            DataSet ds = q.ExecuteDataSet();

            expectedTable           = ds.Tables[0];
            expectedTable.TableName = "Expected";

            processedTable           = ds.Tables[1];
            processedTable.TableName = "Processed";

            discrepantTable           = ds.Tables[2];
            discrepantTable.TableName = "Discrepancies";

            FillTableList();
        }