/// <summary> /// 向随访明细表中插入一条新记录 /// </summary> /// <returns>影响的行数、-1 失败</returns> public int Insert(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord, string sequ) { string strSQL = ""; //读取SQL语句 if (this.Sql.GetSql("HealthReacord.Visit.VisitRecord.Insert", ref strSQL) == -1) { this.Err = "没有找到HealthReacord.Visit.VisitRecord.Insert字段!"; return(-1); } try { //获取随访明细流水号 visitRecord.ID = sequ; //获取传递参数数组 string[] strParm = this.GetVisitRecordParmItem(visitRecord); strSQL = string.Format(strSQL, strParm); } catch (Exception ex) { this.Err = "赋值时候出错!" + ex.Message; return(-1); } //执行SQL语句并返回 return(this.ExecNoQuery(strSQL)); }
/// <summary> /// 删除随访记录明细 /// </summary> /// <returns>成功返回 0;失败返回 -1</returns> private int DeleteRecord() { if (MessageBox.Show("是否作废选择的历史随访信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning) == DialogResult.Yes) { visitRecordManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); for (int i = 0; i < fpVisitRecord_Sheet1.Rows.Count; i++) { if (this.fpVisitRecord_Sheet1.Cells[i, 0].Text == true.ToString()) { Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord = fpVisitRecord_Sheet1.Rows[i].Tag as Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord;//Tag中的对象 if (visitRecord != null) { if (visitRecordManager.DelVisitRecord(visitRecord.ID) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); //t.RollBack(); MessageBox.Show("删除联系人发生错误:" + visitRecordManager.Err); return(-1); } } } } Neusoft.FrameWork.Management.PublicTrans.Commit(); #region 重新加载随访明细 if (fp_Sheet1.ActiveRowIndex > -1) { //当前选择的随访患者病历号 string cardNo = fp_Sheet1.Cells[fp_Sheet1.ActiveRowIndex, 1].Text.Trim(); if (!string.IsNullOrEmpty(cardNo)) { if (QueryVisitRecordByCardNo(cardNo) == -1) { MessageBox.Show("明细信息查询失败"); } } } #endregion } return(0); }
/// <summary> /// 新增方法,插入随访明细,并更新随访主记录 /// </summary> /// <param name="visitRecord">随访明细实体</param> /// <param name="sequ">随访记录唯一ID</param> /// <param name="visit">随访主记录实体</param> /// <returns>成功返回 0;失败返回 -1;</returns> public int InsertAndUpdateVisit(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord , string sequ, Neusoft.HISFC.Models.HealthRecord.Visit.Visit visit) { if (InsertVisitRecordInfo(visitRecord, sequ) == -1) { return(-1); } if (UpdateVisit(visit) == -1) { return(-1); } return(0); }
/// <summary> /// 更新随访记录明细 /// </summary> /// <param name="visitRecord">随访明细记录</param> /// <returns>影响的行数、-1 失败</returns> public int UpdateVisitRecord(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord) { this.SetDB(visitRecordManager); int intReturn = visitRecordManager.Update(visitRecord); if (intReturn < 0) { this.Err = visitRecordManager.Err; return(-1); } return(intReturn); }
/// <summary> /// 插入随访记录明细 /// </summary> /// <param name="visitRecord">随访明细记录</param> /// <returns>影响的行数、-1 失败</returns> public int InsertVisitRecordInfo(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord, string sequ) { this.SetDB(visitRecordManager); int intReturn = visitRecordManager.Insert(visitRecord, sequ); if (intReturn < 0) { this.Err = visitRecordManager.Err; return(-1); } return(intReturn); }
/// <summary> /// 随访信息录入 /// </summary> /// <param name="visitRecord"></param> /// <returns>影响的行数、-1 失败</returns> public int Update(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord) { string strSQL = ""; //读取SQL语句 if (this.Sql.GetSql("HealthReacord.Visit.VisitRecord.Update", ref strSQL) == -1) { this.Err = "没有找到HealthReacord.Visit.VisitRecord.Update字段!"; return(-1); } try { string[] strParm = this.GetVisitRecordParmItem(visitRecord); strSQL = string.Format(strSQL, strParm); } catch (Exception ex) { this.Err = "赋值时出错!" + ex.Message; return(-1); } //执行SQL语句并返回 return(this.ExecNoQuery(strSQL)); }
/// <summary> /// 根据SQl语句读取随访明细信息 /// </summary> /// <param name="strSQL"></param> /// <returns></returns> private ArrayList ExecQueryBySQL(string strSQL) { this.ExecQuery(strSQL); ArrayList list = new ArrayList(); Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord = null; try { while (this.Reader.Read()) { visitRecord = new Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord(); visitRecord.ID = this.Reader[0].ToString(); visitRecord.Patient.PID.CardNO = this.Reader[1].ToString(); visitRecord.Circs.ID = this.Reader[2].ToString(); visitRecord.DeadReason.ID = this.Reader[3].ToString(); visitRecord.DeadTime = NConvert.ToDateTime(this.Reader[4].ToString()); if (this.Reader[5].ToString().Equals("1")) { visitRecord.IsDead = true; } else { visitRecord.IsDead = false; } if (this.Reader[6].ToString().Equals("1")) { visitRecord.IsRecrudesce = true; } else { visitRecord.IsRecrudesce = false; } if (this.Reader[7].ToString().Equals("1")) { visitRecord.IsSequela = true; } else { visitRecord.IsSequela = false; } if (this.Reader[8].ToString().Equals("1")) { visitRecord.IsSuccess = true; } else { visitRecord.IsSuccess = false; } if (this.Reader[9].ToString().Equals("1")) { visitRecord.IsTransfer = true; } else { visitRecord.IsTransfer = false; } visitRecord.RecrudesceTime = NConvert.ToDateTime(this.Reader[10].ToString()); visitRecord.ResultOper.ID = this.Reader[11].ToString(); visitRecord.ResultOper.OperTime = NConvert.ToDateTime(this.Reader[12].ToString()); visitRecord.Sequela.ID = this.Reader[13].ToString(); visitRecord.Symptom.ID = this.Reader[14].ToString(); visitRecord.TransferPosition.ID = this.Reader[15].ToString(); visitRecord.VisitOper.ID = this.Reader[16].ToString(); visitRecord.VisitOper.OperTime = NConvert.ToDateTime(this.Reader[17].ToString()); visitRecord.VisitType.ID = this.Reader[18].ToString(); #region {E9F858A6-BDBC-4052-BA57-68755055FB80} //随访方式 visitRecord.VisitType.Name = this.Reader[44].ToString(); visitRecord.Symptom.Name = this.Reader[45].ToString(); visitRecord.VisitResult.Name = this.Reader[46].ToString(); #endregion visitRecord.WriteBackPerson = this.Reader[19].ToString(); if (this.Reader[20].ToString().Equals("1")) { visitRecord.IsPassive = true; } else { visitRecord.IsPassive = false; } if (this.Reader[21].ToString().Equals("1")) { visitRecord.LinkWay.IsLinkMan = true; } else { visitRecord.LinkWay.IsLinkMan = false; } visitRecord.LinkWay.LinkMan.Name = this.Reader[22].ToString(); visitRecord.LinkWay.LinkWayType.ID = this.Reader[23].ToString(); visitRecord.LinkWay.Relation.ID = this.Reader[24].ToString(); if (this.Reader[25].ToString().Equals("1")) { visitRecord.IsResult = true; } else { visitRecord.IsResult = false; } visitRecord.LinkWay.ZIP = this.Reader[26].ToString(); //visitRecord.ResultOper.Name = this.Reader[37].ToString(); if (this.Reader[27].ToString().Equals("1")) { visitRecord.IsWorkLoad = true; } else { visitRecord.IsWorkLoad = false; } visitRecord.LinkWay.Address = this.Reader[28].ToString(); visitRecord.LinkWay.Mail = this.Reader[29].ToString(); visitRecord.LinkWay.Phone = this.Reader[30].ToString(); visitRecord.LinkWay.OtherLinkway = this.Reader[31].ToString(); visitRecord.User01 = this.Reader[32].ToString(); visitRecord.User02 = this.Reader[33].ToString(); visitRecord.User03 = this.Reader[34].ToString(); visitRecord.Circs.Name = this.Reader[35].ToString(); visitRecord.DeadReason.Name = this.Reader[36].ToString(); visitRecord.Sequela.Name = this.Reader[37].ToString(); visitRecord.TransferPosition.Name = this.Reader[38].ToString(); visitRecord.LinkWay.LinkWayType.Name = this.Reader[39].ToString(); visitRecord.LinkWay.Relation.Name = this.Reader[40].ToString(); visitRecord.ResultOper.Name = this.Reader[41].ToString(); visitRecord.VisitOper.Name = this.Reader[42].ToString(); list.Add(visitRecord); } } catch (Exception ex) { this.Err = "读取随访明细出错!" + ex.Message; return(null); } finally { this.Reader.Close(); } //返回数组 return(list); }
/// <summary> /// 获取insert或update的参数 /// </summary> /// <param name="linkway">随访明细记录类</param> /// <returns>返回参数数组</returns> private string[] GetVisitRecordParmItem(Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord) { string[] strParm = new string[36]; strParm[0] = visitRecord.ID; strParm[1] = visitRecord.Patient.PID.CardNO; strParm[2] = visitRecord.Circs.ID; strParm[3] = visitRecord.DeadReason.ID; strParm[4] = visitRecord.DeadTime.ToString(); if (visitRecord.IsDead) { strParm[5] = "1"; } else { strParm[5] = "0"; } if (visitRecord.IsRecrudesce) { strParm[6] = "1"; } else { strParm[6] = "0"; } if (visitRecord.IsSequela) { strParm[7] = "1"; } else { strParm[7] = "0"; } if (visitRecord.IsSuccess) { strParm[8] = "1"; } else { strParm[8] = "0"; } if (visitRecord.IsTransfer) { strParm[9] = "1"; } else { strParm[9] = "0"; } strParm[10] = visitRecord.RecrudesceTime.ToString(); strParm[11] = visitRecord.ResultOper.ID; strParm[12] = visitRecord.ResultOper.OperTime.ToString(); strParm[13] = visitRecord.Sequela.ID; strParm[14] = visitRecord.Symptom.ID; strParm[15] = visitRecord.TransferPosition.ID; strParm[16] = visitRecord.VisitOper.ID; strParm[17] = visitRecord.VisitOper.OperTime.ToString(); strParm[18] = visitRecord.VisitType.ID; strParm[19] = visitRecord.WriteBackPerson; if (visitRecord.IsPassive) { strParm[20] = "1"; } else { strParm[20] = "0"; } if (visitRecord.LinkWay.IsLinkMan) { strParm[21] = "1"; } else { strParm[21] = "0"; } strParm[22] = visitRecord.LinkWay.LinkMan.Name; strParm[23] = visitRecord.LinkWay.LinkWayType.ID; strParm[24] = visitRecord.LinkWay.Relation.ID; if (visitRecord.IsResult) { strParm[25] = "1"; } else { strParm[25] = "0"; } strParm[26] = visitRecord.LinkWay.ZIP; if (visitRecord.IsWorkLoad) { strParm[27] = "1"; } else { strParm[27] = "0"; } strParm[28] = visitRecord.LinkWay.Address; strParm[29] = visitRecord.LinkWay.Mail; strParm[30] = visitRecord.LinkWay.Phone; strParm[31] = visitRecord.LinkWay.OtherLinkway; strParm[32] = visitRecord.User01; strParm[33] = visitRecord.User02; strParm[34] = visitRecord.User03; #region {E9F858A6-BDBC-4052-BA57-68755055FB80} strParm[35] = visitRecord.VisitResult.ID; #endregion //返回数组 return(strParm); }
/// <summary> /// 获取随访明细信息 /// </summary> /// <param name="cardNo">病历号</param> /// <returns>成功返回 0;失败返回 -1</returns> private int QueryVisitRecordByCardNo(string cardNo) { //随访明细列表 ArrayList list = new ArrayList(); list = visitRecordManager.QueryByCardNo(cardNo); if (list == null) { return(0); } fpVisitRecord_Sheet1.Rows.Count = list.Count; for (int i = 0; i < list.Count; i++) { Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord visitRecord = list[i] as Neusoft.HISFC.Models.HealthRecord.Visit.VisitRecord; if (visitRecord != null) { this.fpVisitRecord_Sheet1.Cells[i, 1].Text = visitRecord.VisitOper.OperTime.ToShortDateString(); //随访时间 this.fpVisitRecord_Sheet1.Cells[i, 2].Text = visitRecord.LinkWay.LinkMan.Name; //联系人 this.fpVisitRecord_Sheet1.Cells[i, 3].Text = visitRecord.VisitType.Name; //随访方式 this.fpVisitRecord_Sheet1.Cells[i, 4].Text = visitRecord.VisitResult.Name; //随访结果 this.fpVisitRecord_Sheet1.Cells[i, 5].Text = visitRecord.Circs.Name; //一般情况名称 this.fpVisitRecord_Sheet1.Cells[i, 6].Text = visitRecord.Symptom.Name; //症状表现 this.fpVisitRecord_Sheet1.Cells[i, 7].Text = visitRecord.IsDead ? "是" : "否"; //是否死亡 this.fpVisitRecord_Sheet1.Cells[i, 8].Text = visitRecord.DeadTime.ToString(); //死亡时间 this.fpVisitRecord_Sheet1.Cells[i, 9].Text = visitRecord.DeadReason.Name; //死亡原因 this.fpVisitRecord_Sheet1.Cells[i, 10].Text = visitRecord.IsRecrudesce ? "是" : "否"; //是否复发 this.fpVisitRecord_Sheet1.Cells[i, 11].Text = visitRecord.RecrudesceTime.ToString(); //复法时间 this.fpVisitRecord_Sheet1.Cells[i, 12].Text = visitRecord.IsSequela ? "是" : "否"; //是否有后遗症 this.fpVisitRecord_Sheet1.Cells[i, 13].Text = visitRecord.Sequela.Name; //后遗症 this.fpVisitRecord_Sheet1.Cells[i, 14].Text = visitRecord.IsTransfer ? "是" : "否"; //是否转移 this.fpVisitRecord_Sheet1.Cells[i, 15].Text = visitRecord.TransferPosition.Name; //后遗症 this.fpVisitRecord_Sheet1.Rows[i].Tag = visitRecord; } } return(0); }