public override List <AdUserPageVO> GetModels(ref AdUserPagePara 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 <AdUserPageVO> list = new List <AdUserPageVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new AdUserPageVO(table.Rows[i]));
}
if (!mp.Recount.HasValue)
{
mp.Recount = GetRecords(mp);
}
return(list);
}
private void BindPage()
{
AdUserPagePara aup = new AdUserPagePara();
aup.AdPageId = int.Parse(hidId.Value);
aup.FlowUserId = Account.UserId;
var list = AdUserPageBLL.Instance.GetModels(aup);
if (list.Count == 0)
{
if (string.IsNullOrEmpty(txtPageName.Value))
{
txtPageName.Value = AdPageInfoBLL.Instance.GetPageName();
AdPageInfoBLL.Instance.CreateAdPage(txtPageName.Value, DN.WeiAd.Business.Config.AppConfig.TemplateName);
}
}
else
{
txtPageName.Value = list[0].PageName;
}
var info = AdPageInfoBLL.Instance.GetModelById(aup.AdPageId.Value);
if (info != null)
{
lnkPrview.NavigateUrl = AdPageInfoBLL.Instance.GetAdViewUrl(txtPageName.Value);
lnkPrview.Text = lnkPrview.NavigateUrl;
ltAdTitle.Text = info.Title;
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
AdUserPagePara aup = new AdUserPagePara();
aup.AdPageId = int.Parse(hidId.Value);
aup.FlowUserId = Account.UserId;
var list = AdUserPageBLL.Instance.GetModels(aup);
if (list.Count == 0)
{
var adpage = AdPageInfoBLL.Instance.GetSingle(new AdPageInfoPara()
{
Id = aup.AdPageId.Value
});
if (adpage != null)
{
AdUserPageVO info = new AdUserPageVO();
info.AdPageId = int.Parse(hidId.Value);
info.CreateDate = DateTime.Now;
info.CreateUserId = Account.UserId;
info.PageName = txtPageName.Value;
info.AdUserId = adpage.UserId;
info.FlowLastDate = DateTime.Now;
info.FlowUserId = Account.UserId;
info.Gid = Guid.NewGuid().ToString();
var plist = AdUserPageBLL.Instance.GetModels(new AdUserPagePara()
{
PageName = info.PageName
});
if (plist.Count == 0)
{
if (AdPageInfoBLL.Instance.CreateAdPage(info.PageName, DN.WeiAd.Business.Config.AppConfig.TemplateName, adpage.Id))
{
AdUserPageBLL.Instance.Add(info);
Response.Redirect("/AccFlow/Tasks/UserTaskList.aspx?state=0");
lblMsg.Text = "领取任务成功。";
}
else
{
lblMsg.Text = "领取任务失败，再试一试。";
}
}
else
{
lblMsg.Text = "该页面己经存在，重新添加任务一次。";
}
}
else
{
lblMsg.Text = "该广告己经不存，无法领取任务。";
}
}
else
{
lblMsg.Text = "您己经领取过该任务。";
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
AdUserPagePara aup = new AdUserPagePara();
aup.AdPageId = int.Parse(hidId.Value);
aup.FlowUserId = int.Parse(ddlFlow.SelectedValue);
var list = AdUserPageBLL.Instance.GetModels(aup);
if (list.Count == 0)
{
var adpage = AdPageInfoBLL.Instance.GetSingle(new AdPageInfoPara()
{
Id = aup.AdPageId.Value
});
if (adpage != null)
{
AdUserPageVO info = new AdUserPageVO();
info.AdPageId = int.Parse(hidId.Value);
info.CreateDate = DateTime.Now;
info.CreateUserId = Account.UserId;
info.PageName = txtPageName.Value;
info.AdUserId = adpage.UserId;
info.FlowLastDate = DateTime.Now;
info.FlowUserId = int.Parse(ddlFlow.SelectedValue);
info.Gid = Guid.NewGuid().ToString();
var plist = AdUserPageBLL.Instance.GetModels(new AdUserPagePara()
{
PageName = info.PageName
});
if (plist.Count == 0)
{
if (AdPageInfoBLL.Instance.CreateAdPage(info.PageName, ddlTemplate.SelectedValue, adpage.Id))
{
AdUserPageBLL.Instance.Add(info);
lblMsg.Text = "分配成功。";
}
else
{
lblMsg.Text = "分配成功失败，再试一试。";
}
}
else
{
lblMsg.Text = "该页面己经存在，重新添加任务一次。";
}
}
else
{
lblMsg.Text = "该广告己经不存，无法领取任务。";
}
}
else
{
lblMsg.Text = "该工作室中己存在该广告";
}
}
public override string GetOrderByPara(AdUserPagePara mp)
{
if (!string.IsNullOrEmpty(mp.OrderBy))
{
return(string.Format(" order by {0}", mp.OrderBy));
}
return("");
}
public override AdUserPageVO GetSingle(AdUserPagePara mp)
{
var list = GetModels(mp);
if (list.Count == 1)
{
return(list[0]);
}
return(null);
}
public override int GetRecords(AdUserPagePara 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()));
}
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());
}
protected void btnSave_Click(object sender, EventArgs e)
{
AdUserPagePara aup = new AdUserPagePara();
aup.PageName = txtPageName.Value;
var list = AdUserPageBLL.Instance.GetModels(aup);
if (list.Count == 0)
{
AdUserPageVO info = new AdUserPageVO();
info.AdPageId = int.Parse(hidId.Value);
info.CreateDate = DateTime.Now;
info.CreateUserId = Account.UserId;
info.PageName = txtPageName.Value;
info.FlowLastDate = DateTime.Now;
info.AdUserId = Account.UserId;
info.Gid = Guid.NewGuid().ToString();
if (AdPageInfoBLL.Instance.CreateAdPage(info.PageName, ddlTemplate.SelectedValue, int.Parse(hidId.Value)))
{
AdUserPageBLL.Instance.Add(info);
var adinfo = AdPageInfoBLL.Instance.GetSingle(new AdPageInfoPara()
{
Id = info.AdPageId
});
if (adinfo != null)
{
adinfo.PageCount = AdUserPageBLL.Instance.GetRecords(new AdUserPagePara()
{
AdPageId = info.AdPageId
});
adinfo.LastDate = DateTime.Now;
AdPageInfoBLL.Instance.Edit(adinfo);
}
lblMsg.Text = "页面创建成功。";
}
else
{
lblMsg.Text = "创建广告页失败，请联系管理员处理。";
}
}
else
{
lblMsg.Text = "该页面己经存在，请重新输入。";
}
}
private void Bind(int pageIndex = 1)
{
AdUserPagePara cip = new AdUserPagePara();
cip.PageIndex = pageIndex - 1;
cip.PageSize = 10;
cip.FlowUserId = Account.UserId;
cip.OrderBy = " id desc ";
cip.IsState = int.Parse(hidState.Value);
var list = AdUserPageBLL.Instance.GetModels(ref cip);
rptTable.DataSource = list;
rptTable.DataBind();
apPager.RecordCount = cip.Recount.Value;
}
public override bool Delete(AdUserPagePara 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);
}
private void BindPage()
{
var tlist = AdPageInfoBLL.Instance.GetTemplateSett();
ddlTemplate.Items.Clear();
foreach (var item in tlist)
{
ddlTemplate.Items.Add(item);
}
var ulist = AccountInfoBLL.Instance.GetModels(new AccountInfoPara()
{
UserType = 1
});
ddlFlow.DataSource = ulist;
ddlFlow.DataTextField = "NickName";
ddlFlow.DataValueField = "Id";
ddlFlow.DataBind();
AdUserPagePara aup = new AdUserPagePara();
aup.AdPageId = int.Parse(hidId.Value);
aup.FlowUserId = Account.UserId;
var list = AdUserPageBLL.Instance.GetModels(aup);
if (list.Count == 0)
{
txtPageName.Value = AdPageInfoBLL.Instance.GetPageName();
}
else
{
txtPageName.Value = list[0].PageName;
}
var info = AdPageInfoBLL.Instance.GetModelById(aup.AdPageId.Value);
if (info != null)
{
lnkPrview.NavigateUrl = string.Format("/Ad/{0}.aspx", info.ViewPage);
}
}
private void Bind(int pageIndex = 1)
{
AdUserPagePara cip = new AdUserPagePara();
cip.PageIndex = pageIndex - 1;
cip.PageSize = 10;
cip.FlowUserId = Account.UserId;
cip.OrderBy = " id desc ";
cip.IsState = int.Parse(hidState.Value);
var list = AdUserPageBLL.Instance.GetModels(ref cip);
rptTable.DataSource = list;
rptTable.DataBind();
QueryGroupInfo query = new QueryGroupInfo();
query.FlowUserId = Account.UserId;
query.Time = DateTime.Now;
query.GroupBy = "adid";
var table = AnalysisBLL.Instance.GetAnalysis(query);
for (int i = 0; i < rptTable.Items.Count; i++)
{
HiddenField hidAdId = (HiddenField)rptTable.Items[i].FindControl("hidAdId");
Literal ltPvCount = (Literal)rptTable.Items[i].FindControl("ltPvCount");
Literal ltUvCount = (Literal)rptTable.Items[i].FindControl("ltUvCount");
Literal ltIpCount = (Literal)rptTable.Items[i].FindControl("ltIpCount");
var rows = table.Select(string.Format("adid={0}", hidAdId.Value));
if (rows != null && rows.Count() != 0)
{
ltPvCount.Text = rows[0]["pvcount"].ToString();
ltUvCount.Text = rows[0]["uvcount"].ToString();
ltIpCount.Text = rows[0]["ipcount"].ToString();
}
}
apPager.RecordCount = cip.Recount.Value;
}
private string ReplaceMiddlePageHtml(string html, AdPageInfoVO info)
{
//有效域名
DomainInfoPara dp = new DomainInfoPara();
dp.IsAuth = 1;
dp.IsState = 0;
var list = DomainInfoBLL.Instance.GetModels(dp);
StringBuilder sbDomain = new StringBuilder();
foreach (var item in list)
{
sbDomain.AppendFormat("\"{0}\",", item.Domain);
}
if (sbDomain.Length != 0)
{
sbDomain = sbDomain.Remove(sbDomain.Length - 1, 1);
}
//有效页面
AdUserPagePara aup = new AdUserPagePara();
aup.AdPageId = info.Id;
var plist = AdUserPageBLL.Instance.GetModels(aup);
StringBuilder sbPage = new StringBuilder();
foreach (var item in plist)
{
sbPage.AppendFormat("\"{0}\",", item.PageName);
}
sbPage.AppendFormat("\"{0}\"", info.ViewPage);
html = html
.Replace("$domains$", sbDomain.ToString())
.Replace("$pages$", sbPage.ToString());
return(html);
}
private void Bind(int pageIndex = 1)
{
AdUserPagePara cip = new AdUserPagePara();
cip.PageIndex = pageIndex - 1;
cip.PageSize = 10;
if (!string.IsNullOrEmpty(ddlAdInfo.SelectedValue))
{
cip.AdPageId = int.Parse(ddlAdInfo.SelectedValue);
}
cip.AdPageId = int.Parse(hidAdId.Value);
cip.AdUserId = Account.UserId;
cip.OrderBy = " id desc ";
var list = AdUserPageBLL.Instance.GetModels(ref cip);
rptTable.DataSource = list;
rptTable.DataBind();
apPager.RecordCount = cip.Recount.Value;
apPager.PageSize = cip.PageSize.Value;
}
private void Bind(int pageIndex = 1)
{
AdUserPagePara cip = new AdUserPagePara();
cip.PageIndex = pageIndex - 1;
cip.PageSize = 10;
cip.AdPageId = int.Parse(hidAdId.Value);
cip.OrderBy = " id desc ";
var list = AdUserPageBLL.Instance.GetModels(ref cip);
rptTable.DataSource = list;
rptTable.DataBind();
DN.WeiAd.Business.Entity.Analysis.FlowInfo finfo = new DN.WeiAd.Business.Entity.Analysis.FlowInfo();
finfo.AdId = int.Parse(hidAdId.Value);
finfo.Time = DateTime.Now;
//var table = AnalysisAdBLL.Instance.GetAdFlowDetail(finfo);
for (int i = 0; i < rptTable.Items.Count; i++)
{
Literal ltPv = (Literal)rptTable.Items[i].FindControl("ltPv");
Literal ltUv = (Literal)rptTable.Items[i].FindControl("ltUv");
Literal ltIp = (Literal)rptTable.Items[i].FindControl("ltIp");
HiddenField hidFlowUserId = (HiddenField)rptTable.Items[i].FindControl("hidFlowUserId");
//var row = table.Select(string.Format("FlowUserId={0}", hidFlowUserId.Value));
//if(row!= null && row.Length >=1)
//{
// ltPv.Text = row[0]["pvcount"].ToString();
// ltUv.Text = row[0]["uvcount"].ToString();
// ltIp.Text = row[0]["ipcount"].ToString();
//}
}
apPager.RecordCount = cip.Recount.Value;
apPager.PageSize = cip.PageSize.Value;
}
public override List <AdUserPageVO> GetModels(AdUserPagePara 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 <AdUserPageVO> list = new List <AdUserPageVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new AdUserPageVO(table.Rows[i]));
}
return(list);
}
public override string GetOtherConditionByPara(AdUserPagePara mp)
{
return("");
}
