public override List <AdBrowseVO> GetModels(ref AdBrowsePara 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 <AdBrowseVO> list = new List <AdBrowseVO>(); for (int i = 0; i < table.Rows.Count; i++) { list.Add(new AdBrowseVO(table.Rows[i])); } if (!mp.Recount.HasValue) { mp.Recount = GetRecords(mp); } return(list); }
private void Bind(int pageIndex = 1) { AdBrowsePara cip = new AdBrowsePara(); cip.PageIndex = pageIndex - 1; cip.PageSize = 10; cip.FlowUserId = Account.UserId; cip.OrderBy = " id desc "; cip.Time = int.Parse(txtTime.Value.Replace("-", "")); if (!string.IsNullOrEmpty(ddlAdPage.SelectedValue)) { cip.AdId = int.Parse(ddlAdPage.SelectedValue); } if (!string.IsNullOrEmpty(hidAdUserId.Value)) { cip.AdUserId = int.Parse(hidAdUserId.Value); } var list = AdBrowseBLL.Instance.GetModels(ref cip); rptTable.DataSource = list; rptTable.DataBind(); apPager.RecordCount = cip.Recount.Value; }
public override string GetOrderByPara(AdBrowsePara mp) { if (!string.IsNullOrEmpty(mp.OrderBy)) { return(string.Format(" order by {0}", mp.OrderBy)); } return(""); }
public override AdBrowseVO GetSingle(AdBrowsePara mp) { var list = GetModels(mp); if (list.Count == 1) { return(list[0]); } return(null); }
public override int GetRecords(AdBrowsePara 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())); }
/// <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); } }
private void Bind(int pageIndex = 1) { AdBrowsePara cip = new AdBrowsePara(); cip.PageIndex = pageIndex - 1; cip.PageSize = 10; cip.OrderBy = " id desc "; var list = AdBrowseBLL.Instance.GetModels(ref cip); rptTable.DataSource = list; rptTable.DataBind(); apPager.RecordCount = cip.Recount.Value; }
public override bool Delete(AdBrowsePara 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 Bind(int pageIndex = 1) { AdBrowsePara cip = new AdBrowsePara(); cip.PageIndex = pageIndex - 1; cip.PageSize = 10; cip.Time = int.Parse(DateTime.Now.ToString("yyyyMMdd")); cip.OrderBy = " id desc "; if (!string.IsNullOrEmpty(ddlAdPage.SelectedValue)) { cip.AdId = int.Parse(ddlAdPage.SelectedValue); } var list = AdBrowseBLL.Instance.GetModels(ref cip); rptTable.DataSource = list; rptTable.DataBind(); apPager.RecordCount = cip.Recount.Value; }
public static string GetConditionByPara(AdBrowsePara mp) { StringBuilder sb = new StringBuilder(); if (mp.IsNotDay.HasValue) { if (mp.IsNotDay.Value) { sb.AppendFormat(" AND [Time] <> {0} ", DateTime.Now.ToString("yyyyMMdd")); } else { sb.AppendFormat(" AND [Time] = {0} ", DateTime.Now.ToString("yyyyMMdd")); } } if (mp.Ids != null && mp.Ids.Count != 0) { sb.AppendFormat(" and [Id] ({0}) ", string.Join(",", mp.Ids)); } return(sb.ToString()); }
public override List <AdBrowseVO> GetModels(AdBrowsePara 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 <AdBrowseVO> list = new List <AdBrowseVO>(); for (int i = 0; i < table.Rows.Count; i++) { list.Add(new AdBrowseVO(table.Rows[i])); } return(list); }
public override string GetOtherConditionByPara(AdBrowsePara mp) { return(""); }
public override string GetConditionByPara(AdBrowsePara mp) { StringBuilder sb = new StringBuilder(); if (mp.Id.HasValue) { sb.AppendFormat(" AND [Id]='{0}' ", mp.Id); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.Url))) { sb.AppendFormat(" AND [Url]='{0}' ", mp.Url); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ClientIp))) { sb.AppendFormat(" AND [ClientIp]='{0}' ", mp.ClientIp); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseType))) { sb.AppendFormat(" AND [BrowseType]='{0}' ", mp.BrowseType); } if (mp.CreateDate.HasValue) { sb.AppendFormat(" AND [CreateDate]='{0}' ", mp.CreateDate); } if (mp.AdId.HasValue) { sb.AppendFormat(" AND [AdId]='{0}' ", mp.AdId); } if (mp.AdUserId.HasValue) { sb.AppendFormat(" AND [AdUserId]='{0}' ", mp.AdUserId); } if (mp.FlowUserId.HasValue) { sb.AppendFormat(" AND [FlowUserId]='{0}' ", mp.FlowUserId); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.AdUrl))) { sb.AppendFormat(" AND [AdUrl]='{0}' ", mp.AdUrl); } if (mp.Money.HasValue) { sb.AppendFormat(" AND [Money]='{0}' ", mp.Money); } if (mp.IsMoney.HasValue) { sb.AppendFormat(" AND [IsMoney]='{0}' ", mp.IsMoney); } if (mp.Time.HasValue) { sb.AppendFormat(" AND [Time]='{0}' ", mp.Time); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ClientId))) { sb.AppendFormat(" AND [ClientId]='{0}' ", mp.ClientId); } if (mp.IsMobile.HasValue) { sb.AppendFormat(" AND [IsMobile]='{0}' ", mp.IsMobile); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.ReferrerUrl))) { sb.AppendFormat(" AND [ReferrerUrl]='{0}' ", mp.ReferrerUrl); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseName))) { sb.AppendFormat(" AND [BrowseName]='{0}' ", mp.BrowseName); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.BrowseVersion))) { sb.AppendFormat(" AND [BrowseVersion]='{0}' ", mp.BrowseVersion); } if (!string.IsNullOrEmpty(SqlFilterHelper.CheckPropertyName(mp.OsName))) { sb.AppendFormat(" AND [OsName]='{0}' ", mp.OsName); } sb.Insert(0, " WHERE 1=1 "); return(sb.ToString()); }