public override bool Edit(SummaryAdDayHistoryVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@TimeId", Value = ParameterHelper.ConvertValue(m.TimeId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PvCount", Value = ParameterHelper.ConvertValue(m.PvCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UvCount", Value = ParameterHelper.ConvertValue(m.UvCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IpCount", Value = ParameterHelper.ConvertValue(m.IpCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsDelete", Value = ParameterHelper.ConvertValue(m.IsDelete)
});
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 int InsertIdentityId(SummaryAdDayHistoryVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@TimeId", Value = ParameterHelper.ConvertValue(m.TimeId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PvCount", Value = ParameterHelper.ConvertValue(m.PvCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UvCount", Value = ParameterHelper.ConvertValue(m.UvCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IpCount", Value = ParameterHelper.ConvertValue(m.IpCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsDelete", Value = ParameterHelper.ConvertValue(m.IsDelete)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override string GetOtherConditionByModel(SummaryAdDayHistoryVO m)
{
return("");
}
public override string GetOrderByModel(SummaryAdDayHistoryVO m)
{
return("");
}
