private void ExecuteOrderChangeCommand(object parameter)
{
var dropobj = parameter as ProfileModel;
if (dropobj.GroupNo == _draggedObject.GroupNo &&
_draggedObject.Comment == "Pallet")
{
//remove the drag object and re-insert it
PalletList.Remove(_draggedObject);
var idx = PalletList.IndexOf(dropobj);
PalletList.Insert(idx, _draggedObject);
}
else
{
//delete the item from drag list
if (13.Equals(_draggedObject.GroupNo))
{
Group1x3.Remove(_draggedObject);
}
else if (26.Equals(_draggedObject.GroupNo))
{
Group2x6.Remove(_draggedObject);
}
else if (45.Equals(_draggedObject.GroupNo))
{
Group4x5.Remove(_draggedObject);
}
else if (123456.Equals(_draggedObject.GroupNo))
{
Brothers.Remove(_draggedObject);
}
}
}
/// <summary>
/// Method for converting pallet list object to be a string list
/// so that the list contains all items in the pallet list object
/// </summary>
/// <param name="palletList"></param>
/// <returns></returns>
public List <string[]> GetAdaptedAllPalletsList(PalletList palletList)
{
List <string[]> allPalletList = new List <string[]>();
if (palletList.pallets != null)
{
foreach (Pallet pallet in palletList.pallets)
{
string[] row = { pallet.palletID, pallet.companyID, pallet.locationID, pallet.palletHeight.ToString(), pallet.palletArea.ToString(), transformIntoDateTime(pallet.arrivalDate.ToString()), pallet.daysStored.ToString() };
allPalletList.Add(row);
}
}
return(allPalletList);
}
public PalletList GetPalletList(string pickno, out string resultMsg) //
{
resultMsg = string.Empty;
PalletList lstPallet = null;
try
{
using (ProductCardRePackBLL prodRePack = new ProductCardRePackBLL())
{
lstPallet = prodRePack.GetPalletList(pickno, out resultMsg);
}
}
catch (Exception ex)
{
resultMsg = ex.Message;
}
return(lstPallet);
}
public PalletList GetPalletList(string pickno, out string resultMessage) //
{
resultMessage = string.Empty;
PalletList lstPallet = null;
Pallet pallet = null;
try
{
ProcParam procPara = new ProcParam(3)
{
ProcedureName = "SCANNER_PACK_FG.GET_PALLET_LIST"
};
procPara.AddParamRefCursor(0, "IO_CURSOR");
procPara.AddParamInput(1, "strPICK_NO", pickno);
procPara.AddParamOutput(2, "RESULTMSG", OracleDbType.Varchar2, 255);
OraDataReader.Instance.OraReader = GlobalDB.Instance.DataAc.ExecuteDataReader(procPara);
this.executionTime = GlobalDB.Instance.DataAc.ExecuteTime;
if (OraDataReader.Instance.OraReader.HasRows)
{
lstPallet = new PalletList();
OraDataReader.Instance.OraReader.FetchSize = OraDataReader.Instance.OraReader.RowSize * 100;
while (OraDataReader.Instance.OraReader.Read())
{
pallet = new Pallet();
pallet.PALLET_NO = OraDataReader.Instance.GetString("PALLET_NO");
pallet.SO_NO = OraDataReader.Instance.GetString("SO_NO");
pallet.PALLET_SEQ = OraDataReader.Instance.GetInteger("PALLET_SEQ");
pallet.PALLET_TOTAL = OraDataReader.Instance.GetInteger("PALLET_TOTAL");
pallet.PALLET_STATUS = OraDataReader.Instance.GetString("PALLET_STATUS");
pallet.PALLET_BOX = OraDataReader.Instance.GetInteger("PALLET_BOX");
pallet.PALLET_PCS = OraDataReader.Instance.GetInteger("PALLET_PCS");
lstPallet.Add(pallet);
}
}
// always call Close when done reading.
OraDataReader.Instance.Close();
OracleString resultDB = (OracleString)procPara.ReturnValue(2);
if (!resultDB.IsNull)
{
resultMessage = resultDB.Value;
}
}
catch (Exception ex)
{
lstPallet = null;
throw ex;
}
return(lstPallet);
}
/// <summary>
/// Method that handling the click event of viewing all available pallet button
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void ButtonViewAll_Click(object sender, EventArgs e)
{
PalletList = PalletController.getAvailablePalletList();
updatePalletListView();
}
