public int Add(OldMedGuideModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" INSERT INTO tbl_oldmedguide( ");
builder.Append(" IDCardNo,GuideDate,Doctor,IdentifyResult,IdentifyDes,EmotionAdjust,DietAdjust,LiveAdjust,Sport,Collateral,Attention,OtherGuide,Type,OutKey) ");
builder.Append(" VALUES (");
builder.Append(" @IDCardNo,@GuideDate,@Doctor,@IdentifyResult,@IdentifyDes,@EmotionAdjust,@DietAdjust,@LiveAdjust,@Sport,@Collateral,@Attention,@OtherGuide,@Type,@OutKey) ");
builder.Append(";SELECT @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@GuideDate", MySqlDbType.Date),
new MySqlParameter("@Doctor", MySqlDbType.String, 50),
new MySqlParameter("@IdentifyResult", MySqlDbType.String, 10),
new MySqlParameter("@IdentifyDes", MySqlDbType.String, 1000),
new MySqlParameter("@EmotionAdjust", MySqlDbType.String, 1000),
new MySqlParameter("@DietAdjust", MySqlDbType.String, 1000),
new MySqlParameter("@LiveAdjust", MySqlDbType.String, 1000),
new MySqlParameter("@Sport", MySqlDbType.String, 1000),
new MySqlParameter("@Collateral", MySqlDbType.String, 1000),
new MySqlParameter("@Attention", MySqlDbType.String, 1000),
new MySqlParameter("@OtherGuide", MySqlDbType.String, 1000),
new MySqlParameter("@Type", MySqlDbType.Int32, 4),
new MySqlParameter("@OutKey", MySqlDbType.Int32, 4)
};
cmdParms[0].Value = model.IDCardNo;
cmdParms[1].Value = model.GuideDate;
cmdParms[2].Value = model.Doctor;
cmdParms[3].Value = model.IdentifyResult;
cmdParms[4].Value = model.IdentifyDes;
cmdParms[5].Value = model.EmotionAdjust;
cmdParms[6].Value = model.DietAdjust;
cmdParms[7].Value = model.LiveAdjust;
cmdParms[8].Value = model.Sport;
cmdParms[9].Value = model.Collateral;
cmdParms[10].Value = model.Attention;
cmdParms[11].Value = model.OtherGuide;
cmdParms[12].Value = model.Type;
cmdParms[13].Value = model.OutKey;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
/// <summary>
/// 中医体质同步存入指导意见
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateByUpload(OldMedGuideModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("UPDATE tbl_oldmedguide SET ");
builder.Append("Doctor=@Doctor,");
builder.Append("IdentifyResult=@IdentifyResult,");
builder.Append("IdentifyDes=@IdentifyDes,");
builder.Append("EmotionAdjust=@EmotionAdjust,");
builder.Append("DietAdjust=@DietAdjust,");
builder.Append("LiveAdjust=@LiveAdjust,");
builder.Append("Sport=@Sport,");
builder.Append("Collateral=@Collateral,");
builder.Append("Attention=@Attention, ");
builder.Append("OtherGuide=@OtherGuide ");
builder.Append(" WHERE OutKey=@OutKey");
builder.Append(" AND Type=@Type");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@Doctor", MySqlDbType.String, 50),
new MySqlParameter("@IdentifyResult", MySqlDbType.String, 10),
new MySqlParameter("@IdentifyDes", MySqlDbType.String, 1000),
new MySqlParameter("@EmotionAdjust", MySqlDbType.String, 1000),
new MySqlParameter("@DietAdjust", MySqlDbType.String, 1000),
new MySqlParameter("@LiveAdjust", MySqlDbType.String, 1000),
new MySqlParameter("@Sport", MySqlDbType.String, 1000),
new MySqlParameter("@Collateral", MySqlDbType.String, 1000),
new MySqlParameter("@Attention", MySqlDbType.String, 1000),
new MySqlParameter("@OtherGuide", MySqlDbType.String, 1000),
new MySqlParameter("@OutKey", MySqlDbType.Int32),
new MySqlParameter("@Type", MySqlDbType.Int32)
};
cmdParms[0].Value = model.Doctor;
cmdParms[1].Value = model.IdentifyResult;
cmdParms[2].Value = model.IdentifyDes;
cmdParms[3].Value = model.EmotionAdjust;
cmdParms[4].Value = model.DietAdjust;
cmdParms[5].Value = model.LiveAdjust;
cmdParms[6].Value = model.Sport;
cmdParms[7].Value = model.Collateral;
cmdParms[8].Value = model.Attention;
cmdParms[9].Value = model.OtherGuide;
cmdParms[10].Value = model.OutKey;
cmdParms[11].Value = model.Type;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public int Add(OldMedGuideModel model)
{
return(this.dal.Add(model));
}
/// <summary>
/// 中医体质同步存入指导意见
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool UpdateByUpload(OldMedGuideModel model)
{
return(this.dal.UpdateByUpload(model));
}
/// <summary>
/// 老年人
/// </summary>
/// <param name="IDCardNo"></param>
/// <param name="CheckDate"></param>
/// <param name="VersionNo"></param>
public void SaveOld(string IDCardNo, DateTime CheckDate, string VersionNo)
{
try
{
DataView dv = dsRequire.DefaultView;
// 获取最后一次随访数据
OlderSelfCareabilityModel oldSelfOldModel = OldSelfBLL.GetMaxModel(IDCardNo, "");
if (oldSelfOldModel == null)
{
oldSelfOldModel = new OlderSelfCareabilityModel();
}
OlderSelfCareabilityModel oldSelfNewModel = new OlderSelfCareabilityModel();
#region 自理能力
dv.RowFilter = null;
dv.RowFilter = "TabName='老年人随访' AND Comment='健康评估' AND (IsSetValue='是' OR IsSetValue='预设上次随访') ";
DataTable dt = dv.ToTable();
oldSelfNewModel = EntityAssignment <OlderSelfCareabilityModel>(oldSelfOldModel, oldSelfNewModel, dt);
oldSelfNewModel.IDCardNo = IDCardNo;
oldSelfNewModel.FollowUpDate = CheckDate;
oldSelfNewModel.FollowUpDoctor = ConfigHelper.GetNode("doctorName");
oldSelfNewModel.NextFollowUpDate = CheckDate.AddMonths(3);
oldSelfNewModel.CreatedBy = ConfigHelper.GetNodeDec("doctor");
oldSelfNewModel.CreatedDate = DateTime.Now;
oldSelfNewModel.LastUpDateBy = ConfigHelper.GetNodeDec("doctor");
oldSelfNewModel.LastUpDateDate = DateTime.Now;
#endregion
#region 中医体质及体质结果
MedicineModel oldMedicineOldModel = new MedicineModel();
// 如果为3.0版本，则中医与自理能力都是独立功能，获取最后一次随访数据
if (VersionNo.Contains("3.0"))
{
oldMedicineOldModel = OldMedicineCnBLL.GetAllModel(IDCardNo);
}
else
{
oldMedicineOldModel = OldMedicineCnBLL.GetModelByKey(oldSelfOldModel.ID);
}
MedicineModel oldMedicineNewModel = new MedicineModel();
if (oldMedicineOldModel == null)
{
oldMedicineOldModel = new MedicineModel();
}
// 中医体质预设上次随访内容
oldMedicineNewModel = EntityAssignment <MedicineModel>(oldMedicineOldModel, oldMedicineNewModel);
#endregion
#region 保存默认值
// 自理能力存档
int id = OldSelfBLL.Add(oldSelfNewModel, VersionNo);
if (id > 0)
{
// 中医体质
oldMedicineNewModel.IDCardNo = IDCardNo;
oldMedicineNewModel.OutKey = id;
oldMedicineNewModel.RecordDate = CheckDate.ToString("yyyy-MM-dd");
oldMedicineNewModel.FollowUpDoctor = ConfigHelper.GetNode("doctorName");
oldMedicineNewModel.NextFollowUpDate = CheckDate.AddMonths(3);
oldMedicineNewModel.CreatedBy = ConfigHelper.GetNodeDec("doctor");
oldMedicineNewModel.CreatedDate = DateTime.Now;
oldMedicineNewModel.LastUpdateBy = ConfigHelper.GetNodeDec("doctor");
oldMedicineNewModel.LastUpdateDate = DateTime.Now;
int medicineID = OldMedicineCnBLL.Add(oldMedicineNewModel, VersionNo);
// 中医体质结果
oldMedicineNewModel.MedicineID = medicineID;
OldMedicineResultBLL.Add(oldMedicineNewModel, VersionNo);
// 中医指导建议
OldMedGuideModel GuideModeTemp = new OldMedGuideModel();
string strTzlx = "";
GuideModeTemp.Type = 0;
GuideModeTemp.OutKey = Convert.ToInt32(id);
GuideModeTemp.Doctor = ConfigHelper.GetNode("doctorName");
GuideModeTemp.GuideDate = CheckDate;
GuideModeTemp.IDCardNo = IDCardNo;
#region 根据体质对应体质类型及见意
if (oldMedicineNewModel.Mild == "1" || oldMedicineNewModel.Mild == "2")
{
strTzlx = "平和质";
GuideModeTemp.IdentifyResult = "1";
}
else if (oldMedicineNewModel.Faint == "1" || oldMedicineNewModel.Faint == "2")
{
strTzlx = "气虚质";
GuideModeTemp.IdentifyResult = "2";
}
else if (oldMedicineNewModel.Yang == "1" || oldMedicineNewModel.Yang == "2")
{
strTzlx = "阳虚质";
GuideModeTemp.IdentifyResult = "3";
}
else if (oldMedicineNewModel.Yin == "1" || oldMedicineNewModel.Yin == "2")
{
strTzlx = "阴虚质";
GuideModeTemp.IdentifyResult = "4";
}
else if (oldMedicineNewModel.PhlegmDamp == "1" || oldMedicineNewModel.PhlegmDamp == "2")
{
strTzlx = "痰湿质";
GuideModeTemp.IdentifyResult = "5";
}
else if (oldMedicineNewModel.Muggy == "1" || oldMedicineNewModel.Muggy == "2")
{
strTzlx = "湿热质";
GuideModeTemp.IdentifyResult = "6";
}
else if (oldMedicineNewModel.BloodStasis == "1" || oldMedicineNewModel.BloodStasis == "2")
{
strTzlx = "血瘀质";
GuideModeTemp.IdentifyResult = "7";
}
else if (oldMedicineNewModel.QiConstraint == "1" || oldMedicineNewModel.QiConstraint == "2")
{
strTzlx = "气郁质";
GuideModeTemp.IdentifyResult = "8";
}
else if (oldMedicineNewModel.Characteristic == "1" || oldMedicineNewModel.Characteristic == "2")
{
strTzlx = "特兼质";
GuideModeTemp.IdentifyResult = "9";
}
DataTable dtOldCN = new DataTable();
if (File.Exists(Application.StartupPath + "\\OldCN.xml"))
{
DataSet ds = new DataSet();
ds.ReadXml(Application.StartupPath + "\\OldCN.xml");
dtOldCN = ds.Tables[0];
}
if (!string.IsNullOrEmpty(strTzlx) && dtOldCN != null)
{
foreach (DataRow item in dtOldCN.Rows)
{
if (item["name"].ToString() == strTzlx)
{
GuideModeTemp.EmotionAdjust = item["qzts"].ToString().Trim();
GuideModeTemp.DietAdjust = item["ysty"].ToString().Trim();
GuideModeTemp.LiveAdjust = item["qjts"].ToString().Trim();
GuideModeTemp.Sport = item["ydbj"].ToString().Trim();
GuideModeTemp.Collateral = item["jlbj"].ToString().Trim();
GuideModeTemp.Attention = item["zysx"].ToString().Trim();
GuideModeTemp.OtherGuide = item["qtzd"].ToString().Trim();
GuideModeTemp.IdentifyDes = item["bsjgms"].ToString().Trim();
break;
}
}
// 随访修改中医体质意见
if (!OldMedGuideBLL.UpdateByUpload(GuideModeTemp))
{
// 修改不到则新增
OldMedGuideBLL.Add(GuideModeTemp);
}
}
#endregion
}
#endregion
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
throw ex;
}
}
