public override int InsertIdentityId(VirAdInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LinkUrl", Value = ParameterHelper.ConvertValue(m.LinkUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Price", Value = ParameterHelper.ConvertValue(m.Price)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ShowCount", Value = ParameterHelper.ConvertValue(m.ShowCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClickCount", Value = ParameterHelper.ConvertValue(m.ClickCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@VaildClickCount", Value = ParameterHelper.ConvertValue(m.VaildClickCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IpCount", Value = ParameterHelper.ConvertValue(m.IpCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@MaxCount", Value = ParameterHelper.ConvertValue(m.MaxCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override bool Insert(VersionInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override bool Edit(SysAreaProvincesVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateTime", Value = ParameterHelper.ConvertValue(m.CreateTime)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override bool Insert(ChannelInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LinkUrl", Value = ParameterHelper.ConvertValue(m.LinkUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ImgUrl", Value = ParameterHelper.ConvertValue(m.ImgUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsShow", Value = ParameterHelper.ConvertValue(m.IsShow)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsHot", Value = ParameterHelper.ConvertValue(m.IsHot)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsTop", Value = ParameterHelper.ConvertValue(m.IsTop)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ColorValue", Value = ParameterHelper.ConvertValue(m.ColorValue)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LastDate", Value = ParameterHelper.ConvertValue(m.LastDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override int InsertIdentityId(UserCodeInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@TypeId", Value = ParameterHelper.ConvertValue(m.TypeId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CodeContent", Value = ParameterHelper.ConvertValue(m.CodeContent)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override int InsertIdentityId(SysAreaCityVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ParentId", Value = ParameterHelper.ConvertValue(m.ParentId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ZipCode", Value = ParameterHelper.ConvertValue(m.ZipCode)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateTime", Value = ParameterHelper.ConvertValue(m.CreateTime)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override int InsertIdentityId(PlayHistoryVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
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 = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdUrl", Value = ParameterHelper.ConvertValue(m.AdUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Time", Value = ParameterHelper.ConvertValue(m.Time)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money)
});
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 = "@ClientIp", Value = ParameterHelper.ConvertValue(m.ClientIp)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClientUv", Value = ParameterHelper.ConvertValue(m.ClientUv)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClientPv", Value = ParameterHelper.ConvertValue(m.ClientPv)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Price", Value = ParameterHelper.ConvertValue(m.Price)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
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 bool Edit(AdUserPageVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Gid", Value = ParameterHelper.ConvertValue(m.Gid)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PageName", Value = ParameterHelper.ConvertValue(m.PageName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdPageId", Value = ParameterHelper.ConvertValue(m.AdPageId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdUserId", Value = ParameterHelper.ConvertValue(m.AdUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsState", Value = ParameterHelper.ConvertValue(m.IsState)
});
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 = "@FlowUserId", Value = ParameterHelper.ConvertValue(m.FlowUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FlowLastDate", Value = ParameterHelper.ConvertValue(m.FlowLastDate)
});
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 bool Edit(FtpInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Domains", Value = ParameterHelper.ConvertValue(m.Domains)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpServer", Value = ParameterHelper.ConvertValue(m.FtpServer)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpUserName", Value = ParameterHelper.ConvertValue(m.FtpUserName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpPassword", Value = ParameterHelper.ConvertValue(m.FtpPassword)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsSynchronization", Value = ParameterHelper.ConvertValue(m.IsSynchronization)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CloseDate", Value = ParameterHelper.ConvertValue(m.CloseDate)
});
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 bool Insert(ProductInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Price", Value = ParameterHelper.ConvertValue(m.Price)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AttrText", Value = ParameterHelper.ConvertValue(m.AttrText)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AttrStyle", Value = ParameterHelper.ConvertValue(m.AttrStyle)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsState", Value = ParameterHelper.ConvertValue(m.IsState)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsDelete", Value = ParameterHelper.ConvertValue(m.IsDelete)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override int InsertIdentityId(ChannelInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LinkUrl", Value = ParameterHelper.ConvertValue(m.LinkUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ImgUrl", Value = ParameterHelper.ConvertValue(m.ImgUrl)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsShow", Value = ParameterHelper.ConvertValue(m.IsShow)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsHot", Value = ParameterHelper.ConvertValue(m.IsHot)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsTop", Value = ParameterHelper.ConvertValue(m.IsTop)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ColorValue", Value = ParameterHelper.ConvertValue(m.ColorValue)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LastDate", Value = ParameterHelper.ConvertValue(m.LastDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override bool Insert(HistoryUserLogBrowseVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Time", Value = ParameterHelper.ConvertValue(m.Time)
});
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 = "@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 = "@Price", Value = ParameterHelper.ConvertValue(m.Price)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override bool Edit(AdSiteInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@WebSite", Value = ParameterHelper.ConvertValue(m.WebSite)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LastDate", Value = ParameterHelper.ConvertValue(m.LastDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PlatformType", Value = ParameterHelper.ConvertValue(m.PlatformType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Contact", Value = ParameterHelper.ConvertValue(m.Contact)
});
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 bool Edit(LogIpInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Ip", Value = ParameterHelper.ConvertValue(m.Ip)
});
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 = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
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 bool Edit(ServerInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ServerId", Value = ParameterHelper.ConvertValue(m.ServerId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Ip", Value = ParameterHelper.ConvertValue(m.Ip)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsState", Value = ParameterHelper.ConvertValue(m.IsState)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UpdateDate", Value = ParameterHelper.ConvertValue(m.UpdateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
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(HistoryUserLogBrowseVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Time", Value = ParameterHelper.ConvertValue(m.Time)
});
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 = "@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 = "@Price", Value = ParameterHelper.ConvertValue(m.Price)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override int InsertIdentityId(ProductInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdId", Value = ParameterHelper.ConvertValue(m.AdId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Price", Value = ParameterHelper.ConvertValue(m.Price)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AttrText", Value = ParameterHelper.ConvertValue(m.AttrText)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AttrStyle", Value = ParameterHelper.ConvertValue(m.AttrStyle)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsState", Value = ParameterHelper.ConvertValue(m.IsState)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsDelete", Value = ParameterHelper.ConvertValue(m.IsDelete)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override bool Edit(LogLoginVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginName", Value = ParameterHelper.ConvertValue(m.LoginName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginState", Value = ParameterHelper.ConvertValue(m.LoginState)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginDesc", Value = ParameterHelper.ConvertValue(m.LoginDesc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginDate", Value = ParameterHelper.ConvertValue(m.LoginDate)
});
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 = "@LoginType", Value = ParameterHelper.ConvertValue(m.LoginType)
});
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 bool Edit(VirAdLogBrowseVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ShowCount", Value = ParameterHelper.ConvertValue(m.ShowCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClickCount", Value = ParameterHelper.ConvertValue(m.ClickCount)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@VaildClickCount", Value = ParameterHelper.ConvertValue(m.VaildClickCount)
});
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 = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override bool Edit(AdQcodeInfoVO 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 = "@AdUserId", Value = ParameterHelper.ConvertValue(m.AdUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@QcodeUrl", Value = ParameterHelper.ConvertValue(m.QcodeUrl)
});
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 = "@QcodeUrl2", Value = ParameterHelper.ConvertValue(m.QcodeUrl2)
});
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(FtpInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Desc", Value = ParameterHelper.ConvertValue(m.Desc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Domains", Value = ParameterHelper.ConvertValue(m.Domains)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpServer", Value = ParameterHelper.ConvertValue(m.FtpServer)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpUserName", Value = ParameterHelper.ConvertValue(m.FtpUserName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FtpPassword", Value = ParameterHelper.ConvertValue(m.FtpPassword)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsSynchronization", Value = ParameterHelper.ConvertValue(m.IsSynchronization)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CloseDate", Value = ParameterHelper.ConvertValue(m.CloseDate)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override int InsertIdentityId(AdUserPageVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Gid", Value = ParameterHelper.ConvertValue(m.Gid)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@PageName", Value = ParameterHelper.ConvertValue(m.PageName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdPageId", Value = ParameterHelper.ConvertValue(m.AdPageId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@AdUserId", Value = ParameterHelper.ConvertValue(m.AdUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsState", Value = ParameterHelper.ConvertValue(m.IsState)
});
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 = "@FlowUserId", Value = ParameterHelper.ConvertValue(m.FlowUserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@FlowLastDate", Value = ParameterHelper.ConvertValue(m.FlowLastDate)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override bool Edit(UserFinanceHistoryVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@RechargeType", Value = ParameterHelper.ConvertValue(m.RechargeType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@MoneyType", Value = ParameterHelper.ConvertValue(m.MoneyType)
});
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 = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override int InsertIdentityId(LogIpInfoVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Ip", Value = ParameterHelper.ConvertValue(m.Ip)
});
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 = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override int InsertIdentityId(LogLoginVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginName", Value = ParameterHelper.ConvertValue(m.LoginName)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginState", Value = ParameterHelper.ConvertValue(m.LoginState)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginDesc", Value = ParameterHelper.ConvertValue(m.LoginDesc)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@LoginDate", Value = ParameterHelper.ConvertValue(m.LoginDate)
});
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 = "@LoginType", Value = ParameterHelper.ConvertValue(m.LoginType)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override int InsertIdentityId(UserFinanceHistoryVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@RechargeType", Value = ParameterHelper.ConvertValue(m.RechargeType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Money", Value = ParameterHelper.ConvertValue(m.Money)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@MoneyType", Value = ParameterHelper.ConvertValue(m.MoneyType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override bool Edit(DomainSynchroHistoryVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = EDIT;
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ServerId", Value = ParameterHelper.ConvertValue(m.ServerId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@MainDomain", Value = ParameterHelper.ConvertValue(m.MainDomain)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Domains", Value = ParameterHelper.ConvertValue(m.Domains)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@DomainPath", Value = ParameterHelper.ConvertValue(m.DomainPath)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@OperType", Value = ParameterHelper.ConvertValue(m.OperType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsSynchro", Value = ParameterHelper.ConvertValue(m.IsSynchro)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@SynchroDate", Value = ParameterHelper.ConvertValue(m.SynchroDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClientIp", Value = ParameterHelper.ConvertValue(m.ClientIp)
});
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 = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
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(DomainSynchroHistoryVO m)
{
CodeCommand command = new CodeCommand();
command.CommandText = INSERT + "; select @@Identity";
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ServerId", Value = ParameterHelper.ConvertValue(m.ServerId)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@MainDomain", Value = ParameterHelper.ConvertValue(m.MainDomain)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@Domains", Value = ParameterHelper.ConvertValue(m.Domains)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@DomainPath", Value = ParameterHelper.ConvertValue(m.DomainPath)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@OperType", Value = ParameterHelper.ConvertValue(m.OperType)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@IsSynchro", Value = ParameterHelper.ConvertValue(m.IsSynchro)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@SynchroDate", Value = ParameterHelper.ConvertValue(m.SynchroDate)
});
command.Parameters.Add(new SqlParameter()
{
ParameterName = "@ClientIp", Value = ParameterHelper.ConvertValue(m.ClientIp)
});
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 = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
});
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 bool Edit(LogBrowseVO 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);
}