protected void ExtendedGridView1_RowCommand(object sender, CommandEventArgs e)
{
if ((e.CommandName == "EditIP") || (e.CommandName == "DelIP"))
{
GridViewRow row = ((GridView)sender).Rows[Convert.ToInt32(e.CommandArgument)];
string commandName = e.CommandName;
if (commandName != null)
{
if (!(commandName == "EditIP"))
{
if (!(commandName == "DelIP"))
{
return;
}
}
else
{
this.Context.Items.Add("startIP", ((Label)row.FindControl("LblStartIP")).Text);
this.Context.Items.Add("endIP", ((Label)row.FindControl("LblEndIP")).Text);
this.Context.Items.Add("address", row.Cells[2].Text);
base.Server.Transfer("IPAdd.aspx?Action=Edit");
return;
}
StatIPInfo info = new StatIPInfo();
info.StartIP = StringHelper.EncodeIP(((Label)row.FindControl("LblStartIP")).Text);
info.EndIP = StringHelper.EncodeIP(((Label)row.FindControl("LblEndIP")).Text);
if (IPStorage.Delete(info))
{
this.ExtendedGridView1.DataBind();
}
}
}
}
public bool Delete(StatIPInfo info)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@StartIp", DbType.Double, info.StartIP);
cmdParams.AddInParameter("@EndIp", DbType.Double, info.EndIP);
return(DBHelper.ExecuteProc("PR_Analytics_StatIPInfo_Delete", cmdParams));
}
private static StatIPInfo StatIPInfoListFromrdr(NullableDataReader rdr)
{
StatIPInfo info = new StatIPInfo();
info.StartIP = rdr.GetDouble("StartIp");
info.EndIP = rdr.GetDouble("EndIp");
info.Address = rdr.GetString("Address");
return(info);
}
public bool Add(StatIPInfo info)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@StartIp", DbType.Double, info.StartIP);
cmdParams.AddInParameter("@EndIp", DbType.Double, info.EndIP);
cmdParams.AddInParameter("@Address", DbType.String, info.Address);
return(DBHelper.ExecuteProc("PR_Analytics_StatIPInfo_Add", cmdParams));
}
private static void CompareIP(StatIPInfo info)
{
if (info.StartIP > info.EndIP)
{
double startIP = info.StartIP;
info.StartIP = info.EndIP;
info.EndIP = startIP;
}
}
public bool Update(StatIPInfo newInfo, StatIPInfo oldInfo)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@StartIp", DbType.Double, newInfo.StartIP);
cmdParams.AddInParameter("@EndIp", DbType.Double, newInfo.EndIP);
cmdParams.AddInParameter("@Address", DbType.String, newInfo.Address);
cmdParams.AddInParameter("@oldStartIp", DbType.Double, oldInfo.StartIP);
cmdParams.AddInParameter("@oldEndIp", DbType.Double, oldInfo.EndIP);
return(DBHelper.ExecuteNonQueryProc("PR_Analytics_StatIPInfo_Update", cmdParams) > 0);
}
private void AddIP()
{
StatIPInfo info = new StatIPInfo();
info.StartIP = StringHelper.EncodeIP(this.TxtStartIP.Text);
info.EndIP = StringHelper.EncodeIP(this.TxtEndIP.Text);
CompareIP(info);
info.Address = DataSecurity.FilterBadChar(this.TxtIPAddress.Text);
if (IPStorage.Add(info))
{
AdminPage.WriteSuccessMsg("网站统计IP添加成功！", "IPAdd.aspx");
}
else
{
AdminPage.WriteErrMsg("<li>网站统计IP添加失败，添加的IP地址段与系统已存在的记录重叠或来源详细地址重复！</li>");
}
}
private void EditIP()
{
StatIPInfo info = new StatIPInfo();
StatIPInfo oldInfo = new StatIPInfo();
info.StartIP = StringHelper.EncodeIP(this.TxtStartIP.Text);
info.EndIP = StringHelper.EncodeIP(this.TxtEndIP.Text);
info.Address = DataSecurity.FilterBadChar(this.TxtIPAddress.Text);
oldInfo.StartIP = StringHelper.EncodeIP(this.HdnOldStartIP.Value);
oldInfo.EndIP = StringHelper.EncodeIP(this.HdnOldEndIP.Value);
CompareIP(info);
if (IPStorage.Update(info, oldInfo))
{
AdminPage.WriteSuccessMsg("网站统计IP修改成功！", "IPManage.aspx");
}
else
{
AdminPage.WriteErrMsg("<li>网站统计IP修改失败，修改的IP地址段与系统已存在的记录重叠或来源详细地址重复！</li>");
}
}
public static bool Update(StatIPInfo newInfo, StatIPInfo oldInfo)
{
return(dal.Update(newInfo, oldInfo));
}
public static bool Delete(StatIPInfo info)
{
return(dal.Delete(info));
}
public static bool Add(StatIPInfo info)
{
return(dal.Add(info));
}
