public SqlDataReader getinfoban(string _id) {
     string query = string.Format("SELECT * FROM ban WHERE maban='"+_id+"'");
     try
     {
         con = new DbConnection();
         con.openConnection();
     }
     catch (SqlException e) { }
     return con.MyReader(query);
 }
        public SqlDataReader getmahoadon(string maban, string tinhtrang)
        {
            string query = string.Format("SELECT * FROM hoadon WHERE maban=" + maban + " and tinhtrang=" + tinhtrang);

            try
            {
                con = new DbConnection();
                con.openConnection();
            }
            catch (SqlException e) { }
            return(con.MyReader(query));
        }
        public SqlDataReader getinfoban(string _id)
        {
            string query = string.Format("SELECT * FROM ban WHERE maban='" + _id + "'");

            try
            {
                con = new DbConnection();
                con.openConnection();
            }
            catch (SqlException e) { }
            return(con.MyReader(query));
        }