public ActionResult GetClubDetailPage(string pagination, string sdate, string edate, string keyword, string clubid)
{
Pagination paginationobj = pagination.ToObject <Pagination>();
T_Club_member model = new T_Club_member();
model.pageIndex = paginationobj.page;
model.pageSize = paginationobj.rows;
model.totalCount = paginationobj.total;
model.startDate = sdate;
model.endDate = edate;
model.userName = keyword;
model.clubId = Convert.ToInt32(clubid);
List <T_Club_member> list = this._club.GetClubUserPage(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>
/// <param name="json"></param>
/// <param name="userid"></param>
public object GetClubAuth(string json, int userid)
{
JObject obj = JObject.Parse(json);
int clubid = Convert.ToInt32(obj["nClubId"]);
List <T_Club_member> list = this._club.GetClubUser(clubid);
T_Club_member user = list.Where(w => w.userId == userid).FirstOrDefault();
_Response result = new _Response();
if (user == null)
{
result.code = 0;
result.msg = "非俱乐部成员";
}
else
{
result.code = 1;
result.body = new
{
position = user.position
};
result.msg = "身份验证成功";
}
return(result);
}
/// <summary>
/// 设置俱乐部成员 可用积分上限
/// </summary>
/// <param name="josn"></param>
/// <returns></returns>
public _Response AddClubMemberScoreLimit(string json)
{
JObject obj = JObject.Parse(json);
int clubid = Convert.ToInt32(obj["nClubId"]);
int userid = Convert.ToInt32(obj["userId"]);
int value = Convert.ToInt32(obj["val"]);
var data = new
{
clubId = clubid,
userId = userid,
addScore = value
};
json = JSONHelper.ObjectToJSON(data);
Entity.Common.ResponseRet dataResult = WebSecurityHelper.GameServerApi.ToPost("addClubMemberScoreLimit", json);
WebSecurityHelper.LogCommon.Current.WriteLog_Operation(Game.Entity.OperationType.Update, (dataResult.result ? "1" : "0"), "俱乐部设置", "俱乐部" + clubid + "的" + userid + "积分额度追加" + value);
_Response result = new _Response(dataResult.result);
T_Club_member club = this._club.GetClubUserInfo(clubid, userid);
result.body = club;
return(result);
}
/// <summary>
/// 查询俱乐部成员
/// </summary>
/// <returns></returns>
public List <T_Club_member> GetClubUserPage(T_Club_member model)
{
using (IDbConnection conn = DapperAdapter.MySQLOpenConnection(ConfigurationHelper.MySQLConnectionStr))
{
DynamicParameters param = new DynamicParameters();
StringBuilder sb = new StringBuilder();
sb.Append(" SELECT c.*,u.nickName as userName ,u.coin FROM T_Club_member c LEFT JOIN t_user u on c.userId=u.userId WHERE clubId=@clubId ");
param.Add("@clubId", model.clubId);
if (!string.IsNullOrEmpty(model.startDate))
{
sb.Append(" and createTime>=@startDate ");
param.Add("@startDate", model.startDate);
}
if (!string.IsNullOrEmpty(model.endDate))
{
sb.Append(" and createTime<=@endDate ");
param.Add("@endDate", model.endDate);
}
if (!string.IsNullOrEmpty(model.userName))
{
sb.Append(" and nickName like @Name ");
param.Add("@Name", "%" + model.userName + "%");
}
sb.Append(" order by createTime desc");
//获取总记录数
string sqlCount = sb.ToString().Replace("SELECT c.*,u.nickName as userName", "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_Club_member>(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);
}
}
/// <summary>
/// 俱乐部成员信息
/// </summary>
/// <param name="userid"></param>
/// <param name="user"></param>
/// <returns></returns>
public _Response GetClubUserInfo(string json)
{
JObject obj = JObject.Parse(json);
int clubid = Convert.ToInt32(obj["nClubId"]);
int userid = Convert.ToInt32(obj["userid"]);
T_Club_member club = this._club.GetClubUserInfo(clubid, userid);
_Response result = new _Response(true);
result.body = club;
return(result);
}
/// <summary>
/// 设置俱乐部成员 可用积分上限
/// </summary>
/// <param name="josn"></param>
/// <returns></returns>
public _Response AddClubMemberCoinLimit(string json)
{
JObject obj = JObject.Parse(json);
int clubid = Convert.ToInt32(obj["nClubId"]);
int userid = Convert.ToInt32(obj["userId"]);
int value = Convert.ToInt32(obj["val"]);
var data = new
{
clubId = clubid,
userId = userid,
addCoin = value
};
json = JSONHelper.ObjectToJSON(data);
Entity.Common.ResponseRet dataResult = WebSecurityHelper.GameServerApi.ToPost("addClubMemberCoinLimit", json);
#region 返回错误信息
/*
* 101 用户不存在
* 206 俱乐部不存在
* 210 该俱乐部成员不存在
* 252 金币池余额不足
* 253 回收金币时玩家余额不足
* 250 积分池不足
* 251 回收积分时成员的现有积分不足
*/
string msg = "";
switch (dataResult.ret)
{
case 101:
msg = "用户不存在";
break;
case 206:
msg = "俱乐部不存在";
break;
case 210:
msg = "该俱乐部成员不存在";
break;
case 252:
msg = "金币池余额不足";
break;
case 253:
msg = "回收金币时玩家余额不足";
break;
case 250:
msg = "积分池不足";
break;
case 251:
msg = "回收积分时成员的现有积分不足";
break;
default:
break;
}
#endregion
WebSecurityHelper.LogCommon.Current.WriteLog_Operation(Game.Entity.OperationType.Update, (dataResult.result ? "1" : "0"), "俱乐部设置", "请求返回状态码" + dataResult.ret + ";" + msg + ";俱乐部" + clubid + "的" + userid + "金币 请求 " + value);
_Response result = new _Response(dataResult.result);
result.msg = msg;
T_Club_member club = this._club.GetClubUserInfo(clubid, userid);
result.body = club;
return(result);
}
