EquipmentManagement/Admin/UP_Equipment.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_updateEquipment : System.Web.UI.Page
{
    public bool issq;
    public bool whsq;
    public bool dbsq;
    public bool bfsq;
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string str = "select EquipmentID from Equipment";
            Sbgl_Up sbup = new Sbgl_Up();
            DataSet ds = sbup.Get_info(str);
            int total = ds.Tables[0].Rows.Count;
            for (int i = 0; i < total; i++)
            { equipmentID.Items.Add(ds.Tables[0].Rows[i][0].ToString()); }
        }
        
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        int id = Convert.ToInt32(equipmentID.SelectedValue);

        string str1 = "select EquiStyleID,EquiSortID from Equipment where EquipmentID=" + id;
        Sbgl_Up my = new Sbgl_Up();
        string sbbm = string.Empty;
        DataSet ds1 = my.Get_info(str1);
        int getEquiStyleID = Convert.ToInt32(ds1.Tables[0].Rows[0][0]);
        int getEquiSortID = Convert.ToInt32(ds1.Tables[0].Rows[0][1]);
        if (getEquiStyleID > -1 || getEquiSortID > -1)
        {
            string str2 = "select EquiStyleName from EquiStyle where EquiStyleID=" + getEquiStyleID;
            DataSet ds2 = my.Get_info(str2);
            int total1 = ds2.Tables[0].Rows.Count;
            for (int i = 0; i < total1; i++)
            { 
                DDL_Sbzl.Items.Add(ds2.Tables[0].Rows[i][0].ToString()); 
            }
            string str3 = "select EquiSortName from EquiSort where EquiSortID=" + getEquiSortID;
            DataSet ds3 = my.Get_info(str3);
            int total2 = ds3.Tables[0].Rows.Count;
            for (int j = 0; j < total2; j++)
            {
                DDL_Sblb.Items .Add ( ds3.Tables[0].Rows[j][0].ToString());
            }
        }