/// <summary> /// 获取俱乐部的战绩列表 /// </summary> /// <param name="pagination"></param> /// <param name="sdate"></param> /// <param name="edate"></param> /// <param name="clubid"></param> /// <returns></returns> public ActionResult GetClubGameDetail(string pagination, string sdate, string edate, string clubid, string roomNum) { Pagination paginationobj = pagination.ToObject <Pagination>(); T_GameRoundLogH5 model = new T_GameRoundLogH5(); model.pageIndex = paginationobj.page; model.pageSize = paginationobj.rows; model.totalCount = paginationobj.total; model.startDate = sdate; model.endDate = edate; model.clubId = Convert.ToInt32(clubid); model.round = Convert.ToInt32(roomNum); List <T_GameRoundLogH5> list = this._clubgame.GetClubGameRoundByRoomNum(model); var jsonData = new { rows = list, total = list.Count > 0 ? list[0].total : 0, page = paginationobj.page, records = list.Count > 0 ? list[0].totalCount : 0 }; return(Success(jsonData)); }
/// <summary> /// 查询房间的记录 /// </summary> /// <returns></returns> public List <T_GameRoundLogH5> GetClubGameRoundByRoomNum(T_GameRoundLogH5 model) { using (IDbConnection conn = DapperAdapter.MySQLOpenConnection(ConfigurationHelper.MySQLConnectionStr)) { DynamicParameters param = new DynamicParameters(); StringBuilder sb = new StringBuilder(); //SELECT * FROM t_game_round_log_h5 string sqlCol = "SELECT gr.*,u1.nickName as playNickName1,u2.nickName as playNickName2,u3.nickName as playNickName3,u4.nickName as playNickName4,u5.nickName as playNickName5,u6.nickName as playNickName6 "; sb.Append(sqlCol); sb.Append(" FROM t_game_round_log_h5 as gr"); sb.AppendLine(@" LEFT JOIN t_user u1 on u1.userId = gr.player1 LEFT JOIN t_user u2 on u2.userId = gr.player2 LEFT JOIN t_user u3 on u3.userId = gr.player3 LEFT JOIN t_user u4 on u4.userId = gr.player4 LEFT JOIN t_user u5 on u5.userId = gr.player5 LEFT JOIN t_user u6 on u6.userId = gr.player6"); sb.AppendLine(" where gr.clubId = @clubId and gr.roomNum = @roomNum"); param.Add("@clubId", model.clubId); param.Add("@roomNum", model.round); if (!string.IsNullOrEmpty(model.startDate)) { sb.AppendLine(" and gr.updateTime>=@startDate "); param.Add("@startDate", model.startDate); } if (!string.IsNullOrEmpty(model.endDate)) { sb.AppendLine(" and gr.updateTime<=@endDate "); param.Add("@endDate", model.endDate); } //获取总记录数 string sqlCount = sb.ToString().Replace(sqlCol, "select count(1) totalCount "); //分页 if (model.pageIndex >= 0 && model.pageSize > 0) { sb.Append(" limit " + ((model.pageIndex - 1) * model.pageSize) + "," + model.pageSize); } //分页记录列表 var list = conn.Query <T_GameRoundLogH5>(sb.ToString(), param).ToList(); if (list != null && list.Count() > 0) { //总记录数列表 dynamic identity = conn.Query(sqlCount, param).Single(); list[0].totalCount = Convert.ToInt64(identity.totalCount); list[0].pageIndex = model.pageIndex; list[0].pageSize = model.pageSize; } return(list); } }