/// <summary> /// 获取交易类型 /// </summary> /// <param name="code">代码</param> /// <returns>交易类型对象</returns> public virtual TBTradeType Get(string code) { TBTradeType tbTradeType = null; try { string strSQL = "select * from TBTradeType where code=@code"; Param param = new Param(); param.Clear(); param.Add("@code", code); db.Open(); ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param); if (dr.Read()) { tbTradeType = ReadData(dr); } dr.Close(); } catch (Exception e) { throw e; } finally { db.Close(); } return(tbTradeType); }
/// <summary> /// 读取交易类型信息 /// </summary> /// <param name="dr">记录指针</param> /// <returns>交易类型对象</returns> protected virtual TBTradeType ReadData(ComDataReader dr) { TBTradeType tbTradeType = new TBTradeType(); tbTradeType.code = dr["code"].ToString(); //代码 tbTradeType.name = dr["name"].ToString(); //名称 return(tbTradeType); }
/// <summary> /// 修改交易类型 /// </summary> /// <param name="data">数据库连接</param> /// <param name="tbTradeType">交易类型</param> public virtual void Edit(DataAccess data, TBTradeType tbTradeType) { string strSQL = "update TBTradeType set name=@name where code=@code"; Param param = new Param(); param.Clear(); param.Add("@name", tbTradeType.name); //名称 param.Add("@code", tbTradeType.code); //代码 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接 #region 代码生成器自动生成 /// <summary> /// 增加交易类型 /// </summary> /// <param name="data">数据库连接</param> /// <param name="tbTradeType">交易类型</param> public virtual void Add(DataAccess data, TBTradeType tbTradeType) { string strSQL = "insert into TBTradeType (code,name) values (@code,@name)"; Param param = new Param(); param.Clear(); param.Add("@code", tbTradeType.code); //代码 param.Add("@name", tbTradeType.name); //名称 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 修改交易类型 /// </summary> /// <param name="tbTradeType">交易类型</param> public virtual void Edit(TBTradeType tbTradeType) { try { db.Open(); Edit(db, tbTradeType); } catch (Exception e) { throw e; } finally { db.Close(); } }