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