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(); }
private static Prescript convertToPrescript(List <Medicine> medsdb, DataRow dr) { if (dr == null) { return(null); } Prescript p = new Prescript(); p.id = int.Parse(dr["id"].ToString()); p.name = dr["name"].ToString(); string prescriptline = dr["prescript"].ToString(); if (prescriptline == null) { return(null); } string[] medicines = prescriptline.Split(";".ToCharArray()); string[] para; int id; double weight, state; Medicine mmm = new Medicine(); foreach (string x in medicines) { if (x.Length == 0) { continue; } para = x.Split(",".ToCharArray()); id = int.Parse(para[0]); weight = double.Parse(para[1]); state = double.Parse(para[2]); mmm.id = id; id = medsdb.BinarySearch(mmm); if (id == -1) { continue; } p.add(medsdb[id], weight, state); } p.sort(); return(p); }
public int CompareTo(object obj) { if (obj is Prescript) { Prescript p = (Prescript)obj; if (extra) { if (extrascore == p.extrascore) { return(0); } if (extrascore > p.extrascore) { return(1); } return(-1); } return(id - p.id); } return(0); }
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); } } }