private void InsertResultRow(IpNeedToBan log, DataTable table)
{
var dr = table.NewRow();
dr[0] = log.IP;
dr[1] = log.RelatedURL;
dr[2] = log.Host;
dr[3] = log.RequestedTime;
dr[4] = log.HasBanned;
dr[5] = log.Remark;
table.Rows.Add(dr);
}
private void InsertIntoIpNeedToBanTable(IpNeedToBan ipNeedToBan, SqlConnection conn, SqlTransaction tran)
{
var sql = new StringBuilder(string.Format(@"IF NOT EXISTS(SELECT * FROM [dbo].[IpNeedToBan]
WHERE IP = '{0}'
)
INSERT INTO [dbo].[IpNeedToBan]
values ('{0}', '{1}' , '{2}','{3}', '{4}' , '{5}')
", ipNeedToBan.IP, ipNeedToBan.RelatedURL, ipNeedToBan.Host
, ipNeedToBan.RequestedTime, ipNeedToBan.HasBanned, ipNeedToBan.Remark));
var cmd = new SqlCommand(sql.ToString(), conn, tran);
cmd.ExecuteNonQuery();
}
public void InsertIntoIpNeedToBanTable(IpNeedToBan ipNeedToBan)
{
throw new NotImplementedException();
}
