public ScoreJudge(OlderMedicineResultModel src, string pscore, string pjudge, RadioButton r_y, RadioButton r_qy)
{
this.DataSrc = src;
this.ProScore = pscore;
this.ProJudege = pjudge;
this.rdY = r_y;
this.rdQY = r_qy;
}
public bool Update(OlderMedicineResultModel model)
{
return(this.dal.Update(model));
}
public int Add(OlderMedicineResultModel model)
{
return(this.dal.Add(model));
}
public void SetCnResult(string IDCardNo)
{
if (string.IsNullOrEmpty(Convert.ToString(RecordsManageMentModel.BMI)) &&
string.IsNullOrEmpty(Convert.ToString(RecordsManageMentModel.Waistline)))
{
return;
}
string strYear = DateTime.Now.Year.ToString();
string strOldWhere = string.Format("IDCardNo='{0}' AND left(FollowUpDate,4) = '{1}' order by FollowUpDate Desc limit 0,1 ", IDCardNo, strYear);
List <OlderSelfCareabilityModel> OlderList = new List <OlderSelfCareabilityModel>();
OlderList = new OlderSelfCareabilityBLL().GetModelList(strOldWhere);
if (OlderList.Count == 0)
{
return;
}
OlderSelfCareabilityModel olderModel = OlderList[0];
oldMedCn = olderMedicineCnBLL.GetModel(olderModel.IDCardNo, olderModel.ID);
oldMedResult = olderMedicineResultBLL.GetModel(olderModel.IDCardNo, olderModel.ID);
if (oldMedCn == null || oldMedResult == null)
{
return;
}
this.judge_qixu = new ScoreJudge(this.oldMedResult, "FaintScore", "Faint");
this.judge_yang = new ScoreJudge(this.oldMedResult, "YangsCore", "Yang");
this.judge_yin = new ScoreJudge(this.oldMedResult, "YinScore", "Yin");
this.judge_tanshi = new ScoreJudge(this.oldMedResult, "PhlegmdampScore", "PhlegmDamp");
this.judge_shire = new ScoreJudge(this.oldMedResult, "MuggyScore", "Muggy");
this.judge_xueyu = new ScoreJudge(this.oldMedResult, "BloodStasisScore", "BloodStasis");
this.judge_qiyu = new ScoreJudge(this.oldMedResult, "QiConstraintScore", "QiConstraint");
this.judge_tebing = new ScoreJudge(this.oldMedResult, "CharacteristicScore", "Characteristic");
this.judge_tizhiAll = new List <ScoreJudge>();
this.judge_tizhiAll.AddRange((IEnumerable <ScoreJudge>) new ScoreJudge[] { this.judge_qixu, this.judge_yang, this.judge_yin, this.judge_tanshi, this.judge_shire, this.judge_xueyu, this.judge_qiyu, this.judge_tebing });
if (!string.IsNullOrEmpty(Convert.ToString(RecordsManageMentModel.BMI)))
{
if (Convert.ToDouble(RecordsManageMentModel.BMI) < 24)
{
oldMedCn.Weight = 1;
}
else if (Convert.ToDouble(RecordsManageMentModel.BMI) >= 24 && Convert.ToDouble(RecordsManageMentModel.BMI) < 25)
{
oldMedCn.Weight = 2;
}
else if (Convert.ToDouble(RecordsManageMentModel.BMI) >= 25 && Convert.ToDouble(RecordsManageMentModel.BMI) < 26)
{
oldMedCn.Weight = 3;
}
else if (Convert.ToDouble(RecordsManageMentModel.BMI) >= 26 && Convert.ToDouble(RecordsManageMentModel.BMI) < 28)
{
oldMedCn.Weight = 4;
}
else if (Convert.ToDouble(RecordsManageMentModel.BMI) >= 28)
{
oldMedCn.Weight = 5;
}
}
if (!string.IsNullOrEmpty(Convert.ToString(RecordsManageMentModel.Waistline)))
{
if (Convert.ToDouble(RecordsManageMentModel.Waistline) < 80)
{
oldMedCn.Abdomen = 1;
}
else if (Convert.ToDouble(RecordsManageMentModel.Waistline) >= 80 && Convert.ToDouble(RecordsManageMentModel.Waistline) <= 85)
{
oldMedCn.Abdomen = 2;
}
else if (Convert.ToDouble(RecordsManageMentModel.Waistline) >= 86 && Convert.ToDouble(RecordsManageMentModel.Waistline) <= 90)
{
oldMedCn.Abdomen = 3;
}
else if (Convert.ToDouble(RecordsManageMentModel.Waistline) >= 91 && Convert.ToDouble(RecordsManageMentModel.Waistline) <= 105)
{
oldMedCn.Abdomen = 4;
}
else if (Convert.ToDouble(RecordsManageMentModel.Waistline) > 105)
{
oldMedCn.Abdomen = 5;
}
}
//this.xmlDs = new DataSet();
//this.xmlDs.ReadXml(Application.StartupPath + @"\old_med.xml");
//GlbTools.DatatableFillModel<OlderMedicineCnModel>(oldMedCn, this.xmlDs.Tables[0]);
oldMedResult.FaintScore = new decimal?(this.GetScore(oldMedCn.Tired, oldMedCn.Breath, oldMedCn.Voice, oldMedCn.Influenza));
oldMedResult.YangsCore = new decimal?(this.GetScore(oldMedCn.FootHand, oldMedCn.Stomach, oldMedCn.Cold, oldMedCn.Coolfood));
oldMedResult.YinScore = new decimal?(this.GetScore(oldMedCn.Eye, oldMedCn.Mouth, oldMedCn.Thirsty, oldMedCn.Defecatedry));
oldMedResult.PhlegmdampScore = new decimal?(this.GetScore(oldMedCn.Weight, oldMedCn.Snore, oldMedCn.Abdomen, oldMedCn.Tongue));
oldMedResult.MuggyScore = new decimal?(this.GetScore(oldMedCn.Greasy, oldMedCn.Eczema, oldMedCn.Smell, oldMedCn.Defecate));
oldMedResult.BloodStasisScore = new decimal?(this.GetScore(oldMedCn.Skin, oldMedCn.Arms, oldMedCn.Spot, oldMedCn.Vein));
oldMedResult.QiConstraintScore = new decimal?(this.GetScore(oldMedCn.Emotion, oldMedCn.Spirit, oldMedCn.Alone, oldMedCn.Fear));
oldMedResult.CharacteristicScore = new decimal?(this.GetScore(oldMedCn.Nasal, oldMedCn.Allergy, oldMedCn.Urticaria, oldMedCn.Scratch));
oldMedResult.MildScore = new decimal?(this.GetPinghe(oldMedCn.Energy, oldMedCn.Tired, oldMedCn.Voice, oldMedCn.Emotion, oldMedCn.Cold));
this.UpdateJudge();
//修改数据
olderMedicineCnBLL.Update(this.oldMedCn);
olderMedicineResultBLL.Update(this.oldMedResult);
}
public bool Update(OlderMedicineResultModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OLD_MEDICINE_RESULT set ");
builder.Append("PhysicalID=@PhysicalID,");
builder.Append("MedicineID=@MedicineID,");
builder.Append("Mild=@Mild,");
builder.Append("Faint=@Faint,");
builder.Append("Yang=@Yang,");
builder.Append("Yin=@Yin,");
builder.Append("PhlegmDamp=@PhlegmDamp,");
builder.Append("Muggy=@Muggy,");
builder.Append("BloodStasis=@BloodStasis,");
builder.Append("QiConstraint=@QiConstraint,");
builder.Append("Characteristic=@Characteristic,");
builder.Append("MildScore=@MildScore,");
builder.Append("FaintScore=@FaintScore,");
builder.Append("YangsCore=@YangsCore,");
builder.Append("YinScore=@YinScore,");
builder.Append("PhlegmdampScore=@PhlegmdampScore,");
builder.Append("MuggyScore=@MuggyScore,");
builder.Append("BloodStasisScore=@BloodStasisScore,");
builder.Append("QiConstraintScore=@QiConstraintScore,");
builder.Append("CharacteristicScore=@CharacteristicScore,");
builder.Append("MildAdvising=@MildAdvising,");
builder.Append("FaintAdvising=@FaintAdvising,");
builder.Append("YangAdvising=@YangAdvising,");
builder.Append("YinAdvising=@YinAdvising,");
builder.Append("PhlegmdampAdvising=@PhlegmdampAdvising,");
builder.Append("MuggyAdvising=@MuggyAdvising,");
builder.Append("BloodStasisAdvising=@BloodStasisAdvising,");
builder.Append("QiconstraintAdvising=@QiconstraintAdvising,");
builder.Append("CharacteristicAdvising=@CharacteristicAdvising,");
builder.Append("MildAdvisingEx=@MildAdvisingEx,");
builder.Append("FaintAdvisingEx=@FaintAdvisingEx,");
builder.Append("YangadvisingEx=@YangadvisingEx,");
builder.Append("YinAdvisingEx=@YinAdvisingEx,");
builder.Append("PhlegmdampAdvisingEx=@PhlegmdampAdvisingEx,");
builder.Append("MuggyAdvisingEx=@MuggyAdvisingEx,");
builder.Append("BloodStasisAdvisingEx=@BloodStasisAdvisingEx,");
builder.Append("QiconstraintAdvisingEx=@QiconstraintAdvisingEx,");
builder.Append("CharacteristicAdvisingEx=@CharacteristicAdvisingEx ,");
builder.Append("IsDel=@IsDel,");
builder.Append("IDCardNo=@IDCardNo,");
//新增字段
builder.Append("RecordDate=@RecordDate,");
builder.Append("EffectAssess=@EffectAssess,");
builder.Append("Satisfy=@Satisfy ");
builder.Append(" where OUTkey=@OUTkey");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@PhysicalID", MySqlDbType.String, 8),
new MySqlParameter("@MedicineID", MySqlDbType.Decimal),
new MySqlParameter("@Mild", MySqlDbType.String, 1),
new MySqlParameter("@Faint", MySqlDbType.String, 1),
new MySqlParameter("@Yang", MySqlDbType.String, 1),
new MySqlParameter("@Yin", MySqlDbType.String, 1),
new MySqlParameter("@PhlegmDamp", MySqlDbType.String, 1),
new MySqlParameter("@Muggy", MySqlDbType.String, 1),
new MySqlParameter("@BloodStasis", MySqlDbType.String, 1),
new MySqlParameter("@QiConstraint", MySqlDbType.String, 1),
new MySqlParameter("@Characteristic", MySqlDbType.String, 1),
new MySqlParameter("@MildScore", MySqlDbType.Decimal),
new MySqlParameter("@FaintScore", MySqlDbType.Decimal),
new MySqlParameter("@YangsCore", MySqlDbType.Decimal),
new MySqlParameter("@YinScore", MySqlDbType.Decimal),
new MySqlParameter("@PhlegmdampScore", MySqlDbType.Decimal),
new MySqlParameter("@MuggyScore", MySqlDbType.Decimal),
new MySqlParameter("@BloodStasisScore", MySqlDbType.Decimal),
new MySqlParameter("@QiConstraintScore", MySqlDbType.Decimal),
new MySqlParameter("@CharacteristicScore", MySqlDbType.Decimal),
new MySqlParameter("@MildAdvising", MySqlDbType.String, 18),
new MySqlParameter("@FaintAdvising", MySqlDbType.String, 18),
new MySqlParameter("@YangAdvising", MySqlDbType.String, 18),
new MySqlParameter("@YinAdvising", MySqlDbType.String, 18),
new MySqlParameter("@PhlegmdampAdvising", MySqlDbType.String, 18),
new MySqlParameter("@MuggyAdvising", MySqlDbType.String, 18),
new MySqlParameter("@BloodStasisAdvising", MySqlDbType.String, 18),
new MySqlParameter("@QiconstraintAdvising", MySqlDbType.String, 18),
new MySqlParameter("@CharacteristicAdvising", MySqlDbType.String, 18),
new MySqlParameter("@MildAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@FaintAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@YangadvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@YinAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@PhlegmdampAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@MuggyAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@BloodStasisAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@QiconstraintAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@CharacteristicAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@IsDel", MySqlDbType.String, 1),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@OUTkey", MySqlDbType.Int32, 8),
//新增字段
new MySqlParameter("@RecordDate", MySqlDbType.Date),
new MySqlParameter("@EffectAssess", MySqlDbType.String, 10),
new MySqlParameter("@Satisfy", MySqlDbType.String, 10)
};
cmdParms[0].Value = model.PhysicalID;
cmdParms[1].Value = model.MedicineID;
cmdParms[2].Value = model.Mild;
cmdParms[3].Value = model.Faint;
cmdParms[4].Value = model.Yang;
cmdParms[5].Value = model.Yin;
cmdParms[6].Value = model.PhlegmDamp;
cmdParms[7].Value = model.Muggy;
cmdParms[8].Value = model.BloodStasis;
cmdParms[9].Value = model.QiConstraint;
cmdParms[10].Value = model.Characteristic;
cmdParms[11].Value = model.MildScore;
cmdParms[12].Value = model.FaintScore;
cmdParms[13].Value = model.YangsCore;
cmdParms[14].Value = model.YinScore;
cmdParms[15].Value = model.PhlegmdampScore;
cmdParms[16].Value = model.MuggyScore;
cmdParms[17].Value = model.BloodStasisScore;
cmdParms[18].Value = model.QiConstraintScore;
cmdParms[19].Value = model.CharacteristicScore;
cmdParms[20].Value = model.MildAdvising;
cmdParms[21].Value = model.FaintAdvising;
cmdParms[22].Value = model.YangAdvising;
cmdParms[23].Value = model.YinAdvising;
cmdParms[24].Value = model.PhlegmdampAdvising;
cmdParms[25].Value = model.MuggyAdvising;
cmdParms[26].Value = model.BloodStasisAdvising;
cmdParms[27].Value = model.QiconstraintAdvising;
cmdParms[28].Value = model.CharacteristicAdvising;
cmdParms[29].Value = model.MildAdvisingEx;
cmdParms[30].Value = model.FaintAdvisingEx;
cmdParms[31].Value = model.YangadvisingEx;
cmdParms[32].Value = model.YinAdvisingEx;
cmdParms[33].Value = model.PhlegmdampAdvisingEx;
cmdParms[34].Value = model.MuggyAdvisingEx;
cmdParms[35].Value = model.BloodStasisAdvisingEx;
cmdParms[36].Value = model.QiconstraintAdvisingEx;
cmdParms[37].Value = model.CharacteristicAdvisingEx;
cmdParms[38].Value = model.IsDel;
cmdParms[39].Value = model.IDCardNo;
cmdParms[40].Value = model.OUTkey;
//新增字段
cmdParms[41].Value = model.RecordDate;
cmdParms[42].Value = model.EffectAssess;
cmdParms[43].Value = model.Satisfy;
return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
}
public int Add(OlderMedicineResultModel model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OLD_MEDICINE_RESULT(");
builder.Append("PhysicalID,MedicineID,Mild,Faint,Yang,Yin,PhlegmDamp,Muggy,BloodStasis,QIconStraint,Characteristic,");
builder.Append("MildScore,FaintScore,YangsCore,YinScore,PhlegmdampScore,MuggyScore,BloodStasisScore,QiConstraintScore,");
builder.Append("CharacteristicScore,MildAdvising,FaintAdvising,YangAdvising,YinAdvising,PhlegmdampAdvising,MuggyAdvising,");
builder.Append("BloodStasisAdvising,QiconstraintAdvising,CharacteristicAdvising,MildAdvisingEx,FaintAdvisingEx,YangadvisingEx,");
builder.Append("YinAdvisingEx,PhlegmdampAdvisingEx,MuggyAdvisingEx,BloodStasisAdvisingEx,QiconstraintAdvisingEx,");
builder.Append("CharacteristicAdvisingEx,IsDel,IDCardNo,OUTkey,RecordDate,EffectAssess,Satisfy)");
builder.Append(" values (");
builder.Append("@PhysicalID,@MedicineID,@Mild,@Faint,@Yang,@Yin,@PhlegmDamp,@Muggy,@BloodStasis,@QIconStraint,@Characteristic,");
builder.Append("@MildScore,@FaintScore,@YangsCore,@YinScore,@PhlegmdampScore,@MuggyScore,@BloodStasisScore,@QiConstraintScore,");
builder.Append("@CharacteristicScore,@MildAdvising,@FaintAdvising,@YangAdvising,@YinAdvising,@PhlegmdampAdvising,@MuggyAdvising,");
builder.Append("@BloodStasisAdvising,@QiconstraintAdvising,@CharacteristicAdvising,@MildAdvisingEx,@FaintAdvisingEx,@YangadvisingEx,");
builder.Append("@YinAdvisingEx,@PhlegmdampAdvisingEx,@MuggyAdvisingEx,@BloodStasisAdvisingEx,@QiconstraintAdvisingEx,");
builder.Append("@CharacteristicAdvisingEx,@IsDel,@IDCardNo,@OUTkey,@RecordDate,@EffectAssess,@Satisfy)");
builder.Append(" ;select @@IDENTITY");
MySqlParameter[] cmdParms = new MySqlParameter[] {
new MySqlParameter("@PhysicalID", MySqlDbType.String, 8),
new MySqlParameter("@MedicineID", MySqlDbType.Decimal),
new MySqlParameter("@Mild", MySqlDbType.String, 1),
new MySqlParameter("@Faint", MySqlDbType.String, 1),
new MySqlParameter("@Yang", MySqlDbType.String, 1),
new MySqlParameter("@Yin", MySqlDbType.String, 1),
new MySqlParameter("@PhlegmDamp", MySqlDbType.String, 1),
new MySqlParameter("@Muggy", MySqlDbType.String, 1),
new MySqlParameter("@BloodStasis", MySqlDbType.String, 1),
new MySqlParameter("@QIconStraint", MySqlDbType.String, 1),
new MySqlParameter("@Characteristic", MySqlDbType.String, 1),
new MySqlParameter("@MildScore", MySqlDbType.Decimal),
new MySqlParameter("@FaintScore", MySqlDbType.Decimal),
new MySqlParameter("@YangsCore", MySqlDbType.Decimal),
new MySqlParameter("@YinScore", MySqlDbType.Decimal),
new MySqlParameter("@PhlegmdampScore", MySqlDbType.Decimal),
new MySqlParameter("@MuggyScore", MySqlDbType.Decimal),
new MySqlParameter("@BloodStasisScore", MySqlDbType.Decimal),
new MySqlParameter("@QiConstraintScore", MySqlDbType.Decimal),
new MySqlParameter("@CharacteristicScore", MySqlDbType.Decimal),
new MySqlParameter("@MildAdvising", MySqlDbType.String, 18),
new MySqlParameter("@FaintAdvising", MySqlDbType.String, 18),
new MySqlParameter("@YangAdvising", MySqlDbType.String, 18),
new MySqlParameter("@YinAdvising", MySqlDbType.String, 18),
new MySqlParameter("@PhlegmdampAdvising", MySqlDbType.String, 18),
new MySqlParameter("@MuggyAdvising", MySqlDbType.String, 18),
new MySqlParameter("@BloodStasisAdvising", MySqlDbType.String, 18),
new MySqlParameter("@QiconstraintAdvising", MySqlDbType.String, 18),
new MySqlParameter("@CharacteristicAdvising", MySqlDbType.String, 18),
new MySqlParameter("@MildAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@FaintAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@YangadvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@YinAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@PhlegmdampAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@MuggyAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@BloodStasisAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@QiconstraintAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@CharacteristicAdvisingEx", MySqlDbType.String, 200),
new MySqlParameter("@IsDel", MySqlDbType.String, 1),
new MySqlParameter("@IDCardNo", MySqlDbType.String, 21),
new MySqlParameter("@OUTkey", MySqlDbType.Int32, 11),
//新增字段
new MySqlParameter("@RecordDate", MySqlDbType.Date),
new MySqlParameter("@EffectAssess", MySqlDbType.String, 10),
new MySqlParameter("@Satisfy", MySqlDbType.String, 10)
};
cmdParms[0].Value = model.PhysicalID;
cmdParms[1].Value = model.MedicineID;
cmdParms[2].Value = model.Mild;
cmdParms[3].Value = model.Faint;
cmdParms[4].Value = model.Yang;
cmdParms[5].Value = model.Yin;
cmdParms[6].Value = model.PhlegmDamp;
cmdParms[7].Value = model.Muggy;
cmdParms[8].Value = model.BloodStasis;
cmdParms[9].Value = model.QiConstraint;
cmdParms[10].Value = model.Characteristic;
cmdParms[11].Value = model.MildScore;
cmdParms[12].Value = model.FaintScore;
cmdParms[13].Value = model.YangsCore;
cmdParms[14].Value = model.YinScore;
cmdParms[15].Value = model.PhlegmdampScore;
cmdParms[16].Value = model.MuggyScore;
cmdParms[17].Value = model.BloodStasisScore;
cmdParms[18].Value = model.QiConstraintScore;
cmdParms[19].Value = model.CharacteristicScore;
cmdParms[20].Value = model.MildAdvising;
cmdParms[21].Value = model.FaintAdvising;
cmdParms[22].Value = model.YangAdvising;
cmdParms[23].Value = model.YinAdvising;
cmdParms[24].Value = model.PhlegmdampAdvising;
cmdParms[25].Value = model.MuggyAdvising;
cmdParms[26].Value = model.BloodStasisAdvising;
cmdParms[27].Value = model.QiconstraintAdvising;
cmdParms[28].Value = model.CharacteristicAdvising;
cmdParms[29].Value = model.MildAdvisingEx;
cmdParms[30].Value = model.FaintAdvisingEx;
cmdParms[31].Value = model.YangadvisingEx;
cmdParms[32].Value = model.YinAdvisingEx;
cmdParms[33].Value = model.PhlegmdampAdvisingEx;
cmdParms[34].Value = model.MuggyAdvisingEx;
cmdParms[35].Value = model.BloodStasisAdvisingEx;
cmdParms[36].Value = model.QiconstraintAdvisingEx;
cmdParms[37].Value = model.CharacteristicAdvisingEx;
cmdParms[38].Value = model.IsDel;
cmdParms[39].Value = model.IDCardNo;
cmdParms[40].Value = model.OUTkey;
//新增字段
cmdParms[41].Value = model.RecordDate;
cmdParms[42].Value = model.EffectAssess;
cmdParms[43].Value = model.Satisfy;
object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);
if (single == null)
{
return(0);
}
return(Convert.ToInt32(single));
}
