Beispiel #1
0
        private void pictureBoxDataupload_Click(object sender, EventArgs e)
        {
            string strwhere = "";

            if (this.ckbcheckdate.Checked)
            {
                strwhere = string.Format(" CheckDate BETWEEN '{0}' and '{1}' ",
                                         this.dtpstart.Value.Date.ToString("yyyy-MM-dd"), this.dtpend.Value.Date.ToString("yyyy-MM-dd"));
            }

            DataSet customds = new RecordsCustomerBaseInfoBLL().GetList(strwhere);

            int amount = 0;

            progressBar1.Visible   = true;
            progressBar1.Minimum   = 0;
            progressBar1.Maximum   = customds.Tables[0].Rows.Count;
            progressBar1.BackColor = Color.Green;
            labCountnum.Text       = customds.Tables[0].Rows.Count.ToString();

            foreach (DataRow row in customds.Tables[0].Rows)
            {
                if (string.IsNullOrEmpty(row["IDCardNo"].ToString()))
                {
                    continue;
                }

                int OutKey = Convert.ToInt32(row["ID"].ToString());

                // 基本信息
                this.Model = new RecordsBaseInfoBLL().GetModel(row["IDCardNo"].ToString());
                if (this.Model == null)
                {
                    this.Model = new RecordsBaseInfoModel();
                }

                // 健康评价
                this.AssessmentGuides = new RecordsAssessmentGuideBLL().GetModelByOutKey(OutKey);

                if (this.AssessmentGuides == null)
                {
                    this.AssessmentGuides = new RecordsAssessmentGuideModel();
                }

                this.AssessmentGuides.IDCardNo = this.Model.IDCardNo;

                // 辅助检查
                this.AssistCheck = new RecordsAssistCheckBLL().GetModelByOutKey(OutKey);
                if (this.AssistCheck == null)
                {
                    this.AssistCheck = new RecordsAssistCheckModel();
                }

                // 一般状况
                this.generalconditionmodel = new RecordsGeneralConditionBLL().GetModelByOutKey(OutKey);
                if (this.generalconditionmodel == null)
                {
                    this.generalconditionmodel = new RecordsGeneralConditionModel();
                }

                // 查体
                this.physicalModel = new RecordsPhysicalExamBLL().GetModelByOutKey(OutKey);
                if (this.physicalModel == null)
                {
                    this.physicalModel = new RecordsPhysicalExamModel();
                }

                // 现存健康问题
                this.questionModel = new RecordsHealthQuestionBLL().GetModelByOutKey(OutKey);
                if (this.questionModel == null)
                {
                    this.questionModel = new RecordsHealthQuestionModel();
                }

                // 生活方式
                this.liftModel = new RecordsLifeStyleBLL().GetModelByOutKey(OutKey);
                if (this.liftModel == null)
                {
                    this.liftModel = new RecordsLifeStyleModel();
                }

                //脏器功能
                this.visceraFunctionModel = new RecordsVisceraFunctionBLL().GetModelByOutKey(OutKey);
                if (this.visceraFunctionModel == null)
                {
                    this.visceraFunctionModel = new RecordsVisceraFunctionModel();
                }
                AssessmentGuides.IsNormal      = "1";
                AssessmentGuides.Exception1    = null;
                AssessmentGuides.Exception2    = null;
                AssessmentGuides.Exception3    = null;
                AssessmentGuides.Exception4    = null;
                AssessmentGuides.HealthGuide   = null;
                AssessmentGuides.DangerControl = null;
                AssessmentGuides.Arm           = null;
                AssessmentGuides.VaccineAdvice = null;
                AssessmentGuides.Other         = null;
                AssessmentGuides.WaistlineArm  = null;

                #region  赋值给RecordsManageMentModel

                RecordsManageMentModel.Symptom            = row["Symptom"].ToString();
                RecordsManageMentModel.Other              = row["Other"].ToString();
                RecordsManageMentModel.BMI                = this.generalconditionmodel.BMI;
                RecordsManageMentModel.RightHeight        = this.generalconditionmodel.RightHeight;
                RecordsManageMentModel.RightPre           = this.generalconditionmodel.RightPre;
                RecordsManageMentModel.LeftHeight         = this.generalconditionmodel.LeftHeight;
                RecordsManageMentModel.LeftPre            = this.generalconditionmodel.LeftPre;
                RecordsManageMentModel.Waistline          = this.generalconditionmodel.Waistline;
                RecordsManageMentModel.Height             = this.generalconditionmodel.Height;
                RecordsManageMentModel.PulseRate          = this.generalconditionmodel.PulseRate;
                RecordsManageMentModel.Weight             = this.generalconditionmodel.Weight;
                RecordsManageMentModel.OldSelfCareability = this.generalconditionmodel.OldSelfCareability;
                RecordsManageMentModel.DrinkRate          = this.liftModel.DrinkRate;
                RecordsManageMentModel.SmokeCondition     = this.liftModel.SmokeCondition;
                RecordsManageMentModel.ExerciseRate       = this.liftModel.ExerciseRate;

                if (this.liftModel.ExerciseTimes.HasValue)
                {
                    RecordsManageMentModel.ExerciseTimes = this.liftModel.ExerciseTimes.ToString();
                }
                else
                {
                    RecordsManageMentModel.ExerciseTimes = "";
                }

                RecordsManageMentModel.DietaryHabit = this.liftModel.DietaryHabit;
                RecordsManageMentModel.ECG          = this.AssistCheck.ECG;
                RecordsManageMentModel.ECGEx        = "";

                if (!string.IsNullOrEmpty(this.AssistCheck.ECG))
                {
                    if (this.AssistCheck.ECG.Contains("2"))
                    {
                        RecordsManageMentModel.ECGEx += "ST-T改变,";
                    }
                    if (this.AssistCheck.ECG.Contains("3"))
                    {
                        RecordsManageMentModel.ECGEx += "陈旧性心肌梗塞,";
                    }
                    if (this.AssistCheck.ECG.Contains("4"))
                    {
                        RecordsManageMentModel.ECGEx += "窦性心动过速,";
                    }
                    if (this.AssistCheck.ECG.Contains("5"))
                    {
                        RecordsManageMentModel.ECGEx += "窦性心动过缓,";
                    }
                    if (this.AssistCheck.ECG.Contains("6"))
                    {
                        RecordsManageMentModel.ECGEx += "早搏,";
                    }
                    if (this.AssistCheck.ECG.Contains("7"))
                    {
                        RecordsManageMentModel.ECGEx += "房颤,";
                    }
                    if (this.AssistCheck.ECG.Contains("8"))
                    {
                        RecordsManageMentModel.ECGEx += "房室传导阻滞,";
                    }
                    if (this.AssistCheck.ECG.Contains("9"))
                    {
                        RecordsManageMentModel.ECGEx += this.AssistCheck.ECGEx;
                    }
                }
                else
                {
                    RecordsManageMentModel.ECGEx = "";
                }

                RecordsManageMentModel.BCHAO      = this.AssistCheck.BCHAO;
                RecordsManageMentModel.BCHAOEx    = this.AssistCheck.BCHAOEx;
                RecordsManageMentModel.PRO        = this.AssistCheck.PRO;
                RecordsManageMentModel.GLU        = this.AssistCheck.GLU;
                RecordsManageMentModel.KET        = this.AssistCheck.KET;
                RecordsManageMentModel.BLD        = this.AssistCheck.BLD;
                RecordsManageMentModel.UrineOther = this.AssistCheck.UrineOther;
                RecordsManageMentModel.HB         = this.AssistCheck.HB;
                RecordsManageMentModel.WBC        = this.AssistCheck.WBC;
                RecordsManageMentModel.PLT        = this.AssistCheck.PLT;
                RecordsManageMentModel.SGPT       = this.AssistCheck.SGPT;
                RecordsManageMentModel.GOT        = this.AssistCheck.GOT;
                RecordsManageMentModel.BP         = this.AssistCheck.BP;
                RecordsManageMentModel.TBIL       = this.AssistCheck.TBIL;
                RecordsManageMentModel.CB         = this.AssistCheck.CB;
                RecordsManageMentModel.SCR        = this.AssistCheck.SCR;
                RecordsManageMentModel.BUN        = this.AssistCheck.BUN;
                RecordsManageMentModel.PC         = this.AssistCheck.PC;
                RecordsManageMentModel.TC         = this.AssistCheck.TC;
                RecordsManageMentModel.HYPE       = this.AssistCheck.HYPE;
                RecordsManageMentModel.TG         = this.AssistCheck.TG;
                RecordsManageMentModel.GT         = this.AssistCheck.GT;
                RecordsManageMentModel.LowCho     = this.AssistCheck.LowCho;
                RecordsManageMentModel.HeiCho     = this.AssistCheck.HeiCho;
                RecordsManageMentModel.FPGL       = this.AssistCheck.FPGL;
                RecordsManageMentModel.HCY        = this.AssistCheck.HCY;
                RecordsManageMentModel.Other      = this.AssistCheck.Other;

                if (community.Equals("威海美年大健康") && StringPlus.toString(this.AssistCheck.UA) != "")
                {
                    RecordsManageMentModel.UA = this.AssistCheck.UA;
                }

                RecordsManageMentModel.BrainDis      = this.questionModel.BrainDis;
                RecordsManageMentModel.RenalDis      = this.questionModel.RenalDis;
                RecordsManageMentModel.HeartDis      = this.questionModel.HeartDis;
                RecordsManageMentModel.EyeDis        = this.questionModel.EyeDis;
                RecordsManageMentModel.NerveDis      = this.questionModel.NerveDis;
                RecordsManageMentModel.ElseDis       = this.questionModel.ElseDis;
                RecordsManageMentModel.BrainOther    = this.questionModel.BrainOther;
                RecordsManageMentModel.RenalOther    = this.questionModel.RenalOther;
                RecordsManageMentModel.HeartOther    = this.questionModel.HeartOther;
                RecordsManageMentModel.EyeOther      = this.questionModel.EyeOther;
                RecordsManageMentModel.NerveOther    = this.questionModel.NerveOther;
                RecordsManageMentModel.ElseOther     = this.questionModel.ElseOther;
                RecordsManageMentModel.BarrelChest   = this.physicalModel.BarrelChest;  //桶状胸
                RecordsManageMentModel.BreathSounds  = this.physicalModel.BreastEx;     //呼吸音
                RecordsManageMentModel.Rale          = this.physicalModel.Rale;         //罗音
                RecordsManageMentModel.HeartRhythm   = this.physicalModel.HeartRhythm;  //心律
                RecordsManageMentModel.Noise         = this.physicalModel.Noise;        //杂音
                RecordsManageMentModel.PressPain     = this.physicalModel.PressPain;    //压痛
                RecordsManageMentModel.EnclosedMass  = this.physicalModel.EnclosedMass; //包块
                RecordsManageMentModel.Liver         = this.physicalModel.Liver;        //肝大
                RecordsManageMentModel.Spleen        = this.physicalModel.Spleen;       //脾大
                RecordsManageMentModel.Voiced        = this.physicalModel.Voiced;       //移动性浊音
                RecordsManageMentModel.FootBack      = this.physicalModel.FootBack;     //足背动脉搏动
                RecordsManageMentModel.Edema         = this.physicalModel.Edema;        // 下肢水肿
                RecordsManageMentModel.LeftView      = this.visceraFunctionModel.LeftView;
                RecordsManageMentModel.RightView     = this.visceraFunctionModel.RightView;
                RecordsManageMentModel.HeartRate     = this.physicalModel.HeartRate;
                RecordsManageMentModel.Listen        = visceraFunctionModel.Listen;
                RecordsManageMentModel.SportFunction = visceraFunctionModel.SportFunction;

                #endregion

                healthAssessment = new HealthAssessment {
                    Model = this.Model
                };
                olderCnandResult = new OlderCnAndResult();

                // 异常信息
                this.AssessmentGuides = healthAssessment.SetHealthEx(this.AssessmentGuides);

                // 危险因素控制
                this.AssessmentGuides = healthAssessment.SetDangerous(this.AssessmentGuides);

                //随访中医辨识更新
                olderCnandResult.SetCnResult(row["IDCardNo"].ToString());

                // 健康评价异常的更新
                if (this.AssessmentGuides != null)
                {
                    this.AssessmentGuides.OutKey = OutKey;
                    RecordsAssessmentGuideBLL recordsAssessmentGuideBll = new RecordsAssessmentGuideBLL();
                    if (!recordsAssessmentGuideBll.ExistsOutKey(this.AssessmentGuides.IDCardNo, OutKey))
                    {
                        if (recordsAssessmentGuideBll.Add(this.AssessmentGuides) > 0)
                        {
                            amount++;
                            labUploadnum.Text  = amount.ToString();
                            progressBar1.Value = amount;
                        }
                    }
                    else
                    {
                        if (recordsAssessmentGuideBll.Update(this.AssessmentGuides))
                        {
                            amount++;
                            labUploadnum.Text  = amount.ToString();
                            progressBar1.Value = amount;
                        }
                    }
                }
            }

            MessageBox.Show("成功匹配:" + amount + "条数据!", "提示");
            progressBar1.Visible = false;
        }
