Paper/paperSH.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;

public partial class Paper_paperSH : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindDataGridView("");
        }
    }
    protected void btnQuery_Click(object sender, EventArgs e)
    {
        string strWhere = "";

        if (paperName.Text.Trim() != "")
        {
            strWhere = " paperName like '%" + paperName.Text.Trim() + "%'";
        }

        if (paperType.SelectedIndex != 0)
        {
            strWhere = strWhere + " and paperType='" + paperType.SelectedItem.Text + "'";
        }

        if (paperAudit.SelectedIndex != 0)
        {
            strWhere = strWhere + " and paperAudit='" + paperAudit.SelectedItem.Text + "'";
        }

        if (strWhere.Length>4 && strWhere.Substring(0, 4) == " and")
        {
            strWhere = "1=1 " + strWhere;
        }

        BindDataGridView(strWhere);
    }

    protected void BindDataGridView(string strWhere)
    {
        ExecuteSql exec = new ExecuteSql();

        string strSql = "select * from dbo.papers";

        if (strWhere != "")
        {
            strSql = strSql + string.Format(" where {0} ", strWhere);
        }

        DataTable dt = exec.execSQLTable(strSql);

        Grid1.DataSource = dt;

        Grid1.DataBind();