EquipmentManagement/Admin/UP_EquiSort.aspx.cs

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

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

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;
using Data_Control;

public partial class Admin_UP_EquiSort : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            Sbgl_Up sbup = new Sbgl_Up();
            string sqlstr =
              "select distinct a.EquiStyleName,b.EquiStyleID from EquiStyle a,EquiSort b where a.EquiStyleID=b.EquiStyleID";
            DataSet ds = sbup.Get_info(sqlstr);
            int total = ds.Tables[0].Rows.Count;
            for (int i = 0; i < total; i++)
            {
                jbm.Items.Add(ds.Tables[0].Rows[i][0].ToString());
            }
        }
    }

    protected void Button1_Click(object sender, System.EventArgs e)
    {
        if (bmnr.Text == "")
        {
            Response.Redirect("msg.aspx?msg=请填写或选择必填项目！");
        }
        else
        {
            Sbgl_Up sbup = new Sbgl_Up();
            string styleName = jbm.SelectedValue.ToString();
            string sqlstr = "select EquiStyleID from EquiStyle where EquiStyleName='" + styleName + "'";
            DataSet ds = sbup.Get_info(sqlstr);
            int styleID = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
            Sbgl_Control my = new Sbgl_Control();
            my.update_sblb(Convert.ToInt32(bmid.Value), styleID , bmnr.Text);
            Response.Redirect("msg.aspx?msg=修改运行成功！");
        }
    }
    protected void Show_Click(object sender, EventArgs e)
    {
        Sbgl_Up sbup = new Sbgl_Up();
        string styleName = jbm.SelectedValue.ToString ();
        string sqlstr = "select EquiStyleID from EquiStyle where EquiStyleName='" + styleName+"'";
        DataSet ds = sbup.Get_info(sqlstr);
        int styleID = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
        string sqlstr1 = "select * from EquiSort where EquiStyleID='" + styleID+"'";
        DataSet ds1 = sbup.Get_info(sqlstr1);
        bmid.Value=ds1.Tables [0].Rows [0][0].ToString ();
        bmnr.Text = ds1.Tables[0].Rows[0][1].ToString();