private void UniPreparation(string UnName) { DG_UniPreparation.DataSource = null; if (UnName != "") { string NewUnname = string.Empty; //dr = ds.Tables[0].Select(" 通用名 like '% + UnName + "%'"); DataTable DTable = ds.Tables[0]; DTable = ds.Tables[0].Copy(); DTable.Rows.Clear(); NewUnname = UnName.Replace("%", " "); NewUnname = NewUnname.Replace("*", " "); NewUnname = NewUnname.Replace("|", " "); NewUnname = NewUnname.Replace(":", " "); NewUnname = NewUnname.Replace(":", " "); //dt2.ImportRow(dt.Rows[0]);//这是加入的是第一行 //string sql = string.Format(" 通用名 like '%{0}%'", NewUnname); string sql = string.Format(" 通用名 like '%{0}%' OR SpellCode like '%{0}%'", NewUnname); try { DataRow[] rowsArry = ds.Tables[0].Select(sql); foreach (DataRow row in rowsArry) { DTable.ImportRow(row); } //dt.Rows.Add(dr); if (DTable.Rows.Count > 0) { DG_UniPreparation.DataSource = DTable; } } catch { DTable = db.GetPIVAsDB(select.UniPreparation(UnName)).Tables[0]; if (DTable.Rows.Count > 0) { DG_UniPreparation.DataSource = DTable; } } } else { DG_UniPreparation.DataSource = ds.Tables[0]; } if (DG_UniPreparation.Rows.Count > 0) { DG_UniPreparation.Columns[0].Visible = false; DG_UniPreparation.Columns[1].Width = 180; DG_UniPreparation.Columns[2].Width = 200; //DG_UniPreparation.Columns[5].Width = 200*4; DG_UniPreparation.ClearSelection(); } }
private void Txt_UniPreparation_KeyDown(object sender, KeyEventArgs e) { if (e.KeyCode == Keys.Down) { DG_UniPreparation.Select(); } else if (e.KeyCode == Keys.Escape) { DG_UniPreparation.Visible = false; } else if (e.KeyCode == Keys.Enter && DG_UniPreparation.Visible == true) { DG_UniPreparation.Visible = false; } else if (e.KeyCode == Keys.Enter && DG_UniPreparation.Visible == false) { DG_UniPreparation.Visible = true; } }