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