/// <summary>
///查询广告列表
///创建人：wsy
///时间2015-07-23
/// </summary>
/// <param name="context"></param>
public void Search(HttpContext context)
{
string pageIndex = context.Request["pageIndex"] ?? "";
string pageSize = context.Request["pageSize"] ?? "";
string advid = context.Request["advid"] ?? "";
string name = StringHelper.SqlSpecialConvert(context.Request["sname"] ?? "", StringConverTypeEnum.Like);
int totalCount = 1;
List <Psys_VW_AdvAndUser> advlist = new Psys_Adv_BLL().GetListByPage(Convert.ToInt32(pageIndex), Convert.ToInt32(pageSize), advid, " Adv_Type, SortNum desc ", ref totalCount, name);//查询广告列表
StringBuilder table = new StringBuilder();
table.Append("<tr><th style='width:15px;'>序号</th><th style='width:80px;'>广告位置</th><th style='width:100px;'>图片跳转链接</th><th style='width:40px;'>最后修改人</th><th style='width:45px;'>最后修改日期</th><th style='width:45px;'>操作</th></tr>");
if (advlist.Count > 0)
{
for (int i = 0; i < advlist.Count; i++)
{
table.Append("<tr>");
table.Append("<td>" + (i + 1) + "</td>"); //序号
table.Append("<td ><div class='new_titleimg'><i name='titlename' onmouseover='doover(this)' onmouseout='doout(this)' >" + advlist[i].Name + "</i><div style='display:none'><img src='" + advlist[i].PicPath + "'></div></div></td>"); //广告位置
table.Append("<td title='" + advlist[i].PicUrl + "'>" + StringHelper.SubString(advlist[i].PicUrl, 50) + "</td>"); //图片跳转链接
table.Append("<td title='" + advlist[i].LastEditUserName + "'>" + StringHelper.SubString(advlist[i].LastEditUserName.ToString(), 10) + "</td>"); //最后修改人
table.Append("<td >" + DateTimeHelper.ToString(advlist[i].LastEditDate, DateTimeHelper.DateFormat.SHORTDATE) + "</td>"); //最后修改日期
table.Append("<td>");
table.Append("<a href='AdvEdit.aspx?advid=" + advlist[i].ID + "&type=0'>编辑</a>"); // //添加积分商城广告判断标识0：阅读网 1：积分商城 edit by fuzhenzhen 15-11-05
table.Append("<a href=\"javascript:SortPreAndNext('" + advlist[i].ID + "','up')\">上移</a>"); //上移 lyn
table.Append("<a href=\"javascript:SortPreAndNext('" + advlist[i].ID + "','down')\">下移</a>"); //下移 lyn
table.Append("</td>");
table.Append("</tr>");
}
context.Response.Write(JsonConvert.SerializeObject(new { count = totalCount, data = table.ToString() }));
}
else
{
context.Response.Write("{\"count\":\"" + totalCount + "\",\"data\":\"\"}");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string id = Request["advid"] ?? "";
string type = Request["type"] ?? ""; //添加积分商城广告判断标识0：阅读网 1：积分商城 edit by fuzhenzhen 15-11-05
advid.Value = id;
pictype.Value = type;
if (type == "1")
{
advcation.InnerHtml = "您当前的位置：天鹅商城管理";
}
if (!string.IsNullOrEmpty(id))
{
Psys_Adv adv = new Psys_Adv_BLL().SelectEntity(id);//根据ID查询广告信息
if (adv != null)
{
name.Value = adv.Name;
pic.Value = "../" + adv.PicPath;
pic_url.Value = adv.PicUrl;
sp.InnerHtml = "(" + adv.PicRemark + ")";
hid_isnofollow.Value = adv.IsNofollow.ToString();
altname.Value = adv.AltName;
}
}
}
}
/// <summary>
/// 编辑广告
/// 创建人：wsy
/// 时间2015-07-23
/// </summary>
/// <param name="context"></param>
public void EditAdv(HttpContext context)
{
string pic = UploadPic(context);//上传图片
if (pic == "-1")
{
//格式不正确
context.Response.Write(pic);
return;
}
else if (pic == "-2")
{
//文件大小>5M
context.Response.Write(pic);
return;
}
else
{
string id = context.Request["advid"]; //广告ID
string url = context.Request["url"]; //图片跳转链接
string altname = context.Request["altname"];
string isnofollow = context.Request["isnofollow"];
string oldpic = "";
Psys_Adv_BLL bll = new Psys_Adv_BLL();
Psys_Adv adv = bll.SelectEntity(id);//根据ID查询广告
if (adv != null)
{
adv.PicUrl = url;
adv.LastEditUserID = new Guid(RequestSession.GetSessionUser().UserId);
adv.LastEditDate = DateTime.Now;
oldpic = adv.PicPath;
adv.IsNofollow = Convert.ToInt32(isnofollow);
adv.AltName = altname;
if (!string.IsNullOrEmpty(pic) && pic != "-3")
{
adv.PicPath = "/Upload/AdvPic/" + pic;
}
string result = bll.Update(adv).ToString();
if (result == "1" && !string.IsNullOrEmpty(pic) && pic != "-3")
{
//删除原来的图片
if (!string.IsNullOrEmpty(oldpic))
{
string pa = System.Web.HttpContext.Current.Server.MapPath(oldpic);
if (File.Exists(pa))
{
File.Delete(pa);
}
}
}
context.Response.Write(result);
LogHelper.InserLog((int)EnumClass.OperateType.编辑操作, PageBase.CurrentOperatName, "编辑了名称为" + adv.Name + "的广告");
}
}
}
/// <summary>
/// 删除广告
/// 创建人：wsy
/// 时间2015-07-23
/// </summary>
/// <param name="context"></param>
public void DeletePic(HttpContext context)
{
string id = context.Request["id"];
Psys_Adv_BLL bll = new Psys_Adv_BLL();
Psys_Adv adv = bll.SelectEntity(id);//根据ID查询广告
adv.Status = 1;
context.Response.Write(bll.Update(adv));//将广告状态改为已删除
LogHelper.InserLog((int)EnumClass.OperateType.除操作, PageBase.CurrentOperatName, "删除了名称为" + adv.Name + "的广告");
}
/// <summary>
/// 导出Excel列表
/// 时间：2015-08-16
/// 创建人：wsy
/// </summary>
/// <param name="context"></param>
public void ExportExcel(HttpContext context)
{
string type = context.Request["type"];
string advid = context.Request["advid"] ?? "";
string pageIndex = context.Request["pageIndex"] ?? "";
string pageSize = context.Request["pageSize"] ?? "";
string recordCount = context.Request["recordCount"] ?? "0";
int totalCount = 0;
string name = StringHelper.SqlSpecialConvert(context.Request["sname"] ?? "", StringConverTypeEnum.Like);
List <Psys_VW_AdvAndUser> advlist;
pageSize = type == "all" ? recordCount : pageSize;//判断导出当前or全部
pageIndex = type == "all" ? "1" : pageIndex;
Psys_Adv_BLL bll = new Psys_Adv_BLL();
advlist = bll.GetListByPage(Convert.ToInt32(pageIndex), Convert.ToInt32(pageSize), advid, " SortNum desc ", ref totalCount, name);//查询广告列表
Excel.ExportExcelByMyXls <Psys_VW_AdvAndUser>(advlist, "Name,PicUrl,LastEditUserName,ToDateShort", "广告位置,图片跳转链接,最后修改人,最后修改日期", "AdvList.xls", "广告列表导出");
LogHelper.InserLog((int)EnumClass.OperateType.导出操作, PageBase.CurrentOperatName, "导出了广告列表");
}
