setitem.aspx.cs

来自「这也是关于论坛的一个源代码」· CS 代码 · 共 442 行 · 第 1/2 页

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 Foosun.CMS;
using Foosun.CMS.Common;
using Foosun.Model;

public partial class manage_survey_setItem : Foosun.Web.UI.ManagePage
{
    public manage_survey_setItem()
    {
        Authority_Code = "S004";
    }
    Survey sur = new Survey();
    rootPublic rd = new rootPublic();
    protected void Page_Load(object sender, EventArgs e)
    {
        this.PageNavigator1.OnPageChange += new PageChangeHandler(PageNavigator1_PageChange);
        if (!IsPostBack) //判断页面是否重载
        {
            //判断用户是否登录
            copyright.InnerHtml = CopyRight;//获取版权信息
            if (SiteID == "0")
            {
                param_id.InnerHtml = "<a href=\"setParam.aspx\" class=\"list_link\">系统参数设置</a>&nbsp;┊&nbsp;";
            }
            VoteItemManage(1);  //初始分页数据

            #region 选择类别,主题(新增选项时)
            DataTable dt = sur.Str_SelectSql();
            //显示类别主题
            if (dt != null)
            {
                foreach (DataRow r in dt.Rows)
                {
                    ListItem lit = new ListItem();
                    lit.Text = "类别:" + r["ClassName"].ToString() + "--" + "主题:" + r["Title"].ToString();
                    lit.Value = r["TID"].ToString();//选项所属主题TID
                    this.vote_CTName.Items.Add(lit);//新增加
                    this.classnameedit.Items.Add(lit);//修改

                }
                dt.Clear();
            }

            #endregion
            string type = Request.QueryString["type"];
            switch (type)
            {
                case "edit":
                    setItemEdit();
                    break;
                case "delone":
                    setItemDel();
                    break;
            }
        }
    }
    /// <summary>
    /// 分页
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="PageIndex"></param>
    /// code by chenzhaohui

    protected void PageNavigator1_PageChange(object sender, int PageIndex)
    {
        VoteItemManage(PageIndex);//管理页面分页查询
    }

    /// <summary>
    /// 修改初始页面信息
    /// </summary>
    ///code by chenzhaohui

    void setItemEdit()
    {
        int IID = int.Parse(Request.QueryString["ID"]);
        DataTable dt = sur.Str_ItemSql(IID);
        if (dt.Rows.Count > 0)
        {
            this.classnameedit.Text = dt.Rows[0]["TID"].ToString();
            this.itemnameedit.Text = dt.Rows[0]["ItemName"].ToString();
            this.valueedit.Text = dt.Rows[0]["ItemValue"].ToString();
            this.itemmodele.Text = dt.Rows[0]["ItemMode"].ToString();
            this.picsurl.Text = dt.Rows[0]["PicSrc"].ToString();
            this.discoloredit.Text = dt.Rows[0]["DisColor"].ToString();
            this.pointqe.Text = dt.Rows[0]["VoteCount"].ToString();
            this.discriptionitem.Value = dt.Rows[0]["ItemDetail"].ToString();
        }
        else
        {
            PageError("未知错误,异常错误", "setItem.aspx");
        }
    }

    /// <summary>
    /// 删除单个事件
    /// </summary>
    ///code by chenzhaohui 

    void setItemDel()
    {
        int IID = int.Parse(Request.QueryString["ID"]);
        if (IID <= 0)
        {
            PageError("错误的参数传递!", "");
        }
        else
        {
            if (sur.Del_Str_ItemSql(IID) == 0)
            {
                PageError("意外错误：未知错误", "");
            }
            else
            {
                rd.SaveUserAdminLogs(1, 1, UserNum, "删除投票选项", "删除成功");
                PageRight("删除成功。", "setItem.aspx");
            }
        }
    }

    /// <summary>
    /// 管理列表页
    /// </summary>
    /// <param name="PageIndex"></param>
    /// code by chenzhaohui

