//添加广告位置 public void AddAD_Position() { int Ad_Position_ID = tools.CheckInt(Request.Form["Ad_Position_ID"]); string Ad_Position_Name = tools.CheckStr(Request.Form["Ad_Position_Name"]); int Ad_Position_ChannelID = tools.CheckInt(Request.Form["Ad_Position_ChannelID"]); string Ad_Position_Value = tools.CheckStr(Request.Form["Ad_Position_Value"]); int Ad_Position_Width = tools.CheckInt(Request.Form["Ad_Position_Width"]); int Ad_Position_Height = tools.CheckInt(Request.Form["Ad_Position_Height"]); int Ad_Position_IsActive = tools.CheckInt(Request.Form["Ad_Position_IsActive"]); string Ad_Position_Site = Public.GetCurrentSite(); int U_Ad_Position_Marketing = tools.CheckInt(Request.Form["U_Ad_Position_Marketing"]); double U_Ad_Position_Price = tools.CheckFloat(Request.Form["U_Ad_Position_Price"]); if (Ad_Position_Name == "") { Public.Msg("error", "错误信息", "请填写位置名称", false, "{back}"); } if (Ad_Position_Value == "") { Public.Msg("error", "错误信息", "请填写位置代号", false, "{back}"); } ADPositionInfo entity = new ADPositionInfo(); entity.Ad_Position_ID = Ad_Position_ID; entity.Ad_Position_Name = Ad_Position_Name; entity.Ad_Position_ChannelID = Ad_Position_ChannelID; entity.Ad_Position_Value = Ad_Position_Value; entity.Ad_Position_Width = Ad_Position_Width; entity.Ad_Position_Height = Ad_Position_Height; entity.Ad_Position_IsActive = Ad_Position_IsActive; entity.Ad_Position_Site = Ad_Position_Site; entity.U_Ad_Position_Marketing = U_Ad_Position_Marketing; entity.U_Ad_Position_Price = U_Ad_Position_Price; if (Myposition.AddAD_Position(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "ad_position_add.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
//获取广告推广申请 public string GetAd_Applys() { ADPositionInfo positioninfo = null; QueryInfo Query = new QueryInfo(); Query.PageSize = tools.CheckInt(Request["rows"]); Query.CurrentPage = tools.CheckInt(Request["page"]); string keyword = tools.CheckStr(Request["keyword"]); string Ad_Kind = tools.CheckStr(Request["Ad_Kind"]); int ad_channel_id = tools.CheckInt(Request["ad_channel_id"]); Query.ParamInfos.Add(new ParamInfo("AND", "str", "ADInfo.Ad_Site", "=", Public.GetCurrentSite())); Query.ParamInfos.Add(new ParamInfo("AND", "int", "ADInfo.U_Ad_Advertiser", ">", "0")); if (Ad_Kind.Length > 0) { Query.ParamInfos.Add(new ParamInfo("AND", "str", "ADInfo.Ad_Kind", "=", Ad_Kind)); } if (Ad_Kind.Length == 0 & ad_channel_id != 0) { string ad_kind_str = GetADKinds(ad_channel_id); Query.ParamInfos.Add(new ParamInfo("AND", "str", "ADInfo.Ad_Kind", "in", ad_kind_str)); } if (keyword.Length > 0) { Query.ParamInfos.Add(new ParamInfo("AND(", "str", "ADInfo.Ad_Title", "like", keyword)); Query.ParamInfos.Add(new ParamInfo("OR)", "int", "ADInfo.U_Ad_Advertiser", "in", "select supplier_id from supplier where Supplier_CompanyName like '%" + keyword + "%'")); } string Audit = tools.CheckStr(Request["Audit"]); Query.ParamInfos.Add(new ParamInfo("AND", "str", "ADInfo.U_Ad_Audit", "=", Audit)); Query.OrderInfos.Add(new OrderInfo(tools.CheckStr(Request["sidx"]), tools.CheckStr(Request["sord"]))); PageInfo pageinfo = MyAD.GetPageInfo(Query, Public.GetUserPrivilege()); IList <ADInfo> Ads = MyAD.GetADs(Query, Public.GetUserPrivilege()); if (Ads != null) { StringBuilder jsonBuilder = new StringBuilder(); jsonBuilder.Append("{\"page\":" + pageinfo.CurrentPage + ",\"total\":" + pageinfo.PageCount + ",\"records\":" + pageinfo.RecordCount + ",\"rows\""); jsonBuilder.Append(":["); Supplier Supplier = new Supplier(); SupplierInfo SupplierEntity; foreach (ADInfo entity in Ads) { jsonBuilder.Append("{\"id\":" + entity.Ad_ID + ",\"cell\":["); //各字段 jsonBuilder.Append("\""); jsonBuilder.Append(entity.Ad_ID); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(Public.JsonStr(entity.Ad_Title)); jsonBuilder.Append("\","); jsonBuilder.Append("\""); positioninfo = Myposition.GetAD_PositionByValue(entity.Ad_Kind, Public.GetUserPrivilege()); if (positioninfo != null) { jsonBuilder.Append(positioninfo.Ad_Position_Name); } else { jsonBuilder.Append(entity.Ad_Kind); } jsonBuilder.Append("\","); jsonBuilder.Append("\""); if (entity.Ad_MediaKind == 1) { jsonBuilder.Append("文字"); } else if (entity.Ad_MediaKind == 2) { jsonBuilder.Append("图片"); } else if (entity.Ad_MediaKind == 3) { jsonBuilder.Append("Flash"); } else { jsonBuilder.Append("富媒体"); } jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(entity.Ad_Show_Freq); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(entity.Ad_Sort); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(entity.Ad_Show_times); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(entity.Ad_Hits); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(entity.Ad_StartDate.ToShortDateString() + " - " + entity.Ad_EndDate.ToShortDateString()); jsonBuilder.Append("\","); jsonBuilder.Append("\""); if (entity.U_Ad_Audit == 1) { jsonBuilder.Append("已审核"); } else if (entity.U_Ad_Audit == 2) { jsonBuilder.Append("审核不通过"); } else { jsonBuilder.Append("未审核"); } jsonBuilder.Append("\","); jsonBuilder.Append("\""); SupplierEntity = Supplier.GetSupplierByID(entity.U_Ad_Advertiser); if (SupplierEntity != null) { jsonBuilder.Append(SupplierEntity.Supplier_CompanyName); } jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append(entity.Ad_Addtime); jsonBuilder.Append("\","); jsonBuilder.Append("\""); jsonBuilder.Append("<img src=\\\"/images/icon_view.gif\\\"> <a href=\\\"ad_view.aspx?ad_id=" + entity.Ad_ID + "\\\" title=\\\"查看\\\">查看</a>"); if (Public.CheckPrivilege("c47f67fa-1142-459d-b466-e3216848ff9c") && entity.U_Ad_Audit == 0) { jsonBuilder.Append(" <img src=\\\"/images/icon_edit.gif\\\"> <a href=\\\"ad_edit.aspx?ad_id=" + entity.Ad_ID + "\\\" title=\\\"修改\\\">修改</a>"); } if (Public.CheckPrivilege("6087aa59-bd66-4eb5-8fb0-f72da294b1ae") && entity.U_Ad_Audit != 1) { jsonBuilder.Append(" <img src=\\\"/images/icon_del.gif\\\"> <a href=\\\"javascript:void(0);\\\" onclick=\\\"confirmdelete('ad_do.aspx?action=move&ad_id=" + entity.Ad_ID + "')\\\" title=\\\"删除\\\">删除</a>"); } jsonBuilder.Append("\","); jsonBuilder.Remove(jsonBuilder.Length - 1, 1); jsonBuilder.Append("]},"); } jsonBuilder.Remove(jsonBuilder.Length - 1, 1); jsonBuilder.Append("]"); jsonBuilder.Append("}"); return(jsonBuilder.ToString()); } else { return(null); } }
//广告推广审核 public void ADApply_Audit_Edit(int status) { string ad_id = tools.CheckStr(Request["ad_id"]); if (ad_id == "") { Public.Msg("error", "错误信息", "请选择要操作的申请信息", false, "{back}"); return; } ADPositionInfo AdPositionEntity = null; if (tools.Left(ad_id, 1) == ",") { ad_id = ad_id.Remove(0, 1); } ProductDenyReasonInfo reasoninfo; QueryInfo Query = new QueryInfo(); Query.PageSize = tools.CheckInt(Request["rows"]); Query.CurrentPage = tools.CheckInt(Request["page"]); Query.ParamInfos.Add(new ParamInfo("AND", "int", "ADInfo.Ad_ID", "in", ad_id)); Query.ParamInfos.Add(new ParamInfo("AND", "str", "ADInfo.Ad_Site", "=", Public.GetCurrentSite())); Query.ParamInfos.Add(new ParamInfo("AND", "int", "ADInfo.U_Ad_Audit", "=", "0")); Query.ParamInfos.Add(new ParamInfo("AND", "int", "ADInfo.U_Ad_Advertiser", ">", "0")); Query.OrderInfos.Add(new OrderInfo("ADInfo.Ad_ID", "DESC")); IList <ADInfo> entitys = MyAD.GetADs(Query, Public.GetUserPrivilege()); if (entitys != null) { foreach (ADInfo entity in entitys) { if (status == 1) { AdPositionEntity = Myposition.GetAD_PositionByValue(entity.Ad_Kind, Public.GetUserPrivilege()); if (AdPositionEntity == null) { AdPositionEntity = new ADPositionInfo(); } double DeductMoney = ((entity.Ad_EndDate - entity.Ad_StartDate).Days + 1) * AdPositionEntity.U_Ad_Position_Price; if (supplier.GetSupplierAdvAccount(entity.U_Ad_Advertiser) >= DeductMoney) { supplier.Supplier_Account_Log(entity.U_Ad_Advertiser, 2, Math.Round(0 - DeductMoney, 2), "广告服务费"); } else { Public.Msg("error", "错误信息", "账户余额不足", false, "{back}"); break; } } entity.U_Ad_Audit = status; MyAD.EditAD(entity, Public.GetUserPrivilege()); } } Response.Redirect("/ad/ad_apply.aspx"); }