public void SendRoleData(string _Acc)
{
GetRolesList szGetRolesList = new GetRolesList();
szGetRolesList.Acc = _Acc;
szGetRolesList.ZoneID = 0;
MemoryStream msResult = new MemoryStream();
Serializer.Serialize <GetRolesList>(msResult, szGetRolesList);
byte[] msSendData = msResult.ToArray();
TCPOutPacket szTCPOutPacket = TCPOutPacket.MakeTCPOutPacket(m_GSNetClient.OutPacketPool, msSendData, 0, msSendData.Length, (int)CommandID.CMD_GET_ROLE_LIST);
if (m_GSNetClient.SendData(szTCPOutPacket))
{
SysConOut.WriteLine("发送获取角色列表数据成功");
}
else
{
SysConOut.WriteLine("发送获取角色列表数据失败");
}
//TCPOutPacket szTCPOutPacket = TCPOutPacket.MakeTCPOutPacket(m_tcpOutPacketPool,
// StringUtil.substitute("{0}:{1}", _Acc, "0"),
// (int)TCPServerCmds.CMD_ROLE_LIST);
//if (m_GSNetClient.SendData(szTCPOutPacket))
// SysConOut.WriteLine("发送获取角色列表数据成功");
//else
// SysConOut.WriteLine("发送获取角色列表数据失败");
m_GSNetClient.OutPacketPool.Push(szTCPOutPacket);
}
/// <summary>
/// 获取角色列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public BsTableDataSource <Role> GetRolesList(GetRolesList request)
{
using (var db = DbFactory.Open())
{
var builder = db.From <Role>();
if (!string.IsNullOrEmpty(request.roleName))
{
builder.Where(x => x.RoleName.Contains(request.roleName));
}
if (request.Id != null)
{
builder.Where(x => x.Id == request.Id.Value);
}
if (!string.IsNullOrEmpty(request.Sort))
{
if (request.Order == "desc")
{
builder.OrderByFieldsDescending(request.Sort);
}
else
{
builder.OrderByFields(request.Sort);
}
}
else
{
builder.OrderBy(x => x.Id);
}
var count = db.Count(builder);
var PageSize = request.PageSize == 0 ? 15 : request.PageSize;
var PageIndex = request.PageIndex == 0 ? 0 : request.PageIndex * PageSize;
builder.Limit(PageIndex, PageSize);
var list = db.Select <Role>(builder);
return(new BsTableDataSource <Role>()
{
total = count, rows = list
});
}
}
/// <summary>
/// 获取角色列表
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public BsTableDataSource <Role> GetRolesList(GetRolesList request)
{
return(SysManager.GetRolesList(request));
}
