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