private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) { if (e.RowIndex >= 0) { if (dataGridView1.Columns[e.ColumnIndex].HeaderText == "打印") { int ret = 0; try { ret = Program.openport("Gprinter GP-3120TU"); //Open specified printer driver if (ret < 1) { return; } if (dataGridView1.Columns[0].HeaderText != "证书编号" || dataGridView1.Columns[1].HeaderText != "姓名" || dataGridView1.Columns[9].HeaderText != "发证日期") { MessageBox.Show("异常情况,请重新打开软件再尝试"); return; } string print1 = "姓名:" + dataGridView1.Rows[e.RowIndex].Cells[1].Value.ToString(); // MajorLog.Info(print1); MajorLog.Info(dataGridView1.Rows[e.RowIndex].Cells[9].Value.ToString()); MajorLog.Info(dataGridView1.Rows[e.RowIndex].Cells[9].Value.ToString().Substring(2, 8)); string print2 = "发证日期:" + dataGridView1.Rows[e.RowIndex].Cells[9].Value.ToString().Substring(2, 8); string print3 = dataGridView1.Rows[e.RowIndex].Cells[0].Value.ToString(); MajorLog.Info(print3); DialogResult dr = MessageBox.Show(print1 + "\n" + print2 + "\n" + print3, "是否打印", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (dr == DialogResult.OK) { ret = Program.setup("30", "17", "6", "10", "0", "1", "0"); //Setup the media size and sensor type info ret = Program.clearbuffer(); //Clear image buffer // ret = TSCLIB_DLL.barcode("0", "0", "128", "10", "1", "0", "2", "2", "Barcode Test"); //Drawing barcode ret = Program.printerfont("0", "24", "TSS24.BF2", "0", "1", "1", print1); //Drawing printer font ret = Program.printerfont("0", "56", "TSS24.BF2", "0", "1", "1", print2); //Drawing printer font ret = Program.printerfont("0", "88", "TSS24.BF2", "0", "1", "1", print3); //Drawing printer font ret = Program.printlabel("1", "1"); //Print labels ret = Program.closeport(); } else { return; } } catch (Exception ex) { MessageBox.Show("异常情况,无法正常打印标签!" + ex.Message); MajorLog.Info("打码机未连接或出现异常情况,无法正常打印标签!" + ex.ToString()); } } } }
private void button2_Click(object sender, EventArgs e) { int ret = 0; try { ret = Program.openport("Gprinter GP-3120TU"); //Open specified printer driver if (ret < 1) { // MessageBox.Show("请检查打印机是否就绪!"); return; } string print1 = "姓名:" + CertInfo.name; string print2 = "有效期至:" + CertInfo.cert_validity_period_end.Substring(2, 8); string print3 = CertInfo.OnlyID; ret = Program.setup("30", "17", "6", "10", "0", "1", "0"); //Setup the media size and sensor type info ret = Program.clearbuffer(); //Clear image buffer // ret = TSCLIB_DLL.barcode("0", "0", "128", "10", "1", "0", "2", "2", "Barcode Test"); //Drawing barcode ret = Program.printerfont("0", "24", "TSS24.BF2", "0", "1", "1", print1); //Drawing printer font ret = Program.printerfont("0", "56", "TSS24.BF2", "0", "1", "1", print2); //Drawing printer font ret = Program.printerfont("0", "88", "TSS24.BF2", "0", "1", "1", print3); //Drawing printer font //ret = Program.setup("40", "32", "6", "10", "0", "1", "0"); //Setup the media size and sensor type info //ret = Program.clearbuffer(); //Clear image buffer // ret = TSCLIB_DLL.barcode("0", "0", "128", "10", "1", "0", "2", "2", "Barcode Test"); //Drawing barcode //ret = Program.printerfont("0", "40", "TSS24.BF2", "0", "1", "1", print1); //Drawing printer font //ret = Program.printerfont("0", "80", "TSS24.BF2", "0", "1", "1", print2); //Drawing printer font //ret = Program.printerfont("0", "120", "TSS24.BF2", "0", "1", "1", print3); //Drawing printer font ret = Program.printlabel("1", "1"); //Print labels ret = Program.closeport(); } catch (Exception ex) { MajorLog.Info("打码机未连接或出现异常情况,无法正常打印标签!" + ex.ToString()); } }
private void button1_Click(object sender, EventArgs e) { MajorLog.Debug("点击确认并制证"); if (button1.Text == "确认并制证") { #region 制证 try { MajorLog.Debug("开始制证"); string downCmd = "CN=USER,O=" + CertInfo.OnlyID + ",C=CN"; // string downCmdRoot = "CN=ROOT,O=TEST,C=CN"; byte[] s = new byte[1024]; int ret = 0; ret = Function.Genuserkey();//产生用户密钥对 if (ret == -1) { return; } MajorLog.Info("产生用户密钥对"); ret = Function.Genuserp10(ref s[0], downCmd);//产生用户P10 if (ret == -1) { return; } MajorLog.Info("产生用户P10"); ret = Function.Genusercer(ref s[0], "FEDCBA9876543210", "20170101000000", "20270101000000", downCmd, 1);//产生用户证书 MajorLog.Info("产生用户证书"); string strGet2 = System.Text.Encoding.Default.GetString(s, 0, s.Length); // int len = strGet2.Length; // string downStr = strGet2.Substring(0, len); ret = Function.Importcert(strGet2); if (ret > 0) { MajorLog.Debug("写入证书--成功"); } else { MajorLog.Debug("写入证书--失败"); } timer1.Enabled = true; } catch (Exception ex) { MessageBox.Show(ex.Message); MajorLog.Debug(ex.ToString()); } #endregion CertInfo.state = "0"; string CmdStr = "insert into tableall(姓名,性别,年龄,手机号,身份证号,邮箱账号,证书类型,设备类型,发证日期,证书有效期,项目名称,APPID,APP密码,所属单位名称,所属单位电话,所属单位地址,备注,证书编号,状态,设备所属单位) " + "values(@name,@gender, @age, @phone, @id,@mail,@issue_type,@install_type,@issue_day,@valid_period,@project_name,@appid,@appkey,@company_name,@company_phone,@company_address,@remarks,@OnlyID,@state,@belong)"; if (Function.UseDataBase != 0) { using (MySqlConnection con = new MySqlConnection(SQLClass.connsql)) using (MySqlCommand cmd = new MySqlCommand(CmdStr, con)) { try { cmd.Parameters.AddWithValue("@name", CertInfo.name); cmd.Parameters.AddWithValue("@gender", CertInfo.gender); cmd.Parameters.AddWithValue("@age", CertInfo.age); cmd.Parameters.AddWithValue("@phone", CertInfo.phone); cmd.Parameters.AddWithValue("@id", CertInfo.id); cmd.Parameters.AddWithValue("@mail", CertInfo.email); cmd.Parameters.AddWithValue("@issue_type", CertInfo.issue_type); cmd.Parameters.AddWithValue("@install_type", CertInfo.install_type); cmd.Parameters.AddWithValue("@issue_day", CertInfo.issue_day); cmd.Parameters.AddWithValue("@valid_period", CertInfo.cert_validity_period); cmd.Parameters.AddWithValue("@project_name", CertInfo.project_name); cmd.Parameters.AddWithValue("@appid", CertInfo.appid); cmd.Parameters.AddWithValue("@appkey", CertInfo.appkey); cmd.Parameters.AddWithValue("@company_name", CertInfo.company_name); cmd.Parameters.AddWithValue("@company_phone", CertInfo.company_phone); cmd.Parameters.AddWithValue("@company_address", CertInfo.company_address); cmd.Parameters.AddWithValue("@remarks", CertInfo.remarks); cmd.Parameters.AddWithValue("@OnlyID", CertInfo.OnlyID); cmd.Parameters.AddWithValue("@State", CertInfo.state); cmd.Parameters.AddWithValue("@Belong", CertInfo.company_belong); con.Open(); cmd.ExecuteNonQuery(); con.Close(); button1.Text = "制证中..."; button1.BackColor = Color.Green; } catch (MySqlException ex) { MessageBox.Show(ex.Message); } } } else { MajorLog.Debug("未使用数据库"); } } else { MessageBox.Show("制证已完成,请关闭此窗口!"); } }