/// <summary> /// 修改门诊病人信息 /// </summary> /// <param name="memberEntity">会员信息</param> public void UpdateOPPatientInfo(ME_MemberInfo memberEntity) { string sql = @" UPDATE OP_CostHead SET PatName='{0}',PatTypeID={1} WHERE MemberID={2}"; sql = string.Format(sql, memberEntity.Name, memberEntity.PatType, memberEntity.MemberID); oleDb.DoCommand(sql); sql = @" UPDATE OP_FeeItemHead SET PatName='{0}' WHERE MemberID={1}"; sql = string.Format(sql, memberEntity.Name, memberEntity.MemberID); oleDb.DoCommand(sql); sql = @" UPDATE OP_FeeRefundHead SET PatName='{0}' WHERE PatListID IN (SELECT PatListID FROM OP_PatList WHERE MemberID={1})"; sql = string.Format(sql, memberEntity.Name, memberEntity.MemberID); oleDb.DoCommand(sql); string sex = string.Empty; if (memberEntity.Sex == "1") { sex = "男"; } else if (memberEntity.Sex == "2") { sex = "女"; } AgeValue ag = AgeExtend.GetAgeValue(memberEntity.Birthday); string age = ag.ReturnAgeStr_EN(); string patTypeName = string.Empty; Basic_PatType model = (Basic_PatType)NewObject <Basic_PatType>().getmodel(memberEntity.PatType); patTypeName = model.PatTypeName; sql = @" UPDATE OP_PatList SET PatTypeID={0},PatName='{1}',PatSex='{2}',Birthday='{3}',Age='{4}',Allergies='{5}',WorkUnit='{6}',PatTypeName='{7}' WHERE MemberID={8}"; sql = string.Format(sql, memberEntity.PatType, memberEntity.Name, sex, memberEntity.Birthday.ToString("yyyy-MM-dd HH:mm:ss"), age, memberEntity.Allergies, memberEntity.WorkUnit, patTypeName, memberEntity.MemberID); oleDb.DoCommand(sql); }
/// <summary> /// 获取绑定数据源信息 /// </summary> /// <param name="patlistid">病人ID</param> /// <returns>病人信息数据</returns> public MedicalCasePatient GetCasePatInfoDataSource(int patlistid) { MedicalCaseDbHelper helper = new MedicalCaseDbHelper(); MedicalCasePatient casePatInfo = helper.GetCasePatient(patlistid); AgeValue ageValue = AgeExtend.GetAgeValue(casePatInfo.Birthday, casePatInfo.EnterHDate); casePatInfo.Age = "0"; if (ageValue.Y_num > 0) { casePatInfo.Age = ageValue.Y_num.ToString(); } else { casePatInfo.BirthDays = (ageValue.M_num * 30 + ageValue.D_num) / 30; } return(casePatInfo); }