/// <summary>
/// 广告位置添加
/// </summary>
/// <returns></returns>
public ActionResult AdertPositionEdit()
{
//BLL.ProductTypeBase ptbll = new BLL.ProductTypeBase();
//List<Model.ProductTypeBase> modelType = ptbll.GetModelList(" pt_ParentId = 0 and pt_IsDel=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["AdertType"] = new SelectList(selectType, "Value", "Text", "请选择");
//List<SelectListItem> select1 = new List<SelectListItem> { new SelectListItem { Text = "请选择", Value = "-1" }, new SelectListItem { Text = "左边", Value = "0" }, new SelectListItem { Text = "下边", Value = "1" } };
//ViewData["XianshiPosition"] = new SelectList(select1, "Value", "Text", "请选择");
ViewData["otype"] = RequestBase.GetString("otype");
if (RequestBase.GetString("p_ID") != null && RequestBase.GetString("p_ID") != "")
{
Model.AdertPositionBase apmodel = new Model.AdertPositionBase();
apmodel = new BLL.AdertPositionBase().GetModel(int.Parse(RequestBase.GetString("p_ID")));
Model.AdertPositionBase adert = new BLL.AdertPositionBase().GetModel(int.Parse(RequestBase.GetString("p_ID")));
//DataSet ptdataset = new BLL.ProductTypeBase().GetList(" pt_Name='" + adert.p_PositionExplain + "'");
//int ptid = int.Parse(ptdataset.Tables[0].Rows[0]["pt_ID"].ToString());
//ViewData["AdertType"] = new SelectList(selectType, "Value", "Text", ptid);
//if (adert.p_showposition == "0")//广告位置在左边时
//{
// ViewData["XianshiPosition"] = new SelectList(select1, "Value", "Text", 0);
//}
//else
//{
// ViewData["XianshiPosition"] = new SelectList(select1, "Value", "Text", 1);
//}
return View(adert);
}
else
{
return View();
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.AdertPositionBase DataRowToModel(DataRow row)
{
Model.AdertPositionBase model = new Model.AdertPositionBase();
if (row != null)
{
if (row["p_ID"] != null && row["p_ID"].ToString() != "")
{
model.p_ID = int.Parse(row["p_ID"].ToString());
}
if (row["p_PositionName"] != null)
{
model.p_PositionName = row["p_PositionName"].ToString();
}
if (row["p_PositionExplain"] != null)
{
model.p_PositionExplain = row["p_PositionExplain"].ToString();
}
if (row["p_CreateDate"] != null && row["p_CreateDate"].ToString() != "")
{
model.p_CreateDate = DateTime.Parse(row["p_CreateDate"].ToString());
}
if (row["p_CreateUser"] != null && row["p_CreateUser"].ToString() != "")
{
model.p_CreateUser = new Guid(row["p_CreateUser"].ToString());
}
if (row["p_Status"] != null && row["p_Status"].ToString() != "")
{
model.p_Status = int.Parse(row["p_Status"].ToString());
}
if (row["p_Delete"] != null && row["p_Delete"].ToString() != "")
{
model.p_Delete = int.Parse(row["p_Delete"].ToString());
}
if (row["p_showposition"] != null)
{
model.p_showposition = row["p_showposition"].ToString();
}
if (row["p_producttype"] != null && row["p_producttype"].ToString() != "")
{
model.p_producttype = int.Parse(row["p_producttype"].ToString());
}
}
return model;
}
/// <summary>
/// 删除
/// </summary>
/// <returns></returns>
public ActionResult Delete()
{
string pid = RequestBase.GetString("p_ID");
Model.AdertPositionBase apmodel = new Model.AdertPositionBase();
apmodel = new BLL.AdertPositionBase().GetModel(int.Parse(pid));
bool result = false;
try
{
if (apmodel.p_PositionExplain == "1")
{
return Content(DWZUtil.GetResultJson("300", "删除失败！！此广告位为固定广告位不能进行此操作！", "", "", ""));
}
else
{
Model.AdertPositionBase adertposition = apbll.GetModel(int.Parse(RequestBase.GetString("p_ID")));
adertposition.p_Delete = 1;
result = apbll.Update(adertposition);
if (result)
{
return Content(DWZUtil.GetAjaxTodoJson("200", "删除成功！！", "w_广告位置管理", "", "forward", "AdertPositionBox", ""));
}
else
{
return Content(DWZUtil.GetResultJson("300", "删除失败！！", "", "", ""));
}
}
}
catch
{
return Content(DWZUtil.GetResultJson("300", "删除失败！！", "", "", ""));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.AdertPositionBase GetModel(int p_ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 p_ID,p_PositionName,p_PositionExplain,p_CreateDate,p_CreateUser,p_Status,p_Delete,p_showposition,p_producttype from AdertPositionBase ");
strSql.Append(" where p_ID=@p_ID");
SqlParameter[] parameters = {
new SqlParameter("@p_ID", SqlDbType.Int,4)
};
parameters[0].Value = p_ID;
Model.AdertPositionBase model = new Model.AdertPositionBase();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}