/// <summary>
/// 读取彩票奖期信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>彩票奖期对象</returns>
private TBLotteryPeriod ReadData(ComDataReader dr)
{
TBLotteryPeriod tbLotteryPeriod = new TBLotteryPeriod();
tbLotteryPeriod.lotteryType = dr["lotteryType"].ToString(); //彩种
tbLotteryPeriod.period = dr["period"].ToString(); //期次
if (dr["startTime"] == null)
{
tbLotteryPeriod.startTime = "";//开售时间
}
else
{
tbLotteryPeriod.startTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["startTime"]);//开售时间
}
if (dr["endTime"] == null)
{
tbLotteryPeriod.endTime = "";//截止时间
}
else
{
tbLotteryPeriod.endTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["endTime"]);//截止时间
}
if (dr["publishTime"] == null)
{
tbLotteryPeriod.publishTime = "";//开奖时间
}
else
{
tbLotteryPeriod.publishTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["publishTime"]); //开奖时间
}
tbLotteryPeriod.saleStatus = dr["saleStatus"].ToString(); //销售状态
tbLotteryPeriod.remark = dr["remark"].ToString(); //备注说明
return(tbLotteryPeriod);
}
/// <summary>
/// 获取彩票奖期
/// <param name="lotteryType">彩种</param>
/// </summary>
/// <returns>彩票奖期对象</returns>
public TBLotteryPeriod Get(string lotteryType)
{
TBLotteryPeriod tbLotteryPeriod = null;
try
{
string strSQL = "select * from TBLotteryPeriod 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())
{
tbLotteryPeriod = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbLotteryPeriod);
}
/// <summary>
/// 修改彩票奖期
/// <param name="data">数据库连接</param>
/// <param name="tbLotteryPeriod">彩票奖期</param>
/// </summary>
public void Edit(DataAccess data, TBLotteryPeriod tbLotteryPeriod)
{
string strSQL = "update TBLotteryPeriod set period=:period,startTime=To_date(:startTime,'yyyy-mm-dd hh24:mi:ss'),endTime=To_date(:endTime,'yyyy-mm-dd hh24:mi:ss'),publishTime=To_date(:publishTime,'yyyy-mm-dd hh24:mi:ss'),saleStatus=:saleStatus,remark=:remark where lotteryType=:lotteryType";
Param param = new Param();
param.Clear();
param.Add(":period", tbLotteryPeriod.period); //期次
param.Add(":startTime", tbLotteryPeriod.startTime); //开售时间
param.Add(":endTime", tbLotteryPeriod.endTime); //截止时间
param.Add(":publishTime", tbLotteryPeriod.publishTime); //开奖时间
param.Add(":saleStatus", tbLotteryPeriod.saleStatus); //销售状态
param.Add(":remark", tbLotteryPeriod.remark); //备注说明
param.Add(":lotteryType", tbLotteryPeriod.lotteryType); //彩种
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
private DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
#region 代码生成器自动生成
/// <summary>
/// 增加彩票奖期
/// <param name="data">数据库连接</param>
/// <param name="tbLotteryPeriod">彩票奖期</param>
/// </summary>
public void Add(DataAccess data, TBLotteryPeriod tbLotteryPeriod)
{
string strSQL = "insert into TBLotteryPeriod (lotteryType,period,startTime,endTime,publishTime,saleStatus,remark) values (:lotteryType,:period,To_date(:startTime,'yyyy-mm-dd hh24:mi:ss'),To_date(:endTime,'yyyy-mm-dd hh24:mi:ss'),To_date(:publishTime,'yyyy-mm-dd hh24:mi:ss'),:saleStatus,:remark)";
Param param = new Param();
param.Clear();
param.Add(":lotteryType", tbLotteryPeriod.lotteryType); //彩种
param.Add(":period", tbLotteryPeriod.period); //期次
param.Add(":startTime", tbLotteryPeriod.startTime); //开售时间
param.Add(":endTime", tbLotteryPeriod.endTime); //截止时间
param.Add(":publishTime", tbLotteryPeriod.publishTime); //开奖时间
param.Add(":saleStatus", tbLotteryPeriod.saleStatus); //销售状态
param.Add(":remark", tbLotteryPeriod.remark); //备注说明
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改彩票奖期
/// <param name="tbLotteryPeriod">彩票奖期</param>
/// </summary>
public void Edit(TBLotteryPeriod tbLotteryPeriod)
{
try
{
db.Open();
Edit(db, tbLotteryPeriod);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
