/// <summary> /// 插入一条联系方式记录 /// </summary> /// <param name="linkway">联系方式类</param> /// <returns>影响的行数、-1 失败</returns> public int Insert(Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay linkway) { string strSQL = ""; //读取SQL语句 if (this.Sql.GetSql("HealthReacord.Visit.LinkWay.Insert", ref strSQL) == -1) { this.Err = "没有找到HealthReacord.Visit.LinkWay.Insert字段!"; return(-1); } try { //取联系方式流水号 linkway.ID = this.GetSequence("HealthReacord.Visit.LinkWay.GetLinkWayID"); if (linkway.ID == null) { return(-1); } //获取传递参数 string[] strParm = this.GetLinkWayParmItem(linkway); strSQL = string.Format(strSQL, strParm); } catch (Exception ex) { this.Err = "赋值时出错!" + ex.Message; return(-1); } //执行SQL语句返回 return(this.ExecNoQuery(strSQL)); }
/// <summary> /// 根据住院号或病历号查询患者联系人列表 /// </summary> /// <param name="patientNo">住院号</param> /// <param name="cardNo">病历号</param> private void GetLinkWay(string patientNo, string cardNo) { fpLinkWay_Sheet1.RowCount = 0; ArrayList list = new ArrayList(); list = linkWayManager.QueryLinkWay(patientNo, cardNo); if (list == null) { return; } fpLinkWay_Sheet1.Rows.Count = list.Count; for (int i = 0; i < list.Count; i++) { Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay linkWayObj = list[i] as Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay; if (linkWayObj != null) { this.fpLinkWay_Sheet1.Cells[i, 0].Text = linkWayObj.Name; //联系人 this.fpLinkWay_Sheet1.Cells[i, 1].Text = linkWayObj.Memo; //与患者关系 this.fpLinkWay_Sheet1.Cells[i, 2].Text = linkWayObj.Phone; //联系电话 this.fpLinkWay_Sheet1.Cells[i, 3].Text = linkWayObj.User01; //电话状态 this.fpLinkWay_Sheet1.Cells[i, 4].Text = linkWayObj.Address; //联系地址 this.fpLinkWay_Sheet1.Cells[i, 5].Text = linkWayObj.Mail; //电子邮件 this.fpLinkWay_Sheet1.Rows[i].Tag = linkWayObj; } } }
/// <summary> /// 获取Insert的参数 /// </summary> /// <param name="linkway">联系方式实体类</param> /// <returns>返回参数数组</returns> private string[] GetLinkWayParmItem(Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay linkway) { string[] strParm = new string[17]; strParm[0] = linkway.ID; if (linkway.IsLinkMan) { strParm[1] = "1"; } else { strParm[1] = "0"; } strParm[2] = linkway.LinkMan.Name; strParm[3] = linkway.LinkWayType.ID; strParm[4] = linkway.Relation.ID; strParm[5] = linkway.Patient.PID.CardNO; strParm[6] = linkway.ZIP; strParm[7] = linkway.OperEnvi.ID; strParm[8] = linkway.OperEnvi.OperTime.ToString(); strParm[9] = linkway.Address; strParm[10] = linkway.Mail; strParm[11] = linkway.Phone; strParm[12] = linkway.OtherLinkway; strParm[13] = linkway.Memo; strParm[14] = linkway.User01; strParm[15] = linkway.User02; strParm[16] = linkway.User03; //返回数组 return(strParm); }
/// <summary> /// 执行SQL语句,读取linkWay实体信息到ArrayList中 /// </summary> /// <param name="strSQL">需要执行的SQL语句</param> /// <returns>返回数组、错误返回null</returns> private ArrayList ReadLinkWayInfo(string strSQL) { this.ExecQuery(strSQL); ArrayList list = new ArrayList(); Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay linkWay = null; try { while (this.Reader.Read()) { linkWay = new Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay(); linkWay.ID = this.Reader[0].ToString(); if (this.Reader[1].ToString().Equals("1")) { linkWay.IsLinkMan = true; } else { linkWay.IsLinkMan = false; } linkWay.LinkMan.Name = this.Reader[2].ToString(); linkWay.LinkWayType.ID = this.Reader[3].ToString(); linkWay.Relation.ID = this.Reader[4].ToString(); linkWay.Patient.PID.CardNO = this.Reader[5].ToString(); linkWay.ZIP = this.Reader[6].ToString(); linkWay.OperEnvi.ID = this.Reader[7].ToString(); linkWay.OperEnvi.OperTime = NConvert.ToDateTime(this.Reader[8].ToString()); linkWay.Address = this.Reader[9].ToString(); linkWay.Mail = this.Reader[10].ToString(); linkWay.Phone = this.Reader[11].ToString(); linkWay.OtherLinkway = this.Reader[12].ToString(); linkWay.Memo = this.Reader[13].ToString(); linkWay.User01 = this.Reader[14].ToString(); linkWay.User02 = this.Reader[15].ToString(); linkWay.User03 = this.Reader[16].ToString(); linkWay.LinkWayType.Name = this.Reader[17].ToString(); linkWay.Relation.Name = this.Reader[18].ToString(); linkWay.OperEnvi.Name = this.Reader[19].ToString(); list.Add(linkWay); } } catch (Exception ex) { this.Err = "读取联系方式出错!" + ex.Message; return(null); } finally { this.Reader.Close(); } //返回数组 return(list); }
/// <summary> /// 插入一条联系方式记录 /// </summary> /// <param name="linkway">联系方式实体类</param> /// <returns>影响的行数、-1 失败</returns> public int InsertLinkWay(Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay linkway) { this.SetDB(linkWayManager); int intReturn = linkWayManager.Insert(linkway); if (intReturn < 0) { this.Err = linkWayManager.Err; return(-1); } return(intReturn); }
/// <summary> /// 获取SQL语句参数 /// </summary> /// <param name="linkWayObj">联系方式实体类</param> /// <returns>返回参数数组</returns> private string[] GetLinkWayParm(Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay linkWayObj) { return(new string[] { linkWayObj.ID, //唯一编号 linkWayObj.Patient.PID.PatientNO, //住院号 linkWayObj.Patient.PID.CardNO, //病历号 linkWayObj.Name, //联系人 linkWayObj.Memo, //与患者关系 linkWayObj.Address, //地址 linkWayObj.Mail, //电子邮箱 linkWayObj.Phone, //联系电话 linkWayObj.User01, //电话状态 this.Operator.ID, //操作员 this.GetSysDateTime() //操作时间 }); }
/// <summary> /// 删除联系人 /// </summary> /// <param name="linkWayObj">联系方式实体类</param> /// <returns>失败返回-1</returns> public int DelLinkWay(Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay linkWayObj) { //获取主sql语句 string strSQL = string.Empty; if (this.Sql.GetSql("HealthReacord.Visit.LinkWay.DeleteLinkWay", ref strSQL) == -1) { this.Err = "获取SQL语句:HealthReacord.Visit.LinkWay.DeleteLinkWay 失败"; return(-1); } strSQL = string.Format(strSQL, linkWayObj.ID); return(this.ExecNoQuery(strSQL)); }
/// <summary> /// 更新联系人 /// </summary> /// <param name="linkWayObj">联系方式实体类</param> /// <returns>失败返回-1</returns> public int UpdateInsertLinkWay(Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay linkWayObj) { //获取主sql语句 string strSQL = string.Empty; if (this.Sql.GetSql("HealthReacord.Visit.LinkWay.UpdateLinkWay", ref strSQL) == -1) { this.Err = "获取SQL语句:HealthReacord.Visit.LinkWay.UpdateLinkWay 失败"; return(-1); } //获取传递参数 string[] strParm = GetLinkWayParm(linkWayObj); strSQL = string.Format(strSQL, strParm); return(this.ExecNoQuery(strSQL)); }
/// <summary> /// 根据SQL语句,查询患者联系人列表 /// </summary> /// <param name="strSql"></param> /// <returns></returns> private ArrayList QueryLinkWayBySql(string strSql) { this.ExecQuery(strSql); ArrayList list = new ArrayList(); Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay linkWay = null; try { while (this.Reader.Read()) { linkWay = new Neusoft.HISFC.Models.HealthRecord.Visit.LinkWay(); linkWay.ID = this.Reader[0].ToString(); //唯一编号 linkWay.Name = this.Reader[1].ToString(); //联系人 linkWay.Memo = this.Reader[2].ToString(); //与患者关系 linkWay.Phone = this.Reader[3].ToString(); //联系电话 linkWay.User01 = this.Reader[4].ToString(); //电话状态 linkWay.Address = this.Reader[5].ToString(); //联系地址 linkWay.Mail = this.Reader[6].ToString(); //Email list.Add(linkWay); } } catch (Exception ex) { this.Err = "读取联系方式出错!" + ex.Message; return(null); } finally { this.Reader.Close(); } return(list); }