/// <summary> /// 取得固定列表记录 /// </summary> /// <param name="SizeNum">列表记录数</param> /// <param name="strWhere">查询条件</param> /// <returns>IList Lucklist</returns> public IList <BCW.Model.Game.Lucklist> GetLucklists(int SizeNum, string strWhere) { IList <BCW.Model.Game.Lucklist> listLucklists = new List <BCW.Model.Game.Lucklist>(); string sTable = "tb_Lucklist"; string sPkey = "id"; string sField = "ID,SumNum,PostNum,Bjkl8Qihao"; string sCondition = strWhere; string sOrder = "Bjkl8Qihao Desc"; int iSCounts = SizeNum; int p_recordCount; using (SqlDataReader reader = SqlHelper.RunProcedureMe(sTable, sPkey, sField, 1, SizeNum, sCondition, sOrder, iSCounts, out p_recordCount)) { //计算总页数 if (p_recordCount == 0) { return(listLucklists); } while (reader.Read()) { BCW.Model.Game.Lucklist objLucklist = new BCW.Model.Game.Lucklist(); objLucklist.ID = reader.GetInt32(0); objLucklist.SumNum = reader.GetInt32(1); if (!reader.IsDBNull(2)) { objLucklist.PostNum = reader.GetString(2); } objLucklist.Bjkl8Qihao = reader.GetInt32(3); listLucklists.Add(objLucklist); } } return(listLucklists); }
/// <summary> /// 根据Bjkl8Qihao开奖 /// </summary> /// <param name="model"></param> /// <returns></returns> public int Update3(BCW.Model.Game.Lucklist model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Lucklist set "); strSql.Append("SumNum=@SumNum,"); strSql.Append("PostNum=@PostNum,"); strSql.Append("LuckCent=@LuckCent,"); strSql.Append("Bjkl8Nums=@Bjkl8Nums,"); strSql.Append("State=@State"); strSql.Append(" where Bjkl8Qihao=@Bjkl8Qihao and State=0"); SqlParameter[] parameters = { new SqlParameter("@Bjkl8Qihao", SqlDbType.Int, 4), new SqlParameter("@SumNum", SqlDbType.Int, 4), new SqlParameter("@PostNum", SqlDbType.NVarChar, 50), new SqlParameter("@LuckCent", SqlDbType.BigInt, 8), new SqlParameter("@Bjkl8Nums", SqlDbType.NVarChar, 100), new SqlParameter("@State", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.Bjkl8Qihao; parameters[1].Value = model.SumNum; parameters[2].Value = model.PostNum; parameters[3].Value = model.LuckCent; parameters[4].Value = model.Bjkl8Nums; parameters[5].Value = model.State; return(SqlHelper.ExecuteSql(strSql.ToString(), parameters)); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(BCW.Model.Game.Lucklist model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_Lucklist set "); strSql.Append("SumNum=@SumNum,"); strSql.Append("BeginTime=@BeginTime,"); strSql.Append("EndTime=@EndTime,"); strSql.Append("State=@State,"); strSql.Append("PostNum=@PostNum,"); strSql.Append("Bjkl8Nums=@Bjkl8Nums,"); strSql.Append("LuckCent=@LuckCent"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@SumNum", SqlDbType.Int, 4), new SqlParameter("@BeginTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@State", SqlDbType.Int, 4), new SqlParameter("@PostNum", SqlDbType.NVarChar, 50), new SqlParameter("@Bjkl8Nums", SqlDbType.NVarChar, 100), new SqlParameter("@LuckCent", SqlDbType.Int, 8) }; parameters[0].Value = model.ID; parameters[1].Value = model.SumNum; parameters[2].Value = model.BeginTime; parameters[3].Value = model.EndTime; parameters[4].Value = model.State; parameters[5].Value = model.PostNum; parameters[6].Value = model.Bjkl8Nums; parameters[7].Value = model.LuckCent; SqlHelper.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到本期对象实体 /// </summary> public BCW.Model.Game.Lucklist GetLucklistSecond() { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 * from tb_Lucklist "); strSql.Append("where Bjkl8Qihao not in (select top 1 Bjkl8Qihao from tb_Lucklist order by Bjkl8Qihao desc ) "); strSql.Append("order by Bjkl8Qihao desc"); BCW.Model.Game.Lucklist model = new BCW.Model.Game.Lucklist(); using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString())) { if (reader.HasRows) { reader.Read(); model.ID = reader.GetInt32(0); model.SumNum = reader.GetInt32(1); model.PostNum = reader.GetString(2); model.BeginTime = reader.GetDateTime(3); model.EndTime = reader.GetDateTime(4); model.LuckCent = reader.GetInt64(5); model.Pool = reader.GetInt64(6); model.BeforePool = reader.GetInt64(7); model.State = reader.GetByte(8); if (!reader.IsDBNull(9)) { model.panduan = reader.GetString(9); } model.Bjkl8Qihao = reader.GetInt32(10); return(model); } else { model.ID = 0; model.SumNum = 0; model.PostNum = ""; model.BeginTime = DateTime.Now; model.EndTime = DateTime.Now.AddMinutes(30); model.LuckCent = 0; model.Pool = 0; model.BeforePool = 0; model.panduan = ""; return(model); } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add2(BCW.Model.Game.Lucklist model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_Lucklist("); strSql.Append("SumNum,PostNum,BeginTime,EndTime,LuckCent,Pool,BeforePool,State,panduan,Bjkl8Qihao,Bjkl8Nums)"); strSql.Append(" values ("); strSql.Append("@SumNum,@PostNum,@BeginTime,@EndTime,@LuckCent,@Pool,@BeforePool,@State,@panduan,@Bjkl8Qihao,@Bjkl8Nums)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@SumNum", SqlDbType.Int, 4), new SqlParameter("@PostNum", SqlDbType.NVarChar, 50), new SqlParameter("@BeginTime", SqlDbType.DateTime), new SqlParameter("@EndTime", SqlDbType.DateTime), new SqlParameter("@LuckCent", SqlDbType.BigInt, 8), new SqlParameter("@Pool", SqlDbType.BigInt, 8), new SqlParameter("@BeforePool", SqlDbType.BigInt, 8), new SqlParameter("@State", SqlDbType.TinyInt, 1), new SqlParameter("@panduan", SqlDbType.NVarChar, 50), new SqlParameter("@Bjkl8Qihao", SqlDbType.Int, 4), new SqlParameter("@Bjkl8Nums", SqlDbType.NVarChar, 100) }; parameters[0].Value = model.SumNum; parameters[1].Value = model.PostNum; parameters[2].Value = model.BeginTime; parameters[3].Value = model.EndTime; parameters[4].Value = model.LuckCent; parameters[5].Value = model.Pool; parameters[6].Value = model.BeforePool; parameters[7].Value = model.State; parameters[8].Value = model.panduan; parameters[9].Value = model.Bjkl8Qihao; parameters[10].Value = model.Bjkl8Nums; object obj = SqlHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 取得每页记录 /// </summary> /// <param name="p_pageIndex">当前页</param> /// <param name="p_pageSize">分页大小</param> /// <param name="p_recordCount">返回总记录数</param> /// <param name="strWhere">查询条件</param> /// <returns>IList Lucklist</returns> public IList <BCW.Model.Game.Lucklist> GetLucklists(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount) { IList <BCW.Model.Game.Lucklist> listLucklists = new List <BCW.Model.Game.Lucklist>(); string sTable = "tb_Lucklist"; string sPkey = "id"; string sField = "ID,SumNum,PostNum,State,Bjkl8Qihao,Bjkl8Nums"; string sCondition = strWhere; string sOrder = "Bjkl8Qihao Desc"; int iSCounts = 0; using (SqlDataReader reader = SqlHelper.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount)) { //计算总页数 if (p_recordCount > 0) { int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex); } else { return(listLucklists); } while (reader.Read()) { BCW.Model.Game.Lucklist objLucklist = new BCW.Model.Game.Lucklist(); objLucklist.ID = reader.GetInt32(0); objLucklist.SumNum = reader.GetInt32(1); if (!reader.IsDBNull(2)) { objLucklist.PostNum = reader.GetString(2); } objLucklist.State = reader.GetByte(3); objLucklist.Bjkl8Qihao = reader.GetInt32(4); if (!reader.IsDBNull(5)) { objLucklist.Bjkl8Nums = reader.GetString(5); } listLucklists.Add(objLucklist); } } return(listLucklists); }
/// <summary> /// 得到一个对象实体 /// </summary> public BCW.Model.Game.Lucklist GetLucklist(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top(1) * from tb_Lucklist"); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; BCW.Model.Game.Lucklist model = new BCW.Model.Game.Lucklist(); using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters)) { if (reader.HasRows) { reader.Read(); model.ID = reader.GetInt32(0); model.SumNum = reader.GetInt32(1); model.PostNum = reader.GetString(2); model.BeginTime = reader.GetDateTime(3); model.EndTime = reader.GetDateTime(4); model.LuckCent = reader.GetInt64(5); model.Pool = reader.GetInt64(6); model.BeforePool = reader.GetInt64(7); model.State = reader.GetByte(8); if (!reader.IsDBNull(9)) { model.panduan = reader.GetString(9); } model.Bjkl8Qihao = reader.GetInt32(10); model.Bjkl8Nums = reader.GetString(11); return(model); } else { return(null); } } }