示例#1
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                // === modified by jeffery
                //dsorder = Maticsoft.DBUtility.DbHelperSQL.Query("SELECT Are,count(Are) as 'Sum' FROM Room GROUP BY Are ");
                QPS.NEW.DAL.SQLHelper sqlHelper = new NEW.DAL.SQLHelper(null);
                dsorder = sqlHelper.GetDataSet("SELECT Are,count(Are) as 'Sum' FROM Room GROUP BY Are ",
                                               CommandType.Text,
                                               null);
                // ===

                DataList2.DataSource = dsorder;
                DataList2.DataBind();

                bind();
                //if (Session["username"] ==null)
                //{
                //    unLog.Visible = true;
                //    userLoginfo.Visible = false;
                //}
                //if (Session["username"] != null)
                //{
                //    username = Session["username"].ToString();
                //    Label1.Text = username;
                //    unLog.Visible = false;
                //    userLoginfo.Visible = true;
                //    string query = "select DContent from Document where DType='5' ";
                //    DataSet doc = Maticsoft.DBUtility.DbHelperSQL.Query(query);
                //    Repeater1.DataSource = doc;
                //    Repeater1.DataBind();

                //}
            }
        }
示例#2
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string query = "select DContent from Document where DType='3' ";

            // === modified by jeffery
            //DataSet  ds= Maticsoft.DBUtility.DbHelperSQL.Query(query);
            QPS.NEW.DAL.SQLHelper sqlHelper = new NEW.DAL.SQLHelper(null);
            DataSet ds = sqlHelper.GetDataSet(query, CommandType.Text, null);
            // ===
        }
示例#3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            string query="select DContent from Document where DType='3' ";

            // === modified by jeffery
            //DataSet  ds= Maticsoft.DBUtility.DbHelperSQL.Query(query);
            QPS.NEW.DAL.SQLHelper sqlHelper = new NEW.DAL.SQLHelper(null);
            DataSet ds = sqlHelper.GetDataSet(query, CommandType.Text, null);
            // ===
        }
示例#4
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                // === modified by jeffery
                //dsorder = Maticsoft.DBUtility.DbHelperSQL.Query("SELECT Are,count(Are) as 'Sum' FROM Room GROUP BY Are ");
                QPS.NEW.DAL.SQLHelper sqlHelper = new NEW.DAL.SQLHelper(null);
                dsorder = sqlHelper.GetDataSet("SELECT Are,count(Are) as 'Sum' FROM Room GROUP BY Are ",
                    CommandType.Text,
                    null);
                // ===

                DataList2.DataSource = dsorder;
                DataList2.DataBind();

                bind();
                //if (Session["username"] ==null)
                //{
                //    unLog.Visible = true;
                //    userLoginfo.Visible = false;
                //}
                //if (Session["username"] != null)
                //{
                //    username = Session["username"].ToString();
                //    Label1.Text = username;
                //    unLog.Visible = false;
                //    userLoginfo.Visible = true;
                //    string query = "select DContent from Document where DType='5' ";
                //    DataSet doc = Maticsoft.DBUtility.DbHelperSQL.Query(query);
                //    Repeater1.DataSource = doc;
                //    Repeater1.DataBind();

                //}

            }
        }