/// <summary> /// 修改随访检索申请记录 /// </summary> /// <param name="visitSearches">随访检索申请实体</param> /// <returns>影响的行数、-1 失败</returns> public int Update(Neusoft.HISFC.Models.HealthRecord.Visit.VisitSearches visitSearches) { string strSQL = ""; //读取SQL语句 if (this.Sql.GetSql("HealthReacord.Visit.VisitSearches.Update", ref strSQL) == -1) { this.Err = "没有找到HealthReacord.Visit.VisitSearches.Update字段!"; return(-1); } try { //获取传递参数数组 string[] strParm = this.GetVisitSearchesParmItem(visitSearches); strSQL = string.Format(strSQL, strParm); } catch (Exception ex) { this.Err = "赋值时出错!" + ex.Message; return(-1); } //执行SQL语句并返回 return(this.ExecNoQuery(strSQL)); }
/// <summary> /// 获取insert或update的参数 /// </summary> /// <param name="linkway">随访检索申请实体</param> /// <returns>返回参数数组</returns> private string[] GetVisitSearchesParmItem(Neusoft.HISFC.Models.HealthRecord.Visit.VisitSearches visitSearcher) { string[] strParm = new string[25]; strParm[0] = visitSearcher.ID; strParm[1] = visitSearcher.DoctorOper.ID; strParm[2] = visitSearcher.Teacher.ID; strParm[3] = visitSearcher.Teacher.User01; strParm[4] = visitSearcher.SearchesContent; strParm[5] = visitSearcher.DoctorOper.OperTime.ToString(); strParm[6] = visitSearcher.BookingTime.ToString(); if (visitSearcher.IsCharge) { strParm[7] = "1"; } else { strParm[7] = "0"; } strParm[8] = visitSearcher.ChargeCost.ToString(); strParm[9] = visitSearcher.IllType.ID; strParm[10] = visitSearcher.Years.ToString(); strParm[11] = visitSearcher.Items.ID; strParm[12] = visitSearcher.Copy; strParm[13] = visitSearcher.Append; //申请状态 if (visitSearcher.SearchesState == Neusoft.HISFC.Models.HealthRecord.Visit.EnumSearchesState.Apply) { strParm[14] = "0"; } //科主任审核状态 if (visitSearcher.SearchesState == Neusoft.HISFC.Models.HealthRecord.Visit.EnumSearchesState.Auditing) { strParm[14] = "1"; } //信息科审核状态 if (visitSearcher.SearchesState == Neusoft.HISFC.Models.HealthRecord.Visit.EnumSearchesState.Notion) { strParm[14] = "2"; } //确认状态 if (visitSearcher.SearchesState == Neusoft.HISFC.Models.HealthRecord.Visit.EnumSearchesState.Searches) { strParm[14] = "3"; } strParm[15] = visitSearcher.AuditingOper.ID; strParm[16] = visitSearcher.AuditingOper.OperTime.ToString(); strParm[17] = visitSearcher.SearchesOper.ID; strParm[18] = visitSearcher.SearchesOper.OperTime.ToString(); strParm[19] = visitSearcher.NotionOper.ID; strParm[20] = visitSearcher.NotionOper.User01; strParm[21] = visitSearcher.NotionOper.OperTime.ToString(); strParm[22] = visitSearcher.User01; strParm[23] = visitSearcher.User02; strParm[24] = visitSearcher.User03; //返回数组 return(strParm); }
/// <summary> /// 修改随访检索申请记录 /// </summary> /// <param name="visitSearches">随访检索申请实体</param> /// <returns>影响的行数、-1 失败</returns> public int UpdateVisitSearches(Neusoft.HISFC.Models.HealthRecord.Visit.VisitSearches visitSearches) { this.SetDB(visitSearchesManager); int intReturn = visitSearchesManager.Update(visitSearches); if (intReturn < 0) { this.Err = visitSearchesManager.Err; return(-1); } return(intReturn); }
/// <summary> /// 向随访申请表中插入一条新的记录 /// </summary> /// <param name="visitSearches">随访检索申请实体</param> /// <returns>影响的行数、-1 失败</returns> public int Insert(Neusoft.HISFC.Models.HealthRecord.Visit.VisitSearches visitSearches) { string strSQL = ""; //读取SQL语句 if (this.Sql.GetSql("HealthReacord.Visit.VisitSearches.Insert", ref strSQL) == -1) { this.Err = "没有找到HealthReacord.Visit.VisitSearches.Insert字段!"; return(-1); } try { //获取申请流水号 visitSearches.ID = this.GetSequence("HealthReacord.Visit.VisitRecord.GetVisitSearchesID"); //获取申请流水号是否成功 if (visitSearches.ID == null) { this.Err = "获取流水号出错!"; return(-1); } //获取传递参数数组 string[] strParm = this.GetVisitSearchesParmItem(visitSearches); strSQL = string.Format(strSQL, strParm); } catch (Exception ex) { this.Err = "赋值时出错!" + ex.Message; return(-1); } //执行SQL语句并返回 return(this.ExecNoQuery(strSQL)); }
/// <summary> /// 通过执行SQL语句,将查询到的信息读到ArrayList中 /// </summary> /// <param name="strSQL">需要执行的SQL语句</param> /// <returns>返回读取到的数组、错误返回null</returns> private ArrayList ReadVisitSearchesInfo(string strSQL) { //执行SQL语句 this.ExecQuery(strSQL); ArrayList list = new ArrayList(); Neusoft.HISFC.Models.HealthRecord.Visit.VisitSearches visitSearches = null; try { while (this.Reader.Read()) { visitSearches = new Neusoft.HISFC.Models.HealthRecord.Visit.VisitSearches(); visitSearches.ID = this.Reader[0].ToString(); visitSearches.DoctorOper.ID = this.Reader[1].ToString(); visitSearches.Teacher.ID = this.Reader[2].ToString(); visitSearches.Teacher.User01 = this.Reader[3].ToString(); visitSearches.SearchesContent = this.Reader[4].ToString(); visitSearches.DoctorOper.OperTime = NConvert.ToDateTime(this.Reader[5].ToString()); visitSearches.BookingTime = NConvert.ToDateTime(this.Reader[6].ToString()); //是否收费 if (this.Reader[7].ToString() == "1") { visitSearches.IsCharge = true; } else { visitSearches.IsCharge = false; } visitSearches.ChargeCost = NConvert.ToDecimal(this.Reader[8].ToString()); visitSearches.IllType.ID = this.Reader[9].ToString(); visitSearches.Years = NConvert.ToDecimal(this.Reader[10].ToString()); visitSearches.Items.ID = this.Reader[11].ToString(); visitSearches.Copy = this.Reader[12].ToString(); visitSearches.Append = this.Reader[13].ToString(); string stat = this.Reader[14].ToString(); if (stat == "0") { //申请 visitSearches.SearchesState = Neusoft.HISFC.Models.HealthRecord.Visit.EnumSearchesState.Apply; } else { if (stat == "1") { //科主任审核 visitSearches.SearchesState = Neusoft.HISFC.Models.HealthRecord.Visit.EnumSearchesState.Auditing; } else { if (stat == "2") { //信息科长审核 visitSearches.SearchesState = Neusoft.HISFC.Models.HealthRecord.Visit.EnumSearchesState.Notion; } else { //检索确认 visitSearches.SearchesState = Neusoft.HISFC.Models.HealthRecord.Visit.EnumSearchesState.Searches; } } } visitSearches.AuditingOper.ID = this.Reader[15].ToString(); visitSearches.AuditingOper.OperTime = NConvert.ToDateTime(this.Reader[16].ToString()); visitSearches.SearchesOper.ID = this.Reader[17].ToString(); visitSearches.SearchesOper.OperTime = NConvert.ToDateTime(this.Reader[18].ToString()); visitSearches.NotionOper.ID = this.Reader[19].ToString(); visitSearches.NotionOper.User01 = this.Reader[20].ToString(); visitSearches.NotionOper.OperTime = NConvert.ToDateTime(this.Reader[21].ToString()); visitSearches.User01 = this.Reader[22].ToString(); visitSearches.User02 = this.Reader[23].ToString(); visitSearches.User03 = this.Reader[24].ToString(); //将实体添加到数组中 list.Add(visitSearches); } } catch (Exception ex) { this.Err = "读取随访检索申请内容出错!" + ex.Message; return(null); } finally { this.Reader.Close(); } //返回数组 return(list); }