예제 #1
0
파일: fbdbrw.aspx.cs 프로젝트: wxxxc/oaDemo
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("9");

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

                //AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]);

                //短信
                //dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms());

                //页面绑定
                ListViewBind();
            }
        }
예제 #2
0
파일: Dxtj.aspx.cs 프로젝트: wxxxc/oaDemo
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("3");

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

                OperQx();

                //txtSdate.Text = hkdb.SetDate("D", -30);
                txtSdate.Text = hkdb.SetDate("auto", 0);
                txtEdate.Text = hkdb.SetDate("D", 1);

                GridViewBind();
            }
        }
예제 #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            mydb hkdb = new mydb();

            hkdb.VeriSess("0");

            if (!IsPostBack)
            {
                rqstr.Text = Server.UrlDecode(Request.QueryString["rqstr"].ToString());
                str1       = "" + rqstr.Text + "";
                ArrayList myarr = new ArrayList();
                string[]  mystr = str1.Split(',');
                for (int s = 0; s < mystr.Length; s++)
                {
                    strlist += "'" + mystr[s] + "',";
                }
                strlist += "'0'";

                str2 = "" + Server.UrlDecode(Request.QueryString["usernamestr"].ToString()) + "";
                ArrayList myarr2 = new ArrayList();
                string[]  mystr2 = str2.Split(',');
                for (int s = 0; s < mystr2.Length; s++)
                {
                    strlist2 += "'" + mystr2[s] + "',";
                }
                strlist2 += "'0'";

                if (Request.QueryString["rqstr"] != null)
                {
                    if (strlist != "")
                    {
                        SqlDataReader datar = SqlHelper.ExecuteReader("SELECT ui_id,ui_desc FROM yh WHERE ui_id IN (" + strlist2 + ")");
                        while (datar.Read())
                        {
                            ListItem theItem = new ListItem();
                            theItem.Text  = datar["ui_desc"].ToString();
                            theItem.Value = datar["ui_id"].ToString();
                            SelectedListBox.Items.Add(theItem);
                        }
                        datar.Close();
                    }
                }

                DataBindToDownList();
            }
        }
예제 #4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

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

                //参数判断
                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    SqlDataReader datar = SqlHelper.ExecuteReader("SELECT A.*,B.MC AS DengJi_MC,C.MC AS PinZheng_MC FROM OA_FilesManage A LEFT OUTER JOIN hk_ZDYLX B ON(A.DengJi=B.ID) LEFT OUTER JOIN hk_ZDYLX C ON(A.PinZheng=C.ID) WHERE A.ID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
                    if (datar.Read())
                    {
                        lblNumber.Text     = datar["Number"].ToString();
                        lblName.Text       = datar["Name"].ToString();
                        lblRoomName.Text   = datar["RoomName"].ToString();
                        lblBackYear.Text   = datar["BackYear"].ToString();
                        lblStarttime.Text  = datar["Starttime"].ToString();
                        lblEndtime.Text    = datar["Endtime"].ToString();
                        lblUnitName.Text   = datar["UnitName"].ToString();
                        lblBzPost.Text     = datar["BzPost"].ToString();
                        lblBgTime.Text     = datar["BgTime"].ToString();
                        lblDengJi.Text     = datar["DengJi_MC"].ToString();
                        lblQuanZong.Text   = datar["QuanZong"].ToString();
                        lblMulu.Text       = datar["Mulu"].ToString();
                        lblDaGuan.Text     = datar["DaGuan"].ToString();
                        lblBaoXian.Text    = datar["BaoXian"].ToString();
                        lblSuoWei.Text     = datar["SuoWei"].ToString();
                        lblPinZheng.Text   = datar["PinZheng_MC"].ToString();
                        lblPzStartNum.Text = datar["PzStartNum"].ToString();
                        lblPzEndNum.Text   = datar["PzEndNum"].ToString();
                        lblYeShu.Text      = datar["YeShu"].ToString();
                        lblwfDept.Text     = datar["QxUnitName"].ToString();
                        lblState.Text      = datar["State"].ToString();
                        lblRemark.Text     = datar["Remark"].ToString();
                        datar.Close();
                    }
                    else
                    {
                        datar.Close();
                        mydb.Alert_Close("此记录不存在,可能已被删除!");
                    }
                }
            }
        }
예제 #5
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("3");

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

                SqlDataReader datar = SqlHelper.ExecuteReader("select * from OA_KlAction where id='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
                if (datar.Read())
                {
                    title.Text   = datar["title"].ToString();
                    editor.Value = datar["Content"].ToString();
                }
                datar.Close();
            }
        }
