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);
}
