public bool SaveModelToDB() { this.elderSelf.FollowUpDate = new DateTime?(this.dtpCheckdate.Value.Date); this.elderSelf.NextFollowUpDate = new DateTime?(this.dtpNextF.Value.Date); if (GlbTools.IsChanged(this.cp_elderSelf, this.elderSelf, new string[] { "VisitDate", "NextfollowupDate" })) { OlderSelfCareabilityBLL older_selfcareability = new OlderSelfCareabilityBLL(); if (older_selfcareability.Exists(this.elderSelf.ID)) { older_selfcareability.Update(this.elderSelf); } RecordsGeneralConditionBLL recordsGeneralConditionBLL = new RecordsGeneralConditionBLL(); RecordsGeneralConditionModel recordsGeneralConditionModel = recordsGeneralConditionBLL.GetModel(this.Model.IDCardNo); if (recordsGeneralConditionModel != null) { recordsGeneralConditionModel.OldSelfCareability = this.tbTotal.Text; if (this.account <= 3M) { recordsGeneralConditionModel.OldSelfCareability = "1"; } else if ((this.account >= 4M) && (this.account <= 8M)) { recordsGeneralConditionModel.OldSelfCareability = "2"; } else if ((this.account >= 9M) && (this.account <= 18M)) { recordsGeneralConditionModel.OldSelfCareability = "3"; } else if (this.account >= 19M) { recordsGeneralConditionModel.OldSelfCareability = "4"; } recordsGeneralConditionBLL.Update(recordsGeneralConditionModel); } } return(true); }
private void btndataupload_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) { int OutKey = Convert.ToInt32(row["ID"].ToString()); if (string.IsNullOrEmpty(row["IDCardNo"].ToString())) { continue; } // 基本信息 RecordsBaseInfoModel Model = new RecordsBaseInfoBLL().GetModel(row["IDCardNo"].ToString()); if (Model == null) { Model = new RecordsBaseInfoModel(); } // 一般状况 RecordsGeneralConditionModel generalConditionModel = new RecordsGeneralConditionBLL().GetModelByOutKey(OutKey); if (generalConditionModel == null) { generalConditionModel = new RecordsGeneralConditionModel(); } ChronicDiadetesVisitModel diabetesModel = new ChronicDiadetesVisitModel(); diabetesModel.IDCardNo = row["IDCardNo"].ToString(); diabetesModel.Hypertension = generalConditionModel.RightHeight; diabetesModel.Hypotension = generalConditionModel.RightPre; diabetesModel.BMI = generalConditionModel.BMI; diabetesModel.Weight = generalConditionModel.Weight; diabetesModel.Hight = generalConditionModel.Height; if (diabetesModel.BMI != null) { if (diabetesModel.BMI >= 24) { diabetesModel.TargetWeight = diabetesModel.Weight - 5; } } // 生活方式 RecordsLifeStyleModel lifeModel = new RecordsLifeStyleBLL().GetModelByOutKey(OutKey); if (lifeModel == null) { lifeModel = new RecordsLifeStyleModel(); } if (lifeModel.SmokeCondition == "3") { diabetesModel.DailySmokeNum = lifeModel.SmokeDayNum; } else { diabetesModel.DailySmokeNum = 0; } if (lifeModel.DrinkRate == "2" || lifeModel.DrinkRate == "3" || lifeModel.DrinkRate == "4") { diabetesModel.DailyDrinkNum = lifeModel.DayDrinkVolume; } else { diabetesModel.DailyDrinkNum = 0; } diabetesModel.DailySmokeNumTarget = 0; diabetesModel.DailyDrinkNumTarget = 0; diabetesModel.SportTimePerWeekTarget = 7; diabetesModel.SportPerMinuteTimeTarget = 60; // 辅助检查 RecordsAssistCheckModel AssistCheck = new RecordsAssistCheckBLL().GetModelByOutKey(OutKey); if (AssistCheck == null) { AssistCheck = new RecordsAssistCheckModel(); } diabetesModel.FPG = AssistCheck.FPGL; diabetesModel.HbAlc = AssistCheck.HBALC; new ChronicDiadetesVisitBLL().UpdateDate(diabetesModel); ChronicHypertensionVisitModel hypertensionModel = new ChronicHypertensionVisitModel(); hypertensionModel.Hypertension = generalConditionModel.RightHeight; hypertensionModel.Hypotension = generalConditionModel.RightPre; hypertensionModel.BMI = generalConditionModel.BMI; hypertensionModel.Weight = generalConditionModel.Weight; hypertensionModel.Hight = generalConditionModel.Height; if (hypertensionModel.BMI != null) { if (hypertensionModel.BMI >= 24) { hypertensionModel.WeightTarGet = hypertensionModel.Weight - 5; } } if (AssistCheck.FPGL != null) { hypertensionModel.AssistantExam = $"空腹血糖:{AssistCheck.FPGL}mmol/L"; } // 查体 RecordsPhysicalExamModel physicalModel = new RecordsPhysicalExamBLL().GetModelByOutKey(OutKey); if (physicalModel == null) { physicalModel = new RecordsPhysicalExamModel(); } decimal dd = 0; if (!string.IsNullOrEmpty(physicalModel.HeartRate)) { if (decimal.TryParse(physicalModel.HeartRate, out dd)) { hypertensionModel.HeartRate = dd; } } if (lifeModel.SmokeCondition == "3") { hypertensionModel.DailySmokeNum = lifeModel.SmokeDayNum; } else { hypertensionModel.DailySmokeNum = 0; } if (lifeModel.DrinkRate == "2" || lifeModel.DrinkRate == "3" || lifeModel.DrinkRate == "4") { hypertensionModel.DailyDrinkNum = lifeModel.DayDrinkVolume; } else { hypertensionModel.DailyDrinkNum = 0; } hypertensionModel.DailySmokeNumTarget = 0; hypertensionModel.DailyDrinkNumTarget = 0; hypertensionModel.SportTimeSperWeekTarget = 7; hypertensionModel.SportPerMinutesTimeTarget = 60; hypertensionModel.IDCardNo = row["IDCardNo"].ToString(); new ChronicHypertensionVisitBLL().UpdateDate(hypertensionModel); 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; } }
private void dgvData_CellContentClick(object sender, DataGridViewCellEventArgs e) { if ((this.bds.Position >= 0) && (e.RowIndex >= 0)) { DataRowView view = (DataRowView)this.bds.List[this.bds.Position]; if (((this.dgvData.Columns[e.ColumnIndex].HeaderText == "修改") && (this.bds.Position >= 0)) && (e.RowIndex >= 0)) { PhysicalInfoFactory.ID = int.Parse(view.Row["ID"].ToString()); PhysicalInfoFactory.NewAdd = false; using (PEControler controler = new PEControler(new PhysicalForm(view.Row["IDCardNo"].ToString()), new PhysicalInfoFactory())) { controler.IParentFrm.IShowDialog(); CheckData(); } GC.Collect(); } else if (((this.dgvData.Columns[e.ColumnIndex].HeaderText == "删除") && (this.bds.Position >= 0)) && (e.RowIndex >= 0)) { if (view != null) { DataRow row = view.Row; if (MessageBox.Show("确定删除:" + row["CustomerName"].ToString() + "?删除之后的信息将无法恢复!", "删除", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { int BaseID = Convert.ToInt32(row["ID"].ToString()); RecordsGeneralConditionModel GerneralCondition = new RecordsGeneralConditionBLL().GetModelByOutKey(BaseID); if (GerneralCondition != null) { RecordsSelfcareabilityBLL RecordsSelfcareabilityBLL = new RecordsSelfcareabilityBLL(); RecordsSelfcareabilityBLL.Delete(GerneralCondition.SelfID); } RecordsMediPhysDistModel MediPhys = new RecordsMediPhysDistBLL().GetModelByOutKey(BaseID); if (MediPhys != null) { RecordsMedicineCnBLL MedicineCnBLL = new RecordsMedicineCnBLL(); RecordsMedicineResultBLL MedicineResultBLL = new RecordsMedicineResultBLL(); MedicineCnBLL.Delete(MediPhys.MedicineID); MedicineResultBLL.Delete(MediPhys.MedicineResultID); } RecordsSignatureModel Signature = new RecordsSignatureBLL().GetModelByOutKey(BaseID, row["IDCardNo"].ToString()); if (Signature != null) { if (Signature.FeedbackDate.HasValue) { string strfbDate = Convert.ToDateTime(Signature.FeedbackDate).ToString("yyyyMMdd"); string strSign1_Self = String.Format("{0}{1}_{2}_B.png", SignPath, Signature.IDCardNo, strfbDate); if (File.Exists(strSign1_Self)) //如果存在则删除图片 { File.Delete(strSign1_Self); } string strSign1_Js = String.Format("{0}{1}_{2}_J.png", SignPath, Signature.IDCardNo, strfbDate); if (File.Exists(strSign1_Js)) //如果存在则删除图片 { File.Delete(strSign1_Js); } string strSign1_Fkr = String.Format("{0}{1}_{2}_F.png", SignPath, Signature.IDCardNo, strfbDate); if (File.Exists(strSign1_Fkr)) //如果存在则删除图片 { File.Delete(strSign1_Fkr); } string strSign1_Ys = String.Format("{0}{1}_{2}_Doc.png", SignPath, Signature.IDCardNo, strfbDate); if (File.Exists(strSign1_Ys)) //如果存在则删除图片 { File.Delete(strSign1_Ys); } } } new RecordsCustomerBaseInfoBLL().Delete(BaseID); row.Delete(); row.Table.AcceptChanges(); CheckData(); } } } } }
private DataTable TransDs(DataSet ds) { DataTable dt = new DataTable(); dt.Columns.Add("CustomerName"); dt.Columns.Add("Sex"); dt.Columns.Add("IDCardNo"); dt.Columns.Add("oldercount"); dt.Columns.Add("SelfCount"); dt.Columns.Add("Nation"); dt.Columns.Add("Birthday"); dt.Columns.Add("Phone"); dt.Columns.Add("CreateDate"); dt.Columns.Add("LastUpdateDate"); dt.Columns.Add("PID"); dt.Columns.Add("SID"); foreach (DataRow row in ds.Tables[0].Rows) { string data = ""; if (!string.IsNullOrEmpty(row["CheckDate"].ToString())) { data = row["CheckDate"].ToString().Substring(0, 4); } int oldercount = 0; row["Sex"] = !(row["Sex"].ToString() == "1") ? "女" : "男"; string selfID = ""; DataTable olderdt = new OlderSelfCareabilityBLL().GetList(string.Format("IDCardNo = '{0}'and Left(FollowUpDate,4)='{1}'", row["IDCardNo"], data)).Tables[0]; if (olderdt.Rows.Count == 0) { oldercount++; //foreach (DataRow item in requiredt.Rows) //{ // if (item["Isrequired"].ToString() == "1") // { // oldercount++; // } //} } //else //{ // DataRow rows = olderdt.Rows[0]; //selfID = olderdt.Rows[0]["ID"].ToString(); // foreach (DataRow item in requiredt.Rows) // { // if (item["Isrequired"].ToString() == "1") // { // switch (item["ChinName"].ToString()) // { // case "进餐": // if (string.IsNullOrEmpty(rows["Dine"].ToString())) // { // oldercount++; // } // break; // case "梳洗": // if (string.IsNullOrEmpty(rows["Groming"].ToString())) // { // oldercount++; // } // break; // case "穿衣": // if (string.IsNullOrEmpty(rows["Dressing"].ToString())) // { // oldercount++; // } // break; // case "如厕": // if (string.IsNullOrEmpty(rows["Tolet"].ToString())) // { // oldercount++; // } // break; // case "活动": // if (string.IsNullOrEmpty(rows["Activity"].ToString())) // { // oldercount++; // } // break; // case "随访医生": // if (string.IsNullOrEmpty(rows["FollowUpDoctor"].ToString())) // { // oldercount++; // } // break; // case "总得分": // if (string.IsNullOrEmpty(rows["TotalScore"].ToString())) // { // oldercount++; // } // break; // case "随访日期": // if (string.IsNullOrEmpty(rows["FollowUpDate"].ToString())) // { // oldercount++; // } // break; // case "下次随访日期": // if (string.IsNullOrEmpty(rows["NextfollowUpDate"].ToString())) // { // oldercount++; // } // break; // case "下次随访目标": // if (string.IsNullOrEmpty(rows["NextVisitAim"].ToString())) // { // oldercount++; // } // break; // default: break; // } // } // } //} int OutKey = 0; int SelfCount = 0; if (row["PID"].ToString() != "" && row["PID"].ToString() != "0") { OutKey = int.Parse(row["PID"].ToString()); } RecordsGeneralConditionModel GenerModel = new RecordsGeneralConditionBLL().GetModelByOutKey(OutKey); if (GenerModel != null) { if (GenerModel.SelfID == 0) { SelfCount++; } } if (!(oldercount == 0) || SelfCount != 0) { DataRow dr = dt.NewRow(); dr["CustomerName"] = row["CustomerName"].ToString().Trim(); dr["Sex"] = row["Sex"].ToString().Trim(); dr["IDCardNo"] = row["IDCardNo"].ToString().Trim(); dr["oldercount"] = Convert.ToString(oldercount); dr["SelfCount"] = Convert.ToString(SelfCount); dr["Nation"] = !(row["Nation"].ToString() == "1") ? row["MINORITY"] : "汉"; if (!string.IsNullOrEmpty(row["Birthday"].ToString())) { dr["Birthday"] = DateTime.Parse(row["Birthday"].ToString()).ToString("yyyy-MM-dd"); } dr["Phone"] = row["Phone"].ToString().Trim(); if (!string.IsNullOrEmpty(row["CreateDate"].ToString())) { dr["CreateDate"] = DateTime.Parse(row["CreateDate"].ToString()).ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(row["LastUpdateDate"].ToString())) { dr["LastUpdateDate"] = DateTime.Parse(row["LastUpdateDate"].ToString()).ToShortDateString(); } dr["PID"] = row["PID"].ToString().Trim(); dr["SID"] = selfID; dt.Rows.Add(dr); } } return(dt); }