public static void Del(TbExecutablePathEntity entity)
{
var db = new TbExecutablePath();
db.Open();
db.ExeSQL(string.Format("delete from {0} where name='{1}'", db.TB_EXE_PATH, entity.name));
db.Close();
}
public static void UpdateOrAdd(TbExecutablePathEntity entity)
{
Del(entity);
var db = new TbExecutablePath();
db.Open();
db.ExeSQL(string.Format("insert into {0} (name,path) values('{1}','{2}')", db.TB_EXE_PATH, entity.name, entity.path));
db.Close();
}
public static List <TbExecutablePathEntity> GetAll()
{
var db = new TbExecutablePath();
db.Open();
var rd = db.ExeQuerySQL(string.Format("select name,path from {0}", db.TB_EXE_PATH));
var list = new List <TbExecutablePathEntity>();
while (rd.Read())
{
list.Add(new TbExecutablePathEntity(rd.GetString(0), rd.GetString(1)));
}
db.Close();
return(list);
}