Пример #1
0
        private void btnElderM_Click(object sender, EventArgs e)
        {
            HealthOldMedEX dex = new HealthOldMedEX(this.Model)
            {
                phy             = this.HHMediphy,
                MedCn           = this.HHMediCn,
                MedResult       = this.HHMediRes,
                HealthModel     = this.HealthModel,
                FormBorderStyle = FormBorderStyle.FixedSingle,
                Text            = "中医体质判定",
                MaximizeBox     = false,
                MinimizeBox     = false,
                ShowIcon        = false
            };

            dex.PhysicalItem();
            dex.StartPosition = FormStartPosition.CenterParent;
            if (dex.ShowDialog() == DialogResult.OK)
            {
                this.pinghezhi.Reset(this.HHMediphy.Mild);
                this.qixuzhi.Reset(this.HHMediphy.Faint);
                this.yangxuzhi.Reset(this.HHMediphy.Yang);
                this.yinxuzhi.Reset(this.HHMediphy.Yin);
                this.tanshizhi.Reset(this.HHMediphy.PhlegmDamp);
                this.shirezhi.Reset(this.HHMediphy.Muggy);
                this.xueyuzhi.Reset(this.HHMediphy.BloodStasis);
                this.qiyuzhi.Reset(this.HHMediphy.QiConstraint);
                this.tejianzhi.Reset(this.HHMediphy.Characteristic);
                this.HHMediCn  = dex.MedCn;
                this.HHMediRes = dex.MedResult;
            }
        }
Пример #2
0
 public void InitEveryThing()
 {
     this.HHMediphy = this.MediPyBLL.GetModel(HealthHouseFactory.ID);
     if (this.HHMediphy == null)
     {
         this.HHMediphy          = new HealthHouseMediPhyModel();
         this.HHMediphy.IDCardNo = this.Model.IDCardNo;
     }
     else
     {
         this.HHMediCn  = this.MediCnBll.GetModel(this.HHMediphy.MedicineID);
         this.HHMediRes = this.MediResBLL.GetModel(this.HHMediphy.MedicineResultID);
     }
     this.HealthModel = new HealthHouseBLL().GetDataByID(HealthHouseFactory.ID);
     if (this.HealthModel == null)
     {
         this.HealthModel = new HealthHouseModel();
     }
     this.pinghezhi      = new Physique(this.radshipinghe, this.radjibenpinghe, this.HHMediphy.Mild);
     this.qixuzhi        = new Physique(this.radshiqixu, this.radqingqixu, this.HHMediphy.Faint);
     this.yangxuzhi      = new Physique(this.radshiyangxu, this.radqingyangxu, this.HHMediphy.Yang);
     this.yinxuzhi       = new Physique(this.radshiyinxu, this.radqingyinxu, this.HHMediphy.Yin);
     this.tanshizhi      = new Physique(this.radshitanshi, this.radqingtanshi, this.HHMediphy.PhlegmDamp);
     this.shirezhi       = new Physique(this.radshishire, this.radqingshire, this.HHMediphy.Muggy);
     this.xueyuzhi       = new Physique(this.radshixueyu, this.radqingxueyu, this.HHMediphy.BloodStasis);
     this.qiyuzhi        = new Physique(this.radshiqiyu, this.radqingqiyu, this.HHMediphy.QiConstraint);
     this.tejianzhi      = new Physique(this.radshitejian, this.radqingtejian, this.HHMediphy.Characteristic);
     this.EveryThingIsOk = true;
 }
