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; }
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; } }