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