//保存,设定按钮
private void save_Click(object sender, EventArgs e)
{
PatientBasicRepository pbr = new PatientBasicRepository();
//读取目前的信息
newData = new PatientBasic
{
CharNo = StaticPatient.patient.CharNo,
PId = StaticPatient.patient.PId,
Weight = float.Parse(weight.Text),
Height = float.Parse(height.Text),
BirthDate = StaticPatient.patient.BirthDate,
BloodType = StaticPatient.patient.BloodType,
Name = StaticPatient.patient.Name,
Comment = StaticPatient.patient.Comment
};
//保存
pbr.saveOnePatient(newData);
StaticPatient.newComment = newComment.Text.ToString();
//替换目前的内容为更新后的 重新加载
isChanged = false;
StaticPatient.patient.Weight = newData.Weight;
StaticPatient.patient.Height = newData.Height;
//StaticPatient.patient.BirthDate = newData.BirthDate;
//StaticPatient.patient.BloodType = newData.BloodType;
//StaticPatient.patient.Name = newData.Name;
//StaticPatient.patient.Comment = newData.Comment;
LoadData();
}
public List <PatientBasic> selectAllName()
{
List <PatientBasic> list = new List <PatientBasic>();
string cmd = "select name from dzmd.patientbasicdata";
MySqlDataReader sdr = mycom.executeSQLR(cmd);
while (sdr.Read())
{
PatientBasic pb = new PatientBasic();
pb.Name = sdr[0].ToString();
list.Add(pb);
}
close();
return(list);
}
public PatientBasic selectOnePatient(string id)
{
PatientBasic pb = new PatientBasic();
string cmd = "select * from dzmd.patientbasicdata WHERE ChartNo='" + id + "'";
MySqlDataReader sdr = mycom.executeSQLR(cmd);
while (sdr.Read())
{
pb.CharNo = sdr[0].ToString();
pb.PId = sdr[1].ToString();
pb.Name = sdr[2].ToString();
pb.Height = float.Parse(sdr[3].ToString());
pb.Weight = float.Parse(sdr[4].ToString());
pb.BloodType = sdr[5].ToString();
pb.BirthDate = (DateTime)sdr[6];
pb.Comment = sdr[7].ToString();
}
close();
return(pb);
}
public Boolean saveOnePatient(PatientBasic patient)
{
string cmd = "UPDATE patientbasicdata SET";
cmd += " Name='" + patient.Name + "'";
cmd += " ,BodyWeight=" + patient.Weight;
cmd += " ,BodyHeight=" + patient.Height;
cmd += " ,BloodType='" + patient.BloodType + "'";
cmd += " ,BirthDate='" + patient.BirthDate.ToString("yyyy-MM-dd HH:mm:ss") + "'";
cmd += " ,MedicalHistory='" + patient.Comment + "'";
cmd += " WHERE ChartNo='" + patient.CharNo + "'";
cmd += " and PersonalIDNumber='" + patient.PId + "'";
MySqlDataReader sdr = mycom.executeSQLR(cmd);
close();
return(true);
}
public List <PatientBasic> selectAll()
{
List <PatientBasic> list = new List <PatientBasic>();
string cmd = "select * from patientbasicdata";
MySqlDataReader sdr = mycom.executeSQLR(cmd);
while (sdr.Read())
{
PatientBasic pb = new PatientBasic();
pb.CharNo = sdr[0].ToString();
pb.PId = sdr[1].ToString();
pb.Name = sdr[2].ToString();
pb.Height = float.Parse(sdr[3].ToString());
pb.Weight = float.Parse(sdr[4].ToString());
pb.BloodType = sdr[5].ToString();
pb.BirthDate = (DateTime)sdr[6];
pb.Comment = sdr[7].ToString();
list.Add(pb);
}
close();
return(list);
}
//重新获得焦点 更新病人资料
private void MainView_Activated(object sender, EventArgs e)
{
patient = StaticPatient.patient;
BasicDataShow();
}
