public void Update(bll_subRoute bllcreate)
    {
        try
        {
            cmd = "EXEC Update_subRoute '"
                  + bllcreate.SUBROUTEID + "','"
                  + bllcreate.SUBROUTECODE + "' ,'"
                  + bllcreate.SUBROUTENAMEBAN + "' ,'"
                  + bllcreate.SUBROUTENAME + "' ,'"
                  + bllcreate.ROUTENAME + "' ,'"
                  + bllcreate.PRESS + "' ,'"
                  + bllcreate.SORTINGORDER + "' ,'"
                  + bllcreate.STARTPOINT + "' ,'"
                  + bllcreate.ENDPOINT + "' ,'"
                  + bllcreate.DEPARTTIME + "' ,'"
                  + bllcreate.ARRIVTIME + "' ,'"
                  + bllcreate.LOCATION + "' ,'"
                  + bllcreate.AUDITUSER + "' ,'"
                  + bllcreate.CREATEDATE + "' ";

            dataProvider.ExecuteCommand(cmd);
        }

        catch (Exception e)
        {
        }
    }
    public void Delete(bll_subRoute bllcreate)
    {
        try
        {
            cmd = "EXEC Delete_subRoute '" + bllcreate.SUBROUTEID + "'";

            dataProvider.ExecuteCommand(cmd);
        }

        catch (Exception e)
        {
            //Use label to print an error >> lbl.text = e.Message;
        }
    }