private void itemHistoryReportToolStripMenuItem_Click(object sender, EventArgs e) { try { if (_ItemHistoryReport.IsDisposed == true) { _ItemHistoryReport = new ItemHistoryView(); } Home.Home_pnl.Visible = false; _ItemHistoryReport.MdiParent = this; _ItemHistoryReport.WindowState = FormWindowState.Maximized; _ItemHistoryReport.Show(); _ItemHistoryReport.Focus(); } catch (Exception ex) { notifyIcon1.ShowBalloonTip(1000, this.Name, ex.Message, ToolTipIcon.Info);; } }
public SortableSearchableBindingList <ItemHistoryTransaction> GetHistory(ItemHistoryView enuItemHistoryView, string strJobNo = null, int intSuffix = 0) { SortableSearchableBindingList <ItemHistoryTransaction> objItemHistoryList = new SortableSearchableBindingList <ItemHistoryTransaction>(); ItemHistoryTransaction objItemHistoryTransaction; SqlCommand objSQLCommand; ExtraSytelineTablesSettings objExtraSytelineTableSettings; SqlDataReader objDataReader; string strSQL; string strJobParameter; objExtraSytelineTableSettings = new ExtraSytelineTablesSettings(); if (strJobNo != null) { strJobParameter = " AND job = '" + strJobNo + "' AND suffix = " + intSuffix.ToString(); } else { strJobParameter = string.Empty; } switch (enuItemHistoryView) { case ItemHistoryView.All: strSQL = QueryDefinitions.GetQuery("SelectAllItemHistory", new string[] { ItemID, strJobParameter }); break; case ItemHistoryView.Shipped: strSQL = QueryDefinitions.GetQuery("SelectShippedItemHistory", new string[] { ItemID, strJobParameter }); break; case ItemHistoryView.Recieved: strSQL = QueryDefinitions.GetQuery("SelectRecievedItemHistory", new string[] { ItemID, strJobParameter }); break; default: strSQL = string.Empty; break; } objExtraSytelineTableSettings.SQLConnection.Open(); objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand(); objSQLCommand.CommandText = strSQL; objDataReader = objSQLCommand.ExecuteReader(); while (objDataReader.Read()) { objItemHistoryTransaction = new ItemHistoryTransaction(); objItemHistoryTransaction.LabelSequence = int.Parse(objDataReader["LabelSequence"].ToString()); objItemHistoryTransaction.ItemID = objDataReader["item"].ToString(); objItemHistoryTransaction.Job = objDataReader["job"].ToString(); objItemHistoryTransaction.CustomerOrderNumber = objDataReader["co"].ToString(); objItemHistoryTransaction.Quantity = int.Parse(objDataReader["Quantity"].ToString()); objItemHistoryTransaction.RecievedTimeStamp = string.Format("{0:MM/dd/yyyy hh:mm:ss tt}", objDataReader["ReceivedTimestamp"]); objItemHistoryTransaction.ShippedTimeStamp = string.Format("{0:MM/dd/yyyy hh:mm:ss tt}", objDataReader["ShippedTimestamp"]); objItemHistoryTransaction.Operator = objDataReader["operator"].ToString(); objItemHistoryTransaction.GrossWeight = double.Parse(objDataReader["GrossWgt"].ToString()); objItemHistoryTransaction.PalletCount = int.Parse(objDataReader["PalletCt"].ToString()); objItemHistoryTransaction.RecievedItemID = int.Parse(objDataReader["ReceivedItemID"].ToString()); objItemHistoryTransaction.Suffix = int.Parse(objDataReader["suffix"].ToString()); objItemHistoryList.Add(objItemHistoryTransaction); } return(objItemHistoryList); }
public SortableSearchableBindingList<ItemHistoryTransaction> GetHistory(ItemHistoryView enuItemHistoryView, string strJobNo = null, int intSuffix = 0) { SortableSearchableBindingList<ItemHistoryTransaction> objItemHistoryList = new SortableSearchableBindingList<ItemHistoryTransaction>(); ItemHistoryTransaction objItemHistoryTransaction; SqlCommand objSQLCommand; ExtraSytelineTablesSettings objExtraSytelineTableSettings; SqlDataReader objDataReader; string strSQL; string strJobParameter; objExtraSytelineTableSettings = new ExtraSytelineTablesSettings(); if (strJobNo != null) strJobParameter = " AND job = '" + strJobNo + "' AND suffix = " + intSuffix.ToString(); else strJobParameter = string.Empty; switch (enuItemHistoryView) { case ItemHistoryView.All: strSQL = QueryDefinitions.GetQuery("SelectAllItemHistory", new string[] { ItemID, strJobParameter }); break; case ItemHistoryView.Shipped: strSQL = QueryDefinitions.GetQuery("SelectShippedItemHistory", new string[] { ItemID, strJobParameter }); break; case ItemHistoryView.Recieved: strSQL = QueryDefinitions.GetQuery("SelectRecievedItemHistory", new string[] { ItemID, strJobParameter }); break; default: strSQL = string.Empty; break; } objExtraSytelineTableSettings.SQLConnection.Open(); objSQLCommand = objExtraSytelineTableSettings.SQLConnection.CreateCommand(); objSQLCommand.CommandText = strSQL; objDataReader = objSQLCommand.ExecuteReader(); while (objDataReader.Read()) { objItemHistoryTransaction = new ItemHistoryTransaction(); objItemHistoryTransaction.LabelSequence = int.Parse(objDataReader["LabelSequence"].ToString()); objItemHistoryTransaction.ItemID = objDataReader["item"].ToString(); objItemHistoryTransaction.Job = objDataReader["job"].ToString(); objItemHistoryTransaction.CustomerOrderNumber = objDataReader["co"].ToString(); objItemHistoryTransaction.Quantity = int.Parse(objDataReader["Quantity"].ToString()); objItemHistoryTransaction.RecievedTimeStamp = string.Format("{0:MM/dd/yyyy hh:mm:ss tt}", objDataReader["ReceivedTimestamp"]); objItemHistoryTransaction.ShippedTimeStamp = string.Format("{0:MM/dd/yyyy hh:mm:ss tt}", objDataReader["ShippedTimestamp"]); objItemHistoryTransaction.Operator = objDataReader["operator"].ToString(); objItemHistoryTransaction.GrossWeight = double.Parse(objDataReader["GrossWgt"].ToString()); objItemHistoryTransaction.PalletCount = int.Parse(objDataReader["PalletCt"].ToString()); objItemHistoryTransaction.RecievedItemID = int.Parse(objDataReader["ReceivedItemID"].ToString()); objItemHistoryTransaction.Suffix = int.Parse(objDataReader["suffix"].ToString()); objItemHistoryList.Add(objItemHistoryTransaction); } return objItemHistoryList; }