product.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using DbPrvd;
using Common;

public partial class product : System.Web.UI.Page
{
    string pageMode = "add";
    string categoryid = "0";
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["User"] == null || Session["Role"] == null)
            Response.Write("<script type='text/javascript'>parent.document.location='timeout.htm';</script>");
        if (Session["Role"].ToString() != "管理员" && Session["Role"].ToString() != "库管")
        {
            Response.Write("<script type='text/javascript'>alert('您无权操作');history.go(-1);</script>");
        }

        if (!IsPostBack)
        {
            BindCategory();
        }
        
        lbltitle.Text = "添加商品";
        if (!string.IsNullOrEmpty(Request.QueryString["mode"]))
        {
            pageMode = Request.QueryString["mode"];
        }
        if (!string.IsNullOrEmpty(Request.QueryString["id"]) && RegexHelper.isNumberR(Request.QueryString["id"]))
        {
            lbltitle.Text = "修改商品";
            categoryid = Request.QueryString["id"];

            if (!IsPostBack)
                BindInfo();

        }
    }
    private void BindInfo()
    {
        string Query = "select * from [" + SqlHelper.Tbpre + "product] as A inner join [" + SqlHelper.Tbpre + "productctgy] as B "+
            " on A.category=B.sid where A.id=" + categoryid;
        SqlDataReader tempReader = SqlHelper.ExecuteReader(SqlHelper.ConStr, CommandType.Text, Query);
        while (tempReader.Read())
        {
            tbxsid.Value = tempReader["sid"].ToString();
            tbxname.Value = tempReader["name"].ToString();
            tbxprice.Value = tempReader["price"].ToString();
            tbxunit.Value = tempReader["unit"].ToString();
            txtremark.Value = tempReader["remark"].ToString();
            for (int i = 0; i < ddlcategory.Items.Count;i++ )
            {
                if (ddlcategory.Items[i].Value == tempReader["category"].ToString())
                    ddlcategory.Items[i].Selected = true;