public bool UpdateByTJMiniPad(RecordsLifeStyleModel model, string checkDate) //Ìå¼ìÎÊѯͬ²½ { StringBuilder builder = new StringBuilder(); builder.Append(@"UPDATE ARCHIVE_LIFESTYLE D SET ExerciseRate=@ExerciseRate,ExerciseTimes=@ExerciseTimes,ExcisepersistTime=@ExcisepersistTime, ExerciseExistense=@ExerciseExistense,DietaryHabit=@DietaryHabit,SmokeCondition=@SmokeCondition,SmokeDayNum=@SmokeDayNum, SmokeAgeStart=@SmokeAgeStart,SmokeAgeForbiddon=@SmokeAgeForbiddon,DrinkRate=@DrinkRate, DayDrinkVolume=@DayDrinkVolume,IsDrinkForbiddon=@IsDrinkForbiddon,DrinkStartAge=@DrinkStartAge, DrinkThisYear=@DrinkThisYear,DrinkType=@DrinkType,ExerciseExistenseOther=@ExerciseExistenseOther, DrinkTypeOther=@DrinkTypeOther,ForbiddonAge=@ForbiddonAge WHERE EXISTS ( SELECT ID FROM ARCHIVE_CUSTOMERBASEINFO M WHERE M.ID = D.OutKey AND M.IDCardNo = @IDCardNo AND M.CheckDate = @CheckDate ) "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@IDCardNo", model.IDCardNo), new MySqlParameter("@CheckDate", checkDate), new MySqlParameter("@ExerciseRate", model.ExerciseRate), new MySqlParameter("@ExerciseTimes", model.ExerciseTimes), new MySqlParameter("@ExcisepersistTime", model.ExcisepersistTime), new MySqlParameter("@ExerciseExistense", model.ExerciseExistense), new MySqlParameter("@DietaryHabit", model.DietaryHabit), new MySqlParameter("@SmokeCondition", model.SmokeCondition), new MySqlParameter("@SmokeDayNum", model.SmokeDayNum), new MySqlParameter("@SmokeAgeStart", model.SmokeAgeStart), new MySqlParameter("@SmokeAgeForbiddon", model.SmokeAgeForbiddon), new MySqlParameter("@DrinkRate", model.DrinkRate), new MySqlParameter("@DayDrinkVolume", model.DayDrinkVolume), new MySqlParameter("@IsDrinkForbiddon", model.IsDrinkForbiddon), new MySqlParameter("@DrinkStartAge", model.DrinkStartAge), new MySqlParameter("@DrinkThisYear", model.DrinkThisYear), new MySqlParameter("@DrinkType", model.DrinkType), new MySqlParameter("@ExerciseExistenseOther", model.ExerciseExistenseOther), new MySqlParameter("@DrinkTypeOther", model.DrinkTypeOther), new MySqlParameter("@ForbiddonAge", model.ForbiddonAge) }; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public List <RecordsLifeStyleModel> DataTableToList(DataTable dt) { List <RecordsLifeStyleModel> list = new List <RecordsLifeStyleModel>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { RecordsLifeStyleModel item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
private void btndataupload_Click(object sender, EventArgs e) { string strwhere = ""; if (this.ckbcheckdate.Checked) { strwhere = string.Format(" CheckDate BETWEEN '{0}' and '{1}' ", this.dtpstart.Value.Date.ToString("yyyy-MM-dd"), this.dtpend.Value.Date.ToString("yyyy-MM-dd")); } DataSet customds = new RecordsCustomerBaseInfoBLL().GetList(strwhere); int amount = 0; progressBar1.Visible = true; progressBar1.Minimum = 0; progressBar1.Maximum = customds.Tables[0].Rows.Count; progressBar1.BackColor = Color.Green; labCountnum.Text = customds.Tables[0].Rows.Count.ToString(); foreach (DataRow row in customds.Tables[0].Rows) { int OutKey = Convert.ToInt32(row["ID"].ToString()); if (string.IsNullOrEmpty(row["IDCardNo"].ToString())) { continue; } // 基本信息 RecordsBaseInfoModel Model = new RecordsBaseInfoBLL().GetModel(row["IDCardNo"].ToString()); if (Model == null) { Model = new RecordsBaseInfoModel(); } // 一般状况 RecordsGeneralConditionModel generalConditionModel = new RecordsGeneralConditionBLL().GetModelByOutKey(OutKey); if (generalConditionModel == null) { generalConditionModel = new RecordsGeneralConditionModel(); } ChronicDiadetesVisitModel diabetesModel = new ChronicDiadetesVisitModel(); diabetesModel.IDCardNo = row["IDCardNo"].ToString(); diabetesModel.Hypertension = generalConditionModel.RightHeight; diabetesModel.Hypotension = generalConditionModel.RightPre; diabetesModel.BMI = generalConditionModel.BMI; diabetesModel.Weight = generalConditionModel.Weight; diabetesModel.Hight = generalConditionModel.Height; if (diabetesModel.BMI != null) { if (diabetesModel.BMI >= 24) { diabetesModel.TargetWeight = diabetesModel.Weight - 5; } } // 生活方式 RecordsLifeStyleModel lifeModel = new RecordsLifeStyleBLL().GetModelByOutKey(OutKey); if (lifeModel == null) { lifeModel = new RecordsLifeStyleModel(); } if (lifeModel.SmokeCondition == "3") { diabetesModel.DailySmokeNum = lifeModel.SmokeDayNum; } else { diabetesModel.DailySmokeNum = 0; } if (lifeModel.DrinkRate == "2" || lifeModel.DrinkRate == "3" || lifeModel.DrinkRate == "4") { diabetesModel.DailyDrinkNum = lifeModel.DayDrinkVolume; } else { diabetesModel.DailyDrinkNum = 0; } diabetesModel.DailySmokeNumTarget = 0; diabetesModel.DailyDrinkNumTarget = 0; diabetesModel.SportTimePerWeekTarget = 7; diabetesModel.SportPerMinuteTimeTarget = 60; // 辅助检查 RecordsAssistCheckModel AssistCheck = new RecordsAssistCheckBLL().GetModelByOutKey(OutKey); if (AssistCheck == null) { AssistCheck = new RecordsAssistCheckModel(); } diabetesModel.FPG = AssistCheck.FPGL; diabetesModel.HbAlc = AssistCheck.HBALC; new ChronicDiadetesVisitBLL().UpdateDate(diabetesModel); ChronicHypertensionVisitModel hypertensionModel = new ChronicHypertensionVisitModel(); hypertensionModel.Hypertension = generalConditionModel.RightHeight; hypertensionModel.Hypotension = generalConditionModel.RightPre; hypertensionModel.BMI = generalConditionModel.BMI; hypertensionModel.Weight = generalConditionModel.Weight; hypertensionModel.Hight = generalConditionModel.Height; if (hypertensionModel.BMI != null) { if (hypertensionModel.BMI >= 24) { hypertensionModel.WeightTarGet = hypertensionModel.Weight - 5; } } if (AssistCheck.FPGL != null) { hypertensionModel.AssistantExam = $"空腹血糖:{AssistCheck.FPGL}mmol/L"; } // 查体 RecordsPhysicalExamModel physicalModel = new RecordsPhysicalExamBLL().GetModelByOutKey(OutKey); if (physicalModel == null) { physicalModel = new RecordsPhysicalExamModel(); } decimal dd = 0; if (!string.IsNullOrEmpty(physicalModel.HeartRate)) { if (decimal.TryParse(physicalModel.HeartRate, out dd)) { hypertensionModel.HeartRate = dd; } } if (lifeModel.SmokeCondition == "3") { hypertensionModel.DailySmokeNum = lifeModel.SmokeDayNum; } else { hypertensionModel.DailySmokeNum = 0; } if (lifeModel.DrinkRate == "2" || lifeModel.DrinkRate == "3" || lifeModel.DrinkRate == "4") { hypertensionModel.DailyDrinkNum = lifeModel.DayDrinkVolume; } else { hypertensionModel.DailyDrinkNum = 0; } hypertensionModel.DailySmokeNumTarget = 0; hypertensionModel.DailyDrinkNumTarget = 0; hypertensionModel.SportTimeSperWeekTarget = 7; hypertensionModel.SportPerMinutesTimeTarget = 60; hypertensionModel.IDCardNo = row["IDCardNo"].ToString(); new ChronicHypertensionVisitBLL().UpdateDate(hypertensionModel); amount++; labUploadnum.Text = amount.ToString(); progressBar1.Value = amount; } MessageBox.Show("成功匹配:" + amount + "条数据!", "提示"); progressBar1.Visible = false; }
public int Add(RecordsLifeStyleModel model) { StringBuilder builder = new StringBuilder(); builder.Append("INSERT INTO ARCHIVE_LIFESTYLE("); builder.Append("PhysicalID,IDCardNo,SmokeDayNum,SmokeAgeStart,SmokeAgeForbiddon,ExerciseRate,ExerciseTimes,DietaryHabit,ExerciseExistense,ExcisepersistTime,SmokeCondition,DrinkRate,DayDrinkVolume,IsDrinkForbiddon,ForbiddonAge,DrinkStartAge,DrinkThisYear,DrinkType,CareerHarmFactorHistory,Dust,DustProtect,Radiogen,RadiogenProtect,Physical,PhysicalProtect,Chem,ChemProtect,Other,OtherProtect,WorkType,WorkTime,DustProtectEx,RadiogenProtectEx,PhysicalProtectEx,ChemProtectEx,OtherProtectEx,DrinkTypeOther,OutKey,ExerciseExistenseOther)"); builder.Append(" VALUES ("); builder.Append("@PhysicalID,@IDCardNo,@SmokeDayNum,@SmokeAgeStart,@SmokeAgeForbiddon,@ExerciseRate,@ExerciseTimes,@DietaryHabit,@ExerciseExistense,@ExcisepersistTime,@SmokeCondition,@DrinkRate,@DayDrinkVolume,@IsDrinkForbiddon,@ForbiddonAge,@DrinkStartAge,@DrinkThisYear,@DrinkType,@CareerHarmFactorHistory,@Dust,@DustProtect,@Radiogen,@RadiogenProtect,@Physical,@PhysicalProtect,@Chem,@ChemProtect,@Other,@OtherProtect,@WorkType,@WorkTime,@DustProtectEx,@RadiogenProtectEx,@PhysicalProtectEx,@ChemProtectEx,@OtherProtectEx,@DrinkTypeOther,@OutKey,@ExerciseExistenseOther)"); builder.Append(";SELECT @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@PhysicalID", MySqlDbType.String, 100), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@SmokeDayNum", MySqlDbType.Decimal), new MySqlParameter("@SmokeAgeStart", MySqlDbType.Decimal), new MySqlParameter("@SmokeAgeForbiddon", MySqlDbType.Decimal), new MySqlParameter("@ExerciseRate", MySqlDbType.String, 1), new MySqlParameter("@ExerciseTimes", MySqlDbType.Decimal), new MySqlParameter("@DietaryHabit", MySqlDbType.String, 100), new MySqlParameter("@ExerciseExistense", MySqlDbType.String, 100), new MySqlParameter("@ExcisepersistTime", MySqlDbType.Decimal), new MySqlParameter("@SmokeCondition", MySqlDbType.String, 1), new MySqlParameter("@DrinkRate", MySqlDbType.String, 1), new MySqlParameter("@DayDrinkVolume", MySqlDbType.Decimal), new MySqlParameter("@IsDrinkForbiddon", MySqlDbType.String, 1), new MySqlParameter("@ForbiddonAge", MySqlDbType.Decimal), new MySqlParameter("@DrinkStartAge", MySqlDbType.Decimal), new MySqlParameter("@DrinkThisYear", MySqlDbType.String, 1), new MySqlParameter("@DrinkType", MySqlDbType.String, 100), new MySqlParameter("@CareerHarmFactorHistory", MySqlDbType.String, 1), new MySqlParameter("@Dust", MySqlDbType.String, 100), new MySqlParameter("@DustProtect", MySqlDbType.String, 1), new MySqlParameter("@Radiogen", MySqlDbType.String, 100), new MySqlParameter("@RadiogenProtect", MySqlDbType.String, 1), new MySqlParameter("@Physical", MySqlDbType.String, 100), new MySqlParameter("@PhysicalProtect", MySqlDbType.String, 1), new MySqlParameter("@Chem", MySqlDbType.String, 100), new MySqlParameter("@ChemProtect", MySqlDbType.String, 1), new MySqlParameter("@Other", MySqlDbType.String, 100), new MySqlParameter("@OtherProtect", MySqlDbType.String, 1), new MySqlParameter("@WorkType", MySqlDbType.String, 100), new MySqlParameter("@WorkTime", MySqlDbType.Decimal), new MySqlParameter("@DustProtectEx", MySqlDbType.String, 100), new MySqlParameter("@RadiogenProtectEx", MySqlDbType.String, 100), new MySqlParameter("@PhysicalProtectEx", MySqlDbType.String, 100), new MySqlParameter("@ChemProtectEx", MySqlDbType.String, 100), new MySqlParameter("@OtherProtectEx", MySqlDbType.String, 100), new MySqlParameter("@DrinkTypeOther", MySqlDbType.String, 100), new MySqlParameter("@OutKey", MySqlDbType.Int32, 11), new MySqlParameter("@ExerciseExistenseOther", MySqlDbType.Int32, 100) }; cmdParms[0].Value = model.PhysicalID; cmdParms[1].Value = model.IDCardNo; cmdParms[2].Value = model.SmokeDayNum; cmdParms[3].Value = model.SmokeAgeStart; cmdParms[4].Value = model.SmokeAgeForbiddon; cmdParms[5].Value = model.ExerciseRate; cmdParms[6].Value = model.ExerciseTimes; cmdParms[7].Value = model.DietaryHabit; cmdParms[8].Value = model.ExerciseExistense; cmdParms[9].Value = model.ExcisepersistTime; cmdParms[10].Value = model.SmokeCondition; cmdParms[11].Value = model.DrinkRate; cmdParms[12].Value = model.DayDrinkVolume; cmdParms[13].Value = model.IsDrinkForbiddon; cmdParms[14].Value = model.ForbiddonAge; cmdParms[15].Value = model.DrinkStartAge; cmdParms[16].Value = model.DrinkThisYear; cmdParms[17].Value = model.DrinkType; cmdParms[18].Value = model.CareerHarmFactorHistory; cmdParms[19].Value = model.Dust; cmdParms[20].Value = model.DustProtect; cmdParms[21].Value = model.Radiogen; cmdParms[22].Value = model.RadiogenProtect; cmdParms[23].Value = model.Physical; cmdParms[24].Value = model.PhysicalProtect; cmdParms[25].Value = model.Chem; cmdParms[26].Value = model.ChemProtect; cmdParms[27].Value = model.Other; cmdParms[28].Value = model.OtherProtect; cmdParms[29].Value = model.WorkType; cmdParms[30].Value = model.WorkTime; cmdParms[31].Value = model.DustProtectEx; cmdParms[32].Value = model.RadiogenProtectEx; cmdParms[33].Value = model.PhysicalProtectEx; cmdParms[34].Value = model.ChemProtectEx; cmdParms[35].Value = model.OtherProtectEx; cmdParms[36].Value = model.DrinkTypeOther; cmdParms[37].Value = model.OutKey; cmdParms[38].Value = model.ExerciseExistenseOther; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
/// <summary> /// 糖尿病 /// </summary> /// <param name="IDCardNo"></param> /// <param name="CheckDate"></param> /// <param name="VersionNo"></param> /// <param name="Model"></param> public void SaveDiadetes(string IDCardNo, DateTime CheckDate, string VersionNo, RecordsBaseInfoModel Model, RecordsCustomerBaseInfoModel CustomerModel) { try { DataView dv = dsRequire.DefaultView; // 获取最后一次随访数据 ChronicDiadetesVisitModel diadetesOldModel = DiadetesVisitBLL.GetMaxModel(IDCardNo); if (diadetesOldModel == null) { diadetesOldModel = new ChronicDiadetesVisitModel(); } ChronicDiadetesVisitModel diadetesNewModel = new ChronicDiadetesVisitModel(); // 取得体检一般情况资料 RecordsGeneralConditionModel conditionModel = new RecordsGeneralConditionBLL().GetModelByOutKey(CustomerModel.ID); // 取得体检生活方式资料 RecordsLifeStyleModel lifeModel = new RecordsLifeStyleBLL().GetModelByOutKey(CustomerModel.ID); if (lifeModel == null) { lifeModel = new RecordsLifeStyleModel(); } // 取得体检查体资料 RecordsPhysicalExamModel physicalModel = new RecordsPhysicalExamBLL().GetModelByOutKey(CustomerModel.ID); if (physicalModel == null) { physicalModel = new RecordsPhysicalExamModel(); } // 取得体检辅助检查资料 RecordsAssistCheckModel checkModel = new RecordsAssistCheckBLL().GetModelByOutKey(CustomerModel.ID); #region 糖尿病基本信息 dv.RowFilter = null; dv.RowFilter = "TabName='糖尿病随访' AND Comment='糖尿病基本信息' AND (IsSetValue='是' OR IsSetValue='预设上次随访') "; DataTable dt = dv.ToTable(); // 是否有基本信息 int count = DiadetesVisitBLL.GetBaseDataCount(IDCardNo); if (count < 1) { // 新增糖尿病基本信息 ChronicDiabetesBaseInfoModel baseModel = new ChronicDiabetesBaseInfoModel() { IDCardNo = IDCardNo, RecordID = Model.RecordID, CreateBy = ConfigHelper.GetNodeDec("doctor"), CreateDate = DateTime.Now, LastUpdateBy = ConfigHelper.GetNodeDec("doctor"), LastUpdateDate = DateTime.Now }; baseModel = EntityAssignment <ChronicDiabetesBaseInfoModel>(baseModel, baseModel, dt); DiadetesVisitBLL.Add(baseModel, VersionNo); } #endregion #region 随访信息 dv.RowFilter = null; dv.RowFilter = "TabName='糖尿病随访' AND Comment='糖尿病随访信息' AND (IsSetValue='是' OR IsSetValue='预设上次随访') AND ChinName<>'用药情况' "; dt = dv.ToTable(); diadetesNewModel = EntityAssignment <ChronicDiadetesVisitModel>(diadetesOldModel, diadetesNewModel, dt); diadetesNewModel.IDCardNo = IDCardNo; diadetesNewModel.RecordID = Model.RecordID; diadetesNewModel.CustomerName = StringPlus.toString(diadetesNewModel.CustomerName) == "" ? Model.CustomerName : diadetesNewModel.CustomerName; diadetesNewModel.Hypertension = conditionModel.LeftHeight; diadetesNewModel.Hypotension = conditionModel.LeftPre; diadetesNewModel.Weight = conditionModel.Weight; diadetesNewModel.Height = conditionModel.Height; diadetesNewModel.BMI = conditionModel.BMI; diadetesNewModel.DorsalisPedispulse = StringPlus.toString(physicalModel.FootBack) != "" ? (int.Parse(physicalModel.FootBack) - 1).ToString() : null; diadetesNewModel.DailySmokeNum = lifeModel.SmokeDayNum; diadetesNewModel.DailyDrinkNum = lifeModel.DayDrinkVolume; diadetesNewModel.FPG = checkModel.FPGL; diadetesNewModel.HbAlc = checkModel.HBALC; diadetesNewModel.VisitDate = CheckDate; diadetesNewModel.NextVisitDate = CheckDate.AddMonths(3); diadetesNewModel.VisitDoctor = ConfigHelper.GetNode("doctorName"); diadetesNewModel.CreateBy = ConfigHelper.GetNode("doctor"); diadetesNewModel.CreateDate = DateTime.Now; diadetesNewModel.LastUpdateBy = ConfigHelper.GetNode("doctor"); diadetesNewModel.LastUpdateDate = DateTime.Now; #endregion #region 保存默认值 // 随访信息存档 int id = DiadetesVisitBLL.Add(diadetesNewModel, VersionNo); #endregion // 保存用药 SaveMedication(IDCardNo, "2", id); } catch (Exception ex) { LogHelper.WriteLog(ex.ToString()); throw ex; } }
/// <summary> /// 高血压 /// </summary> /// <param name="IDCardNo"></param> /// <param name="CheckDate"></param> /// <param name="VersionNo"></param> /// <param name="Model"></param> public void SaveHypertension(string IDCardNo, DateTime CheckDate, string VersionNo, RecordsBaseInfoModel Model, RecordsCustomerBaseInfoModel CustomerModel) { try { DataView dv = dsRequire.DefaultView; // 获取最后一次随访数据 ChronicHypertensionVisitModel hypertensionOldModel = HypertensionVisitBLL.GetMaxModel(IDCardNo, VersionNo); if (hypertensionOldModel == null) { hypertensionOldModel = new ChronicHypertensionVisitModel(); } ChronicHypertensionVisitModel hypertensionNewModel = new ChronicHypertensionVisitModel(); // 取得体检一般情况资料 RecordsGeneralConditionModel conditionModel = new RecordsGeneralConditionBLL().GetModelByOutKey(CustomerModel.ID); // 取得体检生活方式资料 RecordsLifeStyleModel lifeModel = new RecordsLifeStyleBLL().GetModelByOutKey(CustomerModel.ID); if (lifeModel == null) { lifeModel = new RecordsLifeStyleModel(); } // 取得体检查体资料 RecordsPhysicalExamModel physicalModel = new RecordsPhysicalExamBLL().GetModelByOutKey(CustomerModel.ID); if (physicalModel == null) { physicalModel = new RecordsPhysicalExamModel(); } #region 高血压基本信息 dv.RowFilter = null; dv.RowFilter = "TabName='高血压随访' AND Comment='高血压基本信息' AND (IsSetValue='是' OR IsSetValue='预设上次随访') "; DataTable dt = dv.ToTable(); // 是否有基本信息 int count = HypertensionVisitBLL.GetDataCount(IDCardNo); if (count < 1) { // 新增高血压基本信息 ChronicHypertensionBaseInfoModel baseModel = new ChronicHypertensionBaseInfoModel() { IDCardNo = IDCardNo, RecordID = Model.RecordID, CreatedBy = ConfigHelper.GetNodeDec("doctor"), CreatedDate = DateTime.Now, LastUpdateBy = ConfigHelper.GetNodeDec("doctor"), LastUpdateDate = DateTime.Now }; baseModel = EntityAssignment <ChronicHypertensionBaseInfoModel>(baseModel, baseModel, dt); HypertensionVisitBLL.Add(baseModel, VersionNo); } #endregion #region 随访信息 dv.RowFilter = null; dv.RowFilter = "TabName='高血压随访' AND Comment='高血压随访信息' AND (IsSetValue='是' OR IsSetValue='预设上次随访') AND ChinName<>'用药情况' "; dt = dv.ToTable(); hypertensionNewModel = EntityAssignment <ChronicHypertensionVisitModel>(hypertensionOldModel, hypertensionNewModel, dt); hypertensionNewModel.IDCardNo = IDCardNo; hypertensionNewModel.RecordID = Model.RecordID; hypertensionNewModel.CustomerName = StringPlus.toString(hypertensionNewModel.CustomerName) == "" ? Model.CustomerName : hypertensionNewModel.CustomerName; hypertensionNewModel.Hypertension = conditionModel.LeftHeight; hypertensionNewModel.Hypotension = conditionModel.LeftPre; hypertensionNewModel.Weight = conditionModel.Weight; hypertensionNewModel.Height = conditionModel.Height; hypertensionNewModel.BMI = conditionModel.BMI; hypertensionNewModel.HeartRate = physicalModel.HeartRate; hypertensionNewModel.DailySmokeNum = lifeModel.SmokeDayNum; hypertensionNewModel.DailyDrinkNum = lifeModel.DayDrinkVolume; hypertensionNewModel.FollowUpDate = CheckDate; hypertensionNewModel.NextFollowUpDate = CheckDate.AddMonths(3); hypertensionNewModel.FollowUpDoctor = ConfigHelper.GetNode("doctorName"); hypertensionNewModel.CreatedBy = ConfigHelper.GetNode("doctor"); hypertensionNewModel.CreatedDate = DateTime.Now; hypertensionNewModel.LastUpdateBy = ConfigHelper.GetNode("doctor"); hypertensionNewModel.LastUpdateDate = DateTime.Now; #endregion #region 保存默认值 if (VersionNo.Contains("3.0")) { hypertensionNewModel.FollowUpType = hypertensionNewModel.VisitType; hypertensionNewModel.FollowUpWay = hypertensionNewModel.VisitWay; } // 随访信息存档 int id = HypertensionVisitBLL.Add(hypertensionNewModel, VersionNo); #endregion // 保存用药 SaveMedication(IDCardNo, "1", id); } catch (Exception ex) { LogHelper.WriteLog(ex.ToString()); throw ex; } }
public bool UpdateServer(RecordsLifeStyleModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update ARCHIVE_LIFESTYLE set "); builder.Append("PhysicalID=@PhysicalID,"); builder.Append("IDCardNo=@IDCardNo,"); builder.Append("SmokeDayNum=@SmokeDayNum,"); builder.Append("SmokeAgeStart=@SmokeAgeStart,"); builder.Append("SmokeAgeForbiddon=@SmokeAgeForbiddon,"); builder.Append("ExerciseRate=@ExerciseRate,"); builder.Append("ExerciseTimes=@ExerciseTimes,"); builder.Append("DietaryHabit=@DietaryHabit,"); builder.Append("ExerciseExistense=@ExerciseExistense,"); builder.Append("ExcisepersistTime=@ExcisepersistTime,"); builder.Append("SmokeCondition=@SmokeCondition,"); builder.Append("DrinkRate=@DrinkRate,"); builder.Append("DayDrinkVolume=@DayDrinkVolume,"); builder.Append("IsDrinkForbiddon=@IsDrinkForbiddon,"); builder.Append("ForbiddonAge=@ForbiddonAge,"); builder.Append("DrinkStartAge=@DrinkStartAge,"); builder.Append("DrinkThisYear=@DrinkThisYear,"); builder.Append("DrinkType=@DrinkType,"); builder.Append("CareerHarmFactorHistory=@CareerHarmFactorHistory,"); builder.Append("Dust=@Dust,"); builder.Append("DustProtect=@DustProtect,"); builder.Append("Radiogen=@Radiogen,"); builder.Append("RadiogenProtect=@RadiogenProtect,"); builder.Append("Physical=@Physical,"); builder.Append("PhysicalProtect=@PhysicalProtect,"); builder.Append("Chem=@Chem,"); builder.Append("ChemProtect=@ChemProtect,"); builder.Append("Other=@Other,"); builder.Append("OtherProtect=@OtherProtect,"); builder.Append("WorkType=@WorkType,"); builder.Append("WorkTime=@WorkTime,"); builder.Append("DustProtectEx=@DustProtectEx,"); builder.Append("RadiogenProtectEx=@RadiogenProtectEx,"); builder.Append("PhysicalProtectEx=@PhysicalProtectEx,"); builder.Append("ChemProtectEx=@ChemProtectEx,"); builder.Append("OtherProtectEx=@OtherProtectEx,"); builder.Append("DrinkTypeOther=@DrinkTypeOther,"); builder.Append("ExerciseExistenseOther=@ExerciseExistenseOther "); builder.Append(" where IDCardNo=@IDCardNo"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@PhysicalID", MySqlDbType.String, 8), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@SmokeDayNum", MySqlDbType.Decimal), new MySqlParameter("@SmokeAgeStart", MySqlDbType.Decimal), new MySqlParameter("@SmokeAgeForbiddon", MySqlDbType.Decimal), new MySqlParameter("@ExerciseRate", MySqlDbType.String, 1), new MySqlParameter("@ExerciseTimes", MySqlDbType.Decimal), new MySqlParameter("@DietaryHabit", MySqlDbType.String, 30), new MySqlParameter("@ExerciseExistense", MySqlDbType.String, 50), new MySqlParameter("@ExcisepersistTime", MySqlDbType.Decimal), new MySqlParameter("@SmokeCondition", MySqlDbType.String, 1), new MySqlParameter("@DrinkRate", MySqlDbType.String, 1), new MySqlParameter("@DayDrinkVolume", MySqlDbType.Decimal), new MySqlParameter("@IsDrinkForbiddon", MySqlDbType.String, 1), new MySqlParameter("@ForbiddonAge", MySqlDbType.Decimal), new MySqlParameter("@DrinkStartAge", MySqlDbType.Decimal), new MySqlParameter("@DrinkThisYear", MySqlDbType.String, 1), new MySqlParameter("@DrinkType", MySqlDbType.String, 13), new MySqlParameter("@CareerHarmFactorHistory", MySqlDbType.String, 1), new MySqlParameter("@Dust", MySqlDbType.String, 30), new MySqlParameter("@DustProtect", MySqlDbType.String, 1), new MySqlParameter("@Radiogen", MySqlDbType.String, 50), new MySqlParameter("@RadiogenProtect", MySqlDbType.String, 1), new MySqlParameter("@Physical", MySqlDbType.String, 50), new MySqlParameter("@PhysicalProtect", MySqlDbType.String, 1), new MySqlParameter("@Chem", MySqlDbType.String, 50), new MySqlParameter("@ChemProtect", MySqlDbType.String, 1), new MySqlParameter("@Other", MySqlDbType.String, 200), new MySqlParameter("@OtherProtect", MySqlDbType.String, 1), new MySqlParameter("@WorkType", MySqlDbType.String, 30), new MySqlParameter("@WorkTime", MySqlDbType.Decimal), new MySqlParameter("@DustProtectEx", MySqlDbType.String, 500), new MySqlParameter("@RadiogenProtectEx", MySqlDbType.String, 500), new MySqlParameter("@PhysicalProtectEx", MySqlDbType.String, 500), new MySqlParameter("@ChemProtectEx", MySqlDbType.String, 500), new MySqlParameter("@OtherProtectEx", MySqlDbType.String, 500), new MySqlParameter("@DrinkTypeOther", MySqlDbType.String, 20), new MySqlParameter("@ExerciseExistenseOther", MySqlDbType.String, 500) //new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.PhysicalID; cmdParms[1].Value = model.IDCardNo; cmdParms[2].Value = model.SmokeDayNum; cmdParms[3].Value = model.SmokeAgeStart; cmdParms[4].Value = model.SmokeAgeForbiddon; cmdParms[5].Value = model.ExerciseRate; cmdParms[6].Value = model.ExerciseTimes; cmdParms[7].Value = model.DietaryHabit; cmdParms[8].Value = model.ExerciseExistense; cmdParms[9].Value = model.ExcisepersistTime; cmdParms[10].Value = model.SmokeCondition; cmdParms[11].Value = model.DrinkRate; cmdParms[12].Value = model.DayDrinkVolume; cmdParms[13].Value = model.IsDrinkForbiddon; cmdParms[14].Value = model.ForbiddonAge; cmdParms[15].Value = model.DrinkStartAge; cmdParms[16].Value = model.DrinkThisYear; cmdParms[17].Value = model.DrinkType; cmdParms[18].Value = model.CareerHarmFactorHistory; cmdParms[19].Value = model.Dust; cmdParms[20].Value = model.DustProtect; cmdParms[21].Value = model.Radiogen; cmdParms[22].Value = model.RadiogenProtect; cmdParms[23].Value = model.Physical; cmdParms[24].Value = model.PhysicalProtect; cmdParms[25].Value = model.Chem; cmdParms[26].Value = model.ChemProtect; cmdParms[27].Value = model.Other; cmdParms[28].Value = model.OtherProtect; cmdParms[29].Value = model.WorkType; cmdParms[30].Value = model.WorkTime; cmdParms[31].Value = model.DustProtectEx; cmdParms[32].Value = model.RadiogenProtectEx; cmdParms[33].Value = model.PhysicalProtectEx; cmdParms[34].Value = model.ChemProtectEx; cmdParms[35].Value = model.OtherProtectEx; cmdParms[36].Value = model.DrinkTypeOther; cmdParms[37].Value = model.ExerciseExistenseOther; //cmdParms[37].Value = model.ID; return(MySQLHelper.ExecuteSqlServer(builder.ToString(), cmdParms) > 0); }
public RecordsLifeStyleModel DataRowToModel(DataRow row) { RecordsLifeStyleModel recordsLifeStyleModel = new RecordsLifeStyleModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { recordsLifeStyleModel.ID = int.Parse(row["ID"].ToString()); } if ((row["PhysicalID"] != null) && (row["PhysicalID"] != DBNull.Value)) { recordsLifeStyleModel.PhysicalID = row["PhysicalID"].ToString(); } if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)) { recordsLifeStyleModel.IDCardNo = row["IDCardNo"].ToString(); } if (((row["SmokeDayNum"] != null) && (row["SmokeDayNum"] != DBNull.Value)) && (row["SmokeDayNum"].ToString() != "")) { recordsLifeStyleModel.SmokeDayNum = new decimal?(decimal.Parse(row["SmokeDayNum"].ToString())); } if (((row["SmokeAgeStart"] != null) && (row["SmokeAgeStart"] != DBNull.Value)) && (row["SmokeAgeStart"].ToString() != "")) { recordsLifeStyleModel.SmokeAgeStart = new decimal?(decimal.Parse(row["SmokeAgeStart"].ToString())); } if (((row["SmokeAgeForbiddon"] != null) && (row["SmokeAgeForbiddon"] != DBNull.Value)) && (row["SmokeAgeForbiddon"].ToString() != "")) { recordsLifeStyleModel.SmokeAgeForbiddon = new decimal?(decimal.Parse(row["SmokeAgeForbiddon"].ToString())); } if ((row["ExerciseRate"] != null) && (row["ExerciseRate"] != DBNull.Value)) { recordsLifeStyleModel.ExerciseRate = row["ExerciseRate"].ToString(); } if (((row["ExerciseTimes"] != null) && (row["ExerciseTimes"] != DBNull.Value)) && (row["ExerciseTimes"].ToString() != "")) { recordsLifeStyleModel.ExerciseTimes = new decimal?(decimal.Parse(row["ExerciseTimes"].ToString())); } if ((row["DietaryHabit"] != null) && (row["DietaryHabit"] != DBNull.Value)) { recordsLifeStyleModel.DietaryHabit = row["DietaryHabit"].ToString(); } if ((row["ExerciseExistense"] != null) && (row["ExerciseExistense"] != DBNull.Value)) { recordsLifeStyleModel.ExerciseExistense = row["ExerciseExistense"].ToString(); } if (((row["ExcisepersistTime"] != null) && (row["ExcisepersistTime"] != DBNull.Value)) && (row["ExcisepersistTime"].ToString() != "")) { recordsLifeStyleModel.ExcisepersistTime = new decimal?(decimal.Parse(row["ExcisepersistTime"].ToString())); } if ((row["SmokeCondition"] != null) && (row["SmokeCondition"] != DBNull.Value)) { recordsLifeStyleModel.SmokeCondition = row["SmokeCondition"].ToString(); } if ((row["DrinkRate"] != null) && (row["DrinkRate"] != DBNull.Value)) { recordsLifeStyleModel.DrinkRate = row["DrinkRate"].ToString(); } if (((row["DayDrinkVolume"] != null) && (row["DayDrinkVolume"] != DBNull.Value)) && (row["DayDrinkVolume"].ToString() != "")) { recordsLifeStyleModel.DayDrinkVolume = new decimal?(decimal.Parse(row["DayDrinkVolume"].ToString())); } if ((row["IsDrinkForbiddon"] != null) && (row["IsDrinkForbiddon"] != DBNull.Value)) { recordsLifeStyleModel.IsDrinkForbiddon = row["IsDrinkForbiddon"].ToString(); } if (((row["ForbiddonAge"] != null) && (row["ForbiddonAge"] != DBNull.Value)) && (row["ForbiddonAge"].ToString() != "")) { recordsLifeStyleModel.ForbiddonAge = new decimal?(decimal.Parse(row["ForbiddonAge"].ToString())); } if (((row["DrinkStartAge"] != null) && (row["DrinkStartAge"] != DBNull.Value)) && (row["DrinkStartAge"].ToString() != "")) { recordsLifeStyleModel.DrinkStartAge = new decimal?(decimal.Parse(row["DrinkStartAge"].ToString())); } if ((row["DrinkThisYear"] != null) && (row["DrinkThisYear"] != DBNull.Value)) { recordsLifeStyleModel.DrinkThisYear = row["DrinkThisYear"].ToString(); } if ((row["DrinkType"] != null) && (row["DrinkType"] != DBNull.Value)) { recordsLifeStyleModel.DrinkType = row["DrinkType"].ToString(); } if ((row["CareerHarmFactorHistory"] != null) && (row["CareerHarmFactorHistory"] != DBNull.Value)) { recordsLifeStyleModel.CareerHarmFactorHistory = row["CareerHarmFactorHistory"].ToString(); } if ((row["Dust"] != null) && (row["Dust"] != DBNull.Value)) { recordsLifeStyleModel.Dust = row["Dust"].ToString(); } if ((row["DustProtect"] != null) && (row["DustProtect"] != DBNull.Value)) { recordsLifeStyleModel.DustProtect = row["DustProtect"].ToString(); } if ((row["Radiogen"] != null) && (row["Radiogen"] != DBNull.Value)) { recordsLifeStyleModel.Radiogen = row["Radiogen"].ToString(); } if ((row["RadiogenProtect"] != null) && (row["RadiogenProtect"] != DBNull.Value)) { recordsLifeStyleModel.RadiogenProtect = row["RadiogenProtect"].ToString(); } if ((row["Physical"] != null) && (row["Physical"] != DBNull.Value)) { recordsLifeStyleModel.Physical = row["Physical"].ToString(); } if ((row["PhysicalProtect"] != null) && (row["PhysicalProtect"] != DBNull.Value)) { recordsLifeStyleModel.PhysicalProtect = row["PhysicalProtect"].ToString(); } if ((row["Chem"] != null) && (row["Chem"] != DBNull.Value)) { recordsLifeStyleModel.Chem = row["Chem"].ToString(); } if ((row["ChemProtect"] != null) && (row["ChemProtect"] != DBNull.Value)) { recordsLifeStyleModel.ChemProtect = row["ChemProtect"].ToString(); } if ((row["Other"] != null) && (row["Other"] != DBNull.Value)) { recordsLifeStyleModel.Other = row["Other"].ToString(); } if ((row["OtherProtect"] != null) && (row["OtherProtect"] != DBNull.Value)) { recordsLifeStyleModel.OtherProtect = row["OtherProtect"].ToString(); } if ((row["WorkType"] != null) && (row["WorkType"] != DBNull.Value)) { recordsLifeStyleModel.WorkType = row["WorkType"].ToString(); } if (((row["WorkTime"] != null) && (row["WorkTime"] != DBNull.Value)) && (row["WorkTime"].ToString() != "")) { recordsLifeStyleModel.WorkTime = new decimal?(decimal.Parse(row["WorkTime"].ToString())); } if ((row["DustProtectEx"] != null) && (row["DustProtectEx"] != DBNull.Value)) { recordsLifeStyleModel.DustProtectEx = row["DustProtectEx"].ToString(); } if ((row["RadiogenProtectEx"] != null) && (row["RadiogenProtectEx"] != DBNull.Value)) { recordsLifeStyleModel.RadiogenProtectEx = row["RadiogenProtectEx"].ToString(); } if ((row["PhysicalProtectEx"] != null) && (row["PhysicalProtectEx"] != DBNull.Value)) { recordsLifeStyleModel.PhysicalProtectEx = row["PhysicalProtectEx"].ToString(); } if ((row["ChemProtectEx"] != null) && (row["ChemProtectEx"] != DBNull.Value)) { recordsLifeStyleModel.ChemProtectEx = row["ChemProtectEx"].ToString(); } if ((row["OtherProtectEx"] != null) && (row["OtherProtectEx"] != DBNull.Value)) { recordsLifeStyleModel.OtherProtectEx = row["OtherProtectEx"].ToString(); } if ((row["DrinkTypeOther"] != null) && (row["DrinkTypeOther"] != DBNull.Value)) { recordsLifeStyleModel.DrinkTypeOther = row["DrinkTypeOther"].ToString(); } if ((row["ExerciseExistenseOther"] != null) && (row["ExerciseExistenseOther"] != DBNull.Value)) //ExerciseExistenseOther { recordsLifeStyleModel.ExerciseExistenseOther = row["ExerciseExistenseOther"].ToString(); } } return(recordsLifeStyleModel); }
public void SavePhysical(string IDCardNo, DateTime CheckDate, string VersionNo, string barCode = "") { try { DataTable dsRequire = new RequireBLL().GetList("TabName = '健康体检' ").Tables[0]; DataView dv = dsRequire.DefaultView; // 获取最后一次体检数据 RecordsCustomerBaseInfoModel customerOldModel = CustomerBaseInfoBLL.GetMaxModel(IDCardNo); if (customerOldModel == null) { customerOldModel = new RecordsCustomerBaseInfoModel(); } RecordsCustomerBaseInfoModel customerNewModel = new RecordsCustomerBaseInfoModel(); customerNewModel.IDCardNo = IDCardNo; customerNewModel.CheckDate = CheckDate; customerNewModel.CustomerID = barCode; customerNewModel.Doctor = ConfigHelper.GetNode("doctorName"); customerNewModel.CreateBy = ConfigHelper.GetNodeDec("doctor"); customerNewModel.CreateDate = DateTime.Now; customerNewModel.LastUpdateBy = ConfigHelper.GetNodeDec("doctor"); customerNewModel.LastUpdateDate = DateTime.Now; #region 一般状况 dv.RowFilter = "Comment='一般状况' AND (IsSetValue='是' OR IsSetValue='预设上次体检') AND OptionName='Symptom' "; DataTable dt = dv.ToTable(); // 栏位名遍历默认项配置 foreach (DataRow item in dt.Rows) { if (item["IsSetValue"].ToString() == "是") { customerNewModel.Symptom = item["ItemValue"].ToString(); } else { customerNewModel.Symptom = customerOldModel.Symptom; customerNewModel.Other = customerOldModel.Other; } } dv.RowFilter = null; dv.RowFilter = "Comment='一般状况' AND (IsSetValue='是' OR IsSetValue='预设上次体检') AND OptionName<>'Symptom' "; dt = dv.ToTable(); RecordsGeneralConditionModel gerneralOldModel = GeneralConditionBLL.GetModelByOutKey(customerOldModel.ID); RecordsGeneralConditionModel gerneralNewModel = new RecordsGeneralConditionModel(); gerneralNewModel = EntityAssignment <RecordsGeneralConditionModel>(gerneralOldModel, gerneralNewModel, dt); #endregion #region 生活方式 dv.RowFilter = null; dv.RowFilter = "Comment='生活方式' AND (IsSetValue='是' OR IsSetValue='预设上次体检') "; dt = dv.ToTable(); RecordsLifeStyleModel lifeStyleOldModel = LifeStyleBLL.GetModelByOutKey(customerOldModel.ID); RecordsLifeStyleModel lifeStyleNewModel = new RecordsLifeStyleModel(); if (lifeStyleOldModel == null) { lifeStyleOldModel = new RecordsLifeStyleModel(); } lifeStyleNewModel = EntityAssignment <RecordsLifeStyleModel>(lifeStyleOldModel, lifeStyleNewModel, dt); #endregion #region 查体信息 dv.RowFilter = null; dv.RowFilter = "Comment='查体信息' AND (IsSetValue='是' OR IsSetValue='预设上次体检') "; dt = dv.ToTable(); RecordsPhysicalExamModel physicalExamOldModel = PhysicalExamBLL.GetModelByOutKey(customerOldModel.ID); RecordsPhysicalExamModel physicalExamNewModel = new RecordsPhysicalExamModel(); if (physicalExamOldModel == null) { physicalExamOldModel = new RecordsPhysicalExamModel(); } physicalExamNewModel = EntityAssignment <RecordsPhysicalExamModel>(physicalExamOldModel, physicalExamNewModel, dt); #endregion #region 辅助检查 dv.RowFilter = null; dv.RowFilter = "Comment='辅助检查' AND (IsSetValue='是' OR IsSetValue='预设上次体检') "; dt = dv.ToTable(); RecordsAssistCheckModel assistCheckOldModel = AssistCheckBLL.GetModelByOutKey(customerOldModel.ID); RecordsAssistCheckModel assistCheckNewModel = new RecordsAssistCheckModel(); if (assistCheckOldModel == null) { assistCheckOldModel = new RecordsAssistCheckModel(); } assistCheckNewModel = EntityAssignment <RecordsAssistCheckModel>(assistCheckOldModel, assistCheckNewModel, dt); #endregion #region 脏器功能 dv.RowFilter = null; dv.RowFilter = "Comment='脏器功能' AND (IsSetValue='是' OR IsSetValue='预设上次体检') "; dt = dv.ToTable(); RecordsVisceraFunctionModel visceraOldModel = VisceraFunctionBLL.GetModelByOutKey(customerOldModel.ID); RecordsVisceraFunctionModel visceraNewModel = new RecordsVisceraFunctionModel(); if (visceraOldModel == null) { visceraOldModel = new RecordsVisceraFunctionModel(); } visceraNewModel = EntityAssignment <RecordsVisceraFunctionModel>(visceraOldModel, visceraNewModel, dt); #endregion #region 中医体质 RecordsMediPhysDistModel mediPhysDistModel = new RecordsMediPhysDistModel(); #endregion #region 健康评价 RecordsAssessmentGuideModel assessmentGuideModel = new RecordsAssessmentGuideModel(); #endregion #region 健康问题 dv.RowFilter = null; dv.RowFilter = "Comment='健康问题' AND (IsSetValue='是' OR IsSetValue='预设上次体检') "; dt = dv.ToTable(); RecordsHealthQuestionModel questionOldModel = HealthQuestionBLL.GetModelByOutKey(customerOldModel.ID); RecordsHealthQuestionModel questionNewModel = new RecordsHealthQuestionModel(); if (questionOldModel == null) { questionOldModel = new RecordsHealthQuestionModel(); } questionNewModel = EntityAssignment <RecordsHealthQuestionModel>(questionOldModel, questionNewModel, dt); #endregion #region 住院史、用药情况 dv.RowFilter = null; dv.RowFilter = "Comment='治疗情况' AND (IsSetValue='是' OR IsSetValue='预设上次体检' OR IsSetValue='预设随访用药') "; dt = dv.ToTable(); // 获取list model对象,用来获取最后一次体检数据的值 List <RecordsHospitalHistoryModel> hospitalHistoryOld = HospitalHistoryBLL.GetModelList( string.Format("IDCardNo='{0}' AND OutKey={1}", IDCardNo, customerOldModel.ID)); List <RecordsFamilyBedHistoryModel> familyBedHistoryInfoOld = FamilyBedHistoryBLL.GetModelList( string.Format("IDCardNo='{0}' AND OutKey={1}", IDCardNo, customerOldModel.ID)); List <RecordsMedicationModel> medicationOld = MedicationBLL.GetModelList( string.Format("IDCardNo='{0}' AND OutKey={1}", IDCardNo, customerOldModel.ID)); if (hospitalHistoryOld == null) { hospitalHistoryOld = new List <RecordsHospitalHistoryModel>(); } if (familyBedHistoryInfoOld == null) { familyBedHistoryInfoOld = new List <RecordsFamilyBedHistoryModel>(); } if (medicationOld == null) { medicationOld = new List <RecordsMedicationModel>(); } #region 随访用药 List <RecordsMedicationModel> medicationFollowUp = new List <RecordsMedicationModel>(); // 高血压随访 ChronicHypertensionVisitModel HyperModel = new ChronicHypertensionVisitBLL().GetMaxModel(IDCardNo, VersionNo); if (HyperModel != null) { List <ChronicDrugConditionModel> DrugConditions = new ChronicDrugConditionBLL().GetModelList( string.Format(" IDCardNo='{0}' AND Type='{1}' AND OutKey='{2}' ", IDCardNo, "1", HyperModel.ID)); foreach (ChronicDrugConditionModel drugModel in DrugConditions) { RecordsMedicationModel newModel = new RecordsMedicationModel { MedicinalName = drugModel.Name, UseNum = drugModel.DosAge, IDCardNo = IDCardNo }; medicationFollowUp.Add(newModel); } } // 糖尿病随访 ChronicDiadetesVisitModel DiaModel = new ChronicDiadetesVisitBLL().GetMaxModel(IDCardNo); if (DiaModel != null) { List <ChronicDrugConditionModel> DiaDrugConditions = new ChronicDrugConditionBLL().GetModelList( string.Format(" IDCardNo='{0}' AND Type='{1}' AND OutKey='{2}' ", IDCardNo, "2", DiaModel.ID)); foreach (ChronicDrugConditionModel drugModel in DiaDrugConditions) { RecordsMedicationModel newModel = new RecordsMedicationModel { MedicinalName = drugModel.Name, UseNum = drugModel.DosAge, IDCardNo = IDCardNo }; medicationFollowUp.Add(newModel); } } #endregion // 用于存储需存档的体检数据 List <RecordsHospitalHistoryModel> hospitalHistoryNew = new List <RecordsHospitalHistoryModel>(); List <RecordsFamilyBedHistoryModel> familyBedHistoryInfoNew = new List <RecordsFamilyBedHistoryModel>(); List <RecordsMedicationModel> medicationNew = new List <RecordsMedicationModel>(); // 临时存储住院史的默认值 RecordsHospitalHistoryModel hModel = new RecordsHospitalHistoryModel(); //通过栏位名,遍历默认项配置 foreach (DataRow item in dt.Rows) { switch (item["ChinName"].ToString()) { case "住院史": if (item["IsSetValue"].ToString() == "是") { if (!string.IsNullOrEmpty(item["ItemValue"].ToString())) { string[] resList = item["ItemValue"].ToString().Split(';'); if (resList.Length > 4) { hModel.InHospitalDate = Convert.ToDateTime(resList[0].ToString()); hModel.OutHospitalDate = Convert.ToDateTime(resList[1].ToString()); hModel.Reason = resList[2].ToString(); hModel.HospitalName = resList[3].ToString(); hModel.IllcaseNum = resList[4].ToString(); } else if (resList.Length == 1) { hModel.Reason = resList[0].ToString(); } hospitalHistoryNew.Add(hModel); } } else { hospitalHistoryNew = hospitalHistoryOld; } break; case "家庭病床史": if (item["IsSetValue"].ToString() == "预设上次体检") { familyBedHistoryInfoNew = familyBedHistoryInfoOld; } break; case "用药情况": if (item["IsSetValue"].ToString() == "预设上次体检") { medicationNew = medicationOld; } else if (item["IsSetValue"].ToString() == "预设随访用药") { medicationNew = medicationFollowUp; } break; default: break; } } #endregion #region 预防接种史 dv.RowFilter = null; dv.RowFilter = "Comment='健康评价' AND (IsSetValue='是' OR IsSetValue='预设上次体检') "; dt = dv.ToTable(); List <RecordsInoculationHistoryModel> inoculationHistoryOld = InoculationHistoryBLL.GetModelList( string.Format("IDCardNo='{0}' AND OutKey={1}", IDCardNo, customerOldModel.ID)); if (inoculationHistoryOld == null) { inoculationHistoryOld = new List <RecordsInoculationHistoryModel>(); } List <RecordsInoculationHistoryModel> inoculationHistoryNew = new List <RecordsInoculationHistoryModel>(); foreach (DataRow item in dt.Rows) { switch (item["ChinName"].ToString()) { case "非免疫预防接种史": if (item["IsSetValue"].ToString() == "预设上次体检") { inoculationHistoryNew = inoculationHistoryOld; } break; } } #endregion #region 保存默认值 // 体检主档保存 int id = CustomerBaseInfoBLL.Add(customerNewModel); if (id > 0) { // 一般状况 gerneralNewModel.IDCardNo = IDCardNo; gerneralNewModel.OutKey = id; GeneralConditionBLL.Add(gerneralNewModel, VersionNo); // 生活方式 lifeStyleNewModel.IDCardNo = IDCardNo; lifeStyleNewModel.OutKey = id; LifeStyleBLL.Add(lifeStyleNewModel); // 查体信息 physicalExamNewModel.IDCardNo = IDCardNo; physicalExamNewModel.OutKey = id; PhysicalExamBLL.Add(physicalExamNewModel); // 辅助检查 assistCheckNewModel.IDCardNo = IDCardNo; assistCheckNewModel.OutKey = id; AssistCheckBLL.Add(assistCheckNewModel); // 脏器功能 visceraNewModel.IDCardNo = IDCardNo; visceraNewModel.OutKey = id; VisceraFunctionBLL.Add(visceraNewModel); // 中医体质 mediPhysDistModel.IDCardNo = IDCardNo; mediPhysDistModel.OutKey = id; MediPhysDistBLL.Add(mediPhysDistModel); // 健康问题 questionNewModel.IDCardNo = IDCardNo; questionNewModel.OutKey = id; HealthQuestionBLL.Add(questionNewModel); // 健康评价 assessmentGuideModel.IDCardNo = IDCardNo; assessmentGuideModel.OutKey = id; AssessmentGuideBLL.Add(assessmentGuideModel); // 住院史 if (hospitalHistoryNew.Count > 0) { foreach (RecordsHospitalHistoryModel recordsInoculationHistoryModel in hospitalHistoryNew) { recordsInoculationHistoryModel.OutKey = id; recordsInoculationHistoryModel.IDCardNo = IDCardNo; } HospitalHistoryBLL.AddList(hospitalHistoryNew); } // 家庭住院史 if (familyBedHistoryInfoNew.Count > 0) { foreach (RecordsFamilyBedHistoryModel model in familyBedHistoryInfoNew) { model.OutKey = id; model.IDCardNo = IDCardNo; } FamilyBedHistoryBLL.AddList(familyBedHistoryInfoNew); } // 用药 if (medicationNew.Count > 0) { foreach (RecordsMedicationModel model in medicationNew) { model.OutKey = id; model.IDCardNo = IDCardNo; } MedicationBLL.AddList(medicationNew); } // 接种史 if (inoculationHistoryNew.Count > 0) { foreach (RecordsInoculationHistoryModel model in inoculationHistoryNew) { model.OutKey = id; model.IDCardNo = IDCardNo; } InoculationHistoryBLL.AddList(inoculationHistoryNew); } } #endregion } catch (Exception ex) { LogHelper.WriteLog(ex.ToString()); throw ex; } }
public int Add(RecordsLifeStyleModel model) { return(this.dal.Add(model)); }
public bool UpdateByTJMiniPad(RecordsLifeStyleModel model, string checkDate) { return(this.dal.UpdateByTJMiniPad(model, checkDate)); }
public bool UpdateServer(RecordsLifeStyleModel model) { return(this.dal.UpdateServer(model)); }