    protected void VoteItemManage(int PageIndex)//显示投票选项管理页面
    {
        #region 查询条件判断语句

        string KeyWord = Foosun.Common.Input.Filter(this.KeyWord.Text.Trim());//关键字
        string type = this.DdlKwdType.SelectedValue;//选择类型
        int i = 0, j = 0;
        int num = PAGESIZE;//从参数设置里取得每页显示记录的条数
        DataTable dt = null;
        if (KeyWord != "" && KeyWord != null)//如果关键字不为空，则执行下面的条件语句
        {
            switch (type)
            {
                case "choose":
                    break;
                case "title":
                    DataTable dt1 = new DataTable();
                    dt1 = sur.SQl_title(KeyWord);
                    if (dt1 != null)
                    {
                        if (dt1.Rows.Count > 0)
                        {
                            for (int l = 0; l < dt1.Rows.Count; l++)
                            {
                                int tid = int.Parse(dt1.Rows[l]["TID"].ToString());
                                SQLConditionInfo st = new SQLConditionInfo("@TID", "%" + tid + "%");
                                dt = Foosun.CMS.Pagination.GetPage("manage_survey_setItem_1_aspx", PageIndex, num, out i, out j, st);
                            }
                        }
                        else
                        {
                            dt = Foosun.CMS.Pagination.GetPage("manage_survey_setItem_2_aspx", PageIndex, num, out i, out j, null);
                        }
                    }
                    else
                    {
                        dt = Foosun.CMS.Pagination.GetPage("manage_survey_setItem_2_aspx", PageIndex, num, out i, out j, null);
                    }
                    break;
                case "ItemNamee":
                    SQLConditionInfo st1 = new SQLConditionInfo("@ItemName", "%" + KeyWord + "%");
                    dt = Foosun.CMS.Pagination.GetPage("manage_survey_setItem_3_aspx", PageIndex, num, out i, out j, st1);
                    break;
                case "ItemValuee":
                    SQLConditionInfo st2 = new SQLConditionInfo("@ItemValue", "%" + KeyWord + "%");
                    dt = Foosun.CMS.Pagination.GetPage("manage_survey_setItem_4_aspx", PageIndex, num, out i, out j, st2);
                    break;
                case "PicSrcc":
                    SQLConditionInfo st3 = new SQLConditionInfo("@PicSrc", "%" + KeyWord + "%");
                    dt = Foosun.CMS.Pagination.GetPage("manage_survey_setItem_5_aspx", PageIndex, num, out i, out j, st3);
                    break;
                case "DisColorr":
                    SQLConditionInfo st4 = new SQLConditionInfo("@DisColor", "%" + KeyWord + "%");
                    dt = Foosun.CMS.Pagination.GetPage("manage_survey_setItem_6_aspx", PageIndex, num, out i, out j, st4);
                    break;
                case "VoteCountt":
                    SQLConditionInfo st5 = new SQLConditionInfo("@VoteCount", "%" + KeyWord + "%");
                    dt = Foosun.CMS.Pagination.GetPage("manage_survey_setItem_7_aspx", PageIndex, num, out i, out j, st5);
                    break;
                case "ItemDetaill":
                    SQLConditionInfo st6 = new SQLConditionInfo("@ItemDetail", "%" + KeyWord + "%");
                    dt = Foosun.CMS.Pagination.GetPage("manage_survey_setItem_8_aspx", PageIndex, num, out i, out j, st6);
                    break;
            }
        }
        else
        {
            dt = Foosun.CMS.Pagination.GetPage("manage_survey_setItem_2_aspx", PageIndex, num, out i, out j, null);
        }
        #endregion
        this.PageNavigator1.PageCount = j;
        this.PageNavigator1.PageIndex = PageIndex;
        this.PageNavigator1.RecordCount = i;

        if (dt != null)//判断如果dt里面没有内容，将不会显示
        {
            if (dt.Rows.Count > 0)
            {
                //添加列
                dt.Columns.Add("title", typeof(String));//主题名
                dt.Columns.Add("ItemModel", typeof(String));//选项模式
                dt.Columns.Add("oPerate", typeof(String));//操作

                for (int k = 0; k < dt.Rows.Count; k++)
                {
                    int idt = int.Parse(dt.Rows[k]["tid"].ToString());