Project/projectSH.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 ExtAspNet;

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

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

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

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

        DataTable dt = exec.execSQLTable(strSql);

        Grid1.DataSource = dt;

        Grid1.DataBind();       
    }

    

    protected void butQuery_Click(object sender, EventArgs e)
    {
        string strWhere = "";

        if (projectID.Text!="")
            strWhere = "projectID=" + projectID.Text.Trim();

        if (projectName.Text!="")
            strWhere = strWhere + " and projectName='" + projectName.Text.Trim() + "'";

        if (projectAudit.SelectedIndex!=0)
            strWhere = strWhere + " and projectAudit='" + projectAudit.SelectedItem.Text.Trim() + "'";

        if (projectType.SelectedIndex != 0)
            strWhere = strWhere + " and projectType='" + projectType.SelectedItem.Text.Trim() + "'";

        if (projectLeve.SelectedIndex != 0)
            strWhere = strWhere + " and projectLeve='" + projectLeve.SelectedItem.Text.Trim() + "'";

        if (projectState.SelectedIndex != 0)
            strWhere = strWhere + " and projectState='" + projectState.SelectedItem.Text.Trim() + "'";