protected void Page_Load(object sender, EventArgs e) { string vType = Request.QueryString["vType"]!=null?Request.QueryString["vType"].ToString():""; string tType =Request.QueryString["type"]!=null? Request.QueryString["type"].ToString():""; string id = Request.QueryString["id"]!=null?Request.QueryString["id"].ToString():""; dbDns dbdns = null; /// 白名单 if (vType == "6") { dbdns = new dbDns("dns"); } else // 非白名单 { dbdns= new dbDns("dnsalarm"); } DataSet ds = dbdns.getDnsInfo(tType, id); if( ds==null || ds.Tables.Count<1 || ds.Tables[0].Rows.Count<1 ) return ; txtvSrcIp.Text = common.NumberToIP( ds.Tables[0].Rows[0]["vSrcIp"] ); txtvSrcMac.Text = ds.Tables[0].Rows[0]["vSrcMac"].ToString(); txtvDstIp.Text = common.NumberToIP( ds.Tables[0].Rows[0]["vDstIp"] ); txtvDstMac.Text = ds.Tables[0].Rows[0]["vDstMac"].ToString(); txtvName.Text = ds.Tables[0].Rows[0]["vName"].ToString(); txtvType.Text = common.FormatDnsType( Convert.ToInt32( ds.Tables[0].Rows[0]["vType"].ToString() )); tbvAddr.Text = common.NumberToIP(ds.Tables[0].Rows[0]["vAddr"]); dbdns.SetReaded(Request.QueryString["type"], Request.QueryString["id"]); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { dbDns db = new dbDns(); } }
/// <summary> /// 删除DNS数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btDnsDel_Click(object sender, EventArgs e) { DateTime dteFromDate, dteToDate; dteFromDate = Convert.ToDateTime(dnsStartDate.Value.ToString()).Date; dteToDate = Convert.ToDateTime(dnsEndDate.Value.ToString()).Date; dbDns DB = new dbDns(); DB.DelTables(dteFromDate, dteToDate); }
/// <summary> /// 导出DNS数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btDnsExport_Click(object sender, EventArgs e) { DateTime dteFromDate, dteToDate; dteFromDate = Convert.ToDateTime(dnsStartDate.Value.ToString()).Date; dteToDate = Convert.ToDateTime(dnsEndDate.Value.ToString()).Date; dbDns DB = new dbDns(); string FileName = Server.MapPath(".") + "\\temp\\" + common.GetFileName() + ".xls"; DB.ExportToExcel(dteFromDate, dteToDate, FileName); SendToClient(FileName); }
protected void btSave_Click(object sender, EventArgs e) { int level = Convert.ToInt32(this.ddlTypeList.SelectedValue);// this.DNSTypeUserControl1.VLevel; string content = tbContent.Text; string ips = this.TextBox1.Text; if (string.IsNullOrEmpty(ips)) { Message.Show(Page, "对不起,域名地址不能为空"); return; } if (level < 0) { Message.Show(this, "对不起,必须选择DNS类型"); return; } string[] strIps = ips.Split(new char[] { '\n'}); if (strIps == null || strIps.Length <= 0) { Message.Show(Page, "对不起,输入的域名每行必须以换行结尾"); return; } DataSet ds = null; dbDns dn = new dbDns(); foreach (string ip in strIps) { string temp = ip.Trim(); ds = db.GetBlackWhiteModel(temp); if (ds != null && ds.Tables[0].Rows.Count > 0) { if (level == 4) { dn.ExecuteScalar("DELETE FROM [TC_Dns_doubtlist] WHERE [vName]='" + ip+"'"); } Message.Show(Page, "对不起,此域名 " + ip + "已存在,点击确定继续"); } else { db.AddBlackAndWhite(temp,level,0,content); } } ltMsg.Text = "<script>window.close();window.opener.location.href=window.opener.location.href;</script>"; }
protected void btDelAll_Click(object sender, EventArgs e) { string tableName = string.Empty; if (ddlDnsTypelist.SelectedValue.Trim().Equals("6")) { tableName = "dns"; } else { tableName = "dnsalarm"; } dbDns db = new dbDns(); db.DeleteAllRecord(tableName, this.qrytypelist.SelectedValue, Condition); BinddtgData(this.qrytypelist.SelectedValue); }
/// <summary> /// 根据选择的模块生成不同的类型 /// </summary> /// <param name="type"></param> /// <returns></returns> private database CreateDataBase(string type) { database d = null; switch (type) { case "1": d = new dbHttpAll(); break; case "2": d = new dbMsgAll("Msn"); break; case "3": d = new dbMsgAll("Yahoo"); break; case "4": d = new dbMailBox("Pop"); break; case "5": d = new dbMailBox("Smtp"); break; case "6": d = new dbMailSite("Get"); break; case "7": d = new dbMailSite("Send"); break; case "8": d = new dbInfoAll("Web"); break; case "9": d = new dbDns(); break; case "10": d = new dbHorse(); break; case "11": d = new dbInfoAll("Ftp"); break; } return d; }