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