public void ImprimirEtiquetas(String Titulo, String Modelo, String Gramos, String ID) { String sPath = "C:\\Users\\Adan Cervera\\Desktop\\TestGit\\TestGit\\POS.View\\VentasView\\CONTENEDORES.lbx"; bpac.Document objDoc = new Document(); objDoc = new Document(); if (objDoc.Open(sPath) != null) { objDoc.GetObject("objTitulo").Text = Titulo; objDoc.GetObject("modelo").Text = Modelo; objDoc.GetObject("gramos").Text = Gramos; objDoc.GetObject("codebar").Text = ID.ToString() + '-' + Gramos; objDoc.StartPrint("", bpac.PrintOptionConstants.bpoDefault); objDoc.PrintOut(1, bpac.PrintOptionConstants.bpoDefault); objDoc.EndPrint(); objDoc.Close(); } }
private static void ImprimirEtiqueta(Int32 CodigoBarras, String Titulo, String Descripcion) { String sPath = "C:\\Users\\Adan Cervera\\Desktop\\TestGit\\TestGit\\POS.View\\VentasView\\RECARGAS.lbx"; Document objDoc = new Document(); objDoc = new Document(); if (objDoc.Open(sPath) != null) { objDoc.GetObject("codebar").Text = CodigoBarras.ToString(); objDoc.GetObject("modelo").Text = Titulo; objDoc.GetObject("marca").Text = Descripcion; objDoc.StartPrint("", bpac.PrintOptionConstants.bpoDefault); objDoc.PrintOut(1, bpac.PrintOptionConstants.bpoDefault); objDoc.EndPrint(); objDoc.Close(); } }
private void btnGenerateNewPWs_Click(object sender, EventArgs e) { //killprocess("winword"); app = new Microsoft.Office.Interop.Word.Application { Visible = false }; System.Data.DataTable dt = new System.Data.DataTable(); string qry = "SELECT * FROM ibis_pw_userlist WHERE ibis_pw_userlist_active = 1 AND ibis_pw_userlist_id > 1"; //string qry = "SELECT * FROM ibis_pw_userlist WHERE ibis_pw_userlist_active = 1"; Random randnum = new Random(); int _min4 = 0; int _max4 = 9999; int _min6 = 0; int _max6 = 999999; using (MySqlConnection dbh = new MySqlConnection(Properties.Resources.DB_CONNSTR_HES)) { dbh.Open(); using (MySqlDataAdapter da = new MySqlDataAdapter(qry, dbh)) { da.Fill(dt); foreach (DataRow row in dt.Rows) { doc = app.Documents.Add(@"C:\Users\dc1_000\Documents\HoldenEngineering\pw_memo_template.docx"); doc.Activate(); string newpw; if (row["ibis_pw_userlist_un"].ToString().Equals("dholden")) { newpw = String.Format("{0:000000}", randnum.Next(_min6, _max6)); } else { // HERE IS WHERE ONE COULD RANDOMIZE THE PLACEMENT OF // THE ABBREVIATION RELATIVE TO THE FOUR-DIGIT NUMBER newpw = row["ibis_pw_userlist_abbr"].ToString() + String.Format("{0:0000}", randnum.Next(_min4, _max4)); } doc.Bookmarks["bmNameLbl"].Range.Text = row["ibis_pw_userlist_label"].ToString(); doc.Bookmarks["bmGenPW"].Range.Text = newpw; doc.Bookmarks["bmUserName"].Range.Text = row["ibis_pw_userlist_un"].ToString(); doc.Bookmarks["bmOldPW"].Range.Text = row["ibis_pw_userlist_currpw"].ToString(); doc.Bookmarks["bmNewPW"].Range.Text = newpw; doc.Bookmarks["bmNewPW2"].Range.Text = newpw; doc.PrintOut(); ((Microsoft.Office.Interop.Word._Document)doc).Close(false, ref missing, ref missing); try { MySqlCommand cmd = new MySqlCommand(); cmd.Connection = dbh; cmd.CommandText = "UPDATE ibis_pw_userlist SET ibis_pw_userlist_currpw = @npw, ibis_pw_userlist_prevpw = @opw WHERE ibis_pw_userlist_id = @uid"; cmd.Prepare(); cmd.Parameters.AddWithValue("@npw", newpw); cmd.Parameters.AddWithValue("@opw", row["ibis_pw_userlist_currpw"].ToString()); cmd.Parameters.AddWithValue("@uid", row["ibis_pw_userlist_id"].ToString()); cmd.ExecuteNonQuery(); } catch (MySqlException mysqle) { MessageBox.Show("mysql ERROR: " + mysqle.ToString()); return; } catch (Exception m1ex) { MessageBox.Show("M1_ERROR: " + m1ex.ToString()); return; } } } dbh.Close(); } }
private void btnPrintPWMemos_Click(object sender, EventArgs e) { app = new Microsoft.Office.Interop.Word.Application { Visible = false }; System.Data.DataTable dt = new System.Data.DataTable(); string qry = "SELECT * FROM ibis_pw_userlist WHERE ibis_pw_userlist_active = 1"; using (MySqlConnection dbh = new MySqlConnection(Properties.Resources.DB_CONNSTR_HES)) { dbh.Open(); using (MySqlDataAdapter da = new MySqlDataAdapter(qry, dbh)) { da.Fill(dt); foreach (DataRow row in dt.Rows) { doc = app.Documents.Add(@"C:\Users\dc1_000\Documents\HoldenEngineering\pw_memo_template.docx"); doc.Activate(); doc.Bookmarks["bmNameLbl"].Range.Text = row["ibis_pw_userlist_label"].ToString(); doc.Bookmarks["bmGenPW"].Range.Text = row["ibis_pw_userlist_currpw"].ToString(); doc.Bookmarks["bmUserName"].Range.Text = row["ibis_pw_userlist_un"].ToString(); doc.Bookmarks["bmOldPW"].Range.Text = row["ibis_pw_userlist_prevpw"].ToString(); doc.Bookmarks["bmNewPW"].Range.Text = row["ibis_pw_userlist_currpw"].ToString(); doc.Bookmarks["bmNewPW2"].Range.Text = row["ibis_pw_userlist_currpw"].ToString(); doc.PrintOut(); ((Microsoft.Office.Interop.Word._Document)doc).Close(false, ref missing, ref missing); } } dbh.Close(); } }