public override List <VirAdBrowseVO> GetModels(ref VirAdBrowsePara mp)
{
string where = GetConditionByPara(mp);
int pStart = mp.PageIndex.Value * mp.PageSize.Value;
int pEnd = mp.PageSize.Value;
string cmd = QUERYPAGE
.Replace("@PAGESIZE", pEnd.ToString())
.Replace("@PTOP", pStart.ToString())
.Replace("@WHERE", where)
.Replace("@ORDER", GetOrderByPara(mp));
CodeCommand command = new CodeCommand();
command.CommandText = cmd;
var table = DbProxyFactory.Instance.Proxy.ExecuteTable(command);
List <VirAdBrowseVO> list = new List <VirAdBrowseVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new VirAdBrowseVO(table.Rows[i]));
}
if (!mp.Recount.HasValue)
{
mp.Recount = GetRecords(mp);
}
return(list);
}
private void Bind()
{
QueryGroupInfo query = new QueryGroupInfo();
query.TimeStart = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01"));
query.GroupBy = "AdId";
query.OrderBy = " AdId desc ";
query.AdUserID = Account.UserId;
DataTable table = LogBrowseAnalysisBLL.Instance.GetAnalysis(query);
VirAdBrowsePara adp = new VirAdBrowsePara();
for (int i = 0; i < table.Rows.Count; i++)
{
int AdId = int.Parse(table.Rows[i]["AdId"].ToString());
int ipcount = int.Parse(table.Rows[i]["ipcount"].ToString());
adp.AdId = AdId;
var list = VirAdBrowseBLL.Instance.GetModels(adp);
foreach (var item in list)
{
ipcount += item.IpCount;
}
table.Rows[i]["ipcount"] = ipcount;
}
rptTable.DataSource = table;
rptTable.DataBind();
}
public override string GetOrderByPara(VirAdBrowsePara mp)
{
if (!string.IsNullOrEmpty(mp.OrderBy))
{
return(string.Format(" order by {0}", mp.OrderBy));
}
return("");
}
public override VirAdBrowseVO GetSingle(VirAdBrowsePara mp)
{
var list = GetModels(mp);
if (list.Count == 1)
{
return(list[0]);
}
return(null);
}
public override int GetRecords(VirAdBrowsePara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
command.CommandText = QUERYCOUNT + where;
var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);
return(int.Parse(result.ToString()));
}
private void Bind(int pageIndex = 1)
{
VirAdBrowsePara adp = new VirAdBrowsePara();
adp.PageIndex = pageIndex - 1;
adp.PageSize = 10;
adp.OrderBy = " id desc ";
var list = VirAdBrowseBLL.Instance.GetModels(ref adp);
rptTable.DataSource = list;
rptTable.DataBind();
apPager.RecordCount = adp.Recount.Value;
}
public override bool Delete(VirAdBrowsePara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
command.CommandText = DELETE + where;
int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);
if (result >= 1)
{
return(true);
}
return(false);
}
public override string GetConditionByPara(VirAdBrowsePara 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.IpCount.HasValue)
{
sb.AppendFormat(" AND [IpCount]='{0}' ", mp.IpCount);
}
if (mp.PvCount.HasValue)
{
sb.AppendFormat(" AND [PvCount]='{0}' ", mp.PvCount);
}
if (mp.UvCount.HasValue)
{
sb.AppendFormat(" AND [UvCount]='{0}' ", mp.UvCount);
}
if (mp.TimeId.HasValue)
{
sb.AppendFormat(" AND [TimeId]='{0}' ", mp.TimeId);
}
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.CreateUserId.HasValue)
{
sb.AppendFormat(" AND [CreateUserId]='{0}' ", mp.CreateUserId);
}
if (mp.IsDelete.HasValue)
{
sb.AppendFormat(" AND [IsDelete]='{0}' ", mp.IsDelete);
}
sb.Insert(0, " WHERE 1=1 ");
return(sb.ToString());
}
public override List <VirAdBrowseVO> GetModels(VirAdBrowsePara mp)
{
string where = GetConditionByPara(mp);
CodeCommand command = new CodeCommand();
string cmd = LOAD
.Replace("@WHERE", where)
.Replace("@ORDER", GetOrderByPara(mp));
command.CommandText = cmd;
var table = DbProxyFactory.Instance.Proxy.ExecuteTable(command);
List <VirAdBrowseVO> list = new List <VirAdBrowseVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new VirAdBrowseVO(table.Rows[i]));
}
return(list);
}
public override string GetOtherConditionByPara(VirAdBrowsePara mp)
{
return("");
}
