/// <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();
}
}