예제 #6
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("3");

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

                OperQx();

                AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]);

                txtSdate.Text = System.DateTime.Now.AddDays(0).ToString("yyyy-MM-dd");
                txtEdate.Text = System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
                GridViewBind();
            }
        }
예제 #7
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

            if (!IsPostBack)
            {
                hkdb.PassTo("10506", "0");
                qy_fjylurl.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT qy_fjylurl FROM qy WHERE qy_id='001'"));

                //短信
                dxtz.Visible = Convert.ToBoolean(hkdb.VeriSms());
                GridViewBind();
                CheckBtn.Enabled = false;
                xxtz.Enabled     = false;
                dxtz.Enabled     = false;
            }
        }
예제 #8
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

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

                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    SqlDataReader dr = SqlHelper.ExecuteReader("SELECT A.* FROM OA_KQ_SM01 A WHERE SID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
                    if (dr.Read())
                    {
                        lblqdsj.Text   = hkdb.GetDate(dr["qdsj"].ToString());
                        ynqd1.Checked  = hkdb.GetValueChk_Checked(dr["ynqd1"].ToString());
                        ynqt1.Checked  = hkdb.GetValueChk_Checked(dr["ynqt1"].ToString());
                        ynqd2.Checked  = hkdb.GetValueChk_Checked(dr["ynqd2"].ToString());
                        ynqt2.Checked  = hkdb.GetValueChk_Checked(dr["ynqt2"].ToString());
                        ynqd3.Checked  = hkdb.GetValueChk_Checked(dr["ynqd3"].ToString());
                        ynqt3.Checked  = hkdb.GetValueChk_Checked(dr["ynqt3"].ToString());
                        lblkqqksm.Text = dr["kqqksm"].ToString();
                        lblsqr.Text    = dr["sqrmc"].ToString();
                        sssj.Text      = dr["sssj"].ToString();
                        lblspr.Text    = dr["jsrNames"].ToString();
                        lblsqbmmc.Text = dr["sqbmmc"].ToString();
                        lblsqsj.Text   = dr["sqsj"].ToString();
                        Number.Text    = dr["smfj"].ToString();
                        lblsscs.Text   = dr["sscs"].ToString();
                        dr.Close();

                        bd.GetAtt(Number.Text, "o3", "oa/kqsm", fujian);

                        GridViewBind();
                    }
                    else
                    {
                        dr.Close();
                        mydb.Alert_Close("此记录不存在,可能已被删除!");
                    }
                }
                else
                {
                    mydb.Alert_Close("此记录不存在,可能已被删除!");
                }
            }
        }
예제 #9
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("9");

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

                DropDownListBind();

                lblAttachSize.Text = Convert.ToString(SqlHelper.ExecuteScalar("SELECT P_STRING FROM hk_CSDA WHERE PARAMT='P_fj_size'"));

                ynxs.Checked = false;

                Panelrq.Visible = false;
            }
        }
예제 #10
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

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

                SqlDataReader dr = SqlHelper.ExecuteReader("SELECT * FROM hk_FormColumn WHERE clNo='" + hkdb.GetStr(Request.QueryString["Number"]) + "'");
                if (dr.Read())
                {
                    Name.Text          = dr["clName"].ToString();
                    Type.SelectedValue = dr["clType"].ToString();
                }
                dr.Close();
            }
        }
예제 #11
0
파일: Cs.aspx.cs 프로젝트: wxxxc/oaDemo
        protected void Page_Load(object sender, EventArgs e)
        {
            mydb hkdb = new mydb();

            hkdb.VeriSess("3");

            if (!IsPostBack)
            {
                hkdb.PassTo("60102", "60102");
            }

            //Demo
            mydb.IsDemo_Stop();

            //绑定数据
            GridViewBind();
        }
예제 #12
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("3");

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

                OperQx();

                DropDownListBind();

                AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]);

                GridViewBind();
            }
        }
예제 #13
0
파일: Pfclsc.aspx.cs 프로젝트: wxxxc/oaDemo
        protected void Page_Load(object Sender, EventArgs E)
        {
            hkdb.VeriSess("3");

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

                AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]);

                //ksrq_s.Text = System.DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd");
                ksrq_s.Text = Request.Cookies["haoke"].Values["sdate"].ToString();
                ksrq_e.Text = System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");

                GridViewBind();
            }
        }
