public override bool Edit(LogBrowseHistoryVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Url", Value = ParameterHelper.ConvertValue(m.Url)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClientIp", Value = ParameterHelper.ConvertValue(m.ClientIp)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BrowseType", Value = ParameterHelper.ConvertValue(m.BrowseType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdUserId", Value = ParameterHelper.ConvertValue(m.AdUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FlowUserId", Value = ParameterHelper.ConvertValue(m.FlowUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdUrl", Value = ParameterHelper.ConvertValue(m.AdUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsMoney", Value = ParameterHelper.ConvertValue(m.IsMoney)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Time", Value = ParameterHelper.ConvertValue(m.Time)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClientId", Value = ParameterHelper.ConvertValue(m.ClientId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsMobile", Value = ParameterHelper.ConvertValue(m.IsMobile)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ReferrerUrl", Value = ParameterHelper.ConvertValue(m.ReferrerUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BrowseName", Value = ParameterHelper.ConvertValue(m.BrowseName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BrowseVersion", Value = ParameterHelper.ConvertValue(m.BrowseVersion)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@OsName", Value = ParameterHelper.ConvertValue(m.OsName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Country", Value = ParameterHelper.ConvertValue(m.Country)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Area", Value = ParameterHelper.ConvertValue(m.Area)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Region", Value = ParameterHelper.ConvertValue(m.Region)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@City", Value = ParameterHelper.ConvertValue(m.City)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@County", Value = ParameterHelper.ConvertValue(m.County)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Isp", Value = ParameterHelper.ConvertValue(m.Isp)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IpSource", Value = ParameterHelper.ConvertValue(m.IpSource)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override string GetOtherConditionByModel(LogBrowseHistoryVO m)
{
return("");
}
public override int InsertIdentityId(LogBrowseHistoryVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Url", Value = ParameterHelper.ConvertValue(m.Url)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClientIp", Value = ParameterHelper.ConvertValue(m.ClientIp)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BrowseType", Value = ParameterHelper.ConvertValue(m.BrowseType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdUserId", Value = ParameterHelper.ConvertValue(m.AdUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FlowUserId", Value = ParameterHelper.ConvertValue(m.FlowUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdUrl", Value = ParameterHelper.ConvertValue(m.AdUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsMoney", Value = ParameterHelper.ConvertValue(m.IsMoney)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Time", Value = ParameterHelper.ConvertValue(m.Time)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClientId", Value = ParameterHelper.ConvertValue(m.ClientId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsMobile", Value = ParameterHelper.ConvertValue(m.IsMobile)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ReferrerUrl", Value = ParameterHelper.ConvertValue(m.ReferrerUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BrowseName", Value = ParameterHelper.ConvertValue(m.BrowseName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@BrowseVersion", Value = ParameterHelper.ConvertValue(m.BrowseVersion)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@OsName", Value = ParameterHelper.ConvertValue(m.OsName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Country", Value = ParameterHelper.ConvertValue(m.Country)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Area", Value = ParameterHelper.ConvertValue(m.Area)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Region", Value = ParameterHelper.ConvertValue(m.Region)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@City", Value = ParameterHelper.ConvertValue(m.City)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@County", Value = ParameterHelper.ConvertValue(m.County)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Isp", Value = ParameterHelper.ConvertValue(m.Isp)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IpSource", Value = ParameterHelper.ConvertValue(m.IpSource)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override string GetOrderByModel(LogBrowseHistoryVO m)
{
return("");
}
