public override string GetConditionByPara(SysAreaCityPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (mp.ParentId.HasValue)
{
sb.AppendFormat(" AND [ParentId]='{0}' ", mp.ParentId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ZipCode)))
{
sb.AppendFormat(" AND [ZipCode]='{0}' ", mp.ZipCode);
}
if (mp.CreateTime.HasValue)
{
sb.AppendFormat(" AND [CreateTime]='{0}' ", mp.CreateTime);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(UserCodeInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (mp.UserId.HasValue)
{
sb.AppendFormat(" AND [UserId]='{0}' ", mp.UserId);
}
if (mp.TypeId.HasValue)
{
sb.AppendFormat(" AND [TypeId]='{0}' ", mp.TypeId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.CodeContent)))
{
sb.AppendFormat(" AND [CodeContent]='{0}' ", mp.CodeContent);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(ChannelInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Desc)))
{
sb.AppendFormat(" AND [Desc]='{0}' ", mp.Desc);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.LinkUrl)))
{
sb.AppendFormat(" AND [LinkUrl]='{0}' ", mp.LinkUrl);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ImgUrl)))
{
sb.AppendFormat(" AND [ImgUrl]='{0}' ", mp.ImgUrl);
}
if (mp.IsShow.HasValue)
{
sb.AppendFormat(" AND [IsShow]='{0}' ", mp.IsShow);
}
if (mp.IsHot.HasValue)
{
sb.AppendFormat(" AND [IsHot]='{0}' ", mp.IsHot);
}
if (mp.IsTop.HasValue)
{
sb.AppendFormat(" AND [IsTop]='{0}' ", mp.IsTop);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ColorValue)))
{
sb.AppendFormat(" AND [ColorValue]='{0}' ", mp.ColorValue);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.LastDate.HasValue)
{
sb.AppendFormat(" AND [LastDate]='{0}' ", mp.LastDate);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(ProductInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Desc)))
{
sb.AppendFormat(" AND [Desc]='{0}' ", mp.Desc);
}
if (mp.AdId.HasValue)
{
sb.AppendFormat(" AND [AdId]='{0}' ", mp.AdId);
}
if (mp.Price.HasValue)
{
sb.AppendFormat(" AND [Price]='{0}' ", mp.Price);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.AttrText)))
{
sb.AppendFormat(" AND [AttrText]='{0}' ", mp.AttrText);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.AttrStyle)))
{
sb.AppendFormat(" AND [AttrStyle]='{0}' ", mp.AttrStyle);
}
if (mp.IsState.HasValue)
{
sb.AppendFormat(" AND [IsState]='{0}' ", mp.IsState);
}
if (mp.IsDelete.HasValue)
{
sb.AppendFormat(" AND [IsDelete]='{0}' ", mp.IsDelete);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(FtpInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Desc)))
{
sb.AppendFormat(" AND [Desc]='{0}' ", mp.Desc);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Domains)))
{
sb.AppendFormat(" AND [Domains]='{0}' ", mp.Domains);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.FtpServer)))
{
sb.AppendFormat(" AND [FtpServer]='{0}' ", mp.FtpServer);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.FtpUserName)))
{
sb.AppendFormat(" AND [FtpUserName]='{0}' ", mp.FtpUserName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.FtpPassword)))
{
sb.AppendFormat(" AND [FtpPassword]='{0}' ", mp.FtpPassword);
}
if (mp.IsSynchronization.HasValue)
{
sb.AppendFormat(" AND [IsSynchronization]='{0}' ", mp.IsSynchronization);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.CloseDate.HasValue)
{
sb.AppendFormat(" AND [CloseDate]='{0}' ", mp.CloseDate);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(AdUserPagePara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Gid)))
{
sb.AppendFormat(" AND [Gid]='{0}' ", mp.Gid);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.PageName)))
{
sb.AppendFormat(" AND [PageName]='{0}' ", mp.PageName);
}
if (mp.AdPageId.HasValue)
{
sb.AppendFormat(" AND [AdPageId]='{0}' ", mp.AdPageId);
}
if (mp.AdUserId.HasValue)
{
sb.AppendFormat(" AND [AdUserId]='{0}' ", mp.AdUserId);
}
if (mp.IsState.HasValue)
{
sb.AppendFormat(" AND [IsState]='{0}' ", mp.IsState);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
if (mp.FlowUserId.HasValue)
{
sb.AppendFormat(" AND [FlowUserId]='{0}' ", mp.FlowUserId);
}
if (mp.FlowLastDate.HasValue)
{
sb.AppendFormat(" AND [FlowLastDate]='{0}' ", mp.FlowLastDate);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(AdSiteInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Desc)))
{
sb.AppendFormat(" AND [Desc]='{0}' ", mp.Desc);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.WebSite)))
{
sb.AppendFormat(" AND [WebSite]='{0}' ", mp.WebSite);
}
if (mp.UserId.HasValue)
{
sb.AppendFormat(" AND [UserId]='{0}' ", mp.UserId);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.LastDate.HasValue)
{
sb.AppendFormat(" AND [LastDate]='{0}' ", mp.LastDate);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.PlatformType)))
{
sb.AppendFormat(" AND [PlatformType]='{0}' ", mp.PlatformType);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Contact)))
{
sb.AppendFormat(" AND [Contact]='{0}' ", mp.Contact);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(LogIpInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Ip)))
{
sb.AppendFormat(" AND [Ip]='{0}' ", mp.Ip);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.country)))
{
sb.AppendFormat(" AND [country]='{0}' ", mp.country);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.area)))
{
sb.AppendFormat(" AND [area]='{0}' ", mp.area);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.region)))
{
sb.AppendFormat(" AND [region]='{0}' ", mp.region);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.city)))
{
sb.AppendFormat(" AND [city]='{0}' ", mp.city);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.county)))
{
sb.AppendFormat(" AND [county]='{0}' ", mp.county);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.isp)))
{
sb.AppendFormat(" AND [isp]='{0}' ", mp.isp);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(ServerInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ServerId)))
{
sb.AppendFormat(" AND [ServerId]='{0}' ", mp.ServerId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Desc)))
{
sb.AppendFormat(" AND [Desc]='{0}' ", mp.Desc);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Ip)))
{
sb.AppendFormat(" AND [Ip]='{0}' ", mp.Ip);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.IsState.HasValue)
{
sb.AppendFormat(" AND [IsState]='{0}' ", mp.IsState);
}
if (mp.UpdateDate.HasValue)
{
sb.AppendFormat(" AND [UpdateDate]='{0}' ", mp.UpdateDate);
}
if (mp.UserId.HasValue)
{
sb.AppendFormat(" AND [UserId]='{0}' ", mp.UserId);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(AdQcodeInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (mp.AdId.HasValue)
{
sb.AppendFormat(" AND [AdId]='{0}' ", mp.AdId);
}
if (mp.AdUserId.HasValue)
{
sb.AppendFormat(" AND [AdUserId]='{0}' ", mp.AdUserId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.QcodeUrl)))
{
sb.AppendFormat(" AND [QcodeUrl]='{0}' ", mp.QcodeUrl);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.QcodeUrl2)))
{
sb.AppendFormat(" AND [QcodeUrl2]='{0}' ", mp.QcodeUrl2);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(LogLoginPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.LoginName)))
{
sb.AppendFormat(" AND [LoginName]='{0}' ", mp.LoginName);
}
if (mp.LoginState.HasValue)
{
sb.AppendFormat(" AND [LoginState]='{0}' ", mp.LoginState);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.LoginDesc)))
{
sb.AppendFormat(" AND [LoginDesc]='{0}' ", mp.LoginDesc);
}
if (mp.LoginDate.HasValue)
{
sb.AppendFormat(" AND [LoginDate]='{0}' ", mp.LoginDate);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ClientIp)))
{
sb.AppendFormat(" AND [ClientIp]='{0}' ", mp.ClientIp);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseType)))
{
sb.AppendFormat(" AND [BrowseType]='{0}' ", mp.BrowseType);
}
if (mp.LoginType.HasValue)
{
sb.AppendFormat(" AND [LoginType]='{0}' ", mp.LoginType);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
protected override void BindGrid()
{
using (var cmd = new SqlCommand())
{
cmd.CommandText = SelectAllFromTable;
if (IsFiltered)
{
var sql = string.Empty;
sql = SqlFilterHelper.GetWhereClause("Name", cboxName.Text, true, txtName.Text.Trim());
if (sql.Length > 0)
{
cmd.CommandText += " WHERE " + sql;
}
}
cmd.CommandText += " ORDER BY ModifiedDate DESC";
ds.VW_CardType.Clear();
ds.VW_CardType.Merge(DictionaryManager.GetDataTable(cmd));
}
}
public static string GetConditionByPara(AdPageInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.FlowUserTask.HasValue)
{
sb.AppendFormat(" AND NOT ID IN (select AdPageId from [dbo].[AdUserPage] where FlowUserId={0})", mp.FlowUserTask);
}
if (mp.FlowUserRunning.HasValue)
{
sb.AppendFormat(" AND NOT ID IN (select AdPageId from [dbo].[AdUserPage] where FlowUserId={0} AND IsState=0 )", mp.FlowUserRunning);
}
if (mp.FlowUserClosed.HasValue)
{
sb.AppendFormat(" AND NOT ID IN (select AdPageId from [dbo].[AdUserPage] where FlowUserId={0} AND IsState=1 )", mp.FlowUserClosed);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.LikeDesc)))
{
sb.AppendFormat(" AND [Desc] like '%{0}%' ", mp.LikeDesc);
}
return(sb.ToString());
}
public override string GetConditionByPara(LogBrowsePara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Url)))
{
sb.AppendFormat(" AND [Url]='{0}' ", mp.Url);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ClientIp)))
{
sb.AppendFormat(" AND [ClientIp]='{0}' ", mp.ClientIp);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseType)))
{
sb.AppendFormat(" AND [BrowseType]='{0}' ", mp.BrowseType);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.AdId.HasValue)
{
sb.AppendFormat(" AND [AdId]='{0}' ", mp.AdId);
}
if (mp.AdUserId.HasValue)
{
sb.AppendFormat(" AND [AdUserId]='{0}' ", mp.AdUserId);
}
if (mp.FlowUserId.HasValue)
{
sb.AppendFormat(" AND [FlowUserId]='{0}' ", mp.FlowUserId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.AdUrl)))
{
sb.AppendFormat(" AND [AdUrl]='{0}' ", mp.AdUrl);
}
if (mp.Money.HasValue)
{
sb.AppendFormat(" AND [Money]='{0}' ", mp.Money);
}
if (mp.IsMoney.HasValue)
{
sb.AppendFormat(" AND [IsMoney]='{0}' ", mp.IsMoney);
}
if (mp.Time.HasValue)
{
sb.AppendFormat(" AND [Time]='{0}' ", mp.Time);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ClientId)))
{
sb.AppendFormat(" AND [ClientId]='{0}' ", mp.ClientId);
}
if (mp.IsMobile.HasValue)
{
sb.AppendFormat(" AND [IsMobile]='{0}' ", mp.IsMobile);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ReferrerUrl)))
{
sb.AppendFormat(" AND [ReferrerUrl]='{0}' ", mp.ReferrerUrl);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseName)))
{
sb.AppendFormat(" AND [BrowseName]='{0}' ", mp.BrowseName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseVersion)))
{
sb.AppendFormat(" AND [BrowseVersion]='{0}' ", mp.BrowseVersion);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.OsName)))
{
sb.AppendFormat(" AND [OsName]='{0}' ", mp.OsName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Country)))
{
sb.AppendFormat(" AND [Country]='{0}' ", mp.Country);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Area)))
{
sb.AppendFormat(" AND [Area]='{0}' ", mp.Area);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Region)))
{
sb.AppendFormat(" AND [Region]='{0}' ", mp.Region);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.City)))
{
sb.AppendFormat(" AND [City]='{0}' ", mp.City);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.County)))
{
sb.AppendFormat(" AND [County]='{0}' ", mp.County);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Isp)))
{
sb.AppendFormat(" AND [Isp]='{0}' ", mp.Isp);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.IpSource)))
{
sb.AppendFormat(" AND [IpSource]='{0}' ", mp.IpSource);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(LogQcodeInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.CopyText)))
{
sb.AppendFormat(" AND [CopyText]='{0}' ", mp.CopyText);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Url)))
{
sb.AppendFormat(" AND [Url]='{0}' ", mp.Url);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ClientIp)))
{
sb.AppendFormat(" AND [ClientIp]='{0}' ", mp.ClientIp);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseType)))
{
sb.AppendFormat(" AND [BrowseType]='{0}' ", mp.BrowseType);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND convert(varchar(10), [CreateDate], 120) = convert(varchar(10), '{0}',120) ", mp.CreateDate.Value.ToString("yyyy-MM-dd"));
}
if (mp.Money.HasValue)
{
sb.AppendFormat(" AND [Money]='{0}' ", mp.Money);
}
if (mp.IsMoney.HasValue)
{
sb.AppendFormat(" AND [IsMoney]='{0}' ", mp.IsMoney);
}
if (mp.Time.HasValue)
{
sb.AppendFormat(" AND [Time]='{0}' ", mp.Time);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ClientId)))
{
sb.AppendFormat(" AND [ClientId]='{0}' ", mp.ClientId);
}
if (mp.IsMobile.HasValue)
{
sb.AppendFormat(" AND [IsMobile]='{0}' ", mp.IsMobile);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ReferrerUrl)))
{
sb.AppendFormat(" AND [ReferrerUrl]='{0}' ", mp.ReferrerUrl);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseName)))
{
sb.AppendFormat(" AND [BrowseName]='{0}' ", mp.BrowseName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseVersion)))
{
sb.AppendFormat(" AND [BrowseVersion]='{0}' ", mp.BrowseVersion);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.OsName)))
{
sb.AppendFormat(" AND [OsName]='{0}' ", mp.OsName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Country)))
{
sb.AppendFormat(" AND [Country]='{0}' ", mp.Country);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Area)))
{
sb.AppendFormat(" AND [Area]='{0}' ", mp.Area);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Region)))
{
sb.AppendFormat(" AND [Region]='{0}' ", mp.Region);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.City)))
{
sb.AppendFormat(" AND [City]='{0}' ", mp.City);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.County)))
{
sb.AppendFormat(" AND [County]='{0}' ", mp.County);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Isp)))
{
sb.AppendFormat(" AND [Isp]='{0}' ", mp.Isp);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.IpSource)))
{
sb.AppendFormat(" AND [IpSource]='{0}' ", mp.IpSource);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(DomainInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Domain)))
{
sb.AppendFormat(" AND [Domain]='{0}' ", mp.Domain);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.PageName)))
{
sb.AppendFormat(" AND [PageName]='{0}' ", mp.PageName);
}
if (mp.IsState.HasValue)
{
sb.AppendFormat(" AND [IsState]='{0}' ", mp.IsState);
}
if (mp.IsAuth.HasValue)
{
sb.AppendFormat(" AND [IsAuth]='{0}' ", mp.IsAuth);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.CityName)))
{
sb.AppendFormat(" AND [CityName]='{0}' ", mp.CityName);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
if (mp.IsColse.HasValue)
{
sb.AppendFormat(" AND [IsColse]='{0}' ", mp.IsColse);
}
if (mp.ColseDate.HasValue)
{
sb.AppendFormat(" AND [ColseDate]='{0}' ", mp.ColseDate);
}
if (mp.CloseUserId.HasValue)
{
sb.AppendFormat(" AND [CloseUserId]='{0}' ", mp.CloseUserId);
}
if (mp.AdUserId.HasValue)
{
sb.AppendFormat(" AND [AdUserId]='{0}' ", mp.AdUserId);
}
if (mp.IsResolution.HasValue)
{
sb.AppendFormat(" AND [IsResolution]='{0}' ", mp.IsResolution);
}
if (mp.ResolutionDate.HasValue)
{
sb.AppendFormat(" AND [ResolutionDate]='{0}' ", mp.ResolutionDate);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.SerName)))
{
sb.AppendFormat(" AND [SerName]='{0}' ", mp.SerName);
}
if (mp.ResolutionType.HasValue)
{
sb.AppendFormat(" AND [ResolutionType]='{0}' ", mp.ResolutionType);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(PlayHistoryPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (mp.AdUserId.HasValue)
{
sb.AppendFormat(" AND [AdUserId]='{0}' ", mp.AdUserId);
}
if (mp.FlowUserId.HasValue)
{
sb.AppendFormat(" AND [FlowUserId]='{0}' ", mp.FlowUserId);
}
if (mp.AdId.HasValue)
{
sb.AppendFormat(" AND [AdId]='{0}' ", mp.AdId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.AdUrl)))
{
sb.AppendFormat(" AND [AdUrl]='{0}' ", mp.AdUrl);
}
if (mp.Time.HasValue)
{
sb.AppendFormat(" AND [Time]='{0}' ", mp.Time);
}
if (mp.Money.HasValue)
{
sb.AppendFormat(" AND [Money]='{0}' ", mp.Money);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
if (mp.ClientIp.HasValue)
{
sb.AppendFormat(" AND [ClientIp]='{0}' ", mp.ClientIp);
}
if (mp.ClientUv.HasValue)
{
sb.AppendFormat(" AND [ClientUv]='{0}' ", mp.ClientUv);
}
if (mp.ClientPv.HasValue)
{
sb.AppendFormat(" AND [ClientPv]='{0}' ", mp.ClientPv);
}
if (mp.Price.HasValue)
{
sb.AppendFormat(" AND [Price]='{0}' ", mp.Price);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(CustomerInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.AdUrl)))
{
sb.AppendFormat(" AND [AdUrl]='{0}' ", mp.AdUrl);
}
if (mp.AdId.HasValue)
{
sb.AppendFormat(" AND [AdId]='{0}' ", mp.AdId);
}
if (mp.AdUserId.HasValue)
{
sb.AppendFormat(" AND [AdUserId]='{0}' ", mp.AdUserId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.RealName)))
{
sb.AppendFormat(" AND [RealName]='{0}' ", mp.RealName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Phone)))
{
sb.AppendFormat(" AND [Phone]='{0}' ", mp.Phone);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.WeiXinNum)))
{
sb.AppendFormat(" AND [WeiXinNum]='{0}' ", mp.WeiXinNum);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Remark)))
{
sb.AppendFormat(" AND [Remark]='{0}' ", mp.Remark);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Address)))
{
sb.AppendFormat(" AND [Address]='{0}' ", mp.Address);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserCountry)))
{
sb.AppendFormat(" AND [UserCountry]='{0}' ", mp.UserCountry);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserRegion)))
{
sb.AppendFormat(" AND [UserRegion]='{0}' ", mp.UserRegion);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserCity)))
{
sb.AppendFormat(" AND [UserCity]='{0}' ", mp.UserCity);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ClientIp)))
{
sb.AppendFormat(" AND [ClientIp]='{0}' ", mp.ClientIp);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ClientId)))
{
sb.AppendFormat(" AND [ClientId]='{0}' ", mp.ClientId);
}
if (mp.IsMobile.HasValue)
{
sb.AppendFormat(" AND [IsMobile]='{0}' ", mp.IsMobile);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ReferrerUrl)))
{
sb.AppendFormat(" AND [ReferrerUrl]='{0}' ", mp.ReferrerUrl);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseName)))
{
sb.AppendFormat(" AND [BrowseName]='{0}' ", mp.BrowseName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseVersion)))
{
sb.AppendFormat(" AND [BrowseVersion]='{0}' ", mp.BrowseVersion);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.OsName)))
{
sb.AppendFormat(" AND [OsName]='{0}' ", mp.OsName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Country)))
{
sb.AppendFormat(" AND [Country]='{0}' ", mp.Country);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Area)))
{
sb.AppendFormat(" AND [Area]='{0}' ", mp.Area);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Region)))
{
sb.AppendFormat(" AND [Region]='{0}' ", mp.Region);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.City)))
{
sb.AppendFormat(" AND [City]='{0}' ", mp.City);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.County)))
{
sb.AppendFormat(" AND [County]='{0}' ", mp.County);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Isp)))
{
sb.AppendFormat(" AND [Isp]='{0}' ", mp.Isp);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.IpSource)))
{
sb.AppendFormat(" AND [IpSource]='{0}' ", mp.IpSource);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND convert(varchar(10), [CreateDate], 120) = convert(varchar(10), '{0}',120) ", mp.CreateDate.Value.ToString("yyyy-MM-dd"));
}
if (mp.Num.HasValue)
{
sb.AppendFormat(" AND [Num]='{0}' ", mp.Num);
}
if (mp.Price.HasValue)
{
sb.AppendFormat(" AND [Price]='{0}' ", mp.Price);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ProducteName)))
{
sb.AppendFormat(" AND [ProducteName]='{0}' ", mp.ProducteName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Color)))
{
sb.AppendFormat(" AND [Color]='{0}' ", mp.Color);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Size)))
{
sb.AppendFormat(" AND [Size]='{0}' ", mp.Size);
}
if (mp.IsDelete.HasValue)
{
sb.AppendFormat(" AND [IsDelete]='{0}' ", mp.IsDelete);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserAttr)))
{
sb.AppendFormat(" AND [UserAttr]='{0}' ", mp.UserAttr);
}
if (mp.CheckState.HasValue)
{
sb.AppendFormat(" AND [CheckState]='{0}' ", mp.CheckState);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.CheckRemark)))
{
sb.AppendFormat(" AND [CheckRemark]='{0}' ", mp.CheckRemark);
}
if (mp.IsExport.HasValue)
{
sb.AppendFormat(" AND [IsExport]='{0}' ", mp.IsExport);
}
if (mp.ExportUserId.HasValue)
{
sb.AppendFormat(" AND [ExportUserId]='{0}' ", mp.ExportUserId);
}
if (mp.ExportDate.HasValue)
{
sb.AppendFormat(" AND convert(varchar(10), [ExportDate], 120) = convert(varchar(10), '{0}',120) ", mp.ExportDate.Value.ToString("yyyy-MM-dd"));
}
sb.Append(CustomerInfoAccessOther.GetConditionByPara(mp));
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(ArticleInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (mp.ChannelId.HasValue)
{
sb.AppendFormat(" AND [ChannelId]='{0}' ", mp.ChannelId);
}
if (mp.ArticleTypeId.HasValue)
{
sb.AppendFormat(" AND [ArticleTypeId]='{0}' ", mp.ArticleTypeId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Title)))
{
sb.AppendFormat(" AND [Title]='{0}' ", mp.Title);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.TitleImg)))
{
sb.AppendFormat(" AND [TitleImg]='{0}' ", mp.TitleImg);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.TitleShort)))
{
sb.AppendFormat(" AND [TitleShort]='{0}' ", mp.TitleShort);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.LinkUrl)))
{
sb.AppendFormat(" AND [LinkUrl]='{0}' ", mp.LinkUrl);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.PageKey)))
{
sb.AppendFormat(" AND [PageKey]='{0}' ", mp.PageKey);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.PageDesc)))
{
sb.AppendFormat(" AND [PageDesc]='{0}' ", mp.PageDesc);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ConetntShort)))
{
sb.AppendFormat(" AND [ConetntShort]='{0}' ", mp.ConetntShort);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Content)))
{
sb.AppendFormat(" AND [Content]='{0}' ", mp.Content);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ContentGroup)))
{
sb.AppendFormat(" AND [ContentGroup]='{0}' ", mp.ContentGroup);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Lable)))
{
sb.AppendFormat(" AND [Lable]='{0}' ", mp.Lable);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Source)))
{
sb.AppendFormat(" AND [Source]='{0}' ", mp.Source);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.EditUser)))
{
sb.AppendFormat(" AND [EditUser]='{0}' ", mp.EditUser);
}
if (mp.IsContributions.HasValue)
{
sb.AppendFormat(" AND [IsContributions]='{0}' ", mp.IsContributions);
}
if (mp.IsState.HasValue)
{
sb.AppendFormat(" AND [IsState]='{0}' ", mp.IsState);
}
if (mp.IsShow.HasValue)
{
sb.AppendFormat(" AND [IsShow]='{0}' ", mp.IsShow);
}
if (mp.ContributionsUserId.HasValue)
{
sb.AppendFormat(" AND [ContributionsUserId]='{0}' ", mp.ContributionsUserId);
}
if (mp.OrderIndex.HasValue)
{
sb.AppendFormat(" AND [OrderIndex]='{0}' ", mp.OrderIndex);
}
if (mp.IsHot.HasValue)
{
sb.AppendFormat(" AND [IsHot]='{0}' ", mp.IsHot);
}
if (mp.IsHeadline.HasValue)
{
sb.AppendFormat(" AND [IsHeadline]='{0}' ", mp.IsHeadline);
}
if (mp.IsTop.HasValue)
{
sb.AppendFormat(" AND [IsTop]='{0}' ", mp.IsTop);
}
if (mp.OpenCount.HasValue)
{
sb.AppendFormat(" AND [OpenCount]='{0}' ", mp.OpenCount);
}
if (mp.CommentCount.HasValue)
{
sb.AppendFormat(" AND [CommentCount]='{0}' ", mp.CommentCount);
}
if (mp.LikeCount.HasValue)
{
sb.AppendFormat(" AND [LikeCount]='{0}' ", mp.LikeCount);
}
if (mp.StepCount.HasValue)
{
sb.AppendFormat(" AND [StepCount]='{0}' ", mp.StepCount);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.LastDate.HasValue)
{
sb.AppendFormat(" AND [LastDate]='{0}' ", mp.LastDate);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
if (mp.AuditUserId.HasValue)
{
sb.AppendFormat(" AND [AuditUserId]='{0}' ", mp.AuditUserId);
}
if (mp.AuditState.HasValue)
{
sb.AppendFormat(" AND [AuditState]='{0}' ", mp.AuditState);
}
if (mp.AuditDate.HasValue)
{
sb.AppendFormat(" AND [AuditDate]='{0}' ", mp.AuditDate);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.AuditDesc)))
{
sb.AppendFormat(" AND [AuditDesc]='{0}' ", mp.AuditDesc);
}
if (mp.IsAd.HasValue)
{
sb.AppendFormat(" AND [IsAd]='{0}' ", mp.IsAd);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(VirAdInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (mp.UserId.HasValue)
{
sb.AppendFormat(" AND [UserId]='{0}' ", mp.UserId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Desc)))
{
sb.AppendFormat(" AND [Desc]='{0}' ", mp.Desc);
}
if (mp.LinkUrl.HasValue)
{
sb.AppendFormat(" AND [LinkUrl]='{0}' ", mp.LinkUrl);
}
if (mp.Price.HasValue)
{
sb.AppendFormat(" AND [Price]='{0}' ", mp.Price);
}
if (mp.ShowCount.HasValue)
{
sb.AppendFormat(" AND [ShowCount]='{0}' ", mp.ShowCount);
}
if (mp.ClickCount.HasValue)
{
sb.AppendFormat(" AND [ClickCount]='{0}' ", mp.ClickCount);
}
if (mp.VaildClickCount.HasValue)
{
sb.AppendFormat(" AND [VaildClickCount]='{0}' ", mp.VaildClickCount);
}
if (mp.IpCount.HasValue)
{
sb.AppendFormat(" AND [IpCount]='{0}' ", mp.IpCount);
}
if (mp.MaxCount.HasValue)
{
sb.AppendFormat(" AND [MaxCount]='{0}' ", mp.MaxCount);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(AccountInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserName)))
{
sb.AppendFormat(" AND [UserName]='{0}' ", mp.UserName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.NickName)))
{
sb.AppendFormat(" AND [NickName]='{0}' ", mp.NickName);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Email)))
{
sb.AppendFormat(" AND [Email]='{0}' ", mp.Email);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Phone)))
{
sb.AppendFormat(" AND [Phone]='{0}' ", mp.Phone);
}
if (mp.UserType.HasValue)
{
sb.AppendFormat(" AND [UserType]='{0}' ", mp.UserType);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserPwd)))
{
sb.AppendFormat(" AND [UserPwd]='{0}' ", mp.UserPwd);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserImg)))
{
sb.AppendFormat(" AND [UserImg]='{0}' ", mp.UserImg);
}
if (mp.RegDate.HasValue)
{
sb.AppendFormat(" AND [RegDate]='{0}' ", mp.RegDate);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.RegIp)))
{
sb.AppendFormat(" AND [RegIp]='{0}' ", mp.RegIp);
}
if (mp.IsLock.HasValue)
{
sb.AppendFormat(" AND [IsLock]='{0}' ", mp.IsLock);
}
if (mp.LastLoginDate.HasValue)
{
sb.AppendFormat(" AND [LastLoginDate]='{0}' ", mp.LastLoginDate);
}
if (mp.AccountType.HasValue)
{
sb.AppendFormat(" AND [AccountType]='{0}' ", mp.AccountType);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.OpenId)))
{
sb.AppendFormat(" AND [OpenId]='{0}' ", mp.OpenId);
}
if (mp.ConsumptionMoney.HasValue)
{
sb.AppendFormat(" AND [ConsumptionMoney]='{0}' ", mp.ConsumptionMoney);
}
if (mp.Money.HasValue)
{
sb.AppendFormat(" AND [Money]='{0}' ", mp.Money);
}
if (mp.MoneyFree.HasValue)
{
sb.AppendFormat(" AND [MoneyFree]='{0}' ", mp.MoneyFree);
}
if (mp.MoneyCount.HasValue)
{
sb.AppendFormat(" AND [MoneyCount]='{0}' ", mp.MoneyCount);
}
if (mp.LastMoneyDate.HasValue)
{
sb.AppendFormat(" AND [LastMoneyDate]='{0}' ", mp.LastMoneyDate);
}
sb.AppendLine(AccountInfoAccessOther.GetConditionByPara(mp));
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(DomainSynchroHistoryPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (mp.ServerId.HasValue)
{
sb.AppendFormat(" AND [ServerId]='{0}' ", mp.ServerId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Name)))
{
sb.AppendFormat(" AND [Name]='{0}' ", mp.Name);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.MainDomain)))
{
sb.AppendFormat(" AND [MainDomain]='{0}' ", mp.MainDomain);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Domains)))
{
sb.AppendFormat(" AND [Domains]='{0}' ", mp.Domains);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.DomainPath)))
{
sb.AppendFormat(" AND [DomainPath]='{0}' ", mp.DomainPath);
}
if (mp.OperType.HasValue)
{
sb.AppendFormat(" AND [OperType]='{0}' ", mp.OperType);
}
if (mp.IsSynchro.HasValue)
{
sb.AppendFormat(" AND [IsSynchro]='{0}' ", mp.IsSynchro);
}
if (mp.SynchroDate.HasValue)
{
sb.AppendFormat(" AND [SynchroDate]='{0}' ", mp.SynchroDate);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ClientIp)))
{
sb.AppendFormat(" AND [ClientIp]='{0}' ", mp.ClientIp);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
if (mp.UserId.HasValue)
{
sb.AppendFormat(" AND [UserId]='{0}' ", mp.UserId);
}
if (mp.IsDelete.HasValue)
{
sb.AppendFormat(" AND [IsDelete]='{0}' ", mp.IsDelete);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override string GetConditionByPara(AdPageInfoPara mp)
{
StringBuilder sb = new StringBuilder();
if (mp.Id.HasValue)
{
sb.AppendFormat(" AND [Id]='{0}' ", mp.Id);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.WeiXinUrl)))
{
sb.AppendFormat(" AND [WeiXinUrl]='{0}' ", mp.WeiXinUrl);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Title)))
{
sb.AppendFormat(" AND [Title]='{0}' ", mp.Title);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.TitleImg)))
{
sb.AppendFormat(" AND [TitleImg]='{0}' ", mp.TitleImg);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.QcodeImg)))
{
sb.AppendFormat(" AND [QcodeImg]='{0}' ", mp.QcodeImg);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Content)))
{
sb.AppendFormat(" AND [Content]='{0}' ", mp.Content);
}
if (mp.AdType.HasValue)
{
sb.AppendFormat(" AND [AdType]='{0}' ", mp.AdType);
}
if (mp.CreateDate.HasValue)
{
sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate);
}
if (mp.LastDate.HasValue)
{
sb.AppendFormat(" AND [LastDate]='{0}' ", mp.LastDate);
}
if (mp.UserId.HasValue)
{
sb.AppendFormat(" AND [UserId]='{0}' ", mp.UserId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ViewPage)))
{
sb.AppendFormat(" AND [ViewPage]='{0}' ", mp.ViewPage);
}
if (mp.UserCodeId.HasValue)
{
sb.AppendFormat(" AND [UserCodeId]='{0}' ", mp.UserCodeId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserCodeIds)))
{
sb.AppendFormat(" AND [UserCodeIds]='{0}' ", mp.UserCodeIds);
}
if (mp.IsState.HasValue)
{
sb.AppendFormat(" AND [IsState]='{0}' ", mp.IsState);
}
if (mp.Money.HasValue)
{
sb.AppendFormat(" AND [Money]='{0}' ", mp.Money);
}
if (mp.SaleType.HasValue)
{
sb.AppendFormat(" AND [SaleType]='{0}' ", mp.SaleType);
}
if (mp.PlanIp.HasValue)
{
sb.AppendFormat(" AND [PlanIp]='{0}' ", mp.PlanIp);
}
if (mp.StartTime.HasValue)
{
sb.AppendFormat(" AND [StartTime]='{0}' ", mp.StartTime);
}
if (mp.PlanTerminal.HasValue)
{
sb.AppendFormat(" AND [PlanTerminal]='{0}' ", mp.PlanTerminal);
}
if (mp.MoneyCount.HasValue)
{
sb.AppendFormat(" AND [MoneyCount]='{0}' ", mp.MoneyCount);
}
if (mp.BuyMoney.HasValue)
{
sb.AppendFormat(" AND [BuyMoney]='{0}' ", mp.BuyMoney);
}
if (mp.OrderIndex.HasValue)
{
sb.AppendFormat(" AND [OrderIndex]='{0}' ", mp.OrderIndex);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.UserCode)))
{
sb.AppendFormat(" AND [UserCode]='{0}' ", mp.UserCode);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.TitleShort)))
{
sb.AppendFormat(" AND [TitleShort]='{0}' ", mp.TitleShort);
}
if (mp.BuyIp.HasValue)
{
sb.AppendFormat(" AND [BuyIp]='{0}' ", mp.BuyIp);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.TemplateName)))
{
sb.AppendFormat(" AND [TemplateName]='{0}' ", mp.TemplateName);
}
if (mp.IsDel.HasValue)
{
sb.AppendFormat(" AND [IsDel]='{0}' ", mp.IsDel);
}
if (mp.IsAuth.HasValue)
{
sb.AppendFormat(" AND [IsAuth]='{0}' ", mp.IsAuth);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.StaticContent)))
{
sb.AppendFormat(" AND [StaticContent]='{0}' ", mp.StaticContent);
}
if (mp.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.MiddlePage)))
{
sb.AppendFormat(" AND [MiddlePage]='{0}' ", mp.MiddlePage);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.AdTimeStart)))
{
sb.AppendFormat(" AND [AdTimeStart]='{0}' ", mp.AdTimeStart);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.AdTimeEnd)))
{
sb.AppendFormat(" AND [AdTimeEnd]='{0}' ", mp.AdTimeEnd);
}
if (mp.UserAdTypeId.HasValue)
{
sb.AppendFormat(" AND [UserAdTypeId]='{0}' ", mp.UserAdTypeId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Desc)))
{
sb.AppendFormat(" AND [Desc]='{0}' ", mp.Desc);
}
if (mp.SiteTypeId.HasValue)
{
sb.AppendFormat(" AND [SiteTypeId]='{0}' ", mp.SiteTypeId);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.PlatformType)))
{
sb.AppendFormat(" AND [PlatformType]='{0}' ", mp.PlatformType);
}
if (mp.DeleteDate.HasValue)
{
sb.AppendFormat(" AND [DeleteDate]='{0}' ", mp.DeleteDate);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.DefaultQcode)))
{
sb.AppendFormat(" AND [DefaultQcode]='{0}' ", mp.DefaultQcode);
}
if (mp.QcodeCount.HasValue)
{
sb.AppendFormat(" AND [QcodeCount]='{0}' ", mp.QcodeCount);
}
if (mp.PageCount.HasValue)
{
sb.AppendFormat(" AND [PageCount]='{0}' ", mp.PageCount);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.QcodeImg2)))
{
sb.AppendFormat(" AND [QcodeImg2]='{0}' ", mp.QcodeImg2);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.DefaultQcode2)))
{
sb.AppendFormat(" AND [DefaultQcode2]='{0}' ", mp.DefaultQcode2);
}
if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.DomainList)))
{
sb.AppendFormat(" AND [DomainList]='{0}' ", mp.DomainList);
}
sb.Append(AdPageInfoAccessOther.GetConditionByPara(mp));
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
