bas/bmgl/Dept_Show.aspx.cs

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

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

using System;
using System.Data.SqlClient;
using System.Web.UI;
using haoke365;

namespace hkoa.SystemManage.Orga
{
    public partial class Dept_Show : System.Web.UI.Page
    {
        mydb hkdb = new mydb();
        BindData bd = new BindData();

        public static string showtitle;

        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

            if (!Page.IsPostBack)
            {
                hkdb.PassTo("60301", "0");

                //EAM字段判断
                SqlDataReader dr1 = SqlHelper.ExecuteReader("SELECT * FROM hk_Init WHERE ProduID='E'");
                if (dr1.Read())
                {
                    p_eam.Visible = true;
                }
                dr1.Close();

                //KMS字段判断
                SqlDataReader dr2 = SqlHelper.ExecuteReader("SELECT * FROM hk_Init WHERE ProduID='K'");
                if (dr2.Read())
                {
                    p_kms.Visible = true;
                }
                dr2.Close();

                //Report字段判断
                SqlDataReader dr3 = SqlHelper.ExecuteReader("SELECT * FROM hk_Init WHERE ProduID IN('R','S')");
                if (dr3.Read())
                {
                    p_report.Visible = true;
                }
                dr3.Close();

                SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.*,(CASE WHEN JGLB='1' THEN '地区中心' WHEN JGLB='2' THEN '幼儿园' ELSE '总部机构' END)AS JGLB_MC,(CASE WHEN BMGLQX='Y' THEN '允许管理子部门数据' ELSE '不允许管理子部门数据' END)AS BMGLQX_MC,B.mc,(SELECT BM_MC FROM BM WHERE BM_ID=A.SSDQZX)AS SSDQZX_MC FROM BM A LEFT OUTER JOIN hk_ZDYLX B ON(A.bm_lx=B.id) WHERE bm_id='" + hkdb.GetFormatStr(Request.QueryString["id"]) + "'");
                if (dr.Read())
                {
                    showtitle = "部门详细信息";
                    bmmc.Text = dr["bm_mc"].ToString();
                    bmfzr.Text = dr["bm_fzr"].ToString();
                    bmdh.Text = dr["bm_dh"].ToString();
                    bmcz.Text = dr["bm_cz"].ToString();
                    bmlx.Text = dr["mc"].ToString();
                    bz.Text = hkdb.TbToLb(dr["bm_bz"].ToString());
                    ynffbm.Text = dr["ynffbm"].ToString();
                    ynslbm.Text = dr["ynslbm"].ToString();
                    jglb.Text = dr["jglb_mc"].ToString();
                    ssdqzx.Text = dr["ssdqzx_mc"].ToString();