/// <summary>Переход на другое элемент</summary> /// <param name="sender">Кнопка</param> private void button_click(object sender) { Button button = ((Button)sender); string command = string.Format("SELECT {0},{1} FROM {2} WHERE {3}=@Id", dbObject.BARCODE_NAME, dbObject.IDENTIFIER_NAME, button.Name, dbObject.IDENTIFIER_NAME); List <object> values = null; using (SqlCeCommand query = dbWorker.NewQuery(command)) { query.AddParameter("Id", button.Tag); values = query.SelectToList(); } if (values != null && values.Count == 2 && values[0] != null) { string barcode = values[0].ToString().TrimEnd(); if (!string.IsNullOrEmpty(barcode)) { showInfoByBarcode(barcode); } else { long id = values[1] != null?Convert.ToInt64(values[1]) : 0; TypeOfAccessories typeOfAccessories = button.Name == typeof(Lamps).Name ? TypeOfAccessories.Lamp : TypeOfAccessories.ElectronicUnit; showInfoById(id, typeOfAccessories); } } }
private List <object> getFilledPosition() { using (SqlCeCommand query = dbWorker.NewQuery("SELECT c.Position FROM Cases c WHERE c.Map=@Map AND c.Register=@Register")) { query.AddParameter("Map", MapInfo.Id); query.AddParameter("Register", Register); return(query.SelectToList()); } }