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