예제 #14
0
파일: Lxwh.aspx.cs 프로젝트: wxxxc/oaDemo
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("3");

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

                DropDownListBind();

                panel2.Visible = false;
                @add.Text      = "增 加";
            }

            //绑定数据
            GridViewBind();
        }
예제 #15
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

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

                SqlDataReader datar = SqlHelper.ExecuteReader("select a.*,b.ui_desc from OA_MPJ a left outer join yh b on (a.lrr=b.ui_id) where id='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
                if (datar.Read())
                {
                    xm.Text            = datar["xm"].ToString();
                    zw.Text            = datar["zw"].ToString();
                    gsdh.Text          = datar["gsdh"].ToString();
                    czdh.Text          = datar["czdh"].ToString();
                    gsmc.Text          = datar["gsmc"].ToString();
                    gsdz.Text          = datar["gsdz"].ToString();
                    yzbm.Text          = datar["yzbm"].ToString();
                    w_mail.Text        = datar["w_mail"].ToString();
                    hylb.Text          = datar["hylb"].ToString();
                    xz.SelectedValue   = datar["xz"].ToString();
                    mplx.SelectedValue = datar["mplx"].ToString();
                    gswz.Text          = datar["gswz"].ToString();
                    bmmc.Text          = datar["bmmc"].ToString();
                    zzdh.Text          = datar["zzdh"].ToString();
                    h_mail.Text        = datar["h_mail"].ToString();
                    yddh.Text          = datar["yddh"].ToString();
                    msn.Text           = datar["msn"].ToString();
                    qq.Text            = datar["qq"].ToString();
                    lrr.Text           = datar["ui_desc"].ToString();
                    if (datar["lrr"].ToString() != this.Session["userid"].ToString())
                    {
                        SaveBtn2.Visible = false;
                        SaveBtn.Visible  = false;
                        DelBtn.Visible   = false;
                    }
                    lrsj.Text = string.Format("{0:d}", datar["lrsj"]);
                    datar.Close();
                }
                else
                {
                    datar.Close();
                    mydb.Alert_Close("此记录不存在,可能已被删除!");
                }
            }
        }
예제 #16
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("3");

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

                //Demo
                mydb.IsDemo_Stop();

                AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]);

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

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

                BindAttr();

                //判断新增还是修改
                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    lbltitle.Text = "修改";
                    SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM HK_QZDA WHERE QZID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
                    if (datar.Read())
                    {
                        qzlx.SelectedValue = datar["qzlx"].ToString();
                        qzmc.Text          = datar["qzmc"].ToString();
                        qzsm.Text          = datar["qzsm"].ToString();
                        UserID.Text        = datar["qzcyid"].ToString();
                        UserName.Text      = datar["qzcymc"].ToString();
                        datar.Close();
                    }
                    else
                    {
                        datar.Close();
                        mydb.Alert_Close("此记录不存在,可能已被删除!");
                    }
                }
                else
                {
                    //新增页面
                    lbltitle.Text      = "新增";
                    SaveAddBtn.Visible = true;

                    //群组类型
                    SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT xh FROM hk_Init WHERE produID IN('O','E')");
                    if (datar1.Read())
                    {
                        qzlx.Enabled = true;
                    }
                    datar1.Close();
                }
            }
        }
예제 #18
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

            if (!IsPostBack)
            {
                jigou.Attributes.Add("readonly", "readonly");

                SqlDataReader dr = SqlHelper.ExecuteReader("select * from BM where bm_id='" + hkdb.GetStr(Request.QueryString["id"]) + "'");
                if (dr.Read())
                {
                    jigou.Text  = dr["bm_mc"].ToString();
                    GzdwId.Text = dr["bm_id"].ToString();
                }
                dr.Close();
            }
        }
예제 #19
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"]) + "'");

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

            SqlHelper.ExecuteSql("DELETE FROM hk_Work WHERE wStatus='等待送审' AND PromoterID='" + this.Session["UserID"].ToString() + "'");

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

                AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]);

                BindDplist();

                DataBindToGridview(CreateMidSql());
            }
        }
