public static void updatePrescript(Prescript p)
{
db.open(prescriptDBName);
db.prepare("update [prescript] set [name]=@name,[prescript]=@script where [id]=@id");
db.setup(DbType.String, "name", p.name);
db.setup(DbType.String, "script", p.toPrescriptString());
db.setup(DbType.Int32, "id", p.id);
db.update();
db.close();
}
public static void addPrescript(List <Prescript> plist, Prescript p)
{
int index = plist.BinarySearch(p);
if (index < 0)
{
db.open(prescriptDBName);
db.prepare("insert into [prescript] values (null,'"
+ p.name + "','" + p.toPrescriptString() + "')");
db.update();
db.prepare("select last_insert_rowid()");
DataTable dt = db.query();
db.close();
if (dt.Rows.Count > 0)
{
int lastid = int.Parse(dt.Rows[0][0].ToString());
p.id = lastid;
//plist.Add(p);
}
}
}
