/// <summary> /// 获取排行记录 /// </summary> /// <param name="p_pageIndex">当前页</param> /// <param name="p_pageSize">分页大小</param> /// <param name="strWhere">查询条件</param> /// <param name="p_recordCount">返回总记录数</param> /// <returns></returns> public IList <BCW.Baccarat.Model.BaccaratTop> GetUserTop(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount) { IList <BCW.Baccarat.Model.BaccaratTop> listUserTop = new List <BCW.Baccarat.Model.BaccaratTop>(); // 计算用户ID总数 string countString = "select COUNT(distinct UsID) from tb_BaccaratTop where " + strWhere + ""; p_recordCount = Convert.ToInt32(SqlHelper.GetSingle(countString)); if (p_recordCount > 100) { p_recordCount = 100; } if (p_recordCount > 0) { int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex); } else { return(listUserTop); } //取出相关记录 StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT UsID,SUM(TopBonusSum) as aa FROM tb_BaccaratTop where "); strSql.Append(strWhere + " group by UsID order by aa DESC"); using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString())) { int stratIndex = (p_pageIndex - 1) * p_pageSize; int endIndex = p_pageIndex * p_pageSize; int k = 0; while (reader.Read()) { if (k >= stratIndex && k < endIndex) { BCW.Baccarat.Model.BaccaratTop objbjlPay = new BCW.Baccarat.Model.BaccaratTop(); objbjlPay.UsID = reader.GetInt32(0); objbjlPay.aa = reader.GetInt32(1); listUserTop.Add(objbjlPay); } if (k == endIndex) { break; } k++; } } return(listUserTop); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(BCW.Baccarat.Model.BaccaratTop model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update tb_BaccaratTop set "); strSql.Append("UsID=@UsID,"); strSql.Append("UsName=@UsName,"); strSql.Append("Topdate=@Topdate,"); strSql.Append("TopBonusSum=@TopBonusSum,"); strSql.Append("RoomID=@RoomID,"); strSql.Append("RoomTable=@RoomTable"); strSql.Append(" where TopID=@TopID"); SqlParameter[] parameters = { new SqlParameter("@UsID", SqlDbType.Int, 4), new SqlParameter("@UsName", SqlDbType.NVarChar, 50), new SqlParameter("@Topdate", SqlDbType.DateTime), new SqlParameter("@TopBonusSum", SqlDbType.Int, 4), new SqlParameter("@RoomID", SqlDbType.Int, 4), new SqlParameter("@RoomTable", SqlDbType.Int, 4), new SqlParameter("@TopID", SqlDbType.Int, 4) }; parameters[0].Value = model.UsID; parameters[1].Value = model.UsName; parameters[2].Value = model.Topdate; parameters[3].Value = model.TopBonusSum; parameters[4].Value = model.RoomID; parameters[5].Value = model.RoomTable; parameters[6].Value = model.TopID; int rows = SqlHelper.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(BCW.Baccarat.Model.BaccaratTop model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into tb_BaccaratTop("); strSql.Append("UsID,UsName,Topdate,TopBonusSum,RoomID,RoomTable)"); strSql.Append(" values ("); strSql.Append("@UsID,@UsName,@Topdate,@TopBonusSum,@RoomID,@RoomTable)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UsID", SqlDbType.Int, 4), new SqlParameter("@UsName", SqlDbType.NVarChar, 50), new SqlParameter("@Topdate", SqlDbType.DateTime), new SqlParameter("@TopBonusSum", SqlDbType.Int, 4), new SqlParameter("@RoomID", SqlDbType.Int, 4), new SqlParameter("@RoomTable", SqlDbType.Int, 4) }; parameters[0].Value = model.UsID; parameters[1].Value = model.UsName; parameters[2].Value = model.Topdate; parameters[3].Value = model.TopBonusSum; parameters[4].Value = model.RoomID; parameters[5].Value = model.RoomTable; object obj = SqlHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } 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 BaccaratTop</returns> public IList <BCW.Baccarat.Model.BaccaratTop> GetBaccaratTops(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount) { IList <BCW.Baccarat.Model.BaccaratTop> listBaccaratTops = new List <BCW.Baccarat.Model.BaccaratTop>(); string sTable = "tb_BaccaratTop"; string sPkey = "id"; string sField = "*"; string sCondition = strWhere; string sOrder = "TopBonusSum 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(listBaccaratTops); } while (reader.Read()) { BCW.Baccarat.Model.BaccaratTop objBaccaratTop = new BCW.Baccarat.Model.BaccaratTop(); objBaccaratTop.TopID = reader.GetInt32(0); objBaccaratTop.UsID = reader.GetInt32(1); objBaccaratTop.UsName = reader.GetString(2); objBaccaratTop.Topdate = reader.GetDateTime(3); objBaccaratTop.TopBonusSum = reader.GetInt32(4); objBaccaratTop.RoomID = reader.GetInt32(4); objBaccaratTop.RoomTable = reader.GetInt32(4); listBaccaratTops.Add(objBaccaratTop); } } return(listBaccaratTops); }
/// <summary> /// 得到一个对象实体 /// </summary> public BCW.Baccarat.Model.BaccaratTop DataRowToModel(DataRow row) { BCW.Baccarat.Model.BaccaratTop model = new BCW.Baccarat.Model.BaccaratTop(); if (row != null) { if (row["TopID"] != null && row["TopID"].ToString() != "") { model.TopID = int.Parse(row["TopID"].ToString()); } if (row["UsID"] != null && row["UsID"].ToString() != "") { model.UsID = int.Parse(row["UsID"].ToString()); } if (row["UsName"] != null) { model.UsName = row["UsName"].ToString(); } if (row["Topdate"] != null && row["Topdate"].ToString() != "") { model.Topdate = DateTime.Parse(row["Topdate"].ToString()); } if (row["TopBonusSum"] != null && row["TopBonusSum"].ToString() != "") { model.TopBonusSum = int.Parse(row["TopBonusSum"].ToString()); } if (row["RoomID"] != null && row["RoomID"].ToString() != "") { model.RoomID = int.Parse(row["RoomID"].ToString()); } if (row["RoomTable"] != null && row["RoomTable"].ToString() != "") { model.RoomTable = int.Parse(row["RoomTable"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public BCW.Baccarat.Model.BaccaratTop GetModel(int TopID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 TopID,UsID,UsName,Topdate,TopBonusSum,RoomID,RoomTable from tb_BaccaratTop "); strSql.Append(" where TopID=@TopID"); SqlParameter[] parameters = { new SqlParameter("@TopID", SqlDbType.Int, 4) }; parameters[0].Value = TopID; BCW.Baccarat.Model.BaccaratTop model = new BCW.Baccarat.Model.BaccaratTop(); DataSet ds = SqlHelper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }