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