public int InsertBarTenderPrintingLable(int productid, string formatname, int chk) { try { string btFileName = ""; LogFile lf = new LogFile(); using (Engine btEngine = new Engine()) { lf.LogMessge("S1 :" + "Inside Service"); btEngine.Start(); lf.LogMessge("S2 :" + "Service Started"); btEngine.Window.Visible = true; // btFileName = @"\\glpdc01\corp\IT Files\GPLS\BarTenderFiles\" + filename + ".btw"; //btFileName = @"\\psapp01\IT Files\PLS\BarTenderFiles\" + filename + ".btw"; btFileName = @"\\psapp01\IT Files\PLS\BarTenderFilesTest01\" + formatname + ".btw"; lf.LogMessge("S3 :" + "File Path"); lf.LogMessge("S4 :" + "File :" + btFileName); LabelFormatDocument btFormat = btEngine.Documents.Open(btFileName); lf.LogMessge("S5 :" + "Go the File"); Seagull.BarTender.Print.Database.QueryPrompts queryprompts = btFormat.DatabaseConnections.QueryPrompts; queryprompts["productid"].Value = productid.ToString(); queryprompts["chk"].Value = chk.ToString(); lf.LogMessge("S6 :" + "Query Promted"); //btFormat.PrintSetup.IdenticalCopiesOfLabel = labelcount; //btFormat.PrintSetup.NumberOfSerializedLabels = 4 Result result = btFormat.Print(btFileName); lf.LogMessge("S7 :" + "Result: " + result); //Result result = btFormat.Print(); if (result == Result.Failure) { lf.LogMessge("S8 :" + "Failure "); btFormat.Close(Seagull.BarTender.Print.SaveOptions.DoNotSaveChanges); btEngine.Stop(); btEngine.Dispose(); return(0); } else { lf.LogMessge("S9 :" + "Sucess "); btFormat.Close(Seagull.BarTender.Print.SaveOptions.DoNotSaveChanges); btEngine.Stop(); btEngine.Dispose(); return(1); } } } catch (Exception ex) { LogFile lf1 = new LogFile(); lf1.LogMessge("S10 :" + "Exception Date :" + DateTime.Now.ToLongTimeString() + "\nException Message:" + ex.Message); // Page.ClientScript.RegisterStartupScript(this.GetType(), "log", "log('" + ex.Message + "');", true); return(0); } }
public int BarTenderPrintingLable(int controlId, int labelcount, int categorycode, string filename, int batchid, int testprint) { try { string btFileName = ""; LogFile lf = new LogFile(); using (Engine btEngine = new Engine()) { lf.LogMessge("S1 :" + "Inside Service"); btEngine.Start(); lf.LogMessge("S2 :" + "Service Started"); btEngine.Window.Visible = true; // btFileName = @"\\psapp01\IT Files\PLS\BarTenderFilesTes1\" + filename + ".btw"; btFileName = @"\\psapp01\IT Files\PLS\BarTenderFiles\" + filename + ".btw"; lf.LogMessge("S4 :" + "File :" + btFileName); LabelFormatDocument btFormat = btEngine.Documents.Open(btFileName); lf.LogMessge("S3 :" + "File Path"); lf.LogMessge("S4 :" + "File :" + btFileName); Seagull.BarTender.Print.Database.QueryPrompts queryprompts = btFormat.DatabaseConnections.QueryPrompts; lf.LogMessge("S5 :" + "Go the File"); queryprompts["controlid"].Value = controlId.ToString(); queryprompts["categorycode"].Value = categorycode.ToString(); queryprompts["toprint"].Value = labelcount.ToString(); queryprompts["batchid"].Value = batchid.ToString(); queryprompts["testprint"].Value = testprint.ToString(); lf.LogMessge("S6 :" + "Query Promted"); //btFormat.PrintSetup.IdenticalCopiesOfLabel = labelcount; //btFormat.PrintSetup.NumberOfSerializedLabels = 4 Result result = btFormat.Print(btFileName); lf.LogMessge("S7 :" + "Result: " + result); //Result result = btFormat.Print(); if (result == Result.Failure) { lf.LogMessge("S8 :" + "Failure "); btFormat.Close(Seagull.BarTender.Print.SaveOptions.DoNotSaveChanges); btEngine.Stop(); btEngine.Dispose(); return(0); } else { lf.LogMessge("S9 :" + "Sucess "); btFormat.Close(Seagull.BarTender.Print.SaveOptions.DoNotSaveChanges); btEngine.Stop(); btEngine.Dispose(); return(1); } } } catch (Exception ex) { LogFile lf1 = new LogFile(); lf1.LogMessge("S10 :" + "Exception Date :" + DateTime.Now.ToLongTimeString() + "\nException Message:" + ex.Message); return(0); } }
public void BarTenderPrintingLable(int id) { try { DataTable dt = new DataTable(); //SqlCommand cmd = new SqlCommand("dbo.spLabelingReportPreview", conn); //cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@ControlID", id); //SqlDataAdapter da = new SqlDataAdapter(cmd); //da.Fill(dt); dt = st_dll.ReportData("dbo.spLabelingReportPreview", id, 4); DataRow row = dt.Rows[0]; using (Engine btEngine = new Engine()) { btEngine.Start(); //btEngine.Window.Visible = true; string btFileName = ""; btFileName = @"\\GLWS18\Users\samancha\Documents\BarTender\BarTenderDocuments\Product_Label.btw"; //btFileName = @"C:\Users\samancha\Desktop\Product_Label.btw"; LabelFormatDocument btFormat = btEngine.Documents.Open(btFileName); Seagull.BarTender.Print.Database.QueryPrompts queryprompts = btFormat.DatabaseConnections.QueryPrompts; queryprompts["controlid"].Value = id.ToString(); btFormat.PrintSetup.IdenticalCopiesOfLabel = Convert.ToInt32(dt.Rows[0]["LabelCount"]); Result result = btFormat.Print(btFileName); //Result result = btFormat.Print(); if (result == Result.Failure) { //string Message = "Label is printed Failure"; //string wsScript = "<script type=\"text/javascript\">document.getElementById('#divfailure').style.display='block';document.getElementById('#divfailure').InnerHtml ='" + Message + "'</script>"; //Page.ClientScript.RegisterStartupScript(this.GetType(), "validation", wsScript, true); SucessMessage("Label is printed successfully !"); } else { //string Message = "Label is printed Successfully"; //string wsScript = "<script type=\"text/javascript\">document.getElementById('#divAdded').style.display='block';document.getElementById('#divAdded').InnerHtml ='" + Message + "'</script>"; //Page.ClientScript.RegisterStartupScript(this.GetType(), "validation", wsScript, true); ErrorMessage("Failed to print the label !"); } btFormat.Close(Seagull.BarTender.Print.SaveOptions.DoNotSaveChanges); btEngine.Stop(); } } catch (Exception ex) { ErrorMessage(ex.Message); } }
//protected void btnPrint_Click(object sender, EventArgs e) //{ // btnPrint.Enabled = false; // DataTable dt = st_dll.GetLabelCountData("dbo.spGenerateLabels", "C", controlId, categorycode); // if (Convert.ToInt32(dt.Rows[0]["LabelCount"]) > 0) // { // ProductsEntity pe = new ProductsEntity(); // pe.ControlID = controlId; // pe.PrintedByID = Convert.ToInt32(Session["UserID"]); // pe.categorycode = categorycode; // int print_result = BarTenderPrintingLable(controlId, Convert.ToInt32(dt.Rows[0]["LabelCount"]), categorycode); // if (print_result != 0) // { // int result = st_dll.UpdatePrinting("dbo.spUpdatePrinting", pe); // if (result != 0) // { // if (categorycode == 2) // { // ProductsEntity pe1 = new ProductsEntity(); // pe1.ControlID = controlId; // pe1.PrintedByID = Convert.ToInt32(Session["UserID"]); // pe1.categorycode = 3; // DataTable dt2 = st_dll.GetLabelCountData("dbo.spGenerateLabels", "C", controlId, 3); // System.Threading.Thread.Sleep(2000); // int case_result = BarTenderPrintingLable(controlId, Convert.ToInt32(dt2.Rows[0]["LabelCount"]), 3); // //DelayMethod(controlId, Convert.ToInt32(dt2.Rows[0]["LabelCount"]), categorycode); // if (case_result != 0) { // st_dll.UpdatePrinting("dbo.spUpdatePrinting", pe1); // } // } // BindGrid(1,100); // CheckLabelPrint(controlId, categorycode); // SucessMessage("The labels are printed successfully!"); // } // else { // ErrorMessage("Failed to Save the Print Data!"); // } // } // else { // ErrorMessage("Failed to Print the Label in BarTender!"); // } // } // else { // ErrorMessage("All labels are printed!"); // } // btnPrint.Enabled = true; //} //public void DelayMethod(int ControlID,int labelcount,int categorycode) //{ // System.Threading.Timer timer = null; // timer = new System.Threading.Timer((obj) => // { // BarTenderPrintingLable(ControlID, labelcount, categorycode); // timer.Dispose(); // }, // null, 1000, System.Threading.Timeout.Infinite); //} public int BarTenderPrintingLable(int controlId, int labelcount, int categorycode) { try { //DataTable dt = new DataTable(); //dt = st_dll.ReportData("dbo.spLabelingReportPreview", controlId, categorycode); //DataRow row = dt.Rows[0]; string btFileName = ""; string fileName = ""; using (Engine btEngine = new Engine()) { btEngine.Start(); btEngine.Window.Visible = true; if (categorycode == 3) { if (ddlLabelFormats.SelectedValue == "0") { fileName = st_dll.GetCaseFileName("dbo.spGetCaseFileName", controlId, categorycode); btFileName = @"\\glpdc01\corp\IT Files\GPLS\BarTenderFiles\" + fileName + ".btw"; } else { //fileName = ddlLabelFormats.SelectedItem.Text; fileName = ddlLabelFormats.SelectedValue.ToString(); btFileName = @"\\glpdc01\corp\IT Files\GPLS\BarTenderFiles\" + fileName + ".btw"; } } else { //fileName = ddlLabelFormats.SelectedItem.Text; fileName = ddlLabelFormats.SelectedValue.ToString(); // btFileName = @"\\GLWS18\Users\samancha\Documents\BarTender\BarTenderDocuments\" + fileName + ".btw"; btFileName = @"\\glpdc01\corp\IT Files\GPLS\BarTenderFiles\" + fileName + ".btw"; } //if (categorycode == 1 || categorycode == 4) //{ //Product Label // int unitsize = st_dll.GetUnitSize(controlId); // string itemdesc = st_dll.GetItemDesc(controlId); // if (unitsize != 0) // { // btFileName = @"\\GLWS18\Users\samancha\Documents\BarTender\BarTenderDocuments\ProductLabel_New.btw"; // } // else { // btFileName = @"\\GLWS18\Users\samancha\Documents\BarTender\BarTenderDocuments\ProductLabel_New_ItemDesc.btw"; // } //} //else if (categorycode == 2) //{ //Insert Box Label // btFileName = @"\\GLWS18\Users\samancha\Documents\BarTender\BarTenderDocuments\InsertLabel_New.btw"; //} //else if (categorycode == 3) //{ //Case Label // btFileName = @"\\GLWS18\Users\samancha\Documents\BarTender\BarTenderDocuments\CaseLabel_New.btw"; //} // btFileName = @"C:\Users\samancha\Desktop\Product_Label.btw"; LabelFormatDocument btFormat = btEngine.Documents.Open(btFileName); Seagull.BarTender.Print.Database.QueryPrompts queryprompts = btFormat.DatabaseConnections.QueryPrompts; queryprompts["controlid"].Value = controlId.ToString(); queryprompts["categorycode"].Value = categorycode.ToString(); queryprompts["toprint"].Value = labelcount.ToString(); //btFormat.PrintSetup.IdenticalCopiesOfLabel = labelcount; //btFormat.PrintSetup.NumberOfSerializedLabels = 4 Result result = btFormat.Print(btFileName); //Result result = btFormat.Print(); if (result == Result.Failure) { //string Message = "Label is printed Failure"; //string wsScript = "<script type=\"text/javascript\">document.getElementById('#divfailure').style.display='block';document.getElementById('#divfailure').InnerHtml ='" + Message + "'</script>"; //Page.ClientScript.RegisterStartupScript(this.GetType(), "validation", wsScript, true); //SucessMessage("Label is printed Successfully !"); btFormat.Close(Seagull.BarTender.Print.SaveOptions.DoNotSaveChanges); btEngine.Stop(); btEngine.Dispose(); return(0); } else { //string Message = "Label is printed Successfully"; //string wsScript = "<script type=\"text/javascript\">document.getElementById('#divAdded').style.display='block';document.getElementById('#divAdded').InnerHtml ='" + Message + "'</script>"; //Page.ClientScript.RegisterStartupScript(this.GetType(), "validation", wsScript, true); //ErrorMessage("Failed to Print the Label !"); btFormat.Close(Seagull.BarTender.Print.SaveOptions.DoNotSaveChanges); btEngine.Stop(); btEngine.Dispose(); return(1); } } } catch (Exception) { return(0); } }