private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == dataGridView1.Columns["edit_column"].Index)
{
string intID = dataGridView1.Rows[e.RowIndex].Cells[2].Value.ToString() + "|" + dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString();
PatientMedicalRecord myform = new PatientMedicalRecord(intID);
myform.MdiParent = this.ParentForm;
myform.WindowState = FormWindowState.Maximized;
myform.Show();
this.Close();
}
}
private void medicalRecordToolStripMenuItem_Click(object sender, EventArgs e)
{
if (ActiveMdiChild != null)
{
ActiveMdiChild.Close();
}
PatientMedicalRecord newMDIChild = new PatientMedicalRecord(string.Empty);
newMDIChild.MdiParent = this;
newMDIChild.MaximizeBox = false;
newMDIChild.WindowState = FormWindowState.Maximized;
newMDIChild.Show();
}
public string GetPatientMedicalRecords(string requestXml)
{
string doc;
try
{
Request request = RequestHelper.GetRequest(requestXml);
PatientMedicalRecordBll patientMedicalRecordBll = new PatientMedicalRecordBll();
PatientMedicalRecord patientMedicalRecord = patientMedicalRecordBll.GetPatientMedicalRecord(request);
if (patientMedicalRecord is null)
{
XDocument xDoc = new XDocument
(
new XDeclaration("1.0", "utf-8", "yes"),
new XElement
(
"response",
new XElement("resultCode", 1),
new XElement("resultMsg", "未能查询到患者门诊病历!"),
new XElement("resultContent")
)
);
doc = xDoc.ToString();
}
else
{
doc = patientMedicalRecordBll.ConvertPatientMedicalRecordToXml(patientMedicalRecord);
}
}
catch (Exception)
{
XDocument xDoc = new XDocument
(
new XDeclaration("1.0", "utf-8", "yes"),
new XElement
(
"response",
new XElement("resultCode", 1),
new XElement("resultMsg", "系统出现内部错误!"),
new XElement("resultContent")
)
);
doc = xDoc.ToString();
return(doc);
}
return(doc);
}
public string ConvertPatientMedicalRecordToXml(PatientMedicalRecord patientMedicalRecord)
{
//XmlDocument xmlDoc = new XmlDocument();
XDocument xDoc = new XDocument
(
new XDeclaration("1.0", "utf-8", "yes"),
new XElement
(
"response",
new XElement("resultCode", 0),
new XElement("resultMsg", "获取患者门诊病历成功!"),
new XElement
(
"resultContent",
new XElement("hospitalId", patientMedicalRecord.HospitalId),
new XElement("hospitalName", patientMedicalRecord.HospitalName),
new XElement("medicalCardNo", patientMedicalRecord.MedicalCardNo),
new XElement("outPatientNo", patientMedicalRecord.OutPatientNo),
new XElement("patientName", patientMedicalRecord.PatientName),
new XElement("identCard", patientMedicalRecord.IdentCard),
new XElement("genderValue", patientMedicalRecord.GenderValue),
new XElement("patientAge", patientMedicalRecord.PatientAge),
new XElement("clinicTime", patientMedicalRecord.ClinicTime),
new XElement("clinicDepartments", patientMedicalRecord.ClinicDepartments),
new XElement("actionInChief", patientMedicalRecord.ActionInChief),
new XElement("hisPresentIllness", patientMedicalRecord.HisPresentIllness),
new XElement("pastHistory", patientMedicalRecord.PastHistory),
new XElement("personalHistory", patientMedicalRecord.PersonalHistory),
new XElement("allergicHistory", patientMedicalRecord.AllergicHistory),
new XElement("familyHistory", patientMedicalRecord.FamilyHistory),
new XElement("physicalExamination", patientMedicalRecord.PhysicalExamination),
new XElement("auxiliaryExaminations", patientMedicalRecord.AuxiliaryExaminations),
new XElement("preliminaryJudgment", patientMedicalRecord.PreliminaryJudgment),
new XElement("other1", patientMedicalRecord.Other1),
new XElement("other2", patientMedicalRecord.Other2),
new XElement("other3", patientMedicalRecord.Other3),
new XElement("other4", patientMedicalRecord.Other4),
new XElement("other5", patientMedicalRecord.Other5),
new XElement("pid", patientMedicalRecord.PID),
new XElement("dzjkNo", patientMedicalRecord.DzjkNo)
)
)
);
//xmlDoc.LoadXml(xDoc.ToString());
return(xDoc.ToString());
}
public void addPatientMedicalRecord()
{
PatientMedicalRecord _PatientMedicalRecord = new PatientMedicalRecord
{
PatientID = 12,
DocumentCategoryID = 2,
DocumentTypeID = 40,
PatMRDocumentDate = System.DateTime.Now,
PatMRDocumentName = "Testing.pdf",
PatMRPageStart = 2,
PatMRPageEnd = 4
};
var _id = _patientRepository.addPatientMedicalRecords(_PatientMedicalRecord);
Assert.IsTrue(_id > 0, "failed");
}
public PatientMedicalRecord GetPatientMedicalRecord(Request request)
{
string sqlMzsf = $"select top 1 * from (select 病人姓名,门诊号,卡号,日期,医疗保险号,医保 from 门诊收费流水帐 union select 病人姓名,门诊号,卡号,日期,医疗保险号,医保 from 门诊收费) as MZSF where 卡号='{request.OutPatientNo}' order by 日期 desc";
string sqlGh = $"select top 1 * from (select 卡号,门诊号,姓名,出生日期,年龄,性别,民族,身份证,婚姻,职业,通信地址,电话 from 门诊挂号流水帐 union select 卡号,门诊号,姓名,出生日期,年龄,性别,民族,身份证,婚姻,职业,通信地址,电话 from 门诊挂号) as GH where 卡号='{request.OutPatientNo}'";
string sqlMzbl = $"select top 1 卡号,门诊号,时间,过敏史,主诉,现病史,既往史,望闻问切,西医诊断,中医诊断,处理,体检,病程,建议 from MZ_BL where 卡号='{request.OutPatientNo}' order by 时间 desc";
DataTable dtMzsf = SqlCommon.ExecuteSqlToDataSet(SqlCommon.GetConnectionStringFromConnectionStrings("HisConnectionString"), sqlMzsf).Tables[0];
DataTable dtGh = SqlCommon.ExecuteSqlToDataSet(SqlCommon.GetConnectionStringFromConnectionStrings("GHConnectionString"), sqlGh).Tables[0];
DataTable dtMzbl = SqlCommon.ExecuteSqlToDataSet(SqlCommon.GetConnectionStringFromConnectionStrings("HisConnectionString"), sqlMzbl).Tables[0];
if (dtMzsf != null && dtMzsf.Rows.Count > 0 && dtGh != null && dtGh.Rows.Count > 0)
{
PatientMedicalRecord patientMedicalRecord = new PatientMedicalRecord
{
HospitalId = ConfigurationManager.AppSettings["HospitalId"],
HospitalName = ConfigurationManager.AppSettings["HospitalName"],
MedicalCardNo = dtMzsf.Rows[0]["卡号"].ToString(),
OutPatientNo = dtMzsf.Rows[0]["卡号"].ToString(),
PatientName = dtGh.Rows[0]["姓名"].ToString(),
IdentCard = dtGh.Rows[0]["身份证"].ToString(),
GenderValue = dtGh.Rows[0]["性别"].ToString() == "男" ? "1" : "0",
PatientAge = dtGh.Rows[0]["年龄"].ToString(),
ClinicTime = Convert.ToDateTime(dtMzsf.Rows[0]["日期"]).ToString("yyyy-MM-dd"),
ClinicDepartments = "暂无",
ActionInChief = dtMzbl != null && dtMzbl.Rows.Count > 0 && dtMzbl.Rows[0]["主诉"].ToString() != "" ? dtMzbl.Rows[0]["主诉"].ToString() : "暂无",
HisPresentIllness = dtMzbl != null && dtMzbl.Rows.Count > 0 && dtMzbl.Rows[0]["现病史"].ToString() != "" ? dtMzbl.Rows[0]["现病史"].ToString() : "暂无",
PastHistory = "暂无",
PersonalHistory = "暂无",
AllergicHistory = "暂无",
FamilyHistory = "暂无",
PhysicalExamination = "暂无",
AuxiliaryExaminations = "暂无",
PreliminaryJudgment = dtMzbl != null && dtMzbl.Rows.Count > 0 && dtMzbl.Rows[0]["西医诊断"].ToString() != "" ? dtMzbl.Rows[0]["西医诊断"].ToString() : "暂无",
Other1 = null,
Other2 = null,
Other3 = null,
Other4 = null,
Other5 = null,
PID = dtMzsf.Rows[0]["卡号"].ToString(),
DzjkNo = null
};
string startDate = Convert.ToDateTime(dtMzsf.Rows[0]["日期"]).ToString("yyyy-MM-dd") + " 00:00:00";
string endDate = Convert.ToDateTime(dtMzsf.Rows[0]["日期"]).ToString("yyyy-MM-dd") + " 23:59:59";
string sqlMzhj = $"select * from (select 发票流水号,日期,卡号,病人姓名,科室ID,医师,YF_ID,名称,单位,数量,用法,用量 from 划价临时库 where 科室ID<>0 and 发票流水号<>'-1' union select 发票流水号,日期,卡号,病人姓名,科室ID,医师,YF_ID,名称,单位,数量,用法,用量 from 划价流水帐 where 科室ID<>0 and 发票流水号<>'-1') as Mzhj where 卡号='{dtMzsf.Rows[0]["卡号"].ToString()}' and 日期 between '{startDate}' and '{endDate}'";
DataTable dtMzhj = SqlCommon.ExecuteSqlToDataSet(SqlCommon.GetConnectionStringFromConnectionStrings("HisConnectionString"), sqlMzhj).Tables[0];
if (dtMzhj != null && dtMzhj.Rows.Count > 0)
{
string sqlDoc = $"select id,医师代码,医师姓名,所在科室,挂号科室,划价号 from 医师代码 where 医师姓名='{dtMzhj.Rows[0]["医师"].ToString()}'";
DataTable dtDoc = SqlCommon.ExecuteSqlToDataSet(SqlCommon.GetConnectionStringFromConnectionStrings("HisConnectionString"), sqlDoc).Tables[0];
patientMedicalRecord.ClinicDepartments = dtDoc != null && dtDoc.Rows.Count > 0 ? dtDoc.Rows[0]["所在科室"].ToString() : null;
}
return(patientMedicalRecord);
}
else
{
return(null);
}
}
public int updatePatientMedicalRecordsForMedicalRec(PatientMedicalRecord _medicalRecord)
{
return(_patientRepository.updatePatientMedicalRecordsForMedicalRec(Mapper.Map <DTO.PatientMedicalRecord, MMC.Core.Data.Model.PatientMedicalRecord>(_medicalRecord)));
}
public int updatePatientMedicalRecordsForMedicalRec(PatientMedicalRecord _medicalRecord)
{
return(_patientMedicalRecord.Update(_medicalRecord, hp => hp.DocumentTypeID, hp => hp.PatMRDocumentName, hp => hp.PatMRDocumentDate, hp => hp.PatMRSummary));
}
public int updatePatientMedicalRecords(PatientMedicalRecord _medicalRecord)
{
return(_patientMedicalRecord.Update(_medicalRecord));
}
public int addPatientMedicalRecords(PatientMedicalRecord _medicalRecord)
{
return(_patientMedicalRecord.Add(_medicalRecord).PatientMedicalRecordID);
}
