modifyproductadmin.ascx.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;

public partial class AdminControl_ModifyProductAdmin : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Admin"] != null)
        {
            if (!IsPostBack)
            {
                if (AdminCenterAccess.GetAdminTypeByAdminName(Session["Admin"].ToString()) == "超级管理员"
                    || AdminCenterAccess.GetAdminTypeByAdminName(Session["Admin"].ToString()) == "图书管理员")
                {
                    GetCategories();
                    int howManyPages;
                    GetProductInCategory(ddlCategory.SelectedValue.ToString(), 1, out howManyPages);
                    CreatePageNumber(howManyPages);
                    lblCount.Text = howManyPages.ToString();

                }
                else
                {
                    Response.Redirect("AdminCenter.aspx");
                }
            }
        }
    }

    protected void CreatePageNumber(int howManyPages)
    {
        ddlPageNumber.Items.Clear();
        for (int i = 1; i <= howManyPages; i++)
        {
            ddlPageNumber.Items.Add(i.ToString());
        }
    }

    private void GetProductInCategory(string categoryID, int pageNumber, out int howManyPages)
    {
        gridProducts.DataSource = CommonDataAccess.GetBooksInCategory(categoryID, pageNumber, out howManyPages);
        gridProducts.DataBind();
    }

    private void GetCategories()
    {
        ddlCategory.DataSource = CommonDataAccess.GetCategories();
        ddlCategory.DataTextField = "Name";
        ddlCategory.DataValueField = "CategoryID";
        ddlCategory.DataBind();
    }
    protected void ddlCategory_SelectedIndexChanged(object sender, EventArgs e)
    {
        int howmanyPages;

        GetProductInCategory(ddlCategory.SelectedValue.ToString(), 1, out howmanyPages);
        CreatePageNumber(howmanyPages);
    }
    protected void ddlPageNumber_SelectedIndexChanged(object sender, EventArgs e)
    {
        int pageNumber = Int32.Parse(ddlPageNumber.SelectedItem.Text);
        int howManyPages;
        GetProductInCategory(ddlCategory.SelectedValue.ToString(), pageNumber, out howManyPages);

    }
    protected void gridProducts_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        gridProducts.EditIndex = -1;
        int num;
        GetProductInCategory(ddlCategory.SelectedValue.ToString(), Int32.Parse(ddlPageNumber.SelectedItem.Text.ToString()), out num);
    }
    protected void gridProducts_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string bookID = gridProducts.DataKeys[e.RowIndex].Value.ToString();
        bool isSuccess = false;
        if (!AdminCenterAccess.DeleteBookInfo(bookID, out isSuccess))
        {
            Message.ShowMsgBox(Page, "删除失败!");
        }
        else
        {
            if (isSuccess)
            {
                Message.ShowMsgBox(Page, "删除成功!");
                int howManyPage;
                GetProductInCategory(ddlCategory.SelectedValue.ToString(),Int32.Parse(ddlPageNumber.SelectedItem.Text.ToString()), out howManyPage);


            }
            else
            {
                Message.ShowMsgBox(Page, "该产品不允许删除!");
            }
        }
    }
    protected void gridProducts_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gridProducts.EditIndex = e.NewEditIndex;
        int num;
        GetProductInCategory(ddlCategory.SelectedValue.ToString(), Int32.Parse(ddlPageNumber.SelectedItem.Text.ToString()), out num);

    }
    protected void gridProducts_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string bookID = gridProducts.DataKeys[e.RowIndex].Value.ToString();
        string bookName = ((TextBox)gridProducts.Rows[e.RowIndex].Cells[1].Controls[0]).Text;

        string author = ((TextBox)gridProducts.Rows[e.RowIndex].Cells[3].Controls[0]).Text;
        string publisher = ((TextBox)gridProducts.Rows[e.RowIndex].Cells[4].Controls[0]).Text;
        string price = ((TextBox)gridProducts.Rows[e.RowIndex].Cells[5].Controls[0]).Text;
        string amount = ((TextBox)gridProducts.Rows[e.RowIndex].Cells[6].Controls[0]).Text;
        string leftNumber = ((TextBox)gridProducts.Rows[e.RowIndex].Cells[7].Controls[0]).Text;
        string content = ((TextBox)gridProducts.Rows[e.RowIndex].Cells[8].Controls[0]).Text;
        string isRecommon = ((CheckBox)gridProducts.Rows[e.RowIndex].Cells[9].Controls[0]).Checked.ToString();
        string isSpecialPrice = ((CheckBox)gridProducts.Rows[e.RowIndex].Cells[10].Controls[0]).Checked.ToString();
        string imageFileName1 = ((TextBox)gridProducts.Rows[e.RowIndex].Cells[11].Controls[0]).Text;
        string imageFileName2 = ((TextBox)gridProducts.Rows[e.RowIndex].Cells[12].Controls[0]).Text;
        if (AdminCenterAccess.ModifyBookInfo(bookID, bookName, imageFileName1, imageFileName2,
            author, publisher, content, price, isRecommon, isSpecialPrice, amount, leftNumber))
        {
            Message.ShowMsgBox(Page, "修改成功");
            gridProducts.EditIndex = -1;
            int num;
            GetProductInCategory(ddlCategory.SelectedValue.ToString(), Int32.Parse(ddlPageNumber.SelectedItem.Text.ToString()), out num);


        }
        else
        {
            Message.ShowMsgBox(Page, "修改失败");
        }
    }
}