protected void SchemaSeri(AttaList _attaListDal, Infos infomodel, string adpause) { StringBuilder strSqlAddLab = new StringBuilder(); strSqlAddLab.Append("insert into InfoLabel("); strSqlAddLab.Append("IID,ALID)"); strSqlAddLab.Append(" values ("); strSqlAddLab.Append("@IID,@ALID)"); }
private void AddInfo(Database db, DbTransaction trans, 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 }