public static bool insert(XmlNode xn)
{
Global.sql = "INSERT INTO rekam_terapi VALUES('" +
xn.SelectSingleNode("id_rm").InnerText + "','" +
xn.SelectSingleNode("id_terapi").InnerText + "')";
return(Global.ExecQuery(Global.sql));
}
public static bool insert(XmlNode xn)
{
Global.sql = "INSERT INTO kondisi_keluar VALUES('" +
xn.SelectSingleNode("id_kondisi").InnerText + "','" +
xn.SelectSingleNode("kondisi").InnerText + "')";
return(Global.ExecQuery(Global.sql));
}
public static bool update(XmlNode xn)
{
Global.sql = "UPDATE kondisi_keluar SET kondisi = '" +
xn.SelectSingleNode("kondisi").InnerText + "' WHERE id_kondisi = '" +
xn.SelectSingleNode("id_kondisi").InnerText + "'";
return(Global.ExecQuery(Global.sql));
}
public static bool update(XmlNode xn)
{
Global.sql = "UPDATE rekam_terapi SET " +
"id_obat = '" + xn.SelectSingleNode("id_obat").InnerText +
"' WHERE id_rm = '" + xn.SelectSingleNode("id_rm").InnerText +
"' AND id_terapi = '" + xn.SelectSingleNode("id_terapi").InnerText + "'";
return(Global.ExecQuery(Global.sql));
}
public static bool update(XmlNode xn)
{
Global.sql = "UPDATE rekam_obat SET " +
"jumlah = " + xn.SelectSingleNode("jumlah").InnerText +
" WHERE id_rm = '" + xn.SelectSingleNode("id_rm").InnerText + "'" +
"AND id_obat = '" + xn.SelectSingleNode("id_obat").InnerText + "'";
return(Global.ExecQuery(Global.sql));
}
public static bool update(XmlNode xn)
{
Global.sql = "UPDATE rekam_medis SET " +
"id_pasien = '" + xn.SelectSingleNode("id_pasien").InnerText +
"', id_reg = '" + xn.SelectSingleNode("id_reg").InnerText +
"', id_kondisi = '" + xn.SelectSingleNode("id_kondisi").InnerText +
"', stole_diastole = " + xn.SelectSingleNode("stole_diastole").InnerText +
", respiratory_rate = " + xn.SelectSingleNode("respiratory_rate").InnerText +
", suhu = " + xn.SelectSingleNode("suhu").InnerText +
", nadi = " + xn.SelectSingleNode("nadi").InnerText +
", berat_badan = " + xn.SelectSingleNode("berat_badan").InnerText +
", tinggi_badan = " + xn.SelectSingleNode("tinggi_badan").InnerText +
", anamnesia = '" + xn.SelectSingleNode("anamnesia").InnerText +
"' WHERE id_rm = '" + xn.SelectSingleNode("id_rm").InnerText + "'";
return(Global.ExecQuery(Global.sql));
}
public static bool insert(XmlNode xn)
{
Global.sql = "INSERT INTO rekam_medis VALUES('" +
xn.SelectSingleNode("id_rm").InnerText + "','" +
xn.SelectSingleNode("id_pasien").InnerText + "','" +
xn.SelectSingleNode("id_reg").InnerText + "','" +
xn.SelectSingleNode("id_kondisi").InnerText + "'," +
xn.SelectSingleNode("stole_diastole").InnerText + "," +
xn.SelectSingleNode("respiratory_rate").InnerText + "," +
xn.SelectSingleNode("suhu").InnerText + "," +
xn.SelectSingleNode("nadi").InnerText + "," +
xn.SelectSingleNode("berat_badan").InnerText + "," +
xn.SelectSingleNode("tinggi_badan").InnerText + ",'" +
xn.SelectSingleNode("anamnesia").InnerText + "','" +
xn.SelectSingleNode("tanggal").InnerText + "')";
return(Global.ExecQuery(Global.sql));
}
public static bool delete(XmlNode xn)
{
Global.sql = "DELETE kondisi_keluar WHERE id_kondisi = '" + xn.SelectSingleNode("id_kondisi").InnerText + "'";
return(Global.ExecQuery(Global.sql));
}
public static bool delete(XmlNode xn)
{
Global.sql = "DELETE rekam_medis WHERE id_rm = '" + xn.SelectSingleNode("id_rm").InnerText + "'";
return(Global.ExecQuery(Global.sql));
}