private void BindPage()
{
AdPageInfoPara adp = new AdPageInfoPara();
adp.UserId = Account.UserId;
var adlist = AdPageInfoBLL.Instance.GetModels(adp);
ddlAd.Items.Clear();
foreach (var item in adlist)
{
ddlAd.Items.Add(new ListItem()
{
Value = item.Id.ToString(), Text = string.Format("{0}-{1}", item.Id, item.Title)
});
}
var ulist = AccountInfoBLL.Instance.GetModels(new AccountInfoPara()
{
UserType = 3
});
ddlCpsUser.DataSource = ulist;
ddlCpsUser.DataTextField = "UserName";
ddlCpsUser.DataValueField = "Id";
ddlCpsUser.DataBind();
}
private void BindPage()
{
AdPageInfoPara app = new AdPageInfoPara();
app.UserId = int.Parse(hidUserId.Value);
var list = AdPageInfoBLL.Instance.GetModels(app);
List <AdDomainItem> dlist = new List <AdDomainItem>();
foreach (var item in list)
{
if (!string.IsNullOrEmpty(item.DomainList))
{
var tlist = item.DomainList.Split(',');
foreach (var url in tlist)
{
if (!string.IsNullOrEmpty(url))
{
AdDomainItem domain = new AdDomainItem();
domain.Url = url;
if (!dlist.Contains(domain))
{
dlist.Add(domain);
}
}
}
}
}
rptDomain.DataSource = dlist;
rptDomain.DataBind();
}
public override List <AdPageInfoVO> GetModels(ref AdPageInfoPara 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 <AdPageInfoVO> list = new List <AdPageInfoVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new AdPageInfoVO(table.Rows[i]));
}
if (!mp.Recount.HasValue)
{
mp.Recount = GetRecords(mp);
}
return(list);
}
private void BindPage()
{
AdPageInfoPara adp = new AdPageInfoPara();
adp.UserId = Account.UserId;
var adlist = AdPageInfoBLL.Instance.GetModels(adp);
ddlAd.Items.Clear();
foreach (var item in adlist)
{
ddlAd.Items.Add(new ListItem()
{
Value = item.Id.ToString(), Text = string.Format("{0}-{1}", item.Id, item.Title)
});
}
if (!string.IsNullOrEmpty(hidId.Value))
{
var info = ProductInfoBLL.Instance.GetSingle(new ProductInfoPara()
{
Id = int.Parse(hidId.Value), CreateUserId = Account.UserId
});
if (info != null)
{
txtDesc.Text = info.Desc;
txtName.Text = info.Name;
txtPrice.Text = info.Price.ToString();
txtAttr.Text = info.AttrText;
ddlAd.SelectedValue = info.AdId.ToString();
btnEdit.Visible = true;
}
}
btnSave.Visible = !btnEdit.Visible;
}
private void Bind(int pageIndex = 1)
{
AdPageInfoPara cip = new AdPageInfoPara();
cip.PageIndex = pageIndex - 1;
cip.PageSize = 10;
cip.IsDel = 1;
cip.UserId = Account.UserId;
cip.OrderBy = " id desc ";
if (!string.IsNullOrEmpty(ddlUserAdType.SelectedValue))
{
cip.UserAdTypeId = int.Parse(ddlUserAdType.SelectedValue);
}
if (!string.IsNullOrEmpty(ddlSiteType.SelectedValue))
{
cip.SiteTypeId = int.Parse(ddlSiteType.SelectedValue);
}
if (!string.IsNullOrEmpty(txtDesc.Value))
{
cip.LikeDesc = txtDesc.Value;
}
var list = AdPageInfoBLL.Instance.GetModels(ref cip);
rptTable.DataSource = list;
rptTable.DataBind();
apPager.RecordCount = cip.Recount.Value;
}
public override string GetOrderByPara(AdPageInfoPara mp)
{
if (!string.IsNullOrEmpty(mp.OrderBy))
{
return(string.Format(" order by {0}", mp.OrderBy));
}
return("");
}
private void BindPage()
{
AdPageInfoPara adp = new AdPageInfoPara();
var adlist = AdPageInfoBLL.Instance.GetModels(adp);
var ulist = AccountInfoBLL.Instance.GetModels(new AccountInfoPara()
{
IsNotAdmin = true
});
ddlAd.Items.Clear();
foreach (var item in adlist)
{
string nick = "";
var user = ulist.SingleOrDefault(p => p.Id == item.UserId);
if (user != null)
{
nick = user.NickName;
}
ddlAd.Items.Add(new ListItem()
{
Value = item.Id.ToString(), Text = string.Format("用户ID={2}-{3}，广告ID={0}-{1}", item.Id, item.Title, item.UserId, nick)
});
}
ddlAdUserName.Items.Clear();
foreach (var item in ulist)
{
ddlAdUserName.Items.Add(new ListItem()
{
Text = item.UserName + AccountInfoBLL.Instance.GetUserTypeNameById(item.UserType), Value = item.Id.ToString()
});
}
if (!string.IsNullOrEmpty(hidId.Value))
{
var info = ProductInfoBLL.Instance.GetSingle(new ProductInfoPara()
{
Id = int.Parse(hidId.Value)
});
if (info != null)
{
txtDesc.Text = info.Desc;
txtName.Text = info.Name;
txtPrice.Text = info.Price.ToString();
txtAttr.Text = info.AttrText;
ddlAd.SelectedValue = info.AdId.ToString();
ddlAdUserName.SelectedValue = info.CreateUserId.ToString();
btnEdit.Visible = true;
}
}
btnSave.Visible = !btnEdit.Visible;
}
public override AdPageInfoVO GetSingle(AdPageInfoPara mp)
{
var list = GetModels(mp);
if (list.Count == 1)
{
return(list[0]);
}
return(null);
}
public override int GetRecords(AdPageInfoPara 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)
{
AdPageInfoPara app = new AdPageInfoPara();
app.PageIndex = pageIndex - 1;
app.PageSize = 10;
app.UserId = Account.UserId;
var list = AdPageInfoBLL.Instance.GetModels(ref app);
rptTable.DataSource = list;
rptTable.DataBind();
}
private void Bind(int pageIndex = 1)
{
AdPageInfoPara cip = new AdPageInfoPara();
cip.PageIndex = pageIndex - 1;
cip.PageSize = 10;
cip.UserId = Account.UserId;
cip.OrderBy = " id desc ";
var list = AdPageInfoBLL.Instance.GetModels(ref cip);
rptTable.DataSource = list;
rptTable.DataBind();
apPager.RecordCount = cip.Recount.Value;
}
public override bool Delete(AdPageInfoPara 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()
{
AdPageInfoPara ap = new AdPageInfoPara();
ap.UserId = Account.UserId;
var list = AdPageInfoBLL.Instance.GetModels(ap);
ddlAdInfo.DataSource = list;
ddlAdInfo.DataTextField = "Title";
ddlAdInfo.DataValueField = "Id";
ddlAdInfo.DataBind();
ddlAdInfo.Items.Insert(0, new ListItem()
{
Text = "不限", Value = ""
});
if (!string.IsNullOrEmpty(hidAdId.Value))
{
ddlAdInfo.SelectedValue = hidAdId.Value;
ddlAdInfo.Enabled = false;
}
}
public override List <AdPageInfoVO> GetModels(AdPageInfoPara 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 <AdPageInfoVO> list = new List <AdPageInfoVO>();
for (int i = 0; i < table.Rows.Count; i++)
{
list.Add(new AdPageInfoVO(table.Rows[i]));
}
return(list);
}
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 GetOtherConditionByPara(AdPageInfoPara mp)
{
return("");
}
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());
}
