protected void BindWebSite()
{
ddlWebSite.Items.Clear();
Bll_AdminWebSite BAdmin_WebSite = new Bll_AdminWebSite();
DataSet ds = BAdmin_WebSite.GetList(" State=1 ");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ListItem li = new ListItem();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
li = new ListItem(ds.Tables[0].Rows[i]["WebName"].ToString(), ds.Tables[0].Rows[i]["ID"].ToString());
ddlWebSite.Items.Add(li);
}
}
ddlSite.Items.Clear();
BAdmin_WebSite = new Bll_AdminWebSite();
ds = BAdmin_WebSite.GetList(" 1=1 ");
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
ListItem li = new ListItem();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
li = new ListItem(ds.Tables[0].Rows[i]["WebName"].ToString(), ds.Tables[0].Rows[i]["ID"].ToString());
ddlSite.Items.Add(li);
}
}
}
public static void SetWebSiteBrowseNum(int WebSiteID)
{
Bll_AdminWebSite BAdmin_WebSite = new Bll_AdminWebSite();
if (WebSiteID != 0 && GetCookie(WebSiteID.ToString(), "WebSiteBrowse") == 0)
{
Mod_AdminWebSite MAdmin_WebSite = BAdmin_WebSite.GetModel(WebSiteID);
if (MAdmin_WebSite != null)
{
MAdmin_WebSite.Attr5 = (MAdmin_WebSite.Attr5 + 1);
BAdmin_WebSite.Update(MAdmin_WebSite);
SetCookie(WebSiteID.ToString(), "1", "WebSiteBrowse");
}
}
}
/// <summary>
/// 获取网站配置
/// </summary>
/// <param name="WebSiteID">网站配置id</param>
/// <returns>Mod_WebSite</returns>
public static Mod_AdminWebSite GetWebSite(int WebSiteID)
{
Bll_AdminWebSite BAdmin_WebSite = new Bll_AdminWebSite();
Mod_AdminWebSite MAdmin_WebSite = new Mod_AdminWebSite();
MAdmin_WebSite = BAdmin_WebSite.GetModel(WebSiteID);
if (MAdmin_WebSite != null)
{
return(MAdmin_WebSite);
}
else
{
return(new Mod_AdminWebSite());
}
}
//获取站点
private void GetWebSite()
{
if (AdminManage.RoleID == 10001)
{
Bll_AdminWebSite BWebSite = new Bll_AdminWebSite();
rptWebSiteList.DataSource = BWebSite.GetList(0, " State=1 ", " OrderBy desc ");
rptWebSiteList.DataBind();
}
else
{
Bll_AdminRole BAdmin_Role = new Bll_AdminRole();
Mod_AdminRole MAdmin_Role = BAdmin_Role.GetModel(AdminManage.RoleID);
if (MAdmin_Role != null && MAdmin_Role.WebSiteIDStr != "")
{
Bll_AdminWebSite BWebSite = new Bll_AdminWebSite();
rptWebSiteList.DataSource = BWebSite.GetList(0, " ID in(" + MAdmin_Role.WebSiteIDStr + ") and State=1 ", " OrderBy desc ");
rptWebSiteList.DataBind();
}
}
}
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;
}
}
}
