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