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