/// <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);
}
}
