|
Server : Microsoft-IIS/10.0 System : Windows NT EBS-6136 10.0 build 17763 (Windows Server 2016) i586 User : jxgj ( 0) PHP Version : 7.0.33 Disable Function : passthru,exec,system,shell_exec,proc_open,popen,pcntl_exec,socket_bind,stream_socket_server Directory : D:/tmp_aspnet/root/a99112df/ca2a8923/ |
?#pragma checksum "D:\wwwroot\ldxynb\wwwroot\back\Class\class2.aspx.cs" "{406ea660-64cf-4c82-b6f0-42d48172a799}" "E4015A710C94530189B9BF1F22A31E1E"
#line 1 "D:\wwwroot\ldxynb\wwwroot\back\Class\class2.aspx.cs"
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using CoreClass;
using System.Data.OleDb;
public partial class Back_class2 : System.Web.UI.Page
{
protected CoreClass.DBCommon dbc = new DBCommon();
protected CoreClass.PublicFunction pubfun = new PublicFunction();
DataTable dt = new DataTable();
public int id1;
public int ChannelId = 0;
public int ChannelLeval = 0;
protected string classname1;
protected string jibie;
protected string lianjie;
protected void Page_Load(object sender, System.EventArgs e)
{
pubfun.RegisterAdminPageClientScriptBlock(Page);
if (this.Request.QueryString["ChannelId"] == null || this.Request.QueryString["ChannelId"].Trim() == "")
{
this.ChannelId = 1;
}
else
{
this.ChannelId = Int32.Parse(this.Request.QueryString["ChannelId"].Trim());
}
this.pubfun.checkAdminAccessRights(this.Page, "Class" + this.ChannelId.ToString());
//频路设置
OleDbDataReader dr = this.dbc.GetDataReaderBySql("select top 1 * from ClassChannel Where ChannelId=" + this.ChannelId.ToString());
if (!dr.Read())
{
this.Response.Write("<html><head><LINK href=\"../Back/back.css\" type=\"text/css\" rel=\"stylesheet\"></head><body>频路不存在!</body></html>");
dr.Close();
this.Response.End();
return;
}
this.ChannelLeval = Int32.Parse(dr["MaxLevel"].ToString());
dr.Close();
if (this.ChannelLeval < 2)
{
this.Response.Write("<html><head><LINK href=\"../Back/back.css\" type=\"text/css\" rel=\"stylesheet\"></head><body>频路配置谬误!</body></html>");
this.Response.End();
}
if (this.Request.QueryString["id1"] == null || this.Request.QueryString["id1"].Trim() == "")
{
this.Response.Redirect("Class.aspx?ChannelId=" + this.ChannelId);
return;
}
else
{
this.id1 = Int32.Parse(this.Request.QueryString["id1"].Trim());
}
if (!IsPostBack)
{
this.InitPage();
}
}
private void InitPage()
{
OleDbDataReader dr = this.dbc.GetDataReaderBySql("select top 1 * from Class Where classid=" + this.id1.ToString());
if (dr.Read())
{
this.classname1 = dr["ClassName"].ToString();
dl.TableHeaderName = "【" + classname1 + "】分类治理" + "<button style=\"margin-left:5px;margin-bottom:3px;\" onclick=\"window.location='Class2.aspx?id1=" + pubfun.Gettid(id1) + "&ChannelId=" + this.ChannelId + "';\" class=\"ManagerButton\" id=\"Button2\" type=\"button\"><img src=\"../images/arrow_undo.gif\"/> 返 回 </button>";
}
else
{
dr.Close();
Response.Redirect("Class.aspx?ChannelId=" + this.ChannelId);
return;
}
dr.Close();
this.dt = this.dbc.GetDataTableBySql("Select * From Class Where tid=" + this.id1.ToString() + " Order By OrderNum");
this.dl.DataSource = this.dt;
this.dl.DataBind();
dt.Dispose();
}
protected void dl_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
OleDbDataReader dr;
int id, aimId, aimOdr;
TextBox tb;
OleDbCommand cmd;
switch (e.CommandName)
{
case "mdy":
this.dl.EditItemIndex = e.Item.ItemIndex;
this.InitPage();
break;
case "cancel":
this.dl.EditItemIndex = -1;
this.InitPage();
break;
case "up":
id = Int32.Parse(this.dl.DataKeys[e.Item.ItemIndex].ToString());
aimOdr = 0;
aimId = 0;
dr = this.dbc.GetDataReaderBySql("select top 1 classid,OrderNum From Class Where OrderNum<(Select OrderNum From Class Where classid=" + id.ToString() + ") And tid=" + this.id1.ToString() + " Order By OrderNum DESC");
if (dr.Read())
{
aimOdr = Int32.Parse(dr["OrderNum"].ToString());
aimId = Int32.Parse(dr["classid"].ToString());
}
else
{
pubfun.Alert("当前分类已经分列在第一位！", -1);
return;
}
dr.Close();
if (aimId > 0)
{
this.dbc.ExcuteSql("Update Class Set OrderNum=" + pubfun.GetValue("Class", "OrderNum", "classid=" + id.ToString()) + " Where classid = " + aimId.ToString());
}
this.dbc.ExcuteSql("Update Class Set OrderNum = " + aimOdr.ToString() + " Where Classid = " + id.ToString());
this.dl.EditItemIndex = -1;
this.InitPage();
break;
case "down":
id = Int32.Parse(this.dl.DataKeys[e.Item.ItemIndex].ToString());
aimOdr = 0;
aimId = 0;
dr = this.dbc.GetDataReaderBySql("select top 1 Classid,OrderNum From Class Where OrderNum>(Select OrderNum From Class Where Classid=" + id.ToString() + ") And tid=" + this.id1.ToString() + " Order By OrderNum ASC");
if (dr.Read())
{
aimOdr = Int32.Parse(dr["OrderNum"].ToString());
aimId = Int32.Parse(dr["classid"].ToString());
}
else
{
pubfun.Alert("当前分类已经分列在最后一位！", -1);
return;
}
dr.Close();
if (aimId > 0)
{
this.dbc.ExcuteSql("Update Class Set OrderNum=" + pubfun.GetValue("Class", "OrderNum", "classid=" + id.ToString()) + " Where Classid = " + aimId.ToString());
}
this.dbc.ExcuteSql("Update Class Set OrderNum = " + aimOdr.ToString() + " Where Classid = " + id.ToString());
this.dl.EditItemIndex = -1;
this.InitPage();
break;
case "ok":
tb = (TextBox)e.Item.FindControl("iptMdy");
if (tb.Text.Trim() == "")
{
pubfun.Alert("分类名称不能为空！", -1);
return;
}
id = Int32.Parse(this.dl.DataKeys[e.Item.ItemIndex].ToString());
cmd = this.dbc.GetCommandBySql("Update Class Set ClassName = @cn2 Where Classid=" + id.ToString());
cmd.Parameters.Add("@cn2", OleDbType.VarChar, 50).Value = this.pubfun.SubStringByByte(tb.Text.Trim(), 50);
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Connection.Dispose();
cmd.Dispose();
this.dl.EditItemIndex = -1;
this.InitPage();
break;
case "del":
id = Int32.Parse(this.dl.DataKeys[e.Item.ItemIndex].ToString());
if (!Convert.ToBoolean(pubfun.GetValue("Class", "AllowDel", "classid=" + id.ToString())))
{
pubfun.Alert(Page, "该分类不能删除!",-1);
return;
}
this.dbc.ExcuteSql("Delete From Class Where Classid=" + id.ToString());
this.dl.EditItemIndex = -1;
this.InitPage();
break;
case "re:true":
id = Int32.Parse(this.dl.DataKeys[e.Item.ItemIndex].ToString());
this.dbc.ExcuteSql("update Class set recommend=1 where Classid=" + id.ToString());
this.dl.EditItemIndex = -1;
this.InitPage();
break;
case "re:false":
id = Int32.Parse(this.dl.DataKeys[e.Item.ItemIndex].ToString());
this.dbc.ExcuteSql("update Class set recommend=0 where Classid=" + id.ToString());
this.dl.EditItemIndex = -1;
this.InitPage();
break;
case "list:true":
id = Int32.Parse(this.dl.DataKeys[e.Item.ItemIndex].ToString());
this.dbc.ExcuteSql("update Class set islist=1 Where Classid=" + id.ToString());
this.InitPage();
break;
case "list:false":
id = Int32.Parse(this.dl.DataKeys[e.Item.ItemIndex].ToString());
this.dbc.ExcuteSql("update Class set islist=0 Where Classid=" + id.ToString());
this.InitPage();
break;
case "pic:true":
id = Int32.Parse(this.dl.DataKeys[e.Item.ItemIndex].ToString());
this.dbc.ExcuteSql("update Class set ispic=1 Where Classid=" + id.ToString());
this.InitPage();
break;
case "pic:false":
id = Int32.Parse(this.dl.DataKeys[e.Item.ItemIndex].ToString());
this.dbc.ExcuteSql("update Class set ispic=0 Where Classid=" + id.ToString());
this.InitPage();
break;
}
}
#region 得到级别
public string Getjibie(int sortID)
{
string jibie = "";
if (sortID == 1 && this.ChannelLeval > 2)
{
jibie = "三级分类";
}
else if (sortID == 2 && this.ChannelLeval > 3)
{
jibie = "四级分类";
}
else if (sortID == 3 && this.ChannelLeval > 4)
{
jibie = "五级分类";
}
else if (sortID == 4 && this.ChannelLeval > 5)
{
jibie = "六级分类";
}
else if (sortID == 5 && this.ChannelLeval > 6)
{
jibie = "七级分类";
}
else if (sortID == 6 && this.ChannelLeval > 7)
{
jibie = "八级分类";
}
else if (sortID == 7 && this.ChannelLeval > 8)
{
jibie = "九级分类";
}
else if (sortID == 8 && this.ChannelLeval > 9)
{
jibie = "十级分类";
}
else
{
jibie = "";
}
return jibie;
}
#endregion
protected void dl_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if (!Convert.ToBoolean(pubfun.GetValue("classChannel", "HaveRe", "ChannelId=" + this.ChannelId)))
{
e.Item.Cells[4].Visible = false;
}
if (!Convert.ToBoolean(pubfun.GetValue("classChannel", "ListOrPic", "ChannelId=" + this.ChannelId)))
{
e.Item.Cells[3].Visible = false;
}
if (this.ChannelLeval < pubfun.Getcid(id1) + 3) e.Item.Cells[2].Visible = false;
switch (e.Item.ItemType)
{
case ListItemType.AlternatingItem:
case ListItemType.Item:
LinkButton btnDel = (LinkButton)e.Item.FindControl("btnDel");
LinkButton btnMdy = (LinkButton)e.Item.FindControl("btnMdy");
DataRowView drv = (DataRowView)e.Item.DataItem;
if (Boolean.Parse(drv["stop"].ToString()))
{
btnDel.Visible = false;
btnMdy.Visible = false;
}
else
{
btnDel.Visible = true;
btnMdy.Visible = true;
btnDel.Attributes.Add("onclick", "javascript:return confirm('真的要删除吗？');");
}
LinkButton btnlist1 = (LinkButton)e.Item.FindControl("btnlist1");
LinkButton btnlist2 = (LinkButton)e.Item.FindControl("btnlist2");
if (Boolean.Parse(drv["islist"].ToString())) btnlist2.Visible = false;
else btnlist1.Visible = false;
LinkButton btnpic1 = (LinkButton)e.Item.FindControl("btnpic1");
LinkButton btnpic2 = (LinkButton)e.Item.FindControl("btnpic2");
if (Boolean.Parse(drv["ispic"].ToString())) btnpic2.Visible = false;
else btnpic1.Visible = false;
break;
}
}
protected void Button1_Click(object sender, EventArgs e)
{
InitPage();
if (iptNew.Text.Trim() == "")
{
pubfun.Alert(Page, "请填写要增长的分类名称！");
iptNew.Focus();
return;
}
int curOrder = 0;
OleDbDataReader dr = this.dbc.GetDataReaderBySql("select top 1 OrderNum From Class Where tid=" + this.id1.ToString() + " Order By OrderNum DESC");
if (dr.Read())
{
curOrder = Int32.Parse(dr["OrderNum"].ToString()) + 1;
}
dr.Close();
OleDbCommand cmd = this.dbc.GetCommandBySql("Insert Into Class(channelid,tid,cid,ClassName,OrderNum,stop) values(@channelid,@id1,@cid,@cn2,@odr,0)");
cmd.Parameters.Add("@channelid", OleDbType.VarChar, 5).Value = this.ChannelId;
cmd.Parameters.Add("@id1", OleDbType.VarChar, 5).Value = this.id1;
cmd.Parameters.Add("@cid", OleDbType.VarChar, 5).Value = pubfun.Getcid(id1) + 1;
cmd.Parameters.Add("@cn2", OleDbType.VarChar, 50).Value = this.pubfun.SubStringByByte(iptNew.Text.Trim(), 50);
cmd.Parameters.Add("@odr", OleDbType.VarChar, 5).Value = curOrder;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
cmd.Connection.Dispose();
cmd.Dispose();
pubfun.RegisterStartupScript(Page, "PAGE", "window.location.href='"+Request.Url.AbsoluteUri+"';");
}
}
#line default
#line hidden