Beispiel #2
0
        private void TransDs(DataSet ds)
        {
            ds.Tables[0].Columns.Add("MustChoose");
            string mustchoosenode = ConfigHelper.GetMustChooseNode("mustchoose");

            if (string.IsNullOrEmpty(mustchoosenode))
            {
                mustchoosenode = "0000000000000000000000000000000000000000000000000";
                ConfigHelper.WriteNode("mustchoose", "0000000000000000000000000000000000000000000000000");
            }
            char[] chrArray = mustchoosenode.ToCharArray();
            RecordsCustomerBaseInfoBLL CustomerBaseBll     = new RecordsCustomerBaseInfoBLL();
            RecordsGeneralConditionBLL GeneralConditionBll = new RecordsGeneralConditionBLL();
            RecordsLifeStyleBLL        LifeStyleBll        = new RecordsLifeStyleBLL();
            RecordsPhysicalExamBLL     PhysicalExamBll     = new RecordsPhysicalExamBLL();
            RecordsAssistCheckBLL      AssistCheckBll      = new RecordsAssistCheckBLL();
            RecordsVisceraFunctionBLL  VisceraFunctionBll  = new RecordsVisceraFunctionBLL();
            RecordsHealthQuestionBLL   HealthQuestionBll   = new RecordsHealthQuestionBLL();
            RecordsAssessmentGuideBLL  AssessmentGuideBll  = new RecordsAssessmentGuideBLL();

            foreach (DataRow row in ds.Tables[0].Rows)
            {
                string str = "";
                row["Sex"] = !(row["Sex"].ToString() == "1") ? "女" : "男";
                DataTable CustomerBaseInfoDt = CustomerBaseBll.GetList(string.Format("IDCardNo = '{0}'", row["IDCardNo"])).Tables[0];
                DataTable GeneralConditionDt = GeneralConditionBll.GetList(string.Format("IDCardNo = '{0}'", row["IDCardNo"])).Tables[0];
                if (CustomerBaseInfoDt.Rows.Count > 0 || GeneralConditionDt.Rows.Count > 0)
                {
                    str = str + "一般状况:";
                    if (CustomerBaseInfoDt.Rows.Count > 0)
                    {
                        DataRow CustomerBaseInforow = CustomerBaseInfoDt.Rows[0];
                        if (chrArray[0] == '1' && string.IsNullOrEmpty(CustomerBaseInforow["Symptom"].ToString()))
                        {
                            str = str + "症状、";
                        }
                    }
                    if (GeneralConditionDt.Rows.Count > 0)
                    {
                        DataRow GeneralConditionrow = GeneralConditionDt.Rows[0];
                        if (chrArray[1] == '1' && string.IsNullOrEmpty(GeneralConditionrow["AnimalHeat"].ToString()))
                        {
                            str = str + "体温、";
                        }
                        if (chrArray[2] == '1' && string.IsNullOrEmpty(GeneralConditionrow["BreathRate"].ToString()))
                        {
                            str = str + "呼吸频率、";
                        }
                        if (chrArray[3] == '1' && string.IsNullOrEmpty(GeneralConditionrow["Waistline"].ToString()))
                        {
                            str = str + "腰围、";
                        }
                        if (chrArray[4] == '1' && string.IsNullOrEmpty(GeneralConditionrow["Height"].ToString()))
                        {
                            str = str + "身高、";
                        }
                        if (chrArray[5] == '1' && string.IsNullOrEmpty(GeneralConditionrow["PulseRate"].ToString()))
                        {
                            str = str + "脉率、";
                        }
                        if (chrArray[6] == '1' && string.IsNullOrEmpty(GeneralConditionrow["Weight"].ToString()))
                        {
                            str = str + "体重、";
                        }
                        if (chrArray[7] == '1' && string.IsNullOrEmpty(GeneralConditionrow["BMI"].ToString()))
                        {
                            str = str + "体质指数、";
                        }
                        if (chrArray[8] == '1' && string.IsNullOrEmpty(GeneralConditionrow["LeftPre"].ToString()))
                        {
                            str = str + "左侧低血压、";
                        }
                        if (chrArray[9] == '1' && string.IsNullOrEmpty(GeneralConditionrow["RightPre"].ToString()))
                        {
                            str = str + "右侧低血压、";
                        }
                        if (chrArray[10] == '1' && string.IsNullOrEmpty(GeneralConditionrow["LeftHeight"].ToString()))
                        {
                            str = str + "左侧高血压、";
                        }
                        if (chrArray[11] == '1' && string.IsNullOrEmpty(GeneralConditionrow["RightHeight"].ToString()))
                        {
                            str = str + "右侧高血压、";
                        }

                        if (str.Length > 2)
                        {
                            if (str == "一般状况:")
                            {
                                str = "";
                            }
                            else
                            {
                                str = str.Substring(0, str.Length - 1) + ",";
                            }
                        }
                    }
                }

                string    strlife     = "";
                DataTable LifeStyleDt = LifeStyleBll.GetList(string.Format("IDCardNo = '{0}'", row["IDCardNo"])).Tables[0];
                if (LifeStyleDt.Rows.Count > 0)
                {
                    strlife = strlife + "生活方式:";
                    DataRow LifeStylerow = LifeStyleDt.Rows[0];
                    if (chrArray[12] == '1' && string.IsNullOrEmpty(LifeStylerow["DietaryHabit"].ToString()))
                    {
                        strlife = strlife + "饮食习惯、";
                    }
                    if (chrArray[13] == '1' && string.IsNullOrEmpty(LifeStylerow["CareerHarmFactorHistory"].ToString()))
                    {
                        strlife = strlife + "职业病危害因素接触史、";
                    }
                }
                if (strlife.Length > 2)
                {
                    if (strlife == "生活方式:")
                    {
                        strlife = "";
                    }
                    else
                    {
                        str = str + strlife.Substring(0, strlife.Length - 1) + ",";
                    }
                }

                string    strphysicalexam = "";
                DataTable PhysicalExamDt  = PhysicalExamBll.GetList(string.Format("IDCardNo = '{0}'", row["IDCardNo"])).Tables[0];
                if (PhysicalExamDt.Rows.Count > 0)
                {
                    strphysicalexam = strphysicalexam + "查体信息:";
                    DataRow PhysicalExamrow = PhysicalExamDt.Rows[0];
                    if (chrArray[14] == '1' && string.IsNullOrEmpty(PhysicalExamrow["Skin"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "皮肤、";
                    }
                    if (chrArray[15] == '1' && string.IsNullOrEmpty(PhysicalExamrow["Sclere"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "巩膜、";
                    }
                    if (chrArray[16] == '1' && string.IsNullOrEmpty(PhysicalExamrow["Lymph"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "淋巴结、";
                    }
                    if (chrArray[17] == '1' && string.IsNullOrEmpty(PhysicalExamrow["BarrelChest"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "桶状胸、";
                    }
                    if (chrArray[18] == '1' && string.IsNullOrEmpty(PhysicalExamrow["BreathSounds"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "呼吸音、";
                    }
                    if (chrArray[19] == '1' && string.IsNullOrEmpty(PhysicalExamrow["Rale"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "罗音、";
                    }
                    if (chrArray[20] == '1' && string.IsNullOrEmpty(PhysicalExamrow["HeartRate"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "心率、";
                    }
                    if (chrArray[21] == '1' && string.IsNullOrEmpty(PhysicalExamrow["HeartRhythm"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "心律、";
                    }
                    if (chrArray[22] == '1' && string.IsNullOrEmpty(PhysicalExamrow["Noise"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "杂音、";
                    }
                    if (chrArray[23] == '1' && string.IsNullOrEmpty(PhysicalExamrow["EnclosedMass"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "包块、";
                    }
                    if (chrArray[24] == '1' && string.IsNullOrEmpty(PhysicalExamrow["Edema"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "下肢水肿、";
                    }
                    if (chrArray[25] == '1' && string.IsNullOrEmpty(PhysicalExamrow["FootBack"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "足背动脉搏动、";
                    }
                    if (chrArray[26] == '1' && string.IsNullOrEmpty(PhysicalExamrow["Anus"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "肛门指诊、";
                    }
                    if (chrArray[27] == '1' && string.IsNullOrEmpty(PhysicalExamrow["Breast"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "乳腺、";
                    }
                    if (chrArray[28] == '1' && string.IsNullOrEmpty(PhysicalExamrow["PressPain"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "压痛、";
                    }
                    if (chrArray[29] == '1' && string.IsNullOrEmpty(PhysicalExamrow["Liver"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "肝大、";
                    }
                    if (chrArray[30] == '1' && string.IsNullOrEmpty(PhysicalExamrow["Spleen"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "脾大、";
                    }
                    if (chrArray[31] == '1' && string.IsNullOrEmpty(PhysicalExamrow["Voiced"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "移动性浊音、";
                    }
                    if (chrArray[32] == '1' && string.IsNullOrEmpty(PhysicalExamrow["EyeRound"].ToString()))
                    {
                        strphysicalexam = strphysicalexam + "眼底、";
                    }
                }
                if (strphysicalexam.Length > 2)
                {
                    if (strphysicalexam == "查体信息:")
                    {
                        strphysicalexam = "";
                    }
                    else
                    {
                        str = str + strphysicalexam.Substring(0, strphysicalexam.Length - 1) + ",";
                    }
                }

                string    strAssistCheck = "";
                DataTable AssistCheckDt  = AssistCheckBll.GetList(string.Format("IDCardNo = '{0}'", row["IDCardNo"])).Tables[0];
                if (AssistCheckDt.Rows.Count > 0)
                {
                    strAssistCheck = strAssistCheck + "辅助检查:";
                    DataRow AssistCheckrow = AssistCheckDt.Rows[0];
                    if (chrArray[33] == '1' && string.IsNullOrEmpty(AssistCheckrow["FPGL"].ToString()))
                    {
                        strAssistCheck = strAssistCheck + "空腹血糖DL、";
                    }
                }
                if (strAssistCheck.Length > 2)
                {
                    if (strAssistCheck == "辅助检查:")
                    {
                        strAssistCheck = "";
                    }
                    else
                    {
                        str = str + strAssistCheck.Substring(0, strAssistCheck.Length - 1) + ",";
                    }
                }

                string    strVisceraFunction = "";
                DataTable VisceraFunctionDt  = VisceraFunctionBll.GetList(string.Format("IDCardNo = '{0}'", row["IDCardNo"])).Tables[0];
                if (VisceraFunctionDt.Rows.Count > 0)
                {
                    strVisceraFunction = strVisceraFunction + "脏器功能:";
                    DataRow VisceraFunctionrow = VisceraFunctionDt.Rows[0];
                    if (chrArray[34] == '1' && string.IsNullOrEmpty(VisceraFunctionrow["Lips"].ToString()))
                    {
                        strAssistCheck = strAssistCheck + "口唇、";
                    }
                    if (chrArray[35] == '1' && string.IsNullOrEmpty(VisceraFunctionrow["ToothResides"].ToString()))
                    {
                        strAssistCheck = strAssistCheck + "齿列、";
                    }
                    if (chrArray[36] == '1' && string.IsNullOrEmpty(VisceraFunctionrow["Pharyngeal"].ToString()))
                    {
                        strAssistCheck = strAssistCheck + "咽部、";
                    }
                    if (chrArray[37] == '1' && string.IsNullOrEmpty(VisceraFunctionrow["Listen"].ToString()))
                    {
                        strAssistCheck = strAssistCheck + "听力、";
                    }
                    if (chrArray[38] == '1' && string.IsNullOrEmpty(VisceraFunctionrow["SportFunction"].ToString()))
                    {
                        strAssistCheck = strAssistCheck + "运动功能、";
                    }
                }
                if (strVisceraFunction.Length > 2)
                {
                    if (strVisceraFunction == "脏器功能:")
                    {
                        strVisceraFunction = "";
                    }
                    else
                    {
                        str = str + strVisceraFunction.Substring(0, strVisceraFunction.Length - 1) + ",";
                    }
                }

                string    strHealthQuestion = "";
                DataTable HealthQuestionDt  = HealthQuestionBll.GetList(string.Format("IDCardNo = '{0}'", row["IDCardNo"])).Tables[0];
                if (HealthQuestionDt.Rows.Count > 0)
                {
                    strHealthQuestion = strHealthQuestion + "健康问题:";
                    DataRow HealthQuestionrow = HealthQuestionDt.Rows[0];
                    if (chrArray[39] == '1' && string.IsNullOrEmpty(HealthQuestionrow["BrainDis"].ToString()))
                    {
                        strHealthQuestion = strHealthQuestion + "脑血管疾病、";
                    }
                    if (chrArray[40] == '1' && string.IsNullOrEmpty(HealthQuestionrow["RenalDis"].ToString()))
                    {
                        strHealthQuestion = strHealthQuestion + "肾脏疾病、";
                    }
                    if (chrArray[41] == '1' && string.IsNullOrEmpty(HealthQuestionrow["HeartDis"].ToString()))
                    {
                        strHealthQuestion = strHealthQuestion + "心脏疾病、";
                    }
                    if (chrArray[42] == '1' && string.IsNullOrEmpty(HealthQuestionrow["VesselDis"].ToString()))
                    {
                        strHealthQuestion = strHealthQuestion + "血管疾病、";
                    }
                    if (chrArray[43] == '1' && string.IsNullOrEmpty(HealthQuestionrow["EyeDis"].ToString()))
                    {
                        strHealthQuestion = strHealthQuestion + "眼部疾病、";
                    }
                    if (chrArray[44] == '1' && string.IsNullOrEmpty(HealthQuestionrow["NerveDis"].ToString()))
                    {
                        strHealthQuestion = strHealthQuestion + "神经系统疾病、";
                    }
                    if (chrArray[45] == '1' && string.IsNullOrEmpty(HealthQuestionrow["ElseDis"].ToString()))
                    {
                        strHealthQuestion = strHealthQuestion + "其他系统疾病、";
                    }
                }
                if (strHealthQuestion.Length > 2)
                {
                    if (strHealthQuestion == "健康问题:")
                    {
                        strHealthQuestion = "";
                    }
                    else
                    {
                        str = str + strHealthQuestion.Substring(0, strHealthQuestion.Length - 1) + ",";
                    }
                }

                string    strAssessmentGuide = "";
                DataTable AssessmentGuideDt  = AssessmentGuideBll.GetList(string.Format("IDCardNo = '{0}'", row["IDCardNo"])).Tables[0];
                if (AssessmentGuideDt.Rows.Count > 0)
                {
                    strAssessmentGuide = strAssessmentGuide + "健康评价:";
                    DataRow AssessmentGuiderow = AssessmentGuideDt.Rows[0];
                    if (chrArray[46] == '1' && string.IsNullOrEmpty(AssessmentGuiderow["IsNormal"].ToString()))
                    {
                        strAssessmentGuide = strAssessmentGuide + "是否正常1:体检无异常2:有异常、";
                    }
                    if (chrArray[47] == '1' && string.IsNullOrEmpty(AssessmentGuiderow["HealthGuide"].ToString()))
                    {
                        strAssessmentGuide = strAssessmentGuide + "健康指导、";
                    }
                    if (chrArray[48] == '1' && string.IsNullOrEmpty(AssessmentGuiderow["DangerControl"].ToString()))
                    {
                        strAssessmentGuide = strAssessmentGuide + "危险因素控制、";
                    }
                }
                if (strAssessmentGuide.Length > 2)
                {
                    if (strAssessmentGuide == "健康评价:")
                    {
                        strAssessmentGuide = "";
                    }
                    else
                    {
                        str = str + strAssessmentGuide.Substring(0, strAssessmentGuide.Length - 1) + ",";
                    }
                }
                if (str.Length > 0)
                {
                    str = str.Substring(0, str.Length - 1);
                }

                row["MustChoose"] = str;
            }
        }