public void Initialize()
{
if (DesignMode)
{
return;
}
// sanity check
Items.Clear();
// load all pallets from database
foreach (string typeName in PalletData.TypeNames)
{
PalletData palletData = PalletData.GetByName(typeName);
PalletProperties palletProperties = new PalletProperties(null, typeName,
palletData.Dimensions.X, palletData.Dimensions.Y, palletData.Dimensions.Z);
palletProperties.ID.SetNameDesc(typeName, palletData.Description);
palletProperties.Weight = palletData.Weight;
palletProperties.Color = Color.Yellow;
Items.Add(new ItemBaseWrapper(palletProperties));
}
// always select first item
if (Items.Count > 0)
{
SelectedIndex = 0;
}
}
private void OnEditPallets(object sender, EventArgs e)
{
try
{
// get the collection of work sheets
Excel.Sheets sheets = Globals.StackBuilderAddIn.Application.Worksheets;
Excel.Worksheet worksheet = null;
// find the "Pallets" worksheet
try
{
worksheet = (Excel.Worksheet)sheets["Pallets"];
}
catch (System.Runtime.InteropServices.COMException)
{
worksheet = (Excel.Worksheet)sheets.Add();
worksheet.Name = "Pallets";
// modify header
worksheet.get_Range("a" + 1, "a" + 1).Value = "Name";
worksheet.get_Range("b" + 1, "b" + 1).Value = "Description";
worksheet.get_Range("c" + 1, "c" + 1).Value = "Length";
worksheet.get_Range("d" + 1, "d" + 1).Value = "Width";
worksheet.get_Range("e" + 1, "e" + 1).Value = "Height";
worksheet.get_Range("f" + 1, "f" + 1).Value = "Weight";
worksheet.get_Range("g" + 1, "g" + 1).Value = "Form factor";
Excel.Range headerRange = worksheet.get_Range("a" + 1, "g" + 1);
headerRange.Font.Bold = true;
// initialize pallet sheet
string[] palletTypes = PalletData.TypeNames;
int i = 2;
foreach (string typeName in palletTypes)
{
PalletData palletData = PalletData.GetByName(typeName);
worksheet.get_Range("a" + i, "a" + i).Value = palletData.Name;
worksheet.get_Range("b" + i, "b" + i).Value = palletData.Description;
worksheet.get_Range("c" + i, "c" + i).Value = palletData.Length;
worksheet.get_Range("d" + i, "d" + i).Value = palletData.Width;
worksheet.get_Range("e" + i, "e" + i).Value = palletData.Height;
worksheet.get_Range("f" + i, "f" + i).Value = palletData.Weight;
worksheet.get_Range("g" + i, "g" + i).Value = palletData.Name;
++i;
}
// fit column width
worksheet.get_Range("a" + 1, "g" + (i - 1)).Columns.AutoFit();
worksheet.Activate();
}
OnRefreshPallets(sender, e);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void onPalletTypeChanged(object sender, EventArgs e)
{
PalletData palletData = PalletData.GetByName(PalletTypeName);
if (null == palletData)
{
return;
}
// set name / description / length / width / height / weight
PalletName = palletData.Name;
Description = palletData.Description;
PalletLength = UnitsManager.ConvertLengthFrom(palletData.Length, UnitsManager.UnitSystem.UNIT_METRIC1);
PalletWidth = UnitsManager.ConvertLengthFrom(palletData.Width, UnitsManager.UnitSystem.UNIT_METRIC1);
PalletHeight = UnitsManager.ConvertLengthFrom(palletData.Height, UnitsManager.UnitSystem.UNIT_METRIC1);
Weight = UnitsManager.ConvertMassFrom(palletData.Weight, UnitsManager.UnitSystem.UNIT_METRIC1);
PalletColor = palletData.Color;
graphCtrl.Invalidate();
}
