protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", false);
ePath = Server.MapPath("/UpLoad/");
try
{
var id = Request.QueryString["spid"];
var sortnum = Request.QueryString["sortnum"];
var itid = Request.QueryString["itid"];
var batta = HttpUtility.UrlDecode(Request.QueryString["batta"]);
var tiid = Request.QueryString["tiid"];
var name = HttpUtility.UrlDecode(Request.QueryString["name"]);
var iid = Request.QueryString["iid"];
var xPosition = Request.QueryString["xposition"];
var yPosition = Request.QueryString["yposition"];
var diid = Request.QueryString["diid"];
var bpic = HttpUtility.UrlDecode(Request.QueryString["bpic"]);
var aatta = HttpUtility.UrlDecode(Request.QueryString["aatta"]);
var adtype = Request.QueryString["adtype"];
Database db = DatabaseFactory.CreateDatabase();
#region 设置背景图
if (!string.IsNullOrEmpty(bpic) && !string.IsNullOrEmpty(tiid))
{
var timodel = _tempInfoDal.GetModel(Convert.ToInt32(tiid));
if (null != timodel)
{
if (bpic != timodel.AttID)
{
if (File.Exists(ePath + bpic))
{
var fi = new FileInfo(ePath + bpic);
fi.MoveTo(Server.MapPath("/UploadFiles/" + bpic));
timodel.AttID = bpic;
var res = _tempInfoDal.Update(timodel);
if (res)
{
Response.Write("0|~|" + tiid);
Response.End();
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
}
else
{
Response.Write("0|~|" + tiid);
Response.End();
}
}
}
#endregion
#region 除热点
if (!string.IsNullOrEmpty(diid))
{
var infomodel = _infosDal.GetModel(Convert.ToInt32(diid));
if (null != infomodel)
{
_infosDal.Delete(infomodel.IID);
List <SqlParameter> parameters = new List <SqlParameter>();
var dtatta = _attaListDal.GetList(" IID=" + infomodel.IID, parameters).Tables[0];
if (dtatta.Rows.Count > 0)
{
for (int i = 0; i < dtatta.Rows.Count; i++)
{
var del = "delete from AttaList where ALID='" + dtatta.Rows[i]["ALID"] +
"'; ";
DbCommand dbCommanddel = db.GetSqlStringCommand(del);
db.ExecuteNonQuery(dbCommanddel);
if (DBNull.Value != dtatta.Rows[i]["AttID"])
{
if (!string.IsNullOrEmpty(dtatta.Rows[i]["AttID"].ToString()))
{
if (File.Exists(Server.MapPath("/UploadFiles/" + dtatta.Rows[i]["AttID"])))
{
var fi = new FileInfo(Server.MapPath("/UploadFiles/" + dtatta.Rows[i]["AttID"]));
fi.Delete();
}
}
}
}
}
Response.Write("0|~|" + iid);
Response.End();
}
}
#endregion
var attsql = string.Empty;
#region 修改热点
if (!string.IsNullOrEmpty(iid))
{
var infomodel = _infosDal.GetModel(Convert.ToInt32(iid));
infomodel.IName = name;
infomodel.XPosition = xPosition;
infomodel.YPosition = yPosition;
infomodel.HotType = Convert.ToInt32(adtype);
#region 热点图片/视频
List <SqlParameter> parameters = new List <SqlParameter>();
var dtatta = _attaListDal.GetList(" IID=" + infomodel.IID, parameters).Tables[0];
if (!string.IsNullOrEmpty(batta))
{
var list = batta.Split(':');
foreach (var s in list)
{
if (!string.IsNullOrEmpty(s))
{
if (dtatta.Select(" AttID='" + s + "' ").Length <=
0)
{
if (File.Exists(ePath + s))
{
var fi = new FileInfo(ePath + s);
fi.MoveTo(Server.MapPath("/UploadFiles/" + s));
attsql += "insert into AttaList(AttID,IID)values (N'" + s + "','" +
infomodel.IID + "');";
}
}
}
}
if (dtatta.Rows.Count > 0)
{
for (int i = 0; i < dtatta.Rows.Count; i++)
{
if (!list.Contains(dtatta.Rows[i]["AttID"]))
{
var del = "delete from AttaList where ALID='" + dtatta.Rows[i]["ALID"] +
"'; ";
DbCommand dbCommanddel = db.GetSqlStringCommand(del);
db.ExecuteNonQuery(dbCommanddel);
if (DBNull.Value != dtatta.Rows[i]["AttID"])
{
if (!string.IsNullOrEmpty(dtatta.Rows[i]["AttID"].ToString()))
{
if (File.Exists(Server.MapPath("/UploadFiles/" + dtatta.Rows[i]["AttID"])))
{
var fi =
new FileInfo(
Server.MapPath("/UploadFiles/" + dtatta.Rows[i]["AttID"]));
fi.Delete();
}
}
}
}
}
}
}
else
{
for (int i = 0; i < dtatta.Rows.Count; i++)
{
var del = "delete from AttaList where ALID='" + dtatta.Rows[i]["ALID"] +
"'; ";
DbCommand comdel = db.GetSqlStringCommand(del);
db.ExecuteNonQuery(comdel);
if (DBNull.Value != dtatta.Rows[i]["AttID"])
{
if (!string.IsNullOrEmpty(dtatta.Rows[i]["AttID"].ToString()))
{
if (File.Exists(Server.MapPath("/UploadFiles/" + dtatta.Rows[i]["AttID"])))
{
var fi =
new FileInfo(Server.MapPath("/UploadFiles/" + dtatta.Rows[i]["AttID"]));
fi.Delete();
}
}
}
}
}
#endregion
#region 热点图标
if (!string.IsNullOrEmpty(aatta))
{
if (aatta != infomodel.ADPic)
{
if (File.Exists(ePath + aatta))
{
var fi = new FileInfo(ePath + aatta);
fi.MoveTo(Server.MapPath("/UploadFiles/" + aatta));
infomodel.ADPic = aatta;
}
}
}
else
{
infomodel.ADPic = "";
}
#endregion
if (!string.IsNullOrEmpty(attsql))
{
DbCommand dbCommandAtt = db.GetSqlStringCommand(attsql);
db.ExecuteNonQuery(dbCommandAtt);
}
var upres = _infosDal.Update(infomodel);
if (upres)
{
Response.Write("0|~|" + iid);
Response.End();
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
#endregion
#region 新增热点
else
{
var inmodel = new Admin.Model.Infos();
inmodel.IName = name;
inmodel.Status = 1;
inmodel.IType = 5;
inmodel.TIID = Convert.ToInt32(tiid);
inmodel.XPosition = xPosition;
inmodel.YPosition = yPosition;
inmodel.SortNum = 1;
inmodel.NType = 0;
inmodel.HotType = Convert.ToInt32(adtype);
if (!string.IsNullOrEmpty(aatta))
{
if (File.Exists(ePath + aatta))
{
var fi = new FileInfo(ePath + aatta);
fi.MoveTo(Server.MapPath("/UploadFiles/" + aatta));
inmodel.ADPic = aatta;
}
}
var aiid = _infosDal.Add(inmodel);
if (!string.IsNullOrEmpty(batta))
{
var labArray = batta.Split(':');
foreach (var s in labArray)
{
if (!string.IsNullOrEmpty(s))
{
if (File.Exists(ePath + s))
{
var fi = new FileInfo(ePath + s);
fi.MoveTo(Server.MapPath("/UploadFiles/" + s));
var ilmodel = new Admin.Model.AttaList();
ilmodel.IID = aiid;
ilmodel.AttID = s;
_attaListDal.Add(ilmodel);
}
}
}
}
Response.Write("0|~|" + aiid);
Response.End();
}
#endregion
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
Response.Write("1|~|" + ee.Message);
Response.End();
}
}