protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", false);
if (!IsPostBack)
{
var iid = Request.QueryString["iid"];
if (!string.IsNullOrEmpty(iid))
{
var imodel = _infosDal.GetModel(Convert.ToInt32(iid));
if (null != imodel)
{
txtName.Value = imodel.IName;
if (!string.IsNullOrEmpty(imodel.PicAttID))
{
//var fname = imodel.PicAttID.Substring(36);
var fname = "";
if ("C0pY" == imodel.PicAttID.Substring(0, 4))
{
fname = imodel.PicAttID.Substring(76);
}
else
{
fname = imodel.PicAttID.Substring(36);
}
litPic.Text =
"<div class=\"upatta\" title=\"" + fname + "\" data-file=\"" + imodel.PicAttID + "\"><div class=\"upsigin\"><div class=\"at-file\"><img width=\"220\" id=\"at-img\" src=\"/UploadFiles/" + imodel.PicAttID + "\"><span class=\"at-name\">" + (fname.Length > 10 ? fname.Substring(0, 10) + "..." : fname) + "</span></div></div></div>";
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", true);
if (!IsPostBack)
{
var spid = Request.QueryString["spid"];
if (!string.IsNullOrEmpty(spid))
{
#region 导航
var pid = Request.QueryString["pid"];
if ("0" != pid && !string.IsNullOrEmpty(pid))
{
var imodel = _infosDal.GetModel(Convert.ToInt32(pid));
if (null != imodel)
{
litStaName.Text = "<div class=\"backup\"><a href=\"/Manage/Template/Redircet.aspx?spid=" + spid + "&itid=" + Request.QueryString["itid"] +
"\" class=\"back_btn backfirst\">返回首页</a><a href=\"/Manage/Template/Redircet.aspx?spid=" + spid +
"&tiid=" + imodel.TIID + "&itid=" + Request.QueryString["itid"] +
"\" class=\"back_btn\">返回上级</a> </div>";
}
}
else
{
#region 分站名称
var spmodel = _staPackageDal.GetModel(Convert.ToInt32(spid));
if (null != spmodel)
{
var orgmodel = _orgOrganizeDal.GetModel(Convert.ToInt64(spmodel.OrgId));
if (null != orgmodel)
{
litStaName.Text =
"<div class=\"logo\"><img src=\"/images/LOGO-yt.png\" style=\"display: block; width: 50px; height: 50px;\" alt=\"沿途\" /></div><div class=\"title\"><strong>" +
orgmodel.OrgName + "</strong><span>" + orgmodel.EnName + "</span></div>";
}
}
#endregion
}
#endregion
var itid = Request.QueryString["itid"];//分类id
if (!string.IsNullOrEmpty(itid))
{
var model = _infoTypeDal.GetModel(Convert.ToInt32(itid));
if (null != model)
{
litType.Text = Service.GetType(Convert.ToInt32(model.ITID), spid);
}
}
else
{
litType.Text = Service.GetType(0, spid);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", false);
ePath = Server.MapPath("/UpLoad/");
try
{
var iid = Request.QueryString["iid"];
#region
if (!string.IsNullOrEmpty(iid))
{
var iimodel = _infosDal.GetModel(Convert.ToInt32(iid));
if (null != iimodel)
{
var res = "";
if (1 == iimodel.Status)
{
iimodel.Status = 0;
}
else
{
iimodel.Status = 1;
}
var upres = _infosDal.Update(iimodel);
if (upres)
{
Response.Write("0|~|");
Response.End();
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
#endregion
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
Response.Write("1|~|" + ee.Message);
Response.End();
}
}
public static string Nav(Admin.Model.TempInfo timodel, object spid, object itid)
{
#region 导航
var str = "";
if (0 != timodel.ParentID)
{
var imodel = infosDal.GetModel(Convert.ToInt32(timodel.ParentID));
if (null != imodel)
{
str = "<div class=\"backup\"><a href=\"/Manage/Template/Redircet.aspx?spid=" + spid + "&itid=" + itid +
"\" class=\"back_btn backfirst\">返回首页</a><a href=\"/Manage/Template/Redircet.aspx?spid=" + spid +
"&tiid=" + imodel.TIID + "&itid=" + itid +
"\" class=\"back_btn\">返回上级</a> </div>";
}
}
else
{
#region 分站名称
StaPackage _staPackageDal = new StaPackage();
OrgOrganize _orgOrganizeDal = new OrgOrganize();
var spmodel = _staPackageDal.GetModel(Convert.ToInt32(spid));
if (null != spmodel)
{
var orgmodel = _orgOrganizeDal.GetModel(Convert.ToInt64(spmodel.OrgId));
if (null != orgmodel)
{
str =
"<div class=\"logo\"><img src=\"/images/LOGO-yt.png\" style=\"display: block; width: 50px; height: 50px;\" alt=\"沿途\" /></div><div class=\"title\"><strong>" +
orgmodel.OrgName + "</strong><span>" + orgmodel.EnName + "</span></div>";
}
}
#endregion
}
return(str);
#endregion
}
private string GetBtn(Admin.Model.TempInfo timodel, int sortNum)
{
var user = (OrgUsers)HttpContext.Current.Session["CurrentUser"];
var res = "";
List <SqlParameter> par1 = new List <SqlParameter>();
var tmpPar1 = _templateParDal.GetModel(" TID=" + timodel.TID + " and SortNum=" + sortNum + " ", par1);
var info1 = _infosDal.GetModel(" TIID=" + timodel.TIID + " and SortNum=" + sortNum + " ", par1);
if (null != info1)
{
#region 纯图广告反显
if (info1.IType == 6)
{
res = "<div class=\"btnbox\" style=\"top:54%;display:none\"><a href=\"javascript:;\" class=\"btn edit-info\" data-iid=\"" +
info1.IID + "\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">编辑</a> <a href=\"javascript:;\" class=\"btn del-info\" data-iid=\"" + info1.IID +
"\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">删除</a>";
if (1 == user.Type)
{
if (1 == info1.Status)
{
res += " <a href=\"javascript:;\" class=\"btn sin-info btn-warning\" data-iid=\"" +
info1.IID +
"\">标记</a>";
}
else
{
res += " <a href=\"javascript:;\" class=\"btn sin-info btn-warning\" data-iid=\"" +
info1.IID +
"\">取消标记</a>";
}
}
else
{
if (0 == info1.Status)
{
res += " <span class=\"btn btn-editing\">待修改</span>";
}
}
res += "</div><img src=\"/UploadFiles/" + info1.PicAttID + "\">";
}
#endregion
}
else
{
res = "<div class=\"btnbox\"><a href=\"javascript:;\" class=\"btn new-info\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">新增</a>";
//res += " <a href=\"javascript:;\" class=\"btn select-info\" data-sortnum=\"" + sortNum +
// "\">选择</a>";
res += "</div><img>";
}
return(res);
}
private string GetBtn(Admin.Model.TempInfo timodel, int sortNum)
{
var res = "";
List <SqlParameter> par1 = new List <SqlParameter>();
var tmpPar1 = templateParDal.GetModel(" TID=" + timodel.TID + " and SortNum=" + sortNum + " ", par1);
var info1 = infosDal.GetModel(" TIID=" + timodel.TIID + " and SortNum=" + sortNum + " ", par1);
if (null != info1)
{
#region 资讯反显
if (info1.IType == 1)
{
res = "<div class=\"btnbox\" style=\"top:54%;display:none\"><a href=\"javascript:;\" class=\"btn edit-info\" data-iid=\"" +
info1.IID + "\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">编辑</a> <a href=\"javascript:;\" class=\"btn del-info\" data-iid=\"" + info1.IID +
"\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">删除</a> <a href=\"/Manage/News/Redircet.aspx?spid=" + Request.QueryString["spid"] + "&itid=" + Request.QueryString["itid"] + "&pid=" + info1.IID + "\" class=\"btn enter-news\" data-iid=\"" + info1.IID +
"\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">查看资讯</a></div><img src=\"/UploadFiles/" + info1.PicAttID + "\">";
}
#endregion
#region 视频反显
if (info1.IType == 2)
{
res = "<div class=\"btnbox\" style=\"top:54%;display:none\"><a href=\"javascript:;\" class=\"btn edit-info\" data-iid=\"" +
info1.IID + "\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">编辑</a> <a href=\"javascript:;\" class=\"btn del-info\" data-iid=\"" + info1.IID +
"\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">删除</a></div><img src=\"/UploadFiles/" + info1.PicAttID + "\">";
}
#endregion
#region 专题反显
if (info1.IType == 3)
{
res = "<div class=\"btnbox\" style=\"top:54%;display:none\"><a href=\"javascript:;\" class=\"btn edit-info\" data-iid=\"" +
info1.IID + "\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">编辑</a> <a href=\"javascript:;\" class=\"btn del-info\" data-iid=\"" + info1.IID +
"\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">删除</a> <a href=\"/Manage/Template/Redircet.aspx?spid=" + Request.QueryString["spid"] + "&itid=" + Request.QueryString["itid"] + "&pid=" + info1.IID + "\" class=\"btn\" data-iid=\"" + info1.IID +
"\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">查看专题</a></div><img src=\"/UploadFiles/" + info1.PicAttID + "\">";
}
#endregion
}
else
{
res = "<div class=\"btnbox\"><a href=\"javascript:;\" class=\"btn new-info\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">新增</a> <a href=\"javascript:;\" class=\"btn select-info\" data-sortnum=\"" + sortNum +
"\">选择</a></div><img>";
}
return(res);
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", true);
if (!IsPostBack)
{
var spid = Request.QueryString["spid"];
if (!string.IsNullOrEmpty(spid))
{
#region 左侧分类
var itid = Request.QueryString["itid"]; //分类id
if (!string.IsNullOrEmpty(itid))
{
var model = _infoTypeDal.GetModel(Convert.ToInt32(itid));
if (null != model)
{
litType.Text = Service.GetType(Convert.ToInt32(model.ITID), spid);
}
}
else
{
litType.Text = Service.GetType(0, spid);
}
#endregion
#region 块内容
var tiid = Request.QueryString["tiid"];
if (!string.IsNullOrEmpty(tiid))
{
TempInfo _tempInfoDal = new TempInfo();
var timodel = _tempInfoDal.GetModel(Convert.ToInt32(tiid));
if (null != timodel)
{
#region 导航
if (0 != timodel.ParentID)
{
var imodel = infosDal.GetModel(Convert.ToInt32(timodel.ParentID));
if (null != imodel)
{
litStaName.Text = "<div class=\"backup\"><a href=\"/Manage/Template/Redircet.aspx?spid=" + spid + "&itid=" + Request.QueryString["itid"] +
"\" class=\"back_btn backfirst\">返回首页</a><a href=\"/Manage/Template/Redircet.aspx?spid=" + spid +
"&tiid=" + imodel.TIID + "&itid=" + Request.QueryString["itid"] +
"\" class=\"back_btn\">返回上级</a> </div>";
}
}
else
{
#region 分站名称
StaPackage _staPackageDal = new StaPackage();
OrgOrganize _orgOrganizeDal = new OrgOrganize();
var spmodel = _staPackageDal.GetModel(Convert.ToInt32(spid));
if (null != spmodel)
{
var orgmodel = _orgOrganizeDal.GetModel(Convert.ToInt64(spmodel.OrgId));
if (null != orgmodel)
{
litStaName.Text =
"<div class=\"logo\"><img src=\"/images/LOGO-yt.png\" style=\"display: block; width: 50px; height: 50px;\" alt=\"沿途\" /></div><div class=\"title\"><strong>" +
orgmodel.OrgName + "</strong><span>" + orgmodel.EnName + "</span></div>";
}
}
#endregion
}
#endregion
#region 分页
var pager = "";
List <SqlParameter> parDef = new List <SqlParameter>();
var preitModel =
_tempInfoDal.GetModel(
" ITID=" + timodel.ITID + " and ParentID=" + timodel.ParentID + " and TIPage=" +
(timodel.TIPage - 1), parDef);
if (null != preitModel)
{
pager += "<td><a href=\"/Manage/Template/Redircet.aspx?itid=" +
Request.QueryString["itid"] + "&spid=" + Request.QueryString["spid"] + "&tiid=" +
preitModel.TIID + "\" class=\"btn btnprev\" data-tiid=\"" + preitModel.TIID +
"\">上页 </a></td>";
}
else
{
pager += "<td> </td>";
}
var count =
_tempInfoDal.GetList(" TIPage is not null and TIPage!='' and ITID=" + timodel.ITID + " and ParentID=" + timodel.ParentID,
parDef).Tables[0].Rows.Count;
if (count > 1)
{
pager +=
"<td>页码 </td><td><input type=\"text\" class=\"form-control input-sm iptpno\" value=\"" +
timodel.TIPage +
"\" style=\"width: 40px;display:inline;text-align: center;\" /> /" + count + "</td><td><input data-parcount=\"" + timodel.ParentID + "\" data-count=\"" + count + "\" type=\"button\" class=\"btn btn-sm repage\" value=\"跳转\" style=\"width: 70px;\" /></td><td><input type=\"button\" class=\"btn btn-sm editpno\" value=\"修改页码\" style=\"width: 70px;\" /></td><td><input type=\"button\" class=\"btn btn-sm delpage\" value=\"删除当前页\" /></td>";
}
else if (count == 1)
{
pager +=
"<td><input type=\"button\" class=\"btn btn-sm delpage\" value=\"删除当前页\" /></td>";
}
var nexitModel =
_tempInfoDal.GetModel(
" ITID=" + timodel.ITID + " and ParentID=" + timodel.ParentID + " and TIPage=" +
(timodel.TIPage + 1), parDef);
if (null != nexitModel)
{
pager += "<td><a href=\"/Manage/Template/Redircet.aspx?itid=" +
Request.QueryString["itid"] + "&spid=" + Request.QueryString["spid"] + "&tiid=" +
nexitModel.TIID + "\" class=\"btn btnnext\" data-tiid=\"" +
nexitModel.TIID + "\">下页 </a></td>";
}
else
{
pager += "<td> </td>";
litNewPage.Text = "<a href=\"/Manage/Systems/ChooseNewsTemplate.aspx?page=" +
(timodel.TIPage + 1) + "&pid=" + timodel.ParentID + "&itid=" +
Request.QueryString["itid"] + "&spid=" + Request.QueryString["spid"] +
"&tiid=" + timodel.TIID + "\" class=\" btn btn-add newpage\">新建内容页</a> <a href=\"/Manage/News/RedircetAD.aspx?itid=" +
Request.QueryString["itid"] + "&spid=" + Request.QueryString["spid"] + "&tiid=" +
timodel.TIID + "\" class=\"btn btn-add newpage\" style=\"top:50%\">添加文末广告</a>";
}
litPager.Text = pager;
#endregion
List <SqlParameter> par1 = new List <SqlParameter>();
var tmpPar1 = templateParDal.GetModel(" TID=" + timodel.TID + " and SortNum=1 ", par1);
var str = "<div class=\"box col-sm-12 ht2\" style=\"text-align:inherit\">";
var dtInfo = infosDal.GetList(" TIID=" + timodel.TIID, par1).Tables[0];
if (dtInfo.Rows.Count > 0)
{
for (int i = 0; i < dtInfo.Rows.Count; i++)
{
var point = "/images/hand.png";
if ("" != dtInfo.Rows[i]["ADPic"].ToString())
{
point = "/UploadFiles/" + dtInfo.Rows[i]["ADPic"];
}
str +=
"<div class=\"news-pic\" style=\"top:" + dtInfo.Rows[i]["YPosition"] +
"px;left:" + dtInfo.Rows[i]["XPosition"] +
"px;\"><a href=\"javascript:;\" data-iid=\"" + dtInfo.Rows[i]["IID"] +
"\" class=\"btn edit-pic\">编辑</a> <a href=\"javascript:;\" data-iid=\"" +
dtInfo.Rows[i]["IID"] +
"\" class=\"btn del-pic\">删除</a><img src=\"" + point + "\" style=\"background-color:transparent\"/></div>";
}
if (dtInfo.Rows.Count < 4)
{
str +=
"<div class=\"btnbox\"><a href=\"javascript:;\" class=\"btn new-info\" data-bgw=\"" +
tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">新增热点</a> <a href=\"javascript:;\" class=\"btn edit-bpic\" data-bgw=\"" +
tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\" data-tiid=\"" +
timodel.TIID + "\">编辑背景</a></div>";
}
else
{
str +=
"<div class=\"btnbox\"><a href=\"javascript:;\" data-bgw=\"" +
tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\" class=\"btn edit-bpic\" data-tiid=\"" +
timodel.TIID + "\">编辑背景</a></div>";
}
}
else
{
str +=
"<div class=\"btnbox\"><a href=\"javascript:;\" class=\"btn new-info\" data-bgw=\"" +
tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">新增热点</a> <a href=\"javascript:;\" class=\"btn edit-bpic\" data-bgw=\"" +
tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\" data-tiid=\"" + timodel.TIID + "\">上传背景</a>";
//str += " <a href=\"javascript:;\" class=\"btn select-info\" data-sortnum=\"1\">选择</a>";
str += "</div>";
}
if (!string.IsNullOrEmpty(timodel.AttID))
{
str += "<img src=\"/UploadFiles/" + timodel.AttID + "\">";
}
else
{
str += "<img>";
}
str += "</div>";
litInfo1.Text = str;
}
}
#endregion
}
}
}
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();
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", false);
if (!IsPostBack)
{
rboSingle.Checked = true;
rboDouble.Checked = false;
dorg.Style.Add("display", "block");
dvideo.Style.Add("display", "none");
var iid = Request.QueryString["iid"];
if (!string.IsNullOrEmpty(iid))
{
var imodel = _infosDal.GetModel(Convert.ToInt32(iid));
if (null != imodel)
{
if (!string.IsNullOrEmpty(imodel.ADPic))
{
var fname = "";
if ("C0pY" == imodel.ADPic.Substring(0, 4))
{
fname = imodel.ADPic.Substring(76);
}
else
{
fname = imodel.ADPic.Substring(36);
}
litPic.Text =
"<div class=\"upatta\" title=\"" + fname + "\" data-file=\"" + imodel.ADPic + "\"><div class=\"upsigin\"><div class=\"at-file\"><img width=\"220\" id=\"at-img\" src=\"/UploadFiles/" + imodel.ADPic + "\"><span class=\"at-name\">" + (fname.Length > 15 ? fname.Substring(0, 15) + "..." : fname) + "</span></div></div></div>";
}
txtName.Value = imodel.IName;
txtXPosition.Value = imodel.XPosition;
txtYPosition.Value = imodel.YPosition;
#region
var css = "";
var str = "";
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@IID", DbType.AnsiString)
{
Value = iid
});
var dt = _attaListDal.GetList(" IID=@IID ", parameters).Tables[0];
#region 热点图片
if (1 == imodel.HotType)
{
css = "upatta3";
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (DBNull.Value != dt.Rows[i]["AttID"])
{
if (!string.IsNullOrEmpty(dt.Rows[i]["AttID"].ToString()))
{
//var fname = dt.Rows[i]["AttID"].ToString().Substring(36);
var fname = "";
if ("C0pY" == dt.Rows[i]["AttID"].ToString().Substring(0, 4))
{
fname = dt.Rows[i]["AttID"].ToString().Substring(76);
}
else
{
fname = dt.Rows[i]["AttID"].ToString().Substring(36);
}
var img = "";
if (1 == imodel.HotType)
{
img = "<img width=\"100\" height=\"100\" src=\"/UploadFiles/" +
dt.Rows[i]["AttID"] + "\">";
}
str += "<li class=\"" + css + "\" title=\"" + fname + "\" data-file=\"" +
dt.Rows[i]["AttID"] +
"\">" + img +
(fname.Length > 5 ? fname.Substring(0, 5) + "..." : fname) +
"<div class=\"load\" style=\"height: 0px;margin-top:0px;\"></div><a href=\"javascript:;\" class=\"del-hotpic\" data-alid=\"" +
dt.Rows[i]["ALID"] + "\">删除</a></li>";
}
}
}
}
}
#endregion
#region 热点视频
else if (2 == imodel.HotType)
{
css = "upatta2";
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (DBNull.Value != dt.Rows[i]["AttID"])
{
if (!string.IsNullOrEmpty(dt.Rows[i]["AttID"].ToString()))
{
//var fname = dt.Rows[i]["AttID"].ToString().Substring(36);
var fname = "";
if ("C0pY" == dt.Rows[i]["AttID"].ToString().Substring(0, 4))
{
fname = dt.Rows[i]["AttID"].ToString().Substring(76);
}
else
{
fname = dt.Rows[i]["AttID"].ToString().Substring(36);
}
//var img = "";
//if (1 == imodel.HotType)
//{
// img = "<img width=\"100\" height=\"100\" src=\"/UploadFiles/" +
// dt.Rows[i]["AttID"] + "\">";
//}
//str += "<div class=\"" + css + "\" title=\"" + fname + "\" data-file=\"" +
// dt.Rows[i]["AttID"] +
// "\">" + img +
// (fname.Length > 5 ? fname.Substring(0, 5) + "..." : fname) +
// "<div class=\"load\" style=\"height: 0px;margin-top:0px;\"></div><a href=\"javascript:;\" class=\"del-hotpic\" data-alid=\"" +
// dt.Rows[i]["ALID"] + "\">删除</a></div>";
str += "<div class=\"upatta2\" title=\"" + fname + "\" data-file=\"" +
dt.Rows[i]["AttID"] +
"\"><div class=\"upsigin\"><div class=\"at-file\"><span class=\"at-name\">" +
(fname.Length > 15 ? fname.Substring(0, 15) + "..." : fname) +
"</span></div></div></div>";
}
}
}
}
}
#endregion
#endregion
if (1 == imodel.HotType)
{
rboSingle.Checked = true;
rboDouble.Checked = false;
dorg.Style.Add("display", "block");
dvideo.Style.Add("display", "none");
litHotPic.Text = str;
}
else if (2 == imodel.HotType)
{
rboSingle.Checked = false;
rboDouble.Checked = true;
dvideo.Style.Add("display", "block");
dorg.Style.Add("display", "none");
Literal1.Text = str;
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", false);
ePath = Server.MapPath("/UpLoad/");
try
{
var sortnum = Request.Form["sortnum"];
var itid = Request.Form["itid"];
var batta = HttpUtility.UrlDecode(Request.Form["batta"]);
var tiid = Request.Form["tiid"];
var name = HttpUtility.UrlDecode(Request.Form["name"]);
var iid = Request.Form["iid"];
var context = HttpUtility.UrlDecode(Request.Form["context"]);
var csize = Request.Form["csize"];
var ccolor = Request.Form["ccolor"];
var cposi = Request.Form["cposi"];
if (!string.IsNullOrEmpty(itid))
{
var itmodel = _infoTypeDal.GetModel(Convert.ToInt32(itid));
if (null != itmodel)
{
if (!string.IsNullOrEmpty(iid))
{
var infomodel = _infosDal.GetModel(Convert.ToInt32(iid));
infomodel.IName = name;
infomodel.Context = context;
infomodel.ConColor = ccolor;
infomodel.ConPosition = cposi;
infomodel.ConSize = csize;
if (batta != infomodel.PicAttID)
{
var fi = new FileInfo(ePath + batta);
if (fi.Exists)
{
fi.MoveTo(Server.MapPath("/UploadFiles/" + batta));
if (!string.IsNullOrEmpty(infomodel.PicAttID))
{
var ofi = new FileInfo(Server.MapPath("/UploadFiles/" + infomodel.PicAttID));
if (ofi.Exists)
{
ofi.Delete();
}
}
infomodel.PicAttID = batta;
}
}
var upres = _infosDal.Update(infomodel);
if (upres)
{
Response.Write("0|~|" + iid);
Response.End();
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
else
{
var inmodel = new Admin.Model.Infos();
inmodel.IName = name;
inmodel.Context = context;
inmodel.ConColor = ccolor;
inmodel.ConPosition = cposi;
inmodel.ConSize = csize;
inmodel.Status = 1;
inmodel.IType = 4;
inmodel.TIID = Convert.ToInt32(tiid);
inmodel.NType = 0;
var fi = new FileInfo(ePath + batta);
if (fi.Exists)
{
fi.MoveTo(Server.MapPath("/UploadFiles/" + batta));
inmodel.PicAttID = batta;
}
inmodel.SortNum = Convert.ToInt32(sortnum);
var aiid = _infosDal.Add(inmodel);
Response.Write("0|~|" + aiid);
Response.End();
}
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
Response.Write("1|~|" + ee.Message);
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", true);
if (!IsPostBack)
{
var spid = Request.QueryString["spid"];
if (!string.IsNullOrEmpty(spid))
{
#region 左侧分类
var itid = Request.QueryString["itid"]; //分类id
if (!string.IsNullOrEmpty(itid))
{
var model = _infoTypeDal.GetModel(Convert.ToInt32(itid));
if (null != model)
{
litType.Text = Service.GetType(Convert.ToInt32(model.ITID), spid);
}
}
else
{
litType.Text = Service.GetType(0, spid);
}
#endregion
#region 块内容
var tiid = Request.QueryString["tiid"];
if (!string.IsNullOrEmpty(tiid))
{
TempInfo _tempInfoDal = new TempInfo();
var timodel = _tempInfoDal.GetModel(Convert.ToInt32(tiid));
if (null != timodel)
{
#region 导航
litStaName.Text = Service.Nav(timodel, Request.QueryString["spid"], Request.QueryString["itid"]);
#endregion
#region 分页
var pager = "";
List <SqlParameter> parDef = new List <SqlParameter>();
var preitModel =
_tempInfoDal.GetModel(
" ITID=" + timodel.ITID + " and ParentID=" + timodel.ParentID + " and TIPage=" +
(timodel.TIPage - 1), parDef);
if (null != preitModel)
{
pager += "<td><a href=\"/Manage/Template/Redircet.aspx?itid=" +
Request.QueryString["itid"] + "&spid=" + Request.QueryString["spid"] + "&tiid=" +
preitModel.TIID + "\" class=\"btn btnprev\" data-tiid=\"" + preitModel.TIID +
"\">上页 </a></td>";
}
else
{
pager += "<td> </td>";
}
var count =
_tempInfoDal.GetList(" TIPage is not null and TIPage!='' and ITID=" + timodel.ITID + " and ParentID=" + timodel.ParentID,
parDef).Tables[0].Rows.Count;
if (count > 1)
{
pager +=
"<td>页码 </td><td><input type=\"text\" class=\"form-control input-sm iptpno\" value=\"" +
timodel.TIPage +
"\" style=\"width: 40px;display:inline;text-align: center;\" /> /" + count + "</td><td><input data-parcount=\"" + timodel.ParentID + "\" data-count=\"" + count + "\" type=\"button\" class=\"btn btn-sm repage\" value=\"跳转\" style=\"width: 70px;\" /></td><td><input type=\"button\" class=\"btn btn-sm editpno\" value=\"修改页码\" style=\"width: 70px;\" /></td><td><input type=\"button\" class=\"btn btn-sm delpage\" value=\"删除当前页\"/></td>";
}
else if (count == 1)
{
pager +=
"<td><input type=\"button\" class=\"btn btn-sm delpage\" value=\"删除当前页\"/></td>";
}
var nexitModel =
_tempInfoDal.GetModel(
" ITID=" + timodel.ITID + " and ParentID=" + timodel.ParentID + " and TIPage=" +
(timodel.TIPage + 1), parDef);
if (null != nexitModel)
{
pager += "<td><a href=\"/Manage/Template/Redircet.aspx?itid=" +
Request.QueryString["itid"] + "&spid=" + Request.QueryString["spid"] + "&tiid=" +
nexitModel.TIID + "\" class=\"btn btnnext\" data-tiid=\"" +
nexitModel.TIID + "\">下页 </a></td>";
}
else
{
pager += "<td> </td>";
litNewPage.Text = "<a href=\"/Manage/Systems/ChooseNewsTemplate.aspx?page=" +
(timodel.TIPage + 1) + "&pid=" + timodel.ParentID + "&itid=" +
Request.QueryString["itid"] + "&spid=" + Request.QueryString["spid"] +
"&tiid=" + timodel.TIID + "\" class=\"btn btn-add newpage\" style=\"top:33%\">新建内容页</a> <a href=\"/Manage/News/RedircetAD.aspx?itid=" +
Request.QueryString["itid"] + "&spid=" + Request.QueryString["spid"] + "&tiid=" +
timodel.TIID + "\" class=\"btn btn-add newpage\" style=\"top:53%\">添加文末广告</a>";
}
litPager.Text = pager;
#endregion
#region
var sortNum = 1;
List <SqlParameter> par1 = new List <SqlParameter>();
var tmpPar1 =
_templateParDal.GetModel(" TID=" + timodel.TID + " and SortNum=" + sortNum + " ", par1);
var info1 = _infosDal.GetModel(" TIID=" + timodel.TIID + " and SortNum=" + sortNum + " ",
par1);
if (null != info1)
{
#region 图文资讯反显
var user = (OrgUsers)HttpContext.Current.Session["CurrentUser"];
if (info1.IType == 4)
{
litInfo1.Text =
"<div class=\"btnbox\" style=\"top:54%;display:none\"><a href=\"javascript:;\" class=\"btn edit-info\" data-iid=\"" +
info1.IID + "\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">编辑</a> <a href=\"javascript:;\" class=\"btn del-info\" data-iid=\"" +
info1.IID +
"\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">删除</a>";
if (1 == user.Type)
{
if (1 == info1.Status)
{
litInfo1.Text += " <a href=\"javascript:;\" class=\"btn sin-info btn-warning\" data-iid=\"" +
info1.IID +
"\">标记</a>";
}
else
{
litInfo1.Text += " <a href=\"javascript:;\" class=\"btn sin-info btn-warning\" data-iid=\"" +
info1.IID +
"\">取消标记</a>";
}
}
else
{
if (0 == info1.Status)
{
litInfo1.Text += " <span class=\"btn btn-editing\">待修改</span>";
}
}
litInfo1.Text += "</div>";
litInfo1.Text += "<div class=\"txtbox tbox" + info1.ConPosition + "\"><div class=\"pd\" style=\"font-size:" + info1.ConSize + "px;color:#" + info1.ConColor + "; word-break: break-all;\">" + info1.Context + "</div></div><img src=\"/UploadFiles/" + info1.PicAttID + "\" style=\"height:606px; display:block; width:100%;\">";
List <SqlParameter> par = new List <SqlParameter>();
par.Add(new SqlParameter("@IID", DbType.AnsiString)
{
Value = info1.IID
});
var dt = _adInfosDal.GetListAI(" AdInfos.IID=@IID ", par).Tables[0];
}
#endregion
}
else
{
litInfo1.Text =
"<div class=\"btnbox\"><a href=\"javascript:;\" class=\"btn new-info\" data-sortnum=\"" +
sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">编辑</a>";
//litInfo1.Text += " <a href=\"javascript:;\" class=\"btn select-info\" data-sortnum=\"" +
// sortNum +
// "\">选择</a>";
litInfo1.Text += "</div><img>";
}
#endregion
}
}
#endregion
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", true);
if (!IsPostBack)
{
var spid = Request.QueryString["spid"];
if (!string.IsNullOrEmpty(spid))
{
#region 左侧分类
var itid = Request.QueryString["itid"]; //分类id
if (!string.IsNullOrEmpty(itid))
{
var model = _infoTypeDal.GetModel(Convert.ToInt32(itid));
if (null != model)
{
litType.Text = Service.GetType(Convert.ToInt32(model.ITID), spid);
}
}
else
{
litType.Text = Service.GetType(0, spid);
}
#endregion
#region 块内容
var tiid = Request.QueryString["tiid"];
if (!string.IsNullOrEmpty(tiid))
{
TempInfo _tempInfoDal = new TempInfo();
var timodel = _tempInfoDal.GetModel(Convert.ToInt32(tiid));
if (null != timodel)
{
#region 导航
var ptiid = Request.QueryString["ptiid"];
if (!string.IsNullOrEmpty(ptiid))
{
litStaName.Text = "<div class=\"backup\"><a href=\"/Manage/Template/Redircet.aspx?spid=" + spid + "&itid=" + Request.QueryString["itid"] +
"\" class=\"back_btn backfirst\">返回首页</a><a href=\"/Manage/Template/Redircet.aspx?spid=" + spid +
"&tiid=" + ptiid + "&itid=" + Request.QueryString["itid"] +
"\" class=\"back_btn\">返回上级</a> </div>";
}
else
{
#region 分站名称
StaPackage _staPackageDal = new StaPackage();
OrgOrganize _orgOrganizeDal = new OrgOrganize();
var spmodel = _staPackageDal.GetModel(Convert.ToInt32(spid));
if (null != spmodel)
{
var orgmodel = _orgOrganizeDal.GetModel(Convert.ToInt64(spmodel.OrgId));
if (null != orgmodel)
{
litStaName.Text =
"<div class=\"logo\"><img src=\"/images/LOGO-yt.png\" style=\"display: block; width: 50px; height: 50px;\" alt=\"沿途\" /></div><div class=\"title\"><strong>" +
orgmodel.OrgName + "</strong><span>" + orgmodel.EnName + "</span></div>";
}
}
#endregion
}
#endregion
#region 分页
litPager.Text = "<td><input type=\"button\" class=\"btn btn-sm delpage\" value=\"删除\" style=\"width: 50px;\" /></td>";;
#endregion
#region
var sortNum = 1;
List <SqlParameter> par1 = new List <SqlParameter>();
var tmpPar1 =
_templateParDal.GetModel(" TID=" + timodel.TID + " and SortNum=" + sortNum + " ", par1);
var info1 = _infosDal.GetModel(" TIID=" + timodel.TIID + " and SortNum=" + sortNum + " ",
par1);
if (null != info1)
{
var user = (OrgUsers)HttpContext.Current.Session["CurrentUser"];
#region 纯图广告反显
if (info1.IType == 7)
{
#region 右侧推荐
litInfo1.Text += "<div class=\"txtbox tmenu\"><ul>";
List <SqlParameter> par = new List <SqlParameter>();
par.Add(new SqlParameter("@IID", DbType.AnsiString)
{
Value = info1.IID
});
var dt = _adInfosDal.GetListAI(" AdInfos.IID=@IID ", par).Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows.Count < 6)
{
litInfo1.Text +=
"<li class=\"tit\"><span class=\"btn btnadd add-rec\" data-iid=\"" +
info1.IID +
"\">添加推荐</span> </li>";
}
else
{
litInfo1.Text += "<li class=\"tit\"></li>";
}
for (int i = 0; i < dt.Rows.Count; i++)
{
litInfo1.Text +=
"<li title=\"" +
dt.Rows[i]["IName"] + "\"><span class=\"del del-rec\" data-aiid=\"" +
dt.Rows[i]["AIID"] +
"\">删除</span><a href=\"/Manage/Template/Redircet.aspx?spid=" +
Request.QueryString["spid"] + "&pid=" + dt.Rows[i]["Inf_IID"] +
"&itid=" +
Request.QueryString["itid"] + "\"><span class=\"hot\"></span>" +
(dt.Rows[i]["IName"].ToString().Length > 12
? dt.Rows[i]["IName"].ToString().Substring(0, 12) + "..."
: dt.Rows[i]["IName"].ToString()) + "</a></li>";
}
}
else
{
litInfo1.Text +=
"<li class=\"tit\"><span class=\"btn btnadd add-rec\" data-iid=\"" +
info1.IID +
"\">添加推荐</span> </li>";
}
litInfo1.Text += " </ul></div>";
#endregion
litInfo1.Text +=
"<div class=\"btnbox\" style=\"top:54%;right:10%;display:none\"><a href=\"javascript:;\" class=\"btn edit-info\" data-iid=\"" +
info1.IID + "\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">编辑</a> <a href=\"javascript:;\" class=\"btn del-info\" data-iid=\"" +
info1.IID +
"\" data-sortnum=\"" + sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">删除</a>";
if (1 == user.Type)
{
if (1 == info1.Status)
{
litInfo1.Text += " <a href=\"javascript:;\" class=\"btn sin-info btn-warning\" data-iid=\"" +
info1.IID +
"\">标记</a>";
}
else
{
litInfo1.Text += " <a href=\"javascript:;\" class=\"btn sin-info btn-warning\" data-iid=\"" +
info1.IID +
"\">取消标记</a>";
}
}
else
{
if (0 == info1.Status)
{
litInfo1.Text += " <span class=\"btn btn-editing\">待修改</span>";
}
}
litInfo1.Text += "</div><img style=\"height: 606px; display: block; width: 756px;\" src=\"/UploadFiles/" + info1.PicAttID + "\">";
}
#endregion
}
else
{
litInfo1.Text =
"<div class=\"btnbox\"><a href=\"javascript:;\" class=\"btn new-info\" data-sortnum=\"" +
sortNum +
"\" data-bgw=\"" + tmpPar1.BgWidth + "\" data-bgh=\"" + tmpPar1.BgHeight +
"\">新增</a>";
//litInfo1.Text += " <a href=\"javascript:;\" class=\"btn select-info\" data-sortnum=\"" +
// sortNum +
// "\">选择</a>";
litInfo1.Text += "</div><img>";
}
#endregion
}
}
#endregion
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", true);
var iid = Request.QueryString["siid"];
var tiid = Request.QueryString["tiid"];
if (!string.IsNullOrEmpty(iid) && !string.IsNullOrEmpty(tiid))
{
try
{
var imodel = _infosDal.GetModel(Convert.ToInt32(iid));
if (null != imodel)
{
var timodel = _tempInfoDal.GetModel(Convert.ToInt32(tiid));
if (null != timodel)
{
Database db = DatabaseFactory.CreateDatabase();
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
DbTransaction trans = conn.BeginTransaction();
try
{
AddInfo(db, trans, imodel, Convert.ToInt32(tiid), Convert.ToInt32(timodel.ITID));
trans.Commit();
conn.Close();
Response.Write("0|~|");
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
trans.Rollback();
conn.Close();
Response.Write("1|~|" + ee.Message);
Response.End();
}
}
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
Response.Write("1|~|" + ee.Message);
Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", false);
if (!IsPostBack)
{
litselinfo.Text = GetDdl("");
var iid = Request.QueryString["iid"];
if (!string.IsNullOrEmpty(iid))
{
dorg.Visible = false;
rbNews.Disabled = true;
rbVideo.Disabled = true;
rbTopic.Disabled = true;
var imodel = _infosDal.GetModel(Convert.ToInt32(iid));
if (null != imodel)
{
txtName.Value = imodel.IName;
if (!string.IsNullOrEmpty(imodel.PicAttID))
{
var fname = "";
if ("C0pY" == imodel.PicAttID.Substring(0, 4))
{
fname = imodel.PicAttID.Substring(76);
}
else
{
fname = imodel.PicAttID.Substring(36);
}
litPic.Text =
"<div class=\"upatta\" title=\"" + fname + "\" data-file=\"" + imodel.PicAttID + "\"><div class=\"upsigin\"><div class=\"at-file\"><img width=\"220\" id=\"at-img\" src=\"/UploadFiles/" + imodel.PicAttID + "\"><span class=\"at-name\">" + (fname.Length > 15 ? fname.Substring(0, 15) + "..." : fname) + "</span></div></div></div>";
}
if (imodel.NType == 0)
{
radInfo.Checked = true;
}
if (imodel.NType == 1)
{
radAds.Checked = true;
}
if (imodel.IType == 1)
{
rbNews.Checked = true;
}
if (imodel.IType == 2)
{
rbVideo.Checked = true;
dorg.Visible = true;
#region 内容视频
if (!string.IsNullOrEmpty(imodel.VideoAttID))
{
//var vname = imodel.VideoAttID.Substring(36);
var vname = "";
if ("C0pY" == imodel.VideoAttID.Substring(0, 4))
{
vname = imodel.VideoAttID.Substring(76);
}
else
{
vname = imodel.VideoAttID.Substring(36);
}
litVideo.Text =
"<div class=\"upatta2\" title=\"" + vname + "\" data-file=\"" +
imodel.VideoAttID +
"\"><div class=\"upsigin\"><div class=\"at-file\"><span class=\"at-name\">" +
(vname.Length > 15 ? vname.Substring(0, 15) + "..." : vname) +
"</span></div></div></div>";
}
#endregion
#region 暂停广告
if (!string.IsNullOrEmpty(imodel.ADPic))
{
var fname = "";
if ("C0pY" == imodel.ADPic.Substring(0, 4))
{
fname = imodel.ADPic.Substring(76);
}
else
{
fname = imodel.ADPic.Substring(36);
}
litpausepic.Text =
"<div class=\"upatta5\" title=\"" + fname + "\" data-file=\"" + imodel.ADPic +
"\"><div class=\"upsigin\"><div class=\"at-file\"><img width=\"220\" id=\"at-img\" src=\"/UploadFiles/" +
imodel.ADPic + "\"><span class=\"at-name\">" +
(fname.Length > 15 ? fname.Substring(0, 15) + "..." : fname) +
"</span></div>";
litpausepic.Text += GetDdl(imodel.ADLink);
litpausepic.Text += "</div></div>";
}
#endregion
#region 广告视频
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@IID", DbType.AnsiString)
{
Value = iid
});
var dt = _attaListDal.GetList(" IID=@IID ", parameters).Tables[0];
var str = "";
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
if (DBNull.Value != dt.Rows[i]["AttID"])
{
if (!string.IsNullOrEmpty(dt.Rows[i]["AttID"].ToString()))
{
//var fname = dt.Rows[i]["AttID"].ToString().Substring(36);
var fname = "";
if ("C0pY" == dt.Rows[i]["AttID"].ToString().Substring(0, 4))
{
fname = dt.Rows[i]["AttID"].ToString().Substring(76);
}
else
{
fname = dt.Rows[i]["AttID"].ToString().Substring(36);
}
str +=
"<div class=\"upatta6\" title=\"" + fname + "\" data-file=\"" + dt.Rows[i]["AttID"] +
"\"><div class=\"upsigin\"><div class=\"at-file\"><span class=\"at-name\">" +
(fname.Length > 15 ? fname.Substring(0, 15) + "..." : fname) +
"</span></div>";
str += GetDdl(dt.Rows[i]["AD_IID"].ToString());
str += "<span><a href=\"javascript:void(0)\" class=\"glyphicon glyphicon-remove delfile\" data-attid=\"" + dt.Rows[i]["AttID"].ToString() + "\" title=\"移除文件\">删除</a></span>";
str += "</div></div>";
}
}
}
}
litpausevideo.Text = str;
#endregion
txtADTime.Value = imodel.ADTime;
}
if (imodel.IType == 3)
{
rbTopic.Checked = true;
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", true);
var iid = Request.QueryString["iid"];
if (!string.IsNullOrEmpty(iid))
{
try
{
var imodel = _infosDal.GetModel(Convert.ToInt32(iid));
if (null != imodel)
{
Database db = DatabaseFactory.CreateDatabase();
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
DbTransaction trans = conn.BeginTransaction();
try
{
var templatesql = "select TIID from TempInfo where ParentID=" + iid;
DbCommand dbComTemplate = db.GetSqlStringCommand(templatesql);
var dt = db.ExecuteDataSet(dbComTemplate, trans).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DelTemplate(db, trans, Convert.ToInt32(dt.Rows[i]["TIID"]));
}
}
var delinfo = "delete from InfoLabel where IID=" + iid + ";delete from AdInfos where Inf_IID=" + iid + ";delete from AdInfos where IID=" + iid + ";delete from AttaList where IID=" + iid + ";delete from Infos where IID=" + iid;
DbCommand dbComDelInfo = db.GetSqlStringCommand(delinfo);
db.ExecuteNonQuery(dbComDelInfo, trans);
trans.Commit();
conn.Close();
Response.Write("0|~|");
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
trans.Rollback();
conn.Close();
Response.Write("1|~|" + ee.Message);
Response.End();
}
}
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
Response.Write("1|~|" + ee.Message);
Response.End();
}
}
}
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 vatta = HttpUtility.UrlDecode(Request.QueryString["vatta"]);
var tiid = Request.QueryString["tiid"];
var itype = Request.QueryString["itype"];
var name = HttpUtility.UrlDecode(Request.QueryString["name"]);
var iid = Request.QueryString["iid"];
var labs = Request.QueryString["labs"];
var ntype = Request.QueryString["ntype"];
var adpause = HttpUtility.UrlDecode(Request.QueryString["adpause"]);
var pausetime = Request.QueryString["pausetime"];
var adpausepic = HttpUtility.UrlDecode(Request.QueryString["adpausepic"]);
var adpauseid = Request.QueryString["adpauseid"];
var adpausepicid = Request.QueryString["adpausepicid"];
if (!string.IsNullOrEmpty(itid))
{
var itmodel = _infoTypeDal.GetModel(Convert.ToInt32(itid));
if (null != itmodel)
{
#region 修改info
if (!string.IsNullOrEmpty(iid))
{
Database db = DatabaseFactory.CreateDatabase();
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
DbTransaction trans = conn.BeginTransaction();
try
{
var infomodel = _infosDal.GetModel(Convert.ToInt32(iid));
infomodel.IName = name;
infomodel.NType = Convert.ToInt32(ntype);
infomodel.ADTime = pausetime;
#region 背景图片
if (batta != infomodel.PicAttID)
{
var fi = new FileInfo(ePath + batta);
if (fi.Exists)
{
fi.MoveTo(Server.MapPath("/UploadFiles/" + batta));
if (!string.IsNullOrEmpty(infomodel.PicAttID))
{
var ofi =
new FileInfo(Server.MapPath("/UploadFiles/" + infomodel.PicAttID));
if (ofi.Exists)
{
ofi.Delete();
}
}
infomodel.PicAttID = batta;
}
}
#endregion
if ("2" == itype)
{
#region 内容视频
if (vatta != infomodel.VideoAttID)
{
var fi = new FileInfo(ePath + vatta);
if (fi.Exists)
{
fi.MoveTo(Server.MapPath("/UploadFiles/" + vatta));
if (!string.IsNullOrEmpty(infomodel.VideoAttID))
{
var ofi =
new FileInfo(
Server.MapPath("/UploadFiles/" + infomodel.VideoAttID));
if (ofi.Exists)
{
ofi.Delete();
}
}
infomodel.VideoAttID = vatta;
}
}
#endregion
#region 广告图片
if (!string.IsNullOrEmpty(adpausepic) && "undefined" != adpausepic)
{
if (infomodel.ADPic != adpausepic)
{
var vfi = new FileInfo(ePath + adpausepic);
if (vfi.Exists)
{
vfi.MoveTo(Server.MapPath("/UploadFiles/" + adpausepic));
infomodel.ADPic = adpausepic;
}
}
}
infomodel.ADLink = adpausepicid;
#endregion
#region 修改广告视频
List <SqlParameter> parameters = new List <SqlParameter>();
var dtatta = _attaListDal.GetList(" IID=" + infomodel.IID, parameters).Tables[0];
if (!string.IsNullOrEmpty(adpause))
{
var advArray = adpause.Split(':');
var addadvList = "";
var advidarray = adpauseid.Split(':');
for (int i = 0; i < advArray.Length; i++)
{
if (!string.IsNullOrEmpty(advArray[i]))
{
var dr = dtatta.Select(" AttID='" + advArray[i] + "' ");
if (dr.Length <= 0)
{
var vfi = new FileInfo(ePath + advArray[i]);
if (vfi.Exists)
{
vfi.MoveTo(Server.MapPath("/UploadFiles/" + advArray[i]));
addadvList +=
"insert into AttaList(AttID,IID,AD_IID) values (N'" +
advArray[i] + "','" +
infomodel.IID + "','" + advidarray[i] + "');";
}
}
else
{
if (advidarray[i] != dr[0]["AD_IID"].ToString())
{
addadvList += "update AttaList set AD_IID='" + advidarray[i] + "' where ALID='" + dr[0]["ALID"] + "';";
}
}
}
}
if (!string.IsNullOrEmpty(addadvList))
{
DbCommand dbComAddadvList = db.GetSqlStringCommand(addadvList);
db.ExecuteNonQuery(dbComAddadvList, trans);
}
if (dtatta.Rows.Count > 0)
{
for (int i = 0; i < dtatta.Rows.Count; i++)
{
if (!advArray.Contains(dtatta.Rows[i]["AttID"]))
{
var del = "delete from AttaList where ALID='" +
dtatta.Rows[i]["ALID"] +
"'; ";
DbCommand dbCommanddel = db.GetSqlStringCommand(del);
db.ExecuteNonQuery(dbCommanddel, trans);
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, trans);
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 更新info
StringBuilder strSqlUpdate = new StringBuilder();
strSqlUpdate.Append("update Infos set ");
strSqlUpdate.Append("IName=@IName,");
strSqlUpdate.Append("PicAttID=@PicAttID,");
strSqlUpdate.Append("VideoAttID=@VideoAttID,");
strSqlUpdate.Append("NType=@NType,");
strSqlUpdate.Append("ADTime=@ADTime,");
strSqlUpdate.Append("ADPic=@ADPic,");
strSqlUpdate.Append("ADLink=@ADLink");
strSqlUpdate.Append(" where IID=@IID ");
DbCommand dbCommandUpdate = db.GetSqlStringCommand(strSqlUpdate.ToString());
db.AddInParameter(dbCommandUpdate, "IID", DbType.Int32, infomodel.IID);
db.AddInParameter(dbCommandUpdate, "IName", DbType.String, infomodel.IName);
db.AddInParameter(dbCommandUpdate, "PicAttID", DbType.String, infomodel.PicAttID);
db.AddInParameter(dbCommandUpdate, "VideoAttID", DbType.String, infomodel.VideoAttID);
db.AddInParameter(dbCommandUpdate, "NType", DbType.Byte, infomodel.NType);
db.AddInParameter(dbCommandUpdate, "ADTime", DbType.String, infomodel.ADTime);
db.AddInParameter(dbCommandUpdate, "ADPic", DbType.String, infomodel.ADPic);
db.AddInParameter(dbCommandUpdate, "ADLink", DbType.String, infomodel.ADLink);
db.ExecuteNonQuery(dbCommandUpdate);
#endregion
var dellab = "delete from InfoLabel where IID=" + infomodel.IID;
DbCommand dbCommand = db.GetSqlStringCommand(dellab);
db.ExecuteNonQuery(dbCommand, trans);
if (!string.IsNullOrEmpty(labs))
{
StringBuilder strSqlAddLab = new StringBuilder();
var labArray = labs.Split(',');
foreach (var alid in labArray)
{
if (!string.IsNullOrEmpty(alid))
{
strSqlAddLab.Append("insert into InfoLabel(");
strSqlAddLab.Append("IID,ALID)");
strSqlAddLab.Append(" values (");
strSqlAddLab.Append("'" + infomodel.IID + "','" + alid + "')");
}
}
if (!string.IsNullOrEmpty(strSqlAddLab.ToString()))
{
DbCommand dbCommandAddLab = db.GetSqlStringCommand(strSqlAddLab.ToString());
db.ExecuteNonQuery(dbCommandAddLab, trans);
}
}
trans.Commit();
conn.Close();
Response.Write("0|~|" + infomodel.IID);
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
trans.Rollback();
conn.Close();
Response.Write("1|~|" + ee.Message);
Response.End();
}
}
}
#endregion
#region 新增info
else
{
var sql = " TIID='" + tiid + "' and SortNum='" + sortnum + "' ";
var exit = _infosDal.GetModel(sql, new List <SqlParameter>());
if (null != exit)
{
Response.Write("1|~|操作失败");
Response.End();
}
Database db = DatabaseFactory.CreateDatabase();
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
DbTransaction trans = conn.BeginTransaction();
try
{
#region 新增info
var picattid = "";
var fi = new FileInfo(ePath + batta);
if (fi.Exists)
{
fi.MoveTo(Server.MapPath("/UploadFiles/" + batta));
picattid = batta;
}
var videoatta = "";
if (!string.IsNullOrEmpty(vatta))
{
var vfi = new FileInfo(ePath + vatta);
if (vfi.Exists)
{
vfi.MoveTo(Server.MapPath("/UploadFiles/" + vatta));
videoatta = vatta;
}
}
var papic = "";
if (!string.IsNullOrEmpty(adpausepic) && "undefined" != adpausepic)
{
var vfi = new FileInfo(ePath + adpausepic);
if (vfi.Exists)
{
vfi.MoveTo(Server.MapPath("/UploadFiles/" + adpausepic));
papic = adpausepic;
}
}
var papicid = "";
if (!string.IsNullOrEmpty(adpausepicid) && "undefined" != adpausepicid)
{
papicid = adpausepicid;
}
StringBuilder addinfo = new StringBuilder();
addinfo.Append("insert into Infos(");
addinfo.Append(
"IName,PicAttID,IType,TIID,SortNum,Status,VideoAttID,NType,ADTime,ADPic,ADLink)");
addinfo.Append(" values (");
addinfo.Append(
"@IName,@PicAttID,@IType,@TIID,@SortNum,@Status,@VideoAttID,@NType,@ADTime,@ADPic,@ADLink)");
addinfo.Append(";select @@IDENTITY");
DbCommand dbComAddInfo = db.GetSqlStringCommand(addinfo.ToString());
db.AddInParameter(dbComAddInfo, "IName", DbType.String, name);
db.AddInParameter(dbComAddInfo, "PicAttID", DbType.String, picattid);
db.AddInParameter(dbComAddInfo, "IType", DbType.Int32, itype);
db.AddInParameter(dbComAddInfo, "TIID", DbType.Int32, tiid);
db.AddInParameter(dbComAddInfo, "SortNum", DbType.Int32, sortnum);
db.AddInParameter(dbComAddInfo, "Status", DbType.Byte, 1);
db.AddInParameter(dbComAddInfo, "VideoAttID", DbType.String, videoatta);
db.AddInParameter(dbComAddInfo, "NType", DbType.Byte, ntype);
db.AddInParameter(dbComAddInfo, "ADTime", DbType.String, pausetime);
db.AddInParameter(dbComAddInfo, "ADPic", DbType.String, papic);
db.AddInParameter(dbComAddInfo, "ADLink", DbType.String, papicid);
object niid = db.ExecuteScalar(dbComAddInfo, trans);
#endregion
#region 新增lab
if (!string.IsNullOrEmpty(labs))
{
var labArray = labs.Split(',');
var addlabList = "";
foreach (var s in labArray)
{
if (!string.IsNullOrEmpty(s))
{
addlabList += "insert into InfoLabel(IID,ALID) values ('" +
niid + "','" + s + "');";
}
}
DbCommand dbComAddlabList = db.GetSqlStringCommand(addlabList);
db.ExecuteNonQuery(dbComAddlabList, trans);
}
#endregion
#region 新增广告视频
if (!string.IsNullOrEmpty(adpause))
{
var advArray = adpause.Split(':');
var addadvList = "";
var advidarray = adpauseid.Split(':');
for (int i = 0; i < advArray.Length; i++)
{
if (!string.IsNullOrEmpty(advArray[i]))
{
var vfi = new FileInfo(ePath + advArray[i]);
if (vfi.Exists)
{
vfi.MoveTo(Server.MapPath("/UploadFiles/" + advArray[i]));
addadvList += "insert into AttaList(AttID,IID,AD_IID) values (N'" + advArray[i] + "','" +
niid + "','" + advidarray[i] + "');";
}
}
}
DbCommand dbComAddadvList = db.GetSqlStringCommand(addadvList);
db.ExecuteNonQuery(dbComAddadvList, trans);
}
#endregion
trans.Commit();
conn.Close();
Response.Write("0|~|" + niid);
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
trans.Rollback();
conn.Close();
Response.Write("1|~|" + ee.Message);
Response.End();
}
}
}
#endregion
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
Response.Write("1|~|" + ee.Message);
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", false);
if (!IsPostBack)
{
#region 模板id
var tiid = Request.QueryString["tiid"];
var itid = Request.QueryString["itid"];
var spid = Request.QueryString["spid"];
var pid = Request.QueryString["pid"];
var repage = Request.QueryString["repage"];
var parcount = Request.QueryString["parcount"];
if (!string.IsNullOrEmpty(repage) && !string.IsNullOrEmpty(parcount))
{
List <SqlParameter> parDef = new List <SqlParameter>();
parDef.Add(new SqlParameter("@ParentID", DbType.AnsiString)
{
Value = parcount
});
parDef.Add(new SqlParameter("@TIPage", DbType.AnsiString)
{
Value = repage
});
parDef.Add(new SqlParameter("@ITID", DbType.AnsiString)
{
Value = itid
});
var model = _tempInfoDal.GetModel(" ParentID=@ParentID and TIPage=@TIPage and ITID=@ITID ", parDef);
if (null != model)
{
var template = _templatesDal.GetModel(Convert.ToInt32(model.TID));
if (null != template)
{
Response.Redirect(template.TLink + "?itid=" + model.ITID + "&tiid=" + model.TIID + "&spid=" + spid, true);
}
}
}
else if (!string.IsNullOrEmpty(tiid))
{
var model = _tempInfoDal.GetModel(Convert.ToInt32(tiid));
if (null != model)
{
var template = _templatesDal.GetModel(Convert.ToInt32(model.TID));
if (null != template)
{
Response.Redirect(template.TLink + "?itid=" + model.ITID + "&tiid=" + tiid + "&spid=" + spid, true);
}
}
}
else if (!string.IsNullOrEmpty(pid))
{
List <SqlParameter> parDef = new List <SqlParameter>();
parDef.Add(new SqlParameter("@ParentID", DbType.AnsiString)
{
Value = pid
});
var timodel = _tempInfoDal.GetModel(" ParentID=@ParentID and TIPage=1 ", parDef);
if (null != timodel)
{
var template = _templatesDal.GetModel(Convert.ToInt32(timodel.TID));
if (null != template)
{
var itmodel = _infoTypeDal.GetModel(Convert.ToInt32(timodel.ITID));
Response.Redirect(template.TLink + "?itid=" + timodel.ITID + "&tiid=" + timodel.TIID + "&spid=" + itmodel.SPID,
true);
}
}
else
{
var imodel = _infosDal.GetModel(Convert.ToInt32(pid));
if (null != imodel)
{
var tiModel = _tempInfoDal.GetModel(Convert.ToInt32(imodel.TIID));
if (null != tiModel)
{
var itmodel = _infoTypeDal.GetModel(Convert.ToInt32(tiModel.ITID));
if (null != itmodel)
{
Response.Redirect("/Manage/Systems/CreateFirstPage.aspx" + "?page=1&spid=" + itmodel.SPID + "&itid=" + itmodel.ITID + "&pid=" + pid, true);
}
}
}
}
}
else if (!string.IsNullOrEmpty(itid))
{
var model = _infoTypeDal.GetModel(Convert.ToInt32(itid));
if (null != model)
{
List <SqlParameter> parDef = new List <SqlParameter>();
var itModel = _tempInfoDal.GetModel(" ITID=" + itid + " and TIPage=1 and ParentID=0 ", parDef);
if (null != itModel)
{
var template = _templatesDal.GetModel(Convert.ToInt32(itModel.TID));
if (null != template)
{
Response.Redirect(template.TLink + "?spid=" + model.SPID + "&tiid=" + itModel.TIID + "&itid=" + itid, true);
}
}
else
{
Response.Redirect("/Manage/Systems/CreateFirstPage.aspx" + "?page=1&spid=" + model.SPID + "&itid=" + itid, true);
}
}
}
else if (!string.IsNullOrEmpty(spid))
{
List <SqlParameter> parDef = new List <SqlParameter>();
parDef.Add(new SqlParameter("@SPID", DbType.AnsiString)
{
Value = spid
});
var itmodel = _infoTypeDal.GetModel(" SPID=@SPID and SortNum=1 ", parDef);
if (null != itmodel)
{
List <SqlParameter> parDef1 = new List <SqlParameter>();
var tiModel = _tempInfoDal.GetModel(" ITID=" + itmodel.ITID + " and TIPage=1 and ParentID=0 ", parDef1);
if (null != tiModel)
{
var template = _templatesDal.GetModel(Convert.ToInt32(tiModel.TID));
if (null != template)
{
Response.Redirect(template.TLink + "?itid=" + itmodel.ITID + "&tiid=" + tiModel.TIID + "&spid=" + itmodel.SPID, true);
}
}
else
{
Response.Redirect("/Manage/Systems/CreateFirstPage.aspx" + "?page=1&spid=" + itmodel.SPID + "&itid=" + itmodel.ITID, true);
}
}
else
{
Response.Redirect("/Manage/Systems/CreateFirstPage.aspx?page=1&spid=" + spid, true);
}
}
#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
VerifyPage("", true);
var iid = Request.QueryString["iid"];
if (!string.IsNullOrEmpty(iid))
{
try
{
var imodel = _infosDal.GetModel(Convert.ToInt32(iid));
if (null != imodel)
{
Database db = DatabaseFactory.CreateDatabase();
using (DbConnection conn = db.CreateConnection())
{
conn.Open();
DbTransaction trans = conn.BeginTransaction();
try
{
var templatesql = "select TIID from TempInfo where ParentID=" + iid;
DbCommand dbComTemplate = db.GetSqlStringCommand(templatesql);
var dt = db.ExecuteDataSet(dbComTemplate, trans).Tables[0];
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DelTemplate(db, trans, Convert.ToInt32(dt.Rows[i]["TIID"]));
}
}
#region
var Attas = new StringBuilder();
Attas.Append(" select * from AttaList where IID=" + iid);
DbCommand dbComAttList = db.GetSqlStringCommand(Attas.ToString());
var dtAttList1 = db.ExecuteDataSet(dbComAttList, trans).Tables[0];
dtAttList.Merge(dtAttList1);
var Infos = new StringBuilder();
Infos.Append(" select * from Infos where IID=" + iid);
DbCommand dbComInfos = db.GetSqlStringCommand(Infos.ToString());
var dtInfos1 = db.ExecuteDataSet(dbComInfos, trans).Tables[0];
dtInfos.Merge(dtInfos1);
#endregion
var delinfo = "delete from InfoLabel where IID=" + iid + ";delete from AdInfos where Inf_IID=" + iid + ";delete from AdInfos where IID=" + iid + ";delete from AttaList where IID=" + iid + ";delete from Infos where IID=" + iid;
DbCommand dbComDelInfo = db.GetSqlStringCommand(delinfo);
db.ExecuteNonQuery(dbComDelInfo, trans);
trans.Commit();
conn.Close();
#region delete files
if (dtAttList.Rows.Count > 0)
{
for (int i = 0; i < dtAttList.Rows.Count; i++)
{
try
{
var oldbpic =
new FileInfo(
HttpContext.Current.Server.MapPath("/UploadFiles/" + dtAttList.Rows[i]["AttID"]));
if (!string.IsNullOrEmpty(dtAttList.Rows[i]["AttID"].ToString()) && oldbpic.Exists)
{
oldbpic.Delete();
}
}
catch (Exception)
{
}
}
}
if (dtInfos.Rows.Count > 0)
{
for (int i = 0; i < dtInfos.Rows.Count; i++)
{
try
{
var oldbpic =
new FileInfo(
HttpContext.Current.Server.MapPath("/UploadFiles/" + dtInfos.Rows[i]["PicAttID"]));
if (!string.IsNullOrEmpty(dtInfos.Rows[i]["PicAttID"].ToString()) && oldbpic.Exists)
{
oldbpic.Delete();
}
}
catch (Exception)
{
}
try
{
var oldbpic1 =
new FileInfo(
HttpContext.Current.Server.MapPath("/UploadFiles/" +
dtInfos.Rows[i]["VideoAttID"]));
if (!string.IsNullOrEmpty(dtInfos.Rows[i]["VideoAttID"].ToString()) && oldbpic1.Exists)
{
oldbpic1.Delete();
}
}
catch (Exception)
{
}
try
{
var oldbpic2 =
new FileInfo(
HttpContext.Current.Server.MapPath("/UploadFiles/" + dtInfos.Rows[i]["ADPic"]));
if (!string.IsNullOrEmpty(dtInfos.Rows[i]["ADPic"].ToString()) && oldbpic2.Exists)
{
oldbpic2.Delete();
}
}
catch (Exception)
{
}
}
}
if (dtTempInfo.Rows.Count > 0)
{
for (int i = 0; i < dtTempInfo.Rows.Count; i++)
{
try
{
var oldbpic =
new FileInfo(
HttpContext.Current.Server.MapPath("/UploadFiles/" + dtTempInfo.Rows[i]["AttID"]));
if (!string.IsNullOrEmpty(dtTempInfo.Rows[i]["AttID"].ToString()) && oldbpic.Exists)
{
oldbpic.Delete();
}
}
catch (Exception)
{
}
}
}
#endregion
Response.Write("0|~|");
Response.End();
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
trans.Rollback();
conn.Close();
Response.Write("1|~|" + ee.Message);
Response.End();
}
}
}
else
{
Response.Write("1|~|操作失败");
Response.End();
}
}
catch (System.Threading.ThreadAbortException ex)
{
}
catch (Exception ee)
{
Response.Write("1|~|" + ee.Message);
Response.End();
}
}
}
