goodsinfo.aspx.cs

网上购物商城主要由前台会员模块和后台管理模块两部分组成。 q 前台功能模块 前台模块主要包括会员注册、登录、修改个人信息、购物、查询购物情况和查看各种服务条款等功能。 q 后台管理模块 后台模

using System;
using System.Data;
using System.Data.SqlClient;
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;

public partial class MemberManage_GoodsInfo : System.Web.UI.Page
{
    SqlOperate sqloperate = new SqlOperate();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string sqlstr = "select * from vb_GoodsInfo";
            sqloperate.gvDataBind(gvGoodsInfo, sqlstr);
        }
    }
    protected void tvGType_SelectedNodeChanged(object sender, EventArgs e)
    {
        string sSeleNodeText = tvGType.SelectedValue.ToString();
        string sqlstr = "select * from vb_GoodsInfo where GoodsTypeName='" + sSeleNodeText + "' or StoreName='" + sSeleNodeText + "'";
        sqloperate.gvDataBind(gvGoodsInfo, sqlstr);
    }
    protected void gvGoodsInfo_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        gvGoodsInfo.PageIndex = e.NewPageIndex;
        this.gvbind();
    }
    protected void btnSel_Click(object sender, EventArgs e)
    {
        this.gvbind();
    }
    public void gvbind()
    {
        if (txtKey.Text == "")
        {
            string sqlstr = "select * from vb_GoodsInfo";
            sqloperate.gvDataBind(gvGoodsInfo, sqlstr);
        }
        else
        {
            string sqlstr = "select * from vb_GoodsInfo where "
                + ddlCondition.SelectedValue + " like '%" + txtKey.Text.Trim() + "%'";
            sqloperate.gvDataBind(gvGoodsInfo, sqlstr);
        }
    }
}