/// <summary> /// 广告计划 /// </summary> /// <returns></returns> public JsonResult GetAdPlanList() { try { int page = !string.IsNullOrEmpty(Request["page"]) ? Convert.ToInt32(Request["page"]) : 1; int limit = !string.IsNullOrEmpty(Request["limit"]) ? Convert.ToInt32(Request["limit"]) : 10; var ADName = Request["ADName"] ?? ""; var BusinessPlanID = Request["BusinessPlanID"] ?? ""; var startLaunchTime = Request["startLaunchTime"] ?? ""; var endLaunchTime = Request["endLaunchTime"] ?? ""; var Status = Request["Status"] ?? ""; var ADPlanID = Request["ADPlanID"] ?? ""; var NewAdPlanID = Request["NewAdPlanID"] ?? ""; var paramRequest = new CreativePlanRequest { PageIndex = page, PageSize = limit, ADName = ADName, BusinessPlanID = BusinessPlanID, endLaunchTime = endLaunchTime, startLaunchTime = startLaunchTime, Status = Status, IsAdmin = true, NewAdPlanID = NewAdPlanID, AdPlanID = ADPlanID }; if (paramRequest.PageIndex == 0) { paramRequest.PageIndex = 1; } else { paramRequest.PageIndex = (paramRequest.PageIndex / 10) + 1; } var result = creativePlanLogic.QueryUserListPage(paramRequest); if (result != null && result.count > 0) { result.msg = "SUCCESS"; result.code = 0; } return(Json(result)); } catch (Exception ex) { LogWriter.error($"GetAdPlanList=>获取广告信息异常:{ex.ToString() + ex.Message}"); return(Json(new CreativePlanPageResponse() { code = -1, msg = "未查询到数据" })); } }
public CreativePlanPageResponse QueryUserListPage(CreativePlanRequest request) { int total = 0; var pageList = CreativePlanQuery.QueryCreativePlan(request, out total); CreativePlanPageResponse page = new CreativePlanPageResponse(); if (pageList != null && pageList.Count > 0) { page.count = total; page.data = pageList.ToList(); return(page); } return(page); }
public List <CreativePlanEntity> QueryCreativePlan(CreativePlanRequest request, out int total) { total = 0; List <CreativePlanEntity> list = new List <CreativePlanEntity>(); StringBuilder sq = new StringBuilder(); sq.Append(" select * from ( "); sq.Append(" select {2} "); sq.Append(" from dbo.tblAdvertisingPlan a with(nolock) "); sq.Append(" where {0} "); sq.Append(" ) c where {1} "); DynamicParameters dp = new DynamicParameters(); string where_1 = " 1=1 "; if (!string.IsNullOrWhiteSpace(request.ADName)) { where_1 += " and a.ADName=@ADName"; dp.Add("ADName", request.ADName, DbType.String); } if (!string.IsNullOrWhiteSpace(request.BusinessPlanID)) { where_1 += " and a.BusinessPlanID=@BusinessPlanID"; dp.Add("BusinessPlanID", request.BusinessPlanID, DbType.String); } if (!string.IsNullOrWhiteSpace(request.Status)) { where_1 += " and a.Status=@Status"; dp.Add("Status", request.Status, DbType.String); } if (!string.IsNullOrWhiteSpace(request.startLaunchTime)) { where_1 += " and a.LaunchTime>@startLaunchTime"; dp.Add("startLaunchTime", request.startLaunchTime, DbType.String); } if (!string.IsNullOrWhiteSpace(request.endLaunchTime)) { where_1 += " and a.LaunchTime<=@endLaunchTime"; dp.Add("endLaunchTime", request.endLaunchTime, DbType.String); } if (!request.IsAdmin) { where_1 += " and a.UserManageId=@UserManageId"; dp.Add("UserManageId", request.UserManageId, DbType.Int32); } if (!string.IsNullOrWhiteSpace(request.NewAdPlanID)) { where_1 += " and a.NewAdPlanID=@NewAdPlanID"; dp.Add("NewAdPlanID", request.NewAdPlanID, DbType.String); } if (!string.IsNullOrWhiteSpace(request.AdPlanID)) { where_1 += " and a.AdPlanID=@AdPlanID"; dp.Add("AdPlanID", request.AdPlanID, DbType.String); } where_1 += " and a.IsDelete=0 "; dp.Add("PageIndex", request.PageIndex, DbType.Int32, ParameterDirection.Input); dp.Add("PageSize", request.PageSize, DbType.Int32, ParameterDirection.Input); string sql_list = string.Format(sq.ToString(), where_1, " c.Num > (@PageIndex - 1) * @PageSize and c.Num <= @PageIndex * @PageSize", "ROW_NUMBER() over(order by a.CreateTime desc) as Num,* "); string sql_count = string.Format(sq.ToString(), where_1, "1=1", "count(0) as nums"); using (IDbConnection conn = new SqlConnection(DBConnectionStringConfig.Default.JMGGConnectionString)) { total = conn.Query <int>(sql_count, dp).FirstOrDefault(); list = conn.Query <CreativePlanEntity>(sql_list, dp).ToList(); } return(list); }