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

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

                //缺省月份
                if (hkdb.IsDemo("N") == "true")
                {
                    cxyf.Text = "2015-01";
                }
                else
                {
                    cxyf.Text = hkdb.SetDate("Y-M", 0);
                }

                SqlDataReader datar = SqlHelper.ExecuteReader("SELECT KQID FROM OA_KQ_QX WHERE YHID='" + this.Session["UserID"] + "'");
                if (datar.Read())
                {
                    lblkqid.Text = datar["KQID"].ToString() + "  ";
                }
                datar.Close();

                lblrzrq.Text = SqlHelper.ExecuteScalar("SELECT convert(char(10),UI_RZRQ,111) FROM YH WHERE UI_ID='" + this.Session["UserID"] + "'").ToString();

                GridViewBind();
            }
        }
예제 #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();
            }
        }