TJFX2.aspx.cs

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

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;

using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;


/// <summary>
/// 被评教师意见汇总
/// </summary>
public partial class TJFX2 : PageBase
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindResult();
        }

    }

    #region 数据绑定
    /// <summary>
    ///绑定列表
    /// </summary>
    private void BindResult()
    {

        //组合查询条件
        string strSql = string.Empty;
        strSql = " select  YJID,LEFT (YJNR,50) as YJNR ,( select jsxm from sjinfo  where sjinfo.jsid =YJB.jsid)  as JSXM ,jsid, FBRLX , " +
                 "CASE FBRLX when '学生' then  ( select xsxm from xsinfo where xsid=FBRID) "+
                 " when '教师' then (select jsxm from sjinfo where jsid=fbrid ) "+
                  " when '考评组' then ( select KPZMC from kpz where kpzid =fbrid ) "+
                  "   else '匿名' end as FBRXM ,FBSJ  from  YJB where 1=1 ";
        if (this.ddlCXLX.SelectedValue.Trim() != "全部")
        {
            if (this.txtCXNR.Text != "")
            {
                strSql += " and  " + this.ddlCXLX.SelectedValue.Trim() + "  like '%" + this.txtCXNR.Text.Trim() + "%'";
            }
        }

        DataTable dt = DbHelperSQL.Query(strSql).Tables[0];
        if (dt != null)
        {
            this.gvData.DataKeyNames = new string[] { "YJID" };
            this.gvData.DataSource = dt;
            this.gvData.DataBind();
            ShowStats(dt.Rows.Count.ToString());
        }
    }

    #endregion