/// <summary>
/// 添加/编辑
/// </summary>
/// <returns></returns>
public ActionResult AdertEdit()
{
//绑定广告位置
BLL.AdertPositionBase apbll = new BLL.AdertPositionBase();
List<Model.AdertPositionBase> listadert= apbll.GetModelList(" p_Delete=0 and p_Status=0 ");
List<SelectListItem> seltype = new List<SelectListItem>();
seltype = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" } };
for (int i = 0; i < listadert.Count; i++)
{
seltype.Add(new SelectListItem
{
Value = listadert[i].p_ID.ToString(),
Text = listadert[i].p_PositionName
});
}
ViewData["AdertPosition"] = new SelectList(seltype, "Value", "Text", "请选择");
//绑定广告分类
BLL.ProductTypeBase ptbll = new BLL.ProductTypeBase();
List<Model.ProductTypeBase> modelType = ptbll.GetModelList(" pt_ParentId = 0 and pt_IsDel=0 and pt_StatusCode=0");
List<SelectListItem> selectType = new List<SelectListItem>();
selectType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" } };
for (int i = 0; i < modelType.Count; i++)
{
selectType.Add(new SelectListItem
{
Value = modelType[i].pt_ID.ToString(),
Text = modelType[i].pt_Name
});
}
ViewData["AdertFenLeiPosition"] = new SelectList(selectType, "Value", "Text", "请选择");
ViewData["otype"] = RequestBase.GetString("otype");
if (RequestBase.GetString("a_ID") != null && RequestBase.GetString("a_ID") != "")
{
Model.Adert adert = new BLL.Adert().GetModel(int.Parse(RequestBase.GetString("a_ID")));
ViewData["AdertPosition"] = new SelectList(seltype, "Value", "Text", adert.a_PID);
if (adert.a_spare2 != null)
{
ViewData["AdertFenLeiPosition"] = new SelectList(selectType, "Value", "Text", adert.a_spare2);
}
else {
}
ViewData["picurl"] = adert.a_Image;
return View(adert);
}
else {
return View();
}
}
//广告管理
// GET: /Adert/
/// <summary>
/// 广告列表页
/// </summary>
/// <returns></returns>
public ActionResult AdertMsg()
{
//绑定广告分类
BLL.ProductTypeBase ptbll = new BLL.ProductTypeBase();
List<Model.ProductTypeBase> modelType = ptbll.GetModelList(" pt_ParentId = 0 and pt_IsDel=0 and pt_StatusCode=0");
List<SelectListItem> selectType = new List<SelectListItem>();
selectType = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" } };
for (int i = 0; i < modelType.Count; i++)
{
selectType.Add(new SelectListItem
{
Value = modelType[i].pt_ID.ToString(),
Text = modelType[i].pt_Name
});
}
ViewData["AdertFenLeiPosition"] = new SelectList(selectType, "Value", "Text", "请选择");
//绑定广告位置
BLL.AdertPositionBase apbll = new BLL.AdertPositionBase();
List<Model.AdertPositionBase> listap = apbll.GetModelList(" p_Status = 0 and p_Delete=0");
List<SelectListItem> selectposition = new List<SelectListItem>();
selectposition = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" } };
for (int i = 0; i < listap.Count; i++)
{
selectposition.Add(new SelectListItem
{
Value = listap[i].p_ID.ToString(),
Text = listap[i].p_PositionName
});
}
ViewData["AdertPosition"] = new SelectList(selectposition, "Value", "Text", "请选择");
return View();
}
/// <summary>
/// 获取广告
/// </summary>
/// <param name="viewName">view名称</param>
/// <param name="ptID">分类ID</param>
/// <param name="isBottom">是否底部</param>
public void GetProductTypeAds(string viewName, int ptID, bool isBottom)
{
BLL.AdertPositionBase adp = new BLL.AdertPositionBase();
string sql = string.Empty;
if (isBottom)
{
sql = "p_Status = 0 and p_Delete = 0 and p_producttype = " + ptID + "and p_showposition = 1";
}
else
{
sql = "p_Status = 0 and p_Delete = 0 and p_producttype = " + ptID + "and p_showposition = 0";
}
var model = adp.GetModelList(sql).FirstOrDefault();
if (model != null)
{
var list = new BLL.Adert().GetModelList(" a_Status = 0 and a_Delete = 0 and a_PID = " + model.p_ID);
ViewData[viewName] = list;
}
}
