public void addData(Medicinedata u)
{
string sql = string.Format("INSERT INTO medicinedata (`MedicineId`,`MedicineName`, `Unit`) VALUES ('"
+ u.MId + "','" + u.MName + "','" + u.Unit + "')");
mycom.executeSQLCUD(sql);
}
private void InsertNewSingleVitalData(string AID, string name, string data, DateTime time)
{
string cmd = "INSERT INTO `dzmd`.`vitalrecord` (`AnesthesiaID`, " +
"`VitalSigns`, `VitalTime`, `VitalDetail`) VALUES ('" +
AID + "', '" + name + "', '" + time.ToString("yyyy-MM-dd HH:mm:ss") +
"', '" + data + "');";
mycom.executeSQLCUD(cmd);
}
public void insertMRecord(AnesthesiaMedicineRecord a)
{
mycom = new sqlBase();
//string sql = string.Format("INSERT INTO anesthesiamedicinerecord (`MedicineID`,`Time`, `ActualAmount`, `FlowRate`) VALUES ('"
// + a.MedicineID + "','" + a.Time + "','" + a.ActualAmount + "','" + a.FlowRate + "')");
string sql = string.Format("INSERT INTO anesthesiamedicinerecord (`MedicineID`,`ActualAmount`,`AnesthesiaType`,`AnesthesiaID`, `StartTime`,`FlowRate`) VALUES ('"
+ a.MedicineID + "','" + a.ActualAmount + "','" + a.AnesthesiaType + "','" + a.AnesthesiaID + "','" + a.StartTime.ToString("yyyy-MM-dd HH:mm:ss") + "','" + a.FlowRate + "')");
mycom.executeSQLCUD(sql);
mycom.closeConnect();
}
//設置停止時間
public void setEndTime(AnesthesiaMedicineRecord a)
{
mycom = new sqlBase();
string sql = "UPDATE anesthesiamedicinerecord SET EndTime = '" + a.EndTime.ToString("yyyy-MM-dd HH:mm:ss") + "' WHERE StartTime = '"
+ a.StartTime.ToString("yyyy-MM-dd HH:mm:ss") + "' AND MedicineID = '" + a.MedicineID + "' AND AnesthesiaID = '" + a.AnesthesiaID + "'";
Console.WriteLine(sql);
mycom.executeSQLCUD(sql);
mycom.closeConnect();
}
//删除药物记录
public void deleteByTime(AnesthesiaMedicineRecord a)
{
mycom = new sqlBase();
string sql;
if (a.AnesthesiaType == 0)
{
sql = "DELETE FROM anesthesiamedicinerecord WHERE StartTime = '" + a.StartTime.ToString("yyyy-MM-dd HH:mm:ss") + "' AND MedicineID = '"
+ a.MedicineID + "' AND AnesthesiaID = '" + a.AnesthesiaID + "'";
}
else
{
sql = "DELETE FROM anesthesiamedicinerecord WHERE StartTime = '" + a.StartTime.ToString("yyyy-MM-dd HH:mm:ss") + "' AND MedicineID = '"
+ a.MedicineID + "' AND AnesthesiaID = '" + a.AnesthesiaID + "' AND ActualAmount = '" + a.ActualAmount + "'";
}
mycom.executeSQLCUD(sql);
mycom.closeConnect();
}
//修改药物记录
public void updateByTime(AnesthesiaMedicineRecord a)
{
mycom = new sqlBase();
string sql;
if (a.AnesthesiaType == 0)
{
sql = "UPDATE anesthesiamedicinerecord SET ActualAmount = '" + a.ActualAmount + "' WHERE StartTime = '" + a.StartTime.ToString("yyyy-MM-dd HH:mm:ss")
+ "' AND MedicineID = '" + a.MedicineID + "' AND AnesthesiaID = '" + a.AnesthesiaID + "'";
}
else
{
sql = "UPDATE anesthesiamedicinerecord SET ActualAmount = '" + a.ActualAmount + "' , FlowRate = '" + a.FlowRate +
"' WHERE StartTime = '" + a.StartTime.ToString("yyyy-MM-dd HH:mm:ss") + "' AND MedicineID = '"
+ a.MedicineID + "' AND AnesthesiaID = '" + a.AnesthesiaID + "'";
}
Console.WriteLine(sql);
mycom.executeSQLCUD(sql);
mycom.closeConnect();
}
