public List <ChronicHypertensionBaseInfoModel> DataTableToList(DataTable dt)
{
List <ChronicHypertensionBaseInfoModel> list = new List <ChronicHypertensionBaseInfoModel>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
ChronicHypertensionBaseInfoModel item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public int AddServer(ChronicHypertensionBaseInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into CD_HYPERTENSION_BASEINFO(");
builder.Append("CustomerID,RecordID,IDCardNo,ManagementGroup,CaseOurce,TerminateExcuse,");
builder.Append("FatherHistory,Symptom,HypertensionComplication,Hypotensor,TerminateManagemen,");
builder.Append("TerminateTime,CreateUnit,CurrentUnit,CreateoBy,CreatedDate,");
builder.Append("LastUpdateBy,LastUpdateDate,IsDel )");
builder.Append(" values (");
builder.Append("@CustomerID,@RecordID,@IDCardNo,@ManagementGroup,@CaseOurce,@TerminateExcuse,");
builder.Append("@FatherHistory,@Symptom,@HypertensionComplication,@Hypotensor,@TerminateManagemen,");
builder.Append("@TerminateTime,@CreateUnit,@CurrentUnit,@CreateoBy,@CreatedDate,@LastUpdateBy,");
builder.Append("@LastUpdateDate,@IsDel )");
builder.Append(";select @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@CustomerID", MySqlDbType.String, 32),
new MySqlParameter("@RecordID", MySqlDbType.String, 17),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@ManagementGroup", MySqlDbType.String, 1),
new MySqlParameter("@CaseOurce", MySqlDbType.String, 1),
new MySqlParameter("@TerminateExcuse", MySqlDbType.String, 1),
new MySqlParameter("@FatherHistory", MySqlDbType.String, 30),
new MySqlParameter("@Symptom", MySqlDbType.String, 30),
new MySqlParameter("@HypertensionComplication", MySqlDbType.String, 50),
new MySqlParameter("@Hypotensor", MySqlDbType.String, 1),
new MySqlParameter("@TerminateManagemen", MySqlDbType.String, 1),
new MySqlParameter("@TerminateTime", MySqlDbType.Date),
new MySqlParameter("@CreateUnit", MySqlDbType.Decimal),
new MySqlParameter("@CurrentUnit", MySqlDbType.Decimal),
new MySqlParameter("@CreateoBy", MySqlDbType.Decimal),
new MySqlParameter("@CreatedDate", MySqlDbType.Date),
new MySqlParameter("@LastUpdateBy", MySqlDbType.Decimal),
new MySqlParameter("@LastUpdateDate", MySqlDbType.Date),
new MySqlParameter("@IsDel", MySqlDbType.String, 1)
};
cmdParms[0].Value = model.CustomerID;
cmdParms[1].Value = model.RecordID;
cmdParms[2].Value = model.IDCardNo;
cmdParms[3].Value = model.ManagementGroup;
cmdParms[4].Value = model.CaseOurce;
cmdParms[5].Value = model.TerminateExcuse;
cmdParms[6].Value = model.FatherHistory;
cmdParms[7].Value = model.Symptom;
cmdParms[8].Value = model.HypertensionComplication;
cmdParms[9].Value = model.Hypotensor;
cmdParms[10].Value = model.TerminateManagemen;
cmdParms[11].Value = model.TerminateTime;
cmdParms[12].Value = model.CreateUnit;
cmdParms[13].Value = model.CurrentUnit;
cmdParms[14].Value = model.CreateoBy;
cmdParms[15].Value = model.CreatedDate;
cmdParms[16].Value = model.LastUpdateBy;
cmdParms[17].Value = model.LastUpdateDate;
cmdParms[18].Value = model.IsDel;
object single = MySQLHelper.GetSingleServer(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
public bool UpdateServer(ChronicHypertensionBaseInfoModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update CD_HYPERTENSION_BASEINFO set ");
builder.Append("CustomerID=@CustomerID,");
builder.Append("RecordID=@RecordID,");
builder.Append("IDCardNo=@IDCardNo,");
builder.Append("ManagementGroup=@ManagementGroup,");
builder.Append("CaseOurce=@CaseOurce,");
builder.Append("TerminateExcuse=@TerminateExcuse,");
builder.Append("FatherHistory=@FatherHistory,");
builder.Append("Symptom=@Symptom,");
builder.Append("HypertensionComplication=@HypertensionComplication,");
builder.Append("Hypotensor=@Hypotensor,");
builder.Append("TerminateManagemen=@TerminateManagemen,");
builder.Append("TerminateTime=@TerminateTime,");
builder.Append("CreateUnit=@CreateUnit,");
builder.Append("CurrentUnit=@CurrentUnit,");
builder.Append("CreateoBy=@CreateoBy,");
builder.Append("CreatedDate=@CreatedDate,");
builder.Append("LastUpdateBy=@LastUpdateBy,");
builder.Append("LastUpdateDate=@LastUpdateDate,");
builder.Append("IsDel=@IsDel ");
builder.Append(" where IDCardNo=@IDCardNo");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@CustomerID", MySqlDbType.String, 32),
new MySqlParameter("@RecordID", MySqlDbType.String, 17),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@ManagementGroup", MySqlDbType.String, 1),
new MySqlParameter("@CaseOurce", MySqlDbType.String, 1),
new MySqlParameter("@TerminateExcuse", MySqlDbType.String, 1),
new MySqlParameter("@FatherHistory", MySqlDbType.String, 30),
new MySqlParameter("@Symptom", MySqlDbType.String, 30),
new MySqlParameter("@HypertensionComplication", MySqlDbType.String, 50),
new MySqlParameter("@Hypotensor", MySqlDbType.String, 1),
new MySqlParameter("@TerminateManagemen", MySqlDbType.String, 1),
new MySqlParameter("@TerminateTime", MySqlDbType.Date),
new MySqlParameter("@CreateUnit", MySqlDbType.Decimal),
new MySqlParameter("@CurrentUnit", MySqlDbType.Decimal),
new MySqlParameter("@CreateoBy", MySqlDbType.Decimal),
new MySqlParameter("@CreatedDate", MySqlDbType.Date),
new MySqlParameter("@LastUpdateBy", MySqlDbType.Decimal),
new MySqlParameter("@LastUpdateDate", MySqlDbType.Date),
new MySqlParameter("@IsDel", MySqlDbType.String, 1)
//new MySqlParameter("@ID", MySqlDbType.Int32, 8)
};
cmdParms[0].Value = model.CustomerID;
cmdParms[1].Value = model.RecordID;
cmdParms[2].Value = model.IDCardNo;
cmdParms[3].Value = model.ManagementGroup;
cmdParms[4].Value = model.CaseOurce;
cmdParms[5].Value = model.TerminateExcuse;
cmdParms[6].Value = model.FatherHistory;
cmdParms[7].Value = model.Symptom;
cmdParms[8].Value = model.HypertensionComplication;
cmdParms[9].Value = model.Hypotensor;
cmdParms[10].Value = model.TerminateManagemen;
cmdParms[11].Value = model.TerminateTime;
cmdParms[12].Value = model.CreateUnit;
cmdParms[13].Value = model.CurrentUnit;
cmdParms[14].Value = model.CreateoBy;
cmdParms[15].Value = model.CreatedDate;
cmdParms[16].Value = model.LastUpdateBy;
cmdParms[17].Value = model.LastUpdateDate;
cmdParms[18].Value = model.IsDel;
//cmdParms[20].Value = model.ID;
return(MySQLHelper.ExecuteSqlServer(builder.ToString(), cmdParms) > 0);
}
public ChronicHypertensionBaseInfoModel DataRowToModel(DataRow row)
{
ChronicHypertensionBaseInfoModel chronicHypertensionBaseInfoModel = new ChronicHypertensionBaseInfoModel();
if (row != null)
{
if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != ""))
{
chronicHypertensionBaseInfoModel.ID = int.Parse(row["ID"].ToString());
}
if ((row["CustomerID"] != null) && (row["CustomerID"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.CustomerID = row["CustomerID"].ToString();
}
if ((row["RecordID"] != null) && (row["RecordID"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.RecordID = row["RecordID"].ToString();
}
if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.IDCardNo = row["IDCardNo"].ToString();
}
if ((row["ManagementGroup"] != null) && (row["ManagementGroup"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.ManagementGroup = row["ManagementGroup"].ToString();
}
if ((row["CaseOurce"] != null) && (row["CaseOurce"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.CaseOurce = row["CaseOurce"].ToString();
}
if ((row["TerminateExcuse"] != null) && (row["TerminateExcuse"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.TerminateExcuse = row["TerminateExcuse"].ToString();
}
if ((row["FatherHistory"] != null) && (row["FatherHistory"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.FatherHistory = row["FatherHistory"].ToString();
}
if ((row["Symptom"] != null) && (row["Symptom"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.Symptom = row["Symptom"].ToString();
}
if ((row["HypertensionComplication"] != null) && (row["HypertensionComplication"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.HypertensionComplication = row["HypertensionComplication"].ToString();
}
if ((row["Hypotensor"] != null) && (row["Hypotensor"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.Hypotensor = row["Hypotensor"].ToString();
}
if ((row["TerminateManagemen"] != null) && (row["TerminateManagemen"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.TerminateManagemen = row["TerminateManagemen"].ToString();
}
if (((row["TerminateTime"] != null) && (row["TerminateTime"] != DBNull.Value)) && (row["TerminateTime"].ToString() != ""))
{
chronicHypertensionBaseInfoModel.TerminateTime = new DateTime?(DateTime.Parse(row["TerminateTime"].ToString()));
}
if (((row["CreateUnit"] != null) && (row["CreateUnit"] != DBNull.Value)) && (row["CreateUnit"].ToString() != ""))
{
chronicHypertensionBaseInfoModel.CreateUnit = new decimal?(decimal.Parse(row["CreateUnit"].ToString()));
}
if (((row["CurrentUnit"] != null) && (row["CurrentUnit"] != DBNull.Value)) && (row["CurrentUnit"].ToString() != ""))
{
chronicHypertensionBaseInfoModel.CurrentUnit = new decimal?(decimal.Parse(row["CurrentUnit"].ToString()));
}
if (((row["CreateoBy"] != null) && (row["CreateoBy"] != DBNull.Value)) && (row["CreateoBy"].ToString() != ""))
{
chronicHypertensionBaseInfoModel.CreateoBy = new decimal?(decimal.Parse(row["CreateoBy"].ToString()));
}
if (((row["CreatedDate"] != null) && (row["CreatedDate"] != DBNull.Value)) && (row["CreatedDate"].ToString() != ""))
{
chronicHypertensionBaseInfoModel.CreatedDate = new DateTime?(DateTime.Parse(row["CreatedDate"].ToString()));
}
if (((row["LastUpdateBy"] != null) && (row["LastUpdateBy"] != DBNull.Value)) && (row["LastUpdateBy"].ToString() != ""))
{
chronicHypertensionBaseInfoModel.LastUpdateBy = new decimal?(decimal.Parse(row["LastUpdateBy"].ToString()));
}
if (((row["LastUpdateDate"] != null) && (row["LastUpdateDate"] != DBNull.Value)) && (row["LastUpdateDate"].ToString() != ""))
{
chronicHypertensionBaseInfoModel.LastUpdateDate = new DateTime?(DateTime.Parse(row["LastUpdateDate"].ToString()));
}
if ((row["IsDel"] != null) && (row["IsDel"] != DBNull.Value))
{
chronicHypertensionBaseInfoModel.IsDel = row["IsDel"].ToString();
}
}
return(chronicHypertensionBaseInfoModel);
}
private void BindingModel()
{
this.hpyBaseInfo = new ChronicHypertensionBaseInfoBLL().GetModel(this.Model.IDCardNo);
if (this.hpyBaseInfo == null)
{
ChronicHypertensionBaseInfoModel cd_Hypertension_baseinfo = new ChronicHypertensionBaseInfoModel {
IDCardNo = this.Model.IDCardNo,
RecordID = this.Model.RecordID,
Hypotensor = "1"
};
this.hpyBaseInfo = cd_Hypertension_baseinfo;
this.hpyBaseInfo.ManagementGroup = "1";
this.hpyBaseInfo.CaseOurce = "1";
this.hpyBaseInfo.CreateUnit = new decimal?(ConfigHelper.GetNodeDec("orgCode"));
this.hpyBaseInfo.CreateoBy = new decimal?(ConfigHelper.GetNodeDec("doctor"));
this.hpyBaseInfo.CreatedDate = new DateTime?(DateTime.Today);
}
else
{
this.hpyBaseInfo.LastUpdateBy = new decimal?(ConfigHelper.GetNodeDec("doctor"));
this.hpyBaseInfo.LastUpdateDate = new DateTime?(DateTime.Today);
}
this.hpyBaseInfo.CurrentUnit = new decimal?(ConfigHelper.GetNodeDec("orgCode"));
this.SimpleBinding(this.cbxManagerGroup, this.hpyBaseInfo, "ManagementGroup");
this.SimpleBinding(this.cbxFromWhere, this.hpyBaseInfo, "CaseOurce");
this.SimpleBinding(this.cbxStopResult, this.hpyBaseInfo, "TerminateExcuse");
this.famHistory = new ManyCheckboxs <ChronicHypertensionBaseInfoModel>(this.hpyBaseInfo);
this.famHistory.AddCk(new LoneCheckbox[] { new LoneCheckbox(this.ck1), new LoneCheckbox(this.ck2), new LoneCheckbox(this.ck3), new LoneCheckbox(this.ck4), new LoneCheckbox(this.ck5, true), new LoneCheckbox(this.ck6, true), new LoneCheckbox(this.ck7, true) });
this.famHistory.BindingProperty("FatherHistory", "");
CMoreChange change = new CMoreChange {
Name = "目前症状",
MoreChange = this.cklSymptom,
Unusual = "无症状"
};
this.symptom = change;
this.symptom.TransInfo(this.hpyBaseInfo.Symptom, "");
CMoreChange change2 = new CMoreChange {
Name = "并发症",
MoreChange = this.cklTogetherSymptom,
Unusual = "无任何并发症"
};
this.together = change2;
this.together.TransInfo(this.hpyBaseInfo.HypertensionComplication, "");
if (this.hpyBaseInfo.TerminateManagemen == "1")
{
this.ckxStopManager.Checked = true;
this.cbxStopResult.Enabled = true;
}
else if (this.hpyBaseInfo.TerminateManagemen == "2")
{
this.cbxStopResult.Enabled = false;
this.dtpStopDate.Enabled = false;
}
if (this.hpyBaseInfo.TerminateTime.HasValue)
{
this.dtpStopDate.Value = this.hpyBaseInfo.TerminateTime.Value;
}
if (this.hpyBaseInfo.Hypotensor == "1")
{
this.rdYes.Checked = true;
}
else
{
this.rdNo.Checked = true;
}
}
public int AddServer(ChronicHypertensionBaseInfoModel model)
{
return(this.dal.AddServer(model));
}
public bool UpdateServer(ChronicHypertensionBaseInfoModel model)
{
return(this.dal.UpdateServer(model));
}
public int Add(ChronicHypertensionBaseInfoModel model, string Version = "V2.0")
{
return(this.dal.Add(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;
}
}