예제 #21
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

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

                //参数判断
                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    lbltitle.Text = "修改";
                    SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM QY WHERE QY_ID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
                    if (datar.Read())
                    {
                        gsbm.Text = datar["qy_id"].ToString();
                        gsmc.Text = datar["qy_qc"].ToString();
                        gsjc.Text = datar["qy_jc"].ToString();
                        gsdh.Text = datar["qy_dh"].ToString();
                        gscz.Text = datar["qy_cz"].ToString();
                        gsdz.Text = datar["qy_dz"].ToString();
                        yzbm.Text = datar["qy_yzbm"].ToString();
                        mail.Text = datar["qy_mail"].ToString();
                        //khyh.Text = datar["qy_khyh"].ToString();
                        //yhzh.Text = datar["qy_yhzh"].ToString();
                        bz.Text = datar["qy_bz"].ToString();
                        datar.Close();

                        gsbm.ReadOnly = true;
                        //Init
                        DelBtn.Visible = true;
                    }
                    else
                    {
                        datar.Close();
                        mydb.Alert_Close("此记录不存在,可能已被删除!");
                    }
                }
                else
                {
                    lbltitle.Text      = "新增";
                    SaveAddBtn.Visible = true;
                }
            }
        }
예제 #22
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("3");

            //加载提示
            mydb.PageWait();

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

                //Demo
                mydb.IsDemo_Stop();

                //参数判断
                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM hk_DbBackUp WHERE buID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
                    if (datar.Read())
                    {
                        lbldb.Text = "【" + datar["dbname"].ToString() + "】";
                        sDbName    = datar["dbname"].ToString();
                        lblrq.Text = "【" + datar["settimes"].ToString() + "】";
                        sDbUrl     = datar["dburl"].ToString();
                        datar.Close();
                    }
                    else
                    {
                        datar.Close();
                        mydb.Alert_Close("此记录不存在,可能已被删除!");
                    }

                    //备份参数
                    SqlDataReader datar1 = SqlHelper.ExecuteReader("SELECT * FROM hk_DbSet");
                    if (datar1.Read())
                    {
                        sUrl  = datar1["DbUrl"].ToString();
                        sUser = datar1["DbUser"].ToString();
                        sPwd  = datar1["DbPwd"].ToString();
                        sName = datar1["DbName"].ToString();
                    }
                    datar1.Close();
                }
            }
        }
예제 #23
0
        protected void Page_Load(object Sender, EventArgs E)
        {
            hkdb.VeriSess("4");

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

                BindAttr();

                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    lbltitle.Text = "修改";

                    if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                    {
                        SqlDataReader datar = SqlHelper.ExecuteReader("SELECT * FROM HR_Kpdf_Pw WHERE PID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "'");
                        if (datar.Read())
                        {
                            pid.Text           = datar["pid"].ToString();
                            pwxm.Text          = datar["pwxm"].ToString();
                            pwlx.SelectedValue = datar["pwlx"].ToString();
                            bz.Text            = datar["pwbz"].ToString();
                            datar.Close();

                            //Init
                            DelBtn.Visible     = true;
                            SaveAddBtn.Visible = false;
                            img1.Visible       = false;
                            pwlx.Enabled       = false;
                        }
                        else
                        {
                            datar.Close();
                            mydb.Alert_Close("此记录不存在,可能已被删除!");
                        }
                    }
                }
                else
                {
                    lbltitle.Text      = "新增";
                    SaveAddBtn.Visible = true;
                }
            }
        }
예제 #24
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

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

                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    SqlDataReader dr = SqlHelper.ExecuteReader("SELECT DISTINCT * from OA_KQ_QJD02 A LEFT OUTER JOIN OA_KQ_QJD01 B ON(A.SSQID=B.QID) WHERE B.QID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "' AND A.SPRID='" + this.Session["userid"] + "' AND A.SPZT='确认完成'");
                    if (dr.Read())
                    {
                        lblqjlx.Text   = dr["qjlx"].ToString();
                        lblgjlb.Text   = dr["gjlb"].ToString();
                        lblqjkssj.Text = hkdb.GetDate(dr["qjkssj"].ToString());
                        lblqjkssd.Text = dr["qjkssd"].ToString();
                        lblqjjssj.Text = hkdb.GetDate(dr["qjjssj"].ToString());
                        lblqjjssd.Text = dr["qjjssd"].ToString();
                        lblqjts.Text   = dr["qjts"].ToString();
                        lblqjly.Text   = dr["qjly"].ToString();
                        lblgztzqk.Text = dr["gztzqk"].ToString();
                        lblsqr.Text    = dr["sqrmc"].ToString();
                        sssj.Text      = dr["sssj"].ToString();
                        lblspr.Text    = dr["jsrNames"].ToString();
                        lblsqbmmc.Text = dr["sqbmmc"].ToString();
                        lblsqsj.Text   = dr["sqsj"].ToString();
                        Number.Text    = dr["qjfj"].ToString();
                        dr.Close();

                        bd.GetAtt(Number.Text, "o2", "oa/qjd", fujian);

                        GridViewBind();
                    }
                    else
                    {
                        dr.Close();
                    }
                }
                else
                {
                    mydb.Alert_Close("此记录不存在,可能已被删除!");
                }
            }
        }
