/// <summary> /// 更新终端资料库中的脏器资料--五官 /// </summary> /// <param name="model"></param> /// <param name="RecordDate"></param> /// <returns></returns> public void InsertByMouth(RecordsVisceraFunctionModel model) { StringBuilder builder = new StringBuilder(); builder.Append(@" INSERT INTO ARCHIVE_VISCERAFUNCTION ( PhysicalID ,IDCardNo ,Lips ,ToothResides ,Pharyngeal ,LeftView ,Listen ,RightView ,LeftEyecorrect ,RightEyecorrect ,OutKey ,HypodontiaEx ,SaprodontiaEx ,DentureEx ) VALUES ( @PhysicalID ,@IDCardNo ,@Lips ,@ToothResides ,@Pharyngeal ,@LeftView ,@Listen ,@RightView ,@LeftEyecorrect ,@RightEyecorrect ,@OutKey ,@HypodontiaEx ,@SaprodontiaEx ,@DentureEx ) "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@Lips", model.Lips), new MySqlParameter("@ToothResides", model.ToothResides), new MySqlParameter("@HypodontiaEx", model.HypodontiaEx), new MySqlParameter("@SaprodontiaEx", model.SaprodontiaEx), new MySqlParameter("@DentureEx", model.DentureEx), new MySqlParameter("@Pharyngeal", model.Pharyngeal), new MySqlParameter("@Listen", model.Listen), new MySqlParameter("@LeftView", model.LeftView), new MySqlParameter("@RightView", model.RightView), new MySqlParameter("@LeftEyecorrect", model.LeftEyecorrect), new MySqlParameter("@RightEyecorrect", model.RightEyecorrect), new MySqlParameter("@IDCardNo", model.IDCardNo), new MySqlParameter("@OutKey", model.OutKey), new MySqlParameter("@PhysicalID", model.PhysicalID) }; MySQLHelper.ExecuteSql(builder.ToString(), cmdParms); }
public int AddServer(RecordsVisceraFunctionModel model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into ARCHIVE_VISCERAFUNCTION("); builder.Append("PhysicalID,IDCardNo,Lips,ToothResides,ToothResidesOther,Pharyngeal,LeftView,Listen,RightView,SportFunction,LeftEyecorrect,RightEyecorrect,OutKey,HypodontiaEx,SaprodontiaEx,DentureEx,LipsEx,PharyngealEx )"); builder.Append(" values ("); builder.Append("@PhysicalID,@IDCardNo,@Lips,@ToothResides,@ToothResidesOther,@Pharyngeal,@LeftView,@Listen,@RightView,@SportFunction,@LeftEyecorrect,@RightEyecorrect,@OutKey,@HypodontiaEx,@SaprodontiaEx,@DentureEx,@LipsEx,@PharyngealEx )"); builder.Append(";select @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@PhysicalID", MySqlDbType.String, 8), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@Lips", MySqlDbType.String, 1), new MySqlParameter("@ToothResides", MySqlDbType.String, 100), new MySqlParameter("@ToothResidesOther", MySqlDbType.String, 200), new MySqlParameter("@Pharyngeal", MySqlDbType.String, 1), new MySqlParameter("@LeftView", MySqlDbType.Decimal), new MySqlParameter("@Listen", MySqlDbType.String, 1), new MySqlParameter("@RightView", MySqlDbType.Decimal), new MySqlParameter("@SportFunction", MySqlDbType.String, 1), new MySqlParameter("@LeftEyecorrect", MySqlDbType.Decimal), new MySqlParameter("@RightEyecorrect", MySqlDbType.Decimal), new MySqlParameter("@OutKey", MySqlDbType.Int32, 4), new MySqlParameter("@HypodontiaEx", MySqlDbType.String, 100), new MySqlParameter("@SaprodontiaEx", MySqlDbType.String, 100), new MySqlParameter("@DentureEx", MySqlDbType.String, 100), new MySqlParameter("@LipsEx", MySqlDbType.String, 100), new MySqlParameter("@PharyngealEx", MySqlDbType.String, 100) }; cmdParms[0].Value = model.PhysicalID; cmdParms[1].Value = model.IDCardNo; cmdParms[2].Value = model.Lips; cmdParms[3].Value = model.ToothResides; cmdParms[4].Value = model.ToothResidesOther; cmdParms[5].Value = model.Pharyngeal; cmdParms[6].Value = model.LeftView; cmdParms[7].Value = model.Listen; cmdParms[8].Value = model.RightView; cmdParms[9].Value = model.SportFunction; cmdParms[10].Value = model.LeftEyecorrect; cmdParms[11].Value = model.RightEyecorrect; cmdParms[12].Value = model.OutKey; cmdParms[13].Value = model.HypodontiaEx; //缺齿 cmdParms[14].Value = model.SaprodontiaEx; //龋齿 cmdParms[15].Value = model.DentureEx; //义齿 cmdParms[16].Value = model.LipsEx; //口唇其他 cmdParms[17].Value = model.PharyngealEx; //咽部其他 object single = MySQLHelper.GetSingleServer(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
/// <summary> /// 更新终端资料库中的脏器资料--五官 /// </summary> /// <param name="model"></param> /// <param name="RecordDate"></param> /// <returns></returns> public bool UpdateByMouth(RecordsVisceraFunctionModel model, string RecordDate) { StringBuilder builder = new StringBuilder(); builder.Append(@" UPDATE ARCHIVE_VISCERAFUNCTION D SET Lips = @Lips ,ToothResides= @ToothResides ,Pharyngeal= @Pharyngeal ,LeftView= @LeftView ,Listen= @Listen ,RightView= @RightView ,LeftEyecorrect= @LeftEyecorrect ,RightEyecorrect= @RightEyecorrect ,HypodontiaEx = @HypodontiaEx ,SaprodontiaEx = @SaprodontiaEx ,DentureEx = @DentureEx WHERE D.OUTKEY= ( SELECT M.ID FROM ARCHIVE_CUSTOMERBASEINFO M WHERE IFNULL(M.IsDel,'')!='Y' AND M.IDCardNo =@IDCardNo AND LEFT(M.CheckDate,4) = @CheckDate order by M.CheckDate DESC LIMIT 0,1 ); "); if (Convert.ToString(RecordDate).Length > 3) { RecordDate = RecordDate.Substring(0, 4); } MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@Lips", model.Lips), new MySqlParameter("@ToothResides", model.ToothResides), new MySqlParameter("@HypodontiaEx", model.HypodontiaEx), new MySqlParameter("@SaprodontiaEx", model.SaprodontiaEx), new MySqlParameter("@DentureEx", model.DentureEx), new MySqlParameter("@Pharyngeal", model.Pharyngeal), new MySqlParameter("@Listen", model.Listen), new MySqlParameter("@LeftView", model.LeftView), new MySqlParameter("@RightView", model.RightView), new MySqlParameter("@LeftEyecorrect", model.LeftEyecorrect), new MySqlParameter("@RightEyecorrect", model.RightEyecorrect), new MySqlParameter("@IDCardNo", model.IDCardNo), new MySqlParameter("@CheckDate", RecordDate) }; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public List <RecordsVisceraFunctionModel> DataTableToList(DataTable dt) { List <RecordsVisceraFunctionModel> list = new List <RecordsVisceraFunctionModel>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { RecordsVisceraFunctionModel item = this.dal.DataRowToModel(dt.Rows[i]); if (item != null) { list.Add(item); } } } return(list); }
public bool UpdateVsiual(RecordsVisceraFunctionModel model) { StringBuilder builder = new StringBuilder(); List <MySqlParameter> ilistStr = new List <MySqlParameter>(); MySqlParameter[] cmdParms = new MySqlParameter[] { }; builder.Append(@"UPDATE ARCHIVE_VISCERAFUNCTION SET IDCardNo=IDCardNo "); if (model.LeftView.HasValue) { builder.Append(",LeftView=@LeftView"); ilistStr.Add(new MySqlParameter("@LeftView", model.LeftView)); } if (model.LeftEyecorrect.HasValue) { builder.Append(",LeftEyecorrect=@LeftEyecorrect"); ilistStr.Add(new MySqlParameter("@LeftEyecorrect", model.LeftEyecorrect)); } if (model.RightView.HasValue) { builder.Append(",RightView=@RightView"); ilistStr.Add(new MySqlParameter("@RightView", model.RightView)); } if (model.RightEyecorrect.HasValue) { builder.Append(",RightEyecorrect=@RightEyecorrect"); ilistStr.Add(new MySqlParameter("@RightEyecorrect", model.RightEyecorrect)); } builder.Append(" WHERE IDCardNo = @IDCardNo AND OutKey = @OutKey"); ilistStr.Add(new MySqlParameter("@IDCardNo", model.IDCardNo)); ilistStr.Add(new MySqlParameter("@OutKey", model.OutKey)); cmdParms = ilistStr.ToArray(); return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
/// <summary> /// 更新终端资料库中的脏器资料--五官 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateByMouth(RecordsVisceraFunctionModel model) { StringBuilder builder = new StringBuilder(); builder.Append(@" UPDATE ARCHIVE_VISCERAFUNCTION D SET Lips = @Lips ,ToothResides= @ToothResides ,Pharyngeal= @Pharyngeal ,LeftView= @LeftView ,Listen= @Listen ,RightView= @RightView ,LeftEyecorrect= @LeftEyecorrect ,RightEyecorrect= @RightEyecorrect ,HypodontiaEx = @HypodontiaEx ,SaprodontiaEx = @SaprodontiaEx ,DentureEx = @DentureEx WHERE OutKey=@OutKey "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@Lips", model.Lips), new MySqlParameter("@ToothResides", model.ToothResides), new MySqlParameter("@HypodontiaEx", model.HypodontiaEx), new MySqlParameter("@SaprodontiaEx", model.SaprodontiaEx), new MySqlParameter("@DentureEx", model.DentureEx), new MySqlParameter("@Pharyngeal", model.Pharyngeal), new MySqlParameter("@Listen", model.Listen), new MySqlParameter("@LeftView", model.LeftView), new MySqlParameter("@RightView", model.RightView), new MySqlParameter("@LeftEyecorrect", model.LeftEyecorrect), new MySqlParameter("@RightEyecorrect", model.RightEyecorrect), new MySqlParameter("@IDCardNo", model.IDCardNo), new MySqlParameter("@OutKey", model.OutKey) }; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public bool UpdateByTJMiniPad(RecordsVisceraFunctionModel model, string checkDate) //体检问询同步 { StringBuilder builder = new StringBuilder(); builder.Append(@"UPDATE ARCHIVE_VISCERAFUNCTION D SET Lips=@Lips,ToothResides=@ToothResides,Pharyngeal=@Pharyngeal, Listen=@Listen,SportFunction=@SportFunction,HypodontiaEx=@HypodontiaEx, SaprodontiaEx=@SaprodontiaEx,DentureEx=@DentureEx 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("@Lips", model.Lips), new MySqlParameter("@ToothResides", model.ToothResides), new MySqlParameter("@Pharyngeal", model.Pharyngeal), new MySqlParameter("@Listen", model.Listen), new MySqlParameter("@SportFunction", model.SportFunction), new MySqlParameter("@HypodontiaEx", model.HypodontiaEx), new MySqlParameter("@SaprodontiaEx", model.SaprodontiaEx), new MySqlParameter("@DentureEx", model.DentureEx) }; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
/// <summary> /// 更新终端资料库中的脏器资料--五官 /// </summary> /// <param name="model"></param> /// <returns></returns> public bool UpdateByMouth(RecordsVisceraFunctionModel model) { return(this.dal.UpdateByMouth(model)); }
public bool UpdateServer(RecordsVisceraFunctionModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update ARCHIVE_VISCERAFUNCTION set "); builder.Append("PhysicalID=@PhysicalID,"); builder.Append("IDCardNo=@IDCardNo,"); builder.Append("Lips=@Lips,"); builder.Append("ToothResides=@ToothResides,"); builder.Append("Pharyngeal=@Pharyngeal,"); builder.Append("LeftView=@LeftView,"); builder.Append("Listen=@Listen,"); builder.Append("RightView=@RightView,"); builder.Append("SportFunction=@SportFunction,"); builder.Append("LeftEyecorrect=@LeftEyecorrect,"); builder.Append("RightEyecorrect=@RightEyecorrect,"); builder.Append("ToothResidesOther=@ToothResidesOther,"); builder.Append("HypodontiaEx=@HypodontiaEx,"); builder.Append("SaprodontiaEx=@SaprodontiaEx,"); builder.Append("DentureEx=@DentureEx,"); builder.Append("LipsEx=@LipsEx, "); builder.Append("PharyngealEx=@PharyngealEx "); builder.Append(" where IDCardNo=@IDCardNo"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@PhysicalID", MySqlDbType.String, 8), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@Lips", MySqlDbType.String, 1), new MySqlParameter("@ToothResides", MySqlDbType.String, 100), new MySqlParameter("@Pharyngeal", MySqlDbType.String, 1), new MySqlParameter("@LeftView", MySqlDbType.Decimal), new MySqlParameter("@Listen", MySqlDbType.String, 1), new MySqlParameter("@RightView", MySqlDbType.Decimal), new MySqlParameter("@SportFunction", MySqlDbType.String, 1), new MySqlParameter("@LeftEyecorrect", MySqlDbType.Decimal), new MySqlParameter("@RightEyecorrect", MySqlDbType.Decimal), new MySqlParameter("@ToothResidesOther", MySqlDbType.String, 200), new MySqlParameter("@HypodontiaEx", MySqlDbType.String, 100), new MySqlParameter("@SaprodontiaEx", MySqlDbType.String, 100), new MySqlParameter("@DentureEx", MySqlDbType.String, 100), new MySqlParameter("@LipsEx", MySqlDbType.String, 100), new MySqlParameter("@PharyngealEx", MySqlDbType.String, 100) // new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.PhysicalID; cmdParms[1].Value = model.IDCardNo; cmdParms[2].Value = model.Lips; cmdParms[3].Value = model.ToothResides; cmdParms[4].Value = model.Pharyngeal; cmdParms[5].Value = model.LeftView; cmdParms[6].Value = model.Listen; cmdParms[7].Value = model.RightView; cmdParms[8].Value = model.SportFunction; cmdParms[9].Value = model.LeftEyecorrect; cmdParms[10].Value = model.RightEyecorrect; cmdParms[11].Value = model.ToothResidesOther; cmdParms[12].Value = model.HypodontiaEx; cmdParms[13].Value = model.SaprodontiaEx; cmdParms[14].Value = model.DentureEx; cmdParms[15].Value = model.LipsEx; cmdParms[16].Value = model.PharyngealEx; //cmdParms[12].Value = model.ID; return(MySQLHelper.ExecuteSqlServer(builder.ToString(), cmdParms) > 0); }
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 AddServer(RecordsVisceraFunctionModel model) { return(this.dal.AddServer(model)); }
public bool UpdateByTJMiniPad(RecordsVisceraFunctionModel model, string checkDate) //Ìå¼ìÎÊѯͬ²½ { return(this.dal.UpdateByTJMiniPad(model, checkDate)); }
public bool UpdateServer(RecordsVisceraFunctionModel model) { return(this.dal.UpdateServer(model)); }
public bool UpdateVsiual(RecordsVisceraFunctionModel model) { return(dal.UpdateVsiual(model)); }
/// <summary> /// 新增终端资料库中的脏器资料--五官 /// </summary> /// <param name="model"></param> /// <param name="RecordDate"></param> /// <returns></returns> public void InsertByMouth(RecordsVisceraFunctionModel model) { this.dal.InsertByMouth(model); }
public RecordsVisceraFunctionModel DataRowToModel(DataRow row) { RecordsVisceraFunctionModel recordsVisceraFunctionModel = new RecordsVisceraFunctionModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { recordsVisceraFunctionModel.ID = int.Parse(row["ID"].ToString()); } if (((row["OutKey"] != null) && (row["OutKey"] != DBNull.Value)) && (row["OutKey"].ToString() != "")) { recordsVisceraFunctionModel.OutKey = int.Parse(row["OutKey"].ToString()); } if ((row["PhysicalID"] != null) && (row["PhysicalID"] != DBNull.Value)) { recordsVisceraFunctionModel.PhysicalID = row["PhysicalID"].ToString(); } if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)) { recordsVisceraFunctionModel.IDCardNo = row["IDCardNo"].ToString(); } if ((row["Lips"] != null) && (row["Lips"] != DBNull.Value)) { recordsVisceraFunctionModel.Lips = row["Lips"].ToString(); } if ((row["ToothResides"] != null) && (row["ToothResides"] != DBNull.Value)) { recordsVisceraFunctionModel.ToothResides = row["ToothResides"].ToString(); } if ((row["ToothResidesOther"] != null) && (row["ToothResidesOther"] != DBNull.Value)) { recordsVisceraFunctionModel.ToothResidesOther = row["ToothResidesOther"].ToString(); } if ((row["Pharyngeal"] != null) && (row["Pharyngeal"] != DBNull.Value)) { recordsVisceraFunctionModel.Pharyngeal = row["Pharyngeal"].ToString(); } if (((row["LeftView"] != null) && (row["LeftView"] != DBNull.Value)) && (row["LeftView"].ToString() != "")) { recordsVisceraFunctionModel.LeftView = new decimal?(decimal.Parse(row["LeftView"].ToString())); } if ((row["Listen"] != null) && (row["Listen"] != DBNull.Value)) { recordsVisceraFunctionModel.Listen = row["Listen"].ToString(); } if (((row["RightView"] != null) && (row["RightView"] != DBNull.Value)) && (row["RightView"].ToString() != "")) { recordsVisceraFunctionModel.RightView = new decimal?(decimal.Parse(row["RightView"].ToString())); } if ((row["SportFunction"] != null) && (row["SportFunction"] != DBNull.Value)) { recordsVisceraFunctionModel.SportFunction = row["SportFunction"].ToString(); } if (((row["LeftEyecorrect"] != null) && (row["LeftEyecorrect"] != DBNull.Value)) && (row["LeftEyecorrect"].ToString() != "")) { recordsVisceraFunctionModel.LeftEyecorrect = new decimal?(decimal.Parse(row["LeftEyecorrect"].ToString())); } if (((row["RightEyecorrect"] != null) && (row["RightEyecorrect"] != DBNull.Value)) && (row["RightEyecorrect"].ToString() != "")) { recordsVisceraFunctionModel.RightEyecorrect = new decimal?(decimal.Parse(row["RightEyecorrect"].ToString())); } if ((row["HypodontiaEx"] != null) && (row["HypodontiaEx"] != DBNull.Value)) { recordsVisceraFunctionModel.HypodontiaEx = row["HypodontiaEx"].ToString(); } if ((row["DentureEx"] != null) && (row["DentureEx"] != DBNull.Value)) { recordsVisceraFunctionModel.DentureEx = row["DentureEx"].ToString(); } if ((row["SaprodontiaEx"] != null) && (row["SaprodontiaEx"] != DBNull.Value)) { recordsVisceraFunctionModel.SaprodontiaEx = row["SaprodontiaEx"].ToString(); } if ((row["LipsEx"] != null) && (row["LipsEx"] != DBNull.Value)) { recordsVisceraFunctionModel.LipsEx = row["LipsEx"].ToString(); } if ((row["PharyngealEx"] != null) && (row["PharyngealEx"] != DBNull.Value)) { recordsVisceraFunctionModel.PharyngealEx = row["PharyngealEx"].ToString(); } } return(recordsVisceraFunctionModel); }
private void pictureBoxDataupload_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) { if (string.IsNullOrEmpty(row["IDCardNo"].ToString())) { continue; } int OutKey = Convert.ToInt32(row["ID"].ToString()); // 基本信息 this.Model = new RecordsBaseInfoBLL().GetModel(row["IDCardNo"].ToString()); if (this.Model == null) { this.Model = new RecordsBaseInfoModel(); } // 健康评价 this.AssessmentGuides = new RecordsAssessmentGuideBLL().GetModelByOutKey(OutKey); if (this.AssessmentGuides == null) { this.AssessmentGuides = new RecordsAssessmentGuideModel(); } this.AssessmentGuides.IDCardNo = this.Model.IDCardNo; // 辅助检查 this.AssistCheck = new RecordsAssistCheckBLL().GetModelByOutKey(OutKey); if (this.AssistCheck == null) { this.AssistCheck = new RecordsAssistCheckModel(); } // 一般状况 this.generalconditionmodel = new RecordsGeneralConditionBLL().GetModelByOutKey(OutKey); if (this.generalconditionmodel == null) { this.generalconditionmodel = new RecordsGeneralConditionModel(); } // 查体 this.physicalModel = new RecordsPhysicalExamBLL().GetModelByOutKey(OutKey); if (this.physicalModel == null) { this.physicalModel = new RecordsPhysicalExamModel(); } // 现存健康问题 this.questionModel = new RecordsHealthQuestionBLL().GetModelByOutKey(OutKey); if (this.questionModel == null) { this.questionModel = new RecordsHealthQuestionModel(); } // 生活方式 this.liftModel = new RecordsLifeStyleBLL().GetModelByOutKey(OutKey); if (this.liftModel == null) { this.liftModel = new RecordsLifeStyleModel(); } //脏器功能 this.visceraFunctionModel = new RecordsVisceraFunctionBLL().GetModelByOutKey(OutKey); if (this.visceraFunctionModel == null) { this.visceraFunctionModel = new RecordsVisceraFunctionModel(); } AssessmentGuides.IsNormal = "1"; AssessmentGuides.Exception1 = null; AssessmentGuides.Exception2 = null; AssessmentGuides.Exception3 = null; AssessmentGuides.Exception4 = null; AssessmentGuides.HealthGuide = null; AssessmentGuides.DangerControl = null; AssessmentGuides.Arm = null; AssessmentGuides.VaccineAdvice = null; AssessmentGuides.Other = null; AssessmentGuides.WaistlineArm = null; #region 赋值给RecordsManageMentModel RecordsManageMentModel.Symptom = row["Symptom"].ToString(); RecordsManageMentModel.Other = row["Other"].ToString(); RecordsManageMentModel.BMI = this.generalconditionmodel.BMI; RecordsManageMentModel.RightHeight = this.generalconditionmodel.RightHeight; RecordsManageMentModel.RightPre = this.generalconditionmodel.RightPre; RecordsManageMentModel.LeftHeight = this.generalconditionmodel.LeftHeight; RecordsManageMentModel.LeftPre = this.generalconditionmodel.LeftPre; RecordsManageMentModel.Waistline = this.generalconditionmodel.Waistline; RecordsManageMentModel.Height = this.generalconditionmodel.Height; RecordsManageMentModel.PulseRate = this.generalconditionmodel.PulseRate; RecordsManageMentModel.Weight = this.generalconditionmodel.Weight; RecordsManageMentModel.OldSelfCareability = this.generalconditionmodel.OldSelfCareability; RecordsManageMentModel.DrinkRate = this.liftModel.DrinkRate; RecordsManageMentModel.SmokeCondition = this.liftModel.SmokeCondition; RecordsManageMentModel.ExerciseRate = this.liftModel.ExerciseRate; if (this.liftModel.ExerciseTimes.HasValue) { RecordsManageMentModel.ExerciseTimes = this.liftModel.ExerciseTimes.ToString(); } else { RecordsManageMentModel.ExerciseTimes = ""; } RecordsManageMentModel.DietaryHabit = this.liftModel.DietaryHabit; RecordsManageMentModel.ECG = this.AssistCheck.ECG; RecordsManageMentModel.ECGEx = ""; if (!string.IsNullOrEmpty(this.AssistCheck.ECG)) { if (this.AssistCheck.ECG.Contains("2")) { RecordsManageMentModel.ECGEx += "ST-T改变,"; } if (this.AssistCheck.ECG.Contains("3")) { RecordsManageMentModel.ECGEx += "陈旧性心肌梗塞,"; } if (this.AssistCheck.ECG.Contains("4")) { RecordsManageMentModel.ECGEx += "窦性心动过速,"; } if (this.AssistCheck.ECG.Contains("5")) { RecordsManageMentModel.ECGEx += "窦性心动过缓,"; } if (this.AssistCheck.ECG.Contains("6")) { RecordsManageMentModel.ECGEx += "早搏,"; } if (this.AssistCheck.ECG.Contains("7")) { RecordsManageMentModel.ECGEx += "房颤,"; } if (this.AssistCheck.ECG.Contains("8")) { RecordsManageMentModel.ECGEx += "房室传导阻滞,"; } if (this.AssistCheck.ECG.Contains("9")) { RecordsManageMentModel.ECGEx += this.AssistCheck.ECGEx; } } else { RecordsManageMentModel.ECGEx = ""; } RecordsManageMentModel.BCHAO = this.AssistCheck.BCHAO; RecordsManageMentModel.BCHAOEx = this.AssistCheck.BCHAOEx; RecordsManageMentModel.PRO = this.AssistCheck.PRO; RecordsManageMentModel.GLU = this.AssistCheck.GLU; RecordsManageMentModel.KET = this.AssistCheck.KET; RecordsManageMentModel.BLD = this.AssistCheck.BLD; RecordsManageMentModel.UrineOther = this.AssistCheck.UrineOther; RecordsManageMentModel.HB = this.AssistCheck.HB; RecordsManageMentModel.WBC = this.AssistCheck.WBC; RecordsManageMentModel.PLT = this.AssistCheck.PLT; RecordsManageMentModel.SGPT = this.AssistCheck.SGPT; RecordsManageMentModel.GOT = this.AssistCheck.GOT; RecordsManageMentModel.BP = this.AssistCheck.BP; RecordsManageMentModel.TBIL = this.AssistCheck.TBIL; RecordsManageMentModel.CB = this.AssistCheck.CB; RecordsManageMentModel.SCR = this.AssistCheck.SCR; RecordsManageMentModel.BUN = this.AssistCheck.BUN; RecordsManageMentModel.PC = this.AssistCheck.PC; RecordsManageMentModel.TC = this.AssistCheck.TC; RecordsManageMentModel.HYPE = this.AssistCheck.HYPE; RecordsManageMentModel.TG = this.AssistCheck.TG; RecordsManageMentModel.GT = this.AssistCheck.GT; RecordsManageMentModel.LowCho = this.AssistCheck.LowCho; RecordsManageMentModel.HeiCho = this.AssistCheck.HeiCho; RecordsManageMentModel.FPGL = this.AssistCheck.FPGL; RecordsManageMentModel.HCY = this.AssistCheck.HCY; RecordsManageMentModel.Other = this.AssistCheck.Other; if (community.Equals("威海美年大健康") && StringPlus.toString(this.AssistCheck.UA) != "") { RecordsManageMentModel.UA = this.AssistCheck.UA; } RecordsManageMentModel.BrainDis = this.questionModel.BrainDis; RecordsManageMentModel.RenalDis = this.questionModel.RenalDis; RecordsManageMentModel.HeartDis = this.questionModel.HeartDis; RecordsManageMentModel.EyeDis = this.questionModel.EyeDis; RecordsManageMentModel.NerveDis = this.questionModel.NerveDis; RecordsManageMentModel.ElseDis = this.questionModel.ElseDis; RecordsManageMentModel.BrainOther = this.questionModel.BrainOther; RecordsManageMentModel.RenalOther = this.questionModel.RenalOther; RecordsManageMentModel.HeartOther = this.questionModel.HeartOther; RecordsManageMentModel.EyeOther = this.questionModel.EyeOther; RecordsManageMentModel.NerveOther = this.questionModel.NerveOther; RecordsManageMentModel.ElseOther = this.questionModel.ElseOther; RecordsManageMentModel.BarrelChest = this.physicalModel.BarrelChest; //桶状胸 RecordsManageMentModel.BreathSounds = this.physicalModel.BreastEx; //呼吸音 RecordsManageMentModel.Rale = this.physicalModel.Rale; //罗音 RecordsManageMentModel.HeartRhythm = this.physicalModel.HeartRhythm; //心律 RecordsManageMentModel.Noise = this.physicalModel.Noise; //杂音 RecordsManageMentModel.PressPain = this.physicalModel.PressPain; //压痛 RecordsManageMentModel.EnclosedMass = this.physicalModel.EnclosedMass; //包块 RecordsManageMentModel.Liver = this.physicalModel.Liver; //肝大 RecordsManageMentModel.Spleen = this.physicalModel.Spleen; //脾大 RecordsManageMentModel.Voiced = this.physicalModel.Voiced; //移动性浊音 RecordsManageMentModel.FootBack = this.physicalModel.FootBack; //足背动脉搏动 RecordsManageMentModel.Edema = this.physicalModel.Edema; // 下肢水肿 RecordsManageMentModel.LeftView = this.visceraFunctionModel.LeftView; RecordsManageMentModel.RightView = this.visceraFunctionModel.RightView; RecordsManageMentModel.HeartRate = this.physicalModel.HeartRate; RecordsManageMentModel.Listen = visceraFunctionModel.Listen; RecordsManageMentModel.SportFunction = visceraFunctionModel.SportFunction; #endregion healthAssessment = new HealthAssessment { Model = this.Model }; olderCnandResult = new OlderCnAndResult(); // 异常信息 this.AssessmentGuides = healthAssessment.SetHealthEx(this.AssessmentGuides); // 危险因素控制 this.AssessmentGuides = healthAssessment.SetDangerous(this.AssessmentGuides); //随访中医辨识更新 olderCnandResult.SetCnResult(row["IDCardNo"].ToString()); // 健康评价异常的更新 if (this.AssessmentGuides != null) { this.AssessmentGuides.OutKey = OutKey; RecordsAssessmentGuideBLL recordsAssessmentGuideBll = new RecordsAssessmentGuideBLL(); if (!recordsAssessmentGuideBll.ExistsOutKey(this.AssessmentGuides.IDCardNo, OutKey)) { if (recordsAssessmentGuideBll.Add(this.AssessmentGuides) > 0) { amount++; labUploadnum.Text = amount.ToString(); progressBar1.Value = amount; } } else { if (recordsAssessmentGuideBll.Update(this.AssessmentGuides)) { amount++; labUploadnum.Text = amount.ToString(); progressBar1.Value = amount; } } } } MessageBox.Show("成功匹配:" + amount + "条数据!", "提示"); progressBar1.Visible = false; }
/// <summary> /// 更新终端资料库中的脏器资料--五官 /// </summary> /// <param name="model"></param> /// <param name="RecordDate"></param> /// <returns></returns> public bool UpdateByMouth(RecordsVisceraFunctionModel model, string RecordDate) { return(this.dal.UpdateByMouth(model, RecordDate)); }