article_manage.aspx.cs

易想商城系统

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using Shop.Web.UI;
namespace YXShop.Web.Admin.Article
{
    public partial class Article_Manage : System.Web.UI.Page
    {
        public string channelID = "";
        public string classID = "";
        public string channelBar = "";//导航
        public int pageIndexNow = 1;//页码
        public string ShowPageText = "";
        public string action = "";
        BasePage bp = null;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!PowerTree.PowerPass.isPass("012001000", PowerTree.PowerPanel.PowerType.look))
            {
                bp = new BasePage();
                bp.PageError("对不起，你没有查看该页面的权限！", "../index.aspx");
            }
            #region 参数获取
            //-控制分页参数--------------------------------
            if (Request.QueryString["page"] != null)
            {
                try
                {
                    this.pageIndexNow = Convert.ToInt32(Request.QueryString["page"]);
                }
                catch { this.pageIndexNow = 1; }
            }
            else
            { 
             this.pageIndexNow = 1;
            }
            //控制查询范围为具体的频道及该频道的类别------ 
            if (Request["channelID"] != "")
            {
                this.channelID = Request.QueryString["channelID"];
            }
            if (Request["Class_ID"] != "")
            {
                this.classID = Request.QueryString["Class_ID"];
            }
            if (Request["action"] != "")
            {
                this.action = Request.QueryString["action"];
            }
            //-----------------------------------
            #endregion
            if (!Page.IsPostBack)
            {
                BindDatas();
            }
        }

        public void BindDatas()
        {
            YXShop.BLL.YixiangChannel bll = new YXShop.BLL.YixiangChannel();
                  channelBar = bll.ChannelNavigation(this.channelID);
                  InitBindData(this.channelID,this.classID);
        }
        #region 数据绑定
        public void InitBindData(string _channelId,string _classId)
        {
            try
            {
                YXShop.DBUtility.Pager pager = new YXShop.DBUtility.Pager();
                string strWhere = "";
                if (!string.IsNullOrEmpty(_channelId))
                {
                    strWhere = " channelID=" +int.Parse(_channelId);
                    if (!string.IsNullOrEmpty(_classId))
                    {
                        strWhere += "  AND  classID=" +int.Parse(_classId);
                    }
                }
                if (this.action == "SH")
                {
                    if (!string.IsNullOrEmpty(strWhere))
                    {
                        strWhere = "  AND stateNow=1";
                    }
                    else
                    {
                        strWhere = "  stateNow=1";
                    }
                }
                articles.DataSource = pager.PageSelect(YXShop.DBUtility.SqlHelper.ConnectionStringLocalTransaction, "yixiang_article", "*", "articleID", 20, this.pageIndexNow, 1, strWhere);
                articles.DataBind();
                this.ShowPageText = pager.PageText("Article_Manage.aspx?channelID=" + this.channelID + "&Class_ID=" + this.classID);
            }
            catch { }
        }
        #endregion
  
        #region 处理文章是否置顶、是否推荐
        public string changeBoolString(bool valParam, string writeStr, string writeStrOther)
        {
            return (valParam) ? writeStr : writeStrOther;
        }
        #endregion

        #region 处理发布者
        public string dealSpaceVal(string str)
        {
            return string.IsNullOrEmpty(str) ? "匿名" : str;
        }
        #endregion


        #region 处理文章状态(审核)
        public string changeIntString(int valParam, string writeStr, string writeStrOther)
        {
            return (valParam==1) ? writeStr : writeStrOther;
        }
        #endregion

        public string CutString(string str)
        {
            return YXShop.Common.WebUtility.GetLenghtAll(str, 12) + "...";
        }
        #region//绑定频道与类别
        public string retChannelOrClass(string classId,string channelId,string typeId)
        {
            string retStr = ""; 
            string hrefRet = "";
            try
            {
               
                if (typeId == "ch")
                {
                    YXShop.BLL.YixiangChannel bllch = new YXShop.BLL.YixiangChannel();
                    // retStr = bllch.GetSingleChannelInfo(channelId).channelName.ToString();

                    string str = "Select YX_Name from YX_InforChannel where yx_id=" + int.Parse(channelId);
                    retStr = YXShop.DBUtility.SqlHelper.ExecuteScalar(YXShop.DBUtility.SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, str, null).ToString();
                    hrefRet = "<a href='Article_Manage.aspx?channelID=" + channelId + "'><font color='gray'>" + retStr + "</font></a>";
                }
                else
                {
                    if (classId == "0")
                    {
                        retStr = "顶级类别";
                    }
                    else
                    {
                        YXShop.BLL.YixiangChannelClass bllcl = new YXShop.BLL.YixiangChannelClass();
                        retStr = bllcl.GetSingleClassInfo(classId).Class_Name.ToString();
                    }
                    hrefRet = "<a href='Article_Manage.aspx?channelID=" + channelId + "&Class_ID=" + classId + "'><font color='gray'>" + retStr + "</font></a>";

                }
            }
            catch { }
            return hrefRet;
        }
        #endregion

        public void delBtn_OnClick(object sender, EventArgs e)
        {
            try
            {
                foreach (string _item in valuelist.Value.Split(','))
                {
                    YXShop.DBUtility.SqlHelper.ExecuteNonQuery(YXShop.DBUtility.SqlHelper.ConnectionStringLocalTransactionHr, CommandType.Text, "delete from Yixiang_Article where articleID=" + int.Parse(_item), null);
                    BindDatas();
                }
                Response.Redirect(Request.UrlReferrer.ToString());

            }
            catch { }

        }

        public int getIsPower(object obj)
        {
            int reInt = 1;
            if (obj != null) 
            {
                if (obj.ToString() == "del")
                {
                    if (!PowerTree.PowerPass.isPass("012001003", PowerTree.PowerPanel.PowerType.del))
                    {
                        reInt = 0;
                    }
                }
                else if (obj.ToString() == "update") 
                {
                    if (!PowerTree.PowerPass.isPass("012001004", PowerTree.PowerPanel.PowerType.update))
                    {
                        reInt = 0;
                    }
                }
                else
                {
                    if (!PowerTree.PowerPass.isPass("012001006", PowerTree.PowerPanel.PowerType.other))
                    {
                        reInt = 0;
                    }
                }
            }
            return reInt;
        }
    }
}