public List <vech> getAllVechs()
{
List <vech> li = new List <vech>();
SQLiteCommand cmd = new SQLiteCommand(m_con);
cmd.CommandText = "select * from detail";
SQLiteDataReader dr = cmd.ExecuteReader();
StringBuilder sb = new StringBuilder();
while (dr.Read())
{
vech one = new vech();
one.typeName = dr.GetString(0);
one.number = dr.GetString(1);
one.status = dr.GetString(2);
li.Add(one);
}
return(li);
}
public void deleteVech(vech one)
{
string str = "delete from detail where typename=" + "'" + one.typeName + "' and number ='" + one.number + "'";
excuteCommand(str);
}
public void updateVech(vech one)
{
string str = "update detail set status ='" + one.status + "' where typeName=" + "'" + one.typeName + "' and number ='" + one.number + "'";
excuteCommand(str);
}
public void insertVech(vech one)
{
string str = "insert into detail (typeName, number, status) values ('" + one.typeName + "', '" + one.number + "', '" + one.status + "')";
excuteCommand(str);
}
