/// <summary>
/// 数据同步迁移
/// </summary>
/// <param name="time">默认是当前时间的前一天，格式：yyyyMMdd</param>
public void Synchronization(int time = 0)
{
if (time == 0)
{
time = int.Parse(DateTime.Now.AddDays(-1).ToString("yyyyMMdd"));
}
AdBrowsePara ap = new AdBrowsePara();
ap.IsNotDay = true;
ap.PageSize = 1000;
ap.PageIndex = 0;
List <AdBrowseVO> list = new List <AdBrowseVO>();
list = AdBrowseBLL.Instance.GetModels(ref ap);
while (list.Count != 0)
{
List <int> ids = new List <int>();
foreach (var item in list)
{
AdBrowseHistoryVO info = new AdBrowseHistoryVO();
info.AdId = item.AdId;
info.AdUrl = item.AdUrl;
info.BrowseType = item.BrowseType;
info.ClientIp = item.ClientIp;
info.CreateDate = item.CreateDate;
info.IsMoney = item.IsMoney;
info.Money = item.Money;
info.Time = item.Time;
info.Url = item.Url;
info.AdUserId = item.AdUserId;
AdBrowseHistoryBLL.Instance.Add(info);
ids.Add(item.Id);
//删除数据
//AdBrowseBLL.Instance.Delete(new AdBrowsePara() { Id = item.Id });
}
AdBrowseBLL.Instance.Delete(new AdBrowsePara()
{
Ids = ids
});
list = AdBrowseBLL.Instance.GetModels(ref ap);
}
}
public override bool Edit(AdBrowseHistoryVO 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 = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
});
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override string GetOtherConditionByModel(AdBrowseHistoryVO m)
{
return("");
}
public override int InsertIdentityId(AdBrowseHistoryVO 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)
});
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
public override string GetOrderByModel(AdBrowseHistoryVO m)
{
return("");
}