예제 #25
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

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

                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    SqlDataReader dr = SqlHelper.ExecuteReader("SELECT DISTINCT * from OA_KQ_SM02 A LEFT OUTER JOIN OA_KQ_SM01 B ON(A.SSSID=B.SID) WHERE B.SID='" + hkdb.GetStr(Request.QueryString["id"].ToString()) + "' AND A.SPRID='" + this.Session["userid"] + "' AND A.SPZT='确认完成'");
                    if (dr.Read())
                    {
                        lblqdsj.Text   = hkdb.GetDate(dr["qdsj"].ToString());
                        ynqd1.Checked  = hkdb.GetValueChk_Checked(dr["ynqd1"].ToString());
                        ynqt1.Checked  = hkdb.GetValueChk_Checked(dr["ynqt1"].ToString());
                        ynqd2.Checked  = hkdb.GetValueChk_Checked(dr["ynqd2"].ToString());
                        ynqt2.Checked  = hkdb.GetValueChk_Checked(dr["ynqt2"].ToString());
                        ynqd3.Checked  = hkdb.GetValueChk_Checked(dr["ynqd3"].ToString());
                        ynqt3.Checked  = hkdb.GetValueChk_Checked(dr["ynqt3"].ToString());
                        lblkqqksm.Text = dr["kqqksm"].ToString();
                        lblsqr.Text    = dr["sqrmc"].ToString();
                        sssj.Text      = dr["sssj"].ToString();
                        lblspr.Text    = dr["jsrNames"].ToString();
                        lblsqbmmc.Text = dr["sqbmmc"].ToString();
                        lblsqsj.Text   = dr["sqsj"].ToString();
                        Number.Text    = dr["smfj"].ToString();
                        lblsscs.Text   = dr["sscs"].ToString();
                        dr.Close();

                        bd.GetAtt(Number.Text, "o3", "oa/kqsm", fujian);

                        GridViewBind();
                    }
                    else
                    {
                        dr.Close();
                    }
                }
                else
                {
                    mydb.Alert_Close("此记录不存在,可能已被删除!");
                }
            }
        }
예제 #26
0
파일: zsjs.aspx.cs 프로젝트: wxxxc/oaDemo
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("3");

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

                tjStr = "无";
                nrStr = "无";

                AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]);
            }
            else
            {
                GridViewBind();
            }
        }
예제 #27
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("3");

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

                if (Request.QueryString["roleid"].ToString() == "1")
                {
                    mydb.Alert_Goto("为避免误操作,系统将不允许修改【超级管理员】角色的权限!", "role.aspx");
                }

                LabelRole.Text = Request.QueryString["rolename"];

                BindTree();
            }
        }
예제 #28
0
        protected void Page_Load(object sender, EventArgs e)
        {
            mydb hkdb = new mydb();

            hkdb.VeriSess("1");

            //消息提醒参数
            SqlDataReader dr = SqlHelper.ExecuteReader("SELECT ynRemind,RemindSound,RemindTime,RemindMode FROM hk_MySet WHERE FK_uid='" + this.Session["userid"] + "'");

            if (dr.Read())
            {
                ynRemindStr   = dr["ynRemind"].ToString();
                RemSoundStr   = dr["RemindSound"].ToString();
                RemTimeStr    = dr["RemindTime"].ToString();
                RemindModeStr = dr["RemindMode"].ToString();
            }
            dr.Close();
        }
예제 #29
0
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("4");

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

                OperQx();

                DropDownListBind();

                if (!string.IsNullOrEmpty(Request.QueryString["id"]))
                {
                    bm_sjbm.SelectedValue = Request.QueryString["id"];
                }
            }
        }
예제 #30
0
파일: Khwh01.aspx.cs 프로젝트: wxxxc/oaDemo
        protected void Page_Load(object sender, EventArgs e)
        {
            hkdb.VeriSess("3");

            if (!IsPostBack)
            {
                //Init
                hkdb.PassTo("11701", "11701");

                //txtSdate.Text = DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd");
                txtSdate.Text = Request.Cookies["haoke"].Values["sdate"].ToString();
                txtEdate.Text = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");

                AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]);

                GridViewBind();
            }
        }