/// <summary> /// 向肿瘤明细表中插入一条数据 /// </summary> /// <param name="info"></param> /// <returns>出现异常返回-1 成功返回1 插入失败返回 0</returns> public int InsertTumourDetail(Neusoft.HISFC.Models.HealthRecord.TumourDetail info) { string strSql = ""; if (this.Sql.GetSql("Case.Tumour.InsertTumourDetail", ref strSql) == -1) { return(-1); } try { info.OperInfo.ID = this.Operator.ID; //获取索引值 info.HappenNO = Neusoft.FrameWork.Function.NConvert.ToInt32(this.GetSequence("Case.Tumour.GetSequence")); object[] mm = GetInfo(info); if (mm == null) { this.Err = "业务层从实体中获取字符数组出错"; return(-1); } strSql = string.Format(strSql, mm); } catch (Exception ee) { this.Err = ee.Message; return(-1); } return(this.ExecNoQuery(strSql)); }
/// <summary> /// 更新肿瘤明细表中得数据 /// </summary> /// <param name="info"></param> /// <returns>出现异常返回-1 成功返回1更新失败返回 0 </returns> public int UpdateTumourDetail(Neusoft.HISFC.Models.HealthRecord.TumourDetail info) { string strSql = ""; if (this.Sql.GetSql("Case.Tumour.UpdateTumourDetail", ref strSql) == -1) { return(-1); } try { info.OperInfo.ID = this.Operator.ID; object[] mm = GetInfo(info); if (mm == null) { this.Err = "业务层从实体中获取字符数组出错"; return(-1); } strSql = string.Format(strSql, mm); } catch (Exception ee) { this.Err = ee.Message; return(-1); } return(this.ExecNoQuery(strSql)); }
public ArrayList GetTumourDetail(string inpatienNo) { ArrayList List = null; string strSql = ""; if (this.Sql.GetSql("Case.Tumour.GetTumourDetail", ref strSql) == -1) { return(null); } try { strSql = string.Format(strSql, inpatienNo); //查询 this.ExecQuery(strSql); Neusoft.HISFC.Models.HealthRecord.TumourDetail info = null; List = new ArrayList(); while (this.Reader.Read()) { info = new Neusoft.HISFC.Models.HealthRecord.TumourDetail(); info.InpatientNO = Reader[0].ToString(); info.HappenNO = Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[1].ToString()); info.CureDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[2].ToString()); info.DrugInfo.ID = Reader[3].ToString(); info.DrugInfo.Name = Reader[4].ToString(); info.Qty = Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[5].ToString()); info.Unit = Reader[6].ToString(); info.Period = Reader[7].ToString(); info.Result = Reader[8].ToString(); info.OperInfo.ID = Reader[9].ToString(); List.Add(info); info = null; } this.Reader.Close(); } catch (Exception ee) { this.Err = ee.Message; if (!this.Reader.IsClosed) { this.Reader.Close(); } List = null; } return(List); }
/// <summary> /// 删除一条数据 /// </summary> /// <param name="info"></param> /// <returns></returns> public int DeleteTumourDetail(Neusoft.HISFC.Models.HealthRecord.TumourDetail info) { string strSql = ""; if (this.Sql.GetSql("Case.Tumour.DeleteTumourDetail", ref strSql) == -1) { return(-1); } try { //格式化字符串 strSql = string.Format(strSql, info.InpatientNO, info.HappenNO); } catch (Exception ee) { this.Err = ee.Message; return(-1); } return(this.ExecNoQuery(strSql)); }
private object[] GetInfo(Neusoft.HISFC.Models.HealthRecord.TumourDetail info) { try { object[] s = new object[10]; s[0] = info.InpatientNO; //住院流水号 s[1] = info.HappenNO; //发生序号 s[2] = info.CureDate.ToString(); //治疗日期 s[3] = info.DrugInfo.ID; //药物代码 s[4] = info.DrugInfo.Name; //药物名称 s[5] = info.Qty.ToString(); //剂量 s[6] = info.Unit; //单位 s[7] = info.Period; //疗程 s[8] = info.Result; // 疗效 s[9] = info.OperInfo.ID; // 操作员代号 return(s); } catch (Exception ex) { this.Err = ex.Message; return(null); } }