TJFX2Edit.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;

using System.Text;

/// <summary>
/// 意见详情
/// </summary>
public partial class TJFX2Edit :PageBase
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            if (Request.Params["id"] != null && Request.Params["id"].Trim() != "")
            {
                string id = Request.Params["id"];
                 ShowInfo(int.Parse(id));
            }
        }
    }

    /// <summary>
    /// 显示详细信息
    /// </summary>
    /// <param name="YJID"></param>
    private void ShowInfo(int YJID)
    {
        StringBuilder strSql = new StringBuilder();
        strSql.Append("select  top 1  ");
        strSql.Append("  YJID,  YJNR   , ( select jsxm from sjinfo  where sjinfo.jsid =yjb.jsid)  as JSXM , jsid, FBRLX ,");
        strSql.Append("CASE FBRLX when '学生' then  ( select xsxm from xsinfo where xsid=FBRID) ");
        strSql.Append(" when '教师' then (select jsxm from sjinfo where jsid=fbrid ) ");
        strSql.Append("when '考评组' then ( select KPZMC from kpz where kpzid =fbrid ) ");
        strSql.Append("else '非法用户' end as FBRXM ,FBSJ   ");
        strSql.Append(" from YJB ");
        strSql.Append(" where YJID=" + YJID + ""); 
        DataSet ds = DbHelperSQL.Query(strSql.ToString());
        if (ds.Tables[0].Rows.Count > 0)
        {
            this.lblYJNR.Text = ds.Tables[0].Rows[0]["YJNR"].ToString();
            this.lblJSID.Text = ds.Tables[0].Rows[0]["JSXM"].ToString();
            this.lblFBRLX.Text = ds.Tables[0].Rows[0]["FBRLX"].ToString();
            this.lblFBRID.Text = ds.Tables[0].Rows[0]["FBRXM"].ToString();
            this.lblFBSJ.Text = ds.Tables[0].Rows[0]["FBSJ"].ToString();
             
            
        }
        

    }