protected void btnEdit_Click(object sender, EventArgs e) { string WhereStr = " WebSiteID=" + ddlWebSite.SelectedValue + " AND IsCopy=1 "; if (ddlWebSite.SelectedValue == ddlSite.SelectedValue) { MessageBox.ShowMsgAndRedirect(this, "目标站点与生成站点不能一样!", "/Manage_SW/Column/Admin_WebSite/Copyweb.aspx"); return; } WebSite.BLL.Bll_AdminMenu bll_AdminMenu = new Bll_AdminMenu(); if (bll_AdminMenu.Exists(string.Format("WebSiteID={0}", ddlSite.SelectedValue))) { MessageBox.ShowMsgAndRedirect(this, "生成站点已存在!", "/Manage_SW/Column/Admin_WebSite/Copyweb.aspx"); return; } Bll_AdminWebSite BAdmin_WebSite = new Bll_AdminWebSite(); Mod_AdminWebSite modWebSite = BAdmin_WebSite.GetModel(int.Parse(ddlWebSite.SelectedValue)); modWebSite.ID = int.Parse(ddlSite.SelectedValue); modWebSite.State = 1; modWebSite.WebName = ddlSite.SelectedItem.Text; BAdmin_WebSite.Update(modWebSite); DataSet ds = BAdmin_Menu.GetList(WhereStr); if (ds != null && ds.Tables.Count > 0) { DataTable dt = ds.Tables[0]; GetTree(dt, 0, 0); List <String> SQLStringList = new List <string>(); //分类表 DataTable table_dt = GetColumnList("SW_BaseType").Tables[0]; string strColumn = string.Empty; string strSql = string.Empty; for (int i = 1; i < table_dt.Rows.Count; i++) { strColumn += table_dt.Rows[i]["COLUMN_NAME"] + ","; } strColumn = strColumn.Substring(0, strColumn.Length - 1); strSql = "insert into SW_BaseType (" + strColumn + ") "; strSql += "select " + strColumn.Replace("WebSiteID", ddlSite.SelectedValue) + " from SW_BaseType where WebSiteID=" + ddlWebSite.SelectedValue; SQLStringList.Add(strSql); //新闻表 table_dt = GetColumnList("SW_Information").Tables[0]; strColumn = string.Empty; strSql = string.Empty; for (int i = 1; i < table_dt.Rows.Count; i++) { strColumn += table_dt.Rows[i]["COLUMN_NAME"] + ","; } strColumn = strColumn.Substring(0, strColumn.Length - 1); strSql = "insert into SW_Information (" + strColumn + ") "; strSql += "select " + strColumn.Replace("WebSiteID", ddlSite.SelectedValue) + " from SW_Information where WebSiteID=" + ddlWebSite.SelectedValue; SQLStringList.Add(strSql); //新闻相册表 table_dt = GetColumnList("SW_PicList").Tables[0]; strColumn = string.Empty; strSql = string.Empty; for (int i = 1; i < table_dt.Rows.Count; i++) { strColumn += table_dt.Rows[i]["COLUMN_NAME"] + ","; } strColumn = strColumn.Substring(0, strColumn.Length - 1); strSql = "insert into SW_PicList (" + strColumn + ") "; strSql += "select " + strColumn.Replace("WebSiteID", ddlSite.SelectedValue) + " from SW_PicList where WebSiteID=" + ddlWebSite.SelectedValue; SQLStringList.Add(strSql); //新闻属性表 table_dt = GetColumnList("SW_Attr").Tables[0]; strColumn = string.Empty; strSql = string.Empty; for (int i = 1; i < table_dt.Rows.Count; i++) { strColumn += table_dt.Rows[i]["COLUMN_NAME"] + ","; } strColumn = strColumn.Substring(0, strColumn.Length - 1); strSql = "insert into SW_Attr (" + strColumn + ") "; strSql += "select " + strColumn.Replace("WebSiteID", ddlSite.SelectedValue) + " from SW_Attr where WebSiteID=" + ddlWebSite.SelectedValue; SQLStringList.Add(strSql); //友情链接 table_dt = GetColumnList("SW_Link").Tables[0]; strColumn = string.Empty; strSql = string.Empty; for (int i = 1; i < table_dt.Rows.Count; i++) { strColumn += table_dt.Rows[i]["COLUMN_NAME"] + ","; } strColumn = strColumn.Substring(0, strColumn.Length - 1); strSql = "insert into SW_Link (" + strColumn + ") "; strSql += "select " + strColumn.Replace("WebSiteID", ddlSite.SelectedValue) + " from SW_Link where WebSiteID=" + ddlWebSite.SelectedValue; SQLStringList.Add(strSql); int rows = WebSite.DBUtility.DbHelperSQL.ExecuteSqlTran(SQLStringList); if (rows == 0) { MessageBox.ShowMsgAndRedirect(this, "数据生成失败!", "/Manage_SW/Column/Admin_WebSite/Copyweb.aspx"); return; } else { MessageBox.ShowMsgAndRedirect(this, "数据生成成功!", "/Manage_SW/Column/Admin_WebSite/Copyweb.aspx"); return; } } }