void Query(int offset) { GameServer server = ServerDropDownList.SelectedGameServer; if (server == null) { LabelOpMsg.Text = string.Format(StringDef.MsgCannotBeNone, StringDef.GameServer); return; } if (!server.IsConnected) { LabelOpMsg.Text = StringDef.NoConnectionAlert; return; } string roleName = TextBoxRole.Text.Trim(); if (roleName == null || roleName.Length == 0) { LabelOpMsg.Text = string.Format(StringDef.MsgCannotBeNone, StringDef.RoleName); return; } string roleGuid = WebUtil.FindRoleGuidByName(CurrentUser.Id, server, roleName); if (roleGuid == null || roleGuid.Length == 0) { LabelOpMsg.Text = string.Format(StringDef.MsgNotExist, StringDef.RoleName); return; } StringBuilder whereStatement = new StringBuilder(); whereStatement.AppendFormat(" WHERE PlayerGuid='{0}'", roleGuid); foreach (ListItem item in CheckBoxListPlayerAction.Items) { if (!item.Selected) { whereStatement.AppendFormat(" AND ActionId<>{0}", item.Value); } } if (ScriptCalendarStartTime.Selected) { DateTime startTime = ScriptCalendarStartTime.SelectedDate; whereStatement.AppendFormat(" AND RecordTime>='{0}'", startTime); } if (ScriptCalendarEndTime.Selected) { DateTime endTime = ScriptCalendarEndTime.SelectedDate; whereStatement.AppendFormat(" AND RecordTime<='{0}'", endTime); } StringBuilder orderByStatement = new StringBuilder(); if (ListBoxOrderBy.SelectedIndex == 0) { orderByStatement.Append(" ORDER BY RecordTime"); } else { orderByStatement.Append(" ORDER BY PlayerAction"); } if (ListBoxOrderByType.SelectedIndex == 0) { orderByStatement.Append(" ASC"); } else { orderByStatement.Append(" DESC"); } SqlCommand cmd = new SqlCommand("SELECT Id,RecordTime,PlayerAction,ActionDesc FROM playeraction" + whereStatement.ToString() + orderByStatement.ToString()); if (!server.IsConnected) { LabelOpMsg.Text = StringDef.NoConnectionAlert; return; } SqlResult result = WebUtil.QueryGameServerDb(CurrentUser.Id, server, cmd); ArrayList c2sNetMsgInfoList = new ArrayList(); if (result != null && result.Success) { result.SetFieldType(new SqlDataType[] { SqlDataType.Int32, SqlDataType.DateTime, SqlDataType.Int32, SqlDataType.String }); object[] record = null; while ((record = result.ReadRecord()) != null) { PlayerActionInfo info = new PlayerActionInfo(); info.Id = (int)record[0]; info.RecordTime = (DateTime)record[1]; info.Action = (int)record[2]; info.Desc = record[3] as string; c2sNetMsgInfoList.Add(info); } if (c2sNetMsgInfoList.Count == 0) { LabelOpMsg.Text = StringDef.NoMatchingRecord; return; } else { CreateTableC2SNetMsg(c2sNetMsgInfoList); PanelResult.Visible = true; } } else { if (result == null) { LabelOpMsg.Text = StringDef.QueryTimeOut; } else { LabelOpMsg.Text = StringDef.OperationFail; } } }
void Query(int offset) { GameServer server = ServerDropDownList.SelectedGameServer; if (server == null) { LabelOpMsg.Text = string.Format(StringDef.MsgCannotBeNone, StringDef.GameServer); return; } if (!server.IsConnected) { LabelOpMsg.Text = StringDef.NoConnectionAlert; return; } string roleName = TextBoxRole.Text.Trim(); if (roleName == null || roleName.Length == 0) { LabelOpMsg.Text = string.Format(StringDef.MsgCannotBeNone, StringDef.RoleName); return; } string roleGuid = WebUtil.FindRoleGuidByName(CurrentUser.Id, server, roleName); if (roleGuid == null || roleGuid.Length == 0) { LabelOpMsg.Text = string.Format(StringDef.MsgNotExist, StringDef.RoleName); return; } StringBuilder whereStatement = new StringBuilder(); whereStatement.AppendFormat(" WHERE PlayerGuid='{0}'", roleGuid); foreach (ListItem item in CheckBoxListPlayerAction.Items) { if (!item.Selected) { whereStatement.AppendFormat(" AND ActionId<>{0}", item.Value); } } if (ScriptCalendarStartTime.Selected) { DateTime startTime = ScriptCalendarStartTime.SelectedDate; whereStatement.AppendFormat(" AND RecordTime>='{0}'", startTime); } if (ScriptCalendarEndTime.Selected) { DateTime endTime = ScriptCalendarEndTime.SelectedDate; whereStatement.AppendFormat(" AND RecordTime<='{0}'", endTime); } StringBuilder orderByStatement = new StringBuilder(); if (ListBoxOrderBy.SelectedIndex == 0) { orderByStatement.Append(" ORDER BY RecordTime"); } else { orderByStatement.Append(" ORDER BY PlayerAction"); } if (ListBoxOrderByType.SelectedIndex == 0) { orderByStatement.Append(" ASC"); } else { orderByStatement.Append(" DESC"); } SqlCommand cmd = new SqlCommand("SELECT Id,RecordTime,PlayerAction,ActionDesc FROM playeraction" + whereStatement.ToString() + orderByStatement.ToString()); if (!server.IsConnected) { LabelOpMsg.Text = StringDef.NoConnectionAlert; return; } SqlResult result = WebUtil.QueryGameServerDb(CurrentUser.Id, server, cmd); ArrayList c2sNetMsgInfoList = new ArrayList(); if (result != null && result.Success) { result.SetFieldType(new SqlDataType[] { SqlDataType.Int32, SqlDataType.DateTime, SqlDataType.Int32, SqlDataType.String }); object[] record = null; while ((record = result.ReadRecord()) != null) { PlayerActionInfo info = new PlayerActionInfo(); info.Id = (int)record[0]; info.RecordTime = (DateTime)record[1]; info.Action = (int)record[2]; info.Desc = record[3] as string; c2sNetMsgInfoList.Add(info); } if (c2sNetMsgInfoList.Count == 0) { LabelOpMsg.Text = StringDef.NoMatchingRecord; return; } else { CreateTableC2SNetMsg(c2sNetMsgInfoList); PanelResult.Visible = true; } } else { if (result == null) LabelOpMsg.Text = StringDef.QueryTimeOut; else LabelOpMsg.Text = StringDef.OperationFail; } }