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(""); }