public PatientMedicamentsReportBuilder(ConnectionFactory factory, Config config, Patient patient)
: base(ReportBuilderId.PatientMedicaments)
{
AddDataSource("ReportsDataSet_PatientMedicaments", GetPatientMedicamentsTable(factory, patient.Id));
Insurance insurance;
string insuranceCompanyName = "";
using (GmConnection conn = factory.CreateConnection())
{
AddParameter("PatientName", patient.GetPatientName(conn));
AddParameter("DoctorName", patient.GetDoctorName(conn));
AddParameter("ChiefName", patient.GetChiefName(conn));
AddParameter("Age", patient.GetAgeStr(conn));
insurance = patient.GetInsurance(conn);
if (insurance != null)
{
insuranceCompanyName = insurance.GetInsuranceCompanyName(conn);
}
}
AddParameter("HeadDoctor", config.departmentConfig.headDoctor);
AddParameter("DepartmentName", config.departmentConfig.departmentName);
AddParameter("HospitalName", config.departmentConfig.hospitalName);
DiagnosisInfo di = patient.patientDiagnoses.LatestDiagnosisInfo;
AddParameter("Diagnosis", di.text);
AddParameter("DiagnosisCode", di.code);
AddParameter("AdmissionDate", patient.admissionDate);
AddParameter("DischargeDate", patient.DischargeDateStr);
AddParameter("Duration", patient.Duration);
AddParameter("CaseHistoryNumber", patient.patientData);
AddParameter("InsuranceNumber", insurance != null?insurance.number:"");
AddParameter("InsuranceCompany", insuranceCompanyName);
}
private EMKServise.DiagnosisInfo ConvertDiagnosisInfo(DiagnosisInfo c)
{
if ((object)c != null)
{
EMKServise.DiagnosisInfo edi = new EMKServise.DiagnosisInfo();
if (c.Comment != "")
{
edi.Comment = c.Comment;
}
if (c.DiagnosedDate != DateTime.MinValue)
{
edi.DiagnosedDate = c.DiagnosedDate;
}
edi.DiagnosisChangeReason = c.DiagnosisChangeReason;
edi.DiagnosisStage = c.DiagnosisStage;
edi.IdDiagnosisType = c.IdDiagnosisType;
edi.IdDiseaseType = c.IdDiseaseType;
edi.IdDispensaryState = c.IdDispensaryState;
edi.IdTraumaType = c.IdTraumaType;
edi.MedicalStandard = c.MedicalStandard;
edi.MESImplementationFeature = c.MESImplementationFeature;
edi.MkbCode = c.MkbCode;
return(edi);
}
else
{
return(null);
}
}
public TestDiagnosisInfo(DiagnosisInfo d)
{
if (d != null)
{
info = d;
}
}
static public TestDiagnosisInfo BuildTestMainDiagnosisInfoFromDataBaseData(string idReferral)
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
//опять DiagnosedDateSpecified, что с этим делать?
//ещё есть какой-то idDiagnosisStatus и idLpu, так же idDiagnosisContainer - это не diagnosisType?
string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral + "' AND id_diagnosis_container = '" + complication + "')";
NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection);
using (NpgsqlDataReader diagnosisReader = person.ExecuteReader())
{
while (diagnosisReader.Read())
{
DiagnosisInfo diag = new DiagnosisInfo();
if (diagnosisReader["comment"] != DBNull.Value)
{
diag.Comment = Convert.ToString(diagnosisReader["comment"]);
}
if (diagnosisReader["diagnosis_date"] != DBNull.Value)
{
diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]);
}
TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag);
if (diagnosisReader["id_mkb_code"] != DBNull.Value)
{
tDiag.mkbCode = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(diagnosisReader["id_mkb_code"]));
}
return(tDiag);
}
}
}
return(null);
}
public static List<TestDiagnosisInfo> BuildTestComplicationDiagnosisInfoFromDataBaseData(string idReferral)
{
List<TestDiagnosisInfo> diagnosis = new List<TestDiagnosisInfo>();
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
//опять DiagnosedDateSpecified, что с этим делать?
//ещё есть какой-то idDiagnosisStatus и idLpu, так же idDiagnosisContainer - это не diagnosisType?
string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral + "' AND id_diagnosis_container = '" + complication + "')";
NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection);
using (NpgsqlDataReader diagnosisReader = person.ExecuteReader())
{
while (diagnosisReader.Read())
{
DiagnosisInfo diag = new DiagnosisInfo();
if (diagnosisReader["comment"].ToString() != "")
diag.Comment = Convert.ToString(diagnosisReader["comment"]);
if (diagnosisReader["diagnosis_date"].ToString() != "")
diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]);
TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag);
if (diagnosisReader["id_mkb_code"].ToString() != "")
tDiag.mkbCode = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(diagnosisReader["id_mkb_code"]));
diagnosis.Add(tDiag);
}
}
}
if (diagnosis.Count != 0)
return diagnosis;
else
return null;
}
public TestDiagnosisInfo(DiagnosisInfo r)
{
diagnosisInfo = r;
if (diagnosisInfo.DiagnosisType != null)
diagnosisType = new TestCoding(diagnosisInfo.DiagnosisType);
if (diagnosisInfo.MkbCode != null)
mkbCode = new TestCoding(diagnosisInfo.MkbCode);
}
public void Init(DiagnosisInfo diagnosisInfo)
{
bool idChanged = this.diagnosisInfo.id != diagnosisInfo.id;
this.diagnosisInfo = diagnosisInfo;
textBox.Text = diagnosisInfo;
lblCode.Text = CodeStr();
if (idChanged && OnDiagnosisIdChanged != null)
{
OnDiagnosisIdChanged(null, null);
}
}
public TestDiagnosisInfo(DiagnosisInfo r)
{
diagnosisInfo = r;
if (diagnosisInfo.DiagnosisType != null)
{
diagnosisType = new TestCoding(diagnosisInfo.DiagnosisType);
}
if (diagnosisInfo.MkbCode != null)
{
mkbCode = new TestCoding(diagnosisInfo.MkbCode);
}
}
public void OnSelected()
{
DiagnosisInfo di = patient.LatestDiagnosisInfo;
if (diagnosisId != di.id)
{
using (GmConnection conn = App.CreateConnection())
{
Diagnosis d = di.GetDiagnosis(conn);
if (d != null)
{
hospitalStay = App.DepartmentConfig.GetRecommendedHospitalStay(d);
}
}
diagnosisId = di.id;
}
lblHospitalStay.Text = string.Format("ќриентировочный срок пребывани¤ больного в стационаре {0} койкодней", hospitalStay);
}
static public TestDiagnosisInfo BuildTestMainDiagnosisInfoFromDataBaseData(string idReferral, string idLpu)
{
if (idLpu != "")
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral +
"' AND id_diagnosis_container = '" + complication + "' AND id_lpu = '" +
idLpu + "'";
NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection);
using (NpgsqlDataReader diagnosisReader = person.ExecuteReader())
{
while (diagnosisReader.Read())
{
DiagnosisInfo diag = new DiagnosisInfo();
if (diagnosisReader["comment"] != DBNull.Value)
{
diag.Comment = Convert.ToString(diagnosisReader["comment"]);
}
if (diagnosisReader["diagnosis_date"] != DBNull.Value)
{
diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]);
}
TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag);
if (diagnosisReader["id_diagnosis_status"] != DBNull.Value)
{
tDiag.diagnosisType =
TestCoding.BuildCodingFromDataBaseData(
diagnosisReader["id_diagnosis_status"].ToString());
}
if (diagnosisReader["id_mkb_code"] != DBNull.Value)
{
tDiag.mkbCode =
TestCoding.BuildCodingFromDataBaseData(
Convert.ToString(diagnosisReader["id_mkb_code"]));
}
return(tDiag);
}
}
}
}
return(null);
}
public static TestDiagnosisInfo BuildDiagnosisFromDataBaseDate(string idDiagnosis)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findTD = "SELECT * FROM Diagnosis WHERE IdDiagnosis = '" + idDiagnosis + "'";
SqlCommand TDcommand = new SqlCommand(findTD, connection);
using (SqlDataReader TDReader = TDcommand.ExecuteReader())
{
while (TDReader.Read())
{
DiagnosisInfo d = new DiagnosisInfo();
if (TDReader["Comment"].ToString() != "")
d.Comment = Convert.ToString(TDReader["Comment"]);
if (TDReader["DiagnosedDate"].ToString() != "")
d.DiagnosedDate = Convert.ToDateTime(TDReader["DiagnosedDate"]);
if (TDReader["IdRDiagnosisChangeReason"].ToString() != "")
d.DiagnosisChangeReason = Convert.ToByte(TDReader["IdRDiagnosisChangeReason"]);
if (TDReader["IdDiagnoseStage"].ToString() != "")
d.DiagnosisStage = Convert.ToByte(TDReader["IdDiagnoseStage"]);
if (TDReader["IdDiagnosisType"].ToString() != "")
d.IdDiagnosisType = Convert.ToByte(TDReader["IdDiagnosisType"]);
if (TDReader["IdDiseaseType"].ToString() != "")
d.IdDiseaseType = Convert.ToByte(TDReader["IdDiseaseType"]);
if (TDReader["IdRDispensaryState"].ToString() != "")
d.IdDispensaryState = Convert.ToByte(TDReader["IdRDispensaryState"]);
if (TDReader["IdTraumaType"].ToString() != "")
d.IdTraumaType = Convert.ToByte(TDReader["IdTraumaType"]);
if (TDReader["IdRMedicalStandard"].ToString() != "")
d.MedicalStandard = Convert.ToInt32(TDReader["IdRMedicalStandard"]);
if (TDReader["IdRMESImplementationFeature"].ToString() != "")
d.MESImplementationFeature = Convert.ToByte(TDReader["IdRMESImplementationFeature"]);
if (TDReader["MkbCode"].ToString() != "")
d.MkbCode = Convert.ToString(TDReader["MkbCode"]);
return (new TestDiagnosisInfo(d));
}
}
}
return null;
}
public TestDiagnosisInfo(DiagnosisInfo d)
{
if (d != null)
info = d;
}
public SelectDiagnosisForm(DiagnosisInfo diagnosisInfo)
{
InitializeComponent();
this.diagnosisInfo = diagnosisInfo;
FormUtils.Init(this);
}
public TestDiagnosisInfo(DiagnosisInfo r)
{
diagnosisInfo = r;
diagnosisType = new TestCoding(diagnosisInfo.DiagnosisType);
mkbCode = new TestCoding(diagnosisInfo.MkbCode);
}
public static TestDiagnosisInfo BuildTestMainDiagnosisInfoFromDataBaseData(string idReferral, string idLpu)
{
if (idLpu != "")
{
using (NpgsqlConnection connection = Global.GetSqlConnection())
{
string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral +
"' AND id_diagnosis_container = '" + complication + "' AND id_lpu = '" +
idLpu + "'";
NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection);
using (NpgsqlDataReader diagnosisReader = person.ExecuteReader())
{
while (diagnosisReader.Read())
{
DiagnosisInfo diag = new DiagnosisInfo();
if (diagnosisReader["comment"] != DBNull.Value)
diag.Comment = Convert.ToString(diagnosisReader["comment"]);
if (diagnosisReader["diagnosis_date"] != DBNull.Value)
diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]);
TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag);
if (diagnosisReader["id_diagnosis_status"] != DBNull.Value)
tDiag.diagnosisType =
TestCoding.BuildCodingFromDataBaseData(
diagnosisReader["id_diagnosis_status"].ToString());
if (diagnosisReader["id_mkb_code"] != DBNull.Value)
tDiag.mkbCode =
TestCoding.BuildCodingFromDataBaseData(
Convert.ToString(diagnosisReader["id_mkb_code"]));
return tDiag;
}
}
}
}
return null;
}
public static void Seed(this ModelBuilder modelBuilder)
{
var user1 = new User()
{
UserId = 1,
Name = "Andrey",
Surname = "Solovyev",
BornDate = new DateTime(2000, 04, 03),
PassportData = "2020445765",
Snills = "1234"
};
var user2 = new User()
{
UserId = 2,
Name = "Vasiliy",
Surname = "Sychev",
BornDate = new DateTime(2000, 10, 10),
PassportData = "2020123987",
Snills = "2345"
};
var user3 = new User()
{
UserId = 3,
Name = "Ivan",
Surname = "Tkachenko",
BornDate = new DateTime(2000, 04, 07),
PassportData = "2020234765",
Snills = "3456"
};
var user4 = new User()
{
UserId = 4,
Name = "Ivan",
Surname = "Menshih",
BornDate = new DateTime(2001, 8, 14),
PassportData = "2014456765",
Snills = "4567"
};
var user5 = new User()
{
UserId = 5,
Name = "Lev",
Surname = "Makeev",
BornDate = new DateTime(2000, 07, 24),
PassportData = "2020567123",
Snills = "6789"
};
modelBuilder.Entity <User>().HasData(user1, user2, user3, user4, user5);
var specialty1 = new Specialty()
{
SpecialtyId = 1,
Name = "Endocrinologist"
};
var specilaty2 = new Specialty()
{
SpecialtyId = 2,
Name = "Сardiologist"
};
var specialty3 = new Specialty()
{
SpecialtyId = 3,
Name = "Therapist"
};
var specilaty4 = new Specialty()
{
SpecialtyId = 4,
Name = "Neurologist"
};
modelBuilder.Entity <Specialty>().HasData(specialty1, specilaty2, specialty3, specilaty4);
var doctor1 = new Doctor()
{
DoctorId = 1,
UserId = user1.UserId,
SpecialtyId = specialty1.SpecialtyId,
LicenseNumber = "1111"
};
var doctor2 = new Doctor()
{
DoctorId = 2,
UserId = user2.UserId,
SpecialtyId = specilaty2.SpecialtyId,
LicenseNumber = "2222"
};
var doctor3 = new Doctor()
{
DoctorId = 3,
UserId = user3.UserId,
SpecialtyId = specialty3.SpecialtyId,
LicenseNumber = "3333"
};
modelBuilder.Entity <Doctor>().HasData(doctor1, doctor2, doctor3);
var patient1 = new Patient()
{
PatientId = 1,
Policy = "12321",
UserId = user4.UserId
};
var patient2 = new Patient()
{
PatientId = 2,
Policy = "213214",
UserId = user5.UserId
};
modelBuilder.Entity <Patient>().HasData(patient1, patient2);
var visit1 = new Visit()
{
VisitId = 1,
PatientId = patient1.PatientId,
DoctorId = doctor1.DoctorId,
DateVisit = new DateTime(2021, 02, 02),
Price = 1300
};
var visit2 = new Visit()
{
VisitId = 2,
PatientId = patient1.PatientId,
DoctorId = doctor2.DoctorId,
DateVisit = new DateTime(2021, 01, 20),
Complaint = "Too expensive",
Price = 1000
};
var visit3 = new Visit()
{
VisitId = 3,
PatientId = patient2.PatientId,
DoctorId = doctor1.DoctorId,
DateVisit = new DateTime(2021, 03, 25),
Price = 1200
};
modelBuilder.Entity <Visit>().HasData(visit1, visit2, visit3);
var diagnosis1 = new Diagnosis()
{
DiagnosisId = 1,
Name = "Diabetes",
Description = "Needs careful treatment"
};
var diagnosis2 = new Diagnosis()
{
DiagnosisId = 2,
Name = "Tachycardia",
Description = "Nothing serious, just avoid much coffee"
};
var diagnosis3 = new Diagnosis()
{
DiagnosisId = 3,
Name = "Headache",
Description = "Outflow of blood from the head is disturbed"
};
modelBuilder.Entity <Diagnosis>().HasData(diagnosis1, diagnosis2, diagnosis3);
var diagnosisInfo1 = new DiagnosisInfo()
{
DiagnosisInfoId = 1,
DiagnosisId = diagnosis1.DiagnosisId,
PatientId = patient1.PatientId
};
var diagnosisInfo2 = new DiagnosisInfo()
{
DiagnosisInfoId = 2,
PatientId = patient2.PatientId,
DiagnosisId = diagnosis2.DiagnosisId
};
modelBuilder.Entity <DiagnosisInfo>().HasData(diagnosisInfo1, diagnosisInfo2);
var cabinet1 = new Cabinet()
{
CabinetId = 1,
CabinetNumber = 228
};
var cabinet2 = new Cabinet()
{
CabinetId = 2,
CabinetNumber = 320
};
var cabinet3 = new Cabinet()
{
CabinetId = 3,
CabinetNumber = 223
};
modelBuilder.Entity <Cabinet>().HasData(cabinet1, cabinet2, cabinet3);
var cabinetInfo1 = new CabinetInfo()
{
CabinetInfoId = 1,
CabinetId = cabinet1.CabinetId,
DoctorId = doctor1.DoctorId,
DateStart = new DateTime(2019, 3, 23)/*,
* DateEnd = default*/
};
var cabinetInfo2 = new CabinetInfo()
{
CabinetInfoId = 2,
CabinetId = cabinet2.CabinetId,
DoctorId = doctor2.DoctorId,
DateStart = new DateTime(2015, 6, 12),
DateEnd = new DateTime(2018, 3, 21)
};
var cabinetInfo3 = new CabinetInfo()
{
CabinetInfoId = 3,
CabinetId = cabinet3.CabinetId,
DoctorId = doctor2.DoctorId,
DateStart = new DateTime(2018, 3, 21)/*,
* DateEnd = default*/
};
var cabinetInfo4 = new CabinetInfo()
{
CabinetInfoId = 4,
CabinetId = cabinet2.CabinetId,
DoctorId = doctor3.DoctorId,
DateStart = new DateTime(2018, 3, 21)
};
modelBuilder.Entity <CabinetInfo>().HasData(cabinetInfo1, cabinetInfo2, cabinetInfo3, cabinetInfo4);
}
static public TestDiagnosisInfo BuildDiagnosisFromDataBaseDate(string idDiagnosis)
{
using (SqlConnection connection = Global.GetSqlConnection())
{
string findTD = "SELECT * FROM Diagnosis WHERE IdDiagnosis = '" + idDiagnosis + "'";
SqlCommand TDcommand = new SqlCommand(findTD, connection);
using (SqlDataReader TDReader = TDcommand.ExecuteReader())
{
while (TDReader.Read())
{
DiagnosisInfo d = new DiagnosisInfo();
if (TDReader["Comment"].ToString() != "")
{
d.Comment = Convert.ToString(TDReader["Comment"]);
}
if (TDReader["DiagnosedDate"].ToString() != "")
{
d.DiagnosedDate = Convert.ToDateTime(TDReader["DiagnosedDate"]);
}
if (TDReader["IdRDiagnosisChangeReason"].ToString() != "")
{
d.DiagnosisChangeReason = Convert.ToByte(TDReader["IdRDiagnosisChangeReason"]);
}
if (TDReader["IdDiagnoseStage"].ToString() != "")
{
d.DiagnosisStage = Convert.ToByte(TDReader["IdDiagnoseStage"]);
}
if (TDReader["IdDiagnosisType"].ToString() != "")
{
d.IdDiagnosisType = Convert.ToByte(TDReader["IdDiagnosisType"]);
}
if (TDReader["IdDiseaseType"].ToString() != "")
{
d.IdDiseaseType = Convert.ToByte(TDReader["IdDiseaseType"]);
}
if (TDReader["IdRDispensaryState"].ToString() != "")
{
d.IdDispensaryState = Convert.ToByte(TDReader["IdRDispensaryState"]);
}
if (TDReader["IdTraumaType"].ToString() != "")
{
d.IdTraumaType = Convert.ToByte(TDReader["IdTraumaType"]);
}
if (TDReader["IdRMedicalStandard"].ToString() != "")
{
d.MedicalStandard = Convert.ToInt32(TDReader["IdRMedicalStandard"]);
}
if (TDReader["IdRMESImplementationFeature"].ToString() != "")
{
d.MESImplementationFeature = Convert.ToByte(TDReader["IdRMESImplementationFeature"]);
}
if (TDReader["MkbCode"].ToString() != "")
{
d.MkbCode = Convert.ToString(TDReader["MkbCode"]);
}
return(new TestDiagnosisInfo(d));
}
}
}
return(null);
}
private EMKServise.DiagnosisInfo ConvertDiagnosisInfo(DiagnosisInfo c)
{
if ((object)c != null)
{
EMKServise.DiagnosisInfo edi = new EMKServise.DiagnosisInfo();
if (c.Comment != "")
edi.Comment = c.Comment;
if (c.DiagnosedDate != DateTime.MinValue)
edi.DiagnosedDate = c.DiagnosedDate;
edi.DiagnosisChangeReason = c.DiagnosisChangeReason;
edi.DiagnosisStage = c.DiagnosisStage;
edi.IdDiagnosisType = c.IdDiagnosisType;
edi.IdDiseaseType = c.IdDiseaseType;
edi.IdDispensaryState = c.IdDispensaryState;
edi.IdTraumaType = c.IdTraumaType;
edi.MedicalStandard = c.MedicalStandard;
edi.MESImplementationFeature = c.MESImplementationFeature;
edi.MkbCode = c.MkbCode;
return edi;
}
else
return null;
}
//得到诊断信息 LY 2015-10-10
public List <DiagnosisInfo> PsDiagnosisGetDiagnosisInfo(DataConnection pclsCache, string UserId, string VisitId)
{
List <DiagnosisInfo> list = new List <DiagnosisInfo>();
CacheCommand cmd = null;
CacheDataReader cdr = null;
try
{
if (!pclsCache.Connect())
{
return(null);
}
cmd = new CacheCommand();
cmd = Ps.Diagnosis.GetDiagnosisInfo(pclsCache.CacheConnectionObject);
cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId;
cmd.Parameters.Add("VisitId", CacheDbType.NVarChar).Value = VisitId;
cdr = cmd.ExecuteReader();
while (cdr.Read())
{
string RecordDateShow = "";
string str1 = cdr["RecordDate"].ToString();
if (str1 != "")
{
RecordDateShow = str1.Substring(0, 4) + "-" + str1.Substring(4, 2) + "-" + str1.Substring(6, 2);
}
DiagnosisInfo NewLine = new DiagnosisInfo();
NewLine.VisitId = cdr["VisitId"].ToString();
NewLine.DiagnosisType = cdr["DiagnosisType"].ToString();
NewLine.DiagnosisTypeName = cdr["DiagnosisTypeName"].ToString();
NewLine.DiagnosisNo = cdr["DiagnosisNo"].ToString();
NewLine.Type = cdr["Type"].ToString();
NewLine.TypeName = cdr["TypeName"].ToString();
NewLine.DiagnosisCode = cdr["DiagnosisCode"].ToString();
NewLine.DiagnosisName = cdr["DiagnosisName"].ToString();
NewLine.Description = cdr["Description"].ToString();
NewLine.RecordDate = cdr["RecordDate"].ToString();
NewLine.RecordDateShow = RecordDateShow;
NewLine.Creator = cdr["Creator"].ToString();
NewLine.RecordDateCom = Convert.ToDateTime(cdr["RecordDate"]).ToString("yyyy-MM-dd HH:mm:ss");
list.Add(NewLine);
}
return(list);
}
catch (Exception ex)
{
HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Diagnosis.GetDiagnosisInfo", "数据库操作异常！ error information : " + ex.Message + Environment.NewLine + ex.StackTrace);
return(null);
}
finally
{
if ((cdr != null))
{
cdr.Close();
cdr.Dispose(true);
cdr = null;
}
if ((cmd != null))
{
cmd.Parameters.Clear();
cmd.Dispose();
cmd = null;
}
pclsCache.DisConnect();
}
}
public TestDiagnosisInfo(DiagnosisInfo r)
{
diagnosisInfo = r;
diagnosisType = new TestCoding(diagnosisInfo.DiagnosisType);
mkbCode = new TestCoding(diagnosisInfo.MkbCode);
}
