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;
}
