//private object AddInfo(Database db, DbTransaction trans, Admin.Model.Infos oldinfomodel, int tiid, int itid) //{ // #region 新增info // var oldbpic = new FileInfo(Server.MapPath("/UploadFiles/" + oldinfomodel.PicAttID)); // var newPicAttaId = ""; // if ("" != oldinfomodel.PicAttID && oldbpic.Exists) // { // newPicAttaId = Guid.NewGuid().ToString(); // newPicAttaId = newPicAttaId + oldinfomodel.PicAttID.Substring(36); // oldbpic.CopyTo(Server.MapPath("/UploadFiles/" + newPicAttaId)); // } // var newVAttaId = ""; // if (!string.IsNullOrEmpty(oldinfomodel.VideoAttID)) // { // var oldvideo = new FileInfo(Server.MapPath("/UploadFiles/" + oldinfomodel.VideoAttID)); // newVAttaId = Guid.NewGuid().ToString(); // if (oldvideo.Exists) // { // newVAttaId = newVAttaId + oldinfomodel.VideoAttID.Substring(36); // oldvideo.CopyTo(Server.MapPath("/UploadFiles/" + newVAttaId)); // } // else // { // newVAttaId = oldinfomodel.VideoAttID; // } // } // StringBuilder addinfo = new StringBuilder(); // addinfo.Append("insert into Infos("); // addinfo.Append( // "IName,PicAttID,IType,TIID,LID,SortNum,Status,CreateDate,Context,ConPosition,ConColor,ConSize,XPosition,YPosition,VideoAttID)"); // addinfo.Append(" values ("); // addinfo.Append( // "@IName,@PicAttID,@IType,@TIID,@LID,@SortNum,@Status,@CreateDate,@Context,@ConPosition,@ConColor,@ConSize,@XPosition,@YPosition,@VideoAttID)"); // addinfo.Append(";select @@IDENTITY"); // DbCommand dbComAddInfo = db.GetSqlStringCommand(addinfo.ToString()); // db.AddInParameter(dbComAddInfo, "IName", DbType.String, oldinfomodel.IName); // db.AddInParameter(dbComAddInfo, "PicAttID", DbType.String, newPicAttaId); // db.AddInParameter(dbComAddInfo, "IType", DbType.Int32, oldinfomodel.IType); // db.AddInParameter(dbComAddInfo, "TIID", DbType.Int32, tiid); // db.AddInParameter(dbComAddInfo, "LID", DbType.Int32, oldinfomodel.LID); // db.AddInParameter(dbComAddInfo, "SortNum", DbType.Int32, oldinfomodel.SortNum); // db.AddInParameter(dbComAddInfo, "Status", DbType.Byte, oldinfomodel.Status); // db.AddInParameter(dbComAddInfo, "CreateDate", DbType.DateTime, oldinfomodel.CreateDate); // db.AddInParameter(dbComAddInfo, "Context", DbType.String, oldinfomodel.Context); // db.AddInParameter(dbComAddInfo, "ConPosition", DbType.String, oldinfomodel.ConPosition); // db.AddInParameter(dbComAddInfo, "ConColor", DbType.String, oldinfomodel.ConColor); // db.AddInParameter(dbComAddInfo, "ConSize", DbType.String, oldinfomodel.ConSize); // db.AddInParameter(dbComAddInfo, "XPosition", DbType.String, oldinfomodel.XPosition); // db.AddInParameter(dbComAddInfo, "YPosition", DbType.String, oldinfomodel.YPosition); // db.AddInParameter(dbComAddInfo, "VideoAttID", DbType.String, newVAttaId); // object niid = db.ExecuteScalar(dbComAddInfo, trans); // #endregion // #region 新增InfoLabel // var infolabel = "select * from InfoLabel where IID=" + oldinfomodel.IID; // DbCommand dbComInfoLabel = db.GetSqlStringCommand(infolabel); // var dtInfoLabel = db.ExecuteDataSet(dbComInfoLabel, trans).Tables[0]; // if (dtInfoLabel.Rows.Count > 0) // { // var addinfolabel = ""; // for (int i = 0; i < dtInfoLabel.Rows.Count; i++) // { // addinfolabel += "insert into InfoLabel(IID,ALID) values ('" + niid + "','" + // dtInfoLabel.Rows[i]["ALID"] + "');"; // } // DbCommand dbComAddInfoLabel = db.GetSqlStringCommand(addinfolabel); // db.ExecuteNonQuery(dbComAddInfoLabel, trans); // } // #endregion // #region 新增AdInfo // var adInfo = "select * from AdInfos where IID=" + oldinfomodel.IID; // DbCommand dbComAdInfo = db.GetSqlStringCommand(adInfo); // var dtAdInfo = db.ExecuteDataSet(dbComAdInfo, trans).Tables[0]; // if (dtAdInfo.Rows.Count > 0) // { // var addAdInfo = ""; // for (int i = 0; i < dtAdInfo.Rows.Count; i++) // { // addAdInfo += "insert into AdInfos(IID,Inf_IID) values ('" + niid + "','" + // dtAdInfo.Rows[i]["Inf_IID"] + "');"; // } // DbCommand dbComAddAdInfo = db.GetSqlStringCommand(addAdInfo); // db.ExecuteNonQuery(dbComAddAdInfo, trans); // } // #endregion // #region 新增AttaList // var attalist = "select * from AttaList where IID=" + oldinfomodel.IID; // DbCommand dbComAttaList = db.GetSqlStringCommand(attalist); // var dtAttaList = db.ExecuteDataSet(dbComAttaList, trans).Tables[0]; // if (dtAttaList.Rows.Count > 0) // { // var addAttaList = ""; // for (int i = 0; i < dtAttaList.Rows.Count; i++) // { // var oldfile = new FileInfo(Server.MapPath("/UploadFiles/" + dtAttaList.Rows[i]["AttID"])); // var newAttaId = ""; // if ("" != dtAttaList.Rows[i]["AttID"].ToString() && oldfile.Exists) // { // newAttaId = Guid.NewGuid().ToString(); // newAttaId = newAttaId + dtAttaList.Rows[i]["AttID"].ToString().Substring(36); // oldfile.CopyTo(Server.MapPath("/UploadFiles/" + newAttaId)); // } // addAttaList += "insert into AttaList(AttID,IID) values ('" + // newAttaId + "','" + niid + "');"; // } // DbCommand dbComAddAttaList = db.GetSqlStringCommand(addAttaList); // db.ExecuteNonQuery(dbComAddAttaList, trans); // } // #endregion // #region 新增TemplateInfo // var templatesql = "select * from TempInfo where ParentID=" + oldinfomodel.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++) // { // var addTempInfo = ""; // var attidbp = dt.Rows[i]["AttID"]; // var newAttaId = ""; // if (DBNull.Value != attidbp) // { // if (!string.IsNullOrEmpty(attidbp.ToString())) // { // var oldfile = new FileInfo(Server.MapPath("/UploadFiles/" + attidbp)); // if (oldfile.Exists) // { // newAttaId = Guid.NewGuid().ToString(); // newAttaId = newAttaId + attidbp.ToString().Substring(36); // oldfile.CopyTo(Server.MapPath("/UploadFiles/" + newAttaId)); // } // } // } // if (dt.Rows[i]["TIPage"] == DBNull.Value) // { // addTempInfo = "insert into TempInfo(ITID,TID,ParentID,AttID) values ('" + itid + // "','" + dt.Rows[i]["TID"] + "','" + niid + "','" + newAttaId + "');select @@IDENTITY"; // } // else // { // addTempInfo = "insert into TempInfo(ITID,TID,TIPage,ParentID,AttID) values ('" + itid + // "','" + dt.Rows[i]["TID"] + "','" + dt.Rows[i]["TIPage"] + "','" + niid + // "','" + newAttaId + "');select @@IDENTITY"; // } // DbCommand dbComAddTempInfo = db.GetSqlStringCommand(addTempInfo); // var ntiid = db.ExecuteScalar(dbComAddTempInfo, trans); // var infos = "select * from Infos where TIID=" + dt.Rows[i]["TIID"]; // DbCommand dbComInfos = db.GetSqlStringCommand(infos); // var dtInfos = db.ExecuteDataSet(dbComInfos, trans).Tables[0]; // if (dtInfos.Rows.Count > 0) // { // foreach (DataRow dataRow in dtInfos.Rows) // { // var imodel = _infosDal.DataRowToModel(dataRow); // AddInfo(db, trans, imodel, Convert.ToInt32(ntiid), itid); // } // } // } // } // #endregion // return niid; //} #region private void AddInfo(Database db, DbTransaction trans, Admin.Model.Infos oldinfomodel, int tiid, int itid) { #region 新增info var oldbpic = new FileInfo(Server.MapPath("/UploadFiles/" + oldinfomodel.PicAttID)); var newPicAttaId = ""; if ("" != oldinfomodel.PicAttID && oldbpic.Exists) { newPicAttaId = Guid.NewGuid().ToString(); if ("C0pY" == oldinfomodel.PicAttID.Substring(0, 4)) { newPicAttaId = "C0pY" + newPicAttaId + oldinfomodel.PicAttID.Substring(40); } else { newPicAttaId = "C0pY" + newPicAttaId + oldinfomodel.PicAttID; } oldbpic.CopyTo(Server.MapPath("/UploadFiles/" + newPicAttaId)); } var newVAttaId = ""; if (!string.IsNullOrEmpty(oldinfomodel.VideoAttID)) { var oldvideo = new FileInfo(Server.MapPath("/UploadFiles/" + oldinfomodel.VideoAttID)); newVAttaId = Guid.NewGuid().ToString(); if (oldvideo.Exists) { if ("C0pY" == oldinfomodel.VideoAttID.Substring(0, 4)) { newVAttaId = "C0pY" + newVAttaId + oldinfomodel.VideoAttID.Substring(40); } else { newVAttaId = "C0pY" + newVAttaId + oldinfomodel.VideoAttID; } oldvideo.CopyTo(Server.MapPath("/UploadFiles/" + newVAttaId)); } else { newVAttaId = ""; } } var newadAttaId = ""; if (!string.IsNullOrEmpty(oldinfomodel.ADPic)) { var oldvideo = new FileInfo(Server.MapPath("/UploadFiles/" + oldinfomodel.ADPic)); newadAttaId = Guid.NewGuid().ToString(); if (oldvideo.Exists) { if ("C0pY" == oldinfomodel.ADPic.Substring(0, 4)) { newadAttaId = "C0pY" + newadAttaId + oldinfomodel.ADPic.Substring(40); } else { newadAttaId = "C0pY" + newadAttaId + oldinfomodel.ADPic; } oldvideo.CopyTo(Server.MapPath("/UploadFiles/" + newadAttaId)); } else { newadAttaId = ""; } } StringBuilder addinfo = new StringBuilder(); addinfo.Append("insert into Infos("); addinfo.Append( "IName,PicAttID,IType,TIID,LID,SortNum,Status,CreateDate,Context,ConPosition,ConColor,ConSize,XPosition,YPosition,VideoAttID,NType,HotType,ADTime,ADPic,ADLink)"); addinfo.Append(" values ("); addinfo.Append( "@IName,@PicAttID,@IType,@TIID,@LID,@SortNum,@Status,@CreateDate,@Context,@ConPosition,@ConColor,@ConSize,@XPosition,@YPosition,@VideoAttID,@NType,@HotType,@ADTime,@ADPic,@ADLink)"); addinfo.Append(";select @@IDENTITY"); DbCommand dbComAddInfo = db.GetSqlStringCommand(addinfo.ToString()); db.AddInParameter(dbComAddInfo, "IName", DbType.String, oldinfomodel.IName); db.AddInParameter(dbComAddInfo, "PicAttID", DbType.String, newPicAttaId); db.AddInParameter(dbComAddInfo, "IType", DbType.Int32, oldinfomodel.IType); db.AddInParameter(dbComAddInfo, "TIID", DbType.Int32, tiid); db.AddInParameter(dbComAddInfo, "LID", DbType.Int32, oldinfomodel.LID); db.AddInParameter(dbComAddInfo, "SortNum", DbType.Int32, oldinfomodel.SortNum); db.AddInParameter(dbComAddInfo, "Status", DbType.Byte, oldinfomodel.Status); db.AddInParameter(dbComAddInfo, "CreateDate", DbType.DateTime, oldinfomodel.CreateDate); db.AddInParameter(dbComAddInfo, "Context", DbType.String, oldinfomodel.Context); db.AddInParameter(dbComAddInfo, "ConPosition", DbType.String, oldinfomodel.ConPosition); db.AddInParameter(dbComAddInfo, "ConColor", DbType.String, oldinfomodel.ConColor); db.AddInParameter(dbComAddInfo, "ConSize", DbType.String, oldinfomodel.ConSize); db.AddInParameter(dbComAddInfo, "XPosition", DbType.String, oldinfomodel.XPosition); db.AddInParameter(dbComAddInfo, "YPosition", DbType.String, oldinfomodel.YPosition); db.AddInParameter(dbComAddInfo, "VideoAttID", DbType.String, newVAttaId); db.AddInParameter(dbComAddInfo, "NType", DbType.Byte, oldinfomodel.NType); db.AddInParameter(dbComAddInfo, "HotType", DbType.Byte, oldinfomodel.HotType); db.AddInParameter(dbComAddInfo, "ADTime", DbType.String, oldinfomodel.ADTime); db.AddInParameter(dbComAddInfo, "ADPic", DbType.String, newadAttaId); db.AddInParameter(dbComAddInfo, "ADLink", DbType.String, oldinfomodel.ADLink); object niid = db.ExecuteScalar(dbComAddInfo, trans); #endregion #region 新增InfoLabel var infolabel = "select * from InfoLabel where IID=" + oldinfomodel.IID; DbCommand dbComInfoLabel = db.GetSqlStringCommand(infolabel); var dtInfoLabel = db.ExecuteDataSet(dbComInfoLabel, trans).Tables[0]; if (dtInfoLabel.Rows.Count > 0) { var addinfolabel = ""; for (int i = 0; i < dtInfoLabel.Rows.Count; i++) { addinfolabel += "insert into InfoLabel(IID,ALID) values ('" + niid + "','" + dtInfoLabel.Rows[i]["ALID"] + "');"; } DbCommand dbComAddInfoLabel = db.GetSqlStringCommand(addinfolabel); db.ExecuteNonQuery(dbComAddInfoLabel, trans); } #endregion #region 新增AdInfo var adInfo = "select * from AdInfos where IID=" + oldinfomodel.IID; DbCommand dbComAdInfo = db.GetSqlStringCommand(adInfo); var dtAdInfo = db.ExecuteDataSet(dbComAdInfo, trans).Tables[0]; if (dtAdInfo.Rows.Count > 0) { var addAdInfo = ""; for (int i = 0; i < dtAdInfo.Rows.Count; i++) { addAdInfo += "insert into AdInfos(IID,Inf_IID) values ('" + niid + "','" + dtAdInfo.Rows[i]["Inf_IID"] + "');"; } DbCommand dbComAddAdInfo = db.GetSqlStringCommand(addAdInfo); db.ExecuteNonQuery(dbComAddAdInfo, trans); } #endregion #region 新增AttaList var attalist = "select * from AttaList where IID=" + oldinfomodel.IID; DbCommand dbComAttaList = db.GetSqlStringCommand(attalist); var dtAttaList = db.ExecuteDataSet(dbComAttaList, trans).Tables[0]; if (dtAttaList.Rows.Count > 0) { var addAttaList = ""; for (int i = 0; i < dtAttaList.Rows.Count; i++) { var oldfile = new FileInfo(Server.MapPath("/UploadFiles/" + dtAttaList.Rows[i]["AttID"])); var newAttaId = ""; if ("" != dtAttaList.Rows[i]["AttID"].ToString() && oldfile.Exists) { newAttaId = Guid.NewGuid().ToString(); if ("C0pY" == dtAttaList.Rows[i]["AttID"].ToString().Substring(0, 4)) { newAttaId = "C0pY" + newAttaId + dtAttaList.Rows[i]["AttID"].ToString().Substring(40); } else { newAttaId = "C0pY" + newAttaId + dtAttaList.Rows[i]["AttID"]; } oldfile.CopyTo(Server.MapPath("/UploadFiles/" + newAttaId)); } addAttaList += "insert into AttaList(AttID,IID) values (N'" + newAttaId + "','" + niid + "');"; } DbCommand dbComAddAttaList = db.GetSqlStringCommand(addAttaList); db.ExecuteNonQuery(dbComAddAttaList, trans); } #endregion #region 新增TemplateInfo var templatesql = "select * from TempInfo where ParentID=" + oldinfomodel.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++) { var addTempInfo = ""; var attidbp = dt.Rows[i]["AttID"]; var newAttaId = ""; if (DBNull.Value != attidbp) { if (!string.IsNullOrEmpty(attidbp.ToString())) { var oldfile = new FileInfo(Server.MapPath("/UploadFiles/" + attidbp)); if (oldfile.Exists) { newAttaId = Guid.NewGuid().ToString(); if ("C0pY" == attidbp.ToString().Substring(0, 4)) { newAttaId = "C0pY" + newAttaId + attidbp.ToString().Substring(40); } else { newAttaId = "C0pY" + newAttaId + attidbp.ToString(); } oldfile.CopyTo(Server.MapPath("/UploadFiles/" + newAttaId)); } } } if (dt.Rows[i]["TIPage"] == DBNull.Value) { addTempInfo = "insert into TempInfo(ITID,TID,ParentID,AttID) values ('" + itid + "','" + dt.Rows[i]["TID"] + "','" + niid + "',N'" + newAttaId + "');select @@IDENTITY"; } else { addTempInfo = "insert into TempInfo(ITID,TID,TIPage,ParentID,AttID) values ('" + itid + "','" + dt.Rows[i]["TID"] + "','" + dt.Rows[i]["TIPage"] + "','" + niid + "',N'" + newAttaId + "');select @@IDENTITY"; } DbCommand dbComAddTempInfo = db.GetSqlStringCommand(addTempInfo); var ntiid = db.ExecuteScalar(dbComAddTempInfo, trans); var infos = "select * from Infos where TIID=" + dt.Rows[i]["TIID"]; DbCommand dbComInfos = db.GetSqlStringCommand(infos); var dtInfos = db.ExecuteDataSet(dbComInfos, trans).Tables[0]; if (dtInfos.Rows.Count > 0) { foreach (DataRow dataRow in dtInfos.Rows) { var imodel = _infosDal.DataRowToModel(dataRow); AddInfo(db, trans, imodel, Convert.ToInt32(ntiid), itid); } } } } #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); 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(); } }