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(); } } }