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()); }