Пример #3
0
 public ScoreJudge(HealthHouseMedicineResultModel 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(HealthHouseMedicineResultModel model)
 {
     return(this.dal.Update(model));
 }
 public int Add(HealthHouseMedicineResultModel model)
 {
     return(this.dal.Add(model));
 }
Пример #6
0
        public bool Update(HealthHouseMedicineResultModel model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("update HEALTHHOUSE_MEDICINE_RESULT set ");
            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("IDCardNo=@IDCardNo ");
            builder.Append(" where ID=@ID");
            MySqlParameter[] cmdParms = new MySqlParameter[] {
                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("@IDCardNo", MySqlDbType.String, 21),
                new MySqlParameter("@ID", MySqlDbType.Int32, 8)
            };
            cmdParms[0].Value  = model.Mild;
            cmdParms[1].Value  = model.Faint;
            cmdParms[2].Value  = model.Yang;
            cmdParms[3].Value  = model.Yin;
            cmdParms[4].Value  = model.PhlegmDamp;
            cmdParms[5].Value  = model.Muggy;
            cmdParms[6].Value  = model.BloodStasis;
            cmdParms[7].Value  = model.QiConstraint;
            cmdParms[8].Value  = model.Characteristic;
            cmdParms[9].Value  = model.MildScore;
            cmdParms[10].Value = model.FaintScore;
            cmdParms[11].Value = model.YangsCore;
            cmdParms[12].Value = model.YinScore;
            cmdParms[13].Value = model.PhlegmdampScore;
            cmdParms[14].Value = model.MuggyScore;
            cmdParms[15].Value = model.BloodStasisScore;
            cmdParms[16].Value = model.QiConstraintScore;
            cmdParms[17].Value = model.CharacteristicScore;
            cmdParms[18].Value = model.MildAdvising;
            cmdParms[19].Value = model.FaintAdvising;
            cmdParms[20].Value = model.YangAdvising;
            cmdParms[21].Value = model.YinAdvising;
            cmdParms[22].Value = model.PhlegmdampAdvising;
            cmdParms[23].Value = model.MuggyAdvising;
            cmdParms[24].Value = model.BloodStasisAdvising;
            cmdParms[25].Value = model.QiconstraintAdvising;
            cmdParms[26].Value = model.CharacteristicAdvising;
            cmdParms[27].Value = model.MildAdvisingEx;
            cmdParms[28].Value = model.FaintAdvisingEx;
            cmdParms[29].Value = model.YangadvisingEx;
            cmdParms[30].Value = model.YinAdvisingEx;
            cmdParms[31].Value = model.PhlegmdampAdvisingEx;
            cmdParms[32].Value = model.MuggyAdvisingEx;
            cmdParms[33].Value = model.BloodStasisAdvisingEx;
            cmdParms[34].Value = model.QiconstraintAdvisingEx;
            cmdParms[35].Value = model.CharacteristicAdvisingEx;
            cmdParms[36].Value = model.IDCardNo;
            cmdParms[37].Value = model.ID;
            return(MySQLHelper.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }
Пример #7
0
        public int Add(HealthHouseMedicineResultModel model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("insert into HEALTHHOUSE_MEDICINE_RESULT(");
            builder.Append("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,IDCardNo)");
            builder.Append(" values (");
            builder.Append("@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,@IDCardNo)");
            builder.Append(" ;select @@IDENTITY");
            MySqlParameter[] cmdParms = new MySqlParameter[] {
                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("@IDCardNo", MySqlDbType.String, 21)
            };
            cmdParms[0].Value  = model.Mild;
            cmdParms[1].Value  = model.Faint;
            cmdParms[2].Value  = model.Yang;
            cmdParms[3].Value  = model.Yin;
            cmdParms[4].Value  = model.PhlegmDamp;
            cmdParms[5].Value  = model.Muggy;
            cmdParms[6].Value  = model.BloodStasis;
            cmdParms[7].Value  = model.QiConstraint;
            cmdParms[8].Value  = model.Characteristic;
            cmdParms[9].Value  = model.MildScore;
            cmdParms[10].Value = model.FaintScore;
            cmdParms[11].Value = model.YangsCore;
            cmdParms[12].Value = model.YinScore;
            cmdParms[13].Value = model.PhlegmdampScore;
            cmdParms[14].Value = model.MuggyScore;
            cmdParms[15].Value = model.BloodStasisScore;
            cmdParms[16].Value = model.QiConstraintScore;
            cmdParms[17].Value = model.CharacteristicScore;
            cmdParms[18].Value = model.MildAdvising;
            cmdParms[19].Value = model.FaintAdvising;
            cmdParms[20].Value = model.YangAdvising;
            cmdParms[21].Value = model.YinAdvising;
            cmdParms[22].Value = model.PhlegmdampAdvising;
            cmdParms[23].Value = model.MuggyAdvising;
            cmdParms[24].Value = model.BloodStasisAdvising;
            cmdParms[25].Value = model.QiconstraintAdvising;
            cmdParms[26].Value = model.CharacteristicAdvising;
            cmdParms[27].Value = model.MildAdvisingEx;
            cmdParms[28].Value = model.FaintAdvisingEx;
            cmdParms[29].Value = model.YangadvisingEx;
            cmdParms[30].Value = model.YinAdvisingEx;
            cmdParms[31].Value = model.PhlegmdampAdvisingEx;
            cmdParms[32].Value = model.MuggyAdvisingEx;
            cmdParms[33].Value = model.BloodStasisAdvisingEx;
            cmdParms[34].Value = model.QiconstraintAdvisingEx;
            cmdParms[35].Value = model.CharacteristicAdvisingEx;
            cmdParms[36].Value = model.IDCardNo;
            object single = MySQLHelper.GetSingle(builder.ToString(), cmdParms);

            if (single == null)
            {
                return(0);
            }
            return(Convert.ToInt32(single));
        }
Пример #8
0
        public HealthHouseMedicineResultModel DataRowToModel(DataRow row)
        {
            HealthHouseMedicineResultModel medicine_result = new HealthHouseMedicineResultModel();

            if (row != null)
            {
                if (((row["ID"] != null) && (row["ID"] != DBNull.Value)) && (row["ID"].ToString() != ""))
                {
                    medicine_result.ID = int.Parse(row["ID"].ToString());
                }
                if ((row["Mild"] != null) && (row["Mild"] != DBNull.Value))
                {
                    medicine_result.Mild = row["Mild"].ToString();
                }
                if ((row["Faint"] != null) && (row["Faint"] != DBNull.Value))
                {
                    medicine_result.Faint = row["Faint"].ToString();
                }
                if ((row["Yang"] != null) && (row["Yang"] != DBNull.Value))
                {
                    medicine_result.Yang = row["Yang"].ToString();
                }
                if ((row["Yin"] != null) && (row["Yin"] != DBNull.Value))
                {
                    medicine_result.Yin = row["Yin"].ToString();
                }
                if ((row["PhlegmDamp"] != null) && (row["PhlegmDamp"] != DBNull.Value))
                {
                    medicine_result.PhlegmDamp = row["PhlegmDamp"].ToString();
                }
                if ((row["Muggy"] != null) && (row["Muggy"] != DBNull.Value))
                {
                    medicine_result.Muggy = row["Muggy"].ToString();
                }
                if ((row["BloodStasis"] != null) && (row["BloodStasis"] != DBNull.Value))
                {
                    medicine_result.BloodStasis = row["BloodStasis"].ToString();
                }
                if ((row["QIconStraint"] != null) && (row["QIconStraint"] != DBNull.Value))
                {
                    medicine_result.QiConstraint = row["QIconStraint"].ToString();
                }
                if ((row["Characteristic"] != null) && (row["Characteristic"] != DBNull.Value))
                {
                    medicine_result.Characteristic = row["Characteristic"].ToString();
                }
                if (((row["MildScore"] != null) && (row["MildScore"] != DBNull.Value)) && (row["MildScore"].ToString() != ""))
                {
                    medicine_result.MildScore = new decimal?(decimal.Parse(row["MildScore"].ToString()));
                }
                if (((row["FaintScore"] != null) && (row["FaintScore"] != DBNull.Value)) && (row["FaintScore"].ToString() != ""))
                {
                    medicine_result.FaintScore = new decimal?(decimal.Parse(row["FaintScore"].ToString()));
                }
                if (((row["YangsCore"] != null) && (row["YangsCore"] != DBNull.Value)) && (row["YangsCore"].ToString() != ""))
                {
                    medicine_result.YangsCore = new decimal?(decimal.Parse(row["YangsCore"].ToString()));
                }
                if (((row["YinScore"] != null) && (row["YinScore"] != DBNull.Value)) && (row["YinScore"].ToString() != ""))
                {
                    medicine_result.YinScore = new decimal?(decimal.Parse(row["YinScore"].ToString()));
                }
                if (((row["PhlegmdampScore"] != null) && (row["PhlegmdampScore"] != DBNull.Value)) && (row["PhlegmdampScore"].ToString() != ""))
                {
                    medicine_result.PhlegmdampScore = new decimal?(decimal.Parse(row["PhlegmdampScore"].ToString()));
                }
                if (((row["MuggyScore"] != null) && (row["MuggyScore"] != DBNull.Value)) && (row["MuggyScore"].ToString() != ""))
                {
                    medicine_result.MuggyScore = new decimal?(decimal.Parse(row["MuggyScore"].ToString()));
                }
                if (((row["BloodStasisScore"] != null) && (row["BloodStasisScore"] != DBNull.Value)) && (row["BloodStasisScore"].ToString() != ""))
                {
                    medicine_result.BloodStasisScore = new decimal?(decimal.Parse(row["BloodStasisScore"].ToString()));
                }
                if (((row["QiConstraintScore"] != null) && (row["QiConstraintScore"] != DBNull.Value)) && (row["QiConstraintScore"].ToString() != ""))
                {
                    medicine_result.QiConstraintScore = new decimal?(decimal.Parse(row["QiConstraintScore"].ToString()));
                }
                if (((row["CharacteristicScore"] != null) && (row["CharacteristicScore"] != DBNull.Value)) && (row["CharacteristicScore"].ToString() != ""))
                {
                    medicine_result.CharacteristicScore = new decimal?(decimal.Parse(row["CharacteristicScore"].ToString()));
                }
                if ((row["MildAdvising"] != null) && (row["MildAdvising"] != DBNull.Value))
                {
                    medicine_result.MildAdvising = row["MildAdvising"].ToString();
                }
                if ((row["FaintAdvising"] != null) && (row["FaintAdvising"] != DBNull.Value))
                {
                    medicine_result.FaintAdvising = row["FaintAdvising"].ToString();
                }
                if ((row["YangAdvising"] != null) && (row["YangAdvising"] != DBNull.Value))
                {
                    medicine_result.YangAdvising = row["YangAdvising"].ToString();
                }
                if ((row["YinAdvising"] != null) && (row["YinAdvising"] != DBNull.Value))
                {
                    medicine_result.YinAdvising = row["YinAdvising"].ToString();
                }
                if ((row["PhlegmdampAdvising"] != null) && (row["PhlegmdampAdvising"] != DBNull.Value))
                {
                    medicine_result.PhlegmdampAdvising = row["PhlegmdampAdvising"].ToString();
                }
                if ((row["MuggyAdvising"] != null) && (row["MuggyAdvising"] != DBNull.Value))
                {
                    medicine_result.MuggyAdvising = row["MuggyAdvising"].ToString();
                }
                if ((row["BloodStasisAdvising"] != null) && (row["BloodStasisAdvising"] != DBNull.Value))
                {
                    medicine_result.BloodStasisAdvising = row["BloodStasisAdvising"].ToString();
                }
                if ((row["QiconstraintAdvising"] != null) && (row["QiconstraintAdvising"] != DBNull.Value))
                {
                    medicine_result.QiconstraintAdvising = row["QiconstraintAdvising"].ToString();
                }
                if ((row["CharacteristicAdvising"] != null) && (row["CharacteristicAdvising"] != DBNull.Value))
                {
                    medicine_result.CharacteristicAdvising = row["CharacteristicAdvising"].ToString();
                }
                if ((row["MildAdvisingEx"] != null) && (row["MildAdvisingEx"] != DBNull.Value))
                {
                    medicine_result.MildAdvisingEx = row["MildAdvisingEx"].ToString();
                }
                if ((row["FaintAdvisingEx"] != null) && (row["FaintAdvisingEx"] != DBNull.Value))
                {
                    medicine_result.FaintAdvisingEx = row["FaintAdvisingEx"].ToString();
                }
                if ((row["YangadvisingEx"] != null) && (row["YangadvisingEx"] != DBNull.Value))
                {
                    medicine_result.YangadvisingEx = row["YangadvisingEx"].ToString();
                }
                if ((row["YinAdvisingEx"] != null) && (row["YinAdvisingEx"] != DBNull.Value))
                {
                    medicine_result.YinAdvisingEx = row["YinAdvisingEx"].ToString();
                }
                if ((row["PhlegmdampAdvisingEx"] != null) && (row["PhlegmdampAdvisingEx"] != DBNull.Value))
                {
                    medicine_result.PhlegmdampAdvisingEx = row["PhlegmdampAdvisingEx"].ToString();
                }
                if ((row["MuggyAdvisingEx"] != null) && (row["MuggyAdvisingEx"] != DBNull.Value))
                {
                    medicine_result.MuggyAdvisingEx = row["MuggyAdvisingEx"].ToString();
                }
                if ((row["BloodStasisAdvisingEx"] != null) && (row["BloodStasisAdvisingEx"] != DBNull.Value))
                {
                    medicine_result.BloodStasisAdvisingEx = row["BloodStasisAdvisingEx"].ToString();
                }
                if ((row["QiconstraintAdvisingEx"] != null) && (row["QiconstraintAdvisingEx"] != DBNull.Value))
                {
                    medicine_result.QiconstraintAdvisingEx = row["QiconstraintAdvisingEx"].ToString();
                }
                if ((row["CharacteristicAdvisingEx"] != null) && (row["CharacteristicAdvisingEx"] != DBNull.Value))
                {
                    medicine_result.CharacteristicAdvisingEx = row["CharacteristicAdvisingEx"].ToString();
                }
                if ((row["IDCardNo"] != null) && (row["IDCardNo"] != DBNull.Value))
                {
                    medicine_result.IDCardNo = row["IDCardNo"].ToString();
                }
            }
            return(medicine_result);
        }