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;
}
