コード例 #1
0
    public static string checkevents()
    {
        mydb   db = new mydb();
        string st = "select event_id from tbl_events where event_date  between dateadd(MINUTE,-1,GETDATE()) and dateadd(MINUTE,1,GETDATE()) and is_displayed = 0";

        return(db.read_val(st));
    }
コード例 #2
0
    public static string isClosed(string orderid)
    {
        mydb   db = new mydb();
        string st = "";

        st = "select isClosed from tbl_orders where order_id=" + orderid;
        return(db.read_val(st));
    }
コード例 #3
0
    /// <summary>
    /// Page Load Event
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            st         = "select top(1) image_url from tbl_themes where is_active = 1";
            background = db.read_val(st);

            if (Request.Cookies["tableNumber"] != null)
            {
                st = "select order_id,amount from tbl_orders where tableNumber=" + Request.Cookies["tableNumber"].Value + " and isClosed=0";

                SqlDataReader dr = db.readall(st);
                if (dr.Read())
                {
                    hf_orderid.Value     = dr[0].ToString();
                    lnk_cart.Text        = dr[1].ToString();
                    pnl_neworder.Visible = false;
                    pnl_page.Visible     = true;
                }
                else
                {
                    ScriptManager.RegisterStartupScript(UpdatePanel3, UpdatePanel3.GetType(), "", "$('#processing-modal').modal('show');", true);
                    pnl_neworder.Visible = true;
                    pnl_page.Visible     = false;
                }
                pnl_table.Visible = false;
                dr.Close();
            }
            else
            {
                pnl_page.Visible     = false;
                pnl_table.Visible    = true;
                btn_neworder.Visible = false;
            }
            st = "select category_id,category_name from tbl_category where is_active=1";
            db.fill_rptr_ret_sqlda(st, rpt_category);

            st = "SELECT [Combo_id],[title],[description],[price],[combo_picture] FROM [dbo].[tbl_combos]";
            db.fill_rptr_ret_sqlda(st, rpt_combos);

            st = @"SELECT tbl_player.song_id,tbl_songs.song_name,tbl_songs.song_url,case is_playing when 1 then 'playing' else '' end as is_playing,
                case when is_requested =1 or is_playing = 1 then 'display:none' else '' end as is_requested
                from tbl_player inner join tbl_songs on tbl_player.song_id = tbl_songs.song_id where is_played = 0 and is_played=0 order by order_number,requested_time";
            db.fill_rptr_ret_sqlda(st, rpt_playlist);
        }
    }
コード例 #4
0
    public static string play_song(string songid)
    {
        mydb   db = new mydb();
        string st = "";

        st = "select order_number from tbl_player where song_id = (select max(isnull(song_id,1)) from tbl_player where is_playing =1 or is_requested = 1)";
        string val = db.read_val(st);

        st = "update tbl_player set is_requested=1 , requested_time = getdate(),order_number=" + val + " where song_id=" + songid;
        db.ExeQuery(st);
        return("done");
    }