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