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