/// <summary>
/// 获取游戏类型
/// </summary>
/// <param name="gameId">游戏编号</param>
/// <returns>游戏类型对象</returns>
public virtual TBGame Get(string gameId)
{
TBGame tbGame = null;
try
{
string strSQL = "select * from TBGame where gameId=@gameId";
Param param = new Param();
param.Clear();
param.Add("@gameId", gameId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbGame = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbGame);
}
/// <summary>
/// 读取游戏类型信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>游戏类型对象</returns>
protected virtual TBGame ReadData(ComDataReader dr)
{
TBGame tbGame = new TBGame();
tbGame.gameId = dr["gameId"].ToString(); //游戏编号
tbGame.gameName = dr["gameName"].ToString(); //游戏名称
tbGame.isUse = dr["isUse"].ToString(); //使用状态
tbGame.typeCode = dr["typeCode"].ToString(); //类型分类
return(tbGame);
}
/// <summary>
/// 加载指定游戏类型
/// <param name="gameId">游戏编号</param>
/// </summary>
public void Load(string gameId)
{
try
{
TBGame tbGame = tbGameDAO.Get(gameId);
WebJson.ToJson(context, tbGame);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 修改游戏类型
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbGame">游戏类型</param>
public virtual void Edit(DataAccess data, TBGame tbGame)
{
string strSQL = "update TBGame set gameName=@gameName,isUse=@isUse,typeCode=@typeCode where gameId=@gameId";
Param param = new Param();
param.Clear();
param.Add("@gameName", tbGame.gameName); //游戏名称
param.Add("@isUse", tbGame.isUse); //使用状态
param.Add("@typeCode", tbGame.typeCode); //类型分类
param.Add("@gameId", tbGame.gameId); //游戏编号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加游戏类型
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbGame">游戏类型</param>
public virtual void Add(DataAccess data, TBGame tbGame)
{
string strSQL = "insert into TBGame (gameId,gameName,isUse,typeCode) values (@gameId,@gameName,@isUse,@typeCode)";
Param param = new Param();
param.Clear();
param.Add("@gameId", tbGame.gameId); //游戏编号
param.Add("@gameName", tbGame.gameName); //游戏名称
param.Add("@isUse", tbGame.isUse); //使用状态
param.Add("@typeCode", tbGame.typeCode); //类型分类
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 增加游戏类型
/// <param name="tbGame">游戏类型</param>
/// </summary>
public void Add(TBGame tbGame)
{
try
{
tbGameDAO.Add(tbGame);
Message.success(context, "游戏类型增加成功");
loginSession.Log("XXXXXX游戏类型增加成功");
}
catch (Exception e)
{
Message.error(context, "游戏类型增加失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 获取指定游戏信息
/// <param name="areaId">区域编号</param>
/// </summary>
public TBGame Get(string gameId)
{
TBGame tbGame = new TBGame();
try
{
tbGame = tbGameDAO.Get(gameId);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
return(tbGame);
}
/// <summary>
/// 修改游戏类型
/// </summary>
/// <param name="tbGame">游戏类型</param>
public virtual void Edit(TBGame tbGame)
{
try
{
db.Open();
Edit(db, tbGame);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
