using DevExpress.Internal.WinApi.Windows.UI.Notifications; using DevExpress.Utils.Drawing.Helpers; using GSproduction.SQL; using GSProduction.SQLLT; using SpeechLib; using System; using System.ComponentModel; using System.Data; using System.Drawing; using System.Windows.Forms; namespace GSproduction { public partial class GSBGBarcodeFrm : Form { #region 参数 private Panel panel1; private Timer timer1; private System.ComponentModel.IContainer components; private TextBox textBox1; private Label label5; SQLHelper SQL = null; OracleHelper OraSQL = null; DataTable tbB = null; DataTable tbC = null; DataTable tbD = null; DataTable tbA = null; DataTable dtWC = null; DataTable tbG = null; private int b =0; private string tmNO =""; private Panel panel2; private DataGridView dataGridView1; private GSproductionClass wc = new GSproductionClass(); private WeightCollectDataSet1 weightCollectDataSet1; private BindingSource bGBarcodeBindingSource; private WeightCollectDataSet1TableAdapters.BGBarcodeTableAdapter bGBarcodeTableAdapter; int d = 0; String connStr = "Data Source=192.168.1.198;Initial Catalog=CSFrameworkV5_Normal;User Id=sa;Password=Weaver@2001;Pooling=False;Pooling=true;Min Pool Size=10;Max Pool Size=50;Connect Timeout=500"; private DataGridViewTextBoxColumn BianNo; private Label label9; private TextBox textBox5; private Label label8; private TextBox textBox4; private Label label7; private TextBox textBox3; private Label label6; private TextBox textBox2; private Timer timer2; private Label label1; private TextBox textBox6; private Label label2; private TextBox textBox7; private DataTable tbBARDAB;//条码表 String connectionString = "Data Source=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =192.168.1.19)(PORT =1521)))(CONNECT_DATA =(SERVICE_NAME = ORCL)));Persist Security Info=True;User Id = abtdev;Password=abt_dev"; //String connectionString = "Data Source = 192.168.1.19; Initial Catalog = abtdev; User ID = abtdev; Password=abt_dev"; #endregion #region 初始化数据 public GSBGBarcodeFrm() { InitializeComponent(); this.TopMost = true; // 窗口置顶 // this.FormBorderStyle = FormBorderStyle.None; // 去除边框 // this.SetStyle(ControlStyles.ResizeRedraw | ControlStyles.AllPaintingInWmPaint, true); // 设置样式 this.WindowState = FormWindowState.Maximized;//最大化 this.textBox1.Focus(); // 默认聚焦到textbox1 SQL = new SQLHelper(connStr); // OraSQL = new OracleHelper(connectionString); // string sql = "select BarcodeNO 条码号,LinesName 线别,WorkNo 工单单号,Product 产品类型,CheckCategory1 检测类别1,CheckCategory2 检测类别2,CheckCategory3 检测类别3,CheckCategory4 检测类别4,CheckCategory5 检测类别5,CheckCategory6 检测类别6,CheckCategory7 检测类别7,CheckCategory8 检测类别8,CheckCategory9 检测类别9,CheckCategory10 检测类别10 from BGBarcode where 1=2"; string sql = "select BARCODE,CREATETIME,BILLNO,QUANTITY,PORESULT,ERMSG from GSLOG_BG(NOLOCK) where 1 = 2"; // dtWC = OraSQL.ReturnDataSet("SELECT BARCODENO,'' CHEEKTIME ,LINESNAME,WORKNO,PRODUCT,CHECKCATEGORY1,CHECKCATEGORY2,CHECKCATEGORY3,CHECKCATEGORY4,CHECKCATEGORY5,CHECKCATEGORY6,CHECKCATEGORY7,CHECKCATEGORY8,CHECKCATEGORY9,CHECKCATEGORY10 FROM BGBarcode where 1 = 2", "BGBarcode").Tables[0]; dtWC = SQL.ExecuteDataTable(sql); dtWC.Columns.Add("BianNo"); dataGridView1.DataSource = dtWC; dataGridView1.Columns[0].HeaderText = "条码"; dataGridView1.Columns[1].HeaderText = "报工时间"; dataGridView1.Columns[2].HeaderText = "工单单号"; dataGridView1.Columns[3].HeaderText = "报工数量"; dataGridView1.Columns[4].HeaderText = "报工结果"; dataGridView1.Columns[5].HeaderText = "返回信息"; // dataGridView1.Columns[0].Width = 200; //comboBox2.Enabled = false; //comboBox1.ForeColor = System.Drawing.Color.Yellow; } #endregion #region 初始化 private void InitializeComponent() { this.components = new System.ComponentModel.Container(); this.panel1 = new System.Windows.Forms.Panel(); this.label2 = new System.Windows.Forms.Label(); this.textBox7 = new System.Windows.Forms.TextBox(); this.label1 = new System.Windows.Forms.Label(); this.textBox6 = new System.Windows.Forms.TextBox(); this.textBox5 = new System.Windows.Forms.TextBox(); this.label9 = new System.Windows.Forms.Label(); this.label8 = new System.Windows.Forms.Label(); this.textBox4 = new System.Windows.Forms.TextBox(); this.label7 = new System.Windows.Forms.Label(); this.textBox3 = new System.Windows.Forms.TextBox(); this.label6 = new System.Windows.Forms.Label(); this.textBox2 = new System.Windows.Forms.TextBox(); this.textBox1 = new System.Windows.Forms.TextBox(); this.label5 = new System.Windows.Forms.Label(); this.timer1 = new System.Windows.Forms.Timer(this.components); this.panel2 = new System.Windows.Forms.Panel(); this.dataGridView1 = new System.Windows.Forms.DataGridView(); this.BianNo = new System.Windows.Forms.DataGridViewTextBoxColumn(); this.timer2 = new System.Windows.Forms.Timer(this.components); this.bGBarcodeBindingSource = new System.Windows.Forms.BindingSource(this.components); this.weightCollectDataSet1 = new GSproduction.WeightCollectDataSet1(); this.bGBarcodeTableAdapter = new GSproduction.WeightCollectDataSet1TableAdapters.BGBarcodeTableAdapter(); this.panel1.SuspendLayout(); this.panel2.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.bGBarcodeBindingSource)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.weightCollectDataSet1)).BeginInit(); this.SuspendLayout(); // // panel1 // this.panel1.Controls.Add(this.label2); this.panel1.Controls.Add(this.textBox7); this.panel1.Controls.Add(this.label1); this.panel1.Controls.Add(this.textBox6); this.panel1.Controls.Add(this.textBox5); this.panel1.Controls.Add(this.label9); this.panel1.Controls.Add(this.label8); this.panel1.Controls.Add(this.textBox4); this.panel1.Controls.Add(this.label7); this.panel1.Controls.Add(this.textBox3); this.panel1.Controls.Add(this.label6); this.panel1.Controls.Add(this.textBox2); this.panel1.Controls.Add(this.textBox1); this.panel1.Controls.Add(this.label5); this.panel1.Dock = System.Windows.Forms.DockStyle.Top; this.panel1.Font = new System.Drawing.Font("宋体", 14F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.panel1.ForeColor = System.Drawing.Color.Black; this.panel1.Location = new System.Drawing.Point(0, 0); this.panel1.Name = "panel1"; this.panel1.Size = new System.Drawing.Size(1356, 449); this.panel1.TabIndex = 0; this.panel1.Paint += new System.Windows.Forms.PaintEventHandler(this.panel1_Paint); // // label2 // this.label2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.label2.AutoSize = true; this.label2.Font = new System.Drawing.Font("宋体", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.label2.Location = new System.Drawing.Point(30, 361); this.label2.Name = "label2"; this.label2.Size = new System.Drawing.Size(79, 33); this.label2.TabIndex = 23; this.label2.Text = "数量"; // // textBox7 // this.textBox7.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.textBox7.Font = new System.Drawing.Font("宋体", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.textBox7.Location = new System.Drawing.Point(170, 361); this.textBox7.Name = "textBox7"; this.textBox7.ReadOnly = true; this.textBox7.Size = new System.Drawing.Size(1131, 44); this.textBox7.TabIndex = 22; // // label1 // this.label1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.label1.AutoSize = true; this.label1.Font = new System.Drawing.Font("宋体", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.label1.Location = new System.Drawing.Point(30, 361); this.label1.Name = "label1"; this.label1.Size = new System.Drawing.Size(79, 33); this.label1.TabIndex = 23; this.label1.Text = "数量"; // // textBox6 // this.textBox6.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.textBox6.Font = new System.Drawing.Font("宋体", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.textBox6.Location = new System.Drawing.Point(170, 361); this.textBox6.Name = "textBox6"; this.textBox6.ReadOnly = true; this.textBox6.Size = new System.Drawing.Size(1131, 44); this.textBox6.TabIndex = 22; // // textBox5 // this.textBox5.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.textBox5.Font = new System.Drawing.Font("宋体", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.textBox5.Location = new System.Drawing.Point(169, 289); this.textBox5.Name = "textBox5"; this.textBox5.ReadOnly = true; this.textBox5.Size = new System.Drawing.Size(1132, 44); this.textBox5.TabIndex = 20; this.textBox5.TextChanged += new System.EventHandler(this.textBox5_TextChanged); // // label9 // this.label9.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.label9.AutoSize = true; this.label9.Font = new System.Drawing.Font("宋体", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.label9.Location = new System.Drawing.Point(30, 292); this.label9.Name = "label9"; this.label9.Size = new System.Drawing.Size(79, 33); this.label9.TabIndex = 21; this.label9.Text = "单位"; this.label9.Click += new System.EventHandler(this.label9_Click); // // label8 // this.label8.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.label8.AutoSize = true; this.label8.Font = new System.Drawing.Font("宋体", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.label8.Location = new System.Drawing.Point(30, 237); this.label8.Name = "label8"; this.label8.Size = new System.Drawing.Size(143, 33); this.label8.TabIndex = 17; this.label8.Text = "产品规格"; // // textBox4 // this.textBox4.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.textBox4.Font = new System.Drawing.Font("宋体", 14F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.textBox4.Location = new System.Drawing.Point(170, 234); this.textBox4.Name = "textBox4"; this.textBox4.ReadOnly = true; this.textBox4.Size = new System.Drawing.Size(1132, 39); this.textBox4.TabIndex = 16; this.textBox4.TextChanged += new System.EventHandler(this.textBox4_TextChanged); // // label7 // this.label7.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.label7.AutoSize = true; this.label7.Font = new System.Drawing.Font("宋体", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.label7.Location = new System.Drawing.Point(30, 175); this.label7.Name = "label7"; this.label7.Size = new System.Drawing.Size(143, 33); this.label7.TabIndex = 15; this.label7.Text = "产品名称"; // // textBox3 // this.textBox3.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.textBox3.Font = new System.Drawing.Font("宋体", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.textBox3.Location = new System.Drawing.Point(169, 172); this.textBox3.Name = "textBox3"; this.textBox3.ReadOnly = true; this.textBox3.Size = new System.Drawing.Size(1132, 44); this.textBox3.TabIndex = 14; this.textBox3.TextChanged += new System.EventHandler(this.textBox3_TextChanged); // // label6 // this.label6.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.label6.AutoSize = true; this.label6.Font = new System.Drawing.Font("宋体", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.label6.Location = new System.Drawing.Point(30, 115); this.label6.Name = "label6"; this.label6.Size = new System.Drawing.Size(143, 33); this.label6.TabIndex = 13; this.label6.Text = "产品编码"; // // textBox2 // this.textBox2.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.textBox2.Font = new System.Drawing.Font("宋体", 16F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.textBox2.Location = new System.Drawing.Point(169, 112); this.textBox2.Name = "textBox2"; this.textBox2.ReadOnly = true; this.textBox2.Size = new System.Drawing.Size(1132, 44); this.textBox2.TabIndex = 12; // // textBox1 // this.textBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.textBox1.Font = new System.Drawing.Font("宋体", 18F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.textBox1.Location = new System.Drawing.Point(169, 42); this.textBox1.Name = "textBox1"; this.textBox1.Size = new System.Drawing.Size(1132, 49); this.textBox1.TabIndex = 9; this.textBox1.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.textBox1_KeyPress); // // label5 // this.label5.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.label5.AutoSize = true; this.label5.Font = new System.Drawing.Font("宋体", 18F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134))); this.label5.Location = new System.Drawing.Point(29, 45); this.label5.Name = "label5"; this.label5.Size = new System.Drawing.Size(87, 36); this.label5.TabIndex = 8; this.label5.Text = "条码"; this.label5.Click += new System.EventHandler(this.label5_Click); // // timer1 // this.timer1.Enabled = true; this.timer1.Interval = 1000; // // panel2 // this.panel2.Controls.Add(this.dataGridView1); this.panel2.Dock = System.Windows.Forms.DockStyle.Fill; this.panel2.Location = new System.Drawing.Point(0, 449); this.panel2.Name = "panel2"; this.panel2.Size = new System.Drawing.Size(1356, 260); this.panel2.TabIndex = 1; // // dataGridView1 // this.dataGridView1.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill; this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize; this.dataGridView1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { this.BianNo}); this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill; this.dataGridView1.Location = new System.Drawing.Point(0, 0); this.dataGridView1.Name = "dataGridView1"; this.dataGridView1.ReadOnly = true; this.dataGridView1.RowHeadersWidth = 51; this.dataGridView1.RowTemplate.Height = 27; this.dataGridView1.Size = new System.Drawing.Size(1356, 260); this.dataGridView1.TabIndex = 0; this.dataGridView1.CellContentClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.dataGridView1_CellContentClick); this.dataGridView1.ColumnHeaderMouseClick += new System.Windows.Forms.DataGridViewCellMouseEventHandler(this.dataGridView1_ColumnHeaderMouseClick); // // BianNo // this.BianNo.DataPropertyName = "BianNo"; this.BianNo.HeaderText = "编号"; this.BianNo.MinimumWidth = 6; this.BianNo.Name = "BianNo"; this.BianNo.ReadOnly = true; // // timer2 // this.timer2.Enabled = true; this.timer2.Interval = 2000; // // bGBarcodeBindingSource // this.bGBarcodeBindingSource.DataMember = "BGBarcode"; this.bGBarcodeBindingSource.DataSource = this.weightCollectDataSet1; // // weightCollectDataSet1 // this.weightCollectDataSet1.DataSetName = "WeightCollectDataSet1"; this.weightCollectDataSet1.SchemaSerializationMode = System.Data.SchemaSerializationMode.IncludeSchema; // // bGBarcodeTableAdapter // this.bGBarcodeTableAdapter.ClearBeforeFill = true; // // GSBGBarcodeFrm // this.ClientSize = new System.Drawing.Size(1356, 709); this.Controls.Add(this.panel2); this.Controls.Add(this.panel1); this.Name = "GSBGBarcodeFrm"; this.Text = "扫码报工"; this.Load += new System.EventHandler(this.GSBGBarcodeFrm_Load); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); this.panel2.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.bGBarcodeBindingSource)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.weightCollectDataSet1)).EndInit(); this.ResumeLayout(false); } #endregion #region 初始化窗口、启动下拉控件 private void GSBGBarcodeFrm_Load(object sender, EventArgs e) { this.textBox1.Focus(); } #endregion #region 扫描条码回车事件 private void textBox1_KeyPress(object sender, KeyPressEventArgs e) { if (e.KeyChar == 13) { string sqlstr = String.Format(@"SELECT * FROM BARDAB(NOLOCK) WHERE DAB001='{0}'", textBox1.Text.ToString()); tbBARDAB = SQL.ExecuteDataTable(sqlstr); wc.BianNo = b.ToString(); //编号 wc.BarcodeNO = textBox1.Text.ToString(); //条码 wc.CHEEKTIME = DateTime.Now.ToString(); //时间 wc.Product = ""; //结果 wc.CheckCategory1 = ""; //错误信息 if (tbBARDAB.Rows.Count <= 0) { wc.LinesName = ""; //工单号 wc.WorkNo = ""; //报工数量 wc.Product = "报工失败"; //结果 wc.CheckCategory1 = "该条码不存在"; //错误信息 InsertRowToDataTable(wc); textBox1.Text = ""; return; } wc.LinesName = tbBARDAB.Rows[0]["DAB031"].ToString(); //工单号 wc.WorkNo = tbBARDAB.Rows[0]["DAB005"].ToString(); //报工数量 if (tbBARDAB.Rows[0]["DAB049"].ToString() == "1") { wc.Product = "报工失败"; //结果 wc.CheckCategory1 = "该条码已报工"; //错误信息 InsertRowToDataTable(wc); textBox1.Text = ""; return; } textBox2.Text = tbBARDAB.Rows[0]["DAB020"].ToString(); textBox3.Text = tbBARDAB.Rows[0]["DAB021"].ToString(); textBox4.Text = tbBARDAB.Rows[0]["DAB008"].ToString(); textBox5.Text = tbBARDAB.Rows[0]["DAB022"].ToString(); textBox7.Text = tbBARDAB.Rows[0]["DAB005"].ToString(); string sqlstr2 = String.Format(@"EXEC WMS_CREATE_SAOMIAOBG '{0}'", textBox1.Text.ToString()); DataTable table = SQL.ExecuteDataTable(sqlstr2); textBox1.Text = ""; this.textBox1.Focus(); if(table!= null && table.Rows.Count > 0) { if(table.Rows[0]["RESULT"].ToString() == "1") { wc.Product = "报工失败"; //结果 wc.CheckCategory1 = table.Rows[0]["MSG"].ToString(); //错误信息 } else { wc.Product = "报工成功"; //结果 wc.CheckCategory1 = ""; //错误信息 } } InsertRowToDataTable(wc); } } #endregion #region 将数据增加到表格中 InsertRowToDataTable(GSproductionClass wc) /// /// 将数据增加到表格中 /// /// 数据类 private void InsertRowToDataTable(GSproductionClass wc) { DataRow newRow = dtWC.NewRow(); newRow["BianNo"] = wc.BianNo; newRow["BARCODE"] = wc.BarcodeNO; newRow["CREATETIME"] = wc.CHEEKTIME; newRow["BILLNO"] = wc.LinesName; newRow["QUANTITY"] = wc.WorkNo; newRow["PORESULT"] = wc.Product; newRow["ERMSG"] = wc.CheckCategory1; dtWC.Rows.InsertAt(newRow, 0); } #endregion #region 表格排序 dataGridView1_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) /// /// 表格排序 /// /// 数据类 private void dataGridView1_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { switch (dataGridView1.Columns[e.ColumnIndex].HeaderCell.SortGlyphDirection) { case SortOrder.None: break; case SortOrder.Ascending: dataGridView1.Sort(dataGridView1.Columns[e.ColumnIndex], ListSortDirection.Ascending); break; case SortOrder.Descending: dataGridView1.Sort(dataGridView1.Columns[e.ColumnIndex], ListSortDirection.Descending); dataGridView1.Columns[e.ColumnIndex].HeaderCell.SortGlyphDirection = SortOrder.Descending; break; default: break; } } private void Form1_Load(object sender, EventArgs e) { textBox1.Select(); } #endregion #region 声音播放 private void playT(string s) { SpeechVoiceSpeakFlags Flags = SpeechVoiceSpeakFlags.SVSFlagsAsync; SpVoice voice = new SpVoice(); voice.Voice = voice.GetVoices(string.Empty, string.Empty).Item(0); voice.Rate = 0; voice.Volume = 100; voice.Speak(s, Flags); } #endregion private void textBox6_TextChanged(object sender, EventArgs e) { textBox1.Focus(); } private void panel1_Paint(object sender, PaintEventArgs e) { textBox1.Focus(); } private void label5_Click(object sender, EventArgs e) { textBox1.Focus(); } private void label10_Click(object sender, EventArgs e) { textBox1.Focus(); } private void label9_Click(object sender, EventArgs e) { textBox1.Focus(); } private void textBox5_TextChanged(object sender, EventArgs e) { textBox1.Focus(); } private void label1_Click(object sender, EventArgs e) { textBox1.Focus(); } private void textBox7_TextChanged(object sender, EventArgs e) { textBox1.Focus(); } private void textBox3_TextChanged(object sender, EventArgs e) { textBox1.Focus(); } private void textBox4_TextChanged(object sender, EventArgs e) { textBox1.Focus(); } private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e) { textBox1.Focus(); } } }