public List <ChronicMentalDiseaseVisitModel> DataTableToList(DataTable dt)
{
List <ChronicMentalDiseaseVisitModel> list = new List <ChronicMentalDiseaseVisitModel>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
ChronicMentalDiseaseVisitModel item = this.dal.DataRowToModel(dt.Rows[i]);
if (item != null)
{
list.Add(item);
}
}
}
return(list);
}
public ChronicMentalDiseaseVisitModel GetModelFollowUpDate(ChronicMentalDiseaseVisitModel model)
{
return(this.dal.GetModelFollowUpDate(model));
}
public ChronicMentalDiseaseVisitModel ExistsCheckDate(ChronicMentalDiseaseVisitModel model)
{
return(this.dal.ExistsCheckDate(model));
}
public int AddServer(ChronicMentalDiseaseVisitModel model)
{
return(this.dal.AddServer(model));
}
public bool UpdateServer(ChronicMentalDiseaseVisitModel model)
{
return(this.dal.UpdateServer(model));
}
/// <summary>
/// 精神疾病
/// </summary>
/// <param name="IDCardNo"></param>
/// <param name="CheckDate"></param>
/// <param name="VersionNo"></param>
/// <param name="Model"></param>
public void SaveMental(string IDCardNo, DateTime CheckDate, string VersionNo, RecordsBaseInfoModel Model)
{
try
{
// 获取最后一次随访数据
ChronicMentalDiseaseVisitModel mentalOldModel = MentalDiseaseVisitBLL.GetMaxModel(IDCardNo, VersionNo);
if (mentalOldModel == null)
{
mentalOldModel = new ChronicMentalDiseaseVisitModel();
}
ChronicMentalDiseaseVisitModel mentalNewModel = new ChronicMentalDiseaseVisitModel();
#region 精神疾病基本信息
// 是否有基本信息
int count = MentalDiseaseBaseBLL.GetDataCount(IDCardNo);
if (count < 1)
{
// 新增精神疾病基本信息
ChronicMentalDiseaseBaseInfoModel baseModel = new ChronicMentalDiseaseBaseInfoModel()
{
IDCardNo = IDCardNo,
RecordID = Model.RecordID,
CreatedBy = ConfigHelper.GetNodeDec("doctor"),
CreatedDate = DateTime.Now,
LastUpdateBy = ConfigHelper.GetNodeDec("doctor"),
LastUpDateDate = DateTime.Now
};
MentalDiseaseBaseBLL.Add(baseModel);
}
#endregion
#region 随访信息
mentalNewModel = EntityAssignment <ChronicMentalDiseaseVisitModel>(mentalOldModel, mentalNewModel);
mentalNewModel.IDCardNo = IDCardNo;
mentalNewModel.RecordID = Model.RecordID;
mentalNewModel.FollowUpDate = CheckDate;
mentalNewModel.NextFollowUpDate = CheckDate.AddMonths(3);
mentalNewModel.FollowUpDoctor = ConfigHelper.GetNode("doctorName");
mentalNewModel.CreatedBy = ConfigHelper.GetNodeDec("doctor");
mentalNewModel.CreatedDate = DateTime.Now;
mentalNewModel.LastUpdateBy = ConfigHelper.GetNodeDec("doctor");
mentalNewModel.LastUpdateDate = DateTime.Now;
#endregion
#region 保存默认值
if (VersionNo.Contains("3.0"))
{
mentalNewModel.FollowUpType = mentalNewModel.VisitType;
}
// 随访信息存档
int id = MentalDiseaseVisitBLL.Add(mentalNewModel, VersionNo);
#endregion
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
throw ex;
}
}
public int Add(ChronicMentalDiseaseVisitModel model, string Version = "V2.0")
{
return(this.dal.Add(model, Version));
}
public int Add(ChronicMentalDiseaseVisitModel model, string VersionNo)
{
StringBuilder builder = new StringBuilder();
builder.Append("INSERT INTO CD_MENTALDISEASE_FOLLOWUP(");
builder.Append("CustomerID,RecordID,IDCardNo,Fatalness,PresentSymptom,PresentSymptoOther,");
if (VersionNo.Contains("3.0"))
{
builder.Append(" VisitDate,VisitDoctor,NextVisitDate,VisitType, ");
}
else
{
builder.Append(" FollowUpDate,FollowUpDoctor,NextFollowUpDate,FollowUpType, ");
}
builder.Append("Insight,SleepQuality,Diet,PersonalCare,Housework,ProductLaborWork,LearningAbility,");
builder.Append("SocialInterIntera,MildTroubleFrequen,CreateDistuFrequen,CauseAccidFrequen,AutolesionFrequen,");
builder.Append("AttemptSuicFrequen,AttemptSuicideNone,LockCondition,HospitalizatiStatus,LastLeaveHospTime,");
builder.Append("LaborExaminati,LaborExaminatiHave,MedicatioCompliance,AdnerDruReact,AdverDruReactHave,");
builder.Append("TreatmentEffect,WhetherReferral,ReferralReason,ReferralAgencDepar,RehabiliMeasu,");
builder.Append("RehabiliMeasuOther,FollowupClassificat,CreatedBy,CreatedDate,LastUpdateBy,LastUpdateDate,");
builder.Append("IsDel,NoVisitReason,DeathDate,IllReason,DeathReason,OtherDangerFrequen)");
builder.Append(" VALUES (");
builder.Append("@CustomerID,@RecordID,@IDCardNo,@Fatalness,@PresentSymptom,@PresentSymptoOther,@FollowUpDate,@FollowUpDoctor,");
builder.Append("@NextFollowUpDate,@FollowUpType,@Insight,@SleepQuality,@Diet,@PersonalCare,@Housework,@ProductLaborWork,@LearningAbility,");
builder.Append("@SocialInterIntera,@MildTroubleFrequen,@CreateDistuFrequen,@CauseAccidFrequen,@AutolesionFrequen,@AttemptSuicFrequen,");
builder.Append("@AttemptSuicideNone,@LockCondition,@HospitalizatiStatus,@LastLeaveHospTime,@LaborExaminati,@LaborExaminatiHave,");
builder.Append("@MedicatioCompliance,@AdnerDruReact,@AdverDruReactHave,@TreatmentEffect,@WhetherReferral,@ReferralReason,");
builder.Append("@ReferralAgencDepar,@RehabiliMeasu,@RehabiliMeasuOther,@FollowupClassificat,@CreatedBy,@CreatedDate,");
builder.Append("@LastUpdateBy,@LastUpdateDate,@IsDel,@NoVisitReason,@DeathDate,@IllReason,@DeathReason,@OtherDangerFrequen)");
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("@FollowUpDate", MySqlDbType.Date),
new MySqlParameter("@Fatalness", MySqlDbType.String, 1),
new MySqlParameter("@PresentSymptom", MySqlDbType.String, 50),
new MySqlParameter("@PresentSymptoOther", MySqlDbType.String, 200),
new MySqlParameter("@Insight", MySqlDbType.String, 1),
new MySqlParameter("@SleepQuality", MySqlDbType.String, 1),
new MySqlParameter("@Diet", MySqlDbType.String, 1),
new MySqlParameter("@PersonalCare", MySqlDbType.String, 1),
new MySqlParameter("@Housework", MySqlDbType.String, 1),
new MySqlParameter("@ProductLaborWork", MySqlDbType.String, 1),
new MySqlParameter("@LearningAbility", MySqlDbType.String, 1),
new MySqlParameter("@SocialInterIntera", MySqlDbType.String, 1),
new MySqlParameter("@MildTroubleFrequen", MySqlDbType.Int32),
new MySqlParameter("@CreateDistuFrequen", MySqlDbType.Int32),
new MySqlParameter("@CauseAccidFrequen", MySqlDbType.Int32),
new MySqlParameter("@AutolesionFrequen", MySqlDbType.Int32),
new MySqlParameter("@AttemptSuicFrequen", MySqlDbType.Int32),
new MySqlParameter("@AttemptSuicideNone", MySqlDbType.String, 1),
new MySqlParameter("@LockCondition", MySqlDbType.String, 1),
new MySqlParameter("@HospitalizatiStatus", MySqlDbType.String, 1),
new MySqlParameter("@LastLeaveHospTime", MySqlDbType.Date),
new MySqlParameter("@LaborExaminati", MySqlDbType.String, 1),
new MySqlParameter("@LaborExaminatiHave", MySqlDbType.String, 100),
new MySqlParameter("@MedicatioCompliance", MySqlDbType.String, 1),
new MySqlParameter("@AdnerDruReact", MySqlDbType.String, 1),
new MySqlParameter("@AdverDruReactHave", MySqlDbType.String, 100),
new MySqlParameter("@TreatmentEffect", MySqlDbType.String, 1),
new MySqlParameter("@WhetherReferral", MySqlDbType.String, 1),
new MySqlParameter("@ReferralReason", MySqlDbType.String, 200),
new MySqlParameter("@ReferralAgencDepar", MySqlDbType.String, 80),
new MySqlParameter("@RehabiliMeasu", MySqlDbType.String, 20),
new MySqlParameter("@RehabiliMeasuOther", MySqlDbType.String, 10),
new MySqlParameter("@FollowupClassificat", MySqlDbType.String, 1),
new MySqlParameter("@NextFollowUpDate", MySqlDbType.Date),
new MySqlParameter("@FollowUpDoctor", MySqlDbType.String, 30),
new MySqlParameter("@CreatedBy", 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("@NoVisitReason", MySqlDbType.String, 1),
new MySqlParameter("@DeathDate", MySqlDbType.Date),
new MySqlParameter("@IllReason", MySqlDbType.String, 1),
new MySqlParameter("@DeathReason", MySqlDbType.String, 1),
new MySqlParameter("@OtherDangerFrequen", MySqlDbType.Decimal),
new MySqlParameter("@FollowUpType", MySqlDbType.String, 1)
};
cmdParms[0].Value = model.CustomerID;
cmdParms[1].Value = model.RecordID;
cmdParms[2].Value = model.IDCardNo;
cmdParms[3].Value = model.FollowUpDate;
cmdParms[4].Value = model.Fatalness;
cmdParms[5].Value = model.PresentSymptom;
cmdParms[6].Value = model.PresentSymptoOther;
cmdParms[7].Value = model.Insight;
cmdParms[8].Value = model.SleepQuality;
cmdParms[9].Value = model.Diet;
cmdParms[10].Value = model.PersonalCare;
cmdParms[11].Value = model.Housework;
cmdParms[12].Value = model.ProductLaborWork;
cmdParms[13].Value = model.LearningAbility;
cmdParms[14].Value = model.SocialInterIntera;
cmdParms[15].Value = model.MildTroubleFrequen;
cmdParms[16].Value = model.CreateDistuFrequen;
cmdParms[17].Value = model.CauseAccidFrequen;
cmdParms[18].Value = model.AutolesionFrequen;
cmdParms[19].Value = model.AttemptSuicFrequen;
cmdParms[20].Value = model.AttemptSuicideNone;
cmdParms[21].Value = model.LockCondition;
cmdParms[22].Value = model.HospitalizatiStatus;
cmdParms[23].Value = model.LastLeaveHospTime;
cmdParms[24].Value = model.LaborExaminati;
cmdParms[25].Value = model.LaborExaminatiHave;
cmdParms[26].Value = model.MedicatioCompliance;
cmdParms[27].Value = model.AdnerDruReact;
cmdParms[28].Value = model.AdverDruReactHave;
cmdParms[29].Value = model.TreatmentEffect;
cmdParms[30].Value = model.WhetherReferral;
cmdParms[31].Value = model.ReferralReason;
cmdParms[32].Value = model.ReferralAgencDepar;
cmdParms[33].Value = model.RehabiliMeasu;
cmdParms[34].Value = model.RehabiliMeasuOther;
cmdParms[35].Value = model.FollowupClassificat;
cmdParms[36].Value = model.NextFollowUpDate;
cmdParms[37].Value = model.FollowUpDoctor;
cmdParms[38].Value = model.CreatedBy;
cmdParms[39].Value = model.CreatedDate;
cmdParms[40].Value = model.LastUpdateBy;
cmdParms[41].Value = model.LastUpdateDate;
cmdParms[42].Value = model.IsDel;
cmdParms[43].Value = model.NoVisitReason;
cmdParms[44].Value = model.DeathDate;
cmdParms[45].Value = model.IllReason;
cmdParms[46].Value = model.DeathReason;
cmdParms[47].Value = model.OtherDangerFrequen;
cmdParms[48].Value = model.FollowUpType;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}