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

            if (!IsPostBack)
            {
                SqlDataReader dr = SqlHelper.ExecuteReader("select * from hk_Ygtxl where id='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
                if (dr.Read())
                {
                    Folder.Text    = dr["FoldersName"].ToString();
                    PxNum.Text     = dr["PxNum"].ToString();
                    FoldersID.Text = dr["FoldersID"].ToString();
                    Name.Text      = dr["Name"].ToString();
                    Worknum.Text   = dr["Worknum"].ToString();
                    Unit.Text      = dr["Unit"].ToString();
                    Respon.Text    = dr["Respon"].ToString();
                    Post.Text      = dr["Post"].ToString();
                    Sex.Text       = dr["Sex"].ToString();
                    Officetel.Text = dr["Officetel"].ToString();
                    Fax.Text       = dr["Fax"].ToString();
                    MoveTel.Text   = dr["MoveTel"].ToString();
                    HomeTel.Text   = dr["HomeTel"].ToString();
                    Email.Text     = dr["Email"].ToString();
                    QQNum.Text     = dr["QQNum"].ToString();
                    MsnNum.Text    = dr["MsnNum"].ToString();
                    NbNum.Text     = dr["NbNum"].ToString();
                    Address.Text   = dr["Address"].ToString();
                    ZipCode.Text   = dr["ZipCode"].ToString();
                    Remark.Text    = hkdb.TbToLb(dr["Remark"].ToString());
                    BothDay.Text   = dr["BothDay"].ToString();
                }
                dr.Close();
            }
        }
Example #2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

            SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM hk_Seal WHERE sID='" + hkdb.GetStr(Request.QueryString["id"]) + "'");

            if (datar.Read())
            {
                lblsName.Text        = datar["sName"].ToString();
                lblsType.Text        = datar["sType"].ToString();
                lblsStatus.Text      = datar["sStatus"].ToString();
                lblsRemark.Text      = hkdb.TbToLb(datar["sRemark"].ToString());
                sPicNewName.ImageUrl = "../../Attach/flow/Seal/" + datar["sPicNewName"].ToString();
            }
            datar.Close();
        }
Example #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

            SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,B.ui_desc FROM hk_Seal A LEFT OUTER JOIN yh B ON(A.sUser=B.ui_id) WHERE sID='" + hkdb.GetStr(Request.QueryString["id"]) + "' AND sStatus='待审'");

            if (datar.Read())
            {
                lblsName.Text        = datar["sName"].ToString();
                lblsType.Text        = datar["sType"].ToString();
                lblsStatus.Text      = datar["sStatus"].ToString();
                lbluID.Text          = datar["sUser"].ToString();
                lblsUser.Text        = datar["ui_desc"].ToString();
                lblsRemark.Text      = hkdb.TbToLb(datar["sRemark"].ToString());
                sPicNewName.ImageUrl = "../../Attach/flow/Seal/" + datar["sPicNewName"].ToString();
            }
            datar.Close();
        }
Example #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

            if (!IsPostBack)
            {
                SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM hk_OffSeal WHERE oID='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
                if (datar.Read())
                {
                    lbloName.Text        = datar["oName"].ToString();
                    lbloRemark.Text      = hkdb.TbToLb(datar["oRemark"].ToString());
                    oPicNewName.ImageUrl = "../../Attach/flow/Seal/" + datar["oPicNewName"].ToString();
                }
                datar.Close();

                BindAttr();

                //页面绑定
                GridViewBind();
            }
        }
Example #5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

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

                SqlDataReader datar = SqlHelper.ExecuteReader("SELECT fcName,fcRemark from hk_FormClass WHERE fcID='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
                if (datar.Read())
                {
                    fcName.Text   = datar["fcName"].ToString();
                    fcRemark.Text = hkdb.TbToLb(datar["fcRemark"].ToString());
                    datar.Close();
                }
                else
                {
                    datar.Close();
                    mydb.Alert_Close("此记录不存在,可能已被删除!");
                }
            }
        }
Example #6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

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

                SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.*,(SELECT BM_MC FROM BM WHERE BM_ID=A.BM_SJBM)AS SJBMMC,(CASE WHEN BMGLQX='Y' THEN '允许管理子部门数据' ELSE '不允许管理子部门数据' END)AS BMGLQX_MC,B.mc FROM BM A LEFT OUTER JOIN hk_ZDYLX B ON(A.bm_lx=B.id) WHERE bm_id='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
                if (dr.Read())
                {
                    showtitle   = "部门详细信息";
                    bmbm.Text   = dr["bm_bm"].ToString();
                    bmmc.Text   = dr["bm_mc"].ToString();
                    sjbmmc.Text = dr["sjbmmc"].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());
                    bmglqx.Text = dr["bmglqx_mc"].ToString();

                    //ModBtn.Visible = true;
                    //DelBtn.Visible = true;
                    //AddBtn.Visible = true;

                    OperQx();
                }
                else
                {
                    showtitle      = "暂未选中任何部门";
                    ModBtn.Visible = false;
                    DelBtn.Visible = false;
                    AddBtn.Visible = false;
                }
                dr.Close();
            }
        }