//保存,设定按钮 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(); }