/// <summary> /// 根据床位等级编码提取BedFeeItem信息 /// </summary> /// <param name="minFeeCode">最小费用编码</param> /// <returns>成功: 床位信息数组, 失败 null, 没有找到数据:元素为0的ArrayList</returns> public ArrayList QueryBedFeeItemByMinFeeCode(string minFeeCode) { string sql = string.Empty; //查询SQL语句 if (this.Sql.GetSql("Fee.BedFeeItem.SelectByFeeCode", ref sql) == -1) { this.Err = "没有找到索引为:Fee.BedFeeItem.SelectByFeeCode的SQL语句"; return(null); } if (this.ExecQuery(sql, minFeeCode) == -1) { return(null); } try { ArrayList bedFeeItems = new ArrayList(); //循环读取数据 while (this.Reader.Read()) { Neusoft.HISFC.Models.Fee.BedFeeItem bedFeeItem = new Neusoft.HISFC.Models.Fee.BedFeeItem(); bedFeeItem.PrimaryKey = this.Reader[0].ToString(); bedFeeItem.FeeGradeCode = this.Reader[1].ToString(); bedFeeItem.ID = this.Reader[2].ToString(); bedFeeItem.Name = this.Reader[3].ToString(); bedFeeItem.Qty = NConvert.ToDecimal(this.Reader[4].ToString()); bedFeeItem.SortID = NConvert.ToInt32(this.Reader[5].ToString()); bedFeeItem.IsBabyRelation = NConvert.ToBoolean(this.Reader[6].ToString()); bedFeeItem.IsTimeRelation = NConvert.ToBoolean(this.Reader[7].ToString()); bedFeeItem.BeginTime = NConvert.ToDateTime(this.Reader[8].ToString()); bedFeeItem.EndTime = NConvert.ToDateTime(this.Reader[9].ToString()); bedFeeItem.ValidState = (EnumValidState)NConvert.ToInt32(this.Reader[10]); bedFeeItem.ExtendFlag = this.Reader[13].ToString(); bedFeeItems.Add(bedFeeItem); } this.Reader.Close(); return(bedFeeItems); } catch (Exception e) { this.Err = e.Message; if (!this.Reader.IsClosed) { this.Reader.Close(); } return(null); } }
/// <summary> /// 更新床位信息一条记录 /// </summary> /// <param name="bedFeeItem">床位信息实体</param> /// <returns>成功 1 失败 -1 没有删除到记录 0</returns> public int UpdateBedFeeItem(Neusoft.HISFC.Models.Fee.BedFeeItem bedFeeItem) { string sql = string.Empty; //更新fin_com_bedfeegrade表的SQL语句 if (this.Sql.GetSql("Fee.BedFeeItem.UpdateBedFeeItem", ref sql) == -1) { this.Err = "没有找到索引为: Fee.BedFeeItem.UpdateBedFeeItem 的SQL语句"; return(-1); } return(this.ExecNoQuery(sql, this.GetBedFeeItemParms(bedFeeItem))); }
/// <summary> /// 通过实体获得字符参数数组 /// </summary> /// <param name="bedFeeItem">床位费实体</param> /// <returns></returns> private string[] GetBedFeeItemParms(Neusoft.HISFC.Models.Fee.BedFeeItem bedFeeItem) { string[] parms = { bedFeeItem.PrimaryKey, bedFeeItem.FeeGradeCode, bedFeeItem.ID, bedFeeItem.Name, bedFeeItem.Qty.ToString(), bedFeeItem.SortID.ToString(), NConvert.ToInt32(bedFeeItem.IsBabyRelation).ToString(), NConvert.ToInt32(bedFeeItem.IsTimeRelation).ToString(), bedFeeItem.BeginTime.ToString(), bedFeeItem.EndTime.ToString(), ((int)bedFeeItem.ValidState).ToString(), this.Operator.ID }; return(parms); }
public int Update(Neusoft.HISFC.Models.Fee.BedFeeItem info) { string strSql = ""; if (this.Sql.GetSql("Fee.BedFeeItem.UpdateBedFeeItem", ref strSql) == -1) { return(-1); } try { strSql = string.Format(strSql, info.ID, info.FeeGradeCode, info.ID, info.Name, info.Qty, info.SortID, FrameWork.Function.NConvert.ToInt32(info.IsBabyRelation), FrameWork.Function.NConvert.ToInt32(info.IsTimeRelation), info.BeginTime, info.EndTime, info.ValidState, this.Operator.ID); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(-1); } try { return(this.ExecNoQuery(strSql)); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(-1); } }
public ArrayList SelectByFeeCode(string feeCode) { string strSql = ""; if (this.Sql.GetSql("Fee.BedFeeItem.SelectByFeeCode", ref strSql) == -1) { return(null); } try { strSql = string.Format(strSql, feeCode); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(null); } try { ArrayList List = new ArrayList(); this.ExecQuery(strSql); while (this.Reader.Read()) { Neusoft.HISFC.Models.Fee.BedFeeItem obj = new Neusoft.HISFC.Models.Fee.BedFeeItem(); obj.ID = Reader[0].ToString(); obj.FeeGradeCode = Reader[1].ToString(); obj.ID = Reader[2].ToString(); obj.Name = Reader[3].ToString(); obj.Qty = FrameWork.Function.NConvert.ToDecimal(Reader[4].ToString()); obj.SortID = FrameWork.Function.NConvert.ToInt32(Reader[5].ToString()); obj.IsBabyRelation = FrameWork.Function.NConvert.ToBoolean(Reader[6].ToString()); obj.IsTimeRelation = FrameWork.Function.NConvert.ToBoolean(Reader[7].ToString()); obj.BeginTime = (DateTime)Reader[8]; obj.EndTime = (DateTime)Reader[9]; obj.ValidState = (EnumValidState)NConvert.ToInt32(Reader[10]); obj.ExtendFlag = Reader[13].ToString(); List.Add(obj); } this.Reader.Close(); return(List); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; if (!Reader.IsClosed) { Reader.Close(); } return(null); } }