string oldName = string.Empty; //用于保存上部操作的人的姓名 /// <summary> /// 进行保存操作 /// </summary> /// <param name="configEmrPoint"></param> /// <returns></returns> private bool SaveData(PatientEntity m_patientInfo) { try { DataManager dtmanager = new DataManager(m_app, "", ""); DataRow foucesRow = gViewBabyInfo.GetDataRow(gViewBabyInfo.FocusedRowHandle); string noofinpat = string.Empty; if (foucesRow != null) { noofinpat = foucesRow["NOOFINPAT"].ToString(); } //string mnoofinpat = foucesRow["MNOOFINPAT"].ToString(); string mnoofinpat = MNoOfPat; if (mnoofinpat == "") { mnoofinpat = foucesRow["MNOOFINPAT"].ToString(); //m_app.CustomMessageBox.MessageShow("请先选择母亲"); //return false; } string edittype = ""; if (m_EditState == EditState.Add) { edittype = "1"; } else { edittype = "2"; } //此处加进编辑过的病人数组中 add ywk EditedPats.Add(mnoofinpat); dtmanager.SaveData(m_patientInfo, edittype, Int32.Parse(noofinpat == "" ? "0" : noofinpat)); ////处理婴儿个数,和上面分开 //int BabyCount= #region "插入入院状态(三测单显示) --- 已弃用(cyq 2012-08-16)" //PatStateEntity patStateEn = new PatStateEntity(); //patStateEn.CCODE = "7008";//状态编号 //patStateEn.DOTIME = m_patientInfo.Birth; //patStateEn.PATID = dtmanager.GetNoofInpatByPatID(m_patientInfo.PatID); //MethodSet.SaveStateData(patStateEn, "1"); #endregion return(true); } catch (Exception e) { return(false); } }
/// <summary> /// 将实体值赋给页面元素 /// </summary> /// <param name="configEmrPoint"></param> private void SetPageValue(PatientEntity patientEntity) { if (patientEntity == null) { return; } txtAge.Text = patientEntity.AgeStr.ToString(); txtName.Text = patientEntity.Name; lueSex.CodeValue = patientEntity.SexID; //deBirth.Text = patientEntity.Birth; deBirth.DateTime = Convert.ToDateTime(patientEntity.Birth); teAdmitDate.Time = Convert.ToDateTime(patientEntity.Birth); }
/// <summary> /// 将grid中的值赋值给实体 /// </summary> /// <param name="foucesRow"></param> /// <returns></returns> private PatientEntity SetEntityByDataRow(DataRow foucesRow) { PatientEntity m_patientInfo = new PatientEntity(); if (foucesRow == null) { return(null); } m_patientInfo.Name = foucesRow["Name"].ToString(); m_patientInfo.Age = Int32.Parse(foucesRow["Age"].ToString()); m_patientInfo.AgeStr = foucesRow["AgeStr"].ToString(); m_patientInfo.Birth = foucesRow["birth"].ToString(); m_patientInfo.SexID = foucesRow["SexID"].ToString(); return(m_patientInfo); }
/// <summary> /// 设定婴儿中的保存操作(含编辑和新增操作 ) /// </summary> /// <param name="m_patientInfo"></param> /// <param name="edittype"></param> public void SaveData(PatientEntity m_patientInfo, string edittype, int noofipat) { SqlParameter parNoofInpat = new SqlParameter("@Noofinpat", SqlDbType.Int, 14); parNoofInpat.Value = noofipat; SqlParameter parPatNoOfHis = new SqlParameter("@patnoofhis", SqlDbType.VarChar, 14); parPatNoOfHis.Value = m_patientInfo.PatNoOfHis; SqlParameter parNoofclinic = new SqlParameter("@Noofclinic", SqlDbType.VarChar, 32); parNoofclinic.Value = m_patientInfo.NoOfcClinic; SqlParameter parNoofrecord = new SqlParameter("@Noofrecord", SqlDbType.VarChar, 32); parNoofrecord.Value = m_patientInfo.NoOfRecord; SqlParameter parpatid = new SqlParameter("@patid", SqlDbType.VarChar, 32); parpatid.Value = m_patientInfo.PatID; SqlParameter parInnerpix = new SqlParameter("@Innerpix", SqlDbType.VarChar, 32); parInnerpix.Value = m_patientInfo.INNERPIX; SqlParameter paroutpix = new SqlParameter("@outpix", SqlDbType.VarChar, 32); paroutpix.Value = m_patientInfo.OUTPIX; SqlParameter parName = new SqlParameter("@Name", SqlDbType.VarChar, 32); parName.Value = m_patientInfo.Name; SqlParameter parpy = new SqlParameter("@py", SqlDbType.VarChar, 8); parpy.Value = m_patientInfo.PY; SqlParameter parwb = new SqlParameter("@wb", SqlDbType.VarChar, 8); parwb.Value = m_patientInfo.WB; SqlParameter parPayid = new SqlParameter("@payid", SqlDbType.VarChar, 4); parPayid.Value = m_patientInfo.PayID; SqlParameter parORIGIN = new SqlParameter("@ORIGIN", SqlDbType.VarChar, 4); parORIGIN.Value = m_patientInfo.ORIGIN; SqlParameter parInCount = new SqlParameter("@InCount", SqlDbType.Int); parInCount.Value = m_patientInfo.InCount; SqlParameter parSexID = new SqlParameter("@sexid", SqlDbType.VarChar, 4); parSexID.Value = m_patientInfo.SexID; SqlParameter parBirth = new SqlParameter("@Birth", SqlDbType.VarChar, 19); parBirth.Value = m_patientInfo.Birth; SqlParameter parAge = new SqlParameter("@Age", SqlDbType.Int); parAge.Value = m_patientInfo.Age; SqlParameter parAgeStr = new SqlParameter("@AgeStr", SqlDbType.VarChar, 16); parAgeStr.Value = m_patientInfo.AgeStr; SqlParameter parIDNO = new SqlParameter("@IDNO", SqlDbType.VarChar, 18); parIDNO.Value = m_patientInfo.IDNO; SqlParameter parMarital = new SqlParameter("@Marital", SqlDbType.VarChar, 12); parMarital.Value = m_patientInfo.Marital; SqlParameter parJobID = new SqlParameter("@JobID", SqlDbType.VarChar, 4); parJobID.Value = m_patientInfo.JobID; SqlParameter parCSDProvinceID = new SqlParameter("@CSDProvinceID", SqlDbType.VarChar, 14); parCSDProvinceID.Value = m_patientInfo.CSD_ProvinceID; SqlParameter parCSDCityID = new SqlParameter("@CSDCityID", SqlDbType.VarChar, 14); parCSDCityID.Value = m_patientInfo.CSD_CityID; SqlParameter parCSDDistrictID = new SqlParameter("@CSDDistrictID", SqlDbType.VarChar, 14); parCSDDistrictID.Value = m_patientInfo.CSD_DistrictID; SqlParameter parNationID = new SqlParameter("@NationID", SqlDbType.VarChar, 14); parNationID.Value = m_patientInfo.NationID; SqlParameter parNationalityID = new SqlParameter("@NationalityID", SqlDbType.VarChar, 14); parNationalityID.Value = m_patientInfo.NationalityID; SqlParameter parJGProvinceID = new SqlParameter("@JGProvinceID", SqlDbType.VarChar, 14); parJGProvinceID.Value = m_patientInfo.JG_ProvinceID; SqlParameter parJGCityID = new SqlParameter("@JGCityID", SqlDbType.VarChar, 14); parJGCityID.Value = m_patientInfo.JG_CityID; SqlParameter parOrganization = new SqlParameter("@Organization", SqlDbType.VarChar, 64); parOrganization.Value = m_patientInfo.Organization; SqlParameter parOfficePlace = new SqlParameter("@OfficePlace", SqlDbType.VarChar, 64); parOfficePlace.Value = m_patientInfo.OfficePlace; SqlParameter parOfficeTEL = new SqlParameter("@OfficeTEL", SqlDbType.VarChar, 16); parOfficeTEL.Value = m_patientInfo.OfficeTEL; SqlParameter parOfficePost = new SqlParameter("@OfficePost", SqlDbType.VarChar, 16); parOfficePost.Value = m_patientInfo.OfficePost; SqlParameter parHKDZProvinceID = new SqlParameter("@HKDZProvinceID", SqlDbType.VarChar, 14); parHKDZProvinceID.Value = m_patientInfo.HKDZ_ProvinceID; SqlParameter parHKDZCityID = new SqlParameter("@HKDZCityID", SqlDbType.VarChar, 14); parHKDZCityID.Value = m_patientInfo.HKDZ_CityID; SqlParameter parHKDZDistrictID = new SqlParameter("@HKDZDistrictID", SqlDbType.VarChar, 14); parHKDZDistrictID.Value = m_patientInfo.HKDZ_DistrictID; SqlParameter parNATIVEPOST = new SqlParameter("@NATIVEPOST", SqlDbType.VarChar, 16); parNATIVEPOST.Value = m_patientInfo.NATIVEPOST; SqlParameter parNATIVETEL = new SqlParameter("@NATIVETEL", SqlDbType.VarChar, 16); parNATIVETEL.Value = m_patientInfo.NATIVETEL; SqlParameter parNATIVEADDRESS = new SqlParameter("@NATIVEADDRESS", SqlDbType.VarChar, 64); parNATIVEADDRESS.Value = m_patientInfo.NATIVEADDRESS; SqlParameter parADDRESS = new SqlParameter("@ADDRESS", SqlDbType.VarChar, 255); parADDRESS.Value = m_patientInfo.ADDRESS; SqlParameter parContactPerson = new SqlParameter("@ContactPerson", SqlDbType.VarChar, 32); parContactPerson.Value = m_patientInfo.ContactPerson; SqlParameter parRelationshipID = new SqlParameter("@RelationshipID", SqlDbType.VarChar, 14); parRelationshipID.Value = m_patientInfo.RelationshipID; SqlParameter parContactAddress = new SqlParameter("@ContactAddress", SqlDbType.VarChar, 255); parContactAddress.Value = m_patientInfo.ContactAddress; SqlParameter parContactTEL = new SqlParameter("@ContactTEL", SqlDbType.VarChar, 16); parContactTEL.Value = m_patientInfo.ContactTEL; SqlParameter parCONTACTOFFICE = new SqlParameter("@CONTACTOFFICE", SqlDbType.VarChar, 64); parCONTACTOFFICE.Value = m_patientInfo.CONTACTOFFICE; SqlParameter parCONTACTPOST = new SqlParameter("@CONTACTPOST", SqlDbType.VarChar, 16); parCONTACTPOST.Value = m_patientInfo.CONTACTPOST; SqlParameter parOFFERER = new SqlParameter("@OFFERER", SqlDbType.VarChar, 64); parOFFERER.Value = m_patientInfo.OFFERER; SqlParameter parSocialCare = new SqlParameter("@SocialCare", SqlDbType.VarChar, 14); parSocialCare.Value = m_patientInfo.SocialCare; SqlParameter parINSURANCE = new SqlParameter("@INSURANCE", SqlDbType.VarChar, 32); parINSURANCE.Value = m_patientInfo.INSURANCE; SqlParameter parCARDNO = new SqlParameter("@CARDNO", SqlDbType.VarChar, 32); parCARDNO.Value = m_patientInfo.CARDNO; SqlParameter parADMITINFO = new SqlParameter("@ADMITINFO", SqlDbType.VarChar, 14); parADMITINFO.Value = m_patientInfo.ADMITINFO; SqlParameter parAdmitDeptID = new SqlParameter("@AdmitDeptID", SqlDbType.VarChar, 14); parAdmitDeptID.Value = m_patientInfo.AdmitDeptID; SqlParameter parAdmitWardID = new SqlParameter("@AdmitWardID", SqlDbType.VarChar, 14); parAdmitWardID.Value = m_patientInfo.AdmitWardID; SqlParameter parADMITBED = new SqlParameter("@ADMITBED", SqlDbType.VarChar, 14); parADMITBED.Value = m_patientInfo.ADMITBED; SqlParameter parAdmitDate = new SqlParameter("@AdmitDate", SqlDbType.VarChar, 19); parAdmitDate.Value = m_patientInfo.AdmitDate; SqlParameter parINWARDDATE = new SqlParameter("@INWARDDATE", SqlDbType.VarChar, 19); parINWARDDATE.Value = m_patientInfo.INWARDDATE; SqlParameter parADMITDIAGNOSIS = new SqlParameter("@ADMITDIAGNOSIS", SqlDbType.VarChar, 14); parADMITDIAGNOSIS.Value = m_patientInfo.ADMITDIAGNOSIS; SqlParameter parOutWardDate = new SqlParameter("@OutWardDate", SqlDbType.VarChar, 19); parOutWardDate.Value = m_patientInfo.OutWardDate; SqlParameter parOutHosDeptID = new SqlParameter("@OutHosDeptID", SqlDbType.VarChar, 14); parOutHosDeptID.Value = m_patientInfo.OutHosDeptID; SqlParameter parOutHosWardID = new SqlParameter("@OutHosWardID", SqlDbType.VarChar, 14); parOutHosWardID.Value = m_patientInfo.OutHosWardID; SqlParameter parOutBed = new SqlParameter("@OutBed", SqlDbType.VarChar, 14); parOutBed.Value = m_patientInfo.OutBed; SqlParameter parOUTHOSDATE = new SqlParameter("@OUTHOSDATE", SqlDbType.VarChar, 19); parOUTHOSDATE.Value = m_patientInfo.OUTHOSDATE; SqlParameter parOUTDIAGNOSIS = new SqlParameter("@OUTDIAGNOSIS", SqlDbType.VarChar, 14); parOUTDIAGNOSIS.Value = m_patientInfo.OUTDIAGNOSIS; SqlParameter parTOTALDAYS = new SqlParameter("@TOTALDAYS", SqlDbType.Int); parTOTALDAYS.Value = m_patientInfo.TOTALDAYS; SqlParameter parCLINICDIAGNOSIS = new SqlParameter("@CLINICDIAGNOSIS", SqlDbType.VarChar, 14); parCLINICDIAGNOSIS.Value = m_patientInfo.CLINICDIAGNOSIS; SqlParameter parSOLARTERMS = new SqlParameter("@SOLARTERMS", SqlDbType.VarChar, 16); parSOLARTERMS.Value = m_patientInfo.SOLARTERMS; SqlParameter parADMITWAY = new SqlParameter("@ADMITWAY", SqlDbType.VarChar, 14); parADMITWAY.Value = m_patientInfo.ADMITWAY; SqlParameter parOUTWAY = new SqlParameter("@OUTWAY", SqlDbType.VarChar, 14); parOUTWAY.Value = m_patientInfo.OUTWAY; SqlParameter parCLINICDOCTOR = new SqlParameter("@CLINICDOCTOR", SqlDbType.VarChar, 14); parCLINICDOCTOR.Value = m_patientInfo.CLINICDOCTOR; SqlParameter parRESIDENT = new SqlParameter("@RESIDENT", SqlDbType.VarChar, 14); parRESIDENT.Value = m_patientInfo.RESIDENT; SqlParameter parATTEND = new SqlParameter("@ATTEND", SqlDbType.VarChar, 14); parATTEND.Value = m_patientInfo.ATTEND; SqlParameter parCHIEF = new SqlParameter("@CHIEF", SqlDbType.VarChar, 14); parCHIEF.Value = m_patientInfo.CHIEF; SqlParameter parEDU = new SqlParameter("@EDU", SqlDbType.VarChar, 14); parEDU.Value = m_patientInfo.EDU; SqlParameter parEDUC = new SqlParameter("@EDUC", SqlDbType.Int); parEDUC.Value = m_patientInfo.EDUC; SqlParameter parRELIGION = new SqlParameter("@RELIGION", SqlDbType.VarChar, 32); parRELIGION.Value = m_patientInfo.RELIGION; SqlParameter parSTATUS = new SqlParameter("@STATUS", SqlDbType.Int); parSTATUS.Value = m_patientInfo.STATUS; SqlParameter parCRITICALLEVEL = new SqlParameter("@CRITICALLEVEL", SqlDbType.VarChar, 14); parCRITICALLEVEL.Value = m_patientInfo.CRITICALLEVEL; SqlParameter parATTENDLEVEL = new SqlParameter("@ATTENDLEVEL", SqlDbType.VarChar, 14); parATTENDLEVEL.Value = m_patientInfo.ATTENDLEVEL; SqlParameter parEMPHASIS = new SqlParameter("@EMPHASIS", SqlDbType.Int); parEMPHASIS.Value = m_patientInfo.EMPHASIS; SqlParameter parISBABY = new SqlParameter("@ISBABY", SqlDbType.Int); parISBABY.Value = m_patientInfo.ISBABY; SqlParameter parMOTHER = new SqlParameter("@MOTHER", SqlDbType.Int); parMOTHER.Value = m_patientInfo.MOTHER; SqlParameter parMEDICAREID = new SqlParameter("@MEDICAREID", SqlDbType.VarChar, 14); parMEDICAREID.Value = m_patientInfo.MEDICAREID; SqlParameter parMEDICAREQUOTA = new SqlParameter("@MEDICAREQUOTA", SqlDbType.Int); parMEDICAREQUOTA.Value = m_patientInfo.MEDICAREQUOTA; SqlParameter parVOUCHERSCODE = new SqlParameter("@VOUCHERSCODE", SqlDbType.VarChar, 14); parVOUCHERSCODE.Value = m_patientInfo.VOUCHERSCODE; SqlParameter parSTYLE = new SqlParameter("@STYLE", SqlDbType.VarChar, 14); parSTYLE.Value = m_patientInfo.STYLE; SqlParameter parOPERATOR = new SqlParameter("@OPERATOR", SqlDbType.VarChar, 14); parOPERATOR.Value = m_patientInfo.OPERATOR; SqlParameter parMEMO = new SqlParameter("@MEMO", SqlDbType.VarChar, 64); parMEMO.Value = m_patientInfo.MEMO; SqlParameter parCPSTATUS = new SqlParameter("@CPSTATUS", SqlDbType.Int); parCPSTATUS.Value = m_patientInfo.CPSTATUS; SqlParameter parOUTWARDBED = new SqlParameter("@OUTWARDBED", SqlDbType.Int); parOUTWARDBED.Value = m_patientInfo.OUTWARDBED; SqlParameter parXZZProvinceID = new SqlParameter("@XZZProvinceID", SqlDbType.VarChar, 14); parXZZProvinceID.Value = m_patientInfo.XZZ_ProvinceID; SqlParameter parXZZCityID = new SqlParameter("@XZZCityID", SqlDbType.VarChar, 14); parXZZCityID.Value = m_patientInfo.XZZ_CityID; SqlParameter parXZZDistrictID = new SqlParameter("@XZZDistrictID", SqlDbType.VarChar, 14); parXZZDistrictID.Value = m_patientInfo.XZZ_DistrictID; SqlParameter parXZZTEL = new SqlParameter("@XZZTEL", SqlDbType.VarChar, 14); parXZZTEL.Value = m_patientInfo.XZZ_TEL; SqlParameter parXZZPost = new SqlParameter("@XZZPost", SqlDbType.VarChar, 16); parXZZPost.Value = m_patientInfo.XZZ_Post; SqlParameter parEditType = new SqlParameter("@EditType", SqlDbType.VarChar, 16); parEditType.Value = edittype; SqlParameter[] paraColl = new SqlParameter[] { parNoofInpat, parPatNoOfHis, parNoofclinic, parNoofrecord, parpatid, parInnerpix, paroutpix, parName, parpy, parwb, parPayid, parORIGIN, parInCount, parSexID, parBirth, parAge, parAgeStr, parIDNO, parMarital, parJobID, parCSDProvinceID, parCSDCityID, parCSDDistrictID, parNationID, parNationalityID, parJGProvinceID, parJGCityID, parOrganization, parOfficePlace, parOfficeTEL, parOfficePost, parHKDZProvinceID, parHKDZCityID, parHKDZDistrictID, parNATIVEPOST, parNATIVETEL, parNATIVEADDRESS, parADDRESS, parContactPerson, parRelationshipID, parContactAddress, parContactTEL, parCONTACTOFFICE, parCONTACTPOST, parOFFERER, parSocialCare, parINSURANCE, parCARDNO, parADMITINFO, parAdmitDeptID, parAdmitWardID, parADMITBED, parAdmitDate, parINWARDDATE, parADMITDIAGNOSIS, parOutWardDate, parOutHosDeptID, parOutHosWardID, parOutBed, parOUTHOSDATE, parOUTDIAGNOSIS, parTOTALDAYS, parCLINICDIAGNOSIS, parSOLARTERMS, parADMITWAY, parOUTWAY, parCLINICDOCTOR, parRESIDENT, parATTEND, parCHIEF, parEDU, parEDUC, parRELIGION, parSTATUS, parCRITICALLEVEL, parATTENDLEVEL, parEMPHASIS, parISBABY, parMOTHER, parMEDICAREID, parMEDICAREQUOTA, parVOUCHERSCODE, parSTYLE, parOPERATOR, parMEMO, parCPSTATUS, parOUTWARDBED, parXZZProvinceID, parXZZCityID, parXZZDistrictID, parXZZTEL, parXZZPost, parEditType }; try { m_App.SqlHelper.ExecuteNoneQuery("EMRPROC.usp_editBabyinfo", paraColl, CommandType.StoredProcedure); } catch (Exception ex) { MessageBox.Show("错误" + ex.Message); throw; } }
/// <summary> /// 将页面的值加进实体里 /// </summary> /// <returns></returns> private PatientEntity SetEntityByPage() { PatientEntity patEntity = new PatientEntity(); //此处除了姓名,性别,出生日期,年龄,noofinpat,其他的都要与他的母亲保持一致 //其余的取母亲的 patEntity.Name = this.txtName.Text; patEntity.Birth = deBirth.DateTime.ToString("yyyy-MM-dd") + " " + teAdmitDate.Time.ToString("HH:mm"); //patEntity.Birth = deBirth.DateTime.ToString("yyyy-MM-dd");/*deBirth.EditValue.ToString("yyyy-MM-dd");*/ //patEntity.Age = Int32.Parse(txtAge.Text); patEntity.Age = 0; patEntity.AgeStr = txtAge.Text; patEntity.SexID = lueSex.CodeValue; patEntity.ISBABY = 1; patEntity.MOTHER = Int32.Parse(NOOFINPAT); //patEntity string sql = string.Format("select * from inpatient where noofinpat='{0}'", NOOFINPAT); DataTable dt = m_app.SqlHelper.ExecuteDataTable(sql, CommandType.Text); string babyNO = GetBabyNo(NOOFINPAT); for (int i = 0; i < dt.Rows.Count; i++) { //patEntity.PatNoOfHis = dt.Rows[0]["PATNOOFHIS"].ToString(); //patnoofhis等四个地方随机生成 14位 patEntity.PatNoOfHis = babyNO; //Guid.NewGuid().ToString().Substring(1, 14); patEntity.NoOfcClinic = babyNO; //Guid.NewGuid().ToString().Substring(1, 14); patEntity.NoOfRecord = babyNO; //Guid.NewGuid().ToString().Substring(1, 14);; patEntity.PatID = babyNO; //Guid.NewGuid().ToString().Substring(1, 14); //patEntity.NoOfcClinic = dt.Rows[0]["NOOFCLINIC"].ToString(); //patEntity.NoOfRecord = dt.Rows[0]["NOOFRECORD"].ToString(); //patEntity.PatID = dt.Rows[0]["PATID"].ToString(); patEntity.INNERPIX = dt.Rows[0]["INNERPIX"].ToString(); patEntity.OUTPIX = dt.Rows[0]["OUTPIX"].ToString(); patEntity.PY = ""; patEntity.WB = ""; patEntity.PayID = dt.Rows[0]["PAYID"].ToString(); patEntity.ORIGIN = dt.Rows[0]["ORIGIN"].ToString(); patEntity.InCount = Int32.Parse(dt.Rows[0]["INCOUNT"].ToString()); patEntity.IDNO = dt.Rows[0]["IDNO"].ToString(); patEntity.Marital = "0";/*dt.Rows[0]["MARITAL"].ToString();*/ patEntity.JobID = dt.Rows[0]["JOBID"].ToString(); patEntity.CSD_ProvinceID = dt.Rows[0]["PROVINCEID"].ToString(); patEntity.CSD_CityID = dt.Rows[0]["COUNTYID"].ToString(); patEntity.CSD_DistrictID = dt.Rows[0]["DISTRICTID"].ToString(); patEntity.NationID = dt.Rows[0]["NATIONID"].ToString(); patEntity.NationalityID = dt.Rows[0]["NATIONALITYID"].ToString(); patEntity.JG_ProvinceID = dt.Rows[0]["NATIVEPLACE_P"].ToString(); patEntity.JG_CityID = dt.Rows[0]["NATIVEPLACE_C"].ToString(); patEntity.Organization = dt.Rows[0]["ORGANIZATION"].ToString(); patEntity.OfficePlace = dt.Rows[0]["OFFICEPLACE"].ToString(); patEntity.OfficeTEL = dt.Rows[0]["OFFICETEL"].ToString(); patEntity.OfficePost = dt.Rows[0]["OFFICEPOST"].ToString(); patEntity.NATIVEADDRESS = dt.Rows[0]["NATIVEADDRESS"].ToString(); patEntity.NATIVETEL = dt.Rows[0]["NATIVETEL"].ToString(); patEntity.NATIVEPOST = dt.Rows[0]["NATIVEPOST"].ToString(); patEntity.ADDRESS = dt.Rows[0]["ADDRESS"].ToString(); patEntity.ContactPerson = dt.Rows[0]["CONTACTPERSON"].ToString(); patEntity.RelationshipID = dt.Rows[0]["RELATIONSHIP"].ToString(); patEntity.ContactAddress = dt.Rows[0]["CONTACTADDRESS"].ToString(); patEntity.CONTACTOFFICE = dt.Rows[0]["CONTACTOFFICE"].ToString(); patEntity.ContactTEL = dt.Rows[0]["CONTACTTEL"].ToString(); patEntity.CONTACTPOST = dt.Rows[0]["CONTACTPOST"].ToString(); patEntity.SocialCare = dt.Rows[0]["SOCIALCARE"].ToString(); patEntity.INSURANCE = dt.Rows[0]["INSURANCE"].ToString(); patEntity.CARDNO = dt.Rows[0]["CARDNO"].ToString(); patEntity.ADMITINFO = dt.Rows[0]["ADMITINFO"].ToString(); patEntity.AdmitDeptID = dt.Rows[0]["ADMITDEPT"].ToString(); patEntity.AdmitWardID = dt.Rows[0]["ADMITWARD"].ToString(); patEntity.ADMITBED = dt.Rows[0]["ADMITBED"].ToString(); patEntity.AdmitDate = patEntity.Birth; patEntity.INWARDDATE = patEntity.Birth; patEntity.ADMITDIAGNOSIS = dt.Rows[0]["ADMITDIAGNOSIS"].ToString(); patEntity.OutHosDeptID = dt.Rows[0]["OUTHOSDEPT"].ToString(); patEntity.OutHosWardID = dt.Rows[0]["OUTHOSWARD"].ToString(); patEntity.OutBed = dt.Rows[0]["OUTBED"].ToString(); patEntity.OutWardDate = dt.Rows[0]["OUTWARDDATE"].ToString(); patEntity.OUTHOSDATE = dt.Rows[0]["OUTHOSDATE"].ToString(); patEntity.OUTDIAGNOSIS = dt.Rows[0]["OUTDIAGNOSIS"].ToString(); patEntity.TOTALDAYS = Int32.Parse(dt.Rows[0]["TOTALDAYS"].ToString() == "" ? "0" : dt.Rows[0]["TOTALDAYS"].ToString()); patEntity.CLINICDIAGNOSIS = dt.Rows[0]["CLINICDIAGNOSIS"].ToString(); patEntity.SOLARTERMS = dt.Rows[0]["SOLARTERMS"].ToString(); patEntity.ADMITWAY = dt.Rows[0]["ADMITWAY"].ToString(); patEntity.OUTWAY = dt.Rows[0]["OUTWAY"].ToString(); patEntity.CLINICDOCTOR = dt.Rows[0]["CLINICDOCTOR"].ToString(); patEntity.RESIDENT = dt.Rows[0]["RESIDENT"].ToString(); patEntity.ATTEND = dt.Rows[0]["ATTEND"].ToString(); patEntity.CHIEF = dt.Rows[0]["CHIEF"].ToString(); patEntity.EDU = dt.Rows[0]["EDU"].ToString(); //Int32.Parse(dt.Rows[0]["TOTALDAYS"].ToString() == "" ? "0" : dt.Rows[0]["TOTALDAYS"].ToString());STATUS patEntity.EDUC = Int32.Parse(dt.Rows[0]["EDUC"].ToString() == "" ? "0" : dt.Rows[0]["EDUC"].ToString()); patEntity.RELIGION = dt.Rows[0]["RELIGION"].ToString(); patEntity.STATUS = Int32.Parse(dt.Rows[0]["STATUS"].ToString() == "" ? "0" : dt.Rows[0]["STATUS"].ToString()); patEntity.CRITICALLEVEL = dt.Rows[0]["CRITICALLEVEL"].ToString(); patEntity.ATTENDLEVEL = dt.Rows[0]["ATTENDLEVEL"].ToString(); patEntity.EMPHASIS = Int32.Parse(dt.Rows[0]["EMPHASIS"].ToString() == "" ? "0" : dt.Rows[0]["EMPHASIS"].ToString()); patEntity.MEDICAREID = dt.Rows[0]["MEDICAREID"].ToString(); patEntity.MEDICAREQUOTA = Int32.Parse(dt.Rows[0]["MEDICAREQUOTA"].ToString() == "" ? "0" : dt.Rows[0]["MEDICAREQUOTA"].ToString()); patEntity.VOUCHERSCODE = dt.Rows[0]["VOUCHERSCODE"].ToString(); patEntity.STYLE = dt.Rows[0]["STYLE"].ToString(); patEntity.OPERATOR = dt.Rows[0]["OPERATOR"].ToString(); patEntity.MEMO = dt.Rows[0]["MEMO"].ToString(); patEntity.CPSTATUS = Int32.Parse(dt.Rows[0]["CPSTATUS"].ToString() == "" ? "0" : dt.Rows[0]["CPSTATUS"].ToString()); patEntity.OUTWARDBED = Int32.Parse(dt.Rows[0]["OUTWARDBED"].ToString() == "" ? "0" : dt.Rows[0]["OUTWARDBED"].ToString()); patEntity.XZZ_ProvinceID = dt.Rows[0]["XZZPROVICEID"].ToString(); patEntity.XZZ_CityID = dt.Rows[0]["XZZCITYID"].ToString(); patEntity.XZZ_DistrictID = dt.Rows[0]["XZZDISTRICTID"].ToString(); patEntity.XZZ_TEL = dt.Rows[0]["XZZTEL"].ToString(); patEntity.HKDZ_ProvinceID = dt.Rows[0]["HKDZPROVICEID"].ToString(); patEntity.HKDZ_CityID = dt.Rows[0]["HKZDCITYID"].ToString(); patEntity.HKDZ_DistrictID = dt.Rows[0]["HKZDDISTRICTID"].ToString(); patEntity.XZZ_Post = dt.Rows[0]["XZZPOST"].ToString(); } return(patEntity); }