/// <summary>
/// 获取积分投注开奖公告
/// </summary>
/// <param name="flowId">流水号</param>
/// <returns>积分投注开奖公告对象</returns>
public virtual TBPNumNotice Get(string flowId)
{
TBPNumNotice tbPNumNotice = null;
try
{
string strSQL = "select * from TBPNumNotice where flowId=@flowId";
Param param = new Param();
param.Clear();
param.Add("@flowId", flowId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbPNumNotice = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbPNumNotice);
}
/// <summary>
/// 加载指定积分投注开奖公告
/// </summary>
/// <param name="flowId">流水号</param>
public void Load(string flowId)
{
try
{
TBPNumNotice tbPNumNotice = tbPNumNoticeDAO.Get(flowId);
WebJson.ToJson(context, tbPNumNotice);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 读取积分投注开奖公告信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>积分投注开奖公告对象</returns>
protected virtual TBPNumNotice ReadData(ComDataReader dr)
{
TBPNumNotice tbPNumNotice = new TBPNumNotice();
tbPNumNotice.flowId = dr["flowId"].ToString(); //流水号
tbPNumNotice.gameId = dr["gameId"].ToString(); //游戏编号
tbPNumNotice.period = dr["period"].ToString(); //期次
tbPNumNotice.startTime = dr["startTime"].ToString(); //开售时间
tbPNumNotice.endTime = dr["endTime"].ToString(); //截止时间
tbPNumNotice.publishTime = dr["publishTime"].ToString(); //开奖时间
tbPNumNotice.numbers = dr["numbers"].ToString(); //开奖号码
return(tbPNumNotice);
}
/// <summary>
/// 增加积分投注开奖公告
/// </summary>
/// <param name="tbPNumNotice">积分投注开奖公告</param>
public void Add(TBPNumNotice tbPNumNotice)
{
try
{
tbPNumNoticeDAO.Add(tbPNumNotice);
Message.success(context, "积分投注开奖公告增加成功");
loginSession.Log("XXXXXX积分投注开奖公告增加成功");
}
catch (Exception e)
{
Message.error(context, "积分投注开奖公告增加失败");
loginSession.Log(e.Message);
}
}
/// <summary>
/// 修改积分投注开奖公告
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbPNumNotice">积分投注开奖公告</param>
public virtual void Edit(DataAccess data, TBPNumNotice tbPNumNotice)
{
string strSQL = "update TBPNumNotice set gameId=@gameId,period=@period,startTime=@startTime,endTime=@endTime,publishTime=@publishTime,numbers=@numbers where flowId=@flowId";
Param param = new Param();
param.Clear();
param.Add("@gameId", tbPNumNotice.gameId); //游戏编号
param.Add("@period", tbPNumNotice.period); //期次
param.Add("@startTime", tbPNumNotice.startTime); //开售时间
param.Add("@endTime", tbPNumNotice.endTime); //截止时间
param.Add("@publishTime", tbPNumNotice.publishTime); //开奖时间
param.Add("@numbers", tbPNumNotice.numbers); //开奖号码
param.Add("@flowId", tbPNumNotice.flowId); //流水号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
protected DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加积分投注开奖公告
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="tbPNumNotice">积分投注开奖公告</param>
public virtual void Add(DataAccess data, TBPNumNotice tbPNumNotice)
{
string strSQL = "insert into TBPNumNotice (flowId,gameId,period,startTime,endTime,publishTime,numbers) values (@flowId,@gameId,@period,@startTime,@endTime,@publishTime,@numbers)";
Param param = new Param();
param.Clear();
param.Add("@flowId", tbPNumNotice.flowId); //流水号
param.Add("@gameId", tbPNumNotice.gameId); //游戏编号
param.Add("@period", tbPNumNotice.period); //期次
param.Add("@startTime", tbPNumNotice.startTime); //开售时间
param.Add("@endTime", tbPNumNotice.endTime); //截止时间
param.Add("@publishTime", tbPNumNotice.publishTime); //开奖时间
param.Add("@numbers", tbPNumNotice.numbers); //开奖号码
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改积分投注开奖公告
/// </summary>
/// <param name="tbPNumNotice">积分投注开奖公告</param>
public virtual void Edit(TBPNumNotice tbPNumNotice)
{
try
{
db.Open();
Edit(db, tbPNumNotice);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}