示例#1
0
 protected void Page_Load(object sender, EventArgs e)
 {
     if (!Page.IsPostBack)
     {
         Manager m = (Manager)Session["manager"];
         HelloLabel.Text = m.CManagerName;
         Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
         DataSet           ds     = webser.GetAllOrders("");
         if (ds.Tables[0].Rows.Count != 0)
         {
             CloseOrders.Visible  = true;
             ShowOrder.Visible    = true;
             ShowOrder.DataSource = ds;
             ShowOrder.DataBind();
         }
         else
         {
             Response.Write("<script>alert('לא נמצאו הזמנות')</script>");
         }
     }
 }
示例#2
0
    protected void SortButton_Click(object sender, EventArgs e)
    {
        string order = " ORDER BY ", temp = order;

        if (HighToLow.Checked)
        {
            if (order.Equals(temp))
            {
                order += "OrderTotalMoney DESC";
            }
            else
            {
                order += ",OrderTotalMoney DESC";
            }
        }
        if (LowToHigh.Checked)
        {
            if (order.Equals(temp))
            {
                order += "OrderTotalMoney ASC";
            }
            else
            {
                order += ",OrderTotalMoney ASC";
            }
        }
        if (SortUser.Checked)
        {
            if (order.Equals(temp))
            {
                order += "OrderUserId ASC";
            }
            else
            {
                order += ",OrderUserId ASC";
            }
        }
        if (SortDate.Checked)
        {
            if (order.Equals(temp))
            {
                order += "OrderDate";
            }
            else
            {
                order += ",OrderDate";
            }
        }
        if (IsSupplied.Checked)
        {
            if (order.Equals(temp))
            {
                order += "OrderIsSupplied";
            }
            else
            {
                order += ",OrderIsSupplied";
            }
        }
        if (order.Equals(temp))
        {
            order = "";
        }
        Pharmcy.PharmcyWS webser = new Pharmcy.PharmcyWS();
        //sort the orders
        DataSet ds = webser.GetAllOrders(order);

        if (ds.Tables[0].Rows.Count != 0)
        {
            ShowOrder.Visible    = true;
            ShowDetails.Visible  = false;
            CloseOrders.Visible  = true;
            ShowOrder.DataSource = ds;
            ShowOrder.DataBind();
        }
        else
        {
            CloseOrders_Click(sender, e);
            Response.Write("<script>alert('לא נמצאו הזמנות')</script>");
        }
    }