跳至主內容

搜尋

搜尋

How To Disable Pop Up Message Which Display Query During Print Preview.

評論

8 條評論

  • Avatar
    Shotaro Ito
    Hi Phaneendra,

    From BarTender .net Print SDK, Query prompt cannot be disabled unless Window visibility is set to None.
    However you can specify value from QueryPrompts[<Query prompt name>].Value, and dialog won't be shown when all query prompt values have set.
    You can disable other dialogs from SDK - like below.

    [code]
    //Assume btFormat is LabelFormat object, and
    //Engine.Window.VisibleWindows is Seagull.BarTender.Print.VisibleWindows.InteractiveDialogs (or All).

    //Set query prompt value
    btFormat.DatabaseConnections.QueryPrompts["QueryPrompt1"].Value="0001";

    //Disable record selection dialog
    btFormat.PrintSetup.SelectRecordsAtPrint = false;

    //Disable user prompt
    btFormat.PrintSetup.EnablePrompting = false;

    [/code]
    hope that helps!
    0
  • Avatar
    Legacy Poster
    No it doesnt help me, i have tried with your code even then i am not able to handle this pop up message. For your ref. I have attached the screen shot of that pop up msg.http://picasaweb.google.com/lh/view?hl=en&gbv=2&biw=1280&bih=843&q=Prompt_at_print_preview&gs_sm=s&gs_upl=0l0l0l33681l0l0l0l0l0l0l0l0ll0l0&ie=UTF-8&sa=N&tab=iq#5671027821815792514
    0
  • Avatar
    Shotaro Ito
    Mmm, I cannot find the attached - Could you tell me what message is shown on the popup?
    If that's error / warning message, please tell me the message # too.
    0
  • Avatar
    Ian Cummings
    版主
    The screenshot was in the Picasa link. I attach it here for convenience.
    0
  • Avatar
    Ian Cummings
    版主
    I don't recognize this message as coming from BarTender. Based on the title of the Window and its content, it seems more likely that this is a message box from your application, which you used for testing the value of the SQL statement passed to BarTender for debugging purposes. Check your code for such a function call and either comment it out or remove it.

    If this is not the case though...

    1. Do you get this appear when using the BarTender application manually?

    2. Test to see if this is label format related by creating a simple label that connects to the same database in a similar way with just a couple of linked label objects.

    3. In the database set-up for the label format, select the "Options" tab, click the "OLE DB Messages" button and tick the "Ignore all errors" check box and save the label. Does that make any difference?
    0
  • Avatar
    Shotaro Ito
    Thanks Phaneendra, Ian, I can see the popup now.

    It looks you show popup dialog if any message is returned, right?
    Yes, without good reason, it looks .net Print SDK Print method returns Message #1200:Information:SQL Statement in messages object, even the message has been disabled in BarTender's Administer > Application Message setup.

    Since this message is just information, you can ignore this message in your code.
    Something like below.
    [code]
    // Print the format.
    btFormat.Print(btFormat.BaseName, out messages);

    // Show all messages but #1200
    string result = "";
    foreach (Seagull.BarTender.Print.Message m in messages){
    if (m.ID != 1200)
    {
    result = result + m.ID + ":" + m.Severity + ":" + m.Text + "\r\n";
    }
    }
    if (result != "")
    {
    MessageBox.Show(result);
    }
    [/code]
    I'll check the current behavior is intended or not.
    0
  • Avatar
    Legacy Poster

    messageString = messages.Where(m=>m.ID != 1200).Aggregate("Messages:" , (current, message) => current + ("\n\n" + message.Text));

    0
  • Avatar
    Legacy Poster

    Hi.
    I've Failure Message on this code and nothing print, but sometimes it prints and show message

                // Start the BarTender print engine.
                btEngine.Start();
    
                // Open a format.
                LabelFormatDocument btFormat = btEngine.Documents.Open(labelpath, printer);
                ((OLEDB)btFormat.DatabaseConnections[0]).SQLStatement = SQL;
                btFormat.PrintSetup.IdenticalCopiesOfLabel = copies;
    
                Messages btMessages;
                // Print the format.
                Result nResult = btFormat.Print("OUT Sticker", out btMessages);
                if (nResult != Result.Success)
                {
                    foreach (Message m in btMessages)
                        alert += "Category = " + m.Category + " ID = " + m.ID + " Severity = " + m.Severity + " Text = " + m.Text + " ";
                            //"Text = " + m.Text;
                }
    

     

    Category = Printer ID = 1200 Severity = Information Text =

     SQL Statement: SELECT "Article", "Date Insert",
    "Description", "GuidNo", "ID",
    "Param1", "Param10", "Param11",
    "Param12", "Param13", "Param14",
    "Param15", "Param16", "Param17",
    "Param18", "Param19", "Param2",
    "Param3", "Param4", "Param5", "Param6",
    "Param7", "Param8", "Param9", "Printer
    Name", "Processed", "Qty", "Request Necessary
    Date", "RequestId", "SAD No_ Barcode", "Ship-to
    Priority", "SN", "Sticker No_", "TQty",
    "User", "WO Reqd_ Date", "WO Reqd_ WeekDay" FROM
    "dbo"."xxxxxxxxx" WHERE
    "GuidNo" = '4C3176D2-E0BC-4A42-99F5-B047AA8DC45C' ORDER BY
    "ID" "

    It's on Zebra ZM400. But this format at the same time sucessfully prints on other printers (ZM400, Z4MPlus)

    After restart server it works correctly till some point.

     

    What could be the problem?

    Driver on all ZM400 identical ... Seagull

    Bartender version: 9.01


    0

登入寫評論。