/// <summary> /// 举报信息查詢 /// </summary> /// <param name="index"></param> /// <param name="pageSize"></param> /// <returns></returns> public Message JW2_JB_Query(int index, int pageSize) { string serverIP = ""; string BeginTime = ""; string EndTime = ""; string typeName = ""; int type = -1; try { serverIP = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.JW2_ServerIP).m_bValueBuffer); BeginTime = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.BeginTime).m_bValueBuffer); EndTime = Encoding.Default.GetString(msg.m_packet.m_Body.getTLVByTag(TagName.EndTime).m_bValueBuffer); TLV_Structure strut = new TLV_Structure(TagName.JW2_UserSN, 4, msg.m_packet.m_Body.getTLVByTag(TagName.JW2_Type).m_bValueBuffer); type = (int)strut.toInteger(); SqlHelper.log.WriteLog(lg.JW2API_BrowseServerAddress + CommonInfo.serverIP_Query(serverIP) + lg.JW2API_JB + typeName + "!"); Console.WriteLine(DateTime.Now + lg.JW2API_BrowseServerAddress + CommonInfo.serverIP_Query(serverIP) + lg.JW2API_JB + typeName + "!"); string ret = ""; switch (type) { case 1: { typeName = "昵称有问题"; ret = "2,4,8,16,32,64,128,256,512,1024"; break; } case 2: { typeName = "房间名有问题"; ret = "1,4,8,16,32,64,128,256,512,1024"; break; } case 4: { typeName = "大小喇叭有问题"; ret = "1,2,8,16,32,64,128,256,512,1024"; break; } case 8: { typeName = "横幅内容有问题"; ret = "1,2,4,16,32,64,128,256,512,1024"; break; } case 16: { typeName = "宠物名字有问题"; ret = "1,2,4,8,32,64,128,256,512,1024"; break; } case 32: { typeName = "家族名有问题"; ret = "1,2,4,8,16,64,128,256,512,1024"; break; } case 64: { typeName = "聊天内容有问题"; ret = "1,2,4,8,16,32,128,256,512,1024"; break; } case 128: { typeName = "名片信息有问题"; ret = "1,2,4,8,16,32,64,256,512,1024"; break; } case 256: { typeName = "小屋留言板有问题"; ret = "1,2,4,8,16,32,64,128,512,1024"; break; } case 512: { typeName = "家族论坛有问题"; ret = "1,2,4,8,16,32,64,128,256,1024"; break; } case 1024: { typeName = "外挂"; ret = "1,2,4,8,16,32,64,128,256,512"; break; } } DataSet ds = JW2DataInfo.JW2LogDataInfo.JB_Query(serverIP, type, ret, BeginTime, EndTime); if (ds != null && ds.Tables[0].Rows.Count > 0) { //总页数 index = index * pageSize; int pageCount = 0; pageCount = ds.Tables[0].Rows.Count % pageSize; if (pageCount > 0) { pageCount = ds.Tables[0].Rows.Count / pageSize + 1; } else { pageCount = ds.Tables[0].Rows.Count / pageSize; } if (index + pageSize > ds.Tables[0].Rows.Count) { pageSize = ds.Tables[0].Rows.Count - index; } Query_Structure[] structList = new Query_Structure[pageSize]; for (int i = index; i < index + pageSize; i++) { Query_Structure strut1 = new Query_Structure((uint)ds.Tables[0].Rows[i].ItemArray.Length + 1); byte[] bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, int.Parse(ds.Tables[0].Rows[i].ItemArray[0].ToString())); strut1.AddTagKey(TagName.JW2_ReportSn, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); string ReporterNick = CommonInfo.JW2_UserSn_UserNick(serverIP, int.Parse(ds.Tables[0].Rows[i].ItemArray[1].ToString())); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ReporterNick); strut1.AddTagKey(TagName.JW2_ReporterNick, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[2].ToString()); strut1.AddTagKey(TagName.JW2_ReportedNick, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, int.Parse(ds.Tables[0].Rows[i].ItemArray[3].ToString())); strut1.AddTagKey(TagName.JW2_ReportType, TagFormat.TLV_INTEGER, (uint)bytes.Length, bytes); bytes = TLV_Structure.ValueToByteArray(TagFormat.TLV_STRING, ds.Tables[0].Rows[i].ItemArray[4].ToString()); strut1.AddTagKey(TagName.JW2_Memo, TagFormat.TLV_STRING, (uint)bytes.Length, bytes); strut1.AddTagKey(TagName.PageCount, TagFormat.TLV_INTEGER, 5, TLV_Structure.ValueToByteArray(TagFormat.TLV_INTEGER, pageCount)); structList[i - index] = strut1; } return(Message.COMMON_MES_RESP(structList, Msg_Category.JW2_ADMIN, ServiceKey.JW2_JB_Query_Resp, 5)); } else { return(Message.COMMON_MES_RESP(lg.JW2API_NoJB, Msg_Category.JW2_ADMIN, ServiceKey.JW2_JB_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } } catch (System.Exception ex) { SqlHelper.errLog.WriteLog(lg.JW2API_QueryJB + serverIP + "->" + ex.Message); return(Message.COMMON_MES_RESP(lg.JW2API_NoJB, Msg_Category.JW2_ADMIN, ServiceKey.JW2_JB_Query_Resp, TagName.ERROR_Msg, TagFormat.TLV_STRING)); } }