private void ChooseAddress_Load(object sender, EventArgs e)
{
uxCBAisle.SelectedIndex = 0;
uxCBShelf.SelectedIndex = 0;
uxCBSubshelf.SelectedIndex = 0;
try
{
dsPhysicalInventory = new DataSetPhysicalInventory();
cache.AddObject(CacheAddress.PhysicalInventoryData, dsPhysicalInventory);
taWarehouseInventory = new WarehouseInventoryTableAdapter();
taWarehouseLocations = new WarehouseLocationsTableAdapter();
taPhysicalProgress = new PhysicalProgressTableAdapter();
taPhysicalProgressSummary = new PhysicalProgressSummaryTableAdapter();
taEmployee = new EmployeeTableAdapter();
cache.AddObject(CacheAddress.WarehouseInventoryTableAdapter, taWarehouseInventory);
cache.AddObject(CacheAddress.WarehouseLocationsTableAdapter, taWarehouseLocations);
cache.AddObject(CacheAddress.PhysicalProgressTableAdapter, taPhysicalProgress);
cache.AddObject(CacheAddress.PhysicalProgressSummaryTableAdapter, taPhysicalProgressSummary);
cache.AddObject(CacheAddress.EmployeeTableAdapter, taEmployee);
cache.AddObject(CacheAddress.BeginPhysicalAisle, BeginPhysicalAisle);
cache.AddObject(CacheAddress.BeginPhysicalShelf, BeginPhysicalShelf);
cache.AddObject(CacheAddress.BeginPhysicalSubshelf, BeginPhysicalSubshelf);
taWarehouseLocations.Fill(dsPhysicalInventory.WarehouseLocations);
}
catch (SqlException ex)
{
foreach (SqlError SQLErr in ex.Errors)
{
MessageBox.Show(SQLErr.Message);
}
}
}
private void RefreshProgress()
{
try
{
_putAwayRack = RackSelection.Text;
_putAwayShelf = ShelfSelection.Text;
if (string.IsNullOrEmpty(_putAwayShelf))
{
ShelfSelection.Focus();
return;
}
_putAwayPosition = PositionSelection.Text;
if (string.IsNullOrEmpty(_putAwayPosition))
{
PositionSelection.Focus();
return;
}
using (var ppTA = new PhysicalProgressTableAdapter())
{
uxGridProgress.DataSource = ppTA.GetCycleCountProgressByAddress(Plant, _putAwayRack, _putAwayShelf,
_putAwayPosition);
}
using (var ppsTA = new PhysicalProgressSummaryTableAdapter())
{
var ppsDT = ppsTA.GetCycleCountProgressSummary(Plant, _putAwayRack, _putAwayShelf, _putAwayPosition);
switch (ppsDT.Rows.Count)
{
case 1:
uxLabelProgress.Text = ppsDT[0].FoundCount +
" Found, " +
ppsDT[0].MissingCount +
" Missing, " +
ppsDT[0].TotalCount +
" Total";
break;
default:
throw new Exception("Unable to retrieve summary.");
}
}
}
catch (SqlException ex)
{
foreach (SqlError sqlErr in ex.Errors)
{
MessageBox.Show(sqlErr.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void frmScanToLocation_Load(object sender, EventArgs e)
{
try
{
MyRFGun = new SymbolRFGun.SymbolRFGun();
MyRFGun.RFScan += new RFScanEventHandler(MyRFGun_RFScan);
}
catch (SymbolRFGunException ex)
{
MessageBox.Show(ex.Message);
this.Close();
}
try
{
//Select Device from device list
Symbol.Audio.Device MyDevice = (Symbol.Audio.Device)Symbol.StandardForms.SelectDevice.Select(
Symbol.Audio.Controller.Title,
Symbol.Audio.Device.AvailableDevices);
if (MyDevice == null)
{
MessageBox.Show("No Device Selected", "SelectDevice");
//close the form
this.Close();
return;
}
//check the device type
switch (MyDevice.AudioType)
{
//if standard device
case Symbol.Audio.AudioType.StandardAudio:
MyAudioController = new Symbol.Audio.StandardAudio(MyDevice);
break;
//if simulated device
case Symbol.Audio.AudioType.SimulatedAudio:
MyAudioController = new Symbol.Audio.SimulatedAudio(MyDevice);
break;
default:
throw new Symbol.Exceptions.InvalidDataTypeException("Unknown Device Type");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
try
{
Exception ex = null;
dsPhysicalInventory = (DataSetPhysicalInventory)cache.RetrieveObject(CacheAddress.PhysicalInventoryData);
taEmployee = (EmployeeTableAdapter)cache.RetrieveObject(CacheAddress.EmployeeTableAdapter);
taPhysicalProgress = (PhysicalProgressTableAdapter)cache.RetrieveObject(CacheAddress.PhysicalProgressTableAdapter);
taPhysicalProgressSummary = (PhysicalProgressSummaryTableAdapter)cache.RetrieveObject(CacheAddress.PhysicalProgressSummaryTableAdapter);
taWarehouseInventory = (WarehouseInventoryTableAdapter)cache.RetrieveObject(CacheAddress.WarehouseInventoryTableAdapter);
switch (dsPhysicalInventory.Employee.Rows.Count)
{
case 1:
OperatorCode = dsPhysicalInventory.Employee[0].OperatorCode;
uxLabelOperatorCode.Text = OperatorCode;
break;
case 0:
ex = new Exception("Invalid password.");
throw ex;
default:
ex = new Exception("Unknown error validating password.");
throw ex;
}
PutAwayAisle = (string)cache.RetrieveObject(CacheAddress.BeginPhysicalAisle);
BeginPhysicalShelf = (Int32)cache.RetrieveObject(CacheAddress.BeginPhysicalShelf);
BeginPhysicalSubshelf = (Int32)cache.RetrieveObject(CacheAddress.BeginPhysicalSubshelf);
uxCBAisle.Items.Add(PutAwayAisle);
uxCBAisle.SelectedIndex = 0;
if (BeginPhysicalShelf == 0)
{
uxCBShelf.Items.Add("1");
uxCBShelf.Items.Add("2");
uxCBShelf.Items.Add("3");
uxCBShelf.Items.Add("4");
PutAwayShelf = 1;
}
else
{
uxCBShelf.Items.Add(BeginPhysicalShelf.ToString());
PutAwayShelf = BeginPhysicalShelf;
}
uxCBShelf.SelectedIndex = 0;
if (BeginPhysicalSubshelf == 0)
{
uxCBSubshelf.Items.Add("1");
uxCBSubshelf.Items.Add("2");
uxCBSubshelf.Items.Add("3");
uxCBSubshelf.Items.Add("4");
uxCBSubshelf.Items.Add("5");
uxCBSubshelf.Items.Add("6");
uxCBSubshelf.Items.Add("7");
uxCBSubshelf.Items.Add("8");
uxCBSubshelf.Items.Add("9");
uxCBSubshelf.Items.Add("10");
uxCBSubshelf.Items.Add("11");
uxCBSubshelf.Items.Add("12");
PutAwaySubshelf = 1;
}
else
{
uxCBSubshelf.Items.Add(BeginPhysicalSubshelf.ToString());
PutAwaySubshelf = BeginPhysicalSubshelf;
}
uxCBSubshelf.SelectedIndex = 0;
RefreshProgress();
}
catch (SqlException ex)
{
foreach (SqlError SQLErr in ex.Errors)
{
MessageBox.Show(SQLErr.Message);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
