public ChronicHypertensionVisitModel ExistsCheckDate(ChronicHypertensionVisitModel model) { StringBuilder builder = new StringBuilder(); builder.Append("select ID,RecordID,CustomerID,IDCardNo,CustomerName,"); builder.Append("FollowUpDate,FollowUpDoctor,NextFollowUpDate,"); builder.Append("Symptom,SympToMother,Hypertension,Hypotension,Weight,BMI,HeartRate,PhysicalSympToMother,"); builder.Append("DailySmokeNum,DailyDrinkNum,SportTimePerWeek,SportPerMinuteTime,EatSaltType,EatSaltTarGet,"); builder.Append("PsyChoadJustMent,ObeyDoctorBehavior,AssistantExam,MedicationCompliance,Adr,AdrEx,FollowUpType,"); builder.Append("ReferralReason,ReferralOrg,FollowUpWay,WeightTarGet,BMITarGet,DailySmokeNumTarget,DailyDrinkNumTarget,"); builder.Append("SportTimeSperWeekTarget,SportPerMinutesTimeTarget,CreatedBy,CreatedDate,"); builder.Append("LastUpdateBy,LastUpdateDate,IsDel,Hight,DoctorView,IsReferral,NextMeasures,ReferralContacts,ReferralResult,Remarks from CD_HYPERTENSIONFOLLOWUP "); builder.Append(" where FollowUpDate = @FollowUpDate and IDCardNo =@IDCardNo "); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@FollowUpDate", MySqlDbType.Date), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21) }; cmdParms[0].Value = model.FollowUpDate; cmdParms[1].Value = model.IDCardNo; new ChronicHypertensionVisitModel(); DataSet set = MySQLHelper.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count > 0) { return(this.DataRowToModel(set.Tables[0].Rows[0])); } return(null); }
public List <ChronicHypertensionVisitModel> DataTableToList(DataTable dt) { List <ChronicHypertensionVisitModel> list = new List <ChronicHypertensionVisitModel>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { ChronicHypertensionVisitModel 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(ChronicHypertensionVisitModel model, string Version = "V2.0") { return(this.dal.Add(model, Version)); }
public bool UpdateDate(ChronicHypertensionVisitModel model, string Version = "V2.0") { return(dal.UpdateDate(model, Version)); }
/// <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 UpdateDate(ChronicHypertensionVisitModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update CD_HYPERTENSIONFOLLOWUP set "); decimal d; if (decimal.TryParse(model.Hypertension.ToString(), out d)) { builder.Append("Hypertension='" + d + "',"); } if (decimal.TryParse(model.Hypotension.ToString(), out d)) { builder.Append("Hypotension='" + d + "',"); } if (decimal.TryParse(model.Weight.ToString(), out d)) { builder.Append("Weight='" + d + "',"); } if (decimal.TryParse(model.BMI.ToString(), out d)) { builder.Append("BMI='" + d + "',"); } if (decimal.TryParse(model.Hight.ToString(), out d)) { builder.Append("Hight='" + d + "',"); } if (decimal.TryParse(model.DailySmokeNum.ToString(), out d)) { builder.Append("DailySmokeNum='" + d + "',"); } if (decimal.TryParse(model.DailyDrinkNum.ToString(), out d)) { builder.Append("DailyDrinkNum='" + d + "',"); } if (model.BMI < 24) { builder.Append("WeightTarGet=null,"); } else { if (decimal.TryParse(model.WeightTarGet.ToString(), out d)) { builder.Append("WeightTarGet='" + d + "',"); } } builder.Append("DailySmokeNumTarget='" + model.DailySmokeNumTarget + "',"); builder.Append("DailyDrinkNumTarget='" + model.DailyDrinkNumTarget + "',"); builder.Append("SportTimeSperWeekTarget='" + model.SportTimeSperWeekTarget + "',"); builder.Append("SportPerMinutesTimeTarget='" + model.SportPerMinutesTimeTarget + "',"); builder.Append("AssistantExam='" + model.AssistantExam + "',"); if (decimal.TryParse(model.HeartRate.ToString(), out d)) { builder.Append("HeartRate='" + d + "',"); } string sql = builder.ToString(); sql = sql.Substring(0, sql.LastIndexOf(',')); sql += " where ID=(select * from (select ID from CD_HYPERTENSIONFOLLOWUP where FollowUpDate like '" + DateTime.Now.Year + "%' and IDCardNo='" + model.IDCardNo + "' order by FollowUpDate desc LIMIT 1 )t)"; return(MySQLHelper.ExecuteSql(sql) > 0); }
public bool Update(ChronicHypertensionVisitModel model) { StringBuilder builder = new StringBuilder(); builder.Append("update CD_HYPERTENSIONFOLLOWUP set "); builder.Append("RecordID=@RecordID,"); builder.Append("CustomerID=@CustomerID,"); builder.Append("IDCardNo=@IDCardNo,"); builder.Append("CustomerName=@CustomerName,"); builder.Append("FollowUpDate=@FollowUpDate,"); builder.Append("FollowUpDoctor=@FollowUpDoctor,"); builder.Append("NextFollowUpDate=@NextFollowUpDate,"); builder.Append("Symptom=@Symptom,"); builder.Append("SympToMother=@SympToMother,"); builder.Append("Hypertension=@Hypertension,"); builder.Append("Hypotension=@Hypotension,"); builder.Append("Weight=@Weight,"); builder.Append("BMI=@BMI,"); builder.Append("HeartRate=@HeartRate,"); builder.Append("PhysicalSympToMother=@PhysicalSympToMother,"); builder.Append("DailySmokeNum=@DailySmokeNum,"); builder.Append("DailyDrinkNum=@DailyDrinkNum,"); builder.Append("SportTimePerWeek=@SportTimePerWeek,"); builder.Append("SportPerMinuteTime=@SportPerMinuteTime,"); builder.Append("EatSaltType=@EatSaltType,"); builder.Append("EatSaltTarGet=@EatSaltTarGet,"); builder.Append("PsyChoadJustMent=@PsyChoadJustMent,"); builder.Append("ObeyDoctorBehavior=@ObeyDoctorBehavior,"); builder.Append("AssistantExam=@AssistantExam,"); builder.Append("MedicationCompliance=@MedicationCompliance,"); builder.Append("Adr=@Adr,"); builder.Append("AdrEx=@AdrEx,"); builder.Append("FollowUpType=@FollowUpType,"); builder.Append("ReferralReason=@ReferralReason,"); builder.Append("ReferralOrg=@ReferralOrg,"); builder.Append("FollowUpWay=@FollowUpWay,"); builder.Append("WeightTarGet=@WeightTarGet,"); builder.Append("BMITarGet=@BMITarGet,"); builder.Append("DailySmokeNumTarget=@DailySmokeNumTarget,"); builder.Append("DailyDrinkNumTarget=@DailyDrinkNumTarget,"); builder.Append("SportTimeSperWeekTarget=@SportTimeSperWeekTarget,"); builder.Append("SportPerMinutesTimeTarget=@SportPerMinutesTimeTarget,"); builder.Append("CreatedBy=@CreatedBy,"); builder.Append("CreatedDate=@CreatedDate,"); builder.Append("LastUpdateBy=@LastUpdateBy,"); builder.Append("LastUpdateDate=@LastUpdateDate,"); builder.Append("IsDel=@IsDel,"); builder.Append("Hight=@Hight, "); builder.Append("DoctorView=@DoctorView, "); builder.Append("IsReferral=@IsReferral, "); builder.Append("NextMeasures=@NextMeasures, "); builder.Append("ReferralContacts=@ReferralContacts, "); builder.Append("ReferralResult=@ReferralResult, "); builder.Append("Remarks=@Remarks "); builder.Append(" where ID=@ID"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@RecordID", MySqlDbType.String, 17), new MySqlParameter("@CustomerID", MySqlDbType.String, 32), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@CustomerName", MySqlDbType.String, 30), new MySqlParameter("@FollowUpDate", MySqlDbType.Date), new MySqlParameter("@FollowUpDoctor", MySqlDbType.String, 30), new MySqlParameter("@NextFollowUpDate", MySqlDbType.Date), new MySqlParameter("@Symptom", MySqlDbType.String, 20), new MySqlParameter("@SympToMother", MySqlDbType.String, 500), new MySqlParameter("@Hypertension", MySqlDbType.Decimal), new MySqlParameter("@Hypotension", MySqlDbType.Decimal), new MySqlParameter("@Weight", MySqlDbType.Decimal), new MySqlParameter("@BMI", MySqlDbType.Decimal), new MySqlParameter("@HeartRate", MySqlDbType.Decimal), new MySqlParameter("@PhysicalSympToMother", MySqlDbType.String, 500), new MySqlParameter("@DailySmokeNum", MySqlDbType.Decimal), new MySqlParameter("@DailyDrinkNum", MySqlDbType.Decimal), new MySqlParameter("@SportTimePerWeek", MySqlDbType.Decimal), new MySqlParameter("@SportPerMinuteTime", MySqlDbType.Decimal), new MySqlParameter("@EatSaltType", MySqlDbType.String, 1), new MySqlParameter("@EatSaltTarGet", MySqlDbType.String, 1), new MySqlParameter("@PsyChoadJustMent", MySqlDbType.String, 500), new MySqlParameter("@ObeyDoctorBehavior", MySqlDbType.String, 1), new MySqlParameter("@AssistantExam", MySqlDbType.String, 500), new MySqlParameter("@MedicationCompliance", MySqlDbType.String, 1), new MySqlParameter("@Adr", MySqlDbType.String, 1), new MySqlParameter("@AdrEx", MySqlDbType.String, 500), new MySqlParameter("@FollowUpType", MySqlDbType.String, 1), new MySqlParameter("@ReferralReason", MySqlDbType.String, 500), new MySqlParameter("@ReferralOrg", MySqlDbType.String, 80), new MySqlParameter("@FollowUpWay", MySqlDbType.String, 1), new MySqlParameter("@WeightTarGet", MySqlDbType.Decimal), new MySqlParameter("@BMITarGet", MySqlDbType.Decimal), new MySqlParameter("@DailySmokeNumTarget", MySqlDbType.Decimal), new MySqlParameter("@DailyDrinkNumTarget", MySqlDbType.Decimal), new MySqlParameter("@SportTimeSperWeekTarget", MySqlDbType.Decimal), new MySqlParameter("@SportPerMinutesTimeTarget", MySqlDbType.Decimal), new MySqlParameter("@CreatedBy", MySqlDbType.String, 18), new MySqlParameter("@CreatedDate", MySqlDbType.Date), new MySqlParameter("@LastUpdateBy", MySqlDbType.String, 18), new MySqlParameter("@LastUpdateDate", MySqlDbType.Date), new MySqlParameter("@IsDel", MySqlDbType.String, 1), new MySqlParameter("@Hight", MySqlDbType.Decimal), new MySqlParameter("@DoctorView", MySqlDbType.String, 100), new MySqlParameter("@IsReferral", MySqlDbType.String, 1), new MySqlParameter("@NextMeasures", MySqlDbType.String, 1), new MySqlParameter("@ReferralContacts", MySqlDbType.String, 100), new MySqlParameter("@ReferralResult", MySqlDbType.String, 1), new MySqlParameter("@Remarks", MySqlDbType.String, 100), new MySqlParameter("@ID", MySqlDbType.Int32, 8) }; cmdParms[0].Value = model.RecordID; cmdParms[1].Value = model.CustomerID; cmdParms[2].Value = model.IDCardNo; cmdParms[3].Value = model.CustomerName; cmdParms[4].Value = model.FollowUpDate; cmdParms[5].Value = model.FollowUpDoctor; cmdParms[6].Value = model.NextFollowUpDate; cmdParms[7].Value = model.Symptom; cmdParms[8].Value = model.SympToMother; cmdParms[9].Value = model.Hypertension; cmdParms[10].Value = model.Hypotension; cmdParms[11].Value = model.Weight; cmdParms[12].Value = model.BMI; cmdParms[13].Value = model.HeartRate; cmdParms[14].Value = model.PhysicalSympToMother; cmdParms[15].Value = model.DailySmokeNum; cmdParms[16].Value = model.DailyDrinkNum; cmdParms[17].Value = model.SportTimePerWeek; cmdParms[18].Value = model.SportPerMinuteTime; cmdParms[19].Value = model.EatSaltType; cmdParms[20].Value = model.EatSaltTarGet; cmdParms[21].Value = model.PsyChoadJustMent; cmdParms[22].Value = model.ObeyDoctorBehavior; cmdParms[23].Value = model.AssistantExam; cmdParms[24].Value = model.MedicationCompliance; cmdParms[25].Value = model.Adr; cmdParms[26].Value = model.AdrEx; cmdParms[27].Value = model.FollowUpType; cmdParms[28].Value = model.ReferralReason; cmdParms[29].Value = model.ReferralOrg; cmdParms[30].Value = model.FollowUpWay; cmdParms[31].Value = model.WeightTarGet; cmdParms[32].Value = model.BMITarGet; cmdParms[33].Value = model.DailySmokeNumTarget; cmdParms[34].Value = model.DailyDrinkNumTarget; cmdParms[35].Value = model.SportTimeSperWeekTarget; cmdParms[36].Value = model.SportPerMinutesTimeTarget; cmdParms[37].Value = model.CreatedBy; cmdParms[38].Value = model.CreatedDate; cmdParms[39].Value = model.LastUpdateBy; cmdParms[40].Value = model.LastUpdateDate; cmdParms[41].Value = model.IsDel; cmdParms[42].Value = model.Hight; cmdParms[43].Value = model.DoctorView; cmdParms[44].Value = model.IsReferral; cmdParms[45].Value = model.NextMeasures; cmdParms[46].Value = model.ReferralContacts; cmdParms[47].Value = model.ReferralResult; cmdParms[48].Value = model.Remarks; cmdParms[49].Value = model.ID; return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0); }
public ChronicHypertensionVisitModel DataRowToModel(DataRow row) { ChronicHypertensionVisitModel chronicHypertensionVisitModel = new ChronicHypertensionVisitModel(); if (row != null) { if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != "")) { chronicHypertensionVisitModel.ID = int.Parse(row["ID"].ToString()); } if ((row["RecordID"] != null) && (row["RecordID"] != DBNull.Value)) { chronicHypertensionVisitModel.RecordID = row["RecordID"].ToString(); } if ((row["CustomerID"] != null) && (row["CustomerID"] != DBNull.Value)) { chronicHypertensionVisitModel.CustomerID = row["CustomerID"].ToString(); } if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value)) { chronicHypertensionVisitModel.IDCardNo = row["IDCardNo"].ToString(); } if ((row["CustomerName"] != null) && (row["CustomerName"] != DBNull.Value)) { chronicHypertensionVisitModel.CustomerName = row["CustomerName"].ToString(); } if (((row["FollowUpDate"] != null) && (row["FollowUpDate"] != DBNull.Value)) && (row["FollowUpDate"].ToString() != "")) { chronicHypertensionVisitModel.FollowUpDate = new DateTime?(DateTime.Parse(row["FollowUpDate"].ToString())); } if ((row["FollowUpDoctor"] != null) && (row["FollowUpDoctor"] != DBNull.Value)) { chronicHypertensionVisitModel.FollowUpDoctor = row["FollowUpDoctor"].ToString(); } if (((row["NextFollowUpDate"] != null) && (row["NextFollowUpDate"] != DBNull.Value)) && (row["NextFollowUpDate"].ToString() != "")) { chronicHypertensionVisitModel.NextFollowUpDate = new DateTime?(DateTime.Parse(row["NextFollowUpDate"].ToString())); } if ((row["Symptom"] != null) && (row["Symptom"] != DBNull.Value)) { chronicHypertensionVisitModel.Symptom = row["Symptom"].ToString(); } if ((row["SympToMother"] != null) && (row["SympToMother"] != DBNull.Value)) { chronicHypertensionVisitModel.SympToMother = row["SympToMother"].ToString(); } if (((row["Hypertension"] != null) && (row["Hypertension"] != DBNull.Value)) && (row["Hypertension"].ToString() != "")) { chronicHypertensionVisitModel.Hypertension = new decimal?(decimal.Parse(row["Hypertension"].ToString())); } if (((row["Hypotension"] != null) && (row["Hypotension"] != DBNull.Value)) && (row["Hypotension"].ToString() != "")) { chronicHypertensionVisitModel.Hypotension = new decimal?(decimal.Parse(row["Hypotension"].ToString())); } if (((row["Weight"] != null) && (row["Weight"] != DBNull.Value)) && (row["Weight"].ToString() != "")) { chronicHypertensionVisitModel.Weight = new decimal?(decimal.Parse(row["Weight"].ToString())); } if (((row["BMI"] != null) && (row["BMI"] != DBNull.Value)) && (row["BMI"].ToString() != "")) { chronicHypertensionVisitModel.BMI = new decimal?(decimal.Parse(row["BMI"].ToString())); } if (((row["HeartRate"] != null) && (row["HeartRate"] != DBNull.Value)) && (row["HeartRate"].ToString() != "")) { chronicHypertensionVisitModel.HeartRate = new decimal?(decimal.Parse(row["HeartRate"].ToString())); } if ((row["PhysicalSympToMother"] != null) && (row["PhysicalSympToMother"] != DBNull.Value)) { chronicHypertensionVisitModel.PhysicalSympToMother = row["PhysicalSympToMother"].ToString(); } if (((row["DailySmokeNum"] != null) && (row["DailySmokeNum"] != DBNull.Value)) && (row["DailySmokeNum"].ToString() != "")) { chronicHypertensionVisitModel.DailySmokeNum = new decimal?(decimal.Parse(row["DailySmokeNum"].ToString())); } if (((row["DailyDrinkNum"] != null) && (row["DailyDrinkNum"] != DBNull.Value)) && (row["DailyDrinkNum"].ToString() != "")) { chronicHypertensionVisitModel.DailyDrinkNum = new decimal?(decimal.Parse(row["DailyDrinkNum"].ToString())); } if (((row["SportTimePerWeek"] != null) && (row["SportTimePerWeek"] != DBNull.Value)) && (row["SportTimePerWeek"].ToString() != "")) { chronicHypertensionVisitModel.SportTimePerWeek = new decimal?(decimal.Parse(row["SportTimePerWeek"].ToString())); } if (((row["SportPerMinuteTime"] != null) && (row["SportPerMinuteTime"] != DBNull.Value)) && (row["SportPerMinuteTime"].ToString() != "")) { chronicHypertensionVisitModel.SportPerMinuteTime = new decimal?(decimal.Parse(row["SportPerMinuteTime"].ToString())); } if ((row["EatSaltType"] != null) && (row["EatSaltType"] != DBNull.Value)) { chronicHypertensionVisitModel.EatSaltType = row["EatSaltType"].ToString(); } if ((row["EatSaltTarGet"] != null) && (row["EatSaltTarGet"] != DBNull.Value)) { chronicHypertensionVisitModel.EatSaltTarGet = row["EatSaltTarGet"].ToString(); } if ((row["PsyChoadJustMent"] != null) && (row["PsyChoadJustMent"] != DBNull.Value)) { chronicHypertensionVisitModel.PsyChoadJustMent = row["PsyChoadJustMent"].ToString(); } if ((row["ObeyDoctorBehavior"] != null) && (row["ObeyDoctorBehavior"] != DBNull.Value)) { chronicHypertensionVisitModel.ObeyDoctorBehavior = row["ObeyDoctorBehavior"].ToString(); } if ((row["AssistantExam"] != null) && (row["AssistantExam"] != DBNull.Value)) { chronicHypertensionVisitModel.AssistantExam = row["AssistantExam"].ToString(); } if ((row["MedicationCompliance"] != null) && (row["MedicationCompliance"] != DBNull.Value)) { chronicHypertensionVisitModel.MedicationCompliance = row["MedicationCompliance"].ToString(); } if ((row["Adr"] != null) && (row["Adr"] != DBNull.Value)) { chronicHypertensionVisitModel.Adr = row["Adr"].ToString(); } if ((row["AdrEx"] != null) && (row["AdrEx"] != DBNull.Value)) { chronicHypertensionVisitModel.AdrEx = row["AdrEx"].ToString(); } if ((row["FollowUpType"] != null) && (row["FollowUpType"] != DBNull.Value)) { chronicHypertensionVisitModel.FollowUpType = row["FollowUpType"].ToString(); } if ((row["ReferralReason"] != null) && (row["ReferralReason"] != DBNull.Value)) { chronicHypertensionVisitModel.ReferralReason = row["ReferralReason"].ToString(); } if ((row["ReferralOrg"] != null) && (row["ReferralOrg"] != DBNull.Value)) { chronicHypertensionVisitModel.ReferralOrg = row["ReferralOrg"].ToString(); } if ((row["FollowUpWay"] != null) && (row["FollowUpWay"] != DBNull.Value)) { chronicHypertensionVisitModel.FollowUpWay = row["FollowUpWay"].ToString(); } if (((row["WeightTarGet"] != null) && (row["WeightTarGet"] != DBNull.Value)) && (row["WeightTarGet"].ToString() != "")) { chronicHypertensionVisitModel.WeightTarGet = new decimal?(decimal.Parse(row["WeightTarGet"].ToString())); } if (((row["BMITarGet"] != null) && (row["BMITarGet"] != DBNull.Value)) && (row["BMITarGet"].ToString() != "")) { chronicHypertensionVisitModel.BMITarGet = new decimal?(decimal.Parse(row["BMITarGet"].ToString())); } if (((row["DailySmokeNumTarget"] != null) && (row["DailySmokeNumTarget"] != DBNull.Value)) && (row["DailySmokeNumTarget"].ToString() != "")) { chronicHypertensionVisitModel.DailySmokeNumTarget = new decimal?(decimal.Parse(row["DailySmokeNumTarget"].ToString())); } if (((row["DailyDrinkNumTarget"] != null) && (row["DailyDrinkNumTarget"] != DBNull.Value)) && (row["DailyDrinkNumTarget"].ToString() != "")) { chronicHypertensionVisitModel.DailyDrinkNumTarget = new decimal?(decimal.Parse(row["DailyDrinkNumTarget"].ToString())); } if (((row["SportTimeSperWeekTarget"] != null) && (row["SportTimeSperWeekTarget"] != DBNull.Value)) && (row["SportTimeSperWeekTarget"].ToString() != "")) { chronicHypertensionVisitModel.SportTimeSperWeekTarget = new decimal?(decimal.Parse(row["SportTimeSperWeekTarget"].ToString())); } if (((row["SportPerMinutesTimeTarget"] != null) && (row["SportPerMinutesTimeTarget"] != DBNull.Value)) && (row["SportPerMinutesTimeTarget"].ToString() != "")) { chronicHypertensionVisitModel.SportPerMinutesTimeTarget = new decimal?(decimal.Parse(row["SportPerMinutesTimeTarget"].ToString())); } if ((row["CreatedBy"] != null) && (row["CreatedBy"] != DBNull.Value)) { chronicHypertensionVisitModel.CreatedBy = row["CreatedBy"].ToString(); } if (((row["CreatedDate"] != null) && (row["CreatedDate"] != DBNull.Value)) && (row["CreatedDate"].ToString() != "")) { chronicHypertensionVisitModel.CreatedDate = new DateTime?(DateTime.Parse(row["CreatedDate"].ToString())); } if ((row["LastUpdateBy"] != null) && (row["LastUpdateBy"] != DBNull.Value)) { chronicHypertensionVisitModel.LastUpdateBy = row["LastUpdateBy"].ToString(); } if (((row["LastUpdateDate"] != null) && (row["LastUpdateDate"] != DBNull.Value)) && (row["LastUpdateDate"].ToString() != "")) { chronicHypertensionVisitModel.LastUpdateDate = new DateTime?(DateTime.Parse(row["LastUpdateDate"].ToString())); } if ((row["IsDel"] != null) && (row["IsDel"] != DBNull.Value)) { chronicHypertensionVisitModel.IsDel = row["IsDel"].ToString(); } if (((row["Hight"] != null) && (row["Hight"] != DBNull.Value)) && (row["Hight"].ToString() != "")) { chronicHypertensionVisitModel.Hight = new decimal?(decimal.Parse(row["Hight"].ToString())); } if ((row["DoctorView"] != null) && (row["DoctorView"] != DBNull.Value)) { chronicHypertensionVisitModel.DoctorView = row["DoctorView"].ToString(); } if ((row["IsReferral"] != null) && (row["IsReferral"] != DBNull.Value)) { chronicHypertensionVisitModel.IsReferral = row["IsReferral"].ToString(); } if ((row["NextMeasures"] != null) && (row["NextMeasures"] != DBNull.Value)) { chronicHypertensionVisitModel.NextMeasures = row["NextMeasures"].ToString(); } if ((row["ReferralContacts"] != null) && (row["ReferralContacts"] != DBNull.Value)) { chronicHypertensionVisitModel.ReferralContacts = row["ReferralContacts"].ToString(); } if ((row["ReferralResult"] != null) && (row["ReferralResult"] != DBNull.Value)) { chronicHypertensionVisitModel.ReferralResult = row["ReferralResult"].ToString(); } if ((row["Remarks"] != null) && (row["Remarks"] != DBNull.Value)) { chronicHypertensionVisitModel.Remarks = row["Remarks"].ToString(); } } return(chronicHypertensionVisitModel); }
public int Add(ChronicHypertensionVisitModel model) { StringBuilder builder = new StringBuilder(); builder.Append("INSERT INTO CD_HYPERTENSIONFOLLOWUP("); builder.Append("RecordID,CustomerID,IDCardNo,CustomerName,FollowUpDate,FollowUpDoctor,"); builder.Append("NextFollowUpDate,Symptom,SympToMother,Hypertension,Hypotension,Weight,BMI,"); builder.Append("HeartRate,PhysicalSympToMother,DailySmokeNum,DailyDrinkNum,SportTimePerWeek,"); builder.Append("SportPerMinuteTime,EatSaltType,EatSaltTarGet,PsyChoadJustMent,ObeyDoctorBehavior,"); builder.Append("AssistantExam,MedicationCompliance,Adr,AdrEx,FollowUpType,ReferralReason,ReferralOrg,"); builder.Append("FollowUpWay,WeightTarGet,BMITarGet,DailySmokeNumTarget,DailyDrinkNumTarget,"); builder.Append("SportTimeSperWeekTarget,SportPerMinutesTimeTarget,CreatedBy,CreatedDate,LastUpdateBy,LastUpdateDate,"); builder.Append("IsDel,Hight,DoctorView,IsReferral,NextMeasures,ReferralContacts,ReferralResult,Remarks )"); builder.Append(" VALUES ("); builder.Append("@RecordID,@CustomerID,@IDCardNo,@CustomerName,@FollowUpDate,@FollowUpDoctor,@NextFollowUpDate,@Symptom,"); builder.Append("@SympToMother,@Hypertension,@Hypotension,@Weight,@BMI,@HeartRate,@PhysicalSympToMother,@DailySmokeNum,@DailyDrinkNum,"); builder.Append("@SportTimePerWeek,@SportPerMinuteTime,@EatSaltType,@EatSaltTarGet,@PsyChoadJustMent,@ObeyDoctorBehavior,@AssistantExam,"); builder.Append("@MedicationCompliance,@Adr,@AdrEx,@FollowUpType,@ReferralReason,@ReferralOrg,@FollowUpWay,@WeightTarGet,@BMITarGet,"); builder.Append("@DailySmokeNumTarget,@DailyDrinkNumTarget,@SportTimeSperWeekTarget,@SportPerMinutesTimeTarget,"); builder.Append("@CreatedBy,@CreatedDate,@LastUpdateBy,@LastUpdateDate,@IsDel,@Hight,@DoctorView,@IsReferral,@NextMeasures,@ReferralContacts,@ReferralResult,@Remarks )"); builder.Append(";SELECT @@IDENTITY"); MySqlParameter[] cmdParms = new MySqlParameter[] { new MySqlParameter("@RecordID", MySqlDbType.String, 17), new MySqlParameter("@CustomerID", MySqlDbType.String, 32), new MySqlParameter("@IDCardNo", MySqlDbType.String, 21), new MySqlParameter("@CustomerName", MySqlDbType.String, 30), new MySqlParameter("@FollowUpDate", MySqlDbType.Date), new MySqlParameter("@FollowUpDoctor", MySqlDbType.String, 30), new MySqlParameter("@NextFollowUpDate", MySqlDbType.Date), new MySqlParameter("@Symptom", MySqlDbType.String, 20), new MySqlParameter("@SympToMother", MySqlDbType.String, 500), new MySqlParameter("@Hypertension", MySqlDbType.Decimal), new MySqlParameter("@Hypotension", MySqlDbType.Decimal), new MySqlParameter("@Weight", MySqlDbType.Decimal), new MySqlParameter("@BMI", MySqlDbType.Decimal), new MySqlParameter("@HeartRate", MySqlDbType.Decimal), new MySqlParameter("@PhysicalSympToMother", MySqlDbType.String, 500), new MySqlParameter("@DailySmokeNum", MySqlDbType.Decimal), new MySqlParameter("@DailyDrinkNum", MySqlDbType.Decimal), new MySqlParameter("@SportTimePerWeek", MySqlDbType.Decimal), new MySqlParameter("@SportPerMinuteTime", MySqlDbType.Decimal), new MySqlParameter("@EatSaltType", MySqlDbType.String, 1), new MySqlParameter("@EatSaltTarGet", MySqlDbType.String, 1), new MySqlParameter("@PsyChoadJustMent", MySqlDbType.String, 500), new MySqlParameter("@ObeyDoctorBehavior", MySqlDbType.String, 1), new MySqlParameter("@AssistantExam", MySqlDbType.String, 500), new MySqlParameter("@MedicationCompliance", MySqlDbType.String, 1), new MySqlParameter("@Adr", MySqlDbType.String, 1), new MySqlParameter("@AdrEx", MySqlDbType.String, 500), new MySqlParameter("@FollowUpType", MySqlDbType.String, 1), new MySqlParameter("@ReferralReason", MySqlDbType.String, 500), new MySqlParameter("@ReferralOrg", MySqlDbType.String, 80), new MySqlParameter("@FollowUpWay", MySqlDbType.String, 1), new MySqlParameter("@WeightTarGet", MySqlDbType.Decimal), new MySqlParameter("@BMITarGet", MySqlDbType.Decimal), new MySqlParameter("@DailySmokeNumTarget", MySqlDbType.Decimal), new MySqlParameter("@DailyDrinkNumTarget", MySqlDbType.Decimal), new MySqlParameter("@SportTimeSperWeekTarget", MySqlDbType.Decimal), new MySqlParameter("@SportPerMinutesTimeTarget", MySqlDbType.Decimal), new MySqlParameter("@CreatedBy", MySqlDbType.String, 18), new MySqlParameter("@CreatedDate", MySqlDbType.Date), new MySqlParameter("@LastUpdateBy", MySqlDbType.String, 18), new MySqlParameter("@LastUpdateDate", MySqlDbType.Date), new MySqlParameter("@IsDel", MySqlDbType.String, 1), new MySqlParameter("@Hight", MySqlDbType.Decimal), new MySqlParameter("@DoctorView", MySqlDbType.String, 80), new MySqlParameter("@IsReferral", MySqlDbType.String, 1), new MySqlParameter("@NextMeasures", MySqlDbType.String, 1), new MySqlParameter("@ReferralContacts", MySqlDbType.String, 100), new MySqlParameter("@ReferralResult", MySqlDbType.String, 1), new MySqlParameter("@Remarks", MySqlDbType.String, 100) }; cmdParms[0].Value = model.RecordID; cmdParms[1].Value = model.CustomerID; cmdParms[2].Value = model.IDCardNo; cmdParms[3].Value = model.CustomerName; cmdParms[4].Value = model.FollowUpDate; cmdParms[5].Value = model.FollowUpDoctor; cmdParms[6].Value = model.NextFollowUpDate; cmdParms[7].Value = model.Symptom; cmdParms[8].Value = model.SympToMother; cmdParms[9].Value = model.Hypertension; cmdParms[10].Value = model.Hypotension; cmdParms[11].Value = model.Weight; cmdParms[12].Value = model.BMI; cmdParms[13].Value = model.HeartRate; cmdParms[14].Value = model.PhysicalSympToMother; cmdParms[15].Value = model.DailySmokeNum; cmdParms[16].Value = model.DailyDrinkNum; cmdParms[17].Value = model.SportTimePerWeek; cmdParms[18].Value = model.SportPerMinuteTime; cmdParms[19].Value = model.EatSaltType; cmdParms[20].Value = model.EatSaltTarGet; cmdParms[21].Value = model.PsyChoadJustMent; cmdParms[22].Value = model.ObeyDoctorBehavior; cmdParms[23].Value = model.AssistantExam; cmdParms[24].Value = model.MedicationCompliance; cmdParms[25].Value = model.Adr; cmdParms[26].Value = model.AdrEx; cmdParms[27].Value = model.FollowUpType; cmdParms[28].Value = model.ReferralReason; cmdParms[29].Value = model.ReferralOrg; cmdParms[30].Value = model.FollowUpWay; cmdParms[31].Value = model.WeightTarGet; cmdParms[32].Value = model.BMITarGet; cmdParms[33].Value = model.DailySmokeNumTarget; cmdParms[34].Value = model.DailyDrinkNumTarget; cmdParms[35].Value = model.SportTimeSperWeekTarget; cmdParms[36].Value = model.SportPerMinutesTimeTarget; cmdParms[37].Value = model.CreatedBy; cmdParms[38].Value = model.CreatedDate; cmdParms[39].Value = model.LastUpdateBy; cmdParms[40].Value = model.LastUpdateDate; cmdParms[41].Value = model.IsDel; cmdParms[42].Value = model.Hight; cmdParms[43].Value = model.DoctorView; cmdParms[44].Value = model.IsReferral; cmdParms[45].Value = model.NextMeasures; cmdParms[46].Value = model.ReferralContacts; cmdParms[47].Value = model.ReferralResult; cmdParms[48].Value = model.Remarks; object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms); if (single == null) { return(0); } return(Convert.ToInt32(single)); }
public ChronicHypertensionVisitModel ExistsCheckDate(ChronicHypertensionVisitModel model) { return(this.dal.ExistsCheckDate(model)); }
public int Add(ChronicHypertensionVisitModel model) { return(this.dal.Add(model)); }
public bool UpdateDate(ChronicHypertensionVisitModel model) { return(dal.UpdateDate(model)); }