/// <summary> /// 插入随访安排记录 /// </summary> public int Insert(Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange visitArrange) { string strSQL = this.GetStrSql("HealthReacord.Visit.VisitArrange.Insert"); try { string[] strParm = this.GetParam(visitArrange); strSQL = string.Format(strSQL, strParm); } catch (Exception ex) { this.Err = "赋值时候出错!" + ex.Message; return(-1); } // 执行SQL并返回 return(this.ExecNoQuery(strSQL)); }
/// <summary> /// 根据实体获取sql参数 /// </summary> /// <param name="visitArrange"></param> /// <returns></returns> private string[] GetParam(Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange visitArrange) { string[] strParm = new string[12]; strParm[0] = visitArrange.CardNO; strParm[1] = visitArrange.PatientName; strParm[2] = visitArrange.LastDate.ToString(); strParm[3] = visitArrange.VisitTimes.ToString(); strParm[4] = visitArrange.State; strParm[5] = visitArrange.VisitOper.ID; strParm[6] = visitArrange.VisitOper.OperTime.ToString(); strParm[7] = visitArrange.Oper.ID; strParm[8] = visitArrange.Oper.OperTime.ToString(); strParm[9] = visitArrange.User01; strParm[10] = visitArrange.User02; strParm[11] = visitArrange.User03; //返回数组 return(strParm); }
/// <summary> /// 根据查询得到随访安排泛型 /// </summary> /// <param name="strSql"></param> /// <param name="dtBegin"></param> /// <param name="endTime"></param> /// <returns></returns> private List <Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange> GetVisitArrange(string strSql, params object[] args) { try { strSql = string.Format(strSql, args); this.ExecQuery(strSql); List <Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange> list = new List <Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange>(); while (this.Reader.Read()) { Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange va = new Neusoft.HISFC.Models.HealthRecord.Visit.VisitArrange(); va.CardNO = this.Reader[0].ToString(); va.PatientName = this.Reader[1].ToString(); va.LastDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[2].ToString()); va.VisitTimes = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[3].ToString()); va.State = this.Reader[4].ToString(); va.VisitOper.ID = this.Reader[5].ToString(); va.VisitOper.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[6].ToString()); va.Oper.ID = this.Reader[7].ToString(); va.Oper.OperTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.Reader[8].ToString()); va.User01 = this.Reader[9].ToString(); va.User02 = this.Reader[10].ToString(); va.User03 = this.Reader[11].ToString(); list.Add(va); } return(list); } catch (Exception ex) { this.Err = "执行sql语句失败!" + ex.Message; return(null); } finally { this.Reader.Close(); } }