EquipmentManagement/Admin/Select_EquiChange.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 Select_EquiChange : System.Web.UI.Page
{
    protected System.Web.UI.WebControls.TextBox Textbox1;
    protected HtmlInputHidden Hidden1;
    private int CountRows;
    protected void Page_Load(object sender, EventArgs e)
    {
        BindDataGrid();
        ShowStats();
    }

    private void BindDataGrid()
    {


        string sql = "SELECT a.EquiStyleChangeID as id,b.EquiModel as sn, "+
            "c.EquiStyleName as bmnr, a.DepartmentName AS ybm, a.UsePerson as y_syr,"+
            "a.New_DepartmentName as xbm_name, a.New_User as syr "+
            "FROM EquiChange a , Equipment b, EquiStyle c  "+
            "where a.EquipmentID = b.EquipmentID and b.EquiStyleID = c.EquiStyleID";
        if (Classid.Value != "")
        {
            Tree_Control zgjg = new Tree_Control();
            sql += " and b.DepartmentID in (" + zgjg.Treeinit(Convert.ToInt32(Classid.Value.ToString())) + "0)";
        }
        if (Classid1.Value != "")
        {
            Tree_Control zgjg = new Tree_Control();
            sql += " and a.New_DepartmentID in (" + zgjg.Treeinit(Convert.ToInt32(Classid1.Value.ToString())) + "0)";
        }
        if (wxsjq.Text != "" && wxsjz.Text != "")
        {
            sql += " and a.ChangeDate between '" + Convert.ToDateTime(wxsjq.Text) + "' and '" + Convert.ToDateTime(wxsjz.Text) + "'";
        }
        sql += " order by a.EquiStyleChangeID desc";
        AddEquiDB addEquiDB = new AddEquiDB();
        SqlConnection conn = addEquiDB.GetConn();
        conn.Open();
        SqlDataAdapter da = new SqlDataAdapter(sql, conn);
        DataSet ds = new DataSet();
        da.Fill(ds);
        CountRows = ds.Tables[0].Rows.Count;
        if (CountRows > 0)
        {
            DataGrid1.DataSource = ds.DefaultViewManager.DataSet;
            DataGrid1.DataBind();
        }