/// <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;
}
//导出HTTP数据
protected void btnHttpExport_Click(object sender, EventArgs e)
{
DateTime dteFromDate, dteToDate;
dteFromDate = Convert.ToDateTime(HttpStartDate.Value.ToString()).Date;
dteToDate = Convert.ToDateTime(HttpEndDate.Value.ToString()).Date;
dbHttpAll DB = new dbHttpAll();
string FileName = Server.MapPath(".") + "\\temp\\" + common.GetFileName() + ".xls";
DB.ExportToExcel(dteFromDate, dteToDate, FileName);
SendToClient(FileName);
}
protected void Page_Load(object sender, EventArgs e)
{
_RecordCount = Convert.ToInt32(lblRecordCount.Text);
_PageCount = _RecordCount / _PageSize;
if (_RecordCount % _PageSize > 0) _PageCount++;
_PageIndex = Convert.ToInt32(lblPageIndex.Text);
int selectedCount = 0;
string sParent = "'0'";
DB = new dbHttpAll();
if (!IsPostBack)
{
dbConfig configDB = new dbConfig();
string gUserName = configDB.getUserName(User.Identity.Name);
string gIP = Request.ServerVariables["Remote_Addr"];
string gContent = "网站查询";
common.setLog(User.Identity.Name, gUserName, gIP, gContent);
formInit();
}
else
{
switch (qrytypelist.SelectedItem.Value)
{
case "0"://自选时间段
Condition += "vTime > '" + Convert.ToDateTime(sdate.Value.ToString()).ToString("yyyy-MM-dd") + "'";
Condition += " and vTime < '" + Convert.ToDateTime(edate.Value.ToString()).AddDays(1).ToString("yyyy-MM-dd") + "'";
break;
case "1"://前三天
Condition += "vTime > '" + DateTime.Today.AddDays(-3).ToString("yyyy-MM-dd") + "'";
Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'";
break;
case "2"://前一周
Condition += "vTime > '" + DateTime.Today.AddDays(-7).ToString("yyyy-MM-dd") + "'";
Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'";
break;
case "3"://前一月
Condition += "vTime > '" + DateTime.Today.AddMonths(-1).ToString("yyyy-MM-dd") + "'";
Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'";
break;
case "5"://昨天
Condition += "vTime > '" + DateTime.Today.AddDays(-1).ToString("yyyy-MM-dd") + "'";
Condition += " and vTime < '" + DateTime.Today.ToString("yyyy-MM-dd") + "'";
break;
}
//获取选中的服务器
foreach (ListItem li in cblHost.Items)
{
if (li.Selected)
{
sParent += "," + li.Value + "";
selectedCount++;
}
}
//tedi3231 added 2010.02.01 没有选中任何站点时显示用户能看到的所有站点
if (sParent.Length <= 3)
{
sParent = common.GetHosrList(User.Identity.Name);
}
if (selectedCount < cblHost.Items.Count)
Condition += " and nParent in (" + sParent + ")";
if (txtSrcAddr.Text.ToString() != "")
Condition += " and vSrcAddr = dmc_config.dbo.[f_IP2int]('" + txtSrcAddr.Text.ToString() + "')";
if (txtSrcMac.Text.ToString() != "")
Condition += " and vSrcMac = '" + txtSrcMac.Text.ToString() + "'";
if (txtWeburl.Text.ToString() != "")
{
if (weburleq.Checked)
Condition += " and vURL = '" + txtWeburl.Text.ToString() + "'";
else
Condition += " and vURL like '%" + txtWeburl.Text.ToString().Trim() + "%'";
}
if (txtWebIP.Text.ToString() != "")
Condition += " and vDstAddr = dmc_config.dbo.[f_IP2int]('" + txtWebIP.Text.ToString() + "')";
int senstive = common.GetSenstiveCheck(this.CheckBoxList2);
if (senstive > 0)
Condition += " and ( (nKey & " + senstive + ")>0 ) ";
// 条件传给存储过程的时候，最前面不需要跟上and
if (!string.IsNullOrEmpty(Condition) && Condition.Length > 4 && Condition.Substring(0, 5) == " and ")
Condition = Condition.Substring(5);
}
}
//删除HTTP数据
protected void btnHttpDelete_Click(object sender, EventArgs e)
{
DateTime dteFromDate, dteToDate;
dteFromDate = Convert.ToDateTime(HttpStartDate.Value.ToString()).Date;
dteToDate = Convert.ToDateTime(HttpEndDate.Value.ToString()).Date;
dbHttpAll DB = new dbHttpAll();
DB.DelTables(dteFromDate, dteToDate);
}
