public void getEquipmentList(string searchByAllFields = "", int inStock = -2, int type = 0) { db db; SQLiteDataReader dbRdr; cEquipment e; equipments.Clear(); string query = "SELECT * FROM equipments "; List <string> wheres = new List <string>(); if (searchByAllFields != "") { wheres.Add(String.Format("(brand || model || color || size || number) like '%{0}%'", searchByAllFields)); } if (inStock != -2) { wheres.Add(String.Format("in_stock >= '{0}'", inStock)); } if (type != 0) { wheres.Add(String.Format("type = '{0}'", type)); } if (wheres.Count > 0) { query += "WHERE " + string.Join(" AND ", wheres.ToArray()); } db = new db(); try { if (!db.dbOpen()) { throw new Exception("Ошибка подключения к БД."); } dbRdr = db.getReader(query); while (dbRdr.Read()) { e = new cEquipment(); e.setEquipment(dbRdr); equipments.Add(e); } dbRdr.Close(); db.dbClose(); } catch (Exception ex) { MessageBox.Show("Ошибка чтения из базы данных: " + ex.Message, "Ошибка базы данных", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { db.dbClose(); } }
public List <cEquipment> getEquipment() { List <cEquipment> equipList = new List <cEquipment>(); db db; SQLiteDataReader dbRdr; cEquipment equip; equipList.Clear(); string query = "SELECT * FROM equipments "; query += "INNER JOIN equioments_in_contract ON equipments.id_equipment = equioments_in_contract.id_equipment "; query += String.Format("WHERE equioments_in_contract.equioment_in_contract = {0} ", equipment_in_contract); db = new db(); try { if (!db.dbOpen()) { throw new Exception("Ошибка подключения к БД."); } dbRdr = db.getReader(query); while (dbRdr.Read()) { equip = new cEquipment(); equip.setEquipment(dbRdr); equipList.Add(equip); } dbRdr.Close(); db.dbClose(); } catch (Exception ex) { MessageBox.Show("Ошибка чтения из базы данных: " + ex.Message, "Ошибка базы данных", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { db.dbClose(); } return(equipList); }